Pankaj Kumar Singh

Professional Summary

● Result-oriented Tech Lead with 11+ years of experience in Microsoft Technology.

Extensive experience in Design, Development, & Application Maintenance | Adept at
Product Development, Technical Experimentation, and Functional Design
Specifications. Total 15 years of experience in the IT industry.
● Hands-on experience in detailed design and implementing web-based applications
using .Net tech stack (Python with Tableau, ASP.NET MVC, ASP.NET, ADO.NET,
Web API, RESTful API, and REST API, Angular, Node JS, React JS, SQL Server, C#
and Visual Studio Code, Git, Jenkins and VSTS, Azure DevOps CI/CD, Puppet for
configuration management, Docker, Nagios Web Interface and Nagios Server,
Microsoft Power BI, SSRS reporting and Tableau.
● Design, implement, and maintain/Configure Azure DevOps pipelines (CI/CD), build,
release processes and deployment automation.
● Working as a full stack developer (Angular - Angular, Node JS, React JS, JavaScript,
SQL, CSS).
● Deep experience and knowledge of software design methodologies, information
systems architecture, object-oriented design, and software design patterns.
● Proficiently organized and facilitated daily scrum, sprint review, sprint, and release
planning.
● Coached team members on agile principles and provided general guidance on the
methodology and updated the Agile Tracking system to provide transparency on
product and sprint backlogs.

● Developed N-Tier Architecture, and Design Patterns using Microsoft technologies.

Expertise in web services / Web API RESTful API. Experience with SOA and large
distributed systems. Experience in Microservice.

● Analysis, UML, TDD development, Code review and refactoring, Risk Analysis, and
time estimation, test plans & cases, automated & manual testing.
● Experience in managing complex and highly technical development projects. The
ability to multitask and manage multiple projects simultaneously in a globally
distributed delivery setup. Strong understanding of technology and the ability to deep
dive into a technology problem
● Manage developers in terms of Technologies and Functionalities. Able to do coding
independently (IC) and have knowledge of the SDLC process with documentation.
Participation in all stages of a project's SDLC including requirements gathering and
analysis, design, development, deployment, maintenance, and migration.
documenting, high-level, and low-level design, coding, testing, and deploying.
● An energetic, self-motivated with hands-on experience in programming skills,
client-server infrastructure, application integration, and customization.
 ● Strong communication, collaboration & team-building skills with proficiency in
grasping new technical concepts quickly & utilize the same in a productive manner.
● Create design documents and assign tasks to the team as well as work as an IC
(individual contributor).
● Participate in the review of code, designs, and test plans produced by other team
members.
● Develop assigned modules / new features/enhancements in existing features.
● Perform unit, integration, or system testing which includes the development of test
plans.
● Extending post-go-live and application maintenance support to the client.
● Follow the defined processes/standards and escalate issues/risks in time to immediate
supervisors.
● Provide accurate and timely updates to the stack holder of the project.
● Experience in writing SQL’s stored procedures, triggers, and functions and optimizing
T-SQL statements for implementing business logic. Well-versed with data modeling
and Normalization of database schemas.

Education

Degree University Year of Passing

MCA Uttar Pradesh Technical University 05/2005
BSc Lucknow University 07/2000
Intermediate Govt. Jubilee Inter College 06/1997
High School Govt. Jubilee Inter College 06/1995

Experience

Organization Designation Duration

Tech Mahindra Associate Tech Specialist (05/2017) – (08/2024)
Sagitec Solution Pvt. Ltd Technical Lead (02/2017) – (05/2017)
Capgemini India Pvt. Ltd. Consultant (06/2013) – (01/2017)
Capgemini India Pvt. Ltd. Consultant (11/2012) – (04/2013)
APTARA New Media Pvt. Ltd Senior Developer (01/2008) – (11/2012)

Technical Skills

Operating Systems Windows 10 and 11

Languages C#, C++
Databases SQL Server, MySQL, SQLite, DynamoDB, Power BI, SSRS
reporting and Tableau.
 Web Related ASP.NET, ADO.NET, MVC, jQuery, JavaScript, Ajax, Web API,
Web Service, WCF, Angular JS, Web API, RESTful API and REST
API and Node JS, React JS, HTML, CSS and JavaScript

Tools & Utilities Azure DevOps, Azure Databricks/Notebook, Azure API

Management and Azure load balancer, Visual source code, Visual
Studio, VSTS, SVN, TFS and Docker, Git, Jenkins, and Azure
DevOps CI/CD, Puppet and Nagios for configuration
management/continuous monitoring (Azure monitor services),
GitHub
Domain Knowledge LMS – E-learning, Finance, Mining, Banking

Projects Profile

1. Project Name: OAC for ACC and WCU

Client ACC SharePoint
Role Tech Lead
Organization Tech Mahindra, India
Duration (03/2018) – (08/2024)
Team Size Project: 20 Module: 12
Environment Software Languages and framework: C#, ASP.NET, WPF, Visual
(With skill Studio 2019, HTML, JavaScript, Angular, React JS and NODE JS
versions) Reporting and visualization in data analytics: SSRS
reporting and Tableau. RAD PDF
Database: SQL server, Mongodb and MYSQL
Tools: Visual Studio, Entity framework, jQuery, Java Script,
Angular 12, Microservices API, RESTful API in C# and NODE
JS, RAD PDF, Visual Studio Code, Angular, React JS, and
Power BI, SSRS reporting with Tableau. Test plans & cases,
automated & manual testing. VSTS, SVN, TFS and, Git,
Jenkins, and Azure DevOps CI/CD, Puppet and Azure data
brick/App and Load Balancing, Azure Monitor services for
configuration management/continuous monitoring
Testing: Jasmine framework and Karma tool, Unit testing,
Integration testing, System and Acceptance testing.
O/s: Windows 11

Project Description

OAC stands for Online Application Center. It is used by WCU (different campus) students
for registration purposes. initial information for student is done by CRM team by creating the
lead and that lead will be used by student to make the entries in student portal (this is portal
for students to fill the necessary information with digital sign). Once the student made the
digital sign, he will be able to download the document to view the details. There is another
portal (admin portal) is used to make the sign done by staff and provide the approval by Rep,
Supervisor and official to make his signs on PDF. Once signs are done by staff, students will
be locked and will not be able to perform any update operations on PDF. There is another
service called Image Now services which is used to move the PDF document on image now.

There are five components of OAC.

● OAC Web Application (Student Portal/Fillable plug in): Web Application used for
student registration and digital sign is done by using the RAD PDF control.
● OAC Admin: (Used for Document Approval)
● Component Service: (Used to send / Update data to CRM & Campus Vue): used to
sync up data between OAC DB and CRM DB
● CRM Push Service: WCF Service exposed by us. CRM & Campus Vue application
will consume it to send their data to OAC Database. This console Application is used
as a SQL job.
● Image Now Service: Used to Push Student Documents to Image Now.

Code Workflow:
● The student portal is developed in AngularJS and will communicate to fillable plugin
UI and API code (developed in Visual Studio 2017 with RAD PDF controls to make a
digital sign). Admin Portal is developed in AngularJS and to communicate with
databases, we have created an API.
Below are the application details.
● OAC2.0 is developed in VS 2017 with C#
● Portals are created in VS 2017 with angular.js and jQuery.
● (Web API) API related call made by ajax in jQuery.
● Documents that need to be moved to the desired location are done by SQL job.
● Deployment and work items are done in Azure DevOps.
● Used Puppet for configuration management.
● Python with Tableau for reporting. Visual Analytics for Data Analytics and
Visualizations.

Contribution
● Analysis of the specifications provided by the clients.
● Design and Development
● Coding using Angular, ASP.NET, HTML pages, Java Script
● Database management and SQL connectivity
● Testing - unit testing & integration testing
● Responsible for overseeing the Quality procedures related to the project.
● Client site for implementation.
● Gathering requirement, Design the structure of application and Development of
application.
● Design, implement, and maintain/Configure Azure DevOps pipelines (CI/CD), build,
release processes and deployment automation.
● Develop and maintain Azure DevOps automation scripts.
● Create and maintain Azure DevOps dashboards for Epic/story, task.
● Manage Azure DevOps source control repositories
● Implement and maintain Azure DevOps monitoring and alerting, Ansible, Chef, Puppet,
and Azure Automation.
● Create an Azure Databricks service and Spark cluster
● Create/Upload/Extract a file system in the Data Lake Storage account.
 2. Project Name: ShareCare
Client ShareCare
Role Tech Lead
Organization Tech Mahindra, India
Duration (05/2017) – (02/2018)
Team Size Project: 28 Module: 5
Environment Software Languages: C#, ASP.NET, ADO.NET, VB.net, VB, Visual
(With skill Studio Community 2022, and Visual Studio 2019.
versions) Reporting and visualization in data analytics: Microsoft
Power BI, SSRS reporting and Tableau.
Database: SQL server
Tools: AWS Workspaces, Visual Studio, Entity framework,
jQuery, Java Script, Angular 4.0, Web API, Web API, RESTful
API and REST API, Visual Studio Code, Angular, React JS, and
Power BI, SSRS reporting and Python with Tableau. Test
plans & cases, automated & manual testing. Git, Jenkins, and
Azure DevOps CI/CD, Puppet and Nagios for configuration
management/continuous monitoring

Project Description

Sharecare is a health and wellness company that provides consumers with personalized
health-related information, programs, and resources. It provides personalized
information to the site's users based on their responses to the Real Age Test, the
company's health risk assessment tool, and offers a clinical decision support tool.
Sharecare Enterprise web is a software solution tailored for enterprise level usage
within the healthcare industry.it likely encompasses a range of feature and module
designed to various aspects of healthcare management such as patient to streamline
various aspects of healthcare management such as patient data management
appointment scheduling, electronic health records (EHR), billing, inventory
management.

● Daily Check-in
● Home Cards
● Home Chips
● Search
● Advocacy
● Challenges
● Programs
● Achieve
● Coaching
● Health Profile
● Care Console
● Sharecare Enterprise Web and Mobile,Care Console,Coaching ,SCM ,Diabetic
Solution ,Carelinx,Mind sciences,API / Services

Contribution
● Analysis of the specifications provided by the clients.
● Design and Development
● Provided Training for health care domain.
● Code review.
● Version control in GitHub.
● Test plans & cases, automated & manual testing.

● Managing the JIRA board for Application Maintenance Service and Application
Development Services
● Weekly/Monthly reporting for the work being done against the capacity.
● Service provider will work with Sharecare stakeholders to establish a mutually agreed
upon governance process.
● Involved in finding out new techniques/solutions for the improvement of the projects.

3. Project Name: Admin plus Application

Client USI
Role Programmer
Organization Capgemini, India
Duration (11/2014) – (01/2017)
Team Size Project: 3 Module: 3
Environment Software Languages: C#,
(With skill Database: SQL server
versions) Tools: Visual Studio 2017, Entity framework, jQuery, Java
Script, Web API
O/s: Windows 10
Hardware

Project Description
Admin+ applications for managing life and health policies. Admin+ application is divided
into three modules.
1. Policies module
2. Agency billing module
3. Accounting module
● POLICIES MODULE - The Policies module is used to create new policies and search
existing ones. Policy Search, Policy search result, Adding new policies (DENTAL
POLICY SCREEN, DISABILITY POLICY SCREEN, LIFE POLICY SCREEN,
TERMLIFE POLICY SCREEN)
● AGENCY BILLING MODULE - Agency billing module helps to create, maintain,
generate and print statements of charges for all policies. It also helps to process credit
card, ACH transactions and handle delinquent processing for policies in the system. The
following components are available in ‘Agency Billing’ module:
CREATE POLICY CHARGES, MAINTAIN POLICY CHARGES, GENERATE
STATEMENTS, PRINT STATEMENTS, CREDIT CARD PROCESSING,
DELINQUENT PROCESSING
● ACCOUNTING MODULE - Accounting Module is used to process payments received
and reconcile accounts. The result will populate information into the ‘Payments’ tab in
the ‘Generate Statements’ portion of Agency Billing Module and in accounting tab of the
 policy. The following components are available in Accounting Module: A/R PAYMENT
BATCH LIST, A/P PAYMENT BATCH LIST
● BILLING AND ACCOUNTING - Billing is responsible for generating charges for
policies. Charges can be policy premiums, tax applicable in certain states, admin fee,
billing fee etc.

Contribution
● Analysis of the specifications provided by the clients.
● Design and Development
● Coding using ASP.NET, HTML pages, Java Script
● Database management and SQL connectivity
● Testing - unit testing & integration testing
● Responsible for overseeing the Quality procedures related to the project.
● Client site for implementation.
● Gathering requirement, Design the structure of application and Development of
application.
● Code review.
● Version control in GitHub.

4. Project Name: Maderia Migration

Client First Data Holdings Inc
Role Consultant
Organization Capgemini, India
Duration (12/2012) – (10/2014)
Team Size Project: 8 Module: 2
Environment Software Languages: C#,
(With skill Database: SQL server
versions) Tools: Visual Studio 2017, ETL, RCQ, SVN
O/s: Windows 10
Hardware

Project Description
MADEIRA is a data warehouse that is designated to maintain transactional information from
different sources with 17 databases with more than 1700 tables. Maderia migration is used to
convert the C# and C++ code into informatics (ETL).in the existing data model, data comes
from different sources (C# and C++, SQL Server). Analyze the existing data model and the
related ETL processes and provide a concept for migration from current SQL Server to DB2 /
Netezza did analysis code and provide the Risk Evaluation and code complexity based on
conditions.
MADEIRA are mainly used for below purpose:
● One use of MADEIRA is to provide necessary data for the generation of reports.
● MADEIRA also contains databases, which store the transaction files coming from
different sources.
● MADEIRA also stores the replicated data from different databases to enable querying
and reporting.
MADEIRA maintains also the authorization status of cards and rules in the different
database.
Contribution
● Analysis of the specifications provided by the clients and migration from C# code to
ETL.
● Design and Development
● Responsible for overseeing the Quality procedures related to the project.
● Client site for implementation.
● Gathering requirement, Design the structure of application and Development of
application.
● Code review.
● Version control in GitHub.
● Analyze the code and Store Procedure
● Create Excel file template for ETL.
● Provide input and output parameter to ETL.
● Prepare the document (excel sheet) for code and SP.

5. Project Name: LMS & LAS

Client Intellinex – ACS, USA
Role Developer
Organization Capgemini, India
Duration (08/2008) – (11/2012)
Team Size Project: 15 Module: 6
Environment Software Languages: C#,
(With skill Database: SQL server
versions) Tools: Visual Studio, IIS 6.0, SVN. RCQ
Technologies: ASP.Net 4.0, WCF, Microsoft SQL Server
2005/2008, Visual Studio .Net 2010, IIS 6.0, SVN. RCQ

Hardware

Project Description

The key to the Intellinex LMS is relationship management. User’s complete courses and
learning maps to gain certain skills also meet company requirements. These requirements
include job requirements, organization requirements, and individual requirements. The
Intellinex LMS is not just designed to manage individual components of a customer such as
customer's course offerings or employees. It is designed to both manage these components
and capture the associations between each by tracking the day – to – day interactions. With
the LMS, everything revolves around learning management.
Administrators decide where learning maps and courses are organized, who will be able to
view these learning, and which organizations, jobs, and user will require this learning.
Learners access this learning by searching the catalog, where all the courses and learning
maps are organized in the LMS. These users can view, register for, and participate in
available learning by using the catalog.
Managers can monitor their direct reports development and manage these reports either
collectively or individually. Instructors can manage their assigned courses including the
progress details for learners registered in these courses. By properly establishing the
relationship available in the LMS, the user can effectively structure his learning environment
to ensure that every employee is given a clear and achievable roadmap to meet both their
individual needs and the needs of his company.

The Learning Administration System LAS will be an Internet-based tool, accessible to all EY and
Intellinex employees. The LAS is a replacement of and automation of existing non – integrated
tools and manual processes. The LAS is your entry to submit learning requests for CPE – and non –
CPE related training Instructor – led. You may use LAS to submit firm – sponsored or non – firm
sponsored events.
From the LAS you can do the following:
1 Publishing to the LMS
2 Request Storage in the dbase
3 Communication with the LMS
4 Submit a learning request.
5 Cancel a learning request.
6 Save and exit a request for completing later.
7 Use search to find any learning request.
8 Check the status of requests.
9 Attach supporting documents.

Contribution
● Analysis of the specifications provided by the clients.
● Design and Development
● Coding using ASP.NET, HTML pages, Java Script
● Database management and SQL connectivity
● Testing - unit testing & integration testing
● Gathering requirement, Design the structure of application and Development of
application.
● Code review.
● Version control in GitHub.
● Bug Fixing and Enchantments,
● Coding and Development,
● Created/Updated WCF services.
● Used RCQ for bug tracking, Used VPN for code check in and checkout, Unit testing.

Personal Details

Name Pankaj Kumar Singh

ID No. (India & US)
Aadhaar No - 574460537741
Email Id Pankaj7lko@gmail.com

Passport No. Z4406686 Valid Upto: 10/10/2027

(mm/dd/yyyy)
Type of Visa holding (if any) H1B (Stamping Valid Upto : 09/01/2025
Done) (mm/dd/yyyy)
Location Pune

Contact Numbers Home: 7753964839

Work: 9975686674/7753964839