Post Job Free

Resume

Sign in

Data Analyst Analytics

Location:
Troy, MI
Posted:
January 10, 2024

Contact this candidate

Resume:

Jianxia Jiao Address: **** kirts blvd, Troy, MI, *8084

Phone: 313-***-**** Email: ad2mxc@r.postjobfree.com Summary

With 4 years of experience in the data field, I strive to provide actionable insights from complex datasets by leveraging advanced statistical analysis and ML techniques to improve the quality of service. Adept at developing predictive models, optimizing data processes, optimizing ETL pipelines, developing Big Data Infrastructure and collaborating with interdisciplinary teams to drive data-driven decision-making. Education

•Master in Applied Statistics Sep 2021 – Dec 2023

Oakland University, Rochester, MI

•Master in Health Service Administration Sep 2011 - Dec 2013 University of Detroit Mercy, Detroit, MI

Certification

• SAS Certified Base Programmer for SAS 9.4 (Issued on: May 2021)

• Google Data Analytics Certificate (Issued by Coursera)

• IBM Data Science Professional Certificate (Issued by Coursera) Technical Skills

Programming Tools: Python, SQL, R, SAS

Python Related: Numpy, Pandas, SciKit-Learn, TensorFlow, PyTorch Big Data: Hadoop, Hive, Spark, Databircks

Office Tools: Word, Excel, Access, PowerPoint

Database: Oracle, MySQL, Microsoft SQL Server

Data Visualization: Power BI, Tableau

Experience

•Data scientist June 2022 - March 2023

Cigna Bloomfield, CT

– Developed ETL pipeline project for an app and reduced the running time by 60% compared to the original design by optimizing procedures.

– Led the design, development, and maintenance of Big Data infrastructure with Hadoop tools, ensuring scalability, performance, and reliability.

– Applied advanced statistical analysis and predictive modeling techniques to analyze historical and behavioral information, providing the data to support the new health plan.

– Assisted senior data science team in building innovative machine learning models with generative AI technology.

•Python Programmer January 2022 - April 2022

Deloitte Detroit, MI

– Convert SAS code files to Python and SQL codes. Primary packages used with Pyspark, Numpy, and Pandas.

– Developed Spark applications using Pyspark and SQL for ETL and data aggregation pipeline.

– Created automated scripting with Python and PowerShell commands.

•Data Analyst September 2019 - December 2021

Oakland University Rochester, MI

– Provided suggestions on healthcare service delivery. Reduced 20% cost and increased 50% satisfaction depending on feedback.

– Conducted data quality assessments and implemented data cleansing strategies, enhancing data accuracy by 18% in Spark.

– The Created desired data model and managed multiple databases such as SQL server, Oracle, and Hadoop.

– Generated reporting, analyzing, and predicting operational processes using Python and SQL.

– Created interactive dashboards and reports using Excel, Power BI, and Tableau.



Contact this candidate