Param Jabbal, Developer in Frisco, United States
Param is available for hire
Hire Param

Param Jabbal

Verified Expert  in Engineering

Database Developer

Location
Frisco, United States
Toptal Member Since
August 15, 2022

Param has an extensive techno-functional background in the banking and finance industry with hands-on experience in legacy modernization, including system analysis, software design, development, and migration projects. He is a motivated developer who loves to embrace new technologies to deliver innovative solutions. Param enjoys solving complex problems and streamlining existing systems. He strives to automate and enhance work processes to improve team efficiency.

Portfolio

Wegmans - Main
COBOL, Integrated Database Management Systems (IDMS), Excel VBA, Excel 365...
Bank of America
IBM Db2, COBOL, CICS, Easytrieve Plus, REXX, Python 3, Splunk...
Perot Systems
IBM Db2, COBOL, CICS, JCL, Virtual Storage Access Method (VSAM), Visual Basic...

Experience

Availability

Part-time

Preferred Environment

Windows, IBM Db2, IBM z/OS, Python 3, COBOL, REXX, JCL, VBScript, Tableau, Scripting, Microsoft Word, Mainframe, Documentation

The most amazing...

...thing I've done is to embrace and implement new technologies on legacy platforms by building dashboards and alerts in Splunk using SMF data.

Work Experience

COBOL Developer

2022 - PRESENT
Wegmans - Main
  • Documented the legacy application written in COBOL for the retail chain. The engagement involved tracking the input and output process in the application and documenting it so that the functionality can be ported to the web-enabled application.
  • Executed the process on Mainframe to verify the documented logic in the legacy code.
  • Tracked the project's progress using the Scrum methodology.
Technologies: COBOL, Integrated Database Management Systems (IDMS), Excel VBA, Excel 365, Word 2016, SQL

Consultant/Database Analyst

2010 - PRESENT
Bank of America
  • Engaged and successfully implemented several Mainframe optimizations and Db2 performance enhancements, led initiatives to reduce costs by optimizing the workload for a four-hour rolling average and the TFP.
  • Extracted and transformed data from different sources using Excel (Power Query) to generate reports for management using Python and other data visualization tools like Tableau.
  • Worked on database design projects and implemented SQL enhancements to improve performance and platform stability.
  • Created dashboards using Splunk for senior management for displaying performance metrics by analyzing system management facility (SMF) and Db2 performance data.
  • Automated and enhanced work processes to improve team efficiency using Python and Excel with VBScript that interacts with legacy applications.
  • Modernized several Mainframe projects which involved augmenting the functionality using Python, VBA, Excel, and Power Query to build dashboards for quick and easy access to information.
  • Prepared high-Level and low-level design documents for changes for several regulatory and business enhancement projects.
  • Built processes for automated data loading using Synthetic Data generation using Python.
  • Built and executed testing strategy for data conversion from different platforms onto Mainframe Db2 database.
Technologies: IBM Db2, COBOL, CICS, Easytrieve Plus, REXX, Python 3, Splunk, System Management Facility (SMF), SQL, SQL Performance, Microsoft Excel, Microsoft Access, Python, Data Analytics, Data Analysis, ETL, Data Visualization, Performance Tuning, SQL Stored Procedures, Stored Procedure, Databases, Data Engineering, Schemas, Relational Data Mapping, CSV, Scripting, Data Processing Automation, Data Processing, Macros, Excel 2010, Excel 2016, Pandas, Automation, Microsoft Word, Mainframe, Banking & Finance, Documentation, Power Query, Visual Basic for Applications (VBA)

Associate

1998 - 2010
Perot Systems
  • Received "Special Contribution award" for organizational growth from the company.
  • Engaged in several projects for different clients for Perot Systems which involved coding, development, testing, process automation, report generation using Microsoft Office products, and interactions with the client to represent the company.
  • Led the engagement at World Health Organization (WHO) (Perot Systems) to prepare conceptual, functional, and system design specifications based on project sponsors' requirements and complete the development using ASP, Visual Basic, VBS, and VBA.
  • Migrated data from VSAM datastore to Db2 database. Additionally, was involved in the generation of several reports which extensively used Microsoft products including Excel and VBA.
  • Led development at MCI Worldcom (Perot Systems) by designing, planning, and implementing enhanced customer options and comments to the Db2 project for a bank, earning the company additional projects.
  • Led the team at CEDEL Bank of Luxembourg (through Perot Systems) involving data migration and Y2K compliance on the Legacy Mainframe systems using COBOL, Db2 and CICS.
  • Involved in COBOL upgrade from VSE COBOL to VS COBOL along with Y2K remediation. The changes were implemented in the CICS and IMS databases.
Technologies: IBM Db2, COBOL, CICS, JCL, Virtual Storage Access Method (VSAM), Visual Basic, Visual Basic for Applications (VBA), Databases, CSV, Data Processing, Crystal Reports, Macros, Automation, Microsoft Word, Mainframe, Documentation, Data Visualization, SQL

Developer

1996 - 1998
Userease Softwares
  • Worked as a developer using the latest technologies at that time which included PowerBuiler, Visual Basic, and Visual FoxPro for the clothing industry.
  • Installed the code at the client locations which included meeting and building relationships with the customers to represent the company.
  • Responsible for requirements gathering, designing, coding, and implementing the changes for the garments industry.
Technologies: PowerBuilder, Visual Basic 6 (VB6), Excel VBA, Automation, Visual FoxPro, SQL, Visual Basic for Applications (VBA)

Db2 Performance Data Extraction for Anomaly Detection

The project included extracting the data from performance Db2 tables populated with SMF information record types, SMF100 and SMF101, generated on the mainframe.

The process extracts the data for two consecutive months summarizing each workload, investigates the trends, finds anomalies, and generates reports for further analysis by performance teams. It also generates statistics data for executive summary reports. The automated process executes in minutes compared to hours and days when executed manually.

Dashboards and Alerts Creation in Splunk for SMF

Built the dashboards using the SMF data provisioned by IBM Z operational log and data analytics (ZLDA) in Splunk.

The dashboards provided complete information on Db2 performance data, including locks, latch, and elapsed time for each logical partition on the system.

I also created alerts based on machine learning to find the optimal threshold for each logical partition and provide proactive monitoring of the production and test systems.

Consumer Credit Card Core Platform Modernization

Managed the project deliverables for the product offering engine group. In this project, I wrote high-level and low-level design documents and coded and built processes to automate data loading in the database of other data sources.

Also, I created a testing strategy to include a conversion strategy while overseeing compliance and governance activities related to the project's complete lifecycle.

Pricing and Cash Management

This project proposal was to retain the current standard rate on existing balances. Also, the proposition included creating new standard rate balance categories to accommodate new transactions at a different standard rate and provide future transaction pricing.

I planned and coordinated the power over ethernet (PoE) application analysis and provided inputs to prepare high-level design documents.

My role included automating processes to load the data in databases and verification using the visual basic for applications (VBA) macros and Python scripts.

I coded the critical programs for the project implementation.

Analysis and Documentation of Legacy System in COBOL

I worked on documenting a legacy application written in COBOL for a retail chain. The engagement involved tracking the input and output process in the application and documenting it so that the functionality can be ported to the web-enabled application.
1992 - 1996

Bachelor of Engineering Degree in Computer Technology

Rashtrasant Tukadoji Maharaj Nagpur University (RTMNU) - Nagpur, India

DECEMBER 2021 - PRESENT

Artificial Intelligence & Machine Learning

The McCombs School of Business | via Great Learning

DECEMBER 2018 - PRESENT

ADFz/IDz/RDz Foundations

IBM

MARCH 2018 - PRESENT

SAFe Scrum Master

Scaled Agile

FEBRUARY 2015 - PRESENT

Big Data and Hadoop Developer

Edureka

Libraries/APIs

Pandas

Tools

JCL, Excel 2010, Excel 2016, Microsoft Excel, Microsoft Word, Power Query, Photoshop 7, Splunk, Erwin, Microsoft Access, Tableau, Crystal Reports, Word 2016

Languages

COBOL, CICS, SQL, REXX, Python 3, VBScript, Python, Stored Procedure, Easytrieve Plus, Visual Basic, Visual Basic for Applications (VBA), Python 2, Excel VBA, PowerBuilder, Visual Basic 6 (VB6), Visual FoxPro

Platforms

IBM z/OS, Windows, Jupyter Notebook, Apache Pig

Storage

IBM Db2, SQL Performance, Databases, SQL Stored Procedures, HDFS, Apache Hive, Virtual Storage Access Method (VSAM), IBM Mainframe, Integrated Database Management Systems (IDMS)

Industry Expertise

Banking & Finance

Paradigms

ETL, Automation

Other

Computer Science, Programming, Data Structures, Performance Tuning, Schemas, Relational Data Mapping, CSV, Data Processing, Macros, Mainframe, Documentation, Machine Learning, Artificial Intelligence (AI), System Management Facility (SMF), Data Analytics, Data Analysis, Data Visualization, Data Engineering, Scripting, Data Processing Automation, ESP8266, Compilers, IBM Application Delivery Foundation for z/OS, Big Data, Scrum Master, Excel 365, IoT Protocols, Arduino IDE, Sensors & Actuators

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring