OBJECTIVE

• To get a job at a growth oriented company, and become a critical contributor to its success by applying strong experience in software design, development and testing.
• With my strong aptitude and team work, I am confident to deliver products in timely manner.
• I have keen interest in working on design and development of state - of the-art line of financial information products as I have good problem solving skills and I am quick learner.

TECHNICAL SKILLS

Programming Languages: MS SQL, PL/SQL, C/C++, JAVA, Visual Basic 6.0, VB.Net, ASP.Net

Database Tools: MS SQL Server 2000/ 2005/2008/2012 , MS-Access, Query Analyzer, Enterprise Manager, Management Studio, SQL Server Business Intelligence Development Studio, Oracle 8i/9i

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS) 2005/2008/2012 , Import Export Data, Bulk Insert, BCP

Data Modeling Tools: Microsoft Visio, ER-Win

Reporting Tools: Reporting Services (SSRS), Crystal Reports, MS Access, MS Excel.

Operating Systems: Windows 95/98/NT/XP/Vista/10, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Horsham, PA

SQL-SSIS Developer/ETL Architect

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to Identify business needs and discuss solution options.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created Triggers to maintain user log for security purpose.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Heavily used temporary tables, variables, Common table expression CTE.
• Created functions and views to achieve data reconciliation.
• Created Complex stored procedures.
• Worked/Helped as Performance Tuning specialist in several other projects.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from database.
• Created an ETL solution that reads user Data from an FTP Server into SQL Server Database. The Solution also validated incoming data and send notification to users on completion of Job on daily Basis.
• Extensively used SSIS script component and script task to implement detailed Business logic into Packages.
• Calling multiple packages using Parent Child Relationship.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2008 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Responsible for implementation of SSIS Logging, Error Configurations and Send Mail Task for error handling the packages.
• Created jobs on daily basis and schedule to update recent data by using Tivoli Tool.
• Involved in unit testing of Store Procedure and UI as per requirement on different server.
• Supported production operation activities, with focus on integration and development of new and existing products and services.

Environment: Microsoft SQL Server 2012/2008 Enterprise Edition, SQL Server Integration Service (SSIS) 2012/2008,SSRS,Tivoli, Microsoft Visual Studio 2010, MS Excel 2010,MS Visio, Windows Server 2008, Windows Server 2010

Confidential, Basking Ridge, NJ

SQL-SSIS Developer/ETL Framework Developer/ETL Architect

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment.
• Involved in Functional specification reviews, and created technical specification, ER diagrams using MS Visio and mapping the data into database objects.
• Designed and created metadata driven ETL framework using SQL Server Integration Service(SSIS) to standardize different kinds of data feeds
• Created complex stored procedures for metadata driven ETL to validate metadata using inputted values like data types, length, format, null constraint on columns etc
• Responsible for the design of the SSIS package using various dataflow and control flow controls for the ETL(SSIS) for both metadata driven as well as traditional approach.
• Created complex dynamic SQL stored procedures to perform lookup transformation and log for unsuccessful transformation.
• Converted ActiveX script and VB.Net parsing routines into SQL stored procedure.
• Heavily used cursors to loop through each record type to achieve for each loop in dynamic SQL.
• Heavily used temporary tables, variables, Common table expression CTE.
• Created functions and views to achieve data reconciliation.
• Defined Check constraints, Business Rules, Indexes and synonyms.
• Created and managed users, roles and groups and handled database security.
• Responsible for the Performance tuning of SQL queries and tuned stored procedures by avoiding parameter sniffing.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and generated trace reports while running metadata driven process.
• Added partition slide mechanism to process very large amount of data.
• Developed ETL packages with different data sources (SQL Server, Oracle, Flat Files, Excel source files) and loaded the data into target tables by performing different kinds of transformations(Control flow transformations such as FTP Task, For Loop Container, For Each Loop Container, Execute package task, Execute process task, Script tasks, Send Mail task, Data Reader Task, XML Task and Data flow transformations such as Lookup, Conditional Split, Derived Column, Audit, Merge, Merge Join, Sort ) using SQL Server Integration Services (SSIS).
• Migrated large number of DTS package to SSIS 2012.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Created VB script to perform metadata validation for various feeds.
• Parsed complex reports and converted standard delimited file using VB.Net script
• Having quality to adapt any new technology very quickly and also good at managing project and mentoring.

Environment: Microsoft SQL Server 2012/2008 Enterprise Edition, SQL Server Integration Service (SSIS) 2012/2008,SSRS,DTS, TFS, Microsoft Visual Studio 2008/2005, VB.Net, MS Excel 2010,MS Visio, Windows Server 2008

Confidential, Union NJ

