Summary
Overview
Work History
Education
Skills
Projects
Websites
Certification
Timeline
Generic

Ashish Tammana

Summary

Highly motivated data analyst with a strong background in data engineering, data analysis, and automation. Proficient in Python3, SQL, Google Suite, and Microsoft Office technologies. Demonstrated ability to build and manage scalable data architectures, develop data analysis chains, and create interactive data visualizations. Skilled at working independently and in team environments, with excellent problem-solving and project management capabilities. AWS Certified Data Engineer Associate, expertise with cloud platforms like Amazon AWS, S3, EC2, with a focus on data science applications and industry-relevant experience.

Overview

1
1
year of professional experience
1
1
Certification

Work History

Data Analyst

Nexus Technologies
Bangalore, INDIA
07.2021 - 12.2022
  • Built and maintained data foundations supporting AI and ML projects, for improving data processing efficiency
  • Gathered requirements from business analysts and operational analysts, Identified the data sources required for the reports needed to the consumers
  • Used Python programs automated the process of combining the large datasets and Data files and the converting as Teradata tables for Data Analysis
  • Used Python, XML processing, data exchange and business logic implementation
  • Utilized Python libraries like Boto3 for AWS
  • Used Several Python Libraries Like Python, Numpy and matplotlib and was involved in environment, code installation as well as the SVN implementation
  • Designed and maintained databases using python and developed Python based API (RESTful Web Service) using Flask, SQLAlchemy and PostgreSQL
  • Developed data analysis chains and automation pipelines, for reducing manual data handling
  • Collaborated with data scientists, product managers, and software developers to ensure efficient data feeds, resulting in a 30% increase in data throughput
  • Formalized guidelines for data modeling, database scheming, and metadata documentation, for enhancing data consistency by
  • Communicated data insights effectively to clients and decision-makers, leading to a 15% improvement in project decision timelines
  • Create, develop and fine-tuned SQL objects: Tables, stored procedures, views and triggers
  • Utilized Python and SQL for data analysis and automation, reducing error rates by 10%
  • Implemented cluster analysis (K-means and hierarchical processes) for accurate segmentation of the client base, which improved targeted marketing campaign effectiveness
  • Troubleshooting issues by identifying root causes and finding solutions for the issue
  • Optimized SQL queries used in batch processing and wrote validation scripts in SQL to validate data loading
  • Responsible for managing large databases using Pandas data frames and MySQL
  • Enhanced data visualization and reporting using Tableau and Python-based tools, resulting in a 25% increase in stakeholder engagement
  • Managed large data sets and workbooks, utilizing macros, queries, and scripts for data manipulation, improving data management efficiency by 30%
  • Proficient in applying various excel functions such as pivot tables, VLOOKUP to aggregate data
  • Monitored performance and quality control plans to identify improvements in data systems.

Education

Master of Science - Information Technology, Data Management and Analytics

Washington University of Science and Technology
Alexandria, Virginia, US

Bachelor of Technology - Computer Science and Engineering

ICFAI Institute of Higher Education
Hyderabad, Telangana, IN

Skills

  • Python
  • SQL
  • Apache Spark
  • Hadoop
  • Apache Kafka
  • AWS
  • Tableau
  • MySQL
  • SQLite
  • SQL-server
  • Anaconda
  • Jupyter Notebook
  • Excel
  • Data validation
  • R programming
  • Data collection
  • Deep learning

Projects

Data Mining Project: Clustering for Targeted Marketing Campaigns, Washington University of Science and Technology, Comprehensive Data Analysis Project, Designed and executed data analysis models and tools to enhance business and marketing strategies, focusing on customer segmentation, scalable AI/ML architectures, and market analysis., Developed customer segmentation models using Kaggle data, applying cluster analysis techniques (K-means and hierarchical clustering), which improved marketing campaign effectiveness., Created scalable data architectures to support AI/ML projects, for enhancing data processing efficiency., Conducted market analysis using Python and Jupyter Notebook, identifying key market trends and relationships, and developed predictive models with Scikit-Learn to forecast trends., Ensured data quality through rigorous preprocessing, including Z-score normalization and missing value handling., Designed and delivered data visualizations using Seaborn and Matplotlib., Collaborated with cross-functional teams to standardize data modeling, documentation, and reporting processes, improving overall data consistency and accessibility.

Certification

AWS Certified Data Engineer - Associate

Timeline

Data Analyst

Nexus Technologies
07.2021 - 12.2022

Master of Science - Information Technology, Data Management and Analytics

Washington University of Science and Technology

Bachelor of Technology - Computer Science and Engineering

ICFAI Institute of Higher Education
Ashish Tammana