Summary

7 years of experience as MS SQL Server Developer in various domains like Financial, Insurance, Retail, and Healthcare with expertise in MS SQL Server, SSIS, SSRS for versions 2012/2008r2/2008/2005.

Professional Summary:

• Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Designed Conceptual, Logical and physical Model of database.
• Expert in Data conversion, Data modeling, Normalization and SQL Server Enterprise manager.
• Wrote complex Stored Procedures, User Defined Functions, Views, and creating other database objects.
• Expert in Migration of data from Oracle, Sybase and DB2 to SQL Server.
• Involved creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Expert in Creating, maintaining and Configuring DTS and SSIS packages.
• Involved working with heterogeneous data source like Excel, Flat file, Oracle, DB2, and SQL Server.
• Expert in Logging, Error handling by using Event Handler, and Custom Logging for ssas
• Involved creating operational reports in SSRS 2008/2008r2/2012 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.
• Involved in Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Expert in Database Backup, Recovery and applied necessary SQL Server database Service packs, hot fixes and Security Patches.
• Defined and administered database standards, controls, procedures and documented the same.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.

Business Skills / Technical Skills:

MS SQL Server 2012/2008r2/2008/2005, Visual studio 2010/2008 SSIS/SSRS , Microsoft Access 2007/2003, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, Oracle 11g,10g, and 9i, DB2, MySQL, Sybase, Cognos report, Informatica, Windows Server, Microsoft SharePoint, Erwin, SSMA, MS Access, Java, C , MS Office.

Project Summary:

Confidential

Server/SSIS Developer

Sanef-its technologies is a new leader for mobility and toll system integration. After decades under the CS brand, CS ITS has become Sanef-its technologies with the acquisition of the activity by Sanef group, a leading operator and concessionaire. The project goal was to get data from different heterogeneous sources to SQL Server using SSIS packages and also to writing stored procedure based on business requirements.

Responsibilities:

• Involved in creating various Tables, Views and Functions based on the requirement specified by EDW team and wrote complex Join statements for combining data from various Databases and tables.
• Involved creating complex stored procedure based on business requirements.
• Proficient in tuning SQL queries using execution plan, index and DMV.
• Created SSIS packages with different data sources SQL Server, Flat files, Excel files, CSV files and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Applied various data transformations like Slowly Changing Dimension SCD , Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Use Packages by testing and cleaning the Standardized Data by using tools in Data Flow.
• Involved in scheduling SSIS packages in multiple servers using SQL Server Agent.
• Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.
• Schedule and maintain Full, Differential, Transactional Log backup and restore the data using restore with recovery and restore with no recovery option.
• Worked on locking, blocking and dead lock issues.
• Involved in performance tuning of slow running queries using execution plan and index tuning wizard.
• Scheduling jobs and alerts using SQL Server Agent and configured database mail for any job failure.

Tools Technologies:

MS SQL Server 2012/2008r2 T-SQL, SQL server Integration service 2012/2008r2/ Microsoft visual studio, Windows server 2008.

Confidential

Developer

Confidential is a multi-institutional Catholic health system, co-sponsored by seven religious congregations and Hope Ministries, a Public Juridical Person within Catholic Health. The main project goal was to use integration services to extract data from sources and push that data through staging and create package and generating various report such as drilldown, drillthrough, sub-report,linked-report and dashboard report using SSRS.

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
• Successfully implemented indexes on tables for optimum performance.
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created ETL packages with different data sources SQL Server, Flat files, Excel source files, Oracle and loaded the data into target tables by performing different kinds of transformations using SSIS 2008r2.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Performed Documentation for all kind of SSIS packages.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Involved in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services SSRS .

Tools Technologies:

MS SQL Server 2008r2/2008, SSIS 2008r2/2008, T-SQL, Visual Studio, Windows XP, MS Office 2007/2010, MS Access.

Confidential

Developer

Confidential is one of the biggest and most conveniently accessible bank having branches all across USA. Bank of America is active in many markets, economies and financial sectors. The project was to analyze bank accounts, to market additional products more effectively to the customers who have one or more accounts with the bank i.e. Business and personal account.

Responsibilities:

