Ravi Ranjan Sharma Sr Data Analyst (VBA Expert, Power BI, Python)
1 Review

1. Microsoft Certified | DA-100 Data Analyst Associate in Power BI and with more than 7 years of experience in Advance Excel, VBA, Power BI, Apps Script, SQL, and Python - Pandas
2. I teach students from scratch in a very simple way so that students can grab it easily.
3. My hobby is teaching and working on new projects which makes me a great teacher and developer.
4. MBA in finance and delivering valuable insight via data analytics and advanced data-driven methods.
5. Make a Dashboard in Power BI and in Excel using VBA.
6. Created customized reports with data visualization and variable analysis for US-based clients.
7. Identifying the client’s business requirements and advising on suitable analytical strategies using DAX Function, Advance Excel, VBA, Power Pivot, Data Manipulation & Analysis, Analytics, MS Office, MS PowerPoint, and SQL.

What can do?
◼ Advanced Excel
◼ VBA (Macros) Automation
◼ Create Power BI Dashboard/ Visualization
◼ Advanced Excel Corporate Training
◼ Create Excel Dashboard
◼ Data Analytics

Subjects

  • Power BI dashboard Beginner-Intermediate

  • Basic & Advanced Excel Intermediate-Expert

  • Excel VBA Beginner-Expert

Experience

  • VBA & Power BI Developer (Oct, 2020–Present) at Actiknow Consulting Pvt Ltd.
     Created customized reports with data visualization and variable analysis for US-based clients.
     Worked with ongoing project domains like-Sales and budget forecast, Pricing Calculation, Retirement Analysis, Banking Survey Analysis, etc.
     Verifies the accuracy and performance of all code developed, including the preparation of test data and the execution of the program.
     Identifying the client’s business requirements and advising on suitable analytical strategies using DAX Function, Advance Excel, VBA, Power Pivot, Data Manipulation & Analysis, Analytics, MS Office, MS PowerPoint, SQL.
     Hands-on development and support activities for complex Power BI, Excel-VBA, and SQL solutions.
     Developed test cases based on test matrix including test data preparation for data completeness, data transformations, data quality, performance, and scalability.
     Developed Power BI reports and dashboards from multiple data sources using data blending.
     Developed SQL queries to validate the data such as checking duplicates, null values, truncated values and insuring correct data aggregations.
     Explored data in a variety of ways and across multiple visualizations using Power BI. Strategic expertise in the design of experiments, data collection, analysis and visualization.
     Involved in troubleshooting, resolving and escalating data-related issues and validating data to improve data quality.
     Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, Pie, bar and density charts.
  • Financial Data Analyst (Oct, 2018–Jul, 2020) at Amazon Seller Delhi
     Created customized reports for data visualization and variable analysis of e-commerce companies.
     Using VBA & Python- Pandas to clean and analyze large data sets.
     Responsible for data collection, transforming raw data into MySQL with custom-made applications.
     Preparation of outstanding reports & coordination with clients from multiple courier companies.
  • MIS Coordinator (Sep, 2016–Oct, 2018) at Aakash Educational Services Pvt. Ltd.
     Make Dashboard, Using Macros & VBA Coding, Pivot Tables, and Graphs.
     Generate Reports (MIS & Others as Requested- Weekly/ Monthly/ EOD Reports)
     Team handling, Generate Payment Voucher & Online Payments follow-up.
     JIRA software for ticketing, Taking care of banking-related activities, Preparation of outstanding reports, etc.

Education

  • DA-100 (Jan, 2021–Sep, 2021) from MICROSOFT CERTIFIED PROFESSIONAL DEVELOPER–scored 800
  • MBA (Finance) (Apr, 2011–Mar, 2014) from Vinayaka Missions University, Salem–scored 1st Div

Fee details

    ₹300–800/hour (US$3.59–9.59/hour)

    Depends on efforts, courses & tools

1 Review
5 out of 5

User Photo January 18, 2023
Payment verified US$ 31

Expert in VBA

The tutor is a specialist in VBA and very friendly. Absolute recommendation.