Qualification Summary

ETL Program Manager, Data Architect, ETL expert and architect with 17 years of rich experience in Business Intelligence area. Certified Project Management Professional (PMP ®). Proficient in Dimensional modelling and expertise with Star schema and snowflake schema.

Proficiency in Delivery management, Project Management and Program Management. Successfully led various BI Projects. An avid team player with proven track-record for qualitative and on-schedule deliverables, dedication and skills to meet business requirements and visions, and a proven capability to direct, motivate and mentor team members and peers.

Highly experienced in successfully managing simultaneous and complex projects and laying out roadmaps for operational processes and support. Possess significant analytical and problem solving skills. Implemented various innovative and creative solutions provided by available technology, in different projects.

Possess in-depth knowledge and experience in architecting ETLs supporting complex data acquisition and delivery requirements. A very versatile technical professional providing expertise in managing and implementing data delivery solutions.

Possess proven ability in building and managing successful and strong working relationships with all levels of team as well as client relationships. Has an outstanding written, verbal and presentation skills.

Core Competencies

Work Experience

17 years in IT Industry

Functional Experience

Program Management, Project Management, Delivery Management, Data Architect, ETL Architect and expert, Project planning, knowledge of Database Administration

Primary Domain

Asset Management, Finance and Investments, Equities, Fixed Income

Technical Experience

Operating Systems

Windows, Unix, Solaris

Database

Oracle 7i-11g and Exadata

Programming Language

PL/SQL, C, C++, COBOL, Unix Shell Scripting (Basic)

Tools and Packages

Informatica PowerCenter, Informatica Metadata Manager, Informatica Data Services, Business Objects & Web Intelligence, TIBCO Spotfire, Cognos suite of Products

Career Roles and Responsibilities:

BI Program Management

Team management

Task Allocation and Tracking

Customer Relationship Management

Project Management, Project Estimation, Project Planning, Delivery Management, Project effort Analysis and Costing

Facilitate interactions with Customer, business users and IT

Risk Management and Mitigation planning

Status Reporting

Assist Client in Technology evaluation and/or prescribing new solutions

Design and Architecting Implementation

Business Analysis

Data Model and Design, Architect ETL Design

Career Profile

Employment: May 2016 to Present- Solomon Page Group, LLP.

Position

Data Integration Architect

Client

Tractor Supply Company

Project Title

CRM – DW Integration

Project Location

Brentwood, TN

Period

May 2016 – Present

Project The project involves integration of various data feeds in and out of CRM. The company is instituting a CRM system to better centralize and standardize customer-centric data and phase out legacy applications. My role as a Data Integration architect is to ensure new interfaces are devised according to standards as followed by Tractor Supply Company and design, develop and implement ETL interfaces in and out of CRM.

Technology Used Netezza, Talend

Employment: May 2015 to Apr 2016- Deloitte Consulting LLP.

Position

Manager/ETL and Data Architect

Client

An international Bank

Project Title

Merger and Acquisition

Project Location

Sao Paulo, Brazil (Remote)

Period

Jan 2016 – Present

Project The project involved the strategizing the acquisition of operations of the bank based in Sao Paulo, by another bank. The role also involved facilitating the gathering of requirements and managing the transfer of data as stipulated in regulatory and security standards. Used Tableau for reporting on project metrics and managing the project deliverables.

Technology Used Microsoft Suite of Products, Tableau

Position

Manager / ETL and Data Architect

Client

A major Mortgage Insurance Company

Project Title

Platform Migration

Project Location

Greensboro, NC

Period

Oct 2015 – Nov 2015

Project The project involved the preparation of strategies for migration of legacy systems residing in Mainframes to Oracle Database and the deployment of BPM system and datawarehouse for Business Intelligence reporting. The role required facilitation of gathering of requirements and preparing strategies for the project mobilization. The role also required provisioning project estimations and reporting out on project metrics using Tableau as the standard tool.

Technology Used Microsoft Suite of Products, Tableau

Position

Manager / Data Architect

Client

A major ASSET MANAGEMENT Company

Project Title

Enterprise Data Services

Project Location

Chicago, IL

Period

May 2015 – Sep 2015

