نبذة عني
Data Analyst with 2+ years’ experience for interpreting and analyzing data in order to drive successful business solution. Proficient knowledge in SQL, Tableau and Python. Excellent understanding of business operation an…
Data Analyst with 2+ years’ experience for interpreting and analyzing data in order to drive successful business solution. Proficient knowledge in SQL, Tableau and Python. Excellent understanding of business operation and analytics tools for effective analysis of data.
الخبرة
Data Analyst
Conduct, business intelligence gathering, trending and benchmarking, Data analytics supports decisions for high-priority, enterprise initiatives involving IT/product development.
Extensively responsible for writing SQL queries for data analysis and data cleaning.
Design and development of dashboards for report utilization.
Worked as Data Analyst and Tableau & SQL Developer in IT organizations.
Scheduling updates of the Tableau dashboards on the Tableau server.
Build, customize and publish interactive reports, dashboards & visualizations using Tableau.
Have excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all level and work as a part of a team as well as independently.
Imported Data from various sources such as RDBMS, Apache Hive (Big Data), Flat File (CSV, Excel).
Implement marketing ROI tracking system using Nolan chart, Coxcomb chart, shaped divided donut chart, arrow donut chart etc.
Responsible for documentation to make sure in future that there wouldn’t be any issues to understand reports.
Implement KPI, dual axis, filters and various calculations.
Presenting reports and suggesting actions on impact of data.
Obtaining store level data with regard to sales for weekly and monthly titles for selected wholesalers.
Developed dashboards using Custom SQL queries, and various data sources using data blending techniques for report decimation.
Identifying methods and process on improving operations efficiencies.
Responsible for creating Pricing waterfall and trade framework using Gantt charts and dual axis etc.
Extensively involved in identifying metrics needed for model prioritized across Products, Channels and Categories.
Created Dashboard for margin analysis, profitability analysis and price per segment analysis using LODs & various calculation etc.
Created Dashboard for indicating various KPI (Key Performance Indicators) such as Common List Price for each product category, Product Level intact analysis, Customer Segmentation against Weighted Average Price, etc.
Used custom SQL query on tableau for obtaining metrics matching result.
Responsible for building Interactive dashboard.
Extracted Data from heterogeneous sources such as RDBMS, Apache Hive (Big Data), Flat File (CSV, Excel).
Key topics are visible and trending topics can be assessed by product category, channel or market.
Responsible for using drill down voice level and Omni channel retailer.
Responsible for building Interactive dashboard.
Responsible for using custom SQL query on tableau.
Redeveloped Tableau reports over to a new reporting environment build on Tableau.
Performing data validation, data blending, and use of SQL queries.
Use of filters, transformations, calculated fields, LODs, sets, groups and parameters.
Providing drill down functionality to all the maps, charts and other visualizations as well as making them interactive and applying filters across worksheets.
Design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar-Graphs, and Pie-Charts.
Creating story boards to deliver a complete picture of the status of business and compelling dashboards for actionable insights in Power Bi.
Publishing dashboards on the server, creating packaged workbooks.
Worked on different databases like Redshift, Teradata, PostgreSQL etc.
Knowledge of Data Warehousing concepts.
Imported data from Oracle 12c database and flat files.
Responsible for extracting, loading validation of client data using Tableau.
Created Dashboard for customer segmentation analysis.
Created reports on expenditure for different types of customers.
Developed weekly, monthly, and quarterly reports for sales comparison.
Developed dashboard for analysis of sales across various credit card type.
Sales comparison across various credit card types with overall sales, store wise.
Data Analyst
Data Analyst with 2+ years’ experience for interpreting and analyzing data in order to drive successful business
solution.
Proficient knowledge in SQL, Tableau and Python. Excellent understanding of business operation and analytics tools
for effective analysis of data.