SUMMARY:

• Over fifteen years of experience in all phases of scope, design, development, and implementation of Business Intelligence applications.
• Experience managing fast - paced and dynamic projects in a highly organized manner while remaining on schedule and within budget guidelines.
• Adept at facilitating sessions defining business user requirements, developing and delivering end-user training, creating and maintaining project schedules, and preparing and presenting project briefings to executives.
• Experience in leading and influencing initiatives to address knowledge gaps and translate complicated, abstract issues into clear insights.
• Expertise using various BI tools like OBIEE, OBIA, Daily Business Intelligence (DBI), Business Objects, BRIO and Tableau.
• Implemented executive reporting solutions in Financials, Purchasing, Projects, Sales, Supply Chain, Inventory and HR applications.
• Strong interpersonal skills with expertise in translating business requirements into working system and report design.
• Also have sound functional and technical knowledge in Oracle E-Business Suite, Siebel and Salesforce.com applications.

TECHNICAL SKILLS:

• OBIEE and Tableau
• Oracle Financials
• Human Resources
• Service & Service Contracts
• Procurement & Spend
• Order Management & Sales
• Supply Chain
• Oracle E-Business Suite
• Service Now
• Salesforce.com
• Siebel CRM
• Daily Business Intelligence
• Business Objects
• Workday
• OBIEE
• Tableau
• BRIO
• Business Objects
• Html
• Java
• C
• Data Modeling and Architecture
• Oracle (9i, 10g, 11g)
• PL/SQL
• SQL
• DAC
• JDBC
• Agile
• Scrum and Six Sigma
• Waterfall
• CMMI
• ITIL

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI Business Analyst

Responsibilities:

• Work involved preparing BRDs and FDs based on requirements, as part of the deliverables.
• Built Service Now dashboards in Tableau to measure key metrics for Incidents and demand management.
• Validated and identified data issues in production using SQL scripts
• Work closely with business to drive UAT and test cycles.
• Reviewed business requirements and detail project plans with Stakeholders and provide regular status reports to management.
• Built new finance reports and dashboards using OBIEE 11g and Oracle data warehouse.

Confidential

Senior Business Systems Analyst

Responsibilities:

• Worked on Cost of Non Quality and Cost Reduction Roadmap BI projects as part of Operational Excellence program.
• Translated high-level and detailed business requirements from Oracle EBS into concrete BI solutions that address all facets of the organizational business intelligence needs.
• Worked in fixing issues in existing Tableau reports using desktop client.
• Created a dashboard for Operational Excellence in Tableau
• Engaged with Business to capture business requirements, conducted CRP/UAT sessions, prepared training material and trained end users on OBIEE.
• Collaborated and worked closely with the development and delivery teams (both onsite and off-shore teams) in designing robust and scalable BI and Analytics solution.
• Partnered with business program manager and increased User adoption of the BI dashboards by conducting surveys and providing on going training sessions.
• Supported enhancements and production issues for BI reporting across supply chain, finance and OM in Brio and OBIEE tools.
• Created and managed incidents, Change Requests in Service Now and generated Quarterly Service Now reports.
• Worked on SFDC.com customizations, to modify standard objects like Accounts, Contacts, Opportunities, Products, Price books, Cases, and Leads as required.
• Worked closely with Business to identify and address SOX requirements for key reports.

Confidential

Senior Project Lead

Responsibilities:

• Worked closely with Business users on BI requirements across Service Operations, Channel Sales, Procurement, Financials and HR. Created Business Requirement Documents (BRD)
• Design of dashboards in Oracle Business Intelligence Applications (OBIA), Preparing presentations and Demonstrating BI functionality to mid and senior level management.
• Was involved in leading development efforts to customize and extend Oracle BI applications based on Business requirements.
• Worked on production support issues with Tableau reports for Sales.
• Worked in integrating various external data sources into the data warehouse like Market Development Fund, Point of Sale(POS), Business plan Analytics(PRM) and Salesforce.
• Created and maintained functional specification documentation (FSD) for customization and maintenance actions taken. Prepared test cases and assisted business in performing thorough testing.
• Customized page layouts for Salesforce standard objects and created custom tabs and dashboards with WAVE for manager’s home page and provided access for authorized users.
• Integrated OBIEE dashboard pages within Salesforce application.
• Prepared training road map plan and provided training and support to Business users. Conceptualized and worked on online training modules for business.

