CHANDAN KUMAR

Sr.Technical Lead/ Full Stack Developer/ Business Analyst / Selenium Automation Tester

Email: adwt60@r.postjobfree.com / Mob: +1-202-***-****

[Work Authorization: Have approved i140]

PROFESSIONAL SUMMARY

I am a full stack Developer, Business Analyst, Selenium Automation Tester and an accomplished Technical Lead with experience in all areas of Software Development Life cycle.

I am equally comfortable with backend development using C#, Cloud services and integrations along with front end development, testing and deployment.

I have about 15 years of professional experience in designing, architecting, maintaining enterprise applications including front end (web and desktop) applications, integration services, Rest services, Web APIs, WCF Services and databases.

I am adept in all Microsoft Development tools and technologies like Visual Studio, MVC, WinForms, Web Forms, WPF, Entity framework etc.

Over the years I have gained expertise in many programming languages including ASP.NET CORE, C#, VB.NET, Visual C++, Python and others

Extensive experience in testing both manual as well as automation using Selenium.

I am Proficient and have worked in all .NET frameworks to date. NET CORE 1.1, .NET CORE 2, .NET CORE 3.1. & .NET CORE 7.0.

One the front end I am proficient in many JavaScript libraries, Style languages, Package managers, front end frameworks and tools including (but not limited to) jQuery, Bootstrap, CSS, etc.

I have a strong theoretical understanding backed with years of lab experience of Software design patterns

I am experienced and formally trained in the use of agile development methodologies, including Scrum, Test-Driven Development (TDD) and Extreme programming

Experienced in leading peer code reviews, virtual teams and implementing best practices and following coding standards and documentation

I love building productive teams and mentoring developers in my team. I focus on timely delivery and am acquainted with all project management techniques include agile/scrum, waterfall, and others

I am driven by my passion for architecting and developing elegant and highly usable software services and applications and over the years I have gained expertise and both software design patterns and architectural patterns including the latest trends like Micros Services.

I have hands on experience in working with different with different cloud technologies and cloud vendors including Microsoft Azure, Google Cloud services, AWS and others.

Hands on experience in developing Service Oriented Architecture (SOA) Windows Communication Foundation (WCF), XML Web Services and Window Services.

Extensively worked on creating database, tables, complex Stored Procedures and Triggers using SQL, PL/SQL with MS SQL Server and Oracle databases

Experienced in analysis and design of databases. Good working knowledge of Normalization, T-SQL, Stored Procedures, Rules, Views and Indexes

Extensively worked in writing SQL queries, stored procedures, database triggers, cursors, exception handlers, DTS, SSIS Export & Import and Experience with fine-tuning and optimizing Queries, Stored Procedures and functions

Design documentation, Report and Version control in common repository using Team Foundation Server (TFS), Visual Source Safe (VSS), SVN and Git

I have years of practical experience in all software development life cycle (SDLC) process: Feasibility, Design, Analysis, Coding, Testing, Deployment, Maintenance and End User Training

I am proficient in analyzing, designing and adopting innovative techniques. Works well with customers to determine requirements and application scope

I have strong programming, analytical and communication skills with the ability to work quickly on time sensitive projects

I am a Good Team player with good interpersonal and problem-solving skills and ability to adapt to new environment and learn new tools

Rewarded multiple times on-spot award by the organization management for excellent work.

Experience on reporting software - Crystal Reports & SSRS.

EDUCATION

Master In Business Administration (MBA) - 2022

Master of Computer Applications (MCA) - 2010

TRAINING & CERTIFICATION

Architecting on AWS (Amazon Web Services)

Certificate in J2ee

PROFESSIONAL EXPERIENCE

HHA EXCHANGE WFH, Offshore, India

Lead Full Stack Software Developer/ Automation Tester / Sr.Technical Lead Aug 2022 – Current

HHAeXchange is the only homecare management software that seamlessly connects providers, state Medicaid programs, managed care organizations (MCOs), and caregivers through one platform. This connection breaks down barriers and enables unparalleled efficiency, communication, transparency, and compliance.

Responsibilities:

Gather and analyze user requirements, design and develop new software using software tools/technologies, modify and test commercial client server applications, evaluate existing and emerging software, full life cycle development to perform sophisticated software engineering jobs.

Involve in creating Wireframes, Data models, Technical designs/ specifications, Future process flow diagrams, Use case scenarios.

Work with enterprise/system architects for implementing new enterprise processes, architectural guidelines and standards.

Work as part of Scrum team and participate in all Scrum team activities.

Produce handover documentation (as needed for functionality/feature change).

Provide ongoing support for system modification, maintenance, optimization, and prepare documentation.

Participate in system & database design meetings.

Consult with engineering staff to evaluate interface between hardware and software, develop specifications and performance requirements, or resolve customer problems.

Involve in developing cutting-edge solutions to maximize the performance, scalability, and distributed processing capabilities of the system.

Involve in preparing reports or correspondence concerning project specifications, activities/status.

Confer with data processing/project managers to obtain information on limitations or capabilities or data processing projects.

Undertake storing, retrieving, and manipulating data for analysis of systems capabilities and requirements.

Participate in setting operational specifications and formulating and analyzing software requirements.

Assist in designing embedded systems software.

Involve in creating tools to automate the deployment of an enterprise software solution to the cloud.

Perform testing and validation of software systems to ensure that applications work properly and involve in designing and analyzing databases for the applications

Tools & Technology Stack

Software Design/Architecture: Software Design Patterns, SOA

Microsoft: .Net Core 7.0 MVC, .NET 4/5

IDEs: Visual Studio 2019, Visual Studio 2022

Languages: C# (ASP.NET CORE 7.0), JavaScript, PLSQL

Version Control System: GITHUB, BITBUCKET

OS: Windows

Testing: Selenium

Database: SQL Server

FORD MOTORS COMPANY Dearborn, MI, USA

Lead Full Stack Software Developer/ Automation Tester /Technical Lead May 2020 – July 2022

Component Data Collection (CDCII) is suite of applications that helps to collect all components data using the barcode scan or manual data entry and map it to the VIN number of the vehicle and this information is saved for future reference or recall purpose.

Responsibilities:

Gather and analyze user requirements, design and develop new software using software tools/technologies, modify and test commercial client server applications, evaluate existing and emerging software, full life cycle development to perform sophisticated software engineering jobs.

Involve in creating Wireframes, Data models, Technical designs/ specifications, Future process flow diagrams, Use case scenarios.

Work with enterprise/system architects for implementing new enterprise processes, architectural guidelines and standards.

Work as part of Scrum team and participate in all Scrum team activities.

Update hard-coded variables to use new server information.

Produce handover documentation (as needed for functionality/feature change).

Provide ongoing support for system modification, maintenance, optimization, and prepare documentation.

Participate in system & database design meetings.

Consult with engineering staff to evaluate interface between hardware and software, develop specifications and performance requirements, or resolve customer problems.

Involve in developing cutting-edge solutions to maximize the performance, scalability, and distributed processing capabilities of the system.

Involve in preparing reports or correspondence concerning project specifications, activities/status.

Confer with data processing/project managers to obtain information on limitations or capabilities or data processing projects.

Undertake storing, retrieving, and manipulating data for analysis of systems capabilities and requirements.

Participate in setting operational specifications and formulating and analyzing software requirements.

Assist in designing embedded systems software.

Involve in creating tools to automate the deployment of an enterprise software solution to the cloud.

Perform testing and validation of software systems to ensure that applications work properly and involve in designing and analyzing databases for the applications

Tools & Technology Stack

Software Design/Architecture: Software Design Patterns, SOA

Microsoft: .Net Core 5.1 MVC, .NET 4/5

IDEs: Visual Studio 2017, Visual Studio 2019, Visual Studio 2022

Languages: C# (ASP.NET CORE 3.1), JavaScript, PLSQL

Version Control System: GITHUB

OS: Windows

Testing: Selenium

Database: SQL Server & Oracle

OTAVA Ann Arbor, MI, USA

Lead Full Stack Software Developer Nov 2019– Apr 2020

OTAVA is a global leader of secure, compliant hybrid cloud and IT solutions for service providers, channel partners and enterprise clients. The company’s tagline, ‘Expect Exceptional’ reflects Otava’s mission to deliver clients and partners an experience that truly rises above all others. Their network of 12 data centers and cloud nodes protect mission critical applications to ensure they are always available, secure and comply with government and industry regulations. Backed by independent HIPAA, PCI, SOC 2, ISO 27001 and Privacy Shield audits, Otava delivers exceptional experiences for companies in need of a strategic IT partner.

Responsibilities:

Gather and analyze user requirements, design and develop new software using software tools/technologies, modify and test commercial client server applications, evaluate existing and emerging software, full life cycle development to perform sophisticated software engineering jobs.

Writing Web APIs to collect user’s data by secure RESTful APIs calls

Involve in creating Wireframes, Data models, Technical designs/ specifications, Future process flow diagrams, Use case scenarios.

Work with enterprise/system architects for implementing new enterprise processes, architectural guidelines and standards.

Work as part of Scrum team and participate in all Scrum team activities.

Update hard-coded variables to use new server information.

Produce handover documentation (as needed for functionality/feature change).

Provide ongoing support for system modification, maintenance, optimization, and prepare documentation.

Participate in system & database design meetings.

Consult with engineering staff to evaluate interface between hardware and software, develop specifications and performance requirements, or resolve customer problems.

Involve in developing cutting-edge solutions to maximize the performance, scalability, and distributed processing capabilities of the system.

Involve in preparing reports or correspondence concerning project specifications, activities/status.

Confer with data processing/project managers to obtain information on limitations or capabilities or data processing projects.

Undertake storing, retrieving, and manipulating data for analysis of systems capabilities and requirements.

Participate in setting operational specifications and formulating and analyzing software requirements.

Assist in designing embedded systems software.

Involve in creating tools to automate the deployment of an enterprise software solution to the cloud.

Perform testing and validation of software systems to ensure that applications work properly and involve in designing and analyzing databases for the applications

Tools & Technology Stack

Software Design/Architecture: Software Design Patterns, SOA

Microsoft: Web API, .Net Core 3.1, .NET 4/5

IDEs: Visual Studio 2019, VS Code

Languages: C#, JavaScript, PLSQL, Python

Version Control System: GITLAB

DevOps: PowerShell

OS: Windows, LINUX

Unit testing: XUnit, NUnit

Database: SQL Server

Chemical Bank Troy, MI, USA

Technical Consultant June 2019–Oct 2019

Chemical Bank announced an agreement to merge with TCF Financial Corporation, a well-capitalized bank holding company based in Wayzata, MN. TCF currently operates 315 bank branches throughout the Midwest. Like Chemical, TCF has a strong track record of community banking and is committed to supporting the neighbourhoods they serve.

Responsibilities:

Business analysis, working with clients to understand/define systems and interfaces.

Writing Queries, Building Interfaces, Data Manipulation.

Anticipating, identifying, tracking and resolving issues and risks affecting interface connections.

Developing system specifications and interfaces for complex components, develop them, and get it

delivered as per plan.

Work with Architects, other Technical Leads, Team members, Business owner and business Analyst

to gather requirements and convert them into design specifications, coding and then testing.

Building queries using C#, .Net, SQL and SSIS for the purpose of data manipulation.

Providing primary support toward installation of application releases into production as directed by

stakeholders.

Monitoring service commitments for assigned deliverable and proactively provide work status.

Troubleshooting, supporting in-house .NET batch interfaces and related files/transmissions.

Interacting with members of business group and other developers and work as a team or

individually.

Tools & Technology Stack

Software Design/Architecture: Software Design Patterns

Microsoft: .Net Framework 4.6.2

IDEs: Visual Studio 2019

Languages: C#, JavaScript

Version Control System: GIT

Project Management:

SDLC: Scrum

DevOps: NuGet

Database: SQL Server

Tools: WinSCP

OS: Windows

New Hampshire State, Department of Vital Records, NH Rockville, MD, USA

Technical Lead March 2015 - May 2019

Project #1 NHVRINplus - New Hampshire Vital Records Information Network (NHVRIN) is a web-based vital records registration and issuance application that is used by the DVRA, town clerks, hospital birth clerks and funeral directors to capture and manage vital records data (Birth, Marriage, Death, Fetal Death, Divorce, CU & Dissolution) within a centralized database. And NHVRINplus is a rewrite project to mimic the entire functioning on NHVRIN system with some business logic tweaks using latest technology stack.

Responsibilities:

Requirement Analysis, Design, Implementation, Testing, Deployment and Documentation.

Interacting with Client Business leads for better understanding of the requirement.

Impact analysis of the new requirement or change request on the existing programs initiated by the client.

Designing New Components using HTML, Bootstrap, AJAX, ASP.Net.Core with MVC framework, WebApi, LINQ, Entity Framework.

Involved in migrating the old Oracle objects to SQL Server and data involved.

Involved in changing the Crystal Reports to SSRS.

Identify and verify the impact based on the changes in downstream/upstream applications.

Prepare and review the Detailed design specification document

Coordinating the onsite & offshore activities and providing them guidance on day to day activities.

Performing Unit Testing, Integration Testing & Regression Testing.

Real time bug fix support during acceptance and end-to-end testing.

Generating metrics on the performance of the system.

Participating in Internal Audits and External Reviews.

Involved in the implementation of these changes in production by packaging the application etc.

SVN maintenance on regular basis.

Tools & Technology Stack

Software Design/Architecture: Software Design Patterns, Microservices, N-tier

Microsoft: NET 2,3.5, 4.0, Entity framework, LINQ, ASP.NET Web Forms, ASP.NET MVC, WPF, XAML, Win forms, WCF, ASP.net Web API

IDEs: Visual Studio 2017

Front End/JavaScript: HTML, JavaScript, jQuery, Bootstrap, Angular

Languages: C#, SQL, JavaScript

Version Control System: SVN

Project Management: JIRA

SDLC: Scrum

DevOps: PowerShell, IIS

OS: Windows

Databases: Microsoft SQL server

Unit testing: N Unit

Open Source: Many open source libraries including log4net, JSON.net and others

Project #2 NeCOD (National Electronic Cause of Death) is a mobile application developed to work on both iOS and Android, to improve the timely approval of “cause of death” by New Hampshire Doctors/Corners &/or Certifying Nurses. It is designed in such a way; it works both in offline/online mode to facilitate users to log the cause of death / pronounce death without having internet connection.

Responsibilities:

Requirement Analysis, Design, Implementation, Testing, Deployment and Documentation.

Interacting with Client Business leads for better understanding of the requirement.

Impact analysis of the new requirement or change request on the existing programs initiated by the client.

Designing New Components using HTML, AJAX & WCF web services.

Identify and verify the impact based on the changes in downstream/upstream applications.

Prepare and review the Detailed design specification document

Coordinating the onsite/offshore activities and providing them guidance on day to day activities.

Performing Unit Testing, Integration Testing & Regression Testing.

Real time bug fix support during acceptance and end-to-end testing.

Generating metrics on the performance of the system.

Participating in Internal Audits and External Reviews.

Involved in the implementation of these changes in production by packaging the application etc.

SVN maintenance on regular basis.

Tools & Technology Stack

Software Design/Architecture: Software Design Patterns, Microservices, N-tier

Microsoft: NET 2,3.5, 4.0, WCF API

IDEs: Visual Studio 2015

Front End/JavaScript: HTML, JavaScript, jQuery, AJAX

Languages: C#, SQL, JavaScript

Version Control System: SVN

Project Management: JIRA

SDLC: Scrum

DevOps: IIS

OS: Windows

Databases: Microsoft SQL server, Oracle

Open Source: Many open source libraries including log4net, JSON.net and others

Project # 3 :

New Hampshire Vital Records Information Network (NHVRIN) is a web-based vital records registration and issuance application that is used by the DVRA, town clerks, hospital birth clerks and funeral directors to capture and manage vital records data (Birth, Marriage, Death, Fetal Death, Divorce, CU & Dissolution) within a centralized database.

Responsibilities:

Requirement Analysis, Design, Implementation, Testing, Deployment and Documentation.

Interacting with Client Business leads for better understanding of the requirement.

Impact analysis of the new requirement or change request on the existing programs initiated by the client.

Designing New Components using ASP.Net (vb.net), C#.

Identify and verify the impact based on the changes in downstream/upstream applications.

Prepare and review the Detailed design specification document

Coordinating the onsite/offshore activities and providing them guidance on day to day activities.

Performing Unit Testing, Integration Testing & Regression Testing.

Real time bug fix support during acceptance and end-to-end testing.

Generating metrics on the performance of the system.

Participating in Internal Audits and External Reviews.

Involved in the implementation of these changes in production by packaging the application etc.

SVN maintenance on regular basis

Tools & Technology Stack

Software Design/Architecture: Software Design Patterns, Microservices, N-tier

Microsoft: NET 2,3.5, 4.0

IDEs: Visual Studio 2015

Front End/JavaScript: HTML, JavaScript, jQuery, AJAX

Languages: VB.Net, SQL, JavaScript

Version Control System: SVN

Project Management: JIRA

SDLC: Scrum

DevOps: IIS

OS: Windows

Databases: Oracle

AARP (American Association Of Retired Persons) Rockville, MD, USA

Project Lead Nov 2013 - Feb 2015

Project # 1: Morris Case Management System is a legal case management system customized to the needs and workflow of AARP’s Legal Counsel for the Elderly (LCE). More than 50yrs age people from DC are the users for this application. If users have any issue, they will raise the problem in AARP Morris CMS (LCE). Then User Information is sent to the Lawyer in document format. Lawyer will interact with the user for further detail information and work on the case resolution.

Project # 2:CPTS Stands for Campaign Performance Tracking System. As the name suggests it’s a system to track the campaign’s performance – how’s the campaign doing, cost involved etc. It’s a web application to view the data been given by the campaign managers / group of people. There are two channels for CPTS namely: 1) Alt.Media 2)Direct mail

Project # 3: Catering Request Application is a custom-built .Net application. AARP employee can order food for the participant in the meeting through Catering Request application based on the approval of their manager. Users can choose the level of service per need (Cart Service / Full Service). Cart Service: With cart service the requester picks up the food and beverage in the café. The fully prepared cart will contain everything needed to set up food service for the meeting or event. The requester will be responsible for clean-up and return of the cart and other equipment upon completion of the event. Full Service: Full-Service catering will also be available but the cost for delivery, set-up, breakdown, rental items and service will be added and charged to the requesting business unit. Please allow extra time when requesting full-service catering as the café staff may need to decide for additional serving resources.

Project # 4:Event Sign up Application is a custom-built .Net application. AARP users can create a new event and want to invite all AARP / select any AARP users through Event Sign up application (or) they can also join as participate in existing events. Event Sign up Functionality: General - Able to see list of events, able to create new events. Access Control - Used to select list of people, max of people, date & time. Location Times - Used to add the region of people & time. Registration Option - Used for registration purpose. Confirmation - Used for final confirmation on the events. & send the email to those selected lists of people.

Project # 5: Federal Affairs lobbying is an intranet-based web application used for filing the federal / state lobbying data and has workflow mechanism for approval / rejection of the filing by the Admin (for LD-2/LD-203) /State director (only for State filing). There is FDC & Individual state filing done using this application. There are 3 categories of filing: - 1) LD2 2) LD203 3) State Activity. There are 5 statuses of the filings: - 1) Draft 2) Submitted 3) Director Submitted 4) Approved 5) Rejected. Below is the list of users using this application: - 1) Normal Users 2) Administrator 3) State Director 4) OGC

Project # 6:FLDB (foreign language database) is a custom ASP.Net application to list the AARP employees with foreign language skills/expertise. Only full-time employees are allowed to update the language skills in this application. This application is helpful to the persons who seek any help in any language say Arabic, and then s/he can go to this application and search out the AARP employee with Arabic skills and reach out to them. Users can add multiple language skills to this application with the level like: Read, Write, and Speak.

Project # 7: RRS (Records Retention Schedule) application determines for how long each record type should be retained to meet legal, business, or regulatory requirements. Or in other words we can say “This database/application is a controlling instrument for maintaining AARP’s Record Keeping Policy”. This application helps in maintaining the Record Management with AARP staff across different departments.

Project # 8:Web concierge is a website/application that is used by AARP employees in Rockville location for organizing event ideas with maps, to view metro & regional transit links, restaurant and hotel reviews, finding work location of employees etc. Web concierge is a website/application that is used by AARP employees in Rockville location for organizing event ideas with maps, to view metro & regional transit links, restaurant and hotel reviews, finding work location of employees etc.

Project # 9: WS Admin is an application for monitoring and changing the status of the applications. Using the GUI, one can make the site available / unavailable and bounce the servers on requirement.

Responsibilities:

Requirement Analysis, Design, Implementation, Testing, Deployment and Documentation.

Interacting with Client Business leads for better understanding of the requirement.

Impact analysis of the new requirement or change request on the existing programs initiated by the client.

Designing New Components using ASP.Net (C#).

Identify and verify the impact based on the changes in downstream/upstream applications.

Prepare and review the Detailed design specification document

Coordinating the onsite/offshore activities and providing them guidance on day to day activities.

Performing Unit Testing, Integration Testing & Regression Testing.

Real time bug fix support during acceptance and end-to-end testing.

Generating metrics on the performance of the system.

Participating in Internal Audits and External Reviews.

Involved in the implementation of these changes in production by packaging the application etc.

TFS maintenance on regular basis

Tools & Technology Stack

Software Design/Architecture: Software Design Patterns, Microservices, N-tier

Microsoft: NET 2,3.5, 4.0

IDEs: Visual Studio 2015

Front End/JavaScript: HTML, JavaScript, jQuery, AJAX

Languages: C#, SQL, JavaScript

Version Control System: SVN

Reporting Tool: Crystal Reports

SDLC: Scrum

DevOps: IIS

OS: Windows

Databases: Oracle

Merck Cary, NC, USA

Lead Engineer Sept 2012 - Aug 2013

Project #1: ADA (Assay Data Analyzer) - This Application is being used by the scientist to analyze the data that is extracted by performing some Assay in the lab and to do the Quality assurance check based on that data and to validate a Sample or compound based on that QA check, which finally goes for production of a chemical substance.

Project #2:Mousetrap is a comprehensive library of in-depth functional information regarding pharmaceutical relevant mammalian gene families, such as GPCRs, Protease, and Ion Channels. It helps users to analyze the animal data for drug discovery

Responsibilities:

Requirement Analysis, Design, Implementation, Testing, Deployment and Documentation.

Interacting with Client Business leads for better understanding of the requirement.

Impact analysis of the new requirement or change request on the existing programs initiated by the client.

Designing New Components using VC++ (MFC)

Identify and verify the impact based on the changes in downstream/upstream applications.

Prepare and review the Detailed design specification document

Coordinating the onsite/offshore activities and providing them guidance on day to day activities.

Performing Unit Testing, Integration Testing & Regression Testing.

Real time bug fix support during acceptance and end-to-end testing.

Generating metrics on the performance of the system.

Participating in Internal Audits and External Reviews.

Involved in the implementation of these changes in production by packaging the application etc.

TFS maintenance on regular basis

Tools & Technology Stack

Software Design/Architecture: Software Design Patterns, Microservices, N-tier

IDEs: Visual Studio 2010

Front End/JavaScript: HTML, JavaScript, jQuery, AJAX

Languages: VC++ (MFC)

Version Control System: TFS

DevOps: IIS

OS: Windows

Databases: Oracle

Offshore – GE & Pearson Noida,UP, INDIA

Lead Engineer Sept2007 - Aug 2012

Project #1 (GE): PIPEIMAGE- This project was mainly for inspecting the defect inside the oil & gas pipelines. The inspection was carried out by a machine using magnetic & ultrasonic technology that rolls inside the pipelines and generates data for the Pipe image application. That data shows the defect inside the pipelines in graphics format

Project #2 (Pearson):(PDRM): PDRM (Pearson Document Routing Module)- In today’s organization collaborative working is the norm. It is common for teams to collaboratively work on review and approval of documents. Electronic routing of documents helps to drive efficiency and flexibility into collaboration. Pearson Document Routing Module (PDRM) will manage and improve document routing workflow and can be integrated with PCS applications such as PPS to further improve the efficiency.

Project #3 (Pearson): (PPS): PPS (Pearson Document Routing Module)- Publishing Planning System (PPS) is an application used by editorial group of Pearson Higher education. It is used to analyze and maintain publishing opportunities from financial and market perspectives. Editors, Editors in chief (EIC), Presidents, Business Managers and Financial Analysts are primary users of PPS. PPS provides functionality to track the

Contact this candidate