SUMMARY

• 7+ years of Development experience in MS SQL Server, SSIS and SSRS with various verticals such as Fashion, Healthcare, Insurance, Banking and Finance, Education, and Pharmaceutical industry
• 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 2005 to 2008 and 2008 to 2008r2.
• 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

• MS SQL Server 2012/2008r2/2008/2005
• MS SQL Server 2012/2008R2/2008/2005
• SSRS and SSIS
• CRM
• MS Access 2010/2007
• MySQL
• PL/SQL
• Dynamic SQL
• Microsoft office
• Java
• C++
• MS SQL Profiler
• Query Analyzer
• Enterprise Manager
• Index Tuning Wizard
• Loader and Export/Import
• Erwin 8.0/7.3
• SharePoint
• Microsoft Visio 2010/2007
• Data Modeler
• Third party tool Red Gate and Idera
• Cognos crystal Report
• T-SQL
• P-SQL
• Windows 2008/2003 Advanced Server
• UNIX and Linux environment
• HTML
• VBScript
• JavaScript
• XML
• Shell Script
• CMD and Batch File
• QTP and Load Runner

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

MS SQL Server Developer/SSIS/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, 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, Log Shipping, 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.
• Wrote VB.Net and C#.Net scripts in Script task to validate data using SSIS variables 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 2005 to 2008.
• 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, Dallas, TX

SQL Server Developer/DBA/BI Developer

Responsibilities:

• Successfully installed and configured MS SQL Server 2008 on the production server and helped in migrating from SQL Server 2005 to SQL Server 2008.
• Provided 24x7 dedicated production support for SQL Server problem resolution and server outages.
• Using third party tool Red Gate, ensuring all the databases are backing up on the regular basis and then restoring this databases on requests.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.
• Involved in database and log backups and restoration, planning backup strategies, and scheduling.
• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Automated the migration of data from Oracle 10g to MS SQL Server 2008/2005 and converted the Oracle database objects to MS SQL Server database objects like tables, views, and stored procedures using Microsoft SQL Server Migration Assistant (SSMA).
• Designed SSIS packages to transfer data from various sources like Flat flies, CVS files, Excel, SQL Server to Oracle 10g, and My SQL and from Oracle 10g, and My SQL to MS SQL Server 2008/2005.
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQL statements using MS SQL profiler, Job Activity Monitor and Performance monitor.
• Created SSIS packages to load data from the OLTP system to Data Warehouse and Data mart for analysis of data.
• Improved Performance Tuning of slow running SSIS Packages by using Merge statement from T-SQL and look up as an alternative of slowly changing dimensions.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Defined referential relationships with the measure groups and fact tables.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
• Defined granularity within a measure group and drill through actions.
• Created cube reports that can be browsed at summary level and can be drilled down to the detail level.
• Scheduled and maintained Backups, defined user roles and maintained Log Shipping and Replication.
• Responsible for performance tuning and query optimization using inbuilt SQL tools and third party tool Red Gate.
• Created and dropped cluster and non cluster index for performance tuning and for faster retrieval of the data.

Environment: MS SQL Server 2008/2005, SSIS,SSRS, Microsoft Visual Studio 2008, T-SQL, MS Access, Windows 2008/XP, Red Gate and Remedy Ticketing tool.

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.