Resume

Sign in

B

Location:
McKinney, Texas, United States
Posted:
October 17, 2016

Contact this candidate

E M P L O Y M E N T

VIRE Consulting

October **** – Present

Business Analyst

October 2015 – Present

oDevelop report layouts and mock-ups based upon reporting requirements provided in assigned Unified Work Requests.

oHold meetings with the IRS Stakeholders to develop business rules and data selection criteria for report(s) under development.

oMaintain supporting report development documentation for new and modified reports.

oAssist the Data Analysts on the mapping of data elements for new and modified reports. This is to ensure that the data elements in a given report are being properly populated from the correct summary or primary (FACT) table in the Data Mart.

oWork with report developers to ensure that the report(s) were functioning correctly in either BOE (Business Objects Enterprise) and/or Tableau.

oAssist with the training new Business Analysts as part of a VIRE mentoring program.

MedAssets

June 2013 – October 2015

Business/Data Analyst

June 2013 – October 2015

oManipulate, validate and transforms supplemental data received from Tenet Healthcare

oGenerate and distribute weekly, monthly, and quarterly reports to the Tenet Operations management team, Regional Directors of Material Management, and Facility Directors of Material Management.

Reduced the time of generating and distributing the monthly reports from three days down to one hour by modifying the Excel spreadsheets to link directly to views in a SQL 2008 R2 server.

oCreated SSIS packages to automate the creation and distribution of two reports on a monthly basis.

oCreated a data model, database and SSIS packages to import the supplemental data received from Tenet Healthcare Systems into their associated tables.

oSecured network resource to use as long term storage for the files that contained the supplemental data being received from Tenet Healthcare Systems.

oWorked with IT department to develop QA processes and procedures on the primary data being received from Tenet Healthcare Systems on a daily and monthly basis.

oAssisted in the development of a File Specification to be used for all data imports into an internal reporting tool for conducting Market Share research and high-level analysis.

oDeveloped the SSIS package that created the file from the Tenet Healthcare Systems data that was automatically uploaded to an internal network resource for import into the company’s internal reporting tool.

oUtilized Microstrategy and SSIS package templates for developing reports and data extracts for ad-hoc report requests.

oAssisted in the development of new reporting tools for monitoring ROP/ROQ to aid the Regional and Facility Directors of Material Management in keeping better track of inventory levels and utilization.

Bank of America

September 2012 – March 2013

Contract Data Consultant

September 2012 – March 2013

oGenerate SQL scripts for extracting data using Microsoft SQL Server 2008 for Post Implementation Validations.

oCreate custom queries and scripts for extracting, manipulating, and formatting data using Microsoft SQL Server 2008 and Microsoft Access for ad-hoc reporting needs.

oPerformed weekly audit and distribution reconciliation for the Department of Justice Reporting Project. Created the Microsoft SQL scripts for extracting required data from the Bank of America Microsoft SQL 2008 Server, reconciled the data extract in Microsoft Access with the data provided by the distribution vendor, then provided reports based upon the results to the project’s stake holders using Microsoft Excel.

oCompiled and generated the weekly Audit Tracker Detail report and Breach Activity Graphs using a combination of Microsoft Access and Excel.

oAutomated the process for obtaining the data needed for the Audit Tracker Detail report by using Microsoft Access to pull information from the In-Line Controls SharePoint 2010 site.

oCreate, update, and maintain the Excel spreadsheets being used for the 20 standard Audit Templates that the In-Line Controls team conducted on a weekly basis.

oConduct daily audit of updates to Loss Mitigation Contacts made by Off-Shore Team.

oMaintenance to In-Line Controls SharePoint and Discovery sites.

University of Texas Southwestern Medical Center

June 2003 – August 2012

Software Support Specialist II

October 2011 – August 2012

oProvide server administrative support for the Department of Cardiology IT infrastructure.

oAdministration of the VMware 4 virtual infrastructure.

oTrain clinicians on the use of the Cardiology Clinical Research Participant Enrollment web application.

oDatabase administration for the Department of Cardiology and the Cardiology Clinical Research Database (CCRD) program.

oPerform quarterly data validation to look for possible errors in the data being collected.

oSupervise the lab technician assigned for processing collected blood samples for the CCRD.

oMaintained the departments SharePoint 2007 site.

Programmer Analyst

November 2008 – October 2011

oDevelop Microsoft SQL 2005 Server database model for the Cardiology Clinical Research Database program.

