OBJECTIVE

To be the most sought for

Business Intelligence & Data

Analytics Professional

delivering the best data insights

and solutions to the

organizations I work with.

SUMMARY

An Innovative, dedicated,

detail-oriented and business

savvy IT specialist with 15yrs+

professional experience in

Business Intelligence Analysis

and Development with Project

Management skills across a

broad range of information

technology functions and

diverse industry segments.

Currently searching for a

position, as Data Analyst,

Business Intelligence

Developer, and Project

Manager.

OGINA, MILLICENT

BUSINESS INTELLIGENCE & DATA ANALYTICS CONSULTANT

MBA (Finance), BSc. IST (1st Class Hons.),

Top IT Class of 2003 Student Award.

EXPERIENCE

DATA & CASE INTAKE ANALYST • INTERNATIONAL RESCUE COMMITTEE(IRC),NEW YORK, USA. MAR 2021 – CURRENT

Supported the Ethics and Compliance(ECU) team with case entry of reports from various Country Programmes into the Navex EthicsPoint System.

Carried out analysis of each case to determine whether a case warranted further investigations, feedback to the reporters or referral to the Country Programmes.

Coordinated various triage meetings with senior investigators for the regions across the globe(Asia, Central Africa, Middle East and Northern Africa, Latin America, USA & Europe) and the Senior Director Investigations in United Kingdom.

Delivered Quarterly & Annual Metrics to the NGO Management Committees in the US, Europe and United Kingdom in a Timely and Accurate Manner

Led efforts to ensure enhancements of existing systems to properly capture data for reporting and analytics.

Validated the data made available in the Navex EthicsPoint System to ensure it meets the reporting specifications and is accurate and complete.

Developed detailed System Operation Procedures documentation on the reporting process.

Extracted & Analyzed data from the Ethics and Compliance Systems and loaded onto Microsoft Power BI to come with insightful trends that are informative with recommendations to the management and other decision makers across the organizations.

Identified, evaluated and implemented external services and tools to support data validation and cleansing.

ad3kzu@r.postjobfree.com @MILLYARENDE 609-***-**** HTTPS://WWW.LINKEDIN.COM/IN/ MILLICENT-OGINA-764306B/

OGINA, MILLICENT

BUSINESS INTELLIGENCE & DATA ANALYTICS CONSULTANT

SKILLS

VISUAL ANALYTICS AND BI TOOLS

Qliksense, OBIEE, Tableau,

Microstrategy, SAS. Power BI.

SSIS/SSAS/SSRS.

System Development & Life

Cycle Management.

SYSTEMS AND DATABASE TOOLS

Toad SQL, PL/SQL, MS SQL

Server, Oracle Data Integration

(ODI), Certified Oracle Forms

Developer, Oracle Database

Administration.

Converged Billing

Systems(CBS) Customer

Experience

Management(CEM), Enterprise

Resource Planning

Systems(ERP)

PROJECT MANAGEMENT

PRINCE II Practitioner

ITIL (Information Technology

Infrastructure Library) Oct 2012

DATA WAREHOUSE INFORMATION TECHNOLOGY ANALYST • NEW JERSEY JUDICIARY,USA. SEP 2019 – MAR 2020

Led efforts to ensure enhancements/replacement of existing systems and new systems to properly capture data for reporting and analytics.

Designed and developed detailed specifications, including logical databases and dataset schemas for inclusion in the data warehouse.

Seeked for opportunities to optimize performance and increase reliability to enable users to access data and comply with data security policies and procedures.

Validated the data made available in the data warehouse to ensure it meets the specifications and is accurate and complete.

Coordinated work activities of others on the team, checked on specifications for completeness and accuracy, and advised managers on deadlines, rules and regulations.

Provided support to others within and outside the Judiciary on data available in the data warehouse including performing advanced troubleshooting, developing detailed documentation, developing training programs and conducting training.

Analyzed raw system data and extracted data from a large and complex data warehouse.

