Sonal Mishra

Project: EDW Data Warehouse

• Data Warehouse(EDW/WDW/RDW)
• Technologies: DB2, Teradata, Snowflake, COBOL, VSAM, JCL, Linux
• Team Size: 5
• Project Summary: Managing data for a leading US telecom provider through a robust data warehouse system designed to support business intelligence and analytics.

Key Responsibilities:

• Leading the Tier 2 support on mainframe and linux platforms which include wide range on applications like(CORAL, WDW, RDW, EDW, PMDB, RAS)
• Overseeing deployment activities and ensuring smooth production movement
• Improved customer satisfaction through proactive problem-solving and efficient resolution.
• Championed the adoption of new software tools that streamlined workflows.

Project: Genesis

• Domain: Retail Banking
• Technologies: DB2, CICS, COBOL, VSAM, JCL
• Team Size: 12
• Project Summary: Developed and supported systems for card and paper payment processing. The project encompassed user interfaces for payment initiation, debit and credit transaction selectors, credit reversal cycles, and settlement mechanisms. Additional components included automated payments (autopay), electronic billing (e-bill), and GCMS notification workflows.

Key Responsibilities:

• Conducted detailed requirement analysis and created comprehensive technical documentation.
• Designed and developed COBOL-based solutions for payment processing workflows
• Executed unit testing and ensured code quality and performance
• Monitored deployment activities and supported production releases

• Project: CSS Billing
• Domain: Telecom Billing
• Technologies: IDMS, CICS, COBOL, VSAM, JCL
• Team Size: 17
• Project Summary: CSS Billing system managed the non-real-time billing operations for broadband customers in the UK. It comprised multiple subsystems that handled call log validation, repricing, and billing for diverse products, bundles, and packages. The system generated bills in PDS format for printing, processed payment gateway feeds, and managed debt follow-ups. It also produced daily and monthly revenue assurance reports to support financial tracking and compliance.

Key Responsibilities:

• Participated in requirement gathering and client communications
• Developed applications and transformed prototypes into production-ready designs
• Conducted unit testing, ensured application compatibility, and resolved defects