Data Analyst Resume

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Uploading school districts submitted Annual Financial Report (AFR) data and Annual Statement of Affairs data.
Calculation of the Financial Profile designation for each school district and drafting of the Financial Profile Report.
Calculation and drafting of the Special Education Revenue and Expenditure Report.
Calculation of each district’s Operating Expenditure per Pupil and the Per Capita Tuition Charge calculations.
Compilation of the Statewide AFR. Compiled from the summation of each district’s submitted AFR.
Calculation of the Indirect Cost Rate for each district.
Reconciling and uploading federal NCES and F - 33 Reports.
Heavy work in Access and Excel pulling data, reviewing and manipulating data into pdf reports.

Confidential

Data Analyst

Working with the CFO, and within the billing system and accounting guidelines, I worked on a project to determine when Billing items were within certain G/L codes
Pulled data from data warehouse with SQL, downloading into Excel and analyzing data within Excel to ultimately formulate reports for management
Some of also involved creating Access database and running queries within it

Confidential

IT/Billing Analyst (Contract Assignment)

Working in Remedy ticketing system and CSG billing system, assisted customer service reps in completing billing issues they were unable to process, initiated orders for new installations, terminations, changes from residential to bulk accounts and other scenarios as they arose.
Daily SQL work in BenThic writing new and executing pre-written queries to complete tickets.
Communicated with various departments within the corporation to complete jobs as needed.
After two months in this position, I was number two in completing the most tickets within a months’ time frame. After the third month, I was number one.

Confidential

IT Systems Analyst (Contract Assignment)

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

Confidential

IT Analyst/ Data/Billing

Utilizing SQL and Excel, vetted cyclical billing data, approving data through to Vendors for invoicing to customers
Worked on various projects relating to billing with IT, writing test cases, using SQL to pull data, scrubbing data fixing errors, running testing
Participated in requirement gathering with various departments to implement new billing rates and codes

Confidential

IT Business Data Analyst (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

Confidential

Data Analyst

Imported client claim 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 PowerPoint 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 database to ensure processing of claims in correct and timely manner
Oversaw other company projects as they arose in order to bring new clients on board

Confidential

Data Analyst (Contract Assignment)

Performed data analysis on claims data from multiple payers using Excel and internal tools
Researched and manipulated data as needed to process successfully through internal tools
Processed reports on findings for management

Confidential

Data Analyst (Contract Assignment)

Wrote SQL queries from Verizon data, vetting and identifying anamolies and making corrections, then mapped data back to Frontier Data Warehouse via SQL

Confidential

Database Configuration Specialist

Confidential

Pricing Analyst

Negotiated best pricing on circuits with 3rd party vendors prior to contracted sales
Authored training manual for Pricing Analyst
Trained new hires

Confidential

ReportingSpecialist

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

Confidential

Team Lead/Billing Analyst

Analyzed pre-deregulation billing data to determine billing errors by initially creating error reports, then researched errors and made changes in billing database using TOAD, running test case scenarios pre and post billing to ensure accuracy
Billed major clients for monthly energy used
From new client contracts, entered all data necessary in CIS from service initiation through to billing
Instrumental in driving process improvements and creating new hire training material
Trained new hires as required on systems and every aspect of billing from types of meters billed to components of rates and system

TECHNICAL SKILLS:

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