Connie Hopkins

IT Systems Analyst - HSHS ST JOHNS

Chatham, IL 62629

acxidm@r.postjobfree.com - 217-***-****

Willing to relocate to: Bloomington, IL - Dallas, TX - Nashville, TN Authorized to work in the US for any employer

WORK EXPERIENCE

IT Systems Analyst

HSHS ST JOHNS - July 2016 to Present

• Process files through two payment posting systems for surrounding hospitals and various payers like UHC, Cigna, Aetna, Medicare, Medicaid and others. Ensure that files are processed and posted as designated.

• Support users on Passport and ClaimSource systems used throughout the HSHS hospital system. Respond to Help Desk Tickets through the HSHS Help Desk software support tools.

• Work on various projects as need determines with Management. Sr. Billing Analyst

IMPACT TELECOM - September 2015 to March 2016

• Vetted multiple billing cycles using Excel and SQL queries. Researching variables and presenting data to multiple departments within company.

• Worked on various projects relating to billing with IT. This was completed by using SQL to test on new billing elements within multiple systems.

• Participated in requirement gathering with various departments to implement new billing rates. IT Business Analyst

AMERICAN AIRLINES - April 2014 to September 2014

Contract Assignment)

• Review large data sets of billing from HP for all midrange and desktop servers.

• Vet billing data month over month using Excel VLookUp and creating Pivot tables, providing variances to all shared service Managers.

• Create monthly dashboard reports in Excel for IT Finance showing actual billed versus budgeted.

• Obtain server end of life reports from 5 major vendors, vet data, combine into one database in Excel and create spreadsheet reports and dashboard graphs and process to Share Point for management review.

• Update internal software program with new and decommissioned servers.

• Work with various shareholders and management to work through any questions or issues with data vetted. Data Analyst

ANCILLARY CARE SERVICES, INC - December 2012 to September 2013

* Imported client data files into either Excel or Access

* Scrubbed data for anomalies and errors

* Made corrections in data where necessary

* Processed scrubbed file through company software successfully

* Produced reporting in order to create presentations for Sales to present to client

* Analyzed final results for negative margin pricing

* Calculated pricing adjustments accordingly

* Maintained client data in systems to ensure processing of claims in correct and timely manner

* Oversaw other company projects as they arise in order to bring new clients on board Data Analyst

SEDGWICK CMS - July 2012 to December 2012

Contract Assignment)

* Performed data manipulation

* Provided data analysis on results

* Processed reports on findings for management

Environments:

* MS Excel, multiple insurance claims software company systems. Data Analyst

FRONTIER COMMUNICATIONS - October 2011 to January 2012 Contract Assignment)

* Created SQL queries to access the data on SQL Server

* Analyzed data between Verizon and Frontier billing systems, recognizing and correcting errors prior to system conversion. Reported to all levels of management.

Database Configuration Specialist

LPB ENERGY MANAGEMENT - February 2011 to July 2011

* Created Access databases for new clients through manual creation and downloads

* Provided accurate reporting from databases based on client requirements Pricing Analyst

MASERGY COMMUNICATIONS - August 2007 to January 2008

* Negotiated best pricing on circuits with 3rd party vendors prior to contracted sales

* Authored training manual for Pricing Analyst

* Trained new hires

Reporting Specialist

DIRECT ENERGY, LP - April 2006 to July 2007

* Processed all 3rd party vendor invoices

* Worked with team members and management, vetted invoices

* Created processes and procedures to ensure quality controls were maintained

* Created SQL queries to use in MS Access and V-Lookup in MS Excel producing monthly reports

* Reported on contractual SLA's monthly to all levels of management

* Created quality processes with Operations Team to ensure Vendors met contractual obligations Team Lead/Billing Analyst

TXU ENERGY, CAP GEMINI ENERGY - December 2001 to July 2005

* Analyzed pre-deregulation billing data to determine billing errors by initially created error reports, then researched errors and made changes in billing database

* Billed major clients for monthly energy used

* Created new clients in CIS billing system from post contract sales

* Instrumental in driving process improvements and creating new hire training material

* Trained new hires as required

Sr. Project Analyst, Sales Support

CITIZENS COMMUNICATIONS - August 1996 to December 2001

* Served as liaison with IT in the design and creation of Java based order and reporting system for Sales

* Analyzed monthly data loads from 8 external billing systems into data warehouse prior to utilizing data in newly created SCMS system

* Created ad hoc reports produced from data warehouse queries via SQL or Brio, downloaded into Excel and manipulated into reporting formats. These were done many times throughout the day based on user requests

* Extensive V-Lookup and Pivot table use in order to produce ad hoc reports Sr. Project Analyst, CABS External Inquiries

* Logged and completed 100% of all external research and billing inquiries

* Corrected all billing errors for 100% customer satisfaction within the Direct Sales organization

* Worked closely with Collections, processing monthly adjustments

* Initiated and completed audit resulting in 100% regulatory compliance and billing accuracy Sr. Billing Analyst, CABS

* Solved long distance billing issues by analyzing billing of circuits compared to Inter/Intra terrified rated and corrected errors in billing database tables

* Developed Switched Access training curriculum and manual

* Trained internal and external departmental employees. ADDITIONAL INFORMATION

TECHNICAL SKILLS

• SQL, BRIO Query, TOAD, MySql, MS SQL Server, Crystal Reports, MS Office-Excel, Word, Access, PowerPoint

Contact this candidate