Resume

Work
Experience

Jun 2020 - Sep 2020

Business Analyst Intern

Leveraged machine learning models to forecast post-product launch sales; Improved the current forecast accuracy by 20%
Used historical customer sales data to gather insights on customer buying patterns and proposed a propensity model with 70% accuracy that predicts the type of contraceptive device they want
Designed and Developed ETL jobs to extract data from S3 bucket and Rest APIs and load it in data mart in Redshift
Analyzed and researched on different market trends in USA, African and Asian reproductive health industries
Created, in Power BI, data dashboards that will communicate insights in presentations to potential investors

Sep 2011 - Apr 2018

Data Analyst (Network OPS)

Performed in-depth customer basket analytics for each region and made suggestions to the warehouses to maintain the required inventory to match the demand
Analyzed Big data (10 million records & 200 fields) of 100 carriers with SQL, European region transportation delays and their impact on customers. Findings were used in subsequent carrier selection and bidding negotiations
Resolved 400+ peak season escalations by procuring new carriers who could meet sort centers’ pickup deadlines
Defined KPIs and developed dashboards that tracked Fulfillment and Sort Center performances; Generated ad-hoc reports in Excel Power Pivot and shared them using QuickSight to the decision makers for strategic planning

Jun 2016 - Aug 2017

Business Analyst (Management Trainee)

Developed a customer segmentation framework using KMeans algorithm, tracking the recency, frequency, and monetary values of transactions; This framework helped the client to reclassify their campaign targeting strategies
Utilized SQL (aggregate, Join, sub-query, common table expression, window function) to consolidate data, collaborating with 4 analysts to cut data for senior leaders including Head of Data Management
Executed ‘Loyalty Program Management Roll Out’ proposal, collaborating directly with the Marketing team; Ensured successful pilot by conducting multiple A/B tests for targeted marketing campaigns (R)
Analyzed the bounce, churn & conversion rate using Google Analytics to better retarget abandoned cart users
Automated and monitored essential Tableau dashboards to track 5 different Key Performance Indicators (KPIs) for each of the 4 departments to comprehend the shape of demand

Sep 2019 - Mar 2021

Master of Science in Business Analytics

GPA 3.97 / 4

Aug 2012 - May 2016

Bachelor of Engineering in Civil

GPA 3.23 / 4