Sr Programmer Analyst Resume
St Louis, MO
Experience Summary:
Senior Developer with over 12 years of experience specializing in providing innovative, well-designed solutions to meet the client’s needs. Experience ranges from developing custom applications to developing high performance Enterprise Applications. An excellent team player and communicator who thrives on new challenges and welcomes the opportunity to learn and apply new technologies.
Excellent problem-solving and data analysis skills, having hands-on design, development, testing, maintenance and production support of software applications in Mainframe, Stratus and Java Technologies (with Express Scripts, Edward Jones, EDS).
- Extensively worked on mainframe technologies of COBOL, CICS, VSAM, JCL, SQL, DB2, DL/I,
IMS DB/DC,IDMS,PL/1, MQ Series, Assembler, MVS, OS/390, Z/OS, VOS/Stratus, TSO/ISPF, SPUFI, QMF, Platinum, BMCtools, File-Aid, INSYNC, ENDEVOR, CHANGEMAN, PANVALET, XPEDITER, INTERTEST, CA-7, AUTO-SYS, ABEND-AID, IBM utilities.
- Worked on business Projects/Applications of Financial systems (Brokerage firm), Medicaid systems (Health Insurance), HIPAA, Banking and Credit Cards and Automobile.
- Very good experience in using report generators SAS, Eazytrieve plus, Focus.
- Excellent experience with DB2 database and expertise in using STROBE tool for DB2 performance tuning. Involved in preparing stored procedures and performance tuning of SQL queries.
- Good experience in using Java, J2EE technologies, ASP, HTML, Java script, VB Script, XML.
- Expertise in SEI CMM, PCMM & CMMi Level5 standards.
- Experience in using IBM Rational Rose, Clearcase, Clearquest, RequisitePro (Req Pro), Test manager, Mercury QC tools.
- Knowledge in ITIL Foundation Technology, MS-Project tool.
- Exposure with attending project meetings and working with large/small teams, Project managers, team members / associates, business analysts, statisticians, and internal customers/end users, working with multiple tasks.
- Excellent communications and strong interpersonal skills, which provides with ability to interact with end users, managers, team members etc.
Technical Skills:
Hardware/OS: IBM Mainframes, Windows (Windows NT/2000/XP Professional), UNIX, IBM MVS, VOS/Stratus, OS/390, Z/OS.
Software/Languages: COBOL, CICS, JCL, PL/I, VSAM, DB2, IMS-DB/DC, IDMS, Easytrieve, REXX, Focus, SAS, Assembler, Command Macros, Oracle 7.3.
Technologies: C, C++, Java 2, J2EE, ASP, Java Script, VB Script, IIS 4.0, HTML, XML
Tools/Utilities: ISPF/PDF, Endevor, Changeman, Panvalet, File aid,File Manager, Xpediter,
Intertest,DB2I, Platinum tool, SPUFI, QMF, VSAM, IDCAMS, FTP, NDM/Connect Direct, OLTP, MQ Series, CA7, Auto-sys, Control-M, Peregrine Service Center, PVCS, Omegaview or Omegamon, Mercury Quality Center(QC), MS-Visio, MS-Office tools.
#
Confidential,St Louis, MO 01/2010 – till date
Sr Programmer Analyst
Employer : Confidential,
Edward Jones is an investment company (Brokerage) and serves over 7 million clients from over 10,000 branches in US and through its affiliates in Canada. Edward Jones advises individual investors exclusively and offers a wide variety of investments, including certificates of deposit, bonds, stocks and mutual funds. Edward Jones has $5.20 billion in assets and has gained net profit over $391 million last year.
The client has an existing huge system consisting of 80 sub-systems. Some of the critical systems are Customer Account, Portfolio, Account Activity, Statements, Cash, Money Market, Mutual Funds, Trades, PMF etc.
IS – Mutual Fund and Money Market:-
Project: Insured Bank Deposit Program:
The purpose of this project is to implement a new Insured Bank Deposit product to the firm\'s current offerings that will provide clients with an FDIC insured alternative for their liquid cash balances and generate revenue for the firm. This is an FDIC insured product that will provide financial advisors with a solution for those clients who desire insurance coverage for their liquid cash balances.
This project will implement in 2 phases. Phase 1 will provide manual buy/sell capabilities for the product, as well as the ability to transfer between accounts. Phase 2 will introduce sweeper and additional cash functionality, such as check request, SWPS and ACH on Demand.
Project: ECR – Electronic Client Reporting:
The purpose of this project is to extract customer information and provide it to the Employer of the customer who is requesting it. This system will be set up to extract customer, position and activity data daily and sends it to Employer of the customer.Edward Jones agreed to send the requested data on a daily basis to multiple vendors.
Roles and Responsibilities:
- Work with IT and Business users to evaluate complex user requests, projects, and clarify objectives and functional requirements for new or modified computer programs.
- Independently formulate detailed program specifications using structured analysis and design methodology. Prepare project documentation when needed.
- Develop detailed application designs and specifications for computer applications. May serve in technical lead capacity during project development phase.
- Write documentation describing program modifications, logic, and corrections. Oversee development of user manuals and operating procedures. Provide technical assistance to resolve operating issues.
- Provide on-the-job training for new or less experienced programmers who join the team. Mentor team to improve their understanding and skill and ensure they are familiar with resource materials including manuals and systems documentation.
- Prepared the tech designs, test plans, test cases documents.
- Developed programs using COBOL, JCLs, Procs, DB2, IDMS, CICS, MQ series.
- Developed CICS BMS Maps using SDF II tool.
- Experience in using NDM / Connect Direct tools to transfer data (customer statements) to Broadridge (ADP).
- Developed programs using MQ Series and also involved in enhancements in Assembler programs.
- Responsible for Test Execution (Unit, System, Integration and User Acceptance Testing) in mainframe applications as well as in Web applications.
- Participated in peer reviews of Designs, Code, test results.
- Developed Front end web applications using HTML, Java Script and used XML for transferring data from Mainframe to Web applications.
- Experienced in using STROBE tool for DB2 performance tuning and DBSTATS for IDMS performance tuning.
- Experienced in using DMLO and OLQ to access the IDMS databases online.
- Used Mercury QC as a testing and defect tracking tool.
Environment/Software:
Z/OS , TSO/ISPF, COBOL II, JCL, CICS, VSAM, DB2, IDMS, MQ-Series, Assembler, CA-7, Auto-sys, Xpediter , File-Aid , Abend-aid, SYNC SORT,SDSF, $AVRS(SAVERS), SPUFI, QMF, Mercury Quality Center(QC), TUX, NDM, Connect Direct ,FTP, HTML, Java Script, XML, MS Office (MS-word, Excel, Power Point).
Confidential,St.louis, MO 01/2009 – 12/2009
Sr.Software Engineer
Employer – Confidential,
Express Scripts is Pharmacy Benefit Management (PBM) which makes the use of prescription drugs safer and more affordable for tens of millions of consumers through thousands of employers, government, union and health plans.
Project: TPharm TED Core System
TRICARE Encounter Data (TED) records provide the detailed information for each (claim level)treatment encounter and are required for the TRICARE Management Activity (TMA) health care and financial reporting. TED records contain all of the financial components of the record used in reimbursement of the record, including the ESI administrative fee.
The scope of the project is to develop a fully integrated TED system, according to the unique government requirements. To support Finance by providing automated solutions around TEDs.
This project will encompass all aspects of the TED system. Including: - Initial submission - Resubmission - Adjustments - All financial controls as they relate to the ESI Administration fees - All reporting.
Roles and Responsibilities:
- Work with IT and Business management to evaluate complex user requests, and clarify objectives and functional requirements for new or modified computer programs.
- To formulate detailed program specifications using structured analysis and design methodology
- Prepare project documentation when needed. Work with functional architects to define and implement application architecture.
- To code new or modified computer programs into existing systems and test program effectiveness. This includes coding COBOL programs.
- Developed detailed application designs and specifications for computer applications.
- Perform analysis of complex systems issues or changes.
- Write documentation describing program development, logic, coding, and corrections. Oversee development of user manuals and operating procedures.
- To provide technical assistance to resolve the operating issues.
- Developed VS COBOL II programs using DB2, SQL, VSAM, CICS.
- Developed programs to maintain DEERS patient country code and TMA country code XREF table.
- Developed DB2 Triggers to update the Audit tables for every update to CTRY_XREF, OGP_XREF tables.
- Developed programs for ZIP CODE EDITS process, Overrides based on the HCC member relationship.
- To code new or modified computer programs into existing systems and test program effectiveness. This includes coding COBOL programs, command macros, creating forms, creating Indexed files and required databases.
- Responsible for Test Execution (Unit, System, Integration and User Acceptance Testing) in mainframe applications as well as in Web applications.
- Used Endevor as a version control / Change management tool.
- Used MS Visio tool to generate Flow charts and Table designs for the TED EDITS and TMA Response systems and TED MASS Error correction project.
- Analyzed and proposed new database designs to DBA for creation of DB2 tables for TED MASS ERROR CORRECTION project.
Environment/Software:
Z/OS, TSO/ISPF, COBOL II, JCL, CICS, VSAM, DB2, Assembler, File-Manager , File Manager for DB2, Xpediter, SDSF, FTP, SYNC SORT, SPUFI, Platinum, QMF, IBM Utilities, Endevor, MS-VISIO, MQ Series, QC, MS Office (MS-word, Excel, Power Point) , VOS, MVS, UNIX Cobol, DB2, Command Macros, Forms, Indexed files, DBQ, XTERM, MQ Series.
#
Confidential,St Louis, MO 03/2007 – 12/2008
Sr Programmer Analyst
Employer : Confidential,
Edward Jones is an investment company (Brokerage) and serves over 7 million clients from 10,000 branches in US and through its affiliates in Canada and United Kingdom. Edward Jones advises individual investors exclusively and offers a wide variety of investments, including certificates of deposit, bonds, stocks and mutual funds. Edward Jones has $5.20 billion in assets and has gained net profit over $391 million last year.
The client has an existing huge system consisting of 80 sub-systems. Some of the critical systems are Customer Account, Portfolio, Account Activity, Statements, Cash, Money Market, Mutual Funds, Trades, PMF etc.
Project: Edward Jones Advisory Solutions (EJAS) / Mutual Fund Advisory Account (MFAA) Project:
The purpose of the EJAS is to provide an advisory, non-discretionary account that gives our clients a combination of mutual fund and ETF investments, advice, services, and fees that is an attractive alternative to our commission-based approach; is consistent with the our investment philosophy; and reinforces our business strategy. Advisory Solutions is designed for clients who wish to pursue a long-term investment strategy in an investment advisory program and grant either full or limited investment discretion to Edward Jones for the management of their assets.
Worked on Fee reduction enhancement project as part of automation process for the EJAS application.
Project: Add CASH
The aim of the Add Cash project is to send wires to the Branch Financial advisors when the balance in the client account cross certain limit. When the Clients deposits money into their accounts, and if the balance in the individual accounts raises over $2500 or if the balance in the retirement account cross over $1500, the FA should be notified with these accounts for that branch at the end of the day. The accounts for that branch are consolidated into one wire message listing all the accounts which hits the target amount to be qualified to send a wire.
Project: DAL
DAL is a conversion project. DAL stands for Data Access Layer. The objective of DAL is to abandon IDMS and convert the existing IDMS databases to DB2. Worked on the first phase of the project, which involves converting IDMS programs to DAL, that is to convert all the IDMS call to access the Data Access Layer instead of IDMS database directly. Data Access Layer in turn fetch the data from underlying database. This database will be transparent to the users/programmers.
Project: Direct Deposit/Direct payment Enhancement: Automate the direct deposit Debits from the retirement accounts.
Project: ACH on Demand: This project is to provide Electronic funds transfer service to the customer accounts in another banks thru ACH. The front end activities involve Java and J2EE technologies.
Roles and Responsibilities:
- Involved in Business user interaction for requirement gathering and better understanding of the business.
- Prepared the tech designs, test plans, test cases documents.
- Developed programs using COBOL, JCLs, Procs, DB2, IDMS, CICS, Assembler.
- Implemented CA-7 batch schedule changes to avoid contentions with batch jobs and Online CICS transactions.
- Developed CICS BMS Maps using SDF II tool.
- Experience in using NDM / Connect Direct tools to transfer data (Check prints) to Broadridge (ADP).
- Developed programs using MQ Series and also involved in enhancements in Assembler programs.
- Involved in problem ticket analysis, Bug fixing and provide permanent fixes.
- Responsible for Test Execution (Unit, System, Integration and User Acceptance Testing) in mainframe applications as well as in Web applications.
- Participated in peer reviews of Designs, Code, test results.
- Experienced in using Mercury QC as a testing tool for defect tracking and storing test plans.
- Developed Front end web applications using HTML, Java Script and used XML for transferring data from Mainframe to Web applications.
- Experienced in using STROBE tool for DB2 performance tuning and DBSTATS for IDMS performance tuning.
- Experienced in using DMLO and OLQ to access the IDMS databases online.
- Developed MQ series programs for EJAS project and involved in testing the MQ programs.
- Extensively involved in testing the Batch jobs/Onlines/ADP jobs in the CASH system and created “CASH- system test document” for future reference.
- Provided Technical support/Mentoring to the Team members.
- Review existing programs and assist in making refinements, reducing operating time, and improving current techniques.
Environment/Software:
Z/OS , TSO/ISPF, COBOL II, JCL, CICS, VSAM, DB2, IDMS, MQ-Series, Assembler, CA-7, Auto-sys, Xpediter , File-Aid , Abend-aid, SYNC SORT,SDSF, $AVRS(SAVERS), SPUFI, QMF, Mercury Quality Center(QC), TUX, NDM, Connect Direct ,FTP, HTML, Java Script, XML, MS Office (MS-word, Excel, Power Point).
#
Confidential,Frankfort, KY 05/2005 – 01/2007
Information Analyst
Employer: Confidential,
Kentucky Medicaid Project (KY-MMIS):-
The Commonwealth of Kentucky is responsible for administering the Kentucky Medicaid program. The Legacy KY MMIS supports fee-for-service Medicaid claims processing functions and the information and processing needs of the managed care program.
EDS is the Fiscal Agent to perform the claims payment and related health operations functions supporting Federal and State administrative requirements for eligible Medicaid members.
Adjudicated claims for eligible Medicaid members are processed through the Legacy KY MMIS based on DMS business requirements.
Roles and Responsibilities:
- Greatly involved in understanding of the new design requirements related to the Claims Processing subsystem and implementing them for the Claims Batch cycle.
- Task includes full functional testing and fixing problems of common online modules of all claim types (Institutional, Medical and Dental) such as Claim Exam Entry, Claim Correction and Claim Inquiry modules.
- Involved in analysis, Tech Design, Unit test plans Unit test Cases.
- Provider extracts programs and Provider status reports. Worked on CICS online screens, coding as per the specification and standards, creating test data for unit testing, performing extensive unit testing of each program to verify functionality.
- All the programs (COBOL, DB2, CICS, VSAM) are coded and tested in accordance with the business rules and requirements of the KY department of medical assistance services.
- Also involved in supporting the system test for the Provider subsystem, setting up the JCL, Procs in compliance with production Procs and procedures for execution of string test of the programs.
- Documentation of all the tasks executed that includes change log, online screen documents, business user manuals and demo of new changes on the screens to the users.
- Experienced in enhancement and creation of CICS BMS Maps and programs.
- Worked with SDF II tool for generating BMS Maps.
- Responsible for test execution (Unit, System, Integration and User Acceptance Testing).
- Participated in the status meetings with Client.
- Prepared mainframe systems specification, user systems requirements and system test plans.
- Prepared EDI specification documents for EDI map development, testing, and implementation.
- Involved in Incident analysis, Bug fixing and providing the permanent fixes.
- Provided technical support/mentoring to the team.
- Executed SQL statements using SPUFI, QMF tools.
- Used Xpediter for batch testing and Intertest for online testing.
- Experience in using FTP, NDM / Connect Direct tools to transfer files.
- Involved in production support activities (24X7).
Environment/Software:
IBM S370, TSO/ISPF, COBOL II, CICS, DB2, VSAM, JCL, Xpeditor, Abend-Aid, Intertest, CA7, FTP, NDM/Connect: Direct, Endevor, SPUFI, QMF.
#
Confidential,PLANO, TX 04/2002 – 04/2005
Information Analyst
Employer: Confidential,
The main aim of this Project is to perform the HIPAA Re-mediation project for the Arkansas Medicaid System. HIPAA is primarily being introduced to reform Health insurance and to simplify the administrative functions. HIPAA is designed to promote the electronic exchange and handling of health care information. It establishes standards for storing and transmitting transactions, maintaining the privacy of protected health information, and maintaining the availability and security of health information.
Because of the HIPAA Act, Arkansas Medicaid system is undergoing major changes. The sub-systems Front-end/Input Conversion/Control series, Medical Policy, Eligibility/Provider, Online, Extract Refreshes, Reference, Management and Administrative Report System, DSS Extract have been identified to make changes to be HIPAA compliant.
Roles and Responsibilities:
- Involved in analysis and design of the systems that included Beneficiaries, Providers, Claims Processing and Eligibility according to business requirements
- Analysis, preparation of tech design, unit test plans, unit test cases.
- Participated in peer reviews.
- Extensively used CA-7 for production support activities.
- Involved in full SDLC from analysis to implementation of CSRs.
- Modified COBOL, VSAM, CICS, JCL programs.
- Construct new programs for data conversion (COBOL, VSAM).
- Experienced in enhancement of CICS Maps and CICS programs.
- Used HTML, Java Script for development of web application.
- Unit testing was done by using the XPEDITER for batch programs and INTERTEST for online programs.
- Actively involved in the system testing.
- Prepared EDI specification documents for EDI map development, testing, and implementation.
- Used IBM Rational Rose, clearcase, clearquest, RequisitePro (Req Pro), Testmanager tools.
Environment/Software:
OS/390, TSO/ISPF, COBOL II, CICS, JCL, DB2, VSAM, Endevor, Easytrieve, Assembler, Intertest, Xpediter, CA-7,File-Aid, HTML, Java Script, MS Office (MS-word, Excel, Power Point).
#
Confidential,Kuala lumpur, Malaysia 10/2001 – 04/2002
Consultant
Employer : Confidential,Malaysia
Maybank is the largest financial services group in Malaysia. Its extensive products and services include commercial banking, investment banking, offshore banking, leasing and hire purchase, insurance, factoring, trustee services, asset management, stock broking, nominee services, venture capital and Internet banking.
Maybank is the largest banking group, provides consumer, and banking services in Malaysia including internet banking.
Projects :-
Stratus Conversion: This Project is a conversion of Stratus VOS environment to Z/OS mainframe environment.
CCOCC development : CCOCC subsystem is developed to automate the Maybank cheque clearing process of credit card system. The system runs parallel with two other systems (SAFE, MFB).
Roles and Responsibilities:
- Analyzed the Functionality of the existing system and Stratus VOS environment.
- Analyzed the SEMA group programs and manuals of CARDPAC.
- Analyzed the VOS COBOL programs, Forms, command macros.
- Involved in Preparation of High level / Low level design documents & Specifications.
- Developed the new programs using COBOL II, CICS & VSAM to process the files and interact with the CARDPAC to update the card holder a/c.
- Developed the new programs for data conversion.
- Developed the batch programs for formatting and generating of reports.
- Involved in the Unit Testing & System testing.
- Used CA-Intertest & CEDF for debugging the CICS programs in the Z/os environment.
- Used IBM Rational Rose, clearcase, clearquest, RequisitePro (Req Pro), Testmanager tools.
- MQ series is used to write the data when the files are received by FTOCC.
- Involved in On-Call Production Support 24x7, Problem solving, small enhancements, Performance monitoring, and interacting with users
- Involved in production problem identification & bug fixing
Environment/Software:
Stratus, VOS, COBOL, Forms, command macros, OS/390, TSO/ISPF, CICS, JCL, VSAM, Panvalet, Intertest, CARDPAC, MQ Series, SDSF, SPUFI, QMF, MS Office (MS-word, Excel, Power Point).
#
Confidential,Bentonville, AR 11/2000 – 10/2001
Programmer Analyst
Employer : Confidential,
Wal-Mart is one of the leading Wholesale & Retail stores in the world. The Return sheet system is the main source of mediation between the stores and the buyers. The projects involved in the return sheet system.
Projects:-
DC Expansion : - The project mainly involves the expansion of the return sheet system providing provision for DC expansions. The system was running out of the warehouses. This project was implemented to provide expansion of DCs.
Check point restart : - The check point restart logic changes were done around 300 programs including IMS and DB2. This was a huge project cantering around 60 teams of the entire ISD (Information Systems Division).
Involved in the development of the End of Season and Beginning of Season reports for the buyers and the stores.
Roles and Responsibilities:
- Analyzed the functionality of the existing RSS system.
- Prepared the tech designs and test plans for DC expansion project. Modified the COBOL, IMS DB, DB2 programs as part of DC expansion project.
- Changed the entire return sheet system for accommodating new Distribution Centers
- Added the Check-point/Restart functionality for the COBOL, IMS DB, DB2 programs.
- Tested the programs with and without check-point/Restart logic.
- For the system testing, tested the complete flow, compared the results with production
- Used the Platinum tool for DB2, to verify the table data, and to fetch the data for test purpose.
- For unload & load the DB2 tables BMC tools are used.
- Unit testing was done by using the Xpediter, compared the results with production
- For the system testing, tested the complete flow of jobs and compared the results with production.
- Modified the CICS Maps, CICS Programs as part of enhancement of PO Module.
- Used Code Walk through and Change control Process for implementation.
- For generating reports used SAS.
Environment/Software:
MVS/ESA, TSO/ISPF, COBOL, DB2, CICS, IMS/DB, SAS, EASYTRIEVE, JCL, VSAM, FILE-AID, SDSF, SPUFI, QMF, Platinum tool.
#
Retail Banking 12/1999 – 10/2000
Confidential,Malaysia K.L, Malaysia.
Employer : Confidential,India
AMBANK (previously known as Arab Malaysian Bank) is leading local bank in Malaysia which operations in financial domains like leasing finance, House loan, retail banking, and credit card services. The bank utilizes ALLTEL core banking application modules. These modules are customized to the bank\'s requirements. ALLTEL is installed on IBM Mainframes. I was involved in ST/IMPACTS/IC, ACH (Automated Clearing House) and OCM24hr ATM package.
Roles and Responsibilities:
- Design, Development in Bill Payment System in OCM24.
- Maintaining ATM System in Test &Quality environment
- Analyze the Job flow for ACH system.
- Involved in developing programs to merge AmFinance customer data into OCM system. Perform batch and online testing in Mock environment.
- Branch Rationalization is the exercise of merging one branch with another. One branch will be closed and the business activities of this closed branch will be transferred to the target branch.
- Involved in Automatic Legal Electronic Recovery Tracking System, which keep the Alert database synchronized with Host data.
- Unit Testing, Integration testing
- Involved in On-Call Production Support 24x7, Problem solving, small enhancements, Performance monitoring, and interacting with users
- Production cycle monitoring
- Involved in production problem identification & bug fixing
- Identifying, Unloading and Loading Test data from Production to Test regions
- Documentation as per Client standards
- Analyze the Job flow to make ATM system works for 24 hrs.
Environment/Software:
MVS, ES/9000, TSO/ISPF, VS COBOL II, PL/1, CICS, DB2, IMS DB, Easytrieve, VSAM, JCL, Changeman, FILE –AID, FTP, SPUFI,QMF,Xpediter,Intertest,SDSF.
Educational Qualifications:
Bachelor of Technology (B.Tech).