Olukayode Adegoke
Snellville, GA 30039 adbmtp@r.postjobfree.com
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.