JOAN CARRASCO

IT/Healthcare Professional

“Specialist in fast, accurate data compilation, analysis, application support, testing, and database reporting”

Highly motivated and skilled professional seeks position as a IT professional in health or business environment; ready for opportunity to apply nearly 10 years acquired database skills/applications systems skills to work in complex database/applications-driven organization; exceptional ability in application support techniques and data analysis, maintenance and coding standards; good people skills, management and training ability.

AREAS OF EXPERTISE

Database Control

Medical Data

Transplant Data

Clinical Research

Client Contracts

Reporting Tools

EMR/EHR Backup and recovery

14 years of medical gathering; collecting; analyzing

Open Source Ticketing Systems

Revenue Cycle Quality Assurance

Pharmacy Data

Utilization Review Data

Membership Data

Charge description master systems

Storage Structures

Clinical Applications Systems

Hospital Applications Systems

Clinical Trials Product evaluation and monitoring

Hospital Billing Systems

Clinic Billings Systems End user support, testing, and training/determine trends

Project Lead

Database Interfaces and Database Architecture

Transplant Application Systems

Transplant Database Troubleshooting and fine tuning

Accounting Application Systems Report generation and analysis/ad hoc reporting

Software Implementation

Requirements gathering

Pre-install Processes Supervisor Development/Training

DATABASE PROFICIENCY

PROVEN METHODOLOGY:

Compile and analyze data and generate reports of database processes

Consult on technical issues, Monitor database performance, fine tuning and troubleshooting

Identify, establish and support testing

Conduct research and prepare reports as required

Consistently promoted in organization and given increased responsibilities and workloads

TECHNOLOGY

SQL , Queries, Access, Enterprise Manager, SSRS, SSIS Preinstall Process and Database Architecture United Network Organ Sharing System, UNET

Database Interfaces

VSS/VB

ETL

Data Junction Automated Medical Billing/Credit Resolution

Elite Microsoft Office Suite

Monarch

Crystal Reports

CMS/Omega/Javelin

Cognos Reporting

SQL Server 2000

SQL Server 2005

SQL Server 2008 Patient Analysis & Tracking System (PATS)/ad hoc (Transplant Database)

AS400 system IBMRISC6000 (Signature)/Monarch

Mercury Test Director

Project Management

Crystal Reports Kronos

CAREER PATH

TECHNICAL/APPLICATIONS SUPPORT ANALYST APS June. 2009-July 2010

Major Functions: Responsible for the support and maintenance of DTE/Axiom/InHand BB Time Entry system for law firms; other assigned multi-tiered and desktop applications in use with the company as first, second and third level support and provide a high degree of diagnostic and resolution skills, playing a critical role in managing the escalation process for support issues. In addition, have significant exposure to more than 200 law firms worldwide; high level partners at the firm with critical issues including tasks related to identifying and troubleshoot software issues and resolution. Responsible for heavy telephone contact with clients; provides problem solving and analysis. Responsible for application testing, installation, and version control of applications; oversee open support tickets and take appropriate action to resolve the issue; collaborate with development to provide optimal solutions, monitor customer contacts to identify and communicate problem trends to team lead; communicate new troubleshooting techniques and information. Assist in new application technical training, procedural and tools overview. Work well with end-users in a time-sensitive, high pressure environment.

IT APPLICATION ANALYST Utiliquest Jan.2008-Nov. 2008

Major Functions: Responsible for the day-to-day maintenance of the application systems in operation, including tasks related to identifying and troubleshooting application issues and issues resolution or escalation. Responsibilities also include root cause analysis, management communication, vendor management and client relationship management in partnership with Infrastructure Service Support team members. Take calls/emails as necessary. Ensures all production changes are made in accordance with lifecycle methodology and risk guidelines. Provide business and operational analysis support for IT application solutions. Assists by providing technical solutions across applications, to insure reliability and improve performance. Provide problem solving and analysis of business and on-line software application issues on all aspects of user reported. Created ad-hoc reporting through SSRS. Act as a second/third level resource on assigned applications and others as needed. Assist in new application technical training, procedural and tools overview. Work well with end-users in a time-sensitive, high pressure environment. Ability to deal with frequent changes, delays, or unexpected events.

Promotion: PRODUCTION SUPPORT ANALYST- Matria Healthcare Dec. 2006-Jan. 2008

Major Functions: Responsible for managing ETL processes for multiple file types for all clients using Data Junction Map. Responsible for processing client data according to established process procedures, interpreting detailed instructions, interacting with other internal teams, documenting processed jobs, and ensuring job processing is carried out in a timely and accurate manner. Develops queries, DTS packages, and stored procedures, tables, to update and maintain databases containing critical client data using MS SQL Server 2000 & 2005

Research, analyze and recommend methods for improving information process flow and efficiency based on client needs. Responsible for designing, developing, and maintaining reporting tools used to provide information for management and executives. Develops queries designed to troubleshoot issues and determines appropriate action. Maintain daily focus on achieving and exceeding team and business goals; supports manager in achieving the teams’ strategic and tactical goals. Coordinated with the software developers and the certification team to ensure that Client provides exceptional service to partners and clients by developing the most efficient processes. Represent Client Production Team at meetings in support of process innovation, relationship development and client satisfaction efforts. Manage internal relationships with Software Developers, Certification Staff and other internal teams; understand the needs of other internal parties while effectively communicating opportunities and needs of the Production team.

Perform both roles

OPERATIONS ANALYST

Major Functions: Independently works with peers, data developers and data analyst in performing validation of various types of healthcare related data including medical claims, pharmacy claims, memberships and HRA’s. Ad-hoc research and predefined verification performed. Validates the accuracy of data conversions, assists in the review of the mapping documents for accuracy and compliancy against the company’s data standards; maintains defect tracking of data processing problems; maintains client historical trends and distributions for file feed comparison and performs translation of file layouts and data dictionaries to the actual content of files received. Created and executes queries to retrieve data sets for analysis, problem solving and resolution.

PROJECT LEAD/SUPERVISOR Ochsner Clinic Foundation Hospital, New Orleans, LA Aug. 2006-Dec. 2006

Major Functions: Supervises and leads the daily operation of all Assigned divisions within Transaction Services/Refunds/Collections in collaboration with the Department Manager. Supervise 15 non-exempt employees. Ensured quality production by monitoring departmental controls, employee professional standards, and the daily work routine of assigned personnel. Supervises, plans and organizes all Business function including staff development/training, purchasing and assists with the budgeting process.

DATABASE ANALYST/APPLICATION SUPPORT-Multi Organ Transplant Division, Ochsner Clinic Foundation Hospital, New Orleans, LA Jun. 1998-Aug. 2006-Promotion

Major Functions: Gathering and reporting on transplant patient data; drug trials, organ functionality; Managed Clinical and hospital systems within the Transplant Multi Organ Division; careful source document review; monitor data for missing or implausible data; performing required monitoring tasks efficiency; troubleshooting and analysis of data; training, testing and support of end users; installed, Implementation and supported applications/database/3rd party; progressive promotions to greater levels of responsibility through demonstrated competence in managing data and more complex database tasks; prepare accurate and timely reports; create reports and make recommendations for increased efficiency. Develops queries designed to troubleshoot issues and determines appropriate action. Responsible for designing, developing, and maintaining reporting tools. Validates the accuracy of data conversions, assists in the review of the mapping documents for accuracy. Responsible for processing client data according to process procedures, interpreting detailed instructions, interacting with other internal teams.

DATA ANALYST-Multi Organ Transplant, Ochsner Clinic Foundation Hospital, New Orleans, LA Jan. 1998- Jun.1998

Major Functions: Ensured accurate records of all patient data (transplant patient data; organ functionality; drug trials; medications protocol) monitored regulatory reporting compliances and prepared reports to regulatory agencies (UNOS, SEOF); data research (transplant patient data; medications) promoted to Database Analyst within 6 months. Performed validation of transplant data/DNA data. Maintained defect tracking of data processing problems; maintains client historical trends and distributions for file feed. Created and executes queries to retrieve data sets for analysis, problem solving and resolution. Ensure that data management methodologies include the controls necessary to consistently achieve high data quality. Work with non-matches, close matches as well as other exceptions and correct them as necessary. Perform record updates. Perform root cause analysis and resolve data management issues in collaboration with data owners in the business units. Provide data management advice for system development projects. Creation of Special Reports / Executive level system analyses (Adhoc / Monthly). Processed of gathering, modeling, and transforming data with the goal of highlighting useful information, suggesting conclusions, and supporting decision making.

BILLING SYSTEMS ANALYST Ochsner Clinic Foundation Hospital, New Orleans, LA Mar. 1995-Dec. 1997

Major Functions: Two years experience with automated medical billing; inspected and ensured complete and accurate application of billing codes; researched and analyzed accounts, especially denial reports, and determined corrections and changes as required; responded to needs of patients, medical professionals, insurance agencies, and others; managed client telephone relationships (up to 100 calls daily)

EDUCATION

ASSOCIATE OF SCIENCE DEGREE – MAJOR: ACCOUNTING

Delgado, New Orleans, LA

CHISP-CERTIFIED HEALTH INFORMATICS SYSTEMS PROFESSIONAL

Active pursuit of certification (December 2011); The Certified Health Informatics Systems Professional (CHISP™) credential indicates that a professional has met a defined set of skills-based competencies in health IT, health care regulations, computer science, medical insurance billing, information and data security, medical terminology and anatomy, operational principles in heath care, data-mining, reports, and queries, and technology in quality of care

BACHELOR OF BUSINESS ADMINISTRATION/MANAGEMENT

(Kennesaw University) Senior

Contact this candidate