We provide IT Staff Augmentation Services!

Database Associate Resume

4.00/5 (Submit Your Rating)

CAREER OBJECTIVE:

Seeking a challenging career with a growing organization which utilizes & enhances my skills and abilities for improving productivity and processes of an organization. This organization should mutually help me to grow professionally and personally.

EXPERIENCE SUMMARY:

  • 6+ years of experience in analysis, design, build and test phases for various Mainframe applications in banking and insurance domains
  • Expertise in all phase of SDLC working in onsite/offshore setup with multiple vendors using agile/waterfall methodology
  • Technological forte is Mainframe: COBOL, DB2, JCL and CICS.
  • Good interpersonal skills - good team player and Participated in business requirement workshops and end-to-end s/w implementation.
  • Experience in DB2 V8 & V9.
  • Expertise in performance tuning, debugging, root cause analysis and release management activities.

TECHNOLOGY SKILLS:

Programming Languages: COBOL, JCL, CICS

Operating Systems: MVS/ESA - Z/OS, Windows XP

Database System: IBM DB2, DB2 Stored Procedures.

Mainframe Utilities: TSO/ISPF, FILE-AID, JOBTRAC, CHGMAN, INFOMAN, SPUFIIBM Utilities like QMF, EZYTRIEVE, SORT, XPEDITOR and ENDEVOR.

Quality Tools: HP Mercury Quality Center, HP Quick Place, Microsoft Visual Safe Source

PROFESSIONAL EXPERIENCE:

Confidential

Database Associate

Responsibilities:

  • Analyze the Business Requirements
  • Created high Level Design Document, Tracking and planning.
  • Coded and tested (coded COBOL - DB2 program to fetch the customer details from DB2 Database based on the standard
  • Input layout and send it to different vendor.
  • Tested and coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project. Implementation and Support.

Confidential

Database Associate

Responsibilities:

  • Analyze the Business Requirements Created high Level Design Document, Tracking and planning.
  • Coded and testing {coded COBOL - DB2 program to fetch the customer preferences
  • And get the template from the program and send the alerts to the customer}
  • Created jobs in JCL language to call the program and to provide input and output Data.
  • Tested and coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.
  • Production Implementation and Support.

Confidential

Database Associate

Responsibilities:

  • Analyze the Business Requirements
  • Created high Level Design Document, Tracking and planning.
  • Coded new jobs and installed in to production.
  • Analyze the existing program and make the required change and document the change with test results.
  • Integrate with other applications to verify data is consistent through all the applications. Production Implementation and support

Confidential

Database Associate

Responsibilities:

  • Analyze the Business Requirements Created high Level Design Document, Tracking and planning.
  • Created a new JCL, to execute FILE-AID and SORT to get the input data for the new program.
  • Coded New Program to fetch the data from table and check the status and delete the data from DB2 Database.
  • Production Implementation and support

Confidential

Database Associate

Responsibilities:

  • Analyze the Business Requirements Created high Level Design Document, Tracking and planning.
  • Created a new JCL, to execute FILE-AID and SORT to get the input data for the new program.
  • Format the output and send the results to other team to process the emails.

Confidential

Database Associate

Responsibilities:

  • Analyze the Business Requirements Created high Level Design Document, Tracking and planning.
  • Coded new jobs and installed in to production.
  • Created new tables to store international customer choices and preferences.
  • Programming Stored Procedures to Fetch the details of the international customers.
  • Integrate with other applications to verify data is consistent through all the applications. Production Implementation and support

Confidential

Database Associate

Responsibilities:

  • Analyze the Business Requirements Created high Level Design Document, Tracking and planning.
  • Created a new JOB, toexecute the program with all the necessary inputs.
  • Created a new COBAL-DB2 program to check the CTDB (Communication Tracking Database) and find customers those
  • Those who not visited the site and trigger the Emails for the same.
  • Production Implementation and support

Confidential

Database Associate

Responsibilities:

  • Analyze the Business Requirements Created high Level Design Document, Tracking and planning.
  • Worked with DB2 Data Management Team to get the replication details Set and Create the required JCL in Test region to Test the data. Check the Database for any changes and Implementation.

Confidential

Database Associate

Responsibilities:

  • Analyze the Business Requirements Created high Level Design Document, Tracking and planning.
  • Created a new JCL, to execute FILE-AID and SORT to get the input data for the new program.
  • Create the New COBOL-DB2 program to get the details form the Data Base and trigger the emails for Old/New Email Add.

Confidential

Database Associate

Responsibilities:

  • Generated report like Alerts Report, CTDB Reports, Business Reports.
  • Clarifying the AD-HOC request queries.
  • Produced reports with statistics of production tickets, enhancements on a monthly basis and presented to
  • Customers on a weekly basis.
  • Participated in review activities and deliverables.
  • Attended training programs on various Confidential Business.

We'd love your feedback!