SUMMARY

Experience Summary

Seasoned IT Professional offering over 15 years of experience in developing, implementing, and administering business applications in Financial, Government and Manufacturing sectors. Skills include business process and systems analysis, project management,database and systems development, technical training, system/process documentation and technical writing. Certifications include MCSE, MCDBA. MCT, CTT+.

Work History

09/2012 – Present Confidential,Houston, TX – Senior Developer/Project Manager – Serve as Senior IT resource using MS Access, SQL Server, SAP Business One, WMS systems (Accellos), Crystal Reports and other software to develop applications and tools in support of accounting, shipping, invoicing, sales tracking, inventory, etc. functions at high end Consumer and Industrial lighting Wholesaler/Manufacturer.

• Rebuilt application for creating monthly sales rep reports/exporting reports to excel/emailing reports to relevant sales reps and sales associates using Access, Excel, VBA, SQL, and SQLServer.
• Built application to track/report on outstanding invoices and credit memos for accounting department using Access, Excel, VBA, SQL.
• Supervising ongoing project to install/upgrade latest version of SAP Business One and ensure successful integration with new WMS system.

09/2011 – 09/2012 Confidential,Durham, NC – Project Manager-Senior Business Systems Developer– Initially engaged to head up project to design and build automated policy sales/pricing bid application for Company’s annual policy renewal effort.

• Wrote project plan based on business process analysis, review of existing needs documentation, and end user interviews/JAD meetings.
• Designed and built MS Access 2007 database application from scratch to address business needs. Work included creation of forms, queries, reports, tables, VBA coding, functions, indexes, front end/back end databases, etc.
• Created user and admin documentation, trained end users in functionality, served as DBA for application.

Created Access 2007 application used to produce monthly/YTD summary reports for QA department in Excel for multiple departments within the company.

• Leveraged existing report capabilities by reworking existing data sources to fit new requirements.
• Utilized Crosstab queries, VBA, and SQL to create dataset and export/format to Excel spreadsheets report templates.
• Application launched ahead of schedule, resulted in time savings of several FTE workdays per month.

Built Access 2007 application used by COBRA insurance team to review/edit/correct correspondence data points for COBRA group recipients.

• Based on user interviews, created forms, queries, reports, VBA code to build application.
• Wrote user and admin documentation, trained end users.
• To date have released 5 updates/revisions to application, and serve as DBA/Sys Admin for this application.

03/2011 – 8/2011 Confidential,Austin, TX – Project Manager-Developer/Analyst– Brought back by previous client (see below) to augment/improve existing Fiscal Viability application previously developed in Access 2003.

• Based on updated specifications, reworked various forms, queries, and functionality of existing application.
• Rewrote VBA fiscal “scoring” code, reworking various formulas and ratios.
• Wrote user and admin documentation, trained end users.

Also carried out additional project to analyze, rework, and re-launch parallel Access 2003 based system used to determine “at risk” Nursing home operations within state. application used within the department.

• Performed business process analysis, determined project scope, developed project plan and schedule.
• Documented existing objects/code/procedures within system, remediated errors in code, reworked procedures and objects to ensure functionality, created additional code (including complex queries) and objects where needed.

Rebuilt, modified and re-launched both applications successfully- on time and within budget.

04/2010 – 02/2011 Confidential,Houston, TX- IT Manager, Loss Mitigation Department – Managed seven person development/support team working on Access 2003/Oracle based application critical to the operation of business. Responsible for deriving development plans, assessing prioritizing and assigning project tasks, setting team goals, establishing time lines and dependencies, assigning resources to tasks and performing administrative tasks necessary to keep team functioning smoothly. Performed as project manager for multiple federal directive technical enhancement efforts, ensuring successful deployment of 5 federal directive software releases.

01/2010 – 04/2010 Confidential,Austin, TX- Auditor/Analyst – Worked on project to audit, analyze, and rework billing schedules and rates for data/telecom clients. Analyzed expired and existing service agreements and contracts, evaluated historical bill rates, and determinined appropriate current telecomm rates/charges in various markets nationwide.

