Ab Initio Data Integration

Chandramouli Katari

************.******@*****.*** +1-904-***-**** LinkedIn ID

VISA STATUS H1-B with approved I-140

Current Location: Henrico, VA

DOB: July-01-1987

EDUCATION

GMR Institute of Technology Rajam, Vizianagaram, INDIA

BTech in Computer Science and Engineering GPA 6.7 Apr-2005 To May-2009

SKILLS

Technical: Ab Initio (PDL, EME, Conduct>IT, Express>IT, MDE, Control Centre, ICFF, Continuous Flows, Bit Vectors, Metaprogramming, Vectors), Oracle, Teradata, MS SQL Server, Informatica, Unix Scripting, Python, Autosys, Hadoop, Hive, PySpark, SAP BO, MongoDB, Nettezza, IBM MQ, Kafka, AWS (S3, Glue, Redshift, lambda)

PROFESSIONAL SUMMARY 14 Years of experience

Experienced Ab Initio developer with 14 years of hands-on experience in building and maintaining complex data pipelines and transformations with batch and continuous mode. Expertise includes utilizing Ab Initio's parallel processing capabilities, performance tuning, and troubleshooting. Proven ability to translate business needs into technical specifications and deliver high-quality, reliable data integration solutions.

WORK EXPERIENCE

Employer- Randstad Digital Client – WellsFargo

Senior Ab Initio Developer Sep 2022 To Till date

Skills – Ab Initio, Conduct>IT, Operational Console, Python, Teradata, Oracle, MS SQL, Unix scripting, Autosys

Project: Consumer Lending Real Estate Technology Database

CLRTY(Consumer Lending Real Estate Technology Database) was developed as a 2013 initiative that consolidated Home Lending Credit Risk data into one, controlled environment reducing the proliferation of user defined data processes and mitigating associated data quality challenges. CLRTY contains deep historical data with originations data dating back to 1990 and servicing data dating back to 2004. Provides quarterly refreshed credit bureau and property value estimates to monitor customer credit profile.

Responsibilities:

Design, codes, tests. Debug and document programs using Agile development practices.

Data integration, data modelling, database design, data warehousing or related; developing, testing, implementing ETL solutions using Ab Initio software.

Translates advanced technology experience, an in-depth knowledge of the organizations tactical and strategic business objectives, the enterprise technological environment, the organization structure, and strategic technological opportunities and requirements into technical engineering solutions.

Responsible for being an expert resource for architects in the development of target architectures to ensure that they can be properly designed and implemented.

Write ETL code within deadlines to deliver project on scheduled timelines.

Maintains knowledge of industry best practices and new technologies and recommends innovations that enhance operations and/or provide a competitive advantage to the organization

Provides expert counsel to senior technology leadership and advises and mentor others with the goal of knowledge transfer.

Employer- TATA Consultancy Services Client – Citi Bank

Senior Ab Initio Developer Sep 2019 To Sep 2022

Skills – Ab Initio, Teradata Bteq, Python, Hadoop, Hive, Unix scripting, Autosys

Project Description

Genesis is a central data warehouse build for providing an overview on the assert/liability positions for the wholesale and retail business of Citi at various levels across Citi, which are used for external regulatory reporting. The data is currently used by risk, compliance, finance and regulatory teams. Genesis holds complete global data of all products, regions (NAM, APAC, EMEA & APAC) and LOB’s and delivers a common pool of contracts, balances and positions at various levels. It has a common structure of tables used across all LOB’s (deposits, personal loans, cards, mortgage)

Responsibilities:

Involved in requirement gathering, design and development of data warehouse applications.

Worked on Extraction, Transformation and Loading data from sources to destination according to the business requirements.

As a senior Ab-initio developer, responsible for delivering the code on-time by coordinating with others teammates, providing suggestions if they face any issues.

Developed complex Ab-Initio Graphs based on the mapping and business requirements.

Developed Teradata BTEQs for table loading/deleting/updating data in tables.

Worked on processing huge volumes of data using Ab-Initio graphs and implemented partitioning techniques/lookups to improve the performance.

Implanted Ab-Initio Plans to create structural dependencies between multiple graphs and used send-mail component to notify final status of the process.

Created process to extract data from bigdata Hive tables.

Involved in unit testing and debugging the process.

Involved in implementing job scheduling script using Autosys.

Involved in implementing unix shell scripts reconciliation/email notifications/file copy-over.

Involved build/deploy the application to different server/environment.

Employer- TATA Consultancy Services Client – Citi Bank

Senior Ab Initio Developer Sep 2015 to Sep 2019

Skills – Ab Initio CF, IBM MQ, Kafaka, MDH, Express>IT, Oracle, XML processing, Unix scripting, Autosys

Project Description

Citi Payments Transformation Program’s objective is to migrate the current payments and collections services to a centralized payments hub. This will be accomplished by replacing the Unisys Legacy systems to a state-of-the-art payments hub platform using a middleware working as the enterprise service bus connecting to legacy systems and global initiatives.

Here Abinitio will be working as a FML(Financial Messaging Layer). It will be acting as a communication layer between Unisys(Mainframe) system and GPP(Global Pay+).

Responsibilities:

Involved in requirement gathering, design and development of ETL applications.

Worked on Extracting Mainframe data, Transformation and convert it into xlm data according to the business requirements.

As a senior Ab-initio developer, responsible for delivering the code on-time by coordinating with others teammates, providing suggestions if they face any issues.

Developed complex Ab-Initio Graphs and plans based on the mapping and business requirements.

Worked on processing huge volnumber of files using Ab-Initio graphs.

Implanted Ab-Initio Plans to create structural dependencies between multiple graphs and used send-mail component to notify final status of the process.

Involved in unit testing and debugging the process

Involved in implementing job scheduling script using Autosys.

Involved in implementing unix shell scripts reconciliation/email notifications/file copy over. Involved build/deploy the application to different server/environment.

Employer- Cognizant Technologies Client – Express Scripts

Ab Initio Developer Jan 2013 to May 2015

Skills – Ab Initio, Teradata Bteq, Hadoop, Hive, Unix scripting, Autosys

Project Description

This is migration project, as ESI(West) (Express Scripts) acquired Medco(East) Pharmacy Benefit Management (PBM) organization, the different client data is migrating from West to East future 14 box(Db2) database, so that all the Medco client could be synch with ESI in future all the data could be access with single system.

Responsibilities:

Involved in design and development of data migration applications.

Worked on Extraction, Transformation and Loading data from sources to destination according to the business requirements.

Developed Ab-Initio Graphs based on the mapping and business requirements.

Used latest Ab-Initio techniques like PDL and metaprogramming to remove the dependency on Unix shell scripting.

Worked on Ab-Initio write excel component to produce xlsx reports based on business user specifications.

Worked on processing huge volumes of data using Ab-Initio graphs and implemented partitioning techniques to improve the performance.

Implanted Ab-Initio Plans to create structural dependencies between multiple graphs and used send-mail component to notify final status of the process.

Involved in unit testing and debugging the process.

Involved build/deploy the application to different server/environment.

Employer- Virtusa Client – Citi Bank

ETL Developer Nov 2009 to Sep 2013

Skills – Ab Initio, Oracle, Unix scripting, SAP BO, Autosys

Project Description:

For compliance with Basel II accord (for credit risk) Citigroup Private Bank (CPB) needs to capture information from its various credit and finance systems. This information is stored in the GWM repository, which was designed and created as part of this project. This repository is used to capture data from different source systems. The captured data will be enriched and reconciled. Provide feed to various upstream systems and act as a repository to the data for generating reports that are used by the source and target systems. GWM system is processing approximately 5,00,000 of records every month.

Responsibilities:

Involved in design and development of data warehouse applications.

Worked on Extraction, Transformation and Loading data from sources to stating and staging to target according to the business requirements.

Developed Ab-Initio Graphs based on the mapping and business requirements.

Worked on improving the performance of the Ab-Initio graphs by using AB-Initio performance techniques.

Developed unix shell scripts to trigger email notifications in-case of any failures and sending process summary notifications.

Involved in unit testing and debugging the process. Involved building/deploy the applications to different server/environments.

Contact this candidate