Mis Analyst
Mashreq Bank
Total years of experience :8 years, 7 Months
Data Management on a monthly basis as a part of Retail Banking Group - Finance Team Incentive calculation as per SLA
Consolidated sales data preparation
Loading of System and Manual monthly sales data into database
Handled addendum/policy changes in the automated code as
and when required without affecting other monthly calculations
Extraction of sales reports from MicroStrategy
Generated business performance reports from Sales and Incentive data using Microsoft Power BI
Generated RAR on monthly sales data available in the system and analysis of performance data
Comprehensive understanding of SDLC and data-related technologies
Extract data from a variety of origins, transform data and maintain the data lake
Created ETL workflows and data pipelines using Python programming language and other tools
Performed data pre-processing tasks including classification, validation, missing value corrections
Performed descriptive statistics and analysis, developed insights, and proposed solutions for business queries
Created several dashboards and reports using visualization tools such as Tableau. ∙ Used scripting languages such as Python and R, for hypothesis testing, data validations, and interpretations
Comprehensive understanding of data and data-related
technologies
Worked on traditional data set analysis using Microsoft Excel, and large data sets using tools such as Microsoft Power Query, Google Data Prep, Open Refine
Utilized Alteryx for data preparation and analysis
Successfully interpreted data to conclude managerial actions and strategy
Created data pipelines and workflows using Python
programming language
Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis
Created dashboards and reports using visualization tools such as Tableau, Microsoft Power Bi and Google Data Studio
Used Python and R, for hypothesis testing, to validate data and interpretations
Graduated with 8.25 CGPA