SUMMARY

• Around 8 years of experience in the IT industry as a Microsoft SQL Server developer and its products like Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services and Power BI.
• Experience in Health Care, Finance, Health Insurance and Pharmaceutical Domains.
• Extensive experience in handling various challenging enterprise projects from Client Server application Design and implementation in Microsoft technologies like SQL Server 2012/2008/2005/2000.
• Knowledge on SQL Sentry Plan Explorer.
• Experience on DemandTools to update and delete duplicates in Sales Force.
• Experience on Report Builder tool to generate Tabular reports based on Client Requirement.
• Knowledge on implementing data migration techniques using Cransoft®
• Strong communication, interpersonal, learning and organizing skills.
• Experience of working on defect tracing tools like Share Point, Bugzilla, Jira and Sales Force.
• Expert in writing Parameterized Queries for generating Tabular reports, drill down, drill through, click through, matrix, chart, snap shot reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2012/2008/2005 and deployed them to Central Resource Management (CRM) system.
• Expert in the migration of reports from SQL Server reporting services, Crystal Reports to SSRS, SSRS to Crystal format and deploying using Excel and Microsoft Reporting Server.
• Configured product meta - data tables to support client data reporting needs.
• Worked in several deployment load cycles - Technical Loads, Mock Cutover, Dress Rehearsals and Go Live and managed multiple data loads from various legacy source systems into SAP® ECC, SAP® CRM and SAP® APO
• Expert in developing complex Stored Procedures, Views, Functions, Triggers, Indexes and complex queries on SQL Server 2012/2008/2005.
• Expertise in RDBMS, Data Warehouse Architecture and Modeling. Thorough understanding and experience in data warehouse and Normalization and Demoralization concepts and principles.
• Extensive Experience in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and Database Engine Tuning Advisor.
• Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2008/2005.
• Excellent experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.
• Experienced in all phases of project life cycle starting from business requirement gathering, analysis, design, implementation, testing, and production.
• Experienced in Logical and Physical Database design & development, Data Conversion and Normalization.
• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
• Defined and administered database standards, controls, procedures and documented the same.
• Excellent communication skills and experienced in client interaction while providing technical support and knowledge transfer.

TECHNICAL SKILLS

Database/RDBMS: Microsoft SQL Server 2005, 2008, 2012

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, SQL Query Analyzer, Report Builder and Demand Tools

Programming Languages: T-SQL

BI/Data Model Tools: Microsoft SQL Server Reporting Services 2005/2000, Crystal Reports, DTS, SSIS and Visio 2003

Application Packages: MS Office, MS Outlook

Web Technology: HTML

Operating Systems: MS Windows Family

PROFESSIONAL EXPERIENCE

Confidential, Troy, MI

Sr. MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Analyzed thebusiness requirement and functional specifications provided by the data specialist.
• Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst
• Created ad hoc SSRS reports in the test environment for data validation & Created dynamic Reports from the cube using SSRS and stored procedures.
• Troubleshoot the deployment of reports in the test and production environment using SSRS
• Supporting the product Benefit Driven application for monthly status of benefits that details health care eligibility and pension status etc.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database.
• Working closely with business units to understand key business drivers and then identify the individual business metrics and key measures that support them.
• Wrote complex SQL queries using joins, stored procedures, used defined functions to verify the data from the database to generate reports based on the business requirement
• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports
• Created ad Hoc and parameterized various reports using SQL server 2008 reporting Services.
• Created number of complex formulas, sub reports using different type of variables, custom code and assemblies while developing the reports, which are used by the end users for the analysis purpose.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the reports.
• Wrote complex stored procedures to get the data from different servers and generated the reports on that data.
• Customized SQL queries to create RDL Datasets and create SQL reports.
• Created Tabular and Matrix Reports with all aggregate functions and expressions.
• 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.
• Produced operational reports in SSRS 2012 i.e. drill-down, drill-through, dashboard and matrix reports.

Environment: Microsoft .Net, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services MS SQL Server 2008 R2 and Share Point.

Confidential, Midland, MI

Sr. MS SQL Server/SSIS/CransoftDeveloper

Responsibilities:

• Gathered requirements around various complex data migration entities in SAP® MM, SD and SM.
• Involved in the Analysis Phase and Preparation of the Functional Impact Analysis Document and lead several client workshops
• Developed Functional Specification document and High Level Design documents and extensively used Cransoft® EzMap for file field mapping
• Worked on the creation of DTS packages and SSIS packages to pull data from the legacy world into Cransoft® DataGarage
• Worked as a part of Core Data Readiness Team to extract data from SAP using BackOffice cransoftDatagarage
• Worked with the functional consultants and business team, as a part of data migration strategy to understand the requirements and build the required data conversion logic using BackOffice Cransoft DSW, in modules Master Data, PM (Plant Maintenance), EHS (Environment, Health and Safety), P2P and OTC.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Co-ordinated between customers, functional analysts and developers using the data load cycles
• Performed Functional Testing, End-to-End Unit Testing, Integration Testing and supported User Acceptance Testing (UAT)
• Reported status of all the data migration processes and activities using Cransoft® COT (Conversion Object Tracker)
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Worked on core development of Conversion logic, functional, table, field and value mapping
• Knowledge of creation of CHARMs (Change Release & Management) through SAP® Solution Manager
• Performance Optimization of data migration objects in Cransoft® using MS® SQL Server 2008 R2
• Excellent experience with logging issues and testing processes using standard quality management software such as HPQC
• Prepared Technical specifications and Test plans.
• Used query analyzer and optimizer to optimize queries.
• Prepared detailed and summary level of TO BE LER (Legal Entity rationalization) data for preload and post load validation reports.

Environment: SAP ECC 6.0; BOA Cransoft Version 5.3.3.17102 , MS SQL Server 2008 R2 (SP2), DataSure 2.2

Confidential, Omaha, NE

Sr. MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Expert in designing ETL data flow using SSIS creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Migrated the SSIS packaged which were developed in R2.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Creating SSIS packages. Experience in DTS Migration and Meta data Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Utilized Power Designer to create logical and physical data structures based on a Metadata driven architecture. The data is sourced from external vendors and is supplemented with information from internal settlement and trading systems
• Responsible for design, create and tune database objects (tables, views, indexes) to support Logical and dimensional models. Maintain the referential integrity of the database.
• Ability to analyze and resolve performance issue with database code involvingSSIS and MS SQL Server 2005/2008.
• Wrote complex SQL queries using joins, stored procedures, used defined functions to verify the data from the database to generate reports based on the business requirement
• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports
• Created ad Hoc and parameterized various reports using SQL server 2008 reporting Services
• Implemented multiple grouping into several reports using visibility and toggle options
• Administrated and scheduled mailing subscriptions on SSRS reporting server
• Involved in providing the break-fix, for the reports that fail to run on production environment.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Perform T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2008.
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation

Environment: Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services and MS SQL Server 2008

Confidential, Hagerstown, MD

Sr. MS SQL Server Developer/ETL Developer

Responsibilities:

• Perform routine SFDC maintenance, data cleanup, data imports and Data Load using DemandTools to improve data Quality.
• De-duplication of data in Sales Force using Demand Tools.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure the SSIS Package for run time Parameters and Configuration file
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Developed custom reports as needed using Report builder.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Interacted with business users for understanding and gathering business requirements and involved in project planning, scheduling the database module with project managers.
• Created/modified complex store procedures to fit to the changing requirements and to enhance performance and developed custom functions, indexes to ensure accuracy, quality and consistency of the database.
• Created number of complex formulas, sub reports using different type of variables, custom code and assemblies while developing the reports, which are used by the end users for the analysis purpose.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Built the report models, created a wide variety of interactive reports for business users in Report Builder and deployed the reports in various formats depending on the user requirements.
• Created user groups and accounts for users who could access the reports.
• Designed and implemented stored procedures and triggers for automating tasks.
• Used query analyzer and optimizer to optimize queries.

Environment: Sales Force, Microsoft SQL Server Reporting Services, MS SQL Server 2008, Demand Tools and Report Builder

Confidential, Pittsburgh, PA

ETL Developer

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.
• Designed and modeled Microsoft SQL Server 2008 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2005 data warehouse and data marts.
• Used SSIS packages to roll our data to Live Tables and to Processing Database.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Worked with a Business Analyst to understand the Business Requirements and how these translate to Igloo database design criteria and logical/physical objects
• Schedule Package using SQL Server Job for weekly/monthly basis.
• Used Checkpoint for avoiding re-executes Package from the first task.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Developed packages using fuzzy task for data cleansing.
• Handling the orphan rows in Dimension and Fact tables.
• Participated actively in analysis and discovery phases of data warehouse implementation.
• Migrated some Crystal reports to SSRS reports manually
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Environment: Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services and MS SQL Server 2008

Confidential, Bensalem, PA

SSIS/SSRS/SQL Developer

Responsibilities:

• Extensively involved in installing and configuring SQL server 2005.
• Improved Performance of databases by analyzing Indexes, Fill Factor and Fragmentation issues.
• Handling PAP module.
• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
• Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
• Responsible for design and plan BI solutions & development of SQL Server based solutions.
• Developed / modified SSIS, SSRS packages / reports to meet business requirements
• Worked on SSIS Package, Import/Export for transferring data from Database to SQL Server
• Responsible for Writing relational and multidimensional database queries
• Created SSIS packages to transfer data between OLTP and EDW databases.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Monitoring server performance by using Performance counter & created complex Stored Procedures and Cursors to support applications using T-SQL.
• Prepared Estimates for Database Files and Table size growth.
• Created Distributed Partition views Using T-SQL.

Environment: MS SQL Server 2008, SQL Server Integrating Services 2008, T-SQL, SQL Server Management Studio 2008, ASP.NET C#.NET 2010, AJAX, JAVASCRIPT, Windows Services, Web services, MSMQ, JeffNet, DevExpressToolsMS-Access, C#.NET, VB Script, Windows XP.

Confidential, Riverwood, IL

MS SQL Server/ SSIS/SSRS Developer

Responsibilities:

• Worked on the complete life cycle of the project from design to implementation
• Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst
• Analyzed thebusiness requirement and functional specifications provided by the data specialist.
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company. created SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL server, Excel & Access to SQL Server
• Involved in upgrading packages from SQL server 2005 to SQL server 2008 & Responsible for creating SSIS Packages to extract data from OLTP to Data Warehouse & scheduled Jobs to call the packages & Stored Procedure.
• Responsible for making sure reports are scheduled and delivered in a timely manner & Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
• Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Created ad Hoc and parameterized various reports using SQL server 2008R2 & SQL Server reporting Services 2010 with data from SQL Server and MS Access as data sources
• Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server 2008R2 environment and accomplished data modeling.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly Reports.
• Managed Windows Admin Scripts to monitor Disk and Tape Backups, Disk Space and Service Status for different servers and generate alerts Using SQL server Integration services.
• Documented the complete data warehouse environment, including all dimension and fact tables, the relationship between SSIS packages and the target tables, which packages were valid and in use and the relationship between the jobs and SSIS packages.
• Created ad hoc SSRS reports in the test environment for data validation & Created dynamic Reports from the cube using SSRS and stored procedures.
• Troubleshoot the deployment of reports in the test and production environment using SSRS

Environment: MS SQL Server 2008R2, SQL server Reporting Services 2010, SQL Analysis Services 2010, Microsoft Visual Studio 2010, SQL Server Management Studio, MS Excel, ERWIN 7.3.