Jessica Claire
, , 100 Montgomery St. 10th Floor (555) 432-1000,
Professional Summary

Motivated versatile systems Analyst with 11+ years of IT experience. Proficient in tracking application defects and providing swift resolutions. Diligent, forward-thinking and adaptable to dynamic company, customer and project needs. Expertise in Eligibility, Claims adjudication, Claims Data exchange and PBM healthcare domains. Well-versed in Healthcare project planning and deployment.

  • Universe Basic Programming
  • Python Programming
  • UDB DB2 Database Knowledge
  • TDD expertise using MVTest testing tool
  • Process Improvement
  • Healthcare Knowledge on Claims Adjudication, Eligibility, Claims Data Exchange and PBM.
  • Agile expertise
  • Production support experience
  • Research and Technical Analysis
  • Requirements gathering
  • Documentation abilities
  • IBM RTC - Source Code control system
  • Microsoft Office
  • API design knowledge
Work History
06/2017 to Current System Analyst/Application Developer Meritain Health An Aetna Company | City, STATE,
  • Been an active part of ITPR process gathering project requirements, defined project scope.
  • Provided estimation of development hours for healthcare projects in Eligibility, Claims, Claims data exchange and PBM portfolios.
  • Created high level design and architecture diagrams, with solution to the business problems.
  • Created visual models for Current and future states of application.
  • Created design documents to bridge the gap between business and IT.
  • Provided agile stories breakdown for development.
  • Assisted in Development, End to End testing and implementation. Improvise design as needed.
  • Monitored system performance and analyzed on areas of improvement. Coordinated with Engineers for performance improvement.
  • Developed and implemented personalized client solutions using Universe Basic programming language expertise.
  • Created software applications in test-driven development (TDD) environment


  • Designed and created software application to load and create client specific Logos that are used in the letterheads of EOBs and Member statements, saving multiple hours of development.
  • Played a key role in analyzing and implementing Test driven Development using new MVTest tool at Meritain.
  • Played a key role in Realtime Pricing project for integration between Meritain claims adjudication system and Aetna Pricing engine.
  • Created proof-of-concepts for RESTful connection between Meritain claims application and Integration API.
  • Created Proof-of-concepts for generating JSON using UDO objects in Universe Basic.
  • Collaborated with Technical architects and Database Administrators to create scalable setup for the Realtime pricing setup
  • Working on design and implementation of Transparency in coverage at Meritain, in collaboration with HealthSparq.
11/2012 to 02/2013 Project Lead - DBA Level 2 Support Team Target Corporation | City, STATE,
  • Responsible for the stability of Database environments and maintaining SLA above 90%.
  • Created project management reports and presentations based on CMDB data using MS Excel, powerpoint and Visio for higher management.
  • Represented the team and Coordinated with multiple stake holders on high severity and Global issues.
  • Analyzed and provided resource estimation for new support projects.
  • Coordinated transition between Build and support teams for newly built databases and provide support acceptance sign-off.
  • Validated and fixed missing Database alerts, licenses, database configurations, Database capacity management in preparation for peak season across all the production and stage databases.
  • Trained the support team on new databases and advance database features that are implemented – like SQL Server - Database Mirroring, file streaming, Table partitioning, ‘Always On’ Availability.
03/2011 to 11/2012 UDB DB2 Level 2 Support DBA Target Corporation | City, STATE,
  • Administered, supported and monitored UDB LUW DB2 database issues that including breakfix and proactive monitoring of Databases used by applications in BI portfolio.
  • Monitored and fixed issues with Database maintenance jobs like full DB backups and Runstats.
  • Analyzed database backup history data (weekly) and created reports using MS Excel pivot tables and Macros for identifying backup performance.
  • Validated Database heartbeat monitoring alerts and fixed database issues.
  • Modified DB2 Governor Settings, based on the analysis of application query and environment needs.
  • Monitored and prepared weekly report on the database full backup for critical databases.
  • Created PMRs and worked with IBM DB2 Support for unresolved DB issues and for fixes during Database patching and upgrade.
  • Identified root cause of the problems and implemented fixes during outage windows.
04/2006 to 03/2011 DB2Connect Administrator - Support and Upgrade Target Corporation | City, STATE,
  • Planned and organized Enterprise wide DB2 Connect upgrade (versions V8 FP13 to V9.1FP4 and V9.5FP1) on Unix and Windows platforms.
  • Prepared project plan using MS Project, Visio and Powerpoint and present it to higher management and stakeholders.
  • Analyzed the impact of DB2Connect upgrade, Coordinated with Web Application Services and application teams for planning Outage window and schedule upgrade.
  • Coordinated with Java Technology leadership team, Websphere Application Services and IBM DB2 Support to brainstorm on the recommendations to convert DB2 JDBC Type 2 driver to JDBC Type 4 driver on Target Unix applications during DB2Connect upgrade.
  • Analyzed and tuned DBM CFG and DB2set parameters for DB2Connect V9.5 FP1 and incorporate in the upgrade scripts.
  • Prepared and executed shell scripts for the upgrade during the outage window.
  • Provided technical consultation for Infrastructure projects needing db2connect changes, including DB2 Connect install for new projects.
  • Analyzed the DB2Connect Version or patch to be applied for application performance issues.
  • Identified, updated and tested the Sudo commands for DB2Connect Install, upgrade and uninstall.
  • Coordinated with Access Provisioning and Server Tech teams for Sudo file deployment.
  • Administered DB2connect Master catalog script in sharepoint and update with new db information.
  • Organized Enterprise wide IBM Datastudio developer tool upgrade (desktop and Citrix packages).
Expected in 05/2005 Bachelor of Engineering | Electronics And Communications Engineering Anna University, Tamil Nadu, GPA:
  • DB2 UDB V8.1 Family Fundamentals Certification DB2 V8 for Linux, Unix and Windows
  • DBA Certification DB2 V9 for Linux, Unix and Windows DBA Upgrade Certification

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy


Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:


resume Strength

  • Formatting
  • Length
  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended

  • Anna University

Job Titles Held:

  • System Analyst/Application Developer
  • Project Lead - DBA Level 2 Support Team
  • UDB DB2 Level 2 Support DBA
  • DB2Connect Administrator - Support and Upgrade


  • Bachelor of Engineering

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: