Business Analyst / VBA Developer Resume

SUMMARY:

Business Analyst with 8 years experience developing MS Access applications to provide management with the refined information needed to make critical business decisions.
I m seeking opportunities to apply my experience in a fast - paced, competitive market providing highly effective data analysis. I m experienced in managing processes and obtaining results through supervising the entire life cycle of application development with Six Sigma principles. I provide positive leadership and technical direction in the design and deployment of enterprise-wide solutions that increase productivity and reduce cost.

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst / VBA Developer

Responsibilities:

Supervise the daily operations and maintenance of Databases, ERP software and numerous MS Access applications for Management, Estimating/Sales, A/P, A/R, Inventory and Fabrication.
Published and updated step-by-step instructional documents for all applications and order processing procedures. Distribute documents via bound hardcopy or web downloads to personnel internationally. Developed User and Administrator manuals.
Responsible for developing reports to assist management in identifying market trends, monitoring orders in the pipe-line, close rate success, quoting / sales conversion and financial documentation (Revenue, Expenses, Margins, Commissions). Weekly, Monthly, Annually and ad-hoc reports were provided in many formats to be usable by the various recipients.
Developed VBA resources to increase communication between personnel in and out of the office by integrating email automation and providing secure Internet access to internal data from anywhere in the world and providing standard report functions to be accessed at the push-of-a-button.
Analyzed total order handling process and documented with Visio flowchart to locate inefficiencies and developed solutions to eliminate un-necessary effort by applying technology resources or re-structuring the process.
Implemented and performed data validation and filtering to prevent and remove duplicate data.
Gathered data from many sources to compile into business decision reports for management. Compiled data from multiple database systems into unified reports. ODBC, SQL Data Transfer Services, (dBase) DBF’s, Filemaker.
Automated many critical business reports to be distributed regularly via email and provide delivery and read confirmation for accountability.
Centralized distributed data from satellite locations into secure data warehouse to increase reporting capabilities and to ensure data was being backed up on a regular schedule.
Initiated and expedited the development of the Order Acknowledgement Source Document to eliminate redundant entries, reduce errors, and increase communication.
Programmed Sales Commission Report to eliminate confusion on payables from partial shipments.
Managed total system upgrade of ERP Software from IMPACT version 3.2 CISAM to Syspro 6.0 issue 10 SQL. Led the selection and purchasing of hardware for Data and Application Servers. Supervised data migration contractors.
Performed on the Web Development Team which constructed the web based ePricing Application.
Expert Microsoft Office support. Access, Excel, Visio, PowerPoint, Word, Publisher, Frontpage. Specialize in VBA, Excel Functions and Charting.
Visual Basic coding for application modules and functions. Proficient in SQL queries and data handling.

Software Testing

Responsibilities:

Performed QA and regression testing on software, both proprietary and third-party, for compatibility, usability and defects. Developed written test cases and automated test scripts with Winrunner

Leadership and

Responsibilities:

Conducted Application Sessions with approximately 110 employees and representatives on and off campus via GoToMeeting.

Confidential

Software Tester

Responsibilities:

Installed platform dependent software builds and performed regression testing via manual test cases and automated Winrunner scripts.

Confidential

Warehouse/Service Manager

Responsibilities:

Developed Inventory Management System to optimize product management and Just-In-Time inventory.

Confidential

Construction Estimator

Responsibilities:

Evaluated supplier bids to compile competitive proposals to General Contractors and Architects. Developed Budget Alternates to provide more competitive bids.

Confidential

Estimator

Responsibilities:

Calculated structural loads and material requirements and costs for sub-contractors to bid. Published project specific submittal packages to win project contracts.

Confidential

Air Traffic Control Specialist

Responsibilities:

Instructed Officer and Enlisted ATC Trainees in Tower and RADAR duties and procedures.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship