Bisiriyu Ayomide K.

adiojm@r.postjobfree.com

234**********, 234**********

Profile

A proactive and self-motivated individual with years of experience in Application Development/Support, Oracle Data Analysis / Programming and Business Intelligence. A proven team player with good interpersonal and communication skills. A quick learner with the ability to work under minimal supervision.

KEY SKILLS

In-depth understanding of Data Warehousing concepts including dimension and Fact tables (Star Schema)

Proficient in drawing Entity Relationship diagram

Good Understanding of SQL and Scripting

Data Mining, Analytics and Business Intelligence

Proficient in the development of functions and stored procedures, Packages using Oracle PL/SQL.

Excellent Understanding of Data Manipulation, Data Visualization and Interrogation Techniques.

Proficient in Data Analysis Tools such as (Toad, Excel, Power BI)

Good Knowledge of Big Data/Hadoop Skills (Hive, Spark, Pig, Kafka etc.)

Good Understanding of OBIEE

Good Knowledge Of Statistical Modeling Techniques And Algorithms

Proficient in Extraction Loading and Transformation (ETL), using SQL Loader, Shell Scripting and External tables.

Proficient with Microsoft SSIS, SSRS and SSAS and Power BI

Proficient in UNIX/Python commands/ UNIX Shell Scripting, scheduling of CRON jobs, files manipulation etc.

Good Understanding Of Customer Data Analysis, Propensity Modelling And Segmentation Techniques

Working Knowledge Of Data Mining/ Analysis Using Statistical Analytical System(SAS) & SQL, Problem Solving And Reporting/Presentation

In-depth knowledge of Oracle 10G,11G, and 12 C’s terms like Procedures, Functions, Packages, Indexing, Cursors, Views, Materialized Views, Collections, Bulk processing, Dynamic SQL, Parallel processing, Sequence creations, designing partitioned and non-partitioned tables, indexes, Exchange Partitioning, temporary tables and external tables as well as SQL Tuning.

Working knowledge of fixing oracle errors and data related issues.

Working knowledge of Windows and UNIX Operating Systems and Oracle Exadata

Good knowledge of Database Planning and Designing

Excellent Data Integrity/Management skills

Excellent Understanding of Data Manipulation, Interrogation and troubleshooting Techniques

Excellent written/verbal communication skills

COMPANY

WORK EXPERIENCE

Aug 2015-Till Date

Dec 2011-July 2015

Aug 2010-Dec 2011

Jan 2010-August 2010

Aug 2008 – Jan 2010

Data Analyst /Business Intelligence Consultant

Bluechip Technologies Nigeria Limited

Team Lead Development (Enterprise BI/Data Warehouse Application:9MOBILE NIGERIA)

Developing Business requirements i.e. Smart messaging Application, Activation Location Tracker, Recharge Split Promo, Base stations Monitoring, Red Alert Promo, Hourly Recharge and Activation Monitoring, RGE Event Tracker, Market Share Analysis, Subscribers Segmentation, Churn-Activation-Returnee & Active Base Analysis, Subscriber Credit Score, Recharge Pattern,

Device Analytics, Data 2g/3g/4g Base, Network KPI, 9Mobile Magic Hour Promo etc.

Responsible for Supporting and Developing the Current BI Applications and Initiatives

Delivering Quality, Accurate and Timely Reports

Involves in The Investigation and Analysis of User Problems and subsequent resolution, which helps creating a comprehensive Root Cause Analysis document.

Prompt and Accurate Escalation of Faults

Ensure Closure of Assigned Faults

Ensures Smooth Integration of New Systems and Protocols

Creating and Executing Technical Test Plans for Application Change, Upgrade and New Development.

Continuous Transfer of Knowledge and Skills On New Database

Ensuring checks are in place over applications for Data Integrity.

Create Scripts That Will Automate Operational Efficiency

Ensuring compliance with data related policies, roles, standards and responsibilities.

Multidimensional & dimensional design and implementation (Facts and Dimensions)

Data Analysis for oracle database reporting.

Designing and Implementing of complex files, databases sourcing (ORACLE, MYSQL, MS SERVER)

Ensuring timely completion of development requests and Resolution of Internal/External Issues.

Providing data quality checks on all developments and requests.

Data Mining, Analytics and Business Intelligence

Improvement of the loading processes with the introduction of oracle exchange partitioning concept.

Designing and implementation of stored procedures, packages and functions in Oracle PL/SQL for the ETL processes.

Assisting stakeholders to Drive Smartphone and Data Penetration within Existing Customer Base and Acquiring New Data Customers.

Integration of Big Data Solutions with Existing Reporting and Analytical Solutions

Managing and assuming responsibility of providing the defined set of services to the Business proactively and ensuring all SLAs and OLAs are appropriate.

Designing and Building OBIEE repository: importing metadata, creating physical layer mapping, business model mapping and presentation layer for report definition.

Ensure Generation of Relevant Reports for Management Purposes

Setting up agents for OBIEE automated reports etc.

Responsible for The Development of New Applications, Maintenance, Support and Upgrades to Existing In-House Developed Applications.

Track Revenue Growth for Data Products

Application Support Engineer / ETL Developer (ETISALAT NIGERIA)

oETL Developer for Etisalat Nigeria’s Data Warehouse/Business Intelligence Application.

oPlanning, Developing and implementing Etisalat’s Data Warehouse ETL processes.

oAutomates the loading and monitoring processes via UNIX shell scripting & PL/SQL

oResponsible for System Routine Maintenance

oDeveloping all daily SMS jobs that notifies the Business on the previous day’s KPIs.

oPart of the development team for Etisalat’s Network KPI Report.

oUpholding All Customer Information Security and Enforcing All the Non-Disclosure Agreements.

oData Sourcing from ERP, VAS, Network, Billing (OCS), SMPP, SIMREG teams.

oEnsure Closure of Assigned Faults & Issues.

oDelivery of Key Business KPIs: Active Subscriber (RGE 90), Revenue, Churn, Activation, Product Performance, SIMREG Reports, Mobile Financial Services reports, Customer Relations Reports

oPerform Data and Trend Analysis of All Revenue Generating Transactions

oMonitoring and Reporting System Performance Identifying Exceptions and Unusual Trends

oParticipate in Developing Daily reports that compares Actual against Forecast

oEnsure That All Information and Data Collected, Stored, Shared and Reported Are in Line with Etisalat Guidelines

Application Support Engineer (SIMPLEX: E-PIN Application: ETISALAT NIGERIA)

oSupported Etisalat’s E-PIN Management application

oEnsures EPIN application is always online

oCreating Scripts That Will Automate Operational Efficiency

oEnsure the System Availability by Ensuring all the processes run successfully

oEnsure Availability of System Performance Statistics

oPrompt Delivery of Quality, Accurate and Timely Reports

oPrompt and Accurate Escalation of EPIN order faults

oEnsure That Simplex Functionalities Are Optimal and Maintained Periodically.

oEnsure EPIN orders are delivered on time

Supported the NDIC Data Migration and Reporting application via Microsoft SSRS.

Youth Segment Promo (YSP & Eagle Eye) Applications Support (AIRTEL NIGERIA)

Ensure smooth running of Airtel’s TRU Application

Ensure smooth running of Track RCV Application

Creating and Dropping of partitions of YSP’s database.

Manual migration of subscribers to the TRU’s Benefit classes.

Monthly loading of data into the RCV Database for Airtel’s Eagle Eye Report

Identifying business requirements and help business analyst to define user information/report requirements.

Providing support in user acceptance testing of Airtel’s Business Intelligence Reports

Member of Airtel’s Oracle Business Intelligence Reports team

Designed the production of ERDs (Entity Relationship Diagrams)

Assisting in the identification of BI report’s user’s requirement

Compares the user’s manual reports to the Business intelligence reports to ensure data validity

The following are some of the key achievements that have been undertaken:

Ensured the oracle 10g YSP Application was running smoothly

Creating a standard business intelligence report

Development of process documents for all supported solutions.

Ensured report validity by checking the variance in reports created with manually created reports

Worked effectively with Customer Care unit for manual migration of subscribers

Assisted in the delivery of monthly reports to determine regions where recharge cards are used.

Sep 2004 – Aug 2005

Kurfi Local Government, Kurfi, Katsina State.

National Youth Service Corps (NYSC)

EDUCATION

Feb 2008

2005

Oracle10g Certified Database Associate (OCA)

B. Sc. Business Administration - Olabisi Onabanjo University, Ago-Iwoye, Ogun State, Nigeria

INTERESTS

Traveling – Meeting people and experiencing new cultures.

Reading – Reading motivational books.

Sports – Football, Athletics, Lawn tennis.

REFERENCE

Available on Demand

Contact this candidate