Manoj Abraham

adagpb@r.postjobfree.com

913-***-****

EXPERIENCE: SUMMARY:

IT professional with over 16 years’ experience in a database production environment specializing in project management, analysis/design, development and architecture of client information with a focus on data warehousing in Banking and Financial Service Industry (BFSI).

Designed technical processes as a Team Lead by using internal modeling and working with analytical teams to gather requirements and create specifications.

13 years of experience in Information Technology with a broad range of computer expertise, analytical skills, backend database applications and 12 years in ETL Architecture and Business Intelligence (DW) applications.

Managed all aspects of the SDLC process - requirement analysis, time estimates, functional specification, design, development, testing, packaging, and support/maintenance.

Proficient in both Waterfall and Agile development methodologies.

Proficient in analysis, design, development of Database Management systems using Oracle.

Expertise in UNIX/Linux shell scripting, job scheduling in CRON, Autosys and Control-M.

Expertise in implementing business logic in Oracle using Stored Procedures, Functions, Packages, Views, materialized views, functional based indexes and Triggers, Dynamic SQL, ad-hoc reporting using SQL.

Expertise in Oracle Database Design and ETL with IBM Infosphere (Data stage), Ab Initio and Informatica.

Mentored, coached cross-trained junior developers by providing domain knowledge, design advice.

Proven ability in defining goals, coordinating teams and achieving results.

ACADEMIC PROFILE:

Bachelor’s in computer systems engineering, Carleton University, Ottawa, Canada.

SKILLS:

ETL Tools : Data Stage, Ab Initio, Informatica

RDBMS : Oracle, DB2 UDB, MS SQL Server, DB2, Teradata.

Modeling Tools : Visio,

Scheduling Tools : Autosys, Control-M.

Cloud : Snowflake

O/S : UNIX, Windows and LINUX.

Software Package : Microsoft office, Toad, Beyond Compare 3, IBM Rational Quest.

Management : Team Lead, Project Management, Agile, Waterfall, SDLC process

Consulting Expertise Summary

Industries: Banking and Financials, Retail, Energy.

Solution Areas: ETL design/ development, Data Architecture, Solution Design.

Data Models: Enterprise Data warehouse (EDW) and Reporting Data mart.

EXPERIENCE: SUMMARY: Nuvento 2019 -

Client : BlueCross Blue Shield, AL, 2019 –

Role : Senior Application System Analyst / ETL Developer

Description: BlueCross, being a leading healthcare insurance provider, has accumulated large volumes of data spread across multiple and disparate systems and databases. This project aims build a data mart for Health Provider with patient satisfaction scoring. The Data mart is developed using Data stage as an ETL tool in SQL server database with Web Focus interface.

Responsibilities:

Provide solution architecture to address the new initiatives around the data mart for Provider Managed Resource system.

Developed DataStage ETL jobs with complex transformation rules to populate data marts.

Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.

Participated in the meeting with Business Users and support Analyst for getting the more information and understanding of the Application.

Work closely with Project Manager, Architects, and Data Modelers to understand the business process and functional requirements. Fixed defects highlighted by testing team.

Environment: Data stage 11.7, DB2, Shell scripting, SQL Server, Tableau.

EXPERIENCE: SUMMARY: IBM USA 2004 - 2018

Client : Safeway, Pleasanton, CA, 2017 – 2018

Role : Solutions Architect / ETL Data stage Developer

Description: Safeway, being a leading supermarket chain along with other banner stores, has accumulated large volumes of data spread across multiple and disparate systems and databases. This project aims at redesigning existing Jobs to new cloud platform. It involves analyze existing applications, remove any unused jobs from the flow and redesign the jobs and re-deploy them. And ensure data consistency and permit advanced data management

for business benefit.

Responsibilities:

Provide solution architecture to address the new initiatives around the web based single sing on OKTA system data requirements.

Designing and overseeing development of highly complex IIS Data stage 9.5 code and Scheduling packages to transfer the LDAP data to Cloud environment. As well as providing detailed documentation and knowledge support to the Production Control team...

Lead the team in the design and delivery of data validation rules with IIS Data stage for loading data into the Grocery offer systems.

Worked Closely with Business Analyst to understand business rules and developed Data stage jobs.

Designed and developed Shell scripts, scheduling mechanism to support daily batch loads.

Worked with deployment team to deploy the code in different environments (QA, UAT, PRE-PROD, PROD)

Mentor and challenge junior and other team members, while growing the technical, functional and leadership skills.

Environment: IIS Data stage, DB2, Oracle, Shell scripting, Big data (Design), SQL Developer, Toad, and Teradata

