SUMMARY:

• Over 17 years of Oracle Development.
• Vast experience in the use of Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Discoverer Administrator and Desktop/Plus Editions.
• Good PL/SQL and SQL writing abilities with a working knowledge of stored packages, procedures, functions and SQL scripts.
• Good experience with Oracle Applications through prior use as Accounts Payable / Accounts
• Receivable User as well as CRM Customizations Development.
• Knowledge of Database Modeling, Architecture, Administration and Security Methodologies and concepts with Oracle RDBMS.
• Extensive experience in Business Analysis.
• Excellent Inter - Personal skills with prior Customer Service experience.
• Conducted extensive user training in the use of OBIEE and integrating reporting with the business needs.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98, Windows NT/2000/XP

Programming Languages: Oracle PL/SQL, SQL, Developer 2000

Databases: Oracle 8i, 9i and 10g

Database Administration Tools: Oracle - SQL*Plus, Procedure Builder TOAD 5.0/7.5

SQL Navigator: SQL Loader

Reporting Tools: OBIEE 10g, 11g, 12c OBIA 11.1 Oracle Discoverer 4.1, 9i, 10g Oracle Developer - Forms and Reports 6i

Hyperion: Tableau Desktop

MS Access MS Excel: Oracle Applications: Oracle 11i & R12 Applications Suites - AP, AR, GL, CRM, HR, OPM, OTM, FA

ETL: Informatica PowerCenter 9

WORK EXPERIENCE:

Confidential, Miami, FL

OBIEE/OBIA Reports & Dashboard Developer

Responsibilities:

• Leading the overall OBIEE Development effort for Confidential as part of a global Confidential Oracle R12 reimplementation/upgrade project.
• Client facing role involving gathering requirements from existing reports built from tools such as Hyperion, Tableau and ad hoc queries, and re-developing them in OBIEE.
• Development and conversion of over 300 Hyperion and ad-hoc reports into OBIEE and BI Publisher, and placing them in a number of dashboards based on business requirements from Oracle EBS AP, GL, PO, FA modules.
• C ustomizing OBIA pre-packaged OBIEE metadata solutions in GL , FA and Financial Analytics.
• Administered the OBIEE RPD to customize the OBIEE objects, by enhancing the Physical, BMM and Presentation layers. Preparation of documentation related to the OBIEE development strategy, reports and dashboards. End user training on the OBIEE.

Technologies: Oracle EBS R12; Oracle Database 10g, 11g, 12c; OBIEE 11g; 12c; OBIA 11x; Tableau Desktop; SQL Developer, Hyperion

Confidential, Atlanta, GA

OBIEE/OBIA Reports & Dashboard Developer/Data Analyst

Responsibilities:

• In-depth requirements gathering sessions with the business, GAP analysis, TDDs’ towards the planned Business Analytics data warehouse for HR, Finance, Manufacturing Analytics using Pre-built OBIA. Administering OBIEE which involved building and maintaining the Repository (RPD).
• Gathering user requirements for the development of OBIEE reports and Dashboards, extracting data for analysis and interpretation, assisting on research projects, performing validation procedures to ensure data quality, acting as database content expert and interfacing with end users.
• Building and maintaining complex routines and reporting using automation, testing and maintaining data integrity across multiple databases and environments.
• Translating needs, issues, and ideas into effective strategies and action plans, communicating results/recommendations to project sponsors, clients, and various senior level audiences. ETL development using Informatica PowerCenter. On-call production support involving fixing database and informatica object failures.

Technologies: Oracle Database 10g; OBIEE 11g; OBIA 11x; SQL Navigator, Informatica 9

Confidential, Jacksonville, FL

OBIEE/OBIA Reports and Dashboard Developer/Analyst

Responsibilities:

• Complete maintenance of the OBIEE environment, which included building and customizing the RPD and all objects within in line with the Company’s reporting strategy.
• Participating in defining the project scope and implementation, working closely with business users to capture business needs and requirements for data, development of reports and dashboards based on those requirements, building working prototypes using OBI tools. Developed and documented test scripts for extensive reports and dashboards testing.
• Worked collaboratively with BI Administrator in data modeling and data sourcing/mapping to meet Business requirement needs. Scheduled IBOTS and Delivers.

Technologies: Oracle Database 10g; OBIEE 10g & 11g; SQL Navigator

Confidential, Minette, AL

OBIEE Reports Developer / Business Analyst

Responsibilities:

• Responsible for conducting needs analysis, defining business requirements, development of functional specifications and serving as primary liaison between the business unit and the development team.
• Responsible for the development of complex reports utilizing Oracle Discoverer and OBIEE.
• Developed many Reports using different Views (Tables, Charts, and Pivot Tables) using BI ANSWERS, Built and Managed Interactive Dashboards as well as Dashboard and Page Prompts.
• Extensively used Delivers and iBots for delivering personalized reports to users, Training end users in Discoverer and OBIEE report writing and providing ongoing support to the organization with reporting and analysis needs.

Technologies: Oracle Database 10g; Oracle Applications 11i - Modules (AP, AR, PO, OPM, OTM); Oracle Discoverer 10g Discoverer Plus & Desktop; OBIEE 10g; Toad

Confidential, Horsham, PA

Oracle Discoverer Developer

Responsibilities:

