Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

David Jackson

Dallas

Summary

Business data analyst intern with practical experience with structured query language (SQL) and Python statistical programming. Proven abilities to translate information and present data findings using graphics for diverse groups of people. Strong critical thinking skills, able to analyze data, identify patterns, and extract actionable insights and information from multiple sources. Excellent communicator, able to translate technical information to decision-makers.

Overview

27
27
years of professional experience

Work History

Sr. Data Analyst

BUILDERS FIRST SOURCE
01.2020 - 09.2025
  • Support financial reconciliation related to operational processes and contractual obligations.
  • Responsible for gathering and organizing data from various sources, including both internal and external databases.
  • Extract valuable insights and create informative dashboards, reports, and presentations tailored for different levels of management by utilizing advanced data analysis to deliver reports and answer questions from the business.
  • Created and maintained documentation for the middle tier.
  • Built automated code deployments to cloud environments.

Supply Chain Analyst /Data Analyst

GENPACT, LLC /BOEING
10.2018 - 01.2020
  • Utilizes standard procurement methods, which must include the research of possible sources for the item/service, business enterprises, documentation of sole or single source supplier condition, etc. and subsequent collection of information to ensure the best value and compliance with policies and procedures and applicable regulations.
  • Trained in SAP and also in ATM.
  • Trainer on SRM transferring POs to SAP, and training 5 to 10 Procurement Agent 2 to strategies of negotiation with the supplier or customers.
  • Extracting and manipulating data from Maximo databases using SQL and Python.
  • Analyze data to identify problematic areas and suggest improvements.
  • Help foster trusting relationships with business partners.
  • Track KPIs and report on supply chain’s performance.
  • Downloaded Daily SAP Extracts to create Daily Assignment reports for Procurement Analysts and Metrics reports for upper management.
  • Created Excel Macros/ VBA code to automate daily tasks and reports.
  • Process migration of SQL Server databases.
  • Database creation and management.
  • VBA Development for Automation.
  • Technical and support for Procurement Department Excel Spreadsheet/Macro issues.
  • Assist in product seasonality analysis and sales forecast.
  • Perform ad hoc analysis, reporting and deliverables.
  • Experience in automating ETL workflows or data pipelines.

Sr. Data Analyst

MEDHOST, INC
01.2008 - 10.2018
  • Developed and maintained all VBA Marcos for customers (hospitals).
  • Software defect resolution.
  • Process migration of SQL Server databases.
  • In-depth knowledge of T-SQL, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics Daily SQL (Create and modifying existing scripts).
  • ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Experience in writing Distributed Queries between SQL Servers.
  • Migration of Sybase databases to SQL Server.
  • Formatted spreadsheets and workbooks for print, document reproduction, and presentations.
  • Processed data load requests, manually entered data, reconciled data conflicts, and created data extracts and reports.
  • QA of all SQL Scripts for database bugs issues.
  • Prepared source data for computer entry; compiled, sorted, and prioritized data.
  • Prepared routine and ad hoc status reports.
  • 24 x 7 technical and data support for Applications issues.

Sr. Database Analyst / VBA Developer

AT&T Wireless
07.2006 - 01.2008
  • Lead Database Developer for the CARE Client (DB2 Database).
  • Development and technical support for Microsoft Applications.
  • Primary responsibilities creation, modification, and scheduling of SQL scripts, in Oracle and DB2.
  • Usage Processing (GSM, GPRS, SMS, MMS, PTT, TAP, and TDMA), on UNIX and the AS/400.
  • Data manipulation (deleting and updating) in Oracle and DB2.
  • 24 x 7 technical and data support for QA department.
  • Validation of code pushes to Telegence.
  • Verified and tested new code pushed into UNIX environments.
  • Create pivot tables and modify spreadsheets to achieve analytical goals.
  • Research, update, and validate data underlying spreadsheet production; strategically fill gaps.
  • Prepared routine and ad hoc status reports.

VBA Developer/ Data Analyst

Capgemini / TXU Electric Delivery
10.2002 - 07.2006
  • Create pivot tables and modify spreadsheets to achieve analytical goals.
  • Manage spreadsheets and maintain data currency to ensure accurate data availability for managers and decision-makers.
  • Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.
  • Tables, Logical & Physical Data Modeling using ERWIN and Oracle Designer.
  • Created Microsoft SQL Server and Access databases for tracking and analyzing EDI data.
  • Developed front-end applications in Microsoft Access using VBA.
  • Provided technical support for all Microsoft Applications for RSOM.
  • Created PL/SQL scripts to create daily and monthly GPI reports.
  • Created and modified scripts (Oracle, SQL Server, and DB2).
  • Developed stored procedures to transfer data between DB2.
  • Validated and QA Java new code for TXU EDI Reporting Tool.
  • Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
  • SQL Server, Microsoft Access, and Oracle.
  • Created ad hoc reports for operation and finance departments.
  • Data Quality Analysis and Reporting.
  • Developed VBA application to read and generate monthly reports of EDI files received.
  • Help develop Polaris, a web application to handle EDI transactions, between TXU and ERCOT.

Data Analyst / Access Developer

Transamerica Real Estate Tax Service
04.1998 - 05.2002
  • Processed all AS/400 production (893 Conversions, CV, RQ and PA) and verified accuracy of all converted files.
  • Coordinated report requests and jobs.
  • Reported and submitted proper documentation for new and changed files.
  • Assisted in planning and scheduling of cycle plans.
  • Coordinated requests and receipt of all data files for team.
  • Developed relational databases in Access, SQL Server, Fox Pro, and DB2.
  • Developed, deployed, maintained, and supported all Access applications.
  • Transferred data from the AS/400 into an Access and SQL databases.
  • Developed several Access VBA Applications for Operations.
  • Writing, maintaining and tuning SQL scripts and stored procedures.

Education

Bachelor of Science -

Southern Methodist University
Dallas, TX
01.2002

Skills

  • SQL
  • PYTHON
  • C#
  • VBNET
  • VBA
  • HTML
  • CSS
  • MS Word
  • MS Access
  • MS PowerPoint
  • MS Excel (Complex Spreadsheets, Pivot Tables, and Pivot Charts)
  • Visual Studio

Affiliations

  • Chess
  • Swimming
  • Running
  • Golf

Timeline

Sr. Data Analyst

BUILDERS FIRST SOURCE
01.2020 - 09.2025

Supply Chain Analyst /Data Analyst

GENPACT, LLC /BOEING
10.2018 - 01.2020

Sr. Data Analyst

MEDHOST, INC
01.2008 - 10.2018

Sr. Database Analyst / VBA Developer

AT&T Wireless
07.2006 - 01.2008

VBA Developer/ Data Analyst

Capgemini / TXU Electric Delivery
10.2002 - 07.2006

Data Analyst / Access Developer

Transamerica Real Estate Tax Service
04.1998 - 05.2002

Bachelor of Science -

Southern Methodist University

Similar Profiles

CREATE PROFILE