SUMMARY

• MS SQL Server Developer over 8+ years of experience in various domains like Financial, Insurance, Retail, and Healthcare with expertise in MS SQL Server SSIS, SSRS for versions 2012/2008r 2/2008/2005.
• Involved in creating different kinds of SSIS Packages and Config files with variables, parameters and connection strings.
• Deployed different SSIS packages to different environment (Dev, Staging, Testing) by using packages level deployment project level deployment.
• Used TWS (Tivoli Workload Scheduling) to schedule the packages in different environment.
• Involved with entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
• Designed Logical and physical Database 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, MOLAP cubes, Including Star and Snowflake schema.
• 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 SSIS Packages.
• Involved creating operational reports in SSRS 2008/2008r2/2012 i.e. Drill - Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.
• Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• 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.

TECHNICAL SKILLS

• TWS(Tivoli Workload Scheduling)
• Common Framework
• 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
• PHP
• Java
• Java Beans
• Java Scripts
• JQuery
• Knockout JS
• Hibernate and NHibernate and Entity Framework
• C++ and MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Cockeysville, MD

MS SQL BI/ SSIS/ SSRS Developer

Responsibilities:

• Wrote from complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Responsible to create 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 in different relational model database server such as Oracle and DB2.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Helped in Rebuilding the Indexes at regular intervals for better performance.
• Produced operational reports in SSRS 2012/2008R2 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
• Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008 and using Report Builder for report server to create reports.
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2.
• Involved in configured the report viewing security for various users at various levels using Report Manager.
• Used Facets for processing healthcare claim.
• Maintained Backup of the data, created Job failure alerts using SQL Server Agent and restore data from the backup on request.
• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Improved performance of SQL Queries using SQL Execution Plan and SQL Profiler.

Tools: &Technologies: MS SQL Server 2012/2008r2, SSIS 2012/2008r2, T-SQL, Visual Studio, Facets, Windows XP, MS Office 2007/2010, MS Access, MS Excel.

Confidential, Jersey City, NJ

SQL/BI Developer

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, SSIS 2008R2/2008, SSRS 2008r2, T-SQL, Excel, and Acrobat Reader.

Confidential, Manchester, NH

MS SQL BI / SSIS Developer

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 usingSQLobjects 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.
• Worked on Guidewire Claim Center to manage P&C claims.
• Created ETL packages with different data sources (SQLServer, 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.
• Involved working on P&C Insurance billing system and other property related data.
• 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 2012/2008r2.

Tools: &Technologies: MS SQL Server 2012/2008r2, SSIS 2012/2008r2, T-SQL, Visual Studio, Windows XP, MS Office 2007/2010, MS Access and Guidewire.

Confidential, Atlanta, GA

MS SQL BI/SSIS Developer/DBA

Responsibilities:

• 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 (SQLServer, 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.
• Involved creating Olap Cube based on business requirements.
• 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.
• Used KPI and other indicators in SSAS.
• 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.
• Developed the application using J2EE architecture.
• Involved in developing JSP forms.
• Designed and developed web pages using HTML and JSP.

Tools: &Technologies: MS SQL Server 2008r2/2008, T-SQL, MDX, SQL server Integration service 2008r2/2008, Microsoft visual studio, Windows server 2008.

Confidential, Rosemont, IL

MS SQL Server Developer/BI Developer

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 operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kind of reports such aSub 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.
• Developed the application using J2EE architecture.
• Involved in developing JSP forms.
• Developed SQL queries, Joins with JDBC API to access data.
• Designed various applets using JBuilder.

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

Confidential, Mayfield, OH

MS SQL Developer/SSIS/ SSRS Developer

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.