Summary
Work History
Education
Skills
Websites
Timeline
Generic

Pranavi Jannu

Chicago

Summary

Dynamic Business Analyst with a proven track record at Microsoft Corporation, leveraging SQL and stakeholder communication to enhance e-commerce and financial systems. Successfully improved workflows and compliance, while delivering impactful dashboards and reports. Adept at requirements gathering and process mapping, driving significant operational efficiencies and informed decision-making.

Work History

Business Analyst

Microsoft Corporation
  • Gathered and documented business requirements across e‑commerce, HCM, finance, trading, and retirement plan systems.
  • Performed gap analysis, impact analysis, and feasibility checks to support system upgrades and process improvements.
  • Built dashboards and reports using SQL, Power BI, Tableau, and Cognos to support leadership decision‑making.
  • Improved O2C/I2C, payroll, HR, and trading workflows by identifying issues and recommending fixes.
  • Supported integrations with payment gateways, banking APIs, CRM systems, and cloud migration projects.
  • Wrote user stories, acceptance criteria, and maintained Agile documentation while working with product, dev, QA, and UX teams.
  • Helped compliance teams meet FINRA, SEC, MiFID II, AML, SOX, and payroll audit requirements.
  • Planned and executed UAT by preparing test cases, tracking defects, and coordinating with business users.
  • Created use cases, wireframes, and process flows to clearly explain system behavior and requirements.
  • Managed reporting needs by designing KPIs, dashboards, and performance metrics for different business units.
  • Analyzed SQL data to support delinquency, payment, recovery, and operational reporting.
  • Coordinated with onshore, offshore, and vendor teams to support requirement gathering, testing, and deployments.
  • Supported ERP/CRM implementations (SAP, Oracle, MS Dynamics, Salesforce) by validating configurations and integrations.
  • Identified automation opportunities and worked with RPA/AI teams to reduce manual work.
  • Acted as a main point of contact for cross‑team issues, status updates, and project coordination.

Associate Business Analyst

Label Master
  • Analyzed e‑commerce transaction data to understand customer behavior, improve conversions, and reduce fraud risks.
  • Reviewed legacy brokerage systems, identified gaps, and recommended solutions for migration to modern trading platforms.
  • Ensured SOX, audit, and financial policy compliance across O2C/I2C processes.
  • Performed retirement account data analysis to support planning decisions and improve reporting accuracy.
  • Streamlined O2C and I2C workflows with cross‑functional teams, reducing processing time and errors.
  • Gathered business requirements and translated them into technical specifications for integrations and system upgrades.
  • Designed dashboards and reports in Power BI, Tableau, and Excel for real‑time insights.
  • Prepared BRDs, user stories, acceptance criteria, and process flows for payment systems and banking integrations.
  • Captured and refined functional and non‑functional requirements for payment gateways, APIs, and online banking systems.
  • Built analytics and dashboards for brokerage transactions, including positions, P&L, and exception reporting.
  • Facilitated workshops and JAD sessions to validate requirements and align teams.
  • Performed data mapping and transformation to ensure accurate and consistent data across systems.
  • Coordinated UAT for trading, payment, and retirement systems, validating end‑to‑end functionality.
  • Used Jira and Azure DevOps for backlog management, sprint planning, and defect tracking.
  • Leveraged SQL and BI tools to track e‑commerce KPIs and provide insights for leadership.

Technical Analyst

Soft Think Solutions
  • Analysed system behaviour, data flows, and application performance to identify inefficiencies and propose technically sound enhancements.
  • Interpreted complex technical issues and translated them into clear, actionable insights for cross‑functional teams.
  • Collaborated with developers, QA teams, and business stakeholders to refine requirements, validate solutions, and ensure alignment with business objectives.
  • Utilized SQL, Python, and diagnostic tools to investigate root causes, optimize workflows, and support data‑driven decision‑making.
  • Documented system processes, functional specifications, and technical findings to support product improvements and operational clarity.
  • Supported UAT activities by validating feature functionality, identifying defects, and ensuring readiness for deployment.

Education

DePAUL UNIVERSITY
CHICAGO, IL

Skills

  • Python
  • SQL
  • Excel
  • Tableau
  • Power BI
  • Systems Analysis
  • Technical Troubleshooting
  • Root-Cause Analysis
  • Requirements Gathering
  • Process Mapping
  • Documentation
  • Stakeholder Communication
  • User Stories
  • Agile/Scrum
  • KPI Tracking
  • Data Visualization
  • Business Case Analysis

Timeline

Business Analyst

Microsoft Corporation

Associate Business Analyst

Label Master

Technical Analyst

Soft Think Solutions

DePAUL UNIVERSITY
Pranavi Jannu