Jessica Claire
  • Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
  • H: (555) 432-1000
  • C:
  • Date of Birth:
  • India:
  • :
  • single:
Professional Summary
Core skills include Design, Development, Testing and DBA activities using COBOL, CICS, JCL, DB2, DB2 utilities and VSAM, debugging skills in IBM Debugger (Batch / Online modules) Client / End User support to resolve data issues while using DB2. Performance tuning / issue resolution for various DB2 objects / SQL Queries Expertise on BRIO for generation of Usage Reports Worked in DB2 V8 to V9 Migration process Application-side testing. Preparation and conducting training programs for newly joined team members. Contribution towards practice by taking interviews, preparing best practices / scenarios document. Active participation in various organizational activities / surveys giving feedback.
  • Guest services
  • Inventory control procedures
  • Merchandising expertise
  • Loss prevention
  • Cash register operations
  • Product promotions
Work History
Associate Consultant, 11/2010 - 06/2014
Avtex Washington, ,
  • Wrote maintainable and extensible code in a team environment.
  • Worked closely with other team members to plan, design and develop robust solutions in a timely manner.
  • Interfaced with business analysts, developers and technical support to determine the best requirement specifications.
Associate Consultant, 09/2010 - 06/2014
Avtex Minneapolis, ,
  • HSBC Database
  • Directed software design and development while remaining focused on client needs.
