KIRAN KUMAR

Power Platform Developer

ad4l16@r.postjobfree.com

929-***-****

PROFESSIONAL SUMMARY

Working as a Power Platform Developer having around 10 years of IT experience with multiple skill set and extensive working experience in data warehousing and Business Intelligence Technologies with expertise in Microsoft Power Platform (Power BI, Power Apps & Power Automate), Tableau, SAP BO for building, deploying and managing applications.

Strong Experience on Power BI Desktop - Data model preparation, creating visuals/reports, dashboards and KPI scorecards.

Expertise in importing data from various sources such as Oracle, SQL Server, SQL Server Analysis Services, Custom API’s, SharePoint, MS Excel etc.

Publishing and scheduling Power BI reports as per the business requirements

Skilled in developing visually rich charts, matrices, maps, slicers, funnel, gauges utilizing Power BI, delivering actionable insights.

Implemented Incremental refresh on tables with large data volume.

Implemented Row Level Security in datasets based on the user needs.

Experience in design and development of Canvas, Model-driven Power Apps and Power Pages by utilizing SharePoint, Microsoft Data verse.

Documented Power Automate scripting steps and process flows Assist in converting existing workflows into Power Automate within SharePoint Online.

Proficient in DAX, SQL Server and Power Query (M Code).

Good experience in creating SharePoint Forms & Lists.

Having very good knowledge on Looker, NetSuite, MS BI Stack (SSIS, SSAS & SSRS), DAX Studio, Spotfire, SAP BI, KQL, Azure Data Explorer, Power Virtual Agent and SAP Analytic Cloud.

Good communication and time management skills with strong analytical, problem solving and decision-making capability.

TECHNICAL SKILLS

Reporting Tools

Power BI Desktop, Power BI Services server reporting services (SSRS), Tableau, SAP BO, Spotfire, SAP Analytics Cloud.

Databases

Oracle 10g/11g, MS SQL server 2014/16, and Snowflake cloud database, Azure SQL DB

Operating System

Windows, UNIX

Languages

SQL, PL/SQL, T-SQL

Others

Power Apps, Power Automate, Power Pages, TOAD, Oracle SQL developer, MS Office, FTP, Control-M, JIRA, GitHub, JSON

CERTIFICATIONS:

PL-900: Microsoft Power Platform Fundamentals

PL-300: Microsoft Power BI Data Analytics

DA-100: Analyzing Data with Microsoft Power BI

EDUCATION

Master of Computers Applications from JNTU in 2008

PROJECTS:

Transit, NJ

SR Power Platform Developer Feb 2023 to Till Date

Responsibilities:

Worked with business users to gather in-depth business requirements and keep track of changes in their requirements.

Extensively involved in design of Dashboard to display all the customer related information.

Created various Dashboards by Imported data from multiple data sources into Power BI Desktop like SQL Server, MS Excel

Created Canvas apps to feed the Customers data into SharePoint lists with the help of Power Automate workflows.

Created Model Driven apps by using Data verse and also created Power Pages based on the client’s requirement

Design, code, test automation workflows using Power Automate Cloud Flows, Desktop flows.

Secured the reports using row-level security on data in Power BI Reports.

Created App work spaces to share the Reports and Dashboards the Users.

Responsible for scheduling and monitoring the Report schedules and App Monitoring.

Documented and Provided technical training and demos in Power Platform Applications for the new Users.

Environment: Power BI Desktop, Power BI Service, Power Apps, Power Automate, SharePoint List, Microsoft Office 2021, SQL Server 2019.

Altria, Richmond (VA)

Power Platform Developer Oct 2021 to Jan 2023

Responsibilities:

Interacted with the Business Users to understand the requirements.

Connected with the external data sources to bring the data to Power BI and worked on data Transformations like removing unused columns, name changing of the fields, changed the data types, created conditional columns, merge queries, append queries, etc.

Created Portfolio reports to understand the revenue generated by each Product segment .

Created Employee Time Track report by connecting JIRA, SAP Success factor and Desk Time data to show the Employee Productive Hours, Hours worked on Issues and No of Leaves taken in a month.

Created App Workspace and assign the Users to access the reports.

Designed and implemented data models within the Autonomous Data Warehouse to support reporting and analytics requirements. This includes defining tables, views, indexes, and relationships to optimize query performance and facilitate analysis.

Created a Canvas App for tracking the inventory levels, including raw materials, work-in-progress, and finished goods.

Documented PL/SQL code, data models, and report specifications to ensure clarity and maintainability.

Created Power pages as per the client requirement.

Implemented Row Level Security for data privacy to the reports.

Environment: Power BI Desktop, Power BI Service, Power Apps, Power Automate, Share point, Microsoft Office 2016, SQL Server 2019, JIRA, SAP Success Factor and Desk Time.

