SUMMARY:

• Senior level IT Data Analyst with over 15 years’ experience across diverse industries. Seeking an opportunity to bring expertise in systems & data analysis, database configuration and database management to drive the deployment of applications, business processes, business operations and system solutions. Highly analytical and detail oriented with a documented track record in full software development life cycle (SDLC) methodologies and Agile techniques.

TECHNICAL SKILLS:

• Strong Analytical and communication skills
• Proven experience in database management, systems & data analysis, data configuration & implementation, and SQL programming
• Appreciates challenges and steep learning curves
• Self - starter, goal driven, innovative thinker, and detail oriented
• Software Testing Life Cycle (SDLC)
• Basic Knowledge in: C/C#, Java, Ansible, R, RStudio, Tableau, Notepad ++, Anaconda3, FileZilla, Python, HL7
• Expert in: AS/400 (ICOMS); ETL, SSIS, iSeries System Storage, iSeries Navigator, SQL, SQL Server 2014 Management Studio, SEQUEL Viewpoint, MS SQL, SDLC, EHR construction, EHR configuration, HER System requirements. Altiris, Microsoft Access, All Microsoft Office tools, A+ Certification
• Fluent in: Desktop and laptop repair, Internal components installation, Software libraries maintenance, LMS, SaaS, PaaS, IaaS, process mapping, data profiling, and Enterprise application integration, Linux, WebEx and web conferencing tools, software packaging, release automation

PROFESSIONAL EXPERIENCE:

Confidential, RALEIGH, NC

Clinical Data Analyst

• Work with integration analysts to validate, analyze, codify and normalize clinical data from a variety of electronic medical record (EHR) and vendor types (Athena, Epic, AllScripts, NextGen, Medinformatix, McKesson PP, etc).
• Analyze issues of data integrity, to ensure data is accurate and that it meets standards of rigor for analysis and dissemination.
• Construct clinical quality measures and verify measures pre-loaded from our vendor software via SQL.
• Build the measures, quality test the measures via SQL, work with IT to move the measures from dev to production and coordinate regular production job runs.
• Validate each practice’s measures via SQL, working with practices to identify their coding patterns that lead to low measures or updates required in our measure constructs. As appropriate work with project coaches to help them learn to identify likely causes of issues and run first level problem checking.
• Serve as key project member, coordinating team definitions of new measures, reporting on issues, conveying measure confidence across the hundreds of practices and ensuring confidence in the reported measures.
• Manage data within the CareCentral/BIC UI database and work within project timeline to meet reporting deadlines.

Confidential, RALEIGH, NC

Lead Data Analyst

• Analyze EHR’s, Provider credentialing data, Optical benefit coverage, ICD9 and ICD 10 codes and clinical work flows to ensure the accuracy and efficiency of system requirements.
• Extract data from database by developing database objects, including tables, views and materialized views to generate complex queries for comparison data set construction
• Transform and Configure data to meet system specifications
• Develop database objects, including tables, views and materialized views using SQL
• Provide advanced analytical support for business operations in all or some of the following areas: claims, provider data, member data, clinical data, HEDIS, pharmacy, external reporting
• Design and develop schema data models using MS Excel, Access, SQL, and/or other data ware house analytical tools
• Coordinate statistical data analysis, design, and information flow
• Make frequent recommendations for data standardization and usage to ensure data integrity
• Integrate data into productive system using SSIS tool
• Perform data validation to ensure validity and accuracy of configuration activities.
• Analyze NPI (National Provider Identification) database to verify and assist in the creation of new medical providers.
• Manage, maintain, and update vision benefits, fee schedules, payment schedules, claims processing, provider data, and EHR’s
• Open, close, update, and manage ticketing system to track open issues and projects

Confidential, MORRISVILLE, NC

Senior IT Data Operations Analyst

• Established compatibility with third party software products by developing program for modification and integration.
• Developed and implemented complex Internet and Intranet applications on multiple platforms.
• Coordinated with systems partners to finalize designs and confirm requirements.
• Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
• Diagnosed and troubleshoot AS/400 and Windows processing problems and applied solutions to increase company efficiency.
• Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
• Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.
• Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
• Streamlined and enhanced the corporate operations system.
• Built application platform foundation to support migration from client-server product lines to enterprise architectures and services.
• Designed strategic plan for component development practices to support future projects.
• Consistently met deadlines and requirements for all production work orders.
• Managed creative projects from concept to completion while managing outside vendors.
• Independently designed and executed company database for infrastructure support and development.
• Designed and implemented new data standards for core business services.
• Developed data architecture design to enable analysts to perform targeted customer analysis.
• Recommended architectural improvements, design solutions and integration solutions.
• Provided methodologies for object-oriented software development and efficient database design.
• Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.
• Advocated for end-users to perform testing and problem analysis for server, desktop and IT infrastructure work.
• Trained junior members of IT team regarding data definitions, data implementation, database configuration and troubleshooting of data circuits.
• Serve as primary point of contact in creating database structures, tables, views, and indexes based on user requests over various departments across the region.
• Manage databases to ensure all commercial databases are backed up and maintained. Manage commercial billing system and customer accounts to ensure functionality for end users.
• Create, review and maintain process and system documentation based on quality standards and system compliance of implemented technologies in an effort to provide, interpret and present technical information and resolutions to system based issues to internal clients.
• Exemplify effective communication skills as well as project management skills to apply logical and analytical thinking to aid in proper understanding of system issues and expected resolutions by executives, committees and boards of directors.