Professional Profile

• I am having 8 years 4 months of IT experience in Consulting, Project Management, BI Practice Operations, Project Lead/Team Lead, Functional, Implementation, Production support Developer roles for Oracle Business Intelligence Applications OBIA/OBIEE .
• I have been part of End to End implementations, BI 10g to 11g Upgrades, Oracle EBS Upgrade Value Assessment Study, Support Engagements, SDLCs and Transition of OBIEE Suite from On-Premise to Hosting Environments for various customers across the globe: US, UK India.

Professional Summary

• Over 8 years of experience in the IT industry primarily working and managing DWH/BI engagements across diverse business environments.
• Skilled communicator with interpersonal relationship management skill. Possess significant experience ability to work in multicultural environment.
• Hands on experience on OBIEE 11g/10g, Oracle11i/R12 ERP, ETL Informatica, DAC, Interfaces, Discoverer 4i/10g, Report 6i/10g and BI Publisher.
• Good Functional and Technical knowledge on EBS and BI Applications 7.9.6.4.
• Having hands on experience in Design and Develop BI Metadata .rpd and Reports and Dashboards using OBIEE/Siebel Analytics.
• Proficient in generating OBIEE reports using Oracle Answers, Dashboards.
• Lead and participate in gathering business requirements, analysis of source systems, and define underlying data sources and transformation requirements and Business Intelligence Reporting using OBIEE 11g.
• Good exposer on translate the business requirements and source system understanding into a dimensional data model.
• Proficient in Technical and Functional Specifications, design suitable Analytical Reporting.
• Worked with the source system analysts to understand the source data entities, data and process flow and their potential use for reporting and decision making.
• Proficient in the source to target mapping documents and ETL code to load data from source to target warehouse.
• Excellent ability to troubleshoot and debug an issues, conduct root cause analysis and resolve the issues within SLA.
• Excellent technical and functional debugging and problem solving capabilities and easy grasping of new things.
• Provided technical / user documentation and training and perform peer reviews of work items produced at various stages of the project.
• Involved in designing calls with source systems, clients and with other business partners.
• Good experience is maintaining the versioning and deployment instruction documents while moving the code to various environments.
• Extensively worked with production support team to resolve issues.
• Proficiency at various levels viz. association with end-users for requirements determination, defining the system scope, system analysis, development, testing, user acceptance testing, documentation and Project Management.
• Responsible for the design, set up and maintenance of both Production and Non-Production environments
• Demonstrated development techniques, standards, and guidelines as per the Product.
• Performed effort estimation for various Business Intelligence Reporting activities.
• Maintained project deliverables as per requirements, on time within budgets.
• Assisted users in tuning and building reports.
• Strong technical knowledge of OBIEE 11g architecture, administration tool, security.
• Good understanding of ITIL support processes.
• Team Player with good interpersonal skills and the ability to work in the team.
• Planning scheduling activities to ensure completion of project within the time budgetary parameters. Managing resources and documentation as per the requirements, meeting deadlines without compromising quality norms.
• Experience as a Lead BI Practice in shared model Production Support Engagement Projects.
• Have worked in multi-various domain like Banking, Manufacturing, Marketing Telecom etc

Technical Skills:

BI Tools and Utilities : OBIEE 10g, 11g, DAC, Informatica 9.x

ERP/Applications : Oracle Apps11i /R12 OM, INV, PO, AP, AOL , Oracle BI Applications 7.9.6.

Operating Systems : WIN 2003/2008, Solaris 8.0, UNIX, Linux 4.0.

RDBMS : Oracle 9i, 10g, 11g.

GUI : Oracle Developer 6i Reports 6i, 10g .BI Publisher

Oracle Tools : SQL PLUS, SQL Loader, Discoverer 4i, 10g, Workflow 2.6.x, BI/XML Publisher, SQL Developer and Benthic.

Languages : SQL, PL/SQL, C, C and Java.

Projects and Work Experience:

Confidential

Business Intelligence Analyst

Environment:- Siebel 8.1.1.3, Oracle 11g, Linux x86-64,Oracle Business Intelligence Enterprise Edition OBIEE V 11.1.1.7.1,OBIA 7.9.6.4 Sales Analytics, Informatica 9.5.1 and DAC.1200 active reports.

