Amudha Mukherjee

Email:acwu79@r.postjobfree.com

Address: Alpharetta, GA 30005

Experience Summary

Over 16 years’ of industry experience in complete IT Life cycle covering, software analysis, requirements gathering, design, development, testing& debugging, implementation, post implementation production / maintenance support.

Experienced and Expertise in End to End Data ware housing and Data Migration project implementation covering ETL, Data Warehousing and OLAP.

Expertise in wide range of Databases, DWH, ETL and OLAP Business Intelligence tools.

Work experience in Retail, Banking, and Telecommunication& Transportation (Airlines) Industries.

Global Working experience – primarily in USA, UK & Europe and maintained good working/professional relationships with Industry majors such as Best Buy, Technauts, British Airways, United Utilities, Somerfield Stores Ltd, The Co-operative Group and Postbank

Skill Highlights

ETL : Informatica 5.0, 6.2, 7.1&8, Oracle Warehouse Builder 9 & 10.2, AscentialDataStage 7.5.1.A

OLAP : Business Objects 6.X & XiR2, Oracle Discoverer Plus 9 & 10.2

Exposure : BO Performance Management, Maestro scheduler, Erwin 3.5.2

Training on : Ab Initio, Microsoft Analysis Services and Microsoft Reporting Services

Operating Systems : Solaris UNIX, SCO UNIX, SunOS, Redhat Linux 6.1 & 6.2, Windows NT, 95, 98 & 2000, XP

Database : Oracle 8i, 9, 10g, Teradata V12.0

Languages : C, Pro*C, PL/SQL, SQLPLUS, HTML, Shell Scripts, Java, SQLJ, Pearl and COBOL

Domains : Retail, Banking, Transportation, Utility, Telecommunication, Risk Management

Achievements/Awards

Executed and delivered 11 BIProjects successfully, managed 50+ ETL resources. Awarded “Most Valuable Player” from Bestbuy USA.

Created “Informatica Factory Model” for project execution by creating Informatica assets such as Standards, Templates, Checklist etc., which has been used by many projects of TCS

Appreciated by Somerfield Stores Ltd Customer for successful 5TB Data migration, by redesigning of 350+ Informatica5.0ETL components to Datastage 7.5.1

Trained 400+ TCS associates in DWH concepts, Informatica 8, Oracle Warehouse Builder 10 and Business Objects 6.0 tools in an quarter.

Migrated 8 year old Risk Management tool of 800+ PL/SQL programs to Oracle Warehouse builder 10g ETL components within 6 months

Education

Bachelor of Engineering from National Institute of Technology, (NIT) Trichy, India

Experience Summary from Wipro Technologies

Client: CITI Group – AML E2E Recon Project, Chennai India Aug 2014 – Aug 2015

Role: BI Architect

Project:

Citi has a regulatory mandate to reconcile the data that is being monitored for AML through implementation of various controls. A Global End to End (E2E) Anti Money Laundering (AML) Transaction Reconcile Program has been initiated to comply with the mandate and to provide additional confidence in the completeness of data being monitored for AML.

Responsibilities

Analysis, Preparation of FRD, Development and Testing of ETL code, Deploying in the different environments as per the specifications.

Delivery of investigation files in the respective portals in order to facilitate the CITI customers in reconciliation.

Software:TALEND Integration Suite Enterprise Data Quality 4.1.3, Oracle 11g, ICG Recon Quick Rec (V13)

Experience Summary from TATA Consultancy Services Ltd.,

Client: Retail Projects across TCS - TEG (Technology Excellence Group), Kolkata, India Feb 2012 – Sep 2012

Role: Solution Architect

Served as a solution Architect for TEG-Technology Excellence Group responsible for defining technology architecture and framework for BI delivery.

Prepared technical RFP and proposal for Sainsbury Ltd-UK, Bestbuy-Canada, PETCO, Phones4U-UK

Responsible for providing hands on support to BI delivery teams for Solution, Technical and Data Architectures including platform selection, data modelling and ETL design.

Responsible forEstimation, Tool selection for both ETL and OLAP technologies for the solution.

Shared Implementation Methodology for Sainsbury team

Trained TCS associates on Informatica 9 and shared technical solution

Challenges faced& Solutions given:

