Microsoft excel
Sandra Mwale
Lusaka
Summary
Experienced professional with 13+ years in sales and business development, transitioning into business and data analysis. Highly skilled in leveraging data-driven insights to optimize business strategies, uncover opportunities, and drive decision-making. Proven track record in analyzing complex datasets, identifying market trends, and generating actionable insights. Adept at collaborating across teams to enhance business outcomes. Proficient in Python, SQL, Excel, and Tableau with hands-on experience in data cleaning, data visualization, and statistical analysis to inform strategic decisions. Passionate about using data to drive business success and improve customer satisfaction.
Overview
12
12
years of professional experience
2
2
Certification
Work History
Business Development Manager
Sodibeleng Resources (Pty) Ltd
Johannesburg
01.2019 - 11.2022
- Analyzed sales data and market metrics to optimize business strategies, resulting in a 20% increase in client acquisition and retention
- Utilized data-driven market insights to identify 200+ weekly sales leads, improving lead conversion by 15%
- Created sales reports and dashboards in Excel to track KPIs, improving decision-making and forecasting accuracy
- Lead negotiations on agreement terms, including route pricing and timelines, for both new and existing clients
- Collaborated with cross-functional teams to implement process improvements that enhanced client satisfaction and operational efficiency
Corporate Sales Executive
AMC International
Johannesburg
01.2016 - 03.2019
- Used data analysis to monitor lead generation effectiveness, significantly increasing lead generation over three years
- Conducted market research and segmentation analysis, identifying key opportunities to increase product sales
- Generated weekly reports on sales trends and customer behavior, influencing marketing strategies and significantly boosting sales
- Created and maintained a robust sales pipeline
Senior Sales Consultant
Cell C
01.2014 - 11.2015
- Managed store operations using Excel dashboards for inventory and sales tracking, resulting in a significant improvement operational efficiency
- Leveraged customer data to tailor promotions and in-store experiences, driving a notable increase in foot traffic and sales
- Ensuring excellent customer service and resolving all store issues by encouraging compliance in Cell C operational procedures
Account Manager
Riverbed Limited
03.2013 - 11.2013
- Company Overview: Microsoft Direct Enterprise Advisor (EDA)
- Managed a portfolio of high-value accounts, leveraging data analysis to track account performance and identify opportunities for revenue growth
- Utilized CRM and data management systems using Excel to maintain and update client data, ensuring accuracy for reporting and analysis
- Analyzed sales and client data to uncover trends and patterns, providing actionable insights that contributed to the signing of the Government of Zambia enterprise deal with Microsoft
- Microsoft Direct Enterprise Advisor (EDA)
Senior IT Consultant
Business Connexion
01.2011 - 02.2013
- Analyzed software usage data and ensured adherence to the T-36 True-up process providing insights that improved license compliance and facilitated contracts renewals
- Managed licensing and customer data to generate comprehensive Excel reports for executive review
- Collaborated with sales and technical teams to ensure data-driven decisions aligned with client needs, resulting in improved service delivery and client satisfaction
- Presented detailed analytical reports to high-level executives, translating complex data into clear, actionable recommendations
Education
Diploma in Business Administration -
Society of Business Practitioners
Secondary School Certificate -
Kabulonga Girls Secondary School
Certified Technology Volume Licensing Specialist: Large Organizations -
Microsoft
Skills
- Excellent analytical skills
- Data Extraction
- Data Integrity Management
- Visual Data Analysis
- Data-Driven Predictions
- Data Wrangling
- Data-Driven Trend Assessment
- Data Interpretation in Excel
- Python
- SQL
- Tableau
- Power BI Dashboard Development
- Microsoft BI
- Business Growth Initiatives
- Strategic Issue Resolution
- Client Relationship Management
- Cross-Functional Collaboration
- Effective Decision Making
Websites
Certification
- Data Analyst Bootcamp – Udemy
- Advanced Data Analytics – Google
- Business Analytics with Excel – Simplilearn
- Introduction to Data Analytics – IBM
- Business Intelligence Analyst – Udemy
References
Available upon request.
Personal Information
Nationality: Zambian
Dataanalysisproject
Sales Data Optimization Project, Data Analyst Bootcamp (Udemy), Analyzed a dataset of 19,000+ sales records using Python and SQL, identifying key sales patterns and trends that contributed to increased revenue in underperforming regions., Cleaned and analyzed large datasets with Python to perform predictive analytics on customer purchasing behavior, helping refine marketing campaigns and enhance customer engagement., Developed complex SQL queries to retrieve and analyze transaction data, resulting in actionable insights that improved sales efficiency., Designed interactive dashboards highlighting regional sales trends, optimizing resource allocation and informing targeted marketing strategies., Created visualizations in Tableau to represent customer demographics, purchase behavior, and sales trends, providing key decision-makers with critical insights for strategic planning.
Accomplishments
- Accomplished 95% renewal on time rate through data driven insights.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Location
RemoteImportant To Me
Work from home optionFlexible work hoursPersonal development programsSoftware
Customer relationship management
Microsoft enterprise software solutions
Languages
English
Native language
Interests
Microsoft excel
Data analysis
Technology trends
Business development
Timeline
Business Development Manager
Sodibeleng Resources (Pty) Ltd
01.2019 - 11.2022
Corporate Sales Executive
AMC International
01.2016 - 03.2019
Senior Sales Consultant
Cell C
01.2014 - 11.2015
Account Manager
Riverbed Limited
03.2013 - 11.2013
Senior IT Consultant
Business Connexion
01.2011 - 02.2013
Diploma in Business Administration -
Society of Business Practitioners
Secondary School Certificate -
Kabulonga Girls Secondary School
Certified Technology Volume Licensing Specialist: Large Organizations -
Microsoft
Similar Profiles
Jaden HamiltonJaden Hamilton
Account Executive at LTDAccount Executive at LTD
Aubrey BogdanAubrey Bogdan
Lead Bartender at LTDLead Bartender at LTD
Keano ThebaudKeano Thebaud
Intern at LTDIntern at LTD