Puneet Bhullar
Business Analyst
Etobicoke,Ontario
Summary
Results-oriented Business Analyst with over a decade of experience in driving business process improvements, facilitating effective communication between stakeholders, and delivering strategic insights for informed decision-making. Proven expertise in requirements gathering, data analysis, and implementing technology solutions to optimize operational efficiency. Adept at collaborating with cross-functional teams and leveraging a comprehensive skill set to contribute to the success of diverse projects. Strong analytical and problem-solving skills coupled with a track record of delivering impactful solutions in dynamic business environments.
Overview
11
11
years of professional experience
2
2
years of post-secondary education
Work History
Senior Sales and Costing Analyst
Maple Lodge Farms
Brampton
02.2023 - Current
- Identified opportunities and analyzed marketplace key performance indicators to diversify campaigns, expand visibility, and improve performance.
- Collaborated cross-functionally with Sales and Marketing teams, translating business needs into actionable insights and data-driven solutions.
- Leveraged comprehensive financial knowledge to drive strategic decision-making, offering valuable insights into customer programs and pricing dynamics.
- Conducted meticulous reviews of internal cost structures, ensuring accurate capture of costs and identifying opportunities for cost optimization.
- Applied a proactive analytical approach to daily sales reports, identifying trends and discrepancies to inform strategic adjustments.
- Orchestrated the timely distribution of comprehensive sales reports, supporting key stakeholders in making informed decisions.
- Played a pivotal role in the preparation and analysis of monthly production variances, offering insights into factors affecting prices and profitability.
- Contributed actively to the interim and annual audit processes, ensuring compliance with financial standards and recommending process improvements.
- Led plant trials and conducted yield studies, providing data-driven recommendations for standard cost changes.
Master Data Analyst
Give And Go Prepared Foods
Etobicoke
05.2020 - 02.2023
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.
- Delivered strategic BI and reporting solutions to top executives, collaborating across functions to meet diverse business needs.
- Partnered with stakeholders, directors, and executives to gather requirements, identifying opportunities for process improvement and presenting actionable plans.
- Developed and updated visual dashboards and reports in Power BI, aligning with business requirements to analyze product pricing, cost changes, promotions, and margins.
- Utilized SQL for data extraction, identifying improvement opportunities, anticipating challenges, and implementing corrective actions.
- Provided comprehensive solutions and ongoing support to various departments, addressing business inquiries and technical issues promptly.
- Conducted training sessions on Power BI data modeling, promoting best practices in data analysis and visualization across the organization.
- Successfully managed multiple projects concurrently using MS Project, ensuring progress tracking and meeting deadlines.
- Utilized SharePoint to centralize data, fostering collaboration, consolidation, and customization of data and document management.
- Led and coordinated data validation, quality assurance, and user interface verification activities related to data extraction.
- Managed master data requirements for connected systems, ensuring accuracy and adherence to required formats in NAV.
- Effectively communicated data needs with field offices and project teams, providing clear functional specifications.
- Created and maintained the business application item master, Bill of Materials (BOM), and Routings.
- Prepared, updated, and maintained Standard Operating Procedure (SOP) documentation, contributing to the seamless operation of the organization.
Data Analyst
National Concrete Accessories
Etobicoke
08.2017 - 05.2020
- Produced monthly reports using advanced Excel spreadsheet functions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Provided comprehensive reporting and analytics solutions to branches across Canada, compiling effective monthly financial reports with analysis, commentary, and visuals.
- Analyzed business metrics data from multiple sources, providing EBITDA insights to the senior and executive board management team.
- Identified market trends to increase profits and explored new business opportunities.
- Liaised between Finance, Sales, Purchasing, and other departments, ensuring seamless integrations for future enhancements.
- Successfully executed the migration of ERP systems, including Great Plains, Evolution 360, and QuickBooks, to Microsoft Dynamics NAV.
- Utilized MS Dynamics NAV for daily reporting and analytics, managing database import/export operations.
- Developed, built, and manipulated reports using various business tools such as MS Power BI, SharePoint, MS Jet Reports, and MS Access on a daily/weekly/monthly basis.
- Designed and developed intuitive dashboards using Tableau/Power BI, translating data insights into actionable business decisions.
- Utilized SQL for data extraction and presentation in MS Excel and Tableau/Power BI.
- Created ETL workflows and data models using flowcharts, contributing to efficient data processing.
- Took responsibility for data management, including updates, additions, and revisions of supplier costs and customer resale data.
- Coordinated with management to prioritize business and information requirements.
- Supported continuous improvement of reporting systems and BI tools for financial and business unit managers company-wide.
- Maintained the integrity of weekly and monthly financial reporting processes.
Data Administrator
National Concrete Accessories
Etobicoke
05.2015 - 08.2017
- Created and implemented database designs and data models.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Tested programs and databases to identify issues and make necessary modifications.
Bookkeeper
Private Accounting And Tax Practices
Jalandhar
08.2012 - 08.2013
- Completed payroll for employees and maintained detailed records of procedures.
- Reviewed and filed financial documents, coded accounting entries for data processing, and posted daily receipts and payments in accordance with all corporate protocols.
- Maintained and processed invoices, deposits, and money logs.
- Established QuickBooks accounting system to reflect accurate financial records.
Education
College Diploma - Business Accounting
Centennial College
Scarborough, Ontario 09.2013 - 04.2015
Certificate in Power BI Fundamentals For End Users -
Global Knowledge
Mississauga, Ontario 04.2018 - 04.2018
Certified in Agile Methodology - Agile Project Management And Agile Delivery
Udemy Alumni
Online 05.2020 - 09.2020
The Business Intelligence Analyst Course - Statistic, Database Theory, SQL, Python, MI/AI
Udemy Alumni
Onilne 07.2020 - 12.2020
Skills
Business process mapping
Strategic planning
Data analysis
Pivot tables
Needs assessments
SQL and databases
Project Management
Business planning
Operations analysis
Data Mapping
Web-based reporting tools
Consulting
Microsoft Office Suite
Project finance
Predictive modeling
Product development
Technical Analysis
Technical Writing
Analytical and Critical Thinking
Problem-Solving
Organization and Time Management
Excellent Communication
Attention to Detail
Data Entry
Technical Support
Enterprise application integration
Data quality assurance processes
Activity diagrams
Use Cases
Data formatting
Data profiling
Data validation
Business needs analysis
Microsoft Visio
Financial and operational reporting
Strategic financial planning
Business Development
Industry analysis experience
Data trending
Dependable and Responsible
Customer Relationship Management
Data Collection
Project coordination
Document analysis
Teambuilding
Teamwork and Collaboration
Tableau/ Power BI
Quickbooks/ Cognos TM1/ Oracle Netsuite/ Evolution 360/ Sales force/ MS Navision (NAV)
Quantitative/Qualitative Analyses
Accomplishments
- Led the successful implementation of Microsoft Dynamics NAV across 18 branches , boosting productivity by 20-22%. Proactively analyzed project data, created SOPs, and ensured smooth transitions, earning company-wide recognition.
- Collaborated with the Financial Controller and Business Analyst to establish EFT processes , ensuring accurate data extraction, cleaning, and entry. Rigorously tested and managed timelines, logging hours for resource allocation, contributing to the project's seamless execution
- Led the transition to Manufacturing Business Unit Project, ensuring data cleanup and process improvement. Collaborated on data revision and integration using Jet reports for Microsoft Dynamics NAV.
Timeline
Senior Sales and Costing Analyst
Maple Lodge Farms
02.2023 - Current
The Business Intelligence Analyst Course - Statistic, Database Theory, SQL, Python, MI/AI
Udemy Alumni
07.2020 - 12.2020
Master Data Analyst
Give And Go Prepared Foods
05.2020 - 02.2023
Certified in Agile Methodology - Agile Project Management And Agile Delivery
Udemy Alumni
05.2020 - 09.2020
Certificate in Power BI Fundamentals For End Users -
Global Knowledge
04.2018 - 04.2018
Data Analyst
National Concrete Accessories
08.2017 - 05.2020
Data Administrator
National Concrete Accessories
05.2015 - 08.2017
College Diploma - Business Accounting
Centennial College
09.2013 - 04.2015
Bookkeeper
Private Accounting And Tax Practices
08.2012 - 08.2013