Dileep Kumar Vangapandu
Austin,TX
Summary
Accomplished Senior Data Governance Analyst with expertise in SAP ECC and data harmonization at State Street. Led ERP migration projects, enhancing data accuracy by 30%. Skilled in mentoring and collaboration, driving strategic initiatives. Proficient in Databricks and Excel, delivering insights for decision-making.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Senior Data Governance Analyst – Finance Systems
State Street
Austin, TX
07.2023 - Current
- Managed finance master data (GL accounts, cost centers, profit centers) in SAP ECC and MDG, ensuring global data requests were validated and processed according to policy.
- Led data cleansing and harmonization projects in SAP ahead of ERP migration, identifying duplicates and aligning data to corporate finance standards.
- Worked with the Analytics team to build checks in Databricks and Excel dashboards, helping business users quickly identify inconsistencies in reporting data.
- Represented Finance Systems in the Data Governance Council, sharing practical issues from daily operations and contributing to long-term governance KPIs.
- Mentored junior analysts by reviewing their SAP MDG work and coaching them on data governance processes.
- Supported M&A integration activities by mapping finance master data from acquired entities into SAP BPC for consolidated reporting.
- Analyzed data sets to identify trends and insights for decision-making.
- Assisted in preparing reports to support strategic planning initiatives.
- Collaborated with team members to streamline processes and improve efficiency.
- Conducted research to inform project development and recommendations.
SAP Financial Analyst
Capgemini Technology Services
Pune, India
01.2022 - 08.2022
- Maintained day-to-day finance master data in SAP ECC, ensuring compliance with global standards.
- Worked with finance managers to clean and validate legacy SAP data before system migration, reducing reconciliation errors during testing.
- Designed Excel reconciliation templates with formulas (VLOOKUP, Pivot Tables) to simplify comparisons between migrated and legacy datasets.
- Worked on ERP enhancement projects by performing UAT testing in SAP COPA/BPC, validating that financial reporting matched business expectations.
- Assisted the Close Support team in troubleshooting master data-related errors during month-end close.
Jr. SAP Financial Analyst
Intellisoft Pvt Ltd
India
03.2021 - 01.2022
- Created and updated finance master data in SAP ECC (cost centers, profit centers, GL master data) under senior analyst supervision.
- Performed routine SAP data validation checks to identify missing attributes or inconsistent entries.
- Helped business users with SAP finance navigation and reporting queries.
- Documented common SAP finance issues and created simple training notes for end users.
- Participated in a finance data clean-up initiative, standardizing cost center naming conventions in SAP.
Data Analyst (Financial Systems)
Cognizant Technology Solutions, CTS
India
10.2019 - 03.2021
- Analyzed and validated financial datasets across systems using Excel (Pivot Tables, Lookups, conditional formulas) to ensure accuracy before reporting deadlines.
- Supported a finance system upgrade by validating SAP test data against legacy system records.
- Created recurring Excel reports to highlight mismatches between transactions recorded in SAP and downstream reporting tools.
- Responded to finance team requests for data corrections and documented root causes for recurring data issues.
- Suggested small automation improvements (Excel macros) that reduced manual reconciliation effort.
Education
Master of Science - Data Science
SUNY At Albany
Albany, NY12-2023
Skills
- SAP ECC (Finance/GL, AP, AR modules)
- SAP MDG
- SAP COPA
- SAP BPC
- Databricks
- SQL
- Microsoft Excel
- ERP Migration Support
- Financial Systems Reconciliation
- PowerBI
- AWS
Certification
Microsoft Certified: Power BI Data Analyst Associate
AWS Certified Solutions Architect - Associate
AWS Certified Cloud Practitioner
Timeline
Senior Data Governance Analyst – Finance Systems
State Street
07.2023 - Current
SAP Financial Analyst
Capgemini Technology Services
01.2022 - 08.2022
Jr. SAP Financial Analyst
Intellisoft Pvt Ltd
03.2021 - 01.2022
Data Analyst (Financial Systems)
Cognizant Technology Solutions, CTS
10.2019 - 03.2021
Master of Science - Data Science
SUNY At Albany