PROFESSIONAL SUMMARY:

• Having 7 years of IT professional work experience dedicated to Data warehousing and Business Intelligence community
• Worked on all phases of data warehouse development lifecycle, from gathering requirements, designing, analysis, implementation, testing, implementation, and support of Data Warehouse Applications
• Worked extensively with the Onsite - Offshore model, co-ordination with clients/users, understanding of client requirements and providing appropriate design
• Worked extensively in ETL tools - Informatica Powercenter, Datastage, Unix Shell Scripting and SQL programming.
• Experience working in Oracle, SQL Server and Sybase, DB2 databases.
• Familiar with version management software’s such as TFS, SVN, Git
• Familiar with scheduling tools ESP, Control-M and Appworx
• Have played the role of Technical Lead and Developer in my Career.
• Capable of leading a technical development team and working as an individual as well as part of team
• Sound analytical and problem-solving skills with a good exposure to the key facets of leading teams to meet set objectives and ability to adapt and learn new technologies.
• Familiar with database and ETL best practices
• Well versed individual with good interpersonal and communication skills.
• Worked closely with Business and Sales team for new proposals.
• Worked on assessments for new requirements.
• Ability to work collaboratively and understanding of business requirements and system architecture and adapt to evolving technology, strong sense of responsibility and .
• Leading DW/BI team engagements
• Establishing ETL Governance standards and best practices
• Solution based architecture for ETL problems, unit testing strategies and development of ETL jobs for data warehouses
• Optimizes use of available resources
• Leading DW/BI team engagements
• Understand the requirements, perform thorough analysis (design approach & impact analysis) on the requirements for obtaining clarity
• Work with business owners in understanding the business requirements
• Possess a deep understanding of product technology and functionality & features being handled/ implemented
• Design, creation and management of Datastage jobs, Informatica mappings, SQL scripts and UNIX shell scripting
• Analyze and solve business problems at their root, stepping back to understand the broader context.
• Performance tuning of Informatica Mappings, Datastage jobs and SQL scripts
• Providing knowledge transfer to team members
• Establishing Database, ETL Governance standards and best practices
• Schedule ad-hoc calls or during scrum calls, communicate to the product management team to walkthrough Unit test coverage, development and obtain signoff over the call / through email for every story
• Responsible for providing quality deliverables
• Focuses on results and success, conveying a sense of urgency and driving issues to closure
• Optimizes use of available resources
• Contribute to the development of the Software Engineering competency
• Support the sales team by providing required data for their sales pursuits
• Provided Informatica/Datastage sessions to ETL trainees.
• Provided Knowledge transfer to internal team members specific to my subject area.

TECHNICAL SKILLS:

Methodologies: Agile, Water Fall.

Database: Oracle, SQL server, DB2, Sybase

ETL Tools: Informatica Power Center 8.6.1 and 9.5.1, Datastage 11.5

Operating System: Windows, UNIX, Linux

Scripts: Unix shell scripting.

Design: Visio

Business Domain: Insurance, Healthcare

PROJECT EXPERINCE:

Confidential

ETL Lead & Developer

Responsibilities:

• Act as overall technical authority for the project.
• Design, creation and management of Reusable framework for monthly jobs and provide support to existing applications.
• Work with business owners in understanding the business requirements.
• Analyze and solve business problems at their root, stepping back to understand the broader context.
• Functional testing of the developed objects.
• Performance tuning of Mappings & Sql.
• Analyze and solve business problems at their root, stepping back to understand the broader context.
• Leading and developing a team of DWBI Engineer.
• Leading DW/BI team engagements.
• Establishing Database, ETL Governance standards and best practices.
• Solution based architecture for ETL problems, unit testing strategies and development of ETL jobs for data warehouses.
• Focuses on results and success, conveying a sense of urgency and driving issues to closure.
• Optimizes use of available resources.

Confidential

ETL Lead/Developer

Responsibilities:

• Design, creation and management of Reusable framework and provide support to existing applications.
• Work with business owners in understanding the business requirements.
• Analyze and solve business problems at their root, stepping back to understand the broader context.
• Functional testing of the developed objects.
• Create jobs, DB queries and shell scripting
• Performance tuning of Mappings & Sql.
• Analyze and solve business problems at their root, stepping back to understand the broader context.
• Leading and developing a team of DWBI Engineer.
• Leading DW/BI team engagements.
• Establishing Database, ETL Governance standards and best practices.
• Solution based architecture for ETL problems, unit testing strategies and development of ETL jobs for data warehouses.
• Focuses on results and success, conveying a sense of urgency and driving issues to closure.
• Optimizes use of available resources.

Confidential

Senior ETL Developer

Responsibilities:

• Design, creation and management of Datastage, Informatica Mappings & Sql
• Work with business owners in understanding the business requirements.
• Analyze and solve business problems at their root, stepping back to understand the broader context.
• Functional testing of the developed objects
• Performance tuning of Informatica Mappings & Sql
• Analyze and solve business problems at their root, stepping back to understand the broader context
• Leading and developing a team of DWBI Engineer
• Leading DW/BI team engagements
• Establishing ETL Governance standards and best practices
• Solution based architecture for ETL problems, unit testing strategies and development of ETL jobs for data warehouses
• Focuses on results and success, conveying a sense of urgency and driving issues to closure
• Optimizes use of available resources

Confidential

ETL Developer & Tester

Responsibilities:

• Act as overall technical authority for the project.
• Design, creation and management of Informatica Mappings & Sql
• Work with business owners in understanding the business requirements.
• Analyze and solve business problems at their root, stepping back to understand the broader context.
• Functional testing of the developed objects
• Performance tuning of Informatica Mappings & Sql
• Analyze and solve business problems at their root, stepping back to understand the broader context
• Leading and developing a team of DWBI Engineer
• Leading DW/BI team engagements
• Establishing ETL Governance standards and best practices
• Solution based architecture for ETL problems, unit testing strategies and development of ETL jobs for data warehouses
• Focuses on results and success, conveying a sense of urgency and driving issues to closure
• Optimizes use of available resources

Confidential

ETL Developer & Tester

Responsibilities:

• Preparing Business requirement document and possible approach to Business
• Work order preparation for the proposed business solution and task allocation
• Understanding the business requirement and prepare the understanding documents for the project.
• Developing the ETL standards and strategies to load the data.
• Coordinating and communicating with the onsite coordinator and business stakeholders.
• Preparing the Unit, System integration test cases, User acceptance testing & test logs.
• Focuses on results and success, conveying a sense of urgency and driving issues to closure
• Optimizes use of available resources
• Preparing product support document and knowledge transfer for production support team members.