SUMMARY

• Over 8+ years IT experience in Database Design, Development and Implementation of SQLSERVER 2012/2008R2/2005 and providing ETL/Business Intelligence applications using Microsoft components.
• TEMPEffectively involved in all teh phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects.
• Extensive SQL Development experience in a Banking & Healthcare environment with a strong understanding of data & analytics.
• Working experience in BI Solutions (ETL) using SSIS and SSRS.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Expert in using SQL Server Agent to Schedule and monitor Jobs.
• Extensive knowledge in tuning T - SQL (DDL and DML) queries to improve teh database performance and availability.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL)solutions for data warehousing using SQL Server Integration Service (SSIS)
• Expertise in conversion of DTS to SSIS packages and troubleshooting teh migration issues.
• Used incremental approach in teh Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Experience in providing System and User-defined Variables, Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in creating configuration files to deploy teh SSIS packages across all environments.
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions ( 2005/2008/2008 R2) & features.
• Strong Experience in Unit, Integration and System Testing.

TECHNICAL SKILLS

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SQL SERVER BIDS, Visual Studio 2003/2005/2010, Visual SourceSafe 8.0

Programming Languages: Pascal, C, C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL, HTML, XML

Tools: DTS, SSIS, SSRS, SSAS, Erwin

DATABASE: MS Access, MS SQL Server 2005/2008/2008 R2/2012, Oracle8i/9i/10g, DB2

Operating Systems: Windows NT/98/2000/XP/2003/2008 server

Software: MS Office Visio, MS-Project 2000

IT Processes: Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE

Confidential, Daimler,Portland

SSIS Developer

Responsibilities:

• Created ETL SSIS packages both design and code to process data to target databases.
• Debugging and troubleshooting teh technical issues while implementing teh applications.
• Created Complex ETL Packages using SSIS to extract data from staging tables to tables with incremental load.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created ETL packages with different data sources (SQL Server,.ldif files etc.) and tan loaded teh data into destination tables by performing complex transformations using SSIS.
• Used different transformations lookup, condition split, Derived Column, Data Conversion.
• Created Stored Procedures for package Initialization and end package information to update teh package log table.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages .
• Defined precedence constraints and implemented various control flow tasks such as Data Flow Task,Execute SQL task, Execute Package Task and Send Mail Task.
• Worked extensively on system analysis, design, development, testing and implementation of projects

Environment: MS SQL Server2008, SSRS, SSIS, SQL Query Analyzer, SQL profiler,IIS 6.0,Enterprise Manager, Windows7, SQL Server Management Studio, SQL Server Business Intelligence Studio

Confidential, Moorestown, NJ

SSIS Developer

Responsibilities:

• Created ETL SSIS packages both design and code to process data to target databases.
• Identify and resolve problems encountered during both development and release of teh SSIS code.
• Debugging and troubleshooting teh technical issues while implementing teh applications.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Developed, Maintained, and Monitored all import/export and Data Transformation into teh Staging and Production environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and tan loaded teh data into destination tables by performing complex transformations using SSIS/DTS packages.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Created Stored Procedures to transform teh Data and worked extensively in T-SQL for various needs of teh transformations while loading teh data.
• Created views to display required information on user interface, and triggers to validate consistent data entry into teh database.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler,IIS 6.0,Enterprise Manager, Windows Server 2003/2008, DTS, Share Point Portal Server

Confidential, Charlotte, NC

MS SQL Server SSIS Developer

Responsibilities:

• Used SSIS to create ETL packagesto validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev., Test and Production Environments.
• Worked on development, implementation, administration and support of ETL processes for large-scaleData Warehouses using SSIS and DTS.
• Created SSIS process design architecting teh flow of data from various sources to target and Involved in extracting teh data using SSIS from OLTP to OLAP.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted teh results into reports and kept logs.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from teh Flat files on monthly and weekly basis.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Involved in designing teh physical database models on SQL Server 2005 RDBMS using DML/DDL implementing constraints and triggers for data integrity.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Used Notification services to generate error messages and send them to teh user through e-mails, pager messages, and PDA as well as window messengers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Created incremental data load task using SQLServer Integration services
• Involved in projectstatus report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Involved in migration from SQLServer 2005 to SQL Server 2008

Environment: MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler,IIS 6.0, Oracle10g, 11g, Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server,HTML, XML, C#, .Net,ASP.NET, Visual Studio 2005, MSAccess, Crystal Reports, MS Excel 2007.

Confidential

MS SQL Server SSIS Developer

Responsibilities:

• Installed and configure servers and clients using SQL Server 2008,Upgraded SQL databases
• Managed indexes, statistics and tuned queries by using execution plan for optimizing teh performance of teh databases
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created ETL SSIS packages both design and code to process data to target databases
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from teh Flat files on monthly and weekly basis
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis
• Created Snapshots, Subscriptions and Transactions using Replication services
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor
• Responsible for teh design of teh SSIS package for updating teh data mart from OLTP database and validation of teh aggregate data from teh ODS and teh OLTP Database

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, BizTalk Server 2004 Erwin, Microsoft Visio 2003, SFTP

Confidential

MS SQL Server SSIS\SSRS Developer

Responsibilities:

• Designed SSIS strategies to pull data from different sources, like SQL server, flat files and load it to teh destination database
• Used Email Notification package success or failure. If teh package is success send teh mail with package name, how many records inserted, updated and total records using Send Mail Task. If teh package is failed it will send teh mail package name and error description using On Error Event handlers in Send Mail task.
• Defined precedence constraints and implemented various control flow tasks such as Data Flow Task,Execute SQL task, Execute Package Task and Send Mail Task.
• Used Merge Statement for maintain teh Inserts and updates if teh table have less data.
• Used different transformations lookup, condition split, Derived Column, Data Conversion.
• Created Stored Procedures for package Initialization and end package information to update teh package log table.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports
• Designed Cascading ( Collapsed ), Printable, interacted reports (drill-down and sorting functionality)
• Created sub reports and pass through parameters from main report to teh sub reports

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, BizTalk Server 2004 Erwin, Microsoft Visio 2003, SFTP

Confidential

MS SQL Server SSIS Developer

Responsibilities:

• Developed teh SSIS ETL packages which will take teh data from various sources like Flat files, Excel and XML files and will perform teh appropriate transformations over teh data and will load teh data onto targeted SQLServer Data mart.
• Worked with Script task, Execute DTS package task, Data conversions, Merge Join tasks, look up transformations, Execute SQL Task, OledbCommand Task and Sequence containers and For Each Loop containers in teh package development.
• Developed teh packages to perform Exception handling, staging of data and database backups..
• Worked with Deploying teh SSIS packages using SQLServer package deployment wizard to deploy teh packages on teh production server.
• Environment: SQL Server 2000/2005, Visual Studios 2000, ASP, Excel, MS Access, Visual Basic 6.0, and Windows 2000/NT 4.0