SUMMARY:

• 13+ years of Software industry experience with extensive 7+ years in Data Warehouse development and production support using various ETL & BI Tools in multi - platform environments
• 12+ years of ETL design, development experience using Informatica,and Oracle PL/SQL
• An effective Leader with proven abilities in leading teams, training, mentoring and guiding team members and enabling knowledge sharing among the team
• I have experience in varied industries including Telecom, Media, Pharmacy, Financial services, Insurance and Logistics. I have worked with customers across the globe, and have been instrumental in setting up strong foundations for long term work relationships in my last couple of roles.

IT SKILLS:

• ETLInformatica 6.x 7.x & 8.x, 9.x, Power Centre, Power Exchange,Datastage 8.5,Talend
• Oracle 8i, 9i and 10G, SQL, PL/SQL, SQL Server
• Unix Shell scripting
• ETL-Informatica, Oracle PL/SQL, DataStage 8.5
• Java
• Hadoop, Hortonworks 2.4, sqoop, HBASEand Hive
• Agile and Waterfall methodolgies

PROFESSIONAL EXPERIENCE:

Confidential

Architect( Data Management & ETL)

PlatForm: Informatica 9 Powercentre, Oracle 11.2 Oracle Enterprise Data Quality(EDQ), AWS,ERWIN 7.3.4, Power exchange

Responsibilities:

• Analyzing Reporting requirements for data integration
• Conducted JAD sessions with business users and SME's for better understanding of requirements
• Deliver Detailed Design document
• Design Data model for staging, ODS & data mart
• Present Solution design to the Customer and get sign off
• Design & Develop solution to generate unique customer id using Oracle Enterprise Data Quality
• Design & Developed EDQ jobs for address standardization using LOQATE
• Design ETL using sqoop to ingest data in hadoop on AWS
• Provide estimates for development
• Communicate project status and provide timely escalation of issues, deviations to requirements
• Provide guidance to development team during the build
• Data Modeling, Dimension Modeling, Database Designing.
• Assign & review work of offshore team

Confidential

Lead Data Quality Solution Design Architect

PlatForm: Informatica 9 Powercentre, Teradata, Informatica IDQ

Responsibilities:

• Lead Solution Design for data quality rules using Informatica IDQ (Developer and Analyst)
• Liaised with Business Analysts, QA Analysts & DBA throughout project lifecycle to ensure project requirements are met.
• Develop, execute and evaluate data quality test plans as well as the results and quality of the data as per business needs.
• Provide guidance for IDQ development team

Confidential

Architect( Data Management & ETL)

PlatForm: Informatica 9 Powercentre, Oracle 11G, Informatica IDQ, Power exchange

Responsibilities:

• Solution design for DWBI.
• Develop, execute and evaluate data quality test plans as well as the results and quality of the data assuring compliance with business expectations.
• Perform systems and data analysis to Develop ETL design.
• Develop technical specifications for data acquisition, transformation, and load processes from a variety of sources
• Analyze performance bottlenecks and provide solution for performance improvements
• Provide effort estimates for new projects and initiatives
• Present Senior Management Technical solution options in key projects.
• Represent the Project team in Quality Assurance meetings.
• Involved in Data Discovery phase of key projects.
• Liaised with Business Analysts, QA Analysts & DBA throughout project lifecycle to ensure project requirements are met.

Confidential

Role: Data Architect

PlatForm: Informatica 8.6 Powercentre, Oracle 10G, HP Quality Centre,Autosys, Erwin 7.3.4,Power exchange

Responsibilities:

• Analyzing Reporting requirements for Employee Compliance data mart
• Source system Analysis
• Prepare Source to Target mapping
• Design Logical & Physical Data model for staging, ODS & data mart

Confidential

ETL Solution Architect

PlatForm: Informatica 9 Powercentre, Oracle 10G, HP Quality Centre,Autosys, IDQ

Responsibilities:

• Analyzing Business requirements for data integration
• Solution Design for integrating data from desperate sources.
• Design & Implement Customer Contact Data Quality validation using Informatica Data Quality
• Prepare Detailed Design documents
• Present Solution design to Confidential Solution design team for approval.
• Design Data model for staging, ODS & data mart
• Liaised with business teams to ensure project success.
• Provide estimates for development
• Communicate project status and provide timely escalation of issues, deviations to requirements
• Provide guidance to development team during the build
• Assign & review work of offshore team

Confidential

Technical Project Lead

PlatForm: Datastage 8.5, Oracle 10G, HP Quality Centre,Autosys

Responsibilities:

• Build credibility, establish rapport, and maintain communication with Project Manager to keep him updated on issues and risk factors through careful analysis to anticipated and manage change in the requirements
• Analyse and escalate issues & incidents and track those to the closure
• Interacting with Development, Configuration and QA team during execution
• Help Project Manager Create Dashboards for weekly and Monthly Status reporting to the Director
• Release planning with Project Manager, sign off and Management
• Review ETL design
• Review & Test ETL code developed in pl/sql
• Responsible for Quality and timeliness for all deliverables

Confidential

Technical Project Manager

PlatForm: DataStage 8.5,Oracle 10G, Clarity, Quality Centre, MS-Office,Cognos 8,Erwin 7

Responsibilities:

• Interacting with Development team in India for Status and Project meetings
• Utilized Quality Centre for requirement and defect tracking during a project SDLC
• Prepare logical Data Model and review with the Lead Data Architect
• Developed key mappings to Load data into Aggregate Fact Tables
• Develop ETL Design
• Review & Close ETL design with Solution Architect
• Estimate Development Effort
• Coach, mentor and lead personnel within a technical team environment.
• Responsible for the recruiting, management and career development of consulting staff.

Technical Project Manager

Confidential

PlatForm: DataStage 8.5, Oracle 10G, Clarity, Quality Centre, MS-Office,Cognos 8

Responsibilities:

• Report design review
• Review the team’s work on Analysis/Coding/ Testing and production rollout.
• Developed ETL design.
• Prepare logical Data Model and review with the Lead Data Architect
• Provide Estimate for ETL & Cognos Report Design.
• Track and improve team performance. Managing Vendors.
• Identify areas of improvement in the project processes & implementing the required actions.
• Meet project Quality objectives and ensure zero post implementation defects.
• Review & ensure closure of all SEPG project audit points.
• Responsible for hiring initiatives & defining of KRAs; to be used for direct reports reviews, appraisals and creation of development plans.

Confidential

Technical Lead/Lead Developer as part of the Falcon project for the client Datascan technologies USA

Platform: Informatica 6.2, Oracle 9i, Cognos 7.3, Autosys

Responsibilities:

• Requirement Analysis, Team Management, Coding, Code Reviews, Unit Testing other Project Document review
• Estimation using FP.
• Managing a team of 8-10 personnel.
• Interacting with client, on-site Confidential peers and QA teams.
• Reviewing the code and documentation.
• Developed ETL design Data Mart Layer
• Provide estimates for development.
• Tuning existing PL/SQL ETL programs to improve monthly ETL performance.
• Analyzed the functional specs provided by the business users and created technical specs documents for all the mappings and Design high level document to low level document.
• Involved in developing Informatica mappings based on documents that are developed during analysis.
• Created Mapplet and used them in different Mappings.
• Review ETL mappings