SUMMARY

• 7+years of Development experience in MS SQL Server, SSIS and SSRS with various verticals such asFashion, Healthcare,Insurance, Banking and Finance,, and Pharmaceutical industr
• Strong knowledge in T - SQL, PL/SQL, and MySQL, SQL Data Modeling, and DBA experience in MS SQL Server and Oracle as well as strong knowledge in QA, QTP, LoadRunner.
• Wrote Dynamic SQL Scripts and created Dynamic SSIS Packages.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2012/2008r2/2008 and 2005, and Business Intelligence tools such as SSIS, and SSRS.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from heterogeneous databases such as Oracle 10g and 11g, DB2, Sybase (Adaptive Server Enterprise) 15.0, 15.0.1, and 15.5, and MS Access.
• Highly proficient in using T-SQL for developing Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Data Integrity, SQL joins and Query Writing.
• Strong experience in designing and developing more than 100+ enterprise reports (SSRS/ Business Objects) using the data from ETL Loads, and various heterogeneous data sources.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008r2,2008 and 2005.
• Created SSAS cubes on existing SSRS reports.
• Experienced in Conceptual, Logical and Physical Database design and development, Normalization and Data modeling using Erwin and MS Visio.
• Strong experience in SQL Server Installation, Capacity Planning, Creating and Implementing Backup and Recovery Strategy, Log Shipping, Attaching and Detaching the database, and database designing.
• Expert in using tools like MS SQL Profiler, Performance Monitor, Database Engine Tuning advisor, Index Tuning Wizard, and Execution Plan for Query Optimization, resolving Dead Locks, and Long/Slow running queries.
• Experienced in upgrading SQL Server and r2.
• Strong experience in Data modeling i.e Conceptual, logical and physical designing of database.
• Wrote the descriptive programming whenever required and updated the scripts in QTP.
• Designed and involved in creating new architecture design using class methods to implement QTP scripts
• Maintained positive communications and working relationships at all business levels.
• Excellent experience in working independently as well as in team-oriented environments.

TECHNICAL SKILLS

RDBMS: SQL Server 2008R2/2012, MS Access, Teradata, Oracle

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, Replication

ETL Tools: SSIS

OLAP/Reporting Tools: SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), Crystal Reports, Business Objects, Performance Point Server, PowerPivot, SSAS Tabular, Power BI

Applications: MS Word, MS Excel, MS PowerPoint, SharePoint

Languages: T-SQL, PL/SQL, JAVA, HTML, PHP, C++

Scripts: VB Script, XML, UNIX, JavaScript

Data Modelling Tools: Erwin Tool, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

MS SQL Server Developer/SSRS Developer

Responsibilities:

• Wrote complex T-SQL queries, store procedure and created database objects such as tables, and views.
• 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.
• Created SSIS packages for transaction reconciliation, which is being used by the accounting department as a daily basis from SAP.
• 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.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SAP, SQL Server and Flat File sources and load into various Business Entities.
• 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.
• Wrote the descriptive programming whenever required and updated the scripts in QTP.
• Created Database checkpoints and tested the backend data using QTP.
• Designed and involved in creating new architecture design using class methods to implement QTP scripts.
• Developed Data driven Framework using QTP automated Script to execute the Batch Testing upon certain Interval.
• Developed a Hybrid Framework to automate the testing process of the crucial modules of the application using QTP.

Environment: MS SQL Server 2012, 2008r2, SSIS, SSRS, T-SQL, MSCRM,Windows 2008 Server, and Erwin 8.0. ALM 11.0, QTP, LoadRunner, MS-Office, MS Outlook Express, Linux, Windows

Confidential, Greene, NY

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Transfer data between SQL and SAP LSMW.
• Wrote complex dynamic SQL queries for changing column and table names using SQL variables.
• Created Complex Stored Procedures, Triggers, Function, Indexes, and Tables, Views, T-SQL code and SQL Joins for applications.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Designed databases from scratch using conceptual, logical and physical modeling using Erwin.
• 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.
• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Analyzed and designed the business rules for Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column that are required by the staging OLAP and OLTP databases.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Worked with application developers and production teams across functional units to identify business needs and discussed solution options.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Involved in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports usingSQL ServerReporting Services 2012 and Created ad-hoc reports Using Report Builder.
• Built the SSRS reports from Different Databases like Oracle andSQL Server.Configured and deployed SSRS reports.

