Home

Rajeev - Mainframe Developer/Lead/Architect

[email protected]

Location: Phoenix, Arizona, USA

Relocation: any

Visa: H1B

PROFESSIONAL SUMMARY Over 20 years of experience in enterprise IT with deep expertise in mainframe application development, support, and modernization, spanning industries such as healthcare, finance, and insurance. Extensive experience supporting and enhancing mission-critical mainframe systems for enterprise-scale organizations including American Express, Hertz, Amica Mutual Insurance, GE, and ABC Corp managing CICS transactions, COBOL batch jobs, and DB2/IDMS databases in high-volume production environments. Accomplished Technical Project Manager and Solution Architect, with a proven ability to lead legacy mainframe system transformations, manage large-scale migrations, and bridge the gap between business and engineering teams. Extensive hands-on experience with mainframe technologies including COBOL, JCL, CICS, VSAM, DB2, IDMS and ADSO, including performance tuning, batch optimization, and transaction-heavy workloads. Led multiple successful mainframe-to-modern platform migrations, including data model conversion between IDMS (network model), DB2 (relational model), and MongoDB (schema-less) architectures. Expert in decommissioning legacy mainframe programs and automating migration tasks, with a strong focus on maintaining data integrity and system continuity during modernization efforts. Built tooling and migration accelerators using Python, Neo4j, and Visual Basic to map, track, and document interdependencies across thousands of mainframe artifacts. Experienced in integrating modern technologies like Python, Flask, and FastAPI for backend components in hybrid mainframe-cloud environments, particularly during staged legacy transitions. Skilled in structured analysis, reverse engineering of legacy systems, and supporting QA automation for CICS screen and batch job validation. Strong command of both relational and non-relational databases including DB2, IDMS, Sql Server, PostgreSQL, MongoDB, and Neo4j. Effective mentor and team leader with experience managing cross-functional teams in Agile and traditional environments, ensuring delivery of stable, high-performing mainframe and hybrid systems. Technical Skills Mainframe Systems & Support: COBOL, JCL, CICS, VSAM, DB2, IDMS, Endevor, Changeman, File-AID, TSO/ISPF, Control-D, Abend-AID, XPEDITER, CA-7 Databases: DB2, IDMS (Network Model), Oracle, PostgreSQL, MySQL, MongoDB, Couchbase, DynamoDB, Redshift, Neo4j, SQLite, Redis Programming Languages & Scripting: COBOL, Python, SQL, Bash, VBScript, Shell Scripting, JavaScript Testing, Debugging & QA Automation: Selenium, Pytest, TDD, XPEDITER, PDB, Guidewire Testing, VS Code Debugger APIs & Integration: CICS Transactions, RESTful APIs, GraphQL (basic), Postman, RabbitMQ, Power Query Architecture & Design Patterns: Modular Monoliths, Batch Processing, Event-Driven Architecture, Domain-Driven Design (DDD), MVC BI & Reporting Tools: Power BI, Power Query, Excel, Microsoft 365 (SharePoint, Teams), IBM Content Manager Infrastructure & DevOps: Terraform, Docker, Kubernetes, GitHub Actions, Jenkins, GitLab CI/CD, CircleCI, Git Frameworks & Libraries: Flask, Django, FastAPI, SQLAlchemy, Pandas, NumPy, Matplotlib, Pydantic Cloud Exposure: AWS (EC2, Lambda, RDS, S3, CloudFormation), Azure (SQL Server, Functions), GCP IDEs & Tools: VS Code, VI, Eclipse, Android Studio, TSO/ISPF EDUCATION Master of Computer Applications (MCA) DDU University, Gorakhpur, India (2002) Bachelor of Science in Mathematics (Hons.) BHU University, Varanasi, India (1998) CERTIFICATIONS AWS Certified Solution Architect Associate (2020) IBM Certified DB2 Database Administrator (2009) Multiple IBM Talent & Employee of the Month Awards PROFESSIONAL EXPERIENCE Solution Architect Mainframe | KeyBank June 2024 Present Led the migration of mainframe authentication (RACF, DB2) to SailPoint IdentityIQ, enabling modern, scalable identity governance across systems. Designed and implemented secure, scalable APIs for digital asset management using Python, ensuring robust access controls and integration with IAM policies. Automated data analysis and reporting workflows using Python, Excel VBA, and ServiceNow, significantly reducing manual effort and time to insights. Performed comprehensive access and file storage audits across employees, systems, and teams. Identified over-permissioned users and conducted root-cause analysis for access policy violations. Flagged unauthorized and expired access to critical systems and data. Reviewed security rules and access policies to align with enterprise compliance and risk frameworks. Supported data access updates and visibility controls at the database level. Ensured compliance with data protection standards and identified security risks for mitigation. Documented findings and strategic recommendations for leadership review and compliance reporting. Assessed existing RBAC models and devised implementation strategies for role-based access enforcement in SailPoint. Automated exception reporting to highlight access discrepancies and irregularities across applications. Instituted regular access review processes to ensure permission accuracy and reduce audit risk. Python Architect DBA & Data Engineer | PwC (Global) May 2022 June 2024 Led a very large-scale medallion architecture based data cleanup using Python, enabling robust data quality checks, deduplication, and enrichment across bronze, silver, and gold layers. Served as Lead Data Engineer and DBA, spearheading the migration of on-premise Oracle databases to Azure SQL Server, ensuring data integrity and performance tuning. Designed and implemented high-performance, scalable ETL pipelines using Python, Docker and M Query powering an audit and analytics platform. Standardized and restructured data from multiple heterogeneous sources such as Oracle, Sql Server, flat files into a unified format required by in house Neptune, improving downstream analytics and interoperability. Built and integrated Power BI dashboards for reporting. Leveraged Microsoft 365 tools (PowerBI, Excel, SharePoint, Teams) for enhanced team collaboration, documentation, and streamlined operational workflows. Experimented with integrating lightweight Python-based ML models (scikit-learn) into API services for internal anomaly detection and audits insights recommendation proof-of-concepts. Senior Python Developer | FliptRx Nov 2021 May 2022 Acted as Lead Python Developer supporting a Pharmacy Benefit Manager (PBM) startup focused on Medicare/Medicaid workflows, ensuring sub-second API responses for real-time prescription pricing and approvals. Designed and developed Flask-based microservices, integrated with Couchbase and AWS, to deliver scalable, low-latency backend systems for pharmacy transactions. Built a custom parser for NCPDP EDI formats, enabling accurate adjudication of pharmacy claims data received from clients like ChangeRX. Standardized logging across services using the Python logging module, with real-time observability and Datadog integration supporting production monitoring and model diagnostics readiness. Developed and maintained GraphQL endpoints and ensured seamless interaction with React-based frontend applications. Engineered TCP socket communication endpoints for real-time, bidirectional data exchange with pharmacy partners. Supported RabbitMQ-based asynchronous workflows, contributing to scalable, event-driven system design compatible with ML model trigger pipelines. Collaborated with distributed teams using GitHub, Jira, and Confluence, managing aggressive sprint cycles while enabling continuous delivery into microservices. Technical Project Manager & Senior Python Developer | ASI Aug 2021 Nov 2021 Acted as Technical Project Manager and Architect, leading the modernization of legacy Visual FoxPro applications to a fully cloud-native AWS architecture using Django, MySQL, and serverless technologies. Architected and delivered a centralized authentication system using Django REST Framework, integrated with AWS Cognito and API Gateway for secure, scalable access control across microservices and potential ML API integrations. Spearheaded the automation of the invoice-to-PO reconciliation process, converting PDFs from diverse vendor formats into a standardized structure using Python-based ETL pipelines on AWS Lambda and S3, forming a clean data foundation for ML models. Oversaw CI/CD deployment pipelines using GitHub, Bitbucket, and AWS CodePipeline, supported by CloudFormation to ensure reproducible infrastructure aligning with best practices for automated model deployment and environment consistency. Led full-stack development efforts on AWS Elastic Beanstalk, ensuring scalable service delivery and operational readiness for potential machine learning model endpoints. Collaborated on early-stage MLOps readiness by aligning data processing workflows, deployment architecture, and observability standards to support future ML model integration and monitoring. Managed cross-functional teams including developers, testers, and cloud engineers, ensuring timely, high-quality deliverables while aligning with enterprise security and architectural standards. MongoDB and Sr Python Developer | Here May 2021 Aug 2021 Addressed chronic issue regarding deployment of servers for MongoDB, AWS Developed CloudFormation templates (CFT) for capacity management on AWS. Resolved chronic deployment issues for MongoDB on AWS, improving system stability. Developed AWS CloudFormation Templates (CFTs) to automate capacity management. Optimized database performance by tuning indexing strategies for MongoDB clusters. Implemented monitoring solutions using AWS CloudWatch and Python-based scripts. Mainframe Lead Analyst | Amica Mutual Insurance May 2017 May 2021 Led end-to-end modernization of legacy mainframe systems, including extensive work on COBOL, JCL, DB2, VSAM, and CICS programs, transitioning business-critical reporting workflows to Python- and MongoDB-based platforms. Built a data mapping and lineage analysis tool using Python, Neo4j, and Visual Basic to trace dependencies across thousands of mainframe artifacts spanning CICS screens, COBOL modules, and Control-D reports. Automated the extraction and structured migration of over 650,000+ mainframe reports from Control-D into IBM Content Manager, enabling better document access and compliance. Designed and delivered the "Mainframe Artifacts Mapping Tool" to visualize interconnectivity between CICS transactions, batch jobs, and database interactions. [https://priorart.ip.com/IPCOM/00265610D] Successfully decommissioned over 800 COBOL/CICS programs and thousands of JCL jobs, significantly reducing technical debt and mainframe maintenance costs. Developed automation scripts and modernization accelerators using Python, saving over two person-months of effort by eliminating repetitive tasks and manual mapping. Supported QA teams with Python-Selenium automation for functional testing of legacy Guidewire and CICS terminal screens, improving test coverage across migrated processes. Mainframe Sr Developer/Architect | American Express Oct 2015 May 2017 Led batch job performance optimization, reducing processing time and saving $300K. Assisted customers in architecting and re-engineering applications. Part of Mainframe Modernization team. Implemented major projects with functionality exceeding Business requirements, ahead of schedule, under budget, and defect free. Served as Mainframe liaison to business teams and experience in agile processes & transformation. Developed and executed plan to migrate source code from COBOL to COBOL5/6. Improved multiple batch jobs by fine tuning DB2 SQL constructs, SORT utility, dataset compression usage. Targeted and improved chronic incidents. The process improvement was valued over $300K savings. Automated parts of Source code to CA-R load (CA-R -> IT Asset catalog and reporting tool from CA). Identified multiple redundant obsolete processes from Dev/QA and had them shutdown leading to MIPS savings. Upgraded COBOL applications to next version while ensuring system reliability and cost optimization. Used ServiceNow for troubleshooting and triaging tickets/digital workflow. Used agile practices in this assignment. Mainframe Lead Analyst Apr 2008 Sep 2015 Hertz, Oklahoma City, OK Improved ailing nightly batch cycle. An improvement of over 4 hours realized through an effort lasting 8 months. Improved multiple batch jobs by leveraging DB2 fine tuning, VSAM optimization and SORT usage. Resulted in over USD 400K/Year savings for the client. Automated Traffic Violation Tracking (TVT) process replacing 8-person team. Instrumental in successful knowledge transfer from the previous team. Played crucial role in IT integration when Hertz acquired Dollar Thrifty Supported two of the key applications Vehicle Monitoring and Vehicle Information System. Fascilitated the migration of key IDMS records to DB2 Requirements gathering, application design, coding, testing and documentation. Led the offshore team of 15 people and trained multiple resources on DB2 and IDMS. Used IDMS, ADSO, DB2, IDD, IDML, ADSC, CULPRIT, COBOL, JCL, VSAM, CICSWEB, Changeman and Endevor. Used IBM Maximo for troubleshooting and triaging tickets. Used Changeman, RAT for digital workflow. Analyzed source code and identified issues dealing with incorrect and inefficient coding. Database Administrator IDMS May 2005 Mar 2008 AmerisourceBergen, Orange, CA Physical and Logical Database Design and Changes, Performance monitoring, Backup and Restore of Databases. Training and assisting application programmers on IDMS. Assisted in Migration from IDMS to DB2 applications. Well versed with IDMS tools IDD, IDDM, OLQ, ADSC, ADSO, DMLO, CULPRIT, PMON. Planned the migrations, procedural changes, and training to ease the transition from one release to another, making it as transparent as possible to the user. Used waterfall model in this assignment. Software Developer | General Electrics, Cincinnati, OH | May 2003 Apr 2005 Responsible for coding, testing, analysis, and production support for various applications for GE. Used IDMS, ADSO, COBOL, Visual Basic, Oracle, JCL, Easytrieve. Keywords: continuous integration continuous deployment quality analyst machine learning business intelligence sthree rlang information technology purchase order California Ohio