Mainframe Tech Lead/Programmer Analyst

Girish Kumar Sure

Tech Lead Email: ********************@*****.***, Cell: 952-***-****

Professional Summary

Tech Lead with 13+ years of experience working in different stages of Waterfall and Agile Development environments. Strong desire to learn new technologies, adapt to the project circumstances and specializes in identifying the problems and provide solution quickly.

Technical and Management Skills

Extensive Knowledge of working in Mainframe Applications over MVS, OS/390, VSE, using COBOL, JCL, DB2, IMS, CICS, Stored Procedures, SQL, Easytrieve, MQ, Coolgen, CA-7 (Scheduler), FTP.

Worked on IBM tools like Endeavor, Changeman, Xpeditor, File-Aid, File-Manager, Debug, Platinum, Softech, Strobe, SPUFI, QMF.

Experienced in using Teradata tools (BTEQ) to unload/load data from/to Teradata for Business Users to perform statistical analysis, using Microstrategy for better forecasting and develop strategies.

Expertise in analyzing, designing, developing, testing and implementation of Client-Server, Client-Online and Batch based Coolgen programs, using AdvantageGen 6.5 ver.

Extensive Knowledge in test execution process with experience in various phases of testing like Unit Testing, System Testing, Regression Testing, User Acceptance Testing.

Experienced in developing test plans and test cases and traceability matrix to map the requirements.

Hands-On experience in setting up test data writing SQL queries through SPUFI and testing both Batch Mainframe and Java based Online (Stored Procedures) applications.

Good knowledge of developing Python programs for analyzing large datasets, data cleaning, data pre-processing, performing exploratory data analysis, and develop machine learning algorithms.

Experienced working in a Test Driven Development using Agile-Scrum Methodologies.

Actively participated in Scrum ceremonies like Sprint planning, Sprint review, daily standup and Sprint retrospective meeting and address the impediments in a quick and timely manner.

Experienced with Project Estimation, Project Planning, Project Management, Onsite-Offshore model execution, Change/Incident Management process and developing automated tools in REXX.

Technical Skillset

Languages

COBOL, JCL, SQL, DB2 Stored Procedures, CICS, Coolgen, EASYTRIEVE, DYL280, REXX, C, C++, Python 3.7

Tools

Endeavor, BMC, SPUFI, QMF, CA7 (Scheduler), JMR, $avers, ERWIN, AdvantageGen, Softech, Platinum, ChangeMan, XPeditor, File-Aid/File Manager, Abend-Aid, QMF, IBM Utilities, FTP, NDM, IBM MQ, MQ Listener, HP Service Desk/Service now, HP Quality Center, DEBUG, EXPLAIN, STROBE, SAS, MS Visio, MS Excel, Jupyter Notebook, Tableau

Database

DB2 V10, DB2 V9, DB2 V8, Teradata, IMS, VSAM, Oracle, MySQL

Server

Windows 10, Windows 7, Windows XP, OS/390, Z OS, VSE

Libraries

BTEQ, Numpy, Pandas, Matplotlib, Sklearn, BeautifulSoup, Urllib, Requests

Certification

IBM Certified Database Associate in DB2 Family Fundamentals - Exam 700

Awards

Stood as one of the top 50 COBOL Coders in the organization

Education and Achievements

Master’s in Information Technology Management, with a GPA of 4.0.

Bachelor of Technology in Electronics and Communication.

Fulfilled project needs and delivered on time by learning and implementing Coolgen, Teradata, CICS and CA-7 script writing, effectively.

Received many appreciations from Target Management for an effective delivery and helping Target Business at different levels in executing a project.

Trained new joiners on COBOL, JCL, DB2, CICS Retail Overview, Target Replenishment Overview and Unit/System Test execution.

Key participant in Business discussions and provided better ways of enabling Multi Channel capabilities for Target Corporation.

Excellent communication skills, documentation skills, problem solving ability, analytical and programming skills, and quality conscious.

Professional Experience

Express Scripts, Bloomington, MN June 2020 – Till Date

Tech Lead/Sr. Programmer Analyst

Encounters system extracts the Medicare and Medicaid Claims from Terradata IW Warehouse, validates the Claims data and reports them to LOBs and State Governments for confirmation on claims processing.

