EXPERIENCE SUMMARY:

• 7+ years of experience in Oracle Business Intelligence Enterprise Edition 11g: Gathering Business Requirements, Analysis, Design, Data Modeling, and Development in the finance and retail industries.
• Has overall 7+ years of experience in delivering high end solutions on business intelligence platform for various clients.
• Business analysis identifying opportunities to improve performance by assisting business process strategies in the development, monitoring, and analysis of key operational measures in line with corporate/departmental goals.
• Business analyst in oil and gas industry identifying data and business requirements from 6 different applications namely: JD Edwards, Salesforce, Markview, Accpac & Sage 300, Oracle Contracts and Oracle Scheduling with (OBIEE) as the reporting tool.
• Prepare Test plans and test scripts for different applications.
• Experience in mapping data fields from source to target, and resolving any data discrepancies.
• Expertise in Unit, CPR, System integration and User Acceptance (UAT) Testing
• Trace data and work with Oracle financial modules (AP and AR) and Noetix in line with BI reporting
• Liaise and collaborate with project managers, end users, subject matter experts (SMEs) and developers throughout different project (SDLC) phases.
• Create business requirements documents (BRDs), functional and technical specifications that as per gathered data and business requirement sessions with key users and subject matter experts.
• Drive projects on business intelligence platforms in line with the project scope and deliverable times.
• Coordinate and communicate requirements in an effort to deliver timely.
• Process expert in production support land scape within an onsite - offshore model
• Well-versed and hands on, in integration of SAP BW and OBIEE to provide reporting in F2S, R2R, OTC business processes.
• Expertise in complete life cycle Design, Development, Maintenance and Documentation of various business requirements with Data Warehouses and Data Marts as targets
• Expertise in Performing Gap Analysis, in light of dimensions, Facts, aggregate tables, Measures and Hierarchies.
• Experience in creating, modifying, and Oracle Business Intelligence Dashboards with drill down capabilities using global and local filters in BI Presentation, using Oracle BI Answers, creating Agents in BI Delivers.
• Extensive experience in dimensional modeling design, building business models, configuring metadata, creating reports / Dashboards, cache monitor, building OBIEE Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer), time series objects, configuring OBIEE/ Siebel security (groups, access / query privileges) using OBIEE administration tool.
• Expertise Performance Tuning and Security user groups and priviledge assignments.

TECHNICAL SKILLS:

• Oracle BI Administration tool, Oracle BI Presentation, Oracle BI Dashboards, BI Delivers, Catalog Manager
• JD Edwards, Salesforce, Markview, Accpac & Sage 300, Oracle Contracts and Oracle Scheduling with (OBIEE) as the reporting tool.
• Working knowledge of Oracle financials AP & AR module and Noetix in the BI reporting environment.
• Testing - Unit, CPR, System integration and UAT
• HP Quality Center defect log and tracking tool
• OBIEE Hierarchies, facts, Dimensions and aggregates
• Data Warehousing: Data mart, OLAP, OLTP.
• Dimensional Modeling of Star and Snowflake Schemas
• Working knowledge of Oracle’s Exadata and Exalytics in light of Big Data
• Microsoft Excel, Access, Project, Visio, Power point
• Multi User Development (MUD) environment
• Have created ‘Big Data ‘ use cases

PROFESSIONAL AND INDUSTRY EXPERIENCE:

Confidential

BI Business Analyst

Responsibilities:

• Business analyst for BI Phase III that is focused on identifying data and business requirements from 6 different applications namely: JD Edwards, Salesforce, Markview, Accpac & Sage 300, Oracle Contracts and Oracle Scheduling with BI (OBIEE) as the reporting tool.
• Identified opportunities to improve performance by assisting SMEs in different applications in business process strategies in the development, monitoring, and analysis of key operational measures in line with BI phase III goals.
• Per business requirements data is pulled into the Data warehouse and also used in creating different reporting cubes for different application(s) business and reporting needs.
• Traced data and work in Oracle financial modules (AP and AR) and Noetix in line with BI reporting
• Conduct requirements sessions with end users, super users and subject matter experts (SMEs) from each of these applications to gather data and business requirements.
• Prepared test plans and test scripts for each of these applications
• Conducted Unit, System integration and UAT testing for all the different applicatons
• Understand the business processes and data flows in each application and align it to the departmental objectives as I follow the roadmap to identify business and data needs from end users.
• Mapped all the data elements from source to target as per the different business needs so that all can be pulled into the Datawarehouse (DW) and solved any data discrepancies
• Created business requirements documents (BRDs) and functional specifications that are used by the ETL developers to extract data from these applications.
• Worked with the solution architects in designing the technical specifications identifying the logical schemas - fact and dimension tables and creating relationships.
• Liaised with the ETL developers, SMEs and business to make sure that all data and business needs are met.

