Position: Data Analyst / Product analyst / BI Developer
Category: Data Analyst
English level: fluent
Years of experience: 10

Working with McKinsey company at the biggest retail bank of the country on a project of "Transformation" which was aiming to optimize Business Processes and calculate required employee count for the branches. My role was to support "Change teams" with data, reporting and calculations. Established a Business Model to calculate required employee count. Have used Statistical approaches and worked on DataWareHousing projects.
I am an experienced Business & Data Analytics specialist with advanced Excel, SQL, Power BI skills and work experience in financial industries, Retail Banking, Investment bank (Risk Finance and Treasury) and Telecommunication.
My previous jobs required Business Modelling, Data Analysis, Business Intelligence, Data Warehousing, Data modelling during my daily job. I have created and managed analytical reports, automated management reports which was based on SQL connections, and have provided reports in Power BI, Excel, Tibco etc. I have been Excel trainer for the largest retail bank of the country and have taught SQL along with Excel. During my last 2 jobs, I have improved R and Python skills. Also gained technical skills like working with Git Hub, Agile and Kanban, Jira, Autosys etc.

EXPERIENCE:

1. Telecommunication sector:

Writing SQL queries and mining databases to get target data
Microsoft R, Python for data mining, cleaning and data modeling
Analysing customer data and creating visualization reports with MS Excel, 
Providing KPI and performance indicators analysis to management in MS Power Point
Customer segmentation and analysis to issue new products
Building models in Excel to automatically pull data, analyse and provide visualized results
Regular reports on major KPIs
Customer churn analysis and CRM
Provide analysis on product, service and solutions
Conduct market research and competitor analysis.

2. Retail Banking sector

Daily, weekly, monthly reporting, visualization and data analysis
Usind Excel and Power BI for data modeling and data visualization
SQL Querying and creating data models in conceptional and logical phase using star model
Create relantionships (one to one, one to many) between tables, provide dimension and fact tables for reporting
Building several business models to calculate KPIs and metrics
Calculating the year-end forecast according to monthly sales of Branches.
Analysis of business effectiveness, financial analysis, average service time, average waiting time
based on data of electronic turnover system in branches
Business process and Labor demand analytics - built FTE calculation model in Excel
Mostly used tool(s): Excel (advanced), SQL, Power BI.
I am looking for a company where I can apply my experience
and improve my data analytics skills.