SUMMARY

• Experienced Project Manager, BA, DBA, Data Analyst and Software Developer wif skills and experience including:
• me.T. Project Management using Waterfall and Agile methodologies to manage teams of programmers (internal and external) in support of business requirements and project directives, providing complete and accurate data documentation, and security of data.
• Business Analysis - evaluation and documentation of operational and workflow process modeling and procedures, researching current technologies, performing gap analysis, deliverance of easy-to-understand reports, both written and verbal to stakeholders, including recommendations to improve and streamline processes, analogous wif teh regulations and procedures inherent wifin teh organization.
• Change Control and related documentation in compliance wif Sarbanes Oxley (SOX) auditing and controlling procedures, tailored to manufacturing and its associated ERP engine(s).
• Data Management, Analysis, SQL querying, setup and maintenance wif emphasis on data integrity.
• Management, stewardship and oversight of large databases - creation, ETL, programming user access screens, reports, presentations to stakeholders. Liaison between project sponsors and users down to programmers.
• Programming in Microsoft Visual FoxPro and its precursors, from inception, data mapping, user access application coding, UAT (User acceptance Testing) and training - teh entire SDLC.
• Imported massive raw ASCII text files containing tens of millions of records into comprehensive SQL tables holding 11.5 million Illinois voters, their districts and 20 plus years of each voting histories.
• Recovered from catastrophic hard drive matrix of ERP system data by finding data entry logs and re-running them individually through custom program.
• Performed forensic recovery of deleted emails from former attorneys for criminal investigation

PROFESSIONAL EXPERIENCE

Database Applications: Microsoft SQL Server and Visual FoxPro

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, Visio, PowerPoint

ERP Applications: MFG/Pro, by QAD

Engineering Applications: Autodesk’s AutoCAD and related software

Certifications: Currently preparing for PMP certification

PROFESSIONAL EXPERIENCE:

Project Manager/Data Analyst/Data Steward

Confidential, Chicago, IL

Responsibilities:

• ETL of exceptionally large (over 1 terabyte) raw ASCII data files employing Microsoft SQL Server in support of political campaigns. Performed assessment of data before performing extensive data cleanup and validation, created data dictionary.
• Analysis of election results for several candidates and referendums across respective districts and presentation before campaign teams.
• Managing data warehouse, keeping current 8.3 million record relational database, data mining, querying, and reporting as per needs of political campaigns.
• Using custom SQL and DBM queries to analyze 20 plus years of voting history allowing teh determination of teh best people and districts that require concentration of efforts.
• Successfully managed two political campaigns (candidates were elected).
• Microsoft Visual FoxPro 9 front-end developer to Microsoft SQL Server back-end working wifin an Agile environment.
• 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.

IT Project Manager/ Business Analyst

Confidential, Davenport, IA

Responsibilities:

• Inspired and lead a team of programmers, both internal and external to reach teh goals set forth in teh project plans of several initiatives, all while maintaining strict adherence to company strategies, policies and procedures, as well as compliance wifin teh SOX (Sarbanes/Oxley) guidelines during teh entire SDLC, all in support of teh company’s both short- and long-term strategies and goals.
• Managed teh upgrade and maintenance of production software, including ERP programs: MFG/Pro and MLS, both by QAD, inc., as well as EDI processes. Directed Progress programmers in customization of MFG/Pro.
• Created and managed UAT (User Acceptance Testing) plans, conducted user training.
• Acted as liaison between executive (C-Level) stakeholders/non-technical participants and front-line programmers. Conducted presentations to above individuals/departments.
• Gathered requirements, consulted wif both inside and outside consultants, implemented plans. Assisted in teh creation of project budgets, facilitated progress meetings to keep stakeholders abreast of progress, conducted risk analysis throughout teh entire process.
• Project Management from start to finish supporting approved plans, focusing on intersection of me.T. processes and manufacturing operations.
• Analyzed and performed gap analysis on existing processes involving teh separation, melting down tan reformulating aluminum for recycling. Assisted teams in constructing plans for improvement, from purchasing, inventory, and machine operation through to teh end product. Providing a main plan and possible alternatives.
• Maintained Change Management processes through change control software for SOX compliance utilizing SharePoint. Succeeded in passing internal and external audits.
• Assisted in teh upgrade of old computer systems and software to bring company up-to-date wif 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 wif clients and scanned document control. Greatly increased communication between law firm and it's clients.
• After several years, performed analysis of off-teh-shelf programs aimed at law firms, chose one and assisted in teh setup and importing of all legacy data, allowing for teh seamless transition to new program. Designed tan setup automated backup process. Trained all employees on teh use of dis new program