,
Phone: xxx-xxx-xxxx
Email: xxx@xxxx.xxx
Looking For: data analyst, business analyst
Occupation: IT and Math
Degree: Master's Degree
Career Level: Qualified
Languages:
Highlights:
Skills:Python, SQL, Snowflake, Informatica, Excel, Data Modeling, Data Analysis, Tableau, Power BI, Data Visualization, Dashboard, Business Intelligence, Agile, Waterfall
Deployment Data Analyst 12/2021 - 01/2024
3M, St. Paul, Mn United States
Industry: Manufacturing
Part of the 3M's Global Business Transformation that aims integration of data from legacy systems into SAP. My role was integrating purchasing record data and customer information data from different systems across production plants in South Africa, Korea and North America. Spearheaded integration of purchasing record data and customer information data into SAP, ensuring seamless data migration and operational continuity.
Led extraction assessment and rule refinement for purchasing data across multiple plants, utilizing Jira for team coordination.
Executed comprehensive data integration, mapping, and ETL processes from legacy systems, employing SQL and UML for use case modeling.
Designed and executed SQL ETL test cases to ensure data integrity, completeness, and adherence to SAP standards.
Conducted A/B testing on data transformations and loading strategies to optimize performance and data accuracy
Performed thorough API testing for functional and performance compliance
Contributed to SAP Standards Adherence, ensuring transformed data met SAP's specific standards
Facilitated communication of requirements to development and QA teams through business process modeling and functional use case updates.--
Sr. Associate Data Analyst 11/2021 - current
Turnberry Solutions, Lawrenceville, GA United States
Industry: Consulting
As a Senior Data Analyst at Turnberry Solutions, I leverage my expertise in data modeling, ETL, and Agile methodologies to drive actionable insights and support informed decision-making. I excel in managing complex data extracts, database applications, and ad-hoc queries, utilizing tools like SQL and Python. My proficiency in Power BI enables me to create impactful visualizations and dashboards, empowering stakeholders with valuable insights. My role also involves collaborating with cross-functional teams to ensure data accuracy and optimize business processes.
Handled ongoing project with 3M's data transformation.Performed analysis and ETL on MDM data in various plants.--
Marketing Data Analyst 06/2020 - 11/2021
Wyseland Inc, Atlanta, GA United States
Industry: Wholesale
Wholesale company that supplies rural retailers across eatern US, The project focused on data extraction from legacy, analysis and support for targeted marketing efforts. I was instrumental in extracting and analyzing historical sales data to enhance marketing strategies.
Executed join-based data extraction on sales and customer information, employing SQL and Python for data standardization, including advanced functions and subqueries.
Conducted Data standarization with SQL and Python, including aggragative function and data manipulation as well as complex subqueries.
Utilized K-means clustering techniques to identify several segments of customers allowing the marketing team to target potential customers and increased revenue by 7%.
Visualized and interpreted customer segments to senior management and gained buy-in from executive leaders.
Built prediction models to forecast monthly sales, enabling the identification of plan resources in response to expected demand and project future budgets, resulting in a 70% time reduced for inferring insights from various sales reports.
Developed Power BI dashboards to monitor the performance of over 10,000 sales across the company.
Utilized Google Analytics for trends and performance analysis, enhancing marketing strategies and decision-making processes--
Georgia State University 08/2014 - 12/2018
Atlanta, GA, United States
Degree: Bachelor's Degree
Major:International Business
Interdisciplinary Studies focusing on International Businesses
Resume short
ShL Resume