Open to opportunities

Srujana P

@srujanap

Message

I build governed Power BI, SQL, and automation solutions that improve operational reporting and decision-making.

United States

Message

What I'm looking for

I'm looking to build governed reporting, analytics, and automation that replace manual processes, improve operational efficiency, and support sound strategic decision-making.

I'm building agency travel reporting and contract lifecycle automation for the State of Oklahoma Department of Rehabilitation Services, turning manual analysis into repeatable Power BI, Excel, SharePoint, and Power Automate workflows.

Previously at CloudIntellisoft, I delivered standardized operational, clinical, finance, and compliance reporting across 15+ healthcare facilities. I improved reporting refresh latency by approximately 60%, helped reduce excess inventory by approximately 12% through Python forecasting, and increased dashboard adoption by approximately 40%.

At Meritshot, I connected campaign, customer, web analytics, and operational data to improve attribution analysis by approximately 18% and support approximately 10% lower advertising spend. Earlier at Accenture, I supported Medicaid reporting and system enhancements through requirements, data mapping, reconciliation, UAT, and HIPAA-compliant reporting.

I work closely with business, technical, and compliance teams to turn ambiguous operational problems into governed data products, practical automation, and clear KPI reporting.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Analyst

Current

State of Oklahoma – Department of Rehabilitation Services

Jan 2026 - Present (7 months)

Managed multiple concurrent business analysis and process improvement initiatives across HR, contract operations, agency travel reporting, and purchasing. Developed agency travel reporting in Power BI and Excel and improved contract lifecycle management for 800+ records using SharePoint and Power Automate workflows.

Power BI Excel SharePoint Power Automate Celonis Peoplesoft Smartsheet Business Analysis Process Improvement Requirements Gathering Process Mapping Data Mapping Workflow Automation

Senior Data Analyst

CloudIntellisoft Inc

Aug 2024 - Dec 2025 (1 year 4 months)

Collaborated with stakeholders across 15+ healthcare facilities to define reporting requirements and KPIs, building Power BI dashboards for operational performance and compliance. Improved reporting performance on datasets exceeding 1 million records by refining SQL queries, reducing refresh latency by approximately 60%.

Power BI DAX SQL Server T SQL Python Pandas Azure SQL Azure Data Factory Databricks PySpark Snowflake Data Analysis KPIs Stakeholder Management HIPAA

Senior Data Analyst

Meritshot

Jan 2023 - May 2024 (1 year 4 months)

Improved campaign attribution analysis by approximately 18% using SQL, Google Analytics, and standardized conversion logic. Built Power BI reporting integrating campaign, customer, web analytics, and operational data, and replaced manual extraction with SSIS-based workflows.

SQL Power BI DAX SSIS Google Analytics Excel Data Reconciliation Business Rules Stakeholder Management

Data Analyst

Accenture

Jul 2020 - Jul 2022 (2 years)

Analyzed Medicaid claims, eligibility, provider, and payment workflows, translating business and regulatory needs into functional requirements and data mappings. Developed Power BI and SSRS dashboards that reduced manual report preparation by approximately 30% and coordinated UAT for reporting enhancements.