Resume

Sign in

Data Sql Server

Location:
Fayetteville, Georgia, United States
Posted:
February 06, 2018

Contact this candidate

Resume:

TECHNICAL EXPERTISE

Languages:

PostgreSQL,T-SQL, PL/SQL, SQL* PLUS, C/C++,

Databases:

PGAdmin,Teradata, SQL Server 2008, SQL Server 2005, MySQL 5.0, Oracle 8, Oracle 9i

Platforms:

NetBeans,GlassFish, Linux, UNIX, DOS, WINDOWS, MACINTOSH, NT

Tools:

MS Access, Mercator5.0, SmartDB, WebEx, Vantive, Siebel 7.5,CSP, CSS, Toad, SQL Navigator, DBA Studio, SQL Loader, SQR, DM.net, Excel, Word, Jira, Confluence, Subversion

PROFESSIONAL EXPERIENCE

Legacy Data Access, Marietta, GA Jul 2015 – Sep 2017

Programmer/ Analyst

Developed web application that helps hospital retire their patient accounting systems

Developed views and function using PostgreSQL

Create new projects on NetBeans platform

Worked on numerous projects for clients like Wellstar, Partners, and Emory.

Data discovery prior to developing application screens

Develop and modify Crystal reports. Breakdown reports from other systems and re-engineer to work in PostgreSQL

Work directly with project managers to determine best approach for organizing and developing application to meet clients’ needs

Participate on client calls and application demonstrations

Perform QA on application and resolve issues

Provide customer support

AT&T, Atlanta, GA Mar 2014 – Feb 2015

Data Analyst

Extract, transform and load data using SQL in a Teradata environment

Work as a developer on the MARS ( Marketing Analytics and Reporting Source) and Metrics projects.

Ad-hoc reporting for all marketing clients

Host white boarding sessions with marketing clients

Enhance code performance to limit spooling issues.

Research data related issues

Prepare metadata for all assigned entities.

PRGX Global, Atlanta, GA Jul 2011 – Jan 2014

Business Information Analyst/Data Analyst

Develop programs for approved Medicare concepts for auditors according to edit parameters.

Perform analysis of edit parameters prior to developing programs.

Provide auditors with claim selection data for automated reviews, complex reviews, and semi-automated reviews.

Extraction of data from Healthcare Data warehouse using SQL Server 2008.

Create and modify views.

Modify and execute stored procedures.

Perform task in extracting DRG and Medical Necessity claims for Medicare wave process.

Work with Development group on implementation projects.

Perform UAT testing and give approval to deploy changes into production environment.

Configure concepts templates in UAT and production environments.

Provide support to audit's staff request for standard reporting, programming, data conversion, and special projects.

Prepare recoupment file from auditors for processing.

Use SSIS Import/Export Wizard to move large data set.

MedAssets, Alpharetta, GA Jul 2008 – Jul 2011

Senior Data Analyst

Use internal tools to load data for the Charge Capture Audit (CCA) product.

Process healthcare encounter data.

Prepare data for Comparative Rate Modeling (CRM) team.

Performs data scrubbing using MySQL, SQL Server 2005, SQL Server 2008, MSAccess and Excel.

Performs gap analysis on legacy system compared to new system.

Develop programs and complex queries in SQL Server 2005, SQL Server 2008, MySQL 5.0 to prep and load data.

Internal ETL tool to help automate client processes.

Use SSIS Import/Export Wizard to move data.

Performs weekly/bi-weekly data calls with clients.

Work closely with clinical consultants to ensure data quality.

Manage the integrity of data input and output and follow proper procedure to address any inconsistencies discovered.

Work closely with implementation managers to help manage clients' expectation.

Attend weekly/bi-weekly progress calls with client.

Responsible for high profile clients' data.

Mentor and train new associates.

Assist members of the team with troubleshooting data load issues.

Retrieve/Transmit data via secure FTP.

EDUCATION

Major: Computer Science - Florida International, Miami, Florida



Contact this candidate