• Responsible for creating residential marketing lists based on criteria give by marketing group and management. Process consists of loading text files into Oracle database, standardizing data, executing filtering based on criteria and exporting list for printing company.• Assisted IT group with ETL of customer data from external billing company to and internal billing system as part of a company merger.• Created multiple Python scripts to scrape website data and save it to a MySql database.• Created C# program to upload data to Emma email marketing platform.

• Created C# application to download variable quantities of files from multiple vendors FTP sites and preform automated ETL process into an Oracle database.• Improved Oracle database performance and data integrity by implementing indexing and foreign keys.• Created tables and views to help track business operation data in Oracle that was not previously being tracked.• Created C# application that logs into a web site and submits customer account numbers required by the utility. This automated process submits approximately 100 records in five minutes.• Responsible for UAT of web application. Must coordinate testing and problem resolution between end users and development team.

• Automated existing manual reporting process using C# to do the following: Allow reports to be viewed in a database, export data to Excel, and email reports to customer service representatives or directly to the customer.• Created C# application to import CSV files from ERP system into MySql database. The application is a multi-threaded application that simultaneously downloads 11 files from an FTP server and 20 files from Outlook and then imports them into the database.• Created a C# application that exports data into a fixed width text file for customer to import into SAP.• Responsible for ad hoc reporting for customer service representatives, managers and customers.• Created an Access database to ensure compliance with customer pricing contracts. Database compares cost and price, and then requires customer service to give an explanation of why an order was not compliant.

• Web administrator for facility and database administrator of several Access and MySql databases.• Designed a web based repair backlog application.Created a Visual Basic program that imports data from an Oracle based ERP system and exports the data into a MySql database. Site has query and filter capabilities and a dashboard for progress analysis.• Designed a web based quoting application.Requests for quotes are submitted by an offsite employee.The application allows for data entry and extracts product structure, inventory and cost information from ERP system.Quote information is automatically emailed to responsible individuals.• Designed several web based reports that eliminated manual reporting processes for purchasing, customer service and manufacturing departments.• Designed an Access database to extract data from an Oracle database and populate Excel spreadsheets.The spreadsheets were used by the IT department to transfer data from one ERP system to another.Spreadsheets were originally populated manually.• Designed a web front end for customer service and engineering departments to query data from legacy systems. Data is stored in Microsoft SQL server, Access and MySql databases.Data could not be migrated into new systems and a query interface was needed.• Designed a project management application for engineering department.Application uses a web interface and Access database to manage projects and work load.Time can be allocated to projects to measure percentage of completion.• Created a Total Productive Maintenance database and web front end.Database is used to track maintenance history of equipment.Designed a Visual Basic.Net program that generates and emails a dynamic maintenance report on a weekly basis.• Participated in Lean Enterprising and 5S projects.• Participated in ISO 9001:2000 and ISO 14001 audits.• Received three recognition awards for work on a server migration project, a web application project and an ERP migration project.

• Created an Access database to track order information that was not in ERP system and allowed for additional reporting capabilities.• Created an Access database to track time spent working on orders so it could be billed back to customer.

Assembled printed circuit boards.