SUMMARY

• Senior IT professional with over Ten years of experience in Business Intelligence, OBIEE(11.1.1.7), OBIA(7.9.6.4), OBIA ( 11.1.1.7.1 ), Data warehousing, Informatica, ODI, WebLogic, ODI(10g/11g), DAC, implementation and support of Oracle Databases 7x - 12c and Oracle E-Business Suite R 12, 11i and 11.0.3
• Extensive experience in gathering requirements, documentation, analysis, design and development in an enterprise warehouse environment
• Technical competence in implementation of RPD and reports using OBIEE ( 10g/11g/12c ) /Siebel Analytics/ BI Publisher
• Enabled key design decisions by performing proof of concepts to explore several out of the box OBIEE 11g features and explored ease of customizations to meet the requirements
• Expertise with slider charts, KPI’s, collapsible hierarchies and scorecards
• In-depth knowledge of the overall architecture of OBIEE (10g/11g/12c)
• In-depth knowledge of data modeling using star schema and snow flake schema
• Experience and knowledge in setting up Clustering, Load Sharing/Balance Multiuser Development (MUD), Security and Repository Management.
• Experience in installing and configuring Data Warehouse Administration
• Console (DAC), Web Logic Server and OBIA 7.9.6.3/OBIEE 11.1.1.6.5/ Informatica 9.0.1 interface with oracle ERP R12, PeopleSoft and Sales Force.
• Hands on experience Oracle Data Integrator(ODI 11.1.1.7)
• Experience in configuring and generate Load Plans using BI Application Configuration Manager (BIACM).
• Migrated OBIEE 11g Version 11.1.1.7.0 to 11.1.1.7.1
• Migrated Informatica 8.6 to 9.0.1 on Linux and Windows.
• Extensive expertise using Informatica, Web Logic Server, ODI and other ETL technologies in an Enterprise Warehouse environment
• Performed in various capacities including technical architect, techno-functional lead, technical lead, and technical consultant.
• Experienced in leading on-site and offshore development teams and provides the team with functional and technical expertise
• Knowledge of Tableau Reporting tool.
• Develop and execute activities related to end-to-end project management
• Very much involved in project plans and estimates, scoping and requirements

TECHNICAL EXPERTISE

Data Warehouse: Oracle Data Integrator(10g/11g), Informatica(9.0.1) and DAC

Business Intelligence: Oracle Business Intelligence Enterprise Edition (10g/11g) and OBIA (7.9.6.3)

Oracle Applications: E-Business Suite R12, 11i, 11.0.3, and 10.7SC

Software Tools and Programming Languages: PL/SQL, Oracle Developer (Forms and Reports builder), Oracle Discoverer, Oracle Workflow, SQL*Loader, SQL*Plus, ADI, OEM, Shell Programming, ODI - Oracle Data Integrator, OBIEE and Informatica.

Databases: Oracle 7.x / 8i / 9i / 10g/ 11g/12c

Operating Systems: Windows, UNIX, Linux.

PROFESSIONAL EXPERIENCE

BI Architect

Responsibilities:

• Major changes made to Prebuild Repository (.RPD) physical, logical and presentation sections as required by business - replaced legacy source system with E-Business Suite R12.
• Created new database schema objects for new enterprise warehouse with HR and Sales Bookings.
• Documented all changes to EDW for removal of legacy systems with E-Business Suite R12.
• Migration of RPD and Catalog from Develop to QA and UAT instances.
• Modified reports using XML editor to accommodate new presentation layer.

BI Architect

Responsibilities:

• My primary responsibilities BI design and lead offshore ETL technical team.
• Project implementing by Accenture in OBIA ( 11.1.1.7.1 ) with using PeopleSoft Source System.
• Collected requirements as per business needs and Prepared Techno Functional documentation and implementing custom mappings per business requirement.
• Worked on new ELT mappings and customizations existing ELT Mappings in ODI
• Hands on experience of ODI 11.1.1.7.1
• Designed Data Model and Build Custom Fact and Dimension tables for HR, AR Deposits and Payments of VDOT
• Customized Time and Labor, Accruals - Extended Absence, Headcount Gain & Loss HR Analytics Subject Areas.
• Very much involved in project plans and estimates, scoping and requirements .

­

BI Architect

Responsibilities:

