Archit Arora Email & Phone Number

Gilbert, AZ, US

Atlanta, GA, US

American Fork, Utah, US

Schaumburg, IL, US

• Develop, optimize, and maintain data infrastructure and ETL pipelines for the company
• Develop a common transformation module in Python with the ability to consume and transform any scraped input data source into a usable format for the underwriters
• Utilize Kafka, Spark, and other distributed technologies for scaling the ETL pipeline and have a continuous stream of data making its way into Elasticsearch for consumption by application. Generated 10 TB of useful.
• Deploy and integrate data science models in production to run them on new incoming data. Integrated and deployed NAICS North American Industry Classification System and SIC Standard Industry Classification prediction.
• Identify new data sources useful for customers and either ingest it in-house or send it to offshore teams
• Manage offshore teams to scrape new data sources, solve any scraping issues and improve the quality of delivered data by using automated QA and QC testing

Schaumburg, IL, US

Austin, TX, US

• Worked in the Insides Sales department of a fabless semiconductor company
• Worked on B2B Integration to facilitate an electronic cloud-based system of recording sales for distributors to move from an earlier standard of recording sales individually at each end leading to mismatch over the years
• Used openpyxl and pandas library in Python to manipulate excel sheets and reconcile historical sales data between distributor and company databases

• Worked in the corporate office of a mattress production company setting up operations in India.
• Helped formulate strategic plan by benchmarking current mattress manufacturers and analyzing current industry landscape using market research reports
• Optimized and expanded the supply chain of mattresses by identifying new suppliers and distributors from 3 locations to 20 locations across India
• Worked in cross-functional team with marketing and sales departments, to discuss product penetration in various states and changes if required to the product to boost sales

Pune, Maharashtra, IN

• Worked in production in the vehicle assembly line having a rollout of 300 vehicles/day and supervised a workforce of 400 people.
• Led new product introduction team in my shop and worked in cross-functional teams to roll out new products entailing: production planning, design modifications, process management and demand forecasting
• Conducted MOST (Maynard Operation Sequence Technique) study for line balancing and reduction of men on the payroll in the shop by 50 manpower/day, part of process management activity
• Analyzed defects and performed root cause analysis to improve First Shot Okay (FSO) percentage from 22% to 98% and thus increasing efficiency
• Coolant filling automation idea implemented on assembly line achieving a saving of 26 man-days and Rs.10,000 / month. Presented in a case study competition at INSSAN (Indian National Suggestion Scheme Association).

New York, NY, US

• Worked in the investment banking research arm for Technology, Media and Telecommunications (TMT) sector
• Worked in tandem with London bankers to prepare pitch books (marketing materials for investment bankers) involving components like market and industry landscapes, financial analysis and valuations, equity research.
• Notable M&A deals worked on during internship: $990mn Yahoo's acquisition of Tumblr, $18bn Liberty Global acquisition of Virgin Media
• Performed quarterly update of trading and transaction comparable by analyzing financial statements, used for calculating deal multiples and financial ratios

Master Of Science (M.Sc.), Operations Research And Industrial Engineering

Msc.(Hons.), Economics

B.E.(Hons.), Mechanical

High School