Umashankar Pati

BI and Data Analytics professional with 13+ years of IT experience and 8 years of hands-on Power BI and SQL expertise. Experienced in enterprise dashboard delivery, semantic model design, DAX, dimensional modelling, data validation, stakeholder engagement and production support across Microsoft Fabric, Azure Databricks, Databricks SQL Warehouse, AWS Redshift and Azure SQL. Skilled in Python-based data analysis and automation using Pandas and NumPy, with working knowledge of Power Automate for workflow approvals, notifications and reporting process automation.

Strong background in banking, financial reporting, governance, reconciliation, UAT and cross-functional delivery.

Lead BI Engineer / AI-Enabled BI Engineer at R Systems International Ltd. (2025-03 – Present)

• Deliver Power BI, Microsoft Fabric and Azure Databricks analytics solutions for enterprise reporting, including semantic models, SQL views, KPI dashboards and client-facing validation.
• Design and enhance Power BI dashboards using Fabric semantic models and Databricks SQL Warehouse, improving KPI visibility, consistency and reporting confidence.
• Develop SQL and Python-based validation utilities to reconcile source-to-report totals, identify mismatches, verify joins and accelerate data-quality analysis.
• Create reporting views in AWS Redshift for country filters, parent/company relationships, shared dimensions and business-specific reporting logic used across Power BI and Sisense.
• Use Power Automate concepts for approval workflows, scheduled notifications, refresh alerts and operational hand-offs around BI reporting processes.
• Partner with stakeholders and QA teams to clarify requirements, document KPI definitions, analyze Jira defects and support SIT, UAT and production sign-off.
• Contribute to an AI Dashboard Generator that translates business requirements into KPI mappings, DAX, SQL logic, semantic-model outputs and dashboard recommendations.

Specialist - Data Analytics / Power BI Developer at Fiserv India Pvt. Ltd. (2020-02 – 2024-05)

• Built, published and supported interactive Power BI dashboards and scheduled refreshes for banking and financial reporting use cases.
• Designed semantic models, DAX measures, calculated columns and report navigation based on BRDs and stakeholder requirements.
• Implemented slicers, drill-down, drill-through, bookmarks, row-level security and usability improvements for self-service analytics.
• Performed DAX optimization, data modelling and large-dataset handling to improve report performance and maintainability.
• Used advanced SQL across PostgreSQL, MySQL and Azure SQL for extraction, transformation, analysis, reconciliation and validation.
• Applied Python with Pandas, NumPy and Matplotlib for data cleaning, exploratory analysis, dataset profiling and repeatable quality checks.

Senior Associate Consultant at Infosys Pvt. Ltd. (2015-12 – 2020-01)

• Translated banking-client enhancement requests into reporting, ETL, testing and release deliverables.
• Delivered reporting and visualization solutions for transaction trends, operational metrics and KPI performance.
• Coordinated code review, Git check-ins, SIT, UAT, production deployment and stakeholder communication as Release Manager.

Associate Consultant at Capgemini India Pvt. Ltd. (2012-05 – 2015-11)

• Supported banking compliance and production-support projects involving batch monitoring, abend resolution, JCL/PROC updates and testing.
• Prepared analysis documents, UTP/UTR evidence, validation notes and release-support documentation.

B.Tech. in Electronics and Communication Engineering – BPUT, Odisha, India (2010)