Gajanan Saraswat, Software Developer in Pune, Maharashtra, India
Gajanan Saraswat

Software Developer in Pune, Maharashtra, India

Member since September 29, 2021
Gajanan is a Microsoft Certified Senior Engineer with over six years of Microsoft technologies experience. He is specialized in Microsoft CRM, Dynamics 365, Microsoft Power Platforms, Azure Cloud, and Office 365 and is an expert in the customization of CRM using C#.NET. Gajanan takes ownership, delivers on time, and aims for the best possible outcome in any given scenario.
Gajanan is now available for hire

Portfolio

  • LTI
    Microsoft Power Apps, Microsoft Power BI, Microsoft Power Automate...
  • LTI
    Azure DevOps, Azure Logic Apps, Azure Functions, C#
  • HCL Technologies
    Microsoft Dynamics CRM, Microsoft Power Apps, Microsoft Azure

Experience

  • Microsoft Dynamics CRM 6 years
  • Microsoft Power BI 5 years
  • Azure Logic Apps 3 years
  • Microsoft Azure 3 years
  • Azure Functions 3 years
  • Microsoft Power Automate 3 years
  • Microsoft Power Apps 3 years
  • Microsoft Power Platform 3 years

Location

Pune, Maharashtra, India

Availability

Part-time

Preferred Environment

Microsoft Dynamics CRM, Microsoft Power BI, Microsoft Power Automate, Microsoft Power Apps, Microsoft Azure, Microsoft Power Virtual Agents, .NET, JavaScript, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

The most amazing...

...thing I created is an application to capture Microsoft Flows run history and share it daily with the Administrator by MS Flow scheduler via a custom connector.

Employment

  • Senior Consultant

    2021 - PRESENT
    LTI
    • Got certificate of appreciation for outstanding performance, service, and dedication in March 2021.
    • Worked in an 18-member team and led six developer resources (power plant industry from North America Region with revenue of $2 billion for FY 2020-21).
    • Created Power BI report which displays duplicate account records created in Dynamics 365. I eliminated these duplicate records from Dynamics 365 CRM by custom entity record creation and called merge requests from the plugin.
    • Built Azure function app to integrate Dynamics 365 CRM with SAP using HTTP, time, and service bus triggers. Also, I stored external SAP API user IDs and passwords in the Azure Key Vault and accessed them through MS Flows.
    • Created Microsoft Flow to run SSRS reports and stores over SharePoint. Called Microsoft Graph APIs to get item ID, drive ID, and site ID of this stored SSRS report and sent this information to customers by consuming their web APIs via HTTP POST method.
    • Integrated SQL Server DB with Online Dynamics 365 CRM using data transporter. Also, I created a custom connector to get flow run history and email to on daily basis to system administrator using Power Automate flow.
    • Stored and maintained source code over Azure DevOps repositories. I tracked project progress in the agile approach through Azure DevOps. Also, I scheduled solution deployment automation from Azure DevOps build and release pipelines.
    • Participated in requirement gathering from customers.
    Technologies: Microsoft Power Apps, Microsoft Power BI, Microsoft Power Automate, Microsoft Azure
  • Senior Developer

    2021 - 2021
    LTI
    • Certified by Microsoft for PL-200 Microsoft Power Platform Functional Consultant and PL-400 Microsoft Power Platform Developer.
    • Worked for power plant industry having $600 million revenue for fiscal year (FY) 2019-20 with a team size of 12, including two testers, two business analysts, one product owner, one scrum master, and six developers.
    • Was part of the development team for this project, having an estimated budget of $2 million for 18 months.
    • Followed Agile approach for project tracking, collaboration, and delivery with Azure DevOps as a tool. I created solution deployment automation, source code repository, and sprint tasks and assigned these tasks to resources as per their expertise.
    • Developed several function app for integration of Dynamics 365 CRM with SAP for project service automation (PSA) module within the span of two months for eight entities on create, update and delete events in Dynamics 365 CRM.
    • Got expertise in calling function app from C# plugins and code activity.
    • Created schedulers from Microsoft Power Automate to update exchange rates of different currencies with USD. I also created logic apps for the integration of Dynamics 365 CRM with SAP.
    Technologies: Azure DevOps, Azure Logic Apps, Azure Functions, C#
  • Technical Consultant

    2019 - 2021
    HCL Technologies
    • Awarded as Most Productive Resource for achieving most numbers of billable hours (i.e. 1080 Hours) for FY 2019-2020; HCL charges $200 per hour of service per resource.
    • Worked with a team of a total headcount of 12 resources (health care for German-based organization with $600 million revenue for FY 2019-20).
    • Created Canvas Power app for a customer service representative to create appointments, schedule visits, visit approval from the manager, create a case, quote, and another appointment from a visit to customers.
    • Embedded Canvas App to model-driven app’s main form. I filtered this embedded Canvas app’s data from model-driven app’s data available in the main form’s record of an entity.
    • Created custom audit log for the selected set of entities from workflows, and plugins and created dashboard to show these logs to managing users.
    • Worked on Embedded BI using Power BI tool for creating dynamic UI reports for SQL Server and Dynamic 365 CRM platform.
    • Referred XML structured file having data to create product license like—number of users, expiry date I created SSRS reports using FetchXML.
    • Performed customization on Dynamic 365 CRM Field Service module as per customer requirement using plugin, code activity, JavaScript.
    • Worked on the configuration of omnichannel for customer service with Facebook.
    Technologies: Microsoft Dynamics CRM, Microsoft Power Apps, Microsoft Azure
  • Associate Consultant

    2015 - 2019
    Pragmasys Consulting LLP
    • Worked with a team of a total headcount of 12 resources (automobile for German-based organization with $10.8 billion revenue for FY 2019-20).
    • Created, integrated ASP.NET application to bulk import data into Microsoft CRM hosted over the virtual machine by querying data from SQL Server and filtering depending on required conditions.
    • Implemented integration of Microsoft Dynamic CRM with Salesforce from C# plugins on record create, update and delete events of account, contact and lead to synch data in both systems.
    • Created Web API web service to query data to SQL Server and get the result, populate over enhanced user-friendly UI created from native HTML over Microsoft CRM dashboard.
    • Gained hands-on experience in configuring Dynamics 365 CRM entities, forms, views, charts, relationships, alternate keys, business rules, workflows, actions, SLAs, record create and update rules, routing rule, queues, mailbox, data model, and security.
    • Experienced in customization Dynamics 365 CRM of components of MS CRM with OOB facilities, web resource, plugin, code activity, FetchXML as well as doing deployments, troubleshooting, and production support for applications developed.
    • Participated in Power BI, Microsoft Dynamics 365 Sales, service, marketing, field service, and project service automation training modules.
    Technologies: Microsoft Dynamics CRM, Microsoft Azure, .NET