• Managed a team of technical resources both onsite and offshore and ensure project delivery.
• Design and development of all layers of Administration too like Physical, Business Model, and Presentation layer.
• Participate in providing the effort estimations for every release.
• Contributes to the requirements elicitation process by creating assigned parts of the requirements documentation with guidance from supervisors.
• Participate in creating application architecture document to provide deliverables in line with architectural requirements.
• Involving all the release planning calls and providing the estimations on the each requirements.
• Handled the upgrade project BI 10g to BI 11g latest patch set.
• Created the new hierarchy for the Managed solutions team
• Creates low level design artifacts independently and high level design artifacts with guidance and supports prototyping through creation of POCs.
• Delivers high quality code deliverables and supports peers in quality checks such that design requirements are met
• Leads validation activities for the assigned sub-modules for all types of testing e.g. Functional , Integration, System, User experience
• Performs root-cause analysis of any issues that arise post implementation and works on solutions related to issue fixing
• Participate in KT sessions, help prepare system appreciation documents and support the Transition process
• Does impact analysis of issues logged, prioritize and ensure that production support is provided as per the committed SLAs
• Involved in creating the Repository variables, initialization blocks.
• Developed aggregate tables to increase query performance.
• Involved in developing the Dashboard Pages and reports using Answers.
• Worked on Repository migration.
• Created the reports in different views like Table, Pivot, Chart, Filter, Title, view selector, prompts.
• Involved in creating the Dimensional Hierarchies, Level Based Measures and creating the navigations from one report to other pages.
• Use Analytics Agents/iBots to send messages conditionally to Groups / Selective Recipients.
• Scheduled and monitored the ETL runs in DAC.
• Involved debugging the ETL failures by analyzing the workflow and session logs to identify the root cause.
• Worked and reviewing the Technical and Functional Specifications, design suitable Analytical Reporting
• Involved the SSO security using the SAML.
• Worked with Oracle Expert services team
• Guided the team to participate the best practices.

Confidential

Environment:- Siebel 8.1.1.3, Oracle 11g, Linux x86-64, BI Publisher Reports, Oracle Business Intelligence Enterprise Edition OBIEE V 10.1.3.4.1, Informatica 8.6.1 and DAC.

• Design and development of all layers of Administration too like Physical, Business Model, and Presentation layer.
• Involved in creating the Repository variables, initialization blocks.
• Developed aggregate tables to increase query performance.
• Involved in developing the Dashboard Pages and reports using Answers.
• Worked on Repository migration.
• Developed the OBIEE BI Publisher Reports.
• Created the reports in different views like Table, Pivot, Chart, Filter, Title, view selector, prompts.
• Involved in creating the Dimensional Hierarchies, Level Based Measures and creating the navigations from one report to other pages.
• Use Analytics iBots to send messages conditionally to Groups / Selective Recipients.
• Scheduled and monitored the ETL runs in DAC.
• Involved debugging the ETL failures by analyzing the workflow and session logs to identify the root cause.
• Primary contact person on OBIEE issues for ARC.

.

Confidential

Environment:- Oracle Apps R12 Rel 12.0.6 , Oracle 10g, Linux x86-64, Oracle Forms 10g, Oracle Reports 10g.And Implemented OBIEE and the version and components are Oracle Business Intelligence Enterprise Edition OBIEE V 10.1.3.4.1, Informatica 8.6.1, DAC and O/S Linux.

• Design and development of all layers of Administration too like Physical, Business Model, and Presentation layer.
• Involved in creating the Repository variables, initialization blocks
• Developed aggregate tables to increase query performance.
• Involved in developing the Dashboard Pages and reports using Answers.
• Created the reports in different views like Table, Pivot, Chart, Filter, Title, view selector, prompts.
• Involved in creating the Dimensional Hierarchies, Level Based Measures and creating the navigations from one report to other pages.
• Use Analytics iBots to send messages conditionally to Groups / Selective Recipients.
• Involved in single sign issues.

Confidential

