Gowtham Vangapandu
Newark
Summary
Results-driven Business Analyst with around 4 years of experience in data analysis, process optimization, and strategic decisionmaking. Skilled in gathering requirements, identifying business needs, and implementing data-driven solutions to enhance efficiency. Proficient in SQL, Power BI, and Tableau for reporting, visualization, and KPI tracking. Strong expertise in stakeholder collaboration, workflow automation, and cross-functional communication. Adept at driving business growth through market research, predictive analytics, and process improvements.
Overview
5
5
years of professional experience
Work History
Business Analyst
JPMorgan Chase & Co.
NY
04.2024 - Current
- Facilitated UAT, developed comprehensive Test Planning and Execution strategies, and employed strong Problem-Solving and Analysis to ensure product quality and client satisfaction
- Created detailed BRDs and led cross-functional teams through Agile methodologies to deliver high-impact solutions, ensuring alignment with business goals and timely project completion
- Developed complex ETL scripts and optimized Power BI DAX queries to enhance data processing speed, improving reporting accuracy for strategic decision-making
- Managed JIRA backlog and implemented Agile methodologies to streamline workflows, increasing team collaboration and accelerating project delivery by 30%
- Refined financial modelling techniques using Python, delivering more accurate revenue forecasts that informed budget decisions, impacting resource allocation positively by 22%
- Optimized SQL queries and PostgreSQL database structures, resulting in a 30% reduction in query execution time and enhancing data retrieval efficiency for business analytics
- Handled end-to-end SDLC using Agile methodologies, ensuring seamless user story creation and story mapping for efficient backlog prioritization, product development, collaboration, and scalability
- Automated reporting processes using advanced Excel functions such as pivot tables and VLOOKUP, automated reporting processes were developed
Business Analyst
Mphasis Limited
India
01.2020 - 11.2022
- Engineered and maintained CRM databases using SQL, improving customer data management and increasing operational efficiency for enhanced business performance
- Constructed interactive dashboards in Tableau and Excel, incorporating data storytelling techniques to present insights effectively and drive strategic actions, enabling executives to make data-driven decisions faster
- Functioned with key stakeholders to create thorough Functional Requirement Documents (FRD), which ensured that project goals and requirements were communicated clearly and reduced scope modifications throughout development by 15%
- Coordinated with stakeholders through Trello to gather and document detailed business requirements, ensuring alignment and clarity throughout the project
- Proficient in applying Scrum to create and prioritize user stories, ensuring clear requirements and seamless collaboration, resulting in timely delivery and enhanced product quality
- Implemented Python and Pandas for efficient Data Cleaning and Transformation, ensuring 99% data accuracy, consistency, reliability, automation, scalability, and optimized data processing
- Conducted GAP Analysis, Risk Analysis, and SWOT Analysis to identify process inefficiencies, mitigate potential risks, enhance strategic planning, reducing operational risks by 30%, and driving business growth
- Optimized data manipulation and analysis using R and dplyr, improving data wrangling, transformation, aggregation, filtering, reporting, visualization, efficiency, and decision-making by 40%
Education
Master's - Computer Science
Wilmington University
New Castle, DE, USABachelors - Electronics and Telecommunication
Sri Kinjarapu Yerrannaidu College of Agricultural Sciences
AP, IndiaSkills
- SDLC
- Agile/Scrum
- Kanban
- Lean
- Design Thinking
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Statsmodels
- Plotly
- Scikit-learn
- SQL
- Dplyr
- Ggplot2
- Tidyr
- Functional Requirements Document (FRD)
- Business Requirements Document (BRD)
- MS SharePoint
- Confluence
- User Stories
- Use Cases
- Wireframing Tools
- MS Project
- JIRA
- Trello
- Asana
- Tableau
- Power BI
- MS Excel
- Looker
- Cost/Benefit Analysis
- Impact Analysis
- GAP Analysis
- Risk Analysis
- SWOT Analysis
- KPI Management
- Risk Identification
- Data Modeling
- Predictive Analysis
- MySQL
- SQL Server
- MongoDB
- PostgreSQL
- Microsoft Visio
- BPMN
- JAD
- RTM
- UAT
- Process Improvement
- Stakeholder Management
- Effective Communication
- Facilitation
- Negotiation
- Change Management
- Data Warehousing
- CRM Systems
- ERP Systems
Timeline
Business Analyst
JPMorgan Chase & Co.
04.2024 - Current
Business Analyst
Mphasis Limited
01.2020 - 11.2022
Master's - Computer Science
Wilmington University
Bachelors - Electronics and Telecommunication
Sri Kinjarapu Yerrannaidu College of Agricultural Sciences