Timothy P. Jackson

Lewes DE *****

Phone: 443-***-****

E-mail: ad3tiq@r.postjobfree.com

Objective

To continue my computer science career with a progressive and growth-oriented organization and to seek the opportunity to fully utilize my education, background, experience, interpersonal relationship skills, and proven administrative abilities.

Areas of knowledge

Software:

Data Warehouse; Oracle 11g; IBM InfoSphere DataStage 11.5; Python 3.6;

Tableau 2019, 2018 & 10; R Programming for Data Science;

Netezza relational databases; Excel Power Query 2016; Business Objects 10; OBIEE Reports; SQL*Plus; SQR Report Writer; PeopleSoft EPM 9.1; PeopleSoft HRMS 9.1; PeopleSoft Financials 9.1: General Ledger, Payables, Receivables.

Strongest personal capabilities

Excellent interpersonal and customer service skills. Ability to learn quickly and adapt to new systems. Flexibility in job performance. Ability to utilize current resources to complete tasks. Self motivated to see a task to its completion.

Consulting Experience

October 2022 to December 2022

TIAA

Charlotte, NC

Position: DataStage Developer - Conversion Specialist

Performed Data Stage coding and development

November 2020 to May 2021

Main Street America, MSA

Jacksonville, FL

Position: Data Warehouse Architect

Position Tasks: -Code (Python/DataStage/SQL) jobs -Perform Code Reviews

Create and document new process and procedures

Effectively communicate with IT and Business partners

Performed Python coding and development

Performed Data Stage coding and development

Performed performing Code reviews

Performed Data Modeling with both Oracle and SQL Databases

July 2019 to March2020

Bank of America

Charlotte, NC

Position: Data Science, Cyber Security – GSI

Automated Cyber and Privacy Risk Management

Data Automation

oGather data from dissimilar systems, (SQL Server, Cloudera, REST API, CSV, Excel).

oPython 3.x to connect to and manipulate (SQL Server, Cloudera, REST API, CSV, Excel).

oVBA to manipulate and execute Python 3.x code.

oWXPython to display all data from dissimilar systems.

Data Lineage

oAssisted with the accuracy, development and automation of data lineage from source to metrics.

oCreated Python scripts to read PHP files to validate data streams from the source to the metrics.

April 2018 to July 2019

Self-study Development

R Programming for Data Science - Certificate of completion

oData Analytics, Statistical Analysis, Packages, Functions, GGPlot2

Tableau 2019, 2018 & 10 - Certificate of completion

Tableau 2018: Hands-On Tableau Training for Data Science - Certificate of completion

Tableau 2018 Advanced: Master Tableau in Data Science - Certificate of completion

Machine Learning training. Data Scientist Python 3.6. - Certificate of completion

oData Preprocessing (Data cleansing)

oArtificial Neural Networks (for example, client retention)

oConvolutional Neural Networks (for example, photo recognition)

oSimple Linear Regression (for example, salary vs. experience)

oLogistic Regression (for example, age vs. salary with probability to purchase)

oAssociation Rule (for example, people who bought product A and also bought product B)

oMultiple Linear Regression - Where Resources Best Spent (for example, R&D spend vs. Administration spend vs. Marketing spend by state profitability)

Developed a table driven ETL process in Python 3.6.

oFrom a list select the tables to be moved from the source to the OWS to type 2 dimensions.

oIn a multiple processing environment

March 2015 to April 2018

COMPASS GROUP USA, INC.

Charlotte, North Carolina

Position: Sr. Developer EPM

Developed Python 3.6 programs to verify text files format for processing.

Created DataStage 11.5 Parallel ETLs, to load text files into Netezza relational databases 7.1.

Created DataStage 11.5 Parallel ETLs, to clean, verify and load data into the OWS.

Implemented SCD type 2 for OWS and MDW to facilitate as of date reporting.

Developed UNIX script to move files from input folder to proper folder for processing.

