Power Bi Developer

NIRANJAN S

Sr. Power BI Developer

346-***-**** • *********.******@*****.***

SUMMARY

12+ years of overall experience in IT, and as a Power BI Developer

Proficient in importing data from various sources like SQL Server databases, SharePoint and Excel files into BI tools, establishing relationships using Data Modeling, and creating calculated columns, Measures with DAX queries.

Expertise in Power BI Desktop, Charts, DAX, Power Query Editor, Power Bi Service and SQL.

Experience with data analysis, data modeling and data presentation and importing data from SQL Server, Snowflake, Oracle DB, and API to Power BI to generate reports.

Well-versed in agile methodology, with extensive experience in Microsoft tools such as Power BI, Sharepoint, Power Apps, Power Automate, and Visual Studio Services.

Strong Background in Business Intelligence tools, particularly Snowflake and Power BI, for creating reports, dashboards, and visualizations across various Power BI platforms.

Proficient in Power BI Desktop for connecting with diverse data sources, importing, and modeling data for Business Intelligence purposes.

Strong knowledge of Power BI administration and installation of Gateways in Power BI and experience in automatic schedule refresh, and deployment pipelines in Power BI service.

A practical grasp of relational and dimensional data modeling concepts, such as fact and dimension tables, star and snowflake schema modeling, and dimensional modeling.

Proficiency in optimizing data warehouse databases and analytics dashboards and reports, as well as in debugging and performance tuning.

Capable of developing custom visualizations in Power BI using Python libraries to represent data in unique and informative ways.

Experience in gathering and translating end user requirements into effective & efficient Reports and Dashboards.

Experience including analysis, design, development of reports and dashboards for analytics.

Develop Power BI reports, Custom Visuals, Groups Creation and effective dashboards after gathering and translating end user requirements.

Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX.

Experience in creating different visualizations like Line, Bar, Pi, donut, Funnel, Table, Infographic charts etc.

Experience in publishing reports to Power BI services & setting up the necessary connection details and scheduling.

Imported data from multiple data sources into Power BI from various data bases like SQL Server, Oracle etc.

Implemented Role Based Security as part of security in Power BI.

Involved in create ETL packages to validate, extract, transform and load using SSIS.

Expertise in designing Report templates, bar charts, graphs and pie charts based on the data.

Developed various operational Drill-through and Drill-down reports using BI.

Good hands-on experience in creating SQL Server database objects like Tables, Constraints, Joins, Sub-Queries.

Skilled at assessing client needs, working in groups, Leading the team, suggesting ideas that enhance efficiency and

performance, implementing technology solutions and training end users. Create the Key Performance Indicators (KPI) and Metrics to communicates the amount of progress made toward a measurable goal.

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis. Experience in custom visuals and groups creation in Power BI.

Extensive use of DAX (Data Analysis Expressions) functions for the reports and for the tabular models.

Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.

Handson experience on API and Database testing

Involved in designing, developing and executing test cases as a part of an independent test group

Expertise in Testing of web application, Web Responsive and Mobile applications (Android & iOS)

SKILLS

Programming: SQL, Java, R

BI Tools: Tableau, Power BI, QlikView, SAS BI, SSIS, SSRS, SSAS

Databases: Oracle, MySQL, Microsoft SQL Server

Data Modeling & Analysis: ER Studio, Alteryx, SPSS, OLAP, Crystal Reports

OTHER

Certifications:

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Azure Fundamentals

Awards: Received Dr. Reddy’s Digital award for the best performance.

EXPERIENCE

BlackBerry – Austin, USA March 2024 - Present

Sr. BI Developer

Responsible for creating design documents, establish specific solutions, creating test cases. Conducted A/B testing and statistical analysis to optimize marketing campaigns, resulting in a 10 % revenue increase over the quarter.

Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.

Worked on all type of transformations those are available in power bi query editor.

Wrote DAX expressions to create new measures, calculations per business requirements.

Effectively used data blending, filters, actions, and hierarchies feature in Power BI.

Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.

Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.

Developed both simple and complex SQL scripts in snowflake to verify and validate data flow across various applications.

Conducted data analysis, migration, cleansing, transformation, integration, import, and export using various ETL tools and techniques.

Develop Power BI reports & Effective dashboards after gathering and translating end user requirement.

Developed Power BI reports from multiple data source.

Data cleaning in Power BI

Implemented DAX (Data Analysis Expressions) functions for Calculated columns and measures.

End to end process to deliver the project.

Publishing reports and providing access to workspace and granting permissions in power BI services.

Utilized Power BI to create daily, weekly, and monthly dashboards for C-level executives

