Uploaded File
add photo
Pitchumoney
app1kpp@outlook.com
201-491-6193
0 - 25 26th Street
Fair Lawn, NJ 07410
Data Analyst (Senior Capacity Planning & Performance Analyst)
27 years experience W2
1
Recommendation
Average rating
64
Profile views
Summary

An intuitive, innately collaborative professional seeking to leverage technical knowledge in design, coding, troubleshooting in a challenging position as a Technical Lead Developer with 20 plus years’ experience having solid experience in mainframe as well experienced in distributed systems and open-source technology such as Java and SAS

Core Competencies

  • COBOL
  • MVS Utilities
  • TOPAZ/IDZ
  • CA-DETECTOR
  • SFTP
  • DB2 Utils & Studio
  • DB2
  • CICS
  • DFSORT
  • XPEDITER/FILE_AID
  • NDM
  • EASYTRIEVE
  • MQ Series
  • VSAM
  • SPUFI
  • DATA Stage
  • SYNCSORT
  • CI/CD
  • SAS & MXG
  • JCL
  • PLATINUM
  • CHANGEMAN
  • BMC Db2 Utils
  • Linux shell scripting
  • Eclipse IDE
  • MS Visio
  • MS Project
  • SAS Studio
  • SAS Administration
  • SAS EG

TRAINING/KEY COURSES:

  • SAS Administration, SAS Enterprise Guide, SAS Studio, SAS ITRM, DB2 Stored Procedures, Data Modeling Foundation, MQ Series Application Programming, Java 2 Programming Fundamentals, DB2 Information Integrator, UPS Projects Website Training, UPS Project Management Professional, DB2 V12 new features & Intro to NATIVE SQL Stored Procedures, Introduction to SAP HANA Development -In memory Database, Advanced SQL Query tuning and Native Stored Procedure, Data Replication

Experience
Data Analyst (Senior Capacity Planning & Performance Analyst)
Information Technology
Aug 2017 - Dec 2020
Mahwah, NJ
  • Provided data insights to the management to optimize the mainframe resource utilization that supports 100 plus UPS applications by leveraging and analyzing various scheduled monitoring reports.
  • Optimized the cost using forecasting methods to dynamically scale up and down the mainframe resources to meet the demands of peak and normal time periods respectively.
  • Successfully lead and implemented a POC project to migrate 30-year-old SAS mainframe processes into x 86 Linux based SAS Analytics Pro.
  • When this POC project goes to production, it can potentially save UPS $3 Million per year on SAS licensing cost.
  • In this project, Extracted SMF data from mainframe, transformed the data using SFTP and developed several Linux shell scripts to load the data into SAS Analytics Pro. Conducted MIPS data analytics to determine the cost of utilizing mainframe resources.
  • Implemented data pipeline project to build dashboards in PowerBI in GCP for senior management team to monitor the status of 150 plus applications' performance of various architectural components. The management team has easy access to drill down to the problem areas and make informed decisions quickly.
Data Analysis Linux SAS Shell Scripts GCP Capacity Planning Analytics
Remove Skill
Senior Application Developer
Information Technology
Jun 2001 - Jul 2017
Paramus, NJ
  • I was in lead role and managed an offshore team, the Customer Profile System application, that ensures 24x7 availability of login, shipping and tracking of customer facing UPS applications.
  • Implemented disaster recovery process for the Customer Profile System application and validated the process works successfully to ensure Business Continuity Planning.
  • Conducted data mining, provided data insights to the business development team to continuously improve the customer experience by enhancing and introducing
  • capabilities in the existing applications and adding new applications.
  • Implemented procedures and monitors to ensure data availability and reliability of Quantum view and MyChoice applications. These two systems monitor movement and arrival of all the packages by customer account and receiving address. QV is a heavy IBM COBOL-MQ - DB2 systems with started tasks running 24x7.
  • The UPS.com web applications invoking CPS mainframe by JDBC calls to COBOL - Db2 Stored procedures also uses MQ, VSAM, and CICS technologies.
Data Mining DB2 Stored Procedure VSAM Monitors JDBC IBM Websphere MQ Disaster Recovery Cobol CICS Business Development
Remove Skill
References
Average Rating

0 recommendations
Systems Analyst
Information Technology
Oct 2000 - May 2001
Paramus, NJ

