Sarah Gangavarapu

• Business analyst with 3+ years of experience in consumer financial services, including work at Synchrony Financial supporting credit card private label and retail partner programs.
• Supported requirements gathering, process improvement, and data analysis, ensuring successful delivery across full SDLC in agile and waterfall environments.
• Translated business needs into functional requirements, enabling alignment among stakeholders, product owners, technology teams, and risk and compliance partners.
• Data analysis and querying: SQL (Oracle, SQL Server), MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, macros), MS Access.
• Reporting and visualization: Tableau, Power BI, Excel dashboards.
• Process modeling and documentation: MS Visio, Lucidchart, Draw.io, MS Word, MS PowerPoint.
• Testing and defect tracking: Jira, HP ALM/Quality Center, Zephyr, TestRail, Postman (API testing).
• Developed prototypes for user interface designs and wireframing: Balsamiq, Figma.
• Methodologies and frameworks: Agile/Scrum, Waterfall SDLC, Kanban, Lean Six Sigma.

• Analyzed sales and inventory data using SQL, Excel, and Power BI/Tableau, tracked KPIs, and built dashboards to support data-driven decision-making. Collaborated with merchandising, supply chain, and store teams to provide data-driven recommendations enhancing profitability and customer experience.

Skills

• Data Querying and Databases: SQL, MySQL, SQL Server, PostgreSQL
• Spreadsheets and Analysis: MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Query, Formulas, Macros), Google Sheets
• Visualization and BI: Power BI, Tableau, Looker Studio
• Programming (if used): Python (Pandas, NumPy, Matplotlib), R
• Data Sources and Systems: ERP Systems, POS Data, CRM Data, Inventory Management Systems
• Documentation and Collaboration: MS PowerPoint, MS Word, JIRA, Confluence, Microsoft Teams