Data Analyst

RAGHAV CHEGU SHYAM KUMAR

Denver, Colorado 812-***-**** **********@*****.*** linkedin.com/in/raghavcs github.com/ragh4869 EDUCATION

Masters of Science, Data Science May 2023 GPA - 3.90/4.00 Indiana University Bloomington

Courses: Artificial Intelligence, Applied Database Technologies, Network Science, and Engineering Cloud Computing Bachelors of Technology, Electronics & Communication Engineering May 2019 GPA – 7.96/10.00 SRM Institute of Science and Technology

WORK EXPERIENCE

Forest Biometrician (FIA Program Director) July 2023 – January 2025 State of Indiana – DNR Forestry division, Indianapolis, IN

Developed long-range objectives and data projects for the FIA department such as creating Tableau dashboards for insights, yearly reports and other projects that can help the Forestry division.

Migrated critical data from online servers to the local SQL server enhancing access and speed in data querying by 30%.

Collaborated with Purdue to build Forest Growth and Yield models for Indiana’s State and Private forests improving estimates of tree counts, growth, mortality and other metrics by at least 40%. Metadata Content Analyst August 2022 – July 2023

Indiana University Libraries, Bloomington, IN

Used internal tools to migrate a variety of file formats (including XML, CSV, and images) from the old to the new servers.

Established a pipeline to migrate the content in given CSV files to the desired destination achieving 20% more efficiency. IT Data Science Intern May 2022 – August 2022

Bloom Insurance Agency, Bloomington, IN

Conceptualized & optimized stored procedures for lower dependencies in SSRS reports and faster querying by over 35%.

Designed ETL workflows using SSIS packages to automate table insertion and updating for more than 10 clients.

Modularized the ETL pipeline with python for updating the plan structures achieving over 80% more efficiency and better exception handling.

Data Analyst May 2019 – July 2021

LatentView Analytics, Chennai, India

Yielded valuable insights in CRM and Marketing Analytics by implementing 3 POCs – product association for cross-selling, sales impact during Covid, and strategic decision of name retention as per location.

Built a suite of 20 Excel and Power BI dashboards backed by SQL and Python scripts to empower real-time visualizations of trends in retail and consumer domains.

Deployed an end-to-end analysis of the Churn and RFM models from data extraction and pre-processing to building a final model with an accuracy of over 70% and 60%, respectively.

Incorporated Text Processing and Web scraping techniques to extract text data and analyze customer sentiments resulting in a 15% increase in model accuracy.

TECHNICAL SKILLS

Programming/Query Languages: Python, SQL, R, Scala, T-SQL, CQL Cloud/Databases: Google Cloud (GCP), Azure Databricks, MySQL Server, SSMS, MongoDB, Neo4J Data Concepts : A/B & Hypothesis Testing, Consumer Insights, Data Science & ETL Pipeline, Analysis (Campaign, Market Basket, Churn, Sentiment), Packages (Scikit-Learn, Pandas, Numpy, Tensorflow, Keras), Hadoop, Spark, MapReduce, Database Management Tools: Microsoft Suite, Power BI, Tableau, Salesforce, Jupyter, Git, BitBucket, SSIS, SSRS, Atlassian (Jira, Confluence), VS Code LEADERSHIP

Oversaw the Forest Inventory Analysis (FIA) department and managed a team of six by setting expectations, measure progress, provide ongoing feedback, and evaluate the performance of my team.

Chaired Knowledge Sharing Sessions in the retail domain to 4 teams overseeing specifics such as HR and Transactional data.

Managed and mentored three college graduates as a CRM Offshore Lead.

Handled talent acquisition activities (Recruitment) and trained graduates through Boot camp.

Trained more than 10 members of the Ballroom Dance Club at Indiana University as a Team Teacher.

Contact this candidate