SUMMARY:

• Ten Plus (10+) years of experience in Implementing Enterprise Business Intelligence Solutions, BI Architecture, Data Warehouses, Data Processes, Data Integration, Data Modeling, OLAP and OLTP Concepts.
• Developing Complex Reports and Dashboards using OBIEE, BI Publisher, Oracle Data Visualizer, and Tableau.
• Expertise in Design and Development of Metadata Repository (RPD) using Oracle BI Administration Tool.
• Created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Setting up Object and Data Level Security by creating Users/Groups/Application Roles and LDAP Authentication setup.
• Performing Client/Server Installations, Setup, Configuration and Upgrades of OBIEE.
• Worked extensively on Dashboards for the Oracle Financial Analytics modules.
• Worked extensively on OBIEE components like Oracle Enterprise Manager and WebLogic Server Administration Console.
• Extensively worked on Extract, Transformation and Loading data from Multiple Sources to Data Warehouse using ODI (Oracle Data Integrator) and Informatica.
• Data Warehouse Architecture using Ralph Kimball and Inmon’s Dimensional Modeling.
• Created workflows with Worklets and Sessions, Scheduled and Modified using DAC and workflow monitor.
• Expertise in customizing Noetix Views/Analytics.
• Implementing and Managing Large Oracle Data Warehouse solutions, with near real time Data refresh.
• Implementing Automated Data Reconciliation checks from Source to Reporting Data Warehouses to ensure Data Accuracy.
• Creating Conformed Dimensions to be leveraged across enterprise reporting for Data Consistency.
• Conducting Data Validations and Analysis by Creating Complex SQL, Hyperion Smartview and Excel Formulas.
• Performing Regression Testing and Coaching Business users to perform User Acceptance Testing to ensure Accuracy.
• Coordinating Complex BI/Data Warehouse Deployments.
• Experience in Requirement Analysis, JAD sessions, RCA session Business and Systems reviews and working sessions to understand the requirements and system design.
• Excellent analytical, problem solving and communication skills with ability to be an effective team member.
• Team Collaboration, Coaching and Mentoring Team members.

TECHNICAL SKILLS:

Database: Oracle Database, MS SQL Server, DB2, Teradata, Hyperion Essbase

BI Tools: OBIEE, Tableau, BI Publisher, Oracle Data Visualizer, Power BI, R Studo

ETL Tools: ODI, Informatica

Tools: /Languages: Oracle SQL Data Modeler, Toad, Advance SQL, PL/SQL, Java, HTML, CSS

PROFESSIONAL EXPERIENCE:

Confidential, IL

BI/ETL Developer

• Extract data from custom and EBS systems, transformed and loaded into the OBIEE analytics warehouse using ODI.
• Create ODI Interfaces using different transformation logics and migrate data from flat files/legacy to oracle data base.
• Create PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Migrate ODI objects from DEV to UAT/PROD.
• Design Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Define Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Create Star Schema, Time Series Objects, Hierarchies, Level Based Measures.
• Create Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Define application roles in Enterprise Manager to control access on OBIEE reports and dashboards.
• Prepare detail deployment documentation to migrate OBIEE objects from DEV to UAT/PROD.
• Design and develop tolerance reports for data consistency between source and target.
• Prepare test cases in HPE ALM for unit testing.
• Interact with SME’s, Business Analysts and Users for gathering and analyzing the Business Reports Requirements.

Environment: OBIEE 12.2.1.4/12.2.1.3 , Oracle 12c/11g, ODI 12.1.3, Toad, UNIX, Oracle Streams, Oracle applications 11i

Confidential, MD

BI Apps Consultant

• Extracted the data from Hyperion cubes, Oracle, MS SQL Server, transformed the data and loaded into the OBIEE analytics warehouse using ODI.
• Design and Develop end to end BI solution for Budget and Acquisition Planning Applications.
• Created complex reports and dashboards for FDA Executive’s and CFO’s.
• Created Aggregation Facts, Dimension hierarchies, Time comparisons, level-based measures and Share measures along with ranks in RPD.
• Designed and developed object/data level security.
• Applied patches for OBIEE in UNIX environment.
• Worked with ODI Graphical (Designer, Topology Manager, and Operator) & Knowledge Modules (Reverse-engineering, Loading, Check, Integration).
• Customized the ODI Knowledge Modules for efficient data loading.
• Installed and configured WebTier with OBIEE for authentication and authorization.
• Configured OAM and OID with OBIEE to enable SSO.
• Created API for real time data syncing between applications.
• Designed and developed Hyperion Essbase Calc Scripts to export data from Hyperion Applications to OBIEE Data Warehouse.
• Performed ad-hoc data analyses using Hyperion Smartview.
• Gathered requirements from the client for GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Conducted meeting with project managers, business users during testing and deployment stage of the application development life cycle.

Environment: OBIEE 12.2.1.4/12.2.1.1 , Oracle 12c/11g, ODI 11.1.1.9, Toad, UNIX, Windows 2012 R2

Confidential, MD

BI Apps Consultant

