Raghu Babu Sodisetti

Summary

Raghu Babu Sodisetti has 10 + years of IT experience as a Data Warehousing consultant. Competent in using ETL tools like Abinitio, Informatica and BI tools like MSTR. Competent in using Oracle, DB2, Teradata, Netezza and Unix technologies.

He is heading and directing the pattern and transport of ETL and information keeping practices to inhabit particular information Data Warehouse. This Data Warehouse assists the plans of actions and performing business concern ability to present the correct information to the correct people at the suitable time.

He works in close association with the business and application teams to produce overall business ambience and other solutions. He works out specialized patterns and moulds the information for storehouse practices.

His educational background includes:

Master of Information Technology (MIT).

Expertise in DW and BI solutions

Expert in ETL architectural implements

ETL Abinitio Server Admin

Expertise in Banking, Life sciences and Telecom domains.

Expertise in Agile and Water fall methods.

Skills

ETL tools : Abinitio, Informatica

BI Tools : Micro Strategy

Operating System : Windows & UNIX.

Database : Oracle 9.1, DB2, TERADATA, NETEZZA.

Scripting : UNIX Shell Scripting

Awards : “STRETCH” Award from Syntel

: “Customer Delight” from Syntel

: “JPMC Champion” Award from JPMC

: “Data Warehouse scope award” from Cognizant.

Experience Summary

Client

Technology

Roles and Responsibilities

Duration (in months)

AMEX

INFORMATICA,ABINITIO,DB2,UNIX, MICRO STRATEGY,CONTROL-M

Technical Lead

Agile Release Cycle Lead

Project Lead

Abinitio Admin Lead

52

IMS

ABINITIO,UNIX,ORACLE10g,MICRO STRATEGY, CYBERMATION

Technical Lead/Team Lead

17

Goldfish–DFS (Discover Financial Services)

ABINITIO,UNIX,TERADATA

Module Lead/Team Lead

10

JPMC

INFORMATICA,ABINITIO,UNIX,ORACLE 9i

Module Lead/Team Lead

15

BRITISH TELECOM

ABINITIO, ORACLE 9i

TEAM MEMBER

9

Kroger Cincinnati

ABINITIO

TEAM MEMBER

8

Krung Thai Bank

ABINITIO

TEAM MEMBER

10

Professional Experience

New Initiatives - 2015

Mar 2015 – On Going

Client : AMEX

DOMAIN: Banking

CEDW – Currency Exchange Data Warehouse

Currency Exchange Data Warehouse aims to provide a global solution, for business reporting capability of Foreign Exchange Service (FES) Business units.

The warehouse will be a single platform built on Mainframe DB2 database that will pull incremental data using Informatica from the INXS DB2 source system on a daily basis (EMEA / JAPA) and extract historical data once from Express Data database in SQL server for the regions EMEA & JAPA and non operational regions like CHANGI.

Currency Exchange Data Warehouse will be the source for all MIS reports generated out of Micro Strategy reporting tool that replaces the existing Cognos reports and cubes.

CLM - Customer Lifecycle Management

The focus of the CLM needs is around providing the card/product reporting summarized to the highest level of customer. EGDW does keep limited data about the customer namely the name and contact information. To meet the needs of CLM, EGDW would need to re-organize concept of customer and differentiate customer metrics by the combinations of accounts they keep. CLM requirements are to slice the customers into the different categories and report on their counts and total usage by each category.

Role: Tech Lead/Release cycle lead/Prod support lead

Team Size: 18

EGDW – Enterprise Growth Data Warehouse

May 2014 – On Going

Client : AMEX

DOMAIN: Banking

SVDW renamed as EGDW to support agile methodology newly introduced in AMEX and moved under Enterprise Growth (EG).

EGDW will retain all the capabilities already existing with SVDW along with new additional capabilities like managing DASHBORDS, KPI’s etc.

ETL Informatica can be used for data fed into detail and summary tables instead of Abinitio ETL.

Enterprise Growth is dedicated to pursuing new forms of payments and digital commerce that open American Express to new customer segments, new geographies across the world, and new products and services. Specifically, this includes growing a digital services platform for American Express, expanding alternative mobile and online payment services, forming new partnerships and building new revenue streams beyond the traditional Card and travel businesses.

Enterprise Growth seeks to leverage the company’s assets and capabilities and build or acquire the talent, businesses and platforms required to deliver new forms of growth in the digital economy.

Key roles:

Agile team member and Tech lead

Architectural Implements

Implementation of 2-week release cycle

Centralization of production support

Post-launch support for the Abinitio to Informatica migration

Role: Tech Lead/Release cycle lead/Prod support lead

Team Size: 18

SVDW – Stored Value Data Warehouse

Jan 2010 – Apr 2014

Client : American Express(AMEX)

DOMAIN: Banking

The Stored Value Data Warehouse (SVDW) is fed directly from production systems (Serve, FIS, Toppan and GPO legacy, etc.). Its function is primarily business performance reporting. Direct access to the Stored Value Warehouse (SVDW) is limited to individuals with the technical skills to create and manage SQL queries. SVDW is also considered a production platform due to the regulatory and legal support.

Several hundred support requests for custom, ad hoc reports are responded to each year. This covers everything from legal & Custom reports are created for a number of products. Other common requests are for licensing/audit responses, product deep dives/spin downs for customer and product reviews and inventory management support.

ETL Abinitio – ETL used to manage over 272 tables of detailed and summarized data fed into SVDW and used to manage multiple hierarchies (Org IDs, FIS client, MAPS, MS Merchant, product categories).

MicroStrategy (MSTR) - MSTR can be used to generate standard reports that have fixed attributes or parameterized versions that allow the user to enter specific criteria, which translates to thousands of variations. MSTR is an enterprise, web-based, front-end reporting tool that relies on SVDW as the data source. It can be pointed at multiple sources.

The most common product report categories are sales, inventory management and redemptions.

Key Projects Handled:

EMV – EMV Contact less

Convergence – Card processor and product integration.

BLUEBIRD – Serve Bluebird

GPO – Serve GPO Integration

FM – Finance Metrics

SID – Student ID

AAA - Membership

SCM – Inventory Management

Role: Project Lead/Abinitio Admin

Team Size: 20 Plus

UDA - Universal Data Acquisition

Feb 2009 –Jan 2010

Client : IMS

Domain : LIFE SCIENCES

The Universal Data Acquisition System provides a single input mechanism for the receipt of all Prescription data. Regardless of channel or format in which data is originally supplied, the UDA System transforms and stores the data in a common format, which then is processed through the a common application suite.

UDA Front End collects information at script level from various suppliers, processes it and loads it into the UDA database. Suppliers are the various organizations which sell medicines and which have the entire details for a particular medicine being sold. These suppliers sell these data to IMS. Each and every supplier has different form of layouts for the data which is being sent to IMS. IMS consolidates these layouts to a general layout called UTR layout for further processing.

Front end system gets the information and populates the Metadata tables. Metadata table is the table where the layouts for the information sent by different suppliers are captured. This is the table where the supplier files will be stored in the supplier format. These layouts can be retrieved and thus we can come to know the different layouts for the different suppliers. Data are supplied as batches or files. All the files will be processed based on the format through reference files. The application builds history based on the Good store, Bad store and also data used to reject or accept a supplier. This is based on minimum of 6 weeks of data. Corresponding reports are generated to display the process of the data and the output.

Role: Project Lead/Team Lead

Team Size: 12 Plus

MAC Financial Applications

Jan 2007 – Mar 2008

Client : JPMC

Domain : BANKING

Marketing and Control (MAC) Financial Application project involves the applications as follows: Monetary Gateway (MG) and Account Maintenance Engine (ACME).

Monetary Gateway (MG) is a standard service to the registered users to provide card member payment posting, address requirements and controls of all functional areas with respect to payment postings. MG will provide a common frame work for handling any ad hoc monetary posting needs quickly and reliably.

Account Maintenance Engine (ACME) is a middleware which process the Non Monetary transactions. In order to establish more control for batch transactions being submitted to the card processor, it was determined that all transactions regardless of point of origination should go through one central processing point i.e. ACME.

Role: Team Lead

Team Size: 5

BT GenIUS

APRIL 2006 – DEC 2006

Client : BRITISH TELECOM

Domain: Telecom

GENEVA Interface is a part of the Geneva Billing Platform of BT, which caters for the billing of some specific products of BT retail and BT whole sale. These interfaces were developed to integrate and customize the Geneva billing system as per the requirements of BT. In most cases they act as bridge between outer systems (e.g. Mediator etc.) and Geneva.

This project consists of enhancements and maintenance of the interfaces. Due to various reasons such as changing business environment, changing technology and new Geneva versions, enhancements (including development of new interfaces) are required from time to time. Maintenance involves addressing the faults and queries raised by the users.

Role: Team Member

Team Size: 2

Kroger Grocery Retailers

AUG 2005 – MAR 2006

Client : Kroger Cincinnati, OH

Domain: RETAIL

The Kroger is one of the nation's largest grocery retailers. The Kroger Company spans many states with store formats that include grocery and multi-department stores, convenience stores and mall jewelry stores. The DSS Sources information from three different data sources PIMS (Product Information Management System), CIMS (Customer Information Management System), and CCAS (Customer Contact Administrative System). This Application provides data of the various product sales in US, and reports were generated on the various product groups, product promotions and market share of competitor’s product group.

Role: Team Member

Team Size: 3

KTB PCL Strategic Management Support System

SEP 2004 – JUNE 2005

Client : Krung Thai Bank (KTB)

Domain: BANKING

The system has been developed to provide clear picture of the strengths of the bank in order to take effective decisions and build good customer relationship. It provides intelligent information to the management regarding its current business situation and thus helps them to understand the trends, performance and customer analysis of the bank. This system can give intelligent reports regarding current business situation and analytical information about the bank business.

Subject areas covered in the warehouse are like

Accounts like Savings bank Account, Current Account, Loan Account and Over Draft Account and Deposits like Fixed Deposits, Recurring Deposit.

Loans like Personal Loan, School Loan, Industrial Loan, and House Loan etc.

Role: Team Member

Team Size: 4

Responsibility:

My responsibilities include:

Agile Release management

Architectural Implements

Quality Process Handling

Business Requirements study

Technical lead

Implementation & Support

Personal info:

Contact id: acqfh1@r.postjobfree.com

Mobile no: 801-***-**** (US)

Contact this candidate