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, Performance Management applications used to support Call Center infrastructure and Service Agent management software. Lead Projects serving as POC for escalation to senior management and identification of issues that will inhibit project success. Liaison between project team, Stakeholders, and Senior IT Management raising issues for resolution that stand in the way of project execution and completion.

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 on an experienced project team. New to SCRUM, team was given latitude to practice process adaptation per sprint. Responsibilities included creation and implementation of the data model and test data, building model to meet new corporate architectural standards, Java development (Spring), IMPL message definition, UAT showcase test plan creation/execution and the standard SCRUM sprint planning (project & sprint backlog refinement a.k.a. requirements).

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 reporting, accounting interface, marketing support & more. Filled wide set of roles as necessary to get job done. Worked with a diverse set of technologies for both proof of concept and production delivery work which including VS 2008/2010, C#/.NET 3.5/4.0, EXT JS/JavaScript, HTML (5), MS SQLServer 2008, MongoDB, VB6, Sencha Architect, EXT.NET, and more (web technologies) in a Windows environment. Role includes all analytic, design, and development (SDLC) roles involved in custom software development. Role reported into corporate executives, company was purchased and relocated to Florida.

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 wide variety of tests, create, backup, restore, and reset test data to pre-test state on DB2 database.Systems/Test Analyst working on testing product for proprietary software framework supporting the IAA (Insurance Application Architecture) model standard producing insurance and banking applications for agents using web and mobile platforms (over 4600 models to support SF product line at time of departure). Responsible for headless (XML driven) and J2EE/Java based Test-ware application use and support. Project Test Lead for 6 projects and Implementation Test Lead for entire division supporting web based policy application site models (4600+ above).Project data lead for 3 projects on program to create an n-tier OLTP enterprise claims processing system to replace legacy system. Responsible for all data analysis to enable leading project teams in developing J2EE data access objects and SQL for data access, strategic direction for data access, and training support for team members to assist with efficient use of data model, data access, and integration with corporate data warehouse.Roles held in parallel with additional responsibilities in support of data management, warehousing, and movement (ETL) processes.

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, support, and eductions for vendor solutions - Licensing compliance assessments - Sub Contractor: performed analytic, system design, and C#/.NET development work.Strength of economy did not support a start-up consulting business resulting in return to full time employment.

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. Responsible for project management, client presentations, and working with team doing functional analysis of business requirements as compared to a functional analysis of each of the ERP packages and best of bread applications being used by the top 20 law firms. Required working with the account executive using contacts at each of the top 20 legal firms getting responses from 18 of the CEO and CFO’s providing details of their approach and the effectiveness of each.

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 component for a new auto claims processing system being written for one of largest insurance companies. Agile like SDLC working side by side with SME and developer (when not doing work myself).• 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 analytical information.• 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 reports.

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 delivered on time/budget for following 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 and reduction of 4 FTE user administrators to .25 PTE.• Business Systems Analyst responsible for delivering:• Business and functional requirements definition, architectural and screen designs (wireframes) for initial development of customer contract, customer profile, and operational reporting infrastructure for new operational system. • Functional Requirements definition and code for rewrite of middleware system communicating financial information from operational system to Great Plains. Creation of DB tables, triggers, and stored procedures to post transactions between systems.• Requirements definition (business and functional) and architectural design of operational systems customer contracts, customer profile, operational workflow.• Bench Manager responsible for bench project management, career development, mentoring, and placement of personnel on bench to client projects.• Authored 6 proposals independently, 2 in team winning projects for 3 of 8.

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 libraries for rest of team to use data warehouse data.• 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.• Project Manager for project to implement packaged software systems to track shipments and rail routing of raw materials for process manufacturing plants.• Performed user training including creation of training materials, system, and user documentation for DSS and EIS user community.• Promoted twice in 5 years.

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, PowerBuilder, Oracle, Shell Scripting, & proprietary systems.• 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.