SUMMARY:

• 6.8+ years of experience in Data Warehousing encompassing Development, Testing and maintenance of ETL’s on SQL Server, Oracle and SSIS.
• A project executor with exposure to handling projects and ensuring delivery of projects within the time & cost parameters; executed key projects involving Data warehousing using Sql Server, Oracle, SSIS for Business Intelligence.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various heterogeneous source systems like SQL Server, Oracle 11g/10g, DB2, Flat files, XML, Excel into Data Warehouses and Data Marts using SSIS
• Experience in creating and using Stored Procedures, Functions, Triggers, Views and Synonyms in SQL Server and Oracle.
• Good understanding of SQL Server Import/Export utility
• Skilled in Window Batch scripting and also write basic Unix Shell Scripts to automate the jobs.
• Experience in scheduling of ETL jobs using SQL Server Agent and have some idea on Control M tool.
• Also experienced on various tools for check in/check out code like SVN, Tortoise.
• Extensive experience in performing complex analysis and resolving complex issues.
• Rich working experience with very large Data warehouse.

TECHNICAL SKILLS:

ETL Tools: SSIS 2008/2012/2013 , Basics of (Datastage, Informatica)

Data bases: Sql server 2008/2012, Oracle 9i/10g/11g

Languages: SQL, PL/SQL, Window Scripting, UNIX shell scripting basics

Operating Systems: UNIX, Windows 2003/XP/2007/2010

DB Tools: SQL Server, SQL plus, Toad

Other Tools: SVN Tortoise, Autosys, Control - M, Remedy, Putty, Harvest 7

PROFESSIONAL EXPERIENCE:

Confidential

Technology: ETL and .net 4.5

Software/Tools : SSIS 2013, SQL Server 2012

ETL and SQL Server Developer

Responsibilities:

• Involved in gathering requirements from IT/Business client.
• Responsible for design approach and developing ETL packages in SSIS.
• Write multiple stored procedures to handle various functionalities.
• Designing of Data model and table creation in SQL Server.
• Handled data validations and business validations individually.
• Involved in Writing Multiple configurations to deploy the same code in multiple environments.
• Also involved in creating Manifest files, which helps in deploying the code easily.
• Also wrote Reconciliation process and customized email task in SQL script component.
• Perform Unit testing and SIT for all the SSIS packages and stored procedures created.
• Responsible for creating and maintaining all documents for all phases like Requirement, Design and development, SIT/ UAT, Production migration, Deployment and Handover.

Confidential

Technology: ETL/Reporting

Software/Tools : SSIS 2012, SQL Server 2012, Business Objects

Onsite Technical Lead & Developer

Responsibilities:

• Design ETL packages in SSIS.
• Responsible for gathering all ETL requirements.
• Develop various SSIS individual packages based on the Client requirements.
• Involved in enhancement of various existing packages for better performance and add new functionality.
• Created various jobs in AutoSys Scheduler tool to schedule the SSIS Jobs.
• Responsible for creating and maintaining all documents for all phases like Requirement/ Design and development/ system Integration/ User Acceptance testing, Production Deployment and for Handover.
• Also used Attunity drivers to connect with Oracle to improve the performance.
• Perform Unit testing and System Integration testing for all the SSIS packages created.
• Coordination with Business, IT for new requirements.
• Discuss existing issues in application with Business/IT and resolve the same as per timelines

Confidential

Technology: ETL/Reporting

Software/Tools : SSIS 2012, SQL Server 2012, Qlikview 11 and Track IT

Onsite Technical Lead

Responsibilities:

• Involved in migration of servers from Therakos domain to Confidential domain.
• Testing of Entire application after migration
• Coordination with Business, IT and offshore team
• Discuss existing issues in application with Business/IT and resolve the same as per timelines
• Coordinating with source and downstream systems for getting/provision data feeds as per schedule
• Documentation of entire application i.e. Therakos Understanding document, Data dictionaries and Business Rules for all source system.
• Resolve all service requests from users regarding data issues in SSIS and Qlikview
• Handled small enhancement in Qlikview individually
• Worked on enhancements in SSIS whenever requested from Business.
• Handled various recurring data issues by modifying existing SSIS packages.
• Monitoring data loads and validate the data.

Confidential

Technology: ETL

Software/Tools : Data stage 8.5, SSIS, Oracle, UNIX, Control-M, .Net 4.5, SQL Server 2012 and Remedy

Onsite Technical Lead

Responsibilities:

• Coordination with Confidential Business, Confidential IT and offshore team
• Keep application up & running
• Coordinating with different infrastructure teams to keep the servers in better performance
• Discuss existing issues in application with Business/IT and resolve the same as per timelines
• Coordinating with source and downstream systems for getting/provision data feeds as per schedule
• Resolve all service requests from users
• Prepare status reports for IT & Business
• Work on enhancements whenever requested from Business and IT.
• Generating sales data and distribute reports as per the schedule.
• Monitoring Jobs Inbound and Outbound processes.
• Dedicated 40 hours for every month to improve the process.
• Monitoring data loads and validate the data.
• Also act as Onsite lead in gathering requirements from business till sign off /deployments for small projects/enhancements undergone in these applications.

Confidential

Technology: ETL

Software/Tools : SSIS 2010, SQL Server 2008, Window Batch Scripting

ETL Developer and Lead

Responsibilities:

• Responsible for gathering all ETL requirements
• Leading the project form offshore location and responsible for dealing with onsite coordinator and client in regular status calls
• Also handle team and assign tasks on daily basis.
• Write batch Scripts to make the process automated in loading and archiving the source files.
• Design ETL Jobs in SSIS.
• Delivered the Project using standard ICE Methodology for all documentation.
• Responsible for creating and maintaining all documents for all phases like Requirement/ Design and development/ system Integration/ User Acceptance testing, Production Deployment and for Handover.

Confidential

Technology: ETL

Software/Tools : SSIS, SQL Server 2008, UNIX.

ETL Developer

Responsibilities:

• Active and major contribution in requirements gathering, analysis and overall solution design for ETL and Reports.
• Design, development & implementation of ETL transformations, mappings, jobs scheduling using SSIS
• Lead the team for ETL Development.
• Perform Unit and integration testing.
• Perform SIT testing and deployment in (DEV, QA and PROD) Environments.
• Daily status and requirement calls with Client.
• Document preparation as per IGM standards

Confidential

Technology: ETL

Software/Tools : Data stage, PL/SQL, Window Batch Scripting, Cognos

ETL Developer

Responsibilities:

• Responsible for gathering all requirements for ETL
• Leading the project form offshore location and responsible for dealing with onsite coordinator and client for regular status.
• Write batch Scripts to make the process automated in loading and archiving the source files.
• Design, development & implementation of ETL transformations, mappings, jobs.
• Delivered the Project using standard ICE Methodology for all documentation.
• Responsible for creating and maintaining all documents for all phases like Requirement/ Design and development/ system Integration/ User Acceptance testing, Production Deployment and for Handover

Confidential

Technology: BI, Data modeling

Software/Tools: Data stage, Cognos, Oracle and UNIX.

Tester and developer

Responsibilities:

• Requirement understanding, test case preparation & execution.
• Also helped team in creating and understanding data stage jobs.
• Writing SQL Queries and test whether the data shown on the reports matching.
• Responsible for all test management delivery.
• Coordinate with onsite team for gathering Details