Data Analyst

Manish Shetty

347-***-**** • *************@*******.*** • linkedin.com/in/manish-shettty

Atlanta, GA

CAREER OBJECTIVE

Self-Motivated, teamwork-oriented developer with a master’s degree, skilled in designing and implementing relational and dimensional data models. Proficient in T-SQL development and experienced in crafting efficient ETL strategies using SSIS and Azure Data Factory. Adept at transforming raw data into actionable insights, optimizing data processes, and creating visually appealing reports and dashboards. Seeking a challenging role to leverage skills in data analysis, data warehousing, and business intelligence to contribute to organizational success.

PROFESSIONAL EXPERIENCE

Mellow Mushroom, Atlanta, GA Dec 2022 – Dec 2023

Data Engineer

Tools & Environment: SQL Server, SSMS, T-SQL, SSAS, Azure Data Factory, Redgate, Data Bricks, DAX Studio, Power BI

Collaborated with data architect and implemented scalable ETL pipelines to load large datasets into data warehouse

Designed and developed data warehousing solutions, including development of star schemas and snowflake schemas

Integrated Slowly Changing Dimensions (SCD) methodologies for improved historical data tracking

Conducted data analysis to identify and resolve data quality issues, ensuring the accuracy of the datasets

Interface and gather reporting requirements from cross-functional department leaders and users of data including marketing, operations, and finance

Utilized dimensional modelling techniques to design data marts (Labor data, Sales and Transactions) to facilitate efficient and targeted analysis

Designed and implemented tabular model on yearly sales, transactions, guest feedback, and inventory data to support complex reporting requirements

Collaborated with business users to understand reporting requirements

Authored DAX measures to enhance the depth and accuracy of analytical insights

Implemented Time Intelligence functions in DAX to enable date-based analysis over time periods in Power BI reports

Implemented Calculation groups in cube to enable reusable and structured calculations in various reporting scenarios

Utilized drill-through functionality to create detailed and interactive views of data, providing users with ability to investigate specific data points further

Developed dashboards that utilized bookmarks to allow for customizable and specific data views

Conducted performance optimizations for reports and cube to improve load time and user experience

Maintained and updated Power BI reports and dashboards in response to evolving business needs and data sources

Wrote and maintained technical documents that describe analytic system (MS Vizio, Lucid charts) that serve as foundation of knowledge sharing and user facing reference documentation

Maintained a comprehensive report design documents, detailing report structure, and data sources which served as a reference for future development.

CCS Global Tech, Poway, CA May 2021 – Dec 2022

Data Engineer (Consultant) at FoodChainID, Fairfield, IA

Tools & Environment: SQL Server, SSMS, T-SQL, Azure Data Factory, Redgate

Prepared mapping documentation for migration of data from MS Access to SQL server

Developed database objects such as tables, stored procedures, functions, and views

Assisted developers by creating functions and stored procedures for API

Conducted requirements gathering meetings with business stakeholders

Developed and implemented data cleansing, data security, data profiling and data monitoring processes

Performed data cleaning process applied Backward - Forward filling methods on dataset for handling missing values

Facilitated data collection sessions and analyzed data processes, scenarios, and information flow

Resolved multiple data governance issues to support data consistency at the enterprise level

Developed data mapping, data governance, transformation and cleansing rules for the Master Data Management Architecture involving OLTP and OLAP

Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram

Developed pipeline for migrating data from Azure Data Lake to development database

Migrated data from legacy database to SQL server using complex stored procedures and Azure Data Factory

Implemented Azure Data Factory operations and deployed into Azure for moving data from on-premises into cloud

Authored and maintained company data dictionary

Developed complex SQL stored procedure to provide data to legacy applications from the active database

PCS Global Tech, Wayne, PA April 2021 – May 2021

Data Analyst Intern

Worked on all phases of Database development lifecycle from gathering requirements to testing, implementation and support

Applied data modeling in Relational Database System

Authored SQL/TSQL queries to develop database objects such as tables, stored procedures, functions, and views

Used statistical techniques for hypothesis testing to validate data and interpretations

SKILLS

T-SQL, Dynamic SQL, ETL

Visual Studio, DAX Studio

Data visualization: Power BI

Azure SQL, Azure Data Factory

SSMS, SSAS (Tabular), SSRS

Python (NumPy, Pandas, Matplotlib)

EDUCATION

University of Alabama at Birmingham, Birmingham, AL USA Dec 2020

Master’s in Electrical and Computer Engineering

• Excelled in Machine Learning and Big Data coursework

• Worked on Azure platform to manage database as a part of Cloud Computing coursework

Sahyadri College of Engineering and Management, Mangalore, India June 2018

Bachelors in Electronics and Communication Engineering

ACADEMIC/RESEARCH PROJECTS

Image Caption Generation using Transfer Learning

Presented a neural network model which generates caption for a given image

Introduced Transfer learning method to reduce the time required to train the model

Utilized python’s text-to-speech conversion library to read aloud the generated caption

GitHub link: https://github.com/ManishShettty/ImageCaptioning/blob/main/Image%20Captioning.pdf

Contact this candidate