Projects

Oct 2014 - Dec 2016

Guidewire BillingCenter Data Conversion - Legacy Data Extraction

Lead legacy data extraction for Guidewire BillingCenter using a big bang approach, converting data across all U.S. states and policy types in a single, high-impact rollout.
Analyzed and mapped complex legacy billing data (policies, accounts, billing, payments, commissions) to Guidewire data models, ensuring seamless integration.
Developed and optimized COBOL programs and batch jobs on the mainframe to trigger DataStage ETL workflows, significantly improving extraction speed and reliability.
Conducted performance tuning of mainframe extraction jobs, reducing runtime and resource consumption to meet tight project deadlines.
Partnered with business analysts, data architects, and developers to maintain data quality and resolve conversion issues during all testing phases (unit, system, UAT).
Created reusable data extraction templates and detailed documentation, enhancing efficiency and compliance for future data conversions.
Provided insights for data cutover planning and executed mock conversions to ensure a smooth, disruption-free transition from legacy systems to Guidewire BillingCenter.

Tools & Technologies: IBM Mainframe, COBOL, Assembler, JCL, IBM DB2, REXX, SyncSort, DataStage ETL, SQL, Control-M and Control-D.

Jan 2017 - Dec 2019

Guidewire PolicyCenter Data Conversion - Legacy Data Extraction

Lead phased legacy data extraction and conversion for Guidewire PolicyCenter, covering policy lines including Homeowners (HO), Dwelling Fire (DF), Ocean Marine(OM), and Personal Umbrella (PUP) policies.
Executed a structured rollout across five state groups, enabling controlled, low risk deployments with measured intervals between go lives.
Interpreted and mapped complex legacy policy data such as terms, coverages, endorsements, and transaction history into Guidewire's data model with high accuracy.
Designed and optimized COBOL-based mainframe batch programs to extract structured data and interface with DataStage ETL pipelines, ensuring efficient data flow.
Enhanced mainframe job performance by tuning batch processes, significantly reducing runtimes to align with strict cutover timelines.
Collaborated with cross-functional teams through all testing phases (unit, system, UAT) to validate conversions and resolve data-related defects.

Guidewire PolicyCenter Data Integration and Data Remediation

Engineered and maintained legacy system integrations with downstream applications including Prints, Claims, EDB, CMA, and STAT, supporting seamless interoperability and data consistency.
Authored comprehensive documentation for legacy program functions, decoding intricate business logic to improve understanding and long-term maintainability.
Contributed to the maintenance of the Business Rule Database, which stored policy edit error definitions to support validation and clean migration.
Designed and implemented Remaining Lines Gateway mainframe programs in COBOL/JCL to facilitate the transmission of policy and endorsement data from PolicyCenter to legacy systems via the Operational Data Store (ODSDB).
Participated in the design and data modeling of the ODSDB on SQL Server, collaborating with data modelers and DBAs to enable real-time and reporting use cases.
Tested and deployed SSIS packages for extracting data from the ODSDB into XML format, which was then consumed by RL Gateway COBOL programs to update legacy systems.
Ensured robust Enterprise Policy Search (EPS) functionality by validating and integrating high-quality legacy policy data.
Coordinated across development and QA teams to uphold data integrity and consistency throughout the deployment cycle.
Developed and supported mainframe batch jobs for integration workflows, incorporating validation logic, logging, and audit controls.
Led the implementation and refinement of legacy data remediation batches, resolving data issues like duplicates, invalid formats, and business rule violations pre and post conversion.
Strengthened audit and compliance readiness by producing reusable remediation templates and thorough documentation for traceability.

Tools & Technologies: IBM Mainframe, COBOL, Assembler, JCL, IBM DB2, REXX, CICS, SyncSort, SQL Server, DataStage ETL, SQL, SSIS, Control-M and Control-D.

Jan 2020 - Jul 2023

Legacy Systems Maintenance