Developed DataStage 11.5 Parallel ETLs to parse multi record type file for ETL processing.

July 2012 to March 2015

University of Wisconsin Platteville

Platteville, WI

Position: Sr. Developer EPM

Installed Campus Solutions 9.1 for EPM 9.1 data warehouse.

Created new DataStage 8.5 Parallel ETLs to clean, verify, and load data into the OWS.

Installed update and configured dimension and fact tables to accommodate custom tables.

Improved the overall load time from 16 hours to less than 4 hours from the campus solutions source system to the Data Marts.

Created new DataStage 8.5 Parallel ETLs for the top ten slowest ETLs to improve performance.

Developed change management ETL process to detect changes in online system to improve uptime of data warehouse.

Developed error reporting ETL to facilitate distributive departmentalized reporting to help end-users correct data issues.

Knowledge transfer of staff to ensure independence.

Modified delivered ETL maps to facilitate changed or missing data structures in the online system.

Automate load process through the director with email notification.

May 2011 to Dec 2011

University Of Wisconsin

Madison, WI

Position: Sr. Developer EPM

Created database triggers to capture “changed data” from the source database to ETL into EPM 9.1 data warehouse.

Created DataStage 7.5.2 ETLs to clean, verify, and load data to the Operational Data Store.

Created DataStage 7.5.2 ETLs to enrich and load data into the enrichment layer of the EPM 9.1 data warehouse.

Sept 2010 to May 2011

AIG, Manhattan, NY

Position: Sr. Developer EPM

Design and develop Ascential DataStage 7.5.2 ETLs to load payroll data from several different systems from several different countries into EPM 9.1.

Design and develop complicated data cleansing and validation procedures.

Design and develop Ascential DataStage 7.5.2 ETLs to load OWS tables into MDW data warehouse.

Design and develop Ascential DataStage 7.5.2 procedures to auto load data from dissimilar systems using source system variables.

Sept 2009 to Sept 2010

New York State Government, Albany, NY

Position: Sr. Developer EPM

Document and design customizations for EPM 9.0 data warehousing process in Oracle 11g.

Developed Ascential DataStage 8.1. data maps to move data from OLTP database to OWS of data warehouse.

Created a custom Repository for custom OBIEE reports.

Created custom views in the Repository to facilitate business rules for OBIEE reports.

Developed custom OBIEE reports for general ledger, accounts payable, and accounts receivable.

April 2008 to May 2009

Deltek, Herndon, VA

Position: Sr. System Consultant

Designed data models for the data warehouse process using Erwin Data Modeler.

Developed data warehouse product using DataStage 8.1.

Developed DataStage 8.1 data maps to move data from OLTP database to ODS of data warehouse.

Developed DataStage 8.1 incremental data maps to move data from ODS to data warehouse tables.

Developed incremental DataStage 8.1 data maps to move data from ODS to dimensional and fact tables of data marts.

February 2007 to December 2007

Commonwealth of Pennsylvania

Position: DataStage Developer - Conversion Specialist

Worked with data modeling team to develop OLTP production database using Erwin Data Modeler in Oracle 11g.

Developed QualityStage map to perform name cleansing.

Developed QualityStage map to perform address cleansing.

Developed QualityStage map to perform date cleansing.

Developed Ascential data maps to move data from mainframe legacy system into Oracle database 11g tables using complex flat file.

July 2006 to February 2007

Florida State University, Tallahassee, FL

Position: Sr. Developer EPM

Converted EPM 8.8 to EPM 9.0 for PeopleSoft Financials.

Created new Ascential maps to work with customized tables to load data into existing EPM tables.

Created new Ascential maps to populate new data marts.

Developed Ascential data maps to load customized tables from PeopleSoft Financials 9.0 to create custom data mart.

Reduced total load time from thirteen hours to seven hours.

Developed financial Business Object reports, accounts payables and account receivables.

April 2005 to June 2006

