Juan Orozco Email & Phone Number

New Orleans, La, Us

o Power BI Dashboards: Designed, developed, and maintained interactive Power BI dashboards that turned complex data sets into clear, actionable insights. Integrated multiple data sources to provide real-time business performance visualizations.o DAX Coding: Used DAX (Data Analysis Expressions) to write advanced calculations and measures, optimizing data models and enhancing the functionality of Power BI reports.o Machine Learning Models: Built machine learning models with Python and Scikit-learn, focusing on predictive analytics and solving key business challenges. Performed model training, testing, and evaluation to ensure accuracy and reliability.o Data Preprocessing: Applied Python for efficient data preprocessing, reducing processing times significantly while ensuring data quality. Focused on data cleaning, transformation, and feature engineering to streamline workflows and deliver results in a timely manner.o Data-Driven Decision Support: Collaborated with cross-functional teams to understand business needs, providing analytical support and delivering actionable insights that influenced key strategies and decisions.o Timely Results: Streamlined data workflows, optimizing processing times without compromising on quality, enabling faster insights and timely decision-making across teams.

Louisville, Kentucky, Us

o Supported multiple tools in Power BI, Power Automate, and Power Apps for the IT ATX Team. Updated and simplified DAX expressions in Power BI, to make tools more reliable and easier to maintain. Developed DAX expressions using Calculate, Filter, and other advanced Power BI features.o Managed Workspace schedule refreshes and access rights for internal teams on Power BI Server. o Used SQL to analyze and process data from internal data lakes to be used on dashboards. o User Power Query to model relations and incorporate relational data models for complex dashboards. Updated queries on Advanced Editor to simplify and document intake process for Power BI, to make tools easier to maintain and understand for other developers. o Worked with internal clients on requested updates and modifications for Power Apps and Power Automate Flows, to reflect changes in processes needed on the Employee On-Boarding and Internal Transfer programs.

Montreal, Quebec, Ca

o Implemented business layer on Power BI for multiple reports for FMBT. Used SQL to pull data and replicate complex data joins or data filtering where necessary. o Worked with Business Analysts to guarantee client’s satisfaction on business requirements for reports, business layers and dashboards. o Documented data model including tables, primary and foreign keys to ease the replication of joins across multiple reports.

Montreal, Quebec, Ca

o Tableau dashboard development following Agile principles. Advanced use of Tableau features like parameters, calculated fields, dashboard actions (URL, filtering), joins, extracts. o Performed data scrubbing, ETL, and analysis of data using python packages like Pandas and numpy. o SQL (AWS, PostgreSQL) Partitions, subqueries, grouping functions, common table expressions. o Provided guidance to other analysts on dashboard best practices. Assisted with SQL query debugging and optimization to guarantee speedy access and ease of maintenance of data source in the long term. o Documented data model from various sources in order to better understand existing queries, and shorten development times on new queries.o Created intuitive and easy-to-use dashboards and presented results of analyses to the VA Board of Appeals. o Improved response times and reliability of dashboards by creating efficient and easy-to-maintain SQL queries on ETL layers. Developed common table expressions in PostgreSQL as data inputs to dashboards. o Used python scripts to interact and analyze AWS data sources and generate data extracts, as an alternative to SQL queries. o Provided guidance to other analysts on dashboard best practices. Assisted with SQL query debugging and optimization to guarantee speedy access and ease of maintenance of data source in the long term. o Implemented dashboards with advanced features such as parameters, level-of-detail calculations and dashboard actions.o Trained junior developers on advanced Tableau features and SQL queries. o Managed users list to dashboards and Power BI reports. Developed python script to manage user list for FMBT’s reports.

San Jose, Ca, Us

Austin, Tx, Us

o Improved queries and reduced running times by analyzing table relations, and documenting data model. Reduced running times for some Alteryx processes from 30 minutes to 2 minutes by optimizing SQL queries. Used Teradata common table expressions to make SQL code easy to maintain, debug, and understand by other analysts.o Improved data warehouse storage issues by optimizing table indexing. Trained analysts on Teradata indexing practices and diagnosing high “skew” storage issues. o Worked with other data engineers in preparing queries as inputs for Tableau dashboards.

St Paul, Mn, Us

