Data Analyst Warehouse

Sumanth Mereddi

Boston, MA (***)-(***)-**** *******.*@************.***

EDUCATION

Northeastern University, Boston, MA

Master of Science in Information Systems Expected May 2025 Amrita Vishwa Vidyapeetham, Coimbatore, India

Bachelor of Technology in Computer Science and Engineering June 2020 TECHNICAL SKILLS

● Programming Languages Python (Pandas, NumPy, Matplotlib, Seabor), SQL, R

● Databases MySQL, NoSQL, Azure SQL, MongoDB, PostgreSQL

● BI Tools Tableau, Power BI, Anaconda, Informatica PowerCenter

● Tools Talend, Alteryx, VS Code, Jupyter Notebook

● Technologies Amazon Web Services, Unix, Linux, Hive, Pig, Hadoop PROFESSIONAL EXPERIENCE

Data Analyst, TATA Consultancy Services Bangalore, India Oct 2020 - Jun 2023

• Designed and executed efficient ETL utilizing AWS EC2 instances to move data from MySQL database to data warehouse, resulting in a 30% increase in data fetching speed

• Designed, built, and executed Azure Data Factory (v2) with integrated error logging for the purpose of populating Azure Data Warehouse from both Azure Blob Storage and Azure Data Lake Store.

• Created visual dashboards using Tableau and Power BI for executive teams, providing real-time visibility into Adobe sales, enabling proactive decision-making

• Developed and executed ETL processes utilizing data profiling, migration, extraction, transfer, and loading processes to move data from SQL Server to Snowflake cloud data warehouse, resulting in a 15% increase in data fetching speed

• Designed a business-centric dimensional model, improving analysis and decision-making efficiency, fostering a data-driven culture, and reducing data processing times

• Conducted exploratory data analysis and pattern detection using Python, leveraging techniques such as descriptive statistics, data visualization, clustering, and time series analysis to uncover insights and inform decision-making processes.

• Oversaw the full lifecycle of Enterprise Data Warehouse projects using Talend, resulting in 20% enhancement in data retrieval speeds and decrease in data redundancy

Data Analyst Intern, TATA Consultancy Services Bangalore, India Jun 2020 - Aug 2020

• Created and managed 20+ Power BI dashboards with real-time data visualizations for executive review, resulting in a 25% improvement in decision-making speed

• Developed and optimized complex SQL queries to extract and analyze data for generating business intelligence ACADEMIC & PROFESSIONAL PROJECTS

STOCK PRICE TRACKING AND ANALYSIS [Alteryx, Talend, SQL server] Data Visualization Project

• Extracted financial data from CSVs using Alteryx, created a dynamic stage table in SQL server Database, and achieved a 95% accuracy rate in tracking historical price changes by implementing SCD2 logic in Talend

• Implemented ETL processes, reducing data processing time by 40%, and meticulously documented load metrics for process optimization

REMOTE CONSALTING DATABASE SYSYTEM [SQL server, Tableau] Database project

• Designed a relational database for operations and records management for an online Remote consulting database system using SQL server

• Performed conceptual modeling of the database by designing the Modeling Language (UML) diagram by specifying the different types of entities, attributes, and cardinalities

• Through the adept use of Tableau, I provided insightful analytics and real-time dashboard reporting, enhancing the decision- making process

ECOMMERCE INSIGHTS-POWER BI DRIVERN SALES ANALYSIS [Python, Power BI] Data Visualization Project

• Developed a comprehensive sales analysis and optimization dashboard, using a dataset obtained from Kaggle

• Performed data cleaning and transformed the unstructured dataset to a dataset suitable for analysis using NumPy and Pandas libraries.

• Created an interactive dashboard by engaging informative reports generated from the data and created KPI visuals by creating custom measures which helped gain insights on the sales divided by consumer segments and area of sales.

Contact this candidate