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.