I work in data collection and analysis. I have extensive experience with Microsoft Access and Excel.
I work at a production facility as a Operations Data Collector. My company uses one system for recording machine downtime and a separate system for tracking maintenance and tooling work orders.
I have developed a network of Access databases that import data from each of these systems. The data is filtered and sorted and then exported to Excel spreadsheets for creating tables and graphs.
My expertise in Microsoft Access includes designing tables, queries, forms, and reports. I utilize vba code to a great extent for advanced table manipulation. I also know how to import and link external data into my databases.
My expertise in Microsoft Excel includes linking to external tables and creating charts for management review. I am experienced in Excel formulas and vba code.
Some examples of the work I've done include:
1. Charting production downtime vs work orders written.
2. Creation of production reports on a daily basis.
3. Reports to separate downtime based on production, maintenance, and tooling.
4. Tooling reports that show top problem tools, top repair issues, and a chart showing top issue by tool.
5. Reports that track setup time and setup issues.
I designed and maintain an Access Database containing 19 different forms for our process department. Each form represents a process sheet for an individual type of production equipment. The records are split by tooling and machine number.
I am proficient in Microsoft Word and Powerpoint as well. I can utilize these tools for creating work instructions.
Work Terms
I am available to work 2-3 hours per day on each weekday and 4-6 hours per day on weekends. Payments can be split with 25% due at the start of project and the rest due on completion.
I can be contacted through email and phone but prefer the initial contact be made through email.