Power BI, Tableau, Excel, Google Analytics, Python
MANISH SHARMA
BI Developer/Data Analyst
Westmead,NSW
Summary
Process Engineer with 11+ years of experience in Design and Improvement of Production, Business Processes and Quality Management Systems, Data Analytics and Research.
Specialize in improving process efficiency, compliance and business process maturity by using integration tools (IT/OT) and stakeholder engagement.
Overview
7
7
Certificates
7
7
years of post-secondary education
11
11
years of professional experience
Work History
System Design & Development Officer
Sydney Trains
Sydney, NSW
01.2022 - Current
- Mapped "AS-IS" and "TO-BE" processes in Operations area
- Recommended system integrations and process automations to improve efficiency and process maturity.
- Analyzed data using Power BI/Tableau and recommended actionable insights to improve staff rostering principles compliance and governance.
- Collected and addressed process pain points causing duplication.
- Re-designed and automated manual processes (Power Automate, MS Access, Sharepoint and MS Forms).
- Assisted in ISO 9001:2015 Gap Analysis
QA Supervisor
DuluxGroup
Sydney, NSW
09.2019 - 01.2022
- Implemented Lean Six Sigma and Continuous Improvement methodologies in Quality Management - Control Charts, Right First Time, Cycle-Time, Rework reduction and planning, Traceability and Risk Factor Index.
- Created new QMS using Sharepoint, Power Automate, MS Access, SAP GUI Automation.
- Analyzed Customer feedback, Production and Quality Data using Power BI, Tableau KNIME and Azure Data Warehouse (SQL).
- Implemented new technologies to improve quality and process efficiency - eg Rapid Microbe Testing, NIR Spectroscopy for quick moisture detection.
- Liaised with key stake holders in NPD projects.
- Manage QC team of 2 direct reporting and 20 indirect reportings on daily basis.
Operations Coordinator/Business Analyst
Materialised Pty Ltd
Sydney, NSW
09.2017 - 09.2019
- Business Analysis and Process Mapping - Process Re-design and new system integration (Digital Asset Management Tools, PRONTO ERP process re-engineering, Financial Claims Process/System Design, Office 2007 to 365 Migration)
- Created dashboards using Tableau Google Analytics MSBI services & Microsoft SQL.
- Analyzed Asset/Production/Inventory/Shipping/System costs, Demand Forecast, Marketing and New Product Cost, Customer Sentiments, Geographical Sales, Monthly P&L and provided recommendations to owners.
- Continuous Improvements using Lean Six Sigma methodologies and process revamping.
- Managed team of 9 Production and Warehouse personals on daily basis.
- Project Management of large-scale and critical projects (Over $100k in value)
- New Process Design and development of wallcoverings & roller-blinds drop-ship business.
Quality Assurance Officer
Graphics Packaging
Sydney, Sydney
11.2016 - 09.2017
- Supervising team of 5 quality Inspectors in day-to-day quality concerns.
- Documentation and Change Management of New Processes
- Quality Process standardization and rework planning.
- Systematic and priority based handling of customer complaints, root cause analysis and CAPA.
- Writing S&OPs for ISO 9001:2015, ensuring company compliance to HACCP, ISO 14000, GMP.
- Data analysis and creating Six Sigma Control Charts
- Conducted evaluations to identify weak areas and identify problematic issues while promoting corrective methods
Production and QC Supervisor
Omega Paints
Sydney, NSW
10.2015 - 12.2016
- Supervised team of 12 people in Warehouse, Production and QC.
- Improved product formulations for better throughput and performance
- Assisted in Development and Implementation of ERP (Net Suite and In-house VB Excel Program).
- Liaised with Vendors and Suppliers for raw material purchase.
- Ensuring business compliance to ISO 9001, ISO 14000 and WHS policies
- Mapped Business Processes for ERP Implementation - "AS-IS" and "TO-BE" states.
Sr. Research Officer
University of Sydney
Sydney, NSW
09.2012 - 08.2015
- Designed Processes for chemical industries (specialty chemicals, desalination plants, distillery, biogas and biodiesel plants, menthol extraction process,.
- Researched new processes and process integration opportunities for Carbon Capture in collaboration with CSIRO, Delta Electricity and Masdar Institute.
Sr Process Engineer
Synergy Process System
Pune, India, India
06.2014 - 06.2015
- Lead and Supervise team of 6 engineers,
- Developed Process Integration Business segment in firm.
- Conceptual Process Design, FEED and Equipment design for specialty chemicals, desalination plants, distillery, biogas and biodiesel plants, menthol extraction processes.
- Liaised with clients and vendors in mechanical design of equipments and costing
- Performed site visits and stakeholder management for pre and post plant commissioning.
- Published journal papers and delivering presentations to clients.
Process Engineer
Xtreme Engineering
Faridabad, India
10.2011 - 09.2012
- Performed day to day production planning and scheduling.
- Conducted Process troubleshooting and quality testing exercises.
- Assisted in equipment design and delivering solutions to customers
Education
MBA - AI And Data Management
NIBM Global
India (Part Time - Online) 09.2021 - Current
Postgraduate Program - Data Science And Business Analytics
McComb Business School,University of Texas Austin
Austin, US 04.2021 - 03.2022
Master of Science - Process Engineering
University of Manchester
Manchester, UK 09.2010 - 11.2011
B.Tech - Chemical Engineering
National Institute of Technology
India 08.2006 - 07.2010
Skills
Business Process Management
Accomplishments
- Designed Highly Integrated Cloud based Quality Database Management System using Access, Power Automate, Sharepoint , Teams, Power BI, SAP GUI Scripting and VB. System had Data Governance, Version History, Robotics Process Automation, Control Charts and Process capability dashboard, Right First Time calculator, Rework planner, Non-conformance progress tracking/Root cause analysis, SAP GUI Automation and OFS machine data integration.
- Designed and Implemented end to end business process of printed Wallcovering and Blinds dropship/contract manufacturing. Successfully achieved a 63% Net Profit Margin over a span of 1 year.
- Designed a Noval proprietary biogas processing plant with 60% less water and 40% less energy requirement than conventional gas sweetening process. Client bought the exclusive rights to the technology.
- Completed 3 Lean Six Sigma projects in Fabric Production. Achieved a cost saving of $350k in 1.5 year while reducing Takt time from 7 days to 3 days.
- Improved a paint product performance which resulted in nearly $200k labour cost saving and estimated project completion time reduction of 2 years.
- 13 International Journal Publications on Process Integration, Energy and process efficiency, carbon capture and ergonomics.
- National Silver Medalist and 6 times state gold medalist in Taekwondo and Kung Fu competitions.
- Best musician award 6 times in a row at School and 3 times state percussion competition winner.
Software
ERP - Pronto, SAP, NetSuite, Optimus
Sharepoint, Teams and Power Automate
Visio, Drawio, Lucid Chart, Holocentric
Basic VB, JSON
Process Simulators - Aspen Plus, HYSYS, HTRI, Pro II
Access, Excel, Outlook
Minitab, Sigma XL
Supervised and Unsupervised Machine Learning
SQL, SSIS, KNIME, ORANGE 3, Power Query (M and DAX))
Certification
Lean Six Sigma Black Belt
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Timeline
System Design & Development Officer
Sydney Trains
01.2022 - Current
MBA - AI And Data Management
NIBM Global
09.2021 - Current
Postgraduate Program - Data Science And Business Analytics
McComb Business School,University of Texas Austin
04.2021 - 03.2022
QA Supervisor
DuluxGroup
09.2019 - 01.2022
Operations Coordinator/Business Analyst
Materialised Pty Ltd
09.2017 - 09.2019
Quality Assurance Officer
Graphics Packaging
11.2016 - 09.2017
Production and QC Supervisor
Omega Paints
10.2015 - 12.2016
Sr Process Engineer
Synergy Process System
06.2014 - 06.2015
Sr. Research Officer
University of Sydney
09.2012 - 08.2015
Process Engineer
Xtreme Engineering
10.2011 - 09.2012
Master of Science - Process Engineering
University of Manchester
09.2010 - 11.2011
B.Tech - Chemical Engineering
National Institute of Technology
08.2006 - 07.2010
Lean Six Sigma Black Belt
Six Sigma Green Belt
Change Management
Leadership and Team Management
Data Science and Data Visualization
Business Analysis
Agile and Scrum Project Management
Similar Profiles
Hayley CRAGGILLHayley CRAGGILL
Brand Ambassador at DuluxGroupBrand Ambassador at DuluxGroup
Tracy-lee McCaffreyTracy-lee McCaffrey
Salesperson at DuluxGroupSalesperson at DuluxGroup
Deidre WitekDeidre Witek
Field Merchandiser at DuluxGroupField Merchandiser at DuluxGroup