Able Mathew Email & Phone Number

Saint Paul, Mn, Us

Minnesota, United States

• Analyzing the existing design and architecture of the ETL and enhance, tune, and add any new functionality to the existing code• Work on SQL DB for customizations • Work on Unix to support this Project for creating Shell scripts for Jobs• Work on shell scripting batch scripting to code the functionality related to integrating the data from Demantra for reporting• Designing new ETL jobs from scratch to load into the database and till Report• Design and develop data load process (ETL) using IBM Datastage and create workflows to load dimension and fact tables.• Preparation and Review of Source to Target Mapping Sheets and ETL Design Document.• Ensuring that the project confirms to the organization quality norms.• Interact and Co-ordinate between multiple stakeholders.• Intelligent Data Operating Layer implementation for creating a single processing layer that can process all types of content—structured, semi-structured, or unstructured.• Provide daily updates to the Project Managers and updating the Project Status to the Clients.

Chennai, Tamil Nadu, India

Project Name : GM Finance- ODS.Client : General Motors Financials.Organization : Hewlett Packard Enterprse.Duration : Jul 2014 – Mar 2017Role : Senior ETL Consultant.About Client:General Motors, one of the world's largest automakers, traces its roots back to 1908. With its global headquarters in Detroit, GM employs 204,000 people in every major region of the world and does business in some 140 countries. GM and its strategic partners produce cars and trucks in 34 countries, and sell and service these vehicles through the following brands: Buick, Cadillac, Chevrolet, GMC, GM Daewoo, Holden, Opel, Vauxhall and Wuling. GM's largest national market is the United States, followed by China, Brazil, Germany, the United Kingdom, Canada, and Italy.

Chennai, Tamil Nadu, India

Project Name : GM Finance- ODS.Client : General Motors Financials.Organization : Hewlett Packard.Duration : Aug 2013 – Jul 2014Role : Senior ETL Consultant.About Client:General Motors, one of the world's largest automakers, traces its roots back to 1908. With its global headquarters in Detroit, GM employs 204,000 people in every major region of the world and does business in some 140 countries. GM and its strategic partners produce cars and trucks in 34 countries, and sell and service these vehicles through the following brands: Buick, Cadillac, Chevrolet, GMC, GM Daewoo, Holden, Opel, Vauxhall and Wuling. GM's largest national market is the United States, followed by China, Brazil, Germany, the United Kingdom, Canada, and Italy.Project Name : Wolters-Kluwer IMS Transformation-Phase Client : Astellas, United States.Organization : Hewlett Packard.Duration : Sept 2012 – Aug 2013Role : Senior ETL Developer.About Client:Astellas Parma Inc. is a Japanese pharmaceutical company, formed on 1 April 2005 from the merger of Yamanouchi Pharmaceutical Co., Ltd, which is having presence across continents.Project Name : Telstra EDW Transformation.Client : Telstra, Australia.Organization : Hewlett Packard.Duration : May 2009 – Sept 2012Role : Data Analyst.About Client:Telstra is a leading telecommunications and information services company, with one of the best known brands in the country, Australia that provides customers a truly integrated telecommunications experience across fixed line, mobiles, broadband (BigPond®), information, transaction and search (Sensis®) and pay TV (FOXTEL). They offer full range of services and compete in all telecommunications markets throughout Australia, providing more than 9.2 million Australian fixed line and 9.7 million mobile services, including 5.2 million 3G services which makes Telstra Australia’s 3G Market Leader.

Master Of Computer Applications (Mca), Computer Software Engineering

Bachelor Of Science (Bsc), Computer Science