03/2009 – 6/2009 Confidential,Downers Grove, IL- MS Access Developer/Business Analyst – Engaged to revise/rework Microsoft Access based application used for QC for manufacturers of all paper/plastic items used in McDonald’s restaurants worldwide. Additionally, tasked with analyzing Excel based “reporting system” used to track Latin American sales of McDonald’s packaging usage and costs.

• Performed business process analysis, conducted interviews to determine current functionality and derive technical requirements for enhanced QC system.
• Based on system analysis, determined data inputs/outputs for Access and Excel based applications. Created form for controlling regular/specific reports that would take user inputs to determine report content/output.
• Implemented procedures/code to vastly improve efficiency and accuracy of QC effort. Utilized VBA, .pdf outputs, improved user interfaces to achieve efficiencies.
• Engaged in meetings/teleconferences in order to scope/determine project for Latin American cost capture process, local QA effort.
• Utilized Microsoft Access, Excel, VBA, ODBC, Adobe Acrobat for this project.

10/2008 – 12/2008 Confidential,Schaumburg, IL- Access Developer/Project Manager - Engaged to co-lead project designing, building, prototyping and implementing BI dashboards for executive team.

• Performed business process analysis, conducted interviews to determine KPIs and KPI trees, data sources.
• Based on client interviews, determined functional/business requirements and determined project scope.
• Designed, built and implemented MS Access database for project.
• Designed/prototyped dashboards, determined data feeds, etc.
• Utilized Microsoft Access, Excel, Powerpoint, and VBA for this project.

4/2008 – 9/2008 Confidential,Austin, TX – Project Manager-Developer/Analyst - Engaged by a Texas State agency (DADS) to plan, build and implement prototype MS Access based application used to gather financial data used for determining fiscal viability of assisted care facilities. Activities included:

• Performed interviews with users and co-chaired meetings with departmental representatives and managers to determine system needs, requirements, expectations and project scope.
• Based on client interviews and analysis of existing business processes, “reverse engineered” existing process used to determine facility financial ratios. From analysis of existing procedures and through client interface, derived functional specification for project.
• Analyzed existing business processes to identify if and where efficiencies could be introduced into the process as well as to determine overall application design.
• Based on analysis and the interview/meeting results, determined project scope, formulated project plan and identified project deliverables.
• Designed and built application using Microsoft Access, VBA, and Excel. Wrote uat plans, composed test scripts for designated users. Based on test results, performed intensive iterative modifications/testing in order to ensure accuracy and usability of system.
• Application utilized multiple inputs for lookups, scoring routines, reports, and system permissions.
• Performed both ad-hoc and “classroom style” teaching in use of system.
• Due to positive user testing results, launched system one month early. System was a great success, with considerable savings of time realized in data entry, business analysis and viability determination.
• Increased accuracy and accountability attained through use of the system, with high overall user satisfaction in regards to simplicity, effectiveness and ease of use.
• Wrote technical documentation for application, providing dba/tech support for remainder of engagement.

8/2007 – 12/2007 Confidential,Foster City, CA – Pre-Sales Engineer Worked as pre-sales engineer for appliance based web and database security company. Activities included serving as technical resource for sales presentations, installing hardware for pilots, attending trade shows, etc.

3/2007 – 8/2007 Confidential,Chicago, IL – MS Access developer/Analyst Was engaged to analyze, re-architect and make necessary changes to a Microsoft Access based (Access front end, SQL Server back end) application used to track maintenance and capital project costs for multiple sites/buildings. Enhanced application for multi-site functionality, etc. Analyzed and re-engineered Access front end, SQL Server backend, ODBC connectivity, VBA, and stored procedures, reports. Responsible for project plan, scheduling, etc.

