ETL Architect (Informatica)
I have over 17 years of experience in Solution designing and development of Business Intelligence Datawarehousing.
Currently working as an ETL architect and leading the Informatica ETL development and operations in EDW for a large hi-tech organization.
Delivered critical assignments in data warehousing involving solution design, data modeling, ETL design, and code development using Informatica PowerCenter,
Have worked successfully as an Informatica Solution Expert and set up the ETL architecture for a major Health insurance client in North America.
Insightful experience in Project Management activities: Project Roadmap, Project initiation, scooping, estimation, costing, planning, Risk Management, finalization of technical/ functional specifications, communication management, resource administration & optimization, and quality management of the product.
Led a team of 60 in capacity of project manager Successfully developed and implemented EDW for a major telecom client in UK which involved solution design, ETL development using Oracle Warehouse Builder, design of datamart, and development of dashboards and report using Oracle Business Intelligence.
Excellent communication skills with proven ability in driving numerous process improvements
Very rich experience in project/program management with results exceeding the company goals.
Hands-on experience in delivering innovation, product development, change management, quality improvement, regulatory compliance.
Recognized by peers and senior management for getting work done in record time while improving quality.
Specialties: Solution design, Data Analysis, ETL design and development, Demand creation, Business Consulting, Technology Consultation, Compliance and Validation. Developing innovative solutions for complex technical and business problems, Quality Management
Key Skill: Informatica PowerCenter, Informatica PowerExchange, OBIA, Microsoft SQL server, Oracle, PL/SQL, T-SQL, Unix, MySQL, Jira, TFS .
Education: Bachelor of Technology (Computer Science) from Institute of Engineering and Management, Kolkata, 2000
Certifications/Training: Oracle Certified in OBIA for ERP ( IZO-525) and OBIEE10g Foundation Essentials.
oTraining on Oracle Warehouse Builder ( OWB R2) and Oracle Business Intelligence
( OBI), Solution design program, Agile methodology
ETL architect and technical lead in Infosys Ltd : working in Advanced Micro Devices (AMD) from Jun 2013 till date at Austin, TX / Sunnyvale, CA
I am working as an ETL Architect and technical lead in the organization’s EDW and Informatica space.
My responsibilities include
oOverall delivery responsibility of all EDW projects and enhancements
oLead EDW operations - daily production support, EDW Data integrity, Informatica and database health check and improve performance
oCommunication with end users related to new projects/ enhancements request
oRequirement analysis on projects/enhancement
oETL design and development using informatica and SQL – views, procedures etc.
oSupport informatica administration
PREVIOUS EMPLOYMENT HISTORY – Tata Consultancy Services
Enterprise Solutions OBI Apps COE Lead for Tata Consultancy Services: Kolkata, India from Aril 2011 to Oct 2012
I worked as OBIA and Informatica consultant and solutions expert in Oracle Center of Excellence, enterprise Solutions,
My area of responsibilities includes:
oProvide consultation and delivery support to various business critical projects ran in Oracle BI Applications (OBIA) and Informatica set of tools (Informatica PowerCenter, Informatica Data quality) as a COE expert to ensure smooth project delivery.
oLead design and delivery of OBIA implementation projects.
oProduct analysis and create re-usable assets to be used by project teams
oTraining and development of new resources in OBIA.
oCreated competencies in various technologies for joint GTM and bidding proposals for customers
oArranged various workshops, demos with the customers in the field of OBIA space. This in later created high value opportunities for TCS.
oProvided unsolicited proposals and value propositions after understanding customer pains and driving these proposals for realization.
oLeading initiatives in new accounts acquisition.
Solution Architect at TATA Consultancy Services, worked at Humana INC., Louisville, USA from Jan 2009 to March 2011;
The project was a mandatory audit requirement from National Committee for Quality Assurance (NCQA) to measure health insurance Company’s yearly on important dimensions of care and service. HEDIS consists of 71 measures across 8 domains of care. The company needed to provide member, member enrollment, provider, and claims information for last years to a third party vendor in the form of extract to generate the measures on yearly basis. The project was executed in Informatica PowerCenter 8.6.1.
Solution Architect for the major compliance project
oHigh Level Design
Responsible for setting up informatica infrastructure for the client
oSupport on setting up the Informatica development, test and production environment for the customer.
oSupport and consultation on setting up Informatica Repository, Integration Service, Folder structures
oDeployment and code migration strategy from Informatica development,test and production
oSetting up the Informatica Data Quality and Informatica Data Explorer tool for the business analyst team of the customer and provided support and consultation for the data quality strategy using IDE and IDQ.
oScheduling strategy for Informatica projects: Modified the existing homegrown scheduling tool to run the Informatica workflows.
oConsultation on naming convention on Informatica objects, shared TCS best practices on the same.
oInformatica mapping performance tuning
Solution Architect and Project Lead at TATA Consultancy Services, worked at Ethicon Endo Surgery (A Johnson & Johnson Company), Cincinnati, USA from Oct 2008 to Dec 2008. The project was envisioned as a 360 view for provider Information. The project was in analysis and design phase and was developed in Informatica PowerCenter 8.6.1
oResponsible for end to end delivery of the project including design, development, system testing and user acceptance testing.
oHigh Level Design
oCode Review and Deliver.
Project Manager, TATA Consultancy Services Kolkata, worked for client British Telecom from June 2007 to October 2008, Kolkata and Development lead from Feb 2006 to June 2007,.
The goal of the project was to create an EDW for a major business line of the customer performing the task of the central data store and Information repository, holding both granular and aggregated data together with measures and business metrics.
The project was executed using agile methodology with iterative deliveries in each quarter. Oracle Warehouse Builder (OWB) is used as the ETL tool for the EDW with PL/SQL on HP UNIX environment. The MIS reports are based on Oracle Business Intelligence (OBI) tool.
oResponsible for end to end delivery of the offshore project including design, development, system testing and user acceptance testing.
oResponsible for costing, budgeting, resource planning, quality, timely completion, contract management, billing, project health check, profitability, closure, issue resolution and escalation etc for the project.
oResponsible for technical architecture, solution design, and code review for the delivery.
Development Lead at TATA Consultancy Services for Qwest (now CenturyLink) at Denver CO USA from October 2004 to January 2006.
oResponsible for development and enhancement of PANS (Performance Analysis System) datawarehouse (including ETL design and deployment in production) that provides a single source of network operational data supporting multiple means of easy access to enable and support External Reporting and Internal Continuous Improvements.
oThe ETL is built on PL/SQL with batch feed sent to different destination systems.
Development lead at TATA Consultancy Services for United Utilities, Manchester, UK from Oct 2003 to September 2004.
Implementation of primavera project planning ( P3e) suite of products for better and effective project planning and monitoring of different projects in the program level for the company. This also included template creation for different projects, budget planning, resource planning, timesheet entry etc. Modules used were: Project Manager, Methodology Manager, Portfolio Analyst, Primavision, Progress Reporter and Cost Manager. Role included:
oRequirement collection to capture the AS-IS process, mapping of requirements with Primavera functionalities, design of TO-BE processes, joint application development session with the business users.
oResponsible for requirement collection, design of report lay-outs, development of reports using BusinessObjects, delivery of report module.
oMapping of functionalities of Primavera suite of products with the requirement to gather the requirement and design the custom module.
Developer for Ex-Reengineering project at Tata Consultancy Services, Kolkata from October 2000 to October 2003. EX-Reengineering is a product Re-Engineering project .in this project EX PIM and EX Smart Accounting financial products were developed. It is a Re-Engineering project from the older system using Developer 2000 and oracle database to client server technology using Visual Basic, Visual C++, and Microsoft SQL Server. Roles included:
oProduct development of EX-PIM end to end with responsibility of design, development, support in user acceptance test.
oDatabase design, design and development of user interfaces using Microsoft visual Basic, writing business knowledge in Visual C++ and back end stored procedure.
oLeading the team for custom modules as per user requirement, creation of independent re-usable user modules ( ex. accounting, budget) using activeX which can be integrated in other application to achieve the required functionalities with responsibility of requirement understanding, design code development and overall delivery leading a team of 5 .