KATARI CHANDRAMOULI
Ph: +1-904-***-**** Email: ************.******@*****.***
Visa Status : H1B, Valid till OCT-2023
Education
Bachelor of Technology in Computer Science and Engineering,
GMR Institute of Technology, JNTUK University, Kakinada, Andhra Pradesh, India, 2009
Experience Summary
Currently working with Tata Consultancy Services.
Previous employers: Virtusa Polaris and Cognizant
Overall 12 years of experience in Information Technology and mainly worked on AbInitio, Unix, PL/SQL, Autosys, Oracle, Teradata and SAP BO.
Involved in Business Requirements gathering and analysis.
Involved in designing system architecture.
Involved in designing data warehouse projects.
Projects
GENESIS
Client Name CITIGROUP TECHNOLOGY INC, U.S.A
Position Abinitio Developer - Sep 2019 To Till Date
Employer Tata Consultancy Services
Project Location Texas, USA
Skills Abinitio, Teradata, EAP, Hive, Unix & 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 extranal 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
Requirements gathering and designing of new enhancements.
Analysing SAS programs and converting them into Abinitio
Distribution of work among the team and tracking the progress.
Analyzed and identified the root causes for critical issues.
CITI Payments Transformation Program
Client Name CITIGROUP TECHNOLOGY INC, U.S.A
Position Abinitio Developer - Jul 2017 To Aug-2019
Employer Tata Consultancy Services
Project Location Florida, USA
Skills Abinitio, XML Processing, Oracle, Teradata, Unix & 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(Minframe) system and GPP(Global Pay+).
Responsibilities
Requirements gathering and designing of new enhancements.
Processing xml them using graphs.
Distribution of work among the team and tracking the progress.
Analyzed and identified the root causes for critical issues.
Prepared Test Plans, Test cases based on the application manuals for the project.
Automation of manual task using UNIX scripting to save time.
CCB (Citi Commercial Banking)
Client Name CITIGROUP TECHNOLOGY INC, U.S.A
Position Abinitio Developer - Since May 2015- June 2017
Employer Tata Consultancy Services
Project Location Hyderabad, India
Skills Abinitio, Teradata, Unix & Autosys
Project Description
Commercial Business Group (CBG) is now one of the major lines of business within Global Consumer Banking and renamed to "Citi Commercial Bank” (CCB). CCB deals with lending business loans and auto loans, mortgage lending, and basic investment products like savings accounts and certificates of deposits. The foundation of Citi Commercial Bank, currently serving approximately 800,000 clients in 32 countries, is strong. CCB continues to demonstrate its ability to grow, while maintaining Basel III risk weighted asset returns above Citi’s benchmarks and improving overall client satisfaction within each region.
Responsibilities
Requirements gathering and designing of new enhancements
Loading data into data warehouse and validating data in dimension and fact tables.
Enhanced the existing application and implemented different functionalities as per business requirements.
Analyzed and identified the root causes for critical issues.
Prepared Test Plans, Test cases based on the application manuals for the project.
Responsible for task assignment and updating of status in the team
Active participation in team work activities
Client Update Factory
Title Client Update Factory
Client Name Express Scripts(ESI), U.S.A
Position Abinitio Developer - Since Jan 2013- May 2015
Employer Cognizant
Project Location Hyderabad, India
Skills Abinitio, DB2, Unix & 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
Requirements gathering and designing of new enhancements
Providing technical solutions to complex problem.
Identifying redundant/ineffective systems and providing solutions to it.
Enhanced the existing application and implemented different functionalities as per business requirements.
Analyzed and identified the root causes for critical issues.
Prepared Test cases based on the application manuals for the project.
Active participation in support of the application
Private Bank Repository
Title Private Bank Repository
Client Name Express Scripts(ESI), U.S.A
Position Abinitio Developer - Since Nov 2009- Jan 2013
Employer Polaris(Virtusa)
Project Location Hyderabad, India
Skills SAP BO, Abinitio, Oracle, Unix & 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
Attending client calls to understand the requirement.
Developing Abinition graphs and testing.
Enhanced the existing application and implemented different functionalities as per business requirements.
Analyzed and identified the root causes for critical issues.
Prepared Test cases based on the application manuals for the project.
Personal Details
Date of Birth Jul, 01st 1987
Sex Male
Nationality Indian
Marital Status Married
Passport Details S1085559