MANIKANDAN SUBRAMANIAN

Project:

Data Squad (Enterprise Data Warehouse / Data lake / OBIEE/Tableau reporting /Data Analytics)

Roles and Responsibilities:

• Handled Major Product launches including Variable annuity product launches, Institutional product launches like Blackrock/Health Equity and lead bigger projects like Reinsurance initiatives, data analytics initiatives.
• Identified and mitigated potential risks to business operations by conducting detailed systems analysis and implementing preventive measures.
• Partnering with business in delivering all projects under IR/GR/Institutional tribe comprises of various technologies including Enterprise Data Warehouse (IIAS appliance), Data lake (Cloudera), OBIEE/Tableau reporting and Data Analytics.
• Played key role in successful launch of new product lines by coordinating between development teams and stakeholders.
• Facilitated smoother communication between IT and other departments, bridging gap with regular updates and meetings.
• Transformed data management practices, introducing advanced analytics tools that provided deeper business insights.
• Very Strong knowledge on Insurance Life, Annuity and Institutional data and can able to understand the business requirements and can interpret it to the developers.
• Contributed to business growth by analyzing market trends and providing strategic recommendations to senior management.
• Analysis starts with Balance sheet/Income statement impacts for any new products. Understanding the product spec to see how the new products impacts existing interfaces or should build new interfaces.
• Improved team productivity with development and implementation of customized project management tools.
• Collaborated with stakeholders to gather essential requirements, ensuring successful project outcomes.
• Improved operational efficiency by automating routine tasks, freeing up staff to focus on more strategic initiatives.
• Discussions with clients and Gathering requirements and create high level business documents.
• Improved stakeholder satisfaction with detailed requirement gathering and effective communication.
• Provided effort estimates for all product launches involving data squad.
• Communicated and explained business requirements to team members to understand and implement functional demands.
• Mentored junior employees, fostering a positive learning environment that promoted personal growth and skill development.
• Attends daily standup calls with the offshore team to clarify any doubts which the squad has in terms of requirements.
• Optimized resource allocation by carefully monitoring project progress, making adjustments as needed to meet deadlines and budget constraints.
• Handled various data extract requests from business users by executing the SQL against IIAS DB2.
• Established performance goals for employees and provided feedback on methods for reaching those milestones.
• Handled various data Audits like PWC, SOX 404 and NY State and Market Conduct Audits.
• Conducted training sessions to empower users with the knowledge necessary to utilize systems effectively.

Achievements:

• Received recognition from CFO of Equitable.
• Completed FLMI (Life) and FSRI (Annuity) under LOMA and Data Science certification from HarvardX.
• Excellent performer in the Data area especially appreciated as ‘valuable asset for the organization’.
• Continuously received Excellent performance rating in Equitable Life Insurance and looking forward for bigger goals to achieve. Long runner in the organization.

Project: CSI e-Policy Project

Roles and Responsibilities:

• Worked closely with clients to gather requirements and translate them into technical specifications for implementation.
• Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.
• Debugged complex software issues, leading to more stable product release.
• Collaborated with cross-functional teams to ensure seamless integration of new features.
• Participated in regular code reviews, ensuring high-quality standards were consistently met across all development efforts.
• Reduced development time by creating reusable code libraries for future projects.
• Conducted thorough code reviews to ensure adherence to coding standards and best practices.
• Corrected, modified and upgraded software to improve performance.
• Coordinated with stakeholders to define project requirements, ensuring alignment with business goals and customer needs.
• Mentored junior developers, providing guidance and support to accelerate their professional growth.
• Developed comprehensive documentation for software projects, simplifying onboarding process for new team members.
• Involved in estimation phase for deliverables
• Conducted daily status calls with offshore team to ensure smooth flow of deliverables
• Led successful launch of multiple software releases, meeting all project objectives and exceeding user expectations.

Achievements in this project:

• Maintained close communication with clients throughout project life cycles for accurate progress reporting and prompt issue resolution.
• Optimized resource allocation for projects, ensuring optimal use of team skills and minimizing project costs.

Project:

Information Database (IDB) – Data warehouse

Roles/Responsibilities:

