Tom Abraham Email & Phone Number

Charlotte, North Carolina, Us

Charlotte, North Carolina, Us

Manage company-wide data team, and administer Snowflake, FIVETRAN, DBT, Google Looker pipeline for delivery of data to entire staff of analysts. Happy to work in an Agile environment, with great coworkers and tools!

Charlotte, North Carolina, Us

Seattle, Us

Built tools and support structures needed to analyze data, dive deep into data to determine root cause of system errors, and provided actionable insights to business partners.Main Responsibilities:• Designed, architected, and implemented key clickstream datasets to provide structured and timely access to actionable business information.• Facilitated the analytical needs of the Digital Retail business team by understanding their business requirements, collaborating in the design of diagnostic solutions, and delivering exceptional data products and insights.• Tested and tuned report and query performance using Netezza, Snowflake, and Tableau.• Created ETLs/ELTs to take data from various data sources and integrated data to the data warehouse platform as needed to support the build of analytical data sets.• Developed, tested, and pushed through code review SQL DDL and DML solutions.

Seattle, Wa, Us

Used Redshift queries, statistical analysis, and ETL functions to generate metrics and actionable insights for world-wide Automated Inventory Management. Developed a tool to predict out of stock conditions on promotional products and attribute root causes for corrective action.

Seattle, Wa, Us

Analyzed TB-sized Redshift data sets holding information on customer experiences and behavior to create actionable insights to improve the customer experience. Activities include:• Rebuilt FastTrack metrics data pipeline and reporting processes resulting in reduction of 3 headcount in resources required to manage and produce SVP level reporting on Amazon’s ability to offer delivery commitments to customers.• Brought in mid-project to bolster floundering GVS (speed metric and defect attribution system) project and facilitated rapid prototyping and new pipeline development when this became the primary metric for Amazon. Performed weekly prototyping, backfilling and report generation.• Extensive Oracle and Redshift SQL programming, ETL job creation and management, database design and query optimization work.

Irving, Texas, Us

Global Supply Network DivisionSix Sigma Green BeltServed as technical and subject matter expert for REACH & RoHS Data Collection team for enterprise.Main Responsibilities:• Managed and improved Oracle back-end and Access front-end databases and applications to manage campaigns for REACH & RoHS data collection from Tier 1 suppliers.• Processed over 10,000 REACH and RoHS supplier declarations, including inspecting for correctness and advising on corrections needed if believed to be materially defective.• Designed, developed, maintained and trained data collection analysts (12 total) in the use of a campaign management tracker tool. (Special purpose CRM software.)• Managed and improved company’s proprietary IPC-1752A xml generator. Generator given to suppliers to improve response rates.• Team achieved overall supplier response rates of 85%.• Worked closely with Engineering and Process Management staff to integrate data collection to the NPI process to reduce costs of data collection efforts.

• Held the following roles simultaneously, while managing to juggle the competing priorities of the respective positions: quality manager, IT manager, purchasing manager, account manager • Administered SQL Server backend to ERP system• Managed, from inception, program to up-fit Cat C-15’s with modifications for Australia truck market, to facilitate Cat OEM sale of 500 engines to Navistar• Performed security, backups, data cleanup, and extension of off-the-shelf functionality with custom reports, tables, functions, and stored procedures• Handled all aspects of pricing/quoting, obtaining service parts, accommodating customer requested changes as project moved along, shipping finished engines, and communications with Caterpillar and Navistar employees throughout Navistar Engine project• Purchased all consumables, from paint to repair parts for Caterpillar engines for entire enterprise• Negotiated better deals from major suppliers to save more than $35,000 in last calendar year• Served as Quality Manager, and wrote company’s Quality Manual, and drove acceptance of changes required to achieve compliance• Selected, calculated, and presented Quality Metrics to Quality Executive Committee to quantitatively capture quality issues and highlight those most in need of immediate corrective action• Trained office employees in use of ERP system, especially AP, AR, purchasing, shipping, and job movement through shop• Set up automated procedure to add repair components to repair jobs to eliminate potential for errors

Morton, Il, Us

Served as a Customer Account Manager, handling all purchase orders, quoting, and purchase order reconciliation issues for catalog of over 10,000 parts for Caterpillar’s Morton Parts Facility and Global Purchasing units.Main Responsibilities:• Reviewed incoming purchase orders, ensuring correct pricing, engineering change levels, ship-tos, surface preparation, and order quantities.• Quoted new parts, and parts with out-of-date quotes, to maximize revenue stream from service parts.• Utilized familiarity with X12 format EDI files to write EDI file import/export software to take raw EDI files and bring that information into company MRP system (Syteline).• Wrote, ran, and analyzed the results of ad hoc queries to monitor various metrics to maintain quality of customer relationship. Reported findings using Excel, PowerPoint, or Crystal Reports.• Previous duties with same company included special projects to develop accurate cost model for paint line, developing many custom screens for our MRP system (Syteline) in VB6, and facilitating MRP version upgrade.

Founded a rational-emotive based self-help service to assist those with problems in that area.

Champaign, Il, Us

Held a variety of positions including Visiting Lecturer - Computer Science, Management Methods Analyst, Teaching Assistant. Developed a series of videos used to train graduate teaching assistants and new professors in better teaching methods. Served as Senator on University Senate.

Santa Clara, California, Us

Designed database for Intel's LanDesk network/software configuration management program. Served on three person committee that revised and rewrote job ladders for all IT positions at Intel. Received three awards for making "Intel a Great Place to Work".

Chicago, Il, Us

Field Examiner to Monitor and Report on compliance of bank trust departments and free-standing trust companies.

Master Of Science (Ms), Computer Science

Military Logistics

Commissioned Ensign

Bachelor Of Arts (Ba), Economics