SUMMARY:

• 6+ years of total IT experience.
• 5 years of experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps).
• 5 years of Business Development Consulting experience
• Expertise in Business Intelligence Applications using Oracle Business Intelligence (OBIEE/OBIA) in HRCIM, Sales, Procurement modules.
• Experience in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• E-Business Suite: BI Interactive Dashboards, BI Answers, BI Publisher, Delivers, BI Plug-in for Microsoft
• Tools: Microsoft Office - Word, Excel, Access, Outlook, PowerPoint, Projects, and Visio, PeopleSoft
• Operating Systems: Windows XP, Vista, 7 and 8
• Web development: SharePoint 2010
• Other Skills: Business Development, Quality Assurance
• ERP: Hands on experience implementing the complete life cycle of ERP projects from design, gap analysis, development, unit testing, system testing, implementation, deployment and support in Oracle Applications 10g and 11g
• Oracle Tools: Business Intelligence, Web logic

PROFESSIONAL EXPERIENCE

Confidential

Senior OBIEE Developer

• Led dashboard developments for 16 projects within the organization in all three environments Development, Stage and Production.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the HR data.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Led requirement gathering meetings with project sponsors and analysts.
• Conducted data validation meeting with IT teams.
• Wrote specified requirements to RPD team implementing required changes.
• Created business reports using BI Answers as per requirements.
• Developed numerous HR Business Analytics reports consisting of compensation, Organization health, stock awards, bonus, budget, inclusion, performance management, employee demographics, as was reporting etc.
• Led BI hierarchy changes after organization CEO changes and leadership reshuffle.
• Generated various Analytics Reports using global and local filters.
• Engineered changes to preexisting dashboards.
• Tested Dashboards using proxy settings.
• Managed security privileges for each subject area and dashboards according to user requirements
• Created analysis reports comprising of graph views, column selectors and view selectors.
• Recreated tableau reports in OBIEE and migrated OBIEE dashboards to micro strategy reporting.
• Introduced diverse reporting methodology changes in OBIEE reporting ie ‘Related items’ hyperlink in dashboards linking the BI Audiences to tailor specific dashboard of interest or related subject creating a reporting story line.
• Created and maintained a Global navigation tool in BI Dashboards which served as a simple navigation tool for end users in Analytics. Conducted meetings with industry captains via WebEx meeting and conference calls.

Environment: OBIEE 11g, Web Logic Server, I, Oracle 11.2.0.2, SQL, PL/SQL, TOAD, SQL* Plus, Windows 7.

Confidential, OR

Senior OBIEE Consultant

• Confidential is a Management & Technology consulting company. They provide process transformation, enterprise application and database solutions to a broad spectrum of businesses and institutions. At Confidential I was hired on as a Senior OBIEE Consultant. In addition to in house OBIEE development need at the firm my main focus were projects listed below

Confidential, OR

Lead OBIEE Developer

• Lead OBIEE Developer implementing a three track phased OBIEE 11G project with an out of the box customized instance.
• Identified the granularity level of the data required to be available for analysis
• Developed Metadata repository (.rpd), configured metadata the Business Model
• Layer & Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Administered security and created alerts.
• Created templates for presenting results and Analytics and modified the OBIEE Dashboard using cascading style sheets.
• Involved in Reconciliation Process while testing loaded data with user reports.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Implemented a training schedule transferring knowledge to15 BI end users with novice experience in BI Analytics.
• Trained IT end users in BI Analytics resourcing in Building new analytics, filters, Analytic prompts, Dashboard creation, Building Dashboard prompts and creation of system and session variables.
• Customized RPD in coherence with clients’ needs.
• Customized Out of the box Dashboards to client’s specifications, added new filters to existing analytics added Analysis and dashboard prompts.
• Documented customization procedures.
• Created new Analysis and reports deriving from Out of the box subject areas.
• Migrated development from the Development Environment to the Production Environment using Catalog manager and Archive and Unarchieve functionality in Analytics Catalog folder.
• Uploaded Repository changes with Enterprise Manager.
• Migrated Data warehouse tables into Repository Physical Layer

Confidential, WA

Senior OBIEE Developer

• Experience on OBIEE 11.6.0 and PL/SQL
• Involved in business requirements gathering and translated the requirements into technical requirements.
• Developed BI reports in three environments Development, UAT and Production
• Close liaisons with project managers for the whole lifecycle of report development
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Ran extensive database quarries
• Wrote PL/SQL quarries to create new tables, update existing tables.
• Imported table columns into existing Repository tables.
• Implemented fragmentation for three geographies on new repository tables
• Created numerous repository variables.
• Assembled subject areas and created execution plan and accommodated the new mappings.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Built Unified Sub Ledger dashboards reports consisting of Summary, Transactional, Aging, Rollfoward and Variance reports.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Developed presentation variables.
• Developed an extensive Rollfoward report with PTD and LTD variations
• Carried out extensive review of Development environment.
• Oversaw UAT and Production migration of reports.
• Resolved CM tickets as per business end user requirements.
• Trained End Users and Pilot Users about OBIEE Tools.

Confidential, TX

Legacy Assets - OBIEE Developer

• Interacted closely with Functional Analysts and Business Users in the client side, and designed the system accordingly.
• Created customized metrics for client such as Accounts payable, Receivable and Variables
• Performed the gap analysis, Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Model (Physical, Business and Presentation layer).
• Experience on OBIEE 11.1.1.5
• Configured Agents to send the Reports through Emails to the user group.
• Identified granularity level of the financial data required to be available for analysis.
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc report according to the client needs.
• Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE Answers.
• Created Time- Series calculations in the BMM layer.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE Answers to build the query.
• Used presentation variable in OBIEE Answers to save prompt values and use them for conditional formatting.
• Developed different Dashboards/Reports with different views (Calculation, Detailed, Pivot, Charts, and Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.
• Scheduled IBots and seeded server cache using Delivers to improve system performance. Scheduled reports to be e-mailed using BI Publisher Scheduler.
• Coordinated the RPD and Web Catalog objects migration from Development environment to QA environment and then to the Production environment using OBIEE Catalog Manager.

Confidential

Junior OBIEE Developer

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Prepared Design Specifications based on functional requirements of business and produced Technical Design Documents.
• Designed and built Repositories in accordance to business needs.
• Customized Dashboard pages as per business need e.g. Marketing, Field Sales, etc.
• Implemented dynamic dashboard prompts as per business requirement e.g. zooming into particular segments of the business in a performance-optimized manner.
• Transformed change management procedures.
• Implemented performance tuning measures including data caching.
• Adhoc query reporting to support the business requirements.

Confidential, TX

Intern OBIEE Developer

• Collaborated with Business contacts & Business Analysts in the analysis and preparation of OBI data requirements.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Created dimensions, aggregations and keys using admin tool. Customized Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.
• Developed Global prompts, Filters, customized Reports and Dashboards using OBI presentation services.
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc reports according to the client needs.
• Managed the intelligent dashboards by using dashboard, page and report level security.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Worked on OBI presentation Answers to build Interactive Dashboards with drill-down capabilities.