Power Bi Business Intelligence

Rajkamal Jannu

Sr. Power BI / Business Intelligence Developer/Analyst

**********.****@*****.*** M: 407-***-**** linkedin.com/in/rajkamal-jannu-210994163

Summary

Overall, 11 years of experience in Business intelligence developer and analyst roles and primarily worked on BI tools like Power BI, Tableau DB like SQL, SQL, Snowflakes, Azure, Greenplum...Etc.

Connected and blended data from diverse sources including SQL Server, Oracle, Snowflake, Azure, Greenplum, and Excel to build robust and scalable BI solutions.

Utilized SSIS, Alteryx, Informatica, and Azure Data Factory for complex data migration and transformation pipelines, ensuring data integrity throughout the process.

Proactively optimized redundant processes and maintained high data quality using Snowflake zero-copy cloning, Oracle integrity checks, and Power BI data transformation tools.

Developed and deployed end-to-end data analytics solutions leveraging Microsoft Fabric, including Data Factory, Synapse Data Warehouse, and Power BI.

Utilized Fabric's Lakehouse architecture for storing and processing large volumes of structured and unstructured data, enabling efficient exploration and advanced analytics with Spark and SQL.

Proficiently designed complex calculated measures using DAX.

Implemented relational and dimensional data models, including star and snowflake schemas, to optimize data for analysis.

Developed interactive dashboards with Power BI, applying best practices such as reducing cardinality and optimizing query performance for enhanced user experience.

Created custom visuals using Python and integrated APIs into Power BI for advanced data analysis and visualizations.

Designed and deployed interactive dashboards in Tableau, enabling users to explore data through various visualizations and drill-down capabilities.

Developed complex calculations and utilized parameters and sets in Tableau to facilitate dynamic data analysis.

Developed and maintained reports and dashboards within Cognos Analytics, leveraging Framework Manager for metadata modeling.

Created sophisticated analyses and visualizations in Cognos, including crosstabs, charts, and drill-through reports to meet business requirements.

Implemented Power Automate workflows to automate data refreshes, report distributions, and process integrations, streamlining BI operations.

Developed small-scale applications using Power Apps and integrated them with Power Automate to automate business processes, creating interactive forms, data connections, and workflow automation.

Implemented role-based security models in Power BI and databases, ensuring data confidentiality and regulatory compliance.

Led a team of Power BI developers, conducted code reviews, training sessions, and provided mentoring to enhance team capabilities and ensured best practices.

Collaborated with all levels of executives, business analysts, and data engineers to translate business requirements into actionable insights, driving data-driven decision-making and ROI improvements.

Partnered with cross-functional teams to understand business requirements, design dashboards, and present BI solutions tailored to executive and operational needs using SQL-driven Snowflake and Oracle insights.

Partnered with stakeholders to understand business needs and translate them into tailored BI solutions, contributing to strategic decision-making.

Demonstrated expertise in managing BI projects under Agile, Waterfall, and SCRUM methodologies, ensuring timely and high-quality deliverables.

Experienced with a broad range of BI tools and technologies, including Tableau, Cognos, Tibco Spotfire, SSRS, and emerging-gen AI tools like Power BI Co-Pilot.

Completed training on Microsoft Power Apps and Power Automate (Cloud), gaining hands-on experience in low-code application development and workflow automation.

Educational Details

Master’s

Master’s in information technology, University of the Potomac, Washington DC, USA -2018

Bachelor’s Degree

Bachelor of Business Management, Kakatiya University, Warangal, India - 2012

Certifications

Tableau, Azure DP-900

Technical Skills

Programming Languages

TSQL, SQL, PL/SQL, DAX, Python (Basics), C#, XML

Databases & Data Warehousing

Snowflake, Oracle, SQL server, MySQL, Hadoop, Azure, Greenplum.

Data Visualization Tools

Tableau, Power BI, Cognos, Tibco Spotfire, SSRS

MS Power Platform

Power BI (Power Query, Power View and Power Pivot), Power Automate, Power Apps, Fabric.

Operating system

Windows XP, Windows OS, Mac OS,

ETL Tools

ODI, Alteryx, Microsoft Azure, SSIS, Informatica

Data Modeling

Logical Modeling, Physical Modeling, Relational and Dimensional Modeling, ER Diagram

Gen AI

Power BI Co-Pilot, Chat GPT.

Tools

MS Office, MS Access, PowerPoint, Excel, MySQL Workbench, and Oracle Database Management Studio.

