| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE EMAIL AVAILABLE LinkedIn Github TableauEducationIndiana University, Bloomington August Street Address May 2024 Master of Science in Computer ScienceTechnical SkillsProgramming 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 ExperienceData Analyst January 2024 PresentHoosier 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 2022Genesis 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.ProjectsYouTube 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. |
