ETL LEAD / TECHNICAL MANAGER

A result-driven IT professional with 13+ years of technical and team leading experience. Seeking a position as a senior ETL lead for enterprise data warehousing applications.

SUMMARY OF QUALIFICATIONS

Over 13 years of extensive knowledge in Database technologies in OLAP/OLTP systems. Extensive hands-on experience in data warehousing, BI and designing ETLs using INFORMATICA POWERCENTER with Oracle/ MS SQL server databases. That includes development, performance tuning, designing Control M batch scheduling tool for highly complex streams.

Strong experience in the banking sector building datawarehouse for Asset Managements retail funds CRM business (Salesforce.com) for one of the largest US banks – leading a diverse team of developers.

Created Informatica Powercenter workflows, mappings, mapplets, source qualifiers, target definitions for VSAM, CSV, XML and various unstructured files.

Achived top employee ratings and excellent client feedback in various roles as Technology Lead/ Data Architect / Integration Specialist / CRM data- Subject Matter Expert during the ongoing engagement of Cognizant as largest vendor-partner with the largest US bank in Investment Banking and Mortgage sectors.

Good SQL server experience in performace tuning using SHOW PLAN to identify missing indexes and reduce table or index scans.

Strong experience in Oracle (7.0/7.3/ 8i / 9i/10g/11g) with Windows NT / UNIX environment. Extensive hands-on knowledge on Oracle development. Tuning queries for higher performance (Using Hints, explain Plain). Expertise in different DDL/DML/TCL commands. Use Toad, Pl/sql Developer and sql editor for working in Oracle.

Posses strong analytical and problem-solving skills. Hands on experience of 10 years on Linux/Perl/Unix Shell Scripting.

Good Technical project management skills and PMP certified - managed multi-geographical teams, right from new team initiation, onboarding, offshore-onsite team, knowledge transition to BAU stage.

Performed MSSQL query optimizations and reduced batch processing timelines from 4hrs to 3hrs (a 25% time reduction).

Strong knowledge of Data Models and normalized and de-normalized data models – STAR and SNOWFLAKE SCHEMAS. Used INFORMATICA to create workflows and mappings to load FACT and DIMENSION tables.

Performed L2/ L3 production support and lead application teams as an SME ( subject matter expert ) for Asset Managements CRM application.

Managed deliveries with global teams and using agile methodologies functioning as a central point of contact for managing new ETL designs and batch development. Mitigating technology risks and road-blocks, prioritizing daily activities focused on progressing on the critical path meeting projected timelines.

Additional responsibilities include technology management of BAU activities, relationship management, agile methodology implementation, routing and overseeing of support requests, product development, and staff supervision including year-end reviews.

Has sufficient understanding /subject matter expertise and preparedness of information to effectively communicate key messages across matrix project teams, IT or Business teams. Communicates confidently with Directors. Provides proactive communications to key Stakeholders.

Integration Management - Successfully can integrate planning tasks across multiple spaces within LOB. Resource Management - Identifies and negotiate resource needs for project. Successfully ensures business counterpart readiness activities complete and takes ownership for entire end-to-end project

Very interested to train in new tools and technologies in BI and Big data technologies. Done POC using AWS ubuntu, HDFS, Hbase and on mac systems. Has knowledge of Elastic Search, Kibana, logstash and filebeat.

Good communication skills, interpersonal skills, self-motivated, quick learner, team player and hard worker.

Leadership

Data Warehousing

Toad Data Modeler 5.5

SharePoint 2010

PMP (Project Management)

Informatica 9.5 Powercenter

End-to-end Architecture

Linux

MS SQL server

SVN

Estimation techniques

Visual Basic

XML

Control-M 8.0

UNIX Shell Scripting

JAVA

Oracle 11g

SQL queries

Maintenance and Production Support

Scrum

DB2

Toad

Risk management

Data Modeling

SDLC

Microsoft Visual Studio

ITIL

Data Integration

ETL

Visio

MS Project 2010

Data Analysis

SKILLS

PROFESSIONAL EXPERIENCE

Client: JPMorgan & Chase. (Sept2016– May 2017)

Role : Lead a team of 4 for creating of a new UAT lane of ORACLE and informatica servers with new code rollout for regulatory and finance testing needs.

Was responsible for deploying new code and configuration and testing 15 SORs leading a team with one DBA and 2 INFORMATICA ETL developers. Reviewed and implemented multiple batch scheduling jobs using Control M.

Used Oracle SQL loader, table partitions, Control M batch, Unix shell scripting, PL/SQL, stored procedure, Materialized views, and optimized stored procedures.

Client: JPMorgan & Chase. (March 2015 – Sept2016)

Role: Data Architect (batch)/ Subject Matter Expert (Global CRM-batch)/ and data warehouse and ODS

Responsible for leading a technical team of ETL and batch developers to architect a CRM solution for Retail Funds business.

Lead a team of 4 developers for creating a new enterprise data warehouse and ODS (operational data store) for Global Investment Management’s Salesforce application.

Worked on data modelling using dimensional data models. The project involved - migrating data from the legacy system, standardizing the data loading process using transparency data feeds from various transfer agencies and summarizing the data to calculate YTD sales, monthly sales and yesterday’s sales numbers for sales reps. This data was made available for sync up with the Salesforce application cloud.

Create and implement data models (i.e., Star, Snowflake, etc.)

Create and implement data warehouses & data marts in Oracle and MS SQL server 2008.

Created Informatica Powercenter workflows, mappings, mapplets, source qualifiers, target definitions for VSAM, CSV, XML and various unstructured files.

This implementation involved a phased rollout for an Enterprise Data warehouse for EMEA, ASIA, Latin America and North America regions. Worked on the Batch designs that needed a detailed analysis for meeting the SLA timelines of different time zones.

Responsible for designing the ETL modules for data extraction and transformations, doing code optimizations and standardizations using mapplets in Informatica for more than 35 different feed layouts.

Worked on extensive documentation and helped train up operations teams as part of the readiness activities for the rollout.

Delivered project needs on time and within the agreed acceptance criteria using Agile Methodology.

Reported progress to all stakeholders through Sprint Burn-Down Reports, Iteration Burn-Down Reports, and velocity target updates.

Client: JPMorgan & Chase. Period: Mar 2011 – Feb 2015

Role: Subject Matter Expert/ Data Architect (batch) and data warehouse and ODS

Project Description

Was responsible for building solutions to support the ever-changing business landscape of retail CRM and maintaining BAU. Under this larger program managing delivery of multiple projects to improve the quality of call management.

SalesPage CRM – SalesPage is a CRM (Customer Relationship Management) system designed specifically for Asset Management firms. It is designed to resolve the critical problems that the leaders in the mutual funds and annuities have identified. Client advisors are able to track notes and review sales information in the system.

Role and Responsibilities:

Architect file standardization and loading mechanism for more than 24 transparency file projects for the current year.

Was responsible for migrating a large legacy batch involving 150 ETL workflows from informatica 8.6 to 9.5. this involved working with technology team from within the bank to procure new servers, testing implementation, migration and bringing to BAU. This included coding and testing over 600 control m batch jobs using UNIX shells, perl modules and MS SQL server 2008 stored procedures and functions.

Reduced batch processing timelines from 4hrs to 3hrs (a 25% time reduction) by identifying long running stored procedures in MS SQL server and working with DBA teams to add indexes and have brain storming sessions with tech team members to suggest reduction batch dependencies.

Did code Analysis, estimation, designing and performance tuning for extraction transformation and load process.

Work with Business Analysts, Senior Data Architects, SMEs and Business partners to understand the Business requirements, Use cases. Translate the Business requirements into Technical Specifications and Data Models (Logical and Physical).

Responsible for requirement gathering from stakeholders, delivery estimations, scheduling, and weekly status reporting.

Performed peer review, code quality review. Negotiation between business and technology teams to arrive at the most optimum solution for the problems at hand.

Created Informatica Powercenter workflows, mappings, mapplets, source qualifiers, target definitions for VSAM, CSV, XML and various unstructured files.

Worked in resolving data anomalies and conducting data integration analysis.

Maintained metadata and worked on master data management.

Delivered project needs on time and within the agreed acceptance criteria in a hybrid methodology environment as they attempted to transition to an Agile Methodology.

Client: JPMorgan & Chase. Period: Mar 2010 – Feb 2011

Role: Project Lead (offshore -INDIA)

Technology and tools: Sybase 12.5, Unix, Control M, Informatica 8.6.

Project Description

Development, migration and upgrade modules for the Investment Bank.

Managed accounts – Compass to IMS is a decouple project whose objective is to ensure that the existing system stays unaffected after decommissioning of an existing system called Compass.

Performed code optimizations for ETLs used for data extraction and transformations.

Additional responsibilities are seamless migration from Sybase 12.5 to Sybase 15. Optimizations and performance tuning for SQL queries.

Client: JPMorgan & Chase. Period: Feb 2009 – Feb 2010

Project Name: Investment Management – Distribution Institutional

Role: Project Lead (offshore-INDIA)

Project Description

Production Support and Maintenance

Productions Support Team and had complete ownership of applications such as Ampere and CRT among others in the Distributions space in IM.

Role and Responsibilities

Requirement analysis module assignment and tracking.

Code Analysis, estimation, designing SQL queries and performance tuning for ETL extraction transformation and load process. Created Informatica Powercenter workflows, mappings, mapplets.

Requirement gathering from business stakeholders, delivery estimations and scheduling and weekly status reporting.

Peer review, code quality review. Negotiation between business and technology teams to arrive at the most optimum solution for the problems at hand.

Team performance appraisals.

Transitioning of Activities from Onsite to Offshore

Looking after Resourcing needs for account including taking interviews and campus recruitments.

Incident Management

Initiating Service Delivery from Offshore and did PRODUCTION SUPPORT –L3.

Client: JPMorgan & Chase. Period: Nov 2008 – Jan 2009

Project Name: Investment Management – P135

Role: Project Manager / Tech-Lead (onsite / offshore) – New Jersey / Columbus, Ohio & Pune, India

Technology and tools: Sybase 12.5, Unix, Control M, Informatica 8.6.

Project Description

Was responsible for Level 2 Production Support and Maintenance. SQL queries optimizations.

Visited Onsite New Jersey/ Ohio/ Delaware in USA for knowledge Transition of projects for Ampere and CRT among others in the Distributions space in IM.

Client: JPMorgan & Chase. Period: Apr 2008 – Oct 2008

Project Name: Investment Management – IM Fixed Income Build (Compliance)

Role: Team Member

Technology and tools: Sybase 12.5, Unix, Control M, Unix scripting, Rapid Sql

Project Description

Was responsible for a development module using Sybase stored procedures and SQL queries optimizations and Control M jobs.

Control and Compliance Application suite (a combination of desktop and web application), which involves activities about checking trade orders and positions for compliance to the rules and regulations set for different Investment Management accounts.

This was an enhancement module to the existing application.

Client: JPMorgan & Chase. Period: Jan 2007 – Mar 2008

Project Name: Investment Management – IM – Control & Compliance

Role: Team Member

Project Description

Performed level 2 Production support, Maintenance, small enhancements and bug fixes using Sybase 12.5, Unix, Control M, Unix scripting, Rapid Sql, Java script., SQL queries troubleshooting.

Control and Compliance Application suite (a combination of desktop and web application), which involves activities about checking trade orders and positions for compliance to the rules and regulations set for different Investment Management accounts.

Client: JPMorgan & Chase. Period: Jul 2005 – Dec 2006

Project Name: Investment Management – Private Banking – PB Operate

Role: Team Member

Technology and tools: Sybase 12.5, Unix, Control M, Unix scripting, Rapid Sql, Java script, SQL queries troubleshooting.

Project Description

Maintenance and Production Support.

PB-Operate Online Applications group deals with the SDI clients for the A confidential client and one of the largest financial institutions in US Private Bank. The SDI client decides their own investment objectives through various online desktop and web based applications. The PB-Operate Team’s Objective is providing support to the Business Users of the JPMC PB who deals with PB’s SDI Client while working with various Online Applications.

Employer: Tata Tinplate Period: Jan 2004 – Jun 2005

Project Name: BAAN billing system & Building Automation production support

Role: Team Member/ Officer trainee

Technology and tools:

Project Description

Performed Accounting and Sales support with BAAN Interface, VB6, MSAccess, SQL queries troubleshooting

This was a manufacturing company which is in the business of making food grade tin coated sheets from steel rolls. BAAN billing system was used as their invoicing tool in their marketing departments.

Role and Responsibilities

Sales support and invoicing.

Monthly billing cycle application support.

EDUCATIONAL EXPERIENCE

Master of Computer Science, Pune University, Maharashtra, India, 2003

Bachelor of Computer Science, Pune University, Maharashtra, India, 2001

Project Management Professional PMP® #1869383 PMI.org 2015

Contact this candidate