2/2005 – 12/2006 Confidential,Des Plaines, IL – MS Access Developer/DB Administrator – Engaged to serve as both systems analyst/developer and database administrator for Microsoft Access database system used to process Mortgage loan applications for department of multi-national bank.

• Reworked/re-engineered major portions of MS Access database, dramatically increasing efficiency and reducing data corruption failures over 90%
• Created multiple forms used to determine fiscal ratios, sql inputs, date parameters, report composition and subject matter, import/export routines, etc.
• Based on fundamental change of core business process, led project to re-write back end schema, develop data archive, and re-engineer system front end to interface with new back end. Designed and executed test plan, based on results finished project early, performed cut-over with minimal impact to end user.
• Managed project to rework existing and develop new standardized month end, compliance, and performance metrics reporting modules as well as new module to assist in reporting for mortgage aftermarket program. Resulting reports improved accuracy of compliance reporting, increased ability to measure employee performance, and assisted greatly with providing financial data for mortgage resale activity.
• Performed multiple ad-hoc financial analyses, produced countless ad hoc Access reports/studies used for various business activities.
• Served as dba and technical support lead, responsible for system documentation, backups, user training, security, data archiving, etc.

10/2004 – 1/2005 Confidential,IL – MS Access developer/Project Manager - Engaged to build an Access based system used to predict and track project management labor workload for North American plants and operations.

• Based on existing system and project charter/instruction, determined system requirements and design, derived mathematical basis for workload algorithms.
• Built and installed system, performed iterative user testing, made system changes based on test results.
• Developed feasibility guidelines to ensure accuracy of workload algorithms, developed and implemented utilities to enforce guidelines.
• Developed and implemented utilities to ensure data integrity and “cleanliness” pre-import/pre-export. Utilities controlled by forms requiring user inputs in re: subject matter, geographic area, date ranges, etc.
• Utilized Access, Excel, SQL Server, ODBC in project.

6/2004 – 9/2004 Confidential,Chicago, IL – MS Access Developer – Engaged to design and implement Access database used by the IT security department to identify and classify the sensitivity and confidentiality of financial data elements used in the operations of the bank, with emphasis on complying with various statutes of Sarbanes Oxley legislation. Project activities:

• Performed intensive user interviews, business process analysis, and requirements analysis. Based on findings, developed project plan, project scope, and system design.
• Developed and built database system. System utilized lookups, reports, and algorithms based on user input controlled by forms.
• Wrote user test plan, test scripts. Executed plan, performed iterative enhancements/tests to build satisfactory system.
• Developed and implemented utilities and procedures to ensure data accuracy, system security.
• Wrote technical and user documentation, performed user training, served as dba for length of engagement.

4/02-5/04 – Confidential,Chicago, IL – Vice President/Treasurer
Co-founded, served as Vice President and Treasurer for start up network integration and security services company.

• Performed the entrepreneurial functions necessary for starting a company- corporate filings, tax documents, financial statements, etc.
• Co-developed website and marketing material creation, assisted in strategic partner development, client presentations, writing bids and RFPs.
• Performed and documented network assessments- analyzed networks to identify vulnerabilities, provide software/hardware recommendations for securing network and network optimization.
• Developed curriculum for and taught MCSE 2000 track classes.
• Provided client with tailored two week class in Server 2000 install/configuration/security and usage, basics of MS Access 2000. Project included developing curriculum and writing training manuals based on client needs assessment.

5/00-3/02 Confidential,Chicago, IL– Developer/Analyst-

• Served as co-Project lead for development and implementation of registration web-site for national annual convention (30,000 + attendees). Cleansed/edited initial and subsequent data loads, performed daily cleansing to remove invalid/duplicate data. Utilized Access for back end reporting requirements of site, using ODBC to attach to MYSQL database. Performed functional analysis to determine scope and objectives of project. Documented and trained end users on finished application. Established deadlines, evaluated and chose software tools necessary for project, which finished on-time and under budget.
• Designed and implemented Access database to assist in tracking project progress, milestone achievement and log developer concerns/action items.
• Collaborated on design (based on client interviews, needs analysis) and implementation of Oracle database (schema, PL/SQL, stored procedures, views,etc.) for web based advertising piece generation tool. Documented database functionality, worked with programmers to ensure efficient interface between java code and database.
• Worked extensively with clients to design, implement, and revise websites. Analyzed business processes to determine customer and project needs, devised project plans. Used ASP, HTML, and VBScript to implement/revise websites.

