SUMMARY

• Over 7 years of experience in IT implementing full life cycle of Business Intelligence solution with System & Data Analysis, Application Design & Dimensional and Data Modeling with Design, and Documentation with applications on various Versions of UNIX and Windows.
• Experienced in Full Systems Development Life - Cycle Implementation of VariousOBIEE/ETL/ELTProjects.
• Experience in Informatica/ODI 11g, OBIEE 10g/11g/12c, Oracle BI Apps and EIS express Reporting Tool
• Experience in end-to-end implementations of BI solutions for implementing Financials, Supply Chain and Order Management, Procurement and Spend Analytics, Human Capital management.
• Extensive experience in OBIEE Administration Tool, Answers, Interactive Dashboards, BI Publisher, Catalog Manager and Developing Repository (RPD) involving multiple Sources including OLTP, OLAP.
• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer) and setting up Multiuser environment (MUDE) repository
• Expertise in OBIEE/OBIA development and Administration works such as Enterprise Manager and WebLogic console
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables and Performed Cache Management at repository level.
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Installed and Configured the Oracle Data Integrator ODI software tool in a three-tier Environment and performed periodic upgrades, performed source-to-target mappings, storage capacity planning, developing ETL
• Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
• Sound knowledge on knowledge modules like RKM, LKM, CKM, IKM, and JKM.
• Good knowledge on ODI Administration tasks and experience in creating master and work repository in the initial set up of the environment.
• Knowledge on creating ODI procedures to create and populate in target systems.
• Worked on slowly changing dimensions SCD, Change data capture CDC as part of data warehousing concepts.
• Having good experience on Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Experience using Informatica 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Expertise in developing Informatica Mappings using various Transformations (Filter, Expressions, Router, Aggregative, Lookups, Update Strategy) and in creating Workflows.
• Good knowledge about EIS express Reporting and their Plug-in tools like XL Connect and GL Connect
• Experience in designing Data model i.e. Star Schemas/Snow Flake Schemas.
• Extensive knowledge in all phases of Software Development Life Cycle SDLC Requirement Analysis, Design, Development, Testing and Documentation. Exposure to version tracking control systems.
• Excellent interpersonal and communication skills for efficient client interaction.
• Extensive experience on Oracle Data Integrator ODI Development and Administration.
• Extensively worked on Bulk Data Integrations in different environments using Informatica and ODI .
• OBIEE Implementation and configuration specialist and extensive experience as OBIEE and ODI Consultant.
• Developed the Oracle BIEE Metadata repository .rpd model
• Exclusively worked on OBIEE Administration Physical, Business Model Mapping, and Presentation Layers, Answers, Dashboards, Catalog Manager.
• Experience in various domains like Finance, Procurement and spend, HCM and supply chain Management

TECHNICAL SKILLS

Languages: C, C++, PL/SQL, Java

Databases: Oracle 12c/11g/ 10g/9i/8i, DB-2, MS-Access, SQL Server, EBS

Database Clients: Oracle SQL Developer, Toad 12.8.0.49/8. x/9.x.

Reporting Tools: OBIEE 12c (12.2.1.0.0 )/11g (11.1.1.7.1 )/10.1.3.x, OBIA Apps 7.9.6.3, BI Publisher, EIS express Reporting, Oracle EPM 11.1, Crystal Reports 8X.

ETL/ELT Tools: ODI 11g/Informatica Power Center/Mart 5.x/6.x/7.x/8.x, DAC 10.1.3.4

Operating Systems: Windows-XP/7/NT/98/2000/Server 2003, UNIX, LINUX, MS-DOS

Web Technologies: HTML, XML, Java Script, VB Script, ASP, Shell

PROFESSIONAL EXPERIENCE

Confidential - Ashburn, VA

OBIEE/ODI Consultant

Responsibilities:

• Involved in multiple projects like, Financials, Procurement and Spend, Projects and Grants, HCM (Human Capital management).
• Involved in Upgrading OBIEE from 11g (11.1.1.7.1 ) to 12c (12.2.1.0.0 ) and Migrating ETL tool from Informatica to ODI 11g
• Primary responsibility include 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
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications in the development.
• Analyzing Functional documents, identifying the GAP's, designed Reporting Technical Specification documents.
• Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
• Responsible for developing OBIEE11g repository (RPD) from the scratch.
• Implemented a Multi-User Development Environment (MUD) utilizing projects.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Worked on Visual Analyzer in OBIEE12c, created Reports in Financial module and trained Users.
• Developed Time Series Objects using Ago, Period Rolling and To Date functions for time series comparisons.
• Designed Security at object level and data level using Repository Variables, Initialization Blocks, and Session Variables and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
• Designed and developed various Interactive dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector, gauge, Master detail Linking etc. and various report prompts, Dashboard prompts. Filters, Graphs, charts etc.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Coordinated the RPD and Web Catalog objects migration from DEV, QA to Production environment.
• Created various templates, reports, and prompts in BI Publisher.
• Worked towards the Performance Tuning of Dashboards and Reports with Database Administrators.
• Implemented caching and aggregate table techniques to improve the performance.
• Analyze and fix the production problems reported by the users and Trained End Users to Build Ad Hoc Reports using OBIEE Involved in implementing EIS express Reporting integrated with Oracle E-Business Suite for Financials and HCM Transactional/Real Time Reports.
• Worked on EIS Reporting plug in Tools like XL Connect and GL Connect

