Scroll To View More
Dwight Dale Cummings, M.Sc., Python Data Science Developer in Kingston, St. Andrew Parish, Jamaica
Dwight Dale Cummings, M.Sc.

Python Data Science Developer in Kingston, St. Andrew Parish, Jamaica

Member since November 8, 2016
After a successful career developing Oracle applications, Dwight returned to his first love, AI programming and retooled himself as a Python expert and data scientist. He further honed his skills by developing PyOraEBS (an SQLAlchemy-based Python framework) and by serving as Python data science expert in the field of algorithmic trading. Dwight is living his dream by doing what he loves and interfacing with diverse people and cultures.
Dwight is now available for hire

Portfolio

Experience

  • SQL, 20 years
  • Oracle Database, 20 years
  • Pandas, 3 years
  • Jupyter Notebook, 3 years
  • Python 3, 3 years
  • NumPy, 3 years
  • NLTK, 1 year
Kingston, St. Andrew Parish, Jamaica

Availability

Full-time

Preferred Environment

PyCharm, PgAdmin,Toad, SQL Developer

The most amazing...

...Python library I've developed is PyOraEbs: a Python framework leveraging SQLAlchemy that provides a programmatic interface to Oracle’s E-Business Suite.

Employment

  • Python Data Science Expert

    2018 - PRESENT
    Equeum.com (via Toptal)
    • Redesigned and developed a Python library for developing, back-testing, and plotting results of various algorithmic trading strategies.
    • Designed and developed a Python/Flask web application for running and chaining various time-series statistical operations on security price data.
    • Deployed a Python-Flask web app to run and scale in the cloud using Google App Engine's serverless computing architecture.
    Technologies: Python3, Flask, Scikit-learn, SciPy, Pandas, NumPy, Google App Engine
  • Python Engineer

    2016 - PRESENT
    Dwight D. Cummings Business Solutions
    • Designed and developed PyOraEbs, a framework allowing users to develop simple Python scripts to automate and simplify tasks in the Oracle E-Business Suite (EBS) back-end schema. Based on SQLAlchemy, it allows the user to easily expand the framework by defining very minimalistic classes representing tables in the EBS and add methods representing functionality in EBS.
    • Created a live plot of Bitcoin prices using data directly from Bitcoinwisdom. The site was scraped live, and candlesticks plotted with a one-minute resolution.
    • Built a Windows desktop app (Python-based) to check weather information and select a picture of an outfit based on the weather for the email dress recommendation of the day.
    • Scraped the website Indywithkids and delivered information about upcoming events via email in formatted tabular fashion (used Python, Beautiful Soup, and Requests).
    Technologies: Python, PyCharm
  • Oracle Technical Consultant

    2011 - PRESENT
    Grace Kennedy Remittance Services (Money Services)
    • Developed a supplier account audit report to query supplier account audit tables and display details of every instance of the supplier account modification including user, date, data before change, and data after change; also to restrict access to this report to specified responsibilities.
    • Enhanced the productivity by developing an accounting schedule report thus eliminating the manual process of gathering and collating the data need to produce this report.
    • Utilized the Journal Hook feature to correct the effective dates of imported journals for a select list of journal sources.
    • Saved time and money in building a generic system to extract various data sources from Oracle EBS via a concurrent program for use in the bank reconciliation system.
    • Upgraded custom reports and form personalizations to Oracle EBS Release 12.
    • Enabled users to enter Oracle Payables invoices via spreadsheet and upload into Oracle for a high volume supplier.
    • Built a PL/SQL-based concurrent program to convert 18 bank statement file formats to a standard format for the upload to the bank reconciliation system.
    Technologies: Oracle Database 11g, Oracle Database 12c, Oracle EBS Release 12
  • Oracle Database Trainer

    2016 - 2016
    Real World Technology Training & Solutions
    • Taught the training course Oracle Database 11g Program with PL/SQL.
    • Delivered the training course Oracle DBA Workshop I.
    Technologies: Oracle Database 12c
  • Oracle E-Business Suite Consutant

    2014 - 2016
    Kingston Freeport Terminal Limited (via Adjoined Business Solutions)
    • Unified the billing functions of the Terminal Operating System (TOS) with Oracle Receivables by designing and building an interface to streamline the upload of invoice, credit memo, and debit memo transactions.
    • Converted customer data from the TOS to Oracle Receivables while preserving the original customer numbering.
    • Built a comprehensive customer statement report that visually depicts the aging of customer balances over-time.
    • Developed the receipting systems by customizing the AR Receipt form to automate receipt number generation and customizing the physical receipt report.
    • Integrated the Champs Purchase Order module with Oracle Payables (AP) by developing an interface to transfer purchase order creation, and changes, to Oracle PO tables for AP invoice matching.
    • Assimilated inventory movement transactions from the Champs inventory system into Oracle General Ledger.
    • Integrated the receipts from the on-line “E-Wharfage” system as miscellaneous receipts in Oracle Receivables.
    Technologies: Oracle Database 11g, Oracle EBS 11i, PL/SQL, Oracle SQL
  • Oracle Database Trainer

    2010 - 2014
    dotTech Ict Training & Consultants Co Ltd
    • Delivered training course Oracle Database 10g Introduction to SQL.
    • Taught training course Oracle Database 11g Introduction to SQL.
    • Held the training course Oracle 11i WMS Fundamentals.
    • Delivered training course Oracle 10g Program with PL/SQL.
    • Taught training course Oracle 11g Program with PL/SQL.
    • Held training course Oracle DBA Workshop I.
    Technologies: Oracle Database 10g, Oracle Database 11g, Oracle Database 12c
  • Oracle Financials Technical Consultant

    2002 - 2013
    The Port Authority of Jamaica (Sea-Port Governance)
    • Analyzed user requirements, procedures, and problems in the process a generating a custom remittance advice format from Oracle Payables.
    • Developed the modification and carried out the setup to automatically generate the remittance advice according to specified requirements.
    • Added a new data entry form to Oracle Assets to allow entry of the budget costs by asset location.
    • Enhanced the system reporting by modifying or developing from scratch some 25 Oracle Application reports to carefully meet user specifications. The modules include Oracle General Ledger, receivables, payables, and assets.
    • Improved the user interface and business process efficiency by modifying the data entry screens in accordance with user specifications.
    • Implemented automatic sequential receipt numbering for Oracle Receivables.
    Technologies: Oracle 9i, Oracle Applications Release 11
  • Oracle Technical Consultant

    2007 - 2007
    Kingston Container Terminals (Sea-Port Terminal Operations)
    • Modified the check printing program to print a blank check stub for checks with more than 10 invoices.
    • Created a new automatic remittance advice program that will print remittances only for checks with more that 10 invoices.
    • Modified the check printing setup to allow the printing of checks with any number of invoices, and to call the new remittance advice program.
    • Modified the Receivables Payment Register report and the General Ledger report to meet user requirements.
    • Modified the Oracle Receivables Single Invoice report to match the physical invoice form being used.
    • Investigated and resolve long load time of the Oracle Paybles Invoice Find screen.
    Technologies: Oracle Database 9i, Oracle Applications 11i
  • Adjunct Lecturer

    2006 - 2007
    University College of the Caribbean
    • Gave students an understanding of the business issues, processes and techniques associated with the identification of organizational requirements for databases.
    • Helped students understand the fundamental mathematical concepts underlying the theory of relational databases.
    • Developed in students an appreciation for database design using the entity-relationship model, the object-oriented model, and a case tools.
    • Taught the syntax and use of Structured Query Language for database access and creation.
    • Explained the implications of using relational databases in a multi-user environment.
    • Demonstrated and explained the concepts of a commercial relational database management system using Oracle.
    Technologies: Oracle Database 9i
  • Oracle Financials Consultant

    2006 - 2007
    Lasco Distributors Limited (Food Manufacturing and Distribution)
    • Utilized Oracle BI Publisher to deliver extensive high-level management reports from Oracle Applications to Microsoft Excel during post-implementation.
    • Customized several seeded Oracle system reports to meet online reporting needs.
    • Designed and built multiple interfaces to Oracle Applications.
    • Build customized views to supporting real-time system audits and reporting.
    • Reformatted the customer statement, customer invoice and purchase order reports to match the existing format of preprinted forms.
    • Suggested and implemented new system reports.
    Technologies: Oracle Database 9i, Oracle Applications 11i, Oracle BI Publisher, Microsoft Excel
  • Oracle Financials Consultant

    2006 - 2006
    H&L True Values Ltd (Retail)
    • Improved the user performance by conducting training sessions in the Oracle General Ledger and Oracle Receivables.
    • Supported end-users extensively in the production environment.
    • Converted data for Oracle Receivables customer receipts and customer sales invoices.
    • Synchronized the customer numbers in Oracle Receivables with the retail point of sale system.
    • Enhanced system reporting by modifying several reports including the customer statement.
    • Added a new functionality by extending the customer account analysis form in Oracle Receivables.
    Technologies: Oracle Database 9i, Oracle Applications 11i
  • Oracle Financials Consultant

    2005 - 2005
    Hi-Lo Food Stores (Retail)
    • Enhanced reporting through customization of 5 Oracle Receivables Reports.
    • Enabled the generation of the profit-and-loss financial statement by configuring and setting up components of the FSG reporting tool.
    • Improved the financial reporting by setting up e8 additional balance sheet schedules using FSG.
    • Conducted data conversion for Oracle Payables invoices.
    Technologies: Oracle Database 9i, Oracle Applications 11i
  • Oracle Technical Trainer/Consultant

    2005 - 2005
    Jamaica Producers Group (Food Production)
    • Delivered successfully a 5-day technical training course on Oracle’s SQL Language.
    • Developed and delivered a 3-day technical training course on accessing Oracle Applications database tables with SQL.
    • Research and solved the problem of adding new business units for the accounts receivable customers and generating statements by business units.
    Technologies: Oracle 9i, Oracle Applications 11i
  • Independent Consultant, Oracle Applications

    2002 - 2004
    National Commercial Bank (via Adjoined Consulting Inc.)
    • Developed successfully interfaces between Oracle applications and Finacle banking systems including the payroll direct deposits interface for a major local bank, and Oracle Supplier direct deposits interface.
    • Developed 9 new reports to meet the Oracle Payroll user requirements including, pay slip, payroll register, and statutory deduction reports.
    • Improved financial reporting by customizing the general ledger consolidated trial balance report.
    • Enhanced the Oracle Payroll security by configuring the Oracle application auditing system; also developed custom audit reports to meet user requirements, and satisfy external auditing requirements.
    • Automated the journal import process from Oracle Payroll to Oracle General Ledger.
    • Improved the workflow efficiency of Oracle HR and Payroll users by incorporating automated alerts (triggers) using Oracle Alert.
    Technologies: Oracle Database 9i, PL/QL, Oracle SQL, Oracle EBS 11i
  • Oracle Applications Technical Consultant

    1998 - 2004
    Urban Development Corporation (Urban Planning)
    • Developed a new water billing extension to Oracle Receivables, providing easy entry of meter readings, automatic calculation and creation of sales invoices, and customized bill format.
    • Developed a custom module to copying Oracle Receivables invoices for rental income providing an efficient means of entering invoices for the same amounts as in the prior periods.
    • Converted data from legacy or manual systems including purchase invoices, customers, sales invoices, and trade receipts.
    • Modified several reports and forms of the Oracle GL, Oracle Payables, and Oracle Purchasing modules.
    • Planned, developed, tested, and documented the customization to the Oracle Payables check format applying knowledge of Oracle Reports and Oracle PL/SQL.
    • Increased the security of Oracle GL by successfully implementing a modification to secure data based on accounting flexfield security rules.
    • Designed and developed several SQL and PL/SQL scripts every month for solving problems ranging from erroneous data correction to ad hoc reporting.
    • Managed successfully a disk crash crisis which led to the recreation of index tablespace structures in the production environment and 15 hours of non-stop work.
    Technologies: Oracle 8i/9i, Oracle Applications Release 11
  • Oracle Technical Consultant

    2002 - 2002
    Digicel Jamaica Limited (Telecommunications)
    • Implemented successfully a data warehouse with 1 fact and 16 dimensions tables utilizing the partitioning and bitmap indexing capabilities of the Oracle8i database.
    • Developed a large multi-processing PL/SQL application that examined millions of call details records to establish the revenue generate from a new USSD product release.
    • Supported user ad hoc requests for information over the 3-month period by implementing several SQL and PL/SQL scripts.
    Technologies: Oracle Database 8i
  • Oracle Applications Project Analyst

    1997 - 2000
    Jamaica Public Service Company Ltd. (Light and Power)
    • Implemented several modifications and extensions to forms and reports of Oracle Applications modules using the Custom Library extensively, and Oracle Reports.
    • Designed, documented, and implemented interfaces from legacy systems to Oracle Payables.
    • Built data conversion programs for converting vendors, employees, items, and assets and loading into Oracle Applications.
    • Conducted multiple setups of Oracle Applications flexfields, value sets, flexfield security rules, users, document categories, folders, printers, profile options, and responsibilities, and other application entities.
    • Doubled the throughput of users by preparing a trouble shooting guide with detailed solutions to common check processing problems.
    • Planned and prepared technical reports, memoranda, and instructional manuals as documentation of extensions and customizations to the Oracle Financials suite.
    • Modified the Oracle Application form code to correct applications bugs prior to the patches being released.
    • Demonstrated effective presentation skills in-house and at the Oracle User Group Conference.
    Technologies: Oracle 8i RDBMS, Oracle Applications 10SC
  • Oracle Technical Analyst

    1994 - 1997
    Mutual Life Assurance Society (Life Insurance)
    • Designed and built an Oracle Forms-based application for tracking medical requirements, and integrated this custom application with Oracle Financials.
    • Enhanced the customer service by utilizing Oracle CASE 5.0 (Now Oracle Internet Development Suite) to rapidly generate database tables and forms for a new receipting module replacing an old legacy system, then integrating this system to Oracle Applications.
    • Applied knowledge of dBASE IV for Unix in developing a new module facilitating the tracking of all new business processing.
    • Consulted with users extensively to identify current operating procedures and clarify information system objectives.
    • Developed Unix shell scripts including the extensive use of regular expressions.
    • Planned, developed, tested, and documented systems applying knowledge of SQL, PL/SQL, Oracle Forms, Oracle Reports, and Oracle built in packages.
    • Prepared flow charts, entity relationship, and function hierarchy diagrams to illustrate the database design, the sequence of steps in the business process, and the decomposition of functions that the system must implement.
    Technologies: Oracle7 RDBMS, Oracle Applications version 9, dBASE IV

