OBIEE BI Senior Consultant
Resume:
Nabil Derbali
**** ******* ****, *******, ** ****0
********@*****.***
PROFESSIONAL SUMMARY
Over 15 years of overall business experience in the implementation and management of large scale programs through all SDLC stages, from gathering requirements to deployment and maintenance.
Professional experience in Federal management consulting, development, operations and maintenance, to include Federal Accounting systems, Federal Financial Management, Federal Budget Formulation and Execution, OMB A-123, Oracle Financials, Oracle HCM Analytics ETL, OBI HCM Apps Oracle Database, SQL, PL/SQL, XML, UNIX environment, UNIX Shell scripting, XML, Oracle Access Manager (OAM), Encryption Technologies, Informatica, ODI, OWB, Data Warehousing, Oracle OBIEE 11g, BI Publisher 11g, Hyperion Essbase implementation and maintenance. Also experience with DoD Financial Management, SFIS Accounting Library, USSGL structures in a COTS ERP system. Knowledge of OMB guidance and policy related to federal financial systems.
Federal Agencies Consulted with:
oDepartment Of Labor (DOL)
oDOD Army Project (Secret Clearance)
oPatent and Trademark Office (PTO)
oDoD DAI program (Secret Clearance)
oOffice of Personnel Management (OPM)
oSmall Business Administration (SBA)
oFederal Communications Commission (FCC)
oDepartment of Health and Human Services (HHS)– IHS
oFederal Aviation Administration (FAA)
oNational Oceanic and Atmospheric Administration (NOAA)
oEnvironment Protection Agency (EPA)
oDepartment of Labor (DOL)
oDepartment of Education (DoEd)
oUnited States Agency for International Development (USAID)
Oracle experience 11g and R12
oCertified OBIEE 11g
oHyperion Essbase and Report Studio
oOracle OAM, IDM, OHS WebTier and WebGate.
oOBIEE/Noetix Reports, RPD files, Physical layer, Business Model Layer, Presentation Layer, Analyses, dashboards, charts, Pivot Tables, Gauge, Prompts, SQL Statements, SQL Formula, Filters, BI Publisher, Admin tool setup.
oData Warehouse methodologies and ETL process
EXPERIENCE HISTORY
Booz Allen Hamilton (GCE Cloud)
May 2014 – Present
Associate
Program: Department Of Labor (DOL)
• Worked with different business process teams for Oracle financial management services that include handling data migration, reports development and Undelivered Orders (UDO) batch de-obligation.
• Worked with BAH senior management and DOL management to keep them informed about batches de-obligation progress, and to maintain their BI reports and dashboards.
• Managed and processed client UDO batch de-obligation files from receiving monthly batches to delivering final control reports.
• Worked with the Application team and the Accounting Review team to deliver a complex process output and keep the client’s financial appropriations and funding reporting on course.
• Served as the Task Lead for all reports development and maintenance (Informatica and Jaspersoft).
• Developed and modified operational reports across financial business processes based on client requirements utilizing BI tools Informatica and Jaspersoft.
• Develop required SQL extracts used for reconciliations/reports.
• Worked with the customer to develop requirements, functional resolutions, and verification procedures.
• Provided production support for Oracle Federal Financials and addressed customer tickets and requests.
• Provided solutions to Customer Support team for Tier II and Tier III issues
• Validated solutions using functional, integration and regression testing
• Recommended enhancements regarding product, application or documentation.
• Designed and utilized training documentation for clients and customer support analysts
• Designed, documented, validated, and gained approval for test plans and test deliverables
NuWave Solutions, LLC
Sept 2013 – May 2014
Business Intelligence Senior Consultant
Army Enterprise Management Decision Support (EMDS)
Project: Army DOD
Designed and implemented a data warehousing and OBIEE solution for readiness level information to be utilized by Army leaders and commanders. Created BI reports using OBIEE and BI Publisher and published the information in multiple dashboards for different commander units. This information is critical for the leaders as it allows them to have a clear picture of their forces, and use that information to predict and manage their personnel, equipment and training.
Used Oracle Data Integrator (ODI) as an ETL tool to extract and transform data for reporting purpose.
Participated on building a data warehouse and multiple data marts using Oracle Data Warehouse builder (OWB).
Designed data integration solution for their multiple structured and unstructured authoritative data sources including Databases, excel sheets, and commander comments to present a unified view through OBIEE and BI Publisher.
Led the effort of a brand new OBIEE 11g installation, upgraded multiple environments to the latest OBIEE version, implemented latest patches and configured these environments.
Worked on updating RPD file and creating new subject areas for the customer.
Build new dashboards and reports using both OBIEE and BI Publisher.
Interview business users to gather requirements around the specified area and produce requirements documentation
Worked with client's technical personnel to extract data from the existing warehouse and populate a newly developed data model (star schema structure)
Scheduled appropriate reports for daily delivery to identified recipients
Setup access to reports and dashboards based on security requirements
Configured cache management for better performance.
Worked with Oracle Access Manager (OAM) and IDM product installations and setups for access manager, OAM, single sign-on and federated security with LDAP.
Worked on installation and configuration of Oracle HTTP Server (OHS) Web Tier and Oracle WebGate.
Worked with Business Intelligence Enterprise suite SSO integration.
Worked with OBIEE Oracle Portal suite and content management SSO integration
Phacil Inc.
February 2013 – June 2013
OBIEE Hyperion Essbase Consultant
Project: Patent Trademark Office (PTO)
Supported the PTO Office of Patent Financial Management (OPFM) in successfully deploying Oracle Hyperion Essbase and BI Publisher tools to manage the agency Compensation and Non Compensation budget data for both Execution and Formulation.
Created Various BI Publisher Reports and aligned them on various OBIEE Dashboards as per client requirements.
Experience in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
Created Templates such as Employee Account Detail, Reports such as Payroll budget by department, Prompts such as Employee Name in BI Publisher
Schedule reports and bursting as per the requirement in BI Publisher and represented them in dashboards.
Agency has to move their Budget Formulation and Execution data from a legacy system based on Oracle Financial Analyzer (OFA) to Hyperion Essbase and BI Publisher.
Migrated Hyperion application from Windows to Linux using Life Cycle Management (LCM) tool.
Performed a mapping between OFA architecture and Hyperion architecture to find differences and anomalies.
Worked on the ETL piece to extract historical budget data, transform it and load it into Hyperion Essbase.
Loaded current legacy budget data in Access DB, transformed the file, removed unnecessary data from Metrics, Version, and Orgs and loaded the file into Essbase..
Updated and corrected dimensions, added new data elements and fixed the hierarchy.
Created and organized the correct metadata files, loaded them into Hyperion so the historical data will load correctly.
Created Calc and MDX scripts to calculate cubes and rollup data from one cube to another.
Developed reports and forms using Reports Studio.
Trouble shot issues and problems raised by the customer and responded to their request promptly.
Drafted a step by step procedure to document the process of Budget Execution synchronization for the purpose of ETL and to fix Budget Execution Operating Plan.
L-3 Communications (ENGILITY)
April 2009 – February 2013
Senior Systems Analyst
Project: DoD - Defense Agencies Initiative (DAI)
Successfully supported MDA Agency go live on Oracle E-Business Suite (EBS) with OBIEE Reporting tool.
Translated end business user reporting needs into logical data components and worked with the Business Intelligence (BI) and E-Business Global team to source data.
participated in the design and testing of the data warehouse components, participated in the setting and configuration of RPD file to include all 3 layers (physical, BMM, and Presentation)
Worked on Users Administration and performance tuning of various reports.
Gathered requirements and participated in the design and testing of OBIEE/Noetix tool, created reports and published them in Dashboards using Answer sheets and BI Publisher.
Created reports based on global DOD requirements and provided Management with Ad-hoc reports based on individual needs
Worked with ETL (Informatica) group to convert legacy data and load it to the new ERP system, tested and validated data for accuracy
Worked with end user to convert old reports into OBIEE reports
Worked as a key client facing representative to define requirements and help in their implementation.
Provided hands-on client support for developing OBIEE reports. Worked with both technical and functional teams to determine functional reporting requirements, developed and published various reports using Answers sheets, dashboards, charts, Pivot Tables, Gauge, Prompts, Formula, and Filters. Customized SQL statements to satisfy client requirements.
Designed and executed test scripts and helped Agency users running their tests.
Wrote end user training documents on how to use the tool and create new reports
Developed OBIEE report metrics for upper Management.
Conducted training workshops related to OBIEE toolset to empower end users.
Drafted RD20 (Requirement document) and MD50 (Design document) for the Agency specific OBIEE reports, and updated Agency BR100 (Configuration document).
Good understanding of OBIEE reports and dashboard best practices performance
i360technologies, Inc.
September 2008 – March 2009
Senior Oracle Federal Financials Consultant
Project: Office of Personnel Management (OPM)
Worked on the OPM project, setting up and configuring Federal Oracle R12 iProcurement, Purchasing, AP, Fixed Assets, iSetup, iSupplier modules.
Worked on configuring and documenting the new Oracle R12 SLA (Subledger Accounting) for PO, AP and FA.
Worked on Personalizing iProcurment module to add extra DFF fields to the Procurement page.
Personalized iProcurement to add a “BETC” code field at the Distribution lines.
Worked on iProcurement and PO Approval Workflows and customized it to who can approve or modify the document.
Worked on the Contracting Officer Notification Workflow when inspection results in a rejection status. Improper invoices are put on Hold and email notifications are sent to the Contracting Officer reflected in the PO.
Worked on PRISM workflow documentation and interface with iProcurement.
Wrote and executed functional test scripts.
Wrote detailed configuration and design documents for the modules worked on.
Planned CRP session and configured the environment.
Worked on implementing and documenting GL (General Ledger) and Fed Admin modules with Hyperion for Budget Planning, Budget Formulation and Budget Execution.
Helped implement and document CM (Cash Management) module.
Helped configuring AR module with the SLA piece setup.
Responded promptly to client questions and concerns and discussed high level requirements to generate more detailed requirements.
Supported i360 Technologies internal efforts for implementing and testing a new Oracle R12 instance.
SRA International, Inc.
December 2007 to August 2008
Manager
Projects: Office of Personnel Management (OPM), Federal Communications Commission (FCC), Small Business Administration (SBA)
Supported SRA’s business growth initiatives. Supported proposal efforts for winning new business and new Oracle projects for different government agencies.
Planned and prepared 3 Oracle demo-instances for three agencies (OPM, FCC and SBA).
Compared and analyzed documentation about the “As is” process and the recommended “To be” process to determine where to focus team efforts.
Worked on client requirements and Government FSIO requirements to determine a Fit-Gap analysis.
Gathered requirements, defined business process, designed and developed functional specifications for RICE-W components, wrote and executed test scripts. Prepared business transactions for Procure-to-Pay process, including iProcurement, Purchasing and Payables, Accounts Receivable, Loans, Advanced Collection.
Worked on a demonstration of Oracle Business Intelligence Enterprise Edition Plus (OBIEE+) Hyperion Planning to manage Federal client Budget Formulation and Budget Execution requirements.
Provided hands-on support for developing OBIEE reports and dashboards. Gathered and discussed client requirements, worked with team members to define client specific Federal financial reporting needs. Developed and customized reports, graphs, charts and published them in dashboards. Designed and executed test scripts and test plans.
Gathered requirements for the design, development and testing of Oracle Discoverer reports.
BearingPoint
June 2006 – December 2007
Functional Senior Consultant
Projects: Federal Aviation Administration (FAA), Department of Health and Human Services (HHS)
Worked on FAA Cost Accounting System (CAS) and its integration with the global Delphi System.
Worked on FAA different business processes to include their Budget Formulation and execution programs.
Worked with different FAA Organizations on their actual “As is” process and “To be” process for accounting for all different Project Cost Accounting for each department.
Worked on defining requirements and redefining business processes, configuring Oracle applications, testing, and training.
Part of the HHS - Unified Financial Management System (UFMS) project functional team
Worked on iProcurement/Purchasing and Accounts Payable using Oracle Federal Applications 11.5.10. Responsible for coordinating and managing project activities for the iProcurement/ Purchasing and Payables 11i implementation. Responsibilities included Project Management, Business Process Analysis, Requirements Gathering, Fit/Gap analysis, Legacy Data Conversion, Design & Configuration.
Worked on verifying Federal Accounting transactions using the Accounting Treatment Reference Manual.
Documented and flowcharted the “As is” process and the recommended “To be” process.
Reviewed business transactions for different modules (GL, iProcurement, PRISM, AP, Projects and Fixed Assets/SUNFLOWER) to determine gaps.
Drafted business process flowcharts and recommend improvements such as eliminating duplicate tasks and streamlining processes.
Worked with Technical and Functional Leads regarding application issues during testing phase for multiple interfaces and data conversions.
Performed functional reviews of client requirements and business cases to identify discrepancies for different modules (GL, iProcurement, PRISM, Projects, AP, and Fixed Assets/ SUNFLOWER).
Planned and executed test scripts and drove application test activities using Mercury Quality Center for different modules.
Documented test results and resolved testing issues with the client and team members.
Helped document user training manuals by capturing screen shots.
Was part of the iProcurement/PRISM stabilization team after Go-Live.
Client-facing and team lead skills. Strong communication and written skills.
Problem solving skills to address customer issues under tight deadlines; using own initiative and Oracle experience.
Able to contribute to the development of proposal efforts.
SAIC
October 2001 – June 2006
Systems Analyst
INVERTIX
January 2001 – August 2001
QA/CM Manager
COMMERCE ONE/APPNET
November 1999- January 2001
Project Manager
CSC
October 1998 – October 1999
Test Lead
The National Endowment for Democracy (NED)
March 1997 – September 1998
Internal Auditor
TECHNICAL EXPERIENCE
OBIEE 11g Reporting
BI Publisher 11g
Oracle Federal Financial 11.5.10 and R12
Federal Accounting
Financial and Cost Accounting
Rational Unified Process (RUP) methodology
Rational Software Tools (Test Studio, ClearCase, ClearQuest, RequisitePro)
Mercury WinRunner and LoadRunner, Mercury Test Director and Quality Center
CMMI Level 3
ISO Compliance
Project Management (MS Project)
Internal Controls, Internal Audits
Full Software Development Life Cycle experience (SDLC)
Software testing
Software metrics
EDUCATION
George Washington University, Washington DC
Masters of Science in Accounting 1992
HONORS AND AWARDS
Quality Award winner, USAID NMS Project under CSC lead.
Full Scholarship Award to Graduate School, George Washington University.
Contact this candidate