Managed all reporting processes for the Valuestream supply chains, including data gathering, dashboard design, VBA scripting, and dashboard publishing. Coordinated requirements, deadlines, and priorities with stakeholders. o Reduced dashboard production times by automating import data processes for multiple regional formats.o Improved reliability of overall reporting processes by reducing legacy code by 90% using Access and Excel VBA.o Implemented multiple summary SQL queries through several stages of the data flow, assuring data quality.o Expanded the reporting capabilities for various internal clients by using Agile development methodologies.o Consolidated 88 separate SQL queries into 6 customizable SQL queries using VBA, streamlining various data processes and reducing maintenance requirements.

Westlake, Texas, Us

Designed and implemented all Tableau dashboards for the Next Best Conversation program. o Provided guidance to Schwab executives by analyzing call center performance in multiple metrics and providing analysis and results via Tableau dashboards.o Helped call center managers monitor their personnel KPI’s by designing and implementing call center operations dashboards. Summarized results at various levels of the organization using hierarchies, and allowed “drilling down” to explain main trends.o Performed statistical analysis using internal and external data, providing insights on Schwab’s call center performance. Extracted data using SAS and SQL.o Designed and deployed Tableau dashboards catered to different audiences (for executive and operations levels). Used features such as hierarchies, filters, calculated fields, and parameters in Tableau.o Developed advanced queries in Teradata SQL and SAS, retrieving data for dashboards from data warehouse. Wrote multiple procedures and macros in SAS, to automate queries and speed up reports. Implemented SQL queries in Tableau to retrieve data from Teradata data warehouse.o Used SAS to perform decisions trees and cluster analysis on caller profiles, identifying crucial dimensions that drove customer response in the call center.o Coached team members on analytics and dashboarding best practices, providing a consistent end-user experience.

Round Rock, Texas, Us

o Wrote advanced queries in SQL, analyzing Dell’s consumer market performance and trends in retail and direct channels.o Updated dashboards on Dell’s retail and direct consumer channels, providing leadership with main market trends.o Provided insights to management through advanced analytics performed in their customer data including decision trees and cluster analysis. Reported multiple metrics on monthly dashboards.

Boston, Massachusetts, Us

Managed an entire project to reconcile background checks for all active and past employees of the company, encompassing 170K+ employee history records, and OCR (optical character recognition) generated records from existing paper forms.o Used various text/fuzzy matching algorithms implemented in VBA, in order to fulfill FDIC regulations.o Matched over 95% of all employees’ records to background records using a variety of fuzzy matches and text-matching algorithms implemented in VBA/Excel and Access.o Minimized potential data issues by developing text matching algorithms that considered misspellings, date formatting alternatives, and duplicate and inaccurate data.o Maintained stakeholders informed on the progress of the project with the implementation of dashboards in Tableau.

Boston, Ma, Us

Improved the Pricing team’s performance and productivity by automating various data processes using Excel VBA.o Reduced production times from 6 months to 1 month for multiple tools by leading meetings with Pricing team analysts to understand their requirements and align them with development priorities.o Improved the Pricing team’s productivity by implementing over 25 different tools that automated multiple data processes including data import, analysis, report generation, printing, saving backups, and report emailing.o Developed an Excel file-scanning tool that scanned multiple Excel files at a time, and identified potential compatibility issues when transitioning to new version of Excel. Reviewed over 2000 files with tool and reported those that needed manual remediation.

o Improved clients’ productivity by automating various data import, analysis, reporting and exporting processes in Excel/VBA.o Consulted for clients to understand their business needs, and developed data processes and tools to fulfill those needs.

Redmond, Washington, Us

Produced market intelligence and insights to influence business decisions through the understanding of the PC market.o Partnered with various levels of the organization to define and structure market research plans, assuring alignment with corporate strategies.o Developed dashboard-like presentations, reporting on main PC market trends to various levels of the organization. o Developed quantitative models to estimate Linux-based netbook shipments by region, assessing Microsoft’s risk and potential market share erosion of Windows licenses.o Analyzed Windows licensing results on a monthly basis, providing insights to executives using PowerPoint dashboards.

Needham, Massachusetts, Us

o Designed and implemented all data processes for the Worldwide Black Book; IDC’s premier IT spending database. Improved productions times for the Black Book from multiple weeks down to less than 1 hour, using VBA procedures in Excel.o Redesigned overall data platform and processes for the Worldwide Black Book. Implemented new data tools to collect data from research sources.o Transitioned the Black Book’s format from hard copy to digital format, eliminating printing costs and allowing last minute changes in data to be incorporated in a timely manner.

Ms, Marketing Analytics

Mba

Bs, Industrial Engineering