Project Sql
Resume:
Mohan Rajamani
============================================================================================================
Professional Background
Senior IT Professional with proven history of Design, Development, Testing, Quality Assurance, Implementation and Maintenance of software systems on SQL, DB2, Mainframe environment and J2EE / .Net technologies. A true team player who works well in both structured and unstructured environments. Twenty five years of detailed experience including full life cycle. Programming, design, analysis, documentation, hardware, management, user training and support. Define and proposing technical strategies, Discussion with stakeholders, resolving technical issues as an architect. Techno Functional Business Analysis role in Auto/Commercial Insurance, Asset Management and Credit Card Collections applications for 5 years.
Technical Skills
Programming Languages: VS-Cobol-II, Eazytrieve Plus, SAS, Telon, Focus, MF-COBOL , JCL, JavaScript, HTML, CICS, COBOL 370, SQL, PL/1, Assembler, CA7, DHTML, VSAM, IMS, IDMS, Platinum Utilities ,CA7, ZEKE JOB Scheduler, XPEDITOR, DB2 Utilities, HP Quality Center, Visio, ELIPS, Niku Time Sheet, Control-M Lotus notes, CICS Web Services, HTTP,SOAP,IBM Debug tool, RACF, File-AID, Job Track, Intertest, Expeditor, Unix, Peregrine Service Center, IBM Websphere, DB2 Stored Procedures, IBM ClearQuest, SOA, IBM Content Manager,CA-Erwin,APPC/LU 6.2
Integrated Development: DB2 Databases, Microsoft SQL Server 2000, IBM Rdz 7.6, MS-Access
Source Control: Microsoft Visual Source Safe, Endevor, ChangeMan, PanValet
Databases: DB2, IDMS, MS-ACCESS, IMS/DB, Oracle 8i, FOXPRO
Education
• Masters of Business Administration, Annamalai University
• Bachelor of Mechanical Engineering, Madurai Kamaraj University
Project Description
State of GA Atlanta, NJ
SQL/DB2 Programmer Aug’ 2010 – Nov 2010
Responsibilities:
• Design and analysis of requirements for DNR license suspension notification process – Web Methods
and DB2 Stored Procedures for Child Support Project.
• Coded new DB2 stored procedures for DNR license suspension notification process after locating
non Custodial Parents for getting Child support.
• Defined the testing strategy and prepared test cases and scripts for various phases of Unit and
System Testing.
• DB2 performance tuning, running Explains and Catalog Management.
• Design, Coding and testing of new DB2 stored procedures for DNR reporting.
Environment: MVS, COBOL, JCL, CICS, DB2 Stored Procedures, FILEAID, VSAM, Change Man,
SPUFI, RACF, VSAM, Expeditor, Web-services, Visual Studio, .NET Framework.
Verizon Wireless Warren, NJ
SQL/DB2 Programmer Mar’ 2010 – June 2010
Responsibilities:
• Coded new SQL/DB2/COBOL programs to load and unload data and create reports.
• Created GDG bases for QA regions to unload DB2 tables.
• Techno Functional Analysis of rating application (iVISION, Netace).
• Extensively worked with SQL, Relational Databases, DB/2, MVS JCL, SDLC, Debugging Tools, Web Service, Web Methods, Performance Tuning, TSO, SPUFI and QMF
• Defined the testing strategy and prepared test cases and scripts for various phases of Unit and System Testing.
• Coded new COBOL copybooks / SPUFI files. Debugged the deliverable using IBM Debugger.
• Worked in the projects Friends & Family usage -#Min and bill-face changes, Vision Lock-box file opt out, Competitive Response - Bill information credit.
• Prepared the Test Plan, Test Scripts, uploading and track the test plan in Quality Center and reviewed the Test plan and made necessary changes to improve the quality of the document.
• Reviewed requirements, created test plans, setup test plans and validated plans.
• Defects logging, retesting the test scripts, tracking the defects and closing the defects. Analyze Test Execution Results and Report Defects using Quality Center.
• Execution of SQL queries to extract data from DB2 tables for running test scripts.
• Unit/System/Integration testing efforts for all releases.
• Creation, preparation, and conduct of Quality Assurance reviews and the development and execution of test plans and test scripts.
Environment: MVS, COBOL, JCL, CICS, FILEAID, SQL, DB/2, Web Methods, TSO, SPUFI, QMF, VSAM, ChangeMan, SPUFI, RACF,VSAM, Expeditor, Endeavor, UML, Team Track, CICS Web Services, SOAP, IBM Debugger, UNIX, HP QC 10.0,IBM Content Manager,PSS,SMDB,TAS, Intertest.
Morgan Stanley NYC
Consultant/Lead Sep’ 2009 – Jan’ 2010
Responsibilities:
• Coded new SQL, DB2/COBOL programs to load and unload data and create reports.
• Created GDG bases for QA regions to unload DB2 tables. Techno Functional Analysis of Asset Management application.
• Defined the testing strategy and prepared test cases and scripts for various phases of Unit and System Testing.
• Coded new COBOL copy books / SPUFI files. Debugged the deliverable using IBM Debugger.
• Implemented CICS Web Services using IBM Rdz.
• Reviewed requirements, created test plans, setup test plans and validated plans.
• Used SQL, Relational Databases, DB/2, MVS JCL, SDLC, Debugging Tools, Web Service, Web Methods, Performance Tuning, TSO, SPUFI and QMF
Environment: MVS, COBOL, JCL, CICS, FILEAID, VSAM, ChangeMan,PSS , RACF,VSAM, Expeditor, Endeavor, UML, Team Track, SQL, DB/2, Web Methods, TSO, QMF, CICS Web Services, SOAP, IBM Debugger, UNIX, Intertest
American Family Insurance WI
SQL/DB2 Programmer Jun’ 2008 – Feb’ 2009
Responsibilities:
• Resolved problem tickets (SPR).
• Responsible for enhancement to the CICS program to address to the warning messages.
• Responsible for cleaning fields to run the reinstate transactions.
• Defined the testing strategy and prepared test cases and scripts for various phases of Unit and System Testing. Techno Functional Analysis of Auto/Commercial/Ranch insurance applications.
• Responsible for modification of CICS/COBOL programs to resolve the abends.
• Utilized IBM RDz for CICS, Web services implementation and debugging using IBM Debugger.
• Expertise with top down, bottom up, meet in middle and Web Security using RACF.
• Completed CICS Web Services/SOAP/JavaScript and J2EE training for project preparations.
• Utilized DB/2, MVS JCL, SDLC, SQL, TSO, SPUFI, QMF, Relational Databases, Debugging Tools, Web Service, Web Methods and Performance Tuning
Environment: MVS, DB/2, COBOL, JCL, CICS, FILE AID, RACF, SAM, Expeditor, Endeavor, UML, Team Track, SQL, TSO, SPUFI, QMF, CICS Web Services, SOAP, IBM Debugger, UNIX, Panvalet, Mercury Quality Center, Intertest, UNIX Scripts, Relational Databases, Debugging Tools, Web Service, Web Methods and Performance Tuning
Master Card International MO
SQL/DB2 Programmer Mar’ 2008 – Apr’ 2008
Responsibilities:
• Created new copybooks, jobs and procedures to execute batch modules for debit card processing for Odysseus releases. Techno Functional Analysis of Debit Card applications.
• Coded new modules to create output files to send data to the customer master.
• Reviewed requirements, created test plans, setup test plans and validated plans (Unit/System/Integration).
• Created technical designs based on client’s business requirement.
• Extensively worked with DB/2, MVS JCL, TSO, SPUFI, QMF, SQL, Relational Databases, SDLC, Debugging Tools and Performance Tuning
Environment: MVS, COBOL, JCL, SPUFI, CICS, DB2, FILE AID, SAS, Expeditor, Change Man, SPUFI, QMF, EDI, DB/2, TSO, SQL, LOTUS NOTES, Endevor, Mercury Quality Center, Z/OS, J2EE Framework, Intertest
Pearson IA
SQL/DB2 Programmer Aug’ 2007 – Oct’ 2007
Responsibilities:
• Responsible for development and testing of new modules of MN science project to create SDF files.
• Developed and tested new modules for IL PSAE project to create files using SAS.
• Created new copybooks for IL PSAE and MN school projects.
• Created technical designs based on clients business requirement.
• Reviewed requirements, created test plans, setup test plans and validated plans (Unit/System/Integration).
• Completed JavaScript, PMI and J2EE training for project preparations.
• Worked with DB/2, SQL, MVS JCL, SDLC, TSO, SPUFI, QMF, Relational Databases, Debugging Tools and Performance Tuning
Environment: MVS, COBOL, JCL, SPUFI, CICS, DB2, FILE AID, SQL, SAS, Expeditor, Change Man, SPUFI, QMF, EDI, LOTUS NOTES, ZEKE, Mercury Quality Center, Z/OS, J2EE Framework, Unix Scripts, Intertest
CSC MD
Programmer Jun’ 2006 – Jun’ 2007
Responsibilities:
• Developed and tested new modules in Payment system of MARx – Medicare Advantage and Prescription application drug system (Part-D) for various releases 3, 4 and 5.
• Modified the SQL query to fetch entitlement reason code from CME entitlement reason code table.
• Replaced the error message call to with the call to error message module MCSLG101.
• Changed Bene-can-number and bic-code with bene-link-part-key and bene-link-key.
• Prepared test cases and test scripts for various phases of Unit and System Testing.
• Analyzed the Defect Reports and Test Cases.
• Managed problem tickets (MPRs) and implementing the changes.
• Created technical designs based on client’s business requirement.
• Reviewed requirements, created test plans, setup test plans and validated plans.
• Utilized SQL, DB/2, MVS JCL, Debugging Tools, Performance Tuning, TSO, SPUFI, QMF, Relational Databases, SDLC
Environment: MVS, COBOL, JCL, SPUFI, CICS, TSO, DB2, FILE AID, SAS, Expeditor, SQL,Change Man, IMS/DB,ZEKE, QMF, EDI, LOTUS NOTES, Mercury Quality Center, Panvalet, Z/OS, J2EE Framework, Intertest
Edward Jones MO
SQL/DB2 Programmer Dec’ 2005 – May’ 2006
Responsibilities:
• Interacted with users for enhancement and modification requirement analysis.
• Managed problem tickets and tracking the defects using Peregrine-Service Center.
• Managed online transaction abends CICS/IDMS/DB2 and tracking them.
• Reviewed requirements, created test plans, setup test plans and validated plans(Unit/System/Integration).
• Coded new modules to create CUSIP output file in Cobol/IDMS/DB2.
• Techno Functional Analysis of Asset Management application.
• Used IBM 30XX, SQL, DB/2, MVS JCL, SDLC, TSO, SPUFI, QMF, Debugging Tools, Performance Tuning and Relational Databases
Environment: IBM 30XX, MVS, SQL, DB/2, COBOL II, IDMS, Peregrine-Service Center, JCL, SPUFI, TSO/ISPF, SPUFI, QMF, VSAM, CA-7,IBM Info Sphere Information Server, ,PSS,SMDB,TAS ,CICS.
Fannie Mae VA
Programmer Aug’ 2005 – Oct’ 2005
Responsibilities:
• Responsible for documenting the hardware, application and test procedures.
• Reviewed requirements, created test plans, setup test plans and validated plans.
• Responsible for running batch jobs for Laser application testing(Unit/System/Integration).
• Attended team meetings and user interaction meetings as needed.
• Extensively used IBM 30XX, SQL, DB/2, MVS JCL, SDLC, TSO, SPUFI, QMF, Relational Databases, Debugging Tools and Performance Tuning
• Responsible for enhancement of SAS/COBOL/IDMS modules for the Laser system.
Environment: IBM 30XX, SQL, MVS, COBOL II, IDMS, DB/2, QMF, Peregrine-Service Center, JCL, SPUFI, TSO/ISPF, VSAM, CA-7, CICS
Nationwide OH
SQL/DB2 Programmer Mar’ 2005 – Aug’ 2005
Responsibilities:
• Interact with users based in Michigan for enhancement and modification requirement analysis.
• Involved in documenting the Allied applications.
• Responsible for running batch jobs with Allied through various cycles.
• Involved in FTP of data files from Allied to Nationwide.
• Define and proposing technical strategies, Discussion with stakeholders, resolving technical issues as an architect. . Techno Functional Analysis of Auto Insurance application.
• Involved in preparing the contingency plan for Rel 3.0.
• Worked with IBM 30XX, SQL, DB/2, MVS JCL, SDLC, TSO, SPUFI, QMF, Relational Databases Debugging Tools and Performance Tuning
• Reviewed requirements, created test plans, setup test plans and validated plans.
Environment: IBM 30XX, COBOL, VSAM, MVS JCL, DB2, CICS, FTP, TSO/ISPF, SPUFI, QMF, CMAN, MQ Series, SQL, Visio, EDI, Test Director, Lotus Notes, Flow Chart, MS-WORD, MS-EXCEL, Mercury Quality Center, Stored Procedure/OS, VTAM, IDMS, Control-M, ZEKE,SDSF, Intertest
Citi Irving, TX
SQL/DB2 Programmer /Lead Onsite Coordinator Jun’ 2004 – Mar’ 2005
Responsibilities:
• Coded and tested new COBOL/DB2/CICS modules and copybooks for Sears’ card release.
• Involved in FTP of data files from system to users and AT&T mass disconnect data to AT&T.
• Supported batch jobs involving major credit processing for Sears project.
• Worked in the Bridge Enhancement, IRS-1099C, Sears and RPL development projects.
• Involved in writing technical specification, analyzing and coding programs in SAS for creating reports.
• Review of requirements, create test plans, setup test plans and validate plans.
• Created and implemented test plans and test cases based on technical specifications.
• Analyzed business requirements to develop functional and detail design specifications.
• Trained in JavaScript for project preparations.
• Created documents using MS-WORD for status report and requirement analysis.
• Extensively worked with IBM 30XX, SQL, DB/2, MVS JCL, SDLC, TSO, SPUFI, QMF, Debugging Tools, Performance Tuning and Relational Databases
• Responsible for planning, analysis, estimation, tracking and reporting for all project tasks.
Environment: COBOL, VSAM, DB2, SQL, CICS, JCL,TSO/ISPF, SAS, CMAN, PL/1, CA-7, SPUFI, QMF, SDLC, Intertest, Z/OS, EDI, DB2 Stored Procedure, MS-WORD, MS-EXCEL, ZEKE, UML, JavaScript, Mercury Quality Center, Panvalet, Info Man,CA-Erwin, SDSF, ,PSS,SMDB,TAS ,EXPEDITOR
SBC MO
SQL/DB2 Programmer / Team Lead Sep’ 2003 – Mar’ 2004
Responsibilities:
• Developed and tested new SAS/COBOL/CICS/ Easytrieve modules for creating repeating customer file for BI analysis.
• Responsible for planning, analysis, estimation, tracking, reporting for all the tasks associated with the project (SDLC and CMMi Methodologies).
• Extensively worked with IBM 30XX, SQL, DB/2, MVS JCL, TSO, SPUFI, QMF, Relational Databases, Debugging Tools and Performance Tuning
• Reviewed requirements, created test plans, setup test plans and validated plans.
• Analyzed business requirements to develop functional and detail design specifications.
• Created documents using MS-WORD for status report and requirement analysis.
Environment: COBOL, VSAM, DB2, CICS, JCL, SQL, TSO/ISPF, SAS, SQL, Focus, FileAid, IMS/DB, Visio, FTP, HTML, OS/390, SDLC, J2EE Framework, MS-Word, Teredata, EASYTRIEVE+, Intertest, CMAN, CA-7, MS-EXCEL, XML, Stored Procedures, Panvalet, Micro Focus Net Express, Info Man, SDSF,APPC/LU 6.2
GLIC NYC
SQL/DB2 Programmer Dec’ 2002 – Aug’ 2003
Responsibilities:
• Analyzed business requirements to develop functional and detail design.
• Developed and tested new COBOL/DB2/CICS modules for the Cobra Indicator Fix project.
• Developed and tested new COBOL/IMS/DB/DC modules for billing applications.
• Created and implemented test plans and test cases based on technical specifications.
• Executed FTP job to direct production lock box lumped file to test region.
• Define and proposing technical strategies, Discussion with stakeholders, resolving technical issues as an architect.
• Responsible for planning, analysis, estimation, tracking, reporting for all the tasks associated with the project (SDLC and CMMi Methodologies).
• Utilized MVS JCL, TSO, SPUFI and QMF
• Created documents using MS-WORD for status report and requirement analysis.
Environment: COBOL, VSAM, DB2, CICS, MVS JCL, TSO/ISPF, SAS, SQL, Focus, SPUFI, QMF, FileAid, IMS/DB, Visio, FTP, HTML, OS/390, SDLC, J2EE Framework, MS-Word, IMS/DB, Teredata, EASYTRIEVE+, Intertest, CMAN, CA-7, MS-EXCEL, XML, Stored Procedures, Micro Focus Net Express,SDSF, APPC/LU 6.2
Kaiser Permanente CA
SQL/DB2 Programmer Apr’ 2002 – Nov’ 2002
Responsibilities:
• Developed and tested new COBOL/CICS/IMS/DB/DC/ Easytrieve modules for sending error messages to the user.
• Supported the Medicare applications (claims processing) for fulfillment of various service levels.
• Developed Schemas of EDI ANSI X12 Claims (837 and 835).
• Created and implemented test plans and test cases based on technical specifications. Training the junior developers and leading the team.
• Created and maintained project plan using MS-PROJECT. Define and proposing technical strategies, Discussion with stakeholders, resolving technical issues as an architect.
• Responsible for planning, analysis, estimation, tracking, reporting for all the tasks associated with the project (SDLC and CMMi Methodologies).
• Reviewed requirements, created test plans, setup test plans and validated plans.
• Created documents using MS-WORD for status report and requirement analysis.
• Utilized MVS JCL, TSO, SPUFI and QMF
Environment: COBOL, VSAM, DB2, CICS, MVS JCL, TSO/ISPF, SAS, SQL, Focus, SPUFI, QMF, FileAid, IMS/DB, Visio, FTP, HTML, OS/390, SDLC, J2EE Framework, MS-Word, IMS/DB, Teredata, EASYTRIEVE+, Intertest, CMAN, CA-7, MS-EXCEL, XML, Stored Procedures, Micro Focus Net Express, APPC/LU 6.2
TCS Inc Tampa, FL
SQL/DB2 Programmer Aug’ 2000 – Mar’ 2002
Responsibilities:
• Responsible for conversion and testing of OS-VS COBOL modules to COBOL 370 for the various subsystems.
• Managed COBOL/ DB2/CICS program changes and testing for TES screen modification project.
• Worked in SYBIL project which is developed to communicate and transfer the necessary files from the Tampa Mainframe system (OMS) to the plant for printing process using J2EE/Java Script/RPC/Sybase mainframe connect.
• Coded changing, unit and system testing modules for (ASSEMBLER) Order cancel via Cosmo project. Define and proposing technical strategies, Discussion with stakeholders, resolving technical issues as an architect.
• Involved in all phases SDLC methodology - good exposure to project management processes & knowledge areas.
• Utilized IBM 30XX, SQL, DB/2, MVS JCL, TSO, SPUFI, QMF, Relational Databases and Debugging Tools
• Responsible for conversion of SAS programs to COBOL programs.
• Managed a team of 18 to support various MFA releases.
Environment: COBOL, VSAM, DB2, CICS, JCL, TSO/ISPF, SAS, SQL, Focus, FileAid,Insync, Visio, FTP, HTML, OS/390, SDLC, J2EE Framework, MS-Office, MS/DB, Teradata, EASYTRIEVE+, Intertest,Panvalet, CA-7,Erwin , XML, Stored Procedures, Info Man,SDSF, Micro Focus Net Express, SAS Enterprise Data Integration Server/ETL.
State of Tennessee
Programmer Analyst May’ 2000 – Jul’ 2000
Responsibilities:
• Coded and tested new common action blocks (CAB) in Coolgen for CSENET.
• Coded and tested new external action blocks (EAB) in COBOL for CSENET.
• Created test data, test plan and supporting documentation.
• Used IBM 30XX, SQL, DB/2, MVS JCL, Debugging Tools, TSO, SPUFI, QMF and Relational Databases
Environment: IBM 30XX, SQL, COBOL, VSAM, DB2, CICS, JCL, TSO/ISPF, TSO, SPUFI, QMF, XPED, FileAid, Endevor, Cool: Gen.
Lockheed Martin IBS PA
Programmer Analyst Nov’ 1999 – Apr’ 2000
Responsibilities:
• Coded and tested Cobol/DB2 programs that update/insert the tables with the daily transaction data.
• Experience in Unit, System, Integration and regression testing.
• Created GDG bases for storing the daily transaction data from GM.
• Worked with IBM 3090, SQL, DB/2, MVS JCL, SDLC, TSO, SPUFI, QMF, Relational Databases and Debugging Tools
• Created JCL, Procs for executing the new modules
Environment: COBOL, VSAM, DB2, CICS, MVS JCL, SPUFI, TSO/ISPF, FileAid, Endevor, QMF, SPUFI, PLATINUM UTILITIES, IBM 3090, MVS/ESA, EXPEDITOR, SQL, VTAM,ETL,SDSF, DB2 stored procedures
Vanguard Malvern, PA
Programmer Analyst Oct’ 1998 – Oct’ 1999
Responsibilities:
• Created new monthly confirm report using Cobol/DB2.
• Design, coding, testing of new Easytrieve+ program to create a statement suppression report for participants
• Involved in analysis, design, coding, testing of modules to create secured info Pac reports for Vanguard plans.
• Created JCL, Procs for executing the new modules
• Utilized IBM 3090, SQL, DB/2, MVS JCL, TSO, SPUFI, QMF, Relational Databases and Debugging Tools
Environment: COBOL, VSAM, DB2, CICS, MVS JCL, TSO/ISPF, FileAid, ZEKE, QMF, SPUFI, PLATINUM UTILITIES, IBM 3090, MVS/ESA, EXPEDITOR, SQL, VTAM, Easytrieve Plus,Insync,DB2 stored procedures
FDMS Melville, NY
Programmer Analyst May’ 1998 – Aug’ 1998
Responsibilities:
• Created new monthly confirm report using Cobol/DB2.
• Design, coding, testing of new programs for Huntington bank credit transactions request.
• Created JCL, Procs for executing the new modules
• Utilized IBM 3090, SQL, DB/2, MVS JCL, TSO, SPUFI, QMF, Debugging Tools, and Relational Databases
Environment: COBOL, VSAM, DB2, CICS, MVS JCL, TSO/ISPF, FileAid, Endevor, QMF, SPUFI, PLATINUM UTILITIES, IBM 3090, MVS/ESA, EXPEDITOR, QMF, SQL, VTAM, Easytrieve Plus,DB2 stored procedures
Random House MD
Programmer Analyst Mar 1998 – May 1998
Responsibilities:
• Coded and tested a new Cobol/DB2 program that extracts data from Random House tables and Client’s flat file to prepare extracts of matched and unmatched customer data mailing lists.
• Created JCL, Procs for executing the new modules
• Utilized IBM 3090, SQL, DB/2, MVS JCL, Debugging Tools, TSO, SPUFI, QMF and Relational Databases
Environment: COBOL, VSAM, DB2, CICS, MVS JCL, TSO/ISPF, FileAid, Endevor, QMF, TSO, SPUFI, PLATINUM UTILITIES, IBM 3090, MVS/ESA, EXPEDITOR, SDSF, SQL.
FDR Inc NE
Programmer Analyst Jun’ 1997 – Mar’ 1998
Responsibilities:
• Design and analysis of requirements for Card embossing applications.
• Extensively worked with IBM 30XX, SQL, DB/2, MVS JCL, Debugging Tools, TSO, SPUFI, QMF, Viasoft and Relational Databases
• Created JCL, Procs for executing the new modules. Design and analysis of requirements for monetary and non-monetary field’s expansion.
Environment: IBM 30XX, SQL, COBOL, VSAM, DB2, CICS, MVS JCL, TSO/ISPF, SQL, SPUFI, FileAid, QMF, SPUFI ,SDSF,Viasoft.
NLC Ltd India
Sr. Manager/Executive Engineer Aug’ 1986 – Jun’ 1997
Responsibilities:
• Created JCL, Procs for executing the new modules. Design and analysis of requirements for monetary and non-monetary field’s expansion.
• All phases of SDLC and data analysis and Design. Leading a team for Inventory management division.
• Define and proposing technical strategies, Discussion with stakeholders, resolving technical issues as an architect.
• Used SQL, DB/2, MVS JCL, XPEDITOR, Viasoft and Relational Databases
Environment: COBOL, VSAM, DB2, CICS, JCL, TSO/ISPF, QMF, SPUFI, IBM 3090, MVS/ESA, EXPEDITOR, Viasoft, SQL, Oracle 8i, Primavera, UNIX Scripts, MS-Project.
Contact this candidate