DANA L. Fredriksson

eMail: ac0fg0@r.postjobfree.com

**** **** ****** ***** ********, Colorado 80227

Cell: 720-***-****

PROFESSIONAL OBJECTIVE

To obtain a Business System Analyst/Project Manager position that will capitalize on my expertise in integrating clients and technologies throughout entire project life cycle, as well as on my interests and experience in:

Capability Maturity Model (CMM), Business Analysis and Best Practices

Accounting/Financial Functions and Compliance, Health IT

Client Support Service, Project Management and Technical Liaison

Quality Assurance, Systems Integration, Conversions, Technology Enhancements, and Data Mining

CERTIFICATIONS

Data Warehousing Certification Training – Edureka – May 2017

Health Information Technology: Design Certificate – Lamar Community College – 2012 GPA 3.75

Health Information Technology: Implementation Management Certificate – Lamar Community College – 2012 GPA 3.75

Six Sigma Green Belt Training - 2015

Certified Associate in Project Management (CAPM) – 2009

Certified SCRUM Master – 2010

QUALIFICATIONS AND STRENGTHS

More than 10 years of combined experience in Business Analysis, Data Analysis, Systems Integration, Developing and Implementing Strategic Project Initiatives, Quality Assurance, Sales and Client Relationship Management. Provide demonstrated expertise in the following areas:

Consistently Identifying Opportunities to Enhance Productivity, Profit or Performance

Streamlining Processes and Systems Leveraging Technology Applications

Extracting, translating and loading data between systems, ETL

Test lead for ERP system; define, analyze and test system requirements

Liaising Between Diverse Departments, Project Teams and Non-Technical Groups

Coordinating Projects from Initial Concept through Testing, Execution and Training

Strengths:

Well-Organized with Excellent Planning, Time Management and Task Prioritization Skills

Leadership and Team-Building–Raising the Bar of Excellence and Performance

Capable of Relating and Explaining Complex Technical Information to a Wide Variety of Audience Levels

Build and maintain strong relationships with stakeholders.

Ensure the delivered solution meets the scope, cost and time commitments for the initiatives.

Technical Proficiencies:

Oracle PL\SQL and SQL Scripting, SQL Server, TOAD, UNIX, Windows,

Jira, Visio, MS Project, MS Office Suite, Excel, Word, MS Access, Bolo Systems

Waterfall Lifecycle (SDLC), Kanban, SCRUM

PROFESSIONAL EXPERIENCE

AxisPoint Health formally a McKesson Company 2013 to 2017

Senior Business System Analyst

Project Manager for the Nurse Advice Line Dialer Implementation

Used Jira to create user stories. Designed the Jira Workflow used by the Reporting team.

Gathered ETL and UI requirements and designed the Nurse Advice Line Dialer and the Scripted Outbound Implementation

Gathered ETL and designed the Care Manager Dialer Implementation

Designed a solution for the PCM Dialer Implementation

Developed complexed queries to validate client billing by extracting data from both the Data Warehouse and the Application database for comparison

Using Sql Server, performed data analysis to troubleshoot Dialer issues

Designed and developed reports to monitor the billing population during a billing cycle.

Worked with the DBA to gather requirements and designed a data model for the Riverside project, Dialer Project and Scripted Outbound Campaigns.

McKesson Health Services– Broomfield, Colorado 2009 to 2013

Business Analyst\Consultant

Developed complex SQL queries to extract large amounts of data for analyzing and troubleshooting Production Issues using Oracle and TOAD.

Liaison between IT and the other departments performing Production Support to explain issues and solutions

Performed root cause analysis to troubleshoot Production Issues to decrease operational costs.

Performed analysis on Production Issues, gathered requirements, developed Use Cases for the Batching Process

Gathered requirements, developed Use Cases and performed data mapping for consolidating the mail process.

Analyzed data and developed a process for Operations to avoid paying penalties to clients

Gathered requirements and developed reports for operations to validate the data load batching process.

Prepared reports to track Billing defects; analyze root cause for defects and suggest solutions

Performed data analysis which lead to data cleanup for production issues

Coordinated and tracked Production Issues until completion

Gathered requirements and developed Use Cases for the New Disease Management project.

. .

Level3 – Broomfield, Colorado 2008 to 2008

Business Analyst\Consultant

Developed PL\SQL and SQL scripts to extract transform and load large amounts of data from one database to another.

Designed and developed SQL Server database to extract data from different Oracle databases to validate the changes in the Billing process

Gathered requirements to create reports and databases for validating the converted data.

Analyzed and develop methods to streamline the validation process of data using Access 2003 & 2007, Hyperion Brio, TOAD and SQL Server.

Trans Montaigne – Denver, Colorado 2007 to 2008

Business Analyst\Consultant

Gathered requirements, analyzed and develop methods for streamlining the net out process for applying payables.

Developed SQL scripts to validate production and test data.

Gathered requirements and prepared documents for reports and the Electronic Transfer Process.

Developed relationships with different department and stakeholders to gather requirements for process improvements and system solutions