Verizon, NY

Power Platform Developer Feb 2021 to Oct 2021

Responsibilities:

Involved in the Client meetings to understanding the requirements.

Created Dashboards for the Users to Track the Products sales.

Worked on Performance Tuning on the reports, for this we have connected to Azure Data Factory and Snowflake to bring the data to Power BI.

Monitored the performance of the Autonomous Data Warehouse and identify opportunities for optimization.

Created a report with What If Parameters to check the Trend in the future.

Connected with the external data sources to bring the data to Power BI and worked on data Transformations like removing unused columns, name changing of the fields, changed the data types, created conditional columns, merge queries, append queries, etc.

Implemented data validation and quality checks within PL/SQL code to ensure data integrity and accuracy.

Created Model driven App for the Supply Change Management Team .

Environment: Power BI Desktop, Power BI Service, Power Apps, Power Automate, Share Point, Microsoft Office 2016, SQL Server 2016, Azure data Factory and Snowflake.

Sainsbury’s, Bangalore

Power Platform Developer Oct 2018 to Dec 2020

Responsibilities:

Involved in client meetings to get the Business requirements and connected with DB Team to achieve that.

Imported data from multiple data sources into Power BI Desktop like SQL Server, MS Excel

Worked on different DAX functions like Date functions, Time Intelligence functions, Mathematical functions and Statistical functions for creating Calculated Columns and Calculated Measures.

Created multiple Work spaces to share the contents with the Clients and added them for the App work spaces with specific rights and also provided access to build their own reports from scratch.

Row Level Security is implemented to the reports for data privacy.

Created Canvas apps and Model driven apps to track the manufacturing and sales in different Product segments.

Extracted data from MySQL databases using Power BI's built-in connectors or by writing custom SQL queries. Ensured that the data extraction process is efficient and optimized for performance.

Developed scripts and workflows to automate routine tasks such as data loading, transformation, and maintenance activities within the Autonomous Data Warehouse ADW.

Created different cloud flows like Instant flows, scheduled flows and automated flows to run them.

Closely worked on ITSM Teams with Incident, Problem & Change Management and provided ad-hoc reports to the Customers to track how many Incidents have been opened, how many are closed, any SLA breached for specific period.

Environment: Power BI Desktop, Power BI Service, Microsoft Office 2016,SQL Server 2012 & ITSM Tool.

Office Depot, Bangalore

Tableau Developer Aug 2017 to Oct 2018

Responsibilities:

Gathered and analyzed the business requirements and then translated them to technical specifications and designed documents for development.

Actively participated in interaction with Users, Team leads, DBA, and Technical Managers to fully understand the requirements of the system.

Provided mock-up visuals to speed up the requirement visualizations.

Hands-on experience in creating and modifying worksheets and data visualization dashboards.

Created LOD(Level of Detail) expressions data source columns that are computed for each row in the underlying data.

Developed interactive dashboards and reports in Power BI to visualize insights from the MySQL data.

Created Data Source Level Filter, Context Filter, and Cascading Filters to improve performance and user flexibility.

Performed tuning of reports and resolving issues with Tableau Server.

Created Side by Sidebars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, and Symbol Maps according to deliverable specifications.

Environment: Tableau Desktop 10.0, Tableau Server 10.0, SQL Server 2012.

Haldirams, Bangalore

Tableau Developer Oct 2015 to Mar 2017

Responsibilities:

Extensive experience in reviewing those business requirements and analyzing data sources from Excel/Oracle SQL Server to Design, Develop, test reporting, and analyze projects within Tableau Desktop.

Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using Filters and Actions.

Created Heat Maps showing current service subscribers by the color that was broken into regions allowing business Users to understand where we have the most users vs. least users.

Projected and forecasted future growth by developing reports to show in detail.

Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

Developed storytelling dashboards in Tableau Desktop and published them on Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on-demand needed information.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Tested dashboards to ensure data was matching the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop 8.2, Tableau Server 8.2, SQL Server 2008.

Hewlett-Packard, Bangalore

Sap BO Developer Apr 2014 to Aug 2015

Responsibilities:

Involved in the Client meetings to understand the requirements.

Generated various reports on daily, weekly and monthly basis.

Created Dashboards using Filters, table, Line, Column and Pie charts (combination of bar graphs, combination of bar and line graphs, and line graphs will be used to display metrics.)

Worked as a team member in Migration process which included Migration of Reports and Universes from BOSS (3.1) to BOE (4.0).

Tested the reports and Universes in new environment after the migration, which included Parsing of Joins, Refresh Structure, Unit Testing of Business Layer objects, Check integrity, etc.

Environment: Sap BO 4.0, WebI, Universe, SQL Server 2012

Contact this candidate