Confidential

Senior Principal Consultant

Responsibilities:

• Implemented Oracle BI reporting solutions in Financials, Purchasing, Projects, Sales, Supply Chain, Service, EAM, Inventory and HR modules of the Oracle E-Business suite.
• Worked in defining user requirements, creating and maintaining project schedules, preparing and presenting project briefings to executives, developing and delivering end-user training.
• Implemented various Oracle BI tools for clients including DBI, OBIEE, BI Publisher, and Oracle Discoverer. Following are a few project listed:

Confidential, Toronto, CA

Responsibilities:

• Implemented Oracle Business Intelligence Applications (OBIA) for Financials.
• Setup Oracle Business Intelligence Enterprise Edition(OBIEE), Informatica and DAC client for Financial Analytics dashboards for Oracle E-Business suite.
• Configured Informatica services as required for setting up the data warehouse repository.
• Configured and setup the DAC client with required parameters and created execution plans for Initial and incremental load programs.
• Worked in setting up fusion intelligence for Oracle CRM modules including Service, Field Service, Email Center and Service Contracts.
• Work also involved in debugging load errors encountered in the DW repository.

Confidential

Senior OBIEE Consultant

Responsibilities:

• Implemented Oracle Business Intelligence Applications (OBIA 7.9.6) for Financials, Supply Chain, Projects and Service modules.
• Setup Oracle Business Intelligence Enterprise Edition(OBIEE), Informatica and DAC client for Oracle E-Business suite.
• Work included integrating Oracle OBIEE with Oracle E-Business Suite Single sign on, for application security.

Confidential, Santa Clara, CA

Oracle BI Solutioning Team

Responsibilities:

• Implemented Oracle Daily Business Intelligence (DBI 7.3) for Customer Support Field Service, Projects, Procurement, Financials and Service Contracts. Troubleshooted load failures and other issues.
• As Part of Solutioning team, analyzed client requirements and proposed best solutions in Oracle reporting tools - Discoverer10g, BI Publisher and Oracle BI Analytics (OBIEE 10.1.3.x).
• Was involved with integrating Oracle OBIEE with the Oracle E-Business Suite for Fusion Intelligence out of the box dashboards
• Setup LDAP security model in the metadata repository for user access to OBIEE.
• Reviewed functional specifications for reports prior to development effort
• Managed cross functional team dependencies and helped resolve issues and blockers
• Attended CCB Meetings for approvals

Confidential, San Jose, CA

Responsibilities:

• Implemented Oracle Daily Business Intelligence for Projects Intelligence.
• Worked in setting up OBIEE reports and dashboards using Oracle Answers.
• Created new dimensions and facts in the data warehouse to pull in additional data from the Oracle EBS instance.
• Was involved in building new reports in OBIEE using BI Answers and BI Publisher.
• Gave presentations and product demonstrations for various Oracle BI tools.
• Analyzed client requirements for custom development and proposed appropriate solutions.

Confidential, Raliegh, NC

Responsibilities:

• Implemented DBI for Financials as a part of the Fusion Intelligence poc.
• Enabled the out of the box DBI content in e-business suite.
• Also setup and enabled OBIEE reporting for procurement, payables subject areas.
• Worked in building OBIEE reports and dashboards using Oracle Answers.
• Worked on enabling Oracle EBS security to OBIEE layer through Oracle Single Sign-On.
• Demonstrated OBIEE dashboards to the users and the out of the box DBI content for GL, Payables and Procurement.

Confidential, Elko, NV

Responsibilities:

• Was involved in the implementation of Oracle Daily Business Intelligence for Enterprise Asset Management (EAM), Procurement, Payables and Inventory modules.
• Created items and product categories needed for setting up item dimension.
• Setup commodities and purchasing categories for the Commodity dashboards.
• Assigned commodity managers to the required commodities.
• Enabled Inventory Organization access to the inventory management dashboards.
• Created Organization hierarchy for Operating Units. Created security profiles for restricted security access to the Purchasing dashboards.

Confidential, Houston

Responsibilities:

• Implemented Oracle Daily Business Intelligence (DBI 7.3) for Financials and Payables Modules.
• Reviewed Prerequisites and patches needed for the client.
• Setup Hierarchies in GL for Financial Dimensions.
• Debugged issues with Line of Business.
• Setup cost center organizations as needed for manager reporting.
• Delegated Roles and privileges to Stanford Managers to access DBI pages.
• Scoped out work for additional customization related to Location security as per user requirements
• Provided documentation and training to Users for DBI.

Confidential, Baltimore

Responsibilities:

• Implemented Oracle Daily Business Intelligence (DBI 7.2) for Financials and Payables Modules, set up DBI pages
• Reviewed Prerequisites and obtained User Requirements to meet reporting needs
• Mapped GL segments to DBI. Setup parent-child hierarchy for basic dimensions like Cost Center, Financial category and Line of Business using FDHM
• Work involved synchronizing HR Organizations with GL Company cost centers. Assigned cost center managers for all the GL company cost centers
• Setup parent-child hierarchy for basic dimensions like Cost Center, Financial category and Line of Business
• Setup Security profiles for operating unit hierarchy
• Ran Concurrent Programs to load Data into summary tables
• Trained users, prepared documentation and performed knowledge transfer

Confidential, Boston, MA

Responsibilities:

• Implemented Oracle Daily Business Intelligence (DBI 7.2) for Financials and Payables.
• Reviewed Prerequisites and obtained User Requirements to meet reporting needs
• Mapped GL segments to Financial Dimensions. Setup parent-child hierarchy for basic dimensions like Cost Center, Financial category and Line of Business using FDHM.
• Setup Security profiles for operating unit hierarchy, Created company cost center organizations and associated with Manager hierarchy.
• Troubleshooted Performance issues.
• Explored customization and extensibility with DBI designer and Discoverer.
• Trained users, prepared documentation and performed knowledge transfer.

Confidential, San Jose, CA

Oracle DBI Implementation

Responsibilities:

• Implemented and maintained Oracle Daily Business Intelligence modules (DBI 7.1) as part of the Oracle 11i upgrade.
• Involved in DBI setups for pages related to Procurement and Supply chain modules.
• Involved in Page customizations for DBI pages including Order Management and Inventory Management, using DBI administrator.
• Generated consolidated request sets for DBI and ran requests for Initial and Incremental refresh. Also scheduled Incremental refresh to run periodically.
• Involved in providing functional enhancements to existing DBI modules. Created Custom Discoverer folders for new workbooks and enabled the workbooks using Web Discoverer 4i, for access through single sign on.

Confidential, FL

Responsibilities:

• Implemented and maintained Oracle Daily Business Intelligence modules (DBI 7.1) as part of the Oracle 11i upgrade.
• Created Custom Discoverer folders for new workbooks and enabled the workbooks using Web Discoverer 4i, for access through single sign on.
• Involved in DBI setups for pages related to Procurement, Payables and Supply chain.
• Work also involved in synchronizing HR Organizations with GL Company cost centers. Also assigned cost center managers for all the GL company cost centers.
• Involved in Page customizations for DBI pages including Financials and Inventory Management, using DBI administrator.
• Defined Operating Unit security setup for AP (payables), Set up Budgets and Forecasts.
• Generated consolidated request sets for DBI and ran requests for Initial and Incremental refresh. Also scheduled Incremental refresh to run periodically.
• Involved in Page customizations for DBI pages including Financials and Inventory Management, using DBI administrator.
• Involved in providing functional enhancements to existing DBI Financial module

Confidential, Los Angeles

Responsibilities:

• Worked on setting up key components for Oracle applications for Oracle Human resource and Contracts Modules.
• Also setup Business Intelligence components for these applications for Analysis and reporting using Discoverer 4i. Discoverer 4.1.48 Client was used to enable Oracle 11i BIS seeded EUL.
• Used Oracle APIs to customize look and feel of application suite and Business Intelligence Reporting.
• Used Oracle Forms to setup profiles and user responsibilities.
• Customized Front-end pages using Oracle Application Framework.
• Ran Concurrent program Loads to pull in data from the OLTP transaction tables.