SUMMARY

• Highly seasoned and creative OBIEE Developer with 8 plus years in the IT Industry and expertise in full life cycle business intelligence project management, understanding of all aspects of end to end life cycle design, development, implementation, testing and documentation of business applications using oracle technologies, (OBIEE 11g)
• Proficiency in Oracle Business Intelligence Enterprise Edition (OBIEE 11g)
• Proficient in implementing Enterprise Business intelligence
• Excellent ability in RPD metadata modeling, Developing reports, Dashboards and create interactive reports with BI Publisher Reporting
• Strong experience working with Web Services and OBIEE Answers Analytics Admin Tool
• Proficient in MS Office Suite and the Peachtree Accounting System
• Structured Query Language - SQL
• Proficient in Operating systems - Windows XP, Windows 7/8, Linux
• Solid Knowledge of ICH, GCP guidelines for Clinical Research
• Knowledge of clinical trial methodology relating to the monitoring of clinical trials
• Experience in Epiq system, Medwatch, Catsweb, SAP, PIMS, Meditech
• Knowledge of EDC - Medidata Rave and Clinphone
• Detail oriented and efficient in time management, flexible and dependable
• Excellent problem solving skills with strong communication, interpersonal, and organizational skills
• Ability to manage multiple tasks effectively re-align priorities while adhering to deadlines Proficiency in development and production support and OBIEE application design, build, test, experience, including requirements gathering, ownership of metadata and dashboards and reports.
• Extensive experience in migration of OBIEE Presentation Services objects using OBIEE Catalog Manager and repository files between different environments.
• Involved in all the phases of gathering requirement, Proof of Concept, gap analysis, design, development and implementation of software applications.
• Extensive expertise in providing end-to-end business intelligence solution by configuring metadata& building analytics metadata repository, star schemas, snow flake schemas, dimensional modeling design, building business models, generating reports, and creating interactive BI dashboards.
• Extensive experience in migration of OBIEE Presentation Services objects using OBIEE Catalog Manager and repository files between different environments.
• Experience in development of BI Publisher Reports using various templates using BI Publisher Desktop Tool.
• Well versed in Debugging, Optimizing and Performance Tuning of OBIEE Answers / Dashboards / Reports to improve Performance at Database
• Performed gap analysis and feasibility study for the given requirement.
• Extensive experience in testing the Data Warehouse and Business Intelligence applications.
• Self-motivated; able to work independently and in teams; can handle multiple projects while paying attention to details.
• Created and Administered the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Designed, developed, and implemented BI solutions using Oracle's OBIEE suite of products to support the company's reporting, analysis, and visualization requirements.
• Extended and customized the OBIEE metadata repository including the physical, business model, and presentation areas.
• Extensive knowledge of Oracle Business Intelligence Enterprise Edition (OBIEE) from a development perspective as well as from an architecture perspective

TECHNICAL SKILLS

RDBMS: Oracle v 10g, 9i, 8i

Operating Systems: LINUX, Sun-Solaris, Unix, Windows 9X/2K/XP

Languages: SQL, PL/SQL, C, C++, Java

Tools: & Utilities: Forms 6i/9i, Reports 6i/2.5, SQL*Loader, Jdeveloper, Oracle Workflow Builder, TOAD and SQL*Plus, BI- Publisher, MS Visio, Data Loader, OIT 8.3.7, OBIEE 11.1.1.7.13 , 11.1.1.7.15

Hardware: HP 9000, Intel Pentium based PC’s

PROFESSIONAL EXPERIENCE

Confidential, Virginia

Oracle HCM & OBIEE Developer

Responsibilities:

• Objects including repository, interactive dashboards, reports and interactive BI Publisher. Interacting with business analysts and end users to gather requirements and prepare functional and technical documents.
• Experienced in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Created Dashboards, interactive reports in BI Publisher using Analytics requests and assign Permissions to those dashboards to users depending on their user group.
• Design Oracle BI Publisher Data Models, Data sets and Templates, sub templates which will be used by business in daily basis.
• Testing and validating BI Publisher SQL query reports using SQL server as a data source and SQL Developer
• Creates various analytic reports using Global and Local filters
• Participates in weekly meetings with the business users to figure out what was working and what needed changes.
• Training of end users and analyst, helping them to understand the reports, how to navigate the reports, and understand the report requirements.
• Experience in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (RPD) using Oracle BI Administration Tool.
• Skilled at configuring OBIEE Metadata Objects including repository, interactive dashboards, reports and interactive BI Publisher.
• Experienced in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Creating Dashboards using Analytics requests and assign Permissions to those dashboards to users depending on their user group.
• Experience in configuring and set up of OBIEE Security configuring object level and database level security.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, prompts, filters, and variables.
• Creating Dashboards using Analytics requests and assign Permissions to those dashboards to users depending on their user group.
• Experience in configuring and set up of OBIEE Security configuring object level and database level security.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, prompts, filters, and variables.
• Experience in creating executive reports with BI Publisher integrated with OBIEE.
• Created and granted privileges for the users using Analytics Catalog Manager.
• Skilled at configuring OBIEE Metadata Objects including repository, interactive
• Helped users resolve issues during New Hires and Assignment changes.
• Modified OA Framework Pages to display Total Score to Managers.
• Worked on Employee, Address, Phone, Assignment data conversions using HRMS API's.
• Worked on OA Framework personalization to hide Rating levels from Employees.
• Worked on creating Descriptive Flex fields, EIT's and Special Information Types.
• Prepared the code packs to migrate deliverables from one instance to another instance.
• Fixed the errors for multiple reports in several instances.
• Created New Objectives Template to hide inactive Objectives for Employees; New Competencies template to restrict selective competencies.
• Fixed the errors for multiple reports in several instances.
• Developed an OTL report to identify missing time cards and approve them using a custom program.
• Set up New Elements, Element Links, Formula Results.
• Worked on AIM Documentation like MD50, MD70, MD120.
• Created several fast formulas for HRMS Modules.
• Worked on HRMS Reports and Customizations. The users using Analytics Catalog Manager.