Sainsbury’s UK, had space constraint for multiple TB of history data loading. I have created an implementation methodology for parallel export and import process, hence only minimal space used for bulk history data loading.

For Bestbuy – Canada proposal as part of solution recommended Informatica CDC methodology for real-time data warehousing.

Client:The Co-operative Group: Manchester- United Kingdom - Kronos Dec 2009 – Nov 2010

Role: Informatica 8 ETL Architect, Business Objects XiR2 Technical architect and Onsite delivery manager

Served as anETL Architect for The Co-operative Group client and designed and implemented data integration and data warehousing solution.

Re-engineering of 100+ Datastage ETL components to Informatica 8.0 components

Provided Data warehouse ETL Architecture, data model, prepared high level technical specifications, test specifications.

Performed performance testing and defined Implementation methodology.

Implemented successfully in the Client environment

Prepared Requirement documents based on the clients interactions and end users feedback for GSM (General Store Merchandising) report development project.

Leading BOXiR2 report team, created technical specification for BO Universe designing and reports, Use case for testing of reports in Teradata environment

Reviewed deliverables from offshore developers, provided technical solutions to the development team as and when required.

Coordinated with Client and Other support groups for the smooth execution of the project

Challenges faced & Solutions given:

Implementation of real-time Data into TCG environment was challenging. There was a space constraint also for the huge volume of daily data as the batch processes were running for longer duration. Implemented Informatica CDC for real-time loading without batch processing. And also before loading the History data to avoid the duplication, turned on CDC module.

Clients were not having the clear idea on the available data in the GSM environment. We studied the entire GSM environment with the SME from TCS team and created Universe and delivered the reports. This was taken care with their current as well as future requirements of the reports and much appreciated.

Software:Informatica 8, AscentialDatastage 7.5.1, Oracle 10g Database, HP Load Runner 9.10 & HP Quality Center

Client: Somerfield Stores Ltd:Bristol- United Kingdom–Oracle 10g Migration Feb 2008 – Nov 2009

Role: Datastage ETL Architect

Served as an ETL Architect for Somerfield Stores Ltd. Designed and implemented massive 5TB data integration solution.

Redesigned 350+ Informatica 5.0 ETL components to Datastage 7.5.1 components in Oracle 10g Environment

Provided new ETL Architecture, data model, prepared high level technical specifications based on the older Informatica components

Managed technically a team of 16 associates

Prepared and provided Checklist, Standards, and Templates for Datastage ETL Development.

Provided technical solutions to the team, reviewed the deliverables, coordinated with clients, different support groups, stake holders and the development team

Defined the implementation methodology for 250+ DatastageETL components in production environment using phasewiseimplementation.

Decommissioned the older environment without impacting the production environment

This was much appreciated projects for smooth implementation as well as the Best performance implementation

Challenges faced & Solutions given:

The Data warehouse system was receiving data from nearly 210 source systems and some of the source owner was a single user rather than a group. No documentations were available to understand the 350+ Informatica 5.0 ETL functions. Hence the technical specification was created based on the individual ETL components, categorised the components based on 22 subject areas and created enterprise Warehouse with multiple subject area datamarts

Somerfield production environment had 1500+ jobs running and implementing the newer jobs was one of the major challenges faced as well as the overnight jobs were running for more than 18 hours. Hence stores received the reports only around 2.00 pm in the afternoon.

I have redesigned the entire ETL architecture and removed unwanted components and to increase performance redefined them. Due to this the overnight patch jobs completed within 8 hours and the stores were receiving the reports before the stores opens for functioning.

Implemented the ETL batch jobs in phase wise rather than BIG BANG approach suggested by client. But phase wise implementation helped the client for smooth transition without affecting the day-to-day business. As the implementation was broken into small phases, all the initial issues were rectified easily and effectively.

Software: AscentialDatastage 7.5.1, Oracle 10g Database

Client: TCS- Chennai: Risk Management – ALM Tool Reengineering Aug 2006 – Mar 2007

Role: ETL Architect and Project Manager

Served as an Architect for Reengineering of Assets Liability Tool a TCS product. This tool was developed over a span of 8 years with PL/SQL scripts for ETL and Oracle Express for Reporting in Oracle 8i environment. This was reengineered in Oracle Warehouse builder 10g for ETL and Oracle Discovered plus 10.2 for OLAP reports under Oracle 10g environment.

Analysed the existing tool, designed and created Technical Specification document for the entire tool. Prepared high level design document for both ETL and OLAP reports.

Reviewed ETL and OLAP Reports low level Technical Specifications, Reengineering Functional Specification, Unit Test specifications, Unit Test Results and Integration Test Results

Coordinated Risk management Team, ETL and reporting development teams. Provided technical solutions to teams whenever issues raised

Delivered 8 years old Tool in a span of 6 months using Oracle development tool based package with very high performance.

Challenges faced & Solutions given:

The development team of 12 fresher’s from College who were not trained in any technical background. No Documentation for the ALM tool functionality was present as it was developed by many developers in different point of time over a period of 8 years.

Hence I have trained entire 12 team members in Data Warehousing concepts, PL/SQL, Oracle Database, Oracle Warehouse Builder 10.2 and Oracle Discovered plus 10.2.

Executed 800+ Pl/SQL scripts into just 28 OWB modules and delivered the entire package in SIX months duration. This tool based ALM was much appreciated by the Risk Management Practice TCS.

In turn TCS won many new customers for this tool.

Software: Oracle Warehouse Builder10.2, Oracle Discoverer Plus10.1.2, Analytical Workspace Manager10.2, Oracle10g

Client: British Airways- CTD (Customer Transaction Data Warehouse)Plumbing, India Aug2005 – Dec 2005

Role: Informatica 6.0 ETL Technical Manager

Served as Informatica Technical Manager for British Airways Integration Project. This project work involves integration of corporate data from CTD systems to ICW (Integrated Commercial Warehouse).

Responsibility involves Analysis of CTD and ICW data warehouse corporate data, Design and development of Informatica 6.0 mappings in Oracle 9 environments.

Review of the ETL mappings, Test results and specification deliverables.

Coordination with Onsite and offshore teams for delivery and implementation in production environment within the schedule and quality

Software: Informatica 6.0, PL/SQL and Oracle 9

Client: British Airways - GDS Bills Validation&Bestbuy M/F Elimination, UK- London & India Jun2004–Jul2005

Role: Informatica 6.0 and Business Objects Reporting Technical Manager

Served as Business Objects reporting Technical Manager for British Airways Global Distribution Systems Integration Project. The project work involves generation of Business Objects reports on Volume of Booking of chargeable segment status codes for Nine GDS, such as Abacus, Ameadus, Apollo, Galileo, Infini, Sabre, Worldspan, Axess and Topas from ICW WOMBAT system (Integrated Commercial Warehouse) which is in TERADATA Database

Responsibility involves Analysis of Nine GDS systems, Design and development of Business Objects Reports in Oracle 9 environments.

Also responsible for ETL designing and development using Informatica 6.0 for Mainframe elimination project for Bestbuy Client

Review of the InformaticaETL mappings, BO Reports, Test results and specification deliverables.

Coordination with Onsite and offshore teams for delivery and implementation in production environment within the schedule and quality

Software: Business Objects, BTEQ, Teradata, Informatica 6.0, Pro*C, K-Shell, Oracle

Client: United Utilities – Prescot, United Kingdom. Project: Water Billing System Data Migration Jun2003 – May 2004

Role: Informatica 6.0 ETL Testing Head

Served as an Informatica ETL Testing team head for a team of 6 for United Utilities water billing System projects. The new water billing system was developed by integrating 10 disparate systems. The development team was managed by clients and the testing part was taken by my team,

Responsibility involves Defining, Creating and Managing Test Data Configuring for different Testing

Created Test specification for the entire testing cycles such as system, integration, stress and performance related tests. Created Test data also for the same.

The testing environment was created and the tests were carried out for Informatica 6.0 ETL mappings.

The tested informatica mappings were implemented successfully in the production environment.

Also involved in Development of Informatica Mappings during the absence of few ETL developers.

Software: Informatica 6.0, PL/SQL& K-Shell scripts in SUN Solaris Operating System

Client: TATA Teleservices –Project:TTL Data Warehouse building Jan 2003 – May 2003

Role: Oracle Warehouse Builder (OWB 9) ETL Developer

Responsibility involves Analysis of like Revenue, Usage Pattern, and Effectiveness of the introduced schemes in the TTL telecommunication channels.

Based on the analysis varies reports needs to generated for different levels of management for analysis

Designed and developed OWB mappings in Oracle environment taking data from different channels of communications in TTL to create TTL DWH systems.

Developer 2000 tool was used to create static reports from the OWB DWH environments.

Successfully implemented the DWH systems and created reports for analysis by managements.

Software: Oracle Warehouse Builder9, Developer 2000

Client: Bestbuy - Data Warehousing BI CoE, Minneapolis, USA & India Sep 2001 – Dec 2002

Role: Informatica 5.0 ETL Developer and Technical Lead

Served as Informatica ETL developer and then Technical Lead for team of 55 executing 11 BI projects simultaneously.

In Bestbuy there were three major systems viz., RBPM (Retail Business Process Management Project), MLG (Music Land Group), and MLG score Card which Encompasses Data Warehouse. The entire project work involved, extraction of source data from different systems and load them in to these three main systems.

Responsibility involves Analysis of different source systems, designing and development of Informatica ETL mappings for loading the data in the DWH environments

Testing and implementing them in the production environments successfully.

Managed 11 BI projects and prepared Technical specifications for all the ETL mappings, checklists, standards and shared to the development team

Reviewed the deliverables such as ETL mappings, Test specification and results from the team of 55.

Coordination with Onsite and offshore teams for delivery and implementation in production environment within the schedule and quality

Challenges faced & Solutions given:

During 2001 there was not a single Informatica resource in TCS –Chennai centre. Hence self-learned the tool executed the project successfully. Hence TCS has been awarded with 11 BI projects immediately.

Trained 55+ TCS Associates in Informatica 5.0 executed and delivered 11 BI Projects successfully managed 55+ ETL resources. Awarded “Most Valuable Player” from Bestbuy USA.

Created Quality assets such as Informatica Standards, Checklist and Templates and helped the team to execute the project like “Informatica Factory” model.

Published the assets in TCS Intranet and helped the other projects to benefit from the same.

Software: Informatica5.0, Pro*C& K-Shell scripts, Oracle

Client:Bestbuy - Project:Launchpad–Phase 3 Reports, Minneapolis, USA & India Jul 2001 – Sep 2001

Role:Project Leader

Served as a project leader for Retek Launchpad reports from Mainframe environment to Oracle environment, this project was executed using Developer 2000 and Oracle Reports 6i.

Responsibility involves requirement collection, technical specification document preparation based on the functional requirements and data mapping

Development / Generation of Reports using Reports 6I

Preparation of Shell scripts and SQL scripts based on the requirement

Review of low level technical Specification documents, Shell scripts and SQL scripts. Testing of Oracle reports

Organizing weekly status meetings both with Clients and Internal TCS meeting

Preparation of Process documents for Development of Reports

Communicating with Clients, about the project status, issues and concerns and taking necessary actions in the project for smooth delivery

Software: Developer 2000, Oracle Reports 6i, Shell Scripts, PL/SQL, Shell scripts, Oracle

Client:Postbank -Project:Interparts Banking Project, Netherlands, Europe Jan 2001 – Jul 2001

Role:Module Leader

Served as module leader for a development of an automation tool for PostBank officers to collect debt from the defaulters through judicial procedure

Responsibility involves requirement collection, technical specification document preparation based on the functional requirements and client feedback

Visual Basic 6.0 was used for automation tool using DB2 database with MQSeries as Middleware.

Preparation of Requirement documents, high level and low level design documents, quality documents such as standards, checklist and templates for development team

Testing of the tool in production like environment and implementation of the product in client environment

Software: Visual Basic, DB2 &MQseries

Client:Technauts - Project:IMAP for eServer tool, North Carolina, USA May 2000 – Dec 2000

Role: Module Leader& Programmer

Served as module leader and developer for IMAP protocol for eServer product for Technauts client

Responsibility involves Design and development of Internet Message Access Protocol to introduce Mail access facility using IMAP (Internet Message Access Protocol) with the existing eServer package in RedHat Linux O/S with Postgresql database

Tools developed to Test Different Protocols (POP, IMAP, etc) using RFC 2060 standards

Creation of HTML documents of eServer sources using DOXYGEN package

Preparation of Test cases & Test data for testing eServer modules such as Web Server, Mail server, Fail over-Redundancy & Networking.

Software: RedhatLinux 6.1 using C and Postgresql Database

Client: All Indian Banks - Project: TCS- Internet Banking System (IBS) Jun 1999 – Apr 2000

Role:Programmer

Programmer for development Online Transactions module and Data Transfer Module for backend processes of IBS used to update the day end batchprograms which update the database daily automatically.

Responsibility involves Design, development, testing of Data Transfer module using Pro*C and shell scripts using Oracle backend.

Responsibility involves Design and development of Request Forwarding module for both online and offline mode.

Responsibility involves Design and development Administration modules using PL/SQL.

Tested and integrated the above mentioned modules to IBS tool and implemented successfully.

Software: Pro*C, PL/SQL, Shell Scripts, HTML and Java Scripts in Oracle 7.X database in Windows NT and Sun Solaris environment

Client: All Indian Banks Chennai, India Project: TCS Tool - FOREX – Foreign Exchange System Dec 1998 – Jun 1999

Role: Programmer& Analyst

Programmer for development of Foreign Exchange System to automate all transaction Related to Funds transfer, Pipeline, Cash letter and Deposits of using foreign Currency.

This automated tool development responsibility involves preparation of technical specification document, design, development and testing of Cash Letter Module and Pipeline Module modules under Remittance Category

Customization of Remittance Module based on Client’s requirements

Software: Pro*C, PL/SQL, Forms 3.0 in Oracle 7.X database in Windows NT and Sun Solaris environment

Client: All Indian Banks: Chennai, India Project: ISBS – Integrated Standard Banking System Apr 1998 – Dec 1998

Role: Programmer& Module Leader

Programmer and module leader for TCS Product ISBS (Integrated Standard Banking System) used to automate all banking transactions starting from Opening, Different Accounts like Savings, Current, CCOD, Deposits, Loans, Fixed Deposits and Flexi Deposits.

Responsibility includes Installation of ISBS Package, Maintenance, Client support, bug fixing, and Fixing Change request to different branches of the banks in Chennai. Nearly 150 branches were supported

Installation of ISBS package to new branches and installation of add on modules to different branches in Chennai.

HELPDESK - Client Support over phone using HELPDESK software and supported more than 150 bank branches.

Fixing change request raised by client of different branches of banks

Preparation of monthly report for both ISBS head and Resident Managerof TCS

Software: Pro*C, PL/SQL, Forms 3.0 in Oracle 7.X database in Windows NT and Sun Solaris environment

Client: Industrial Quality Concepts Chennai, India. Project:ANDT testing tool automation & CMS Jun1997–Dec 1997

Role: Programmer

Programmer for development of testing tool for ANDT2001 - Windows based Non-destructive testing PC System developed by of M/S.Andrew NDT make California, USA. For material structural study.

Responsibility includes Design, configuration, and development of testing tool for ANDT 2001 tool as per the different client requirements. Hence the tool was parameterised the input based on the different requirements and generated reports and graphs for material study and analysis.

Also designed, developed and implemented Client management systems (CMS) using Developer 2000 for IQC Company. Which helped the management for better communications, contact details of different customers, details of various metallurgical testing carried out for each vendors, invoice preparation, new work request, billing details etc.

Software: Developer 2000, Oracle 7.x, Forms4.5

Client:Indian Institute of TechnologyChennai Project:ComputationalModel of Solidification Process Dec1996–May 1997

Role: Programmer

Programmer for development of a computational Model of Solidification Process for Titanium metals in welding using Numerical Technique

Responsibility includes Analysis, Design, and development of module which takes care of finite element analysis of the problem by taking the data from an input file which contains parameters of various materials and provides results in numeric data as well as a graphical output for Titanium Welding and surface Treatment.

Software: C in MS-DOS

Client: Indian Institute of Technology Chennai Project: ComputationalModel of Heat Transfer Jun 1996 – Nov 1996

Role: Programmer

Programmer for development of a computational Model of Heat transfer on different metals during different heat treatments

Responsibility includes Analysis, Design, and development of module which used to measure the metal resistance quantitatively with various heat treatment test data and in evaluation of mechanical driving force using Heat transfer and mechanical computational Models

Software: C, shell scripts in UNIX environment

Contact this candidate