Raveendra R.

Retails Health Care Business consist of multiple modules/applications with SAP, Mainframe, SQL Server primary technologies. It primarily involves the SAP, maintenance and support of the following applications: REAL, OAIM, SDB, PDB, Web Application.

Data Warehouse Application is used tracking Sales and Marketing purposes for Automobile giants like Honda,Subaru and Mazda. The Application is capable of sending Service Reminders and Special Campaign offers. Responsibilities: • Analyzing LDM and Business Logic • Analyzing Requirements ( Source Queries , Requirement Docs) • Creation ETL Codes ( Projects,Packages,Work Flows , Data Flows , Variables , Error Handling , connections (OLEDB,ADO,EXCEL)) • Used Transforms – Data Conversion, Derived Column ,Look Up, Row Count ,Sort ,Union ALL ,Fuzzy Lookup ,Cache Transform ,OLEDB Source & Destination, ADO NET Source & Destination, Excel Source & Destination • Worked both on Initial Loads and Incremental Loads • Involved in UAT • Updating TCD( Test Case Documents) • Interacting with the Client whenever required • Updating of documents after completion of each ETL Code • Helping the team members technically whenever required • Attending the Sprint retrospective Meeting and Sprint planning Meeting