Methodologies

Agile, Waterfall, SCRUM, SDLC

Other

Visual Studio, Power Apps, Power Automate, Toad, Dbeaver, JIRA, GIT, TFS, MoveIT, FileZilla.

Professional Experience

Santander Bank, NJ

Sr. Power BI Analyst/Developer

Oct 2024 – Present

Responsibilities:

Led the end-to-end development lifecycle of critical Power BI reports and dashboards, from requirements gathering and data modeling to interactive visualization design and user acceptance testing (UAT), ensuring alignment with business objectives.

Architected and implemented robust data models within Power BI, optimizing performance for large datasets sourced from Snowflake and SQL Server, resulting in improvement in report load times.

Successfully managed and executed the deployment of Power BI reports and datasets to the production environment, adhering to strict change management protocols and minimizing disruption to business operations.

Designed and implemented comprehensive UAT test plans and scripts, collaborating with business users to ensure data accuracy, report functionality, and user satisfaction prior to production release.

Proactively identified, diagnosed, and resolved complex production issues related to Power BI reports, data connectivity, and performance bottlenecks, ensuring business continuity and data integrity.

Established and maintained comprehensive documentation for Power BI reports, data sources, and ETL processes, facilitating knowledge transfer and streamlining future maintenance and updates.

Implemented proactive monitoring and alerting mechanisms within the Power BI Service to identify potential data refresh failures or performance degradation, enabling timely intervention and preventing user impact.

Led the optimization and performance tuning of existing Power BI reports and dashboards, leveraging DAX best practices and query optimization techniques to enhance user experience.

Served as the lead for an offshore development team, providing technical guidance, mentoring team members, and ensuring adherence to project timelines and quality standards.

Effectively collaborated with cross-functional teams, including data engineers, business analysts, and IT stakeholders, to gather requirements, resolve data discrepancies, and ensure seamless integration of Power BI solutions.

Facilitated effective communication and collaboration between the onshore and offshore teams, utilizing project management tools and regular meetings to ensure alignment and progress.

Played a key role in gathering and translating business requirements into technical specifications for Power BI reports and dashboards, ensuring the final deliverables met user needs and expectations.

Proficiently utilized Informatica and Power Query (M) to perform complex data transformations, cleansing, and integration from disparate sources, ensuring data quality and consistency within Power BI.

Developed and implemented Power Automate workflows to automate data refresh schedules, report distribution, and notifications, improving efficiency and reducing manual effort.

Leveraged Power Apps to create custom data input forms and write-back solutions integrated with Power BI reports, extending the analytical capabilities and enabling user interaction with the data.

Demonstrated expertise in administering the Power BI Service, including managing user roles and permissions, configuring workspaces, and ensuring data security and compliance.

Contributed to data-driven decision-making by developing insightful Power BI reports and dashboards that provided key performance indicators (KPIs) and actionable insights to business stakeholders.

Actively participated in the continuous improvement of the Power BI environment, researching and implementing new features and functionalities to enhance reporting capabilities and user experience.

Environment: Power BI, DAX, MS Word, Excel, SQL, snowflake, Informatica, Oracle Database.

Software Bots Inc, Canton, MI

Sr. Power BI Developer

Sep 2023 – Sep 2024

Responsibilities:

Collaborated with clients in requirement-gathering sessions and conducted detailed data mapping to translate business needs into specifications for analytical reports.

Developed and deployed custom, interactive Power BI reports and dashboards on the server, leveraging data from diverse sources including SQL Server, Oracle, and Excel.

Designed and maintained sophisticated data models in Power BI, employing data blending techniques and complex DAX calculations to support robust business intelligence and reporting capabilities.

Proficiently utilized both Import and Direct Query modes in Power BI, including the creation of custom tables to optimize data handling and performance.

Ensured the reliability and accuracy of Power BI solutions through continuous maintenance, proactive bug fixing, and performance optimization by refining T-SQL queries and data structures.

Implemented advanced data transformations using Power Query Editor (e.g., pivoting, unpivoting, merging) to ensure data integrity and prepare it effectively for analysis and visualization.

Established and managed Power BI Gateways to maintain up-to-date dashboards and reports, guaranteeing timely insights for stakeholders.

Integrated Power BI with Power Automate to automate report refresh cycles and streamline the secure distribution of dashboards to relevant stakeholders.

Designed and created optimized data extracts to support various reporting platforms, including SSRS, SSIS, and Power BI.

Developed and published interactive Tableau dashboards and stories, incorporating advanced features such as parameters, sets, and calculated fields to enable deeper data exploration.

Implemented Tableau Server administration tasks, including user and group management, permissions configuration, and performance monitoring to ensure a stable and efficient reporting environment.

Utilized Tableau Prep Builder to cleanse, shape, and combine complex datasets from disparate sources, preparing data for advanced visual analytics in Tableau Desktop.

Environment: Power BI, DAX, Power Automate, SSRS, TSQL, SQL, M.S Word, Excel, SQL Server, Oracle.

General Motors, Detroit, MI

BI Developer/Analyst

Feb 2020 – Jul 2023

Responsibilities:

Aligned business intelligence solutions with organizational strategy by understanding business models, expectations, and key performance indicators (KPIs).

Served as a primary point of contact for users and business teams, providing crucial support and maintenance for daily reports and business operations.

Designed and developed impactful data visualization dashboards in Tableau and Power BI by thoroughly analyzing data and business requirements.

Efficiently migrated SQL queries across different environments, ensuring data integrity through the use of appropriate joins, columns, and tables.

Enhanced existing Power BI and Tableau reports by creating new pages, migrating databases, and implementing dashboard modifications.

Collaborated effectively with data engineering teams to establish optimal data structures and content for BI report development.

Utilized project management tools such as Team Foundation Server (TFS) and HP Quality Centre, along with Unified Modelling Language (UML), to document business rules, processes, data modelling, mapping, and design.

Optimized complex DAX calculations and measures, significantly improving the performance and speed of Power BI reports and dashboards for faster insights.

Established and managed robust table relationships within Power BI, creating seamless data models for accurate data representation and analysis.

Applied data modelling best practices, including star and snowflake schemas, to design efficient and scalable Power BI data models.

Integrated Power BI with Power Automate to automate the generation and distribution of daily, weekly, and monthly reports, enhancing reporting efficiency.

Leveraged Power BI dashboards to monitor Robotic Process Automation (RPA) processes and performance metrics, providing real-time insights for operational optimization.

Partnered with cross-functional teams to gather business requirements and translated them into effective Power BI visualizations and Power Automate workflows, ensuring alignment with organizational objectives.

Designed and implemented ETL processes within Power BI, extracting, transforming, and loading data from diverse sources into data models for reporting purposes.

Managed file transfers securely to SFTP servers using FileZilla.

Developed and maintained comprehensive user guides and training manuals.

Actively contributed to the development of management analytical reporting and planning systems and tools.

Analyzed current data warehousing processes to identify areas for improvement, enhancing efficiency and achieving evolving business targets.

Identified and implemented opportunities for process improvement and automation within data and reporting workflows.

Collaborated closely with business stakeholders to elicit data needs and translated them into effective Power BI data models and insightful reports.

Environment: Tableau, Power Bi, Power Automate Cognos, Greenplum, Oracle, BIS, MS SQL Server (2018), Toad Data Point 5.4, Dbeaver, TFS, MS SharePoint/ Word / Excel/ PowerPoint, Microsoft Azure Cloud, FileZilla.

Pfizer, NYC, NY

BI Developer

Sep 2019 – Dec 2019

Responsibilities:

Gathered the Requirements from the Business Users and created a Business Requirement Document to capture all the Requirements.

Coordinated with Clients for a feasibility study of the project in Tableau and drew up the timelines as per project requirements.

Developed, designed, and supported interactive Tableau and Tibco Spotfire Dashboard reports

Prepared report design specifications based on user requirements.

Supported and managed Power BI reports in the operations team.

Estimated the magnitude and time requirements to complete all tasks and provide accurate and timely updates to the team on progress.

Ensured on-time, high-quality deliverables and meet project milestones and deadlines within budget with minimal supervision.

Worked on validation and testing to ensure it meets the requirements.

Supported with troubleshooting problems, providing workarounds, etc.

Produced attractive visuals/dashboards to convey the story inside the data.

Built dashboards using techniques for guided analytics, interactive dashboard design, and best visual practices.

Installed of Spotfire environment for the Informatics team to leverage analytical capabilities.

Installed of required database drivers and data connectors.

Created Information Links with multiple tables, joins, prompts, and personalized and parameterized features.

Supported user and development activities of Spotfire by providing production and development support to troubleshoot and resolve issues.

Exported & imported of dashboards from one environment to another environment

