Data Analyst

AMMAN PATNAIK

Dallas, TX ; +1-940-***-**** ; **********@*****.*** ; www.linkedin.com/in/amman-patnaik SUMMARY

Data Analyst with a strong educational background in Information Technology and Management. Proficient in SQL, Excel, Python, R, and data visualization tools including Tableau and Power BI. Demonstrated success in leveraging data management strategies to optimize business operations and enhance decision-making. EDUCATION

The University of Texas at Dallas December 2024

MS, Information Technology & Management

Coursework: Database Foundations for Business Analytics, System Analysis and Project Management, Advanced Statistics for Data Science, Web Analytics, Operations Analytics, Causal Analytics and A/B Testing, Business Data Warehousing, Big Data, Object Oriented Programming with Python

Gandhi Institute of Technology & Management June 2020 BTech, Electronics and Communications Engineering

SKILLS

Languages: SQL, Python, R (dplyr, ggplot2)

Tools & Skills: mySQL, MongoDB, Oracle Apex, MS Excel, R Studio, Snowflake, Hadoop, Microsoft 365, MATLAB, SharePoint, Tableau, PowerBI, Auditing, Salesforce, Amazon Web Connect, Power BI, Amazon Seller central, Google Analytics, Google Suite, Data Manipulation, Data Cleaning and Preprocessing, Data Warehousing, ETL Processes Certifications: Google Data Analytics Professional Certificate; Microsoft Power BI Data Analyst Professional Certificate; Hands on Essentials – Data Warehouse by Snowflake; Tableau Essential Training by Linkedin; Databricks Generative AI Fundatmentals PROFESSIONAL EXPERIENCE

The University of Texas at Dallas

Data Analyst June 2023 – December 2024

• Leveraged SQL to analyze and manage 100+ student account records daily, generating actionable insights that enhanced financial reporting processes, resulting in a 95%+ customer satisfaction rating in post-analysis surveys.

• Developed interactive reports and dashboards in Power BI, visualizing key student data trends, which improved decision- making efficiency for the finance team.

• Applied advanced Excel functions and Pivot Tables to streamline data processing, increasing data accuracy by 40% and reducing data retrieval time by 50%.

Amazon

Business Operations Analyst March 2021 - December 2022

• Developed and implemented data pipelines using AWS Glue, resulting in a 50% reduction in processing time for data flows in and out of data storage systems, enhancing data efficiency.

• Utilized SQL to audit and analyze seller accounts, achieving a 50% reduction in seller appeals and fostering a more efficient seller ecosystem in collaboration with the Certification/Product Authentication Team.

• Conducted detailed root cause analysis with Python scripting, attaining a 90%+ resolution rate for seller appeals and ensuring 100% accuracy in brand authorization requests.

• Automated reporting and analysis of monthly shrinkage data using Python, improving shrinkage management by 50% and enabling data-driven decision-making for loss prevention strategies.

• Created and maintained interactive Tableau dashboards to visualize operational and performance metrics, facilitating informed decision-making for senior management.

• Consistently surpassed performance goals with >99% accuracy, recognized as a top performer in Q4 2022, significantly contributing to the success of the business operations team. ACADEMIC PROJECT EXPERIENCE

Chicago Crime: Trend and Analysis

• Conducted data analysis on Chicago crime data using SQL, identifying a 20% increase in crime frequency in specific locations and times, which informed targeted policing strategies and resource allocation.

• Designed interactive Tableau dashboards to visualize crime data, empowering decision-makers with actionable insights that led to an 18% reduction in crime rates.

Truck Fleet Data Analysis

• Utilized Hadoop tools to analyze truck fleet data and applied advanced analytics techniques with MapReduce and Apache Spark, resulting in a 25% improvement in operational efficiency and a 20% reduction in fuel consumption.

• Created interactive Tableau dashboards to showcase insights, empowering decision-makers in optimizing trucking operations and mitigating risks.

Contact this candidate