Shriya Jami

Compliance and Data Governance

• Mapped and documented the end-to-end lineage of 150+ systems across the enterprise, collaborating one-on-one with technical managers to capture detailed data flows and dependencies.
• Led stakeholder engagements to gather technical insights, strengthening communication between business owners, developers, and compliance teams.
• Built business views using SQL queries in Azure Data Studio to identify data gaps and discrepancies within the bank’s existing PCI documentation.
• Designed and executed a fully automated data pipeline using Power Automate and Power Query to ingest, validate, and transform tabular compliance data for storage in a Microsoft SQL Server relational database.
• Utilized Azure Data Studio to develop complex SQL queries in a sandbox environment, aggregating and merging project datasets to produce actionable business intelligence views.
• Strengthened enterprise audit readiness by consolidating lineage artifacts, validating data flows, and aligning project deliverables with regulatory standards.

Process Automation and App Development

• Designed and built end-to-end automation solutions using Power Automate Web and Desktop Flows, integrating multiple business processes into a centralized system.
• Developed user-facing Power Apps canvas applications to streamline dynamic data entry processes, creating intuitive UIs for business users.
• Architected and implemented relational data schemas within Dataverse to support scalable app functionality, and maintain data integrity.

Business Intelligence and Data Validation

• Developed SQL-based reconciliation queries using Amazon Athena to validate large-scale data movement between Oracle and OpenSearch environments.
• Built interactive Tableau dashboards to visualize real-time pipeline validation metrics, reducing error detection time, and supporting agile project delivery.
• Constructed front-end OpenSearch queries to cross-validate reconciliation logic, and ensure data accuracy.
• Presented findings and dashboards during Agile sprint demos, enabling data-driven decision-making for client stakeholders.

• Evaluated the financial impacts of FY ’22 standard cost changes on overall profitability and develop recommendations to account for cost increases and raise pricing. Overall price impact was $900,000 through refreshed pricing guidance.

• Calculated FY ’22 burden cost rate based on historical SG&A (Selling, General, and Administrative) costs and OCOS (Operating Costs of Sales) costs to drive visibility to full product cost at the SKU level.

• Created visualizations around price increase elasticity to aid in communication and identification of pricing opportunities.

• Tracked the financial impact of the price and cost increases of the personal protective equipment related to COVID-19.

• Planned and executed workshops and events geared towards facilitating professional development.