Ashish Malhotra
Lead Systems Analyst - Billing
Solon,Ohio
Summary
Accomplished IT professional with over 32 years of global experience in the full life cycle of software design and development specializing in billing systems at Progressive Insurance. Proven leader in managing complex projects and driving performance improvements through innovative solutions and risk-based testing approaches. Certified PMP IBM DB2 professional and ScrumMaster with strong expertise in mainframe and distributed platforms. Demonstrated success in leading cross-functional teams, optimizing processes, and ensuring high-quality deliverables in fast-paced environments.
Overview
32
32
years of professional experience
5
5
Certifications
Work History
Lead Systems Analyst - Billing
Progressive Insurance
01.2021 - Current
- Spearheaded key billing initiatives including IOCD & Metro Project, TelAlert replacement, Stonebranch UAC migration, IE Retirement Project, Mainframe Engineering, App Dynamics and Splunk Monitoring, CCPA Data Discovery, Progressive Home, DB2 upgrades, and COBOL V6.2 Migration.
- Tech Application Owner (EXCEED TAO): Led the Exceed system, supporting business users, managing system enhancements, building new Windows, Linux, and SQL Servers, overseeing code management, mentoring team members, and creating a comprehensive technical application guide.
IT System Test Engineer Lead - EDCS
Progessive Insurance
10.2008 - 07.2021
- Platform POC for Billing, Policy Pro, External Communication and Web Presence: Oversaw environment management, performance testing, and quarterly test data creation. Improved stress test systems, developed strategies for certifying software releases, and managed distributed environments for performance testing.
- Created flash copies of production database for the Billing Stress environment.
- Defined and implemented database gold copies for SQL Server in the Policy Pro Stress environment.
- Enhanced performance testing for billing and policy servicing applications by leveraging the ESP scheduler for automation and stress database refresh jobs.
- Led the creation of performance risk catalogs, risk analysis processes, and performance testing surveys, driving compliance and education on risk-based testing.
- Performance Testing: Managed the performance testing roadmap, collaborating with project managers and development teams for prioritization and execution of performance tests.
- Defined release management SLAs, metrics collection, and disaster recovery processes for billing projects.
- Developed and implemented a new process to refresh the Claims Stress Environment.
- Served as Platform POC and SME for the Claims Data Refresh process.
- Platform POC for Lean Advancement (2021).
- Risk Assessments Process Owner: Created Performance Risk Catalogs, Risk Analysis Processes, and Performance Testing Surveys. Maintained usage across all platforms and established risk assessment quality metrics, increasing visibility into the results of the risk-based testing approach, including process compliance, quality, and lessons learned. Drove adoption and compliance of the risk-based testing process and educated the team on its value.
Lead Applications Developer - Billing
Progressive Insurance
04.2004 - 10.2008
- Designed, developed, deployed, and supported various COBOL, CICS, MQ, and DB2 applications including static database for billing’s month-end processing, BCWS, process control, archive and purge process, and policy generation system for stress environment.
- Data Sanitization Project: Established processes and verification criteria for Billing DB2 tables in the stress environment.
- Participated in internal disaster recovery exercises at Sungard and Colorado Springs, generating disaster recovery processes and verification criteria for the billing application.
Senior Technical Analyst
Yellow Roadway
02.2002 - 04.2004
- Subject Matter Expert (SME): Led projects for financial, personal, and payroll systems, covering scope analysis, design, development, testing, quality control, implementation, and support.
- Cobol 2 to Cobol370 Conversion & System Development: Managed the conversion project and implemented the Bridge Id and Barcodes System, enhancing system functionality.
- Automation & Application Support: Automated hand-drawn checks using IBM Visual Age Generator and maintained critical business applications such as ATA Time and Attendance, Payroll, Personal Health Welfare and Pension, Year-End Processing Systems, Incentive Plans, and IBM VAGEN.
- Upgrades & Development: Led mainframe and DB2 upgrades, designed business objects front ends for DB2 databases, and implemented a new check printing process transitioning from Westcorp to Web-Based Fiware.
- FLM & Direct Deposits: Spearheaded the implementation of Check Workface Timekeeper 4 for Field Labor Management and managed multiple direct deposit projects, improving payroll efficiency.
- Payroll & Connectivity Enhancements: Developed online payroll modules using Visual Age Generator, transitioned DB2 Connect from SNA to TCP-IP, and managed W2 and unemployment reporting to all US states.
- Performance Tuning & Benefits: Conducted performance tuning of payroll schedules, implemented voluntary benefits deductions, and telephone credit union deductions.
- 401K Migration & Employee-ID Projects: Led the 401K migration, Central States Fund Project (HWP), and assigned new employee IDs to all Roadway employees, ensuring smooth transitions and accurate record-keeping.
Project Leader
HCL Technologies America - Roadway Express
05.1997 - 02.2002
- Managed the Year 2000 (Y2K) compliance project ensuring 2300 COBOL programs were compliant using C-MILL tool.
- Handled personnel management, technical and administrative issues, and liaison between Roadway Express management and HCL America staff.
Programmer Analyst
Anderson Consulting
09.1994 - 02.1997
- Collaborated with a team of 300 software professionals to work on Inland Revenue Integrated System (IRIS), a major client-server application for tax collection engaged in taxpayer identification, enforcement, data purification, quality control, and production support.
Programmer
HCL Technologies
06.1992 - 05.1994
- Developed Chest Accounting System, Penal Interest Management System, Small Coin Depot Management System, and Inventory Management System for the Reserve Bank of India (RBI).
Education
Bachelor of Science - Computer Science
Nagpur University
Nagpur, India 05.2001 -
Diploma - Mechanical Engineering
Aryabhat Institute
Delhi, India 05.2001 -
Certification
ITIL Foundation Certificate in IT Service Management
Timeline
Lead Systems Analyst - Billing
Progressive Insurance
01.2021 - Current
IT System Test Engineer Lead - EDCS
Progessive Insurance
10.2008 - 07.2021
Lead Applications Developer - Billing
Progressive Insurance
04.2004 - 10.2008
Senior Technical Analyst
Yellow Roadway
02.2002 - 04.2004
Bachelor of Science - Computer Science
Nagpur University
05.2001 -
Diploma - Mechanical Engineering
Aryabhat Institute
05.2001 -
Project Leader
HCL Technologies America - Roadway Express
05.1997 - 02.2002
Programmer Analyst
Anderson Consulting
09.1994 - 02.1997
Programmer
HCL Technologies
06.1992 - 05.1994