Senior Consultant (ETL- Data Engineer)

HIGHLIGHTS & RESPONSIBILITIES

** ***** ** ***** ********** in Data analytics and BI using multiple tools, with a track record of significant contribution to business profits and customer satisfaction.

Worked as a Senior BI Consultant for various US and Australian clients.

10 years of detail oriented experience with ETL mapping tool Informatica Power Center 8x/9x.

6 years of experience as Team Lead, Technical Lead with project management roles including effort estimation, resource allocation, scrum sprint planning and prioritizing IT dev tickets.

Displayed excellence in stakeholder management, coordinated innovative design solutions and multi-task on multiple high priority engagements and deliverables.

Earned good exposure on all the phases of SDLC covering requirement capture, analysis, design, coding, code reviews, unit testing, integration testing, UAT, implementation and production support activities.

Had ownership in success of multiple projects. Responsible for estimating and delivering on individual task within project along with team efforts.

Creation of technical documentation, High level and low level mapping design and responsible for maintaining and validating the current documentation.

Worked as an Individual contributor for various BI projects to Independently resolve issues.

Acted as mentor to associate-level staff and other peers with issue resolution and in other technical aspects.

Provided technical expertise in designing, documenting and coding new business initiatives while working closely with BA’s and architects to implement best-of-class ETL solutions.

Actively participated in business requirements gathering sessions and understood client requirements.

Involved in creating release documents and helped build and deploy code across servers and environments.

Creation of low level design documents and unit test cases and to develop high quality code and perform unit tests.

Translate complex functional and technical requirements into detailed design.

Always ready to go the extra mile to find right solutions, so as to put the clients first.

Always seek out innovative solutions and embrace evolving technologies and can easily adapt to new tools, technologies and trends.

Worked as an SME on the analysis of requirements, estimations, coordination for end-to-end implementation of solutions etc. for various Data migration and BI modules and applications.

Always thrilled into investigating complex problems, and making sense of information and finding solutions so as to communicate the correct information in an impactful way.

8 years of experience in Oracle, MS SQL Server databases.

5 years of experience in UNIX shell scripting.

6 months of Tableau and QlikView Reporting experience.

Trained in multiple ETL tools like BODS, SSIS, Alteryx and Big Data basics.

Senior member of the technical interview panel, the RFP panel and the Center of Excellence (CoE) team including training, professional skill development and mentoring.

Oracle Certified Professional (OCP) in 9i DBA.

TECHNICAL SKILLS:

ETL Tools:

Informatica Power Center 8.6/9.6.1, Microsoft SSIS 2012

Databases:

Oracle11g, SQL Server 2012, Teradata

Operating Systems:

Windows 10, XP, 7, NT, UNIX (AIX 7.2)

Scripting Languages:

UNIX Shell Scripting

Visualization Tools:

Tableau 10.1, QlikView 11

Trainings Undergone:

Blue Prism (Data Robotics), Big Data basics, Windows Power Shell Scripting, Azure Development, Spotfire, SAP BODS

EDUCATION

Master of Computer Applications, MG University, India 2004

Bachelor of Computer Applications, MG University, India 2001

WORK EXPERIENCE

ETL Architect

Cognizant, Toronto, Canada October 2019 – December 2019

Onsite ETL Architect for a performance Improvement project for a US pharmaceutical client.

Carried out effort estimation, resource allocation and Task planning.

Identified Source, Target and Transformation level bottle necks for the existing loads and designed performance fixes for them.

Performance tuning at both SQL and Informatica ETL level were accomplished with further streamlining of daily loads in Oracle DAC.

Worked along with the OBIEE admin and Oracle DBA to achieve performance improvement in the overall BI application.

Coordinated work efforts between Onsite and offshore resources, along with daily client Scrum calls.

Senior Consultant

EY, Kochi, India March 2015 – March 2018

Team lead for multiple BI engagements.

Carried out effort estimation, resource allocation and Sprint planning.

Designed and executed the audit, batch processing and reconciliation ETL modules with Informatica Power Center for a major US Insurance client.

Developed multiple medium complexity reports in Tableau for an Australian Insurance client.

Developed and enhanced SSIS ETL modules and QlikView reports for an Australian Govt. engagement.

Introduced standards and good practices that helped successful deployment of Informatica code so as to effectively reduce the overall migration time and iterations.

Owned and executed all the code migration and deployment activities to UAT and Production for multiple engagements and clients.

Prepared POC as part of proposal and initiate frequent discussions with various stakeholders on the expected outcomes of Project.

Technical evaluation as part of recruiting new team members and mentoring them.

Defect management with JIRA and HP ALM and review of Unit Test cases.

IT Analyst

TCS, Kochi, India April 2014 – March 2015

Module lead for a major Media market research engagement.

Carried out effort estimation, resource allocation and Sprint planning.

Designed and executed the enhancements for the existing Enterprise Data Warehouse with Informatica Power Center and SQL Server.

Introduced standards and good practices that helped successful deployment of code so as to effectively reduce the overall migration time and iterations.

Owned and executed all the code migration and deployment activities to UAT and Production.

Defect management with JIRA and HP ALM and review of test cases.

Senior Specialist

Nielsen, Kochi, India April 2011 – March 2014

Team lead for a US based major Media Market research engagement.

Carried out effort estimation, resource allocation and Scrum Sprint planning.

Designed and executed the build and enhancements for the existing Enterprise Data Warehouse with Informatica Power Center and SQL Server.

Designed and Created 100 plus workflows and mappings for the engagement.

Authored and designed custom SQL and UNIX scripts for automation and ease of use.

Introduced standards and good practices that helped successful deployment of code so as to effectively reduce the overall migration time and iterations.

Owned and executed all the code migration and deployment activities to UAT and Production.

Defect management with JIRA and HP ALM and review of test cases.

Software Engineer

Xerox, Kochi, India May 2007 – April 2011

Module lead and Senior ETL developer for multiple US clients in the Healthcare sector.

Designed and Created 100 plus workflows and mappings for the engagement with Informatica Power Center and Oracle.

Authored and designed custom SQL and UNIX scripts for automation and ease of use.

Owned and executed all the code migration and deployment activities to UAT and Production.

Defect management with HP ALM and review of test cases.

References available upon request.

Contact this candidate