Raghu Kumar Reddy Devireddy

Mobile: +1-713-***-****

Email: ac2wuv@r.postjobfree.com

Summary:

Over nine years of solid experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio.

Proficient in development and implementation of end-to-end, large, business critical projects in various areas of insurance domain – policy, claims, quotes and agency.

Having rich experience in supporting of more than 150 applications for smooth functioning.

Having good experience of migrating the applications from 1.14 to 3.0 version.

Have experience in Leading and mentoring technology and domain skills to small sized teams of 6 – 8 members and giving them the technology and domain proficiency.

Have rich experience of creating source to target mappings on multiple engagements.

Playing the role of Technical Lead in multiple concurrent projects involving resources at different geographical locations.

Have good experience in interfacing high profile clients and co coordinating with offshore team members for delivery services.

Assist management in developing project schedules, resource allocation in project, planning release, developing communication plan

Ability to face new challenges and good problem solving capabilities.

Competitive, highly motivated, enthusiastic learner, team player and initiator.

Trained from Ab Initio Corporation on Continuous Flows, Meta programming, Conduct>IT, Query>IT, Express>IT.

Led teams of size ranging from 5 to 25.

Work Experience

Organization

Designation

Duration

Syntel Ltd.

Technical Lead

August 2012 to till date

Hoch Technologies

Software Engineer

June 2008 to June 2012

Technical Skills

Operating Systems:

Windows, Unix, Linux

DW Tools

Ab-Initio - GDE 1.14,1.15, 3.0,3.1.7.4,3.2

Co>Op - 2.14,2.15,3.0.4

ACE/Express>IT

BRE

Query>IT

Databases

Oracle 9i/10g/11g, DB2

Programming Languages

Unix Shell scripting, C, SQL, PL/SQL

Schedulers

TWS, Control-M

Others

TOAD, SQL Developer, HP QC

Educational Qualification

Degree

College/School

University/Board

Percentage

MCA

Sri Indu College of Engineering & Technology

Jawaharlal Nehru Technological University

74%

Achievements

Consistent recipient of various awards under Syntel categories including SPOT, Value, Acknowledge and Excellence.

Individually increased the performances of long running Abinitio jobs.

PROJECTS

EFDS

Client Name:

American Express (USA)

Domain:

Banking

Team Size:

30

Duration:

August 2015 to till date

Role:

Technical Lead

Project Description:

The current projects includes matching the credit card transaction information with travel and enrichment information and load into different tables based on subject area. The matching happens on multiple algorithms and enrichment happens on matched data.

The ETL is responsible for maintaining the data flows. Adding new data flows and implementing matching and enrichment on the same. We also maintain additional details on each transaction provided by vendors in a different database. Its time sensitive and a challenging project.

Responsibilities:

Development / Unit testing of AB initio code.

Coming up with innovative technological solutions for complex problems involving history updates / retrofits / history loads,

Understand the business of each of the requests give value to the customer.

Scripting Debugging and support for production issues if any.

Ensure Mapping accuracy for a travel data source into ODS.

Coordinate with offshore and ensure the completion of the mappings.

Contact point from the code perspective for any data related issues in the staging layer.

Review the code and make the code free of performance bottle Necks.

Contact point for the onsite team for running the Application in Development in case of any code changes.

EFDS - BTA

Client Name:

American Express (UK)

Domain:

Banking

Team Size:

15

Duration:

July 2016 to July 2017

Role:

Technical Lead

Project Description:

BTA is plastic-less card account lodged in the client travel booking process; usually stored as the Form of Payment in a traveller profile. The traditional booking channel is a travel management company (TMC) however self-booking tools (SBT) and online booking tools (OBT) are becoming more prevalent. BTA can currently be used for all GDS airfares, TMC transaction fees and hotel ‘bill backs’; direct rail, direct car rental and hotel billing are not typically supported, but do occur under some circumstances in some markets.

Responsibilities:

Involved in the project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution.

Involved in design reviews and provide input to the design recommendations, incorporate security requirements into design, and provided input to information/data flow..

Coordinating with all the interfacing system teams.

Participated in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications, identify/troubleshoot application code-related issues, and review and provide feedback to the final user documentation.

Making sure that the code is delivered for QC testing on or before the delivery dates. If required, keeping the clients informed about reasons for variances in schedule or effort.

Implementation and post implementation activities.

Allbridge Agency Pay

Client Name:

Allstate Insurance (USA)

Domain:

Insurance

Team Size:

25

Duration:

June 2014 to July 2015

Role:

Technical Lead

Project Description:

Allbridge Agency Pay program is to implement the technology to support the new compensation model for Agents. Main objective is to build metrics and data to support Agent and Agency analytics at different levels of grain with respect to annual bonus and variable compensation. The system should be built in such a way that it adheres to various data audits and reporting performed at different levels of summarization.

Responsibilities:

Estimating the efforts and timelines for all projects and get a go ahead from clients for project execution.

Involving in low level design creation for various applications and getting the design approved from client Technical Architects, System Analysts and COE team.

Conducting design walkthroughs with onsite and offshore and making sure that the offshore developers are clear with the requirements and design.

Rendering technical help to the team working in multiple concurrent projects.

Conducting reviews for code, unit test plan and unit test results and verifying if all design requirements are met.

Making sure that the code is delivered for QC testing on or before the delivery dates. If required, keeping the clients informed about reasons for variances in schedule or effort.

Facilitating different meetings with multiple teams for daily team meetings, defect prevention, onsite offshore weekly meetings, etc.

ADW(Allstate Corp Data Warehouse) Maintenance

Client Name:

Allstate Insurance (USA)

Domain:

Insurance

Team Size:

18

Duration:

August 2012 to November 2014

Role:

Analyst Programmer

Project Description:

ADW (AllstateCorp Data Warehouse) is an initiative to replicate the mainframe EDW (Enterprise Data Warehouse) ETL system with newer technology, which is more scalable, manageable and cost effective. The current mainframe process is broadly classified as legacy site and central site. For the most part, the ADW systems will be replicating the mainframe central site process. This effort was a step towards retiring the DB2 Enterprise Data Warehouse (EDW) in favor of the newly constructed Oracle based Allcorp Data Warehouse (ADW).

Responsibilities:

Defects Handling

oAnalysis of the defects.

oGetting the analysis approved from the clients.

oMaking the required changes in the Ab-Initio code.

oTesting and Migration of the modified code.

Enhancement to Existing Codes called as Bundle Changes

oEvery month, some new columns will be added to the base target tables.

oNeed to analyze the graphs affected and have to make the necessary changes in all the affected codes like dml, xfr, sql files.

oTesting of the modified objects, both Unit and End to End.

oMigration of the modified code to production.

Supporting more than 150 applications on daily cycles for smooth functioning.

Improved performance of Ab Initio graphs by using various methods.

Schedule job runs using Tiwoli Work Schedular.

Training and KT sessions to new joiners.

Responsible for overall communication and coordination with the internal, DBA, Other Development and TWS teams.

Global CMR

Client Name:

CITIBANK, Singapore

Domain:

Banking

Team Size:

10

Duration:

September 2008 to June 2012

Role:

ETL Developer

Project Description:

Customer Management Repository (CMR) is a consolidated repository of customer-oriented information within Citi. The ultimate goal of CMR is to consolidate all LOB’s customer data and be the single golden source for customer relationships in Citi. It manages detailed information about Customers, as well as

Their Relationships with various product accounts.

Their Relationships to each other,

Their Relationships to various addresses, and phone numbers

Responsibilities:

Developing Transformations & Graphs using Ab-Initio.

Testing the developed applications and releasing them to production team.

Analysis of Existing application and identifying improvements.

Identify Root Causes of issues that arise and provide improvements to remedy them.

Requirements gathering for the project.

Daily interaction with the clients to get the issues/doubts clarified and to convert the business requirements to technical requirements.

Interaction with the offshore team members to keep the project moving.

Conveying the status of project to all the application owners in the status meetings.

Preparing weekly and monthly status reports which was broadcasted to all the affected application members.

Review of the development work.

Preparation of Unit Test Plans.

Making sure that the testing team is comfortable with the code for Integration testing.

Requirements gathering for the project.

Perform root cause analysis and identify and implement corrective and preventive measure

Daily interaction with the clients to get the issues/doubts clarified and to convert the business requirements to technical requirements.

Interaction with the offshore team members to keep the project moving.

Conveying the status of project to all the application owners in the status meetings.

Preparation of Unit Test Plans.

Reference: https://www.linkedin.com/in/raghu-devireddy-929493144

Contact this candidate