Sumit Barua
MUMBAI,MAHARASHTRA
Summary
Business Intelligence Consultant with 4 years of experience, including 2 years in BI. Expert in QlikView, Qlik Sense, and data visualization. Seeking to excel as a Qlik Developer by delivering impactful solutions and driving operational efficiency.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Business Intelligence Consultant
IRT Digital Analytics Solution
07.2023 - 04.2024
- Implemented best practices, reducing reporting errors by 25% and boosting stakeholder trust
- Automated data processes, improving operational efficiency by 25%
- Enabled data-driven strategies, improving resource allocation accuracy by 15%
- Extracted and transformed data for Qlik Sense and Power BI from various sources
- Increased dashboard adoption by 30% with intuitive designs
- Aligned data models with business needs, improving performance
- Integrated multi-source data for seamless operations.
Data analyst Intern
Abhyaz
01.2023 - 04.2023
- Developed Quarterly and Monthly performance report dashboards, reducing manual effort by 30%
- Maintained Accounts dashboard, reducing turnaround times by 30% and enhancing accuracy
- Established Sales pipeline dashboard for real-time visibility, improving sales performance
- Managed Weekly Subscription dashboards, providing insights for product success and increasing subscription length
- Conducted data cleaning and validation, ensuring robust data management and accurate analysis
- Monitored data uploads, ensuring successful import and maintaining data quality
- Generated ad-hoc reports to meet specific business requirements.
Associate Software Developer
Mphasis
11.2019 - 09.2022
- Used to support client’s requirements as per business needs
- As per the ticket raised used to update and delete the records using SQL
- Maintained SP code for cron, which was sent weekly to the vertical manager
- Create and maintain Masterpolicy and premium in the Suitecrm module; our client was ABHI (Aditya Birla Health Insurance)
- Recipient of three prestigious customer-centricity awards in recognition of exceptional dedication to delivering outstanding customer experiences.
Data analyst Intern
Phootoshooto
10.2021 - 12.2021
- Identified, analyzed, and interpreted trends or patterns in complex data sets by finding correlations and visualizing them with charts
- Demonstrated a consistent monthly increase of 10% in Photography style in Tier-1 Cities
- Developed Tableau and Power Bi dashboards for weekly reporting and project planning using the AIMS Grid process
- Empowered team decision-making by providing insights on market demand and monthly orders for 'Wedding Style Photography'.
Project Intern
Larsen & Toubro Reality
07.2017 - 07.2017
- As an Project Intern, my duty was to analyze the data,finding error and provide solution
- Responsible for communicating the insights to the customer during customer meet and help them understand the technical solution
- Trying to improvise the solutions by team member.
Education
Bachelor of Engineering (B.E.) - Electronics -
Shree L.R Tiwari College of Engineering, MUMBAI
H.S.C - Science -
St Peters junior college of Science, commerce and arts, VASAI
S.S.C -
Holy Family Convent High School, VASAI
Skills
- Data Visualization: QlikSense, Tableau, Power BI, Excel, Zoho Analytics
- Databases: MySQL, MSSQL
- Tools: MS Office, Suite CRM
- Soft Skills: Critical Thinking, Presentation, Communication
- Data dashboard design
- Python Programming
Certification
- Web Development Course by Geeta Technical Institute, 02/08/2019 - 10/09/2019
- Python for beginners and intermediate - Codebasics
- Data Analytics and visualization virtual experience - Accenture
- Fundamental and visualizations with Tableau - UC Davis
- Microsoft Power Bi Desktop for business intelligence - Udemy
Languages
English
Marathi
Hindi
Bengali
Awards
- Exam - TestDome, Passes Public Test and rank upto top 25% which is conducted by TestDome
- Exam - Mphasis, Scored 80% in SQL Server Development Test.
- Intern of the Week - Phootoshooto, Won ‘Intern of the Week’ from Photoshoot as a Data analyst.
- Customer Centricity Award - Mphasis, Excellent communication and soft skills due to which, I Won 3 times Customer Centricity appreciation cards to identify, address, and offer relevant solutions to the stakeholder.
Projects
Executive Sales Dashboard, Tableau, Consumer Goods, Developed interactive sales dashboard using Tableau and MySQL for ATLIQTECHNOLOGY., Imported and managed sales data in MySQL database., Designed and developed visualizations using Tableau Desktop., Incorporated key metrics (total sales, revenue, profit, top-selling products, regional sales) for valuable insights., Enhanced data exploration and decision-making with interactive filters and parameters., Published dashboard on Tableau Public for easy access and sharing of visualizations. Medical Data Extraction, Python, pytesseract, OpenCV, Regular expressions, FastAPI, Built a document extraction backend that helped automate data capture process for AtliQ Insurance that saved them 50k $ annually., Python backend was built using pytesseract, OpenCV, Regular expressions and FastAPI as a web-serving framework., Auto-extracted important fields from patient details and medical prescriptions., Image processing was performed in OpenCV and then pytesseract was used for the image-to-text conversion., The last step was to use Regular Expression (Regex) for extracting important fields from the text.
Timeline
Business Intelligence Consultant
IRT Digital Analytics Solution
07.2023 - 04.2024
Data analyst Intern
Abhyaz
01.2023 - 04.2023
Data analyst Intern
Phootoshooto
10.2021 - 12.2021
Associate Software Developer
Mphasis
11.2019 - 09.2022
Project Intern
Larsen & Toubro Reality
07.2017 - 07.2017
Bachelor of Engineering (B.E.) - Electronics -
Shree L.R Tiwari College of Engineering, MUMBAI
H.S.C - Science -
St Peters junior college of Science, commerce and arts, VASAI
S.S.C -
Holy Family Convent High School, VASAI
Similar Profiles
Alisha SinghAlisha Singh
Senior Human Resources Manager at IRT Digital Analytics System Pvt LtdSenior Human Resources Manager at IRT Digital Analytics System Pvt Ltd
Miloni ParekhMiloni Parekh
BI Consultant at IRT Digital Analytics SolutionsBI Consultant at IRT Digital Analytics Solutions
Sneha UgaleSneha Ugale
IT Process Analyst – Office 365 Admin & Asset/Inve at Digital Track Solution – Client: Tata DigitalIT Process Analyst – Office 365 Admin & Asset/Inve at Digital Track Solution – Client: Tata Digital
Vinayak ShindeVinayak Shinde
Manager - Global Fin & FPNA at Sutherland Global Services Pvt Ltd.Manager - Global Fin & FPNA at Sutherland Global Services Pvt Ltd.
Varun AroraVarun Arora
Assistant General Manager- Brand Strategy & Media at JSW SteelAssistant General Manager- Brand Strategy & Media at JSW Steel