Hariom Singh

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills. Dedicated and hard-working with passion for Big Data.

Sales Insights – Brick & motor business [Power BI | SQL]

• Designed a Power BI dashboard to understand AtliQ hardware goods sales trend.
• The final dashboard was effective at displaying the sales trend of AtliQ hardware, allowing users to understand the data and make informed decisions.
• This dashboard could help in increasing the revenue at least by 7% in the next quarter.

T20 world cup cricket data analytics – Cricket Analysis [Python | Web scrapping | Pandas | Power BI] 

• Created a Power BI report to identify top 11 players for a T20 cricket team by scraping data from espncricinfo with a Brightdata website tool, cleaning and transforming the data with pandas, and evaluating various player performance metrics.
• Used the resulting Power BI dashboard to select players for various categories (openers, middle order/anchors, finishers, all-rounders, specialist fast bowlers) and ultimately choose the top 11 players to play in the match.
• Selected team using the Power BI dashboard has 90% of chances to win the game.

HR Data analytics – HR Domain [Power BI | Excel] 

• Designed a Power BI dashboard to track employee data for the HR team, including working hours, attendance, performance, and leaves. The dashboard streamlined HR processes and increased efficiency.
• This Dashboard can save 3-4hrs of work for the HR daily.

Business 360 - Brick & motor and e-commerce [Power BI | SQL | Excel | Dax Studio] 

• Built a Power BI dashboard to analyze AtliQ hardware's sales trends over the globe by gathering data from Excel/CSV files and a SQL database, creating a data model and visualizations in Power BI, and optimizing the report with DAX studio.
• The dashboard helped AtliQ hardware understand different department's sales trends and make data-driven decisions.
• This project could increase the revenue by 10% and reduce data related expenses by 20%.

IBM Data Science Professional Certificate - IBM.