Experienced results-oriented and versatile professional possessing diverse skills in Business Analysis Project Management and Application Development. Demonstrated ability to independently manage complex development projects throughout full life-cycle from requirements gathering and definition through development and implementation. Consistently delivers project outcomes on time and on budget that meet or exceed requirements.
MS Access Programming and Development
VBA / VB.NET
Ace / ADO / DAO / ODBC Data Connectivity
Expert MS Excel Modeling and Programming
Sharepoint Development / Customization
Sharepoint Designer / Workflows
SQL Server Development and SQL
- Successfully completed multiple application development initiatives working as a consultant a Procter and Gamble. Demonstrated ability to work independently throughout project lifecycles while achieving exceptional customer satisfaction. Key projects included
- FMAT Tracking and Reporting Desinged and developed a tracking and reporting system using a Sharepoint library as backend data storage and Excel user interface. List data is refreshed when the user interface is opened and custom reporting is generated by the user using a graphical query design form and ACE connectivity to query the list data.
- HSE Reporting Tool Uses a SQL Server database where stored procures are used to populate a summary table of Environmental data. An Excel workbook using ADO connectivity serves as the reporting interface.
- Flavors Fragrances Standards Tracking Designed and developed tracking and reporting system related to testing and qualification of thousands of flavors and fragrances used in manufacturing products. Application architecture consists of a Sharepoint list serving as the back-end database. An Access application linked to the Sharepoint list houses the front-end user interface. Through the front-end samples that are submitted by vendors are logged into the system and tracked through the qualification process. Reporting capabilities provide a real-time snapshot of sample status and identifies expiring materials so that new samples can be requested.
- Prototyping Solutions Project Tracking System The application uses a Sharepoint backend combined with an linked Access user interface to manage scheduling staffing supplies inventory tracking and chargeback of Prototyping projects.
- SKU and Spec Simplification Worked as Business Analyst for this corporate initiative with the stated object to reduce complexity within the company by identifying and eliminating out-dated or redundant SKU s and formula specifications. Identified sources for relevant data and then developed interfaces to extract monthly results and report progress against stated targets. My reporting became the standard measurement tool to communicate progress of the initiative.
Project Manager / Business Analyst Confidential
- Working as a independent consultant at Procter and Gamble I drove successful completion of multiple projects that were critical to the mission of the department in which I worked. Projects included
- Implementation Management Managed projects related to the implementation and qualification of Proficy software modules at overseas plants.
- Change Management Analysis Development Implementation and Training Managed a project to define departmental change management procedures and implement the work processes using Serena TeamTrack workflow management software. Performed application design and development using TeamTrack and perform training support and administrative functions.
- SharePoint Development and Support Managed a project and performed technical execution for migration of web sites from Lotus Notes to SharePoint. Performed an upgrade of SharePoint from WSS 2 to WSS 3. Trained users and provide ongoing support.
- PUMA Application Validation and Qualification Managed the initiative to test and qualify PUMA messaging and alerting applicaton for use with Proficy software. Once qualified I defined the acquisition and installation procedures for plants wishing to implement PUMA.
Application Developer Confidential
- Worked in consultation with Senior Partners Department Managers and Project Managers to design develop and maintain computer software applications enabling entry storage and reporting of operations and billing data. Served as point-of-contact for user community to provide training answer questions make enhancements and support all internal business systems.
- Increased security and integrity of mission-critical data improved performance of dependent applications and enhanced accessibility by developing the client-server architecture used for data storage and retrieval of operational data. Completed migration of database management system from MS Access to PostgreSQL DBMS.
- Increased managers effectiveness identifying needed skills and allocating resources to fulfill workload requirements through development of a project estimating system. Effort Estimator enables project managers to efficiently and accurately plan projects tasks and estimate the required effort and costs.
- Streamlined employees weekly time reporting effort with the development of a compay-wide Timecard application. They system links to a forecasting system to automatically pre-populate time records with project numbers and activity codes thereby freeing up more engineers time for billable work.
- Significantly improved management s ability to identify profitable accounts and better allocate resources by working with the company controller in developing a system to extract billing and receivables data from Peachtree Accounting software that is then combined with billable hours from the operations database.
Provided IT consulting project management and programming services to multinational corporate clientele. Successfully completed many projects with emphasis on workflow automation and analytical tool development using Microsoft application development software. Managed small to mid-scale projects through requirements gathering development of functional requirements physical application design programming and user acceptance testing.