• Extracted the data from the custom and EBS 11i system, transformed and loaded into the OBIEE analytics warehouse using Informatica and DAC.
• Customized Purchase Orders, General Ledger, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports in OBIEE.
• Developed and debugged many intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic/Interactive Dashboards with drill-down capabilities using global and local Filters.
• Created the physical and complex joins in the Physical and Business layers.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Improved Performance by tuning the ETL sessions and mappings.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Modified prebuilt ETL mappings (AP, PO and GL) to bring the custom attributes.
• Involved in cache management, performance tuning, data and object security.
• Created custom subject areas, tasks and execution plans in DAC.
• Upgraded OBIEE from 11.1.1.6.6 to 11.1.1.7.150120 in UNIX environment.
• Conducted JAD sessions to gain clarity and finalize business requirements.

Environment: Oracle Applications 11i (AR, AP, GL), Oracle 11g, OBIEE 11.1.1.6.6/11.1.1.7.150120 , OBIA 7.9.6.3, Informatica 9.1, DAC 10.1.3.4, UNIX, Toad

Confidential, TX

OBIEE Developer

• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, Informatica and DAC and the required connectivity for seamless integration with the data warehouse.
• Extracted the data from the source system EBS R12, transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Implemented security by creating users & groups, setting up External Table Authentication.
• Migrated Discoverer reports to OBIEE using Noetix views (for transactional reporting).
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures.
• Worked with Catalog Manager to migrate Web Catalog among Instances.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse.
• Implemented security using LDAP authentication in WebLogic administrator console.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Developed and debugged many intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic/Interactive Dashboards with drill-down capabilities using global and local Filters.
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Developed many complex Full/Incremental Informatica Objects (Workflows / Sessions, Mappings/mapplets) with various transformations.
• Imported and Exported Execution Plan in DAC from one Instance to another Instance.
• Managed test cycles around defects and test cases in HP Quality Center.
• Documented and track defects, as well as produce detailed reports using HP Quality Center.
• Conducted JAD sessions to gain clarity and finalize business requirements.
• Conducted meeting with project managers, business users during testing and deployment stage of the application development life cycle.

Environment: Oracle Applications R12 (GL, AR, AP, OM, PO), Oracle BI Publisher, OBIEE 11g, OBIA 7.9.6.3, Oracle 11g, Informatica 9.0.1, DAC, SQL*Loader, Unix, TOAD

Confidential, WI

OBIEE Consultant

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Defined Connection Pools to the Source Data warehouse tables in the Physical Layer.
• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Implemented Financial Analytics, Supply Chain and Order Management Analytics.
• Created Presentation catalogs/Subject Areas for Sales and Month End Account measures.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Merged repositories and migrated to multiple servers.
• Created production builds and getting approvals from senior management.
• Enhanced performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Created the physical and complex joins in the Physical and Business layers.
• Created Aliases and defined Role-Playing Dimensions.
• Created Repository Groups and Web Groups and assigned users to configure security in OBIEE.
• Worked on Dashboard and Page level prompts and Report filters.
• Involved in performance tuning by enabling the cache to improve the query performance.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse (SIL mappings).
• Worked on application services such as web server functionality, business components and access to back end enterprise systems by using WebLogic server.

Environment: Oracle Applications 11i (AR, AP, GL, OM, INV, SCM), Oracle 10g, OBIEE 10.1.3.4.2 , OBIA 7.9.6.2, SQL*Loader, UNIX, Informatica 8.6.1, DAC, Discoverer 10g, TOAD, UNIX Shell Scripting

Confidential

OBIEE developer

• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• OBIEE Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching).
• Created the physical and complex joins in the Physical and Business layers.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels.
• Defined Session variables in the repository to populate the current date filters.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse (SIL mappings).
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Modified several Customized Reports like Credit/Debit Memo Report, Invoice History, and Invoice.

Environment: Oracle 10g, EBS 11i, OBIEE 10.1.3.4.1 , OBIA 7.9.6, Informatica 8.1.1, SQL Loader, TOAD, Windows NT, UNIX

Confidential

Oracle Technical Consultant

• Worked as part of the Reports Development team.
• Designed and developed Actual Income Budget Statement, Cumulative Balance Sheet and Budget/Actual Report, Income Statement with Variance, Cumulative Balance Sheet and Income Statement Consolidated report.
• Developed various Mailing list reports and Form letter reports using Reports 6i.
• Customized Supplier Paid Invoice History Report, Supplier Merge Report, Supplier Audit Report, Chart of Account Detail Listing Report and Supplier Payment History Report in Account Payables using Oracle Reports 6i.
• Created new custom reports in XML/BI publisher, upgraded Standard 6i reports to XML/BI publisher reports.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages developed.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
• Created required shell scripts for secured FTP with error handling capability.
• Developed design and implementation documents such as MD050, MD070, MD120, Unit Test scripts and user-documentation.

Environment: Oracle Applications 10.7 Account Payables, Account Receivables, Order Management, Inventory, Purchase Order, General Ledger, Oracle 9i, Unix, Reports 6i, Forms 6i, SQL*Loader, TOAD, UNIX Shell Scripting