Summary
Overview
Work History
Education
Skills
Accomplishments
Playing Cricket, Cooking Food, Traveling
Timeline
Generic

HARI SHANKAR

Chicago,IL

Summary

Highly Motivated Data Analyst with 3 years of expertise in using data to make smart business decisions and improve operations. Skilled in analyzing complex data, turning it into clear insights and visuals that help teams understand and act. Proven track record of delivering effective data-driven solutions that drive growth and innovation. Ready to bring these skills to help organizations succeed

Overview

5
5
years of professional experience

Work History

Data Analyst

AMEX
06.2023 - 04.2024
  • Assisted in data cleaning, organization, and preparation for analysis
  • Supported senior analysts and team leads in various analytical projects
  • Participated in gathering and interpreting data insights
  • Worked with Python modules for data manipulation and analysis, driving efficient data processing
  • Expertise in creating impactful visualizations to convey insights effectively
  • Skilled in SQL for data querying and issue resolution, ensuring data accuracy and integrity
  • Designed and implemented Azure Data Lake Gen 2 and Azure SQL pipelines, optimizing data management
  • Contributed to Azure and Power BI solutions, enhancing data analytics capabilities
  • Developed Power BI reports with DAX measures for comprehensive reporting and analysis
  • Collaborated on creating data design documents, ensuring alignment with project objectives
  • Demonstrated proficiency in Excel, including VLOOKUPs, Pivot tables, and advanced functions
  • Worked with SQL Server components (SSIS, SSAS, SSRS) to manage and analyze data effectively
  • Environment: Python, SQL SSAS, Tableau, SQL, Flat Files, SSIS Vs 2013, SSRS, SSAS, Business Intelligence, Tableau, Power BI, Excel, PowerPoint, GIT, GitHub, CI/CD, Agile.
  • Utilized data visualization tools to effectively communicate business insights.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.

Software Engineer/Analysts

Wells Fargo
10.2019 - 12.2021
  • Assisted in data cleaning, organization, and preparation for analysis
  • Utilized Python for data processing tasks such as data cleaning and transformation for datasets at least with size 20650 rows and 10 columns
  • Assisted in SQL query writing and data retrieval from databases using SSMS (SQL Server Management Studio).
  • Created visualizations, and dashboards in Tableau and Power BI to present data insights effectively.
  • Trained to use SSIS (SQL Server Integration Services) for data extraction, transformation, and loading (ETL) tasks.
  • Contribute to data analysis projects by conducting analyses using Python, SQL, Tableau, Power BI, and SSMS.
  • Participated in training sessions to enhance proficiency in Python and Data analytics.
  • Collaborated with team members to understand data requirements and project objectives, ensuring alignment with business needs for the Client.
  • Environment: Python, SQL, Tableau, SSIS, SSMS, SSRS, Business Intelligence, Power BI, Excel, PowerPoint, ,GitHub.

Education

Masters - Computer Science

Southeast Missouri State University
Cape Girardeau, MO

Bachelor of Technology -

Jayamukhi Institute of Technological Sciences

Skills

Cloud Computing

  • AWS (basics), Azure (basics)
  • Data Visualization and Presentations
  • Data Analysis
  • Excel Functions
  • Data Cleaning

Programming Languages

  • Python, Java, SQL, HTML, CSS

Databases

  • SQL, Mysql, MongoDB, Oracle, DBMS, ADBMS

Modules

  • TensorFlow, Matplotlib, NumPy, pandas, OpenCV, Seaborn

Operating system

  • UNIX, Linux, Windows, Mac OS

Machine Learning

  • Linear Regression, Decision Trees, Logistic Regression, Time series analysis, Regression Analysis

Accomplishments

  • COVID-19 Trends in India: Nationwide insights and considering state: Maharashtra
  • An exploratory and explanatory analysis of Covid-19
  • Face Detection and Recognition (OpenCV)
  • Other Projects:
  • Chatbots using python
  • Online shopping
  • Calculator using Java.

Playing Cricket, Cooking Food, Traveling

I like playing cricket with my friends to get relax from works and spend time with my friends.

I cook food when I am stressed and try different recipes.

I like to travel different places to explore and feel relaxed


Timeline

Data Analyst

AMEX
06.2023 - 04.2024

Software Engineer/Analysts

Wells Fargo
10.2019 - 12.2021

Masters - Computer Science

Southeast Missouri State University

Bachelor of Technology -

Jayamukhi Institute of Technological Sciences

Similar Profiles

CREATE PROFILE
HARI SHANKAR