Experience

Universal American

• Insurance
• 300 - 400 Employee

• Reporting Analyst

  • Nov 2012 - Present

  • Co-developed the rewrite of the Appeals and Grievances tracking application in MS Access. • Delivered numerous mock and official audit ODAG reports using SSRS. • Wrote SSIS packages to handle annual HPMS audit submissions. • Developed and maintained an SSIS package to transfer active members from their 2015 to 2016 plans and to ensure they received new health insurance cards. • Became a subject matter expert on Appeals and Grievances reporting and mentored other developers • Co-developed the rewrite of the Appeals and Grievances tracking application in MS Access. • Delivered numerous mock and official audit ODAG reports using SSRS. • Wrote SSIS packages to handle annual HPMS audit submissions. • Developed and maintained an SSIS package to transfer active members from their 2015 to 2016 plans and to ensure they received new health insurance cards. • Became a subject matter expert on Appeals and Grievances reporting and mentored other developers



The Rothwell Group

• Hospitals and Health Care

• Business Analytics Consultant

  • Feb 2012 - Aug 2012

  • Developed SSRS reports that provided operational data to multiple clients. • Resolved support-related issues by developing and testing T-SQL scripts. • Performed data cleansing exercise of more than 10,000 records using an in-house utility. • Assisted other development efforts by testing new features for the software release. • Developed SSRS reports that provided operational data to multiple clients. • Resolved support-related issues by developing and testing T-SQL scripts. • Performed data cleansing exercise of more than 10,000 records using an in-house utility. • Assisted other development efforts by testing new features for the software release.



Texas Medical Center

• United States
• Hospitals and Health Care
• 100 - 200 Employee

• Application Support Analyst

  • Mar 2010 - Nov 2011

  • Supported customers by creating, tracking and documenting solutions in a support database and by monitoring the support queue. • Oversaw all aspects of business group applications including security, reporting, training and performance. • Analyzed information to determine, recommend and plan installation of new systems or modification of an existing system. • Developed and maintained appropriate custom responsibilities and security for all end users within TMC’s applications. • Served as an ITS representative on project teams for the support and maintenance of applications. • Supported the ITS department by participating in an on-call rotation.



Sogeti

• France
• IT Services and IT Consulting
• 700 & Above Employee

• Consultant

  • Nov 2006 - Jan 2009

  • Involved in a number of change management activities, including User Acceptance Test Cycles, business process adoption. • Diagnosed and resolved day-to-day live system issues, predominantly through investigation at the database level (Oracle 10g). • Recorded and monitored all issues raised, providing feedback to the business users as required. • Acted as liaison with other support/development teams in London to resolve cross system issues. • Involved in a number of change management activities, including User Acceptance Test Cycles, business process adoption. • Diagnosed and resolved day-to-day live system issues, predominantly through investigation at the database level (Oracle 10g). • Recorded and monitored all issues raised, providing feedback to the business users as required. • Acted as liaison with other support/development teams in London to resolve cross system issues.



Bridgeway Software

• United Kingdom
• Software Development

• Quality Assurance Analyst

  • May 2000 - Dec 2003

  • Developed test scripts/plans for validation testing two n-tier client/server product suites. • Performed functionality, compatibility, reliability, performance, security, regression, and related testing within a release-cycle format. • Developed T-SQL and PL/SQL scripts to perform data validation testing. • Developed test scripts/plans for validation testing two n-tier client/server product suites. • Performed functionality, compatibility, reliability, performance, security, regression, and related testing within a release-cycle format. • Developed T-SQL and PL/SQL scripts to perform data validation testing.