Jessica Claire
Montgomery Street, San Francisco, CA 94105
Home: (555) 432-1000 - Cell: - - -
  • A dedicated professional with 8+ years of end to end experience in Business Intelligence Implementation Projects.
  • Demonstrated strong technical skills in Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.x/OBIEE Plus/OBIEE 11g) in the  development of complex Dashboards, Answers, Agents/iBOTs, Oracle BI Publisher reports and data model - metadata repository (RPD) using OBIEE Administration tool.
  • Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Data Modeling,Extraction Transformation and Load (ETL) using Informatica Powercenter tools and Datawarehouse Administration Console (DAC).
  • Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps (OBIA), Informatica - Power Center and DAC.
  • Knowledge and Experience in implementations and customizations of the Data Analytics for Finance, HR and SCOM with respective integrating ERP Systems like PeopleSoft, Oracle EBS as per the business requirements.
  • Experienced in various roles such as Project Lead, Technical Lead, and Developer on the path of my career in design and development in full-cycle implementations.
  • Excellent communication skill and extensively worked on coordinating the Onsite & Offshore teams, Admin team and other cross functional teams such as Network team, QA and DBA team in addition to Client Leadership & Functional teams.
  • With an analytical mindset and natural problem solving abilities delivered cutting-edge solutions.
  • Extensive experience working with diverse customers and communicating technical concepts to non-technical audiences. 
  • A quick learner with the proven ability to learn new systems and concepts. 
  • Now Seeking a role that incorporates technical and leadership skill sets to drive business productivity and performance.
Core Qualifications

  • Analysis
  • Data Modeling (ETL and Reports)
  • Design and Develop ETL components
  • Design and Develop Business Intelligence Dashboards and Reports
  • Performance Tuning

  • Leadership
  • Project Management
  • Mentoring
  • Adapting to changing priorities
  • Coordination
  • Communication
Technical Skills
Oracle Business Intelligence Enterprise Edition Expert 8 Current
Informatica Powercenter Intermediate 7 Current
PL/SQL Intermediate 1 Current
Oracle DAC Intermediate 5 Current
ODI 11g Intermediate 1 2015
Professional Experience
01/2016 to
OBIEE Consultant Conduent Incorporated Philadelphia, PA,
  • Designed and Created PL/SQL procedures for auditing the data extracts from source to data warehouse for various entities such as Revenue, Accounts and Contacts
  • Developed ETL components for bring in missing data on targets from source
  • Configured various Data warehouse Load based on business requirements
  • Involved in Optimizing performance of processes and queries
  • Troubleshooted and implemented possible solutions for bug fixes
  • Coordinated with Technical Leads, System Administrators and other Siebel and OBIEE Developers for various component development and migrations
  • Prepared detailed specifications for the development components
  • Responsible for design, coding, testing, debugging and documentation and quality assurance
  • Responsible for directing and monitoring the work of team members
  • Effectively supports release cycle and proactively communicates with Release management, SQA andother teams
2015 to 11/2015
OBIEE Consultant Conduent Incorporated Portland, OR,
Project : BI Enhancements and Support
  • Managed the releases for the BI Platform and the Custom BI enhancements, worked in developing & customizing BI solutions using OBIEE, Informatica and Oracle DAC.
  • Monitoring daily ETL runs and troubleshooting for any issues.
  • Experience in ETL analysis for performance tuning.
  • Co-ordinates in Migration related activities across various instances, Customer Acceptance Testing and Production release.
  • Involved in major configuration tasks and testing of WebLogic Patch Upgrade for OBIEE, Single Sign on & Exalogic Implementation on various environments.
  • Active participation in the discussions on Process Improvement and Optimization of BI Platform tools.
  • Extensively worked as an Onsite-Offshore Coordinator, managed a team at offshore and team at client location.
  • Reporting: As Project lead work on providing effort estimation, Status tracking, Status Reporting to CAB meeting, Daily Status Report, developed Monthly OPS metrics Presentation.
  • Involved in actively coordinating with business team and functional team to gather business requirements and doing fit-gap analysis and lead the offshore team on project deliverables on time.
  • Worked in design and developing new reports based on user requirements and making sure the development effort is compliant with the requirements and its time lines Involved in data modeling and translating them to design in RPD.
  • Worked on providing the RICEF / Report design document for various projects and enhancements.
  • Extensively worked on Project management activity such as providing the BI Track reports on all list of enhancements & bug fixes and report the exact status & project metrics to Client leadership team.
  • Involved in creating Change Request Tracker to consolidate all list of changes after the initial requirements have been frozen.
  • Reviews and evaluates the testing requirements and developed proposal to update/redesign present testing strategy in order to continue & meet quality verification and validation needs.
08/2014 to 10/2014
OBIEE Consultant Cognizant Technology Solutions Corinth, MS,

