Business Analyst/QA
Resume:
KUMAR MSK
Phone: +1-925-***-**** Email: kp1obp@r.postjobfree.com
Professional Summary
• 8 years of experience in Information Technology providing professional service as Mainframe developer in analysis, design, development, enhancement, testing and maintenance.
• Experience in development, production support and maintenance of complex projects.
• Provided 24/7 production supports to Mainframe system, which includes support during night batch run, providing temporary fix to JCL,Db2’s during batch abends to avoid delay
• 8 years of Finance, Retail and Insurance Industry experience in Developing, Enhancing and maintaining large scale Billing, Accounting, General Ledger, General Agency, Bank/Check reconciliation, Reinsurance, Underwriting, Policy admin and Claims systems.
• Got 8 Years of experience in COBOL, JCL, VSAM, MVS, and TSO/ISPF and worked extensively in Mainframe batch applications in wide variety of projects ranging from Development, Enhancement and Maintenance/Production Support.
• Proficient in TSO/ISPF, COBOL, CICS,BMS, DB2,DB2 UDB,MQ SERIES,VSAM, JCL, PROC, REXX SYNCSORT, eZtrieve,CLIST,QUICKJOB,ASSEMBLER,PL/1 and other Mainframe tools/Utilities like ENDEVOR, XPEDITOR, SQL,SPUFI, QMF,DB2 CONNECT,CA INSIGHT,FILE AID, File Transfer Protocol (FTP), IBM FAULT ANALYZER,IBM DEBUGGING TOOL,IBM FILE MANAGER etc.
• Expertise in Software Development Life Cycle (SDLC) Methodologies & Validations to ensure the Quality Assurance Control.
• Good working knowledge of batch FTP processing and the use of CA-7 for scheduling.
• Got 6 years of experience in DB2, DB2 UDB, DB2-CONNECT, SQL, SPUFI and QMF and worked extensively on Mainframes database applications in wide variety of projects ranging from Development, Enhancement and Maintenance/Production Support.
• Have good experience of working in a distributed system environment, interacting and coordinating with teams of various technologies
• Excellent communication skills, both written and verbal. Excellent knowledge of the software development life cycle
• Got 1 year experience in .NET, JAVA, XML and Web methods.
• Good working knowledge on MS Access, MS Word, MS Excel, MS Outlook
Educational Profile:
• Bachelor of Technology in Computer Science Engineering from Jawaharlal Nehru Technological University, India.
Technical Expertise:
HARDWARE IBM OS/390, IBM 3090, IBM PC Compatibles
OPERATING SYSTEMS OS/390, DOS/VSE, MVS/ESA, MS-DOS, WINDOWS XP/NT/2000/98, Z/OS
LANGUAGES JCL, COBOL, EZTRIEVE, SQL, C, PL/I, SELCOPY, DITTO
DATABASES DB2, IMS DB, IDMS
OLTP IMS-DC, ADSO, CICS
WEB RELATED HTML, XML, JAVA SCRIPT, VB SCRIPT
TOOLS & UTILITIES XPEDITER, FILE-AID, SPUFI, QMF, VSAM, ADF, CHANGEMAN, ENDEVOR, PANVALET, MQ Series
DOMAIN KNOWLEDGE Finance, Retail, Manufacturing and Insurance
Professional Experience
Client : Supervalu, CA April 2010 to December 2010
Project : Supply Chain
SUPER VALU is the largest publicly held distributor to grocery retailers in the United States. Super Valu the product-supply lifeline for more than 5,000 retail end points from coast to coast and it operates one of the largest grocery supply chain networks in US with more than 21 million square feet of facilities strategically located to support our coast-to-coast retail operations and customers. Client optimizes its vast logistics network by measuring the cost to move products from the manufacturer to our customers' locations. Super Valu customer service work around the clock to support distribution customers.
Roles/Responsibilities:
• Coding new Jobs using JCL.
• Involved in solving the SEV1 tickets raised by the customers.
• Involved in month end and quarter end process
• Enhancing the business logics in the existing COBOL programs.
• Executing the SQL Queries in SPUFI & QMF
• Preparing the Build for the developed Stored Procedures using the Db2 Development center.
• Preparing Analysis documents and following SDLC process
• Developing the Stored Procedures in DB2 Development center.
• Writing the new Cobol/Db2 Programs which executes in the Batch cycle
• Working closely with the Managers.
• Modifying the existing CICS programs wherever needed.
Client : Thomson Reuters, NY April 2009 to March 2010
Project : Core suite Life Extension
Order Number is a key resource which plays a major role in Core Suite Ordering process.
This number is generated when an order is raised in Compass/Siebel and is interfaced to other applications. As the size of this resource is limited to 6 digits, the maximum number of this resource is limited to 999999.If Order Numbers exhausted it would impact the business continuity. To increase the life span of the resource and ensure smooth business continuity, Thomson Reuters decided to identify and harvest old order numbers in Core Suite so that they can be re-used.
Roles/Responsibilities:
• Analyze the Requirements and Prepare Design Documents.
• Involved in solving the SEV1 tickets raised by the customers.
• Involved in the design and implementation of the Module.
• Code Reviews and Code walk through of the prototype.
• Analyze the User Requests and gave the permanent solutions to fix the requests.
• Refreshing the DB2 Test database with the Production database.
• Responsible for coding, unit and Integration testing of the application.
• Designed and developed Cobol-DB2 programs to extract the information from the DB2 tables as per the format required.
• Performing end-to-end system testing of product writing test cases and fixed the issues found.
• Worked with team of contract/staff technical writers to produce high-quality, timely documentation for our Client’s products.
Client : Thomson Reuters, NY April 2008 to March 2009
Project : Athena CS Integration
This is the project to integrate the Thomson and Reuters Business Entitlements. The Entitlement transactions would be triggered using the newly developed Self Serve Entitlement Tool (GUI). The newly built Service Layer would capture the transactions from the Self Serve Entitlement Tool and route the requests to:
1. Athena System – For Entitlements/Permission.
2. Core Suite (MAINFRAME) – For Ordering and Billing.
Roles/Responsibilities:
• Involved in coding interface programs as per the business requirement.
• Responsible for coding new and modifying existing batch programs.
• Responsible for developing the SQL scripts for file data handling.
• Responsible for coding online programs using CICS and DB2.
• Performed unit testing and integration testing.
• Code Reviews and Code walk through of the prototype.
• Responsible for coding, unit and Integration testing of the application.
• Analyze the Requirements and Prepare Design Documents.
• Designed and developed Cobol-DB2 programs to extract the information from the DB2 tables as per the format required.
• Performing end-to-end system testing of product writing test cases and fixed the issues found.
• Worked with team of contract/staff technical writers to produce high-quality, timely documentation for our Client’s products.
• Created effective modular documentation that aligns with business objects.
• Responsible for relevant documentation, and Unit Test Cases adhering to standards
Client : Thomson Reuters, NY October 2006 to March 2008
Project : IRAS and COMPASS.
Description: Thomson Reuters is a global information company and Onsite-Offshore model Mainframe maintenance project in COBOL, CICS, DB2, Mantis, JCL, and VSAM. Applications maintained are Reuters Sales, Billing and Fixed Asset management and Reporting systems.
Maintenance includes 24/7 support for some of the applications with stringent Service Level Agreement and penalty clauses.IRAS and COMPASS application is designed and built to perform billing, invoicing and revenue analysis functions for clients of different countries across the world.
Roles/Responsibilities:
• Preparation of Unit Test Plans and Unit Test Report for above applications.
• As mainframes Developer, responsible for impact analysis of the fields with the pic class 9(7)V99.
• Developed COBOL programs to be able to convert the masterfiles for the impacted fields.
• Modified each and every impacted copybooks, programs, procs and JCLs.
• Modified the VSAM Files to fit the new file structure.
• 24x7 application support.
• Quality Reviews.
• Enhancements without impacting business.
• Performance Management.
• Monthly Metrics and Reporting.
• Monitoring and effective scheduling.
• Troubleshooting critical abends.
• Change control creation and follow-ups.
• Changeman package approvals and queries.
• Analysis support for all projects.
• Documentation of guidelines and checklists.
• Turnover meetings and implementation involvement.
• Reviewing of new requirements and changes.
• Scheduling using CA7 and autosys.
• Service Level Agreement adherence and review.
• Strategically reduction in missed deadline.
Satyam Computer Services, India
Client: CIGNA Health Insurance, September 2005 to August 2006
Programmer Analyst
Description: I was involved as a Programmer Analyst for the Cigna Health Insurance project. This project involves System Analysis, Maintenance and Enhancement of patient billing, Account Receivable systems and Coordination of insurance benefits, Membership and Enrollment, etc. to healthcare services for Cigna.
Roles/Responsibilities:
• Loading data from Production to Test Environments to test COBOL II, DB2, VSAM programs
• Testing of DB2 applications using QMF, SPUFI from TSO and ISPF.
• Involved in Documentation and Implementation.
• Gathering requirements for pharmacy and eligibility.
• Preparation of Unit Test Plans and Unit Test Report for above applications
• Review of code walk through, Unit Test Plans and Unit Test Results
• Responsible for the on-call support of batch applications
• Responsible for Development and maintenance of COBOL, DB2, VSAM programs.
• Responsible for enhancement of Batch Programs for new business expansion.
• Responsible for developing and supporting Batch Programs/ applications.
• Responsible for fixing of cursor positions, adding new validation checks and meaning full error messages to existing CICS systems.
• Conducting Unit and integration testing and document the test case with test results for above applications. Testing of applications and delivering to the client
Satyam Computer Services, India
Client: British Telecom (BT), London December 2004 to September 2005
Technical Associate
Description: The Operator Service Information System (OSIS) was developed for Operator Services as the strategic repository of number information covering both BT and other Licensed Operators. As such, it occupies a very important place in the overall BT Systems Architecture. The major role of this system is to collect & manage information, which comes from various sources, and to control the distribution of this information to a variety of other systems (commonly known to as “downstream” systems).
OSIS is the UK’s Number Information Repository, as described, and holds directory information for all UK’s licensed telephony operators. However, it does not hold all telephone numbers – it only holds telephone numbers where the customer requires a directory entry and the operator has provided the data to OSIS. For example, only a small number of directory entries for mobile operators are currently held.
Roles/Responsibilities:
• Involved in the business process analysis, requirements scope definition and project execution.
• Preparation of the low level design depending on the Client required definition (CRD).
• Preparation of Test Cases for the new programs.
• Reviewed the code and Unit Testing based on Test Cases.
• Coding JCL’s, Procs and Programs.
• Responsible for Development and maintenance of COBOL, DB2, VSAM programs.
• Responsible for developing and supporting Batch Programs/ applications.
• Responsible for enhancement of Batch Programs for new business expansion.
• Involving the deployments.
Satyam Computer Services, India
Client: Citi Bank, Parsippany, NJ March 2003 to November 2004
Technical Associate
Served as the technical associate on SOPT (Stock option System) mainframe application, adding new users SOPT for specific accounts With Citibank’s Mainframe legacy system.
• Involved in solving the SEV1 tickets raised by the customers.
• Involved in month end and quarter end process.
• 24x7 application support.
• Analysis support for all projects.
• Modified each and every impacted copybooks, programs, Procs and JCLs
• Resolving application problems, Maintaining DB2, SQL server database
• Coded all adapter and wrapper applications using SAS, COBOL, JCL Subroutines, ISPF/TSO, FILEAID, DB2, QMF, Expeditor, File-Aid, SQL, CICS, MQ series, Change man, DB2 store procedure and Expeditor.
• Performed Module, integration, system and regression testing using Test Director.
Contact this candidate