Responsibilities:

Developed data mapping document from Teradata EDW to Mainframe for data validation process.

Developed COBOL programs, JCLs and PROCs and FTP Process and performed Unit Testing and System Testing.

Developed JCLs and SQL Queries to unload the data from Teradata to Mainframe Dataset, using BTEQ Proc.

Actively involved in User Acceptance Testing, developed and executed Test Scripts, recorded test results and maintained errors and bug tracking.

Track the tasks and intakes through Jira.

Coordinate with team on a weekly basis in communicating the status to Project Team and Manager.

Environment/Tools: OS/390, COBOL, JCL, Teradata, DB2, CICS, CA-7, FTP, VSAM, ENDEVOR, SPUFI, Xpeditor, Platinum, Jira, ServiceNow.

St Mary’s University of Minnesota May 2019 – April 2020

Research Analyst

Product Recommendation System

In the E-Commerce industry, it is very important to please and satisfy the customers by providing better promotions, easy identification of products and an easy access of website. In addition to these, it is equally important to have an effective recommendation model that can bring incremental revenues. This can be achieved only when the recommendation model can understand the customer purchase patterns and recommend the products to potential buyers.

Through this project, I am trying to achieve the below recommendation engines on the sales dataset

a)provide a list of top selling items and most popular items

b)provide a list of top selling items and most frequently purchased items of a customer

c)recommend the items to the customer, based on the similar purchasing pattern of other customers (Kendall Correlation)

d)recommend items to customer, based on the item in the view

Responsibilities:

Developed Python programs to perform Data Cleaning and Exploratory Data Analysis on dataset.

Identified the right algorithm based on the pattern of data and developed programs to understand similarities among Products and Customers.

Created .pkl files with results of data analyzed, which are used to publish the results on to website.

Developed Flask web framework in Python to publish results on to website.

Created HTML files to format the website and used basic CSS for page styling.

Deployed the application on Heroku platform and integrate with a website to extract the results.

Built the functionality by following Agile Methodology and RESTful API services.

Environment/Tools: Python 3.7, Jupyter, Flask, Heroku, Tableau, HTML, Windows 10, MS Office, MySQL.

Website: http://product-recommendation-system.herokuapp.com/

Wells Fargo & Co., Minneapolis, MN March 2017 – September 2017

Tech Lead

Enhancements to General Ledger Application and Oracle Migration

General Ledger Application interacts with around 40+ applications, receives data and stores in its Transaction Depository for further processing and publishes several reports. Due to the incremental of applications interacting with General Ledger, it requires multiple changes in order to accept the new channels and incorporate in the existing reports. Also, General Ledger is migrated to Oracle platform from Mainframe, which requires extensive compatibility testing.

Responsibilities:

Analyzed GL reports in validating the data processed by source applications and communicate the results.

Created and reviewed Low level Design documents based on High Level Design documents, to incorporate new application data for GL processing.

Developed COBOL-DB2 programs, COBOL-CICS programs, JCLs and PROCs and performed Unit Testing and System Testing.

Support Oracle migration compatibility testing by coordinating with other application owners.

Modified JCLs and PROCs of automated compatibility testing process to support File-Aid to File Manager migration.

Actively involved in User Acceptance Testing, developed and executed Test Scripts, recorded test results and maintained errors and bug tracking using HP Quality Center (HP-QC).

Coordinating with Offshore team and assign tasks through Quality Center and communicating the status to Project Manager.

Environment/Tools: OS/390, COBOL, JCL, DB2, CICS, CA-7, Oracle, FTP/NDM, ENDEVOR, FILE-AID, File Manager, SPUFI, SAVRS, Xpeditor, Platinum, HP Quality Center, ServiceNow.

SpartanNash, Edina, MN May 2015 – February 2017

Tech Lead

MW to SWAT Conversion October 2016 – February 2017

This project is to support the SpartanNash’s strategic decision to have all DCs’ billing systems, currently Midwest (MW), SWAT and Grand Rapids (GR), to convert to SWAT Billing system and retire MW and GR Billing Systems. This enables to standardize the Customer’s experience and support both internal and external users through SWAT DCs. The project is to perform analysis in identifying the data required to send from MW to SWAT systems. Design and develop the system based on the functionality and perform testing to ensure a smooth execution of conversion of all DCs.

