SQL Developer
Vaisakh
Deepaksinh Virpura
Professional summary:
Ø Over 8 years experience in Database design, development and administration using MS SQL Server 2012, 2008 and 2005 in Production, Test and Development environment.
Ø Experience in Data Modelling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
Ø Strong working experience in SQL Server and T-SQL in constructing triggers, tables, Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
Ø Experience in Data Modelling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2005/2008 for both OLTP (Batch Processing, Online Processing) & Business Intelligence (SSIS, SSRS) applications.
Ø Strong technical knowledge in MS SQL Server development including Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
Ø Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
Ø Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
Ø Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
Ø Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
Ø Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Ø Expertise in Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
Ø Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Ø Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non Clustered indexes on tables
Ø Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
Ø Expert in generating Drilldown reports, Parameterized reports, Linked reports, Sub reports and filters, charts in SSRS 2005/2008.
Ø Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008/2012
Ø Experience in deploying created reports in various sources like Web browser, XML and PDF.
Ø Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
Ø Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
Ø Expertise in performing administrative tasks: database files management, backup/restore, security management, data integration and synchronization
Ø Scheduled the backups for Databases and Transaction log. Performed restoration operations, Suggested backup strategies.
Ø Identifying & resolving blocking and deadlocks.
Ø Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role and 24x7 on call Production support.
TECHNICAL SKILLS:
|
Databases: SQL Server 2005/2008/2012 |
|
|
|
Operating Systems: Windows Server 2003, Windows 98/NT/XP/Professional |
|
Languages: T-SQL, PL/SQL, C/C++, HTML, DHTML, XML, VBScript, Performance Monitor |
|
ETL Tools: SQL Server Integration Services (SSIS) |
|
Reporting Tools: SQL server Reporting Services (SSRS) |
|
Tools: SQL Server Enterprise Manager, Management Studio |
|
Protocol: FTP, TCP/IP, Named Pipes |
|
|
CERTIFICATION
Microsoft Certified professional
EDUCATION
Bachelor’s in Computer Science, Ashford University, Clinton, Iowa, US
Please Reply back to vais...@penmarksolutions.com (+1 347 349 5 381)