Sql Server Data Analyst

Bob Lundberg

Current Location: St Louis Park, Minnesota

US Citizen - Willing to work remotely.

Summary:

Business Intelligence Developer (ETL, SSIS, and SQL) with recent healthcare experience on healthcare benefits, Claims processing with United Healthcare

2 years working with Claims processing at United Healthcare

15+ years in development of ETL Processes, data mapping and other documentation required for ETL development.

15+ years writing, simple to complex SQL code in both PL SQL and T-SQL and performing data analysis in SQL

9+ years of SSIS Packages development, writing and reporting through SSRS

Over 20 years' experience writing, simple to complex SQL code in SQL Server, Teradata, and Oracle

Skilled in data analysis, analytics, data mining, data models, process improvement, automation, and research.

Worked on creating complex SSIS packages, creating jobs, Alerts, and scheduling SSIS Packages using SQL Agent, migrating the data from different legacy systems to SQL using SSIS

Experienced in migrating Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and experience in Creating, Configuring and Fine-tuning ETL workflows in SSIS

15+ years in writing stored procedures in SQL Server and Oracle

Have proven success achieving cost savings and enhancing system functionality

Strong Project Management skills with experience managing multiple projects through full lifecycle, from requirements gathering to final implementation and end user training

Demonstrated ability to collaborate effectively with individuals at all levels and in all functional areas

History of identifying and solving tough business and technical problems

Experience evaluating, optimizing, and rewriting code to speed up procedures

Experience working with Hadoop

Experience in both Visual Studio and BO

Experience pulling data quickly for ad hoc reporting

Technical Skills:

Category: SQL Server, Oracle, Teradata, SAP, Access, Hadoop, Informix 4GL, Linux, Windows

Visual Studio, SQL Management Studio, SSIS, SSRS, SSIS Task Factory, SAP, R-Script, Crystal Reports, BTEQ, PLSQL, Oracle Packages, VB Script, Hive, PeopleSoft, Toad, SQL Assistant, SQL Plus, Excel, PowerShell, Tortoise, GIT, PuTTY, WinSCP, Unix, Shell Script, Informix 4GL, Microsoft Office, JavaScript, HTML, Business Objects ACE, Business Objects Merge Purge, Business Objects Match Consolidate, FTP, PGP

Education:

Computer Science, University of Minnesota, Duluth, Minnesota, US

High School Diploma, Roosevelt High School, Minneapolis, MN in 1982

Experience:

PORTICO – Minneapolis, MN April 2023 to Dec 2023

Senior Programming Analyst

•Using R-Script and SSIS/T-SQL, Supported and enhanced healthcare and benefits payroll processing

•Supported and enhanced healthcare and benefits payroll processing

•Worked using T- SQL to assist in SAP post migration analysis.

•Using T-SQL, assisted with the SAP data updates and data validation.

•Working with SSIS/ T-SQL and SQL Server Agent to convert and automate current R-Script processes, including ETL processes

•Collaborated with technical team to convert and automate current R-Script processes, including ETL processes, using SQL Server Integration Services (SSIS) Catalogs and SQL Server Agent.

•Developed SSIS Packages and Stored Procedures using T-SQL to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.

•Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services(SSIS) and T-SQL

•Created Visual Studio packages that encompassed SQL Server store procedures, file conversion and file extraction

Preferred One / United Healthcare – Minneapolis, MN Aug 2021 to April 2023

Senior ETL Analyst

•Supported and enhanced healthcare claims processing

•Created Visual Studio packages that encompassed SQL Server store procedures, file conversion and file extraction

•Migrated Data Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and experience in Creating, Configuring and Fine-tuning ETL workflows in SSIS using T-SQL

•Collaborated with technical team to automate processes, including ETL processes, using SQL Server Integration Services Catalogs (SSIS) and T-SQL and SQL Server Agent.

•Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.

•Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services(SSIS) and T-SQL

•Update existing and wrote new Crystal reports

•Using T-SQL to extract data for Excel.

Wells Fargo – Minneapolis, MN July 2020 to May 2021

Senior Database Analyst

•Supported and enhanced data processing activities

•Validated, rewrote, and fine-tuned existing Teradata queries

•Collaborated with technical team to automate ETL processes using PowerShell, Visual Basic, Excel and BTEQ scripts

•Wrote several queries to extract data for Tableau reporting

Target – Minneapolis, MN Sep 2019 to May 2020

•Supported business’s needs, with regards to CCPA (California Customer Privacy Act) project to extract customer’s personal identifiable information (PII) from multiple systems throughout the organization

•Met with multiple teams throughout the company to determine if the data they owned will be necessary to be included in the CCPA reporting

•Validated, rewrote, and fine-tuned the queries written by the engineers to extract the PII data from a Hadoop platform

•Experience using Domo and Tableau