Confidential, New Jersey

OBIEE Developer

Responsibilities:

• Interacting with business analysts and end users to gather requirements and prepare functional and technical documents.
• Created and customized Oracle BI metadata in the analytics repository designing star schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool with OBIEE Administration Tool.
• Created Dashboards using Analytics requests and assign Permissions to those dashboards to users depending on their user group.
• Creates various analytic reports using Global and Local filters
• Participates in weekly meetings with the business users to figure out what was working and what needed changes to be done.
• Training of end users and analyst, helping them to understand the reports, how to navigate the reports, and understand the report requirements.

Confidential, Daytona Beach, FL

OBIEE Developer

Responsibilities:

• Created and customized Oracle BI metadata in the analytics repository with OBIEE Administration Tool
• Built the Physical Layer, Business Model and Mapping Layer, Presentation Layer of a Repository by using Star Schemas.
• Experience in migrating the repository and web catalog from development to production environment.
• Developed and maintain BI Reports, Dashboards, Web catalog, Answers
• Created Dashboards using Analytics requests and assign Permissions to those dashboards to users depending on their user group.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.
• Participates in weekly meetings with the business users to figure out what was working and what needed changes to be done.

Confidential, Lake Forest, CA

OBIEE Developer

Responsibilities:

• Participated in the preparation of quarterly investment performance Reports and Dashboards required by the Pension Advisory Committee
• Created Capital Expenditure analysis reports as part of the yearend audit activities
• Created trial balances for all fully reconciled funds
• Performed reconciliation of operating and cash management bank accounts on a daily basis
• Prepared monthly expense budget reports for the General Fund
• Performed analyses of budget line items
• Prepared monthly and quarterly trial balances, journal entries and disbursement journals
• Monitored Investment Account by posting dividend and interest schedules for the General Fund and Charitable Trust Investments
• Created monthly statements for House Account for over 100 sisters' residences
• In charge of handling check requests from various departments and individual sisters
• Performed variance analyses of budget line items
• Prepared monthly and quarterly trial balances, journal entries and disbursement journals
• Ensured that the fair market value for each investment account was recorded in the Peachtree Accounting System at the end of each quarter
• Maintained correspondence as well as investment activity for the alternative investment accounts

Environment: Oracle Applications 11.5.10/ R12 (AP, AR and PO), Install Base modules Oracle Database 9i, SQL*Loader, Windows XP, UNIX

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Installation of hardware and software, troubleshooting
• Provide helpdesk support for over 2000 employees
• Operated the electronic data processing equipment and responded to all situations with the appropriate actions while following the HIS system guidelines.
• Verified and maintained all tape backups for all critical Meditech HIS systems on rotation schedule.
• Manage multiple types of end users and devices on Meditech Hospital Information System.
• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing.
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Utilized Track-It Help Desk to document and track user related tickets.
• Trained end uses on Microsoft Outlook
• Supported in limit system down time during internal or external outages periods
• Used Track-It system for inventory management, auditing hardware and software.
• Identify, isolate and repair computer equipment showing wear and tear as well as during preventative maintenance routines

Confidential

Oracle Application Developer

Responsibilities:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing.
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated sqlldr using shell scripting.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.
• Involved in Form Personalization.
• Created SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface (OM) programs to support the interface requirements.
• Excellent understanding of AOL & Sys Admin, developed new reports, forms, functions, validation sets, request sets and concurrent programs.
• Created new reports Quotations received and Orders booked through TeleSales and integrated with Oracle Applications.
• Developed custom Report RMA, to execute for the required set of books.
• Developed a workflow package to run on Reminder on Thursday for all employees and warning on Monday morning to the employees who did not sent time sheets.
• Used TAR Assistance for expenditure id and functional currency in Project Accounting.
• Thorough understanding of Workflow Order to Cash and Procure to Pay.
• Customizing the Self Service Timecard to Auto-Populate the Hours Type according to Project and Task selection on the Project/Payroll Layout.