Ravi Prakash Kumawat

Ravi Prakash Kumawat

An experienced data analyst having more than 7 years experience in IT industry and more than 2 years of experience in...
India

About Me

I am a passionate and a result oriented professional with over 7+ years of total experience in IT industry and more than 2 years of experience in interpreting and analyzing data thereby driving successful outcomes and bu…

Experience

Data Analyst

5ONE Analytics
Apr 2017 - Present · 9 years 3 months

Tableau certified data analyst having more than 2 years of experiences in data analysis.
My experience includes data analysis , data visualization,data exploration, data mining and web analysis.

Data - Analyst

5ONE Analytics, Gurgaon – Haryana
Apr 2017 - Present · 9 years 3 months

Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting.
Extract data from various data Sources like SQL, ORCLE and transformed the data into required format and loaded into the target (ETL).
Conceptualizing and developing reports, dashboards on Tableau.
Converting pre-existing Excel based reports to Tableau dashboards.
Gather information from various sources and interpret patterns and trends.
Accessing & transforming massive datasets through filtering, grouping, aggregation, & statistical calculation.
Deploying rich graphical visualizations in dashboards to create effective views of data.
Developed Tableau workbooks from multiple data sources using Data Blending.
Created & maintained SQL scripts, indexes, & queries for data analysis and extraction.
TOOLS USED: Excel, Tableau, SAS

DATA - ANALYST

5ONE ANALYTICS, GURGAON – HARYANA
Apr 2017 - Present · 9 years 3 months

Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting.
Extract data from various data Sources like SQL, ORCLE and transformed the data into required format and loaded into the target (ETL).
Conceptualizing and developing reports, dashboards on Tableau.
Converting pre-existing Excel based reports to Tableau dashboards.
Gather information from various sources and interpret patterns and trends.
Accessing & transforming massive datasets through filtering, grouping, aggregation, & statistical calculation.
Deploying rich graphical visualizations in dashboards to create effective views of data.
Developed Tableau workbooks from multiple data sources using Data Blending.
Created & maintained SQL scripts, indexes, & queries for data analysis and extraction.

Business & Quality Analyst

Freelancer
Apr 2016 - Mar 2017 · 11 months

Communicate with clients and gathering the requirements and requirement elicitation.
Conduct a meeting with development team to explain the scope.
Creating SRS, based on requirement gathered.
Creating BRD (Business requirement document) and FRD (Functional requirement document).

IT Admin

MG Career Park Jaipur
Jan 2015 - Mar 2016 · 1 year 2 months

Provide Technical support to Organizations technical and non technical activities.
Manage data on various Data Platforms like EXCEL and SQL.

Academic Head

Aptech Computer Education Jaipur
Jul 2013 - Jan 2015 · 1 year 6 months

Be responsible and accountable for setting and advancing the academic strategy of the Department in line with Faculty and University strategic plans and direction.

IT Trainer

Netcom College Sikar
Jul 2012 - Jun 2013 · 11 months

My responsibilities include providing support for the Engineering project, guiding new trainees.

BUSINESS & QUALITY ANALYST

FREELANCER
Apr 2016 - Mar 2017 · 11 months

Communicate with clients and gathering the requirements and requirement elicitation.
Conduct a meeting with development team to explain the scope.
Creating SRS, based on requirement gathered.
Creating BRD (Business requirement document) and FRD (Functional requirement document).

IT Admin

MG CAREER PARK JAIPUR
Jan 2015 - Mar 2016 · 1 year 2 months

Provide Technical support to Organizations technical and non technical activities.
Manage data on various Data Platforms like EXCEL and SQL.

Academic Head

APTECH COMPUTER EDUCATION JAIPUR
Jul 2013 - Jan 2015 · 1 year 6 months

Be responsible and accountable for setting and advancing the academic strategy of the Department in line with Faculty and University strategic plans and direction.

IT Trainer

NETCOM COLLEGE SIKAR
Jul 2012 - Jun 2013 · 11 months

My responsibilities include providing support for the Engineering project, guiding new trainees.

Skills

Integrated Business Intelligence Cascading Style Sheets (CSS) Data Evaluation HTML (Hyper Text Markup Language) Java Microsoft Excel MySQL PHP: Hypertext Preprocessor (PHP) QA Testing Quality Analysis Quality Management Statistical Analysis System (SAS) SAS Statistical Procedures Base SAS Programming SAS SQL C/C++/C# Core & Advance JAVA Core PHP HTML & JavaScript MS -MY SQL SDLC & STLC Manual Testing JIRA Project Development Tool Test Documentation Tableau Desktop Data Blending & Transformation Data Visualization & Business Intelligence Excel C++ C# JavaScript Tableau Data visualization Data blending Data transformation Tableau parameters Tableau table calculations Tableau sets Tableau groups SDLC STLC Agile Scrum Manual testing JIRA Test documentation SQL ETL
Report this Profile?