Environment: Implemented OBIEE and the version and components are Oracle Business Intelligence Enterprise Edition OBIEE V 10.1.3.4.1.

• Involved in developing the Dashboard Pages and reports using Answers.
• Created the reports in different views like Table, Pivot, Chart, Filter, Title, view selector and prompts.
• iBots are created for seeding the dashboards to Managers.

Confidential

Environment: Oracle Apps 11i Rel 11.5.10.2 , Oracle 10g, Linux x86-64,Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer 4i, Oracle Financial and Supply Chain.

Responsibilities:

• Analyzed the table/view/Package level changes in R12 when compared to 11i
• Analyzed the table/column information and documented the information for Discoverer and RDF reports.
• Compiled the 11i objects in R12 environment and documented the changes.

Confidential

Environment: Oracle Apps R12 Rel 12.0.6 , Oracle 10g, Linux x86-64, Oracle Forms 10g, Oracle Reports 10g.

Responsibilities:

• Played a lead role in acquainting the team with HULFT tool.
• Developed several shell scripts to send out automatic notifications when an error rose which reduced manual monitoring.
• Developed new BI Publisher reports, customized and converted oracle standard reports into various Currency specific XML Publisher reports using different templates.
• Customized Oracle Standard Reports of various modules.
• Taken the Knowledge transfer from other vendors and migrated the CEMLI or RICE components.
• Registered PL/SQL procedures, reports, request sets and new value sets.
• Handled all the workflow open issues.

Confidential

Environment: Oracle Apps 11i Rel 11.5.10.2 , Oracle 10g, Linux x86-64,Oracle Forms 10g, Oracle Reports 10g, Oracle Financial and Supply Chain.

Responsibilities:

• Lead the technical team and conducted the team meetings.
• The custom scheduler developed by Steria is not much capable and hence played primary role in creating a new scheduler called On Demand Scheduler.
• Developed dynamic parameters for concurrent programs/request sets replacing the parameters used by CONCSUB utility.
• Provided logics in the scheduler to handle dependent value sets and special type value sets.
• Taken up the Chorus and NFS interface issues.
• Developed the SQL reports to extract the data as per the business needs in different modules.
• Registered PL/SQL procedures, reports, request sets and new value sets.
• Debugged and provided the solutions for the INV and PO functional issues.
• Worked on PO approval issues.
• Resolved the workflow issues.

Confidential

Responsibilities:

• Registered PL/SQL procedures, reports, request sets and New value sets in R12
• Actively involved up-gradation of Oracle standard reports Report6i in 11i to Report10g in R12.
• Involved up-gradation of packages and XML-Publisher reports to R12.
• Debug the day to day issues consolidated getting in R12.
• Technical Functional Documentation for various Reports and Setups.

Confidential

Environment: Oracle Apps 11i Rel 11.5.10.2 , Oracle 9i, Windows 2003/XP, Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer 4i/10g, Oracle Financial, CRM and Supply Chain.

Responsibilities:

• Developed new XML Publisher reports, customized and converted oracle standard reports into various Currency specific XML Publisher reports using different templates.
• Customized Oracle Standard Reports of various modules.
• Developed Discoverer reports in GL, AR, AP, PA, PO, INV, OM, SC, HRMS, Quotes and Sales User modules.
• Created and Administered Business Areas for GL, AR, AP, PA, PO, INV, OM, SC , Quotes and Sales User modules.
• Involved implementation of PA module in Discoverer.
• Migrated the custom views and workbooks from one instant to another.
• Conducted training for the end users on Discoverer Admin, Desktop, Plus, and Viewer.
• Involved workflow process of CRM-Sales, Quoting modules and Resource setup.
• Developed Data Conversion API/Interface Programs using SQL and PL/SQL.
• Created new Report and registered these reports as concurrent programs in AOL and modified request group to add these concurrent programs.
• Designed and implemented customized Responsibilities, Menus, Functions to map different roles required for the organization, to satisfy SOX requirements.
• Created Query-Only Responsibilities and assigned to the specified users.
• Personalized various forms in Order management.
• Technical Functional Documentation for various Standard and Discoverer Reports.
• Solved all day to day technical issues and fulfilled business requirements.