• Responsible for the interfacing with the business with the goal of gathering user requirements and translating them to technical deliverables, development of complex reports utilizing Oracle Discoverer using Noetix.
• Training end users in Discoverer report writing and providing ongoing support to the organization with reporting and analysis needs.

Technologies: Oracle Database 10g; Oracle Applications R12 - Modules (AP, AR, PO, FA, OPM, OTM) Noetix; Oracle Discoverer 10g Discoverer Plus; Toad

Confidential, Juno Beach, FL

Oracle OBIEE & Discoverer Consultant

Responsibilities:

• Conducted workshops to gather user requirements and performed Gap Analysis, documented and translated them to technical requirements.
• Modified OBIEE pre-built dashboards and reports comprising of tables, pivot tables, chart views using Oracle BI ANSWERS, Worked on reports delivery using Oracle BI Delivers, Recreated complex Oracle Discoverer reports in OBIEE. Creating and maintaining Database objects such as tables, views and PL/SQL packages.
• Developed different kinds of Reports (pivots, charts, tables/compound layout) using global and local filters/variables.

Technologies: Oracle Database 10g; Oracle Applications 11i - Modules: (AP, AR, HR); OBIEE 10.1; Oracle Discoverer 10g Discoverer Plus; Toad

Confidential, Louisville, KY

Oracle Applications & Discoverer Developer

Responsibilities:

• Designed and created Oracle database objects consisting of Tables, Views, PL/SQL procedures, functions and packages, loaded theses objects using SQL Loader, specifically within the HR module.
• Designed and Developed discoverer reports for Oracle application users based on user-requirements.
• Performed the role of business analyst, while interfacing with the management team in other to deliver accurate discoverer reports in a timely manner. Modified existing discoverer reports to increase their functionality.
• Performed a lot of SQL query tuning so as to ensure both historical and new reports ran as fast as possible.
• Worked with Oracle application SMEs and end users to analyze and validate requirements,
• Worked with the DBAs and system admin in other to ensure the discoverer components of the system worked optimally.

Technologies: Oracle Database 11i; Oracle Applications 11i - Modules: (HR); Oracle Discoverer 10g Discoverer Plus; Toad

Confidential

Oracle OBIEE Developer

Responsibilities:

• Conducted business analysis meetings to gather, refine and document user requirements.
• Responsible for the design and development of presentation layers for business analytics data for senior executives.
• Responsible for the development of specific reports, responsible for the definition, development, and testing of the reports using Oracle BI ANSWERS and analytics necessary to retrieve data from both operational and analytical data stores and transform it in to business-actionable information.

Technologies: Oracle Database 11i; Oracle Applications 11i - Modules: (AR, AP, GL, OM & OTM); OBIEE, Discoverer 9i (Both Admin and Plus), Toad.

Confidential, Atlanta, GA

Oracle Discoverer Developer

Responsibilities:

• Designed and Developed discoverer reports for Oracle application users based on user-requirements.
• Modified existing discoverer reports to increase their functionality and used BI (OBIEE) products in Oracle 11i application.

Technologies: Oracle Database 11i; Oracle Applications 11i - Modules: (AR, AP, GL & HR); Oracle Discoverer 9i & 10g (Both Admin and Plus); Toad

Confidential, T ampa, FL

PL/SQL Developer

Responsibilities:

• Re-write of Legacy procedures, functions, triggers with emphasis on efficiency.
• Resolving daily bugs encountered by application users, writing reports using Discoverer.
• Managed full life-cycle of additional features targeted for subsequent releases, including requirements capture, analysis and design, unit testing and user acceptance.

Technologies: Toad 7.4, Oracle 10g Database; .Net, Windows XP, Oracle Discoverer 9i, Oracle Financials 11i- Modules (AR, AP, OPM)

Confidential, Delray Beach, FL

Oracle Developer

Responsibilities:

• Create PL/SQL packages, procedures functions, tables.
• Review requirements, design and write design documents, Prepare test plans and conduct testing and debugging.
• Loading flat files into Oracle database using SQL* Loader.

Technologies: Toad 7.4.0.1, Oracle 9i Database, ChangeMan, SQL Loader, FTP, Oracle Financials 11i Windows XP

Confidential, Roswell, GA

PL/SQL Programmer

Responsibilities:

• Created PL/SQL packages, procedures and functions to facilitate field operations for auto inspections,
• Analyzed and Fixed PL/SQL Bugs, created adhoc reports with SQL to support month end and other processes, analyzed and manipulated data to enforce business rules.
• Built an End User Layer using Discoverer Administrator, and built complex reports on top of the EUL.
• Communicated with end users to gather their reporting requirements and designed the report layout and created reports using Oracle Discoverer 9i.
• Followed software through the development life cycle from analysis, design and coding through testing and deployment.

Technologies: Toad 7.4.0.1, Oracle 9i Database, Bug Tracker, SQL Loader, FTP, Windows XP, Oracle Discoverer 9i

Confidential, Atlanta, GA

Senior PL/SQL Programmer

Responsibilities:

• Write PL/SQL packages, procedures and functions to implement business processes for Niku6/Sigma time reporting system.
• Create and tune SQL queries, create database objects (tables, sequences, indexes, views), write SQL scripts to migrate data from old to new database, test PL/SQL program units, trouble-shoot and fix PL/SQL program units.
• Developed discoverer reports for application users.

Technologies: Oracle Database 8i; Oracle Discoverer 4.1, SQL Navigator, FTP, Unix