Now you can Instantly Chat with Venkata!
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.
· 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.
Data & Analytics
Toshiba America Business - Data Migration and Business Intelligence project implementation
Project Manager (Team Lead)
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
GE Appliances - Data Integration
Project Manager (Team Lead)
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
JP Morgan - ICDW Implementation
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 warehouseShow More Show Less
SkillsInformatica Sybase Teradata
Saudi Telecom - EDW Implementation Project
This project is to maintain the entire orders, subscribers, and loyalty information
of the Saudi telecom company. Source is Siebel CRM (Oracle) and need to
capturethedata incremental basis and populate the EDW. At present
implementing the SCD for the loyalty programs that are launched by the service
provider to the customers.Show More Show Less