Power Bi Information Technology
Resume:
ASHISH KOHALE
**** ****** **, ********, ** *****
ad3lhc@r.postjobfree.com
https://www.linkedin.com/in/ashish-k-58074397/
Education Bachelor of Engineering in Amaravati University (India) 2008
I have overall 13+ years of experience in Information technology with various technology including BI domain. I have worked on multiple reporting tools. I am very comfortable with the role of Power BI developer and believe I could be a best fit for this role because of my report development experience and interactive experience with VP, SR VP, Director, steering committee people too. It is not only a development but also my Team Lead experience could make me the best fit for this role.
PROFESSIOANL SUMMARY
Developed numerous data models, BI and tableau reports, defined built countless key metrics, KPIs, scorecards chart rich reports using complex excel functions, advanced Macro, Microsoft Power BI stack - Power Pivot, DAX, Power View, power query, power Map, OLAP cubes, MDX and Tableau Visualization Tool.
Developed reports in Power BI Desktop and deployed to both Power BI Report Server and Power BI Service
Experience in designing and implementing power apps, visual web parts, workflows, event handlers, and content types, search, custom document libraries.
Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
Worked on all the Products in Power BI such as Power BI Desktop, Power BI Pro, Power BI Embedded, Power BI Report Server, Power BI Premium, Power BI Mobile
Experienced creating tabular reports Matrix Reports, Parameterized Reports, Sub Reports, Global Map Reports in both Power BI and Power BI Cloud Service
Depth knowledge of Snowflake Database, Schema and Table structures.
Worked with azure synapse to process 30 Billon rows of data for Business intelligence analysis.
Expertise in design and configured ISTM and customizing the application using Java Scripts, AJAX, and HTML and Service Now
Excellent experience in MS Dynamics AX, Micro strategy, Reporting implementation of Crystal Reports/ SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
Strong ability to analyze user requirements, Business Requirement Specifications.
Expert in Data Preparation, Data Modeling and Data Blending.
Extensive experience with MySQL, DB2, SQL Server, Oracle Database Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.
Expertise in Power BI, Power BI Pro, Power BI Mobile
Experience in ETL processes involving migrations and in sync processes between two databases.
Excellent knowledge of all the phases of Software Development Life Cycle (SDLC
Extensive experience in design and developing of jobs, workflows, Data flows and creation of transformations between source and target database using Power Platform Apps.
Expert in creating and developing Power BI Dashboards into rich look and tested Power BI reports of Database and verified it with the source data.
Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER functions.
Involved in Coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.
Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
Designed and developed MS PowerApps (Canvas Apps and Model-Driven Apps) / Power Automate/Flow to deliver automation capabilities using low/no-code solutions and products.
Experience on understanding of Power Platform business value and product capabilities.
Lead experience in migrating on-premises SharePoint infrastructure and content to M365 (office 365)
Experience in troubleshooting custom workflows and forms for migration to M365 (Office 365).
Supported solutions within Power Platform using out-of-the box features and capabilities.
Hands on experience Supporting Canvas and Model-driven Power Apps.
Working experience on types of flows using Power Automate.
TECHNICAL SKILLS
Languages
C#, Python Basics
JavaScript, jQuery,
Databases
MS SQL Server 2000/2005/2008/2012,
Azure, Oracle 10g/11g, My SQL, MS Access
Dataverse
SharePoint
Reporting Tool
PowerBI, SSRS, Tableau 8, PowerBI Gateway, Power Query
Tools
VS 2005/8/10/13, SharePoint Designer
Info Path Designer, MS Visio, GIT, JIRA
Service Now, ConnectWise
Web Server
IIS 5.0/6.0/7.0
Frameworks
.NET Framework 8.0
Database Connectivity
SSIS, Informatica
Web Programming
HTML, XML, CAML, XSLT, CSS
Methodologies
Waterfall, Agile/SCRUM
Professional Experience
PowerBI developer/ Power Platform Architect May 2023 – Present
Company Name: NGenious solutions Dallas, Texas
Client Name: USDA (USA Federal Govt.)
The U.S. Department of Agriculture (USDA), Agricultural Research Service (ARS) and AI Centre of Excellence offer exciting collaborative research opportunities to motivated participants interested in solving agricultural-natural resource related problems.
Goal here is to transfer the application from legacy environment to Microsoft Power Platform
Responsibilities:
Create Paginated Reports in PowerBI report builder (BIRT) for Postdoc records by connecting with Azure SQL database.
Convert legacy Oracle ERP reports in PowerBI (BIRT).
Integrated Canvas Apps with various data sources, including Microsoft Dataverse, SharePoint Online, and Azure SQL Server databases.
Created data models and relationships within PowerApps Canvas App to ensure seamless data connectivity.
Implemented data validation and error handling mechanisms to maintain data integrity.
Created visually appealing and intuitive user interfaces using Power Apps Canvas Apps.
Worked on the user interface (UI) of the Canvas App for optimal user experience.
Created wireframes and prototypes to visualize Canvas app functionality.
Integrate PowerApps Canvas with other Microsoft 365 services and external data sources.
Adheres to government-specific compliance standards and regulations.
Includes features such as Microsoft 365 Government, Exchange Online, Teams, and SharePoint Online.
Integrates with other Microsoft 365 services designed for government environments.
Developed and maintained mission-critical web applications using modern technologies such as JavaScript, CSS, and Vue.js.
Develop new user-facing features using Vue.js.
Ensure the technical feasibility of UI/UX designs.
Create responsive and visually appealing user interfaces to enhance user experience.
Client Name: SWAPA
Develop and Configure Centre of Excellence
Centre of Excellence (CoE) in an organization drives innovation and improvement and brings together like-minded people with similar business goals to share knowledge and success, while at the same time providing standards, consistency, and governance to the organization.
Responsibilities:
Used Power BI desktop to directly connect to database tables (Direct Query Mode) or import the files into Power BI (Import Mode)
Developed documentation for business requirements, functional and technical specifications, and development standards for assigned projects and applications.
Used Power BI to extract data from different sources such as SQL Server, Excel, CSV files, load cleaned the data and loaded it into the Power BI canvas for visualization and analysis.
Wrote Azure trigger functions to schedule loading of data into the data model created in Visual Studio and deployed on Azure Analysis Services to be used for reporting by PowerBI.
Analyzed the Business Requirement Document (BRD) to design a conceptual model, participate in all phases of SDLC process to implement T-SQL, SSIS, SSAS and SSRS to develop a solution.
Implemented Power BI Gateway different source to matching analysis criteria and further modelling for Power Pivot and Power View.
Performed programming in M Query while using power query ETL process.
Used Python scripts to update content in the database and manipulate files.
Designed reports utilizing custom filters and DAX expressions with Power BI, and written DAX Expressions, Power Query and Functions in Power BI
Analyzed source system data to assess data quality, worked with technical and business representatives to determine strategies for handling data anomalies that are identified.
Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option- Parameterized, and Linked reports using Tableau.
Carried out administrative tasks on DOMO like adding/maintaining users and groups, scheduling reports, setting up presentations directly on Microsoft Excel and PowerPoint using DOMO plugins.
Set up Microsoft Flow (Power Automate) to provide auto approval and status update feature based on predefined criteria.
Created hierarchies in Power BI to help end users make accurate decisions based on the visualizations.
Created custom KPI scorecards to help end users visualize metrics according to their preference.
Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard
Worked using Column profiling to optimize columns and remove redundancies and errors from individual columns.
Responsible for building reports in Power BI from Scratch.
Worked on building reports for tracking Incidents & Change management on top of Service Now Data
Creating Row level securities and integrating with Power BI service portal.
Used Cross-Report Drill through to link source and target reports to drill through the necessary information for the end user.
Created and developed star and snowflake schema.
Utilized Query Editor to clean and format data and eliminate redundant information and append and merge tables from various data sources.
Worked on emerging trends and technologies in front-end development, UI/UX design, SharePoint, and the Microsoft 365 Power Platform.
Administer and maintain Office 365 services, including Exchange Online, SharePoint Online, Teams, and OneDrive for Business.
Designed and developed Canvas Apps using Microsoft PowerApps platform.
Integrated Canvas Apps with various data sources, including Microsoft Dataverse, SharePoint, and SQL Server databases.
Created data models and relationships within PowerApps Canvas App to ensure seamless data connectivity.
Implemented data validation and error handling mechanisms to maintain data integrity within Canvas App.
Created visually appealing and intuitive user interfaces using Power Apps Canvas Apps.
Configure CoE for the organization.
Create a Theming solution for the organization.
Customize the Center of Excellence Apps and flows as per organization requirement.
Help organization to build DLP policies Apps and flows.
Configure Core components and Nurture components.
Create Power Platform environment (Canvas App) and handle the security roles.
Developed and Support for the applications in InfoPath form on SharePoint on-premises.
Migrated the application from Nintex platform to Power Platform.
Designed and developed Power Platform (PowerApps & PowerAutomate) applications with Dataverse tables.
Used Dataverse features like Virtual Table, Business Process Flow, connect Dataverse tables with each other.
Analysis of InfoPath forms for future redevelop-platform functionality in Power Apps.
Identify the design of site collections and record information concerning customizations and special features in the site and controls available in the SharePoint 2013/2010 server platform and inform to site owners' feasibility of the same features in SharePoint online (SPO).
Helped stakeholders for existing forms using PowerApps Components.
Monitor the REST API Services on SharePoint Online and SharePoint server.
Handled the Feature Permission for application users.
Support applications on SharePoint 2010/2013/2016/2019 server.
Extensively support and maintained approval PowerAutomate/Flows/Workflows in the application.
Support the application using Power Apps and Power Automate to automate customer relationship management processes.
Customize Power Apps Portals (formerly Dynamics 365 Portals) to provide external users with self-service capabilities.
Utilize Power BI to create interactive dashboards and reports that visualize data from multiple sources, including Microsoft SQL Server. Incorporate data from Dynamics 365 and other systems and provide stakeholders with real-time insights and analytics.
Collaborated with compliance officers to understand audit workflows and documentation requirements.
Periodically review and update governance standards based on evolving business requirements and technological advancements.
Technologies: PowerBI, O365/M365, PowerApps, PowerAutomate, SharePoint Online
PowerBI developer/Power Platform developer May 2022 – May 2023
Company Name: EnerMech Houston, Texas
Employment Change Request (ECR)
ECR System is the cloud application on Power Platform which makes provision for the HR department to run the employment request. Human resources forms are documents used by a company's HR department to recruit and manage employees. Manage employee information, employment verification, employment satisfaction, cv submissions, job applications etc. human resources online form templates.
Responsibilities:
Created reports based on different services.
Used Power BI desktop to directly connect to database tables (Direct Query Mode) or import the files into Power BI (Import Mode)
Developed dynamic reports using Power Apps reporting interface and SSRS and deployed it on the CRM that were used in the application Web services Power BI depending on roles.
Developed custom paginated operational reporting solutions targeting Power BI Report Server and Power BI via both T-SQL queries against SQL Server and DAX queries.
Developed documentation for business requirements, functional and technical specifications, and development standards for assigned projects and applications.
Designed a data model on Snowflake database to support reporting requirements.
Deploying the Qlik Sense apps to streams and maintaining user security and data security using section access.
Used Scripting tools and Service Now functionality to create script to automate rote task being done in Service Now
Used Power BI to extract data from different sources such as SQL Server, Excel, CSV files, load cleaned the data and loaded it into the Power BI canvas for visualization and analysis.
Import data from multiple data sources into BI Tools, Knowledge in making use of data sources: analysis server, data lake, azure SQL, cosmos db.
Designed reports utilizing custom filters and DAX expressions with Power BI, and written DAX Expressions, Power Query and Functions in Power BI
Created Mobile Apps with Microsoft Power Apps
Created database links and accessed the data through SQL statements.
Created hierarchies in Power BI to help end users make accurate decisions based on the visualizations.
Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard
Responsible for building reports in Power BI from Scratch.
Creating Row level securities and integrating with Power BI service portal.
Involved in generating and maintaining SQL scripts.
Implemented Power BI Gateway different source to matching analysis criteria and further modelling for Power Pivot and Power View.
Utilized Query Editor to clean and format data and eliminate redundant information and append and merge tables from various data sources.
Monitor and optimize Office 365 performance, ensuring a secure and compliant environment.
Implement domain renames and seamlessly integrate new domains with existing ones in Active Directory.
Automated business processes within Canvas Apps using Power Automate (formerly Flow).
Conducted performance testing and optimization to ensure the responsiveness of Canvas Apps.
Identified and resolved performance bottlenecks in Canvas app design and data retrieval processes.
Implemented security measures within Canvas Apps to control data access and user permissions.
Implement version control for Canvas Apps to track changes over time.
Orchestrated the deployment of Canvas Apps across different environments, including development, testing, and production.
Provided training sessions for end-users on how to navigate and use the Canvas App
Developed and Support for the applications in InfoPath form on SharePoint on-premises.
Built the search service from scratch for SharePoint on-premises.
Migrated the application from Nintex platform to Power Platform Canvas App.
Designed and developed Power Platform (PowerApps & PowerAutomate) applications with Dataverse tables.
Used Dataverse features like Virtual Table, Business Process Flow, connect Dataverse tables with each other.
Analysis of InfoPath forms for future redevelop-platform functionality in Power Apps Canvas App.
Identify the design of site collections and record information concerning customizations and special features in the site and controls available in the SharePoint 2013/2010 server platform and inform to site owners' feasibility of the same features in SharePoint online (SPO).
Integrated Power Automate (formerly Flow) workflows within the Canvas App.
Built the responsive Canvas App and ensured it worked seamlessly across different devices and screen sizes.
Conduct testing of the Canvas App for functionality, usability, and performance.
Maintained the tabular report in SSRS (BIRT) and embedded it in page SharePoint 2010/2013 server.
Helped stakeholders for existing forms using PowerApps Canvas App Components.
Monitor the REST API Services on SharePoint Online and SharePoint server.
Support applications on SharePoint 2010/2013/2016/2019 server.
Designed and supported SSRS and SSIS reports.
Extensively support and maintained approval PowerAutomate/Flows/Workflows in the application.
Support the application using Power Apps and Power Automate to automate customer relationship management processes.
Customize Power Apps Portals (formerly Dynamics 365 Portals) to provide external users with self-service capabilities.
Utilize Power BI to create interactive dashboards and reports that visualize data from multiple sources, including Microsoft SQL Server. Incorporate data from Dynamics 365 and other systems and provide stakeholders with real-time insights and analytics.
Support end-to-end business process automation using Power Automate Cloud Flows. Create workflows that integrate various systems, automate repetitive tasks, and streamline business processes across departments.
Develop a responsive web application using HTML5, CSS, JavaScript, jQuery, and Bootstrap.
Custom Reporting and Analytics: Build custom reports and analytics using Telerik Reporting and deploy it on SharePoint server.
Implemented and maintained document libraries, lists, and content types, site pages, web parts, custom views.
Monitored and troubleshoot site performance, resolving issues as needed.
Provide technical support and troubleshoot issues - SharePoint incident and problem management.
Maintain configurable out of the box (minimize customization) SharePoint applications.
Involved seamless integration with existing SharePoint environments and external systems, followed by thorough testing and validation of application functionality.
Migrated application from SharePoint on-premise 2010/2013 to SharePoint Online using Sharegate tool.
Integrated UiPath with HRIS systems for data synchronization.
Developed UiPath scripts to extract, transform, and load data from various sources.
Collaborated with the database team to ensure data integrity and accuracy in UiPath.
Implemented logging and reporting mechanisms for real-time monitoring of the migration process in UiPath.
Ensuring data integrity, performance, and scalability in database designs.
Monitoring and optimizing database performance and resource utilization.
Technologies: O365, PowerApps, PowerAutomate, SharePoint Online, PowerBI, SharePoint 2010/2013/2016 server.
PowerBI/Power Platform Developer /M365 SharePoint Oct 2020 – May 2022
Deutsche Bank Jacksonville, FL
The bank has millions of users. Develop and support the SharePoint application including Power Platform (PowerApps/Power Automate/Power BI) for the users across the globe. The Email, Productivity and Collaboration (EPC) Service Operations team are responsible for the day-to-day support/development tasks of the end user’s platform for the Banks global EPC environment. In this role working closely with the other platform towers, such as mobility, desktop, voice systems, email, collaboration.
As the Operation Service Specialist, the daily operation and maintenance of the EPC Infrastructure. Analysing issues, request fulfilment, incident management, resolution of issues and conflicts, proactive improvements and automation within the environment and running reports and attending meetings
Responsibilities:
Created POWER BI Visualizations and Dashboards as per the requirements.
Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features.
Upload and save power bi paginated report to power BI Report Server Redesign power bi dashboards and paginated reports.
Created many calculated columns and measures using DAX in POWER BI based on report requirements.
Involved in UI Design for POWER BI Reports and designed effective layouts.
Used Cross-Report Drill through to link source and target reports to drill through the necessary information for the end user.
Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in POWER BI
Involved in migration between various environments in service now using service update sets and import sets.
Configure Power BI Report Server for SSRS, deployed and scheduled reports in Report Manager.
Setting the Policies, Limits for the Azure Data Lake Analytics and provide access to the users to process USQL jobs.
Worked with development team in integrating Power BI visuals in in-house application using Power BI embedded.
Analyzed source system data to assess data quality, worked with technical and business representatives to determine strategies for handling data anomalies that are identified.
Gained experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentation.
Moving data in and out of an instance using import set and transform map and also auto import of data into Service Now.
Created custom KPI scorecards to help end users visualize metrics according to their preference.
Developed complex SQL Views, Common Table Expressions, and Temporary Tables
Created Roles and implemented Row level security for user Authentication in POWER BI
Worked with POWER BI mobile app and created mobile layouts to view reports and dashboards effectively.
Responsible for creating and changing the data visualizations in Power BI reports and Dashboards on client requests.
Troubleshoot and resolve Office 365-related issues promptly to minimize downtime.
Implement security best practices across Office 365 services and Active Directory.
Proactively identified opportunities for improvement in Canvas App design and functionality.
Worked on ticketing tool like Service Now to help the user to support on issues/queries related to PowerAutomate/PowerApps/SharePoint (2010/2013/2016)/SharePoint Online/M365 apps.
Worked on support project on emails and search features of M365.
Support SharePoint applications on InfoPath form.
Migrated the application from InfoPath form to PowerApps (Canvas App).
Analysis of InfoPath forms for future redevelop-platform functionality in Power Apps.
Identify the design of site collections and record information concerning customizations and special features in the site and controls available in the SharePoint 2013/2010 and inform to site owners' feasibility of the same features in SharePoint online (SPO).
Maintained tabular report in SSRS (BIRT) and embedded on SharePoint (2010/2013 server) page.
Developed and Support a Power BI dashboard that visualizes sales pipeline data from Dynamics 365.
Developed and Support Power Automate Cloud Flows to automate tasks such as account provisioning, email notifications, and document signing.
Managed a user-friendly interface with HTML5, CSS, JavaScript, and Bootstrap.
Support Power Automate Cloud Flows to automate task assignment and notifications and integrate with Microsoft SQL Server for data storage.
Support applications on SharePoint 2010/2013/2016/2019 and deploy the solution on SharePoint server.
Worked on HR Department projects like ECR and PRFs on Power Platform (PowerApps/PowerAutomate).
Migrated application from SharePoint on-premises 2010/2013 server to SharePoint Online using ShareGate tool.
Migrate application from SP 2010/2013 server to Power Platform (PowerApps & PowerAutomate) with backed as SharePoint Online.
Designed and supported SSRS and SSIS reports.
Migrate applications from Nintex to Power Platform (PowerApps & PowerAutomate).
Automated tasks for SharePoint like site creation and Manage Access.
Support CI/CD pipeline using the AWS CI/CD stack.
Integrate SharePoint online with Service Now to report issues.
Team handling and performance evaluation activities.
Manage Internal (Intranet) SharePoint Site. Creating and maintaining an efficient and user-friendly SharePoint site architecture.
managing user access and permissions, ensuring proper security protocols, and monitoring site performance to resolve any issues and implement optimizations.
Implement and maintain document libraries, lists, and content types, site pages, web parts, custom views.
Monitor and troubleshoot site performance, resolving issues as needed.
Provide technical support and troubleshoot issues - SharePoint incident and problem management.
Design, develop, implement, and maintain configurable out of the box (minimize customization) SharePoint applications.
Involved seamless integration with existing SharePoint environments and external systems, followed by thorough testing and validation of application functionality.
To automate manual/repetitive tasks using UiPath and PowerAutomate.
Planning and executing data migrations from on-premises databases to Azure SQL.
Implementing and managing ETL processes for data integration.
Technologies: PowerBI, PowerApps, PowerAutomate SharePoint Online, SharePoint 2010/2013 server, Service-Now .NET, C#, SQL 2016, JavaScript, jQuery, Fiddler, SSRS, SSIS, Web Service/WCF, XML, TFS,
PowerBI/Power Platform Developer Feb 2019 – Oct 2020
Patona Technologies Pune, India
Client Name: Treasury Wine Estate (TWE)
SharePoint 2010 On premise to SharePoint Online cloud migration, Nintex to Power Platform migration.
Migrate on-premises application to SharePoint online. This project will help to reduce the cost and the burden of server maintenance. TWE is an Australian Client, have millions of users. Develop and support the SharePoint application for the TWE users.
Responsibilities:
Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power BI Service Desktop tool.
Involved in database development using stored procedures, triggers, views and cursors.
Created Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
Wrote efficient Stored Procedures for the Optimal Performance of the system.
Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
Performed data refresh on Tableau Server on weekly, monthly and quarterly basis and ensured that the views and dashboards were accurately displaying the changes in data.
Designed dimensional data model of the OLAP database using Erwin.
Automated Power Query refresh using power shell script and windows task scheduler.
Deployed Dashboards, Reports and Data sources in the Power BI Service.
Implement automation scripts for routine Office 365 and Active Directory tasks, improving operational efficiency.
Facilitate the adoption of collaboration tools such as Microsoft Teams to enhance team communication and productivity.
Optimize processes for user onboarding, offboarding, and access management to streamline administrative workflows.
Designed and developed responsive Canvas Apps using Microsoft Power Apps platform.
Built a Canvas App application to integrate with various data sources and perform backend operation using PowerAutomate.
Worked on ticketing tool like Service Now to help the user to support on issues/queries related to PowerAutomate/PowerApps/SharePoint (2010/2013/2016)/SharePoint Online/M365 apps.
Integrated UiPath with the existing ERP system for seamless data exchange.
Help to transfer the application from legacy environment to PowerApps (Canvas App).
Analysis of InfoPath forms for future redevelop-platform functionality in Power Apps.
Support tabular report in SSRS and embedded it in SharePoint page.
Migrate Nintex Forms/Workflows to PowerApps and PowerAutomate.
Migrate 3k on premise applications to cloud SP online using Sharegate tool.
Designed developed applications on SharePoint 2010
Contact this candidate