Project Data
Resume:
Professional Summary
Over ** years of Information Technology experience in the field of Design, Development of Data Warehouse involving Teradata, Oracle and Informatica.
Presently associated with Capgemini as Senior Data Analyst/Data Engineer & previously worked with Dell Perot Systems (India) Private Limited as Senior Software Engineer.
Umesh has lead and worked on variety of BI scenario including Enterprise DW, Data Marts, High Volume, Metadata Driven Architecture, Data Integration and Reporting solutions.
He has lead the BI architecture activities for multiple BI engagements for a large Healthcare product manufacturing company on the services domain. During this period, he has successfully participated in architecting, deploying and managing a variety of Business Intelligence solutions.
Has worked on a variety of industries/sub-verticals in Financial Services, Healthcare Verticals.
Have worked on Healthcare and Finance verticals with Teradata 14, Oracle 9i and Informatica 8.6 as the technical base. Proficient in writing SQL, PL/SQL stored procedures, packages and triggers. Proficient in writing the BTEQ, MLOAD and FLOAD Scripts. Had worked on various transformations in Informatica like Expression, Router, SQL Transformation, Update strategy, Sequence Generator, RANK, Filter, and Sorter transformations etc.
Experienced DW-BI professional with excellent business and the technology skills leading large global teams to deliver complex Business Intelligence, DW and Analytics projects.
Extensive experience of interacting with clients both from offshore and onshore. Experience in resolving on-going maintenance issues and bug fixes; monitoring complex ETL jobs. Identify and manage the areas of risk / opportunity, influence and implement continuous improvements to the process
Experience in analyzing the Impact of the various applications that would be affected by a change that is required at an application.
Have analysis, design and troubleshooting skills. Strongly worked in association with team members and provided guidance & support to peers. Worked closely with the leadership teams to understand priorities, influence decisions, propose solutions and ensure success of key priorities.
Estimate work efforts for the team and manage resources accordingly. Proficient in acting as technical liaison between the Business Users and the Technology.Have managed team up to 24 team members as Technical manager.
Good communication skills (written and verbal) and Good Team player and also a self-motivated individual with analytical and problem solving skills with customer focus.
Worked in client place (UK London) for one Healthcare Customer and Finance Customer on the Project Management, Requirement gathering and as SPOC for UAT and release activities.
Currently working in US for leading Air filter manufacturing customer.
Skills Profile
Technical
Database
Teradata 14, Oracle 11g, Sybase, Greenplum
Tools
Informatica, Informatica CDC, Tableau
Languages
C++, Visual Basic, SQL/PLSQL
Other
Informatica 8.6, Spotfire 5.5, Business Objects, Redwood Cronacle 9, Dimensional Modelling
Professional Experience (In Reverse Chronological Sequence)
Project# 1
Organization Name Capgemini
Client Name CLARCOR Industrial Air
Project Name JAROS replacement (Apr 2017 – till date)
Role/Title Onshore Lead/Coordinator – Team Size 5
Work Location Overland Park, Kansas (USA)
Project Description
CLARCOR was looking for building the warehouse which is near real time and have the latest data in the operational reports and warehouse. Currently it’s handled by JAROS and the loads run in batches which is causing the delays to see the transactional changes on the warehouse. Informatica is used to replace JAROS and build the load strategy similar to JAROS in informatica.
Responsibilities
Analysis on the newer requirements from both the source end and the Warehouse and taking up with the Client community for any clarification /suggestion.
Design of the data flow with the new simplified architecture replacing JAROS.
Remediation analysis and implementation of the existing JAROS to the simplified architecture.
Impact analysis of the existing architecture and how that can be done in to be architecture using Informatica. Responsible for end to end analysis of the JAROS application and flow and replicating the same logic and data flow using Informatica.
Analysis on the design and involved in design reviews. Lead design review meetings involving architectural changes.
Estimation for the newer enhancement requests and Project schedule preparation.
Responsible for discussion with other stake holders like ERP, DBA and other functional users and have the design reviews and end to end implementation of the project.
Responsible for defect tracking and also was single point of contact for UAT.
Software / Special Tools Informatica, JAROS, Oracle, SQL, PLSQL
Project# 2
Organization Name Capgemini
Client Name GE Renewables
Project Name RACES (April 2016 – Mar 2017)
Role/Title Technical Project Manager – Team size - 30
Work Location Bangalore
Project Description
GE Power & Water Renewables was looking for a strong BI platform from where turbine related metrics can be generated. JAROS stopped their support and GE decided to move on nextgen BI where the whole process is much faster and simpler to maintain. With that we have implemented the Informatica CDC for incremental data load logic.
Responsibilities
Analysis on the newer requirements from both the source end and the Warehouse and taking up with the Client community for any clarification /suggestion.
Design of the data flow for the RACES ERP to ODS / EDW involving Informatica CDC and GP.
Impact analysis of the existing architecture and how that can be done in to be architecture using Informatica CDC and GP. Responsible for end to end analysis of the JAROS application and flow and replicating the same logic and data flow using Informatica CDC and GP.
Business logic design and development in the GP UDF
Analysis on the design and involved in design reviews. Lead design review meetings involving architectural changes.
Estimation for the newer enhancement requests and Project schedule preparation.
Responsible for defect tracking and also was single point of contact for UAT.
SPOC from offshore for the RACES support and enhancements.
Software / Special Tools Informatica, JAROS, Oracle, Tableau, Greenplum, SQL, PLSQL
Project# 3, 4
Organization Name Capgemini (IGATE Global Solutions)
Client Name GE Healthcare
Project Names PQW (Jan 2016 – Mar 2016) – Team - Individual contributor
Chart of Accounts (June 2015 – Mar 2016) – Team size - 12
Role/Title Project Lead / Architect
Work Location Bangalore
Project Description PQW (Jan 2016 – Mar 2016)
Product Quality Warehouse leverages Product Definition, Manufacturing, Shipment and Fulfillment data from various source systems to create Product Instances to represent every unique system that is manufactured/shipped and maintained at customer site. Unique process to handle multiple ERPs
Project Description Chart of Accounts (June 2015 – Dec 2015)
COA Project is mainly for optimizing the productivity in GE’s shared services model. A single chart of operating accounts that can be transacted in will allow shared services teams to work seamlessly across GE Industrial Segments from anywhere in world. Allows for the easier recast of ERP data in the event of a Company or segment reorganization. This project is to institute a wing-to-wing reporting nomenclature for the Company from the point of entry of data in a shared services or ERP sub-system through segment consolidation and through the corporate consolidation and reporting structure.
Responsibilities
Analysis and worked on data reconciliation from various sources
Mainly focused on the data quality and data mismatch between the source and the target and highlighted the issue to client community.
Proposed changes in the existing design of the data flow to mitigate the data quality issues.
Analysis on the design and involved in design reviews. Lead design review meetings involving architectural changes.
Design of the data flow and to have common ODS/EDW for client architecture. Also worked on achieving this with the BTEQ, FLOAD, MLOAD and TPUMP scripts.
Analysis on the design and involved in design reviews. Lead design review meetings involving architectural changes.
Estimation and responsible for defect tracking and also was single point of contact for UAT.
Test, maintain and monitor computer programs and systems, including coordinating the installation of computer programs and systems
Software / Special Tools Teradata (Utilities - BTEQ, FLOAD, MLOAD, TPMUP), Informatica, Cronacle, SQL, PLSQL
Project# 5
Organization Name Capgemini (IGATE Global Solutions)
Client Name GE Capital (UK)
Project Names Online Vendor Reporting (Sep 2014 – May 2015) – Team size - 3
Role/Title Project Lead
Work Location London (UK)
Project Description
OVR and Data quality program for the long term sustainability diagnosis, remediation, prevention, and monitoring and governance process for all the programs. OVR is a value added reporting for the Vendor clients of GE Capital that gives the complete details of the Customers, Products and the Sales across the regions. This was for moving on to the complete transparency on the Equipment Finance to the GE Capital EF customers. Reconciliation of various reports to a common architecture which gives easy maintenance and long term sustainability with the effective architecture and a centralized controllership.
Responsibilities
Analysis of the various business process, new requirements and activities to simplify the Equipment Finance (EF) models.
Interact with the business users and the data stewards based on the analysis of the existing system and get the go ahead approval on the new short term and long term remediation approach and discuss with the development with for the implementation of the same.
Lineage / blueprint for the changes in the flow. Documenting HLD, LLD and system specifications. Design and implement data quality dashboards and scorecards for communicating progress to business stakeholders and data quality sponsors
Perform source data profiling & analysis against established DQ controls and compliance standards. Implement a framework that addresses issues in existing data and provides a foundation for continuous improvement
Obtain business insight on exceptions and issues identified (review of metrics, data distributions, outliers, trends, etc.). Provide sustainable long term plan and remediation and governance approach.
Software / Special Tools Informatica, Informatica Data Quality, SQL, PLSQL
Project# 6, 7
Organization Name Capgemini (IGATE Global Solutions)
Client Name GE Healthcare
Project Name Uptime SAM implementation (Mar 2014 – Aug 2014) – Team size - 7
Product Quality Dashboard (Aug 2013 – Feb 2014) – Team size - 3
Role/Title Project Lead / Scrum master
Work Location Bangalore
Project Description - Uptime SAM implementation (Mar 2014 – Aug 2014)
GEHC Healthcare Services provides preventative and corrective maintenance services, asset management, and healthcare financial solutions for the HC equipment around the globe through multiple call centers as well as through on-site and distributed field engineers. Currently GEHC is not able to systemically identify accurately the uptime performance to Contract commitment on any contracts for the Healthcare equipment today.
Project Description - Product Quality Dashboard (Aug 2013 – Feb 2014)
The main purpose of the PQD program is to build visual an actionable & operational dashboard for service cost granularity to provide more effective wing-to-wing Cost to Serve (CTS) management. Services after sales are defined as periodic or required maintenance or repair of any asset by its manufacturer or supplier during warranty or contract period and even after that. Implementation of Product Quality dashboard would enable to measure the global metrics for product quality and metrics will be shown in Spotfire tool.
Responsibilities
Analysis on the newer requirements from both the source end and the Warehouse and taking up with the Client community for any clarification /suggestion.
Impact analysis and detail requirement Analysis on the KPI's required in the Dashboard like Uptime, Infantile Failure rate (IFR), Mission Failure rate (MFR), Elapsed time to repair (ETTR), Mean Time between Failure (MTBF), Install and warranty etc.
Interact with various business communities and platforms to capture, verify, prioritize and finalize requirements. Preparation of HLD documents like SRS, SRDS, Impact analysis documents and review of LLD documents.
Environment set up with the predefined data model and to have ODS, EDW client architecture model implemented.
Ensure correct loading of the tables and build relation between them and facilitate to reporting solution to achieve the KPI defined.
Support user community during UAT for the issues if any.
Software / Special Tools Teradata (Utilities - BTEQ, FLOAD, MLOAD, TPMUP), Informatica, Cronacle, SQL, PLSQL
Project# 8
Organization Name Capgemini (IGATE Global Solutions)
Client Name GE Healthcare
Project Name LS Harmony Data Acquisition (Jan 2012 – Jul 2013) – Team size - 14
Role/Title Project Lead / Scrum master
Work Location London (UK) & Bangalore
Project Description
Project Harmony is to build a simplified and standardized OTR and Finance processes from existing multiple JDE ERP systems in to 1 global ERP Platform which accelerates in Commercial Excellence, ease of doing business and On Time Delivery. This integrates transaction systems into EDW. Data from ERP and CRM apps (JDE, BIOPROD, SIEBEL) has been integrated into ODS/EDW. Focusing on Simplification, Growth and Commercial excellence.
Responsibilities
Analysis on the newer requirements from both the source end and the Warehouse and taking up with the Client community for any clarification /suggestion.
Design of the data flow and to have common ODS/EDW for client architecture.
Analyze on the requirements and discuss with the client community to identify the Gaps and suggested changes to done on the URS and suggested design recommendations as well in source side that were accepted and implemented.
Estimation for the newer enhancement requests and Project schedule preparation.
Extensively worked in data Extraction, Transformation and Loading from source to target system using Power Center of Informatica.
Impact analysis on the various applications for any code changes.
Responsible as technical liaison between the Business Users and the implementation teams.
Responsible for defect tracking and also was single point of contact for CRP1, CRP2 and UAT.
Software / Special Tools Teradata (Utilities - BTEQ, FLOAD, MLOAD, TPMUP), Informatica, Cronacle, SQL, PLSQL
Project# 9
Organization Name Capgemini (IGATE Global Solutions)
Client Name GE Healthcare
Project Name Healthcare ITBI Services Mini Loads (Aug 2010 – Dec 2011)
– Team size - 6
Role/Title Technical Lead
Work Location Bangalore
Project Description
Business wanted to have the Siebel Services related Information in the warehouse on an hourly refresh. The Application was already running in Production on a nightly basis and it had dependency on the various other project loads since many tables are shared by more than one project. To make the parallel run feasible the common architecture was introduced for all the service domain tables in scope.
Responsibilities
Analysis on the impact in terms of BI table and loads and impact on another application thoroughly analyzed.
Estimation for the newer enhancement requests and Project schedule preparation.
Analysis on the design and involved in design reviews.
Coding and testing of the application.
Co-coordinating with the various teams for reviewing and migrating of objects.
Preparation of SRS, SRDS and other documentation required.
Project status tracking and reporting
Mentor the development team in technical aspects of the requirements and review the code.
UAT support and go live support for the application.
Software / Special Tools Teradata (BTEQ, FLOAD, MLOAD, TPMUP), Informatica, Cronacle, SQL, PLSQL
Project# 10
Organization Name Perot Systems TSI (India)
Client Name PHH Mortgage
Project Name PHH Mortgage Dev and Support (Aug 2006 – Jul 2010)
Role/Title Senior Software Engineer
Work Location Bangalore
Project Description
Internal and External interfaces are further divided in to Applications such as Loan Registration, Cash to CPI, UBS Mavent, GMAC & TCO.
Loan Registration: LoanReg interface handles Loans from different Databases like PHHORCE (Sybase DB), WEB(Sybase DB) and these generates Loan specific flat files (drip or drop files) and Loan files are processed in LoanReg, which is VC++ application. The processed data is inserted / updated in oracle database called CASH (Oracle DB). From CASH, data will move to other all interfaces like CMDR, QRM, etc.
CASH to CPI: This module is to automate the loan servicing/administration part of the loan life cycle for various Mortgage providers such as Merrill Lynch, Charles Schwab and many more.
UBS Mavent: This module is developed using Oracle (SQL and PLSQL), Informatica, and UNIX. UBS is one of the largest clients of PHH Mortgage. This interface was developed to generate compliance reports and transaction reports based on loan activities in XML format from different data sources to UBS.
TCO (Time Cost Optimization): The main purpose of this project is to Re-design existing stored procedures and Interfaces to come up with one common frame work which extract all required information.
Responsibilities
Create procedures, packages and functions to extract data from different sources.
Developed mappings using expression, aggregator, filter, joiner, Lookup, router, update strategy and procedures to develop and feed Data Mart. Deployed and tested sessions in Informatica Server
Creating shell scripts to trigger Informatica Sessions and Workflows.
Programming the business logic (Oracle PL/SQL, Sybase) for LoanReg, TCO, External Interfaces & GMAC applications.
Preparing System specification, Unit testing, test case preparation and Production support for LoanReg interface.
Investigating and solving any production issues that may arise and suggest and make necessary changes to the applications if required to prevent similar issues from arising in the future.
As Release manager, was responsible for the various release versions of the internal interfaces code and involved in the migration activities.
Perform unit testing at various levels of the ETL.
Software / Special Tools Oracle, Sybase, VC++, Informatica, SQL, PLSQL
Personal and Contact Information
Email ID – ac1sxe@r.postjobfree.com
Mobile# +1-913-***-****
Date of Birth – 22 Dec 1983
Currently residing – Overland Park, KS
Education – Bachelor of Engineering – Electronics and Communications (2006) from Siddaganga Institute of Technology from Vishweshwaraiah Technological University.
Contact this candidate