Pramod Siddabattuni – Product Consultant / Data Solutions Architect

The Annuity Host Conversion project migrated a portion of MetLife of Connecticut (MIC)’s legacy annuity book from a third-party Annuity Host system to Enterprise Vantage — MetLife’s proprietary home-grown policy administration platform. Following conversion, annuity policies became administrable both within Enterprise Vantage and through SmartApp — MetLife’s web-based policy administration application used by home office employees and agents.

SmartApp modules: Client Acquisition (policy search and filtering) · Reports (Crystal Reports-powered user-defined reporting) · Memo Pad (customer notes and account history) · Web Services (inter-application integration across MetLife’s technology estate)

Developer & Module Lead responsibilities:

• Design and development of web pages and web services for assigned SmartApp modules
• SQL Server stored procedures, functions, triggers, and deployment scripts
• SSIS packages for populating the application database from external flat file sources
• Direct client communications for assigned modules
• Coordination with Test teams, DBA, and Production Control teams during deployment

The SEC Print application gave MetLife’s Fund Management Team a governed, auditable platform for managing end-to-end SEC-compliant document delivery across its variable annuity and fund product portfolio — consolidating client data from MetLife administrative systems, third-party systems, eDelivery registration data, and fund-level trading information.

Application modules: Query (client population filters by product, fund, fund family, issuing company, share class) · Document (prospectus and disclosure catalogue) · Mailing (document + query + delivery type configuration) · Project (print vendor output management) · Dashboard (real-time project and data load status)

Developer & Module Lead responsibilities:

• Design and development of web pages and user controls for assigned SEC Print modules
• Stored procedures, functions, triggers, and deployment scripts
• SSIS packages populating the application database from flat files and DB2 systems
• Direct client communications for assigned modules
• Close integration with the Mainframe team via File-Triggered Maestro jobs for Mainframe-sourced administrative data

SMILE (Systems Management Information Library for the Enterprise) is the integrated monitoring portal for MetLife’s ET Monitoring Engineering team — responsible for end-to-end monitoring of 300+ enterprise applications and ~3,500 Unix/Windows servers using BMC Patrol, BMC Perceive, Mercury SiteScope, Mercury Business Availability Center, and Real User Monitoring.

SMILE functional areas: Application Information · Monitoring Requirements · Restoration of Service runbooks · CAHA (Comprehensive Application Health Analysis) Reporting · Dashboard · Task Tracker · Knowledge Repository. Integrated with BMC Perceive, Mercury BAC, and Mercury SiteScope, plus web services connecting to MetLife’s Capacity Planning Application.

Offshore Developer → Onsite Coordinator (single point of contact) responsibilities:

• Web pages, user controls, stored procedures, functions, triggers, deployment scripts
• Perl jobs and DTS packages populating the SMILE database from flat files, Oracle, and SQL Server
• Web services enabling integration between SMILE and the Capacity Planning Application
• Collaboration with monitoring groups for tool integrations (BMC/Mercury)
• Daily/weekly status meetings as single client point of contact, SME/BA requirements engagement, Technical Architect/DBA/Production Control coordination

Web application development
ASP.NET web pages, user controls, and web services across all three projects delivering browser-based interfaces for MetLife’s home office, agent, and technology teams.

Database development
SQL Server stored procedures, functions, triggers, and deployment scripts implementing business logic at the database layer across all three programmes.

Data integration
SSIS packages (Projects 1 & 2), Perl jobs, and DTS packages (Project 3) populating application databases from flat files, DB2, Oracle, and SQL Server sources.

Mainframe & monitoring integration
File-triggered Maestro jobs for SEC Print Mainframe connectivity; direct BMC/Mercury tool integrations within SMILE for enterprise monitoring visibility.

Policy administration modernisation
Reduced MetLife’s dependency on a third-party legacy system, consolidating the MIC annuity book onto Enterprise Vantage with a modern agent interface through SmartApp.

SEC regulatory compliance
A governed, auditable mailing management platform replaced fragmented manual processes with a structured, traceable regulatory document delivery workflow for the Fund Management Team.

Enterprise-scale operational visibility
SMILE unified monitoring requirements, application health, and incident management across 300+ applications and 3,500+ servers within a single integrated portal.

Cross-system integration
Web services, data integration pipelines, and Mainframe integration across all three projects connected applications to MetLife’s broader technology estate, reducing data silos.