Project The project involved the creation of an Enterprise Service Data Services domain that would provision a standardized, consistent, reliable data via a decoupled interface across systems with optimal performance. This needs assimilation of data elements from multiple source systems, domains, dimensional entities and standardizing them. The role required scoping the project by facilitating requirement gathering and provisioning them to the implementing teams. Prepared work-stream plans and pointers to enable team for the preparation of requirement specifications. Status reports are dynamically reported using Tableau as the standard tool.

Technology Used Microsoft Suite of Products, Tableau

Employment: Dec 2002 to Apr 2015- Tata Consultancy Services Ltd.

Position

TCS Project Manager/ Data and ETL Architect

Client

GE Global Operations

Project Title

Business Intelligence (BI) Program

Project Location

CT, USA

Period

Sep 2014 – Apr 2015

Project The BI program was part of the overall decision support program for GE’s organization for Global Operations. The project involved the maintenance and enhancement of two datawarehouses viz. Commercial Datawarehouse (CDW) which housed GE’s overall sales components, their status and trend categorized under different dimensions, and the Accounts Payable Datawarehouse (APDWH) which housed the purchasing and invoicing data for reporting. I managed a team comprising of ETL developers, data architects and support and operational personnel to help the upkeep of the datawarehouses.

Technology Used Microsoft Project Plan, Microsoft Visio, Microsoft Suite of Products, Informatica Power Center, Oracle 11g.

Position

TCS Program Manager/ Data and ETL Architect

Client

A major ASSET MANAGEMENT Company

Project/Program Title

Business Intelligence Program

Project Location

CT, USA

Period

Jun 2010 – Aug 2014

Program Background The Business Intelligence (BI) program includes various projects aligned together to facilitate enhancement requirements and advanced reporting capabilities. The program caters to the successful running and day to day operational assistance for the client’s business processes in addition to the execution of high volume Projects and/or low volume discretionary tasks.

My role involved overseeing and implementing the BI program including the management of a set of teams that catered to the maintenance, support and enhancement of the BI capability as well as provided expert ideas and guidance for technical implementation. The teams comprised of experts from each technical and functional arena that assisted in

Procurement and Transformation of data – Using Informatica as the ETL tool

Master Data Management – Using Golden Source as the MDM tool

Data Reporting – Using Business Objects and Tibco Spotfire.

RTS Support and maintenance

Activities being carried out were

Discussions for requirements gathering

Coordinate analysis and evaluation of alternative design and impact on prevalent system

Coordinate discussions with Data Governance council to confirm and document data configurations.

Program management

BI Support, maintenance and enhancements

Identify client’s goals and provide roadmap for solutions

Projects carried out under the BI program

Project Name

Project Description

Enterprise Portfolio Management System (EPS)

Enterprise Portfolio Management system project involved consolidation of the technical, application and system landscape in line with client’s objective of simplification. Managed a large team of ETL, BO, Spotfire, Golden Source Developers, Project leads. As a project manager, performed project management activities. Planned, Architected, designed and developed new technical solutions. Controlled the overall project direction, progress and plans. Provided radically new way of processing highly normalized and heavy XML feeds using Oracle’s XML Query features.

Global Performance and Analytics (Phase I and II)

The project involved changes to the investment performance calculation engine. Performed project management, led a team of ETL/BO developers and team leads. Performed Architecture of ETL and DB, data analysis, designing and collaborating with client and vendor stakeholders. Provided creative ideas to enhance the performance and better the existing ETLs to increase the standards of Data Quality and accuracy.

Client Web Portal Redesign

The web portal redesign project required facilitation of client reports over the web for a direct interfacing with the customers. Managed the project, led a team of ETL/SQL developers, designed, architected, developed and performed tuning of the interfaces. Involved in the design and management of implementation of additional security feature provided by Oracle’s Virtual Private Database (VPD)

Re-platforming Datawarehouse to EXADATA

The project involved moving the Datawarehouse from a traditional Oracle RDBMS to an Exadata platform. Performed planning, designing, and Proof of Concept of Exadata implementation. Redesigned and tuned the performance of ETLs and SQLs. This project saw almost every interface being analyzed and identified, viz. the BO reports, dashboards and ETL interfaces that had to be migrated to conform to use Exadata features and/or mitigate Query Plan failures (EXPLAIN PLAN).

TIBCO Spotfire Implementation for Data Visualization enhancements

The project involved enterprise-wide implementation of Spotfire as a reporting tool to provide more dynamism to reporting and user interfaces. I was involved in managing the team of Spotfire Developers for the implementation of this project. Provided technical support and ideas to structure queries and provide tuning approaches for faster data retrieval.

Cash Flows

The project required modelling of Datawarehouse tables and design and develop ETLs to procure, transform and load the data pertaining to cash flow information. Managed the project, leading a team of ETL/BO developers, perform data analysis, design and architecting the ETL interfaces.

RTS Support for ETL, BO, and Golden Source

RTS is an operational process with a primary responsibility to support, maintain, control and reconcile different production processes. I oversaw teams that support the three main technology areas/domains that form the baseline for client’s data repository.

MDM Tool (Golden Source Upgrade)

Oversaw the upgrading of the Tool. Strategized the migration, testing and sign off criteria for the upgrade and team sizing.

Oracle Database Upgrade to 11g

Oversaw the upgrading the Database. Strategized the testing criteria, testing procedures and success criteria for the migration.

Informatica Power Center Upgrade from 8.6 to 9.1

Oversaw the upgrading the ETL Tool. Strategized the testing criteria, testing procedures and success criteria for the migration.

Business Objects Upgrade to Version 3.1

Oversaw the upgrading the reporting interface Business Objects. Strategized the testing criteria, testing procedures and success criteria for the migration. Also tracked the user feedback and experience with the upgrade testing.

Consolidation of Business Objects Universes

With a focus towards Simplification, this project catered to the consolidation and reduction of overall Business Objects universes to < 50%. Project involved re-designing the universes and re-writing the reports. I was involved in overseeing the project and also collaborating with the BO team to prescribe efficient design, join conditions and grain of data

BI ETL Process Re-architecture

I proposed this project to the client for initiation to re-architect the ETL processes to simplify and most importantly bring the load cycle intervals to an acceptable and consistent range. I drew up design considerations and the phases in which each targeted area shall be addressed. The whole project involved performance tuning of ETLs, SQLs, leverage advanced features provided by Oracle and Informatica in the load processes. Close to 80% of ETLs were re-written and a successful reduction of load cycle by ~70% was achieved.

Enhancement to Master Data Management (Golden Source)

Managed the successful implementation of various Data and Data model enhancements needed by Business.

Proof of Concept and Evaluation of Data Services

There are many consumers of data from the Datawarehouse and a need was felt to provide the interface as a service. The objective of this project was to select a tool that would provide a standardized and decoupled interface, ease of data delivery, complexity in configuration, administration requirements and customizable features. The project involved evaluation of products like Informatica Data services and Composite. I was involved in the evaluation of the product and noting and providing feedback to the customer.

Other Discretionary Projects

Low scale Datawarehouse enhancements for data enrichment and feature enhancement tasks are captured under this bucket. I successfully managed various simultaneous short-term discretionary projects. Most projects are initiated to achieve client’s goal of Simplification and Data requirement.

Technology Used Microsoft Project Plan, Microsoft Visio, Microsoft suite of Products, Informatica Power Center, Business Objects, Oracle Exadata, Spotfire, TOAD, Embarcadero DBArtisan, PL/SQL

Position

TCS Project Manager/ Lead Data and ETL Architect

Client

A major ASSET MANAGEMENT company

Project Title

Single Security Master (Master Data Management)

Project Location

CT, USA

Period

Jan 2009 – May 2010

Project The Project was a first step towards the creation of a Master Data Management (MDM) architecture for the client Business. The project’s scope was to standardize data, enhance quality control, enhanced data governance and configurations. My role involved managing the project implementation alongwith designing and developing routines for consolidation of all independent datamarts into a unified Datawarehouse, Logical Data Model changes, Conversion of historical data into the new Data Model, Dimensional changes, FACT ID correction etc. I also provided technical expertise in the use of Real-Time Data Feed from MDM to DWH via JMS messages, XML data processing and in also performing real time slowly changes of dimensions. Used dimensional modeling and Star schema / Snowflake concepts to design the target structure.

Technology Used Microsoft Project Plan, Microsoft Visio, Microsoft Suite of Products, Informatica Power Center, Real Time JMS message processing, TOAD, Embarcadero DBArtisan.

Position

TCS Project Manager/ Lead Data and ETL Architect

Client

A major ASSET MANAGEMENT company

Project Title

Business Intelligence RTS (Support and Maintenance)

Project Location

Tata Consultancy Services Ltd., Bangalore, India

Period

Nov 2007 – Dec 2008

Project This operational process involved the Maintenance and support of processes required for the daily functioning and data availability of Datawarehouse/Business Intelligence. Various reporting interfaces use the CDW data to assist the Portfolio managers in supporting investment strategies. The project involved maintenance of ETL components, Load tuning, SLA compliance and incorporation of timely enhancements required to support additional features requested by Business Users.

I was involved in the management of day to day operations, tracking tickets to closure, implementation of discretionary enhancement tasks and Load cycle tuning either via SQL tuning or ETL tuning.

Technology Used Microsoft Project Plan, Microsoft Visio, Microsoft suite of Products, Informatica Power center, Oracle.

Position

TCS Project Manager/ Lead Data and ETL Architect

Client

A major ASSET MANAGEMENT company

Project Title

Performance and Analytics (PANDA)

Project Location

CT, USA

Period

Jul 2005 – Oct 2007

Project This project involved the Re-Design, development and maintenance of Central Datawarehouse to incorporate the changes in the source and the computing methodology of client’s Investment performance and attribution. Various Digital Cockpits in the enterprise use this Central Data warehouse to highlight the performance and analytics involved, to the Portfolio Managers to support their decision making and investment strategies.

Technology Used Microsoft Project Plan, Microsoft Visio, Microsoft suite of Products, Informatica Power Center, Oracle, TOAD, Embarcadero DBArtisan

Position

TCS Project Manager/ Data Architect

Client

A major ASSET MANAGEMENT company

Project Title

Finance Total Returns (Visions)

Project Location

CT, USA

Period

Dec 2003 – Jun 2005

Project This project involved the Design, development and maintenance of the Total Returns Datamart. Various Digital Cockpits in the enterprise used this Datamart to track Investment Performance and assess risks. I designed, developed and also managed a team of developers and leads who were tasked with the implementation of

-Computation of Day over day performance of investments across a range of periods (for funds categorized as Equity, Fixed Income, Mutual Funds, Balanced funds etc.)

-Computation of Attributions by comparing GEAM’s investment against Market Index performance (e.g. MSCI, S&P, Rusell Mellon, TSE, Topix, DJAIG, Barclays etc.)

-Computation of Risk metrics (very complex calculations) to determine the risks associated to an investment

-Various other kinds of complex metrics calculation which enrich decision making at GEAM.

Technology Used Microsoft Project Plan, Microsoft Visio, Microsoft Suite of Products, Informatica, Oracle, TOAD, Embarcader DBArtisan

Position

TCS Project Leader/ ETL and Data Architect

Client

A major ASSET MANAGEMENT Company

Project Title

Insurance Datamart (IDM / IDW)

Project Location

Tata Consultancy Services, Mumbai, India

Period

Apr 2003 – Nov 2003

Project This project involved the Design, development and maintenance of Insurance Datamart. Digital Cockpits pertaining to investment in Insurance business use this data for Day- to-Day investment decisions. Data is retrieved from various client’s businesses and consolidated into one single datamart for a single and standardized reporting destination.

Technology Used Microsoft Project Plan, Microsoft Visio, Microsoft Suite of Products, Informatica Power Center, Oracle

Position

TCS Project Leader/ ETL and Data Architect

Client

A major ASSET MANAGEMENT company

Project Title

Fixed Income (CARRT)

Project Location

Tata Consultancy Services, Mumbai, India

Period

Dec 2002 – Mar 2003

