
Muhammad Usman Mansha
Verified Expert in Engineering
Software Developer
Islamabad, Islamabad Capital Territory, Pakistan
Toptal member since August 23, 2021
Usman has over ten years of professional experience as a Dynamics CRM/365 CE functional consultant and .NET Core and MVC developer. He has worked across different projects like Dynamics customization, plugins, workflows, and web resources development; Dynamics migration, custom WebForms, MVC applications, Angular development, WCF, .NET Core web applications, and SSRS reporting. Usman is a team player, likes to help, writes clean and optimized code, and is always keen to improve his solutions.
Portfolio
Experience
- Data Reporting - 10 years
- C# - 10 years
- Data Analysis - 10 years
- Microsoft SQL Server - 10 years
- Dynamics CRM 365 - 10 years
- App Development - 10 years
- ASP.NET MVC - 7 years
- .NET Core - 3 years
Availability
Preferred Environment
Windows, Microsoft Teams, Skype, Visual Studio, Git, Slack, GitHub, Azure, Dynamics CRM 365, C#
The most amazing...
...thing I did is the .NET app integrated with Dynamics to streamline the accounting workflow of reconciliation, commission calculation, and payout to partners.
Work Experience
Associate Software Architect
Global Rescue
- Worked on deployments in production and kept different dynamics, environments, code repositories, and servers with patches and updates in sync. Set up the CI/CD to deploy our .NET Core and Angular application with GitLab.
- Upgraded Dynamics CRM 2013 on-premise to Microsoft Dynamics 365, version 8.2 (on-premises). Kept up with the latest update rollups.
- Identified and fixed data anomalies and collaborated with the accounting team on reconciliation.
- Managed database backups, mirroring, and log shipping. Also, kept the SQL server patched with the latest supported updates.
- Developed numerous custom .NET applications and workspaces for sales, member services, operations, and accounting teams integrated with Microsoft Dynamics 365, using ASP.NET MVC, Razor, TypeScript, Bootstrap, and Entity Framework.
- Designed an application architecture using .NET Core 5 and Angular 8. Moved legacy .NET Web Forms pages to .NET Core and Angular.
- Worked on SQL services. Used SSIS to write packages that sync data from the main database to two reporting databases. Using SSAS, we developed a cube for senior management on our sales data and provided an option to perform analysis in an Excel file.
- Improved Microsoft Dynamics CRM performance by reviewing the logic of the legacy JavaScript and HTML web resources.
- Worked on the implementation of analytics and GTM in a retail website. Stored campaign codes for different periods using cookies and Dynamics 365 by storing campaign tagging with leads/contacts for campaigns.
- Designed marketing campaign automation in .NET, Dynamics 365, and ClickDimensions. Developed a custom lead journey dashboard with SSIS and .NET. Worked on the Digital Media Portal that integrates with GA, Bing, FB, StackAdapt, LinkedIn, and Dynamics.
Microsoft 365 and Power App Developer
Q-Style Ltd
- Worked on setting up sandbox and production environments.
- Built a Power Apps app with entities related to the manufacturing process of lingerie. Designed flows and scripts for their business process.
- Developed a critical path on the Microsoft Power BI report and a Canvas app that was added to the Power BI report to update activities.
- Created a desktop application for BOM export using a Dynamics API.
C# Developer
Redux Limited
- Generated a database diagram. Ran scripts to find missing indexes and created them. Checked table sizes. The table rows count is also listed.
- Checked the web and tracker app usage. Reviewed existing projects to list technologies used.
- Reviewed stored procedures called in reports and fixed them.
- Handled the development in C# required for improving the company website.
.NET Developer
Sunfly Karaoke Ltd
- Learned DDEX, a standards-setting organization focused on the creation of digital value chain standards to make the exchange of data and information across the music industry more efficient.
- Developed a desktop app that creates DDEX documents for music files.
- Helped the client upload on the SFTP server and end-to-end ingestion of his assets on PEX, which is an attribution engine and marketplace for creators.
Full-stack Developer
Atlas Tech Development, Inc.
- Redid two VB.NET Windows services that read and processed XML from integrated systems in .NET Core.
- Rewrote two SOAP web services that read and processed XML from integrated systems in .NET Core.
- Worked on CI/CD pipelines in Azure DevOps. Used GitHub Desktop for code sharing.
Senior Software Engineer
Global Rescue
- Managed a team of four developers and reviewed their code to ensure code quality and best practices.
- Developed numerous custom .NET applications and workspaces for sales, member services, operations, and accounting teams, using ASP.NET MVC, Razor, TypeScript, Bootstrap, and Entity Framework.
- Analyzed data to find anomalies and fixed them. Worked on data reconciliation with the accounting team.
- Improved the reports development process by introducing a separate reporting database, written syncing jobs, views, functions, and stored procedures.
- Managed database backups, mirroring, and log shipping.
- Used SSIS packages to create another reporting database that stores the lead journey.
Software Engineer
Global Rescue
- Developed a custom framework to convert our DTOs to Dynamics entities and vice versa, using C# reflection.
- Created distributed WCF web services to be used as an API interface for public-facing websites.
- Worked on dozens of SSRS reports for senior management and different teams like sales, member services, operations, and accounting.
- Set up Git repositories to manage scattered code and introduced code best practices and reusability in the team.
- Developed a .NET app integrated with Dynamics to streamline the accounting workflow of reconciliation, commission calculation, and payout to affinity partners.
Associate Software Engineer
Global Rescue
- Migrated data of more than 35 thousand members and their memberships, payments, and family members by writing custom utility in C# from the legacy SQL Server database to Dynamics CRM.
- Worked on complex traveler tracking module in Java EE, EJB, Hibernate, and MySQL.
- Developed custom table, dropdown, and card components in JSF.
Experience
Affinity Partners Commission Engine
Document Management
Dynamics CRM Scheduled Workflows
The project involved developing execution rounds to charge for installments and automatic renewals as well as confirmation emails on the success or failure of transactions. I created and assigned tasks to welcome members.
Data Manipulation for Belongil Times
Separate Reporting Database
Also, wrote functions for reusability and stored procedures to retrieve data.
Desktop App for Music Industry
I also helped the client upload on the SFTP server and end-to-end ingestion of his assets on PEX and 7Digital, which is an attribution engine and marketplace for creators.
Education
Bachelor's Degree in Information Technology
National University of Sciences and Technology - Islamabad, Pakistan
Certifications
AWS Solutions Architect Associate
Amazon Web Services
AWS Developer Associate
Amazon Web Services
AWS Certified Cloud Practitioner
Amazon Web Services
Azure AI Fundamentals
Microsoft
Azure Data Fundamentals
Microsoft
Dynamics 365 Fundamentals (ERP)
Microsoft
Dynamics 365 Fundamentals (CRM)
Microsoft
Enterprise Design Thinking Practitioner
IBM
Azure Fundamentals
Microsoft
Power Platform Fundamentals
Microsoft
Skills
Libraries/APIs
Entity Framework, REST APIs, Complex SQL Queries, NumPy, Pandas, SignalR, Node.js
Tools
Microsoft Dynamics CRM, Microsoft Dynamics, Microsoft Power Apps, Git, Microsoft Teams, Skype, Visual Studio, GitHub, Bitbucket, Microsoft Power BI, Excel 2016, Excel 2013, Microsoft Report Builder, Microsoft Dynamics 365 for Finance and Operations, Microsoft Excel, Microsoft Flow, Slack, GitLab CI/CD, GitLab, RestSharp, Azure Machine Learning, Amazon CloudFront CDN, Amazon Virtual Private Cloud (VPC), Microsoft Access, Azure App Service, Microsoft AI
Languages
C#, SQL, C#.NET, XML, Python, JavaScript, SQL DML, Data Manipulation Language (DML), T-SQL (Transact-SQL), Java, Stored Procedure, HTML, Java EE 7, CSS, TypeScript, Visual Basic, Visual Basic 6 (VB6), Visual Basic .NET (VB.NET), XAML, GraphQL, C++
Frameworks
ASP.NET, .NET 5, ASP.NET MVC, Angular, .NET Core, .NET, Razor, ASP.NET Core, .NET 4, .NET 6, JSF, Hibernate, Bootstrap, Entity Framework Core, Windows Presentation Foundation (WPF), Windows PowerShell, Spring Boot
Paradigms
Change Management, Database-driven Web App Development, ETL, Business Intelligence (BI), REST, App Development, Database Development, Azure DevOps, Desktop App Development, DevOps, Microservices, Requirements Analysis
Platforms
XRM, Windows, Amazon Web Services (AWS), Azure, Microsoft Power Automate, Microsoft Dynamics 365, SharePoint 2013, SharePoint, Amazon EC2, Linux, Azure Synapse
Storage
SQL Server Reporting Services (SSRS), DB, Databases, MySQL, SQL Server 2008, Microsoft SQL Server, XML Parsing, PostgreSQL, Data Integration, SQL Server Integration Services (SSIS), Amazon S3 (AWS S3), SQL Stored Procedures, SQL Functions, SQL Views, SQL Server Agent, JSON, Azure SQL Databases, SQL Performance, Database Administration (DBA), Azure SQL, SQL Server 2014, Data Pipelines
Other
Dynamics CRM 2013, SSRS Reports, Dynamics CRM Plugins, Dynamics CRM Workflows, WCF Web Services, Statistics, Web Development, Dynamics CRM 365, Internet Information Services (IIS), Data Manipulation, CSV, Reconciliation, Data Analytics, Data Reporting, Data Analysis, Data Visualization, Data Warehousing, Data Engineering, Data Migration, Reports, IT Project Management, Product Development, IIS, BI Reports, Product Design, IT Business Analysis, Customer Relationship Management (CRM), Minimum Viable Product (MVP), Back-end Development, Architecture, Dashboards, Data Queries, Performance Tuning, Back-end, Windows Services, SOAP, APIs, File Sharing, SFTP, Microsoft Azure, Web App Development, Data Feeds, Electronic Data Interchange (EDI), Data Management, Enterprise Resource Planning (ERP), CRM APIs, Integration, Business Services, Microsoft Dataverse, Technical Leadership, Microsoft Power Fx, Technical Consulting, Microsoft 365, Full-stack, Solution Architecture, Outlook, Reflection, Cloud Services, Email Campaigns, Google Data Studio, CI/CD Pipelines, Marketing Attribution, Amazon RDS, AWS DevOps, Business Analysis, Product Management, Mail Merge
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring