Systems Analyst

PROFESSIONAL SUMMARY

I have *+ years’ experience in VB.Net, C#, SQL, SQL Server and SQL Developer. I have excellent experience in SSIS/SSRS.I have outstanding experience with the Oracle database as well as Microsoft and have just completed a project where we upgraded to 12c Oracle. On most of my projects, I have been the technical lead and directed the development. My experience has been primarily healthcare utilizing a Labor and Delivery System environment. I am seeking my next challenging opportunity and am available immediately.

TECHNICAL SKILLS

Microsoft Office Suite

oAll starting with 97

Microsoft Windows (all starting with 3.1 Ending at 10)

Customer Service Skills

SQL

oPL-SQL

oT-SQL

oMySQL

oSQLPlus

VB.net

o 2005, 2008, 2010 and Community

VBA

I.S. Security

Oracle BiPublisher and OBIEE

Visual Studio

o2005, 2008, 2010, and Community.2015

oWinForms

oMVP

oASP.Net

oLINQ

oWSF

Visio same years as above

SOX and PCI compliance auditing

C#

oUsing Visual Studio 2007-2015

Business Security & Risk Management

Systems Analysis, Design and Integrations

Troubleshooting

Security Planning

Access Database(20 years)

o97, 2000, 2003, 2007 and 2010

MS SQL Server starting with 2005

oSSIS

oSSAS

oSSMS

oSSRS

SQL Developer starting with 9g

Autoit(5 years)

VMWare ESXI

VMWare v-sphere iclient

VMWare Workstation

C++(10 years)

Java(10 years)

Telnet

DB2

Statistical software

Labor and Delivery Systems:

oOBTraceVue

oWatchChild

OBIX

PROFESSIONAL EXPERIENCE

MXD Group

Walton Pkwy, New Albany, Ohio 43054

Business Intelligence Developer 10/2106 to 4/2017

Worked with Oracle Bi Publisher creating data models and reports complete with business metrics including but now limited to: Open orders, Delivered, Cycle Time and any report that answered business questions dealing with delivery business.

Used PL/SQL; developing queries with multiple joins to pull above reports.

Troubleshoot old BIP reports to make them run quicker but more efficiently.

Attend meetings in a team atmosphere to go over business needs with end users that needed a report suited to a specific detail.

Troubleshoot Access databases that were outdated to accommodate the 2016 Access PtrSafe functions.

Worked as part of a team to create automated process for 239 client scorecards.

Olah-Healthcare Technology, LLC *formerly Strategic Thinking Industries

Application Developer 10/2012 to 09/2016

Developed and created the new Visual Studio program that pulled the reports in a fraction of the time of an old program using VS 2010 upgraded to 2015 with C# and SQL in 2012-2016.

In 2016, automated the above project designing it to work with other software (Labor and Delivery) as well. and an intern only had to change parameters such as: Hospital name and address in a configuration file to run it and pulling from any database with a simple connection (or creating tables (my queries) to match the program)

Created all phases of the above project using it and fine tuning it through my completion of this job.

Designed and implemented automate procedures of pulling OB Trace strips from various Labor and Delivery Software (OBIX, WatchChild and OBTraceVue)and various hospitals for record archiving. Using Autoit to build a script to do this automatically 2012-2016.

Also self-taught myself IBM Impromptu prior to building the Visual Studio program this is a Cognos software.

Went into numerous sites via Remote connection using various connection tools, for the purpose of creating a script to pull reports and trace strips from various systems.

Pulled data, manipulated data, created tables, inserted data into created table and connected with Oracle and MS SQL databases also importing data from 64bit Oracle database to a 32bit MS SQL database

Primarily I was the ‘Jack of all trades’ at Olah-Healthcare accessing a variety of databases from DB2 and AIX to MS SQL Server and Oracle from 8i to 12c. I also was the person in charge of VMs (virtual machines). And finally the only developer on team with multiple computer language knowledge and C# proficiency.

Experience using SSIS (integration), SSRS (reporting), SSAS (analysis) and SSMS (SQL Server Management Studio)

An agile workplace.

Alliance Data Systems, Inc.

Intern 5/2011 to 2/2012

Designed and Implemented testing scripts with QA Analysts to test new programs in the SIT and UAT atmosphere

Completed extreme programming within an agile environment

Created SQL statements and procedures to pull reports on CPU usage among other reports in metrics

Audited all projects and fast tracks for needed documentation on a monthly basis to make sure the project managers were SOX and PCI compliant.

Created procedure to pull information as needed from the databases for testing

Created test scripts using VBA that was used by the automated testers

United Ambulance Service

Emergency Medical Dispatcher 12/1997 to 5/2011

Designed and Implemented Access database and reports program

oDispatchers had to only have dashboard open and click on appropriate form when phone rang

oTabs for in order of what was needed in an emergency situation so that it could be done quickly and efficiently

Dispatched emergency services in a 2 county area

Created and designed reports as needed

Put billing information together for Medicaid and other insurances

EDUCATION

Bachelor of Computer Information System/ Systems Analyst & Integration

DeVry University Online

Graduated Magna Cumme Laude

Master of Information Systems Management

Keller Graduate School of Management

Graduated with distinction

Contact this candidate