* Combined multiple databases into one to organize the data and to make the database easier to work with by creating multiple new forms and reports.*Automated the daily user and term file processes from 40 minute down to a 1 or 2 minute process which was also error proof.* Worked directly with business users and IT peers to define and document project scope and requirements. * Created multiple Data Transformation Services (DTS) to move data between SQL tables and Microsoft access… Show more * Combined multiple databases into one to organize the data and to make the database easier to work with by creating multiple new forms and reports.*Automated the daily user and term file processes from 40 minute down to a 1 or 2 minute process which was also error proof.* Worked directly with business users and IT peers to define and document project scope and requirements. * Created multiple Data Transformation Services (DTS) to move data between SQL tables and Microsoft access and to also update a group of user’s automatically thru e-mail when everything is completed successfully.* Worked with Security Compliance business users to gather requirements for enhancements to the Security Compliance database interface.* Maintained the Security Compliance database used for various IT audits such as SOX and SAS70.* Converted the Security Compliance Database from Access to SQL Server using ADO, ODBC and Microsoft SQL Server Management Studio.* Wrote scripts to automate data transformation and loading of platform and application files containing user account information using ADO and VBA.* Wrote Access application to search, save, and print messages and attachments from Outlook mailboxes by dates received and subject line.*Performed quarterly access reviews of all 15,000 users from over 30 different platforms. Show less

I converted a production forecast excel file into an Access database. This required multiple forms, queries, and multiple custom reports to be written. Database will be used by over 100 users.

• Streamlined existing Access database to work more efficiently, saving the users 6 hours of processing time.• Designed and developed an Access database to enable vendor conversion from mainframe to a new Oracle Accounts Payable system.• Converted Access reporting system from an ad hoc Oracle database to the Supply Chain Oracle standard database. This required query rewrites in addition to new forms and reports within Access.

• Developed and maintained an Access / SQL database (Engineering Tracking System) to track all program builds, ECR/ECO system, part number creation, build issues, work tickets, standard specifications, and purchase requisition system• Converted Access Database to SQL Database with Access Database Project as the front end• Setup and Maintain BOM configurations in ERP system (Axapta)• Participated in a small group to create new ECR (Engineering Change Request / ECO (Engineering Change… Show more • Developed and maintained an Access / SQL database (Engineering Tracking System) to track all program builds, ECR/ECO system, part number creation, build issues, work tickets, standard specifications, and purchase requisition system• Converted Access Database to SQL Database with Access Database Project as the front end• Setup and Maintain BOM configurations in ERP system (Axapta)• Participated in a small group to create new ECR (Engineering Change Request / ECO (Engineering Change Order) process• Developed an access database to create, process, and close the ECR/ECO’s• Participating and creating many of the processes needed by the engineering group• Create and manage entire list of part numbers for the system and transportation groups• Design, release, and order all the labels that are needed for the battery pack systems, and Transportation systems• Process all of the ECR/ECO for the System and transportation groups Show less

• DRE for labels and bag assembly • Author/Track ECA’s (EWO’s) • Create access database to track “signature series” vehicle builds• Manage/track entire fastener database with access for SSR program• Research/track mass issues for all truck program components• Managed project migrating VT part numbers to GM part numbers• Utilize UG, iMAN, and have exported design data to FTP sites for suppliers• Handled various PC, network and system issues as needed

• Co-author, validate, and track TWO’s (Temporary Work Orders)• Maintained MS Access Databases for Saturn LS/LW• Created and set up access databases at Hummer H2 Plant for tracking and reporting to all levels of management on all issues dealing with the building of the Hummer H2 Truck• Created 7 access databases that interacted with each other• Reported in many different types of meeting to executive management• Trouble shoot hardware & software issues.• Support for DRE… Show more • Co-author, validate, and track TWO’s (Temporary Work Orders)• Maintained MS Access Databases for Saturn LS/LW• Created and set up access databases at Hummer H2 Plant for tracking and reporting to all levels of management on all issues dealing with the building of the Hummer H2 Truck• Created 7 access databases that interacted with each other• Reported in many different types of meeting to executive management• Trouble shoot hardware & software issues.• Support for DRE (Design Responsible Engineer) Show less

• Installed network cables for networks consisting of 1000-2000 computers• Prepared calculations for wiring requirements based upon network area• Ensured accuracy of information flow from system servers to network hubs• Tested to ensure proficiency and quality of installation for system functions• Troubleshoots equipment to correct network errors