Data Analyst Oracle Pl
Resume:
Alayande Jamiu Damilola.
adqehq@r.postjobfree.com
Address: **, ***** ******, *** *******, Oworonshoki, Lagos. Lagos state, Nigeria Profile Summary
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 who has the ability to work under minimal supervision. I am seeking to work in a challenging environment where my skills, education can be productively utilized.
KEY SKILLS
• In-depth understanding of Data Warehousing concepts including dimension and Fact tables.
• Good Understanding of SQL And Scripting
• Proficient in the development of functions and stored procedures using Oracle PL/SQL.
• Proficient in the use of Microsoft standard office tools (Word, Power Point etc.)
• Proficient in Data Mining & Analysis Tools such as (Toad, Excel, Power BI)
• Good Understanding of Microsoft Power BI
• Proficient in Extraction Loading and Transformation (ETL), SQL Loader, and External tables.
• Proficient with Microsoft SSIS, SSRS and SSAS.
• Proficient in UNIX/Python commands/ UNIX Shell Scripting, scheduling of CRON jobs, files manipulation etc.
• Strong analytical and problem-solving skills.
• In-depth Knowledge of oracle 10G,1IG, and 12 C Databases
• 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, designing partitioned and non-partitioned tables, indexes, 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
WORK EXPERIENCE
9MOBILE TECHNOLOGIES LIMITED (MAY 2021 --- TILL DATE) DATA ANALYST
• To empower and support customers (specifically, mobile network operators) to define, test, prioritize, execute and report on multi-channel, rule or event-based campaigns via our in-house campaign management system.
• Perform subscriber profiling based on certain attributes, consumer behavior and business rules as defined by customer
• Read, extract, transform, stage and load data using selected tools and frameworks as required and requested.
• Perform end to end maintenance of all components and services of the campaign management system
• Perform tasks such as writing scripts, calling APIs, creating and modifying data flows, write SQL queries, etc.
• Work closely with the other team members for 3rd party integration of data sources • Monitoring and reporting on campaign performance and tracking leads for call to action.
HUAWEI TECHNOLOGIES LIMITED (DECEMBER 2020 --- MARCH 2021) Data Analyst
• To empower and support customers (specifically, mobile network operators) to define, test, prioritize, execute and report on multi-channel, rule or event-based campaigns via our in-house campaign management system.
• Perform subscriber profiling based on certain attributes, consumer behavior and business rules as defined by customer
• Read, extract, transform, stage and load data using selected tools and frameworks as required and requested.
• Perform end to end maintenance of all components and services of the campaign management system
• Perform tasks such as writing scripts, calling APIs, creating and modifying data flows, write SQL queries, etc.
• Work closely with the other team members for 3rd party integration of data sources • Monitoring and reporting on campaign performance and tracking leads for call to action. Tenece Professional Services Limited (AUGUST 2019 --- NOVEMBER 2020) ETL /Business Intelligence Specialist
(United Bank of Africa/Datawarehouse and Application)
• Data Analysis for oracle and Microsoft Sql server database reporting.
• Designing and Implementing of complex files, databases sourcing (ORACLE, 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.
• Wrangling Data from different African countries for the aim of creating data mart
• Building PowerBI Dashboards that show the analytics of the bank financial ratios and various channels.
• creating a unique package using Microsoft Sql server integration services (SSIS) Bluechip Technologies Nigeria Limited
Data Analyst /Business Intelligence Consultant
(9Mobile Enterprise BI/Data Warehouse Application)
• Responsible for Supporting and Developing the Current BI Applications and Initiatives
• Involves in The Investigation and Analysis of User Problems and subsequent resolution which helps creating a comprehensive Root Cause Analysis document.
• Configure, Build, And Test Application or Technical Architecture Components
• Creating and Executing Technical Test Plans for Application Change, Upgrade and New Development.
• Ensuring checks are in place over applications for Data Integrity.
• 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, 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
EDUCATION
2015 B.Tech, Computer science- Ladoke Akintola University of Technology, Oyo State. 2007 Ayo memorial college, Oniparaga, ondo state. (SSCE). INTEREST
• Traveling – Meeting people and experiencing new cultures.
• Reading – Reading motivational books
• Sports – Football, Athletics, Lawn tennis
REFERENCE
Available on demand
Contact this candidate