SUMMARY:

• Over 11 years of experience in Information technology industry involving in all phase of SDLC cycle for mainframe application.
• Having 4 years of Project Management experience in managing small to medium size Mainframe/Salesforce Development project.
• Published an App on GOOGLE ANDROID PLAY STORE - PMP2016.
• Experienced in Data analysis, mining & retrieval utilizing SQL from relational databases, Excel and other data management systems.
• A technocrat in Application Development, Maintenance and Production support in Mainframe(JES3, COBOL, DB2, IDMS,ADS/O, JCL, CICS, CICS SOLA (SOA) Web interface, MQ Series, SQL, VSAM, Stream Weaver, Exstream, Rexx, Macro).
• Thorough hands-on experience on HP EXSTREAM FORMATTING TOOL, RDZ and QTP.
• Experienced with Defect Management Tools - Quality Center for reporting and defect logging, HP CQ, IBM RTC.
• Z/OS & MVS IBM Mainframe systems and Web applications (Explorer --x, HTML, XML), Java, UNIX, Win 95/98/2000/NT, 4.0/2000/ME/XP, DOS platforms, Oracle Apps.
• Extensive Database testing/Analysis: RDBMS, DBMS, DB2 using SQL Developer, SQLPlus (SQL).
• Proficient in designing HLD, LLD, SRS & BRS, Test Plan, Test Cases, Test Scripts and Test Scenario for application development.
• Worked as a Project lead in Confidential - Confidential for a Banking Project.
• Worked as a Project Manager in Anthem - BCBS for a Health Insurance Project.
• Expertise in analyzing existing systems and procedures, enhancing the systems for supporting new features as per customer requirements and to increase the operational efficiency and implementation of new sub-application.
• Adept at gathering and documenting requirements, assessing business objectives, and managing all stages of software development and implementation
• Gained exposure in the end-to-end development of software application from requirement analysis to system study, designing, coding, testing, de-bugging, documentation and implementation.
• An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management.
• Experienced in 24/7 production support/ Disaster Recovery exercise of mission critical mainframe applications.
• Experienced in migration and conversion of mainframe applications
• Experienced in training, leading, mentoring and managing offshore teams across multiple countries(USA, India and Philippines)
• Well versed in Waterfall software development and Agile methodology approaches
• Experienced in leading multiple project teams in building and supporting mainframe based applications.
• Experienced in Finance & Health insurance domains.
• Experienced in Functional Testing, System Testing, Regression Testing and User Acceptance Testing.

TECHNICAL SKILLS:

RDBMS: SQL Server, MS Access, DB2, Spufi & Platinum, IMS.

Defect Management Tools: Quality Center, Clear Quest.

Operating Systems: MS-DOS, Windows 98/NT/2000, Win XP, UNIX, Z/OS, MVS.

DB Tools: MS Access, Microsoft SQL server, SQL Developer, Transact - SQL (Query Analyzer).

Languages/Dev Tools: COBOL, JCL, Stream Weaver, REXX, DYL, VB, SQL, PL/SQL, C, C++, XML, MQ series, CICS.

Scripting Language: HTML, XML, UNIX shell scripts, VB

Letter formatting tools: Exstream 7.0

Other: Microsoft Office, Visio 2000, RDz, QTP.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Project Manager/System/Data Analyst

Responsibilities:

• Onsite Project Manager for CHIPS E&B Application with 3 members in onsite and 16 members in offshore (India and Philippines).
• Project Management activities including timelines, cost, change requests, status gathering from all impacted teams etc. using Software Development Life Cycle (SDLC) Methodology
• Primary production support on-call for membership online and batch support (from 8 AM to 8 PM EST) and second level support for nightly batch cycle.
• Allocate hours between onsite and offshore resources and work on capacity planning for work assigned to development team for different projects.
• Monitor SLA adherence for production support tickets and development projects for number of defects, on time delivery and estimation accuracy.
• Facilitate offshore team with code review, design review and test plan review with client team and getting all necessary approvals for implementation of project as per change management guidelines.
• Doing impact analysis on the new requirement or change request on the existing programs initiated by the clients.
• Data mining & analysis - Complex PL/SQL queries devised using Joins to retrieve data from multiple tables in response to various frequent reporting requests to build and maintain recurring metrics and reports.
• Prepare and execute Disaster Recovery plan for Anthem Virginia systems.
• DB2 SQL Fine tuning/Query optimization for Mainframe application to reduce CPU usage.
• Analysis of existing program using Debugging tool/Writing new COBOL program for new requirements adhere to the industry standard, writing new JCL / proc to schedule new jobs for the proposed system.
• Brainstormed the idea of using CRM Salesforce to build the Application information system to retain the Application knowledge- This Project falls under in house Application Management built to record day to day activity and ongoing maintenance and enhancement details so to retain the application knowledge on the cloud. Down the line the CRM Salesforce system can use the stored info to generate impact analysis report, alerts based upon the events happened in the past, Email to developer and superiors prompting workflow for an ongoing/pending/completed task. A self maintained application encyclopedia.
• Developed & maintained MQ series used receive Enrollment file from external vendors and MQ series used to transmits eligibility files daily, weekly and monthly to various vendors.
• Worked on multiple Nasco/Medsupp migration project.

Hardware IBM Mainframe

Operating System Z-OS, Windows-XP

Language Apex, vf-pages, Triggers, JCL, VSAM, COBOL, SQL, DB2, IMS

Tools: Salesforce.com IDE, Endeavor, DFsort, EzyTrieve, IBM File Manager, ISPF, QMFSPUFI, Platinum, IMS DB/DC, TSRM, HP Quality Center, IBM Debugger.

Project Manager / Programmer (System/Data) Analyst - Onshore Development Lead

Responsibilities:

• Resource Management and Onsite-Offshore coordination
• Doing impact analysis on the new requirement or change request on the existing programs.
• Developing/Coding Application using COBOL, DB2, CICS and SOLA (SOA) Web interface Programs. Wrote Jcl/Proc for the Batch system.
• Analysis of COBOL module for complete Test coverage & Process documentation.
• Wrote Macros, Used QTP to efficiently handle high volume of repetitive task.
• Developing case diagrams and preparing HLD & LLD, Test cases and Test scripts based on business requirements
• Data mining & analysis - Complex PL/SQL queries devised using Joins to retrieve data from multiple data warehouse tables in response to various frequent reporting requests. The same were scheduled to run frequenting emailing the reports to the users.
• Coding done using HP Exstream to generate AFP documents using XML as input. Used Stream weaver/Rexx to sort & reformat the AFP file before spooling the output to the Printers.
• Developed & maintained MQ series to receive Check Data and images from Distributed Check 21 system to generate service notices for check deposits with/without Check images as opted.
• Composed and scheduled complex SQL queries to pull data from multiple table from the data warehouse tables satisfying Business needs for various annual audit and reporting request.
• Handling Production ABEND, monitoring nightly batch jobs and providing immediate fix.
• Managing the configuration and controlling the version using version control tools i.e. Endeavor.
• COBOL code performance tuning, DB2 SQL Query optimization thus enhancing efficiency of Mainframe application to reduce CPU usage.
• HP QC tool used to maintain/resolve Client queries.
• Worked on migration of Brokerage accounts from BOA existing vendor to Confidential platform after the Merger.

Hardware IBM Mainframe

Operating System Z-OS, Windows-XP

Language JCL, VSAM, COBOL, SQL, DB2, CICS SOLA web interface.

Tools: Endeavor, DFsort, EzyTrieve, DYL280, File Aid, and ISPF, QMF, SPUFI, Platinum, and

Hummingbird workbench for Windows NT, QWS3270, HP Exstream, INTERtestRational Clear Quest, MQ series, Rexx, QTP.

Programmer Analyst - Offshore Lead

Responsibilities:

• Offshore Lead for Production support and Enhancement request.
• Developing/Coding Application using COBOL, DB2 and CICS Programs. Wrote Jcl/Proc for the Batch system.
• Analyzed/Debugged CICS COBOL modules using INTERTEST - as impact analysis / to ensure complete Test coverage.
• DFSort to sort and compare large volume datasets for test validation & Adhoc reporting request.
• Wrote Macros, Used QTP to efficiently handle high volume of repetitive task.
• Developing test strategies for efficient and error free testing (preparing Unit test plans and doing Unit test reviews)
• Monitoring payment/deposits through CICS online transaction for Lockbox located at various geographical location.
• Doing reviews for offshore deliverables ensuring round the clock system support.

Hardware IBM Mainframe

Operating System Z-OS, Windows-XP

Language JCL, VSAM, COBOL, VB Script, SQL, DB2

Tools: Endeavor, DFsort, DYL280, File Aid, ISPF, QMF, SPUFI, Platinum, Hummingbird

Workbench for Windows NT, QWS3270, Exstream, QTP, and Macro.

Production support

Responsibilities:

• Started as Project Trainee and later joined as fulltime offshore resource for IAS system.
• Doing research and analysis in response to the Client queries/Onshore request.
• Writing Adhoc Sort jobs and COBOL code fixes for Production issues identified.
• Project documentation, Cost saving analysis and Code optimization.
• Test/QA region setup and maintenance with daily refresh from Production data.
• Batch cycle monitoring and offshore Production support in case of any batch abends.
• Pulling daily report for the mutilated Invoices for past night Batch run and re-spooling the same by manual FTP.
• Developing/Coding Application using COBOL, IDMS and ADS/O Programs. Wrote Jcl/Proc for the Batch system.

Hardware IBM Mainframe

Operating System MVS, Windows-XP

Language JES3, JCL, VSAM, COBOL, SQL, IDMS, ADS/O

Tools: Endeavor, DFsort, DYL280, File Aid, ISPF, QMF, SPUFI, Platinum, Hummingbird