Environment: Tableau, Power BI, Tibco Spotfire, AWS, Oracle, MS SQL Server (2018), MS SharePoint, Toad Data Point 5.4, JIRA, Python, data warehouse, MS SharePoint/ Word / Excel/ PowerPoint.

Merck & Co, Rahway, NJ

BI Developer

Mar 2019 – Aug 2019

Responsibilities:

Developed complex Spotfire Reports from end to end based on client needs and provided detail on demand.

Created Windows forms on Spotfire using Iron Python script for form submissions.

Implemented various data modeling, visualization, and reporting techniques.

Created different types of charts for Spotfire and Tableau Dashboards analysis.

Worked directly with business users to define and prototype QlikView applications, and worked directly with senior management to plan, define and clarify dashboard goals, objectives and requirements.

Worked as Qlik sense new objects, maps KPI’s object and document extension for wireframes, and proof of concept application, Implementing set analysis.

Extracted, transformed, and loaded data from multiple sources into the Qlik sense application.

Created SQL, and SSIS packages to Oracle and other SQL Server instances in SSIS 2012/2014/2016.

Transformed data from various data sources using OLE DB connection by Creating SSIS Packages and used Salesforce for migration to ERP Systems. Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS).

Extracted the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.

Prepared the reports for day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, XML, etc.

Scheduled the Reports to run on a daily and weekly basis in Report Manager emailing them to the director and analysts to be reviewed in spreadsheets.

Produced documentation and procedures for best practices in Teradata development and administration.

Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP), and Bulk Insert.

Extensively involved in the SSAS storage and partitions, and aggregation, calculation of queries with MDX, Data Mining Models, and developing reports using MDX and SQL. Created non-clustered indexes to improve query performance and query optimization.

Performed Tableau Admin duties that comprised configuration, adding users, groups, data connections, scheduling tasks, and embedding views in the Tableau Server.

Performed T-SQL tuning and optimizing queries for reports which take a longer time in execution with SQL Server 2008. Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.

Environment: Tableau, TIBCO Spotfire, QlikView, Oracle, BIS, SSIS, MS SQL Server Management, Teradata dba, MS SharePoint, Dbeaver, MS SharePoint/ Word / Excel/ PowerPoint, HTML, XML.

US Bank, Minneapolis, MN

BI Developer

Jul 2017 – Mar 2019

Responsibilities:

Developed, designed, and supported interactive Tableau Dashboard reports

Prepared the Report Design specifications based on the User’s requirements.

Developed Reports with complex calculations using functions like Table Calculations, LOD Calculations, and Date Validations.

Worked with Sets, Groups, and Parameters and developed Scorecard reports, Executive Summary Reports

Published reports to Tableau Server.

Maintained and Troubleshooted, Analysed the logs and Scheduling Extracts in the Tableau Server

Migrated the Tableau workbooks from one environment to another environment.

Provided the feasibility to business users for ad-hoc reporting using web authoring in Tableau server.

Recorded Performance Tuning in Tableau Desktop

Provided Security while Publishing to the Tableau Server.

Created dashboards like master-detail, multi-master dashboards, and Index dashboards.

Created groups, sets, and bins and performed conditional sorting and filtering as per the requirements.

Coordinated with Clients for a feasibility study of the project in Tableau and drawing up the timelines as per project requirements.

Coordinated with Business Analysts in validating report requirements

Administered users, and user groups, and scheduled instances for reports in Tableau.

Executed and done unit testing and supported for UAT before publishing.

Validated the data for each report and review the reports.

Environment: Tableau, Coric, MS SQL Server Management, / Word / Excel/ PowerPoint.

JMR Infotech, India

Reports Developer

Aug 2012 – Feb 2016

Responsibilities:

Involved in requirement gatherings and analysing the requirements, regularly interacting with customers to resolve issues.

Prepared dashboards using calculated fields, parameters, calculations, groups, sets, and hierarchies in Tableau.

Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.

As a member of the BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing, and Implementation of BI Analytics needs.

Created a database management system for the student database. Specified the business rules for the requirement and Designed the ER model.

Designed all the tables in 3NF enforcing the required database constraints for the successful interaction of the entities.

Created Enterprise Gateway and SSAS Connector on Azure VM for Tableau Report Deployments.

Administered user, and user groups, and scheduled instances for reports in Tableau.

Executed and tested required queries and reports before publishing.

Validated the data for each report and review the reports.

Environment: Tableau, SSAS, MS SQL Server Management, MS SharePoint, MS SharePoint/ Word / Excel/ PowerPoint.

Contact this candidate