Aligned data set attributes and fields across different systems to ensure common connection points are in place when connecting and blending data sets.

Identified, evaluated and implemented external services and tools to support data validation and cleansing.

Documented current contents of data warehouse including plain-English descriptions and mapping back to data entry. ad3kzu@r.postjobfree.com @MILLYARENDE 609-***-**** HTTPS://WWW.LINKEDIN.COM/IN/ MILLICENT-OGINA-764306B/

2

OGINA, MILLICENT

BUSINESS INTELLIGENCE & DATA ANALYTICS CONSULTANT

People Management

Interpersonal Relations Skills

Stakeholder Engagement

STATISTICAL SOFTWARE

Python, SAS or R

WEB TECHNOLOGIES

HTML, VB.Net, SharePoint

DATA ANALYST• JOHNSON & JOHNSON(ETHICON) SOMERVILLE, NEW JERSEY, USA. MAR 2019 – SEP 2019

Driven innovative solutions for data and analytic visualization and reporting.

Provide back-up support in the completion of assigned scorecards, dashboards, power points and detailed reports.

Provided ad hoc analysis as well as predictive analysis by partnering with third party vendors and internal business customers.

Developed new and revised data queries and reports and led data cleansing activities as well as data extraction and transformation. DATA ANALYTICS CONSULTANT • ARAMARK GLOBAL, PHILADELPHIA, PENNSYLVANIA, USA. FEB 2017 – MAR 2019

Fulfilled business and functional information reporting and analytics requirements for Aramark Decision makers.

Provided time sensitive analyses on various metrics through my expertise with Oracle BI, Qlikview/Qliksense, Tableau, Microstrategy.

Executed Data Analytics strategic projects and initiatives with competing deadlines and priorities.

Systematically identified and defined problems, evaluated alternatives and implemented effective information solutions across systems Human Capital Management, ICIMs, Equifax, True screen.

Derived and packaged insights from salesforce, pricing, employee sourcing, recruitment, learning and development, engagement, retention and performance management systems.

Built an integrated data reporting structure and dynamic multi-purpose visualization dashboards in Qliksense, Tableau, Microstrategy, OBIEE to enable high-impact company analytics with actionable KPIs.

ad3kzu@r.postjobfree.com @MILLYARENDE 609-***-**** HTTPS://WWW.LINKEDIN.COM/IN/ MILLICENT-OGINA-764306B/

3

OGINA, MILLICENT

BUSINESS INTELLIGENCE & DATA ANALYTICS CONSULTANT

Reduced time to key business decisions by documenting and providing knowledge transfer materials and job aids on current business metrics reporting systems and rolling out training for across the global offices.

Effective in gathering specifications for data and reporting requirements then translating end user reporting requirements into functional design documents.

Developed SQL queries to extract, manipulate and/or calculate information to fulfill data and reporting requirements.

Performed routine and ad-hoc data analysis, reconciliation, and correction of any data and system issues.

Developed and mocked up prototype reports to demonstrate user requirements. Building test cases and performing comprehensive testing on developed reports.

