Subba Rao K. Email & Phone Number

• Having around 15+ yrs of Experience in Data warehousing and Data Engineering and Data analytics and Business intelligence, technical program manager, supply chain , finance , banking, pharmaceutical, clinical,!MedTech• Extensive Hands on Experience on Informatica, SSIS , SSRS , Tableau, OWB, OBIEE, ODI, Cloud ETL, Snowflake, AWS Glue, Datastage, Alteryx, Python, Power BI • Extensive expertise in building machine learning models and extracting insights from diverse datasets.• Experience in Oracle Knowledge Analytics with ODI and OBIEE• Data warehousing experience using Oracle Data Integrator & ELT Concepts. • Extensively - worked on Multiple ETL Tools Designer Component Interfaces, Packages, Scenarios ,• Developed and supported Extraction, Loading and Transformation process (ELT) using Oracle Data Integrator ,Informatica , to populate the tables in Enterprise Data Warehouse and Data marts. • Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat Files, Oracle, SQL Server, Redshift • Involved in Control-M Job Scheduling for Production Jobs , • Extensive Experience on web logic clustering and Managed servers and domains.• Working experience in using Oracle 10g/9i/8i, SQL, SQL Plus, PL/SQL, Shell Scripts, Windows XP/2000/98/95, and UNIX.• Developed complex mappings and Interfaces in ODI , informatica , SSIS , Cloud ETL to load the data from various sources into the Data Warehouse, using different transformations like joins, filter, aggregations, lookups, sequence etc. • Worked in Data Modeling using Erwin Data Modeler, hands on experience in forward engineer and reverse engineer and proficient in dimensional modeling . • Developed Slowly Changing Dimension Mappings of type I, II and III. • Extensive experience in implementation of, transformations, Stored Procedures and execution of test plans for loading the data successfully into the targets. • Knowledge in Control-M (Job Scheduler) and OBIEE( Reporting Tool) Specialties: Datawarehousing and Databases, Weblogic,OBIEE,ODI,OWB, AWS, Python , SSIS, SSRS, Tableau, Qlikview, PLSQL , SQL , T-SQL, Oracle , SQL Server , Redshift, Salesforce, Oracle ,Teradata, SAS, EBS,Hive,Presto,snowflake,talend, data analytics, machine learning, Airflow,AWS, Sisense , python, Machine Learning.

Listed skills include Oracle, Data Warehousing, Pl/Sql, Sql, and 30 others.