Item Authorization setup by decoupling from Private Zone Retail May 2015 – September 2016

Currently, Item Authorization is supported by Retail Price setup when a Private Zone is tied to the Customer. This project decouples the above and provides a provision to the Customers to Authorize Items to them explicitly irrespective of Retail Price setup in Private Zone. This involves changes to all existing functionality and reporting.

Responsibilities:

Actively participated in Daily standup, Sprint planning and Sprint Review and delivering the required artifacts.

Worked closely with Product Owner in clarifying the issues with User-Stories, track the progress of User-Stories, and log the bugs on HP Quality Center.

Worked with DBA in designing new DB2 tables and developed DDLs.

Created the platinum load JCLs to load the DB2 tables and perform reorg, runstats, etc.,

Developed COBOL-IMS and COBOL-DB2 programs, CICS Maps, JCLs and SLIs and performed Unit Testing, Performance Testing and System Testing.

Extensive development work on VSE-COBOL, MVS-COBOL, VSAM, IMS, DB2, CICS Screens.

Coordinate with a team of five both at Onsite and Offshore, gather the project status and share the report with Project Manager.

Environment/Tools: VSE, MVS, COBOL, JCL, SLI, PROC, IMS, DB2, CICS, VSAM, File Manager, ServiceNow.

Wells Fargo & Co., Minneapolis, MN April 2014 – April 2015

Tech Lead

Enhancements to General Ledger Application and Oracle Migration

General Ledger Application interacts with around 40+ applications, receives data and stores in its Transaction Depository for further processing and publishes several reports. Due to the incremental of applications interacting with General Ledger, it requires multiple changes in order to accept the new channels and incorporate in the existing reports. Also, General Ledger is migrated to Oracle platform from Mainframe, which requires extensive compatibility testing.

Responsibilities:

Created and reviewed Low level Design documents based on High Level Design documents, to incorporate new application data for GL processing.

Developed COBOL-DB2 programs, COBOL-CICS programs, JCLs and PROCs and performed Unit Testing and System Testing.

Support Oracle migration compatibility testing by coordinating with other application owners in capturing the required data into Transaction Depository.

Modified JCLs and PROCs of automated compatibility testing process to support File-Aid to File Manager migration.

Setup and executes General Ledger application job stream by demanding and monitoring through CA-7. Also validates the data and publishes report to all Stakeholders involved in testing.

Actively involved in User Acceptance Testing, developed and executed Test Scripts, recorded test results and maintained errors and bug tracking using HP Quality Center (HP-QC).

and communicate the same to Project Manager.

Coordinating with Offshore team and assign tasks through Quality Center and communicating the status to Project Manager.

Environment/Tools: OS/390, COBOL, JCL, DB2, CICS, CA-7, Oracle, FTP/NDM, ENDEVOR, FILE-AID, File Manager, SPUFI, SAVRS, Xpeditor, Platinum, HP Quality Center, ServiceNow.

Target Corporation, Minneapolis, MN May 2006 - March 2014

Tech Lead

Multi-Channel Inventory Management (MCIM) for Target Corporation May 2013 - March 2014

Target has taken a strategic step to merge replenishment functionalities of Target.com into legacy Brick and Mortar (B&M) Stores world and replenish any Target location from any other location, which enables Target to get the product to Guest with a better pricing and quicker with cheaper delivery charges. This also enables Target to fulfill Guest Online orders in multiple ways, like order-online-pick-up-at-store, order online-ship-from-store and order-from-one-store-and-pick-at-other-store.

Denton Food Distribution Center (FDC) for Target Corporation March 2012 – April 2013

Target has planned to replace the existing Fort Worth, Texas FDC by opening a new FDC at Denton, Texas in March 2013. The purpose of this project is to enable all Replenishment applications in order to support the realignment of all Stores received by Ft. Worth FDC to Denton FDC.

Food Promo Forecast for Target Corporation March 2011 – February 2012

The purpose of this project is to build the necessary system which optimizes the Inventory levels at Store of Grocery Items during Promotions through systematic adjustments of Promotional Forecast which resembles Rapid Rep system in many ways.

Rapid Rep Rewrite for Target Corporation June 2009 – February 2011

The purpose of this project is to build the necessary system infrastructure / data history to support the Rapid Rep research needs and enhancement of Rapid Rep distribution calc. This project also enhances the Rapid Rep Holdback calculation and develops a new application to support the Hold Back calc and Street date maintenance within Rapid Rep.

Supply Distribution Management HV/SHV Time Zone Changes May 2008 – May 2009

The purpose of the SDM HV/SHV project is to modify the SDM process to drop HV / SHV labels only once a day at an appropriate time to minimize delays and capture all potential sales for that day.

Grocery Self Distribution DFD - Life Cycle Testing August 2007 – April 2008

Purpose of Life Cycle Testing is to validate the functional changes done as part of Grocery DFD process and to check the end-to-end Business process to ensure that there is no negative impact on the existing functionality, all the Business process are successfully modified to handle the new DFD functionality, to validate the users are able to do their job once functionality is introduced into FDC and fix any issues and defects.

Grocery Self Distribution DFD - Supply Distribution Management 1 & 2 May 2006 – July 2007

Target opens new Food Distribution Centre (FDC) to manage the inventory and distribution of Grocery items to Target’s retail stores, requires the existing Supply Distribution Management system to be enhanced to support this new business, by bringing in a Withdrawal based system merchandise distribution to stores.

Responsibilities:

Involved in phases like Requirements Gathering, Analysis, Designing, Coding, Testing, Implementation, Go-Live support and Roll-Out support.

Performed impact analysis and written functional specification, high level design and low-level design documents.

Worked with multiple stakeholders during new Distribution Centers Roll-Out by performing data mapping and develop on-demand JCLs and COBOL programs for a one-time load of tables.

Developed Logical and Physical Data Models using ERWIN tool, created DDLs and worked with DBA in defining them.

Worked with cross teams at various stages of projects in ensuring the smooth execution of project.

Developed Source to Target data mapping from Mainframe/DB2 to Teradata EDW environment.

Analyzed Online and Batch CICS-COBOL programs in performing impact analysis.

Developed COBOL, COBOL-DB2, COBOL-DB2 Stored Procedure programs, Native Stored Procedures, JCLs and PROCs and FTP process.

Modified and tested COBOL-CICS-MQ Batch programs and COBOL-CICS Online programs to incorporate the changes.

Developed JCLs and SQL Queries to load the data from DB2 to Teradata, using BTEQ Proc.

Executed COBOL programs in XPeditor for debugging and STROBE in identifying performance issues.

Modified, performed testing and implementation of Coolgen programs.

Tested Stored procedures using tools, Eclipse, and executed test cases from Java screen/front-end.

Performed Unit Testing, Performance Testing and System Testing, using SPUFI and FILE-AID, and actively involved in User Acceptance Testing.

Developed and executed Test Scripts, recorded test results and maintained errors and bug tracking using HP Quality Center (HP-QC).

Created CA-7 implementation documents, written scripts and work with IBM team in implementing job scheduling changes.

Implemented alert mechanism to the system in reporting the delay of execution which could result in missing the Level of Service.

Performed new DB2 tables health check by keeping track of the JCL execution time, STROBE reports and fine-tune the DB2 queries by validating the EXPLAIN reports.

Supported Go-Live of new Food DC by pulling reports by querying against DB2 tables, writing simple COBOL/Easytrieve programs and shared statistics with a better representation.

Performed Data Analysis in SAS and developed REXX tools to automate System Test execution.

Coordinating with Onsite in understanding requirements through Implementation and for defect triaging during Life Cycle Testing.

Coordinating with Offshore team, assign tasks and communicating the status to Project Manager.

Ensured environment readiness, for System, Integration and User Acceptance testing.

Training and Mentoring Team Members on technology and application.

Environment: OS/390, COBOL, JCL, DB2, COBOL-DB2 Stored Procedures, Coolgen, CICS, MQ, MQ Listener, Teradata, CA-7, ENDEVOR, ERWIN, FILE-AID, SPUFI, JMR, Xpeditor, BMC, EXPLAIN, BTEQ, Softech, Platinum, AdvantageGen, REXX, STROBE, Easytrieve, HP Quality Center, TESTOR, HP Service Desk, MicroStrategy, ServiceNow.

Contact this candidate