Alan M. Anderson
***** ******** *** *****, ******** 68164 Phone:402-***-**** e-mail: ***********@***.***
Summary:
A highly skilled professional with experience on enterprise level planning, development, continuous improvement, strategic implementation, integration and execution of hardware and software needs. Committed to personal development and with the ability to learn quickly and adapt to business needs/priorities as needed. I have worked extensively with many large corporations doing ETL work as well as data manipulation and processing. I am also well versed in Assistive Technologies for Visually Impaired people utilizing screen reading programs such as Jaws and Window Eyes, Braille translation software such as Duxbury, and the standards and requirements for making applications accessible utilizing such technologies.
Technologies:
VB.NET, C#.net, Visual Basic, Cold Fusion, SQL, SSRS, Crystal Reports, JavaScript, CSS, HTML, XHTML, XML, ETL, ASP, PHP, Java, MS Visual C++, C, dBase, Clipper, and a host of others.
Software and Operating Systems include: Windows (32 and 64 bit), DOS, Novell Netware, OS/2, UNIX, AS/400 PC support
Databases include: Microsoft SQL, Oracle, Informix, MySQL, OS/400 DB2, MS Access, xBase
Other: Network Management (NT and Novel), multiple word processors, spreadsheets, communications programs, scripting tools, FTP, etc.
Work Experience
Reed & Associates, Omaha, NE (8/2009-1/2010)
IT Manager - Maintains database dictionaries, overall monitoring of standards and procedures, and integration of systems through database design. Managed archival, retrieval and retention schedules for data storage. Designs, implements and maintains systems databases and structures, on multiple platforms, with respect to job execution, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, guidelines, and statistical methods. Supported data access to databases by reporting tools.
Blue Cross Blue Shield, Omaha, NE (4/2008 – 1/2009) 402-***-****)
• Create reports in MS SQL Reporting Services 2005, Deploy report models using Report Builder
• Create Stored Procedures and Functions using SQL and T-SQL 2000, and 2005
• Detailed data analysis and data validation
• Documented, tested, and initiated ETL procedures
• Setup and debug ODBC Connections
• Worked with SSIS
• Worked with Data warehouse systems as well as transaction systems.
FirstComp, Omaha, NE (11/07 – 4/2008) 888-***-****)
• Programmer in Cold Fusion, T-SQL, and SQL Reporting Services.
• Create reports in MS SQL Reporting Services 2005, Deploy report models using Report Builder
• Create Stored Procedures and Functions in Cold Fusion CFC’s and SQL and T-SQL 2000, and 2005
• Create data views and setup data triggers in T-SQL 2005
• Data analysis and validation
• Setup and debug ODBC Connections
• Worked with SSIS
Werner Enterprises, Omaha, NE (1988 - 2007) 402-***-****)
Project Manager (1997- 2007)
Research, plan and manage and/or code development of new systems to automate manual routines to improve accuracy and efficiency utilizing client/serve and thin client web technology.
• Primary developer on Contract Tracking application.
o Utilizes Cold Fusion, FTP, SQL, and parsing of text files
• E-Commerce developer for web store.
• Created ETL procedures for multiple projects utilizing daily, weekly, and quarterly transactions
• Worked with SSIS
• Worked with Data warehouse systems as well as transaction systems.
• Managed projects through their Software Development Life Cycle
• Project Manager / Primary developer on Point of Sale application.
o Utilizes VB6, SQL, Cold Fusion, stored procedure calls with AS/400, interfacing with barcode readers, receipt printers, pole displays, magnetic card readers.
• Primary developer Fuel Island Authorization application.
o Utilizes VB6, SQL, Cold Fusion, serial over IP communication, Stored Procedure Calls with AS/400, interfacing with Gasboy fuel island controllers.
• Primary developer of collecting data from the telephone switch and converting it to a database for reports.
o Utilizes C, Cold Fusion, SQL
Manager of Logistics Systems (1995-1997)
Developed, purchased, and integrated hardware and software solutions for transportation logistics decision support systems. Worked closely with third party software vendors towards improvements and modifications in their systems with the goal of solving transportation problems. Member ‘Council of Logistics Management’ and ‘Society of Logistics Engineers’.
• Primary developer involved in the integration of external customer data into custom systems used for planning, optimizing, and deploying of orders.
• Customer data analysis for integration, create ETL procedures, and output data for ETL procedures and reporting purposes.
Project Manager. (1993-1995)
Research new technologies develop and implement plans for applicable tools. Purchasing manager for PC hardware and software.
Personal Computer Specialist and Programmer. (1988-1993)
Purchasing manager for PC hardware and software Managed Help Desk and assisted users with Microsoft Office Suite, Word Perfect, Lotus 1-2-3, Symphony, Windows, and a multitude of miscellaneous software issues. Wrote custom in-house software using Microsoft Visual Basic, Microsoft C, Clipper, Dbase, and some Assembler, as well IBM AS/400 PC support installation and support.
Radio Shack, Bellevue, NE. (1983 - 1988)
Computer Department Manager: Responsible for scheduling of staff, purchasing, inventory, and general daily accounting functions. Assisted people with software and hardware problems, and designing solutions. Twice recognized as the 2nd best store in the nation for sales during a month.
Anderson Camera, Council Bluffs, IA. (1980 - 1983)
Retail photo store manager: managing office staff, budget, scheduling, and purchasing. Created an Accounts Receivable Program, Retail Inventory Management, General Ledger, and a Finishing Lab Billing package designed specifically for the photo industry using TRS-80 Basic and random order records.
Houpt's Music, Sioux City, IA. (1974 - 1979)
Taught private music lessons and music theory. Served as a technician for musical instruments repairs.
EDUCATION
2006 American InterContinental University – Hoffman Estates, IL – Bachelor of Information Technology, Programming – (Summa Cum Laude)
1996 Executrain Windows NT Administration; Microsoft Visual Basic
1995 Metro Community College -- Advanced C Programming
1994 Service & Administrative Institute. Advanced Leader and Facilitator Training for Process Improvement teams.
1991 DATA-TECH Institute. LAN Management and support.
1990 Novell LAN Administration.
1988-1991 IBM. Miscellaneous personal computer and AS/400 classes.
1988-1989 Gateway Electronics Institute, Omaha, Associates Computer Programming Diploma. Course work included Basic, Dbase III and III+, Assembly Language, COBOL, Microsoft C, MS/DOS, programming as well as program maintenance.
1977-1979 University of South Dakota at Vermillion, South Dakota. Course work included Education, Psychology, and Music Education.
1974-1976 Morningside College, Sioux City, Iowa. Course work included Music Education, History, Physics, and Psychology.
PROFESSIONAL ORGANIZATIONS
Ancient Free and Accepted Masons, 2002-current
Nebraska Foundation for Visually Impaired Children, 1994 – Current
ATM Member of Toastmasters International, 1990- 2002
Member of Midwest Information System Professionals, 1993-2000
Council of Logistics Managers (CLM), 1995-1997
References available upon request