SUMMARY

• MS SQL Server Developer wif 7+ years of strong experience in various domains like Financial, Retail and insurance wif expertise in MS SQL Server 2012/2008R 2/2008/2005/2000 and SSIS, SSRS, SSAS.
• Proficient in installing, configuring, managing, monitoring and troubleshooting MS SQL Server 2012/2008/2008 R2/2005.
• Developed Logical and physical data model using ERWIN, ER Studio and mapped the data into database objects.
• Generated sub reports, cross - tab, conditional, drill down reports, drill through reports and parameterized reports using SSRS 2012
• Strong MS SQL Server 2012/2008/2008 R2/2005 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.
• In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL).
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts, OLAP and OLTP systems.
• Expertise in Merging data from various heterogeneous data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Mastery in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.
• Good understanding in Database Backup, Recovery and Performance tuning, Query Optimization, Client Connectivity, and Database consistency checks using DBCC Utilities.
• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.

TECHNICAL SKILLS

• Microsoft SQL Server 20012/2008R2
• SQL Server Reporting Services (SSRS)
• XML
• SQL Server Integration Services (SSIS)
• Windows Server 2008.

PROFESSIONAL EXPERIENCE:

Confidential

SQL/SSIS Developer

Responsibilities:

• Worked closely wif SME’s end users to understand project requirements and involved in providing solutions to implement or support production issues.
• Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions too.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T-SQL codes to implement business rules. (used CTE, temporary tables and views)
• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler, Indexing.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Responsible for the Performance tuning of the SQL Commands wif the use of the SQL Profiler and Database Engine Tuning Advisor

Confidential

SQL BI Developer

Responsibilities:

• Worked wif business users and development staff to understand/determine requirements, collaborated wif application developers for delivering the requirement on time and wif scalability.
• Worked closely wif SME’s end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.
• Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period.
• Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
• Prepared reports using SSRS 2008R2.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, and xml task and applied various transformation techniques.

Confidential

SQL developer/ SSIS Developer

Responsibilities:

• Understanding the business requirements document (BRD).
• Extracted the data from different sources and stored the data into the intermediate Staging Database using SSIS.
• Applied variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join…to satisfy BRD
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2012.
• Experienced in implementation of strong referential integrity and auditing wif the use of triggers.
• Deployed the SSIS Packages to File System based on the requirements
• Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2012.
• Created complex SSIS packages using various transformations.
• Prepared documentation for ETL process future s.