Mangalambigai Annamalai

The Hartford ( May 2019 – Current)

Project Name: Special Handling Instructions

Role: Senior AWS Solutions Architect

Description: The Hartford is selling online insurance products, and it involves different modules like Policy creation, Claims Handling, Annuities, Document archival. This project purpose is to rewrite and migrate Account Service agreements application to AWS cloud. It involves developing microservices to create, add, update special handling instructions related to claim and to upload relevant documents to S3.

Environment: Angular UI, AWS lambda, AWS ECS Fargate, ALB, S3, AWS Glue, AWS RDS Aurora PostgreSQL

· Led the project to move the ASA application from on-premises to the AWS cloud, ensuring a smooth transition.

· Rewrite the Application using Angular, AWS RDS Aurora, S3

· Built and deployed reliable systems using ECS Fargate for managing containers, S3 for storing files, Lambda for running code without servers, and Aurora RDS for databases.

· Transitioned the on-premises Oracle database to RDS Aurora Serverless via AWS DMS Migration, ensuring secure and efficient data transfer.

· Worked with the DevOps team to automate deployments using Terraform and Jenkins, cutting deployment times by 40%.

· Moved the on-premises Oracle database to RDS Aurora Serverless using AWS DMS Migration, ensuring data was moved safely.

· Created and implemented microservices using Python Lambda to add and update ASA application features.

· Transferred various documents from Oracle DB to S3 using AWS Glue Python jobs, automating the data transfer process.

· Led the disaster recovery strategy for the application in the us-east-2 region, ensuring the system could quickly recover from failures.

· Reviewed architectures for clients and internal teams to make sure AWS services were used efficiently and cost-effectively.

· Added S3 presigned URLs for secure upload and download access to S3 objects within ECS Fargate, making it easy to temporarily access files without needing AWS credentials.

· Implemented multi-region access points for accessing S3, ensuring high availability and faster access to data across different regions

· Used SQLAlchemy ORM for database query formation and execution, simplifying database interactions and improving code maintainability.

Project Name: ECOS Digital Forms

Role: Technical Lead

Description: The Hartford is selling online insurance products, and it involves different modules like Policy creation, Claims Handling, Annuities, Document archival. This project purpose is to move workers comp document created and management to Broadridge as it was managed by Document Management earlier. This will significantly reduce the volume of templates that the Doc Management Team currently manages. It involves developing microservices to communicate to BRCC and incorporate AWS layer to move into serverless platform by using AWS lambda, ECS Fargate.

Environment: Guidewire Claimcenter 9.0, AWS Lambda, Aws Step Functions SQS, AWS SNS, AWS ALB

· Led the implementation of multi-tier web applications to AWS using services like state machine, S3, Lambda, RDS, ensuring high scalability and reliability.

· Designed and Implemented AWS Step Functions workflows to automate complete business process for document multiple status and process to reduce manual intervention.

· Integrated Step functions with AWS Lambda, SQS, SNS to create event driven workflows with precise error handling and retry mechanism.

· Utilized AWS Secrets Manager to store API keys for API authentication, enhancing security and simplifying key management.

· Created service catalog products to establish code pipelines for different environments, streamlining the deployment process and ensuring consistency across environments.

· Developed CloudFormation templates to create and deploy AWS Lambdas and ECS, automating infrastructure provisioning and deployment.

· Configured AWS Application Load Balancer to distribute requests among ECS instances, ensuring high availability and load balancing.

· Implemented Guidewire Inbound Rest Api to update document metadata from Digital Forms

· Implemented CloudWatch alarms and metrics based on ECS and Lambda usage, enabling proactive monitoring and alerting.

Project Name: E-Distribution

Role: AWS Solutions Architect

Description: E-Distribution is an automated system to distribute Ceded Reinsurance billing information and relevant documents to Direct Billed Organizations of HIG. This system is implemented with 3 of the Reinsurers

Environment: AWS Glue, AWS lambda, AWS Aurora

· Transitioned the on-premises Oracle ODS database to RDS Aurora Serverless via AWS DMS Migration, ensuring secure and efficient data transfer.

· DB Links remediated as Glue jobs for feeds, Informatica jobs to be decoupled by writing to files which are picked up by Glue jobs. Lookup values using DB Links or DB connections will be remediated as APIs.

· Compute implemented in AWS Lambda for SPA and SOAP services. EC2 for Autosys client and Spring Batch.

· Configured multi region S3 buckets for storing bills and documents.

Project Name: Enterprise Claim Operating System.

Role: Lead Developer

Description: The Hartford is selling online insurance products and it involves different modules like Policy creation, Claims Handling, Annuities etc. This project focuses on to handle workers compensation claims using Guidewire Claimcenter product and to manage downstream integrations with Claimcenter.

Environment: Guidewire Claimcenter 9.0, Spring Batch, Gosu, Java, Soap and Rest Webservices, XML, XSLT, Soap UI, SQL, PLSQL, WebLogic 10.3, oracle, JSON, angular js.

Responsibilities:

· Enhanced Conduent integration to process payments from medical bills.

· Worked on HR data feed integration to enable HR data feed and auto populate employee data for any account in ECOS.

· Implemented Outbound integration with Healthe system integration User Supervisor details.

· Worked on estimating new project, epic and transforming into features, user stories.

· Worked on sending account management data to Risk Management and Information system via spring batch.

· Develop a Guidewire work queue batch to send Conduent pay order failure details.

· Worked on sending EDI baseline data based on Jurisdiction state change.

· Designed and developed subrogation questionnaire for claims created via Guidewire portal using Fnol snapshot.

· Automated Guidewire batch execution in Bianca framework.

· Mentored the team in understanding ClaimCenter application and assist them in doing the analysis.

· Owned Technical debt user stories and resolved issues in order to support ClaimCenter Upgrade.

· Worked on Nexus scan vulnerabilities issues.

· Worked on release activities to coordinate and consolidate release components with environment team.

CapGemini America, Inc. (Nov 6, 2017-May 24, 2019)

CapGemini is an information technology service, business solutions and outsourcing Services Company with clients all over the world. I was engaged in Insurance project for the client Farmers Insurance.

Project Name: Guidewire ClaimCenter Program.

Role: Technical Manager

Description: Farmers Insurance Group of Companies is a leading U.S. insurer group of automobiles, homes, small businesses and provides a wide range of other insurance and financial services products. Legacy system HEART is a single claims processing platform in support of a united claims organization encompassing Farmers, Foremost, Bristol West and 21st Century system. National Workers Compensation Claims System (NWCS) is a claims application and claims processing application supporting the Commercial, Personal, Homeowners and Workers Compensation claims. Both HEART and NWCS are applications that reside and process on a Siebel platform. This Project involves Personal Lines Auto, Bristol West non-standard Auto, Commercial Auto, Specialty Auto, and Workers Compensation from both the HEART and NWCS claim systems to be replaced with Guidewire Claim Center.

Environment: Guidewire Claimcenter 9.0, MuleSoft, Gosu, Java, Soap and Rest Webservices, XML, XSLT, Soap UI, SQL, PLSQL, JBOSS, oracle, JSON, GitHub, Splunk

Responsibilities:

· Developed solution design document for Coverage engine, SRM, MDM integrations.

· Worked on Mitchell decision point Xpack integration and customized based on business needs.

· Worked on policy search and retrieval from coverage engine system using Soap and Rest Webservice on Policy Search Plugin.

· Validate the process flows and story cards for MDM.

· Worked on recovery integration critical issues and defects on integrating with cash receipts system.

· Worked on DocuSign accelerator and worked with DocuSign system on customizing the implementation.

· Worked on manual coverage integration with coverage engine system.

· Validated the design solution of Claim center offline system and worked on environmental issues on implementing the same.

· Worked on claim data migration issues from legacy system to claim center.

· Worked on claim archival issues and retrieval solution on sending legacy claims to ODS.

· Worked on Claim Specific Limit accelerator for an adjuster to auto approve the payments.

· Developed claim inquiry soap web service for mobile app, sales force application

· Customized GW data model upgrade plugin to remove unused columns in entity.

· Analyzed transactions to be monitored in app dynamics for instrumentation

· Refined the loggers for Splunk dashboard to identify errored transaction.

Cognizant Technology Solutions (March 10,2014 – Nov 3,2017)

Cognizant Technology is an information technology service, business solutions and outsourcing Services Company with clients all over the world. I was engaged in Insurance project for the client The Hartford.

Project Name: Enterprise Claim Operating System –Healthe System

Role: Technical lead

Description: The Hartford contracts with multiple vendors who provide ancillary services for the Workers’ Compensation line of business. This requires vendor management to oversee and manage multiple vendor relationships and claim staff to schedule services through several vendors using different channels with limited visibility into the status of scheduled services. Additionally, The Hartford is not taking advantage of reduced rates and advanced billing scrutiny afforded through an ancillary benefit manager. The Enterprise Claim Operating System (ECOS) Project will integrate with Health systems for Ancillary Benefit Services Management. Ancillary Benefit Services (Transportation, Translation, Durable Medical Equipment, Physical Therapy, Home Health) will be managed / adjudicated in HES and the bills will be passed to Stratacare (Conduent) and Stratacare will send the ABM Bills to ECOS through the Existing Pay order Process. ECOS will process the payments for HES.

Environment: Claimcenter7.0, Spring Batch, Gosu, Java, Webservice, XML, XSLT, SoapUI, SQL, PLSQL,

WebLogic server 10.3, Oracle.

Responsibilities:

· Lead the team in developing the integration between ECOS and Healthe Systems to support inbound/outbound feeds using a separate Event message destination.

· Online claims and injury data are sent to Healthe system using the Event message destination with the service exposed by Healthe.

· Worked with the Application Integration Services team to develop Proxy URL for the service hosted by ECOS in order to use by Healthe system.

· Developed the soap webservice to receive send claim medical, notes data from Healthe System.

· Worked with ECOS and Hartford identity support management team to provide the single sign on access to ECOS users to HES Application using users email address authentication.

· Assisted the team in developing GW batch to send ECOS user’s data in order to provide access to HES application.

· Developed the Spring batch to process the Inbound documents send by Healthe.

· ECOS claims History data are sent via Managed File Transfer. Generated the History data using sql query and regulated using macro based on the format expected by HES.

· Worked with Performance team to provide test data for new integration testing with HES and analyzed the test results to make sure ECOS performance is not degraded.

· Coordinated with HES team for providing and receiving the test data along with test results validation.

· Coordinated with Deployment team in setting up the environment for project deployment.

Project Name: Enterprise Claim Operating System.

Role: Technical lead

Description: The Hartford is selling online insurance products and it involves different modules like Policy creation, Claims Handling, Annuities etc. This project focuses on to handle claims using Guidewire insurance products for commercial line of business like property, auto, workers compensation etc . The Enterprise Claim Operating System (ECOS) Project will replace two claims handling systems (CI and Source) and one “first notice of loss” application (Loss Connect) with a more configurable, adaptable and upgradeable claims handling system from Guidewire. Internal and external interfaces that interact with CI, Source and Loss Connect adapted to interface with the new Guidewire system.

Environment: Guidewire Claimcenter 7.0, Spring Batch, Gosu, Java, Soap and Rest Webservices, XML, XSLT, Soap UI, SQL, PLSQL, WebLogic 10.3, oracle, JSON, angular js.

Responsibilities:

· Developed FNOL based on business rules and requirements.

· Lead 5 members development team in the agile implementation on developing document management and policy search.

· Developed Policy search and Policy retrieve based on policy number, customer details, account details or create unverified policy

· Developed document management system by integrating with Xpression 4.5 for document creation and Documentum for document storage.

· Worked on customizing IDocument Metadata source, IDocument Template source for document creation and storage.

· Customized the Idocument service to retrieve document metadata.

· Developed a Proof of Concept with Atmosphere framework and angular js to broadcast message to individual/group of users.

· Analyzed the performance issues using Dynatrace tool and Guide wire profiler.

· Worked on performance issues in FNOL screen UI, Documents management, policy integration and resolved it.

· Worked on Performance issues and successfully resolved it by improving performance on screen UI, different integrations with ClaimCenter.

· Responsible for improving UI performance in displaying search results.

· Developed ant build scripts for deployment.

· Developed Workers Comp Disability guidelines predictive modelling calculation by invoking REST Web service and processed the JSON response using GSON.

