About Me
Good exposure in SQL development including stored procedure , triggers and functions.
Hands-on experience in performance tuning.
Good knowledge in ETL process and data migration
Experience
Business & Data Analyst
<p>Analyze the high-level requirement and break down into low level modules and share the low-level design to System developer.<br>
Go through the regulatory circular and do impact assessment on the system and decide if the regulatory changes are in scope or out of scope.<br>
Co-ordinate with system developer for any functional changes and estimate the budget required for that change.<br>
Communicate periodically with stake holder regard the status of the project.<br>
Taken care of Procedural changes in System and arranging session to operational team and preparing AWB (Awareness Bulletin).<br>
Effective Communication to Developer & Stake holder and performing Peer review on Design & BRD.<br>
Involved in Functional Testing, System Integration Testing, User Acceptance testing and Smoke Testing.<br>
Reporting the business performance to stake holders using visualization tool Power BI.<br>
Developed various interactive dashboards along with tables, charts and KPI.<br>
Good exposure to Data loading and data modelling & DAX calculations.<br>
Expertise in creating SQL Stored Procedure for user reporting, creating functions for enhanced data extract, develop views and indexes.<br>
Good Knowledge in SSIS and SSRS process.<br>
Hands-on experience in Python to work on various libraries such as Numpy, Pandas, Matplot lib.<br>
Worked in various data extract process and format it as per requirement and share it to Stake holder in traditional methodologies.<br>
Extracted UK Pension policy data from various tables to analyze the performance of Unit-linked policies in the open market.<br>
Evaluated the Pension policies growth by analyzing the growth of the invested fund.<br>
Created the fund growth history table across various funds such as Cash, Property, Managed, International and Security fund and provided the comparison chart across funds.<br>
Fund data from various subsystems are gathered (from SQL server, Mainframe DB2, Excel) and load it into common warehouse.<br>
Processed the data cleaning and formatting and then created the data modelling to do the visualization.<br>
Shared the insight to Operations and Client accounting team to highlight the performance of the fund.<br>
Worked as Application Tester in Unisure Upgrade Project - Recently worked on System Upgrade project to upgrade Unisure (Insurance Software) application from Version 4 to 7.<br>
Involved in lot of testing activities to ensure the smoothening deployment and to support the system administrator.<br>
Involved in decommission the existing version control (Dimension) and move the project code to new version control (MSTFS).<br>
Good knowledge in Azure DevOps.<br>
End-End testing of online and batch process.<br>
Integration Testing of Various downstream applications.<br>
Creation of SQL Stored Procedure.<br>
Maintaining the Policy Audit database.<br>
File Transfer Testing.<br>
Liaise with Vendor if there are any issues with upgraded applications.<br>
Lead Developer/Business Analyst in Incidents – Raise incident if any system defect is identified and interact with Stakeholder and Developer to apply the patches.<br>
Do impact analysis and share the RCA with Incident management team.<br>
Identify the impacted population using SQL.<br>
Do estimate after incident work is approved.<br>
Follow SDLC process to fix the issue. This involves Design, Coding, and multiple levels of testing.<br>
Deploy the changes & Remediate the Impacted polices.<br>
Create SOP for Operation team if required.</p>
Business & Data Analyst
Analyze high-level requirements, Co-ordinate with system developer, Communicate with stakeholder, Perform Peer review on Design & BRD, Data reporting using Power BI
Support Analyst
<p>Production monitoring and ABEND fixing during batch run.<br>
User support on Client working hours and provide immediate solution for User raised tickets.<br>
Analysis on routine incidents and identifying RCA and apply permanent fix for that.<br>
Acts as team lead and guides the juniors for routine manual tasks.<br>
Working on Automation process for regular manual task like Rate upload, Commission Upload and Agent Upload.<br>
Always works in major Insurance functionality like Debit-Balance, Agent Commission Process, Early Payoff Process, Billing Cycle, Claims and New Business.<br>
Providing batch support on various cycles such as year-end, Quarter-end and Month-end.</p>
Support Analyst
Production monitoring,User support,Analysis on routine incidents,Working on Automation process,Providing batch support.
Analyze high-level requirements,Co-ordinate with system developer,Communicate with stakeholder,Perform Peer review on Design & BRD,Data reporting using Power BI
Product Designer
<p>Enhance the system to support the new insurance plan released in the global market.<br>
Enhance the system functionality to support the business.<br>
Create Low level design and involve in Coding and Unit Testing.<br>
Follow SDLC process and support the entire project from scratch to Deployment & Warranty.<br>
Create lot of Valuation Extract which support the actuarials.</p>
Product Designer
Customize system for new insurance plans,Enhance system functionality,Coding and Unit Testing, develop new product features
Analyze high-level requirements,Co-ordinate with system developer,Communicate with stakeholder,Perform Peer review on Design & BRD,Data reporting using Power BI