Post Job Free

Resume

Sign in

Data Analyst

Location:
Snellville, GA
Posted:
February 05, 2020

Contact this candidate

Resume:

Olukayode Adegoke

**** ******** **** *****,

Snellville, GA 30039 adbmtp@r.postjobfree.com

678-***-****

Concentration: Data Science, Data Analytics, BI

Willing to relocate: Anywhere

Authorized to work in the US for any employer

Work Experience

Senior Consultant (Data Analyst/Scientist)

COMPUMATICS INTERNATIONAL (Nigeria) Limited Lagos, Nigeria

January 2015 to June 2019

Duties:

Training, consulting and implementation for clients

Software Development, Data Analysis and all computational matters.

Research and recommend the implementation of new technologies.

Disaster Recovery planning.

Relational & Object Databases.

Oracle PL/SQL, Data Warehousing, Data Migration (Extraction Transformation & Loading - ETL), Database Design, Database Reporting Systems - Cognos and Oracle Products (Impromptu, IWR, PowerPlay, Transformer, Query, Oracle Reports, Oracle Forms, Oracle AS), R.

Digital Data acquisition.

C/C++ and general computer hardware and Operating System principles.

Java and the related technology like Servlets, Java Server Pages (JSP), and HTTP.

Internet and Communication technology issues.

Evaluating emerging technologies. Providing comprehensive ICT solutions to business problems.

Head of ICT

Redeemer's University

Mowe, Ogun State, Nigeria

April 2009 to December 2014

Duties:

ICT infrastructure management.

Interfacing with software and hardware vendors.

Strategic ICT planning.

Contract negotiation.

ICT human resource development - ICT skills.

Research and recommend the implementation of new technologies.

Disaster Recovery planning.

Software Development, Data Analysis and all computational matters.

Database operations and support.

Community ICT skills initiative - I.T. Academy (Microsoft, Oracle, Cisco, & others)

Other duties as assigned by the Vice Chancellor.

Budgetary and Project planning matters.

Staff supervision.

Technical Director/ Administrator

COMPUMATICS INTERNATIONAL (Nigeria) Limited

Lagos, Nigeria

May 2007 to April 2009

Duties:

Training, consulting and implementation for clients

Software Development, Data Analysis and all computational matters.

Research and recommend the implementation of new technologies.

Disaster Recovery planning.

Relational & Object Database theory and design.

Oracle PL/SQL, Data Warehousing, Data Migration (Extraction Transformation & Loading - ETL), Database Design, Database Reporting Systems - Cognos and Oracle Products (Impromptu, IWR, PowerPlay, Transformer, Query, Oracle Reports, Oracle Forms, Oracle Application Server).

Digital Data acquisition.

C/C++ and general computer hardware and Operating System principles.

Java and the related technology like Servlets, Java Server Pages (JSP), and HTTP.

Internet and Communication technology issues.

Senior Database Administrator

Total Systems (TSYS)

Columbus, GA

December 2006 to May 2007

Duties:

Manage the Data Warehousing function, including new development and operational support.

Oracle Database Administration: several instances of OLTP and DSS.

Application DBA - query performance analysis and optimization.

Strong development experience - advanced Oracle SQL & PL/SQL development. Extensive use of PL/ SQL packages, functions, and stored procedures - use Java stored procedures and use of REF CURSORs and COLLECTIONs.

Manage the development, implementation and maintenance of the data warehouse including data analysis and modeling, metadata definitions, extraction, transformation, loading and information access; and set-up of knowledge communities.

Coordinate information management and technology requirements.

Process improvement practices

Provide upper management and stakeholders with accurate summary and detail information.

Manage enterprise architecture planning and standards activities.

Provide technical direction and advice to the upper management on technology trends and issues.

Ensure that the work produced by Data Warehousing function is of outstanding quality.

Senior Database Analyst

United Parcel Service - Supply Chain Solutions

Alpharetta, GA

June 2004 to November 2006

Duties:

Manage the Data Warehousing function, including new development and operational support.

Oracle Database Administration: several instances of OLTP and DSS.

Application DBA - query performance analysis and optimization.

Strong development experience - advanced Oracle SQL & PL/SQL development. Extensive use of PL/ SQL packages, functions, and stored procedures - use Java stored procedures and use of REF CURSORs and COLLECTIONs.

Manage the development, implementation and maintenance of the data warehouse including data analysis and modeling, metadata definitions, extraction, transformation, loading and information access; and set-up of knowledge communities.

Coordinate information management and technology requirements.

Provide upper management and stakeholders with accurate summary and detail information.

Manage enterprise architecture planning and standards activities.

Responsible for information/application access and security policies.

Manage and maintain enterprise architecture strategy and technology plans.

Monitor standards for the technical environment and proactively implement action plans to rectify non-conforming areas.

Concurrently manage multiple technology initiatives.

Provide technical direction and advice to the upper management on technology trends and issues.

Ensure that the work produced by Data Warehousing function is of outstanding quality.

Participate in the development and adoption of standards and methodologies for software development.

Support logistic optimization and reporting efforts.