· Developed business rules to identify duplicate claims during claim creation using Gosu Queries.

· Developed reusable sql/plsql report generation tool using spring framework.

· Worked on Fraud referral rules to identify fraud/suspicious claims. Developed and consumed Soap webservice to send / receive data to SIRIS system.

· Invoked and published Soap web service for SIU referral system to send/receive data from SIRIS system.

· Worked on Policy refresh/Policy Select Integrations. Parsed the xml response from vendor using XSLT mapping.

· Developed account management system and integrated with policy in FNOL process through webservice.

· Developed Policy upload and IRC upload in Account management system through guidewire –spring batch integration.

· Developed validation, workplan rules, activities and its assignment on claim creation.

· Worked on Claim metrics at the claim level and at exposures level.

· Developed workflows for asynchronous communication without using user session threads for improving UI performance.

· Developed roles and permissions specific to screens and claim handling.

· Used Soap UI to do unit/Integration testing of soap and Rest webservice.

Project Name: Enterprise Claim Operating System –Push Notification POC

Role: Technical lead

Description: The Hartford is selling online insurance products and it involves different modules like Policy creation, Claims Handling, Annuities etc. This project focuses on to handle claims using Guidewire insurance products for commercial line of business-like property, auto, workers compensation etc. The Enterprise Claim Operating System (ECOS) Project will replace two claims handling systems (CI and Source) and one “first notice of loss” application (Loss Connect) with a more configurable, adaptable and upgradeable claims handling system from Guidewire. Internal and external interfaces that interact with CI, Source and Loss Connect adapted to interface with the new Guidewire system.

Environment: Guidewire Claimcenter 7.0, Atmosphere Framework, Gosu, Java, Rest Webservice, XML, XSLT, Soap UI, SQL, PLSQL, WebLogic server 10.3, oracle.

Responsibilities:

· Developed Proof of Concept in sending notification to individual users/group of users.

· Users will be notified on any specific service unavailability for certain duration /specific changes in the application or new functionality added.

· Users need to be subscribed to listen for incoming messages. Users are subscribed using atmosphere framework.

· Atmosphere framework and angular js are used to send notification message to users when messages are sent to respective users.

· Implemented the functionality of setting expiration time on message in order to stop sending message after the expiration time.

TATA Consultancy Services Limited (October 30, 2008 – March 12,2014)

TATA Consultancy Services Limited is an information technology service, business solutions and outsourcing Services Company with clients all over the world. I was engaged in Insurance project for the client CNA.

Project Name: Self Service Endorsement.

Role: Technical lead

Description: CNA is selling online commercial insurance products and it involves different modules like customer creation, premium calculation, policy issuance, business classification. This project involves introducing endorsement functionalities for issued policies in CNA Central.

Environment: J2ee 1.5, TopLink, Oracle 11g, Bridge architecture, Spring 2.0 for business rule engine,

JAX-WS, Java script, Jquery, SOAP, WSDL, HTML, SQL, PLSQL, PVCS.

Responsibilities:

· Worked as Technical Lead Developer and involved in requirement Analysis, Design and development. Used Core Java, Toplink, JDBC, JSON, Web Service as an integration Framework to design and develop the application.

· Used jQuery in the UI to show/hide screen details based on user roles.

· Mapped the Oracle tables and java class using Top link.

· Developed metrics report generation using Spring framework

· Responsible for coding, deploying and testing according to the client requirements and also perform code review and debugging.

· Coordinate with offshore and deliver the deliverables with quality and in timelines.

· Responsible for resolving the technical issues during development.

· Coordinated with QA to review and validate the integration test cases and results.

· Have successfully refactoring the Existing code.

· Resolved performance issues and managed team members for different problems resolution at various levels

· Prepared coding standards, deployment checklist templates which helped to improve quality of deliverables.

Project Name: CNA Central

Role: Production Support Lead and Onsite coordinator Major and Minor Enhancements

Modules: Online Quoting, Referral process, Billing, Issuance, Endorsement.

Environment: J2ee 1.5, TopLink, Oracle 11g, Bridge architecture, Spring 2.0 for business rule engine,

