Uploaded File
add photo
David
davewalton2000@yahoo.com
248-506-0905
34023 Moore Drive
Farmingtn Hls, MI 48335
Data Analyst
15 years experience W2
0
Recommendations
Average rating
14
Profile views
Summary

Experience
Data Analyst
Information Technology
Jan 2019 - Apr 2020
  • Worked onsite at General Motors (GM) to provide business IT support for the GM Fleet & Commercial Forecast Planning Team, which is responsible for forecasting and planning production volume for fleet and commercial vehicle customers.
  • Maintained mainframe Easytrieve programs and JCL members used to create reports used by the business team. Created additional reports using MS Access databases.
  • Used Easytrieve and SQL to extract data from multiple DB2 databases and format for import into Excel and Access. Queries needed to be tailored to retrieve only specific vehicle types and/or order types.
  • Assisted with migration of Easytrieve programs and JCL members into Endevor source code control tool in order to comply with GM IT standards.
Data Analysis DB2 Microsoft Excel SQL
Remove Skill
Application Analyst
Information Technology
Jan 2007 - Jan 2013
  • Subject matter expert for General Motors (GM) Dealer Information Database (DID) and Dealer Network Planning System (DNPS) applications oversaw maintenance and minor enhancement activities performed by offshore team of four. DID is a large, business-critical DB2 database containing information for dealers and other business entities conducting business with GM. DNPS is an application used to store contractual data for its US retail dealerships. The combined size of these applications is approximately 300 DB2 tables and 800 programs.
  • Oversaw and directed application maintenance and minor enhancements for Government Bid application, which uses mainframe FOCUS online and batch components.
  • Worked with General Motors application owners to gather and define requirements for software modifications, and to prioritize tasks to be completed by the Capgemini offshore teams. Also coordinated user acceptance testing and production deployment of software changes.
  • Participated in annual disaster recovery testing updated test plans and performed live testing.
  • Worked with multiple vendors to complete user access requests, coordinate production changes, obtain application input data, and provide data to downstream applications. Served as the Capgemini representative to integration team meetings held by mainframe hosting vendor (Hewlett Packard).
  • Created a number of complex SQL queries to provide customer with ad-hoc reports needed to make business decisions.
  • Seamlessly migrated midrange copy of DID database from Solaris server to a new LINUX server.
  • Prepared applications for updates to mainframe software. Mainframe software upgrades most notably included two z/OS versions and two DB2 version upgrades. Jawood Management
Linux SQL
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Science
Michigan Technological University
Certifications
Information Technology Infrastructure Library (Version 3) Foundation Certificate
Skills
SQL
2020
7
Linux
2013
6
Data Analysis
2020
1
DB2
2020
1
Microsoft Excel
2020
1