Andres Castillo, Msc.

Andres Castillo, Msc. Email and Phone Number

Data Analytics Manager @ The Driving Force Group of Companies
Edmonton, AB, CA
Andres Castillo, Msc.'s Location
Edmonton, Alberta, Canada, Canada
Andres Castillo, Msc.'s Contact Details

Andres Castillo, Msc. work email

Andres Castillo, Msc. personal email

n/a

Andres Castillo, Msc. phone numbers

About Andres Castillo, Msc.

Data analytics specialist with a demonstrated track record in areas of cloud-based data applications, data engineering & governance, machine learning, data visualization, data modeling, and optimization.Over the years, I have acquired firsthand experience in developing and implementing data analytics processes to effectively improve industrial operations and business strategies in the education, finance, and automotive sectors. I'm an initiator with a positive mindset who is always willing to take on new challenges. I thrive in dynamic and complex work environments where I can draw on diverse talents and deliver unique tech solutions. 👋🏼 Let's get in touch!

Andres Castillo, Msc.'s Current Company Details
The Driving Force Group of Companies

The Driving Force Group Of Companies

View
Data Analytics Manager
Edmonton, AB, CA
Website:
drivingforce.ca
Employees:
293
Andres Castillo, Msc. Work Experience Details
  • The Driving Force Group Of Companies
    Data Analytics Manager
    The Driving Force Group Of Companies
    Edmonton, Ab, Ca
    View
  • The Driving Force Group Of Companies
    Data Analytics Manager
    The Driving Force Group Of Companies Aug 2021 - Present
    Edmonton, Ab, Ca
    View
  • The Driving Force Group Of Companies
    Data Engineer / Cloud Solutions Architect
    The Driving Force Group Of Companies Jun 2020 - Aug 2021
    Edmonton, Ab, Ca
    As a Data Engineer / Cloud Solutions Architect @ the Driving Force Group of Companies, I designed and developed serverless end-to-end data pipelines, built and automated reports & dashboards, and developed software integrations that supported business and operational processes. • Built multiple data models and developed 40+ reports/dashboards using AWS Quicksight that provided actionable insights for a wide range of business cases: real-time product utilization, detecting fraud, forecasting customers' product demand, etc. • Developed multiple software integrations saving more than 5,000 hrs/yr using AWS Serverless Application Model and services as Lambda, API Gateway, ECS, S3, and Athena. • Designed and developed a CI/CD pipeline that deploys an RDS PostgreSQL database (Master Data Management) in multiple AWS accounts (dev, stg, prod) using the AWS Cloud Development Kit (CDK).• Developed cloud architecture designs to be compliant with the AWS Well Architecture Framework.☁️ 𝗔𝗪𝗦 𝘀𝗲𝗿𝘃𝗶𝗰𝗲𝘀: Lambda, API Gateway, ECS, RDS, S3, Athena, Glue, Glue DataBrew. 💻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗶𝗻𝗴 𝗹𝗮𝗻𝗴𝘂𝗮𝗴𝗲𝘀: Python, Nodejs, Bash.
    View
  • Trust Science
    Business Intelligence Engineer
    Trust Science Nov 2019 - Jun 2020
    Edmonton, Alberta, Ca
    As a BI Engineer @ Trust Science, I had the opportunity of developing and supporting the BI platform of a FinTech company that leverages Artificial Intelligence (AI) & Machine Learning (ML) to capture, interpret and score consumers using unstructured and structured data. • Developed credit risk model performance reports and visualizations uncovering insights that resulted in up to 34% increase in booked loans and up to 27% decrease in default rate.• Developed and maintained descriptive and prescriptive dashboards using AWS Quisksight with 60+ KPIs and measures enabling critical insights and data-driven decisions.• Analyzed and delivered insights from various loan portfolios (up to 10M consumers and 22M loans) using Python, Jupyter Notebook, MS Excel (pivot tables & macros), and Power BI.• Developed and automated monthly financial reports for internal clients using Power BI.• Developed code-based visualizations using Python Plotly/Dash.☁️ 𝗔𝗪𝗦 𝘀𝗲𝗿𝘃𝗶𝗰𝗲𝘀: Quicksight, Athena, S3, Glue, RDS, Lambda, Lake Formation. 💻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗶𝗻𝗴 𝗹𝗮𝗻𝗴𝘂𝗮𝗴𝗲𝘀: Python, VBA, Bash.📁 𝗦𝗼𝗳𝘁𝘄𝗮𝗿𝗲: MS Excel, Power BI, Jupyter Notebook, Plotly/Dash.
    View
  • Trust Science
    Data Engineer
    Trust Science Sep 2018 - Nov 2019
    Edmonton, Alberta, Ca
    As a Data Engineer @ Trust Science, I extracted, transformed, and analyzed (ETL) large amounts of data (big data) from different sources to identify insights that help the company make data-driven decisions.• Performed data exploration, categorical encoding, and feature engineering on large datasets.• Implemented cloud-based architecture designs in AWS to meet business requirements. • Wrote PL/PgSQL and T-SQL queries and stored procedures (functions) to perform ETL processes. • Developed serverless event-driven ETL process that gathers high-volume of data from both push-based and pull-based sources and converts it into JSON format for ML input models. • Developed serverless event-driven ETL process to populate an AWS RDS Data Warehouse (OLAP)💻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗶𝗻𝗴 𝗹𝗮𝗻𝗴𝘂𝗮𝗴𝗲𝘀: Python, Spark, SQL.💾 𝗗𝗮𝘁𝗮 𝘀𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲𝘀: CSV, JSON, XML, Relational Database.☁️ 𝗔𝗪𝗦 𝘀𝗲𝗿𝘃𝗶𝗰𝗲𝘀: RDS, Redshift, S3, Glue, Glue Data Catalog, Athena, Lambda, Lake Formation, Kinesis, SQS, SNS, SES.
    View
  • University Of Alberta
    Operations Research Analyst
    University Of Alberta Mar 2018 - Sep 2018
    Edmonton, Ab, Ca
    As an Operations Research Analyst @ the University of Alberta, I was responsible for providing research, data analysis, and data modeling using Operations Research & Data Sciences techniques to develop optimal solutions to business and operational problems• Developed Operations Research mathematical models to solve complex operational problems.• Analyzed results using statistical techniques and generated reports to support analytic insights.• Prepared reports and presentations summarizing results and outlining recommendations.• Collaborated with professors and engineers to identify, propose, and build business solutions. • Provided coaching and support to team members both in projects and research practice.💻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗶𝗻𝗴 𝗹𝗮𝗻𝗴𝘂𝗮𝗴𝗲𝘀: Python, R, AMPL, CPLEX, Gurobi
    View
  • University Of Alberta
    Graduate Research Assistant / Operations Research Analyst
    University Of Alberta Sep 2015 - Feb 2018
    Edmonton, Ab, Ca
    As a Graduate Research Assistant @ the University of Alberta, I conducted applied research to optimize the capacity cost optimization and availability analysis of long- and ultra-long-haul optical transport networks. • Developed mathematical optimization models for long-haul fiber optical networks achieving savings of up to 21% (~ $1M) in capacity investment.• Developed mathematical optimization models for discrete optimization problems such as product production planning, financial planning, transportation planning, and scheduling management.• Collaborated with Canadian National Railways (CN) on the development of a mathematical model for fuel consumption prediction on intermodal double-stack freight trains.• Built knowledge in optical networking technologies as DWDM, ATM, SONET/SDH, IP/MPLS, OTN.• Delivered technical presentations to all levels of the organization clearly and concisely. 𝗞𝗲𝘆 𝗮𝗰𝗵𝗶𝗲𝘃𝗲𝗺𝗲𝗻𝘁𝘀:🏆 Awarded with the best paper award at an IEEE international conference in Norway.🗣 Mentored 90+ grad and undergrad students as a Teacher Assistant in Operations Research.𝗣𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗶𝗻𝗴 𝗹𝗮𝗻𝗴𝘂𝗮𝗴𝗲𝘀 & 𝘀𝗼𝗳𝘁𝘄𝗮𝗿𝗲:💻 LP/ MIP, AMPL, CPLEX, Gurobi, Python, R, Matlab, MS Excel
    View
  • Ittera Sistemas De Transporte De Información
    Project Engineer
    Ittera Sistemas De Transporte De Información Feb 2013 - Nov 2013
    Maracaibo, Zulia, Ve
    As a Project Engineer @ Ittera, I designed and provided support for the implementation and maintenance of different telecommunications and security systems projects. Projects varied from $10K to $1M in size and were developed in different countries.• Planned and implemented structured cabling, wireless networks, and security systems projects. • Worked independently and led 4-6 network technicians in daily installation and maintenance.• Conducted site inspections, managed resources, prepared cost estimates and technical reports.• Installed and repaired structured copper cabling (Cat 5e, Cat 6, Cat 6a) and fiber optic systems. • Liaised with clients to address their needs and guide the project through final approval. Major projects involved:✔️ Supported the design and installation of the first cabling network Category 7a S/FTP Siemon in Costa Rica. The project involved more than 200 telecommunication points.✔️ Supported the design and installation of a new telecommunication cabling system for the main data center of Venezuela’s fifth-largest bank. The project included 1,300 telecommunication copper connections of category 7a S/FTP Siemon cables and more than 700 fiber optic OM4 cables.
    View
  • Gandalf Comunicaciones C.A.
    Network Engineer
    Gandalf Comunicaciones C.A. Nov 2012 - Dec 2012
    Ve
    Installed and administered LAN and WAN networks based on Cisco & Ubiquiti network wireless technologies. Operated in a fast-paced, on-call, and challenging 24x7 environment.• Provides day-to-day network monitoring and support of three major cities to identify and solve any performance or capacity issue following a strict Service Level Agreement (SLA).• Performed Cisco routing configurations as DHCP, DNS, SSH, RIPv2, EIGRP, OSPF, and BGP.• Tested and installed microwave antennas based on Ubiquiti networks systems.
    View

