Towfik

Towfik

Data Analyst
United Kingdom
English

نبذة عني

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

CAPITA IT Services
Apr 2017 - حتى الآن · 9 سنوات 3 أشهر

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

CAPITA IT Services
Apr 2017 - حتى الآن · 9 سنوات 3 أشهر

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

NTT DATA GDS
Sep 2015 - Mar 2017 · 1 سنة 6 أشهر

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

NTT DATA GDS
Sep 2015 - Mar 2017 · 1 سنة 5 أشهر

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

Cognizant Technology Solutions
Feb 2013 - Sep 2015 · 2 سنوات 7 أشهر

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

Cognizant Technology Solutions
Feb 2013 - Sep 2015 · 2 سنوات 7 أشهر

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

المهارات

ماي إس كيو إل بايثون (لغة برمجة) قاعدة بيانات Db2 من آي بي إم (IBM Db2) نومباي (مكتبة لغة Python) باور بي آي Business Analysis Data Analysis SQL SQL Stored Procedure Functions Views Indexes SSIS SSRS Pandas Matplotlib Data Loading Data Modelling DAX Agile Waterfall Functional Testing System Integration Testing User Acceptance Testing Smoke Testing Azure DevOps Mainframe DB2 Excel MSTFS SDLC Unit Testing Coding Production Support Incident Management Root Cause Analysis Automation
الإبلاغ عن هذا الملف الشخصي؟