Power Bi Business Intelligence
Resume:
SRINI REDDY
+1-409-***-**** ***********@*****.*** www.linkedin.com/in/sn4920
PROFESSIONAL SUMMARY
Over 18 years of IT experience specializing in data architecture and enterprise data modeling. Proven expertise in selecting new data management components and designing robust models to support scalable analytics and reporting. Adept at optimizing data integration and ETL pipelines within Agile environments, ensuring effective stakeholder collaboration and actionable insights.
TECHNICAL SKILLS
• Business Intelligence: IBM Cognos, BO, Power BI, Paginated Report Builder, SSRS, Tableau, Power Platform
• Database Technologies: SQL Server, Oracle, Db2, Hive, HANA
• Cloud And Data Platforms: AWS, ADLS, Azure, Snowflake
• Web And Programming: HTML, CSS, JavaScript, WordPress, Bootstraps
• Collaboration And Project Tools: Microsoft Teams, Jira, VSS, SVN, Dynamic 365 WORK EXPERIENCE
BPX Energy Oct 2023 - Present
Sr. Power BI Developer TX
• Collaborated with business users to understand requirements and deliver reports and dashboards aligned with strategic objectives.
• Connected to Snowflake using direct query mode to build semantic data models, supporting effective data visualization and reporting tools.
• Optimized data processing through the implementation of efficient ETL pipelines, streamlining database design and data integration.
• Developed and maintained Power BI dashboards that reflected the migrated data from AWS, ensuring alignment with Oil and Gas stakeholders’ needs.
• Analyze existing BO reports and identify equivalent visuals and DAX logic in Power BI.
• Recreate BO reports in Power BI while aligning with Oil & Gas-specific KPIs (e.g., production volumes, drilling costs, reservoir performan ce).
• Design and build the Canvas App embedded in Power BI.
• Ensure optimized data modeling using star schema and DAX best practices.
• Integrate with oil industry data sources like PI System (OSIsoft), SAP IS-Oil, and SQL Server.
• Cleaned and transformed raw data from multiple sources using Power Query Editor
• Created advanced DAX measures for dynamic KPIs, YTD, MTD, and custom time intelligence
• Implemented complex M code for conditional columns, merges, and parameterized queries.
• Configured Power BI to interface with AWS data sources via Snowflake DB connectors, facilitating seamless data ingestion.
• Enhanced report performance by optimizing Power BI visualizations for quicker loading and querying large datasets.
• Managed large datasets, ensuring scalable and efficient report generation while maintaining a seamless user experience.
• Conducted performance tuning of Power BI reports and backend databases to boost efficiency and reduce latency.
• Delivered training and support to end-users on leveraging Power BI dashboards for actionable insights.
• Delivered multi-page, exportable reports for regulatory and financial reporting needs.
• Created interactive charts including heatmaps, scatter plots, and custom bar charts to effectively visualize complex data relationships. Ally Financial Nov 2022 - Jul 2023
BI Developer IV NC
• Engaged with business users to gather requirements and design reports and dashboards that enhanced decision-making capabilities.
• Utilized Oracle SQL Developer with direct query mode in Power BI Desktop to pull tables/views and build semantic data models.
• Migrated reports from OBIEE and Tableau to Power BI while developing paginated reports with Power BI Report Builder.
• Analyzed and visualized key financial metrics, including loan performance, credit risk, customer churn, and profitability.
• Integrated Copilot into Power BI for automating report generation, data modeling, and DAX query formulation.
• Leveraged SAP HANA to process financial data and create real-time dashboards, contributing to end-to-end business intelligence solutions.
• Implemented DAX measures to track KPIs such as net interest margin, return on assets, and customer acquisition costs.
• Designed complex financial models and what-if scenarios using DAX to forecast revenue and manage risk effectively.
• Constructed and optimized intricate data models in Power BI to support real-time analytics and reporting functions.
• Established relationships between tables, defined calculated columns, and set up hierarchies to improve data navigation and insight derivation.
• Optimized data models using calculated columns, relationships, and performance tuning.
• Implemented complex M code for conditional columns, merges, and parameterized queries.
• Designed pixel-perfect paginated reports using Power BI Report Builder for printable outputs.
• Delivered multi-page, exportable reports for regulatory and financial reporting needs.
• Enhanced semantic data model performance to ensure efficient data retrieval and rapid report loading times.
• Improved query performance by refining T-SQL queries, eliminating unnecessary columns, normalizing tables, and implementing appropriate indexes.
• Produced diverse visualizations using bars, lines, pie charts, maps, scatter plots, Gantt charts, bubbles, histograms, bullets, and highlight tables.
Informa, GIRIKON Solutions Aug 2021 - Oct 2022
Sr. Consultant
• Engaged in performance tuning of measures (DAX) for the reporting team using DAX Studio and SQL Profiler.
• Interacted closely with business users to understand their requirements for creating reports and dashboards.
• Designed pixel-perfect paginated reports using Power BI Report Builder for printable outputs.
• Utilized SQL Server to connect Power BI Desktop via direct query mode, extracting tables/views to build semantic data models.
• Employed joins/views and sub-queries extensively to simplify complex data retrieval tasks involving multiple tables.
• Migrated the reports from Tableau, Cognos to Power BI.
• Created various types of charts (bar, line, pie, and donut) and reports tailored to client specifications.
• Developed calculated columns and measures in Power BI Desktop to enhance data visualization in reports and dashboards.
• Designed and implemented sales performance dashboards to monitor critical metrics such as revenue growth, sales targets, pipeline analysis, and conversion rates.
• Utilized DAX to analyze sales trends, perform year-over-year comparisons, and segment customers effectively.
• Implemented sales forecasting models and dynamic quota assignments using DAX measures to support strategic decision-making.
• Managed and scheduled automatic data refreshes in Power BI Service to ensure up-to-date reporting.
• Built Power BI dashboards using tabular models, designing and modeling datasets based on customer requirements and dashboard needs.
• Built interactive dashboards with dynamic titles, tooltips, and row-level logic.
• Published Power BI Desktop models to Power BI Service, creating highly informative dashboards, collaborating via workspaces and apps, and gaining quick insights into datasets.
• Created and modified Power BI templates (PBT) based on user requirements to streamline reporting processes.
• Analyzed application requirements and functionalities from specifications to ensure alignment with business goals.
• Designed, developed, tested, and maintained Tableau functional reports according to user requirements.
• Developed Tableau data visualizations including crosstabs, heat maps, box and whisker charts, scatter plots, geographic maps, pie charts, bar charts, and density charts.
• Implemented groups, hierarchies, and sets to create detailed level summary reports and dashboards using KPIs.
• Created tabular models using DAX queries in Analysis Services and deployed them to SQL Server for enhanced data analysis and reporting capabilities.
FDLE, G. Com Soft Sept 2020 – Apr 2021
Sr. Power BI Developer FL
• Collaborated closely with business users to understand their requirements for creating reports and dashboards.
• Utilized SQL Server to connect Power BI Desktop via direct query mode, extracting tables/views to build comprehensive data models.
• Employed joins/views and sub-queries extensively to simplify complex queries involving multiple tables.
• Created various types of charts (bar, line, pie, and donut) and reports based on client requirements.
• Developed calculated columns and measures in Power BI Desktop to enhance data visualization in reports and dashboards.
• Scheduled automatic data refreshes and managed refresh schedules in Power BI Service to ensure timely updates.
• Created data visualizations including combination charts, slicers, map visualizations, matrices, tables, scatter charts, waterfall and funnel charts, gauges, and single-number cards.
• Migrated reports from Cognos to Power BI, ensuring continuity and enhanced functionality.
• Established workspaces and content packs in Power BI for business users to access and view developed reports and dashboards.
• Installed and configured Power BI Gateways to automate dashboard and report updates.
• Created workspaces and apps in Power BI Service, granting access to end users and ensuring efficient collaboration.
• Implemented row-level security and integrated it with Power BI Service portal for enhanced data protection and access control. SCE Nov 2019 – Aug 2020
Sr.BI Developer, Migration CA
• Collaborated with business users to understand both business requirements and existing systems.
• Connected to Azure Data Lake storage to retrieve files for building models and creating reports and dashboards based on requirements.
•Collaborated with business users to understand both business requirements and existing systems.
•Connected to Azure Data Lake storage to retrieve files for building models and creating reports and dashboards based on requirements.
•Applied strong expertise in designing, developing, and modeling within Power BI to meet business needs effectively.
•Connected databases such as HANA, DB2, and SQL Server for data import and direct query to develop models and build reports for specific applications.
•Built interactive dashboards with dynamic titles, tooltips, and row-level logic.
•Applied data transformations according to business rules to standardize data formats across multiple sources.
•Implemented Star schemas while designing relational databases and data warehouses to align with business and reporting requirements. NOKIA Feb 2019 - Oct 2019
Sr. Power BI developer, Excel Report Migration CA
• Connected databases such as HANA, DB2, and SQL Server for data import and direct query to develop models and build reports for specific applications.
• Applied data transformations according to business rules to standardize data formats across multiple sources.
• Implemented Star schemas while designing relational databases and data warehouses to align with business and reporting requirements.
• Work with stakeholders to understand business requirements and deliver data-driven solutions.
• Developed and optimized SQL queries to verify logic and test data integrity for various visualizations, matrices, and tables.
• Migrated reports from SAS, Tableau to Power BI, ensuring continuity and improved functionality.
• Created various types of charts (bar, line, pie, and donut) and reports based on client specifications.
• Implemented Copy activity and Dataflow in Azure Data Factory Pipeline Activities for on-cloud ETL processing.
• Implemented row-level security based on region, country, and territory to restrict data access as per organizational policies.
• Published reports and dashboards from Power BI Desktop to Power BI Service for end-user access and sharing.
• Installed and configured Power BI Gateways to automate updates for dashboards and reports.
• Created workspaces and apps in Power BI Service, granting access to end users and facilitating collaboration. SLB Apr 2018 - Jan 2019
Sr. Power BI developer, Migration Houston, TX
• I interacted closely with business users to comprehend business requirements and understand both existing and new systems.
• Developed models to connect with diverse data sources such as MySQL, HIVE, Excel, and SharePoint in Power BI to create reports and dashboards according to client requirements.
• Utilized Merge Queries and Append Queries functions, removed and split columns, and selected necessary columns to streamline data preparation.
• Worked with both import and direct query methods in Power BI, creating custom tables and implementing various transformations using Query Editor.
• Participated in daily stand-up Agile/Scrum meetings to discuss enhancements and progress related to existing requirements.
• Created diverse visualizations in reports using Bar Charts, Pie Charts, Line Charts, Cards, Slicers, Tree Maps, Maps, etc.
• Developed Tabular Models using DAX queries in Analysis Services and deployed them to SQL Server.
• Published dashboard reports to the online Power BI cloud service for consumption by reporting consumers.
• Participated in defect status meetings during User Acceptance Testing (UAT), addressing issues with root cause analysis and timely defect resolution.
THERMO FISHER Jan 2018 - Mar 2018
Power BI developer, Migration Pittsburgh, PA
• Implemented and maintained various levels of data security in Power BI, ensuring appropriate data access and implementing Row-Level Security when necessary.
• Utilized various types of visualizations such as Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, etc., in Power BI to effectively visualize data according to specific requirements.
• Published reports and dashboards to the Power BI service through Office 365 integration, facilitating access and sharing among multiple users within the organization.
• Built interactive dashboards with dynamic titles, tooltips, and row-level logic.
• Successfully migrated all tableau reports to Power BI, ensuring continuity and improved functionality.
• Installed On-Prem Gateways to schedule and refresh reports and dashboards, maintaining data currency and availability.
• Developed professional reports aligned with business requirements using Power BI's robust features and capabilities.
• Proficient in designing and creating Power BI storyboards to provide a summarized narrative of business data. Fresenius Medical Care Aug 2016 - Dec 2017
BI developer MA
• Maintained existing Power BI reports and dashboards, making updates and modifications based on new and changing business requirements.
• Implemented Star and/or Snowflake schemas in the design of relational databases and data warehouses to meet specific business and reporting needs.
• Created data models by extracting data from multiple sources and transforming raw data into actionable business information through Data Conversion, Data Cleansing, Data Aggregation, Data Merging, and Data Splitting processes.
• Developed various types of visualizations (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, etc.) in Power BI according to project requirements.
• Built and published customized interactive dashboards in Power BI, enhancing data visualization and user interactivity.
• Applied DAX functions such as SUMX, CALCULATE, ALLEXCEPT, FILTER, etc., to perform complex calculations and manipulate data as per business requirements.
• Created new measures and calculated columns in Power BI for detailed analysis and visualization within reports and dashboards. Delta Airlines Dec 2015 - Mar 2016
Assistant Consultant
• Developed, organized, and managed graphs, tables, slides, and document templates to streamline the creation of reports.
• Implemented reports with advanced features including Drill Through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, and Master-Detail views.
• Conducted Unit testing in Development environments and provided support to users during User Acceptance Testing (UAT) and Production phases.
• Design, develop, and maintain PL/SQL packages, procedures, functions, and triggers for efficient data processing and reporting.
• Performed extensive performance tuning at both Cognos and database levels to optimize report performance.
• Created and maintained technical documentation detailing the implementation process and report specifications.
• Provided ongoing support and maintenance for existing reports in production environments. Baxter Ltd, Capgemini India Dec 2014 - Aug 2015
Senior Consultant Bangalore
• Implemented reports with advanced features including Drill Through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, and Master-Detail views.
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validating the Prompts using JavaScript.
• Conducted Unit testing in Development environments and provided support to users during User Acceptance Testing (UAT) and Production phases.
Manpower, UST Global, India Nov 2013 - Nov 2014
Sr. System Analyst
• Developed and maintained technical documentation detailing the implementation process.
• Provided ongoing support and maintenance for existing reports in production environments.
• Designed and reviewed Technical Design Documents (TDDs) and queries through onsite/offshore mail coordination.
• Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.
• Prepared training materials developed Business models and trained users in Query Studio according to their specific needs and requirements.
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail, and cross tab tables with multiple breaks.
• Recommended and designed summary tables to be used in reports to optimize performance. Sonoco, Mind tree, India May 2011 - Sep 2013
Sr. Software Engineer
• Interaction with the client for requirements gathering and analysis.
• Developed List Reports with complex formatting in Report Studio.
• Creation of Calculations, Filters during report design.
• Developed reports incorporating Grouping, Sorting, Page Breaks, Sectioning, Joins, and Unions.
• Created text-based prompts, date prompts, and value prompts for user interaction.
• Involved in creating, re-ordering, modifying, and deleting prompts within reports.
• Implemented Conditional Formatting to highlight data in reports.
• Developed complex reports featuring Charts, Crosstabs, and Drill-through functionality.
• Extensively utilized Ranks, Filters, Prompts, Variables, and Calculation Contexts to enhance report design.
• Created Web Intelligence Reports and used Events for scheduling reports on a Daily/Weekly/Monthly basis. Myer HR DATA MART, IBM India Mar 2007 - Apr 2011
Application developer Melbourne, Bangalore, India
• Creating/Modifying catalogs and Impromptu reports based on client specifications.
• Creating user classes and users and configuring necessary access using Access Manager.
• Publishing cubes to the upfront and maintaining existing cubes, models, and IQDs (Intelligent Query Descriptors).
• Developed various types of reports including chart reports, list reports, crosstab reports, drill-through reports, master-detail reports, and multiple reports.
• Develop and manage ETL (Extract, Transform, Load) processes using PL/SQL to integrate data from multiple sources into data warehouses or BI systems.
• Leveraged prompts, calculations, conditions, filters, conditional formatting, and aggregations to enhance report functionality and usability.
American Express Bank Limited-FIG NY DDA PROJECT, Chennai, IBM India Oct 2006 - Feb 2007 Application Developer
• Analyzed business specifications to understand requirements for creating list and chart reports.
• Created technical design documents outlining the structure and specifications of the reports.
• Conducted testing to ensure accuracy and functionality of reports before publishing Cognos Connection.
• Implemented conditional formatting according to specific business requirements to enhance report readability and usability. EDUCATION
Manipal Academy Higher Education 2004
Master of Information Technology
Nagarjuna University 2002
Bachelor of Science
CERTIFICATIONS
• Certified from Microsoft Azure Fundamentals: Microsoft Azure Fundamentals (2022)
• Certified from Microsoft as Power BI Data Analyst Associate: Microsoft as Power BI Data Analyst Associate (2022)
• Certified from IBM as Cognos10 Designer Developer: IBM as Cognos10 Designer Developer (2012)
• Certified from IBM as Cognos8 BI Author: IBM as Cognos8 BI Author (2008)
• Certified from IBM as Cognos8 Metadata Developer: IBM as Cognos8 Metadata Developer (2010)
• Certified from IBM as Cognos8 Administrator: IBM as Cognos8 Administrator (2010)
Contact this candidate