SUMMARY

• 6+ years of total IT experience.
• Active Public Trust clearance.
• Federal experience in the Reporting Development and Analytics field.
• 6+ years of experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps), Hyperion Essbase, Hyperion Interactive Reporting, Hyperion Financial Reporting, Smart Views & Excel Add - in, Pearl.
• 5 years Business Development Consulting experience, A year of Federal Business Intelligence reporting.
• 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.
• E-Business Suite: BI Interactive Dashboards, BI Answers, BI Publisher, Delivers, BI Plug-in for Microsoft
• Experience on creating dashboards and reports using Hyperion SQR Production reporting, Financial Reporting, Interactive reporting (Brio) and Web Analysis.
• Tools: Microsoft Office - Word, Excel, Access, Outlook, PowerPoint, Projects, and Visio, PeopleSoft
• Operating Systems: Windows XP, Vista, 7, 8 and 10
• 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, 11g and 12c.

PROFESSIONAL EXPERIENCE

Confidential, Memphis TN

OBIEE Developer

Responsibilities:

• Experience on OBIEE 12.2 and PL/SQL, Tableau, Teamtrack, Telnet and SQL Developer.
• Implemented OBIEE 11G to 12C Upgrade.
• Updated and enhanced current analytic tools.
• Designed data warehouse mappings.
• Created numerous data models to help the report building process from multiple data sources.
• 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.
• Converted metadata views to Table views.
• Configured and maintained OBIEE Delivery Agents to deliver Scheduled Reports to user group.
• Wrote SQL statement to create new tables, update existing tables.
• Created Tableu metrics using Excel as data source.
• Created analysis reports comprising of graph views, column selectors and view selectors.
• Migrated development from the Development Environment to the Production Environment using Catalog manager and Archive and Unarchieve functionality in Analytics Catalog folder.

Confidential, Washington DC

OBIEE Reports Developer

Responsibilities:

• Collaborated with Business Analysts, discussed and identified the analytics requirements to be obtained from various user groups.
• Created star schemas in the repository. Used the foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer to form relationships between fact and dimensional tables.
• Created iBots/Intelligence Agents for job-critical levels and auditable differences delivered to dashboards.
• Analyzed OBIEE reporting data requests, researching data to satisfy requests.
• Create prompts, Ad Hoc reports and customized reports.
• Supported and executed the migration of multiple OBIEE projects through platform upgrades.
• Debugged complex SQL queries.
• Used PLSQL working on Inbound and outbound interfaces.
• Correct customizations of Data Warehouse, RPD, and in Dashboards.
• Format reports, including embedding web-based communications according to business requirements
• Updated and enhanced current analytic tools.
• Conducted root cause analysis and resolved the issues within SLA.
• Modified existing OBIEE reports and develop new reporting products.
• Performed ongoing stakeholder management in areas such as data quality and interpretation, includes coordinating and facilitating meetings with appropriate parties for more complex requests;
• Performed quality assurance on outgoing reporting data and content.
• Collaborated with other team members to recommend and implement business process changes.
• Developed and maintained reporting SOPs.
• Performed administrative skills (record keeping, note-taking, filing, compiling reports, scheduling activities, status reports)

Confidential

Senior OBIEE Developer

Responsibilities:

• 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

Lead OBIEE Developer

Responsibilities:

• Lead OBIEE Developer implementing a three track phased OBIEE 11G project with an out of the box customized instance.
• 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

Responsibilities:

• 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
• Wrote SQL statement 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 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

OBIEE/Hyperion Developer

Responsibilities:

• 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).
• 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 Adhoc reports 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.
• 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.
• Analyzed financial results and prepared trend reports to support business managers make profitable decisions using Hyperion financial reporting and Hyperion Smartview.
• Extensively involved in developing a planning application, which provides a platform to do budgeting and forecasting.
• Created numerous data models to help the report building process from multiple data sources.
• Modified, replaced and duplicated existing financial, marketing reports developed in Hyperion Intelligence Explorer (Interactive Reporting) and Reports (Financial Reporting).
• Migrated and converted Hyperion Brio reports and Business Objects to the Hyperion Interactive Reporting and Financial Reporting to OBIEE 11G utilizing BI Publisher.
• Developed OBIEE 11G end user training material and led super users Ad Hoc training.

Confidential, Dallas TX

Junior OBIEE Developer

Responsibilities:

• 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

Junior OBIEE Developer

Responsibilities:

• 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.