Home > Candidates > Li Shuaihang
Li Shuaihang

,

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:

Career Information:

Sign up to view Li Shuaihang's full profile.

Highlights:

Skills:Python, SQL, Snowflake, Informatica, Excel, Data Modeling, Data Analysis, Tableau, Power BI, Data Visualization, Dashboard, Business Intelligence, Agile, Waterfall


Experiences:

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--

Education:

Georgia State University 08/2014 - 12/2018
Atlanta, GA, United States
Degree: Bachelor's Degree
Major:International Business
Interdisciplinary Studies focusing on International Businesses


Mercer University 01/2019 - 05/2020
Atlanta, GA, United States
Degree: Master's Degree
Major:Business Analytics
Master of Science in Business Analytics

Download Resume(Available to Employers Only):

Resume short
ShL Resume



More About Li Shuaihang
Please sign in or sign up an employer to view Li Shuaihang's personal information.

  • Phone: xxx-xxx-xxxx
  • Email:xxx@xxxx.xxx
  • Visa: -
  • Work Authorization: -
  • Expected Salary: -
  • Intests & Hobbies: -