• Interaction with clients while business requirements, design implementation phases.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services.
• Created and maintained existing dynamic SSIS packages to load data from and to MS SQL Server and Oracle, Excel files, and flat files.
• Worked on SSMA for transferring data from Oracle to MS SQL Server.
• Design, develop test the ETL processes according to industries best practices using SSIS.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers import/export wizard while developing packages.
• Used Script task for Data Flow and Error Handling in SSIS.
• Worked with T-SQL to create database objects such as Tables, Views, Functions, Triggers and Stored Procedures.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Used SQL profiler, and indexes for performance tuning debugging issue whenever necessary.
• Documented for all kinds of reports and SSIS packages.
• Created reports such as Matrix Report, Drill-Down and Drill-Through Reports, Parameterize Reports, Dash Board Report, and Link report using SSRS 2008r2 and Cognos Reporting tool.

Tools Technologies:

Windows XP, MS SQL Server 2008r2/2008, SSIS 2008r2/2008, SSRS 2008r2/2008, T-SQL, Excel, and Acrobat Reader.

Confidential

Server Developer/BI Developer

Confidential is a leading company in distributing foodservice to restaurants, health care, hospitality facilities and government operations whose affiliates provides own high quality private label food items. The goal of the project was to use integration services to create packages, modify the existing packages based on SQL Server 2008 version and transferring and loading packages into SQL Server 2008r2 destination server and administrator work such as creating and maintaining Backups.

Responsibilities:

• Planned, Defined and Designed data based on business requirement using Erwin data modeler and provided documentations for further reference.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• 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 using SQL Server Agent.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.
• Configured the report viewing security for various users at various levels using Report Manager.
• Fine tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Work on Performance Tuning of complex queries using SQL Profiler, Index Tuning Wizard and Execution Plan.

Tools Technologies:

MS SQL Server 2008r2/2008, SSIS 2008,SSRS 2008, T-SQL, Windows 2008 Server, Erwin 8.0, SQL Server Profiler.

Confidential

Developer/SSIS Developer

Progressive is a leading auto insurance company based in the Cleveland suburb of Mayfield Village, Ohio. In addition to auto insurance, Progressive offers the following types of insurance to customers throughout the country for boat/personal watercraft insurance, commercial auto insurance, homeowners insurance, motorcycle insurance and RV insurance. The project dealt with managing login and user management, database creation, tuning, backup planning for the data containing information about the personal insurance policies of the customers.

Responsibilities:

• Dealt with requirements gathering, analysis, design, development, change management, deployment and user training.
• Added logins, roles, groups to the Window NT and MS SQL Server and maintained proper security procedures.
• Designed ER diagrams Physical and Logical using Erwin and mapping the data into database objects.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing
• Wrote various stored procedures, Indexed views, dimensions and stored outlines for optimal performance.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Connected Linked Servers to OLE DB data sources and providers.
• Wrote distributed queries for Linked Servers.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Performed Data Analysis for automating various drugs related reports utilizing SQL Analysis Services.
• Designed, programmed, deployed and tested the requested Reports.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2005.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Tools Technologies:

SQL Server 2005 Enterprise Edition, MS Excel, T-SQL, MS Access 2000, SQL Reporting Services, Erwin 7.3, XML.

Confidential

Jr. Developer/ Developer

Confidential manufactures pharmaceutical preparations par pharmaceutical production services, Biochemical and biotechnology production, petrochemical and plastic production, chemicals and fertilizers production, pharmaceutical production, drugs or medicine production services. The scope of the project was creating a database schema to perform analysis on the company performance using SSAS and SSRS. The project required creating, designing and modifying existing reports.

Responsibilities:

• Involved in planning, defining and designing data and provided documentation
• Developed and Implemented UNIX shell scripts through command task to handle requirements like dropping and building indexes, flat file archiving/dropping process etc.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs
• Used various SSIS tasks such as conditional split, derived column , which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse
• Created error and performance reports on SSIS packages, Jobs, stored procedures and triggers.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2005
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers
• Involved in documentation for all kinds of reports, DTS and SSIS packages
• Designed and implemented stored procedures and triggers for automating tasks
• Maintained the table performance by following the tuning tips like normalization, creating Index and ensured best practices are applied and integrity of data is maintained through security and documentation.

Tools Technologies:

MS SQL Server 2000/2005, T-SQL, SSRS 2005, SSIS 2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access.