Pradeep Kumar Senior Data Analyst Consultant

Below are few reasons why you should join us :
1 - I have 8+ years of Industry experience which help me to judge what is beneficial for the students and how to train them in their field.
2 - I have cleared Microsoft Office Specialist Excel 2016 Expert exam which is cleared by very few population.
3 - I provide study material from our side, so that student can focus only on the training and no need to make lots of notes.
4 - I provide 99% based practical training because I believe in practical instead of theoretical study.
5 - I allow students to have separate Q&A sessions apart from training time, so that they have good time to clear their doubts.
6 - Any many more.....

We are running a Business Intelligence and Data Analytics Consulting firm where our industry experts team help organizations to manage or handle their data and also how to visualize the data in more meaningful way. We also provide Individual and Corporate training's where we train people to make them experts in their fields. Below are our Services :

1 - Corporate Training (Advanced Excel, VBA & Macros, Power BI, Tableau)
2 - Data Automation Projects
3 - Data Visualization / Dashboard Projects
4 - Website Development
5 - Mobile Application Development

Subjects

  • MIS (Beginner-Expert)

  • Microsoft Excel (Beginner-Expert)

  • VBA & Macro (Beginner-Expert)

  • Tableau Desktop (Beginner-Expert)

  • Power BI dashboard (Beginner-Expert)

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

  • SQL Server (Beginner-Expert)

  • Data Visualization (Beginner-Expert)

  • Data analysis (Beginner-Expert)

  • Excel (Beginner-Expert)

  • Automation Anywhere (Beginner-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

Fee details

    1,000-2,500/hour (US$13.99-34.97/hour)

    These are tentative pricing details. Amount will be finalized once course contents are decided.