Automation Tester Data Entry
Resume:
CHANDAN KUMAR
Sr.Technical Lead/ Full Stack Developer/ Business Analyst / Selenium Automation Tester
Email: **********@*****.*** / 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