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