SQL/SSIS Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment.
• Involved in Functional specification reviews, and created technical specification, ER diagrams and mapping the data into database objects.
• Created Jobs to extract data from different source systems using SSIS packages. Stored Procedures called within these Jobs would aggregate the data and load them in temporary staging table, having the same architecture as the table for which the import is done
• Developed ETL packages with different data sources (SQL Server, Oracle,AS400,Lotus Notes, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations(Control flow transformations such as FTP Task, For Each Loop Container, Execute package task, Execute process task, Script tasks, Send Mail task, XML Task and Data flow transformations such as Lookup, Conditional Split, Derived Column, Audit, Merge, Merge Join, Sort ) using SQL Server Integration Services (SSIS)
• Involved in Data Conversion process in SQL server 2008 using SSIS
• Developed the Slowly Changing Transformation to maintain the Historical Data.
• Performed Data Scrubbing and Validation in SSIS in preparation of implementation in production environment
• Helped the front end application developers with their query requirement
• UsedVBscript in script component for data transformations.
• Designed the data mart with the use of the fact and dimension table model. Also designed the aggregate table for the usage summary reports.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed database consistency checks with DBCC utilities

Environment: Microsoft SQL Server 2008/2005 Enterprise Edition, SQL Server Integration Service (SSIS) 2005/2008,SSRS, SVN, Microsoft Visual Studio 2008/2005, VB.Net, MS Excel 2010,MS Visio, Windows Server 2008

Confidential, NY

SSIS Developer

Responsibilities:

• Responsible for the design of the SSIS package using various dataflow and control flow controls for the ETL for the update the data mart from OLTP database.
• Loaded data from ODS to data warehouse using SSIS.
• Developed the Slowly Changing Transformation to maintain the Historical Data.
• UsedVBscript in script component for data transformations.
• Designed the data mart with the use of the fact and dimension table model. Also designed the aggregate table for the usage summary reports.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed data conversions from flat files into a normalized database structure.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created Triggers to maintain user log for security purpose.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Created and managed users, roles and groups and handled database security.
• Analyzing the Database Growth and Space Requirement for very large database. Handling Users/Logins/User Rights.
• Created several linked server with remote database such as My SQL, DB2.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Designed GUI to run SSIS Package from Front End Application.

Environment: Microsoft SQL Server 2005 Enterprise Edition, SQL Server Integration Service (SSIS) 2005,SSRS, TFS, Microsoft Visual Studio 2005,, MS Excel 2007,MS Visio, Windows Server 2008

Confidential, Virginia Beach, VA

SQL Server Developer

Responsibilities:

• Responsible for logical and the physical design of the data mart for the use reporting services with the use of the OLTP Database in SQL Server 2005.
• Designed the data mart with the use of the fact and dimension table model. Also designed the aggregate table for the usage summary reports.
• Responsible for the design of the SSIS package using various dataflow and control flow controls for the ETL for the update the data mart from OLTP database.
• Developed the Slowly Changing Transformation to maintain the Historical Data.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed data conversions from flat files into a normalized database structure.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created Triggers to maintain user log for security purpose.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Created and managed users, roles and groups and handled database security.
• Analyzing the Database Growth and Space Requirement for very large database. Handling Users/Logins/User Rights.
• Created several linked server with remote database such as My SQL, DB2.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Designed GUI to run SSIS Package from Front End Application.

Environment: Microsoft SQL Server 2005 Enterprise Edition, SQL Server Integration Service (SSIS) 2005,SSRS, TFS, Microsoft Visual Studio 2005,, MS Excel 2007,MS Visio, Windows Server 2008

Confidential, Lakewood, NJ

SQL Server Developer

Responsibilities:

• Wrote complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constrains to preserve data integrity
• Extensive use of Check constraints, Business Rules, Indexes, and Views.
• Created schemas, views, Stored Procedures, Triggers and functions for Data Migration
• Creating dynamic SQL in Stored Procedures to support the dynamic nature of the front end application
• Responsible for building interface stored procedures for various transaction reports
• Created database triggers and constrains to implement business requirements
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Developed ETL packages with different data sources (SQL Server, Oracle, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations(Control flow transformations such as FTP Task, For Loop Container, For Each Loop Container, Execute package task, Execute process task, Script tasks, Send Mail task, Data Reader Task, XML Task and Data flow transformations such as Lookup, Conditional Split, Derived Column, Audit, Merge, Merge Join, Sort ) using SQL Server Integration Services (SSIS)
• Created Jobs to extract data from different source systems using SSIS packages. Stored Procedures called within these Jobs would aggregate the data and load them in temporary staging table, having the same architecture as the table for which the import is done
• Loaded data from ODS to data warehouse using SSIS
• Developed the Slowly Changing Transformation to maintain the Historical Data in SSIS
• Worked extensively on SSIS service to implement the migration of the already existing DTS packages
• Involved in Data Conversion process from SQL server 2000 to SQL Server 2005 using SSIS
• Performed Data Scrubbing and Validation in SSIS in preparation of implementation in production environment
• Define data sources, data source views, dimensions, attributes, attribute relationships, hierarchies, and cubes in an SQL Server Analysis Service (SSAS)
• Created Alerts for successful or unsuccessful completion of scheduled Jobs
• Performed database consistency checks with DBCC utilities
• Helped the front end application developers with their query requirement

Environment: Microsoft SQL Server 2000/2005 Enterprise Edition, Management studio, SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), Crystal Report, Microsoft Visual Studio 2005, VB.Net, MS excel 2003, Windows XP