Data Analyst Visualization

PRAGNA KATASANI

Wixom, Michigan • +1-618-***-**** •ad5wbm@r.postjobfree.com•

https://www.linkedin.com/in/pragnakatasani020/

SUMMARY

Data Analyst with extensive experience in data visualization, manipulation, and statistical analysis. Proficient in developing and maintaining dashboards and visualizations to provide insights into validation test metrics data. Strong analytical skills with the ability to communicate data-driven insights effectively. Expertise in using Alteryx, PowerBI, Qlik Sense, and Python for data manipulation and reporting. Experienced in working with Jira and JQL for automations and generating dashboards.

PROFESSIONAL EXPERIENCE

PROGRAM and DATA ANALYST 08/2023 - Current

Envision Technologies - MI

● Involved in analysis, specification, design, implementation, and testing phases of the Software Development Life Cycle (SDLC) and used Agile methodology for developing applications.

● Designed, developed, and maintained dashboards and visualizations to provide insights into validation test metrics data.

● Utilized JQL for advanced Jira queries to extract and analyze project management data.

● Assisted in the preparation of analytics reports in presentation form, effectively communicating findings to non-technical stakeholders.

● Supported the team in documenting processes and procedures, contributing to the knowledge base and training materials.

● Developed and maintained PowerBI dashboards to track key performance indicators (KPIs) for various business units.

● Conducted data cleaning and preprocessing using Python, ensuring the accuracy and integrity of datasets.

● Developed analytic reports and dashboards for KPI reporting to drive decision-making and performance tracking.

● Utilized Jira data to generate native dashboards and leveraged connections to Alteryx for web-based dashboards and Gantt charts.

● Prepared analytics reports in presentation format, effectively communicating data-driven insights, Dashboards using Power BI and Tableau.

● Gathered requirements on desired metrics data and built on existing Jira automation.

● Documented processes and steps required for backend maintenance, ensuring smooth and efficient operations. DATA ANALYST 07/2019 - 06/2021

APSIS Technologies Pvt, LTD. - Bangalore, India

● Produced and maintained Tableau data sources and data extracts, improving data accuracy by 15% and reducing data processing time by 20%

● Developed and maintained complex dashboards and reports using PowerBI, providing actionable insights to management.

● Conducted data mining and statistical analysis to identify trends and patterns, aiding strategic decision-making.

● Collaborated with cross-functional teams to gather and define requirements, ensuring the delivery of relevant and impactful reports.

● Automated data workflows using Alteryx, significantly reducing the time required for data processing and reporting.

● Implemented data visualization best practices, enhancing the clarity and usability of reports and dashboards. GRADUATE PROJECTS:

Projects:

Advanced Data Visualization and Analytics Dashboard

● Developed an advanced data visualization and analytics dashboard to provide actionable insights and support decision-making processes for university administration.

● Conducted data extraction, transformation, and loading (ETL) processes using Alteryx, ensuring data accuracy and consistency.

● Conducted data extraction, transformation, and loading (ETL) processes using Alteryx, ensuring data accuracy and consistency.

● Performed data queries and manipulations using SQL and Python to support in-depth data analysis.

● Utilized advanced data visualization techniques to present complex data in a clear and understandable manner.

● Gathered requirements from stakeholders and iteratively improved dashboard functionalities based on feedback.

● Documented the project process, including data sources, transformation steps, and visualization design choices. Automated Data Reporting System for Course Evaluations

● Created an automated system for processing and reporting course evaluation data, streamlining the feedback collection and analysis process for the university's academic departments.

● Collected and cleaned student performance data from multiple sources using Python libraries such as pandas and NumPy.

● Conducted exploratory data analysis (EDA) to identify trends and patterns related to student performance.

● Developed and trained machine learning models using Scikit-learn to predict student outcomes, achieving an accuracy of 92%.

● Utilized Python for data cleaning, manipulation, and statistical analysis.

● Designed and implemented PowerBI dashboards to present evaluation results and insights to faculty members.

● Documented the entire process, including ETL steps, data transformation logic, and dashboard design, for future reference and maintenance.

Personality and Substance Abuse Study:

● This project delved into the interrelation between personality traits and substance abuse, specifically focusing on

● volatile substances. Python was used for generating visualizations like heat maps and bar diagrams.

● SQL queries were employed for data retrieval, and machine learning models such as linear regression, logistic regression, and KNN were applied to classify user behavior and substance abuse patterns over certain periods. Also, Principal Component Analysis (PCA) was used to decompose clusters into one component, enhancing understanding of the data structure. SKILLS

● Data Visualization and Manipulation Tools: Alteryx, PowerBI, Qlik Sense

● Programming Languages: Python

● Analytical Skills: Data queries, manipulation, statistical analysis, data mining, and multi-dimensional reporting

● Other Skills: Excellent mathematical, statistical, logical, and reasoning skills; strong communication abilities

● Methodologies: Agile processes and methodologies

● AWS, GCP, Apache Spark, Query Optimization,

Hadoop Ecosystem, IIOT.

● NumPy, Pandas, Matplotlib, SciPy, Scikit-learn,

Seaborn,

● TensorFlow, Kafka, PySpark

● Tableau, Power BI, SSRS, Jenkins

● Project Management Tools: Jira, JQL

● MS SQL Server, PostgreSQL, MongoDB, MySQL

EDUCATION

● Southern Illinois University - Carbondale, IL Master of Science Computer Science, 05/2023

3.6 GPA

● Jawaharlal Nehru Technological University, INDIA Bachelor’s in Technology Electronics & Communications Engineering, 04/2020

3.7 GPA

Contact this candidate