B Shree
Austin
Summary
- With over 10+ years of experience in Business Intelligence and Data Analysis, Power BI Developer, SQL/BI Developer.
- I excel in designing, analyzing, implementing, and administering BI solutions. My expertise spans a broad range of tools and technologies.
- Skilled in developing comprehensive Power BI dashboards, writing advanced DAX, and configuring data gateways for seamless data integration.
- Advanced knowledge of SQL Server, Azure SQL Database, Oracle, and PostgreSQL, with a strong focus on data modeling and creating SQL server objects.
- In-depth understanding of data warehousing concepts, data transformation, and ETL processes, ensuring efficient data flow and accuracy.
- Established and maintained Power BI governance policies to standardize workspace management, data access, and reporting practices.
- Proficient in connecting Power BI to diverse data sources (on-premise and cloud-based) and managing secure, scalable data models.
- Skilled in designing and deploying interactive dashboards and reports based on complex business requirements.
- Strong knowledge of Power Query (M), DAX, and ETL processes for data transformation, cleansing, and performance tuning.
- Experience with monitoring and optimizing Power BI performance, including capacity planning and server diagnostics.
- Proven ability to manage user roles and permissions, enforce security standards, and ensure compliance with governance policies.
- Adept at troubleshooting data and report issues, debugging DAX queries, and ensuring high data integrity.
- Delivered technical support and training to business users, enabling effective adoption of self-service analytics.
- Developed and maintained Power BI roadmaps, aligning reporting initiatives with strategic business goals.
- Excellent communication and collaboration skills, working with global, cross-functional teams and stakeholders.
- Designed and deployed BI solutions, including the integration of Power BI dashboards with ServiceNow for seamless reporting and data visualization.
- Collaborated with IT, security teams, to maintain secure authentication and identity access controls using Azure AD.
- Expertise in publishing the reports into Power BI Service and sharing the dashboards with the users.
- Integrated on-premises data sources with cloud-based platforms using a hybrid approach, utilizing SSIS for on-premises data integration and ADF for cloud-based data integration, ensuring seamless connectivity and data flow between environments.
- Expertise in Creating roles to implement Static and Dynamic ROW LEVEL SECURITY[RLS] For the Reports.
- Managed user roles, access permissions, and Row-Level Security (RLS) to control data visibility within Power BI reports.
- Administered Power BI workspaces, apps, and datasets while ensuring compliance with internal security policies and audit requirements.
- Experienced in Agile/Scrum methodologies, ensuring effective project management, and timely delivery of BI projects.
- Designed and executed advanced ANSI-SQL queries to extract, cleanse, and transform raw data from various source systems (e.g., databases, APIs, flat files) into structured, ready-to-use datasets for Power BI reports.
- Developed scheduled ANSI SQL queries to automate data extraction and transformation processes, ensuring timely updates to Power BI datasets through regular refresh cycles.
- Competent in integrating BI solutions with various RDBMS systems, facilitating seamless data exchange and reporting across platforms.
- Adept at generating and interpreting reports for statistical analysis, enabling data-driven decision-making.
Overview
3
3
years of professional experience
Work History
Power BI Developer
World Bank
08.2022 - Current
- Connected Power BI to various data sources including on-premises SQL Server, Excel, SharePoint, and cloud platforms such as Azure SQL and Azure Data Lake.
- Designed and maintained semantic data models to ensure accuracy, consistency, and high-performance data retrieval across reports.
- Implemented data cleansing, shaping, and transformation workflows using Power Query (M language) to prepare raw data for analytics.
- Built robust ETL pipelines within Power BI and integrated tools (e.g., SSIS, Azure Data Factory) to automate data refresh and transformation.
- Conducted requirement analysis and reviewed reporting database enhancements for enterprise-level clients.
- Administer and maintain the Power BI environment, including configuration of security policies, data connections, and usage metrics.
- Connect and manage Power BI across hybrid data sources (on-prem & cloud); optimized dataflows and semantic models for performance.
- Optimized data models by managing relationships, reducing cardinality, and applying best practices in star/snowflake schema design.
- Ensured data integrity and consistency through validation rules, exception handling, and standardized data definitions.
- Involved in data migration project from legacy warehouse to Cloud (Azure and snowflake).
- Transformed, defined, navigated the data from data source and perform merge and append queries using Power Query.
- Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.
- Defined and implemented financial billing triggers, incorporating complex algorithms to ensure accurate Created SSIS Packages for incremental loading and slowly changing dimensions.
- Designed and implemented API and data integration solutions using Connect and SSIS.
- Conducted unit testing to identify and fix defects during development, ensuring smooth deployment in production environments.
- Designed, developed, and deployed interactive Power BI reports and dashboards tailored to business stakeholders across Finance, HR, and Operations.
- Partnered with senior leadership and product teams to define milestones, allocate resources, and track progress of BI initiatives.
- Ensured continuous improvement of BI services by incorporating user feedback, performance metrics, and evolving business needs.
- Translated complex business requirements into intuitive, actionable visuals using slicers, KPIs, drill-throughs, and bookmarks.
- Developed complex calculated fields using ANSI SQL functions such as CASE, CAST(), CONVERT(), and DATEPART() to perform business-specific logic directly in SQL before bringing data into Power BI for visualization.
- Created standardized SQL views using ANSI SQL syntax to pre-aggregate data, enabling Power BI to quickly retrieve summarized data and reducing report refresh times.
- Provided day-to-day technical support and troubleshooting for Power BI users, resolving issues related to reports, data refresh, access, and visuals.
- Conducted onboarding and training sessions for business users to enable self-service analytics using Power BI.
- Used DAX and calculated columns to track and visualize SLA breaches, enabling faster resolution.
- Proactively developed features like dynamic report filters, enabling clients to customize views and improve insights for SLA tracking.
- Interacted with different project teams to finalize the release scope for project delivery.
- Utilized GIT for source control, ensuring data integrity and version management across multiple data projects.
- Worked with JIRA/DevOps for project planning and issue tracking.
- Developed technical enhancements, system documentation, and implemented procedures for quality improvement.
Environment: Power BI, DAX, Azure, Power BI Gateway, Power Query, MS SQL Server 2016/2014/2012/2008 R2,
MS Excel, Team Foundation, SSIS, SSRS, SSAS, Snowflake, Report builder.
Timeline
Power BI Developer
World Bank
08.2022 - Current