Rakesh Gujja
Business Intelligence Analyst at MEP STOCK LIMITED- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
0
/5.0 / Based on 0 ratingsFilter reviews by:
Experience
-
MEP STOCK LIMITED
-
Consumer Electronics
-
1 - 100 Employee
-
Business Intelligence Analyst
-
Sep 2021 - Present
• Processed various types of CSV, Text, JSON using Python scripts for the process. • Developed and deployed scripts to handle daily sales and customer reports. • Worked on historical data like cleaning and analysing relationships between each data. • Created a report on the basis historical data analysis that helped the stakeholders to improve their market strategy. • Created automated interactive report that shows total sales, sales by region, total profit, profit by period of time and loses • Helped the stakeholders while making decisions by providing historical data analysis inputs. • Calculating profit & loss (PnL) and total transactional report (TTR) using sales data. • Automate the existing jobs to reduce the manual jobs.
-
-
-
sparknode analytics
-
Marketing Services
-
1 - 100 Employee
-
Data Analyst
-
Jan 2019 - Jul 2020
• Built the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Microsoft Azure ‘big data’ technologies. • Built analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics. • Worked with stakeholders to assist with data-related technical issues and support their data infrastructure needs. • Produced attractive visuals/dashboards to convey the story inside the data and writing the reports of the data insights. • Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. • Delivering the data in a useful and appealing way to the clients • Delivered updates to stakeholders based on analytics. • Built CI/CD pipeline with tools like Azure DevOps
-
-
-
Sparkynode analytics
-
Information Services
-
1 - 100 Employee
-
junior Data Analyst
-
Aug 2017 - Jan 2019
• Collecting data from different departments like sale Department, logistics and marketing etc. • Attending stand up meetings with senior data analyst. • Used to work with cloud based data like SQL , writing SQL queries, manipulating data as per requirement • Used work with large excel sheets. • Helping the senior data analyst in data cleaning and data analysis. • Used to get involved in data Visualization • Collecting data from different departments like sale Department, logistics and marketing etc. • Attending stand up meetings with senior data analyst. • Used to work with cloud based data like SQL , writing SQL queries, manipulating data as per requirement • Used work with large excel sheets. • Helping the senior data analyst in data cleaning and data analysis. • Used to get involved in data Visualization
-
-
Education
-
University of East London
Msc computer science, Information Technology -
Jawaharlal Nehru Technological University
Bachelor of Technology - BTech, First Class