Programmer Analyst Resume Profile
SUMMARY
- 10 years of professional experience in Information Technology with extensive experience in Mainframe Application Programming. Proficient in TSO/ISPF, COBOL, DB2, JCL, CICS, VSAM, IDMS,SYNCSORT, EZTRIEVE. Proficient in tool/Utilities ENDEVOR, QMF, XPEDITOR, CHANGEMAN, OPC, SQL, NDM, SPUFI, DCLGEN, FILE-AID, ABEND-AID, QMF, REGEN MASS REGEN,CODE MIGRATION, DB2 CONNECT, CA INTERTEST, CA INSIGHT, IBM FAULT ANALYZER, IBM DEBUGGING TOOL, IBM FILE MANAGER , CA-7. Over 10 years of diverse experience in software analysis, design, development, enhancement, debugging, documentation, and testing for both on-line and batch applications having exposure to all stages of SDLC and skilled in resolving online and batch problems. Good knowledge of Software Development Life Cycle SDLC and Testing Methodologies and Techniques. Having experience in DB2,DB2 UDB,SQL,SPUFI,QMF,IDMS,COBOL, JCL GDG's , CICS and worked extensively on Mainframes database applications in wide variety of projects ranging from Requirement gathering, Development, Testing, Debugging, Troubleshooting, Enhancements and Maintenance/Production Support. Worked on National Provider Identifier project. Functional expertise includes Healthcare domain, Medicaid Management Information System MMIS .
- Experience in Medicaid Applications and Worked for HIPAA.
- Expertise in obtaining the project requirements from user, writing system specifications, translating user requirements into technical specifications, preparation of requirements documents, formulating the requirements into design specifications and tracking project progress. Strong experience using DB2 stored Procedures To develop an integrated project plan and risk analysis with action plans to mitigate the risks Responsible for client handling starting from SRS Discussion to Final Project Handover. Experience in design, analysis, coding, testing, gathering business requirements and Preparing Business specs. Involved in Peer reviews, inter-group coordination, Training Program. Performed in test planning, test cases creation, testing and documentation. Experience in implementation capability of complete SDLC process in software application development. Experience in analyzing the existing mainframe legacy system, understanding the business functionality. Involved in the final Roll out, migration of the tested components of the application to the production. Strong analytical skills with ability to quickly understand clients business needs. Excellent Communication skills, organizational skills, analytical skills and strong interpersonal skills. An innovative and effective team player with good initiative. Analytical and systematic thinking ability with a goal and solution oriented approach. Experience in analyzing the existing mainframe legacy system, understanding the business functionality. Coordinated the testing efforts with UAT User Acceptance Testing team and resolved their findings on the application which also involved Setting up of the Test Environment for UAT. Ability to learn new application s and process quickly. Expertise in preparing High-level design and Low-level design document as well as Unit test plans for testing. Technologies Tools
- Languages : VS COBOL II, COBOL, JCL, C, and SQL.
- Operating Systems : OS/390, MVS/ESA, WINDOWS 98/NT/XP, MS-DOS.
- Tools : File Aid, Endevor, Xpeditor, PLATINUM as DB2.
- Test Types : System Testing, Functional Testing, Integration Testing, Regression Testing.
- Software Utilities: : CA7 Scheduler, FILE-AID, SUPERC, SPUFI, QMF, XPEDITER, SYNCSORT, FTP, Microsoft word, Microsoft Excel, Microsoft Visio,
- Microsoft Access, Microsoft PowerPoint and Zeke scheduler
- Databases : DB2, SQL, Oracle.
PROFESSIONAL EXPERIENCE
Confidential
Role: Team lead
Environment: IBM MF, MVS Z/OS, VS COBOL II, JCL, DB2,VSAM, File AID, Expeditor, MICROSOFT SHARE POINT, MICROSOFT ACCESS
Description:
There are various subsystems under Medicaid system like Claims processing, Provider, Billing, and Fee for service, Encounter etc. There are eight claim types that are processed by MMIS like Drug, Home Health, Inpatient, Dental, Medical, Outpatient, Crossover and Nursing Home. Maintenance of MMIS system includes handling of Issues and CMR as per the requirements given by different Stakeholders like Provider services, policy, ISIS, data warehouse, Revenue collections etc. This issue and CMR will be assigned Via On Base tool which is used for Issue handling, time tracking, sign off process etc I am the primary on call person for the daily batch cycles which starts at 6.00 PM daily. If any job is failed, the cycle monitor will give a call to the primary support to handle the failure. After the issue is resolved, primary on call person have to re-run the job using Zeke scheduler.
Responsibilities include:
- Estimation and Design of Issue and CMR.
- Primary on call person for any issues regarding Batch Cycles.
- Creation of test cases and test strategies.
- Coding and Review of all impacted modules.
- Created BSD Business System Design document and Technical Requirement Documents as a result of meetings with the Business Areas
- Performed in test planning, test cases creation, testing and documentation.
- Coordinated with Project Leaders in deciding the project plans and goals.
|
|
|
|
|
Confidential
Role: Programmer Analyst
Environment: IBM MF, MVS Z/OS, VS COBOL II, JCL, VSAM, DB2, File AID, Endevor, Expeditor MICROSOFT SHARE POINT, MICROSOFT ACCESS.
Description:
- In Medicaid system, currently, each Medicaid provider is identified by an eight digit number that is randomly assigned by the MMIS. This number is used throughout the system on reports, claims and payment vouchers. The Health Insurance Portability and Accountability Act of 1996 HIPAA mandated a standard unique identifier be adopted, the National Provider Identifier NPI . The decision was made by the State to keep the current Medicaid Provider Identifier process in place and crosswalk with the NPI.
- During the NPI assessment phase, the State identified the need to create a new provider record layout file to hold the 10 digit NPI number in addition to supplemental data used in the provider identification cross-walk.
Responsibilities include:
- Worked on tasks related to complex Provider sub-system.
- Worked on Provider Reports and Provider Interfaces related work.
- Worked in provider module in correcting certain provider related validations.
- Developed and enhanced Batch modules in COBOL/VSAM under Endevor environment.
- Involved in finding and fixing logical errors while performing Peer reviews of all Subsystems.
- Debugging of the Batch modules using Expediter and File-Aid tools and performed Unit testing thru batch, system testing.
- Developed JCLs and Procedures.
- Used IBM transfer utilities moving the test elements into production.
- Executed FTP jobs to transfer the files between external agencies interacting with the system.
- Coded one time programs to fix bugs related to provider and NPI fields.
Confidential
Role: Programmer Analyst
Environment: IBM MF, MVS Z/OS, VS COBOL II, JCL, DB2, VSAM, File AID, Endevor, Expeditor, SPUFI and Platinum for DB2.
Description:
- In Medicaid system, currently, each Medicaid provider is identified by an eight digit number that is randomly assigned by the MMIS. This number is used throughout the system on reports, claims and payment vouchers. The Health Insurance Portability and Accountability Act of 1996 HIPAA mandated a standard unique identifier be adopted, the National Provider Identifier NPI . The decision was made by the State to keep the current Medicaid Provider Identifier process in place and crosswalk with the NPI.
- During the NPI assessment phase, the State identified the need to create a new provider database table to hold the 10 digit NPI number in addition to supplemental data used in the provider identification cross-walk.
- Approach: Verification of the new table and access to the new table to be accomplished through use of the Platinum tool. This tool allows viewing of the MMIS system tables and fields
- The MMIS database structure must be remediate to include NPI specific data elements.
Responsibilities include:
- Involved in Maintenance, Enhancements and testing of the backend business process of MEDICAID Subsystems Recipient, Provider, Claims, and Third Party Liability TPL Management.
- Worked on tasks related to complex claim-modules and Provider sub-system.
- Worked in provider module in correcting certain provider related validations.
- Coded one time programs to fix bugs related to provider and NPI fields.
- Developed and enhanced Batch modules in COBOL/DB2 under Endevor environment.
- Involved in finding and fixing logical errors while performing Peer reviews of all Subsystems.
- Debugging of the Batch modules using Expediter and File-Aid tools and performed Unit testing thru batch, system testing and Exam Entry online.
- Developed JCLs and Procedures.
- Used IBM transfer utilities moving the test elements into production.
Confidential
Role: Programmer Analyst
Environment: IBM MF, MVS Z/OS, VS COBOL II, JCL, DB2, VSAM, File AID, Endevor, Expeditor, SPUFI , Platinum for DB2 and Natural DB2.
Description:
ACS, Mississippi is mainly in Health Care services.ACS is foremost provider of consulting, application and IT business process outsourcing solutions to the health care industry. ACS servicing the federal/state government for their healthcare project, which is providing free medical insurance to people below the poverty line. Medicaid and Medicare are the two types of services provided by the federal/state government. The project deals MMIS. The cycle of the project starts from a claim, for servicing beneficiary and ends with Payment to provider. The claim goes trough different levels of adjudication and finally does the payment. Here we do data conversion programs to fix the database with the updated values. The subsystems updated trough data fix programs are
1. CLAIM
2. PROVIDER
3. BENEFICIARY
4. FINANCIAL
5. TPL
6. REFERENCE
7. PHARMACY
Responsibilities:
- Involved in Maintenance, Enhancements and testing of the backend business process of MEDICAID Subsystems Recipient, Provider, Claims, and Third Party Liability TPL Management.
- Worked on Data Conversion related Tasks.
- Worked on tasks related to complex In Patient Pricing Module.
- Worked on tasks related to complex claim-modules and Provider sub-system.
- Worked in provider module in correcting certain provider related validations.
- Coded one time programs to fix bugs related to provider and NPI fields.
- Developed and enhanced Batch modules in COBOL/DB2 under Endevor environment.
- Involved in finding and fixing logical errors while performing Peer reviews of all Subsystems.
- Debugging of the Batch modules using Expediter and File-Aid tools and performed Unit testing thru batch, system testing and Exam Entry online.
- Developed JCLs and Procedures.
- Perform actively in the defining of Organizational processes and standardization used as the basis for a successful CMMI Level 3 assessments.
Confidential
Role: Programmer Analyst
Environment: IBM MF, MVS Z/OS, COBOL II, JCL, DB2, VSAM, File AID, Endevor, Expeditor.
Description:
This is a Maintenance project. METLIFE Metropolitan Life insurance Company is one of the biggest Insurance Companies in USA. This project is to support 3rd party notification and outlines the following 3 main processes.
1. Storage, Access and Maintenance of 3PN data.
2. Creation of 3 PN notice.
3. Annual notification of eligibility.
The existence an NEF New England Financial, USA system was enhanced to send out annual offers to eligible policy holders. The election of the 3rd party notice 3PN will be tracked on the policy master file. The 3PN address data will be collected, stored and maintained via DB2 table data. This project also includes understanding the system flow for the application, which prints the NEF Return/Logo address for client letter forms. These address changes had to be incorporated in the application. And the report has to be given to the share Holders and notify changes whenever it is required and there may be some special mailing that are required when a change to the original funds prospectus as needed.
Responsibilities:
- Maintenance of 3rd Party Notification Data.
- Creation of 3rd Party Notice, if elected.
- Preparation of program specification document.
- Reviewing the Requirement sent by the Client / Onsite Coordinators.
- Updating the RDD.
- Preparation of Test Plans.
- Quality Documentation, Unit Testing.
Confidential
Role: Programmer
Environment: IBM MF, MVS Z/OS, COBOL II, JCL, IDMS, DB2, File AID and Natural DB2.
Description :
Dresdner Bank Headquartered in Germany is a leading global investment bank Serving institutional, corporate, government and individual clients. The core Banking activities are new customer generation, transaction monitoring, money Transferring mechanism, lending loan to valid customer and quarterly interest Calculation as per the banking policies. Enhancement activities of the operation and its specification, which reliable to customer and banker will be received from the banking authority and the prototype is derived after the feasibility constraint and integration. The modules of enhancement activities will be coded by our team and submitted for integration testing after the unit testing.
Responsibilities:
- Review of the coding to ensure standards set by Client.
- Interacting with the on-site coordinator for clarification of the work details.
- Unit Testing using the test data given by Client.
- Enhancements to the existing System as specified by the client Using COBOL, JCL, VSAM and bug fixing in the existing system
- Preparing JCL's and conducting unit test.
- Extensively used XPEDITER for debugging programs
- Sticking to CMM level norms and AQA processes for Documentation
- Performing reviews in each phase using Xpediter.
- Unit testing and Review of the programs.
