Param is available for hire
Hire ParamParam Jabbal
Verified Expert in Engineering
Database Developer
Frisco, United States
Toptal member since August 15, 2022
Bio
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
Lake County Appeal
Excel 365, Artificial Intelligence (AI), Python 3, Machine Learning, PDF...
Bank of America
IBM Db2, COBOL, CICS, Easytrieve Plus, REXX, Python 3, Splunk...
JANO Technologies
FTP, Microsoft SQL Server, Windows PowerShell, IBM Db2, SQL, Data Cleaning...
Experience
- Databases - 20 years
- SQL - 20 years
- COBOL - 15 years
- Visual Basic for Applications (VBA) - 15 years
- Automation - 10 years
- SQL Performance - 10 years
- Python - 7 years
- Machine Learning - 3 years
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
Excel and Python Expert
2023 - PRESENT
Lake County Appeal
- Designed and built a Python-driven product to replace manual Excel research by classifying property tax appeal requests into categories and generating detailed spreadsheets with PDFs, reducing processing time from several days to under an hour.
- Implemented AI-driven features to classify property and sales data, reducing manual intervention and freeing the team to focus on high-value tasks like legal analysis and property tax negotiation, resulting in improved organizational productivity.
- Integrated AI, automated Excel 365, and generated custom reports, meeting the client's needs. The product's flexibility in handling large datasets enabled faster decision-making, improved research, enhanced satisfaction, and operational excellence.
Technologies: Excel 365, Artificial Intelligence (AI), Python 3, Machine Learning, PDF, Data Scraping, VBScript, Python, Databases
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), Data Scraping, VBScript
Microsoft SQL Developer
2025 - 2025
JANO Technologies
- Optimized complex SQL queries on interconnected tables in DB2 for data extraction, cleansing, and transformation. Improved data migration accuracy by 25%, reducing manual cleaning efforts and ensuring smooth integration with the input system.
- Designed relationship diagrams using Python to visualize links of tables on SQL Server and DB2, helping identify key data dependencies and redundancies, enabling critical decisions on data transformation, and accelerating migration timelines.
- Collaborated with cross-functional teams, including RPG developers, to clean and transform data for the migration from SQL Server to DB2. Utilized sophisticated SQL techniques and PowerShell scripts for efficient data export.
Technologies: FTP, Microsoft SQL Server, Windows PowerShell, IBM Db2, SQL, Data Cleaning, Data Conversion, Data Migration, Data Scraping, VBScript, Python, Databases
Excel Macro Expert
2024 - 2024
Willis Eckfeldt
- Designed and maintained an advanced Excel VBA macro that seamlessly connected and automated the extraction of large-scale trading data, generating dynamic Excel reports, reducing manual reporting time, and increasing accuracy.
- Built and optimized VBA-driven Excel reports tailored to client portfolios, highlighting performance trends, trade execution summaries, and key financial metrics. This helped the wealth management team provide insightful reports for client meetings.
- Integrated flexible filters and sorting options within the VBA macro, allowing team members to customize reports based on trading criteria, client types, or date ranges.
Technologies: Visual Basic for Applications (VBA), Visual Basic, Microsoft Excel, Python 3, Python, Data Scraping, VBScript
COBOL Developer
2022 - 2023
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, VBScript, Python, Databases
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, Data Scraping, VBScript
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), VBScript, Databases
Experience
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.
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.
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.
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.
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.
Education
1992 - 1996
Bachelor of Engineering Degree in Computer Technology
Rashtrasant Tukadoji Maharaj Nagpur University (RTMNU) - Nagpur, India
Certifications
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
Skills
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), Microsoft SQL Server
Industry Expertise
Banking & Finance
Paradigms
ETL, Automation
Frameworks
Windows PowerShell
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, Data Scraping, Compilers, IBM Application Delivery Foundation for z/OS, Big Data, Scrum Master, Excel 365, IoT Protocols, Arduino IDE, Sensors & Actuators, FTP, Data Cleaning, Data Conversion, Data Migration, PDF
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