Pradeep Kumar - MData Finnovatics Excel, VBA, and Power BI Experts
18 Reviews

Thanks for reaching out to my profile. 🙏

We are 💥💥💥 MICROSOFT OFFICE SPECIALIST CERTIFIED EXPERTS 💥💥💥.

We possess in-depth knowledge of Business Intelligence, Data Automation, and Data Analytics.

We collaborate with businesses and individuals to simplify their processes and make their jobs easier. We collaborate closely with top management to assist them in delivering dashboards for decision-making. Assist clients by providing consulting on work-related issues.

Why are we the best?
✔ 11+ years of extensive industry experience
✔ 800+ completed projects
✔ 40+ country client base
✔ 100% client’s satisfaction
✔ 99% of projects delivered in 2 days.

💥💥💥 FREE 3 Months Maintenance 💥💥💥

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

To get started right away, simply contact us; we will listen to your concerns, investigate your options, and provide you with the best solution possible.

Subjects

  • Microsoft Excel Beginner-Expert

  • Excel Beginner-Expert

  • Power BI Beginner-Expert

  • Data analysis Beginner-Expert

  • Financial Modeling Beginner-Expert

  • Advanced Excel (With formula and macro) Beginner-Expert

  • VBA & Macro Beginner-Expert

  • Power BI dashboard Beginner-Expert

  • Microsoft Power BI Expert

  • VBA automation Expert

Experience

  • Senior Data Analytics Consultant & Corporate Trainer (Jul, 2018–Present) at MData Finnovatics, Delhi NCR
     We have done ample of projects with multiple clients (Onshore and Offshore).
     Collaborate with management and subject matter experts to identify their challenges and accordingly assist them in providing the corporate trainings(Advanced Excel, VBA-Macros, Data Visualization - Excel, Power BI, Tableau).
     Work closely with companies to automate their processes to make their work easy.
     Work closely with top management to assist them in providing Dashborads for their decision making.
     Assist my clients to provide them consulting related to data related issues.
  • Senior Data Analyst (Dec, 2013–Jun, 2018) at aon hewitt
     Experience including analysis, modeling, design and development of Tableau reports and Dashboards for analytics and reporting applications.
     Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, filters, Calculated fields, Sets, Groups, Parameters etc. in Tableau.
     Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
     Acquire data from primary and secondary sources and maintain databases.
     Experience in Big Data Analytics with hands on experience in Data Extraction, Data Analytics, Data Loading, Data Visualization.
     Manupulating, Cleaning & processing the primary and secondary data using Advanced Excel, VBA (Macros), Data Science- R and SQL.
     Data Management using Microsoft SQL – Tables, Queries, Stored Procedures, Functions, Views, etc.
     Data Mining - Filter and clean the raw data to get the relevant information out of big data.
     Preparing project setups of the companies as per client’s usage and requirements in the organization and also responsible for MIS reporting by using MS Excel and VBA.
     Meeting with different key users to determine system and reporting requirements.
     Developed many software modules that are used to convert raw data into reports and Automate regular reports and generate custom reports as needed.
     Prepare different trackers like Production tracker, In-Progress report, Variance report, Leave Planner and Seat Utilization report through VBA.
     Deliver projects by maintaining quick TAT and highest quality standards execute it in MS Excel and MS SQL.
     Managing and design Monthly, Weekly Dashboards & Daily Report Creating in MS-Excel, PowerBI and Tableau through analysis and producing the actionable information.
     Extensive usage of VBA (Aggregate functions, Lookup, Pivot table, Macros).
     Develop strong working relationships with the business and other technology team members to deliver high quality technology solutions.
     Work on Financial & Compensation and Database environments – MS SQL Server and Share Point.
     Experience in R Programming Language, Data extraction, Data Cleaning, Data Loading, Data Transformation, Predictive Modeling and Data Visualization using R, PowerBI and Tableau.
  • Associate (Oct, 2011–Dec, 2013) at Tata Consultancy Services, Gurgaon
     Perform analytical review of financial operations of the process; interpret financial data and project the financial probability of process; ensure timely presentation of financial information.
     Working knowledge of Master Feeder Strategy (Hedge Fund Structure).
     Calculate Gross Asset Value and Net Asset Value of different individual funds as well as of Funds of Funds (FOF).
     Prepare final working papers which include Trial Balance, Balance Sheet, Dividends, Accruals and Appraisals.
     P/L reconciliation with trial balance and find variance with the estimated P/L.
     Responsible for maintaining and ensuring completeness of process work papers and related documentations.
     Making all the new updates in the Processing Documents and reviewing them simultaneously which help in processing the job effectively and efficiently.
     Use Bloomberg for generating security setup in Geneva/ Getting historical Price of securities/Checking Corporate Actions/Obtaining Exchange rate/Acquiring information on futures and options.

Education

  • Microsoft Office Specialist Excel 2016 Expert (Apr, 2019–Apr, 2019) from Microsoft
  • BBA CAM (Aug, 2009–Jul, 2011) from Mahrishi Dayanand University,Rohtak–scored 1st

Fee details

    ₹1,000–2,500/hour (US$11.88–29.71/hour)

    These are tentative pricing details. The amount will be finalized once the course contents are decided.

18 Reviews
4.9 out of 5

User Photo February 27, 2023
Payment verified US$ 130

Excel

On time and clean work.

User Photo November 29, 2021
Payment verified US$ 10

Formula help

V quick response and very knowledgeable with Excel

User Photo November 19, 2021
Payment verified US$ 89.14 (7500 INR)

Awesome Tutor who understands your requirments

I would highly recommend Pradeep for an assignment that anybody needs help with. He is methodical and explains well.

User Photo April 21, 2021

Expands very quickly :)

He understood my current issues very well, proposed a solution on Power BI, and Pradeep has high-quality skills regarding data visualizations. Additionally, he assists you with everything you require in a matter of moments and is extremely and kind. Thanks a lot, Pradeep.

User Photo April 18, 2021

Logical and Practical Learning

Excellent tutoring with practical use case which is beneficial for day to day work. Regular practice file sent and briefly recap in each lesson. Lessons fits best for someone who has never worked on Excel as well as anyone who would like to brush up excel skill.

User Photo March 29, 2021

Quick

Very helpful and can get things done quickly and efficiently

User Photo February 14, 2021

Fast and efficient

Excellent quality and efficient (quick) work by Pradeep. Really skilled and without too much guidance. Many thanks, Paul.

User Photo December 8, 2020

Excellent Trainer

Trainer was quick in understanding the current issues I was facing with my advanced excel knowledge, helped to resolve them and proposed what needs to be done and how to achieve.

User Photo December 7, 2020

Good service, Good results and nice communication

Very helpful with the scraping of data from multiple websites

User Photo December 2, 2020

Very understanding

I needed help with an assignment that I didn’t even have all the information for and he still helped and delivered based only on the context that was given. He’s super understanding and knows his stuff!

User Photo October 15, 2020

perfect!!!

amazing tutor

User Photo October 15, 2020

Best tutor

I got A with his help

User Photo October 14, 2020

Great help

He’s a good helper ain’t very cheap. He help you with everything you need in moments he’s very generous and kind.

User Photo September 24, 2020

Good tutor

He can help you

User Photo April 28, 2020

Really smart and great tutor

was really helpful and helped me throughout my course!

User Photo April 9, 2020

Best Teacher for Advanced Excel and PowerBI

Pradeep Sir is expert in Advanced Excel and PowerBI. I have learned both the courses and got the job successfully. I was trying to switch my job into a better job but due to lack of knowledge, I couldn't. After completed the course successfully, I changed my job finally. Thank you Pradeep Sir and I would recommend whoever wants to learn Advanced Excel or PowerBI must contact Pradeep Sir.

User Photo April 8, 2020

Great Tutor

Pradeep was a very good tutor. We were skeptical at first, since we are in USA, but he was very flexible, responsive to all of our texts, and most importantly gave great lessons that were very interactive. We will definitely be using him for more courses.

User Photo March 29, 2020

Excellent teacher with great knowledges and skill

before being taught by him I was noob or mostly confused on excel and data analysis. but sir not only make my doubt clear but also build my understanding from zero to professional level. Best Online tutor for advance excel and data analysis online.