• My primary responsibilities are modifications existing ETL Mappings, DAC in OBIA 7.9.6.4 with OBIEE 11g and DAC11g.
• Also involved in develop and execute activities related to end-to-end project management.
• Did customizations to about 100 Informatica ETL Mappings, developed about 40 incremental and Deletion mappings.
• Above new Mappings/Tasks are added in new Subject Areas in DAC and modified logical folders for customized Mappings/Tasks.
• Installed OBIA in windows and Linux Servers.
• Changes made to Prebuild Repository (.RPD) physical, logical and presentation sections to add above customization.
• Migrated Informatica 8.6 to 9.0.1 (part of OBIA 7.9.6.4)
• Migration of ETL and DAC code from Develop to QA and UAT instances
• Migrated OBIEE 11g Version 11.1.1.7.0 to 11.1.1.7.1 on Development and Prod Windows Server as a separate project.
• Part of Security, created Application Roles, Applications Profiles, added Data and Object level securities using Enterprise Manager/WebLogic and BI Admin tool.

OBIA Consultant / BI Architect

Responsibilities:

• This project (BI Apps 7.9.6.3) is implementing by a local private company.
• My primary responsibilities are modifications and enhancements to existing RPD, ETL Mappings, DAC, Analyses and Dashboards.
• Did customization of Informatica ETL Mappings and DAC.
• Changes made to Prebuild Repository(.RPD) physical, logical and presentation sections
• Added Fiscal Calendar Dimension to Sales Booking Lines Fact
• Migration of RPD and Catalog from Develop to QA and UAT instances.
• Security: Data and Object Level - Added new users, groups in WebLogic server.

Created new Application Roles in EM and added new Catalog Groups

OBIA Sr. Developer / BI Architect

Responsibilities:

• This project (BI Apps 7.9.6.3) is implementing by Oracle Corporation.
• New requirements gathering from users and provide Analysis and Design documents by track. Documents should be approved by Change Control Board before development.
• My primary responsibilities are modifications and enhancements to existing Analyses and Dashboards.
• Adding new DFF’s and KFF’s to existing prebuild analytics belongs to Accounts Payables, Accounts Receivables and Projects to Invoice (P2I), Enterprise Asset Maintenance (EAM) and HR Analytics.
• Configuration changes to prebuild Group Account Names/Number thru flat files using ETL
• Changes made to Prebuild Repository(.RPD) physical, logical and presentation sections
• Migration of RPD and Catalog from Develop to Testing and Production instances.

BI Architect

Responsibilities:

• This is short term comprehensive project handled independently start to finish.
• Reviewed all existing Financial Reports (Budget, Revenue, Expenditure and Projects) build in Cognos with backend Informix database.
• Installed OBIEE 11g (11.1.1.6.0 ) in Windows Server and applied 11.1.1.6.5 patch.
• Web Logic server installed and configured, Users and Group created using web logic security.
• Created Application Roles, Applications Profiles using Enterprise Manager.
• Designed and Developed Physical, BMM and Presentation layers of brand new Metadata repository (.RPD)
• Authored the Techno-functional specifications document for City team approval
• Designed the overall Finance dashboard and developed alone without anyone’s help
• Developed number analyses using Pivot, Graphs, Column and View selector
• Implemented data and object level securities
• Configured LDAP authentication for 50 users and groups using Application Roles
• Used extensively SQL, PL/SQL to get OBIEE Analyses performance improvement
• Created Views and Materialized Views in Oracle Database connecting to Informix.

BI Architect

Responsibilities:

• Involved in requirement gathering to understand the business problem areas
• Key participant in evaluating / reviewing the BRD from an IT perspective
• Authored the Techno-functional specifications document for stake holder approval
• Co - architected the overall data and reporting solution
• Participated in the LDM and PDM sessions in the capacity of an IT lead to facilitate the IT solution for the necessary business problems
• Spearheaded the BI team responsible for the delivery of the analytic solution provisioning using OBIEE 11g
• Co-designed the overall dashboard design and solution for the Order management dashboard
• Provided solutions in user and data level security implementation
• Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model as per the reporting requirements using OBIEE Admin and Web tool
• Explored and developed reports using BI Publisher for executive reporting

Sr. BI Consultant

Responsibilities:

• Successfully upgraded the OBIEE 10g application to OBIEE 11g (11.1.5)
• Responsible for the end to end installation and configuration of Oracle 11g
• Worked with Oracle support to resolve several product version related issues.
• Recommended and modified the data model to overcome the technical challenges due the changes in 11g architecture
• Solved several upgrade related issues in both RPD and reports
• Involved in upgrading BI publisher reports
• Interacted with server administration, QA, development teams for the resolving several critical upgrade related issues

BI Tech Lead

Responsibilities:

• Developed Metadata repository (.rpd), configured metadata the Business Model
• Layer & Physical Data Model as per the reporting requirements using OBIEE Admin and Web tool.
• Configured Clustering, Load Balance and Multiuser Development (MUD).
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector.
• Administered security and created alerts.
• Created templates for presenting results and Analytics and modified the OBIEE Dashboard using cascading style sheets.
• Involved in Reconciliation Process while testing loaded data with user reports.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Working with Offshore and Onsite ETL Teams. Gather Production requirements/changes from onsite and share and executing with offshore team.

Sr. BI Consultant

Responsibilities:

• Analyze Design, and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Developed and debugged many 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. Extensively used Delivers, iBots and BI Publisher
• Developed many complex Initial/Incremental Informatica Objects (Workflows / Sessions, Mappings/ Mapplets with various transformations i.e., expressions, aggregators, filters, lookup, stored procedures transformations, join, normalize, filter, router, sorter and update strategy).
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
• Implemented the delivery of iBots using Siebel Delivers to alert the associated teams.
• Performed Unit testing, Integration testing, and Regression testing to validate report and mapping functionality.
• Responsible for Functional Design Document.
• Interact with Users during User Acceptance Testing (UAT).
• Manages detail design efforts based on agreed requirements/scope.
• Closely adheres and works towards milestones on development.
• Develop the repositories keeping in view best practices/methods from vendor.
• Responsible for deliverables needed for vendor review and/or any internal technical reviews.
• Help testing team with test scripts, defects resolution, etc.

Sr BI Consultant

Responsibilities:

• Gathered business & functional requirements and translated them into technical requirements
• Responsible for overall Datamart architecture, Business models and Reporting needs.
• Designed staging areas for multiple sources of data from Oracle Applications 11i, Agile Flat Files and external Customer enterprise systems.
• Installed and configured Oracle Data Integrator 10g with Master and Work Repository.
• Developed more than hundred ETL Interface using ODI.
• Used extensively Oracle SQL and PL/SQL in Oracle Data Integrator (ODI)
• Used Oracle and Text file Knowledge modules in ODI Interfaces.
• Used Full and Incremental interfaces in ODI.
• Created and configured ODI scheduler Agent for Scheduling process.
• Used extensively ODI variables for Input file names.
• Interface Error handling and automated notifications.
• Installed and configured Oracle Business Intelligence (OBIEE 10.1.3.4) software.
• Created and configured Repositories (RPD) using the Oracle Business Intelligence Administration Tool.
• Developed number of Reports, Dashboards using Answers per Business Requirement.
• Developed Supply Chain, BOM, Inventory and Procurement dashboards and Answers.

BI Consultant

Responsibilities:

• Installed and configured Oracle Data Integrator, Oracle Business Intelligence (OBIEE) software.
• Designed staging areas for multiple sources of data from Oracle Applications R12 and external Forecast system.
• Developed ETL Interface using ODI.
• Used Oracle SQL and PL/SQL in Oracle Data Integrator (ODI)
• Used Oracle and Text file Knowledge modules in ODI Interfaces.
• Developed Full and Incremental ETL interfaces in ODI.
• Configured ODI scheduler Agent for Scheduling.
• Used extensively ODI variables for Input file names.
• Built ETL interfaces to transfer data from Source to Targets, mappings, error handling and automation.
• Participated in design, development, testing and implementation of the data warehouse applications.
• Extensive ETL development experience and Informatics ETL tool utilization.
• Ensured completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements.
• Collaborated with business users and development team to design, develop and implement data warehousing projects.
• Developed number of Reports, Dashboards using Answers per Business Requirement
• Developed Sales, Forecast and Inventory dashboards and Answers.

Confidential, Los Altos, CA

BI Consultant

Responsibilities:

• Created technical design documents BI Projects
• Developed RPD’s in Siebel Analytics/OBIEE for Manufacturing and Sales Projects
• Developed, modified, maintained and supported dashboards, reports in OBIEE
• Installed and configured Oracle Data Integrator/Sunopsis, Oracle Business Intelligence (OBIEE) software.
• Developed ETL Interface using ODI/Sunopsis.
• Used Oracle SQL and PL/SQL in Oracle Data Integrator (ODI)
• Used Oracle and Text file Knowledge modules in ODI Interfaces.
• Developed Full and Incremental ETL interfaces in ODI.
• Implemented the security architecture of Siebel Analytics/OBIEE Role/Access based user management Reports / Dashboards
• Managing Project teams to customize ERP Applications, New Applications Design & Development in Java.