Alejandro Ortega
Olathe
Summary
With over 23 years of expertise in business analysis, data management, retail management, finance, technical analysis, operations project/product management, and customer service, I bring a dedicated and professional approach to every task. My commitment lies in utilizing this extensive experience to enhance the success of company products, services, and overall satisfaction.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Business Intelligence (BI) Developer
Insight Global - Consultant, Bluescope Buildings, N.A.
07.2024 - Current
- Data Analysis and Interpretation: Analyze large datasets to extract meaningful insights and trends
- Use statistical methods to interpret data and provide actionable recommendations
- Collaborate with business stakeholders to understand their goals and needs, tailoring analyses to meet these requirements
- Data Modeling and Management: Design and manage data models, often by transforming raw data into structured formats
- Create relationships between different datasets to enable comprehensive reporting
- Optimize data models for performance in Power BI, ensuring that reports run efficiently
- Dashboard and Report Development: Develop visually compelling and interactive dashboards, reports, and data visualizations using Power BI
- Use Power BI’s DAX (Data Analysis Expressions) language to create complex calculations and measures
- Customize visuals to convey insights in an accessible and user-friendly manner
- Along with: Data Extraction and Integration, Automation and Optimization, Stakeholder Communication and Training, and Intelligence and Strategy Development
- This role combines technical expertise in data handling and Power BI development with an analytical mindset to generate insights that drive organizational growth and efficiency
- Adapted quickly to new technologies and programming languages, enhancing overall team productivity.
- Participated in software field testing to verify performance of developed projects.
- Collaborated with cross-functional teams to ensure seamless integration of new features.
- Translated customer requirements into written use cases.
Business Systems Analyst
Apex Systems - Consultant, Koch Global
04.2024 - 06.2024
- As a Business Systems Analyst: Addressing business needs with technical and non-technical solutions
- Working with Product Owners to facilitate enterprise transformation
- Cloud technology expertise
- Empathy for understanding business needs
- Effective global team collaboration
- Agile methods implementation: One team practicing 2-week Sprints
- Responsibilities in Agile environment: Creating stories, epics, card updates
- Leading backlog grooming and update calls
Sr. Business Optimization Analyst
Littler Mendelson - Business Optimization
04.2023 - 11.2023
- Conduct research, analysis, and provide recommendations to support business evaluations
- Assist with project plans and documentation for business line initiatives
- Create flowcharts and diagrams using MS Visio
- Support cross-functional activities during project design and implementation
- Identify process gaps and root cause issues to drive fact-based process improvement decisions
- Prioritize and identify key performance indicators in business lines using a high level of business acumen
- Utilize essential SQL, MS Excel, and Power BI to help drive critical business decisions
Sr. Business Analyst
T-Mobile - Digital AI/ML Chatbot Performance
02.2021 - 09.2023
- Optimized chatbot performance, ensuring a seamless customer experience during the transition phase
- Created and executed leadership reports and defined use case requirements for chatbot enhancements
- Developed new AI-driven chatbot flows in an Agile environment, improving user interactions
- Led C-SAT reviews and suggested updates to enhance chatbot satisfaction
- Analyzed workflows, providing stakeholders with actionable performance feedback
- Built and updated data dashboards using Power BI, Tableau, Snowflake, SSMS, and other tools
- Managed Agile workflows via Jira and ServiceNow
Sr. Business Analyst
Sprint / T-Mobile
11.2017 - 08.2020
- Provided support for the retail workforce operations regarding store processes, workforce alignment, and training as well as compensation reconciliation
- Responsible for data management, reporting, overtime reconciliation, and workforce optimization
- Led the implementation of Kronos WFC, including gathering requirements, configuring for desktop and mobile, testing, providing training, and documenting the process
- Ensured consistent post-deployment monitoring and updates
- Gathered requirements, formed implementation teams, and provided cross-functional support
- Utilized various reporting tools, created training materials and videos, facilitated release calls, and updated workflows for a better user experience
Sr. Finance Business Analyst
Sprint
01.2016 - 11.2017
- Improved financial forecasting accuracy by conducting in-depth data analysis and implementing advanced modeling techniques.
- Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Utilized SQL, MS Excel, Power Point, and VBA
- Developed and implemented data governance policies and procedures.
- Generated standard and custom reports to provide insights into business performance.
Sr. Business Analyst - National Retail
Sprint
07.2015 - 12.2015
- Created detailed user stories for system enhancements, leading to improved functionality and user satisfaction.
- Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.
- Improved project efficiency by analyzing business processes and identifying areas for improvement.
- Conducted gap analyses to identify discrepancies between current and desired states, leading to actionable recommendations.
- Collaborated with cross-functional teams, ensuring a cohesive approach to business analysis.
- Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
- Utilized data visualization techniques to present and explain complex data sets.
Education
Master of Business Administration - Business Administration And Management
University of Saint Mary
Leavenworth, KSBachelor of Science - Business and Management
Friends University
Wichita, KSSkills
- Communication
- Business Analysis
- Leadership
- Problem-Solving
- Strategic Thinking
- Project Management
- Data Analysis
- Customer Focused
- Requirements Gathering
- Business Process Mapping
- Training and Development, Documentation
- Adaptability, Change Management
- Solutions Oriented
- Collaboration
- MS Office Suite / O365, Excel, Word, Power Point, Visio, Planner, Project, SharePoint
- Alteryx
- ServiceNow, Workday, PeopleSoft
- Salesforce
- Jira, Monday
- Power BI, Qlik, Tableau
- SQL , SSMS
- Databricks, Azure
- Google Cloud Platform
- Google Big Query, Google Looker
- Oracle (CRM Reporting), Teradata
- Mongo
- Snowflake
- Kronos WFC
- Lucidchart
- Python
- Root Cause Analysis
- Problem-solving
- Requirements gathering
- Technical support
- Project management
- Technical analysis
- Process documentation
- Big data analytics
Certification
- Lean Six Sigma Green Belt
- Kansas State Real Estate License
Languages
Spanish
Full Professional
Timeline
Business Intelligence (BI) Developer
Insight Global - Consultant, Bluescope Buildings, N.A.
07.2024 - Current
Business Systems Analyst
Apex Systems - Consultant, Koch Global
04.2024 - 06.2024
Sr. Business Optimization Analyst
Littler Mendelson - Business Optimization
04.2023 - 11.2023
Sr. Business Analyst
T-Mobile - Digital AI/ML Chatbot Performance
02.2021 - 09.2023
Sr. Business Analyst
Sprint / T-Mobile
11.2017 - 08.2020
Sr. Finance Business Analyst
Sprint
01.2016 - 11.2017
Sr. Business Analyst - National Retail
Sprint
07.2015 - 12.2015
Master of Business Administration - Business Administration And Management
University of Saint Mary
Bachelor of Science - Business and Management
Friends University