Data Analyst Analysis

JOHNSON AMARIKWA

+1-832-***-**** Katy, TX ***** **********@*****.***

https://www.linkedin.com/in/johnsonamarikwa-18b818250/ PROFESSIONAL SUMMARY Results-driven Data Analyst with a proven track record in data analytics, statistical modeling, and data visualization across diverse industries. Skilled at transforming complex datasets into clear, actionable insights that enhance decision-making, optimize business processes, and drive growth. Experienced in leading data-focused projects, from data cleaning and analysis to delivering key insights to stakeholders, ensuring strategic alignment with business objectives. Adept at collaborating with cross-functional teams, including product, marketing, and executive leadership, to ensure data solutions support organizational goals. Currently seeking an opportunity within a dynamic, forward-thinking organization to apply analytical expertise and contribute to impactful, data-driven decisions. CORE COMPETENCIES Data Analysis and Exploration Python SQL Data Cleaning and Preparation Statistical Knowledge Data Visualization IBM Cognos Microsoft Excel Dashboard and Report Creation Writing and Communication Problem Solving Project Management Machine Learning Linear Programming ARIMA Model Forecasting Data-Driven Decision Making Business Analysis Customer Satisfaction Analysis Predictive Analytics Resource Optimization Microsoft Excel Solver R Shiny Python Dash Data Storytelling Performance Tracking Analytical Thinking Forecasting Models Trend Analysis Operational Efficiency Team Collaboration Workflow Optimization Critical Thinking Competitive Analysis Business Process Improvement PROFESSIONAL EXPERIENCE Data Analyst Aug 2024 - Present

Freelance

● Spearhead and execute multiple end-to-end data analysis projects for clients across diverse industries, utilizing statistical techniques to uncover critical insights that optimize business strategies, enhance operational workflows, and contribute to significant revenue growth.

● Develop and deploy interactive dashboards using Tableau and Power BI, allowing clients to monitor real-time KPIs and make informed strategic decisions more quickly.

● Clean and transform large datasets to ensure data accuracy, resulting in more precise reporting and improved analysis outcomes across multiple projects.

● Build predictive models using machine learning algorithms to forecast trends, optimize marketing strategies, and improve client business operations in areas like sales and supply chain management.

● Automate data processing and reporting workflows with Python and SQL, reducing manual tasks by 40% and increasing efficiency for clients in real-time data analysis.

● Collaborate with marketing, sales, and product teams to align data-driven insights with business objectives, significantly improving performance in key areas such as customer acquisition and retention.

● Create visually impactful data visualizations and reports that simplify complex data findings, enabling key stakeholders to make informed, data-backed decisions.

● Conduct detailed data audits and quality checks, improving data accuracy by 20% and reducing errors in client reporting systems.

● Deliver comprehensive data reports and strategic recommendations that help clients improve their operational efficiency and increase revenue by up to 15%.

Western Digital jan 2023 - july 2024

Data Analyst / Bi Developer

• Developed continuous monitoring protocols for data quality within BI dashboards, ensuring that stakeholders had access to accurate and up-to-date information at all times.

• Created stored procedures and SQL queries to pull data into Power Pivot models, improving reporting efficiency by at least 30%.

• Led the migration of over 50 reports from the internal legacy analytics infrastructure to the Tableau environment, reducing costs by over 30%.

• Developed automation pipelines for real-time and near-real-time analytics solutions.

• Applied statistical software packages, such as Python, R, and SAS, to conduct investigations, evaluate root causes, and present recommendations for resolving complex issues.

• Designed and implemented dashboards in Tableau and Power BI to visualize key performance indicators, enhancing decision-making capabilities for stakeholders.

• Conducted extensive data analysis to identify trends, patterns, and anomalies, providing actionable insights to business leaders.

• Collaborated with cross-functional teams to gather and define business requirements, ensuring the development of accurate and relevant BI solutions.

• Optimized existing BI processes and workflows, resulting in a 20% increase in efficiency and data accuracy.

• Trained and mentored junior analysts on BI tools and best practices, fostering a culture of continuous learning and improvement.

• Developed and maintained detailed documentation of BI processes, ensuring knowledge transfer and consistency in reporting standards.

Data Analyst Intern July 2022 - Dec 2022

HNG

● Developed and applied advanced data analysis techniques to extract actionable insights from large, complex datasets, enabling the team to make data-driven decisions that directly contributed to business growth and strategic planning.

● Assisted in cleaning, organizing, and structuring raw data, ensuring data integrity and improving the overall efficiency of the analysis process.

● Collaborated on multiple cross-functional projects to identify and define key performance indicators (KPIs), leveraging data to highlight areas of improvement and growth opportunities.

● Created detailed, visually compelling reports and dashboards using tools such as Excel, SQL, and Power BI to effectively communicate data findings to stakeholders and team members.

● Analyzed both customer and operational data to support critical decision-making processes, identifying key trends that informed strategic adjustments in marketing, sales, and operations to optimize overall business performance.

