Sales Manager
Resume:
Daniel J. Fleming
*******.*******@*****.***
Education
Parks College of Saint Louis University - Bachelor of Science in Avionics Engineering
Finished Course Work for:
.NET Framework 3.5
ADO.NET
ASP.NET using Visual Basic and C#
Professional Summary
Since graduating from Parks College1986 I worked writing software through the full software cycle for aircraft
systems for 13 years, an IT database SQL application developer, Business/Data Analyst and QA tester for 13 years,.
Key Skills
• Business Analyst
• Application Developer
• Data Analysis
• QA Analyst
• Relational Databases Sybase/Oracle/Microsoft PL/SQL/Access/Business Objects
• Web Development Classic ASP,VBA
• Avionics Engineer C/UNIX FORTRAN
• Troubleshooting Problem Solving Analytical
• Innovative Adaptable Team Player
• Testing Manual and Automated
Technical Expertise
• Oracle PL/SQL, Sybase PL/SQL, Microsoft SQL, Access, VBA, Business Objects
• C, C#, EDI, UNIX
• VAX/VMS, FORTRAN, ADA
• WEB Development
• ASP, HTML, XML, VBScript, JavaScript, Visual Basic 6.0, VBA
• TOAD, PVSC, Embarcadero, FTP
Professional Experience
Yellow Pages St. Louis MO (6 month contract) Sept 2013 –
Mar 2014
Business Analyst / Programmer /Administrative Assistant / QA Tester
• Developing new application using Access SQL and VBA for Sales Commission payment plan.
• QA Testing on a unit level and in Production using Access SQL.
• Developing Ad Hoc reports in Business Objects for upper management Report Cards.
• Participating in Administrative tasks to maintain database data integrity.
• Developing more user friendly Agency Detail reports in Access.
LMS Logistics St. Louis MO (3 month contract) May 2012 –
July 2013
Business Analyst / QA Tester
• Gathering and translating business requirements
• Analyzed and tested a new Freight Pay Invoicing software application.
• Analyzing and converted new data to migrate to new software.
• Performed SQL queries to test results.
• Acting as a liaison between Business Stake Holders and Technical Teams
Nextgen St. Louis MO (3 month contract) Oct 2011 – Jan 2012
Business Analyst / QA Tester
• Gathered and translated business documents
• Analyzed requirements documents to update Medicare Provider application from HIPAA 4010 to 5010 format.
• Changed 837 Professional, 835 Remittance and 270/271 Planned Care of Service to fit EDI format.
• Updated code from ICD-9 medical billing codes to ICD-10 medical billing codes.
• C#, XML, EDI, Debugging and Testing
SLI Global Solutions Clayton, MO (3 month Contract Position) Oct 2010 –
Jan 2011
Business Analyst/ QA Analyst
• Gathered requirements to develop test cases for testing Wells Fargo Financial application.
• Test cases developed manually in Excel.
• Results were verified using Microsoft SQL on a Microsoft database.
• Test cases were run manually and results were recorded into a Microsoft Excel tool, which automatically tracked metrics
for pass/fail percentages and performance of ISI Grid processes.
Demand Management – Clayton, MO (7 month Contract Position) Apr 2009 - Nov 2009
QA Analyst
• Developed manual test scripts to test new system development on existing Supply Chain Management tool.
• Demand Solutions is converting existing Forecast Management and Requirements Planning legacy code of Excel
Spreadsheets and csv flat files to a C# Web tool.
• Created test code manually and then automated test code 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.
Boeing Aerospace Sept 2008 – Jan 2009
Sr. Systems Analyst
• Defined requirements to test new Strategic Border Initiative (SBINet)
• Integrated Virtual Environment (IVE) tool developed in Liferay.
• Wrote test scripts for new Development and Analysis tool with built in cost control tool for Next Generation Aircraft.
• Process includes gathering requirements for developing integrating math and physics models using Matlab's Mathworks.
• Manually executed test scripts and documented results into a Powerpoint presentation.
Charter Communications - Des Peres, MO (6 month Contract Position) Mar 2008 –
Aug 2008
Data Specialist/ Business Analyst
• Gathered business requirements to create new telephony billing templates.
• Created templates and wrote test scripts to help team members test database table and field names.
• Manually executed test scripts to create status reports 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 also 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 (VBA) to transfer data from spreadsheets to BackOffice templates. Used
Microsoft desktop products Access, Word and Excel.
Anheuser-Busch Inc. - St. Louis, MO (Contract position) Sept 2007 –
Feb 2008
Programmer/Web Application Developer
• Gathered requirements to create new front-end web application for Analyzing Utility processes.
• Development was done using a Oracle back end, Visual Basic Middle Tier and a Classic ASP front end.
• Developed test scripts and scenarios to test equations used for analyzing Utility processes.
• Manually ran test scripts and documented results
• 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 manually adding equations to database. An ASP front end was created to shorten
process by hours and eliminate operator errors. Data was then 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 $300,000.
InfoSoftPOS – Fenton, MO Feb 2007 – Sep 2007
Programmer/ Web application developer
• Analyzed business requirements to develop new applications Employee Scheduling, Inventory Control and Sales Reports.
• Developed test scenarios to test various applications.
• Applications were developed in an Enterprise driven, Internet Controlled, Point of Sale business applications – using
Microsoft Enterprise Manager, ASP, HTML, VBScript and Javascript.
• Microsoft SQL server database and SQL extractions for touch screen cash registers for point of sale for sandwich and fast
food restaurants.
• 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 $500,000 in total revenue over 3 years.
Masterclock – St. Charles, MO Dec 2005 –
May 2006
IT application developer, PC repair, Windows Server Sys Admin
• Responsible for gathering business requirements from the Sales department, Inventory department and Accounting
department to developed a 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.
• Created tables and defined 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).
The Kelsey Group, Realtors - Chesterfield, MO Feb2005 –
Dec 2005
Real Estate Agent
• Working as a real estate for The Kelsey Group, Realtors.
• Assisting clients in buying and selling residential homes.
AFS Message-Link - St. Peters, MO Nov 2004 – Mar 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.
Mercy Health Plan - St. Louis, MO May 14 2004 – July 30 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.
Maritz Travel Company - St. Louis, MO Feb 2001 –
Jan 2003
Senior Programmer Analyst
• Responsible for gathering business requirements to create a new accounting program that keeps track of traveler expenses.
Discovered flaw in business rules engine that was putting multiple rows into database.
• Developed algorithm for trapping multiple rows.
• Developed a system to speed up stored procedures and added indexes for performance enhancement. Major money making
application went from 4 hour run time to 20 minutes for 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.
• Gather business requirements from scratch to create 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 in a
Data Warehousing effort.
• Technical writing skills use to developed software procedures document.
• Development was done using Sybase Transact SQL on Embarcadero Rapid SQL tool.
Alliance Blue Cross Blue Shield -St. Louis, MO Mar 1999 – Feb
2001
Senior Programmer Analyst
• Gathered and analyzed business specifications from user inputs to create health insurance applications including
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.
Contact this candidate