Environment: MS SQL Server 2012, SSIS, SSRS, T-SQL, Dynamic SQL, MSCRM, Windows 2008 Server, and Erwin 8.0, MS Office, MS Outlook Express, Linux, Windows.

Confidential, Burlington, NJ

MS SQL Server Developer/BI Developer

Responsibilities:

• Wrote from simple to 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.
• Created simple to complex Store Procedure to re-use all the complex queries that I wrote for the River Stone’s Enterprise Data Warehouse (EDW) in a specific format with the help of given template.
• 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.
• Worked with a Cognos team and helped to create complex by weekly, quarterly and annual report by writing code based on the requirement.
• 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.
• 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.
• Helped in planning out the coding and offered different solutions in initial planning of the project.

Environment: MS SQL Server 2012, 2008r2, SSIS, SSRS, T-SQL, SSMS Execution Plan, SQL Profiler, LogShipping, Windows 2008 Server, and Erwin 8.0.,MS-Office, MS Outlook Express, Linux,Windows.

Confidential, Wilmington, Delaware.

SQL Developer /BI Developer/DBA

Responsibilities:

• Interaction with clients while business requirements, design & implementation phases.
• Created different types of reports such as drill down, drill through, parameterize and dash board reports and schedule them according to business requirement using SSRS.
• Generating on-demand, ad-hoc, custom reports for business analysis and management decision using SSRS.
• Migrated data to the staging server and then that data were later populated to the OLAP (Online Analytical Processing) Server to use with SSAS for analysis purpose.
• 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.
• Wrote complex T-SQL and PL/SQL queries, stored procedures, views, triggers, functions, table variables, and cursors as per business requirement.
• Made indexes, constraints & business rules wherever applicable.
• Used SQL profiler for performance tuning & debugging issue whenever necessary.
• WroteVB.Net and C#.NetscriptsinScripttasktovalidatedatausingSSISvariables and custom code.
• Involved in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports usingSQL ServerReporting Services 2008 and Created ad-hoc reports Using Report Builder.
• Built the SSRS reports from Different Databases like Oracle andSQL Server.Configured and deployed SSRS reports.
• Scheduled and maintained Backups, defined user roles and maintained Log Shipping and Replication.
• Involved in performance tuning of complex T-SQL and PL/SQL quires using SQL Profiler and Execution Plan.

Environment: MS SQL Server 2008, SSIS 2008, SSRS 2008, Excel, Oracle 10g, T-SQL, Microsoft Office, C#, VB.NET.

Confidential, Kansas City, MO

MS SQL Server Developer/SSIS Developer/SSRS Developer

Responsibilities:

• 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.
• Created Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, T-SQL code and SQL Joins for applications.
• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Designed SSIS packages to transfer data from various sources like XML files, Excel, MS SQL Server 2008R2/2008 to and from Oracle 10g and 11g.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Analyzed and designed the business rules for Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column that are required by the staging OLAP and OLTP databases.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Involved in migration from MS SQL Server .
• Migrated packages from development server to production server using package configuration.
• Worked with application developers and production teams across functional units to identify business needs and discussed solution options.
• Defined the browsing perspectives and browsing translations since most transactions were online.

Environment: MS SQL Server 2008r2/2008, SSIS, SSRS, Microsoft Performance Point Server 2010, Microsoft Share Point Server, T-SQL, Java, Microsoft Office, Erwin 7.3, and Report Builder 3.0.

Confidential

Jr. SQL Server Developer/SSIS Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation
• Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
• 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
• Generated ad hoc reports using MS Reporting services and crystal reports
• 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.

Environment: 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, Crystal Reports 9/10,Unix Shell Scripting.