Anupam Lalwani
Data | Business Intelligence Analyst
Anupam Lalwani
Data / Business Intelligence Analyst
Hi! I am a business analyst with a knack of persuasive storytelling. I hold over 5 years of work experience working with data of different industries and countries. I am always passionate about unveiling the story behind numbers, connecting the dots and solving business problems.
Currently I am pursuing Data Analytics Certificate from University of California, Berkeley to enhance my toolkit by learning new analytical languages and libraries. I have an excellent ROI track record - per my previous managers. I am looking for opportunities in analytics, to help organizations take informed decisions.
Work Experience
-
Business Intelligence Analyst
October 2016 - July 2017Comcast NBC Universal
- Created customized ad-hoc reports and dynamic dashboards, automated process for ETL, daily reports and dashboards while ensuring data validity using SQL, Advanced Excel, SSIS, Tableau
- Handled everyday reports, maintained and updated ETL processes, provided support to sales team of more than 600 people to help them optimize their strategies on daily basis
- Carried out data manipulation using SQL and Excel to analyze trends in KPIs from large data sets for different sales channels that helped company reduce negative revenue by more than $20K per month
- Collaborated with finance and marketing teams to provide customized reports to upper management about important KPIs like variance of budget vs forecast, budget vs target, conversion rate, promotions performance
- Maintained and analyzed special subscription reports catered to upper management focusing on subscription KPIs such as disconnect rate, voluntary/in-voluntary, upgrade rate -
Senior Business Analyst
March 2011 - March 2014Tata Consultancy Services
- Carried out ETL, cleaning, modeling and analysis of data from Nielsen servers using UNIX, SQL Server, MS Access, Pivot tables and Excel Charts
- Used statistical methods like significance testing, regression analysis, factor analysis, clustering and multivariate analysis to generate results
- Created statistical models using Nielsen’s global modeling platform and provided insights that helped client to save/earn around $1M in various markets
- Conducted new employee training, mentoring and ensured timely delivery of projects with 100% accuracy
- Worked with international teams, provided category insights and helped building client presentations and dashboards to convey a story through numbers -
Sales Support Assistant
December 2009 - January 2011Crocs International
- Carried out ETL process and generated daily reports for sales operations department, facilitating in forecasting and planning sales/demand
- Analyzed purchase and sales order reports using Pivot tables in Excel and automated purchase order forms using vba script to save time when creating purchase orders
Education
-
Data Analytics Certificate
June 2017 - December 2017University of California Berkeley
24 weeks rigorous program focused on developing working knowledge of different tools like Python (Pandas, Numpy, Scikit learn, Matplotlib), Javascript (D3), Tableau, SQL.
-
Marketing Certificate in Social Media and Web Analytics
June 2015 - July 2016University of California Los Angeles
Full time certificate program focusing on covering coursework like Brand Mangement, Strategic Marketng, Consumer Research, Predictive Analytics, UX/UI Design 101. -
Masters of Business Administration (Finance)
June 2007 - July 2009Maharaja Saiyajirao University, India
