Manoj Kumar Sannapaneni
Bellevue,WA
Summary
Experienced data analyst with a strong background in SQL, Python, and data visualization tools. Skilled in extracting and analyzing real-time data from databases, applying advanced statistical techniques for forecasting and optimization, and creating interactive dashboards for tracking key performance indicators. Proven ability to provide actionable insights and support data-driven decision-making.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst Intern
Navigo IT
01.2023 - 05.2023
- Utilized Apache Spark, Python and SQL in analyzing real-time user data, log event analysis and behavior
- Demonstrated proficiency in using Apache Cassandra and Amazon DynamoDB for managing large-scale data
- Leveraged AWS cloud services for scalable data storage and computing resources
- Implemented data cleaning pipeline, improving data accuracy and reducing inconsistencies by 30%
- Improved data access and query performance by 25% through efficient schema design in MongoDB.
Data Analyst
TATA AIG General Insurance Company
01.2021 - 09.2021
- Utilized advanced SQL queries and Python libraries for insurance-specific data analysis
- Developed Tableau dashboards for real-time insights into claims, underwriting, and customer analytics
- Streamlined claims processing through automated procedures, reducing processing time by 20%
- Built risk assessment model through predictive analysis, reducing claim frequency by 10%.
- Deployed predictive analytics models to forecast future trends.
Business Data Analyst
ICICI Prudential Life Insurance Company
06.2019 - 01.2021
- Performed data mining using SQL and Python on extensive insurance datasets
- Created Power BI and Tableau dashboards for tracking KPIs
- Implemented predictive churn model, reducing customer churn rate by 15%
- Improved claims processing procedures, leading to 25% reduction in processing time and annual cost savings of INR 10,00,000
Education
Master of Science - Management Information Systems
Northern Illinois University
DeKalb, IL05.2023
MBA - Operations and Marketing
Ramaiah Institute of Management
Bangalore, India05.2019
Bachelors - Electronics and Communications Engineering
RMD Engineering College
Chennai, India04.2017
Skills
- Programming Languages: Python, SQL, CSS, HTML
- Databases: MySQL, MongoDB, Microsoft Azure DB
- Tools/Frameworks: SAP, MS Excel(Pivot tables, VLOOKUP), MS Access, MS PowerPoint, Tableau, Power BI, Node XL, REST API, AWS, ETL
- Operating systems: Windows, Linux, MacOS
- Data quality assurance processes, Predictive modeling, Marketing research
- Software Development Life Cycle (SDLC)
Certification
SAP Certified Application Associate - Business Process Integration with SAP S/4HANA 2020
Projects
Data Analysis of AT&T Refurbished Data:
Utilized SQL for data extraction, manipulation, and summarization of AT&T refurbished test data.
Employed strategic SQL techniques such as indexing, query optimization, subqueries, and query tuning.
Gained a comprehensive understanding of Data Warehousing concepts such as Star Schema, Snowflake Schema, OLAP, and OLTP.
Analysis of COVID-19 Data:
Conducted in-depth analysis of COVID-19 data using Python libraries (Pandas, Matplotlib, and Seaborn).
Presented visualizations of data trends and insights using Tableau.
Received commendation for providing valuable insights and contributing to local pandemic response efforts.
Timeline
Data Analyst Intern
Navigo IT
01.2023 - 05.2023
Data Analyst
TATA AIG General Insurance Company
01.2021 - 09.2021
Business Data Analyst
ICICI Prudential Life Insurance Company
06.2019 - 01.2021
Master of Science - Management Information Systems
Northern Illinois University
MBA - Operations and Marketing
Ramaiah Institute of Management
Bachelors - Electronics and Communications Engineering
RMD Engineering College
Similar Profiles
Diana ShmurunDiana Shmurun
RN Discharge Planner at VA Puget Sound Health Care SystemRN Discharge Planner at VA Puget Sound Health Care System
Brendan FarleyBrendan Farley
Parking Ambassador at Republic ParkingParking Ambassador at Republic Parking
Chunhai YangChunhai Yang
Sale Associate at Ethen FoodsSale Associate at Ethen Foods
Anoop Muraleedharan NairAnoop Muraleedharan Nair
Quality Assurance Engineer II – Alexa Video at AmazonQuality Assurance Engineer II – Alexa Video at Amazon
Jetta OskirkoJetta Oskirko
Data Research/Data Analyst Intern at Metrowest Economic Research CenterData Research/Data Analyst Intern at Metrowest Economic Research Center