• Mentored junior developers through regular 1-on-1 meetings, providing guidance on best practices, coding standards, and career growth opportunities.
• Worked closely with clients to gather requirements and translate them into technical specifications for implementation.
• Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.
• Debugged complex software issues, leading to a more stable product release.
• Collaborated with cross-functional teams to ensure seamless integration of new features.
• Participated in regular code reviews, ensuring high-quality standards were consistently met across all development efforts.
• Conducted thorough code reviews to ensure adherence to coding standards and best practices.
• Corrected, modified and upgraded software to improve performance.
• Estimated work hours and tracked progress using Scrum methodology.
• Review of the new COBOL modules for new functions developed by offshore, adhering to coding standards.
• Involved in batch performance tuning using Platinum detector, DB2MSTR and STROBE

Achievements in this project:

• Received four CTO recognitions for various projects delivered on time and quality.

Project:

Customer data (CIF) migration to MDM

Roles/Responsibilities:

• Mainframe component of Customer data migration to MDM and retained few of the outbound processing in mainframe, by utilizing the replication feed from MDM database to DB2 using materialized views
• Requirement Analysis & Design Solution of Business Requirements
• Direct communication with the client for task related query resolution
• Estimating for assigned task using the estimation template provided
• Creating Technical Design Document and Unit Test Case document
• Coding new COBOL DB2 modules, JCL as per IDI and AXA standards in LIBRARIAN
• Conducting training sessions for the team members to operate the Automation Tool
• Self and peer reviews
• Involved in Unit Testing and Integration Testing
• Conducting internal meeting with peer team members on a regular basis
• Communication and coordination with the Onsite Coordinator for technical, functional and task related activities.

Achievements in this project:

• Delivered both the phases of the projects (Wave 3E and 3M) on time with good quality, by coordinating with peer team members in offshore
• Proposed automation approaches for integration testing, which reduces manual effort
• Received appreciations from application delivery manager.

Project:

Tailored Account Processing Billing (Customer Billing)

Roles/Responsibilities:

• Requirement Analysis & Design Solution of Business Requirements
• Direct communication with the client for task related query resolution
• Estimating for assigned task using the estimation template provided
• Creating Technical Design Document and Unit Test Case document
• Conducting training sessions for the team members to operate the Automation Tool
• Self and peer reviews
• Involved in Unit Testing and Integration Testing
• Conducted daily status calls with the offshore team to ensure smooth flow of the deliverables
• Creation of new JCL and COBOL programs for the death match enhancement work and test the same
• Identify all defects during the development phase
• Identify of the root cause of the defects encountered and to come up with action item for the same
• To conduct Defect Prevention meetings to notify the team about the defects and to come up with action plans to minimize the defect count
• Also to identify areas of improvement and to come up with competency development plan for the team members

Achievements in this project:

• Delivered IVR automation project with great success
• Delivered billing statement project on time and with good quality
• Resolved all the open incidents and defects outstanding in the application and made application stable
• Helped CSR in automating the bulk transactions for write-offs/disbursements

Project: Machine Account Checking (Agency Billing) and Commercial Index (CIX)

Roles/Responsibilities:

• Creation of new JCL and COBOL programs for death match enhancement work.
• Identify all defects during development phase
• Identify root cause of defects encountered and came up with RCA analysis
• To conduct Defect Prevention meetings to notify team about defects and to come up with action plans to minimize defect count
• Also to identify areas of improvement and to come up with competency development plan for team members
• Involved in Unit Testing and Integration Testing
• Conducting internal meeting with peer team members on regular basis
• Communication and coordination with Onsite Coordinator for technical, functional and task related activities.

Achievements in this project:

• Delivered Agent commission statement project without any issues by coordinating with onshore team
• Delivered Endevor migration project with great success
• Proposed automation approaches for integration testing, which reduces manual effort
• Received appreciations from application delivery manager.

Project:

National Accounts Receivable System (NARS)

Roles/Responsibilities:

• Creation of module inventory for process for which Rules need to be extracted
• Analyze programs using XPEDITOR and CHANGEMAN program listings to create program understanding documents
• Extraction of Business Process rules, Candidate Business Rules, Validation and System Requirement /
• Constraints and to narrow language more business-like
• Requirement Analysis, Technical Design Documentation and Test Plan Preparation for Death Match
• Enhancement work
• Creation of new JCL and COBOL programs for death match enhancement work.
• Identify all defects during development phase
• Identify root cause of defects encountered and to come up with action item for same
• Communication and coordination with Onsite Coordinator for technical, functional and task related activities.

Achievements in this project:

• Delivered Rules extract project on time for building new LSB application
• Received appreciations from our application delivery manager for our effort