Alejandro Ramirez, Developer in Coquitlam, BC, Canada
Alejandro is available for hire
Hire Alejandro

Alejandro Ramirez

Verified Expert  in Engineering

Power Platform Developer

Coquitlam, BC, Canada

Toptal member since September 8, 2023

Bio

Alejandro is a seasoned professional passionate about helping organizations streamline their processes and achieve their business goals with top-notch tech-based solutions. He uniquely blends extensive knowledge of Power BI, Power Apps, and Power Automate with proven expertise in business and marketing. Alejandro has worked for different companies, creating custom solutions that meet each organization's unique needs, automate critical processes, and improve overall efficiency.

Portfolio

Univerus Software
Microsoft Power BI, Microsoft Power Apps, Microsoft Power Automate, SQL, APIs...
TEAM International
Microsoft Power BI, Microsoft Power Apps, Microsoft Power Automate, SQL, UiPath...
Neuralnet
Microsoft Power BI, Data Analytics, Data Cleaning, SQL, Python

Experience

  • Data Analytics - 7 years
  • User Interface (UI) - 7 years
  • User Experience (UX) - 7 years
  • Microsoft Power BI - 6 years
  • SQL - 5 years
  • Microsoft Power Apps - 5 years
  • Microsoft Power Automate - 5 years
  • Azure - 5 years

Availability

Part-time

Preferred Environment

Microsoft Power Apps, Microsoft Power Automate, Microsoft Power BI

The most amazing...

...thing I've developed is a solution to supercharge my client organization's sales efforts, transforming the way they approach lead generation and deal closures.

Work Experience

Power Platform Developer

2020 - 2023
Univerus Software
  • Served as the technical lead for automation and data visualization across 10+ business units, spearheading the implementation of solutions developed with Power Platform and Microsoft Azure services.
  • Developed exportable pixel-perfect reports for multiple clients using stored procedures. Additionally, implemented an automated job in Python to streamline the deployment process for a substantial volume of reports.
  • Integrated the Xero financial system with Power BI, leveraging their APIs to deliver comprehensive financial insights and reporting. It involved handling various currencies and consolidating them into Canadian dollars.
  • Consolidated Jira and ZenDesk data to efficiently track employee tasks and client billing.
  • Implemented automation and reports within Humi, the payroll and HR software.
Technologies: Microsoft Power BI, Microsoft Power Apps, Microsoft Power Automate, SQL, APIs, Azure, SSRS Reports

Power Platform Developer

2018 - 2020
TEAM International
  • Crafted, designed, tested, and rolled out over 100 solutions for a top semiconductor company based in the US. These innovations significantly impacted how they do business, boosting their performance and tech capabilities.
  • Provided mentorship to interns and junior team members in the Power Platform, helping them enhance their technical proficiency and soft skills.
  • Managed administrative tasks for the Power Platform, SharePoint, and Power BI admin centers in Microsoft Office 365.
Technologies: Microsoft Power BI, Microsoft Power Apps, Microsoft Power Automate, SQL, UiPath, Web Development

Data Analyst

2015 - 2018
Neuralnet
  • Created several monitoring dashboards that integrate seamlessly with Google Analytics. This helps the business to closely monitor their ad campaigns and optimize strategies for reaching the right audience.
  • Transferred complex and challenging Excel spreadsheets to more reliable tools like Power BI, SQL, and Python. This transition grants easier data maintenance and management.
  • Conducted technical demonstrations for potential clients, contributing to successful deal closures.
Technologies: Microsoft Power BI, Data Analytics, Data Cleaning, SQL, Python

Teamder

A user-friendly Power Apps product that serves as an all-in-one CRM. With Microsoft Dataverse behind the scenes for secure data storage, this app lets sales effortlessly manage leads and log every interaction. Leveraging Power Automate, we automated workflows to save time and boost efficiency. Additionally, Power BI enables the creation of visually appealing executive reports, providing valuable insights to inform strategic decision-making processes.

Mentorship App

A Power Platform solution designed to foster mentorship and collaboration at every level. This app empowers all employees to step into the mentor role or seek guidance as a mentee across various areas of expertise. The app's intelligent matching system suggests the best mentor-mentee pairings.

OpenAI Bot

A Power Apps solution integrated with the Azure OpenAI API serving as a chatbot within Microsoft Teams for our organization. This AI assistant offers comprehensive support for employees and can handle a wide range of tasks and inquiries. Additionally, it's linked to our organization's data sources, enabling access and delivery of real-time information and insights.

Opportunity Tracker App and Report

An internal application for sales opportunity tracking. This application features robust row-level security measures to ensure confidentiality, restricting access to specific sales personnel. Additionally, it incorporates a Power BI reporting layer for managers, leveraging advanced DAX calculations to extract diverse metrics and insights. This comprehensive solution enhances data privacy and delivers actionable intelligence to support effective sales management and decision-making.
2017 - 2017

Bachelor's Degree (Exchange Program) in Business Administration

Victoria University of Wellington - Wellington, New Zealand

2013 - 2017

Bachelor's Degree in Marketing | Advertising and Marketing

EAFIT University - Colombia

MARCH 2020 - PRESENT

Microsoft Certified Solutions Associate (MCSA): BI Reporting

Microsoft

FEBRUARY 2020 - PRESENT

Microsoft Certified: Power Platform App Maker Associate

Microsoft

FEBRUARY 2020 - PRESENT

Microsoft Certified: Data Analyst Associate

Microsoft

Tools

Microsoft Power Apps, Microsoft Power BI, Figma, Power Query

Platforms

Microsoft Power Automate, Azure

Languages

SQL, Python

Storage

Azure SQL

Other

Data Analytics, Data Cleaning, User Experience (UX), User Interface (UI), APIs, Statistics, UiPath, Web Development, SSRS Reports, Office 365

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring