SUMMARY

• 10+ years of experience with relational databases, systems analysis, design, programming, and support.

TECHNICAL SKILLS

• SQL Server, SSRS, SSIS, T - SQL, PL/SQL, ETL, EPIC, PeopleSoft, Visual Studio, MS Office,
• Crystal Reports, ASP, VB, VBScript, VBA, Windows, UNIX Shell, MS-DOS Shell, and TFS.
• Strong analytical, problem solving, and interpersonal relationship skills. Supports end users and clients.

PROFESSIONAL EXPERIENCE

Data/ETL Analyst

Confidential

Responsibilities:

• Created data mapping for Claims Header and Details, Eligibility, and Providers from Trizetto to HealthX.
• Participated in Epic Chronicle Hierarchical Database transfers to Clarity Relational Database using bcp protocol.
• Designed complex SQL Query routines to ensure claims adjustment accuracy.
• Created SSIS packages to extract, transform, and load claims data to Cognizant Trizetto proprietary databases.

Confidential

Responsibilities:

• Redesigned SQL procedures for improved performance, for example, reducing run time of batch job from 40 minutes to 6.
• Trained development team members on advanced SQL coding strategies like Common Table Expressions, Cross Apply, and portable ANSI standards.
• Coded data validation logic to exclude and report invalid values within ETL process.
• Led review of column data types and implemented those changes within the data warehouse for efficient use of space and memory.
• Used MS Visual Studio for database project development and publishing across different SQL Servers.
• Added new ETL data flow tasks and column mapping using SSIS 2008.
• Controlled database source code versions and created work items to document progress using TFS.

Confidential

• Responsible for monitoring data updates for multiple clients to ensure the integrity of data, processed inbound and outbound data and rectifying errors that may occur.
• Researched inconsistent data loads and addressed issues
• Quality Audits outbound data files before moving to production jobs to ensure accuracy

Confidential

• Developed queries and excel documents for KPI dashboards
• Analyzed claims data, accounts payable, third party reimbursement
• Designed database integration processes for pharmacy management software and databases

Confidential

Responsibilities:

• Created, managed and updated database for donor records
• Built reports for donor relationship management

Confidential

Responsibilities:

• Designed various reports for class action claims processing services including paper and electronic claims
• Arranged analysis reports and be accountable to answer any SQL queries, complaints or proposal along with writing T-SQL queries
• Gathered data necessary to accomplish analysis from a number of sources
• Developed new SSIS and SSRS reports where suitable
• Completed numerous monthly reports and inform and change reports on request

Data Analyst

Confidential

Responsibilities:

• Prepare ad hoc data extractions, reports, and analysis summaries: review, troubleshoot, and correct database information, ensure incoming data meets database standards, and run eligibility and claims database update processes.
• Extensive use of SSRS and SSIS for automation the daily, weekly and monthly reporting to the client.
• Deliver data information to internal and external clients as required; analyze information requests and deliver accurate and timely data to requesting users or clients. Analyze and assist with programming computer systems to properly address client inquiries. Review data flow to determine problems affecting client eligibility and claim processing.
• Assist with departmental projects. Use computer systems to improve and enhance healthcare administrative services. Assist coding with T-SQL in MS Server environment. Participated in various data conversions.
• Assist in new and existing client set-up and maintenance processes. Communicate technical information to clients and users.
• Perform routine and ad-hoc data maintenance and updating functions and provide staff and users with assistance solving computer related problems. Identify nature of information processing to resolve computer related problems. Coordinate computer systems hardware and software to increase compatibility and enable information sharing.
• Balance data - ensure check run totals match reporting totals (monthly, quarterly, annually). Analyze computer and client data to confirm accurate processing. Develop summaries to ensure information is accurate.

Programmer Analyst

Confidential

Responsibilities:

• Designed various custom weekly and monthly reports using MySQL database and MS Access.
• Reports included warehouse inventory, equipment management, safety, and performance reporting.

Confidential

Responsibilities:

• Wrote SQL Server stored procedures and used SQL Server Reporting Services.
• Designed procedures that generate massive intelligent e-mailing and mail merge style reporting for selected set of claimants, sites, and incidents.

System Developer

Confidential

Responsibilities:

• Developed and maintained custom billing templates and billing interfaces using Whitehill Enterprise (version 5)
• Designed and maintained custom Confidential applications using MS Access and SQL Server.
• Created custom Confidential reports using SQL Reporting Services.
• Wrote stored procedures and ad-hoc queries to support the Accounting Department

Programmer Analyst

Confidential

Responsibilities:

• Designed Java Applications using J-Link for PRO/ENGINEER Wildfire to access internal components of PRO/E Session to customize models, parameters and exchange data with SQL Server 2000 Database and C, C++ functions to data output from and into PRO/E.
• Created various systems controlling data flow and updates using MS Office 97/2000/XP/2003 Automation. Participated in all phases of the development life cycle. The application is developed using C/C++, VB, XML, COM+, and MSSQL-2000 as the application database.