Experience

  • Car Fleet for Magazine
    https://docs.google.com/presentation/d/1iKkQrLjGBFSR3l3SjnXAmO4ty4K5ysPE/edit?usp=sharing&ouid=107499251939915966118&rtpof=true&sd=true

    I configured a mailbox for customers who want to put car specifications in their magazine. From email records, we created a fleet request and contact if the sender doesn't exist in the system. This fleet request gets approved by managers to publish car models in customer's magazine.

    Vehicle usage SSRS reports were created for checking logs of fleet requested for the given period. This whole module was designed, developed, and delivered by me single-handedly within four weeks.

    This module was created on the MS CRM 2016 version and includes configurations of forms, entity, views, dashboard, relationships, and business rules, customizations of JavaScript, C# Plugin, C# code activity, and SSRS reporting.

  • Accounts Duplicate Cleanup
    https://docs.google.com/presentation/d/1_77snXLoz-SKHZWLNOGsGgqt_kdGgyaf/edit?usp=sharing&ouid=107499251939915966118&rtpof=true&sd=true

    On this project, I was working on:
    • Identifying duplicate accounts from combinations of email, phone, account name, and address available in Microsoft Dynamics 365 CRM v9.0 from Power BI reporting.
    • Creating duplicate detection rules to merge a duplicate account into original accounts. I assigned duplicate records as a child and the original record as a parent from these rules.
    • Creating a custom entity with parent and child text fields.
    • Exporting data from this Power BI report and imported into Dynamics 365 custom entity.
    • Creating a code activity that merges child account into parent account by account globally unique identifier (GUIDs) available in parent and child text fields.
    • Presentation regarding this project is available in the given project URL.

  • Goals vs Target Data Microsoft Dynamics CRM Server 2016 On-premise

    There's a limitation from Microsoft for goals not to be available to display on mobile devices. I have created an HTML web resource with gear, bar, pie, and column charts to overcome this limitation. I used HTML5 successfully implemented this UI in five business days.

    Also, I created custom HTTP GET Web APIs, which query the MSCRM SQL database and provide data from custom goals and achievement tables. I developed this Web API in five business days.

    These HTML charts loads data from custom tables from JQuery to get data through custom Web API calls from Ajax.

    Finally, I created a dashboard in Microsoft Dynamics CRM Server 2016 and provided HTML web resources reference to this dashboard.

Skills

  • Tools

    Microsoft Dynamics CRM, Microsoft Power BI, Microsoft Power Apps, Azure Logic Apps
  • Other

    Microsoft Power Automate, C# Plugins, C# Code Activity, Microsoft Azure, Microsoft Power Virtual Agents, Azure WebJobs, Microsoft Power Platform, Microsoft CRM 2016, C# WebAPI, MSCRM 2016
  • Languages

    JavaScript, HTML, C#, HTML5
  • Frameworks

    .NET
  • Libraries/APIs

    jQuery
  • Paradigms

    Azure DevOps
  • Platforms

    Azure Functions
  • Storage

    SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Education

  • Bachelor's Degree in Computer Science
    2010 - 2015
    University of Pune - Pune, Maharashtra, India

Certifications

  • PL-200 Microsoft Power Platform Functional Consultant
    APRIL 2020 - MARCH 2023
    Microsoft
  • Exam MB-400: Microsoft Power Apps and Dynamics 365 Developer
    JULY 2019 - JUNE 2021
    Microsoft
  • Exam MB-200: Microsoft Power Platform and Dynamics 365 Core
    APRIL 2019 - MARCH 2021
    Microsoft

To view more profiles

Join Toptal
Share it with others