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