EXPERIENCE: SUMMARY:

Client : Chevron Corporation, Bakersfield, LA, 2017

Role : Tech Lead / ETL Data stage developer

Description: Chevron, one of the world’s leading integrated energy companies producing petroleum products and manager large number of Oil Wells in USA. The project is to automate processes that load the Well logistics data from different sources (SOR) to the Enterprise Data warehouse (EDW) and data marts. . It also sends daily extracts to different systems to satisfy their downstream requirements.

Responsibilities:

Provide solution architecture to address the new initiatives around the Data Warehouse data requirements.

Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.

Supporting the off-shore team by setting up the Infrastructure, ramping up development and production support.

Designing and overseeing development of highly complex IIS Data stage code and Scheduling packages as well as providing detailed documentation and knowledge support to the client.

Lead the off-shore team in the design and delivery of data validation rules with IIS Data stage for loading data into the EDW.

Worked Closely with Business Analyst to understand business rules and developed Data stage jobs.

Developed balance reconciliations processes, point to point controls, capturing operational info for the reporting team.

Environment: Team management, IIS Data stage, Teradata, DB2, Oracle, SQL Server & Shell scripting.

EXPERIENCE: SUMMARY:

Client : FORD, Dearborn, MI, 2016

Role : Data Analyst / Quality Stage Developer.

Description: Ford Motor Company is an American multinational automaker sells automobiles and

commercial vehicles and most luxury cars. Ford initiated MDM (Master Data Management) project to consolidate all the customer data from Canada, Mexico and USA. This project involves analyze existing address standardization application codes and converted Quality Stage Modules. The existing address standardization application has match ratio of 35% and the quality stage modules improved the match ratio to acceptable rate of 85%. The Quality stage jobs were executed to load standardized customer data to MDM tables.

Responsibilities:

Provide solution architecture to address the new initiatives around the customer address standardization data requirements.

Review existing address conversion codes in Java and translate them to Quality stage modules.

Develop new Quality stage modules to add additional functionalities that does not in the existing applications.

Designing and overseeing development of highly complex IIS Data stage/Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.

On a Weekly basis, produced reconciliation report with metrics and reviewed with management team.

Environment: IIS Data stage, Quality Stage, UNIX, Oracle, DB2, SQL Server.

EXPERIENCE: SUMMARY:

IBM USA

Client : Fannie Mae, Herndon, Virginia, 2014– 2015

Role : ETL Architect / Designer

Description: Fannie Mae provide a secondary market in home mortgages, purchasing mortgages from the lenders who originate loans. The Data warehouse EDW/BI team helped in extracting the data from warehouse to query the Marts to generate the reports for different LOBs. Job Specification and Unit Test case reports were generated, and Informatica with DT was used as an

ETL tool to extract, transform and load data to the data mart.

Responsibilities:

Provide solution architecture to address the new initiatives around the CRM Data Warehouse data requirements.

Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.

Supporting the deployment team by setting up the Infrastructure, ramping up development and production support.

Designing and overseeing development of highly complex Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.

Lead the team in the design and delivery of data validation rules with Informatica ETL tool for loading data into the EDW. .

Ported Oracle OBIA informatica codes to Microsoft APS platform.

Environment: Team management, Informatica with DT, JENS Message broker, DB2, Oracle, OBIA, Auto Sys.

EXPERIENCE: SUMMARY:

IBM USA

Client : State Farm, Bloomington, Illinois, 2011 – 2014

Role : ETL Architect / Designer / Business Analyst

Description: State Farm is leading insurance company specialized in auto, home and life insurance products.

Worked in projects (DC3, DC8). The project DC8 was to develop business rules document to support single view data mart project. My role was to produce business mapping document by driving mapping session with business users and technical analysts. DC3 project is Java Based Payment WIP processing system development. My role as ETL architect to design and develop informatica codes to support back end system.

Responsibilities:

Provide solution architecture to address the new initiatives around the single view data mart requirements.

Supporting the DC3 support team by setting up the Infrastructure, ramping up development and production support.

Designing and overseeing development of highly complex Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the client transition team.

Lead the team in the design and delivery of data validation rules with Informatica for loading data into the payment system data base.

Environment: Informatica, DB2, Oracle, SQL Server & Shell scripting, Informatica and Toad.

EXPERIENCE: SUMMARY:

IBM USA

Client : Walgreens, Deerfield, IL

Role : ETL Designer / Ab Initio Developer, 2009-2010