JAX-WS, Java script, jQuery, SOAP, HTML, SQL, PLSQL, WAS 6.0.

Responsibilities:

· Capturing Business process Requirements and managing business rules.

· Evaluate business requirements, perform a Gap analysis, and create detail design specifications

· Preparing high level and low-level design

· Be responsible for the overall quality and timeliness of the deliverables.

· Code review using ASSENT tool which gives the report of execution time taken in unit level testing and application-level testing.

· Identification of areas of improvement in legacy Java applications.

· Establishing & monitoring the processes for Issue

· Building test cases, constructing test-data from test cases, arriving at test-drivers from test-data, Verification of test results and Test-result logging and reporting.

· Performance Tuning – This activity involves fine-tuning the existing application and to monitor the performance of the newly implemented enhancements.

· Defect tracking and managing change requests.

· Single Point of Contact for CnaCentral severity 1 and 2 production support issues.

· Analyse root cause of defects

· Issue identification and resolution

· Used File compare tool to merge files from previous release.

Project Name: Ocean Marine Program

Role: Technical Lead

Modules: Online Quoting, Premium generation, Referral process, Billing, Issuance, Endorsement, Updation of policy number in CICS system.

Description: Introduction of new ocean cargo insurance product in the existing application

Environment: J2ee 1.5, TopLink, Oracle 11g, Bridge architecture, Spring 2.0 for business rule engine,

JAX-WS, Java script, jQuery, SOAP, HTML, SQL, PLSQL.

Responsibilities:

· Estimation of program in IT review.

· Participated while capturing business requirement and RSD preparation.

· Prepared High level and low-level design.

· Developed prototypes for rich user interface such as light box in Jquery.

· · Invoked Ajax call for Soap webservices invocation zip code validation.

· Used Top link as ORM for database connection with oracle 11g.

· Developed dependency injections (IOC) modules for commodities and packing level.

· Developed the coverage rule engine in Spring 2.0 and used the setter dependency injection modules for sub coverages.

· Developed Batch Job for updating policy number in CICS system.

· Prepared Coding Standards, Requirement gathering checklist and Deployment checklist templates which helped to improve quality of deliverables.

· Lead the team in delivering the deliverables with quality and in timelines.

· Coordinated with QA team for building test cases.

· Defect tracking and managing change requests.

· Improved the reusability by making business rules table driven.

Project Name: Real Time Quoting (RTQ)

Role: Technical Lead

Modules: Online Quoting, Premium generation, Referral.

Description: Developed the Commercial Insurance connect, Auto, worker compensation products using accord standards.

Environment: Acord jar, J2ee 1.5, JAX RPC, SOAP Webservice.

Responsibilities:

· Developed Soap web service for Policy number generation.

· Mapped the coverage details based on acord standard.

· Used Top link as ORM for database connection with oracle 11g.

· Prepared coverage mapping document for. ACORD standard with sea pass gateway.

· Performed the functionality testing using JUnit.

· Win sql tool was used to query DB2 database.

· JSON is used for Proposal letter generation either in pdf or word document. It’s a collective data for coverage details for the quote.

Project Name: Re Rating.

Role: Developer

Modules: Premium calculation for expired quotes.

Description: Developed Batch job for re rating the expired quotes automatically and makes the agent issue the policy.

Environment: Acord jar, J2ee 1.5, JAX WS, SOAP Webservice, JSP, Servlet, HTML, SQL, PLSQL, EJB.

Responsibilities:

· Developed plsql procedure to retrieve the expired quotes.

· Used HTML and JSP for presentation layer.

· Jquery and JavaScript are used to disable and enable the quote eligible for re rating.

· Developed the metrics report of re rated quotes using SQL, Servlet and JSP.

· Developed Test Harness for re rating the quote. It helps to developers and to QA for the verification of standard input and output.

· Developed business logic in such a way new coverage addition are made table driven.

· Developed Business rule engine in EJB for removing the expired coverage while re rating.

· Developed the premium calculation algorithm and deploy it as webservice.

· Used setter injection to update the new premium details.

· Developed Batch job to pick the failed quotes for rating while re rating. Its auto batch job which runs every day for an hour.

· Quote comparison tool is implemented using JavaScript.