Led the end-to-end analysis and implementation of Monthly Rate Revisions by gathering requirements from actuarial teams and product managers, analyzing their impact on policy administration, and updating mainframe programs accordingly.
Directed daily Kanban stand-ups, ensuring smooth workflow coordination, removing blockers, and tracking progress to meet sprint and project milestones.
Provided technical leadership in analyzing complex legacy COBOL and Assembler applications, extracting critical business logic, and creating detailed data mapping documentation to support the phased migration to Guidewire PolicyCenter.
Oversaw ongoing production support for key legacy systems such as Gateway, Amica Number Master, and Enterprise Database (EDB), managing enhancement prioritization, quality assurance, and deployment to ensure business continuity.
Championed performance tuning and troubleshooting of nightly batch processes, leading root cause investigations, implementing permanent fixes, and optimizing runtimes to meet stringent operational deadlines.
Led incident management efforts for CICS dumps, coordinating cross-functional teams to analyze dumps, identify root causes, implement corrective actions, and maintain detailed knowledge base documentation for future reference.
Directed resolution of data integrity issues causing suspended messages in Guidewire PolicyCenter queues, improving transaction throughput and system stability.
Acted as the primary liaison between client business teams and offshore developers, clarifying technical requirements, ensuring alignment, and fostering a culture of quality and continuous improvement.
Proactively identified recurring defects and root causes, initiating long-term fixes to improve overall system stability and user satisfaction.
Collaborated with Amica and IBM stakeholders to identify, propose, and implement system enhancements that improved robustness, performance, and client satisfaction, contributing to business growth.

Tools & Technologies: IBM Mainframe, COBOL, Assembler, JCL, IBM DB2, SQL, REXX, CICS, SyncSort, DumpMaster, JIRA, Confluence, BMC Remedy, SQL Server, Control-M and Control-D

Aug 2023 - Jun 2024

Mainframe Decommissioning

Played a pivotal role in Mainframe Decommissioning initiatives by conducting comprehensive dependency analysis across multiple legacy systems to identify critical integrations, data flows, and application interdependencies. This analysis helped define safe and effective retirement paths for mainframe components without impacting business operations.
Developed and executed strategic phased decommissioning plans, breaking down the complex migration into manageable stages aligned with business priorities and technical readiness. These plans minimized downtime, ensured continuity, and allowed for thorough validation at each phase.
Led rigorous parallel data validation runs between the legacy mainframe environment and newly implemented distributed systems, identifying data gaps, inconsistencies, and transformation issues. Coordinated with data architects and QA teams to resolve discrepancies, ensuring the integrity and completeness of migrated data.
Worked on a robust legacy data archival solution, extracting critical legacy data into well-structured XML files and securely storing them on AWS S3 cloud storage. This solution enabled efficient long-term preservation and fast retrieval of legacy information to support legal, compliance, audit, and subpoena requests.
Ensured that all nightly production batch jobs continued to run smoothly without interruption during the decommissioning phases, safeguarding business operations and maintaining data processing schedules.
Collaborated extensively with cross-functional teams—including business analysts, data modelers, compliance officers, and IT infrastructure teams—to synchronize decommissioning activities, validate adherence to data retention policies, and ensure regulatory compliance throughout the project lifecycle.
Established documentation standards and created detailed runbooks outlining the decommissioning process, fallback procedures, and data access protocols, enhancing operational transparency and enabling future audits or investigations..
Continuously monitored decommissioning progress and post-decommissioning system health, proactively addressing issues and optimizing processes for subsequent phases of the mainframe retirement roadmap.

Tools & Technologies: IBM Mainframe, COBOL, Assembler, JCL, IBM DB2, SQL, REXX, CICS, SyncSort, DumpMaster, JIRA, Confluence, BMC Remedy, SQL Server, Control-M and Control-D.

Jul 2024 - Present

Financial System Modernization

Analyzed legacy financial systems written in COBOL and Assembler to extract policy and claims processing logic for modernization.
Created detailed data mapping sheets to translate legacy statistical data structures to modern PL/SQL schemas.
Authored pseudocode and business logic specifications for PL/SQL developers to ensure accurate system redevelopment.
Acted as a liaison between business users and technical teams to clarify legacy behavior and ensure functional alignment.
Responded to developer queries regarding business rules, ensuring clear understanding and proper implementation.
Reviewed and validated PL/SQL unit test results against legacy system outcomes and expected financial scenarios.
Conducted impact analysis and provided implementation recommendations during Monthly Rate Revision tasks.
Assessed required modifications in PL/SQL procedures to accommodate updated rate structures and regulatory changes
Participated in sprint planning, backlog grooming, and story documentation using Agile tools (JIRA, Confluence).

Tools & Technologies: Oracle PL/SQL, MongoDB, MongoDB Compass, Python, COBOL, Assembler, Excel, VS Code, Notepad++, Agile, Confluence and JIRA.