Gajanan is available for hire
Hire GajananGajanan Saraswat
Verified Expert in Engineering
Software Developer
Location
Pune, Maharashtra, India
Toptal Member Since
November 1, 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.
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
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.
Work Experience
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=trueI 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.
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=trueOn 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.
• 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.
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
Platforms
Microsoft Power Automate, Azure Functions, Microsoft Power Platform
Other
Plugins, Microsoft Azure, Microsoft Power Virtual Agents, Azure WebJobs
Languages
JavaScript, HTML, C#, HTML5
Frameworks
.NET
Libraries/APIs
jQuery, Web API
Paradigms
Azure DevOps
Storage
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
Education
2010 - 2015
Bachelor's Degree in Computer Science
University of Pune - Pune, Maharashtra, India
Certifications
APRIL 2020 - MARCH 2023
PL-200 Microsoft Power Platform Functional Consultant
Microsoft
JULY 2019 - JUNE 2021
Exam MB-400: Microsoft Power Apps and Dynamics 365 Developer
Microsoft
APRIL 2019 - MARCH 2021
Exam MB-200: Microsoft Power Platform and Dynamics 365 Core
Microsoft
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring