Description
* About 12 years of IT experience in various Oracle Business Analytics and Data integration tools such as ODI, OWB and OBIEE * Experienced in dimensional and relational data modeling using star and snowflake schemas, OLTP/OLAP system, Fact and Dimension tables, Conceptual, Logical and Physical data modeling * Extensive experience of working in all phases of Project life cycle such as requirement gathering, design, development, testing, production support and enhancements * Good experience in designing data warehouse and DataMart * Expertise in creating ODI development objects- procedure, user function, sequences * Good experience on ODI and database performance tuning * Worked extensively in developing ODI business objects- interfaces, packages, scenarios, Load plans, CDCs, Knowledge modules according to various business scenarios * Good knowledge of Data Marts, Operational Data Store (ODS), Dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Services * Proficient working experience in SQL, PL/SQL, stored procedures, functions, packages, DB triggers and indexes * Abilities in administering & migrating ODI and database objects and providing technical support for business applications * An effective communicator with good interpersonal, problem solving and analytical skills Skills Summary Domain Manufacturing, Telecom, Health-Care, Utilities, Logistics, Banking, Supply Chain Domain Manufacturing, Telecom, Health-Care, Utilities, Logistics, Banking, Supply Chain
Accomplishments
Highlights:
Job Skills
Keywords
