PhaniSai Ankarla

Data Analyst

Juniper Networks

Jul 2025 - Current (1 year 1 month)

• Developed and deployed interactive Power BI dashboards for sales, pipeline, and SLA reporting; consolidated spreadsheets into a governed model, cutting weekly reporting time by 40% and boosting adoption of a "single source of truth." • Engineered SQL joins and transformations across product, account, and entitlement data; implemented validation and error handling that reduced downstream defect tickets and improved data reliability. • Defined and operationalized business KPIs (win rate, cycle time, attach, churn risk) in partnership with finance/ops; authored metric documentation to ensure cross-team consistency and audit readiness. • Automated data refreshes using Power Query and parameterized Excel macros; streamlined ad-hoc reportin

Business Analyst / BI Analyst

Mastek

Jul 2021 - Jul 2023 (2 years 1 month)

• Led requirements gathering for data/reporting workstreams: discovery, BRD/FRD, user stories, acceptance criteria; standardized business rules across finance, sales, and service, eliminating conflicting definitions. • Designed, governed, and maintained Tableau/Power BI dashboards for executive scorecards and operational health; instituted row-level security and version control to protect sensitive data. • Performed gap analysis and process re-engineering, removing redundant handoffs; improved cycle times by 20% and laid groundwork for API/ETL automation. • Directed UAT cycles with business owners: built test cases, managed defect triage, and set sign-off criteria; reduced post release issues through tighter requirement-to-test traceabi

A

Business Analyst

Allsec Technologies

Jul 2019 - Jun 2021 (2 years)

• Led requirements gathering for data/reporting workstreams: discovery, BRD/FRD, user stories, acceptance criteria; standardized business rules across finance, sales, and service, eliminating conflicting definitions. • Designed, governed, and maintained Tableau/Power BI dashboards for executive scorecards and operational health; instituted row-level security and version control to protect sensitive data. • Performed gap analysis and process re-engineering, removing redundant handoffs; improved cycle times by 20% and laid groundwork for API/ETL automation. • Directed UAT cycles with business owners: built test cases, managed defect triage, and set sign-off criteria; reduced post release issues through tighter requirement-to-test traceabi

B

Business Analyst Intern

Jan 2019 - Jun 2019 (6 months)

• Queried and cleansed MySQL/MS SQL data with Excel/Power Query to deliver accurate SLA, AHT, and quality audit metrics; reduced reconciliation errors and disputes. • Built and deployed KPI dashboards in Excel/Tableau with drill-downs and thresholds; enabled leadership to identify bottlenecks, lifting compliance and resolution metrics. • Mapped processes and defined RACI ownership, reducing escalations and clarifying accountability across teams. • Instituted data governance controls (valid ranges, referential integrity, date normalization) and documented lineage for compliance and audit transparency.

About

Detail

Timeline

Résumé