Cross-functional team member engaged in a project to develop a system for Consulting Group Research System. Responsibilities included:

  • Assisted Consulting Group's research analysts in gathering and analyzing data, formulating opinions, and generating reports.
  • Provided a single point of access to data from multiple sources, a suite of analytical tools, publishing functionality and a workflow process that would allow Consulting Group to standardize the management firms and products.
  • Developed reports using DB2 stored procedures through batch COBOL applications.
  • Wrote program specifications coding and unit testing.
Stored Procedure System Analysis Unit Testing DB2 Cobol
Remove Skill
Programmer/Analyst
Information Technology
Nov 1998 - Jul 2000

(Singapore)

Team member who was responsible for the maintenance and enhancement of the COSMOS system for Citibank APT. COSMOS is the backbone of the backend operation of Citibank and fulfills a variety of financial procedure in both online and batch environments. The system consists of a large number of modules such as FT, FX, and MM Cosmos interfaces with many other systems of Citibank such as CRMS and TRESTEL. Cosmos is also connected to external system SWIFT via IBM MERVA software. Cosmos is functionally divided into three major teams: the Release team for implementing enhancements, the Support team to solve the production problems of on-line and batch, and MVS conversion team to change OS/VS COBOL into COBOL-370. Responsibilities included:

  • User requirement Analysis, Preparation of Functional Specification, Program Specification, System integration Test plan and Unit test coding of program & JCL and testing and support activities in user acceptance testing and in production implementation.
  • Assisted with Fund Transfer Integration System implementation in China. FTI system utilizes a PC-based front-end and mainframe as backend engine. It uses Citibank’s own communication software RCS Regional Control System to connect the interface.
  • Facilitated on online Earmarking and Credit Line Availability (OLECA) project which involved mainframe CICS, MQ Series and HP-Unix/Oracle on the backend. As a member of the Support team, managed on-line and batch problems of Indonesia, Thailand and Malaysia MERVA\SWIFT.
CICS Cobol DB2 Java JCL SAS SQL Stored Procedure Training Test Planning Systems Integration Swift SAP HANA SAP Project Management Oracle IBM Websphere MQ IBM MERVA Database Maintenance Data Replication Data Modeling backbone.js Analysis Integration Testing
Remove Skill
Programmer/Analyst
Information Technology
Jun 1986 - Oct 1998

11-1996 to 10-1998 - Programmer/Analyst, Central Provident Fund Board, Singapore

06-1995 to 02-1996 - Programmer/ Analyst, KRAN Information Systems, Kerala, India

06-1986 to 03-1995 Junior Programmer, Trivandrum Telephones, Kerala, India

No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Science-Chemistry
Madurai-Kamaraj University
Computer Science and Application
University of Kerala
Certifications
DB2 V7 Fundamentals from IBM Corporate Representative
UPS Associates Project Management Certification
Skills
Cobol
2017
18
DB2
2017
18
Stored Procedure
2017
18
CICS
2017
17
IBM Websphere MQ
2017
17
Business Development
2017
16
Data Mining
2017
16
Disaster Recovery
2017
16
JDBC
2017
16
Monitors
2017
16
VSAM
2017
16
SAS
2020
5
Analytics
2020
3
Capacity Planning
2020
3
Data Analysis
2020
3
GCP
2020
3
Linux
2020
3
Shell Scripts
2020
3
Analysis
2000
1
backbone.js
2000
1
Data Modeling
2000
1
Data Replication
2000
1
Database Maintenance
2000
1
IBM MERVA
2000
1
Integration Testing
2000
1
Java
2000
1
JCL
2000
1
Oracle
2000
1
Project Management
2000
1
SAP
2000
1
SAP HANA
2000
1
SQL
2000
1
Swift
2000
1
Systems Integration
2000
1
Test Planning
2000
1
Training
2000
1
CHANGEMAN
0
1
Continuous Deployment
0
1
Continuous Integration
0
1
DataStage
0
1
Easytrieve
0
1
Eclipse
0
1
IDE
0
1
MS Project
0
1
MS Visio
0
1
Platinum
0
1
Problem Solving
0
1
Scripting
0
1
SPUFI
0
1
SYNCSORT
0
1
System Analysis
2001
1
Unit Testing
2001
1
XPEDITOR
0
1
Awards
President of UPS Toastmasters Club - “Speeches R US”, 2011