Sunil Pancholi (Lead .Net Full Stack Developer)

Cell Number: +1-404-***-****

Email: - adnbiv@r.postjobfree.com

Summary:

● Senior Developer (Lead Full Stack Developer) with close to 13 years of design and development in UI and Web platform using windows forms, .net Core 2.x, ASP.net, Angular 2 /4/ 6/8/9, Web API, Web Service, WCF, PHP, Entity Framework,C#,vb.net, bootstrap, HTML 5, CSS, Fiddler, AZURE, Dev Express Tools,Design patterns,including Object Oriented design, profiling, and fine tuning .net applications, Design Principles, Microservices.

●12+ years ‘experience in ASP.net, windows forms in domains of- Media, School Management, Financial Advisory (Tax), Hospitality Management, Supply Chain Management

●8+ years knowledge and experience in Relational Databases, DB Design, Normalization, ER Diagrams, SQL server (2000,2005, 2008).

●Worked Projects on ASP.NET, ASP.NET MVC, ASP.NET Web API, C#, Angular8+,AngularJS 1.6,,AngularJS 1.4, HTML5, XML, JavaScript, Ajax, TypeScript.

●Versatile experience in working on .Net Technology, Programming Language, Operating System, Database, and various other tools

●Skillful in Software Development Life Cycle

●Expertise in scheduling and meeting deadlines for deliverables while achieving excellence in quality of work

●Ability to apply advanced principles, theories, and concepts, and contributes to the development of innovative principles and ideas

●Have 2 years of Onsite work experience in USA & 6 months working in UK.

●Hands on Experience on Working on Project in Angular 2/4/6/8 Technology.

●In depth design analysis including design impact, fault and exception handling, UI component layout and structure, UI, and services integration specification

●Integrated application with multiple vendor systems working through API details workflow definitions, XML data specification.

●Create database design of tables, create stored procedures, identify indexes, simplify and tune table joins in database components of application

●Create entity/model creation using ADO.Net

●Development of applications in Microsoft technologies - C#, .net, Windows forms and Asp.net

●Development of UI components using JavaScript frameworks and AngularJS

●Hands on experience on multi-threaded components applied to Caching refill, File Watcher Processors.

●Extensive development experience using Agile/Iterative methodologies

Technical Summary

Framework

Microsoft .Net framework 1.1/2.0/3.5, 4.0,4.6

Web Services, WCF, WSDL2.0, SOAP2.0, Entity Framework, AZURE

Languages

C#, JavaScript, HTML, XHTML, LINQ, XML

JavaScript frameworks

Angular 2/4/6/8, Bootstrap, jQuery, Prime NG, Angular Material

Web Layer Framework

.net Core,ASP.net, AJAX, MVC 4,5, MVVM, REST services, Web API, WCF, Web Service, SSIS, SSRS,Javascript, Entity framework,JQUERY,HTML5,css

Testing & Deployment

IIS 6.0

Database

SQL Server 2000/2005/2008, Oracle

Operating Systems

Windows server 2003/2008 Windows (XP, Win 7)

Development Env.

Visual Studio 2003/2005/2008/2010,2013,2017, core

Source Control

Microsoft VS TFS 2005/2008, GitHub,AZURE Devops

Education

Bachelor’s in engineering (Information Technology), from Nirmal Institute of Technology, India - 2007

Projects:

Company : TRUCK PRO(EDI Project) Project: DANA EDI

Role: .Net Full Stack Developer

Period: April 2021 – June 2021

Location: Memphis,TN. USA

Truck Prop is Providing various parts of truck to all over USA. They have One Consignment partner DANA for which

We need to Process the EDI Document like 850 or 856 and send them back and we call also generate EDI Document from screen as well(856 and 861)

Function & Responsibilities:

●Create Web API and UI in Angular

●CI/CD Pipeline

●Designing algorithms and flowcharts to create new software programs and systems

●Producing efficient and elegant code based on requirements

●Testing and deploying programs and applications

●Troubleshooting, debugging, maintaining and improving existing software

●Compiling and assessing user feedback to improve software performance

●Observing user feedback to recommend improvements to existing software products

●Developing technical documentation to guide future software development projects

Technologies: Angular 10,C#, .NET core 2.X,Entity Framework,Web API, Web API, Microservices LINQ and Entity Framework, HTML5/CSS, OOD & Design Patterns,Mongo DB, SQL Server, JavaScript, AZURE Devops.

Company : LEX TECHNOLOGY(Client Lab express) Project: LEADS

Role: .Net Full Stack Developer

Period: JULY 2020 – March 2021

Location: Memphis,TN. USA

Lab express is a specialized App based logistics service structured specifically for the Laboratory/Medical Industry. We realize efficiently capturing pertinent data and transporting medical related materials from both internal and external origins and destinations is necessary for you to compete today.

Function & Responsibilities:

●Create Web API and UI in Angular

●CI/CD Pipeline

●Optimize the Stored Procedure

●Designed and developed Modules using Angular 8, .net core, C#, Web API, AZURE

●Developed user interface using Angular Material.

●Collaborating with management, departments and customers to identify end-user requirements and specifications

●Designing algorithms and flowcharts to create new software programs and systems

●Producing efficient and elegant code based on requirements

●Testing and deploying programs and applications

●Troubleshooting, debugging, maintaining and improving existing software

●Compiling and assessing user feedback to improve software performance

●Observing user feedback to recommend improvements to existing software products

●Developing technical documentation to guide future software development projects

Technologies: Angular 8,C#, ASP.NET 4.5, .NET core 2.X, MVC and Entity Framework,MVC,jQuery Web API, Web services, LINQ and Entity Framework, HTML5/CSS, OOD & Design Patterns, Windows services, Unit Testing Frameworks, SQL Server, JavaScript, JQuery, & Bootstrap, SQL DB

Client: International Paper, USA Project: Omega

Role: .Net Full Stack Developer

Period: Aug 2019 – June 2020

Location: Memphis,TN, USA

International paper is one of the World’s largest pulp and Paper Company. Omega is their Distributed Web based Product which can be used by All Mills which Produces paper/pulp and keep tracking of staring from manufacturing to Deliver to the Customer of the Product.

I was part of the Omega Deliver Team which was part of this Supply Chain Management and is responsible for the Delivery of the Shipment and various Business Rules.

Function & Responsibilities:

●Create Web API

●Designed and developed Modules using .net core, C#, Web API, and Angular 8 (CLI), Micro Service, Docker, SignalR, RabbitMQ, SQL/Oracle, AZURE

●Developed user interface using Angular Material.

●Designed and developed Stored procedures, Table, and database objects in Oracle database

●Performance tuned the stored procs for faster retrieval, and code performance improvements.

●Provide Quick Fix to the technical issues raised by QA Team and.

●Handled customer issues and Provide Technically Solution.

●Devops Implementation.

●Executed whole Project in Agile Methodology.

●Tested Web API through Fiddler.

●Implemented Design pattern.

●Estimation of the Work.

Technologies: Angular 8,C#, ASP.NET 4.5, .NET core 2.X, MVC and Entity Framework,MVC,jQuery Web API, Web services, LINQ and Entity Framework, SQL Server, JavaScript, JQuery, & Bootstrap, SQL DB

Client: Deloitte, UK Project: Taxe (Voyager)

Role: .Net Technical Lead

Period: May 2018 – June 2019

Location: Mumbai, India

Taxe is Web Application in which We Made Module called SRT which will determine weather

Individual was in UK or not based on the UK Government Laws and we need to show then Dynamic Generated Flowchart.

Voyager Phase Two has the go ahead and one its deliverables is the migration of the Excel-based SRT Tool to a Web-based screen accessed via Taxe. I worked for the automation of SRT Tool.

Function & Responsibilities:

●Designed and Developed all Modules using .net CORE, C#, Web API, and Angular 6 (CLI), AZURE

●Developed user interface using prime NG third party UI Tool.

●Designed and developed Stored procedures, Table, and database objects in SQL database

●Designed and Develop SSIS package that will Import Data from Source to SQL Database.

●Performance tuned the stored procs for faster retrieval, and code performance improvements.

●Provide Quick Fix to the technical issues raised by QA Team and.

●Handled customer issues and Provide Technically Solution.

●Executed whole Project in Agile Methodology

●Created SQL Server Agent Job to call SSIS package

●Tested Web API through Fiddler.

●Implemented Design pattern like abstract Factory, Singleton for Logging of the events

Technologies: Angular 2/4, Prime NG, Entity Framework, Windows Workflow Foundation, SSIS, Open Source libraries like: angular-calendar, dagre-d3, workflow-core, TFS (Team Foundation Server), Mock FrameWork

Employer Capgemini (May 2011 to Jan 2018)

Client: Schlumberger Project: Oil Drilling (QUEST Application)

Role: Senior .Net Developer

Period: September 2016 –February 2018

Location : Mumbai, India

Quest is an Application which will handle all the incidents occur at one of the big Oil Drilling Company and also manage the various Reports.

Function & Responsibilities:

●Created Architecture for this Project in using Various Design patterns.

●Developed product features through full SDLC using .net

●Created Admin Module for Quest in Angular 2 with Web API

●Create database objects and indexes for storing rate commission data in SQL

●Perform Route Cause Analysis in ASP.net and C# to resolve the issues.

●Worked in Agile Methodology

●Created Web API to fetch the Details from the Database.

●Check-in/ Check Out Branching and merging in TFS

●Used JavaScript for various Client-Side Validations.

●Hosted Website into IIS.

Technologies:SQL server, MVC, asp.net, SSIS, java Script, Angular 2, Web API, TFS, Angular 2/4

Client: Store feeder Project: Store Feeder Click and Drop Project

Role: Lead .Net Developer (UK Onsite)

Period: February 2016 – Jul 2016

Location: Nottingham, UK

Simplify your multi-channel retailing by utilizing Store Feeder the most effective way of managing your ecommerce operations. With integrations to all major sales channels, you’ll be collating all orders into one place and managing your inventory across your chosen channels.

Function & Responsibilities:

●Gathered requirements for subsystems, designed, made plans work and led team members during development

●Performed data base profiling in SQL server 2000/2005/2008 to reduce tune database calls from the UI

●Tuned stored procedure and table access in queries for faster stored proc execution

●Developed GUI Store feeder Application using bootstrap.

●Implemented mail tracking System in Angular JS and created Web API for various Operations.

●Used HTML 5 in this Project.

●Created Stored Procedure, SQL Functions, triggers and SQL Jobs.

Technologies: Angular 2, MVC, Asp.net, WCF, C#, SQL Server, HTML, Mock Framework

, CSS, JavaScript.

Client: Univision (Doral, Miami) Project: Title Registry

Role: Senior Software Engineer (Onsite in USA for 14 months)

Period: Nov 2014 – January 2016

Location: Miami, Florida (11 Months)

Adding Metadata to the Title Registry Application and to make sure that those all the Metadata are flowing to the all the down system correctly for any Series/Movie/Novella etc.

Function & Responsibilities:

●Designed and Implemented Title Registry Application in MVC and SQL

●Designed and Developed the implementation of the UI in ASP.NET

●Created SSIS package for migrating Data from Excel to SQL.

●Implemented SSRS Reporting for this Project.

●Used Various oops Concepts and Design patterns.

Technologies:

Microsoft.net Framework 2.0, Asp.net, MVC, WCF, C#, SQL Server, HTML, CSS, JavaScript, SSIS, SSRS, TFS.

Client: New market international Project: Hospitality Information System (HIS)

Role: Software Engineer (Onsite in USA for 2 Months)

Period: April 2013 - October 2014

Location: Portsmouth, NH (for 2 Months)

This Project was mainly for Management of Hospitality of USA and various Data gathering System.

Function & Responsibilities:

●Designed and Developed business components in C# and asp.net.

●Developed the implementation of the UI in ASP.NET

●Developed the logging HIS in C#

●Created Database Diagram and writing Stored Procedure to Implement some Module Level Functionality.

●Used HTML and CSS for UI Design and JavaScript for UI Validation.

Technologies: Asp.net, WCF, C#, SQL Server, HTML, CSS, JavaScript, PHP, SSIS

Client: Serco Project: School Management System

Role: Software Engineer

Period: May 2011 – March 2013

Location: Gandhinagar, India

It was the third-party integration service for our client SERCO for Making various function using WCF services. I have Created various custom Services which are invoked as per Requirement to get the Required Results

Function & Responsibilities:

●Designed and Developed business components in C#

●Developed the implementation of the UI in ASP.NET

●Created Database First Entity Framework for getting Data into the System

●Created WCF for Fetching Data.

Technologies: Microsoft .Net framework 1.1/2.0, Asp.net, WCF, C#, SQL Server, HTML, CSS, JavaScript

Client: www.Fibre2Fashion.com Project: Business to Business(B2B) Portal

Role: Software Engineer

Period: March 2007 – May 2011

Location: Ahmedabad, India

www.Fibre2Fashion.com

http://news.fibre2fashion.com/

http://jobs.fibre2fashion.com

http://www.technicaltextile.net

This Website was mainly used for doing the B2B business for Garment Industries.

Here user can See the various products and can Buy or Sell from all over the World through this Website. It also Contains the Admin Module

Function & Responsibilities:

●Designed and Developed business components in C#

●Developed the implementation of the UI in ASP.NET

Technologies: Microsoft .Net framework 1.1/2.0, Asp.net, C#, SQL Server, AJAX, Web Service, HTML, CSS, JavaScript

Contact this candidate