Candidates About

Tarun Rathod

Experience Summary

Experienced IT Analyst with around 6 years of experience, including 3 years as a Team lead. Experienced in Oracle SQL and ETL- IBM Datastage development with knowledge of UNIX, Autosys, PL/SQL and COGNOS (Query Studio and Report Studio). Experienced in Data Analysis. Developed ADHOC Reports with critical timelines. Experienced in leading and managing offshore/onshore team. Ability to work independently and in team.

Technical Skills

·                        Oracle SQL Developer

·                        ETL –IBM Datastage Developer

·                        Data manipulation and reporting in Microsoft Excel

·                        IBM COGNOS (Query Studio and Report Studio)

·                        Exposure of PL/SQL, Unix Shell Scripting, Autosys , Microsoft Access

·                        Operating Systems: Windows, Unix, Mainframe operating system- z/OS

·                        Databases: Oracle 10g , 11g and DB2

·                        Software used

o   Toad for SQL,PL/SQL development 

o   IBM Datastage Server 8.5,8.7,9.1 and 11.5 for ETL development

o   putty for Unix Shell Script development

Certification

·         R Programming by Johns Hopkins University on Coursera. Certificate earned at May 31, 2017

Experience

Tata Consultancy Services Pvt Ltd                  

Client: Vantiv, now Worldpay

Project:  Enterprise Data Warehouse Support                                                   (May 2018 – present) 

Responsibilities:

1.       Interfacing with the business users of the system, gathering and analyzing business requirements, and providing appropriate solutions. Interacting with users daily for any kind of issues and their proper resolution.

2.       Providing daily reports to users and understanding the requirements related to application changes. Informing customers of any updates in the form of mail or in status calls.

3.       Supporting and supervising critical applications based on IBM info sphere data stage. Tuning of application components for better performance. Maintaining and configuring of production, staging, and development environments.

4.       Performing daily/weekly/monthly activities based on the requests from the users.

5.       Providing robust reporting capabilities for billing reports to customers and metrics reports to management.

6.       Studying the existing process and providing suggestions for process improvement which would benefit the system and process.

7.       Working in concurrence with development teams for the implementation of new changes and ensuring the successful validation of existing production system.

8.       Moving changes to production for fulfilling business requirements or for enhancing system performance.

9.       Ensuring changes are moved to the system with minimal impact to services.

10.    Preparing application overview documents and known error databases.

11.    Participating in the bridge/incident calls for critical issues and documenting incident write-up, root causes, and lessons learned.

Client: Bank of America – Merrill Lynch

Project:  Client and Account Data - ADHOC Reporting                                         (Apr 2015 – Apr 2018)      

Responsibilities:

1) Manage ADHOC report requests which received through emails and HP QC Portal from business/legal/other teams

2) Analyse and understand the report requirement and work with requestor/Data Governance/Solution Architect team to clarify any concerns

3) Assign and involve responsible teams to develop ADHOC reports and manage them to complete the request

5) Develop SQL/ETL code and deliver the report in critical timeline

6) Work as Team lead and manage the onshore and offshore team by assigning work and solving their technical and business issues

7) Present report to requestor/Data Governance teams through meeting/email

8) Solve technical, business or data related issues raised by Data Governance teams

9) Enhance ADHOC reporting process to make reporting more easier for the requestor and teams involved in the process

10) Create and manage documentation for each ADHOC request and Knowledge Transfer documents 

11) Provide and maintain weekly/on-demand status reports to management team

12) Developing non-funded critical projects which involves design and development of database table/index, SQL/ETL Code and COGNOS reporting as a value add for the team

  Client: Bank of America – Merrill Lynch

Project:  Client and Account Data -Data Quality, Analysis and Reporting                            (Jun 2012 – Mar 2015)                                                

Responsibilities:

A)   Project Development:

1)       Understand project requirement and develop Low level Design

2)       Design and develop database table/index, ETL,  SQL , COGNOS and Autosys job as per project requirement

3)       Unit testing of the code

4)       Work with testing team and fix defect in the code

5)       Provide support to solve production issues on the projects whenever needed

6)       Optimize code and performance improvements of Oracle –SQL and ETL

B)   Data Analysing:

1) Analyse and report production data issues and give strategic and tactical solutions.

2) Help Solution Architect team in requirement analysing for the project

C)   ADHOC Reporting:

1) Manage ADHOC report requests which received through emails and HP QC Portal from business/legal/other teams

2) Analyse and understand the report requirement and work with requestor/Data Governance/Solution Architect team to clarify any concerns

3) Assign and involve responsible teams to develop ADHOC reports and manage them to complete the request

5) Develop SQL/ETL code and deliver the report in critical timeline

6) Work as Team lead and manage the onshore and offshore team by assigning work and solving their technical and business issues

        7) Present report to requestor/Data Governance teams through meeting/email

Education