SUMMARY

• IT Professional with around 5 years in Oracle Business Intelligence Application Development, Oracle Data Integration Deployment and Support, involved in all stages of the application development life cycle.
• Expertise in buildingFinancial Budgeting and Forecasting, EPM and OLAP, ETL applications with Hyperion planning.
• Extensively worked with large Databases in Development, Testing and Production environments.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling
• Extensive experience in writing advanced Oracle PL/SQL programs by using Collections, Records, Objects, Packages, API's, Procedures and Functions.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Good experience in BI Reporting tool.
• Interacted with BI team to understand the report requirements.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Oracle Data Integrator (ODI) reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Primary responsibility include but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three - tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Good knowledge on RDBMS concepts. Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Very good understanding of Business Intelligence and Data Warehousing Concepts with emphasis on Analytical Reports and ETL.
• Expertise in Essbase cube analysis, design and maintenance, Essbase database administration upgrades, performance tuning and optimization.
• Skilled in automation, optimization and performance tuning of Essbase application data metadata processing.
• Experience in dynamically building dimensions, Attributes using Rule files and loading Fact Data in an Essbase application by means of several build methods such as Generation, Level and Parent child references.
• Experience with preparing the High level and Low Level Design Documents.
• Proficient in creation of Oracle Data Integrator (ODI) objects and tailoring knowledge modules (KMs)to suit ETL data movements.
• Expertise in loading data using Oracle Data Integrator (ODI), and Outline Load Utility and Essbase Rule File.
• Complete understanding of Database Design Life Cycle.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work / project environment.

TECHNICAL SKILLS

ETL Tools (ETL): Oracle Data Integrator (ODI)11.x, Financial Management 11.1.1.x/9.x/4.x, OLAP 11.x

Reporting Tools: OBIEE 11.1.1.7, Financial Reports, Excel Spreadsheet Add-in, Hyperion Smart view, SSRS, SQR

Databases: Oracle 9i/10g/11i, SQL Server 2000/2005/2008.

Dimensional Modeling: Star-schema Modeling, Snow-flake Modeling, Fact and Dimension Tables, Physical and Logical data Modeling.

Programming Languages: C, SQL, PL/SQL, T-SQL, Java Script

Operating Systems: Windows 2003/2008/2012 , UNIX.

PROFESSIONAL EXPERIENCE

Confidential - WI

Sr. ODI Consultant

Responsibilities:

• Involved in the installation of Oracle Data Integrator 11.1.1.7 on server and client and built the ODI architecture accordingly.
• Worked with data from Flat files (*.csv), connected to Cubes and Planning Connections according to the requirement.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
• Developed various ODI interfaces to load data from Flat file & Relational Sources to Oracle Data Mart.
• Worked on BI Dashboards and Reports.
• Extensively worked with BI Development team to identify Dimension and Fact tables.
• Implemented calculation engine that includes robust mathematical functions for computing derived data, used Essbase functions & Calculation commands to develop the Calc scripts deriving managing costs, increasing revenues & markdowns.
• Updated the Planning environment with member and formula changes and designed, developed, and implemented enhancements to existing products
• Developed various ODI packages and Scenarios to load data into Essbase applications.
• Utilized Oracle Data Integrator (ODI) to create packages, interfaces, procedures, scenarios and load plans that assisted in moving data from raw sources to normalized entities to dimensions
• Created ODI Sequences and Data sequences and implemented them in the ODI process.
• Wrote calculation scripts or business rules to perform cost allocation based on different drivers.
• Improved the performance of the financial reporting by making necessary changes in the Workflows while recreating them in ODI.
• Performed knowledge transfer to the financial users regarding how to use data forms for the budgeting and workflow process.
• Worked in the entire phase environment DEV, TEST, QA, and PROD, also involved in PROD support if any issue arises.
• Coordinated with my team for migrating Essbase cubes and reports from Development environment to Functional and UAT environment.

Environment: ODI11.x, Oracle 11g, TOAD for SQL Server 4.5.0.854, OBIEE 11.1.1.7, PeopleSoft EPM, Windows Server

Confidential - Jacksonville, FL

Sr. ODI Developer

Responsibilities:

• Build an efficient data marts and train members for support.
• Worked with financial users to understand the functionality and to identify the outline structure to build a cube.
• Loaded monthly actual and forecasting data into Fin plan application and load FTE’S, and pay grades into workforce application. created ODI agent and monitored the daily update loads
• Utilized Oracle Data Integrator (ODI) to create packages, interfaces, procedures, scenarios and load plans that assisted in moving data from raw sources to normalized entities to dimensions
• Created ODI Sequences and Data sequences and implemented them in the ODI process.
• Wrote calculation scripts or business rules to perform cost allocation based on different drivers.
• Closely worked with OBIEE Team to create new reports.
• Performed knowledge transfer to the financial users regarding how to use data forms for the budgeting and workflow process.
• Participated in meetings with financial users and IT Department if any issues arise regarding ODI
• Work on the 3-Year Projection Model.

Environment: ODI 11.x, OBI 11.x Oracle 11g, Toad, Oracle EBS 11.x, DB2, Informatica, UNIX, MS Excel 2010

Confidential - Kansas City, MO

Sr. ODI Developer/Administrator

Responsibilities:

• Involved in gathering business and functional requirements from detailed business meetings and converted them into design specification documents.
• Installation and Configuration of the Development server consisting Oracle Data Integrator ODI
• Configured Data Sources through ODI Topology.
• Wrote calculation scripts or business rules to perform cost allocation based on different drivers.
• Created Users, Groups, Filters and assigned different levels of Security Access to users.
• Worked on OBIEE reporting tool.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management.
• Participated in Optimization of the ODI by analyzing and modifying various aspects such as reduce data flows between different servers, configuration, modifying member storage properties etc.
• Created and scheduled Batch Scripts for complete automation processes for application refresh and backup.
• Helped IT team with database backups, migrate applications from test to production server, and synchronize both environments.

Environment: Oracle 11g, OBIEE 11g, ODI 11.1.1.5, Linux, Hyperion DRM 11.1.2.1, Essbase, Planning

Confidential - Atlanta, GA

ODI Consultant

Responsibilities:

• Loaded monthly actual and forecasting data into Fin plan application and load FTE’S, and pay grades into workforce application.
• Maintain security by creating, managing, and assigning provisions to the users in the shared services.
• Wrote several SQL Scripts to perform automation and load data, export data, and execute calculations as necessary.
• Helped IT team with database backups, migrate applications from test to production server, and synchronize both environments along with installation and configuration of ODI and ERPI.
• Span drives whenever there is a disk space issue and conduct performance tuning to increase performance.
• Participated in meetings with financial users and IT Department if any issues arise regarding Hyperion.
• Work on the 3-Year Projection Model.
• Created UAT Scripts closed worked together in creating Training Manual.

Environment: ODI, OBIEE 10.1.3.4.X, Oracle 10g, Windows Server 2003, PL/SQL, SQL*Plus, TOAD, Informatica 7.1.