Prachi Mahapatra

Ph.: +1-774-***-****; Email:adbki8@r.postjobfree.com: LinkedIn: http://www.linkedin.com/in/prachi-mahapatra CAREER OBJECTIVE

Seasoned Business Analyst with 5+ years of work experience in Data Analysis, Predictive Modeling, Data Visualization using Tableau, Program Management, and Business Process Improvement in MNCs like Amazon and Cisco. EDUCATIONAL BACKGROUND

University of Texas Arlington, United State of America Aug’19- Present Master’s in Business Analytics (First Class with Distinction) Madras Christian College, Madras University, India June’10-May’13 Bachelor Computer Application (First Class with Distinction) SKILLS

Programming Proficiency: SQL,R (dplyr, ggplot2, caret), Python (pandas, scikit-learn), JavaScript, HTML, C/C++, Visual Studio, SAS Data Visualization : RShiny, Tableau

Online Certification : R Programming from Coursera, Six Sigma, ITIL Domain Knowledge : E-commerce, Networking

Operating Systems : Linux, Windows

Languages : English (Fluent), French (Intermediate), Hindi (Fluent) WORK EXPERIENCE (5+ years)

Business Analyst, Cisco India, Bengaluru Sep ’16 –Feb’19

• Project Over Delivery Model:

o Built a logistics regression model in R to predict potential projects which will be over delivered o Intimation sent to respective project managers which were predicted by the model so that they can manage time and labor. o Result: Improved profitability by predicting $3 million worth over delivery well in advance for managers to take action

• Developed two COGS Predictive model for Fiscal Year Planning: o Time series forecasting model using ARIMA technique for predicting Cost of Goods Sold o Linear Regression model to provide a what-if scenario with input variables like headcount, revenue, region, etc.

• Cisco Accounts Validation Process:

o Developed scalable scripts to validate and monitor key metrics for all the accounts in Cisco Advanced Services such as cost budget, actual cost, actual revenue, actual margin, sold vs delivered margin, and booked gross margin o Validated existing DBs & scripts which helped increasing the number of accounts in scope from 350 to 2,244 o Result: Reduced time of validation from 5 days to 1 day; scaled the process to all accounts of Cisco Advanced Services

• Report Automation:

o Minimized the time taken to produce the transaction revenue forecast; changed the report methodology by combining multiple sources into a single data source to increase report accuracy and decrease redundancy using SQL scripts.

• Project Management:

o Headed project management plan involving scope statement, delivery schedule, resource management, quality management o Streamlined the innovation initiative to add value to customer by encouraging team to come up with automation ideas for accelerating the time cycle of redundant tasks

• Ease of Selling Automated Dashboard:

o Developed a fully automated dashboard using tableau and R Shiny to provide insights into Ease of Selling metrics o Shifted to real-time insights from weekly report by improving the refresh frequency of data o Result: Improved efficiency by saving 8 man hours per week

• Data Governance Model:

o Implemented data governance model to ensure high data quality for accurate and effective Business Intelligence & Analytics o Developed a R Shiny Dashboard to monitor data gaps between several transaction & reporting systems o Result: Improved Data Accuracy to 98% from 75%, reduction in Total Cost of Ownership of IT systems, increased truthfulness of insights on business to the senior management

Amazon Development Center, Bangalore, India

• Operations Team Lead Oct’15 – Sep’16

o Understood the domain and the product in detail to come with test strategy/planning, developed test cases, drive test case sign-off processes with the stakeholders, and prepared test execution report o Performed Market Research and prepared documents with analysis for Pre-Sales, Business Development & Market Trends

• Operations

Automation Analyst Jun’13 – Sep‘15

o Developed high-quality test strategies and automation scripts in Vendor and Seller Management, Demand Planning, Demand Estimation, Pricing Analysis

o Built automated tests using existing tools and frameworks to expose defects in product code using Agile testing methodology Current Projects

Pulpy Pantry: Supply Chain Competition Oct ’19 –Current o Strategizing the bundle packs and pricing of the granola bar and chips packets o Marketing Strategies to sell the product to mother’s who are key target Current Positions

o Vice President in Data Analytics

o Social and Media Coordinator in PyMavs (Python Organization ) EXTRACURRICULAR ACHIEVEMENTS

o 3 times Regional Gold Medalist and played National Level in Taekwondo for the year 2008-2011 o Runner Up for 2 consecutive years in National Level Dance competition for the year 2011-2013