Saraswat Mukherjee

Highly skilled and motivated IT engineer with 3.5+ years of experience in Power BI and advanced Excel. Proficient in data analysis, I have successfully contributed in generating dashboards and reports by data analysis through Power BI & advanced excel. Have excelled in collaborating with cross-functional teams to deliver innovative solutions that meet business requirements.

Adept at Power BI frameworks and libraries, leveraging object-oriented principles and design patterns to develop efficient software applications. Also proficient in advanced Excel for creation of complex formulas, macros, and visualizations for data processing and reporting processes. Can collaboratively work by effectively communicating with different stakeholders and gaining cognizance of project requirements to identify and resolve technical issues for ensuring smooth project execution.

IT Professional who can bring in a fresh and energetic approach with 2+ years of rich experience in Lupin Limited having worked as Data analysts involved in deriving inferences and insights from large data sets to help in generating sales for various products. Also worked as a Support Administrator in Goodricke Tea Private Limited for 13 months and as a Junior Engineer in Imax Solutions for 8 months.

Data analysts at Lupin Limited (2021-04 – 2023-01)

• Developed a comprehensive sales dashboard that provided real-time insights into sales performance, leading to a 10% increase in sales productivity.
• Received positive feedback from senior management for delivering actionable insights that contributed to strategic decision-making.
• Conducted in-depth analysis of business data to identify trends, patterns, and insights.
• Extracted data from various sources including databases, spreadsheets, and cloud services using Power BI Desktop.
• Transformed and cleaned raw data using Power Query Editor to ensure accuracy and consistency.
• Designed and developed interactive dashboards and reports using Power BI Desktop to visualize key performance indicators (KPIs) and metrics.
• Built and optimized data models in Power BI Desktop to support complex reporting requirements.
• Established relationships between different data tables and defined calculations using DAX (Data Analysis Expressions).
• Provided training and support to end-users on how to interpret and use Power BI reports effectively.
• Responsible for data extraction from SAP SD module, data validation and data cleansing using advanced excel procedures and creating and deriving insights out of sales data sets across regions.
• Creation of dashboards and deriving insights for creating budgetary plans for different products across regions

Junior Engineer at Imax Solutions (2020-06 – 2021-02)

• Extracted data from various sources including databases, spreadsheets using Power BI Desktop.
• Designed and developed interactive dashboards and reports using Power BI Desktop to visualize key performance indicators (KPIs) and metrics.
• Built and optimized data models in Power BI Desktop to support complex reporting requirements.
• Worked closely with cross-functional teams including business stakeholders, IT professionals, and data engineers to understand requirements and deliver solutions.
• Worked in HTML and CSS for creating web site for clients
• Used JavaScript to access and modify the content, styling and behavior of HTML elements on a web-page to dynamically update and generate content on websites

Support Administrator at Goodricke Tea Private Limited (2019-04 – 2020-05)

• Conducted in-depth analysis of business data to identify trends, patterns, and insights.
• Created a variety of visualizations such as bar charts, line charts, pie charts, maps, and gauges to effectively communicate data insights.
• Implemented best practices for data modeling to improve performance and scalability of reports and dashboards.
• Conducted regular meetings and presentations to share insights and findings derived from Power BI reports and dashboards.
• Actively participated in peer reviews and knowledge sharing sessions to exchange best practices and lessons learned.
• Implemented feedback from users to iterate and improve existing reports and dashboards for better usability and effectiveness.
• Streamlined reporting processes by migrating existing Excel-based reports to Power BI, resulting in significant time savings and improved data accuracy.
• Ensuring data entry, documentation, and record-keeping of organized data sets primarily involving inventory and sales data across zones and states and their easy retrieval.
• Providing recommendations and insights after thorough data analysis through advanced excel techniques for sales, distribution and inventory data sets

Bachelor of Technology in Computer Science and Engineering – Techno India College of Technology (2015 – 2019)

Diploma in Computer Science and Technology – Elite Polytechnic Institute (2011 – 2014)

Higher Secondary Certificate Examination – Kalyan Nagar Vidyapeeth for boys’ (2011)

Madhyamik Pariksha – Rani Rashmoni High School (2009)