Isaac Rosales
Software Engineer
I specialize in turning complex data into actionable insights, building scalable BI solutions that drive business growth and efficiency.
Work Experience
Business Intelligence Specialist
Microsoft (Inviso Corp)
- Designed and maintained Power BI dashboards, enabling actionable insights for sales analysis, Dynamics CRM tracking, and customer segmentation across LATAM, the U.S., and Canada.
- Enhanced ETL workflows using Fabric dataflows and M Scripting to efficiently process large datasets, ensuring accurate and timely data delivery.
- Led the development of a key sales dashboard integrating data from various sources, providing visibility into revenue and pipeline performance for leadership teams.
- Collaborated with sales and marketing teams to create data-driven strategies by identifying patterns in customer behavior and optimizing outreach efforts.
- Built a ticketing app in PowerApps & Power Automate to capture user feedback and new requirements, streamlining continuous improvements.
- Ingested and integrated data from diverse sources, including data warehouses, SSAS cubes, SQL Server databases, and the Dynamics CRM API, enabling seamless analytics and reporting.
Business Intelligence Analyst
Johnson & Johnson (BEPC Consulting)
- Developed Power BI dashboards to track financial metrics, providing clear visibility into cost savings, project timelines, and the progress of healthcare supply chain initiatives across multiple manufacturing plants.
- Implemented project management solutions using PowerApps and Flow to optimize resource allocation and prevent employee workload over-allocation.
- Analyzed production data to identify recurring defects and bottlenecks in the supply chain, enabling actionable improvements in efficiency and supporting project engineers in optimizing processes and enhancing product quality.
- Developed a comprehensive Power BI report for a business unit, integrating data from inventories, costs, production yield, scrap, and other key sources to provide an overview of operations.
Web Developer (Intern)
Lexmark International
- Created a production efficiency tracker to monitor performance across the entire manufacturing plant, calculating efficiency by analyzing man-hours, downtime, and production outputs. Provided granular insights by product, shift, and production line, enabling managers to identify bottlenecks, allocate resources effectively, and enhance overall operational productivity.
- Developed full-stack ASP.NET applications with responsive frontends, improving user experience with Bootstrap and JavaScript.
- Migrated crucial SSRS reports to Power BI, addressing frequent query timeout errors and significantly improving report performance and user experience by optimizing data models and query execution.
- Managed end-to-end data projects, including data modeling, SSIS workflows for file integration and stored procedures, and Power BI reports for data visualization.
IT Support
CIMASA S.A.
- Developed a barcode attendance system in Visual Basic for 550+ employees, drastically reducing paper usage and enabling the payroll team to easily calculate total hours per employee.
- Automated administrative tasks with Excel macros, reducing repetitive data entry.
- Created a C# application to automate contract renewals, saving significant manual processing time.
- Handled hardware and software support, maintaining stable day-to-day operations across the company.
Side Projects
Survey Data & Sentiment Analysis for Public Infrastructure Evaluation
Conducted data analysis for the Mexican government to support ISO 9001 certification, leveraging user feedback to identify key infrastructure improvements
Challenge
The State Government of Chihuahua aimed to obtain ISO 9001certification, which required the tracking, measurement, analysis, and evaluation of customer satisfaction and the effectiveness of the management system across three transnational bridges between Ciudad Juarez and El Paso.
Solution
Analyzed survey data to assess user satisfaction and safety, developed a Power BI dashboard for decision-makers, and used AI-driven sentiment analysis to classify user feedback into complaints, suggestions, and concerns.
Impact
- Helped government executives identify and prioritize key infrastructure improvements based on data-driven recommendations.
- Supported the successful ISO 9001 certification by providing the required data analysis and insights.
Tourism Data Platform for Public Access & Insights (SICHITUR)
Collaborated in a web platform for the Mexican government to provide public access to tourism KPIs, integrating data from various sources to enhance decision-making and transparency.
Challenge
The Tourism Department of Chihuahua needed a public platform to provide transparent access to tourism data, including visitor trends, economic impact, and social media insights.
Solution
Developed sichitur.com, a web platform with integrated Power BI dashboards, automated tourism data collection from flights, hotels, and social media, and performed sentiment analysis to provide public access to tourism KPI's.
Impact
- Empowered government executives, businesses, and the public with data-driven insights for better planning.
- Provided data integration, enhancing tourism strategy based on visitor trends and economic impact.
Agente Libre – AI-Powered Job Matching Platform
Developed a web application to automate job searching by aggregating listings from multiple sources and using AI-powered resume matching to recommend the best opportunities.
Challenge
With numerous job boards online, job seekers struggle to track openings across multiple platforms and identify opportunities that align with their skills and experience.
Solution
Developed Agente Libre, a web application that scrapes and enriches job listings daily, applies AI-powered resume matching to suggest relevant jobs, enables users to manage digital resumes, and provides automated alerts for top opportunities.
Impact
- Simplifies job searching by centralizing listings from multiple sources and enhancing discovery through AI.
- Empowers job seekers with personalized recommendations, resume insights, and an easy-to-use platform tailored for remote work in Mexico.
Mobile Tire Repair Business (MePonché)
Co-founded a mobile tire repair service leveraging data analytics to optimize operations, improve service response time, and set competitive pricing for profitability.
Challenge
Efficiently delivering mobile tire repair services required identifying an optimal base of operations, ensuring fast response times, and setting competitive pricing to attract customers while remaining profitable.
Solution
Used geospatial and market analysis to identify the best service location, optimized pricing for affordability and profitability, and developed a Power BI dashboard to track operations, revenue trends, and customer distribution.
Impact
- Introduced an innovative on-location tire repair service with a competitive and sustainable pricing model, making it accessible to a wider audience while maintaining profitability.
- Secured funding for business expansion by presenting data-driven insights to investors.
Data Analyst Volunteer - Chupacabras A.C.
Led data analysis efforts for a major mountain bike event, providing insights on cyclist satisfaction, performance, and economic impact—key factors in securing government support and sponsorships.
Challenge
Organizers needed data-driven insights to demonstrate the event’s economic impact and participant experience, crucial for securing government permissions and sponsorships.
Solution
Conducted cyclist satisfaction and economic impact studies, and developed Power BI reports showcasing the event's value to stakeholders.
Impact
- Demonstrated the economic impact in our community, proving its value to the local government, which helped in securing permissions and funding.
- Provided sponsorship-attracting insights, highlighting visitor spending and participant engagement to bring in new partners.
- Saved 500+ man-hours annually by digitizing and streamlining survey processes, ensuring long-term sustainability for future volunteers.
Power BI Instructor
Trained over 200 professionals in Power BI as part of a government initiative, preparing them for certification and strengthening data analytics expertise in Chihuahua’s workforce.
Challenge
The Chihuahua government needed to upskill professionals in data analytics, particularly in Power BI, to support the growing demand for BI tools in manufacturing industries.
Solution
Designed and delivered Power BI courses for a government-backed program, training in data modeling, DAX, Power Query, and visualization best practices to prepare them for Microsoft’s Power BI certification.
Impact
- Trained over 200 professionals for the Microsoft Power BI Data Analyst Associate certification.
- Strengthened Chihuahua’s workforce by increasing Power BI expertise in industries vital to the region’s economy.