Project This project involved the Design, development and maintenance of Datamart pertaining to the Fixed Income business of the client. Reporting of the Fixed Income business is based on the data consolidated in the Fixed Income Datamart (a.ka. CARRT). I managed and participated in the support/maintenance, design, development, enhancement and upkeep of this datamart.

Technology Used Microsoft Project Plan, Oracle 9i, Informatica 5.x/6.x

Employment: Sep 1998 – Dec 2002 - Tata Infotech Limited

Position

Module Leader – Project Co-ordinator

Client

Lafarge Philippines Inc., Manila, Philippines

Project Title

Financial Datawarehouse

Project Locations

Lafarge India Limited (Calcutta, WB, India & Mumbai, MH, India)

Period

Oct 2000 – Nov 2002

Project LAFARGE Inc. was the major in the Building and Construction Materials sector. They used J.D. Edwards, an ERP system, to maintain the financial accounts. They also have another tool over Oracle database, which oversees the Costing transactions of the company. The project involved creating a common Datawarehouse for all the source systems and then creating various Datamarts out of it, catering to various departmental needs.

I managed, designed, developed ETL interfaces to extract the ERP data and feed into Datawarehouse. Cognos came up with a tailored product called eApps for JD Edwards (which was a Beta product) and I performed the POC on that product. Based on my recommendations, findings and test results, the product matured and released as RTM 1.0. I also developed Cognos Cubes and Business Objects/Web Intelligence reports for data visualization out of the Datawarehouse.

Technology Used Oracle 8.x, Cognos Suite of Products, Cognos Decision Stream, Cognos eApps, Business Objects, Web-Intelligence

Position

Module Leader – Project Co-ordinator and Senior ETL developer

Client

Lafarge India Limited

Project Title

Financial Datawarehouse

Project Locations

Lafarge India Limited Mumbai, MH, India

Period

Mar 2001 – Nov 2002

Project LAFARGE Inc. was the major in the Building and Construction Materials sector. This project scoped the procurement of data from J.D.Edwards into a central datawarehouse catering to various reporting needs of their INDIA operations. I managed, designed, developed ETL interfaces to extract the ERP data and feed into Datawarehouse. I also developed Cognos Cubes and Business Objects/Web Intelligence reports for data visualization out of the Datawarehouse.

Technology Used Oracle 8.x, Cognos Suite of Products, Cognos eApps, Business Objects, Web-Intelligence, PL/SQL

Position

Team Member / Developer

Client

Bharat Sanchar Nigam Limited (BSNL) – Formerly known as VSNL

Project Title

Telecom Datawarehouse

Project Locations

Bharat Sanchar Nigam Limited Mumbai, MH, India

Period

Dec 1999 – Sep 2000

Project BSNL is the international telecom gateway in India for international voice and data traffic. The Project involved creation of a datamart for the purpose of business analysis of BSNL’s Billing Mediation System, Traffic Accounting System and the SAP Financial system. Functionality of the reports were based on three areas: MIS reports, Time-of-day Analysis and Inter Switch Reconciliation. I developed the ETL scripts and report creation for this datamart.

Technology Used Oracle 8.x, Business Objects, Web-Intelligence, PL/SQL, Unix Shell-scripting

Position

Team Member / Developer

Client

Tata Infotech Limited

Project Title

Trouble Report Information Management System (TRIMS)

Project Locations

Tata Infotech Limited Mumbai, MH, India

Period

Jan 1999 – Nov 1999

Project TRIMS was a project tracking system catering to the needs of Project Managers. It aided in project monitoring and quality assurance. It is developed on Windows98 with Oracle and Developer 2000. The system maintains information on Deliverables, Change Requests, User Communication forms, Test Cases, Change Impacts and Time sheets. The system was developed for Data entry and report generation using the Front-end. I designed and developed the back-end tables in Oracle and the front-end screens using Oracle’s Developer 2000.

Technology Used Oracle 8.x, Developer 2000

Professional Affiliations

Oracle Technology Network

Informatica Developers Network

Project Management Institute

Education

Bachelor of Engineering in Electronics and Instrumentation Engineering, with Honors, from D.A.V.V. University, Indore, India – 1998

Certifications

Project Management Professionsl (PMP ®)

Contact this candidate