Scott Weishaar Email & Phone Number

Iowa, United States

Iowa City, Iowa Area

Writing MS SQL Server T-SQL stored procedures and scripts.Creating VBA scripts to automate Excel reports.Editing/proof reading functional specification documents, proposals, and training materials.Performing GAP analysis between project documents (functional specifications and functional test plans, RFP's and proposals).Business Consultations

Buffalo Grove, IL

Service Delivery. Contracted to own IT Projects and serve as a technical lead on projects when needed. Own sole accountability for successful completion of multiple large projects, lead application technology design & implementation decisions for projects, Upgrade and support Workforce Management, Email Management, Predictive Call Routing, Screen Capture.

Greater Chicago Area

Working in a SCRUM feature team on a project to build a new horizontal collateral management system to replace the many vertical legacy systems serving different LOB's resulting in disparate functionality and conflicting data. System based on Java, Oracle, using Eclipse, Spring, JS, and much more while following leading edge architectural design principles.

Itasca, IL

Commercial Software Development - Auto Repair POS & Inventory, Data Warehouse from POS system data providing capabilities sold in SAAS model. Worked on data warehouse system capabilities including both reporting and functional such as: Dashboard Reports, Operational Reports, POS system Support services (disaster recovery, one time configuration), CarFax.

Bloomington/Normal, Illinois Area

Implementation Test Analyst (ITA) Team Lead – Testing of implementation of new software and the changes in the system configuration required to support them. Responsible to approve all changes based on tests showing implementation will not interfere with production availability or cause any data anomalies. Led team of 5 ITA’s training on how to execute.

Bolingbrook, IL

Independant consultant attempting to launch an independant consultancy. Provided consulting services to small to mid sized businesses:- Performing IT strategy assessments- PC network service and expansion- Application server administration for small business accounting packages- DBA services for MS SqlServer- Industry specific application installation.

Greater Chicago Area

Project and Client Manager responsible for leading an ERP Assessment for a top 10 legal firm assessing high level ERP packages compared to group of best in class functional applications (SaaS Accounting, hosted applications including accounting packages) to assess what the best approach was when compared with the approach of the top 20 world law firms..

Greater Chicago Area

• PM/BA working on web portal based on ACORD standard for one of world’s largest insurance Co.’s to integrate internal systems to efficiently work together using J2EE framework.
• Lead Data Analyst working on reverse engineering of legacy auto claims processing systems interface with ERP Accounting Package to develop functional specifications for new.NET/C# based interface to accounting.
• Created a report inventory and process assessment at a leading international bank tracing down root cause of value mismatches between systems.
• Assessment of requirements to combine departments to optimize productivity, reducing overall headcount for a leading international bank.
• Documented definition of base metrics by reverse engineering source code computations from the enterprise data warehouse for leading Cellular Phone Company, developing a ta repository application to warehouse and serve.
• Provided MS Access based tool to report on user and data usage metrics for enterprise data marts, monitoring database activity by capturing SQL and user information and parsing SQL using VBA into details to build.

Oak Brook Terrace, IL

• Program Manager in charge of support and change management for operational web application.
• Project Manager and Business Systems Analyst (including creation of business and functional requirements documents, architectural design, process definitions, and develop code) for applications development projects.
• New data warehouse and Business Objects BI reporting and analytical environment.
• Managed project to rewrite the settlement sub-application and re-engineer the corresponding process to automate creation of settlement statements and corresponding invoices and/or payments.
• 3 projects upgrading from NT network to Active directory and corresponding upgrade of Exchange 5.5 to Exchange 2000
• Project to upgrade web application to automate user management through web front end using integration with Active Directory. Lead Architect and Systems Business Analyst eliminating all user management manual processes.

Greater Chicago Area

• IT Department Manager for Client Company, managing IT organization of 12 employees.
• Lead architect performing architectural analysis and design of new system being written for leading Cellular Phone Company.
• Team Leader and Architect for team of 6 responsible for order fulfillment sub-system of a web storefront application created for a leading national pharmaceutical chain.
• PM, Team Leader and Architect to re-write two legacy commercial software applications.
• Team Leader and System Architect designing and implementing a data warehouse created using data from a new ERP implementation. Role responsibilities included creation of DSS and EIS applications and foundation class.
• Team Leader and Architect responsible for a gross profit system to track financial performance to plan by week and fiscal periods. Actual data extracted from Lawson accounting.

Greater Chicago Area

• Created computer publishing applications allowing clients to maintain their data to create multiple forms of: print, digital imaging, CD distribution, SGML,and HTML (web).
• Applications Analyst responsible for development and support of applications on MVS and VMS mainframes, VAX, UNIX (Sun Solaris, HP, and AIX), and windows platforms programming in PL1, CA-DATACOMM, FoxPro, C, VB.
• Promoted 3 times in 5 years.

Greater Detroit Area

• Programmer Maintaining General Motors CAD/CAM system.
• Fixed bug 3 year old bug that 3 PHD’s in applied math fail to solve resulting in promotion.
• Promoted 4 times in 5 years.

Ms, Computer Science, 4.0/4.0

Activities and Societies: Member of Depaul Chapter of Upsilon Pi EpsilonGraduated with distinction honors for straight A average.

Bachelor Of Science (Bs), Industrial Technology Computer Applications, 3.7 Of 4.0

Activities and Societies: (SME) Society of Manufacturing Engineers. 18 month Internship at Firestone Tire Corporation writing programs to.