oMaintain the standard de-normalized database; create/extract normalized data sets based upon the requests from researchers.

oDe-identified patient information data to meet HIPAA regulations and validated it for accuracy, reviewing for anomalies.

oCreate web-based reports and dashboards using Excel and Microsoft SSRS. These reports and dashboards were designed to provide the Project Stakeholders the ability to monitor the progress of the project and made accessible on the program’s SharePoint 2007 site..

oCreated a web-based participant entry system using ASP.net.

oPerform quarterly data validation to look for possible errors in the data being collected.

oCreated an automated SSIS package which imported patient data from one of the University’s Clinical Systems into the CCRD database on a daily basis for all newly enrolled study participants.

oEnroll participants into the Cardiology Clinical Research Database program.

oDevelop the lab processing protocol for the Cardiology Clinical Research Database program.

oSupervise the lab technician assigned for processing collected blood samples.

oTrain clinicians on the use of the Cardiology Clinical Research Participant Enrollment web application.

Project Manager

July 2007 – November 2008

oProvide daily assistance to the Program Director and Senior Program Management Officer on the $75M Gulf War Illness and Infectious Diseases Program.

Prepare quarterly reports to the VA and the 25 University Stakeholders. The reports for the University Stakeholders were developed using Microsoft Excel and SSRS,

Create a Program Management Office portal with SharePoint 2005.

Create Master Timelines and track deliverables for the 18 Task Orders using Microsoft Project and Portfolio.

Provide additional Project Management support to the Principal Investigators all 18 Task Orders.

Develop the database model using Microsoft Visio for the programs accounting system and Rosetta Stone. The database itself was then created using Microsoft SQL Server 2005.

oMange Task Order 2, Specimen Handling and Processing.

Coordinate the transfer of PII/PHI/III and collected specimens in accordance of HIPAA regulations between the sub-contractor and processing lab.

Monitor the $2.5M budget for Task Order 2.

Created the Use Cases to developed workflows and lab protocols that were used by the sub-contractor and processing lab to keep the handling of the collected specimens and PII/PHI/III in accordance of HIPAA regulations. The Use Cases, workflows, and lab protocols were reviewed on a bi-monthly bases to ensure that everything was functioning properly.

Database Analyst

April 2006 – July 2007

oDevelop the data model, databases, reports, and websites using PHP/MySQL for the Reynolds Foundation Dallas Heart Study, a $15M program.

oMaintain the standard de-normalized database, create/extract normalized data sets based upon the requests from researchers.

oCreate tables and import data from outside sources into MS SQL server to combine with existing data to generate normalized data sets for researchers.

oCreate improved reporting processes to track cohort for future follow-ups by creating standardized reports using MS SQL SSRS.

oCreate action plan and timelines for the migration of the production database from MS SQL 2000 to MS SQL 2005 and relocating the production servers to the University’s Data Center.

oProvide technical support to the Reynolds Program Management Office and the DCC Staff.

oDevelop web application and database using PHP/MySQL for improved tracking of publications by Reynolds Investigators for the Project Management Office.

Technical Support Specialist I

June 2003 – April 2006

oReduced the billing cycle from nine months to three days for the McDermott Center’s DNA Sequencing/Genotyping Core by developing an on-line ordering system.

oCreated standardized and ad-hoc reports for Departmental Administrators for account reconciliations, budgeting, and statistical analysis of types of orders being placed.

oProvide IT support for the 80+ personnel of the McDermott Center.

oProvide training to new employees on the use of network shares and University email system.

oMaintain the websites for the McDermott Center and the Reynolds Foundation.

Infinity Partners - Contract Network/PC Technician

Consolidated Graphics – Systems Administrator

Regional Medical Center at Memphis – Systems Analyst

B&M Printing – Systems Administrator

Azo., Inc. – PC Technician/Network Assistant

November 2002 – January 2003

April 1999 – August 2002

1998 – 1999

1994 – 1998

1991 – 1994

E D U C A T I O N

Bachelors Degree in Business Management, University of Central Arkansas, 1988

ADVANCED SOFTWARE

Microsoft Access, Microsoft SQL Server, Microsoft SQL Server Reporting Service, Microsoft SharePoint, Microsoft Project Server, Microsoft Project Portfolio Server, Red Hat Linux, MySQL, PHP, Apache, VMware 4, VMware 5,Windows 2003, Windows 2008, and ASP.net.



Contact this candidate