SUMMARY

• Over 5 years’ experience in OBIEE 11.1.1.5 providing end - to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports and using dashboards.
• Extensive experience installing both database and obiee software on a windows platform.
• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Scheduler, Oracle BI Interactive Dashboard and BI Publisher.
• Experienced in interacting with Business users conducting interviews to gather, analyze and document user needs, business processes, identifying reports/KPIs and other requirements then rolling out deliverables.
• Extensive experience in OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated OBIEE implementations.
• Expertise in using dimensional hierarchy modeling and time series modeling in the Business Model and Mapping layer to meet business requirements.
• Expertise in OBIEE Publisher using multiple data sources. Trained end users to easily design report layouts directly in a Web browser, this dramatically reduced the time and cost needed to develop and maintain reports.
• Proficient in implementing comprehensive Security functionality - created users & web groups, external table security using session variables, tested and validated the model using OBIEE Admin tool and associating Catalog objects & Web modules with the created users / groups to data and object level security
• Building star and snowflake schemas in the repository as well as using the Foreign key link in the physical layer and the New complex joint key in the Business Model and Mapping layer.
• Expertise in using Alias and Dim tables so that the hierarchy and time series modeling would meet business requirements.
• Experience in using and troubleshooting the main servers: Oracle BI Server, Oracle Presentation Server and Oracle BI Scheduler.
• Experience in a Multi User Development Environment (MUDE), pulling r.p.d from versioning tool to common directory and making changes to meet business requirements.
• Expertise in designing and developing custom reports using BI Answers and making them available in Dashboards. Implemented drill in place so that users could view data at the granular level and make effective decisions concerning the business.
• Experience in Configuring the Oracle BI Scheduler server and creating ibots to alert users so that they can be proactive and make important business decisions quickly and at less cost.
• Expertise in managing the NQSCONFIG.INI file to manage the rpd
• Experience in Data security and administration of OBIEE
• Expertise managing the cache environment.
• Proficient in Installation, Configuration, and Administration of OBIEE 11g standalone
• Experience with Metadata and Interactive Dashboard Development with drill down capabilities.
• Experience interfacing OBI with Oracle Database.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Business Intelligence Developer

Responsibilities:

• Working closely with Business Analysts in understanding the Analytical requirements and creating the business model for generating reports as per the user requirements.
• Interacting with business analyst and sales representatives for gathering Obiee Reports, Dashboards requirements and to define business and functional specifications
• Configuring OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changing the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business and Mapping model layer. Establishing the logical joins/keys required to support drill-down aggregation.
• Creating dimension hierarchies and assigned levels for each level.
• Designing and Configuring Dashboards in Analytics for different groups of users to view figures across regions, products with the facility to drill down to individual customer relationship manager.
• Developing Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management (CRM) to analyze the financial service center statistics for different campaigns, Customized pre-built dashboards.
• Developing custom reports/Ad-hoc queries using OBI Answers and Filters.
• Responsible for Unit and System Testing and Performed Data Validation for all the reports that are generated from OBIEE.
• Performed Testing of the IT Defects and CR raised by the Testing team.
• Interfacing OBI with Oracle Database
• Using SQL developer in Performance tuning situations
• Identifying the aggregate levels for each source and created dimension sources for each level of aggregates

Environment: Oracle Business Intelligence suite (OBIEE), Oracle 11g

Confidential

Quality Control Assurance

Responsibilities:

• Utilized CLO for accessing transactional data for auditing
• Review, and evaluate the work of Funders, Vendors and Executive Funders
• Used Titan to verify notes in deal
• Accessed external Vendor sources in verifying validity of information in our databases
• Worked through Crystal reports to verify funded deals for evaluation
• Worked in Excel as a database and a reporting tool
• Ensured all funded deals are according to Confidential guidelines
• Extensively consulted Roadmap an internal policy and procedures document as a guideline in performing audits
• Consulted with end users on policy formulations
• Compile and update weekly reports with scorecards and send reports to the end users
• Utilized Excel to create formulas for calculations, entering data, formatting work sheets and creating graphs
• Reviewed and update State Specific task audits, ensure this critical aspect of our business is been adhered to
• Attended Monthly departmental calibration meetings intended to improve performances.
• Attend weekly Customer meetings to update on new policies and procedures.
• Updated PFR and distributed
• Facilitate side by side with new hires and current employees, ensure understanding of current error trends and prescribe diagnostic measures.
• Extensively used excel to create pivot tables, and pivot charts.
• Used Microsoft excel to create graphs and charts to aide in simplifying analysis of data.
• Supported Senior managers by providing

Confidential

IT Support

Responsibilities:

• Provide helpdesk support and resolve problems to the end user’s satisfaction
• Monitor and respond quickly and effectively to requests received through the IT helpdesk
• Monitor Service Desk for tickets assigned to the queue and process first-in first-out based on priority
• Modify configurations, utilities, software default settings, etc. for the local workstation
• Utilize and maintain the helpdesk tracking software
• Document internal procedures
• Assist with on boarding of new users
• Ensure each workstation has a computer, monitor, keyboard, mouse, hard drive, and any additional specialized equipment
• Install, test and configure new workstations, peripheral equipment and software
• Maintain inventory of all equipment, software and software licenses
• Report issues to the Service Desk for escalation
• Manage PC setup and deployment for new employees using standard hardware, images and software
• Assign users and computer to proper groups in Active Directory
• Perform timely workstation hardware and software upgrades as required