Senior Mainframe/data Analytics Consultant Resume
PROFESSIONAL SUMMARY:
- 15+ years of extensive experience in Analysis, Design, Development, Implementation, Production Support, and testing of Business Applications software in Mainframe technologies.
- Responsible individual who can work independently or lead or in a group/team setting to meet deadlines while handling multiple assignments.
- Possess skills in trouble - shooting problems in a wide variety of applications, production problems and provide solutions.
- Good knowledge of Data warehousing concepts and ETL processes.
- Proficient in unit, system, regression, QA testing and preparing SDLC documentations.
TECHNICAL SKILLS:
Operating Systems: Z/OS, MVS OS/390, MVS OS/370, ES9000, UNIX, LINUX, VMS and WINDOWS.
Software: COBOL/COBOL II, DB2/SQL, DB2 STORED PROCEDURES, CICS, BMS, PAINT, VSAM, JCL, PLATINUM TOOLS, DB2 UTILITIES, JAVA, XML, JSON, TERADATA, SQL ASSISTANT, FAST LOAD, XPORT, COMPAREX, DYL-280, Confidential UTILITIES, PANVALET, UDB, MQSERIES, FILEAID, EASYTRIEVE, TSO/ISPF, EXPEDITOR, CHANGEMAN, LIBRARIAN, ENDEVOR, SPUFI, QMF, SYNCSORT, FTP, VPN, NDM, FILEMASTER, CA-1, CA-7, JIRA, CONFLUENCE, IMS DB/DC, SMARTTEST, INTERTEST, MS OFFICE and IDCAMS.
EXPERIENCE:
Confidential
Senior Mainframe/Data Analytics Consultant
Responsibilities:
- Writing technical specifications and developed client s system in mainframe.
- Unit, system, Regression, end to end testing and supporting QA teams.
- Production support during batch cycles.
- Used ENDEVOR change management to develop, maintain and move all components into the production.
Technical Environment: DB2, COBOL, JCL, LINUX, TOAD, HIVE, HUE, IMPALA, Z/OS, FTP, ENDEVOR, FILEMASTER, ICETOOL, IDCAMS, TSO/ISPF, SYNCSORT.
Confidential
Senior Mainframe Consultant
Responsibilities:
- Agile methodology was used for the entire project and I was involved in sprint planning coordination with the ADL.
- Attended daily standup meeting with the ADL and the technical team.
- Used JIRA for project planning and document repository.
- Developed an in-house search algorithm which scans the entire library and list out all elements affected by the change and it replaced the time consuming manual search.
- Developed an in-house MQ Router module which enables communication with DTCC and BoNY initiated from different test systems at the same time.
- Re-write some old Cobol/CICS/DB2/VSAM programs into a latest version and modified countless programs.
- Executed unit, system and integration testing and supported UAT.
- Re-designed and developed part of the system to improve the efficiency.
- Used ENDEVOR change management to develop, maintain and move all components into the production.
Technical Environment: DB2, COBOL, CICS, VSAM, JCL, Z/OS, FTP, ENDEVOR, FILEAID, PLATINUM TOOLS, XPEDITOR, FILEMASTER, IDCAMS, TSO/ISPF, SYNCSORT.
Confidential, New Jersey
Senior Mainframe Developer
Responsibilities:
- Writing technical specification and developed client’s system.
- Attended the end client’s meeting to support the Account Manager for technical aspects.
- Represented the Billing team for internal intra-department meeting to resolve any issues aroused.
- Unit, system, Regression, end to end testing and supporting QA teams for their quality testing.
- Lead an offshore team for the systems development and support and provided the technical education to all members in the team.
- Production support during batch cycles.
- Resolved client’s billing issues and recreated the files when requested.
- Supported the internal audit team for any client’s external audit.
- Helped the Account Managers for all their queries and created ad-hoc reports.
- Used ENDEVOR change management to develop, maintain and move all components into the production.
Technical Environment: TERADATA SQL ASSISTANT, TERADATA EXPORT/LOAD UTILITIES, DB2, COBOL, CICS, VSAM, JCLZ/OS, FTP, ENDEVOR, FILEAID, PLATINUM TOOLS, XPEDITOR, FILEMASTER, IDCAMS, TSO/ISPFSYNCSORT.
Confidential, NYC
Senior Technical Analyst
Responsibilities:
- Attended technical design meetings with project managers and involved in designing system architecture.
- Developed technical specifications for each component in this project.
- Lead a team of three developers for this project.
- Used SWIFT 202,103,900,910 formats for financial transactions involved.
- Used XML tags to enclose SWIFT messages as per GMA standard.
- The XML messages are then sent to Money Transfer system using MQ technology.
- Developed online screens using CICS/DB2.
- Developed DB2/COBOL/IMS programs for constructing messages and parsing incoming messages from other systems via MQ.
- All development processes are automated using Internal Reader, CICS Interval Control and in-house Job Scheduling software (PICS).
- Involved in unit, system testing and supporting UAT.
- Used ENDEVOR change management to develop, maintain and move all components into the production.
- Involved in production migration and on-call support.
- Worked on Credit, Debit and Combined Interest products.
Technical Environment: ENTERPRISE COBOL III, CICS, DB2 v8.1, VSAM, JCL, Z/OS, MVS/ESA, ENDEVOR, FILEAID, JAVAPLATINUM TOOLS, XPEDITOR, FILEMASTER, IDCAMS, TSO/ISPF, SYNCSORT, MQSERIES and IMS.
Confidential, New Jersey
Senior Programmer Analyst
Responsibilities:
- Arranged and attended user meetings and confirm the functional requirements.
- Developed Technical Design and arranged peer review meetings for design approval.
- Developed COBOLII/DB2/CICS programs, JCL, PROCS, CONTROL CARDS and COPYBOOKS.
- Used EZTRIEVE, SAS, FILEAID, SYNCSORT and FILEMASTER for various billing file manipulations.
- Handled a team of 3 members from offshore as a team leader for UHG billing file changes.
- Developed FTP/VPN and NDM jobs for billing file transmission to clients.
- Created unit, system, regression test plans and executed.
- Coordinated and assisted QA and UAT teams for testing and approvals.
- Created ENDEVOR packages to move all mainframe components to production.
- Production support and on-call support during weekends on rotational basis.
- Followed full SDLC process and created technical Design, Code Review, test plans, QA gates and Checklist documentations including getting approvals.
- Created change control documents.
- Fixed various production problems, re-created billing files and re-transmitted to clients.
- Closely worked with team members and other support groups to nail down any technical issues.
Technical Environment: COBOL II, CICS, DB2, VSAM, JCL, Z/OS, MVS/ESA, ENDEVOR, FILEAID, XPEDITOR, FILEMASTER, INTERTEST, FILEAID, IDCAMS, TSO/ISPF, SYNCSORT, FTP, NDM, MQSERIES and TEREDATA.
Confidential, New Jersey
Senior Programmer Analyst
Responsibilities:
- Analysis the existing system and prepared system modification design document.
- Prepared resource estimation.
- Document the programs, JCLs, PROCs, DBRMs, copybooks affected by new changes.
- Extract data from DB2 database using Batch COBOL and JCL.
- Developed new DB2/COBOL II batch programs.
- Developed new online screens using CICS II/COBOL/VSAM for new deal tracking functionality.
- Modified both batch and online programs involving CICS/COBOL II/DB2/VSAM/IMS D/C.
- Used FILEAID, SYNCSORT and EZTRIEVE to create test data.
- Used SMART TEST for program debugging and PAINT software for CICS online screens.
- Involved in unit, system and UAT testing with test plan preparation.
- User demonstration of new functionality and user manual.
- Used CHANGEMAN to migrate the mainframe components to production.
- Problem fixing and production support including on-call.
- Followed SDLC process and documentation on various stages of projects.
Technical Environment : COBOL II, CICS, DB2, VSAM, IMS/DC, JCL, CHANGEMAN, FILEAID, SMARTTEST, IDCAMS, TSO/ISPF, SYNCSORT, PAINT