About Me
Sales Operation Analyst with experience in data analysis, business analysis, data visualization, data modeling, data cleaning and preparation, machine learning, NLP, data mining, inventory management, customer relationsh…
Sales Operation Analyst with experience in data analysis, business analysis, data visualization, data modeling, data cleaning and preparation, machine learning, NLP, data mining, inventory management, customer relationship management, supply chain management, APIs, and Google Analytics. Experienced in Python, R, SQL, SAS, Java, Graphtalk, Microsoft Excel, Tableau, PowerBI, SAP, Google Analytics, Automation Anywhere, Power Automate, and Adobe software across roles in sales operations, data analysis, data engineering, and software engineering.
Experience
Sales Operation Analyst
Utilized APIs (Target Plus API) and Python scripting to dynamically gather real-time data on baby product details from prominent retailers like Target, facilitating informed decision-making in inventory management and identifying popular products for potential growth opportunities.
Implemented weekly sales analysis with Excel Pivot Table from 5 warehouse locations across the United States, facilitating the analysis of sales performance and profit margins across a variety of brands and 1000+ products, including Mattel, Fisher-Price, and Graco.
Automated inventory outbound systems using XLOOKUP, VLOOKUP and conditional formatting, seamlessly integrating with Microsoft Power Automate to enhance operational efficiency by 85%.
Coordinated effective communication with sales specialists and conducted thorough analysis of 2000+ customer websites to understand preferences and needs, offering recommendations for baby products to drive customer satisfaction and increase sales performance.
Sales operation analyst
• Utilized APIs (Target Plus API) and Python scripting to dynamically gather real-time data on baby product details from prominent retailers like Target, facilitating informed decision-making in inventory management and identifying popular products for potential growth opportunities.
• Implemented weekly sales analysis with Excel Pivot Table from 5 warehouse locations across the United States, facilitating the analysis of sales performance and profit margins across a variety of brands and 1000+ products, including Mattel, Fisher-Price, and Graco.
• Automated inventory outbound systems using XLOOKUP, VLOOKUP and conditional formatting, seamlessly integrating with Microsoft Power Automate to enhance operational efficiency by 85%.
• Coordinated effective communication with sales specialists and conducted thorough analysis of 2000+ customer websites to understand preferences and needs, offering recommendations for baby products to drive customer satisfaction and increase sales performance.
Data Analyst
Conducted market basket analysis, customer behavior analysis, and modeling using Python to support skin care products development, resulting in a 25% upswing in skin care products sales.
Automated SQL data pipelines to preprocess and transform customer data, achieving a 42% reduction in processing time and an 18% increase in accuracy.
Developed impactful Tableau dashboards revealing annual sales trends, top sellers, and geographic insights, leading strategic decision-making for stakeholders to instigate actionable changes to product combinations and business strategies.
Data Engineer/Analyst
Developed visualizations and reports using Tableau and Excel that were used by clients from different industries to make data-driven decisions, resulting in a 18% increase in operational efficiency.
Optimized and automated data cleansing, extraction, and analysis processes using SQL, resulting in a 25% reduction in data errors and inconsistencies.
Pioneered Machine Learning like Multiple linear regression and RPA, boosting talent acquisition efficiency by 23% in employee sourcing during the pandemic through external data extracting, cross-referencing, talent acquisition, and predictive modeling.
Collaborated with diverse industries to identify process optimization through consultative methodologies and RPA integration, delivering efficiency improvements ranging from 22% to 30% across diverse sectors.
Software Engineer
Analyzed users' ad-hoc data requests and developed GraphTalk scripts to extract specific clients’ data, facilitating the process of data verification.
Modified production-level code, such as transforming routine ad-hoc requests into system-integrated functionalities to ensure accurate data extraction, resulting in a significant 66% efficiency improvement for users retrieving data.