Girish G

Experience

• 

  Veritas Document Solutions - An RRD Company

  May 2017 - Apr 2019

  Power Bi developer

  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-users to make filters. • Designed Power BI visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.• Created Cash Product Dashboard reports presenting critical company data in a single report using Cognos 11 metric studios.• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. Show less

• 

  Baxter International Inc.

  Jun 2019 - May 2020

  Power Bi / Sharepoint Developer

  • Strong experience in writing stored procedures, functions, triggers in MS T-SQL building the packages, Testing, and implementing in the production server.• Redesigned and tuned stored procedures, triggers, UDF, views, indexes, and was successfully able to increase the performance of the slow running queries. • Experience in Developing and Publishing Reports in SQL Server 2013 using SSRS (SQL Server Reporting Services).• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports, and Ad-hoc Reports. • Generated and formatted Reports using Global Variables and Expressions for the reports. • Designed and implemented stylish report layouts.• Involve in designing and publishing visually rich and intuitive Power BI dashboards for executive decision making Show less

• 

  CareSource

  Jun 2020 - Dec 2021

  Power Apps/ Sharepoint Developer

  • Worked on the Design and development of Data Migration/reporting projects.• Gathered and documented business requirements for analytical reports. Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.• This involved refactoring the code and optimizing the code based on the analysis for the SSIS packages, SSRS reports.• Developed complex SQL queries using stored procedures, common table expressions (CTE), temporary table to support SSRS reports. • Involves in designing and implementing parameterized and cascading parameterized reports using SSRS.• Involves in creating Sub-Reports, Drill down reports, and Drill through reports and Tabular reports using SSRS.• Involves in configure and maintain Report Manager and Report Server for SSRS.• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.• Experience in analyzing Medicaid management information system databases and developing reports/dashboards on that data. • Created mappings for sources Oracle, SQL server, flat and XML files to load and integrate data to warehouse.• Created target definition in oracle which was the target database.• Implemented lookups and different transformations in the mappings. Show less

• 

  Abbott

  Jun 2022 - now

  Power Platform Developer

  •Developed and deployed PowerApp solutions leveraging both model-driven and canvas apps to streamline operations for Abbott's medical devices and diagnostics businesses. This improved user experience and data management.• Developed canvas apps using Power Apps to digitize paper-based processes for managing quality control, logistics, and regulatory documentation for medical devices. Reduced document processing time by 80%.•Using PowerApps Built interactive model-driven apps on Dataverse to optimize sales ordering and inventory management for diagnostics products. Apps integrated with Dynamics 365 CRM and ERP system, improving data accuracy by 85%.•Created Power Automate workflows, including desktop, cloud, and data flow, to automate manual processes around pharmaceuticals and nutritional supply chains. This increased efficiency.•Leveraged C# and .NET skills to build custom connectors and integrate external APIs within the Power Platform solutions to meet Abbott’s unique requirements.Integrated SharePoint document libraries with PowerApps and Power Automate to optimize document management for quality assurance and regulatory compliance needs, reducing document retrieval times.•Customized and extended Dynamics CRM to support organization sales teams and order management processes, driving adoption and data accuracy.Designed interactive Power BI reports and dashboards providing real-time sales, inventory, and production insights enabling data-driven decision-making across Abbott.•Developed Power Query ETL scripts and SQL procedures to integrate Abbott's product, customer, and financial data from multiple systems like ERP, CRM, and proprietary databases into Dataverse. Enabled unified reporting using Excel and Power BI leveraging clean, consistent data.•Built Azure Functions to expose proprietary Abbott APIs and data for integration into PowerApps and Power Automate. Enabled scalable and secure enterprise solutions on Power Platform. Show less