Data Analyst Resume

PROFESSIONAL EXPERIENCE:

Data Analyst

Confidential

Created analysis tools to estimate past, current, and future risk scores for physicians to maximize the earning potential for the company while providing excellent member care. Generated reports to account for risk adjustments in the market place. Analyze per member per month premiums for each line of business and for individual providers. Work with multiple departments to communicate the information to the providers.
Set up procedures to create a master member information in order to create accurate membership statistics.
Created Tableau reports to forecast future risk for claims issues.
Identified business rules and standardizations for data transformation and discovery purposes.
Ability to juggle multiple tasks and help my coworkers meet their deadlines by providing crucial data information.
Created the entire reporting structure for company including executive dashboard, financial reports, data quality audits, business intelligence, and dashboard reporting.
Provided DBA functions in SQL server including adding permissions, importing and exporting data, scheduling jobs, and writing stored procedures.
Used ETL techniques to create physician scorecard. Created the data structures, imported, transformed and loaded the data.
Created data imports and exports for data integrity analysis.
Worked with finance team to recover misallocated funds and determine a reimbursement schedule.
Worked with management to choose the most cost effective reporting tool for the company.
Created Tableau dashboard to monitor claims errors.
Created a series of financial reports to be able to pay our clients on a monthly basis. I worked closely with the finance department to ensure financial accuracy and created audits to ensure integrity of financial reports.

Data Analyst / Programmer

Confidential

Wrote complex stored procedures used to create back end data structures for
Managed the design web based applications working with the end users to create applications work flow. Analyzed business process requirements and information data flow. Managed project scope in order to deliver application on schedule.
Developed web based applications. Worked with team members to generate standard data entry screens. Considered user input for ease of use. Designed needed database structures for the database. Created scripts to transfer and clean legacy data into new data structures.
Designed and implemented a data driven reports used to manage staff based on their level of performance. The reports were designed using Jasper reports and run monthly against an Informix database. Used a nightly script to populate a data mart for high level statistics.
Performed multiple data migrations in order to support reports conversions.
Used five different reporting tools and worked to migrate all of the solutions to one project without losing end user functionality.
Developed Versata applications using Java code to create applications for Appeals, Investigations, and Equipment Tracking.

TECHNICAL SKILLS:

Java, Versata, Groovy Script, Informix, SQL, Stored Procedure Language, UNIX, x - reporter, WebFOCUS, Jasper Reports, Crystal, Access, Excel, ITIL, Business Process Management, Blue Works, IBM Lombardi, SQL server, Business Intelligence, SSRS, XML, Tableau, SSIS

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship