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  identifying data and business requirements from 6 different applications namely
• Has worked with Oracle financial 
• Create business requirements documents, 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.
• 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,
• Extensive experience in dimensional modeling design, building business models, configuring metadata, creating reports / Dashboards, cache monitor, building  Repository consisting of three layers 
• Expertise in 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
• Applications: 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 modules 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  EXPERIENCE

 Business Analyst

• Business analyst for BI Phase III that is focused on identifying data and business requirements from 6 different applications namely
• Identified opportunities to improve performance by assisting  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  for different application(s) business and reporting needs.
• Traced data and work in Oracle  line with  reporting
• Conduct requirements sessions with end users, super users and subject matter experts  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  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.
• 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  and functional specifications that are used by the ETL developers to extract data from these applications.
• Customized and developed  configured metadata objects and Web Catalog Objects.
• Developed many  with different analytic views (drill-down / dynamic, sheets, pivot table, chart, column selector, tabular with global and local filters.
• Worked with the solution architects in designing the technical specifications identifying the logical schemas and creating relationships.
•   ETL developers,  and business to make sure that all data and business needs are met.

 Techno-Functional analyst/developer

Responsibilities: 

• Import  queries from  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  Admin and Web tool.
• Designed business models conforming to functional mapping, defined logical and complex joins 
• Created test scripts and plans.
• Conducted report Unit and User Acceptance Testing  with functional team leaders
• Used the  Quality Center tool to Log and track the  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 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 Admin tool and associating catalog objects and Web modules with the created users and groups
• Used filters in providing  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  Answers and create numerous executive level reports.

 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 for the different Dashboard reports used by the sales representatives (end users) as per different metrics 
• Analyzed and used various data sources as Oracle and Excel .
• Customized and developed, configured metadata objects and Web Catalog Objects.
• Developed many reports  in  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 to deliver Analytics content based on schedule, automated iBot queries to obtain daily, weekly and monthly reports.
• Operated in a Multi User Development environment
• Used SQL developer in Performance tuning situations

Confidential, Irving TX 

 OBIEE Techno/functional Analyst

Responsibilities:

• Identified the  of the data required to be available for analysis.
• Interacted with business representatives and end users for  and to define business and functional specifications
• Developed, Physical layer & Business Model and Mapping, Web Catalog Objects as per the data requirements
• Worked on  to build Interactive 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 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.

OBIEE Analyst

Responsibilities:

•  interacted with the business users, defined subject areas for analytical data requirements.
• Performed  and feasibility study for the given business requirements.
• Customized the Repository 
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• keys for dimensional modeling design, defined drill- down time series & other dimension hierarchies, and whole diagram
• Created test scripts and plans.
• 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  Admin tool to setup Users and Groups
• Created security authorization session variables and initialization blocks in the repository.
• Deployed into  Services ready for building reports/dashboards from the repository 
• 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