Etl Developer Business Analyst

Marcie Burg Cell: 920-***-****

**** ******* **, ***** ***, WI 54304 ******.****@*****.***

Professional Profile

Accomplished applications developer and business analyst in the information technology field since 1998. Expertise using formal methodologies in working with all phases of the System Development Life Cycle from requirements definition through design, development and implementation. Extensive knowledge of the health insurance industry, and significant Extraction, Transformation, and Load (ETL) experience. Excellent communication skills, work well independently or as a team member, and thrives on continuous learning. Employment Experience

Multicolor Corporation

3/2020 – 7/2020

BI ETL Developer

Achievements:

● Updated/tested BI/ETL Environment

● Updated Database/Datawarehouse with current mappings

● Processed Imports for testing Shipping integrations project Technologies

● Postgrees Sql, SQL Server, Pentaho,SSIS

IGEN

2/2018 – 4/2019

Software Implementer/Analyst

Achievements:

● Configured and implemented software for numerous clients.

● DBA backup duties including refreshing environments

● Data Analysis for new clients

● Testing of new releases of IDEA software.

Technologies

● Microsoft Windows, SQL Server 2014, IDEA software Associated Bank

12/2016– 2/2018

System Analyst III

Achievements:

● Implemented SAP Business Planning and Consolidation package for the finance/accounting department to replace out of date system.

● Wrote SQL stored procedures to import data

● Implemented new check processing software to reduce fraud.

● Administered Concur travel and expense

● Upgrade Coupa procurement software

● Support day to day operations for finance and audit departments.

● On-call support for finance/audit department

Technologies

● Microsoft Windows, SQL Server 2012, Visual Studio 2012, Trintech Financial Solutions, Concur Travel and Expense Solutions. Coupa Procurement Solutions.

Zyquest Consultant for Manitowoc Cranes Inc.

07/2012 – 6/2016

Consultant

Achievements:

● Worked on Remote Diagnostics Project and utilized the CraneStar data to do predictive analytics on crane performance.

● Built ETL extracts to move data from SQL Server 2008 transaction system to data warehouse in Oracle 11g.

● Designed and developed weather data retrieval process using NOAA web service and XML.

● Converted XML extracts retrieved from web service into Oracle database.

● Data Cleansing/Harmonizing to convert data from existing Oracle system to SAP.

Technologies

● Microsoft Windows, Unix, SAP, SQL Server 2008, Oracle,Talend, XML, Tortise SVN, PL SQL

Independent Printing, DePere, WI

11/2011 – 4/2012

Level II Software Developer

Achievements:

● Designed, developed, and implemented Label printing software using C#, SQL Server 2008 and Crystal Reports.

● Developed cXML extract process of shipping data to external customer.

● Developed, maintained, and documented C# windows applications.

● Supported daily business operations.

Technologies

● C#,MySQL,SQL Server 2008,Visual Studio 2010,Crystal Reports,Microsoft Windows,Oracle, DTS/SSIS

HealthEOS by Multiplan, DePere, WI

1/2005 – 9/2011

Programmer/Analyst

Achievements:

● Designed, developed, and implemented Enterprise Reporting System/ Data Warehouse using C#, SQL Server 2000 and Crystal Reports. Reduced IT involvement by moving reporting tasks into the hands of the business.

● Analyzed, designed and implemented DTS/SSIS jobs to consolidate data from multiple database environments into SQL Server to streamline access to information for both IT and the business.

● Converted data for integration with parent company systems.

● Created Oracle stored procedures using PL/SQL to extract data for external clients.

Technologies

● FoxPro,C#,MySQL,SQL Server 2000,Visual Studio

2003/2005,Crystal Reports/Business Objects,Microsoft Windows, Oracle,PL/SQL, SSIS

American Medical Security, Green Bay, WI

6/1992 – 1/2005

Sr. Programmer Analyst(1/2001 – 1/2005), Programmer Analyst(6/1998 – 1/2001), Commissions Team(6/1992-6/1998)

Achievements:

● Maintained and enhanced Premium Posting System to apply customer payments to premiums due. Main contact for IT department and business for posting questions.

● Designed and developed process to store rating history for insurance policies. Improved customer service and gave business access to necessary information.

● Designed and implemented Excel Macro based Finance Reporting System to report company earnings to stock holders and company executives. Improved accuracy of existing process and eliminated manual steps which reduced time necessary to produce information.

● Analysis, design and development of redesigned Premium Billing System. Increased customer service by producing bills that were clear and easy to understand.

● Supported PeopleSoft CRM user testing. Developed Java and JSP code changes, model changes and documentation.

Technologies

● Cobol, CL, Java, JSP, Websphere, SQL, PeopleCode, Visual Basic, PeopleTools, As400,Microsoft Windows

Education/Training

● Associates Degree, Northeast Wisconsin Technical College, 1998

● Introduction to Java Programming, Northeast Wisconsin Technical College, 2000

● Computer Science, Lakeland College, 2003

● Microsoft C# programming, Binary Training 2005

● Maintaining a SQL Server 2005 Database, Inacom Systems, May 2007

Contact this candidate