Kattunga Durga Srinivas Rao

In this role, I manage the reconciliation process by comparing data between two sources, such as Orbit and Murex. I apply predefined filter conditions to both datasets and create separate files for each leg of the transactions. These files are then uploaded to the DUCO platform, where I oversee the reconciliation process, identify any discrepancies, and ensure accurate resolution. This workflow ensures consistency, accuracy, and compliance throughout the reconciliation process.

Responsibilities:

• Proficient in managing and streamlining reconciliation processes to ensure accurate alignment of financial records.
• Skilled in identifying and resolving discrepancies between internal and external accounts, maintaining compliance with company policies and industry standards.
• Experienced in preparing detailed reconciliation reports, analyzing variances, and implementing corrective actions for improved accuracy.
• Adept at utilizing advanced tools and software for data management and reconciliation tasks, ensuring efficiency and timely completion.
• Strong ability to collaborate across departments to optimize workflows and foster cohesive financial management practices.

CPLA is a project to identify the customer who has living address in Netherlands and making some transaction out side of Netherlands. We are identifying the customers who are making physical transactions (POS+ATM).

Responsibilities:

• ➢ Analyzed the requirements and framed the business logic and implemented it using Datastage.
• ➢ Worked on designing various jobs for extracting data from various sources involving tables and to load the data into target tables.
• Extensively worked in writing the queries into MySQL, which are there in existing legacy system used by the client.
• Worked on improving query performance by keeping the statistics up to date and tuning the converting queries.
• Capable of understanding the client requirements and directly involved in client calls
• Involved in user acceptance testing to identifying the road blocks, which are causing incorrect data in the target system.
• Worked on scheduling the jobs in UAC Scheduler.
• Monitored the daily runs of scheduled jobs, which are developed to load the data into target database.
• Coordinating with various teams to fix the issues that are occurred while monitoring the daily runs.

File Inventory is a Privilege Identify Management Suite that helps to stop the files i.e. if the file is Empty or when the file is duplicated it will reject the file. And also converting the files to secure file transfer by using different methods

Responsibilities:

• Involved in identifying the FTP jobs by using the scripts
• Filling the gap assessments for the identified FTP jobs
• Converting the FTP jobs to Secured File Transfer with different methods.
• Enabling the controls for stopping the Empty and Duplicate files
• By helping to secure the usage of a service account to a specific server/application

CyberArk is a Privilege Identify Management Suite that helps to manage all the privileged account within the organisation with automatic password Management. The tool prevents data against any kind of Cyberark Attack. It has the ability to Secure, Rotate and Control Access to Privileged Account Credential. CyberArk will help fox our issues by managing service accounts and their passwords in the following ways.

Responsibilities:

• Involved in converting different jobs like DB connectivity and FTP to CyberArk .
• Working with different stages like Dataset, Seqentialfile, Oracleconnector and Performed various activities like import and export of Datastage projects
• By providing an 'in service' and 'out service' service account and rotates them without human intervention.
• By rotating the password of a service account without human intervention.
• By helping to secure the usage of a service account to a specific server/application
• Worked in secure room(live date access) for to projects.

Intra Company Fund Transfer This is a Back office application at USAA and this project enables the Bank officers to handle the ledger accounts and missed transactions at members also under this project the scheduled transactions will be handled as per the business requirement.

Responsibilities:

• Involved in designing various jobs for extracting data from various sources like flat files, Oracle DB and to load the data into target tables or files.
• Working with different components like tfileinput, taggregaterow, tunite, tmap and Performed various activities like import and export of Talend projects
• Hands on experience in Analysising ACL script
• Hands on Unit Testing
• Excellent team player with an ability to perform individually, quick learner, ability to meet deadlines and analytical skills
• Skilled at learning new technologies can work well under pressure

Genfare is a leader in providing comprehensive automated fare

collection solutions for transit agencies of all sizes in North America for more than three decades. Genfare has decades of experience with successful fare collection solution implementations to solve even the most complex fare collection challenges. Genfare offers solutions designed for several modes of transportation. The reports available in jasper to Anvizent Dashboard solution. It is a report migration project from Jasper to Anvizent. The main process that is performed in this project is extracting the data from different source systems and transforming that data as per the user requirements and report queries and loading that data into data warehouse i.e. MySQL using Talend. Then Anvizent used to provide Dashboards to business users who use the information to take strategic decisions.

Responsibilities:

• Understand the business requirement as per the client requirement to create the Jobs
• Functional and Technical understanding of the Issues.
• Working with different source like tfileinputdelimited, tMSSqlInput, tMysqlInput and Different target like tMSSqlOutput, tMysqlOutput.
• Developed Jobs using various components like tmap, tjoin, tfilter, taggregator, tsort Involved to designed to the slowly changing dimensions.
• Identified the development error to before moving to UAT Environment ➢ Working with client in meeting and calls.
• Working with Slowly changed dimension –II.
• Involved in unit testing.
• Having motivation to take the independent responsibility as well as ability to ➢ Contribute as a productive team member.