Business Intelligence Data Analyst
Resume:
Ariel Soto
***********@*****.***
www.linkedin.com/in/ariel-soto-a095a5143 Bachelor's in Business Data Science - University of Havana - Havana, Cuba 2010 US Citizen
Sr. Business Development Business Analyst Tableau, Power Bi, SQL, Oracle Data Analyst Sr. Business Intelligence API Integration Multi-Domain Expertise
Results-driven Business Intelligence and Data Analytics professional with 8+ years of experience delivering transformative solutions for Fortune 500 companies. Expertise in designing and implementing streamlined data integration processes, enhancing operational efficiency by up to 40% and reducing processing times across diverse business functions. Proven ability to optimize data workflows, ensuring accuracy, governance, and real-time insights for strategic decision-making.
Exceptional at developing scalable analytics frameworks, automating reporting processes to reduce manual effort by over 50%, and leading cross-functional teams to align data initiatives with organizational goals. Skilled in identifying trends, uncovering actionable insights, and driving improvements in customer satisfaction, operational efficiency, and business outcomes.
Adept at managing complex, high-impact projects under tight deadlines, while delivering tailored solutions that drive enterprise-wide access to critical insights. Renowned for blending business acumen with technical expertise to meet strategic goals and foster continuous improvement across Finance, HR, Supply Chain, and Customer Service functions.
Key Responsibilities and Achievements
Apple Inc - Cupertino, CA Jan 2024- Dec 2024 (W2 Contract)
Sr. Business Intelligence Analyst HR I&D
Led the transition of existing Tableau dashboards to new data sources, incorporating accessibility improvements and creating new dashboards tailored to evolving business needs, significantly boosting stakeholder engagement and understanding.
Configured custom validation messages in Qualtrics to provide respondents with clear guidance on correcting invalid or incomplete responses, reducing the likelihood of data entry errors and enhancing data integrity.
Optimized labor force benchmarking and workforce data analysis by developing SQL queries and integrating Workday systems, supporting data-driven HR decisions and enhancing strategic planning across the organization.
Conducted comprehensive ad-hoc analyses, creating custom reports, Tableau dashboards, presentations, and technical documents to address urgent data requests and support strategic initiatives within the Inclusion & Diversity framework.
Leveraged Wrike to manage analytics projects, streamlining task tracking and collaboration for the analysis and interpretation of both qualitative and statistical I&D data, leading to actionable global recommendations that enhanced workforce inclusivity and equity.
Maintained rigorous data quality standards using Wrike to monitor progress and ensure reliability of analyses and insights, fostering a culture of trust and accuracy in data handling.
Improved data integrity and compliance in HR processes by implementing SQL constraints, configuring Qualtrics validation messages, and tracking data quality initiatives through Wrike, reducing errors and enhancing workforce analytics accuracy.
Utilized Wrike for seamless coordination with the I&D analytics team, becoming a trusted advisor by delivering industry-specific insights and driving impactful Inclusion & Diversity strategies.
Utilized a diverse toolkit including Numbers, Microsoft Excel, Wrike, Keynote, Qualtrics, Tableau, and Snowflake, contributing to a highly efficient and flexible analytics environment.
Developed and maintained robust API connections to facilitate seamless data integration from various systems (HRIS, internal databases) into Tableau, ensuring real-time data availability and consistency in reports.
Integrated Wrike with other project management tools to centralize project tracking, enabling a more streamlined approach to managing complex data models and ensuring consistent progress monitoring.
Implemented response quality checks using Qualtrics’ tools, such as attention checks, speed traps, and consistent response monitoring, to identify and filter out low-quality or unreliable survey responses, ensuring a higher standard of data accuracy.
Implemented advanced Tableau functionalities to visualize complex I&D data, providing clear, actionable insights into workforce diversity, equity, and inclusion efforts, which supported global strategy formulation.
Collaborated closely with the I&D team to translate data-driven insights into visual stories, making extensive use of Tableau’s dynamic and interactive dashboard capabilities to tailor presentations for executive leadership.
American Express - New York, NY 2022 – 2024 (Full Time)
Sr Business Data Analyst TLS
Integrated Tableau reports as primary data sources and transformed them into advanced, interactive dashboards in Power BI, enhancing the visibility and accessibility of key business metrics.
Collaborated with stakeholders to design and implement scalable Snowflake schemas, improving data consistency and enabling efficient querying for customer and operational metrics.
Led the development of advanced data models that merged TLS and Expedia data, facilitating product enhancements by providing a comprehensive view of customer booking behaviors, which directly influenced R&D efforts in improving service offerings.
Applied advanced data profiling techniques using SQL queries to analyze column-level statistics, detect patterns, and identify inconsistencies across large datasets.
Write custom scripts in Python or SQL to calculate key profiling metrics, such as null counts, distinct values, and duplicate detection.
Integrated Tableau reports into Power BI dashboards, enhancing the visibility and accessibility of key business metrics, leading to improved decision-making based on statistical data insights.
Utilized SQL queries to extract HR data from Workday, producing statistical reports that informed strategic decisions in workforce planning and talent management.
Partnered with CRC, Claims, Sales, and Provider Ops to identify and implement process enhancements that elevated the customer service experience.
Conducted in-depth analysis using Speech Miner and Nexidia to extract actionable insights from customer interactions, driving improvements in service quality through data-driven statistical evaluations.
Collaborated with IT and business units to integrate RPA solutions, driving innovation in product development by automating repetitive tasks and freeing up resources for more strategic R&D initiatives.
Partnered closely with Expedia to access and incorporate their booking data into AMEX’s TLS reporting ecosystem, leading to the creation of more accurate and comprehensive reports that accounted for external booking trends.
Developed and managed complex data models that merged TLS and Expedia data, providing a holistic view of customer booking behavior and enabling more precise forecasting and resource allocation while tracking model development and updates using Wrike for streamlined project management.
Leveraged ServiceNow and Wrike to track and manage project milestones and deliverables for data integration initiatives, ensuring timely completion and alignment with business goals across HR and IT functions.
Regularly interacted with directors and other senior executives, utilizing Wrike to organize and prioritize tasks, ensuring the delivery of tailored reports and insights that supported high-level strategic initiatives.
Northwestern Mutual - Milwaukee, WI 2021 – 2022 (Full Time)
Sr. Business Analyst Speech Analytics
Experience working with the Customer services and speech Analytics team, building reports, and utilizing Nexidia (Nice) tool to create speech queries that listened to conversations between the customer services team and clients to identify business opportunities for improvement.
Led efforts to streamline data workflows between Salesforce and other analytics tools like Nexidia and Genesys, ensuring seamless integration for enhanced customer insights and service delivery improvements.
Performed detailed data mapping to establish clear relationships between source and target systems, ensuring seamless data integration and transformation across diverse platforms.
Utilized Salesforce’s CRM capabilities to capture and analyze customer service interactions, identifying trends and business opportunities for improving client engagement strategies.
Developed and optimized SQL-based reporting systems within Power BI to support R&D efforts, enabling the real-time analysis of key metrics such as Customer Effort Score (CES) and Net Promoter Score (NPS), which directly influenced product development decisions.
Leveraged Genesys Cloud's advanced analytics tools to conduct deep-dive analyses of speech and text interactions, enabling the identification of key customer sentiments and trends. This work directly contributed to the optimization of interaction strategies and improved overall customer experience metrics.
Developed custom dashboards within Salesforce to monitor key customer service performance indicators such as Net Promoter Score (NPS) and Customer Effort Score (CES), enabling data-driven decision-making.
Compiled, maintained, and developed database systems for tracking tailored content reports.
Prepared targeted documentation, specifications, and resources to analyze business data.
Automated BI reports for secure virtual server environment using Microsoft Power BI as the main reporting tool.
Designed and implemented efficient data models to optimize database structures, support complex queries, and enhance overall performance for business intelligence solutions.
Analyzed and tracked data to prepare forecasts and identify trends.
Collaborated with quality, risk management and other teams to identify process improvement opportunities based on in-depth BI reviews.
ABM Industries Inc. 2021 (6 months contract) The Intersect Group
Sr Analyst Product Development
Served as the primary point of contact for the customer service team during the ERP migration project, working closely with Infosys to transition data and processes into Oracle seamlessly.
Leveraged Dynamics 365 Business Central to automate and optimize financial workflows, enhancing accuracy and reducing processing time
Conducted extensive data validation using SQL Server and Excel, ensuring accuracy by reviewing records and reaching out to clients for verification of critical customer information.
Spearheaded the implementation and enhancement of Power BI dashboards, providing real-time insights into procurement activities.
Executed data profiling techniques to analyze large datasets, uncover anomalies, and validate data accuracy, driving improvements in data quality and usability.
Developed advanced data modeling solutions to streamline database architecture, enabling efficient storage, retrieval, and reporting of critical business information.
Performed detailed data mapping to establish clear relationships between source and target systems, ensuring seamless data integration and transformation across diverse platforms.
Utilized SQL Server Management to maintain, troubleshoot, and optimize databases, ensuring high availability, data integrity, and performance across enterprise systems.
Partnered with Infosys and internal teams, using Jira to manage workflows, document issues, and monitor the migration process to ensure data integrity and system readiness.
Led the supplier relationship management efforts, establishing effective communication channels to collect green spend data from various vendors.
Implemented data review protocols and logged data-cleansing tasks in Jira, improving the accuracy and reliability of customer service records during the ERP transition.
Automated data processing tasks using Excel’s built-in macros and formulas, significantly reducing manual errors and improving the accuracy and efficiency of routine reporting tasks.
Implemented data normalization processes across multiple suppliers to standardize data formats, ensuring consistency and uniformity in the supplier data set(s).
Collaborated with the Procurement Continuous Improvement Manager to develop and enhance the supplier catalog infrastructure, enabling the identification and reporting of green spend at a transactional level within the Source-to-Pay (S2P) environments.
Successfully transitioned the project from Phase 1 to Phase 2 by automating green spend data extraction via an API, reducing manual efforts and improving reporting efficiency.
Leveraged Power Automate to streamline reporting processes by connecting enterprise systems, achieving a 55% reduction in manual effort for report updates and significantly improving efficiency.
INNIO Waukesha Gas Engines - Waukesha, WI (Full Time)
Sr. Business Analyst/Data Analyst
Creating visualizations for the data extracted using various versions in Tableau Desktop, Tableau Online, and Power BI.
Managed and optimized databases using SQL Server Management, implementing indexing, partitioning, and backup strategies to ensure system reliability and scalability.
Conducted precise data mapping to align disparate data sources with organizational standards, ensuring accurate and consistent information flow between systems.
Integrated ServiceNow with Workday to streamline incident management and automate workflows, improving efficiency across financial and supply chain operations.
Integrated Salesforce data into Tableau to redesign, enhance and automate current supply chain reports.
Utilized Workday’s reporting and analytics features to generate real-time insights, aligning supply chain strategies with financial objectives and enhancing decision-making processes.
Optimized execution of supply chain by forecasting, scheduling orders, and balancing inventory levels creating histogram, scatter plots, and other types of visual interpretation to help identify patterns in our data.
Used analytical models and mathematical analysis to create and maintain key performance metrics through DAX, LOD, and SQL.
Analyzed and documented company processes for executive leadership and suggested areas for improvement.
Developed and maintained custom dashboards in Workday, using data from ServiceNow to monitor and optimize operational performance metrics in financial and supply chain management.
Utilized Oracle DBA, SQL Server, and Oracle Application to conduct analysis.
Analyzed key aspects of the business to evaluate factors driving results and summarized them into presentations using Power Bi, Salesforce and Tableau.
Conducted interviews with key business users to collect information on business processes and user requirements.
Managed multiple projects with a high degree of accuracy and attention to detail.
Documented projects development methodologies in technical manuals to be used by team members in future projects.
Northern Trust - Chicago, IL – 2 months Part Time contract 2022 (contract) The Judge Group
Sr. Business Data Analyst Power Bi Developer
Developed a sophisticated Power BI report analyzing employee cost per usage by integrating multi-dimensional datasets, incorporating real-time cost allocation models, and providing actionable insights to optimize resource utilization and operational efficiency.
Reverse-engineered existing Power BI reports to create comprehensive documentation for seamless knowledge transfer to the offshore reporting team
Supported leadership team with reporting, analysis, and business presentations to inform divisional
strategies using tools such as Power Bi, Microsoft Teams List, SQL Server, and inhouse applications.
Created detailed documentation of report structures, data sources, and metrics to enable the offshore team to maintain and enhance reporting capabilities.
Designed customized data collection models for specific visualization tasks.
Developed a comprehensive Power BI report integrating data from multiple internal tools to provide a unified view of investor activities, enhancing visibility and tracking capabilities.
Provided a high level of BI knowledge to recreate, and document existing complex reports on my own,
fixing multiple errors in the data model and DAX measurements.
Supported the organizational transition to a fully offshore reporting model by ensuring clear and actionable documentation for the India-based team.
Funko - Utah 2021
IT Business Analyst
Spearheaded sales data cleanup initiatives, addressing inconsistent and messy customer data to ensure accuracy and reliability for reporting and analytics.
Defined and tracked key sales performance indicators by identifying critical data sources and standardizing metrics.
Collaborated with stakeholders across departments to align sales analytics with business goals and technology requirements.
Developed and maintained sales analytics dashboards, providing actionable insights to drive strategic decision-making and improve sales performance.
Translated business needs into technical requirements, ensuring IT development efforts aligned with organizational objectives.
Conducted extensive data validation and applied quantitative analysis to produce accurate, visually compelling sales reports and presentations.
Utilized Jira to manage deliverables, track implementation progress, and meet deadlines during the ERP migration project, ensuring seamless integration with sales operations.
Source Medical – Milwaukee, WI 2015 – 2018 (Full Time)
Data Analyst
Designed and delivered customized, interactive sales reports and dashboards, providing clients with actionable insights on lab services, medical devices, and client acquisition metrics.
Conducted in-depth analysis of sales drivers and key revenue performance metrics for lab services and device sales, supporting data-driven decision-making and strategic planning.
Collaborated with cross-functional teams and clients to align reporting outputs with business goals, tailoring insights to enhance client acquisition and retention strategies.
Maintained strict confidentiality and data integrity, adhering to company protocols while handling sensitive client and organizational data.
Developed and presented data-driven insights for clients, leveraging BI tools to showcase sales performance, market trends, and opportunities in lab services and medical devices.
Contact this candidate