Rain Bird, Tucson AZ

Position: Sr. Developer EPM

Configured EPM 8.9 delivered Ascential data maps to work with PeopleSoft Financials and Supply Chain Management 8.0.

Created new Ascential maps to work with customized tables to load data into existing EPM tables.

Modified existing Ascential maps to populate delivered data marts.

Developed Ascential data maps to load customized tables from PeopleSoft Financials 8.0 to create custom data mart.

Implemented SCD type 2 for OWS and MDW to facilitate as of date reporting.

February 2005 to April 2005

GTSI, Chantilly, VA

Position: Sr. Developer EPM

Designed and implement ODS tables, data loader maps, data warehouse tables.

Conducted fit/gap analysis between PeopleSoft SCM 8.4 and PeopleSoft EPM 8.8.

Designed and implement alternative solutions to resolve gaps.

Created custom Informatica 6.1 maps to load legacy data into ODS.

Implemented and executed Informatica 6.1 processes to migrate data from source systems.

Trained client staff to manage and maintain EPM process.

February 2004 to November 2004

D.O.D.

Reston, VA

Position: PeopleSoft EPM 8.8 Implementation – Programmer/Analyst

Performed analysis and development of four data marts.

Designed and implement ODS tables, data loader maps, data warehouse tables, data mart tables and data mart builder.

Conducted fit/gap analysis between PeopleSoft Financials 8.8 and PeopleSoft EPM 8.8.

Designed and implement alternative solutions to resolve gaps.

Created custom Ascential DataStage 7.1 maps to load legacy data into ODS.

Implemented and executed Ascential DataStage 7.1 processes to migrate data from source systems.

Developed and modified Cognos cubes to facilitate custom reports.

Trained client staff to manage and maintain EPM process.

April 2003 to December 2003

Kerr – McGee Oil &Gas,

Oklahoma City, OK

Position: PeopleSoft EPM 8.8 Implementation – Programmer/Analyst

Performed data analysis on source system to identify corrupt data due to implementation, conversions, and mergers.

Conducted fit/gap analysis between HR 8.3 and PeopleSoft EPM 8.8.

Designed and implement alternative solutions to resolve gaps.

Coordinated and conducted system testing and researched/resolved testing issues.

Implemented and executed Informatica processes to migrate data from source systems

Analyzed external source data from ADP payroll and benefits and mapped it to PeopleSoft payroll tables.

Created custom Informatica maps to load ADP payroll and benefits data into ODS.

Trained client staff to manage and maintain ETL process.

Installed and upgraded informatica PowerMart from 5.1 to 6.1.

April 2002 to February 2003

Thrivent Financial for Lutherans, Green Bay, WI

Position: PeopleSoft EPM 8.3 Implementation – Programmer/Analyst

Conducted fit/gap sessions and demonstrated PS 8 Enterprise Warehouse functionality.

Scoped client’s business requirements.

Developed Informatica ETL maps to move data from operational system to the ODS that was not delivered with PeopleSoft EPM 8.3.

Used Informatica to load the staging and reporting tables in PeopleSoft EPM 8.3.

Coordinated and conducted system testing and researched/resolved testing issues.

Trained client staff to manage and maintain ODS system.

Completed on a timely basis the development of all conversion SQRs used to convert employee data into the new system.

March 2001 to November 2001

GlaxoSmithKline, Philadelphia, PA

Position: PeopleSoft HR Consultant – Programmer/Analyst

Technical resource on Apollo project to convert HR system for GlaxoSmithKline to PeopleSoft 8.2. This project included two United States and two United Kingdom sites.

Timely completion of the development of over 40 conversion programs for the US and the UK used to convert employee data into the new system.

Successful completion of unit testing on all assigned SQR conversion programs. Educated and supported client personnel on SQR and PeopleSoft as needed.

Developed procedure and SQR to convert position data from legacy system to position data in PeopleSoft 8.2.

Contact this candidate