•Wrote several queries to extract the PII data

Capella University – Minneapolis, MN Oct 2014 to July 2019

Business Intelligence Analyst

•Supported both business’s needs with regards to learner enrollment, faculty workload and faculty participation and HR’s needs with regards to employment and management by extracting information for ad hoc reporting and automation using simple to complex SQL, PLSQL, Power BI, SSIS and SSRS reporting

•Met with business to analyze and understand their processes to help make processes more efficient with better reporting or automation

•Supported business and HR’s needs by analyzing and extracting information from multiple servers and databases (Oracle and SQL Server) using simple to complex SQL; this information is presented quickly using SSRS reports and subscriptions to allow the flexibility of manual extracts or automated scheduled emails and files

Rust Consulting – Minneapolis, MN July 2013 – Sept 2014

•Liaison between business, analysts, and IT

•Took the information and requests from business

•Presented business’s requests with the technical knowledge, allowing the analyst to write accurate and complete specifications for IT to perform their tasks accurately

•Supported business’s needs by analyzing and extracting information from multiple servers and databases using simple to complex SQL; this information presented quickly and accurately, either summarized or down to the detail of the customers, allowed business to make better and cost-effective decisions going forward

•Key support for other analysts and their work streams

•Provided experience and equipping them with the knowledge of how to look at the data and make better decisions when presenting to business or IT

Best Buy Mobile – Richfield, MN July 2011 to July 2013

Senior Analyst

•Supported business’s needs with regards to sales, inventory, traffic, fraud, and labor by extracting requested information for ad hoc and online reporting using simple to complex SQL

•Interfaced with vendors to set up ETL processes including VB Script for file manipulation, PGP encryption, SFTP file transfers and database loads

•Consulted with business to help determine the best way to extract and present the data being requested

IQ Marketing (American Family Insurance) – Minneapolis, MN Jan 1996 to Sep 2010

Senior Developer- ETL and SQL Development

•Extracted and analyzed data to assist in data profiling for optimum response in future marketing campaigns

•Extracted data using PL/SQL or straight SQL for requested data extracts or ad hoc reporting

•Created dynamic JavaScript reports that access the Oracle database for client’s online reporting

•Created and consulted with others to present data using Crystal Reports and data extracted from the Oracle database using embedded SQL

•Created materialized views for fast uploading of complex online multilevel reporting

•Interfaced with multiple vendors to manage client data for standardization and consistency

•Worked the full lifecycle of projects working with management, sales, outside vendors, clients, and IT to determine the best and most efficient action to process and present the data

•Designed databases, process flow and data flow for new and existing clients using DDL scripts and Oracle SQL Loader

•Using PL/SQL, Shell scripting and a merge/purge tool, developed and maintained automated ETL processes which included data definitions, data mapping and flow diagrams to convert, cleanse, and standardize multiple sets of data files with different formats and efficiency resulting in a uniform set of clean data to be loaded into the database

•Using PL/SQL, developed a package that will assign and track prospective customers, received from various sources to be mailed, called, or emailed on behalf of participating insurance agents, producing up to $100,000 per quarter

•Collaborated with sales and account management to provide time and cost estimates resulting in project producing yearly revenue, anywhere from $500 to $500,000

•Created triggers to populate history tables to report on the activity over the lifecycle of a marketing campaign

•Analyzed data to report on and project response rates, sales, and ROI

•Developed a tool using Oracle PL/SQL for an insurance company to process 12,000,000 prospects for a direct mail/email campaign; removed duplicate names, removed names previously used over the span of 3 months and attributed the names to 3000 agents using business rules defined by the client

•Successful beta run resulted in $700,000 in revenue over a 2-year span -- $500,000 during the first year

•Developed a PL/SQL package to load and update the enrollment status of participating insurance agents in multiple direct marketing campaigns

•Created and maintained PL/SQL scripts to store data into a data warehouse for archival storage and reporting

•Lead consultant on the data migration and database development converting Informix Database to Oracle resulting in the move from an in-house server to an offsite DBA firm, Oracle On-Demand

•Partnered with account management to provide technical expertise to respond to client’s requests and concerns

Little Mountain Software – Monticello, MN Jan 1993 to Jan 1996

Consultant

•Created solutions using an Informix 4Gl platform

•Designed the database and developed invoicing and accounts receivable system for resale to third parties in vertical markets

•Designed and programmed an invoicing and product inventory system for a national mail order company

•Designed and programmed a residential/commercial property management system

•Produced a technical manual that included step-by-step instructions for the user to manage the data using a front-end tool

•For Proex Photo, analyzed hundreds of lines of Informix 4GL code that had not been documented and documenting it

•Updated documentation allowed the programmers to pinpoint the part of the code more easily in question

•Reprogrammed Appointment tracking system

Contact this candidate