Avanish Pandey

732-***-****

adg427@r.postjobfree.com

Summary

Over 19+ years’ experience in the Microsoft Technologies.

Primarily worked on Healthcare, Finance and Audit domain projects.

Currently working as an Onsite Team Lead for Bank of America which involved in developing/maintaining various applications on different technologies using Agile methodology.

Developed web-based applications using ASP.NET, VB.NET, C#.NET, ADO.NET, MVC, Web API, WCF, WPF, Kendo UI, Angular JS, Angular 2+, Typescript, LINQ, HTML5, Bootstrap, SQL SERVER 2016, T-SQL, SSIS, SSRS, PL-SQL XML.

Technical Skills

.Net Technologies: .Net 4.7, ASP.Net/MVC, ASMX, WCF, SSIS, SSRS, WinForms, LINQ

Web Technologies: HTML, CSS, SOAP, Ajax, Bootstrap, Angular 2+, Web API, typescript

Databases: SQL Server 2016/2012/2008//2005/ 2000 / 7.0, MS Access,

Languages: VB.Net, C#, ADO.Net, C, BASIC, COBOL SQL, T-SQL, PL-SQL

Markup: HTML5, XML

Development Tools: MS Visual Studio.Net 2017/2010/2008/2005/2003/6.0

Servers: Microsoft IIS 8.5/6.0/ 5.0

Reporting/Productivity Tools: Crystal Reports, MS Visio 2003, MS Project 2007, QlikView

OS: Windows 10/7, Win NT/2005, 95,98, XP, MS-DOS

Source Control: Team Foundation Server (TFS), visual source safe, SourceTree, Git

Experience

Sr. Software Dev (Mitchell Martin Inc.) July 2019- Currently Working

Client- Bank of America

As a Sr. Developer responsible for Managing, Analysis, design, development, testing and implementation of various projects with Bank of America.

Responsibilities:

Development of new functionalities on the ASP.NET MVC web applications C#, WebApi, Angular 5, Kendo UI

The project also entailed the design of a high performing service architecture for interacting with data using Web API’s

Technical code reviews, process improvements and suggest tools for efficient production support

As a full stack developer extensively used Angular with typescript, bootstrap, jQuery for UI development

Also responsible for development of SSIS packages and database objects like stored procedures, triggers, views etc.

Used multithreading, parameter inspectors, generics, ado.net, log4net, LINQ, jQuery and ASP.NET controls.

Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents.

Present and defend product designs and architecture to clients.

Coordinate and communicate tasks with developers.

Ensure that development is performed as per requirements.

Tracking status and managing WO in JIRA

Guide and share the knowledge with team members

Development in ASP.NET, MVC, Typescript, WCF, C#, VB, SQL SERVER 2012, SQL Reporting, GIT/Bitbucket, Kendo UI, AngularJS, Angular5, MVC, Bootstrap, LINQ, SSIS, SSRS

Main Projects:

RAILS web application:

Registration and Insurance Systems provides facility to initial, amended and renewal filing for insurance licenses and mortgage registration.

Responsibilities includes:

Participated in system specification meetings, analyzed user requirements, coordinated with coders and team members.

Followed Agile and Scrum Methodology.

Working with VS2017 .NET Framework 4.7, Angular 5 +Bootstrap, Angular JS, ASP.NET, VB.NET, C#.NET, WCF.

Developed a REST web API using C#.

Extensively working with User Interface using html5, CSS, Bootstrap, Java Script, jQuery, Json Data and Angular 5

Extensively Working with LINQ, entity framework and SQL Server 2012(Stored Procedures, triggers, tables, Views, etc.)

Wrote Stored Procedures, Functions, views and complex queries. Involved in optimizing stored procedures and queries for faster retrieval in SQL SERVER 2012.

Created SSIS packages to import NMLS, RRA and FRA data in SQL database .

Using Telerik kendo controls for UI.

Using Git/SourceTree for version control

Extensively using browser for checking developing pages for debugging the application(Google Chrome, IE)

Using Object oriented programming methodologies

Team Lead (Orion Systems Integrators, Inc.) Mar 2013- July 2019

Client- KPMG US

Responsibilities includes:

Developed multiple Single Page Applications (SPA) as responsive design with ASP.NET, MVC, jQuery, JavaScript, HTML5, CSS, C#, Web API, Multithreading, LINQ and SQL Server.

Developed latest module in Angular 2, MS Web API with good use of angular components, module, services, observable, directives, decorators, routes, pipes, AOT etc.

Developed multiple web API to provide data to the UI.

Played important role in designing the architecture of various projects.

Worked closely with BAs, management groups and other technical groups to manage and address any issue.

A detailed analysis of the system requirements carried out with the Agile methodology

Heavily used the multithreading using .NET Task Parallel Library for more scalability and controlled programming.