Database and System Status monitoring with BMC Patrol, Oracle Enterprise Manager & Shell scripts.

Senior Business Intelligence Manager

TOTAL EMED CORPORATION

Franklin, TN

January 2003 to June 2004

Duties:

Management, design, user requirement gathering, and development of Data Warehouse using Oracle 8i, 9i and 10g databases and portal.

A mixed environment: ETL (Cognos DecisionStream, Oracle Warehouse Builder), report development (Impromptu, Oracle Report, Oracle Discoverer, Oracle Portal report), delivery tools (Cognos IWR, Oracle Portal).

Installation, administration, configuration and complete support of Oracle 9i & 10g databases, Oracle 9i & 10g Application Server.

Developing and managing team in the development of a portal using Oracle 9iAS and 9iDS tools

Oracle Designer, Oracle Warehouse Builder, Oracle Reports, Oracle Discoverer, Portal reports, etc. Heavy PL/SQL stored procedures and triggers; some Java stored procedures.

Developed many PL/SQL portlets to present business data in graphical and tabular forms as appropriate. Extensive use of PL/SQL packages, functions, and stored procedures - use Java stored procedures and use of REF CURSORs and COLLECTIONs.

Relational and Dimensional data modeling.

Coordinating tool evaluation and purchase.

Managing IT procurement budget.

Senior Consultant

CenturyTel/PROGRESSIVE IT

Dallas, TX

October 2002 to December 2002

Duties:

As a consultant at CenturyTel (Monroe, LA) was primarily charged with Data Warehouse applications performance enhancement issues.

Assisted with overall data warehousing and data delivery.

Relational and Dimensional data modeling.

Oracle 9i database data warehousing options like Materialized VIEWs and Query re-write were used.

Senior Software Engineer

COMPUMATICS INTERNATIONAL

Atlanta, GA

November 2001 to October 2002

Duties:

Trained clients in software development and mathematics.

Trained clients in Oracle PL/SQL, Data warehousing, Data migration, Database design, ETL, Cognos Products (Impromptu, IWR, PowerPlay, Transformer, Query, etc) C/C++ and general computer hardware and Operating System principles.

Also trained clients in Java and the related technology like Servlets, Java Server Pages (JSP), and HTTP.

Senior Software Engineer

BELLSOUTH TELECOMMUNICATIONS

Atlanta, GA

January 2000 to November 2001

Duties:

As a consultant at Bellsouth Telecommunication, Science & Technology Division, implemented a data warehouse / reporting system for a Broadband ADSL provisioning network that used Oracle8 database as the backend.

Heavy data Extraction, Transformation and Loading (ETL).

Used Oracle stored procedures and triggers in data migration and verification.

The development environment are both SUN Spark 5 running SUN OS 5.6 and PC running Microsoft Windows NT 4.0. SQL Navigator, SQL Loader and SQL Plus were used.

Wrote installation guidelines and installation scripts.

Managed Cognos Impromptu WEB Report Server, generate reports in Cognos Impromptu 6.0 and report administration; Cognos PowerPlay was used for data analysis.

Wrote miscellaneous UNIX shell scripts to resolve data problems.

Distributed Defects Tracking System (DDTS) was used to track software defects and resolutions.

Java JDBC and RMI were used to interface with NetExpert for data migration.

Education

Bachelor of Science (Mathematics)

University of Florida - Gainesville, FL

Associate of Science (Land Surveying)

Miami-Dade College - Miami, FL

Basic Training

Federal School of Surveying

School Certificate in West African

Lagelu Grammar School

Skills

Oracle Database, Data Science and BI (10+ years), Database Performance Analysis (10+ years)

Additional Information

•Worked on all phases of database and data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

•Exceptional background in analysis, design, development, computation, customization, and implementation and testing of software applications and products.

•Skilled in crafting ICT solutions to solve business problems - design, implementation, and maintenance phases.

•Demonstrable expertise utilizing RDBMS - Oracle, SQL Servers, and DB2. Plus ETL tools like Oracle Warehouse Builder (OWB) and PL/SQL. Other Oracle tools. Microsoft Data Transformation Services (DTS).

•Strong leader with experience training developers (& users) and advising technical groups on ETL/ Data Warehousing best practices.

•Excellent technical and analytical skills with clear understanding of design goals of ER modelling for OLTP and dimension modelling for OLAP.

•Team player with excellent communication and problem solving skills. Good people-skills.

Tools: Oracle 8i, 9i, 10g DB, 10g AS, 11g DB, SQL Loader, Oracle Import, Export and Data Pump, Oracle tools (Warehouse Builder, Designer, Discoverer, Portal), TOAD, ErWin, Proc* C, Java, SQLJ, C, Cognos tools (Impromptu, IWR, DecisionStream, PowerPlay), IQ/Objects, Distributed Defects Tracking System (DDTS), C/C++, Java, Graphical Data System (GDS), ArcInfo/ArcView - GIS Tools, TCP/IP (and related protocols - HTTP, FTP etc), Unix Shells, PowerBuilder, Pascal. Statistical Analysis System (SAS), and R.



Contact this candidate