Identified and fixed data quality issues, boosting data accuracy by 25%

Developed and maintained database systems, increasing data availability by 15%

Ford – Michigan, USA May 2022 - February 2024

Sr. BI Developer

Validated data accuracy, reducing data discrepancies by 20%

Used various sources to pull data into Power BI such as SQL Server, excel, cloud, SQL Azure, etc.

Created Power BI Visualizations and Dashboards as per the requirements.

Wrote DAX Expressions, Power Query, Functions in Power BI.

Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models

Conducted regular data audits as part of quality assurance, resulting in an improved data governance system

Contributed to cross-functional teams to optimize data cleansing methodologies

Worked in the Data migration team for generating Extraction, Data Quality and Transformation Reports.

Collaborated with the project team to outline project requirements in meetings

Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.

Developed data reconciliation SQL queries to validate the overall data migration.

Designed power BI data visualization using table charts, slicers, filters, navigation to multiple reports

Wrote DAX expressions to create new measures, calculations per business requirements.

Analyzed the data using Statistical features in Power BI to develop trend analysis.

Published the developed dashboard, reports on the Power BI Services

Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.

UC Davis – CA, USA July 2019 – May 2022

Power BI Developer

Development and Creation of Complex Stored Procedures, Triggers and Functions.

Fine-tuning Stored Procedures to improve the performance by removing the unnecessary cursors.

Management of T-SQL Views, Cursors, Index statistics, Tables and query optimization using execution plan for tuning the database.

Always ensured to eliminate NULL and Blank values on the Dashboards/Reports for the best end user experience

Conducted complicated calculation to develop KPI reports/dashboards according to clients' requirement.

Scheduled the Dashboard’s at regular intervals to make sure data refresh is up to date.

Generated periodic reports based on the statistical analysis of the data from various time frames and division using Power Pivot, Power Query, Power View and Power BI.

Continued maintenance and development of bug fixes for the existing and new power Bi reports.

Developed calculated columns and measures using DAX in Power BI.

Created and customized simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.

Managed project insights through Azure DevOps to track the list of assignments and provided daily updates.

Worked with the customer in gathering requirements (BRD) as per the project specifications.

Importing data from different source databases based on the business requirements.

Implemented DAX (Data Analysis Expressions) functions for calculated columns and measures.

Effectively used data blending, filters, actions, and hierarchies feature in Power BI.

Publishing Power BI Reports and scheduling auto refresh.

Worked on creating and implementing pipelines in Azure data factory for the data migration.

Dr. Reddy’s- Louisiana, USA March 2016 - June 2019

Sr. Data Analyst

•Created and modified various complex Stored Procedures used in the application using T-SQL.

•Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Flat files, Excel, Oracle DB2, and SQL Server).

•Worked on Azure Cloud involving migration from On-Premises to Azure.

•Responsible for programming, testing, debugging, and documenting simple to moderately complex ETL applications (SSIS) under direct supervision.

•Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

•Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.

•Understanding the user stories of change control process to define the test scenarios.

•Participated in sprint planning and retrospective meetings based on change request raised by plant users.

•Performed Operational and Performance Qualification, UAT testing process as per the Pharmacy industry standards

•Review and posting bugs in solution manager and tracking the life cycle of bugs until their closure

•Designed the automation scripts for component and regression testing of notification creations and approval process for the web application.

•Performed SAP business object testing in QM module, Verified change control notification reports

•Led and mentored a team of four members

•Release Planning and Product Roll Out

•Organized demo sessions for the end users and give support for the user understanding once they launched application in overall branches including Brazil, UK etc.

Syngenta – India March 2014- Feb 2016

Data Analyst

•Headed negotiations to find optimal solutions with project teams and clients

•Mapped client business requirements to internal requirements of trading platform products

•Supported revenue management using statistical and quantitative analysis, developed several statistical approaches and optimization models.

•Managed and maintained required documentation

•Setting custom reports and dashboards (Google Analytics, MS Excel)

•Led the business analysis team of four members, in absence of the Team Lead

•Added value by providing innovative solutions and delivering improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.

LMS (LABORATORY MANAGEMENT SYSTEM) – India March 2012 - Feb 2014

Quality Analyst

•Followed Agile Methodology which involves daily scrums meetings and Sprint meetings (planning, Review) to meet deadlines and expectations.

•Create a test strategy based on project requirements and schedules.

•Verified consistency across devices, browsers, and operating systems.

•Performed UAT, compatibility testing of ABP (Using different android OS versions and models) and integration testing between different modules.

EDUCATION

•Bachelors in Computer Science, JNTUH, India in 2011.

Contact this candidate