Post Job Free
Sign in

Data Analyst Analysis

Location:
Columbus, IN
Posted:
October 29, 2024

Contact this candidate

Resume:

Sai Charan Reddy Maram

+1-812-***-**** *****.*******@*****.*** LinkedIn Github Tableau

Education

Indiana University, Bloomington August 2022 – May 2024 Master of Science in Computer Science

Technical Skills

Programming Languages: Python, R, SQL, Java, Bash, DAX, HTML/CSS, Javascript. Data Management and Cloud: Microsoft Azure, AWS, Postgres, SQL Server, MongoDB, Snowflake. Data Analysis Tools: PowerBI, Tableau, Excel, Jupyter, Alteryx. Developer Tools:Git, JIRA, Docker, Pyspark, Agile, SDLC, JIRA, Postman. Libraries: Pandas, NumPy, Matplotlib, Plotly, Seaborn, Scikit-learn, Tensorflow, Keras, Pytorch, Nltk. Work Experience

Data Analyst January 2024 – Present

Hoosier Community Network Remote, United States

• Streamlined advanced data cleaning using Excel (VBA macros, pivot tables, VLOOKUPS), enhancing data accuracy and reducing manual effort by 50% for business analysis and reporting.

• Conducted statistical analysis using SAS and Python (Pandas, NumPy), ensuring data quality and resolving 95% of inconsistencies, delivering actionable insights to stakeholders and maintaining data governance standards.

• Collaborated with a cross-functional team to consolidate and migrate data from multiple sources (Excel, REST APIs) to a MySQL database, improving data accessibility and query efficiency by 20% for analytics.

• Worked with stakeholders to design and optimize SQL queries (CTEs, stored procedures, indexes) for faster data retrieval, improving data processing speed by 40% for analytical reports.

• Reviewed SQL queries, data workflows, and Git code for accuracy and efficiency, ensuring clean, high-quality data for reporting and analysis while maintaining version control for all ETL scripts.

• Integrated and transformed data using SSIS to ensure up-to-date and accurate information, providing the foundation for client-facing reports and dashboards.

• Developed interactive dashboards in Power BI using Power Query and DAX to visualize key performance indicators

(KPIs), driving a 25% increase in sales through data-driven insights. Graduate Associate Instructor August 2023 – May 2024 Luddy School of Informatics, Computing and Engineering Bloomington, IN

• Guided 70+ students in developing AI models, focusing on algorithm selection and debugging.

• Mentored students in building predictive models (decision trees, neural networks), ensuring they applied data analysis techniques to real-world problems.

Data Analytics Engineer April 2020 – April 2022

Genesis TechSystems Inc Remote, India

• Implemented a Snowflake data warehouse, integrating diverse data sources (Excel, REST APIs), reducing query times by 50%, and improving data accessibility for business analysis across 5 departments.

• Maintained ETL pipelines for daily data processing and analysis (500,000+ records) using AWS Glue and Apache Spark, ensuring timely and accurate reporting for clients in manufacturing and healthcare.

• Improved data quality by 30% through comprehensive data cleaning, validation, and statistical analysis using PySpark, providing more reliable datasets for hypothesis testing and decision-making.

• Automated ETL workflows using Apache Airflow, with a DAG orchestrating over 20+ daily jobs for data integration.

• Built Tableau dashboards for trend analysis and KPI visualization, enabling data-driven decisions.

• Collaborated with cross-functional teams using JIRA and following Agile/Scrum methodologies to manage daily tasks.

• Automated business reporting with SSRS, delivering detailed, up-to-date reports that improved decision-making.

• Streamlined CI/CD pipelines with AWS CodePipeline, reducing deployment times from 3 hours to 15 minutes, ensuring 100% data availability for real-time reporting.

Projects

YouTube Data Analytics Python, AWS

• Analyzed 100,000+ YouTube metrics, revealing engagement patterns that increased viewer interaction by 23%.

• Engineered an automated ETL pipeline with AWS Lambda, Glue, and S3, reducing data processing times by 30%.

• Created dynamic dashboards using AWS Quicksight, visualizing key metrics to inform strategic adjustments. HR Data Analytics Excel, PowerBI, Power Query, DAX

• Developed a PowerBI dashboard analyzing attrition metrics for 1,470 employees, using DAX for key KPIs.

• Analyzed HR data to identify demographic and occupational attrition trends, aiding in retention strategy formulation.

• Created interactive visualizations in Power BI to support data-driven decision-making processes.



Contact this candidate