Apoorv K.

Experienced Data professional with experience in Data Analysis, reporting and business intelligence

Pune , India

Experience: 3 Years

Apoorv

Pune , India

Experienced Data professional with experience in Data Analysis, reporting and business intelligence

19483.9 USD / Year

Notice Period: Days

3 Years

Now you can Instantly Chat with Apoorv!

Chat Now

About Me

I am working into providing value insights and business reports to the clients and organizations I worked for showing the trends in their operational and transactional behaviour. I am also a part of the development team of 2 amazing products provi...

The tools I have worked upon are Power BI, Python, SSRS, SSRS, MSBI stack, Tableau, MS-Excel, Lucid Charts.

My skills include Business Analysis, Data Analysis, Data Science, Business Intelligence, Machine Learning, Data Visualization, Reporting, Predictive and Descriptive insights, finding KPI's, Dashboardin, Risk Analysis, Decision supporting analysis, Product management and Scrum.

Skills

Portfolio Projects

Description

Generated Analytical reports on Power BI based upon the data generated through synthetic tests
Developed Wireframes, Requirements and Use case diagrams for User Interface design
Prepared PRD, Use case, UI, product planning, network analysis and security related requirement documents and aligned them with the roadmap to achieve business objectives and presented to the stakeholders, higher management and Beta client
Designed Symantec layer on SSAS cube to integrate the product with Behavior Analytics tool
Designed Machine Learning Algorithm to integrate with the product to indicate the factors affecting call quality the most

Show More Show Less

Description

Designed a Symantec layer between Data Warehouse and Visualization platform i.e. Power BI on SSAS cube.
Developed descriptive Visualizations on Power BI to provide effective insights from the collected data
Developed Linear Regression model on Python to predict the utilization probability based upon historical data and presented the insights on Power BI by describing the coefficient matrix
Developed and automated paginated reports on SQL Server Reporting Services (SSRS) tool to integrate on demand report functionality with the product
Performed unit testing and fixed the bugs from database side and Power BI side as well using queries on SQL server management studio

Show More Show Less

Description

Requirement was to analyze whether the client needs to focus more on the website or the application.
Explored data and extracted correlated data sets to operate upon, using Python.
Generated a coefficient report to analyze the effect of various factors on the total spending and pricing of products using Linear regression model.
Made presentable dashboard out of the generated data over Power BI to showcase the cost optimization details to client
Worked upon the project end to end starting from requirement gathering and understanding to data cleaning, developing model and presenting the insights on the dashboards to the client
Client was curious about getting a generalized report, of chances of an advertisement to be clicked by Internet users.
Developed SSRS reports to present the area wise impact of advertisements to the client.
Built a classification model using Logistic regression on Python by analyzing an advertising data set, by splitting the data into train and test.
Created Power BI reports to showcase the exploratory analysis of the factors influencing the users to click on a specific advertisement.