Developed a method to extract and map data to quickly identify unprocessed invoices and to reconcile the AS400 to the Vendors drafts

Developed training documentation for the Electronic Transfer Process or successful implementation of the project

Developed a process to identify millions of dollars of indefinable Oil and Gas payables.

Bolo Systems Inc. - Lakewood Colorado 2006 to 2007

Business Process Analyst\Consultant

Gathered requirements from stakeholders to design application using Visual Basic and Excel to support Client’s revenue process.

Analyzed, mapped and converted clients’ master data from their old accounting system to Bolo’s Oil & Gas ERP System.

Assisted clients to identify and resolve issues concerning the data conversion. Assisted other departments with client issues relating to client issues, Access, and Excel. Map incoming data from clients’ oil and gas source files through creation of Unidata tables, attribute definitions and loading of raw data.

Successfully mapped and imported clients’ data from the review stage through going live.

Gathered requirements, designed and developed an import tool for data for a client to import data from an outside system into Bolo Systems on a reoccurring monthly basis using Visual Basic and Excel Macros.

Using Visual Basic and Excel developed and implemented a business process to import data from another system into Bolo’s database to meet stakeholders’ business objectives.

Using Access and SQL, extracted and translated large data files from other systems into the Bolo’s data format for conversion.

Gathered requirements and designed management reports for stakeholders using the Financial Report Builder reporting tool.

Assisted with Quality Assurance testing and suggested solutions to improve the software reliability.

Prepared test cases and data for quality assurance testing to compare reports produce from different versions of Bolo Systems.

Performed Data Validation to validate conversion data.

Build and maintained strong relationships with clients and stakeholders.

General Electric – Broomfield, Colorado 2006 to 2006

Quality Assurance Analyst/ Consultant

Assigned to a short term project testing changes to Oracle Financials Accounts Payable system. Created and executed Test Cases for Oracle Financials using Test Director. Identify and document bugs. Documented test results.

NEWMONT MINING CORPORATION - Denver, Colorado 2004 to 2006

Fixed Asset Project Accountant/Business Analyst

Analyzed, documented and implemented new procedures for tracking costs of projects and reconciling Construction in Progress to the General Ledger to comply with Sarbanes-Oxley.

Designed methods for extracting, testing and validating large amounts of accounting data from the old system to the new one, using Hyperion Financial Management (HFM) grids and Excel.

Identified data inconsistencies in Ellipse’s accounting reports; prepared requirements to correct inconsistencies.

Gathered requirements for Ellipse Project reports for enhanced accuracy and user understanding.

Enhanced the A/P process and collaborated with other departments to assist them with their accounting needs.

Opened and Closed AFEs and maintained AFE database.

Developed tools for tracking the Hyperion Financial Management (HFM) Users securities using Visual Basic and Excel macros.

Prepared the change report to move these changes into production.

Using the Ellipse’s report writer and modifying the SQL generated statements, extracted data from the database to generate custom reports.

.

WORK TELECOM SERVICES, INC. - Englewood, Colorado 2002 to 2003

Account Representative

Gathered requirements from client to design voice/data solutions.

Negotiated contracts with Clients.

Prepared proposals and RFPs leveraging partnerships with other vendors to create a complete solution for client. Included in these proposals were time estimates and schedules for completing these projects.

Recognized for networking efforts and sales success despite increasing competition and a relatively flat market by organizing a networking group.

LOCKHEED MARTIN EIS - Littleton, Colorado 1997 to 2001

Systems Integrator

Developed programs using SAS and PL/SQL scripts to extract, convert and load data from one database to another.

Prepared and presented a web site demonstration to directors and program managers to obtain funding for web site launch and implementation.

Using Visio, documented dataflow for training and testing throughout the life cycle of the Metaphase Product Data Management system.

Performed regression, unit, and quality assurance testing and implemented enhancements to the system; wrote Oracle and UNIX scripts.

Defined and executed test plans, test scripts and documented test results.

Registration Database systems administrator utilizing HTML, Oracle PLSQL & SQL, and UNIX to support the system.

Using Oracle and Visual Basic, created several applications that extracted data from Oracle databases to produce reports for Accounting.

Recognized for completion of the Y2K Metaphase project testing ahead of schedule.

Using Data Mining techniques saved the company millions through SQL scripting/research/reconciliation of an accounting discrepancy.

Analyzed and documented the data flow of the Registration Database and the different systems it integrates. Presented results to management.

Analyzed several systems to show the company’s impact if they were not Y2K compliant.

Maintained Headcount Management System that tracked schedules, costs and budgets for multiple projects.

Test lead for the Metaphase project; prepared, executed, and documented the test plan and test cases for the project.

Emerald Award Recipient for Excellence in Customer Service, 2001

Team Spirit Award Recipient for Excellence in, and Contribution to Team Work, 2001

EDUCATION AND HONORS

STATE UNIVERSITY OF NEW YORK AT ALBANY - Albany, New York

Bachelor of Arts Degree in Computer Sciences 1997

Minor: Business with emphasis in Accounting, Finance and Management

• Dean’s List - Spring 1996 and Fall 1997

Contact this candidate