Juan Camilo Arias Email & Phone Number

Brook Green, London, Gb

- Developed pyspark models such as: churn prediction, logistic regression, RFM for customer loyalty models, clustering, customer KPIs, business analytics models for largest retailerer in the country- Developed Python Selenium app to automate customer reports, reaching >8500 reports- Pulled and transform data using Pandas, Numpy, Geopandas, taking data from CSV and JSON- Launched EC2 and RDS instances on AWS to pulled and process datalake- Developed single platform on pyspark, python, hadoop, on juyter lab to query transactional data joining, product, store, segmentations and geographical data- Developed a geogrphical model to predict lighting strikes 5 minutes before hitting ground- Developed kpis dashboards using dash boostrap components and plotly

Boston, Massachusetts, Us

• Researched cable penetration market in D. Diligence for Pvt. Equity, resulting largest telecom consolidation in CAM• Analyzed data center ecosystem in Mexico and Latin America for M&A, resulting in asset acquisition • Modeled turn around strategies on recent acquisition from the largest operator in US, resulting in 2 follow up projects• Assessed credit risk exposure and wireless subscriber base merge in M&A process of US operators

Babson Park, Ma, Us

Work with the knowledge management function at the client to: 1. Analyze company’s community operations and client project perspectives.2. Organize interviews with stewards a part of the firm’s internal knowledge communities and stewards on project teams.3. Conduct a root cause analysis to identify gaps of knowledge sharing between internal firm knowledge and client project deliverables.4. Develop recommendations and best practices to share with company’s Core Values Committee.

Babson Park, Ma, Us

• Graduate Researcher in IoT – Which steps should follow an entrepreneur in IoT? A business case of https://www.invisawear.com/, an IoT startup founded by two Amazon interns who are one of the most active start-up at Mass Challenge. This paper will be published as a business case of Harvard Business School.• Graduate Researcher in IoT– Teacher notes researcher of “Beyond Wireless”, a remote IoT temperature control to monitor vaccines in Africa. >50 countries with applications in food industry and agriculture too.

Babson Park, Ma, Us

Attleboro, Ma, Us

Sensata Technologies (ST-NYSE) is a leading provider of sensors to the automotive, heavy vehicle, aerospace and industrial industries. ST is a rapidly growing $3 billion business with operations and business centers in 16 countries and over 20,000 employees worldwide. • Defined a framework to identify a market adjacency leveraging existing technologies and capabilities. The final definition resulted in three horizontals: market needs, competitors offering, and company capabilities. The framework was recognized inside the organization as clear and effective.• Structured the research at each horizontal between qualitative and quantitative analysis. An understanding that appropriately weighted both insights. An analysis that resulted in the growth vs market penetration matrix which prioritized high potential products for the North America Auto division.• Analyzed industry benchmark using an excel model to join IHS Markit (database and forecast of powertrain and vehicle's unit sales) and A2MAC1 (sample of 515 teardown vehicles). The final model resulted in the starting point to research tier manufactures competition and trend.• Presented to the board of directors identifying growing opportunities in macro trends like Electrification, IoT - Connectivity, Autonomous Driving and Shared Hauling.• Defined product TAM (Total Available Market) and SAM (Serviceable Available Market), a guideline which allowed management to start building the product feasibility and go-to-market strategy.• Compared competitors offering and market trends in Asia, Europe and North America to define geographical product timeline and expansion strategy.

Bogotá D.C., Co

ENDEAVOR Company. 10 MUSD sales in 12 countries developing value added services for mobile operators. • Strengthened underperforming services by using business analytics on SQL, a strategy that increased profits by 108%.• Structured, created and consolidated a business analytics unit that used Tableau, R and MySQL. Resulting in weekly reporting, live statistics and precise forecasting at all operations.• Developed a new business intelligence strategy using Tableau, which included cross department collaboration and data driven decision making, in order to improve financial forecasting using monthly rather than quarterly reports.• Established joint venture with Peruvian competitor that holds monopoly on TV channel's content, launching 20 services with local operator, accounting for 50% of country revenue.• Conceptualized, created, and implemented strategy to monetize national football association sponsorship from second biggest mobile operator, spending $250K to produce $1.2M revenue in first year.• Awarded teamwork medal for introducing SCRUM to marketing, reducing delays by 35%.• Established partnership with América Móvil and evaluated profitability of new fitness strategy service of Claro in 5 countries, including pricing and marketing strategy.

Bogotá D.C., Co

• Grouped with East Africa’s main music app, Mdundo and M-Pesa- Safaricom adding 7000 users and 35% increase in successful charging rate. • Strengthened UAE services through new viral marketing campaign which result in 27% increase in sales.• Established the grow strategy in the region, mainly in Middle East and east Africa. Constituted the operation in Kenya.• Implemented cooperation with the main music company in East Africa, Mdundo. The streaming service bills and delivers information to the users through Aldeamo platform.• Strengthened Emirates operation cooperating with local operator through new viral marketing campaign (27% sales increase).• Designed, developed and implemented a sustainable social project for GDA Kenya to deliver health information to underprivileged people in Kenya through mobile devices.Secured funding for GDA through cooperation with the Rockefeller Foundation and iHub

Bogotá D.C., Co

• Established a weekly new service strategy to keep operation growing at 57% during 3 years.• Changed strategy to diversify type and size of clients. Before: one customer accounted for 90% of sales.• Strengthened company presence in the biggest mobile operator by launching a new portfolio of freemium model, an operation which increased sales from an annual total of $20K to $1.5M. • Designed a mobile loan’s service, a system which provided 43% of the total income of Colombia’s operation.• Sustained grow each year of 57%.• Corrected country strategy diversifying operators and sales.• Strengthened company presence in the biggest operator, from a total annual income of $20 k USD to $1,5 M USD per year.• Implemented more than 50 services (average per country is 4) and 8 of them became succesfull business case for all 13 countries. Including partnerships with Sony Music and Emi Music enabling digital fun-club communities to get available content from their favorite artist. • Increased the number of products and platforms inside the second biggest operator. Through business analytics and CRM, so the operator receives the consultancy to launch segmented services for prepaid and postpaid.• Improved 3 business units sales, in second biggest operator: Prepaid users top ups, data plans for prepaid users and SMS services.• Rescued the value added services income from a fall of 45% to the original level in less than two months. Our client, changed our charging policies and removed 50% of charging database.• Implemented mobile banking systems for coffee growers in Colombia contracted by mobile wireless operator movistar, in coordination with a local bank and the NGO of the farmers (Juan Valdez brand).• Rescued the third operator sales through new strategies designed to improve sales and user experience.Designed a service providing 43% of the total income of Colombia.

Shenzhen, Guangdong, Cn

• Recognized among the 12 countries for the best project of value added services in Latin America, Colombia SDP. Telefonica Movistar - Huawei, Toledo, Spain.• Strengthened the development of VAS services on the platform.• Achieved revenue target of services launched on the platform.

Espoo, Southern Finland, Fi

New tenders opportunities, Sales management, Team coordination.- Executed RFP within coordination of solution engineers to fulfill customer challenges.- Improved delivery time with constant communication with our account manager and bid team members. - Finished all trainings on DWDM, GSM, 3G and LTE

Munich, De

Internship at Financial Reporting of Andean region. Consolidating balance sheet, income statements of andean countries which includes: Colombia, Venezuela, Ecuador, Peru and an specific division for power transmission. Extensive use of SAP for consolidation, also support the team with Excel macros to improve delivery and processes.

Mba, Entrepreneurship/Entrepreneurial Studies, Finance, Business Analytics

Bachelors, Industrial Engineer, Operations Research, Finance

Bachelors, Electronic Engineer, Telecomunications, Control Systems