Dwight is available for hire
Hire DwightDwight Dale Cummings, M.Sc.
Verified Expert in Engineering
Python & Data Science Developer
Kingston, St. Andrew Parish, Jamaica
Toptal member since January 6, 2017
Bio
Dwight is an Elixir and Python engineer with deep experience in SQL and data engineering. Self-taught in Elixir through Exercism, he builds reliable back-end systems, data pipelines, APIs, automation, and AI-assisted workflows using Elixir, Python, Snowflake, Databricks, PySpark, and BigQuery. He helps clients turn fragile, manual processes into practical, dependable software across healthcare, finance, telecom, retail, and analytics.
Portfolio
Metis Associates, Inc.
Data Engineering, Skyvia, API Integration, Automation, Microsoft Office...
Ally Leasing LLC
Robotic Process Automation (RPA), API Integration, JavaScript, Python...
Terry Touysithiphonexay
Business Intelligence (BI), Data Pipelines, Data Warehousing, ETL...
Experience
- ETL - 20 years
- SQL - 20 years
- Python - 11 years
- Data Engineering - 8 years
- Pandas - 8 years
- Scraping - 6 years
- Snowflake - 3 years
- Elixir - 1 year
Work Experience
Senior Automation Integration Engineer
2025 - PRESENT
Metis Associates, Inc.
- Designed a Scoro-to-Excel month-end close workbook (RawWIP, WorkCalc, and ArchiveLedger) that enabled the finance team to audit revenue recognition using automated formulas.
- Implemented ingestion gates that reconciled Scoro export row counts to RawWIP and halted runs on mismatches, preventing partial imports from skewing close numbers.
- Built transparent Excel formulas for percent complete, synthetic hours budget, and ITD revenue, plus exception flags for zero or negative EAC, negative deltas, and out-of-range % complete.
- Configured Skyvia packages to push synthetic hours and recognized revenue back to Scoro with composite idempotency keys (Project, PeriodCloseDate, and Amount), enabling safe retries without double posting.
- Automated run control in Azure SQL using stored procedures and a parameters table for PeriodCloseDate, Env, and Mode, generating structured RunIDs to trace each close across DEV, TEST, and PROD.
- Established close controls and an audit trail, including Ingestion_OK, Calculations_Validated, Push_Executed (≥95% success), Archive_Appended, and Reconciliation_OK, and enforced unique (Project, Month-End, and ConnectorRunID) snapshots with PushLog errors.
Technologies: Data Engineering, Skyvia, API Integration, Automation, Microsoft Office, Data Transformation, API Development, ETL, REST APIs, ETL Pipelines, Data Modeling, Azure, Azure Data Factory (ADF), Database Architecture, eCommerce
RPA Developer
2025 - PRESENT
Ally Leasing LLC
- Spearheaded end-to-end RPA solution that ingested orders from API-less marketplace into Caspio, reverse-engineering web flows and automating 100% of daily entries, eliminating 20+ hours of weekly manual keying and slashing errors to zero.
- Engineered Python integration layer that maps Apex and Cultivera invoice schemas to unified SQL triggers in Caspio, synchronising 12 data tables and maintaining referential integrity for 30,000+ records with auto-recovery on edge cases.
- Packaged the automation as a seamless Windows CLI utility with a silent installer, digital signing, and Task Scheduler hooks, allowing non-technical staff to deploy updates via one command while hiding the interpreter entirely.
- Built resilient async workflows using asyncio TaskGroups and granular timeout strategies, guaranteeing every exception is surfaced and logged, cutting debugging time from hours to minutes and raising first-pass success rate to 98%.
- Collaborated with client stakeholders to redesign database triggers, introducing s_Invoices_1 staging table and auto-number workflow that preserved legacy relations yet removed invoice collisions, supporting unlimited scaling.
- Crafted YAML-driven brand/strain reconciliation engine that parses 500+ SKU names, applies rule-based matching, and updates inventory in near-real time, driving 100% pricing accuracy and enabling dynamic promotional discounts.
Technologies: Robotic Process Automation (RPA), API Integration, JavaScript, Python, eCommerce, REST APIs, ETL Pipelines, Playwright, Browser Automation
Power BI Data Engineer
2025 - 2025
Terry Touysithiphonexay
- Designed and launched a Snowflake medallion stack ingesting RO Writer across shops, unifying schemas into a query-ready model that delivers same-day Sales/COGS visibility (Snowflake, SQL, Python).
- Integrated vendors via Fivetran Proxy Agent and APIs/EDI (Advance, XL), mapping invoices to RO numbers and items; built reconciliation to flag price/qty variances and not-on-RO exceptions for trustworthy COGS.
- Published parameterized views and stored procedures for daily/MTD KPIs—sales, COGS%, car count, tech productivity—and shipped Power BI dashboards that replaced manual spreadsheet rollups.
- Automated store alerts with a Slack COGS Bot posting morning/evening summaries, variance breaches, missing RO links, and late postings, tightening feedback loops and speeding frontline action.
- Added observability (freshness checks, row-count drifts, discrepancy logs) and formalized data contracts/runbooks (schemas, credentials, SLAs), cutting time-to-diagnosis and easing team handoff.
Technologies: Business Intelligence (BI), Data Pipelines, Data Warehousing, ETL, Data Engineering, Microsoft Power BI, Tableau, Data Analytics, Snowflake, Inventory Management, Point of Sale, Profit & Loss (P&L), Fivetran, Medallion Architecture, REST APIs, ETL Pipelines, Data Modeling, Data Cleansing, Data Build Tool (dbt), Database Architecture
Data Engineer
2024 - 2025
SumerSports, LLC - Main
- Architected and implemented modern data pipelines using Databricks and PySpark, transforming raw NFL, NCAA, and basketball data into structured, analytics-ready outputs with automated schema inference and rigorous error handling.
- Developed advanced data transformation pipelines employing sophisticated SQL functions and medallion architecture, organizing datasets into Bronze, Silver, and Gold layers for systematic refinement and consistent, high-quality reporting.
- Established a rigorous data quality framework using SQL and PySpark validations, automating consistency checks and anomaly detection to safeguard data integrity and support reliable decision-making.
- Refactored legacy PySpark code into modular, reusable components by integrating unit tests and Dockerized environments to enhance maintainability, scalability, and efficiency in production pipelines.
- Orchestrated the integration of NFL, NCAA, and basketball datasets into a unified analytics platform through sophisticated ingestion, data mapping, and schema validation techniques, reducing redundancies and ensuring accuracy.
- Enhanced operational efficiency by developing automation tools that streamlined PySpark workflow deployments, optimized Spark configurations, and improved cluster performance through proactive resource management.
- Collaborated with cross-functional teams to document best practices and standardize coding protocols, ensuring sustainable, scalable, and secure data engineering processes across the sports analytics organization.
Technologies: Python, SQL, Databricks, PySpark, Data Engineering, Docker, Jira, Git, GitHub, Confluence, Windows PowerShell, Pytest, Medallion Architecture, ETL Pipelines, Data Lakes, Data Cleansing, Data Warehousing, Code Review
Data Engineer
2024 - 2024
Amble Health, Inc
- Created an ELT pipeline using webhooks, connecting Bask Health to Twilio Segment and Snowflake. Coded Segment Source Functions with track() and identify() calls, enabling real-time data flow for patients, products, orders, variants, and prescriptions.
- Established a robust Snowflake environment configuring warehouses, databases, roles, and users to efficiently handle incoming data from Segment. Transformed raw event data into relational formats using dynamic tables for Tableau consumption.
- Imported historical CSV data from Bask Health into Snowflake using Snowflake Staging, the PUT command, and INFER SCHEMA for schema inference. Seamlessly integrated historical and real-time data, making all data accessible to Tableau.
- Created web scraping scripts to extract JSON data from the Bask Health web portal. Transformed this data into CSV format, ensuring complete data ingestion into Snowflake, thus filling critical data gaps when CSVs for some entities were not available.
Technologies: Data Engineering, Snowflake, ETL, Tableau, Bask, Webhooks, REST APIs, ETL Pipelines, Data Modeling
Python Back-end/Data Engineer
2023 - 2023
Doowii, Inc.
- Developed and enhanced back-end data transformation processes used in onboarding new customers' data from their learning management system.
- Built tools using Google BigQuery API to transform and enhance the dataset schemas, such as generating, summarizing, and renaming columns.
- Added enhancements and features to the natural language-to-SQL engine used in generating SQL queries from natural language questions.
- Built data transformation steps in Python and published them as APIs using Google Cloud Functions.
Technologies: Python, ETL, Cloud Dataflow, Apache Beam, Google Cloud Platform (GCP), Orchestration, Generative Pre-trained Transformers (GPT), LangChain, Google BigQuery, Artificial Intelligence (AI), OpenAI GPT-4 API, Google Cloud Functions, Data Engineering, Firebase, REST APIs, ETL Pipelines, Code Review, Large Language Models (LLMs)
Data Architect
2023 - 2023
Ambr-osia
- Analyzed requirements for a dataset consisting of various food items, ingredients, additives, produce, and food preparations.
- Developed and refined an appropriate Google search query with the best possible chance of returning websites containing the required textual data, as well as engineered large language model prompts for text extraction and summarization.
- Developed a Python application that asynchronously scanned an Excel spreadsheet of food items, searched Google for each food item, scraped text from the top two websites, and invoked a large language model to extract and summarize the data.
Technologies: Data, Data Scraping, Python, Web Scraping, ETL, LangChain, Language Models, Microsoft Excel, OpenAI GPT-4 API, Artificial Intelligence (AI), Google API, Data Engineering, Google BigQuery, REST APIs, ETL Pipelines, Data Modeling, Data Cleansing, Database Deduplication, Large Language Models (LLMs), Database Architecture
Python Developer
2022 - 2022
Indigovern LLC
- Built test suites using Python Pytest and created mock objects to replace calls to the database and other cloud services.
- Created Pytest fixtures as test doubles for database query results using mocked data from CSV files.
- Refactored Python-based data ingestion and the data transformation flow to use upgraded features in the codebase.
Technologies: Python, Pandas, SQL, Pytest, ETL, ETL Tools, JSON, Data Engineering, Data Cleansing, Code Review
Python RPA Engineer
2021 - 2022
Frontier Communications
- Built a machine learning model to predict customer cancellations during the provisioning of internet services, using features extracted from textual logs recorded by service technicians.
- Updated a Python/Django-based website by providing convenient access to robotic process automation (RPA) scripts via a web portal.
- Built a generalized regression GUI tool to run single and multivariate regression analysis on an ingested dataset and provided model metrics from Python statsmodels as output.
- Created an RPA tool to download hundreds of PDF invoices from a paginated web portal.
- Developed a custom report mining tool to replace the Monarch report miner capable of extracting structured CSV data from ten different textual report formats.
- Built RPA tools to perform a series of Sarbanes-Oxley (SOX) compliance tests using web automation, web scraping, document scraping, and computer vision.
Technologies: Robotic Process Automation (RPA), Python, Selenium, Generative Pre-trained Transformers (GPT), Natural Language Processing (NLP), Machine Learning, Topic Modeling, Graphical User Interface (GUI), Tkinter, Computer Vision, Optical Character Recognition (OCR), Automation, Data Science, Data Engineering, REST APIs, Data Cleansing, Browser Automation
Python Developer
2021 - 2022
PhysIQ, Inc.
- Built services in Python to ingest large quantities of data files from directory trees with a mechanism for saving a checkpoint location in the event of failures, thus enabling efficient resumption.
- Designed and engineered Python code to ingest a sequence of time series data files and pack the data into a FlatBuffer serialization format.
- Created a command-line interface tool using Python argparse, allowing researchers to quickly ingest large sets of time series data files and upload them to a cloud portal.
- Built a command-line interface tool to allow researchers to export data from a clinical portal into sets of CSV files downloaded to a local directory or exported as a compressed archive.
Technologies: Python, Pandas, FlatBuffers, Argparse, JSON, Data Engineering, REST APIs, ETL Pipelines, Data Cleansing, Healthcare Software, Code Review
Data Engineering Developer
2021 - 2021
Afresh Technologies
- Developed Python libraries for parsing and loading raw customer data by refactoring over 1,000 lines of unstructured Python and Pandas code from Jupyter notebooks.
- Constructed Python APIs and client code to create an ETL data flow for the Ascend platform.
- Refactored a set of SQL transformations into Python code that generated the same data transformations using the Ascend platform.
Technologies: SQL, Python, Jupyter Notebook, Ascend, Snowflake, PySpark, Apache Spark, Data Pipelines, Data Engineering, REST APIs, ETL Pipelines, Data Cleansing, Database Deduplication, Data Warehousing, Code Review
Enterprise Python RPA Engineer
2020 - 2020
Frontier Communications
- Developed a Python application using Selenium, PyAutoGUI, TkInter, and pandas, which automated critical, labor-intensive audit processes, reducing the turnaround time from hours to minutes.
- Developed a Python application using pandas, PyMuPDF, and Python xlwings, which automated the manual scanning of dozens of PDF files for highlighted information and updated Excel spreadsheets from that information.
- Built a Python application using python-docx, automating a process involving document merging and creation using custom-built utilities to convert a word table to a pandas data frame and back.
Technologies: Python, Robotic Process Automation (RPA), Selenium, Automation, REST APIs, Browser Automation
Data Scraping Engineer
2019 - 2019
Yipit, LLC
- Coordinated with other data scraping engineers, analysts, and technical officers to develop specific standards for a data scraping project.
- Executed the most challenging data scraping projects in terms of volume and complexity by leveraging Python, XPath, and a custom infrastructure-as-a-service platform to which I contributed.
- Communicated findings, requirements, and issues with project owners to ensure the correct data was harvested with the appropriate frequency consistent with the business problem being solved.
Technologies: Regular Expressions, JSON, XPath, Puppeteer, Python, Web Scraping, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Code Review, Browser Automation
Oracle Technical Consultant
2011 - 2019
Grace Kennedy Remittance Services (Money Services)
- Developed a supplier account audit report to display details of every instance of the supplier account modification: user, date, and data before and after the change. It also allowed restricted report access to specified responsibilities.
- Enhanced productivity by developing an accounting schedule report, eliminating the manual gathering and collating of the data needed to produce this report.
- Utilized the journal hook feature to correct effective dates of imported journals for a selected 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 to be used in the bank reconciliation system.
- Upgraded custom reports and form personalizations to Oracle EBS Release 12.
- Enabled users to enter Oracle Payables Invoice via a spreadsheet and upload them 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 to be uploaded into the bank reconciliation system.
Technologies: Oracle PL/SQL, SQL, Oracle EBS, BI Reports, Databases, Data Modeling, Data Cleansing
Python Data Science Expert
2018 - 2018
Equeum.com
- Redesigned and developed a Python library to develop, back-test, and plot results of various algorithmic trading strategies.
- Designed and developed a Python/Flask web application to run and chain 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: Google App Engine, NumPy, Pandas, Scikit-learn, Flask, Big Data, PostgreSQL, Data Science, Data Engineering, Google BigQuery, Data Cleansing, Database Deduplication, Code Review
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.
- Prepared course booklets and created development environments for students to practice and complete lab exercises.
Technologies: Oracle Database, Databases, ICT Training, SQL
Oracle E-Business Suite Consultant
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 the 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 the receipt number generation and customize 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 receipts from the online "E-Wharfage" system as miscellaneous receipts in Oracle Receivables.
Technologies: PL/SQL, SQL, Data Pipelines, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
Oracle Database Trainer
2010 - 2014
dotTech Ict Training & Consultants Co Ltd
- Delivered the training course Oracle Database 10g Introduction to SQL.
- Taught the training course Oracle Database 11g Introduction to SQL.
- Held the training course Oracle 11i WMS Fundamentals.
- Delivered the training course Oracle 10g Program with PL/SQL.
- Taught the training course Oracle 11g Program with PL/SQL.
- Delivered the Oracle DBA Workshop I training course as part of Oracle Database Administrator development.
Technologies: Oracle Database, Databases, ICT Training, SQL, Oracle PL/SQL, PL/SQL
Oracle Financials Technical Consultant
2002 - 2013
The Port Authority of Jamaica (Sea-Port Governance)
- Analyzed user requirements, procedures, and problems in generating a custom remittance advice format from Oracle Payables.
- Developed the modification and carried out the set up to automatically generate the remittance advice according to specified requirements.
- Added a new data entry form to Oracle Assets to allow budget costs by asset location entry.
- Enhanced system reporting by modifying or developing 25 Oracle Application reports from scratch 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 following user specifications.
- Implemented automatic sequential receipt numbering for Oracle Receivables.
Technologies: Oracle EBS, Oracle Database, Databases, SQL, Oracle PL/SQL, PL/SQL, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
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 to print remittances only for checks with more than ten invoices.
- Modified the check printing set up 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 used.
- Investigated and resolved the long load time of the Oracle Payables invoice find screen.
Technologies: Oracle EBS, ETL, Databases, SQL, Oracle PL/SQL, App Integration, PL/SQL, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
Adjunct Lecturer
2006 - 2007
University College of the Caribbean
- Facilitated students' comprehension of the business issues, processes, and techniques associated with identifying 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 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, ICT Training, Higher Education, SQL, ERD
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 meeting online reporting needs.
- Designed and built multiple interfaces to Oracle Applications.
- Built customized views to support real-time system audits and reporting.
- Reformatted the customer statement, invoice, and purchase order reports to match the existing format of preprinted forms.
- Proposed, designed, and developed additional system reporting functionalities.
Technologies: Oracle EBS, Oracle Database, ETL, BI Reports, SQL, Oracle PL/SQL, PL/SQL, Data Pipelines, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
Oracle Financials Consultant
2006 - 2006
H&L True Values Ltd (Retail)
- Improved 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 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 EBS, Oracle Database, Databases, SQL, Oracle PL/SQL, ETL, PL/SQL, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
Oracle Financials Consultant
2005 - 2005
Hi-Lo Food Stores (Retail)
- Enhanced reporting through the customization of five Oracle Receivables reports.
- Enabled the profit-and-loss financial statement generation by configuring and setting up components of the Financial Statement Generator (FSG) reporting tool.
- Improved the financial reporting by setting up eight (8) additional balance sheet schedules using the Financial Statement Generator: a tool to design and specify custom financial reporting formats.
- Conducted data conversion for Oracle Payables invoices.
Technologies: Oracle EBS, SQL, Oracle PL/SQL, ETL, Databases, ICT Training, PL/SQL, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
Oracle Technical Trainer | Consultant
2005 - 2005
Jamaica Producers Group (Food Production)
- Delivered a 5-day technical training course on Oracle's SQL Language successfully.
- Developed and delivered a 3-day technical training course on accessing Oracle Applications database tables with SQL.
- Researched and solved the problem of adding new business units for the accounts receivable customers and generating statements by business units.
Technologies: Oracle EBS, SQL, Oracle PL/SQL, ICT Training, Oracle Database, PL/SQL, Data Engineering, Database Architecture
Independent Consultant
2002 - 2004
National Commercial Bank (via Adjoined Consulting Inc.)
- Developed successful 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.
- Composed nine new reports to meet the Oracle Payroll user requirements, including payslips, 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 PL/SQL, Oracle EBS, SQL, Online Banking, App Integration, ETL, PL/SQL, Data Pipelines, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
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, creation of sales invoices, and customized bill format.
- Built a custom module to copy Oracle Receivables invoices for rental income, providing an efficient means of entering invoices for the same amounts as in prior periods.
- Converted data from legacy or manual systems, including purchase invoices, customers, sales invoices, and trade receipts.
- Modified several reports and forms of Oracle General Ledger (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 monthly to solve problems ranging from erroneous data correction to ad hoc reporting.
- Managed a disk crash crisis successfully, which led to the recreation of index tablespace structures in the production environment and 15 hours of non-stop work.
Technologies: Oracle, Oracle EBS, Oracle PL/SQL, SQL, ETL, PL/SQL, Data Pipelines, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
Oracle Technical Consultant
2002 - 2002
Digicel Jamaica Limited (Telecommunications)
- Implemented a data warehouse successfully with one fact and 16 dimension 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 generated from a new USSD product release.
- Supported user ad hoc requests for information over the three months by implementing several SQL and PL/SQL scripts.
Technologies: Oracle, Databases, Data Architecture, Big Data, SQL, Oracle PL/SQL, PL/SQL, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Data Warehousing, Database Architecture
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 to convert vendors, employees, items, and assets and load them into Oracle Applications.
- Conducted multiple setups of Oracle Applications flexfields, value sets, flexfield security rules, users, document categories, folders, printers, profile options, responsibilities, and other application entities.
- Doubled the throughput of users by preparing a troubleshooting guide with detailed solutions to common check processing problems.
- Planned and prepared technical reports, memoranda, and instructional manuals to document extensions and customizations to the Oracle Financials suite.
- Modified the Oracle Application form code to correct application bugs before the patches were released.
- Demonstrated effective presentation skills in-house and at the Oracle User Group Conference.
Technologies: Oracle Database, Oracle EBS, Databases, Oracle PL/SQL, SQL, ETL, PL/SQL, Data Pipelines, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
Oracle Technical Analyst
1994 - 1997
Mutual Life Assurance Society (Life Insurance)
- Designed and built an Oracle Forms-based application to track medical requirements and integrated this custom application with Oracle Financials.
- Enhanced customer service by using Oracle CASE 5 (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 into Oracle Applications.
- Applied knowledge of dBASE IV for Unix in developing a new module to track 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 relationships, 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: Oracle Database, Databases, SQL, Oracle PL/SQL, ETL, PL/SQL, Data Pipelines, Data Engineering, Data Modeling, Data Cleansing, Database Deduplication, Database Architecture
Project History
Python Courses
Completed 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
• 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
Education
1997 - 2000
Master of Science Degree in Computer Based Management Information Systems
The University of the West Indies - Kingston, Jamaica
1990 - 1994
Bachelor of Science Degree in Computer Science
The University of the West Indies - Kingston, Jamaica
Certifications
OCTOBER 2018 - PRESENT
Improving Deep Neural Networks: Hyperparameter Tuning, Regularization and Optimization
Coursera
OCTOBER 2018 - PRESENT
Neural Networks and Deep Learning
Coursera
OCTOBER 2018 - PRESENT
Data Analysis with Python
Coursera
SEPTEMBER 2018 - PRESENT
Data Visualization with Python
Coursera
SEPTEMBER 2018 - PRESENT
Databases and SQL for Data Science
Coursera
SEPTEMBER 2018 - PRESENT
Python for Applied Data Science
Coursera
SEPTEMBER 2018 - PRESENT
Data Science Methodology
Coursera
SEPTEMBER 2018 - PRESENT
Open Source Tools for Data Science
Coursera
AUGUST 2018 - PRESENT
Data Science Orientation
Coursera
Skills
Libraries/APIs
Puppeteer, Scikit-learn, NumPy, Pandas, SQLAlchemy, Beautiful Soup, PySpark, Playwright, REST APIs, Natural Language Toolkit (NLTK), TensorFlow, FlatBuffers, Google API, API Development
Tools
Microsoft Power BI, Pytest, Git, GitHub, AutoHotkey, DataGrip, Microsoft Excel, Cloud Dataflow, Apache Beam, Tableau, Jira, Confluence
Languages
XPath, SQL, Python, Snowflake, Elixir, Pascal, JavaScript
Frameworks
Flask, Scrapy, Selenium, Apache Spark, Windows PowerShell
Paradigms
ETL, Automation, Business Intelligence (BI)
Platforms
Oracle, Jupyter Notebook, Google Cloud Platform (GCP), Databricks, Firebase, Azure, Google App Engine, Oracle Database, Linux, Windows, Unix, Kubernetes, Docker
Storage
Oracle PL/SQL, PostgreSQL, Databases, PL/SQL, Data Pipelines, JSON, Database Architecture, Data Lakes
Other
Regular Expressions, Deep Learning, Data Science, Scraping, Data Engineering, Machine Learning, Time Complexity Analysis, Space Complexity Analysis, Data Structures, ETL Tools, Google BigQuery, Data Visualization, BI Reports, ERD, Web Scraping, Robotic Process Automation (RPA), Natural Language Processing (NLP), Argparse, Optical Character Recognition (OCR), Reports, CSV, CSV File Processing, Generative Pre-trained Transformers (GPT), Data, Data Scraping, LangChain, Language Models, OpenAI GPT-4 API, API Integration, eCommerce, Browser Automation, Data Warehousing, Data Analytics, Fivetran, Skyvia, Medallion Architecture, Data Modeling, Large Language Models (LLMs), Code Review, Data Build Tool (dbt), Azure Data Factory (ADF), ETL Pipelines, Data Cleansing, Database Deduplication, Oracle EBS, Tkinter, Computer Vision, Healthcare Software, Formal Methods, Networking, Artificial Intelligence (AI), Ascend, Management Information Systems (MIS), Data Architecture, Big Data, Online Banking, App Integration, ICT Training, Higher Education, Topic Modeling, Graphical User Interface (GUI), Orchestration, Google Cloud Functions, Bask, Webhooks, Inventory Management, Point of Sale, Profit & Loss (P&L), Microsoft Office, Data Transformation
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring