Data Analyst Analysis

Pavan Kalyan Imadabathini

Data Analyst

+1-480-***-**** ***********************@*****.*** LinkedIn Portfolio SUMMARY

Dynamic Data Analyst with over two years of experience, adept at optimizing data-driven strategies and improving decision-making processes using advanced analytics. Expert in Python, R, and SQL with proficiency in data visualization tools like Tableau and Power BI. Skilled in cloud technologies (AWS, Azure) and database management (MySQL, SQL Server). Demonstrates strong problem-solving and communication skills, ensuring data accuracy and actionable insights. Proven ability to enhance operational efficiency and stakeholder engagement through effective data analysis and reporting. TECHNICAL SKILLS

Programming Language: Python, R, SQL

Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2, dplyr Visualization Tools: Tableau, Power BI, Microsoft Excel, Looker Studio Database: MySQL, SQL Server, Oracle

Cloud Technologies: AWS, Azure

Methodologies: SDLC, Agile, Waterfall

Other Skills: Data Cleaning, Data Wrangling, Data Warehousing, Data Governance, Data mining, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving IDEs: Visual Studio Code, PyCharm

Operating System: Windows, Linux

PROFESSIONAL EXPERIENCE

Freelance (Remote) Tempe, AZ, US

Data Analyst Feb 2024 - Current

• Refined data analysis efficiency by 42% by utilizing Python, NumPy, and Pandas for data manipulation and comprehensive data wrangling, ensuring high-quality datasets for analysis.

• Revamped data retrieval and reporting by developing and executing complex SQL queries on Oracle databases, improving data extraction and processing speed by 35%.

• Elevated data visualization and stakeholder engagement by creating interactive dashboards and detailed Power BI and Microsoft Excel reports, enabling a better understanding of key metrics and trends.

• Executed thorough data cleaning using Python and SQL, addressing missing values, outlier detection, and data standardization, resulting in a 37% reduction in data errors.

• Deployed Azure cloud services for scalable data storage and processing, enhancing data accessibility and ensuring secure data management throughout the project lifecycle.

KPMG A.P, India

Data Analyst May 2020 – Jul 2022

• Amplified data analysis efficiency by 39% using Python and R for data manipulation, leveraging NumPy and Pandas to perform comprehensive data cleaning and wrangling, ensuring high-quality datasets for analysis.

• Crafted interactive dashboards and detailed reports in Tableau, improving data visualization and stakeholder engagement by 25%, facilitating a better understanding of key metrics and trends.

• Established robust data cleaning procedures using Python and R, addressing missing values, outlier detection, and standardization, reducing data errors by 24%.

• Advanced data storage and retrieval processes by designing and managing data warehouses on AWS, utilizing S3 and Redshift to increase data accessibility and processing speed by 40%.

• Mobilized SQL Server to develop and optimize complex queries, improving data extraction, transformation, and loading processes, reducing query execution time by 31%.

• Conducted advanced statistical analysis using ggplot2 and dplyr, providing actionable insights and visualizations that informed strategic business decisions and improved operational efficiency.

• Streamlined data wrangling workflows by developing Python scripts, automating repetitive tasks, and reducing manual data processing time by 39%.

• Initiated dynamic reports and visualizations in Microsoft Excel, leveraging advanced features such as PivotTables, VLOOKUP, and data models to support ad hoc analysis and detailed reporting.

• Participated within Agile frameworks, actively participating in sprint planning, daily stand-ups, and retrospectives to ensure timely project delivery and continuous improvement, enhancing team productivity.

• Presented key analytical findings to stakeholders using clear visualizations and data storytelling techniques, effectively communicating insights to support informed decision-making. EDUCATION

Arizona State University Aug 2022 – May 2024

MS in Information Technology Project Management

R. V. R and J. C College Of Engineering Aug 2017 – May 2021 Bachelor of Technology in Information Technology

PROJECTS

Climate Change Impact Simulator

• Constructed a Climate Change Impact Simulator with AWS and Berkeley Earth data, deepening insights into regional climate variations.

• Designed a user-friendly web interface for the Urban Edge Apparel dashboard, enhancing user engagement and operational efficiency through seamless AWS integration.

Geospatial Analysis Using Apache Spark

• Examined NYC Yellow Cab data with Apache Spark, uncovering mobility trends enhanced route efficiency by 15%.

• Elevated operational planning effectiveness by 20% through the creation and execution of spatial queries, analyzing over a million data points for better resource distribution and decision-making. Data Visualization and Reporting for Movie Dataset Analysis

• Engineered a sophisticated Tableau dashboard to analyze the film industry, featuring interactive visualizations of genre popularity, investment trends, and performance metrics, thereby enhancing strategic decision-making for stakeholders.

• Overhauled data preprocessing with SQL to enhance a dataset of 45,000 movie entries, improving analysis quality by discarding redundant data and concentrating on critical visualization attributes.

• Utilized advanced Tableau functionalities to create dynamic and interactive data visualizations, improving accessibility and providing deeper insights into movie ratings, budget impacts, and social media influence on film success. Urban Edge Apparel Sales and Customer Analysis

• Developed an extensive Tableau dashboard for Urban Edge Apparel, analyzing over 90,000 transactions to visualize sales trends, seasonal patterns, and customer spending, enhancing strategic decision-making.

• Standardized and cleaned data, addressing over 10 data inconsistencies such as future order dates and null values, for increased accuracy in analyzing sales trends.

• Identified critical business insights, including changes in customer purchasing behaviors and product seasonality, facilitating targeted marketing strategies and product placement improvements. Continuous Sign Language Recognition (CSLR)

• Detected sign language glosses and time limits by analyzing weekly annotated video sequences.

• Aligning video and text embeddings in a shared latent space is the basis for CSLR’s architecture. Certifications

• Google Data Analytics Professional Certificate by Google

• Python for Data Science, AI & Development by IBM

• Certified Pega System Architect 23

• AWS Certified Solution Architect - Associate

Contact this candidate