Alberto Sandoval Email & Phone Number

Fremont, Ca, Us

Woodland, Ca, Us

o Utilized SQL to extract, manipulate, and analyze data from Oracle databases to provide insights into business performance.o Developed complex SQL queries to retrieve specific data sets and perform data validation tasks.o Applied SQL functions and joins to merge multiple datasets for comprehensive analysis and reporting.o Leveraged Power BI to create dynamic and visually appealing dashboards that highlight trends, patterns, and anomalies in business data.o Transformed raw data into compelling visualizations and interactive reports using Power BI's drag-and-drop interface and DAX expressions.o Collaborated with stakeholders to understand data visualization requirements and deliver solutions that drive informed decision-making.o Facilitated meetings with business users to gather and document requirements for data analysis and reporting projects.o Translated business requirements into technical specifications and user stories, ensuring alignment with project objectives.o Utilized SQL queries to perform data profiling and analysis, informing the development of comprehensiverequirements documents.o Conducted data validation and reconciliation activities using SQL scripts and queries to ensure data integrity and accuracy.o Collaborated with database administrators to implement data quality checks and constraints within Oracle databases.o Developed SSIS packages to automate data cleansing and transformation processes, improving data reliability and consistency.o Acted as a liaison between business users, IT teams, and management to facilitate communication and ensure project alignment.o Presented findings and insights derived from SQL queries, SSRS reports, and Power BI dashboards to stakeholders in clear and understandable formats.o Solicited feedback from stakeholders to iteratively refine and enhance data analysis solutions, driving continuous improvement.

San Jose, Ca, Us

o Utilized SQL queries to extract, transform, and analyze data from Epicor ERP databases, ensuring data accuracy and integrity.o Developed complex SQL scripts and stored procedures to address specific data analysis requirements and business inquiries.o Conducted ad-hoc data analysis using SQL to support decision-making processes and identify actionable insights.o Acted as a subject matter expert for Epicor ERP, providing support to end-users and troubleshooting system issues.o Collaborated with IT teams to customize and configure Epicor ERP modules to align with business processes and requirements.o Conducted system UAT to ensure the successful implementation of ERP enhancements and upgrades.o Designed and developed interactive dashboards and reports using Tableau and Power BI to visualize key performance indicators (KPIs) and business metrics.o Integrated data from multiple sources into Tableau and Power BI for comprehensive analysis and reporting.o Translated business requirements into technical specifications and user stories, ensuring alignment with project objectives and timelines.o Conducted gap analysis to identify discrepancies between current business processes and system capabilities, proposing solutions to bridge the gap.o Conducted data validation and reconciliation activities within Epicor ERP to ensure data accuracy and consistency.o Developed and executed test cases to validate ERP system functionality and configurations, identifying and resolving issues proactively.o Implemented data quality checks and controls to maintain the integrity of data stored in Epicor ERP databases.o Communicated project updates, status reports, and deliverables to stakeholders, ensuring transparency and alignment with project goals.o Collaborated with cross-functional teams, including IT, finance, and operations, to prioritize and address business needs effectively.

St Petersburg, Florida, Us

o Utilized SAP ERP to monitor and manage inventory levels, ensuring alignment with target stock levels and customer demand.o Conducted regular inventory analysis to identify excess or obsolete inventory, implementing strategies to minimize holding costs and optimize inventory turnover.o Developed and maintained inventory planning models in Excel, leveraging VBA for automation and optimization.o Designed and developed inventory reports and dashboards using Power BI to visualize key performance metrics such as stock levels, turnover rates, and fill rates.o Integrated data from SAP ERP and other sources into Power BI for comprehensive analysis and reporting.o Conducted root cause analysis to identify inventory discrepancies and implement corrective actions.o Streamlined inventory management processes through the development of Excel-based tools and VBA macros, reducing manual effort and improving accuracy.o Implemented process improvements in SAP ERP, such as cycle count frequency adjustments and inventory classification enhancements, to optimize inventory accuracy and efficiency.o Led a team of two cycle counters, providing guidance and support to ensure accurate and timely cycle counting activities.o Conducted training sessions for cycle counters on inventory management best practices, SAP ERP functionality, and use of Excel tools.o Oversaw cycle counting processes, ensuring compliance with inventory control policies and procedures.o Collaborated with cross-functional teams, including procurement, production, and logistics, to coordinate inventory replenishment and allocation activities.o Communicated inventory-related insights and recommendations to senior management and key stakeholders, facilitating data-driven decision-making.o Acted as a liaison between inventory management and other departments, addressing inventory-related issues and driving continuous improvement initiatives.

St Petersburg, Florida, Us

o Leveraged Infor Visual Mfg and SAP systems to analyze supply chain data including inventory levels, procurement activities, and production schedules.o Developed comprehensive reports and dashboards using Power BI to visualize key supply chain metrics such as lead times, supplier performance, and inventory turnover.o Utilized advanced Excel functions and VBA macros to automate data extraction, cleansing, and analysis processes, improving reporting efficiency.o Conducted inventory analysis to identify excess or obsolete inventory, implementing strategies to minimize holding costs and improve inventory turnover ratios.o Collaborated with cross-functional teams to develop and implement inventory optimization initiatives, such as demand forecasting enhancements and ABC inventory classification.o Supported procurement activities by analyzing supplier performance metrics, monitoring purchase orders, and managing supplier relationships within Infor Visual Mfg and SAP ERP systems.o Conducted supplier performance evaluations and contract negotiations to optimize procurement costs and ensure supplier compliance with quality and delivery requirements.o Developed procurement reports and scorecards to track key performance indicators (KPIs) such as on-timedelivery rates, cost savings, and supplier lead times.o Played a key role in an ERP migration project from Infor Visual Mfg to SAP, serving as a subject matter expert for supply chain processes and data migration requirements.o Collaborated with IT teams to map existing supply chain workflows and data structures in Infor to corresponding modules and data objects in SAP.o Conducted user acceptance testing and provided training and support to end-users during the transition from Infor Visual Mfg to SAP.o Communicated project milestones and risks to stakeholders, ensuring alignment with project timelines.o Acted as a liaison between supply chain, IT, and finance teams, addressing issues and coordinating solutions.

St Petersburg, Florida, Us

Administered and maintained enterprise-level applications, including Infor Visual ERP and collaboration tools, ensuring optimal performance and reliability.Installed, configured, and upgraded application software and patches, adhering to best practices and security standards.Managed ERP user access and permissions, to ensure data security and SOX compliance.Monitored application performance and capacity, proactively identifying, and resolving issues to minimize downtime and disruption to business operations.

St Petersburg, Florida, Us

Provided timely and effective troubleshooting and technical support to end users, resolving hardware and software issues promptly.Planned and completed network and domain migrations successfully per corporate policies and standards with minimal downtime.Managed and maintained inventory of IT equipment and software licenses, ensuring accurate records and timely replenishment.Conducted regular system updates and patches, optimizing network performance, and minimizing downtime for users.

St Petersburg, Florida, Us

Conducted thorough inspections of Finished Goods, Work in Progress and purchased components to ensure compliance with quality standards and CAD specifications.Identified and documented defects, irregularities, and deviations from requirements, providing detailed reports and recommendations for corrective action.Collaborated with engineers, production managers, and other stakeholders to address inspection findings and implement improvements.Provided training and guidance to operators and maintenance personnel on proper equipment usage, maintenance procedures, and quality standards.Conducted dimensional and visual inspections, performed tests, and recorded inspection results using computerized systems.

Inspected incoming materials, components, and finished products to verify conformance with quality standards and specifications.Conducted dimensional and visual inspections, performed tests, and recorded inspection results using computerized systems.Coordinated procurement activities for a wide range of goods and services, ensuring timely delivery and cost-effectiveness.Negotiated contracts and terms with vendors to optimize pricing, terms, and conditions while mitigating risks.Managed supplier relationships and resolved disputes or conflicts to maintain positive partnerships.