Andres Castillo, Msc. Skills

Project Management Telecommunications Network Optimization Data Analysis Matlab Engineering Management Cisco Networking Network Design Reliability Engineering Data Mining Sales Management Mobile Communications Networking Routing Protocols Data Modeling Data Warehouse Strategic Planning Research Customer Service Team Leadership Management Leadership Microsoft Power Bi Business Intelligence Software Development Industrial Engineering Statistics Programming International Project Management Operations Research Business Analysis Operations Management Requirements Analysis Microsoft Office Sql Postgresql Routers Switches Microsoft Excel Microsoft Access Tableau Python Bi Developer Object Oriented Programming Cisco Systems Products Multiprotocol Label Switching Computer Networking Git Data Visualization Wireless Communications Systems

Andres Castillo, Msc. Education Details

  • University Of Alberta
    University Of Alberta
    Engineering Management
  • Universidad Rafael Urdaneta
    Universidad Rafael Urdaneta
    Telecommunications Engineering

Frequently Asked Questions about Andres Castillo, Msc.

What company does Andres Castillo, Msc. work for?

Andres Castillo, Msc. works for The Driving Force Group Of Companies

What is Andres Castillo, Msc.'s role at the current company?

Andres Castillo, Msc.'s current role is Data Analytics Manager.

What is Andres Castillo, Msc.'s email address?

Andres Castillo, Msc.'s email address is an****@****nce.com

What is Andres Castillo, Msc.'s direct phone number?

Andres Castillo, Msc.'s direct phone number is +178065*****

What schools did Andres Castillo, Msc. attend?

Andres Castillo, Msc. attended University Of Alberta, Universidad Rafael Urdaneta.

What skills is Andres Castillo, Msc. known for?

Andres Castillo, Msc. has skills like Project Management, Telecommunications, Network Optimization, Data Analysis, Matlab, Engineering Management, Cisco Networking, Network Design, Reliability Engineering, Data Mining, Sales Management, Mobile Communications.

Who are Andres Castillo, Msc.'s colleagues?

Andres Castillo, Msc.'s colleagues are Roxanne Pike, Rochelle S., Takur Laxman, Rudy Rajannan, Ande Van Der Weken, Terri Evans, Samuel Masopeh.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.