Healthcare Data Analyst Resume
Detroit, MI
OBJECTIVE:
To take on new opportunities and experiences where I can utilize as well as expand my skills and knowledge of database, programming, data analyst and business concepts.
TECHNICAL SKILLS:
Programming Languages: SQL, TSQL, Java, C++, C#, HTML
Application / Development Tools: Visual Studio, Eclipse IDE, PowerBuilder 12.5, NetBeans IDE, JIRA, Android Studio, iDashboards
Database / DB Tools: MYSQL Server, Microsoft Access 2010, Oracle Database Expression 11g, Oracle SQL Developer, Microsoft SQL Server 2008, Sybase Central 6.1.0, Toad, PostgreSQL
Desktop Tools: MS Excel, MS PowerPoint, MS Publisher, MS Outlook, MS Word, MS OneNote, MS Visio
Performance / Other: Operation System Design Concepts, Troubleshooting, Debug and Testing, Error and Exception Handling, SQL Performance and Tuning, Relational Database Model, Entity Relationship (ER) Model for Conceptual Database Design, Database Schemas, SQL Normalization, Data Visualization, Java Documentation, Data Structures and Algorithms, Object Oriented Programming, Use Cases, Web Application Development, Block Programming, Virtual Machines
Operating Systems: MAC, Windows, Android, Linux - Ubuntu
PROFESSIONAL EXPERIENCE:
Confidential,Detroit, MI
Healthcare Data Analyst
Responsibilities:
- Represented BHPI at Great Lakes Business Intelligence and Big Data Summit located in Troy, MI
- Took part in extraction, aggregation and quality assurance of data from multiple sources in support of performing operational reporting, client reporting, and quantitative analyses of utilization and healthcare costs
- Executed and verified report data in regards to claims (EDI), insurance, population, treatment plans and other funding/financial data
- Designed and implemented reports for Healthcare Accreditation, NCQA (National Committee for Quality Assurance)
- Collected data from the Michigan Health Information Network (MWHIN) system for reporting purposes
- Collaborated with PCE Systems a provider of Electronic Health Record (EHR), to ensure claims and health data accuracy for reporting purposes
- Used PCE System fully hosted “SaaS/ASP” software (DASH) for data accessibility including care management from initial intake assessment and plan development to treatment, integrated health management, discharge, and billing
- Displayed knowledge of Microsoft SQL Server 2008
- Applied knowledge of SQL table joins, DDL, DML, pivots, views, constraints, and functions to Microsoft SQL Server 2008
- Utilized Microsoft Access 2010 to link with SQL Server 2008 database in creation of multiple internal/external reports
- Practiced transforming reports into interactive business intelligence dashboards using iDashboards software for data visualization purposes
- Worked closely with all levels of stakeholders to quickly develop reports, used for quality reviews, billing and other desired outcomes
- Review problems or errors and recommend changes to workflow procedures and/or system modifications as required
- Demonstrate high proficiency with Microsoft Excel including charts, pivot tables, VLookup/HLookups, and other excel functions
Confidential, KY
Software Developer
Responsibilities:- Attended NTT Data Summer Training Program at the NTT Data Global Delivery Center in Confidential, KY
- Java Training Course
- SQL Development Training Course
- IT Consulting Training Course
- Upon completion worked as part of NTT Data Global Deliver Development Team at the following client location:
Confidential,MI
Responsibilities:- Participated in full software development lifecycle for Pharmaserv Software
- Experienced Agile software methodologies, development models and processes
- Used JIRA for bug / issue tracking and project management purposes
- Proposed and implemented solutions to fix bug/errors within product code using PowerBuilder 12.5
- Created new feature to be utilized in new version of Pharmaserv Software
- Created test in regards to claims/billing utilizing the Pharmaserv point-of-sale system
- Configured, Built/Set-up, Backup and Reimaged Dell 2900 and Dell T410 servers for Confidential client and production purposes
- Gained knowledge and experience of Sybase Central 6.1.0 for database management
- Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes
- Obtained NTT Data Basic Pharmacy Certification
Confidential,Atlanta, GA
Independent Contractor
Responsibilities:- Assisted in set up, configurations and builds of servers
- Assembled and De-assembled network closets and computer equipment at several Atlanta based company locations such as AT&T and Fidelity Bank
- Performed other related duties as assigned
Confidential,Decatur, GA
Technical Account Manager
Responsibilities:- Implemented SQL knowledge using Oracle SQL Developer 3.2.20.09 daily for database management and database manipulation
- Used SQL to complete complex table joins within database to create reports for clients
- Gathered intel from clients to suggest potential new feature / product upgrades
- Processed client payments via phone
- Assisted production team with web interface design and tier one technical issues
- Served as one of the primary contacts for technical and business related issues for several accounts
- Managed multiple projects including the creation, implementation, and execution of a QA Project (Quality Assurance Project)
- Experience with CRM tool to help manage daily functions
- Trained clients on web-based software
- Interacted directly with clients via email and phone inquires
- Gained knowledge of Project Management practices and methods
Confidential,Lawrenceville, GA
Help Desk - Library Student Worker
Responsibilities:- Interacted directly with clients via email and phone inquires
- Enjoyed daily face to face interactions with assisting students/professors/guests in using computers, copiers/scanners, and fax/printers
- Updated hardware and assisted with software installs on both patrons’ and school’s PC and MAC computers
- Performed basic troubleshooting using MAC and Windows OS
- Reported technical problems such as hardware/software failure using help desk ticket
- Answered all incoming phone calls to the GGC Help Desk and walk-up questions from students/professors/guests
Confidential,Norcross, GA
Summer Intern
Responsibilities:- Worked on database updates, correcting errors, and adding data entry using Microsoft Excel 2010
- Performed new desktop configuration on PC computers for future clients
- Attended company staff meetings and group discussion with company Chief Executive Officer (CEO) and Chief Information Officer (CIO)
- Designed templates for marketing division for managed service contract options by comparing to other IT Support Companies using Microsoft Publisher (2013)
- Researched software for hardware monitoring, and merchant service options to implement into accounting software
Confidential,Atlanta, GA
GGC Alumni Liaison
Responsibilities:- Women in Technology is an Atlanta-based group that develops and promotes women for success in technology in Georgia
- Advocated to helped push for increase in Information Technology majors among GGC’s female students as well as participated in a number of WIT Events.
- Participated in Workshops designed to provide exposure to simple application development and software testing
- Build skillset for teamwork development
Confidential,GA
Administrator
Responsibilities:- Valued working to help to encourage goals such as increasing the number of students who persist in an IT major or minor, particularly those underrepresented in computing
- Implemented and design workshops for an Android Mobile App building program called MIT App Inventor
- Trained students to used block programming to create functional mobile apps to test on tablets and android phones
- Provided student driven technological support for GGC outreach initiatives and introductory STEM courses
- Represented GGC in two STARS/IT-ology 2013 Conferences held in Atlanta Georgia