James Fuchs Resume James Fuchs, Websites, IT & Software
Summary:
Experienced BA, DBA, Data Analyst and Software Developer and who just finished a one-year assignment working from home office using FoxPro as a front-end to a SQL Server back-end. I have skills and experience as follows.
• An experienced Business Analyst capable of assessing processes and procedures, researching current technologies, performing gap analysis, and highly skilled in the deliverance of easy to understand reports, both written and verbal to stakeholders.
• An experienced I.T. Project Manager using Waterfall and Agile methodologies to manage teams of programmers (internal and external) in support of project directives.
• Experience in Change Control and related documentation in compliance with Sarbanes Oxley (SOX) auditing processes.
• Over 25 years’ experience managing large databases – creation, analysis, importing of raw data, programming user access screens and reports as per needs of stakeholders.
• Over 25 years’ experience programming in Microsoft Visual FoxPro and its precursors, from inception, data mapping, user access application coding, UAT (User acceptance Testing) and training.
Specialties:
• I.T. Project Management, utilizing both Waterfall and Agile methodologies
• Business Analysis, Gap Analysis
• Database design, programming, and maintenance
• Development using Microsoft SQL Server as a back-end to a Microsoft FoxPro 9.0 Front-end
Technical Skills:
Software Applications All Microsoft programs including Microsoft Word, Excel, Publisher, Outlook, PowerPoint, Visual FoxPro, Microsoft OS from DOS 3.3 through Windows 10
Project Management Jira, Excel
ERP Applications MFG/Pro, by QAD
Database Applications Microsoft SQL Server and Visual FoxPro
Engineering Applications Autodesk’s AutoCAD and related software
Certifications Currently preparing for PMP certification
Professional Experience:
Software Developer Sept. 2019 – Oct. 2020
Data Age Business Systems, Inc, Clearwater, FL (remote assignment)
• Microsoft Visual FoxPro 9 front-end developer to Microsoft SQL Server back-end.
• Upgraded pawnshop POS software to utilize on-line sale of store’s stock, using API calls to website.
• Updated and maintained software, including debugging of errors, both from internal sources as well as a 3,500-customer base.
• Enhanced existing features to satisfy customer base desires.
• Addressed work tickets from Jira project management software.
Business Analyst / IT Project Manager Oct. 2013 – Nov. 2015
Quanex Building Products, Davenport, IA
● Analyzed and performed gap analysis on existing processes involving the separation, melting down then reformulating aluminum for recycling. Assisted teams in constructing plans for improvement, from purchasing, inventory, and machine operation through to the end product. Providing a main plan and possible alternatives.
● Acted as liaison between executive (C-Level) stakeholders/non-technical participants and front-line programmers. Gathered requirements, consulted with both inside and outside consultants, implemented plans. Assisted in the creation of project budgets, facilitated progress meetings to keep stakeholders abreast of progress, conducted risk analysis throughout the entire process.
● Inspired and lead a team of programmers, both internal and external to reach the goals set forth in the project plans of several initiatives, all while maintaining strict adherence to company strategies, policies and procedures, as well as compliance within the SOX (Sarbanes/Oxley) guidelines during the entire SDLC all in support of the company’s both short- and long-term strategies and goals.
● Maintained and upgraded production software, including ERP programs: MFG/Pro and MLS, both by QAD, inc., as well as EDI processes.
● Project Management from start to finish supporting approved plans, focusing on intersection of I.T. processes and manufacturing operations.
● Created and managed UAT (User Acceptance Testing) plans.
● Maintained Change Management processes through change control software for SOX compliance utilizing SharePoint. Satisfactorily succeeded in passing audit.
Data Analyst - Telecommute Contract Mar. 2004 – Sept. 2019 (seasonal)
Ogden & Fry, LLC, Chicago, IL (remote contractor for satisfying technology needs)
● Importing, cleaning, data-mapping, then parsing exceptionally large (over 1 terabyte) raw ASCII data files employing Microsoft SQL Server in support of political campaigns.
● Managing data warehouse, keeping current 8.3 million record relational database, data mining, querying, and reporting as per needs of political campaigns.
● Analysis of 20 plus years of voting history allowing the determination of the best people and districts that require concentration of efforts.
● Managed two political campaigns with successful results (candidates were elected)
Business Analyst/I.T. Administrator 2008 - 2013
The Law Group, Chicago, IL
● Assisted in the upgrade of old computer systems and software to bring company up-to-date with current hardware and software including Microsoft Office and its ancillary programs, enabled client to expand his practice
● Compiled and reorganized over 12,000 client records and associated data into one comprehensive database and wrote a program using Microsoft Visual FoxPro 7.0 through 9.0 enabling users to search, edit, and report data including automated e-mail communications with clients and scanned document control. Greatly increased communication between law firm and it's clients.
● After several years, performed analysis of off-the-shelf programs aimed at law firms, chose one and assisted in the setup and importing of all legacy data, allowing for the seamless transition to new program. Designed then setup automated backup process. Trained all employees on the use of this new program
Business Analyst/Database Programmer – Microsoft FoxPro – Various Contracts 2002 – 2013 Including:
● Digital Pix Composites, Crystal Lake, IL
o Programmed database front-end using SQL back-end
● Several Law offices including:
o Law office of Steven A. Leahy, Chicago, IL
o The law firm of Touhy and Touhy, Ltd
Other notable achievements 1990 – 2008
Team Leader, CAD and Documentation Control
• Atlas Electric Devices Co., Chicago, IL
o Assisted in the installation and configuration of a new ERP system. Customized for company use the manufacturing software MFG/Pro (QAD, Inc.). Exported company’s entire manufacturing system and inventory data from a DEC VAX system to PC-based networked PCs. Implemented engineering change order modules that changed and maintained over 4,000 bills of material.
o Assisted in the implementation of company-wide MRP (Material Requirements Planning) software system to manage manufacturing of large scale machines. Extracted, modified and replaced data out of and back into system including bills of materials to support “just in time” inventory control.
o Managed technical writers developing user manuals of equipment
• Computer Output Process Engineering, Inc., Tucson, AZ
o Helped Design and build paper-handling machinery
• Vega Technologies ,Inc., Tucson, AZ
o Helped design and build world’s first computer controlled DNA synthesizer
Websites, IT & Software
Database Administration
Database Development
Database Programming
Microsoft SQL Server
Programming