Shirisha Lakkavarapu

Business Intelligence Analyst @Clearsulting

Houston, TX, US

Partnered with finance, risk, and product analytics teams to modernize enterprise reporting from Domo to Power BI on Azure, standardizing financial KPIs (revenue, profitability, portfolio health, risk-adjusted returns) to enhance transparency, accuracy, and governance.Designed and deployed Azure Data Factory (ADF) pipelines to integrate data from Salesforce, Workfront, Eloqua, and core financial systems into Azure Data Lake Storage Gen2, establishing a reliable raw → curated → semantic data flow with SLA monitoring and alerting.Modeled financial data marts in Azure Synapse Analytics using Star/Snowflake schemas and SCD Type 2 for key domains (clients, products, transactions, risk exposures), supporting regulatory, performance, and portfolio analytics.Delivered Power BI dashboards for executive financial reporting, marketing analytics, and operational intelligence, visualizing revenue performance, client retention, lead attribution, and risk exposure, increasing decision-making efficiency by 30%.Translated business requirements into BI specifications, collaborated with finance stakeholders to define KPI formulas, hierarchy definitions, and DAX measures, ensuring metric consistency across all reporting layers.Utilized Databricks (PySpark) for data transformation, outlier detection, and reconciliation across financial and operational datasets; integrated Great Expectations to validate data quality and ensure accuracy for audit and compliance.Implemented CI/CD pipelines in Azure DevOps for versioning and automated deployments of BI assets (ADF pipelines, notebooks, Power BI datasets), reducing manual release errors and accelerating production cycles.