Description: Walgreens is leading company operates pharmacy store chain in united states. Specialized in filling prescriptions, health and wellness products. This project was intended to add additional functionality to their existing customer billing system. Walgreens use Ab Initio as an ETL tool to process billing records. It Involved in business requirements gathering meetings and created functional, technical specification documents and source to target mapping documents. Finally, design and develop Ab Initio ETL codes based on the source to mapping documents.

Responsibilities:

Provide solution architecture to address the new initiatives around the Customer billing data requirements.

Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.

Designing and overseeing development of highly complex Ab Intio code and Scheduling packages as well as providing detailed documentation and knowledge support to the team.

Developed balance reconciliations processes, point to point controls, capturing operational info for management report.

Environment: Team management, Ab Intio, DB2, Oracle and Shell scripting.

EXPERIENCE: SUMMARY:

IBM USA

Client : Bank of America, Charlotte North Carolina

Role : ETL Designer / Ab Initio Developer, 2007-2009

Description: The Bank of America Corporation is an investment

bank and financial services company based in Charlotte. This project This project was intended to create

EDW (Enterprise data warehouse) from loan records from different source systems.

Responsibilities:

Provide solution architecture to address the new initiatives around the CRM Data Warehouse data requirements.

Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.

Supporting the deployment team by setting up the Infrastructure, ramping up development and production support.

Designing and overseeing development of highly complex Ab Initio jobs code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.

Lead the team in the design and delivery of data validation rules with Ab Initio ETL modules for loading data into the EDW.

Environment: Team management, Ab Initio, DB2, Oracle, SQL Server & Shell scripting.

EXPERIENCE: SUMMARY:

IBM USA

Client : CapitalOne, Richmond, Virginia, 2004-2006

Role : ETL Designer / ETL developer

Description: Capital One Financial Corporation is a bank holding company specializing in credit cards, auto loans,

banking and savings products. Involved in EDW (Enterprise data warehouse) from Auto loan records and

also, mainframe migration projects. In both projects used etl tool Ab Initio for the processing.

Responsibilities:

Provide solution architecture to address the new initiatives around the CRM Data Warehouse data requirements.

Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs. .

Designing and overseeing development of highly complex IIS data stage/Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.

Lead the team in the design and delivery of data validation rules with IIS data stage for loading data into the EDW.

Developed balance reconciliations processes, point to point controls, capturing operational info for management dashboards.

Environment: Team management, Ab Initio, DB2, Oracle, SQL Server & Shell scripting.

EXPERIENCE: SUMMARY: 2003 – 2004

Aetna, Middletown, CT

Role : Data warehouse/Ab Initio Developer

Description: Aetna is a managed health care company, which sells traditional and consumer directed health care insurance plans and related services, such as medical, pharmaceutical, dental, behavioral health and plans. My role involves working both in team for Claim processor project which aims at developing extracts for new source systems.

Working in team for those projects involved developing jobs from scratch and working on shell scripts for them.

Phase 1 addressed fundamental system issues, including how pharmacy claims were processed and stored,

implementation of claims processor vendor, and solutions for eligibility, and pharmacy network. A review of pharmacy claims processor options were done early in program timeline so other functionalities can be designed around a solid claims structure that will meet their future needs.

Responsibilities:

Exporting the jobs to Testing Environment from Development and then to Production.

Did unit testing of the jobs developed before taking them for UAT and finally Production.

Extensively Used the ETL Tool Ab Initio to develop jobs to extract, transform and load data from various source systems into the Data Warehouse.

Environment: Team management, Ab Initio, Informix XPS, DB2 EEE & Shell scripting

.

EXPERIENCE: SUMMARY: 1999– 2001

MCI-WorldCom, Colorado Springs, CO

Role : Data warehouse/Ab Initio Developer

Description: MCI- WorldCom is telecommunications company that provides wireless services and is an internet service provider. EDW Implementation: This project involves building a new Enterprise Data warehouse (EDW) for the client. This new data warehouse will be based on business model of the customer and would be source system independent. Data from various systems would be cleansed and stored in a normalized database and presented through a dimensional view layer to all users. This new data warehouse would replace the existing data warehouse, which is essentially a collection of disparate data marts built for each department.

Responsibilities:

Designed the Unit testing and integrated testing process and necessary documentation.

Involved in requirements gathering and creating logical and physical design based on the business requirements

Involved in mapping the business rules and worked with the business analyst to get the correct data according to the requirements.

Used Informix XPS load utilities for bulk loading of records which had count often going up to 100 million records.

Environment: Team management, Ab Initio, Informix XPS, DB2 EEE & Shell scripting

Contact this candidate