Venkata D.

Solution Designer & ETL Implementation Specialist

New Delhi , India

Experience: 12 Years

Venkata

New Delhi , India

Solution Designer & ETL Implementation Specialist

27401.1 USD / Year

Immediate: Available

12 Years

Now you can Instantly Chat with Venkata!

Chat Now

About Me

Dear,

I possess over 12 years of experience in the areas of ETL Development, Data Warehouse Projects implementation and support,Performance Tuning, Data Design & Integrity, besides others.

I am current...

I am currently working as Solution Designer in Data warehouse Project implementation, this role requires me play an important role in design solutions and implement them in terms of technical objects like Queries, Tables, interfaces, packages and execution plans to populate dimensions and facts.

A list of accomplishments indicative of my experience includes:

· Implemented major redesign in queries which minimize the ETL execution time to 40 mins (from 110 mins) while extracting the data from source and process data in Data Warehouse in present working project.

· Designed code to preserve references of Customer, Location, Item& Categories in Dimensions and Fact while migrating the Legacy data (Transactions) from Old Data Warehouse to New Data Warehouse referring Source system data and completed data processing (size 1 TB) in 4 hours.

· Migrated data from Legacy Data Warehouse to BI Apps Data Warehouse through Procedures while resolving references of Customers, Locations and Items & associated Categories.

· Performed strategic reconciliation between 2 different systemsin Operational Data Store (ODS) that assisted clients in maintaining proper record of inventory thus improved 432 hours per year for the clients (GE Appliances in 2017)

· Successfully migrated different source systems data (Like Oracle, XML & FlatFile) and integrated in Data warehouse system using Oracle Data integrator.

· Won prestigious Most Valuable Performer Award based on the excellence delivered with respect to ETL Development in implementing the Data Warehouse project using PL/SQL and Materialised viewsin the span of 3 months during 2009 from Sun Microsystems.

Skill Set:

· Primary Skill details: Informatica, Oracle Data Integrator(ODI), Teradata, Oracle, Unix shell scripting

· Secondary Skill details: Ab initio, Power shell scripting, OBIEE, Data Modelling, Team Lead Activities,PL/SQL&taken training on Data Lake (Informatica) in 2016.

Thank you for your time and consideration.

Best Regards,

VENKATA DURGARAOREDDY

Skills

Positions

Project Manager

Backend Developers

Portfolio Projects

Description

Toshiba Global Implementation (TABS) is a migration solution for existing Customized BIAPPS solution with Cognos Data manager as ETL and Cognos Report Builder as Reporting tool. Current new system is a migration project to Oracle BIAPPS solution with Oracle data integrator ETL and OBIEE as Reporting tool. This new Data ware house have the many reports to support the Toshiba manufacturing business. This solution will provide all needs of business users like analysis, reports, performance measurements, forecasting and planning.

Show More Show Less

Description

To capture the Employee Health (EHS) data who works in plants from source system & Work hours from Kronos system (maintained through SQL Server) and load into BI Apps Data warehouse. Integrate with existing objects with EHS data at Employee and Organization level.

Show More Show Less

Description

This project is to build Integrated Data warehouse for consumer baking area in JPMC. Source is Sybase, Flat files and need to capture the data incremental basis and populate ICDW (Integrated Custom Data Warehouse). At present implementing delta extract from Sybase database w.r.t closing desk issues reported by end users. We will receive different SOR’s (System of records) from different source systems and integrate the data while loading into data warehouse

Show More Show Less