● Utilized advanced tools such as Excel for data manipulation, SQL for querying large databases, and Power BI for creating visualizations, conducting in-depth analysis that helped drive operational efficiency and business insights.

● Supported the team in optimizing data workflows by identifying bottlenecks and inefficiencies, and improving data collection methods to enhance the accuracy and reliability of the data used for analysis.

● Gained hands-on experience working with real-world datasets across various business domains, significantly enhancing technical skills in data manipulation, statistical analysis, and visualization. Scrum Master Jan 2019 - June 2022

Walmart, Dallas, TX

● Extracted, analyzed, and interpreted sprint performance data, identifying actionable insights that led to a 20% increase in sprint efficiency by optimizing team workflow and resource allocation based on trends observed in key metrics.

● Utilized advanced data visualization tools like Tableau and Power BI to create dynamic reports and dashboards, effectively communicating team progress, roadblocks, and performance metrics to stakeholders.

● Developed and customized real-time dashboards to track key performance indicators (KPIs) such as velocity, throughput, and burn-down rates, enhancing the accuracy and speed of project tracking.

● Collaborated closely with cross-functional data teams to analyze customer behavior patterns and online shopping trends, leveraging data insights to adjust product development and features.

● Conducted in-depth data analysis on sprint results and team performance, uncovering process inefficiencies and suggesting data-driven improvements that enhanced overall productivity and shortened sprint cycles.

● Integrated multiple data sources to support backlog prioritization and roadmap planning, ensuring that critical features and user stories were accurately aligned with business goals, leading to more focused development cycles.

● Spearheaded the adoption of data-driven decision-making processes within the Scrum teams by continuously monitoring performance data and fostering a culture of using metrics for continuous improvement.

● Facilitated estimation and sprint planning using historical performance data and predictive analytics, which improved the accuracy of project timelines and delivery forecasts. Customer Representative Associate Mar 2016 - Dec 2018 Amazon Fulfillment Center, Houston TX, US

● Maintained an in-depth understanding of a diverse range of products and services, enabling personalized recommendations and delivering tailored solutions to meet customer needs, resulting in consistently high customer satisfaction ratings.

● Proactively contacted potential clients through targeted outreach campaigns, promoting products and services that aligned with their needs, and successfully secured a 40% increase in sales.

● Resolved complex customer and carrier issues by providing prompt and efficient support, analyzing root causes, and offering effective solutions, leading to a significant reduction in complaint escalations.

● Processed product returns in strict adherence to company policies and procedures, ensuring seamless transactions and minimizing errors, while also improving the efficiency of the returns process to reduce handling times by 15%.

● Delivered comprehensive information on order statuses, shipment tracking, and delivery timelines, using internal tracking systems to provide real-time updates to customers.

● Leveraged strong communication and interpersonal skills to de-escalate challenging customer situations, employing active listening and empathy to resolve concerns effectively.

● Conducted detailed analysis of customer inquiries and shipping trends, providing feedback to management on common issues and suggesting process improvements, leading to enhanced operational efficiency PROJECTS

- Data-Driven Decision Making: Business Analysis Case Study for Screamin' Blues Jays' Concert Applied advanced linear programming techniques using Microsoft Excel Solver to optimize resource allocation and student assignments for charter schools in Baltimore City. Delivered actionable insights that enhanced operational efficiency.

- Cookie Sales Performance Dashboard

Designed and developed a comprehensive, visually dynamic dashboard in Microsoft Excel to track and analyze cookie sales performance, providing real-time insights that supported data-driven decision-making.

- Flood Prediction in Lagos State

Leveraged the ARIMA model to forecast potential flood events in Lagos using historical weather data, contributing to proactive disaster management strategies and risk mitigation efforts.

- Danny Restaurant Customer Satisfaction Analysis

Analyzed extensive customer feedback and sales data to identify key areas for improvement. Provided recommendations that significantly enhanced customer satisfaction and operational performance.

- Atuwa Bakery Bread Production Analysis

Conducted an in-depth analysis of production processes and workforce efficiency. Proposed data-driven solutions that streamlined operations and increased profit margins, improving overall business performance.

- Crime in US Communities Dashboard – UBC MDS Data Visualization Developed interactive dashboards utilizing R Shiny and Python Dash to explore and visualize socio-economic and law enforcement data across US communities, providing key insights into crime trends and policy effectiveness.

- Fake News Detector – SFU Hack The Threat '23 Hackathon Built an innovative fake news detection tool during a competitive hackathon, showcasing expertise in natural language processing, machine learning, and real-time analytics to address the growing issue of misinformation. CERTIFICATIONS

- Certificate in Data Analysis, Regonet Global 2024

- Cisco Data Analytics Certification 2024

- Certified Business Analyst

- Certified Scrum Master

- Certified Scrum Product Owner

- PMP (Project Management Professional)

- SAFe Scrum Master

- General Line Insurance Agent

EDUCATION Certification in Business Analytic Science - Business Analyst, University of South Florida, South Florida, FL 2022 MBA in International Business, Lagos State University, Lagos 2014 REFERENCES Available upon request

Contact this candidate