Data Analyst Resume

SUMMARY

An experienced IT professional with an extensive background in Software Development, Systems and Data Analysis and Quality Assurance and testing.
My solid understanding of the Software Development Life Cycle coupled with strong analytical and problem solving skills is an asset in meeting project deadlines and my passion for a quality product has resulted in substantial cost savings.

TECHNICAL SKILLS

SQL, ETL Tools, SSIS, SSRS, C#, UNIX, HTML, JavaScript, COBOL, QNXT, Diamond Healthcare, Visual basic
Visual Studio, Microsoft.NET FRAMEWORK, JIRA, EDI Transactions (837, 834, 835, 820, 999)
SQL Server, Oracle, Informix, Microsoft Access

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

Responsibilities:

Wrote business and technical requirements for a Cloud - based Data Management Platform implementation project.
Performed requirements gathering and gap analysis.

SQL Server Developer/Data Analyst

Confidential

Responsibilities:

Used SQL, SSIS and SSRS in the development of new processes.
Analyzed the root cause of complex data issues and provided effective solutions.
Analyzed data from a variety of sources including database tables and flat files for GAP analysis
Created data dictionaries and technical specifications.
Used backend testing for data validation

SQL Server Developer

Confidential

Responsibilities:

Used SQL, SSIS and SSRS to develop an automated reconciliation process.
Used SQL, SSIS and SSRS to develop Business Intelligence and Data Warehouse applications for Medicare Risk Adjustment Systems (RAPS)
Used SSIS and SQL to perform ETL processes
Analyzed and defined data requirements to support business processes.
Analyzed the root cause of complex production data issues and provided effective solutions.
Created test cases for UNIT and UAT testing

Technical Analyst/ Developer

Confidential

Responsibilities:

Used SSRS to create reports for claims, provider, member, clinical, pharmacy and financial data.
Used SQL for data Extracts, data validation and ad-hoc reporting
Converted business requirements into technical requirements.
Supported the implementation of EDI transactions (837, 834, 820, 277, 999, etc.)
Created detailed mapping documents for data conversion between legacy data elements and QNXT data elements
Analyzed root cause of complex production issues and provided effective solutions.
Created Test Cases for application testing.

SQL/SSRS Developer

Confidential

Responsibilities:

Used SQL to extract data from QNXT database tables.
Trained Developers and Business Analysts on QNXT database schema.
Used SSRS in the creation of HEDIS, enrollment, claims, provider, member, clinical pharmacy and ad-hoc reports.

Technical Analyst/ SSRS Developer

Confidential

Responsibilities:

Used SSRS to create Enrollment, Claims, Provider, Member, Pharmacy and Financial reports
Used SQL to extract data from QNXT database tables and to generate ad-hoc reports.
Worked with client and other stakeholders to identify application development solutions.

QNXT Technical Product Consultant

Confidential

Responsibilities:

Supported the Business in the implementation of QNXT Claims Payment System.
Gathered and documented business requirements for QNXT configuration.
Created mapping documents for new EDI transactions (837, 834, 820, 277, etc.)
Created detailed mapping documents between legacy data elements and QNXT data elements for data conversion of legacy files to QNXT database tables.
Used SQL and Microsoft Access to perform data analysis, data Extracts and ad-hoc reporting.
Scheduled and facilitated meetings.

Confidential

Sql Server Developter

Responsibilities:

Provided production support and maintenance for QNXT claims and enrollment related issues.
Analyzed, designed, developed, implemented and tested new applications.
Provided production support and maintenance of EDI transactions (837, 834, 835, 999,etc)
Performed data analysis, data mapping and data conversion
Use SQL, SSIS, Visual Basic and Microsoft Access to load Fee Schedules, code sets and third party files into QNXT database tables.
Converted business requirements into technical requirements.
Used Visual Basic to create a process that automated and provided more accurate testing of EDI 837 and 834 transactions.