Professional Summary:

• Over 8 years of extensive experience in database design, development, and administration with MS SQL Server versions 2012/2008R2/2008/2005/2000 using SSIS, SSAS, SSRS in Financial, Retail, Healthcare, Insurance, and Banking industries.
• Experienced with all phases of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development, and Implementation.
• Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Extensive experience in MS SQL Server 2012/2008R2/2008/2005, Business Intelligence technologies like MS SQL Server Integration Services SSIS , MS SQL Server Reporting Services SSRS , and MS SQL Server Analysis Services SSAS .
• Involved in installing, configuring, managing, monitoring, and troubleshooting SQL Server 2008/2005.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS Data Transformation Services utility.
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP Online Transaction Processing to OLAP Online Analytical Processing with the help of SSIS.
• Strong experience in designing and developing large number of reports in SSRS/Business Objects using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources.
• Worked in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Involved in creating, configuring and fine-tuning ETL work flows designed in DTS and MS SQL Server Integration Services SSIS .
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Involved in developing and modifying multidimensional cubes using SQL Server Analysis Services SSAS
• Worked in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Excellent in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services SSRS
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Involved in implementing Key Performance Indicator KPI Objects in SSAS 2005.
• Efficient in up-gradation and migration from SQL Server 2000 to SQL Server 2008/2005.
• Involved in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

Business/Technical Skills:

MS SQL Server 2012/2008R2/2008/2005/2000/7.0, MS SQL Server Integration Service SSIS , MS SQL Reporting Services SSRS , MS SQL Server 2008/2005 Analysis Services SSAS , Microsoft Access 2000, Erwin 8.0/7.3/4.2/4.1/4.0, Microsoft Visio 11.0/10.0, T-SQL, PL/SQL, ASP.NET 3.5, C 4, VB.Net, DHTML, HTML, XML 1, XSLT, JavaScript, AJAX V 3.0, Oracle 10g/9i, Crystal Reports 11/10/9/8.5, Visual source safe 2005, MS office 2007/2003, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation, Oracle D2K, Toad, Sql and PL/Sql.

Professional Experience:

Confidential

Role: MS SQL Developer/SSIS/SSAS/SSRS

Responsibilities:

• Involved in Planning, Defining and Designing database using Erwin 8.0 on business requirements and provided documentations.
• Designed MS SSIS Packages to extract data from various OLTP sources, Text Files, XML Extensible Markup Language Files, MS SQL Server and Excel to EDW system SQL Server 2012 .
• Wrote T-SQL queries with the help of Stored Procedures, Functions, Triggers, Cursors, Views, and Indexes.
• Developed and deployed SSIS packages for ETL from various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Look up, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Wrote T-SQL queries, Store Procedures and used them to build packages and maintain the history of the data.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases data mart databases.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked on-demand report and scheduled reports for business analysis and management decisions using SQL Server Reporting Services SSRS by utilizing Subscription.
• Involved in SSIS Packages using Script Task and various C , VB script.
• Created, Maintained scheduled various reports in SSRS like Tabular Reports, Matrix Reports Parameterized Reports using SQL Server Reporting Services SSRS.
• Developed detail and summary reports, line and pie charts, trend analysis reports, sub-reports, and T-SQL queries according to business requirements using SSRS.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Tools and Technologies:
• MS SQL Server 2012, SSRS, T-SQL, SSIS, Visual Source Safe, Win 2008 Advanced Server, , Erwin v8.0, ASP. Net, C .

Confidential

Role: MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Engaged in gathering requirement and documenting it for further reference.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, and etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, developed, and deployed reports in MS SQL Server environment using SSRS 2008R2.
• Implemented Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Generated various reports using SSRS 2008R2.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for monitoring and tuning report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Provided documentation for all kinds of reports, Stored Procedures and SSIS packages.
• Tools and Technologies:
• MS SQL Server 2008R2, SSIS, SSRS, SSAS, Oracle10g, Visual Studio 2005, TFS, Erwin 7.3, Windows NT/2003,Microsoft .NET framework 3.5, C , JavaScript, ASP.NET, XML.

Confidential

Role: MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Created logical and physical data models using Erwin 7.1 to design new database after discussion with technical team and application.
• Analyzed data quality, by working in conjunction with the data warehouse architect on the development of logical data models.
• Designed and developed SSIS packages to move data from production environment to different environments within the organization.
• Involved in Designing and implementing complex SSIS packages to migrate data from multiple data sources for data analyzing, deploying, and dynamic configuring of SSIS packages.
• Created high level ETL Extraction Transformation Loading architecture for overall data transfer from the OLTP sources like MS SQL Server 2000, Oracle, Text Files, Excel and Access to DW with the help of MS SSIS.
• Used SSIS to manually transfer DTS packages 2000 to SSIS packages 2008 using MS SSIS 2008
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions, and Functions using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Created parameterized, drill down, and aggregated reports in MS SQL environment using SSRS 2008.
• Generated daily, weekly and monthly reports for the managers.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Tools and Technologies:
• MS SQL Server 2008, SSRS 2008, SSIS 2008, T-SQL, ETL, C , .NET 2.0, Visual studio 2010, ASP.NET, DTS, java script, MS Access 2007, Excel, SQL profiler, Windows XP, Erwin 7.1, TFS

Confidential

Role: MS SQL Developer/SSIS/SSAS/SSRS Developer

Responsibilities:

• Gathered user requirements, analyzed, and designed software solution and database.
• Designed an OLAP with the help of Erwin 7.1.0 to visualize data structure.
• Created complex Stored Procedures, SSIS Data Transformation Service packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL DDL -Data Definition Language, DML -Data Manipulation Language statements using dynamically generated SQL.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services SSIS 2008.
• Modified cube partitions to optimize the query performance of the cubes
• Created MS SQL server Analysis Projects and created multidimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using MS SSAS 2008.
• Defined Referenced relationships with the measure groups and fact tables.
• Improved query performance by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using MS SSAS 2008.
• Developed MDX expressions for cube calculations and KPIs.
• Implemented the calculations to aggregate physical measures using management studio.
• Generated daily, weekly, monthly, quarterly, and annual reports using MS SSRS 2008.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used profiler to identify and repair database lockups, deadlocks, and other issues.
• Tools and Technologies:
• MS SQL Server 2005 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, VB Script, Windows Server 2003,Erwin 7.1

Confidential

Role: MS SQL Server Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using Erwin Data Modeler.
• Involved in designing, developing and testing of the ETL Extract, Transformation and Load strategy to populate the insurance data from various source systems feeds using SSIS.
• Worked Extensively with MS SQL Server Integration Services SSIS to import, export and transform the data between the linked servers.
• Created packages using MS SQL Server Integration Services SSIS for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multidimensional reports in SQL Server Reporting Services 2005.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Implemented SQL profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
• Tools and Technologies:
• MS SQL Server 2000/7.0, Windows Server, Windows NT, Erwin, Crystal Reports

Confidential

Role: SSIS/SSAS/ SSRS Developer

Responsibilities:

• Involved in module testing and development. Defined testing cycle documents.
• Created various tables, views, indexes and Sequences.
• Implemented database triggers.
• Development of forward port, Creation of test Scripts and Execution of White box testing and integration testing.
• Created many packages, procedures and functions for reports. Data was populated in the reports using these routines.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
• Involved in module design
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Creation of complex business scenarios
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multidimensional reports in SQL Server Reporting Services 2005.
• Performed daily tasks including backup and restore by using MS SQL Server 2005 tools like MS SQL Server Management Studio, MS SQL Server Agent, and Database Engine Tuning Advisor.
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Involved in language compatibility of application for Russian language.
• Tools and Technologies:
• MS SQL Server 2005, Windows NT, T- SQL, Toad.