Business Analyst, SAS Programmer
Resume:
Ted C. Wagner
St. Louis, MO 63005
636-***-**** Home
*********@*********.***
SUMMARY OF QUALIFICATIONS
Data Mining Professional with extensive experience as a statistical and econometric analyst. Seven years experience in business analysis and forecasting using SAS on a UNIX platform and understanding the methods for getting data into SAS. Highly motivated and focused leader with excellent capability to communicate analytic business solutions to all levels of management and customers.
TECHNICAL SKILLS
Operating Systems: UNIX Solaris, DB2 Connect,
Development Tools: SAS, SPSS, Answer Tree, SQL, Excel, Word
Other: Microsoft Office, Outlook, Power Point, Access
PROFESSIONAL EXPERIENCE
Maryville University Fall 2007 – present
Adjunct Faculty
• Taught a graduate Economics class in the MBA program called “Business Economics” and an undergraduate Microeconomics class again this Spring semester.
CitiGroup August 2007 -- December 2007
Sr. Risk Analyst – Citi Home Equity (CHE)
• Worked with the 13 SAS program monthly Citi Home Equity status report until I was confident running and making changes to it. This program was used by senior management to decide which brokers and retail sources for home equity loans and lines of credit were retained.
• Produced a ‘gap report’ that showed the differences in the way Citi and a competitor reported their home equity performance.
Webster University Fall 2006 – Spring 2007
Adjunct Faculty
• Taught a graduate Economics class in the MBA program called “Current Economic Analysis”.
MasterCard International February 2005 – June 2005
Statistical Analyst---MasterCard Advisors
The Data Innovations Group at MasterCard follows the description in the Cross Industry Standard Process for Data Mining (CRISP-DM). They perform their analysis for external customers and provide their clients with analysis of market trends and customer segment profiles to support their acquisition, development and retention objectives. Worked at MasterCard as an employee of Ajilon consulting.
• Using SAS on a UNIX platform, I have been responsible for three of these projects. Used the Cluster, Rank and Means procedures predominantly to break the data history into purchasing clusters, and then further subdivisions based upon their activity and spending. The resulting output is very large and is transferred to Excel workbooks and spreadsheets for additional analysis and delivery to the customer.
Enterprise Rent-A-Car April 1997 -- January 2003
Analytical Specialist II—Data Mining Department
The Data Mining Department consisted of the Data Warehouse, Business Analysis, Decision Support and Analytical Methods. The Data Warehouse supplied the data and the complexity of the request and the level of the requester determined which of the other groups performed the analysis. Analytical Methods handled the most complicated requests from the highest level executives.
• Saved over $20 million with the implementation of SAS on rent forecasting programs. Used as the foundation of the annual purchase plan of over 400,000 vehicles.
• Created a SAS program that rates the overall reliability of the forecasting program for accuracy and outliers. Used to select forecasts which were reliable enough to show to the end users.
• Improved forecasting results by using SPSS and Answer Tree for smaller data sets to improve the forecasting results by determining the most significant independent variables to use in a model statement.
Ted C. Wagner
1440 Carriage Crossing Lane
St. Louis, MO 63005
636-***-**** Home
*********@*********.***
Analytical Specialist I—Data Mining Department
• Reduced the UK advertising expenses over 50% by creating PC-based SAS programs that used Marketing and Advanced Technologies data sets.
• Tested a PC application using wavelets in MATLAB to forecast the number of cars on rent. The results were similar but the extra time required was not a cost effective use of resources.
Business Analyst—Data Mining Department
• Designed the first Information Request page in MS Access. Streamlined the process and reduced the utilization of resources by eliminating the duplications of effort.
• Analyzed incoming requests prior to processing by Decision Support team to expedite the Information Request process.
• Downloaded census data and merged it with our car sales to examine the effect of changes in disposable income on car sales.
• Wrote both UNIX and PC based SAS programs for the Department Manager.
McDonnell Douglas Corporation February 1980 – April 1997
Project Engineer--Configuration and Data Management
Configuration and Data Management was responsible for the completion and submittal of all Engineering Change Proposals to the contract with the customer, and for the preparation, review and submittal of all technical documents called out in the contract.
• Responsible for T-1A and AV8-B training systems data management activity.
• Managed the production of two subcontractors technical documents.
• Managed the internal creation, review and delivery to the customer of all technical documents.
• Prepared and submitted engineering change proposals.
Senior Engineer--Configuration and Data Management
• Attained a 100% on time delivery to the customer of over 400 technical documents per year requiring ongoing coordination with the subcontractors and the customer.
Engineer--Configuration and Data Management
• Configuration and Data Manager for the A6-E SWIP aircrew trainer program. Managed the people within our company responsible for the writing and delivery of all technical documents related to the production of the A6-E SWIP aircrew trainer program.
• Interfaced with customers and coordinated with major subcontractors.
Engineer--Effectiveness Engineering
• Maintained closed-loop failure analysis system.
• Collected, processed and reported test data for reliability analysis.
Buyer--Procurement
• Responsible for all major procurements of raw material and wire and cable by the Astronautics Company
• Received the award for the greatest amount of business placed with small and disadvantaged businesses every time that I was eligible.
EDUCATION
University of Missouri, St. Louis--Masters degree in Economics - 1997
Phi Kappa Phi Honor Society
Omicron Delta Epsilon - International Honor Society In Economics
Bachelors of Science degree in Business Administration - 1979
Contact this candidate