Monte Evans Email & Phone Number

Dallas, Texas, Us

• Employed Power BI tools to build visualizations of the massive amount of Service Level Agreement• (SLA) Data• Developed SQL queries to extract, compile, and analyze Real Estate data to design and develop reports that identified market trends.• Created and updated formulas within data prep tools (Alteryx) used to load client files into Power Bi.• Utilized PowerPoint, Tableau, and Excel while conducting presentations which aided business partners in making data-driven decisions.

Santa Monica, California, Us

• Developed Power BI dashboards for reporting, visualizing, and analyzing the Headcount metrics.• Created info-rich bar graphs, tables, pie charts, and line charts by using Power BI and advanced Excel techniques to give an easy-to-understand overview of current resources and trends.• Facilitated daily stand-up meetings to discuss, gauge and monitor projects, and quickly resolve issues within the active projects.• Successfully developed and implemented recommendations for improvement by adjusting the Key Performance Indicators (KPIs) to more granular measurements.• Introduced and used Smartsheet software as a collaboration tool: Used for planning, tracking, assigning, and managing project progress.

Dallas, Texas, Us

Data Analyst Eximious Group (startup) - Dallas, TX June 2019 to November 2021• Employed Tableau Business Intelligence tools to build visualizations of the massive amount of Service Level Agreement (SLA) Data.• Developed SQL queries to extract, compile, and analyze Real Estate data to design and develop reports that identified market trends.• Created and updated formulas within data prep tools (Alteryx) used to load client files into Tableau.• Utilized PowerPoint, Tableau, and Excel while conducting presentations which aided business partners in making data-driven decisions.

Dallas, Tx, Us

• Identified, analyzed, and interpreted trends and patterns in complex data sets.• Used Microsoft Excel Business Intelligence tools (Power Pivot, Data model) to create and maintain financial models and dashboards.• Provided financial, budget, and business analysis support to various departments by building reports and data visualization based on analysis of data from various sourced systems.• Compared actual to budgeted results at the end of each reporting period and reported on significant variances.

Basel, Baselstadt, Ch

Medical Safety / Vision Care• Developed Tableau dashboards, scorecards, and data visualization analysis for the Global Medical Safety team to bring insight to a large amount of medical safety data• Compiled, manipulated and validated large data sets from multiple sources prior to loading the data into Tableau• Developed and initiated data-driven solutions to support Safety Data analytics and implemented Tableau reporting dashboards for safety and compliance-related KPI’s (Key Performance Indicators) to the Global Medical Safety teams• Assembled and maintained libraries of business data which was collected from various sources: individuals, data warehouses, and company documents• Demonstrated an advanced proficiency in MS Excel by using pivot tables to analyze business data and build summary reports

Basel, Baselstadt, Ch

Global Engineering • Applied knowledge of Business Intelligence tools (Power Pivot, Power Query, and Tableau) while smoothly performing extract, transform, and load (ETL) processes to data from multiple Alcon legacy systems into its new single integrated system• Reduced data extraction time from multiple days to less than an hour by programming excel (VBA) to search and extract data while looking for key phrases• Analyzed Alcon’s business data to identify defects, anomalies, and obsolete figures prior to building dashboard that contains the data.• Programmed Excel workbooks by using Power Query, Power Pivot, and VBA to build dashboards for the data visualization of the metrics gathered and assembled from various systems• Built Dashboards in excel and Tableau for different levels of recipients, based on their need or request

Basel, Baselstadt, Ch

Procurement TechOps• Developed Excel Dashboards and Reports to automate, visualize and making sense of chemical spend data within the Direct Procurement Department. Created data visualization of spending patterns while highlighting the Key Performance Indicators (KPI) of the data captured from Alcon/Novartis Data warehouses• Combined the Power of SAP Business Objects (BO) and Excel PowerPivot functionalities to simplify data manipulation, accessing, navigating, analyzing, formatting, and sharing master data extracted from SAP BW master files and other Novartis/Alcon data stores. (JDE, Access)• Participated in various Ad-Hoc projects within the Alcon Procurement Departments to identify and realize savings for the department• Eagerly and consistently acquired relevant training to stay well-informed of SAP, IRIS, Novartis/Alcon developments and improvements

Bannockburn, Illinois, Us

• Performed daily data-mining duties, which included researching, querying, extracting, importing, cleaning, transforming, validating, and modeling data (Excel, Power Pivot, Power Query, SQL).• Applied an advanced knowledge of Business Intelligence tools, applications, and methodologies to analyze data and present actionable information to help corporate executives, and decision-makers, make more informed business decisions (Advanced Excel Formulas & Functions, Power Pivot, Power Query, Power View, and Tableau).• Introduced MS PowerPivot as an alternative data-mining and analytical tool for identifying trends and spotting problems in campaigns that need to be addressed (reduced a three-day data-mining function to less than an hour).

• Conducted information-gathering sessions with interdepartmental subject-matter experts and stakeholders to acquire intelligence and perform the analysis needed to present informed actionable intelligence while making business decisions.• Monitored and tracked the access rights and privileges of users in various departments to safeguard and ensure the security of the company resources. • Insured that a user level of access adhered to the company policies, Sarbanes-Oxley (SOX) laws, and other legal requirements.• Employed PowerPoint and Tableau to report and present analyzed data to the project team and management.

Jacksonville, Fl, Us

/

Business Administration And Management, General

Computer Science