Databases DB2, Oracle, SQL Server, Microsoft Access, Data Warehouse/Data Mart
01/2014 to Current
Senior Technical Business AnalystNORTHWESTERN MUTUAL － Milwaukee, WI
Lead analyst to optimize the SQL, Informatica ETL, data warehouse, data mart, and business intelligence processes and interfacing applications.
Identified and reengineered long running SQL processes to minimize the risk of jeopardizing established Service Level Agreements.
Project Manager and Lead Application Architect for a 10-month project to develop a core ETL data warehouse, data mart, business intelligence system to consolidate and summarize an average of 2 million daily financial transactions that support the financial activity decisions of the Controllers division.
Developed an Excel / Visual Basic / VBA macro workbook to support the annual Tax Reconciliation activities, allowing the Controllers to manage, reconcile, and generate reports and distributable workbooks.
Automated the monthly and quarterly PeopleSoft security audits resulting in increased data reliability and decreased the audit durations by 80%.
Identified and implemented business and process improvements to the PeopleSoft Financials ERP suite supporting General Ledger, Accounts Payable, Procurement, Travel and Expense, Tax, and Audit.
01/2007 to 01/2014
Senior Business Systems AnalystVEOLIA ENVIRONMENTAL SERVICES － Milwaukee, WI
Team Lead, mentor, and subject matter expert managing ImageNow, an Electronic Content Management application digitizes and routes documents for approval, processing, retention, and information accessibility.
Lead application architect for the redesign of vendor-delivered Accounts Payable workflow.
Efforts resulted in an increase of available discounts taken from $300K to $2.2M by systematically prioritizing voucher activities to maximize cash flow, leveraging the PeopleSoft Financials escalation and approval data.
Enterprise Architect for the design and functional support of PeopleSoft HCM and Financial applications; Human Resources, Payroll, Benefits, Accounts Payable, General Ledger, Inventory, Travel and Expense, and Procurement.
Project Manager for PeopleTools upgrade from 8.52 to 8.53 for both the PeopleSoft HCM and Financial product suites.
01/2005 to 01/2007
Senior Systems AnalystGREDE FOUNDRIES, INC － Milwaukee, WI
Senior Technical Analyst supporting PeopleSoft HR, Payroll, Benefits, Time and Labor, Training Administration, and Company Property modules for a national supplier of ferrous metal, iron, stainless steel, and specialty iron castings.
Designed and developed a customized PeopleSoft based Company Property module to manage assigned assets to achieve reduced property loss, and increase assessment reliability.
Reviewed, coordinated, documented, implemented, and tested PeopleSoft tax updates, patches and fixes.
Evaluated and reengineered customized PeopleSoft objects and internally developed processes for improved performance, increased efficiency and reduced processing time.
Liaison between internal clients and external vendors, interpreting systems requirements, designing solution proposals, estimating cost allocations, executing test plans, and troubleshooting technical and functional issues.
01/1995 to Current
Vice-Chair of Technology/Enterprise Application Architect / AdvisorMILWAUKEE PUBLIC TELEVISION/GREAT TV AUCTION － Brookfield, WI
Designed and developed Visual Basic/SQL Server Windows application that supports the year-round operations, full-time staff members, and more than 4,000 annual volunteers associated with the Milwaukee Public Television Great TV Auction.
During the televised Auction, the application supports nearly 200 simultaneous users.
The supporting SQL database was originally hosted on SQL Server 2000 and currently, SQL Server 2008.
The database incorporates nearly 400 stored procedures, and API interfaces to the broadcasting character generators.
The application incorporates Crystal Reports and interfaces with POS receipt printers.
Since the introduction of the enterprise application, Auction revenue has increased 20% ($200K) annually, and the standardized paperless business operation has increased transaction fulfillment to 99%.
Lead an 8-member team of IT volunteers to accomplish the visionary goals to automate, network, and standardize the infrastructure.
The application is currently being converted to a C#.net application with Visual Studios 2016 to align with current Windows operating systems and the database hosted on SQL Server 2016.
Education and Training
Master of Business Administration: Information TechnologyCONCORDIA UNIVERSITYInformation Technology
Bachelor of Science: Business AdministrationCARDINAL STRITCH UNIVERSITYBusiness Administration
Associate Degree: Business Data ProcessingMILWAUKEE AREA TECHNICAL COLLEGEBusiness Data Processing