Post implementation support provided for all enhancement request. Resolving all business user queries and issues in minimal amount of time.

Main Projects:

CI Platform web application:

Providing facility to CI Team member to schedule/manage CI Workshop.

User can schedule, feedback and report on workshops.

Application has calendar tool to manage/view facilitators availability.

Worked with VS2017 .NET Framework 4.7, Angular 2 + Bootstrap.

Developed a web API using c#.

Extensively working with User Interface using CSS, Bootstrap, Java Script, jQuery, Json Data and Angular 2

Designed the SQL database and SSIS packages to import survey response from excel in to SQL database.

PMT web application:

Providing Project Management, budgeting, scheduling and tracking milestone over Audit engagements for KPMG Auditor and their clients.

PMT is a Web application developed in AngularJS, Typescript, C# using Web API and SQL Server 2012 as backend.

Used Telerik Kendo Grid and chart to show multiple trends for Budget, Actuals and resources.

PMT Reporting Tool

Providing Project Management reporting over Audit engagements for KPMG Auditor and their clients. PMT Reporting Tool is a Web application developed in ASP.NET MVC, AngularJS, Typescript, C# using Web API and SQL Server 2008 as backend. I have worked with Kendo Grid and charts to show multiple reports in tabular and graphical format.

Tech Lead (IBM Global Services) Jun 07 –Mar 2013

Client- Horizon BCBSNJ (Newark NJ)

As a tech lead responsible for Analysis, design, development, testing and implementation of various projects with Horizon BCBSNJ.

Worked with MOM application, which is a middle ware web service using C# and SQL Server 2005 as backend.

Worked with Horizon-TAG group and leading Microsoft area of this group, as an onsite lead.

Development in ASP.NET, MVC, SOAP services, WCF, C#, VB, SQL SERVER 2012, SQL Reporting, TFS, Kendo UI, SSIS, SSRS

Created multiple SSIS packages and jobs to import Rx, Medicare data in SQL database.

MEDICATION THERAPY MANAGEMENT:

Horizon Medication Therapy Management System is an application implemented as a part of CMS Mandate for the new prescription drug benefit under the Medicare program. The system is designed to make the detailed Rx Claim, Medical and Lab Information available to in house Pharmacists and physicians via a web interface. It’s a ASP.NET MVC web application having SQL server 2005 as backend and jQuery for client-side script. Created a few reports using MS-reporting. Created multiple SQL jobs using SSIS package to import Rx, Eligibility, Medicare data in SQL server database.

Enhanced Eligibility 4- IVR:

Project Description: This was the project that I handled from client location (Newark, USA). I was the Tech lead for this project. I gathered information, did analysis, write TRD, interact with clients and other teams, describe the requirement to offshore team, reviewed the deliverables. It’s an Asp.NET Web service handing request from different client and providing response using SQL Server 2005 database.

MOM Benefit Details

Project Description: It was a web application in ASP.NET with SQL Reporting, I got appreciations from BAM, AM, DM, SME for my contributions for this project.

Kalpataru Computers, India Nov 2000 – Jun 2007

Sr S/w Dev

Kalpataru computers is based in Indore – India and providing quality & satisfactory services in-liaison with various companies in London – UK, Tokyo - Japan and Seattle - USA.

Advisory board of directors includes people from Microsoft Corporation.

Project Name: Taxi logic Web application for dispatching & Reporting orders.

Description: Voxpoint, company of Finland, provides taxi dispatching S/w (For more info about company visit www.voxpoint.com). This project is a web application for dispatching & Reporting order. Which can be fully configured by Admin. It has Modules tabs structure which can add/ edit by admin. There is also different role can have different permissions on every module/tab. User/admin can add/delete/view different module Also we have implemented the localization feature in it, right now the application can run in English and finish locale. This project is in development stage, all the database interaction is through web services Web application + services are designed in c#.

Project Name: Voxpoint TaxiLogic Message/order processor service.

Description: Voxpoint, company of Finland, provides taxi dispatching S/w (For more info about company visit www.voxpoint.com). We have made multithreaded 5 Windows services which provide order/message processing with PDA. It uses the GPS for taxi and order positioning. The client place order to operators, operators place order to closest taxi through PDA. Taxi can accept, reject and process the order. The project is successfully running in Finland. Also I was worked for desktop VB 6.0 order submission application of Voxpoint.

This service is designed in VB.NET. Design all the database tables, Stored Procedures, Views (which takes data from different linked SQL Servers), functions, triggers in SQL SERVER 2000.

Education

Master of Computer Application (MCA), Devi Ahilya University, Indore, MP

Bachelor of Science in Comp Sc. Hons, Devi Ahilya University, Indore, MP

Certifications

Project Management Professional (PMP)

Microsoft Certified: Azure Fundamental

Six Sigma White Belt

QlikView Developer/Designer Certification

Contact this candidate