Arthur Lobo Email & Phone Number

Mumbai, Mh, In

Mumbai, Maharashtra, India

Domain: Packaging• Led a 12-member agile team of Solution Architects, Data engineers, UI UX developer, Business Analyst, etc. to identify the overall operating efficiency of converting and corrugator machines for a major packaging company and integrate client data into AWS Data Lake which would power a Global Efficiency Power BI dashboard.• Led a team on a Robotic Process Automation (RPA) project to automate operational processes related to invoicing using Automation Anywhere software.

Mumbai, Maharashtra, India

Domain : Pharma• Successfully led Project Sniper, a micro market strategy initiative leveraging Channel Sales, IQVIA Sales, market prescription, and doctor data from Salesforce. Developed a granular (Pin code level) Power BI dashboard and utilized Python scripting for efficient data processing. • Spearheaded Project M2M, a Global travel and expenses dashboard focused on tracking and analyzing Abbott employees' claims, spend, and credit card aging. • Led the transition of over 15 dashboards related to Abbott's performance, market performance, and new product launches

Mumbai, Maharashtra, India

Domain: Pharma • Developed a comprehensive Monthly Ops dashboard providing key strategic insights into Abbott's performance compared to the Indian Pharma market. • Led end-to-end creation and publishing of Power BI dashboards utilized by senior management teams at Abbott. • Rolled out a highly usable Business dashboard for National, Zonal, Area, and Territory business managers across Abbott India. • Supported maintenance and upgrades of 20+ dashboards. Data sources included Abbworld (Salesforce), IQVIA, and internal finance data.

Mumbai, Maharashtra, India

• Managed Corporate MIS and Consolidation for Abbott's Primary Care business functions and Respicare Division.

Mumbai, Maharashtra, India

Domain: Consumer Packaged Goods and Financial Services • Retail Shopper Insights, Assortment Optimization and Segmentation Analysis • Led automation initiatives for a 6 member team resulting in 85% time savings • Led Delivered multi-country reports for Top Management level, Brand Manager level, Customer Insights and Analytics level • Campaign Effectiveness Assessment • Project Management, Budgeting, End to end delivery and MIS • Data visualization in Tableau, Power BI • Process efficiency and Automation

Mumbai, Maharashtra, India

Domain : Consumer Packaged Goods • Instrumental in developing Standardized Scalable Client Solutions from Data Extraction, Harmonization, Designing the Process Flow, Automation and Validation • Brought about process efficiencies, Time and budget savings • Generating insights and recommendations into client data • Managed the Management Information System (MIS) for the project • Utilized Power BI for data visualization

Mumbai, Maharashtra, India

Domain:- Consumer Packaged goods • Worked on Client Ad-hoc requests including Analytical requirements, Insights Derivation from Data, and Answering Business questions using BI Techniques • Analysis projects on Competitor Share, Distribution, TPR impact, Impact of Sizes on Value and Volume share, Segmentation • Report Standardization and Automation • Achieved a perfect Net Promoter Score of 10 on 10 from the Client

Mumbai, Maharashtra, India

Project: Wealth Management- A Study on HNI’s, Individual Asset Allocation & Family Offices.Brief: A study on the fairly new concept of Family Offices in India which has been adopted from the West , the Structure of Wealth in India, Alternative Asset Classes, the quantum of Investments in them, the nature of Indian Investments, HNI’s and new trends in Wealth Management.Project: Technical Analysis on Realty Sector.Brief: The project was an analysis of 10 stocks in the CNX Realty Index using technical analysis tools such as RSI, MACD, OBV, Stochastics, etc and Chart Patterns over a short to medium term perspective with positional trading calls.

Mumbai, Maharashtra, India

• Handled client accounts and performed tax computation and filing of income tax returns.• Assisted in basic-level audits.

Master Of Business Administration - Mba, Finance, General

Activities and Societies: Finalist in the Inter College Business Plan Competition “Spark” Coordinator in “Summer Excellence” an intra.

Bachelor Of Commerce - Bcom

Secured 1st Rank in Marketing Research in final year TYBCom Secured 1st Rank in Export Marketing in final year TYBCom

Education record