BUSINESS ANALYTICS DEVELOPER • SAFARICOM(NAIROBI KENYA), VODAFONE GROUP (UK AUG 2012 - DEC 2016

Over 13+ years of Multi-BI environment experience in development, design, support of BI related projects on various analytical tools: Microsoft BI, Oracle BI, Microstrategy, Tableau, Qlik, R, SAS.

Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Integration Services (SSIS). Sound Experience and understanding of SSAS, OLAP cube and Architecture, writing expressions in SSRS and Expert in fine tuning the reports.

Experience in report writing using SQL Server Reporting Services

(SSRS), creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous ad3kzu@r.postjobfree.com @MILLYARENDE 609-***-**** HTTPS://WWW.LINKEDIN.COM/IN/ MILLICENT-OGINA-764306B/

4

OGINA, MILLICENT

BUSINESS INTELLIGENCE & DATA ANALYTICS CONSULTANT

sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all. Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.

Expertise in creating Tableau dashboards, workbooks for various BI measures and KPI's and organizing Interactive Dashboard views and objects using Tableau Desktop, Server and Online. Creating and scheduling Tableau Data Extracts (TDE) to refresh data monthly/weekly.

Experienced in Data Analysis and Validation with complex queries and functions to validate summary data from underlying detail data.

● Developed SQL scripts and Packages, SQL Server Procedures, Functions, Views, Triggers and Materialized Views for ETL

●Managed the OBIEE repository, creating reports and deploying to the production environment.

●Strong analytical skills and ability to adapt to new technologies very quickly. Excellent spoken and written communication skills.

●Very Strong on data modeling tools:Erwin Data Modeler, Visio, and TFS with full understanding of the Software Development Life Cycle. BUSINESS INTELLIGENCE ANALYST • SAFARICOM(NAIROBI KENYA), VODAFONE GROUP (UK) JAN 2007-JUL 2012

Led a team of analysts in generating insights the company’s management and decision-making teams in various SBUs like Enterprise, Commercial, Mobile Money (Mpesa) Business Units.

Led the company’s Business Intelligence Initiatives. Researched and made recommendations on latest and innovative Business Intelligence and Analytics platforms that could give more value-addition in the company decision-making.

ad3kzu@r.postjobfree.com @MILLYARENDE 609-***-**** HTTPS://WWW.LINKEDIN.COM/IN/ MILLICENT-OGINA-764306B/

5

OGINA, MILLICENT

BUSINESS INTELLIGENCE & DATA ANALYTICS CONSULTANT

Worked with stakeholders to collate all the requirements and systems specifications and coordinated with vendors enhancements and on migrations from one platform to the next i.e. ProClarity to Oracle Business Intelligence, carrying out system testing and training of users.

Acted as SPOC (Special Point of Contact) for project implementation across companywide systems: Convergent Billing Systems, Customer Relationship Management Systems, Fixed Data and Fiber Provisioning, Mobile Data Pricing Systems, Mpesa (Mobile Money) Systems.

Partnered with cross functional teams to analyze and prepare detailed study of current BI state across the company ensuring alignment to overall company data analytics strategy and vision.

Collected business requirements for BI analytics by reviewing needs with each business unit: Consumer, Enterprise, Mobile Money Payments, and implementing BI solutions.

Translated complex business and application requirements for business teams into functional specs for the development team for further releases of the product

Based on business requirements, developed Complex SQL Stored Procedures, Views, Triggers using T-SQL to implement the business rules and transformations.

Experienced in publishing and managing Live BI Dashboards Reports on the web for Executive Management for High Level Data Analysis and Drill down Interactive Metrics.

Performed Critical Data Analysis and Generated Forecast Graphs/Reports for predictability and key performance measurements on 25 million subscribers using SAS, Python & R.

ad3kzu@r.postjobfree.com @MILLYARENDE 609-***-**** HTTPS://WWW.LINKEDIN.COM/IN/ MILLICENT-OGINA-764306B/

6

OGINA, MILLICENT

BUSINESS INTELLIGENCE & DATA ANALYTICS CONSULTANT

EDUCATION

MASTERS IN BUSINESS ADMINISTRATION (MBA)

AUG 2009 • UNITED STATES INTERNATIONAL UNIVERSITY (USIU) Finance and Strategic Management

A Dissertation on Challenges Faced by Companies Listed in the Stock Exchange: The Case of Nairobi Stock Exchange

BACHELOR OF SCIENCE IN INFORMATION SYSTEMS AND TECHNOLOGY MAR 2003 • UNITED STATES INTERNATIONAL UNIVERSITY (USIU) Top Student Award

Magna Cum Laude(1st Class Honors) GPA 3.802 out of 4.0 ad3kzu@r.postjobfree.com @MILLYARENDE 609-***-**** HTTPS://WWW.LINKEDIN.COM/IN/ MILLICENT-OGINA-764306B/

7

Contact this candidate