Project: OBIEE Upgrade 

  • Extensively worked on upgrade of OBIEE 10g to OBIEE 11g which involve both RPD and Catalog reports.
  • Design and develop new reports based on user requirements.
  • Performed Installation of Repository Creation Utility and OBIEE on Windows Server 2003 Environment.
  • Upgraded RPD and Catalog from OBIEE to OBIEE by using ua.bat file.
  • Worked in data modeling and translating them to design in RPD.
  • Real good experience in Installation of OBIEE 10g and OBIEE 11g on Linux and Windows Platform.
  • Worked with functional team for requirement gathering from business users and provided technical design solutions based on their requirements.
  • Extensively worked in analysis of existing (10g) RPD and catalog objects in development environment and consolidation of the existing 10g report objects.
  • Gap Fit Analysis between Production and Development environments in both 10g and 11g and identified the objects that needed careful upgrade from 10g to 11g.
  • Gathered in consolidation of Physical DSNs, related Physical layer- Business Model and Mapping (BMM) layer and Presentation layer objects.
  • Troubleshoot and fix issues during the upgrade of RPD and catalog objects.
  • Work experience in BULK INSERT and BCP functions for data migration between SQL server databases.
  • Works with Functional Team to determine the risk associated with the requirements for developing the Risk Assessment Matrix.
  • Establish a release mechanism and timing for transporting implemented fixes and enhancements to production system.
  • Knowledge and exposure with all ODI tools - Topology, Security Manager, Designer and Operator and ODI packages, variables, procedures and scenarios using interfaces.
  • Experience in various RPD merge options like Full Repository Merge and Patch Merge.
2013 to 08/2014
Senior OBIEE Developer Panjiva , ,

