SUMMARY:

• 11+ years of experience in data warehousing projects Using Microsoft Business Intelligence (MSBI) Technology - SQL Server Integration Services (SSIS) as an ETL tool and also experienced in SQL Server 2005 and SQL Server 2008.
• 3+ Years of ETL architect with different tools.
• 5+ years as a Technology Lead, with 2+ year of Onsite Client Coordinator and Lean Navigator.
• My technical forte includes development experience using SQL Server 2005 and SQL Server 2008 (SSIS) also have good working knowledge for testing of SSIS Packages.
• 3+ Years of experience in Informatica power center.
• 1+ Years of experience in Attunity replicator which is used to replicate the real time data into the data warehouse.
• 1+ Years of experience in Informatica MDM
• Experience in ETL Architect in designing the ETL flows.
• Experience in developing the complex SQL Server Integration Services (SSIS) packages.
• Experience in implementation of Data warehouse applications mainly Extraction, Transformation and Loading process using ETL tool Using SQL Server Integration Services (SSIS)
• Experience in implementation of Data warehouse applications using Informatica Power Center.
• Experience in developing various DB objects like Views, Triggers and Stored Procedures in SQL Server and Oracle database.
• Involved in all phases of SDLC
• Strong analytical and programming capabilities with good communication skills
• Exceptional ability to quickly master in new concepts and applications
• Excellent analytical, problem solving, technical, interpersonal, and communication skills with a strong entrepreneurial drive.
• Excellent team player and possess leadership ability
• Experience in setting up real time update to the Datawarehouse using Attunity replicator.
• Hands on experience in generating the reports using SQL Server Reporting Services (SSRS).
• Hands on experience in creating the analysis service cubes for the datawarehouse using SQL Server Analysis services (SSAS).
• Extensive experience on supporting applications in production, on call support.
• Ability to learn new technologies and methodologies quickly.

TECHNICAL SKILLS:

Technologies: Datawarehousing - MSBI, ETL Architect

Tools: SSIS(SQL Server Integration Services), Informatica, SSRS(SQL Server Reporting Services) and SSAS (SQL Server Analysis Services), Attunity Replicator.

RDBMS: SQL Server and Oracle

Query Tools: TOAD, SQL Developer

Version Control: TFS

Operating Systems: Windows 2000/7/NT/98/XP

PROFESSIONAL EXPERIENCE:

Confidential

ETL Architect

Responsibilities:

• Analyzing the requirements based on the requirement document
• Architecting the ETL solution for the customer specific solutions using MSBI-SSIS.
• Involved in the design of functional specifications and technical design documents for proposed ETL solution.
• Deploying the product to the end user for ETL packages.
• Production support enhancements and maintenance
• Cube deployment and Architecting the enhancements base on the client requirement and generating the reports.
• Interactions with end clients.

Environment: Windows Server 2008 R2, SQL Server 2012 and SQL Server Integration Services (SSIS)

Confidential

ETL Architect

Responsibilities:

• Analyzing the requirements based on the requirement document
• Estimating the effort for the solution.
• As ETL Architect, I have been involved in providing the ETL solution based on the requirements and client need.
• Involved in reviewing the all the ETL solution developed by the team
• Designed and implemented generic Visio Mapping templates
• Supported development, production and business groups by providing technical tips
• Involved in writing various Views, Triggers and Stored Procedures.
• Involved in the design of functional specifications and technical design documents for proposed ETL solution.
• Involved in Unit and Functional Testing along with the different phases of UAT.
• Production support enhancements and maintenance
• Interactions with clients on daily basis to discuss any issues
• Worked on various performance issues.
• As a team lead all the responsibility of managing the team is been taken proactively.

Environment: Windows Server 2008 R2, SQL Server 2008 R2, SQL Server Integration Services(SSIS), Oracle 11g, Attunity Replicator, Informatica MDM and Tivoli Workload Scheduler (TWS Maestro) .

Confidential

ETL Architect & Lead.

Responsibilities:

• Analyzing the requirements based on the requirement document
• Architecting the overall ETL process
• Estimating the effort for the solution.
• Developing the Stored Procedures in SQL server 2012.
• Involved in the design of functional specifications and technical design documents for proposed ETL solution.
• Involved in Unit and Functional Testing along with the different phases of UAT.
• Production support enhancements and maintenance
• Interactions with clients on daily scrum meetings
• Worked on various performance issues.

Environment: Windows Server 2008 R2, SQL Server 2012 and SQL Server Integration Services (SSIS) and Informatica MDM

Confidential

ETL Module Lead.

Responsibilities:

• Developing the ETL packages and load the data into warehouse using SSIS
• Developing the Stored Procedures in SQL server 2005
• Db modeling of various new enhancements
• Involved in writing various Views and Stored Procedures for Crystal Reports, SSRS reports and new screens
• Involved in the design of functional specifications and technical design documents of module
• Involved in Unit and Functional Testing
• Production support enhancements and maintenance
• Interactions with clients on daily basis to discuss any issues
• Worked on various performance issues

Environment: Windows Server 2008 R2, SQL Server 2005, SQL Server Integration Services (SSIS)

Confidential

ETL Developer

Responsibilities:

• Developing the ETL packages and load the data into warehouse using SSIS
• Developing the Stored Procedures in SQL server 2005
• Developing the cubes using SSAS on the warehouse database
• Creating the Configuration Files for the developed packages.

Environment: Microsoft SQL Server 2008(SSIS,SSRS,SSAS), Microsoft Office Share Point Server, Microsoft SQL Server Analysis Services 2008 and Microsoft SQL Server Reporting Services 2008..

Confidential

ETL Developer

Responsibilities:

• Analyzing the requirements for Wireless system.
• Design of logical model.
• Developing the ETL packages and load the data into data warehouse using SSIS packages.
• Developing the Stored Procedures in Sybase and SQL server 2005
• Developing the cubes using SSAS on the warehouse database
• Creating the reports from Data Warehouse using SSRS
• Testing the back-end functionalities of wireless systems

Environment: Microsoft SQL Server Integration Services 2005 (SSIS), Sybase Data Base and Microsoft SQL Server Reporting Services 2005.

Confidential

ETL Developer

Responsibilities:

• Understanding of business requirement document
• Analyzing source system data.
• Reviewing the Data models and architecture of project.
• Involved in Developing Mappings using Informatica Designer Tool.
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Aggregator while Developing Mappings using Informatica Designer Tool.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy
• Involved in Creating sessions and Work flows using Informatica Work flow Manager.

Environment: Informatica Power center 7, Oracle 10 Data base, SQL developer and TOAD.

Confidential

ETL Developer

Responsibilities:

• Design and development of ETL process using Informatica 7.1.1 to load data from Source to Staging area
• Designed and implemented various transformations using Informatica Designer.
• Developed mapping to load data in slowly changing dimensions.
• Performed tuning of mapping.
• Used Informatica Work flow Manager to Create and Monitor Sessions.

Environment: Informatica Power center 7, Oracle 10 Data base, SQL developer and TOAD

Confidential

ETL Developer

Responsibilities:

• Mainly involved in ETL developing.
• Worked with Power Center, Designer tool to develop mappings.
• Analyzed the sources, targets, transformed the data, mapped the data and loading the data into targets using Informatica.
• Creating the mappings and transformations using Informatica.
• Developed work flows and work lets for mappings using Work flow Manager to load data from source to target tables.
• Loading the data into the data mart by applying the business rules.
• Scheduling the sessions & Batches to load the data into the target. Used Informatica Work flow Manager to Create and Monitor Sessions.

Environment: Informatica Power center 7, Oracle 9 Data base, SQL developer and TOAD