4/96-4/00 Consultant/Business Analysis and Programming-

Performed project management, business and systems analysis, training, application development and integration, technical documentation, and technical support functions for a variety of clients including: Comdisco, Guardian Industries (3rd largest glass producer in world), and assorted small firms. Work highlights:

• Served as Co-Project Lead/MS Access application Analyst for international effort to implement and upgrade CMMS software application integral to plant operations. Scheduled workflow and personnel, set project timelines, organized tech support. Co-developed training program and wrote training documentation, performed end user training on four continents, served as international technical support resource .
• Performed needs/business analyses at multiple jobsites, based on finding developed user applications that performed such tasks as job costing, cost/benefit analyses, customer service phone center operations, direct mail generation, mortgage application processing, and lease accounting analysis. Implemented, trained, and wrote technical documentation for each.
• Served as on-site “technical resource” for Microsoft Access at an international computer equipment leasing company, providing training and technical support to end users across multiple departments.
• Resolved network problems, configured and installed servers, implemented software applications.

1/95-3/96 Program Coordinator/Logistics Analyst Hewlett-Confidential,MI

• Demonstrated/Sold, answered tech questions about Ford/HP CPD, a CD-ROM based system cataloging Ford\'s car and light truck parts at conference sites nationwide.
• Served as customer liaison for HP\'s "Hot Line" parts program, resolved customer engineer job site call conflicts.
• Managed National Customer survey program for Ford/HP Service Bay Diagnostics System, Administered/managed follow-up procedures through to resolution.
• Instituted and coordinated hard drive upgrade program for multi-state area.

1/94-11/94 Project Manager/Access DeveloperConfidential,Chicago, IL

• Developed, tested, implemented, trained and administered MS Access database used in data conversion project for Illinois utility company.
• Responsible for staffing, training and managing all on-site personnel for multiple projects, all of which were completed on or ahead of schedule, at or below budget.
• Served as on-site corporate liason to client, ensured client satisfaction, ultimately selling two additional projects to client.
• Implemented networks, served as system admin for project networks.
• Performed technical design for and managed archiving project of corporate minute documents.

8/93-12/93 PC and peripheral Sales- Confidential,Buffalo Grove, IL

• Sold PCs, printers, laptops, servers, etc.
• Served as team technical resource, wrote various “white papers” on emerging technology.

7/92-6/93 Sales Assistant/Inside Sales- Confidential,Chicago, IL

• Demonstrated Disaster Recovery planning software product at conventions nationwide.
• Performed cold calling and lead qualifying for Midwest and East regions of US, exceeding all call quotas on a regular basis.

7/90-3/92 Accounting Manager- Confidential,Washington, DC

• Responsible for payroll and all related tax filings. Responsible for A/R, A/P, month end G/L entries, bank reconciliations.
• Managed 2 person general accounting staff.

Technical Proficiencies:

Operating Systems
I have successfully installed and managed the following:
Windows NT Server/Workstation 3.x/4.x/2000/2003, Windows 95/98/XP/3.x, DOS, and others. I have architecture and implementation experience with the following Servers: Microsoft IIS, Active Directory, and SQL Server.

Programming
I have experience working with and designing web-based applications using Visual Basic, VBScript, JavaScript, and Velocity Script.
Other Applications
I have mastered many applications – including popular office applications like Microsoft Excel, Access and Word and I am highly proficient at learning new technology, both client/server and web.

Education and Certifications:

Bachelor of Science, Business Administration. Economics Minor

MCSE, MCDBA, MCT, CTT+ certifications.