Leonardo Del Carpio Bellido Email & Phone Number

Miraflores, Lima, PE

Foster City, CA, US

• Developed a research project using qualitative and quantitative methods to properly identify active pharmaceutical ingredients (API), impurities, raw materials, manufacturing components, and finished products through.
• Experienced in performing molecule reactions using Gaussian 9W. Ran regression analysis using JMP Pro.
• Researched spectra identification algorithms and reproduced them using Python
• Developed Raman Spectra identification models using Python, Panda, Numpy, and Scikit-learn
• Operated Spectroscopy Instruments from Thermo Scientific and Renishaw vendors.
• Performed pipetting, reconstitution, laser handle, and microscopic sample activities

Tokyo, JP

• Developed data delivery processes from a wide diversity of sources (E.g.: SQL Server, Oracle, TXT files, CSV files, REST API Services) to different repositories (E.g.: ADLS. Datalake, PostgreSQL, SQL Server)
• Improved an ad-hoc Data Factory ETL framework which allows the creation and deployment of pipeline workflows in testing and production environments, by adding Datalake and REST API data extraction modules
• Coded using PySpark in Databricks for data transformation purposes
• Performed data transformation according to the data scientist’s requirements
• Worked under SCRUM framework. Participated in daily and retrospective meetings. Defined product backlog and sprints
• Kept constant communication with clients to identify requirements and design solutions based on them

Lima, PE

• Led and delivered critical client projects from different disciplines: Data warehousing, Dashboard design and development, Data Governance, and Mobile App Development (as a Product Owner)
• Built PowerApp solutions combining analytical functionality with Power BI and querying different data sources (SQL Server, Oracle, Common Data Service (now rebranded as Dataverse)
• Led the development of algorithms for grade prediction and academic orientation using Azure Machine Learning. The predictions were delivered through API REST services and later shown in Web Applications.
• Developed invoice management Power BI dashboards integrated with insights, KPIs, and categorized information, oriented to fit any type of business. Used cloud-based technology to build an ETL process that massively.
• Designed a roadmap for a retail company. Studied client’s KPIs, business strategy alignment, gap analysis, and quick wins to achieve a better level of BI maturity
• Developed PowerApps for employee time tracking, and food order and tracking management

Miraflores, Lima, PE

• Created data models for financial and retail clients
• Designed and developed ETL processes and designed Dashboards in Power BI, Tableau, and Qlik View/Sense
• Created a client-oriented Finance Datamart. It analyzes bank account statements and customer risk ranking. Plus, an algorithm was developed to identify which person can apply for loans and benefits assuming the least.
• Centralized several highly complex academic data sources into a clean and validated repository
• Optimized Oracle SQL scripts of a whole logistic management system. The execution time was reduced 80%

Lima, PE

• Designed and developed a videogame for a public health organization using Unity3D and C#
• Experienced in database modeling based on diverse client's business processes
• Developed web services
• Developed web applications using Umbraco CMS
• Technical pre-seller: Demos, POCs, and technical solution background design understandable for project stakeholders

Lima, Lima, PE

• Leader of the Productivity Department
• Technical pre-seller: Demos, POCs, and technical solution background design understandable for project stakeholders
• Main consultant for high-complexity developments: back-end or front-end
• Provide training to new employers
• Client troubleshooting for technical concerns

Madrid, Comunidad De Madrid, ES

• SharePoint workflow development, including ad-hoc features that require out-of-the-box configurations of the SharePoint Standard package
• Check-in system development using PHP, Laravel framework, and PostgreSQL
• Designed and developed a financial simulation system using ASP.NET 2.0, C, and Jquery

Montreal, Quebec, CA

• Intranet configuration and development using SharePoint 2010
• Webparts programming and maintenance using ASP.NET 3.5, C#, javascript, HTML
• Report optimization (SQL server, Reporting services)
• Human Resources System development based on SharePoint 2013 Online

Lima, Lima, PE

• Employee of the month (October 2013)
• Webparts development for SharePoint 2010
• Report design and development using Reporting Services
• SharePoint site maintenance
• Wore multiple hats on different occasions (As a report designer, technical leader, and supervisor)
• SharePoint 2010 trainer

M.S. In Applied Statistics And Data Science, Statistics

Business Intelligence Developer, Data Modeling/Warehousing And Database Administration

Project Management Based On Pmbok, Project Management

Game Development With Unity, Computer Games And Programming Skills

Bachelor'S Degree, Computer Systems Engineering