SUMMARY

• Over Seven years of experience in Business Intelligence and Reporting using Dashboards in Weblogic and BI Answers.
• Over 4+ years of experience as an OBIEE 10/11G, and knowledge of BI Publisher 11g / XML Publisher and Oracle E - Business Suite, SharePoint, Cognos and OLAP.
• Experience in implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inman Methodologies.
• Worked in developing OBIEE Repository (RPD) at three layers (Physical Layer, Business Model & Presentation Layer).
• Created Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges).
• Experience in Unit Testing and creating a Smoke Test Scripts using SQL
• Experience in Hyperion Reorting and Management
• Created Alerts using Agent for setting up KPI’s in BI Answers.
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication.
• Have implemented Security Models for Dashboards, Row level, objects Level, Role Level, and Web Level.
• Experience in SDLC-Systems Development Life Cycle
• Have worked with ETL Developers and other IT members in troubleshooting and in UAT.

TECHNICAL SKILLS

• Windows XP/2000/NT/98/95
• SQL
• Power Point
• Essbase
• Hyperion

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Responsibilities:

• Managed Hyperion Planning and Ad-hoc reporting support system
• Troubbleshooting and maintaining Dimensions in Database
• Supported the monthly and quarterly consolidated close and reporting process, including both internal and external reporting requirements.
• Responsible for review and preparation of quarterly results in support of the Investor Relations and Corporate FP&A functions.
• Responsible for review and analysis to ensure financial reports are accurate and have appropriate supporting documentation.
• Supported system administration in Hyperion, JD Edwards, as well as, Essbase software.
• Supported external reporting team in preparation of SEC filings and related support, as assigned.
• Created Hierachies like Parent-Child, Business Rules and Calculations using Hyperian Financials
• Converted Excel reports to BI Dashboards for compliance with the Dodd Frank Act.
• Designed OBIEE 11G Business Intelligence Answers Dashboards
• Created Interactions between BI Reports and Filters to allow drill-down capabilities
• Used Essbase Cubes for Data Modeling as per User requirements
• Created Balance Sheets and Expense Reports in OBIEE Answers
• Made changes to Compound Layouts to suit User requirements
• Worked with other Team members to extract data from Essbase Data Base

Confidential, Renton, WA

OBIEE Reports Developer

Responsibilities:

• Designed document report specifications for BI Answers Dashboards Implemented metadata layers including physical, business model, and presentation layers in RPD.
• Used PeopSoft to process HR Time Sheet, Vacations, PTO and Leave of Absence.
• Loaded PeopleSoft to load Equal Opportunity Employment EEO statistics to Government in compliance with Hiring laws.
• Used Raw Data from OLAP, ODI and OBAW to validate with final Oracle BI Answers Reports. Created scenarios in ODI 12c using parameters as provided by Administrator during OBIEE Integration Responsible for balancing SIL and Test during the integration Balanced Test and Dev environments during UAT Worked with Data Administrator AND Team members in the Migration of DW Builder to ODI Participated in the ODI Migration to convert subset of OWB artifacts into comparable ODI artifacts. Deployed Dev to Production by copying files and Catalogues. Participated in UAT for the Loss Prevention and Basket Analysis Developed interactive Dashboards for the HR Department and Retail Stores for Savers Village using HCM. Provided technical support of BI systems and software to HR, Loss Prevention and Retail Users. Created Smoke Tests for Loss Prevention functional testing during UAT. Prepared test scripts and ran smoke tests during UAT. Merged Dev and QA environments in RPD Performed presentations and workshops with Business Sponsors and Users.

Confidential, Melbourne, FL

OBIEE Contractor

Responsibilities:

• Responsible for all Oracle Business Intelligence solutions and creation of Executive Dashboards and Financial Statements analysis. Defined and developed Executive Dashboards and analytics using the OBI RPD and BI Answers Worked with ETL informatica 9.1 to generate process flow design.
• Developed and implemented strategies for the handling of errors in data modelling.
• Applied dimensional data modeling concepts as they relate to BI methodologies, concepts and designs including: star schemas, Created RPDs using Dimensional Modeling and used them for Mapping. Created Security Groups for granting privileges to the select users who accessed Dashboards and certain Repository Objects. Set up KPI’S for Managers as well as Scorecards to measure performance. Created Agent and Alerts for monitoring of loads and errors during the intermittent loads. Worked closely with other BI members of the development and support team in order to protect the integrity of the company’s data. Environment: BI Answers, OBIEE 11g/10g, Oracle 11g/10g, SQL, Windows Server 2008.

Confidential, Irving TX

OBIEE Developer

Responsibilities:

• Interacted closely with Functional Analysts and Business Users in the client side, and designed the system accordingly.
• Used Tableu Desktop to create Dashboards and visualization of charts.
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) using Cognos and OLAP as per the detailed design requirements.
• Supported, monitored and tuned Informatica ETL processes.
• Responsible for building and enhancement of reporting in Hyperion Financial Reporting
• Analyzed requestsin design solutiosfor projects for Hyperion Reporting
• Developed codesin compliance with best practices for the Bank.
• Performed code reviews for the team and other entities.
• Supported and tuned data visualization using MicroStrategy toolsets and Crystal Report.
• Functioned as backup DBA to ensure high availability for Oracle databases supporting Imaging system and Internet applications.
• Guided and consulted with other DBA within the business unit for installation and configuration of Oracle databases.
• Developed and maintained complex Informatica mappings.
• Perform data validation tests using complex SQL statements.
• Function as backup on-call programmer for nightly ETL load.
• Used Report Studio to create and manage more advanced reports, which were often standarized and executed periodically and distributed to people in various departments.
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports.
• Developed implementation plans and schedules for Informatica enhancements,
• Developed reports based on issues related to the data warehouse.
• Worked with finance staff to document their business rules, data needs and requirements in order to create data warehouse systems.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Ad hoc report according to the client needs. Used Table and pivot table to display hierarchical columns for Parent Child and Logical Table Hierarchies. Worked with ETL Informatica to develope and create Cache persistence Wizard to efficiently handle cache management. Worked with properties such as changing the ownership of a folder or viewing the creation date of an object. Specified permissions that determine the folders and objects that users can view. Sorted data values, applied sorts to members, measures, and rows in views such as tables, pivot tables, graphs, and maps.