Experience

  • Python Courses (Other amazing things)

    Completed in full the following Python Courses:
    - Python for Data Science and Machine Learning Bootcamp.
    - Machine Learning A-Z™: Hands-On Python & R In Data Science.
    - Data Science: Natural Language Processing (NLP) in Python.
    - 30 Days of Python | Unlock your Python Potential.
    - The Python Mega Course: Build 10 Real World Applications.
    - The Complete Python & PostgreSQL Developer Course.

Skills

  • Languages

    Markdown, Python 3, Stored Procedure, SQL
  • Frameworks

    Flask, Scrapy, Jinja
  • Libraries/APIs

    Scikit-learn, NumPy, Pandas, SQLAlchemy, Beautiful Soup, TensorFlow, SciPy, NLTK, Sklearn
  • Tools

    PyCharm
  • Paradigms

    Data Science
  • Platforms

    Jupyter Notebook, Oracle Database
  • Storage

    Oracle 12c, PostgreSQL
  • Other

    Deep Learning

Education

  • Master of Science degree in Computer Based Management Information Systems
    1997 - 2000
    The University of the West Indies at Mona - Kingston 7, Jamaica
  • Bachelor of Science degree in Computer Science
    1990 - 1994
    The University of the West Indies at Mona - Kingston 7, Jamaica
Certifications
  • Improving Deep Neural Networks: Hyperparameter Tuning, Regularization, and Optimization
    OCTOBER 2018 - PRESENT
    Coursera
  • Neural Networks and Deep Learning
    OCTOBER 2018 - PRESENT
    Coursera
  • Data Analysis with Python
    OCTOBER 2018 - PRESENT
    Coursera
  • Data Visualization with Python
    SEPTEMBER 2018 - PRESENT
    Coursera
  • Databases and SQL for Data Science
    SEPTEMBER 2018 - PRESENT
    Coursera
  • Python for Applied Data Science
    SEPTEMBER 2018 - PRESENT
    Coursera
  • Data Science Methodology
    SEPTEMBER 2018 - PRESENT
    Coursera
  • Open Source Tools for Data Science
    SEPTEMBER 2018 - PRESENT
    Coursera
  • Data Science Orientation
    AUGUST 2018 - PRESENT
    Coursera
I really like this profile
Share it with others