Sales Data

KINGSLEY F. FONGANG

Tampa, FL

● Phone: 240-***-**** ● Email: *********@*****.***

IT Professional with over 9 years of experience and demonstrated success in implementing database solutions and developing Business intelligence Reports and Dashboards to improve business functionality in diverse environments. Experience and extensive knowledge in OBIEE Reports and Dashboards Development, Oracle database design, administration, systems analysis. Skilled in reducing costs/driving process improvements with a strong background and proficiency in Database administration, analysis, data security, integrity and management.

TECHNICAL COMPETENCIES

Red Hat Linux RHEL 5.x & 6.x ● AIX ● Solaris ● Windows Server 2008/ 2012● OBIEE 10g/11g/12c ● BI Publisher ●Siebel Analytics 7.8.5 ● Oracle 12c/11g/10g/9i ● SQL ● PL/SQL ● UNIX Shell Scripting ● DBCA ● DBUA ● RMAN ● OEM ● RAC ● ASM ● ODI ● TOAD ● Data Pump ● SQLTRACE ● TKPROF● EXPLAIN PLAN ● STATSPACK ● AWR ● ADDM ● Data Modeling ● Erwin ● SQL Loader SQL Assistant ● RPD

EDUCATION

Master in Business Informatics EUV, Frankfurt/Oder, Germany

BSc in Environmental and Resource management BTU Cottbus, Germany

SUMMARY OF QUALIFICATIONS

Over 9 years of experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, and Testing of Data Warehousing and Database business systems and Implementations.

Over Five years of experience in Business Intelligence and Reporting using Dashboards in Weblogic and BI Answers.

Over 5 years of experience as an OBIEE 10G/11G/12C and BI Publisher 11g.

Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using OBIEE 10g/11g/12c, Siebel Analytics 7.x.

Experience in implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inman Methodologies.

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.

Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.

Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.

Created Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, Security Setup groups, access / query/report privileges.

Created Alerts using Agent for setting up KPI's in BI Answers.

Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication.

Have implemented Security Models for Dashboards, Row level, objects Level, Role Level, and Web Level.

Have worked with ETL Developers and other IT members in troubleshooting and in UAT.

Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.

Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.

Very Good experience with Data warehousing and OLAP technology – designing star schema, snowflake schema, fact and dimension tables, physical and logical data modeling using Erwin/MS Visio/Smart Draw.

Implementation of database software installs, upgrades, and patches

Conducts regular database performance Monitoring, testing and tuning

Conducts regular SQL tracing and tuning.

Capacity planning for database storage and memory

Implements and maintains operational and disaster recovery procedures

Manages database security, user accounts and access privileges

Good Knowledge of SSIS and Tableau

Good Knowledge of ETL Processes.

PROFESSIONAL EXPERIENCE

Wellcare Health Plans: (June 2015 –Present) Tampa, FL

OBIEE Developer

The aim of the project was to build Business Intelligence on top of their Data Warehouse to provide analytical reporting to its managers. Dashboards and reports were built for daily and executive reporting about finance, sales and services.

Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.

Monitored and documented change requests in requirements and ensured modified requirements are met during BI development.

Interviewed SMEs, asking detailed questions regarding reporting requirements to refine BRD and FRD.

Developed metadata repository and configured metadata objects in all three layers using Oracle BI Administration tool.

Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.

Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.

Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.

Used OBIEE Web Catalog to set up groups, access privileges and query privileges.

Configured schedulers and used iBots to generate and deliver reports based on business requirements.

Created dimension hierarchies, aggregation criteria and multiple logical sources in the BMM layer.

Involved in performance tuning of the dashboards with DBAs and BAs using cache management and aggregate tables.

Created schedules to seed and purge cache for cache management.

Implemented security by creating roles and web groups, and defined Object Level and Data Level Security.

Developer templates and reports in Oracle BI Publisher in rtf format.

Participated in designing, coordination and execution of User Acceptance Testing (UAT) with QA, BA and selected business users.

Environment: OBIEE 10g/11g/12c, BI Publisher, Oracle database 10g/11g/12c, EBS R11 (Financial), SQL Server DB, Informatica, Toad 9.6, Linux, Windows XP, XML, RHEL 6x.

Antares Pharma: (June 2013 – May 2015) Minneapolis, MN

Role: OBIEE Consultant

This Assignment involved implementation of OBIEE to analyze Sales and Marketing data. The project involved the entire life cycle of Business Intelligence. I worked on both Repository development and User Interface (UI) development.

Worked closely with the business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into the application.

Interacted with end users and developers to validate the data model.

Requirement validation of the reports and drill downs with business users.

Analysis of existing OLTP system and Identification of required dimensions and facts from the Database.

Creation and Customization of the OBIEE Repository (Physical, Business and Presentation layer).

Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository side.

Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics.