SYSTEM ENGINEER, 02/2007 - 09/2010
Hcl Technologies Ltd. Apache, ,
  • Completed IBM 703-DB2 V8 Application Developer (Score
  • Prepared detailed reports concerning project specifications and activities.
Diploma: INSTRUMENTATION, Expected in 2002
MBA: Finance, Expected in 1 2011
Symbiosis University - ,
Finance BE (Computer) - 2005, Pune University, Pune (63.63%) DIPLOMA (IS) - 2002, MSBTE (77%) SSC - 1999, Pune Divisional Board (75%)
  • OHCB project is development of a new platform for processing the banking business of HSBC in mainframes Currently this project is in its SIT phase for Term Deposit and initial design for Lending.
  • As a part of one HSBC initiative HSBC is Developing new product named OHCB on Mainframes platform which will have all the existing functionality of it's existing core banking product HUB which is on AS400.
  • In conjuction with the current functionality of HUB, HSBC has decided to include additional functionality in the OHCB to meet One HSBC solution.
  • Currently 53 countries uses HUB as their primary banking system.
  • OHCB architecture is totally service based so that it remains very loosely coupled and can interact with other OH (One HSBC) financial product like OH payment, OH forex, OH cards , OHCDM etc easily.
  • This is the flagship project for HSBC and OHCB will be deployed in all the 85+ countries where HSBC is currently in business by year 2020.
  • 2.
  • IBM INDIA PVT LTD, Pune (System Engineer: Mar 2007 - Oct 2010) PROJECT: MIW (MARKETPLACE INFORMATION WAREHOUSE) Developer / DBA Apr 2009 - Oct 2010 Client : IBM, USA Tools : SCLM, RMDS, DB2 Admin Panel, Spufi, QMF, Brio.
  • Platform : Z/OS.
  • Languages : PL1, JCL, VSAM, DB2.
  • Database : DB2 8.0 / 9.0 Team Size : 7 Roles / Responsibilities: DBA Activities (Solving user queries, Loading / Unloading data, Authorization, Execution of Utilities) Change request estimation / updating and scheduling, project metrics management using RPM tool Active participation in Application design.
  • Responsible for Change Request Management, Code development / delivery Creation of BRIO Reports Unit testing and documenting unit test results.
  • Review of program specifications, unit test specifications and unit test results Production Support (L3) / Resolution of abends Description: Marketplace Information Warehouse (MIW) is a part of IW suite of applications.
  • MIW houses multiple sources of data and makes this data easy to use by cleaning, processing, linking, and further defining the data for faster delivery of information that is critical to the business needs of sales and marketing professionals.
  • Data is both licensed from external sources and compiled by IBM internally.
  • MIW receives External data from its Vendors.
  • MIW refines and process raw information received from different vendors into useful information, which is loaded to DB2 tables.
  • IBM sales and marketing team access this data using different online interfaces.
  • The information that MIW receives and process differ for different vendors.
  • PROJECT: LDW ESW Developer Apr 2007 - Mar 2009 Client : IBM, Germany Platform : Z/OS.
  • Tools : Spufi, QMF, Brio, DB2, TSO/ISPF Team Size : 2 Roles / Responsibilities: Responsible Application design.
  • Production Support.
  • Creating Report on BRIO depending on Requirements.
  • Scheduling the jobs in OPC.
  • DBA Activities.
  • Participate in project meeting.
  • Description: EBI (Enterprise Business Information) Operation includes three batches, one for each GEO (EMEA, NA and AP) running overnight.
  • The batches feed daily IDOCs from CBS located on SAP environment to S&D IW located on MVS/DB2 environment through FODS (Fulfillment Operational Data Store).
  • The LDW ESW is physically located on an MVS/DB2 environment in UK/Portsmouth - UK MVS TSOBA.
  • There will be no direct access to the LDW ESW system on TSOBA for the common users (key users and LCM have direct access).
  • Edge-On-Demand is used as a front-end tool with BRIO as the query tool behind.
  • It's a WEB based solution, which supports different formats (BRIO, HTML, and L123).
  • PROJECT: LDS (LEGACY DATA SYSTEMS) Developer Oct 2007 - Mar 2009 Client : IBM, Germany Platform : Z/OS.
  • Tools : Spufi, QMF, Brio, DB2, TSO/ISPF Team Size : 2 Roles / Responsibilities: Responsible Application design.
  • Production Support.
  • Creating Report on BRIO depending on Requirements.
  • Scheduling the jobs in OPC.
  • DBA Activities.
  • Participate in project meeting.
  • Description: The Legacy Data Store (LDS) as a logical part of the EDW consists of 12 tables.
  • It is a system which receives data from the Legacy Warehouse systems and stores it in the S&D Information Warehouse.
  • The whole transmission system consists of two parts: 1) The sending part on Legacy Warehouse Country side 2) The receiving part on S&D IW side For each sending system exists in the S&D IW one dedicated receiving System.
  • The sending and the receiving systems are developed as OPC job net running under MVS.
  • Each job net consists of several jobs, which usually executes one program, but there are also jobs executing more than one.
  • A program is a MVS/DB2 Utility or a PL/I Program.
  • Because up to 12 tables are fed, there are also 12 interfaces, each responsible for one target table.
  • Dependent from the target table, every interface has a specific layout and record format.
  • The two subsystems communicate with the help of a trigger file.
  • This file indicates that a sending action has successfully completed and the data can be accessed on the receiving side.
  • If no trigger file is received on the target side, no processing take place.
analytical skills, banking, CICS, COBOL-II, COBOL, client, clients, Database, delivery, documentation, ENDEVOR, English, File-Aid, functional, Hindi, IBM, DB2, DB2 8.0, DB2 9.0, IBM-MVS, ISPF, JCL, Languages, team building, Team Lead, Mainframe, MS-Access, Windows, News-Letter, OS, Developer, PL1, Coding, proposals, QMF, quality, Quest, reengineering, reporting, REXX, scheduling, SPUFI, SQL, TSO, UDB, VSAM
Additional Information
  • PERSONAL DETAILS Date of Birth : 20-08-1983 Sex : Female Marital Status : Married
  • Hobbies, Interest : Watching movies, Listening music Jessica Claire

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 scorecould 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

  • Clear Contact Info
  • Personalization
  • Strong Summary
  • Target Job
  • Typos

Resume Overview

School Attended

  • Symbiosis University

Job Titles Held:

  • Associate Consultant
  • Associate Consultant


  • Diploma
  • MBA

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

*As seen in:As seen in: