Publication
An Expert Workaround for Executing Complex Entity Framework Core Stored Procedures
https://www.toptal.com/developers/dot-net/entity-framework-core-stored-procedure
Pankaj is currently unavailable
Pankaj Kansodariya
Verified Expert in Engineering
Microsoft Azure Certified Back-end Developer
London, United Kingdom
Toptal member since July 13, 2020
Bio
Pankaj is a Microsoft Certified Professional with 18 years of software development experience within the Microsoft ecosystem, including C#.NET, VB.NET, SQL Server, and cloud computing with Microsoft Azure. He has also started working on mobile app development with Flutter. Pankaj is now ready for his next challenging and rewarding opportunity to demonstrate how his substantial abilities and technical skills will make an effective contribution.
Portfolio
Hall of Fame Dance Challenge
ASP.NET, ASP.NET Core, Azure, C#.NET, Microsoft SQL Server, Git...
Freelance | Toptal Clients
Neo4j, Firebase, Dart, Flutter, Microsoft Azure, Microsoft SQL Server...
Builder.ai
ASP.NET Core, C#.NET, Python, RabbitMQ, Docker, GitLab, Azure Storage
Experience
- Transact-SQL (T-SQL) - 16 years
- VB.NET WinForms - 12 years
- C#.NET - 10 years
- .NET Core - 7 years
- WCF Web Services - 6 years
- Azure - 4 years
- ASP.NET Core MVC - 4 years
- Flutter - 1 year
Preferred Environment
Flutter, Git, Windows, Microsoft Azure, Microsoft SQL Server, Microsoft Visual Studio, C#.NET
The most amazing...
...thing I've converted was a legacy offer calculation engine from BI into a web-based simulation tool with ASP.NET, WCF Service, and SQL Server.
Work Experience
Solution Architect and Senior .NET Back-end Developer
2022 - PRESENT
Hall of Fame Dance Challenge
- Planned and executed the migration of a legacy website to a new website with Microsoft Azure.
- Ensured data integrity, site functionality, and user experience during the migration and collaborated with the development team and stakeholders.
- Improved the website's scalability, allowing greater capacity and flexibility to accommodate growing traffic and user demands.
Technologies: ASP.NET, ASP.NET Core, Azure, C#.NET, Microsoft SQL Server, Git, Entity Framework Core, ASP.NET Razor, Stripe API, Azure DevOps Services, .NET Core, Cloud, Serverless
Software Engineer
2020 - PRESENT
Freelance | Toptal Clients
- Collaborated as a technical screener at Toptal, starting in March 2021.
- Engaged as a senior .NET back-end developer with Gartner from November 2021 to September 2022, working on a distributed system with microsystem-oriented and message-driven architecture with Kafka and optimizing complex materialized views.
- Collaborated on a legislative management platform for security enhancements and a backlog of customer-reported defects at Granicus, a company that provides technology that empowers government organizations to create better lives for their citizens.
- Operated as a senior .NET back-end developer at Jacobs, an American international technical professional services firm, on the company's invoice and ERP system.
- Developed a Flutter app with a Firebase and Neo4j database that includes social media and marketplace functionality for ItsCoastal, the luxury marketplace for global coastal homes, adventures, and yachts.
- Operated on a Flutter app similar to Tinder for recruitment that includes videos for DreamTeams.
- Created a .NET Core application with SignalR for an online training app with live chat at Inxsol, a company that develops custom e-learning courses and information solutions.
- Provided live help on real-world programming issues at an online freelance agency, which I joined in April 2020.
Technologies: Neo4j, Firebase, Dart, Flutter, Microsoft Azure, Microsoft SQL Server, ASP.NET Core MVC, REST APIs, Entity Framework, SignalR, GraphQL, Transact-SQL (T-SQL), Database Development, C#.NET, Test-driven Development (TDD), Git, Jira, .NET, .NET Core, ASP.NET Core, LINQ, Entity Framework Core, SQL Stored Procedures, C#, Domain-driven Design (DDD), Cloud
Senior Software Engineer
2023 - 2025
Builder.ai
- Contributed to architectural decisions and fostered a collaborative environment while focusing on delivering scalable and maintainable C# solutions.
- Utilized best practices and code quality to enforce consistency, improving maintainability and reducing technical debt across the codebase.
- Resolved complex technical issues and performance bottlenecks, ensuring the stability and robustness of critical applications in a high-availability environment.
- Collaborated with cross-functional teams to design and deliver robust software solutions, ensuring alignment with business objectives and technical requirements.
Technologies: ASP.NET Core, C#.NET, Python, RabbitMQ, Docker, GitLab, Azure Storage
Project IT Developer
2016 - 2019
Oakam
- Migrated documents from SQL Server to Azure Blob storage and integrated with existing applications.
- Converted monolithic application logic into microservices with ASP.NET Core Web API.
- Migrated on-premise functionalities to Azure App Services.
- Delivered a solution to log each outbound communication to the customer (by email or text) and integrated it with all other existing applications with WCF service, Entity Framework, and SQL Server.
- Delivered API to evaluate customers’ applications with ASP.NET Core WebAPI and SQL Server.
- Delivered a compliance-related project to notify customers by various channels once they get a summary of borrowing with ASP.NET WebAPI, WCF, and SQL Server.
Technologies: Windows Communication Foundation (WCF), Git, REST APIs, Microsoft SQL Server, .NET, Transact-SQL (T-SQL), Database Development, C#.NET, VB.NET WinForms, Test-driven Development (TDD), Jira, .NET Core, ASP.NET Core, LINQ, WCF Web Services, Entity Framework, Entity Framework Core, SQL Stored Procedures, C#, Domain-driven Design (DDD), Kofax, Cloud, Serverless
IT Developer
2011 - 2016
Oakam
- Developed RESTful APIs for the company's mobile app by ASP.NET Web API and WCF.
- Converted legacy offer calculation engine from BI into a web-based simulation tool with ASP.NET, WCF service, and SQL Server, allowing financial data analysis.
- Developed a worklist tool for store users to reach potential customers with ASP.NET, WCF service, SQL Server, and Kofax-TotalAgility as a process engine.
- Integrated business processes into existing systems with the use of the Kofax-TotalAgility tool.
- Integrated policy-based configurable decision engine with WCF service and SQL Server to replace end-user manual decisions to reduce out-of-policy errors.
- Migrated legacy Excel-VBA financial calculation into reusable .NET SOA-based modules.
- Developed SOA-based reporting solution with WCF service and SSRS to generate loan statements delivered by post, email, and print.
- Streamlined the company’s financial lending systems by linking external providers (call credit) APIs into WCF services.
- Developed configurable product engine with WCF service and SQL Server to replace hardcoded logic into the client's application.
- Migrated legacy SharePoint-based inquiry booking system into ASP.NET, WCF services, SQL Server, and SSIS for data migration.
Technologies: LINQ, Entity Framework, ASP.NET, Microsoft SQL Server, Windows Communication Foundation (WCF), VB.NET, C#.NET, .NET, Transact-SQL (T-SQL), Database Development, ADO.NET, VB.NET WinForms, Test-driven Development (TDD), Git, Jira, Azure, Web Services, .NET Core, ASP.NET Core, REST APIs, WCF Web Services, Entity Framework Core, SQL Stored Procedures, C#, Domain-driven Design (DDD), Kofax
Technical Architect
2010 - 2011
RedZebra Software Ltd, Long Crendon, UK
- Reviewed and improved the company's Call2Field software architecture, such as removal of SQL injection, database design, use of stored procedures, and index.
- Improved the existing application's performance, stability, and reliability by using the latest technology like WCF.
- Developed new enhancements and improved existing Call2Field software, PDA, tablet, and GPS tracking system.
- Corrected existing loopholes, user interface, and coding style in the existing applications.
Technologies: Microsoft SQL Server, Web Services, Windows Communication Foundation (WCF), C#.NET, VB.NET, .NET, Transact-SQL (T-SQL), Database Development, ADO.NET, LINQ, WCF Web Services, SQL Stored Procedures, C#
Senior Developer
2009 - 2010
Hoerbiger India Pvt. Ltd., Pune, India
- Led the development of new products and was involved in all aspects of the software development lifecycle.
- Wrote detailed technical specifications from high-level business specifications.
- Drove continuous improvements to the team with particular emphasis on improving code quality, design, and testing.
- Managed the deployment, including trainer and production releases as per requirements, releases for the QA team, and maintenance of the database scripts on the central repository.
- Served as a single point of contact for the customer; participated in discussions with customers, estimated specifications, negotiated deadlines, and teleconferenced with customers weekly regarding the update and subsequent plan.
Technologies: Microsoft SQL Server, Web Services, C#.NET, VB.NET, .NET, Transact-SQL (T-SQL), Database Development, ADO.NET, VB.NET WinForms, LINQ, SQL Stored Procedures, C#
IT Project Lead
2008 - 2009
Hoerbiger Compression Technology Holding, Inc., Houston, USA.
- Supported the coordination, development, and deployment of applications in the North American region.
- Supported help desk, research, and software engineering development on new and existing projects.
- Provided project assistance with the supervision of outsourced systems developers and regional Hoerbiger employees.
- Maintained the quality of the code (.NET and database) by reviewing it for performance and efficiency.
Technologies: Microsoft SQL Server, Web Services, C#.NET, VB.NET, .NET, Transact-SQL (T-SQL), Database Development, ADO.NET, VB.NET WinForms, LINQ, SQL Stored Procedures, C#
Project Assistant
2006 - 2008
Hoerbiger India Manufacturing Exports, Pune, India.
- Contributed to software development and technical support including training of key users as necessary, systems administration, maintenance, and assistance of Hoerbiger projects internationally.
- Acted as the single point of contact for vendors developing the company’s products and participated in a teleconference with customers and vendors on the technical discussion for development.
- Designed the complex code implementation and complete development of the new modules.
Technologies: Microsoft SQL Server, Web Services, C#.NET, VB.NET, .NET, Transact-SQL (T-SQL), Database Development, ADO.NET, VB.NET WinForms, LINQ, SQL Stored Procedures, C#
Software Developer
2005 - 2006
InfoWorld Technologies, Pune, India.
- Participated in discussions with customers on requirements, estimation, and assistance in the negotiation of deadlines.
- Migrated applications into VB 6.0 with Oracle 8i into new systems in VB.Net with MS SQL Server 2000.
- Maintained existing code and written technical documentation as per migration.
Technologies: VB.NET, Transact-SQL (T-SQL), Database Development, ADO.NET, VB.NET WinForms, Web Services, .NET, LINQ, SQL Stored Procedures, C#
Experience
Compare Mortgages
An application that compares two mortgage products side by side for a given rate, fee, and duration. It will compare two mortgage products with the same duration but different rates and fees. It will also compare two mortgage products with different durations; they will have different rates and fees.
1. Mortgage type: Whether "interest-only" or "repayments."
2. Start date: Date when the mortgage was started or going to start.
3. Fee payment for each product, whether paying upfront or adding on balance.
4. Full repayment schedule for both products for the compared term.
It would also require internet on the device.
1. Mortgage type: Whether "interest-only" or "repayments."
2. Start date: Date when the mortgage was started or going to start.
3. Fee payment for each product, whether paying upfront or adding on balance.
4. Full repayment schedule for both products for the compared term.
It would also require internet on the device.
Mobile App for Coastal Properties
Built an iOS, Android, and web app in Flutter with Firebase and Neo4j Graph DB. It is similar to a social media and marketplace for renting and selling coastal properties and boats and organizing events.
Offer Calculator
While working at Oakam, I converted the BI legacy offer calculation engine into a web-based simulation tool with ASP.NET, WCF, and SQL Server, allowing financial data analysis with simulations and a rules version.
Education
2002 - 2005
Master's Degree in Computer Science
Veer Narmad South Gujarat University - Surat, Gujarat, India
1999 - 2002
Bachelor's Degree in Computer Science
Veer Narmad South Gujarat University - Surat, Gujarat, India
Certifications
MAY 2023 - PRESENT
Microsoft Certified: Azure Fundamentals
Microsoft
FEBRUARY 2017 - PRESENT
Exam 532: Developing Microsoft Azure Solutions
Microsoft
SEPTEMBER 2011 - PRESENT
Foundation Training of TotalAgility
Kofax Education
FEBRUARY 2006 - PRESENT
VB.NET Programming
SEED InfoTech, Pune, India
Skills
Libraries/APIs
Entity Framework, SignalR, REST APIs, LINQ, Stripe API
Tools
Git, Jira, Microsoft Visual Studio, RabbitMQ, Azure DevOps Services, GitLab
Languages
C#.NET, Transact-SQL (T-SQL), C#, VB.NET, Dart, GraphQL, ASP.NET Razor, Python
Frameworks
ASP.NET Core MVC, VB.NET WinForms, Entity Framework Core, ADO.NET, .NET, .NET Core, Flutter, ASP.NET Core, ASP.NET
Paradigms
Database Development, Test-driven Development (TDD)
Platforms
Azure, Azure Functions, Firebase, Apache Kafka, Docker
Storage
Microsoft SQL Server, Neo4j, SQL Stored Procedures, Elasticsearch, Azure Storage
Other
WCF Web Services, Cloud, Kofax, Domain-driven Design (DDD), Azure Service Bus, Serverless, Microsoft Azure, Windows Communication Foundation (WCF), Web Services, Software Development, Business Process Management (BPM)
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