Amogha Shettar
Data Analyst
Bengaluru,Karnataka
Summary
Detail-oriented Data Analyst with 3 years of experience in solving complex technical problems. Proficient in Python, SQL, Power BI, and Tableau, leveraging these technologies to handle large datasets and uncover actionable insights. Skilled in regression, forecasting, and NLP, with expertise in data cleaning, wrangling, visualization, and model training. Strong understanding of IT and business processes, specializing in building predictive models, optimizing processes, and driving innovation. A proactive problem-solver, adept at communicating complex data findings to stakeholders, enabling data-driven decision-making to support strategic growth and operational efficiency. Committed to continuous learning and pursuing diverse opportunities to expand expertise in the field.
Overview
5
5
years of professional experience
6
6
years of post-secondary education
Work History
Data Analyst
Griha Soft
Bengaluru
1 2023 - Current
- Developed complex SQL queries within SSIS for efficient data extraction, transformation, and loading processes
- Created and maintained ETL packages in Visual Studio to facilitate seamless data integration between various systems
- Developed custom Python scripts to automate the aggregation and analysis of transactional data, providing insights that led to a 15% reduction in operational costs
- Demonstrated strong expertise in automation by designing and implementing a Python-based algorithm, using Python libraries to efficiently retrieve, and process datasets on a monthly basis
- Developed a comprehensive inventory analysis system using Python and SQL, applying decision tree algorithms to identify key factors influencing inventory turnover
- Performed database de-fragmentation while optimizing the entire SQL queries, improving database performance and loading speed by 70%.
Fixed Income Quant Analyst
Jennison Associates
Boston
02.2022 - 08.2022
- Initiated and built a $1Bn in assets investment strategy model that reduced analysis time by 40% per week
- Designed and implemented a Python-based time-series Liability Driven model worth over $25 million assets, automating investment strategies, and reducing implementation time by 10-12 hours per week
- Standardized ETL processes to automate data extraction from Bloomberg into SQLite, improving data management efficiency
- Enhanced the database system by optimizing SQL queries thereby reducing data retrieval time by 25%
- Proposed and designed an algorithm in collaboration with a senior portfolio manager for an investment model
- Performed in-depth analysis, reporting, and visualization of raw data using advanced Excel functions, such as lookup, index match, pivot charts, and pivot tables.
Data Analyst
STEK INNOVATIONS
Hubballi
01.2020 - 06.2020
- Conducted trend analysis and market research to optimize the website, leading to a 15% year-to-date improvement in customer retention
- Leveraged historical transaction data for time series analysis of customer needs and behavior, proving valuable insights for marketing retention
- Developed and implemented a Content-Based Filtering algorithm for a recommender engine, automating recommendations and reducing manual effort by 40%
- Utilized Power BI for real-time data visualization, delivering actionable business insights to approx
- 35 clients.
Education
Master of Science - Data Analytics Engineering
Northeastern University
Boston, USA 09.2020 - 12.2022
Bachelor of Engineering - Computer Science And Engineering
KLE Technological University
Hubballi, India 08.2016 - 06.2020
Skills
Python
Skills
Data modeling, Data Analysis, Data Visualization, Statistical Analysis, Machine Learning
Interests
Badminton, Travelling, Movies, Cooking
Timeline
Fixed Income Quant Analyst
Jennison Associates
02.2022 - 08.2022
Master of Science - Data Analytics Engineering
Northeastern University
09.2020 - 12.2022
Data Analyst
STEK INNOVATIONS
01.2020 - 06.2020
Bachelor of Engineering - Computer Science And Engineering
KLE Technological University
08.2016 - 06.2020
Data Analyst
Griha Soft
1 2023 - Current
Similar Profiles
ANJALY SUSAN PHILIPANJALY SUSAN PHILIP
Civil Structural Engineer at Griha DesignsCivil Structural Engineer at Griha Designs
Nishant SharmaNishant Sharma
Business Owner Cum Truck Driver at Griha SajjaBusiness Owner Cum Truck Driver at Griha Sajja
Manish MishraManish Mishra
Assistant Project Manager at Subh Griha DevelopersAssistant Project Manager at Subh Griha Developers