Anil Kanuganti
Atlanta,GA
Summary
I am a graduate student coupled with strong experience of ETL processes to support data conversion, data migration and data consolidation. Proficient in complex data collection and data visualization using advanced SQL, Postgres SQL, RDBMS knowledge across database platforms and BI tools like Tableau and Excel. Superior presentation and organizational skills combined with a proven ability in problem solving, business data modeling, attention to detail and accuracy, and skill to work in a cross functional team.
Knowledgeable Data Engineer with robust background in data architecture and pipeline development. Proven ability to streamline data processes and enhance data integrity through innovative solutions. Demonstrates advanced proficiency in SQL and Python, leveraging these skills to support cross-functional teams and drive data-driven decision-making.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Engineer
TIAA
05.2023 - 04.2025
- Interpreted data and analyzed results using statistical techniques and provided ongoing reports.
- Acquired data from primary or secondary data sources and maintained database systems.
- Built SQL complex queries for accessing and extracting data from MySQL.
- Constructed dashboard and ad-hoc reports Excel and Tableau.
- Analyzed issues for updating databases and expedited 35% of data processing time.
- Environment: MS Excel, My SQL, SQL Server, MS PowerPoint, Tableau.
- Analyzed complex datasets using SQL queries, enhancing data processing efficiency and providing actionable insights through Excel and Tableau visualizations.
- Streamlined data processing workflows, significantly reducing processing time and improving overall database performance for more timely decision-making.
- Developed creative solutions for data acquisition challenges, integrating primary and secondary sources to build comprehensive and reliable database systems.
- Partnered with cross-functional teams to deliver insightful reports and dashboards, facilitating data-driven strategies across the organization.
- Meticulously maintained data integrity, ensuring accuracy in statistical analyses and reporting for informed business decisions.
- Streamlined data workflows, significantly reducing processing time and improving database performance for timely decision-making and strategic planning.
Jr Data Analyst
Tecsolvent Software Technologies Pvt.Ltd
01.2020 - 07.2021
- Responsible for gathering requirements from business analysts and operational analysts, Identified the data sources required for the reports needed to the customers.
- Used Python programs automated the process of combining the large datasets and Data files and then converting them into Teradata tables for Data Analysis.
- Created Automated Python Programs to Archive the database tables which large and not in use into Mainframes folders.
- Developed programs with manipulate arrays using libraries like NumPy and Python.
- Did performance tuning and optimization for increasing the efficiency of the scripts by creating indexes, adding constraints and query optimization.
- Writing SQL scripts for huge data pulls and ad-hoc reports for analysis. Used the Teradata advanced techniques like rank, row number etc.
- Generated graphs using MS Excel Pivot tables and creating presentations using Power Point.
- Generated reports using Proc Tab, Proc Report, Data Null, Proc SQL and Macros. Used OLAP functions like sum, count, csum, etc.
- Communicated with business users and analysts on business requirements.
- Gathered and documented technical and business Meta data about the data.
- Created numerous processes and flow charts to meet business needs and interacted with business users to understand their data needs.
- Created Set, Multiset, Derived, Volatile, Global Temporary tables to retrieve the data from multiple tables.
- Experience in writing Korn shell scripts for automating the jobs.
- Automated reports by connecting Teradata from MS Excel using ODBC.
- Documented scripts, specifications, other processes and preparation of Technical Design Documents.
Education
MS - Data Science
Lindsey Wilson University
Columbia, Kentucky11.2025
MS - Information Systems
Wilmington University
Wilmington, Delaware04.2023
Bachelor of Technology - Electronics and Communication Engineering
Jawaharlal Nehru Technological University
Hyderabad, India11.2020
Skills
- SQL Server Management
- My SQL
- Tableau
- Python
- Pandas
- NumPy
- Scikit-Learn
- Seaborn
- Matplotlib
- MS Excel
- Data Preparation
- Power BI
- PostgreSQL
- ETL
- RDBMS
- Data Stage
- Business Objects
- SSIS
- MS SQL Server
- Teradata
- MS Access
- MS-Office
- Teradata SQL Assistant
- HTML5
- CSS3
- MongoDB
- Decision Tree
- Naive Bayes
- Logistic Regression
- ML Algorithms
- Data analysis
- SQL query development
- Database management
- Data visualization
- Excel dashboard creation
- Python programming
Certification
- Python for Data Science, IBM - May 2024 - August 2024
Personal Information
Title: Data Engineer
Certifications And Projects
- Python Project for Data Science, https://www.credly.com/badges/c464cb3b-ebe7-4f21-be3a-a74746fc8010
- Sentiment Analysis Project Overview, This project centers on the design and implementation of a comprehensive end-to-end sentiment analysis model, specifically trained using posts from Twitter. The primary goal is to develop a system that can effectively process short text inputs and provide accurate and efficient sentiment classifications., The approach utilizes transformer architecture, which was initially introduced for sequence-to-sequence translation tasks through an encoder-decoder framework. In the context of sentiment analysis—a classification problem—only the encoder component is necessary. As a result, the decoder is omitted, allowing the model to maintain its essential structure while focusing on efficient classification performance., PyTorch, Pandas, NLTK, NumPy
Languages
Hindi
Professional Working
Timeline
Data Engineer
TIAA
05.2023 - 04.2025
Jr Data Analyst
Tecsolvent Software Technologies Pvt.Ltd
01.2020 - 07.2021
MS - Information Systems
Wilmington University
Bachelor of Technology - Electronics and Communication Engineering
Jawaharlal Nehru Technological University
MS - Data Science
Lindsey Wilson University