Created connection pools, imported physical tables and defined joins in the physical layer of the repository.

Worked on role-based dashboards in Pharma sales.

Created hierarchies based on the territory level for territorial level sales and contact reports.

Modified Presentation Layer to add presentation tables and columns to meet the business user needs.

Worked on repository and session variables.

Created materialized views and aggregates to improve performance.

Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.

Customized reporting with OBIEE Answers and integrated them into the Dashboards.

Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.

Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.

Created user level security for intelligence dashboards based on Business Requirement.

Created Dashboards with Dashboard prompts, Charts, Pivot tables.

Performed Data Validation of data in the reports and dashboards.

Extensively used SQL Tuning to improve performance.

Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.

Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.

Documented the design for intuitive understanding and future reference.

Performed production support for the project.

Environment: OBIEE 10g/11g, Oracle database 10g/11g/12c, ODI, Windows 2003 server, Red Hat Linux.

Verizon Wireless: April 2012 – May 2013) Falls Church, VA

Role: BI Consultant

The goal of this project was to implement a data warehouse as a single repository of sales data to provide reports of Order Bookings and Forecast data for the Sales Organization. The Reports were developed to cater the needs of all levels of Sales organization, from Sales Representatives to Executives.

Gathered Business requirements by interacting with the Business Analysts and the business users and created mockup reports.

Customized the Siebel Analytics Repository (physical, BMM, and presentation layers).

Created dimension hierarchies, aggregates, and logical sources in the BMM layer.

Worked on repository variables and session variables.

Used the security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges.

Created materialized views and aggregates to improve performance.

Customized Fund, Budget request Facts and Marketing Actual Facts star schemas.

Generated Reports by using Report features like Pivot tables, charts and view selector.

Modified the InstanceConfig.xml inorder to configure the maximum number of rows required on the report.

Created user level security for intelligence dashboards based on Business Requirement.

Customized and Developed Siebel Analytics reports Admin Download, Admin Expense Summary, Fund Vs Total Requested, Consumer Segment Summary, Budget request Transfer, Budget by Consumer Segment, Region Sales Summary and few other reports.

Created Dashboards with Dashboard prompts, Charts, Pivot tables.

Performed Data Validation of data in the reports.

Performed production support for the project.

Environment: OBIEE 10.1.3.4, Oracle 10/11g, SQL Server DB, Informatica, Toad 9.0, Windows XP.

Schaefer Systems International: (Feb 2011 – March 2012) Charlotte, NC

Role: Oracle Database Administrator

This role involved design and implementation of Oracle database 10g/11g/12c and systems solutions for automated material handling software systems and equipment in warehouses and distribution centers.

Designed and implemented database solutions based on software and system requirement specifications.

Installed, created, configured and administered Oracle 10g/11g Oracle Databases both on Windows and UNIX platforms.

Designed and implemented server hardware and operating system solutions based on software and system requirement specifications with a focus on Linux, UNIX, and AIX.

Implemented database and system test scenarios and executed tests on Oracle Failover Cluster, Oracle RAC environments.

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Supported & maintained the Production/Development databases on various servers.

Performed Explain Plan analysis for Query Optimization and SQL tuning.

Berean’s Partners LLC: (June 2008 – Jan 2011) Silver Spring, Maryland

Role: Oracle Database Administrator

A member of the DBA team managing over 60 (production/development) databases - (Oracle and some SQL Server instances) on Sun Solaris (UNIX), Linux (Red hat, Unbreakable Linux & CentOS) and NT/2000 platforms, with sizes ranging from 200M to about 5 terabyte of data on RAC and STAND ALONE environments.

Responsible for overall strategic planning & redesign of databases: Requirements gathering and Analysis, Design, Test and Implementation through the phases of System Development Life Cycle – DATA MODELLING.

Installed, created and configured Oracle 10g and 11g Oracle RAC Databases both on Windows and UNIX platforms.

Installed, configured and maintained Physical, Logical, Active STANDBY databases supported by Data guard on Oracle 10g, 11g RAC servers for the purpose of disaster recovery procedures.

Proficient in Erwin database design software, TOAD, PL/SQL DEVELOPER and Oracle Enterprise Manager database development tool

Established, designed, tested and implemented backup and recovery solutions including automated daily hot/cold backups depending on criticality of the Database - (RMAN, EXP/IMP DATAPUMP and) and database migration.

Provided performance tuning activities for Oracle database improvement. Tuned database through initialization parameter, SQL statement, and memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention.

Security implementation through basic and advance security techniques like applying recent Critical Patches and upgrades, appropriate user grants, permissions and profile management.

Utilized PL/SQL for programming and Stored Procedures especially enhancing capabilities to SQL.

Contact this candidate