SUMMARY

• Having total 9+ years of experience, out of which 7 years of Strong accomplished experience in SSIS development in a data warehouse environment of MS SQL Server with strong business understanding and 2+ years of experience as an SAP FI End - user and Accountant.
• Excellent knowledge of Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, Oracle, OLEDB to Database.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements, understanding the functional work flow of information from source to destination systems.
• Experienced in creating SSIS packages for file transfer from one location to other using different transformations like lookups, Foreach Loop containers Etc., by Sending Alerts using SQL Mail.
• Excellent knowledge of using Variables and Expressions.
• Designed, developed and maintained logical and physical data mappings.
• Created indexes for better performance.
• Ensured accuracy of data by defining and building necessary audits and controls.
• Skilled in error and event handling, precedence Constraints, Break Points, Logging and re-running of failed SSIS packages using checkpoints.
• Experience in writing .net scripts in script component task.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Used Bulk Insert task to load data from different data sources to SQL Server.
• Created, updated and maintained ETL Low Level and High level Design technical Documentation with excellent command on report snapshot.
• Worked with report manager for creating configuration files, deploying SSIS packages across all the environments.
• Very good understanding of data structures, relationships, and hierarchies.
• Created report snapshots for better performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Hands on experience in database installation, configuration, maintenance, monitoring, backup and disaster recovery procedure.
• Actively participated in gathering of User Requirement and System Specification.
• Excellent backend skills in creating databases, Temp Tables to test, tune the SQL queries and Alteration of tables, fields as per requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables.
• Successfully created Fact Tables, Dimensions and joined them to extract meaningful data.
• Created indexes, Views, Stored Procedures, user defined data types for better performance.
• Hands on experience in troubleshooting data base issues.

TECHNICAL SKILLS

RDBMS: Visual Studio 2005/2008, MS SQL SERVER 2000/2005/2008 / R2,Oracle pl/sql

ETL Tools: Microsoft SQL Server Integration services (SSIS) 2008/2012

ERP Packages: SAP R /3 4.7 and 4.6 c

Operating systems: Windows 2000/ XP/ XP Professional/ Vista/ Windows 7/ Windows 8/ Windows 8.1, DOS

Accounting Packages: Tally 7.2

Programming: C, C#, +, VB.net, T- sql

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

SQL/SSIS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Expert in Extracting and Transforming data using SSIS in SQL Server with proper control & data flow elements.
• Created SSIS Packages using Various Transformations like Foreach loop containers, Conditionsplit, lookup, Merge etc... to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file and CSV files to data base.
• Excellent knowledge of using Variables and Expressions.
• Designed, developed and maintained logical and physical data mappings.
• Work with team members to refine, test, and debug programs to meet needs.
• Very good understanding of data structures, relationships, and hierarchies.
• Experienced with SSIS performance tunings using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Involved in Database Backup and Recovery procedures.
• Performed Data Cleansing and Data Profiling using transformations like Data Conversion and Derived Column.
• Worked with report manager for deploying SSIS packages across all the environments.
• Created, updated and maintained ETL Low Level and High level Design technical Documentation with excellent command on report snapshot.
• Experience in writing .net scripts in script component task.
• Used Bulk Insert to load data from different data sources to SQL Server.
• Analyzed problems and new requests.
• Excellent backend skills in creating SQL objects like Alteration of tables, fields, Stored Procedures, user defined data types and functions as per requirements.
• Involved in setting up SQL Server Agent Jobs for timely updating of the tables on the linked servers through SSIS and SQL store procedures.
• Experience in creating Indexes for faster performance and Views for controlling user access to data.
• Created test databases to test and tune the SQL queries.

Environment: SQL server 2008/2008R2/2012,.Net Framework 2.0, 2003 Standard Edition, Microsoft Visual Studio Team foundation server, SQL Server Integration Services 2008, MS-Excel 2003, Excel Power Pivot (1.0 and 2.0 versions).

Confidential, Milwaukee, WI

SQL/SSIS Developer

Responsibilities:

• Created packages using SSIS for data extraction from Flat Files, Excel Files and OLEDB to SQL Server.
• Used expressions and variables in SSIS to make dynamic load.
• Actively participated in gathering of User Requirement and System Specification.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Created SSIS Packages using different Transformations like foreach loop, for loop, Lookup, Pivot Transformations etc... to export data from Excel Spreadsheets, Text file, CSV files to data base.
• Designed dynamic SSIS Packages to transfer data crossing different platforms and archived data files for different DBMS.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables.
• Performed data conversion from flat files, Excel sheets, Text File into SQL Server Table.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Responsible for documentation of system related activities.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in Database Backup and Recovery procedures.
• Extensive experience with Bulk Copy Program (BCP) for flat file import and export operation to/from SQL Server.
• Good command on report snapshot.
• Transformed data from one server to other servers using SQL Server Integration Services(SSIS).
• Skilled in error and event handling: precedence Constraints, Break Points, Logging and re-running of failed SSIS packages using checkpoints.
• Created test databases to test and tune the SQL queries.
• Successfully created Fact Tables and joined them to extract meaningful data.

Environment: MS SQL Server 2000/2005/2008 R2, Management Studio, Integration Services, Reporting Services, SSRS, SQL, PL/SQL, Oracle 9i, Analysis Services, T-SQL, DB2, Windows, ETL, SQL Server Agent, Microsoft Access, Microsoft Share point Portal Server, OLAP.

Confidential

SQL/SSIS Developer

Responsibilities:

• Design and Build Extract Transform Load procedures in SQL Server to import/export data feeds to/from data warehouse.
• Proficient in implementing transformations like Foreach loop, lookups, condition slips etc... available in SSIS toolbox.
• Experienced in Data Conversion to obtain data in required data type and format from Clients data.
• Used Oracle, SQL, and PL/SQL in test environment.
• Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as proactive team member.
• Excellent knowledge of using Variables and Expressions.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS.
• Experience in backup and disaster recovery procedures.
• Created SSIS Packages using different types of Transformations to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file and CSV files, OLEDB to data base.
• Configured, built, deployed different reports in Excel formats according to the business requirement.
• Work with team members to test and debug programs to meet needs.
• Prepared completedata mappingfor all the migrated jobs using SSIS.
• Experienced with SSIS performance tunings using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database.

Environment: MS SQL Server 2005/2000, MS Access 2000, Management Studio, MS SQL Analysis Services 2005, MS Excel, Visual Studio 2005, Windows Server 2003, T-SQL, VB.net, ASP.net.

Confidential 

SQL/SSIS Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Used different Transformation in SSIS as per design specifications.
• Monitored and provided front-line support of daily processes.
• Created SSIS package to load data from Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns and Slowly Changing Dimension.
• Managed and resolved design issues during development.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS to extract data from SQL Server, Flat File sources and load into various Business Entities.
• Assisted new and existing clients with integration and data conversion activities.
• Experience in creating Indexes for faster performance and Views for controlling user access to data.
• Provided estimated time frame for the project by interacting with the other team developers.
• Involved in developing the SQL code for the application.
• Hands on experience in troubleshooting database issues.
• Analyzed the Reports, Tables and ETL process.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Excellent backend skills in creating SQL objects like Alteration of tables and fields as per requirements.
• Designed and created SQL database tables and views structure for the new data mart.
• Created test databases to test and tune the SQL queries.
• Successfully created Fact Tables and joined them to extract meaningful data.

Environment: MS SQL Server 2005/2000,Visual Studio 2005, MS SQL Server Management Studio,DTS-2000,SSIS-2005,SSRS-2005,Report Builder, Office, Excel, ERWIN.