Sign in

Data Support

Woodbury, Minnesota, 55129, United States
November 09, 2018

Contact this candidate



***** ****** ****, ********, ** **129 • H: 612-***-**** •


** **** *****' experience within the information technology industry. Skilled in applications programming using PeopleSoft coupled with Business Intelligence and data warehousing. Knowledgeable in PeopleSoft Financials and HRMS/Benefit modules from a business and design perspective. Proficient using Microsoft BI stack encompassing ETL, Cube design, reporting and dashboard presentation. Database administrator within a Parallel data warehouse (PDW) utilizing SQL server integrations. Accomplished in MS Windows environments, Visual Basic, Access, Excel, Word. Oracle SQL/SQR, and UNIX.


Database design Excellent problem-solving abilities

System upgrades Windows and Linux

System backups Excellent communication skills

Technical specifications creation Enterprise technologies

Excellent diagnostic skills Coding and modularization

Refined system debugging skills

Development Programmer


Database Administer / Analyst

Optum technologies/UHG 01/2017-Current

- Responsible for managing multiple database instances to support development, test and staging environments.

- Spin up new database environments from scratch to facilitate proof of concept (POC) demos to supported teams.

- Backup and restore database environments on demand and emergency recover.

- Leadership capacity to provide and promote best practices for constructing database table structures with optimal indices.

- Utilized database utilities like explain plans to diagnose and visually show best access paths for data retrieval.

- Developed and implemented security audit processes using SSIS with hooks into active directory utilizing PowerShell

- Regular daily duties helping troubleshoot developers complex code problems within SSIS.

- Wide use of Visual Basic scripted tasks declarations in SSIS

- Maintain team data load process documentation using SharePoint

- Defined new server scheduled tasks to support SSIS requirements.

- Introduced to AZURE and geared to exploit cloud-based data presentation thru subscriptions.

- Normal operations including RDP into various non-production application, web and ssis servers to control work loads

- Venafi certificate maintenance and support for Web teams

- SME for group SQL questions.

- Member and fill in scrum master during planning sessions to support team activities.

- Team foundation services (TFS) for continuous deployments

- Support UI thru XML based queries to access database and test application functionality

- Database Administer with critical role to apply and maintain security model across multiple PDW/SQL server instances

- Assist in trouble shooting environmental issues with daily and scheduled deployments

- Monitor and remediate performance issues for app/web/ssis and sql servers

- Support optum teams for deployments and loads.

- SME for team security model and mentor security administration to support internal teams

- Oversee and implement windows patches for group servers

- Using Power BI collect and monitor key metrics to help isolate potential performance problems

- Presented Power BI visualizations in dashboards to team leads to show areas for improvement.

- Using Rally in an Agile setting to track and collect new content and problem management.

- Daily exposure to stored procedures to dissect and analyze use for business logic

- Maintaining team wiki page to support key data loads.

Contractor. ETL Developer – Eden Prairie, MN 07/2016-01/2017

United Health Group - Minnetonka, MN

-Convert ETL for 2017 Annual Enrollment program.

-Provide Secret Shopper data for QlikView reporting.

-Define and implement a new analysis tool for UHG daily factors.

Data Analyst

Augeo Marketing Group - St Paul, MN 07/2015 - 07/2016

-Utilize SSIS .net scripting to interface with third party web sites.

-ETL support for Wells Fargo payment processing.

-Using Microsoft SSIS 2012 to facilitate data collection from multiple web site reward programs.

-Produce functions, stored procedures and numerous queries in SQL server 2012 to perform many adhoc requests and

manipulations of key data elements.

-Utilize SSIS XML email capabilities to present data.

-Extract data on demand for many email campaigns such as Wells Fargo, Scout Loyalty and Shriner.

-Address a collection of service requests from departmental key users.

-Responsible for the implementation of email distributions using Exact Target email platform.

-Fluent using JIRA environment to collect, prioritize act and report enhancements and defects received from departments.

Senior Development Analyst

Smead Manufacturing Company - Hastings, MN 09/2006 - 07/2015

-Lead ETL developer for on BI team responsible

-Re-wrote 150+ staging data and Fact and Dimension warehouse tables from IBM's Data Stage to Microsoft SSIS packages.

-Converted Data warehouse from Microsoft 2005 to 2008.

-Key roles in constructing Microsoft SSIS, SSAS, SSRS, and SharePoint environment for team,

-Clear understanding in using CA Erwin data modeling tool to maintain and document existing and new development.

-Construct dimension and fact table loads using the star schema modeling technique.

-Develop ETL to support multiple metric calculations for corporate wide reporting using Cognos.

-Primary development for Data Stage and SSIS ETL work.

-Performance tuning DataStage / SSIS ETL,

-Support for Monthly DataStage Corporate scorecard loads along with staging loads.

-Primary support for PeopleSoft Financial Accounting systems using GL, AP, FA, PC, AR modules.

-Core team member responsible for upgrading to PS HRMS to release 8.9 Primary team member for maintaining

Supply Chain Management Security Application of various HRMS tax bulletins.

-Key team member responsible for installation and support of Kronos Time Collection system.

-Lead analyst responsible for creating and maintaining numerous interfaces in support of Kronos to PeopleSoft interfaces.

-Continuous improvement for Scorecard data collection. Reduced end to end process time from days to hours.

-Delivered fully documented system for scorecard processing.

-Adapted consultant provided documentation to provide better use of analysis services cubes with data dictionary of available structures.

-Responsible for enforcing corporate security model direction within PeopleSoft.

-Worked closely with infrastructure team to make sure database components are in sync with PeopleSoft internals

Development Analyst

Trane Company - La Crosse, WI 01/1995 - 09/2006

-Lead support analyst for DBS Payroll and Human Resources systems for 3+ years.

-PeopleSoft support for Financial Accounting systems using GL, AP, FA, PO modules.

-Selected as team leader in moving Payroll and HRMS/Benefits functions into PeopleSoft 6.0 for Trane's World Applied

Systems Group.

-Responsible for the implementation of release levels: 2.2, 3.0, 5.12, 7.0, 8.0 and 8.8 With a Project lead role for the

planning and the upgrading of PeopleSoft financials from 5.12 to 7.0 Managed the downsizing of 50 plus mainframe

processes to new client server application in preparation for the Y2K.

-Proficient in using PeopleSoft security functions.

-Established interfaces into the PeopleSoft environment for in house applications using People Tools and SQR/SQL.

-Initiated and completed the conversion of DBS Fixed Asset system to PeopleSoft system.

-Specialized in writing PeopleSoft conversions for Payroll, HRMS and Financial applications.

-Designed COBOL/Focus programs to provide extracts to populate Oracle tables.

-Lead support for Oracle 8I Data Warehouse.

-Administrator for all PeopleSoft environments.

-Lead technical contact for all performance tuning within environment Responsible for evaluating and monitoring all

PeopleSoft job scheduling activity.

Trane Company – La Crosse, WI 01/1988 - 01/1995

-Support DBS PR package by applying and testing tax and regulatory updates for main La Crosse office and 3 business units.

-First department at Trane to offer Laser printing of W2s.

-Updated existing COBOL programs created new programs using PL1 and MicroFocus.

Applications Programmer

RAM - La Crosse, WI 01/1986 - 01/1988

-Maintained COBOL programs for a route accounting system using a Burroughs computer.

-Used relational database called PROGRESS to transition from a microcomputer environment to PC based.

-Act as a liaison by answering software and technical based questions for users.

-Involved in demonstrations of applications and onsite system installations.

-Responsible for performing system backups.


Bachelor of Science: Computer Management Systems Viterbo College - 1985

Computer Management Systems

Emphasis in Business


Six Sigma Greenbelt

Contact this candidate