Alejandro is available for hire
Hire AlejandroAlejandro Ramirez
Verified Expert in Engineering
Power Platform Developer
Location
Coquitlam, BC, Canada
Toptal Member Since
September 8, 2023
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
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
Experience
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.
Skills
Tools
Microsoft Power Apps, Microsoft Power BI, Figma, Power Query
Platforms
Microsoft Power Automate, Azure
Other
Data Analytics, Data Cleaning, User Experience (UX), User Interface (UI), APIs, Statistics, UiPath, Web Development, SSRS Reports, Office 365
Languages
SQL, Python
Storage
Azure SQL
Education
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
Certifications
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
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