Objective



To contribute to the success of an organization seeking an applications professional by utilizing my demonstrated hands on leadership skills as a business/software analyst.


Employment

April, 2009 -  November, 2009
QA Analyst

Developed test script scenarios from existing Supply Chain Management tool. Demand Solutions is converting existing Forecast Management and Requirements Planning legacy to Web based tool. Automated test scripts through a product called TestComplete Vendor AutomatedQA. Created batch process to run test scripts.

Evaluating new web based tool used for Supply Chain management. Gather history results to convert to DMI database to obtain a comprehensive understanding of existing systems and procedures. Put results into equations to predict and forecast sales. Forecast results are used to project inventory planning for customer support and sales. Requirements planning is overlooked and perfected by safety stock time and usage along with overstock transfer calculations.

September, 2008 -  January, 2009
Senior Systems Analyst

Integrated Virtual Environment IVE tool developer. Liferay based Modeling, Development and Analysis with built in cost control tool for Next Generation Aircraft. Strategic Border Initiative is being developed with for front end of business. Process includes developing and integrating math and physics models using Matlab s Mathworks.

Charter Communications - Des Peres, MO 6 month Contract Position

March, 2008 -  August, 2008
Data Specialist

Learned tools to create telephony billing templates in 2 days. Created templates to help team members with backlog in 2 weeks. Learned data base table and field names in record time to create status report for management. Solved issue with backlog of new user ID and password resets for call centers around the world multi-tasking with creating telephony billing templates.

Responsible for keying-in of job ticket issues for cable, high speed data and telephony billing systems using RUMBA mainframe in the ACRS database. Duties include creating templates for future releases using BackOffice. Proficient in writing queries and reports on demand for relational databases. Writing macros from Excel using Visual Basic to transfer data from spreadsheets to BackOffice templates. Microsoft desktop products Access, Word, Excel.

Anheuser-Busch Inc - St.Louis, MO Contract position

September, 2007 -  February, 2008
Programmer/Web Application Developer

Worked with Anheuser-Busch Inc in the Utilities Department developing front end web application for analyzing Utility processes. Development was done using a
Oracle back end, Visual Basic Middle Tier and an ASP front end.

Developed a system to take raw data from sensory inputs on the utility equipment and store into a database. Equations were used to process raw data on electrical, gas water and other utility system equipment. Engineers needed to a web based front end to end cumbersome way of adding equations to database. An ASP front end was created to shorten process by hours and eliminate operator errors. Data was put into equations to enable Engineers to derive dot charts and graphs analyze peaks and valleys of usage.

Upon implementation a compressed air leak was discovered in the Columbus Ohio bottling plant. The leak was located and fixed saving the Columbus Ohio bottling company $300000.

February, 2007 -  September, 2007
Programmer/ Web application developer

Took the place of 3 displaced workers coming up to speed in 3 weeks and developing 7 applications. These new applications help make a sale worth $500000 in total revenue over 3 years.
Developed applications in an Enterprise driven, Internet Controlled, Point of Sale business applications Application development using ASP, HTML, VBScript and Javascript. Analyzed business requirements to develop Employee Scheduling, Inventory Control and Sales Reports. Microsoft SQL server database and SQL extractions for touch screen cash registers for point of sale for sandwich and fast food restaurants.

December, 2005 -  May, 2006
Windows Server System Administrator

Developed tool for employees to be able to order parts in an efficient manor, create revenue projections and inform Sales department of up to the minute of available products. This saved the company untold savings.

Responsible for gathering business requirements from the Sales department, Inventory department and Accounting department to define desired field names data mapping needed to make tools communicate. Using ODBC dumped out fields from Sales, Inventory and Accounting in to Microsoft Access database. From Access I wrote Sales reports in SQL to inform Sales department of up to the minute number of products available and to decrement Inventory manager of complete product and parts after product sold.

Software tools include working with Microsoft Access, QuickBooks, Goldmine Sales Manager, Alchemy Network Asset Manager and Fishbowl Inventory manager.

Performed Systems Administration maintenance on Windows 2000 Server. This includes creating and managing backups of workstations and servers. Installing Skype, working with NovaNet, AD Active directory, DNS Domain Name Server and DHCP Dynamic Host Configuration Protocol.

February, 2005 -  December, 2005
Real Estate Agent

Working as a real estate for The Kelsey Group, Realtors. Assisting clients in buying and selling residential homes.

November, 2004 -  February, 2005
Delphi developer

Talk to users and other developers to define requirements to data needed to develop new products. Gathered requirements to define data needed to develop tools for creating, reading and appending to local Paradox tables.

Code was written in Delphi using Borland Database Engine and registry Editor to create database path and name. Code generated new VCL Components which were added to Object Repository and the Visual Component Library. Experience includes working with IDE debugger and creating DLL packages.

2004 -  2004
Senior Programmer Analyst

Communicating with user community and other programmers to define data mapping from an Oracle legacy system to a Microsoft SQL Server system. Code was cleansed of bad data before data mapping by SQL scripts.
Duties included analyzing legacy business requirements to new business requirements. Process of scrubbing or cleaning data was written in Oracle PL/SQL using TOAD development tool. Used Microsoft s DTS tool to transfer data from Oracle database to SQL Server database.

February, 2001 -  January, 2003
Senior Programmer Analyst

Restructured their Traveler Detail program for performance enhancement. Developed a system to speed up stored procedures. Major money making application went from 4 hour run time to 20 minutes for a whole years worth of data. Shortened run time saved company in the millions of dollars. New revenues increased because applications would now work and work in an acceptable time frame.

Created a data scrubbing/cleansing application called TIDE for European Consortium. These involved normalizing data as per customer specifications and data mapping fields to new tables.

Developed software procedures document. Development was done using Sybase Transact SQL on Embarcadero Rapid SQL tool.

March, 1999 -  February, 2001
Senior Programmer Analyst

Education

Skills


Business Analysis Innovative Adaptable Troubleshooting UNIX Oracle PL/SQL Problem Solving Web Development Team Player Flexibility Analytical Access Demand Management Clayton, MO 7 month Contract Position


Miscellaneous

Gathered and analyzed business specifications from user inputs to create health insurance applications, Explanation of Benefit s EOB s, Remittances, Checks and Capitation Remittances.
Coded and maintained reports and data extracts in Transact SQL using Sybase relational database. Performed automated data extract calls using UNIX executable shell script. Data was extracted from Erisco Facets tables and run on a UNIX autosys environment.
Used UNIX to open SQL sessions to call Sybase stored procedures.
TOAD, PVSC,
Embarcadero, FTP