Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
AgData Global, LLC - Scaroni Family of CompaniesPayroll Lead
Jun. 2019 - Feb. 2024Heber, California, United States➔ General Supervision of 5 employees; Advanced use of Google Sheets Pivot Tables, VLookUps and SumIFs to manage payroll balances and data entries.
➔ Prepared and cleaned data by removing duplicates and using the TRIM function to eliminate excessive white spaces.
➔ Leveraged SQL queries to extract and join payroll data from Picktrace (Payroll Database) for processing more than 2,500 employees a week.
➔ Independently maintained 100% accuracy in transferring correct data from payroll spreadsheets into our Famous Software by utilizing SQL queries with BETWEEN Operator in order to track changes and modifications.
➔ Created and maintained interactive Tableau Dashboards and Stories using filters to easily show stakeholders powerful insights into their weekly payroll.
ALGODONERA CACHANILLA, S.A. DE C.V.Business Analyst
Feb. 2015 - Jun. 2019Mexicali, Baja California, Mexico➔ Utilized advanced Google Sheets formulas such as SUMIFs, VLOOKUPs, and pivot tables to analyze sales and inventory data, increasing reporting efficiency by 30%.
➔ Developed and maintained SQL databases using queries, join formulas, and window functions to extract critical data, streamlining reporting and improving data accuracy.
➔ Built interactive dashboards in Tableau and PowerBI to visualize key metrics, reducing time spent on manual reporting by 40%.
➔ Collaborated with cross-functional teams to identify data-driven insights, facilitating strategic decision-making processes and improving cotton export strategies to Japan.
➔ Created automated workflows and data models that saved 15+ hours per week in manual processes, enhancing operational efficiency.
➔ Conducted thorough data analysis on sales trends, forecasting demand, and optimizing inventory levels to minimize waste and maximize profitability.
➔ Effectively communicated complex data findings to non-technical stakeholders, simplifying insights and enabling informed decision-making across various departments.
Intch is a Professional Networking App for the Future of WorkSee more people like Jose Alberto on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
453430 people
18
Technologist, Project/Program Manager
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
126726 people
18
Technologist, Project/Program Manager
15
Data Analyst
24
Looking to transition into Tech./. Former sales Representative and have very good Communication skilss @ @NikeStore