Environment: OBIEE- 11.1.1.7/12.2.1.0.0 , OBIA 11.1.1.10.1 , Oracle DB 11g/12c, SQL Plus, Oracle SQL Developer, Informatica Power Center 9.5.1, DAC/ODI 11g, EIS express Reporting Tool.

Confidential - Houston, TX

OBIEE/ETL Consultant

Responsibilities:

• Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
• Worked with OBIA RPD, making use of the existing physical/logical objects, creating reports based on pre- built RPD.
• Translated Business requirements into technical requirements.
• Created Dashboard prompts and advanced filter criteria.
• Created new connection pools for different data sources and designed from the scratch (physical, business model and presentation).
• Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports).
• Implemented various Repository Variables and System Variables depending up on user requirements.
• Fixed many OOB issues. Created major and important dashboards like Customer Profitability from the scratch including
• Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy.
• Administered MUD rpd, reviewed developers' rpd development before merging into MUD server.
• Designed and developed complicated/complex reports.
• Worked on developing BI Publisher reports/Templates based on User Requirement.
• Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Worked on INFORMATICA Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: OBIEE-11.1.1.7, Oracle BI Apps, BI Publisher Oracle DB 11g, SQL Plus, Oracle SQL Developer, Informatica Power Center 8.6, DAC.

Confidential - Los Angeles, CA

OBIEE Developer

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering business requirements and understood the current requirements and Data Analysis.
• Involved in designing the dimensional model for Equity Commission project as per the reporting requirements by using the Microsoft Visio.
• Prepared Technical Requirement documentation based on reporting requirements.
• Designed and Developed OBIEE Repository.
• Worked extensively on OBIEE Repository and Dashboards.
• Created number of Complex measures and Logical columns in BMM Layer as per business requirements by using Different Time Series functions like Ago, Todate and other Business logics.
• Created lot of dynamic repository variables and Initialization Blocks for different purpose.
• Extensively working on Merging and Migration of RPD and Catalog to higher environment on a weekly basis.
• Implemented the Security by creating the Users, Groups, Web Groups and Web Catalog
• Implemented external tables for Authentications and Authorization by using VPD.
• Performed Unit testing to validate report and fixed the issues opened by QA and BA team.
• Resolved Post Upgrade RPD Consistency check issues and fixed all the issues related to reports and dashboard after the upgrade in 11g.
• Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.
• Modified default Configuration settings in NQSconfig.INI by using the Enterprise Manager and added new tags in instanceconfig.INI files as per OBIEE 10g configuration files.

Environment: OBIEE 11.1.1.5, Informatica 8.6.1, Oracle10g, Microsoft Visio, SQL Developer, Linux and Windows XP.

Confidential, Richmond, Virginia

OBIEE Developer

Responsibilities:

• Analyze business requirements and translate them into technical design solutions.
• Involved in Migration of all existing Dashboard and Reports developed in Hyperion system to OBIEE10g.
• Extensively worked on Hyperion Data Models/ Queries, detailed Reports, Pivots and Dashboards.
• Development, Implementations, Documentations of Data Warehouse / Data Marts deployments, and Business Intelligence solutions.
• Worked closely with the ETL team to determine the granularity and figure out the facts and dimensions.
• Building executive Performance Management Systems using OBIEE interactive Dashboards.
• Configured Analytics Reports, dashboards, web catalog and the RPD using OBIEE Administration tool 10.1.
• Developed Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic / Interactive Dashboards with drill-down capabilities.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• OBIEE Admin work: New Id creation, Account modification of existing users, Password reset and deletion of accounts.
• Created materialized views and aggregates to improve performance.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Business Model to support Adhoc Reports for User Access based on Requirements.
• Configured Presentation layer used by different User Groups and established various standard queries, in order to support the presentation layer.
• Involved in the logical and physical models of the warehouse.
• Performed unit testing, integration testing on the deliverables to analyze the errors and fix them.

Environment: OBIEE 10.1.3.4.1 , Oracle10g/9i, Oracle EPM 11.1(Hyperion Interactive Reporting), DAC, Informatica 8.6.0, SQL, PL/SQL, Toad, Unix Shell Scripts, Windows and AIX.