Resume

Sign in

Database Architect, Business/Data Analyst

Location:
Plymouth, WI
Salary:
$40.00/Hr
Posted:
April 15, 2020

Contact this candidate

Resume:

John Paul Wohlen

Location: Plymouth, WI

Work Authorization: US Citizen

adctk5@r.postjobfree.com 920-***-****

Summary:

Experience with MS Office:

10+ years of experience working with MS Office while working for clients like FIS, Case New Holland, Milwaukee County, Waukesha County, Western Industries and so on.

Project Manager responsible for Baan ERP implementation from its start utilizing MS Project and other Office programs (Word, Power Point, Excel, Visio and Outlook) to define tasks, assign and track resources, document business processes, report actual against budget and adjust time lines to fit realistic schedules to its successful on time and under budget completion.

Developed project schedules in MS-Project, wrote specification requirements, testing plans, training documentation using Visio and Word and supported implementation in all phases.

Completed Discovery for reporting needs, developed project plans, specifications and time lines for reporting needs to complete implementation, utilizing MS-Project, Visio and Word.

Experience with Data Mining and Integration:

10+ years of experience working with SQL (2016, 2014, 2008r2, 2003, 2000 and 7) while working for clients like FIS, Case New Holland, Milwaukee County, Waukesha County, Western Industries.

Developed a RAD solution to open ended requirements, discovered multiple CRM data-sets (Excel & Text files), Billing data from 5000+ Customers on three different billing systems (SQL ODBC & Text files) created ETL feeds from these sources into distributed Access 2016 databases linked to satisfy the reporting needs. Migrated above solution to the FIS Azure Cloud in SQL 2016 with a team of Indian developers, documented table structure, processes and ETL logic that allowed the team to create SSIS transactions to maintain the SQL data warehouse.

Using SSMS/SSDT developed four SQL Scripts (47 pages) that fed a data warehouse that summarized Farm Journal data into analytical categories of customer characteristics that led to a data warehouse that identification of high potential customers by the Dealer network using simple queries.

Using Crystal Reports, MS-SQL Enterprise Manager/Query Analyzer and associated tools, developed stored procedures and scripts that created temporary and permanent tables used by End of Year reporting, multiple Pension EDI feeds to State and Federal Agencies.

Skills:

Expert: Access, Excel, MS SQL 7, 2000, 2003, 2008r2, 2014, 2016

Advanced: SSMS and Enterprise Manager, SSDT, Word, MS-Project, Visio, Power Point, Crystal Reports, Arpeggio, R & R Report Writer

Intermediate: SSRS, SSIS, Visual Studio, Visual Basic, dot Net, Windows 10, SharePoint 2010, 2013 & 2016

Education & Certification:

B.S. Architecture, University Wisconsin Milwaukee

Six Sigma Green belt, University of Wisconsin Extension

Microsoft Course 1634: Accelerated Exchange SQL

Microsoft Access for Developers, Microsoft Excel Advanced features and Power User VBA

CTX-302.2 Citrix MetaFrame Administration

Professional Experience:

FIS 11/2017 – 10/2019

Database Architect

Did original open ended discovery for complex financial product lines, using six-sigma iteration techniques to determine requirements that lead to the solution that supported campaigns of mass enablement (targeting of customers that would desire new financial products).

Developed a RAD solution to the above requirements, discovered multiple CRM data-sets (Excel & Text files), Billing data from 5000+ Customers on three different billing systems (SQL ODBC & Text files) created ETL feeds from these sources into distributed Access 2016 databases linked to satisfy the reporting needs. Migrated above solution to the FIS Azure Cloud in SQL 2016 with a team of Indian developers, documented table structure, processes and ETL logic that allowed the team to create SSIS transactions to maintain the SQL data warehouse and reporting UI.

Case New Holland Commercial Services 11/2016 to 5/2017

Database Architect

Clarified vague requrements to support field sales, worked with the marketing team that defined 45 categories of farm/farmer characteristics of CNH customers and did original reseach into definations of farming termonolgy to data-mine the Farm Journal data-set (over a million records with 350 attributes defining American/Canadian farms).

Developed four SQL Scripts (47 pages) that fed the data warehouse the summarized Farm Journal data into analytical categories of customer characteristics that led to identification of high potential customers by the Dealer network using simple queries.

Using a model and requirements created by Corporate Marketing developed and documented a 68 table database using Navicat, and SSMS 2014 that is the basis of the data warehouse used for marketing contacts by the Dealer network.

Using Visual Studio/SSDT-2015 and SSIS developed ETL packages that moved data into and out of the above database.

Data-Mined/Scrubbed over seven million customer contacts (over 10 years of data) to arrive at 250,000 valid unique email addresses and their Brand requests that was used to develop a Marketo email marketing campaign.

Milwaukee County 07/2005 to 01/ 2016

Business Analyst IV

Define Business requirements, create SRS for customizations, test, implement, document and train a Ceridian HRIS Cloud application suite (Recruiting, HR Payroll Web, Time & Attendance & Benefits)

Developed project schedules in MS-Project, wrote specification requirements, testing plans, training documentation using Visio and Word and supported implementation in all phases. Led ETL project team that researched and purchased a data conversion tool (V-Edit) to convert Genesys Ebcdic VSAM mainframe files into ASCII MS-SQL 2000 tables. Developed data mapping from Cobal copy books that were used to download the mainframe data and massaged/scrubbed it into SQL 2000 comparable import files into Ceridian.

Due to an aggressive time line and exceptional cases causing UAT failure at go-live, had to develop “work arounds” until Ceridian could fix and finish customizations. Using Access and SQL 2000 developed “on the fly” Retirement reporting and EDI data transfer to Genesys and then V3 retirement systems, Increment and Probation reporting, complex seniority calculations and reporting saving the County millions of dollars in lawsuits.

Did 100% testing of Ceridian's eventual solutions.

Developed ETL processes to create complex financial labor distribution reconciliation data base and reports used by the Milwaukee County Sheriff’s Department to obtain multimillion dollar Federal Grants.

Waukesha County Dept. of Admin Human Resources and Payroll 10/2004 to 07/2005

Business Analyst/Consultant

Finished implementation of Ceridian HRIS project (Installed locally on site)

Completed Discovery for reporting needs, developed project plans, specifications and time lines for reporting needs to complete implementation, utilizing MS-Project and Word.

Using Crystal Reports, MS-SQL Enterprise Manager/Query Analyzer and associated tools, developed stored procedures and scripts that created temporary and permanent tables used by End of Year reporting, multiple Pension EDI feeds to State and Federal Agencies.

Created custom Labor Distribution and Overtime analysis reports for Sheriff’s Department, Budget Planning and complicated Government EEOC-4 reports.

Star Plan Data Systems 10/2002 to 09/2005

Software Developer

Develop a world-class Golf Tournament Windows application

Working with existing software and Golf Professionals, did discovery and documented the golf tournament “process”, developed specifications, work flow charts in Word and Visio.

Created conceptual, logical and physical models that lead to a 45 table relational database in both SQL-2000 and Access.

Using Visual Studio and Visual Basic. Net, ADO. Net, ASP. Net and Crystal Reports 9, developed complex logic & application for events, player entry, teaming, flighting, multiple team tee times and the 1800 different ways to score events, over 600,000 lines of code.

Western Industries 04/1996 to 03/2002

Business Systems Manager

Implemented a Baan IVb2 ERP software solution ($3.9 million dollar budget)

Project Manager responsible for the implementation from its start utilizing MS Project and other Office programs (Word, Power Point, Excel and Outlook) to define tasks, assign and track resources, document business processes, report actual against budget and adjust time lines to fit realistic schedules to its successful on time and under budget completion.

Because Western Industries was too lean to dedicate a traditional ERP team for the three year implementation, I developed a unique project plan: With the approval of the CEO, CFO and Divisional Controllers hired & managed six Business Analysts (one for each Division) set up a Training facility at the pilot Division and with all, took over six months formal Baan training bringing all the Divisional specialists (all the Purchasing Agents for Purchasing module, Engineers, Sales, Finance etc.) in to training to document current and future practices.

Using Visio, Word, Tools 6.1, Crystal & Arpeggio report writers) developed new company/Baan processes and procedures. Developed over a thousand pages of data models, end user training manuals as well custom reports and forms.

Worked closely with CFO and Divisional Controllers to develop a unified General Ledger and dimensions (Baan ERP sub-ledger accounts) as well as the initial financial integration’s (the mapping of the logistical events to their financial results). Taught Baan costing methodology to Division Controllers, led discussion and helped develop final costing process.

Leading cross functional teams of up to twenty at each of six Divisions, trained and worked with end users to integrate the new Baan procedures into best business practices.

As analyst and programmer, integrated shop/labor reporting across multiple databases, over $50,000 per year per Division in HR/payroll costs saved. Developed data model of reporting needs used by Accounting and Operations (in Visio).

Installed and tested SQL-7 and Citrix Metaframe in an N-tiered multi-server design to support Ceridian Source 550 HR & Payroll centralized database of over 156 tables for a distributed user environment of five Divisions in three states covering 1600 employees. Developed the backup and recovery plan to a remote server and Tape off-loading for redundant data recovery.



Contact this candidate