Confidential

BI Sr Technical/Functional analyst

Responsibilities:

• Interacted with business key users to gather report requirements for different departments: Forecast to Stock, Order to Cash, Record to Report, Source to Pay and Manufacturing Execution
• Designed functional and technical specifications documents(High level and low level designs) for the reports as per different metrics and KPIs
• Analyzed business processes and key profit drivers to help achieve management goals and objectives
• Operated in a Multi User Development Environment (MUD)
• Import MDX bex queries from SAP BW multiprovider into the physical layer.
• Developed Metadata repository code in Physical layer & Business Model and Mapping, Web Catalog Objects as per the data requirements using OBIEE Admin and Web tool.
• Designed business models conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Created test scripts and plans.
• Conducted report Unit and User Acceptance Testing (UAT) with functional team leaders
• Led the onsite and offshore production support team and gave periodic status update to the Directors and VPs on issues resolved and progress.
• Used the HP Quality Center tool to Log and track the ETA of defects until resolved
• Applied business logic to the reports: column formula/calculations, hierarchies, content filters, variables, and also use calculation wizard and expression builder in some formulas.
• Worked in the Analyses/ BI Answers after deployment to build reports, views and Interactive Dashboards with drill-down capabilities
• Implemented comprehensive security functionality by creating users & web groups, external table security using session variables, test and validate the model using OBIEE Admin tool and associating catalog objects and Web modules with the created users and groups
• Used filters in providing customized dashboard prompts and action links appropriately to avoid excessive data being displayed on reports.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• Assisted in creation of pivot table requests allowing managers to analyze the business from different perspectives, provide optimized analytics requests using column selectors
• Generated queries and place filters in Oracle BI Answers and create numerous executive level reports.

Confidential, Suffern, NJ

OBIEE Developer

Responsibilities:

• Interacted with business analyst and sales representatives for gathering Obiee Reports, Dashboards requirements and to define business and functional specifications.
• Designed functional specifications documents(High level and low level designs) for the different Dashboard reports used by the sales representatives (end users) as per different metrics and KPIs
• Analyzed and used various data sources as Oracle and Excel (collDM).
• Customized and developed RPD (Physical, BMM and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Developed many reports / dashboards in BI ANSWERS with different analytics views (drill-down / dynamic, sheets, pivot table, chart, column selector, tabular with global and local filters).
• Conduction system intergration and user acceptance testing.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily, weekly and monthly reports.
• Operated in a Multi User Development (MUD) environment
• Used SQL developer in Performance tuning situations

Confidential, Irving TX

OBIEE Techno/functional Analyst

Responsibilities:

• Identified the granularity level of the data required to be available for analysis.
• Interacted with business representatives and end users for requirements analysis and to define business and functional specifications
• Developed Metadata repository (.rpd), Physical layer & Business Model and Mapping, Web Catalog Objects as per the data requirements
• Worked on BI Answers to build Interactive Dashboards with drill-down capabilities.
• Designed the business model conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Implemented comprehensive security functionality by creating users & web groups, external table security using session variables, test and validate the model using OBIEE Admin tool and associating catalog objects and Web modules with the created users and groups
• Used Filters and provided Customized dashboard prompts appropriately to avoid excessive data showing up Reports
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• Created pivot tables enabling managers to analyze the business from different perspectives, provided optimized analytics requests using column selector
• Generated queries and placed filters in Oracle BI Answers and created numerous executive level reports.
• Created testing scripts and plans conducting all report testing with end users.
• Created Business Process specific Dashboards to provide insight into the sales/marketing/financial areas.

Confidential, Irving TX

OBIEE Analyst

Responsibilities:

• Gathered Business requirements, interacted with the business users, defined subject areas for analytical data requirements.
• Performed gap analysis and feasibility study for the given business requirements.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created logical tables, dimension hierarchies, aggregates, and keys for dimensional modeling design, defined drill- down time series & other dimension hierarchies, and whole diagram using complex joints
• Created test scripts and plans.
• Used Rename Wizard to remove underscore character, change all column names so that first letter of each word is uppercase and rest is lowercase.
• Used the security manager in OBIEE Admin tool to setup Users and Groups
• Created security authorization session variables and initialization blocks in the repository.
• Assigned filters to objects and granted access privileges to users or groups
• Deployed OBIEE .rpd into BI Presentation Services ready for building reports/dashboards from the repository using OBIEE
• Developed various Dynamic and Interactive Dashboards/Reports with intuitive drilldowns, drill-across and drillable charts using Oracle Answers using global, local filters and page/dashboard prompts, pivot tables, charts and view selector.
• Used Prompts To Filter Data
• Formatted requests using sorts, filters and prompts
• Formatted column output and modified column data using formulas