Project: Trilogy - Enhancements

  • Implemented end to end-customized application for business.
  • Maintained and designed complete documentations such as BPR, issue trackers, training manuals for end users.
  • Integrated multiple source system using OBIA OOTB ETL framework using Informatica & DAC and Implemented Financial, Procurement and Spend Analytics.
  • Customized various OOTB ETL mappings and built custom DAC tasks, subject areas & execution plans as per business requirements including configuring domain values and transaction types.
  • Worked on incremental and full load of data through Data Warehouse Administration Console (DAC) and Informatica.
  • Developed the Incremental ETL processes i.e., Mappings & Mapplets using various transformations and Workflows with Sessions/tasks for data extraction from E-Business suite.
  • Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
  • Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
  • Worked in developing Custom SQL Codes for the reports.
  • Customized interfaces to load the data from flat files, and other sources to stage and from stage to Oracle HUB.
  • Created PL/SQL Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Involved in migrating DAC repository objects from one environment to another using import & export feature of DAC metadata.
  • Developed Ad-hoc and standard Reports/Dashboards with various KPIs, different Analytics Views (Drill-Down, Pivot Table, Chart, score cards, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
  • Involved in Implementing the single sign on (SSO).
  • Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
09/2011 to 2013
Senior OBIEE Developer Motorola Solutions Inc , ,
Project: Trilogy – Reporting
  • The project involved the implementation of OBIEE 11g and creation/enhancement of existing BI reports.
  • With thorough understanding of Oracle R12 modules such as Supply Chain, Project Accounting and Finance developed POCs working with BAs and the Client BI team.
  • Worked on design and development of various custom BI solutions for OBIEE reports and ETL strategy using Informatica. Created Multiple Hierarchies and created complex Drilldown Analysis in OBIEE 11g.Enhanced performance by creating aggregate tables and Indexes.
  • Traceability document was created to capture all requirements and their corresponding solutions, test cases and deployment.
  • Performed administration tasks related to the development and configuration of User roles for BI reports.
  • By using Static, Session and Request variables, configured Multiple Currency metrics for various analytics and Performance dashboard.
  • Implementation of the Security Setup by creating the Users, Groups, Web Groups in RPD and Web Catalog.
  • By updating the NQSconfig.INI file, enabled Usage Tracking and Dashboards to track performance.
  • Strong skills in both OBIEE repository and report architecture/development.
  • Perform troubleshooting and debugging of defects and production issues in the areas of Informatica, DAC and OBIEE.
  • Involved in PMO activities- Estimated the project milestones and their timelines for new RFPs and enhancement requests.
  • Extended support given during CAT (Customer Acceptance Testing) done by both BAs and Business Users.
  • Involved in tuning the long running reports and improving its performance.
  • Made recommendations to improve technical practices.
  • Extensively worked in Onsite Coordination for the offshore team and provided support on Ticket management on various applications.
07/2011 to 09/2011
OBIEE Developer Motorola Mobility Inc , ,

Project: EIM Enhancements

  • Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
  • Configuration of out-of-the box and custom Data Analytics of Order Management and Supply Chain.
  • Continuously monitor systems & active participation in system capacity planning and optimization strategy to eliminate performance issues.
  • Monitoring ETL run times, CPU and I/O times, report execution times, number of users vs report run times and preparing time profiling chart to identify the bottle neck in the various processes.
  • Adopt tuning techniques to remove the performance barriers.
  • Knowledge in architecture of OBIEE, Informatica tools helped in thorough analysis of backend log files and trace files to troubleshoot any application errors / issues.
  • Migration of ETL objects, SQL scripts using Kintana and ClearCase and also migrated OBIEE objects using catalog manager Worked extensively in creating OBIEE reports with Guided navigations, Drill down function, Conditional formatting, Summary detail views, external web links, HTML and CSS formatting options.
  • Responsible for creation of Design Documents, Test plan and Test cases, Traceability Matrix with Implementation notes and Back out Plan.
  • Involved in Performance Tuning of the various reports.
  • Created new Reporting and ETL data models as well as done enhancements to the existing OBIEE reports.
  • Developed new dashboards on the business needs, implemented dynamic column naming.
  • Configured OBIEE iBots to deliver analytics content based upon schedule and used automated iBot queries to obtain daily and weekly reports.
  • Addition of new Tags into the OBIEE instanceconfig.xml file to resolve issues such as default row displays and non-responsiveness of graph engine.
  • Created Service Requests (SR's) for RPD and Reports issues and coordinated with Oracle support team for resolution of the Issues Creation and Mapping of Application Roles and Policies using Fusion Middleware Control.
  • Migrated Catalog and RPD from OBIEE QA Environment to OBIEE PROD Environment.
  • Deployed OBIEE 11g RPD and Web Catalog by using Web logic Enterprise Manager.
  • Resolve RPD Merge issues by apply patch.
  • Responsible for the migration of ETL objects and Reports across various instances.
06/2007 to 07/2011
BI Developer Motorola Mobility Inc , ,

Project: SC Reporting

  • Developed RPD Subject Areas by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
  • Developed RPD Subject Areas by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
  • Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
  • Migrated Analytics RPD and Web catalog from one environment to another.
  • Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
  • Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc reports according to the client needs.
  • Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
  • Applied Cascading Prompts and Multi-Level Prompts on Dashboards.
  • Identified issues, performance bottlenecks and optimized the Business Intelligence Dashboards and Reports.
  • Deployed OBIEE 11g RPD and Web Catalog by using Web logic Enterprise Manager.
  • Responsible for monitoring the Scheduled ETL tasks and Scheduled Dashboards.
  • Report and Track Performance Issues to the respective stakeholders.
  • Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
  • Wrote Custom SQL Codes for the reports.
  • Raised Service Requests (SR's) of various critical status for Reports and RPD issues and coordinated with Oracle support team for resolution of the Issues Applied Optimization Techniques for the better performance of the reports.
  • Created ad hoc reports for End Users.
  • Knowledge and experience in all the objects configuration & implementation during Production migration.
  • Used external tables to Transform and Load data from Flat files into target tables.
  • Fixed RPD Merge issues by apply patch and resolving inconsistency errors.
  • Trained End Users and Pilot Users about OBIEE Tools.
Expected in 2007
Bachelor of Technology:
Government College of Technology - Affliated to Anna University - Coimbatore, Tamil Nadu
Accounting,Business Intelligence,Business ModelingConfiguration Management, Content Visualization,Capacity Planning,Catalog,Chart building,Client Communication,Data Migration, Data Modeling,Debugging, ETL,Supply Chain,Finance, General Ledger-GL,Migration,Enterprise Implementation, Optimization,  Order Management,Process Improvement,Project management,Quality Assurance,Requirement Analysis,Risk Assessment,Troubleshooting, Application Upgrades, OBIEE (10g/11g),Oracle DAC (10g/11g) ,Oracle 9, Oracle 10g/11g, Oracle Financial, PL/SQL,ClearCase,CSS & HTML,Doors,Oracle E-Business Suite,Peoplesoft,XML, Informatica 8.x, 9.x, Linux, BI Publisher, Windows Platform,Middleware,RDBMS,SQL, SQL server,TOAD,Unix,MS Visio, MS Excel, MS Powerpoint, MS Project, WebLogic, Windows Server,HP Quality Center,Kintana, Clearcase,BMC Remedy

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy


Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:


resume Strength

  • Length
  • Personalization
  • Target Job

Resume Overview

School Attended

  • Government College of Technology - Affliated to Anna University

Job Titles Held:

  • OBIEE Consultant
  • OBIEE Consultant
  • OBIEE Consultant
  • Senior OBIEE Developer
  • Senior OBIEE Developer
  • OBIEE Developer
  • BI Developer


  • Bachelor of Technology

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: