Srinivas Reddy Gundeti
Fairfield,CT
Summary
Seasoned Data Analyst with a proven track record at Bank of America, adept in Python programming and strategic business planning. Spearheaded data integrity initiatives, reducing inconsistencies by 20%, and enhanced customer conversion rates through A/B testing. Excels in collaborative projects, leveraging SQL and NoSQL databases for insightful business intelligence and reporting. Logical data analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with Three years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
Bank of America
New York, NY
11.2023 - Current
- Lead the preparation of LOEs (List of Elements/Features) in Share-point, outlining deliverable for each quarter to align with strategic goals and timeline
- Develop comprehensive user stories for new features, ensuring clarity and traceability throughout the development life-cycle
- Direct data collection efforts across multiple financial systems, ensuring data integrity and completeness for regulatory reporting and business analysis
- Design and implement robust data cleaning and preprocessing pipelines using Python (Pandas) and SQL, reducing data inconsistencies by 20%
- Drive A/B testing initiatives to evaluate new financial products, achieving a 15% increase in customer conversion rates through rigorous experimentation
- Analyze diverse data sets by querying S3, Oracle, and MongoDB databases, delivering actionable insights and solutions across various use cases
- Collaborate with cross-functional data teams to generate and distribute weekly reports, providing stakeholders with timely and accurate updates
- Lead end-to-end development of new mobile features, from conceptualization and design to implementation and deployment
- Develop and optimize SQL and Python queries to support data analysis, reporting, and business intelligence needs
- Environment: Stakeholders, No SQL/SQL, Python, AWS S3, Oracle, Mongo dB
Data Analyst
9th Networks Inc
India
01.2021 - 07.2022
- Analyzed business requirements and provided end-to-end solution design for data modeling
- Writing code as needed for the development of reports, analytics, and visualization of NO SQL/SQL, data models, and semantic models
- Worked on data modeling, building, and creating data visualization, BI reports, and dashboards for multiple applications
- Worked with the client to understand users, the marketplace, the competition, and future trends for the domain in which the client’s Business lives
- Prepared Functional requirement documents (FSD) to translate the Business needs into system requirements and communicate with the Business on a non-technical level
- Responsible for creating Business Objects definition document to map the source system attributes to the reporting fields
- Used Jira tool for defect tracking and reporting bugs
- Extracted data from AWS S3 into data frames, and performed transformations, and actions on data frames
- Performed data visualization and Designed dashboards and generated complex reports, including charts, summaries, and graphs to interpret findings to team and stakeholders
- Environment: Stakeholders, SQL, Databases, Microsoft Excel, AWS S3, Oracle, mongo dB
Python Developer
9th Networks Inc
India
08.2020 - 01.2021
- Collaborated with the development team to design and implement new features for web applications using Python and Django
- Assisted in the development and maintenance of RESTful APIs to support frontend applications
- Wrote clean, maintainable code following best practices and coding standards
- Participated in code reviews and contributed to team discussions to enhance overall code quality
- Conducted testing and debugging of applications to ensure functionality and performance
- Helped in data analysis tasks using libraries like Pandas and NumPy to extract insights from datasets
- Documented development processes and created user guides for future reference
- Environment: Python (Programming Language), Django, NumPy, pandas
Education
MASTER’S - COMPUTER AND INFORMATION SCIENCES
Sacred Heart University
Fairfield, Connecticut, USA12.2023
BACHELOR’S - COMPUTER SCIENCE AND ENGINEERING
Lovely Professional University
Phargwar, Punjab, India05.2021
Skills
- Structured query language (SQL)
- Python Programming
- NoSQL Databases
- Database Management
- Strategic business planning
- Tableau
- Microsoft Excel
- Spreadsheet
- Software Testing Life Cycle (STLC)
- Agile methodology
- AWS S3
- Oracle
- MongoDB
- Project Management
- Data Modeling
- Report Writing
- Defect tracking
- Database Maintenance
- Data formatting
- Software Development Life Cycle (SDLC)
- ETL processes
- Data Visualization and Presentation
Certification
- 2018, C Programming, Internshala
- 2019, Data Science, Internshala
Projects
New York Parking Management System
GROUP PROJECT, 09/01/23 - 12/31/23
- Actively participated in project planning, including feature prioritization and task assignment.
- Conducted regular team meetings to discuss progress, challenges, and solutions.
- Collaborated on troubleshooting and debugging efforts, resolving issues promptly. Contributed to both frontend and backend development, ensuring seamless integration and functionality of the entire application.
- Led the backend development efforts for the New York Parking Management System using Python and Django.,
- Responsible for the front-end development of the New York Parking Management System, leveraging HTML, CSS, and JavaScript.
- Conducted thorough testing of backend functionalities, identifying, and addressing bugs and performance issues.
- Implemented real-time updates for parking availability, enhancing user engagement and experience.
- Conducted extensive testing of the front-end components, addressing cross-browser compatibility and responsiveness.
Pizza Delivery Management System
PERSONAL PROJECT, 09/01/19 - 10/31/19
- Built Using Python (numpy, pandas, matplotlib, seaborn)., This project is about designing a website for pizza ordering and delivering.
- Posed questions, wrangled, explored the data and gained some insights which I visualized using python matplotlib and seaborn packages.
Social Networking Site
PERSONAL PROJECT, 03/01/19 - 05/31/19
- Built Using HTML, CSS3, BOOTSTRAP and JAVASCRIPT.
- The project 'Social Networking Site' is a web-based project.
- In this website, we can connect with friends, message them and can update our profile.
- Included some basic functionalities like credentials validation, etc.
Medical Management System
PERSONAL PROJECT, 09/01/18 - 10/31/18
- Built Using C Programming.
- This project is about management of medicines in a medical store like medicines available and their price.
Electricity Bill Calculator
PERSONAL PROJECT, 04/01/18 - 05/31/18
- Built Using File Handling in C++.
- The project was to write a program for Electricity Bill Calculator which can calculate, generate, save the details of bill.
- It is a user-friendly program which can be easily understandable.
Languages
English
Native/ Bilingual
Hindi
Full Professional
Telugu
Native/ Bilingual
Timeline
Data Analyst
Bank of America
11.2023 - Current
Data Analyst
9th Networks Inc
01.2021 - 07.2022
Python Developer
9th Networks Inc
08.2020 - 01.2021
MASTER’S - COMPUTER AND INFORMATION SCIENCES
Sacred Heart University
BACHELOR’S - COMPUTER SCIENCE AND ENGINEERING
Lovely Professional University
Similar Profiles
Nicholas ShakanNicholas Shakan
Vice President, Portfolio Manager at Bank of America Private BankVice President, Portfolio Manager at Bank of America Private Bank
Anne MilneAnne Milne
Managing Director - Global Head EM Credit Research at Bank of AmericaManaging Director - Global Head EM Credit Research at Bank of America
Samantha DempseySamantha Dempsey
Fraud Servicing Representative at Bank of AmericaFraud Servicing Representative at Bank of America
Yaquelin GuevaraYaquelin Guevara
Relationship Manager Business Owner Specialist at Bank Of AmericaRelationship Manager Business Owner Specialist at Bank Of America
David GrellaDavid Grella
Store Manager at Golf GalaxyStore Manager at Golf Galaxy