Pawan A.

Pawan A.

15.9+ yrs. experience-MCP Certified | (.Net, Sql, MVC, Angular, Ajax, JQuery, Web API, SSRS)

Kuala Lumpur , Malaysia

Experience: 15 Years

Pawan

Kuala Lumpur , Malaysia

15.9+ yrs. experience-MCP Certified | (.Net, Sql, MVC, Angular, Ajax, JQuery, Web API, SSRS)

54999.7 USD / Year

  • Immediate: Available

15 Years

Now you can Instantly Chat with Pawan!

About Me

  • Overall 15.9+ years of experience in the software industry as a Programmer / Developer / Lead / Architect with Web & Windows/WinForms application development and Maintenance, including analysis, and using leading object-ori...
  • Proficient in Microsoft Technologies i.e., Visual Studio 20xx with ASP.Net MVC Core 3.x and .Net Framework 4.x using ASP.Net with C# and VB.Net. 1.6+ years of experience in Silverlight 4/3 with WCF.
  • 11.6+ years of experience in Entity Framework, LINQ and Lambda expressions, Multithreading.
  • Excellent knowledge and experience in developing applications in ASP.Net MVC 5/4/3 using Entity Framework 6 and WCF. Experience in creating and consuming WCF and Web Services.
  • Experience in full Software Development Life Cycle (SDLC) from inception to delivery of product including requirements gathering, creating functional and technical specification, design, and implementation. Experience of Agile (Scrum) methodologies, creating user stories, sprint planning and prioritizing etc.
  • Experience in creating Software Architecture and Design Specifications with user specifications and use cases using Visio. Well versed with UML Diagrams i.e., Structural diagrams and Behavioral Diagrams.
  • Experience in database design and development using SQL Server 2019/2017/2008 R2/ 2005, MS Access 2003, MySQL 9.2, Oracle 10g/9i and DB2.
  • Experience in developing reports using Sql Server Reporting Services (SSRS) and Crystal Report 9.0
  • Working experience of Angular and AngularJs with Web API 2.
  • Working Experience on security technologies e.g., OAuth, OpenID Connect using OWIN libraries.
  • Experience in working with TDD (Test Driven Development) using nUnit, MS Test and xUnit. Experience in automation testing using Selenium over C#.
  • Good Hands-on experience with the implementation of DRY, KISS, SOLID design principles and GoF Design Patterns - Singleton, Factory, Façade, Repository etc.
  • Working with higher management and business team users and business analyst to plan and propose technologies and solutions. Involved in managing end-to-end platform and respective teams including backend operations, data processing operations and other teams like deployment team.
  • Creating SOW (Statement of Work) document and providing the effort estimates (man-hours) for the projects. Handled and managed the SQA processes in the team.
  • Working knowledge of Amazon AWS and Microsoft Azure. Also has basic knowledge of Microservices, Dockers, CI/CD etc.
  • Good leadership skills and strong process orientation, outstanding team Player, strong work ethics, enthusiastic, quick learner with positive attitude. Excellent analytical, problem solving, communication, interpersonal skills with the ability to handle multiple tasks or projects working independently or in a team. Also, able to understand and interpret needs of end users to design quality software.
  • Consistent attention to detail with an ability to analyze and interpret the implication of decisions to minimize bugs and create user-friendly applications.
  • Ability to create and document a conceptual and detailed design and develop software based on a conceptual description of the business logic. Also involved in the Code Review process for Onsite and Offshore team members.
  • Involve in Campus Selection Interviews and Technical Interview Panels in candidates hiring process.
  • Experience in handling teams of 11-15 members. Providing the assistance in onboarding and training to new joiners in architecture and code walk-through with database.
  • Experience in working with global clients like UK, USA, Europe, Australia, Malaysia, Japan, China, Singapore etc. and teams located remotely (e.g., Sydney, Australia, USA, Singapore, and Sweden).
  • Worked with the Sweden client ManpowerGroup at onsite client location Stockholm, Sweden from Mar’14 till Sep’14.

Show More

Skills

Portfolio Projects

Description

Description: Ascender Connect is the application which acts as interface for various applications like Ceridian PeoplePay, PayANZ and LMS in terms of managing backend/administration operations. This application is having various API methods which are used to validate user, get access token, get user access, get employee details, related to workflows for the employees etc. This application manages the entire client’s related data, their HRM related details etc. and the way to connect to the end client applications. The user can create/manage roles; create/manage groups etc. PeoplePay or PayANZ or LMS are the client application which uses the Core application for the roles/groups and other related information. Spark is the application for conversion from MS Visual FoxPro to C#.Net and reports to SSRS reporting tool.

Technologies Used:

Visual Studio 2022/2019, SQL Server 2019, Microsoft Visual FoxPro 9, MSMQ, .Net Core 3.x, ASP.Net MVC 6,

C#.Net, Web API, LINQ & Lambda Expressions, Classic ASP 3.0, jQuery & Ajax, Postman, JIRA, Bootstrap, HTML5

& CSS3, Angular & AngularJs, Windows Services, Reporting Services using SSRS, Agile (Scrum), TFS 2012, MySQL

9.2, OpenID Connect, Visio etc.

Responsibilities:

  • Working with system analyst and business users to ensure full understanding of any issues or change requirements and implications to current business processes.
  • Involved in Technical and architectural Design and application framework. Also do the code review.
  • Produce detailed specifications and write code according to specifications, escalate technical design/specification issues to Business Analyst, and work within given time frame to complete coding. Involved in migration of MS Visual FoxPro code to Microsoft C#.Net code and visual FoxPro reports to SSRS (Sql Server Reporting Services).
  • Involved in creating database objects like tables, functions, stored procedures etc.
  • Involved in creating/managing branches in various environment using TFS (Team Foundation Server). Also involved in creating and deploying the application packages to Dev, QA and UAT environment.
  • Involved in application performance and memory leaking issues in the application.
  • Following standards and processes in-line with process improvements implemented.
  • Testing API’s using tools like Telerik Fiddler Web Developer, Postman, and Swagger.
  • Help to new joiners in onboarding and providing training on the product with architecture and code walk-through with database.
  • Leading a Team of 8 -10 developers and helping them resolving their assigned tasks

Show More Show Less

Description

Description: The Application EHS is as Web Application developed using the IDE Visual Studio 2015 with Sql Server 2016. This application is related to the Environment, Health and Safety for the employees who are working in JABIL across the world. The main modules under the application are- Communication & Complaint, Incidents, and Audit Reports etc.

Technologies Used:

Visual Studio 2015, ASP.Net MVC 6, NodeJs, C#.Net, LINQ & Lambda Expressions, Ajax, jQuery and JavaScript,

Agile (Scrum), ReSharper, TDD using MS Test, JIRA, SQL Server 2016 etc.

Responsibilities:

  • Analyzing the requirements and discussing with the Business Analysts for the UI Screens to be developed.
  • Presentation of the UI screens and the functionality to the client in Prototype.
  • Conform the requirements to the DBA’s for the database design.
  • Clarifications of requirements by discussion with the Client.
  • Writing code and unit testing as per the confirmed functionality by BA’ and client.

Show More Show Less

Description

Description: LPF and JSR is a web application developed using Visual Studio 2010 and now migrated to Visual Studio 2015 with Sql Server 2008 R2. This application is using ASP.Net MVC 5 with C#, cshtml code as the front end. LPF application takes care of the job search functionality for the Monster.Com web portal (https://www.monster.com/jobs/). The search functionality defines the search filters (e.g., job types, company names, city, state, country etc.). With these filter criteria, the system searches the jobs and displays into the search portal page. It also handles the searches based on the radius in km/miles. In the background it uses various search engines like Trovix, SOLR, and Lucene’s to get the search results from internal database as well as from the cloud search services based on the filter criteria passed as the search query.

The website is developed in multiple languages like in German, French, English, Dutch and Swedish etc.

Technologies Used:

Visual Studio 2015/2010, ASP.Net MVC 5, C#.Net, NAnt, Enterprise Library5, LINQ & Lambda Expressions, Ajax, jQuery, Agile (Scrum), ReSharper, TDD using Selenium, JIRA, Perforce, MS Build, SQL Server 2008 R2 etc.

Responsibilities:

  • Analysis of the current/existing applications and solving the issues during migration of the application with its functionality. Supporting the old application by fixing the bugs and adding the new functionality.
  • Clarifications of issues/ new requirements by discussion with the Client.
  • Creating user stories and involved in the sprint creation.
  • Involved in sprint discussion and standup meetings on daily basis.
  • Involved in fixing the security vulnerability issues on the website (e.g., Cross Site Scripting)
  • Working on writing the code as per the new requirements; writing/modifications the stored procedure which matched the required functionality.
  • Peer testing/Code review of the issues fixed by other developers.
  • Performance review for the application using tools like ASPNet_Compiler.
  • Unit testing of the application with required functionalities.

Show More Show Less

Description

Description: Powerbase is the application which takes care of all the records of the candidate which got hired under the ManpowerGroup, Sweden. It contains several modules like Candidate, Customer, Jobs Orders and Client etc. By this application, the user can keep track of all the employees, their schedule of work, Timesheet, payroll system, leave management etc. This application is also integrated with various external systems like web application (Power Cast) from where the selected candidate is mapped to the client, the PeopleSoft application, which is related to employee details, the payroll system to take care of payroll for the employee etc. When a new Candidate found by using the website Power Cast, the employee of the Manpower tries to map the candidate to a client and takes care of all the details of the candidate. So, this application starts once the candidate is the ManpowerGroup, Sweden employee.

Technologies Used:

Conversion tool VBUC, Visual Studio 2012, C#.Net, TFS 2010, VB 6.0, Entity Framework 6, LINQ & Lambda Expressions, Component One, Agile (Scrum), ReSharper, TDD using nUnit, SQL Server 2008 R2 etc.

Responsibilities:

  • Analysis of the current/existing applications.
  • Conversion of old VB 6.0 application code to new Visual Studio 2012 with .Net 4.5 application using VBUC migration tool. Also involved in the Architecture of the new Powerbase application using Mobilize software VBUC.
  • Creating the multilayered architecture to support the existing application components and their uses.
  • Using the Enterprise Library 5, LINQ, and Lambda Expression with Entity Framework 6.
  • Using the components from 3rd party ‘Component One’ library in the new application.
  • Solving the issues during mobilization of the application with its functionality.
  • Supporting the old application by fixing the bugs and adding the new functionality.
  • Clarifications of issues/ new requirements by discussion with the Client.
  • Involved in standup meeting on daily basis and creating user stories and involved in the sprint creation.
  • Unit testing of the application with required functionalities.

Show More Show Less

Description

Description: The NBA application is the collections of more than 200 Applications which are developed using the VB 6.0, Classic ASP 3.0, and ASP.Net with C#, VB.Net, Windows/WinForms applications, ASP.Net Web Services, WCF Services etc. These applications are scheduled and run as per the schedule for the insurance business clients to accomplish their business. A new WCF service (CItoNBConversion) is created to convert the Client Index Policy to the New Business policy, and it’s consumed in the various applications so that they don’t need to convert those policies manually. This service is hosted to the Production Environment and consumed by the other applications like- CER Application (BizTalk Server Application), Mainframe Applications etc.

Technologies Used:

Visual Studio 2010, ASP.Net, C#, PVCS, VB 6.0, TFS 2010, WCF Service, VB.Net, Windows Services, Web Services,

WCF Services, WinForms Applications, TDD, SQL Server 2008 R2, MS Access 2003 etc.

Responsibilities:

  • Analysis of the current existing applications and map the new client’s requirements.
  • Solving the issues from client and maintaining the applications.
  • Enhancement of the applications to support Microsoft Outlook 2010 (using Redemption 2010dll)
  • Created a new WCF Service (CItoNBConversion) to convert the Client Index to the New Business Policy.
  • A new functionality has been implemented (mzTranslateError method) in the Viewer Application (in VB 6.0) using the API. This application is using the API to read the scanned document and shows the page by page.
  • A new change has been done in the Message Facility application (VB 6.0 Application) so that if the user is entering some invalid Group to send the mail, the application will check the existing name in the NBA and Outlook to resolve and get all the E-Mail ids in that group and if the Group id is not valid, it will not allow the user to send the mail.
  • Fillable Form Application Maintenance and enhancements (VB.Net Application)
  • Handling and managing the SQA processes in the team.
  • Modifications in the other applications including database as per the requirements.
  • Clarifications of issues/ new requirements by discussion with the Client through Conference call.
  • Unit testing of the application with required functionalities

Show More Show Less

Description

  • The INET application is the existing web application which is used to maintain the client policies for the clients. This is the insurance domain project where the policy holders can search their policies and check their premiums, generating letters, reports etc. There are various functionalities like creating new ProSec user, searching the policies (Universal Life policies, TRAD Policies etc.) and other details.
  • Analysis of the client requirements and map to the exiting application.
  • Creating new classic ASP 3.0 pages, ASP.Net and its interaction with DB2 as well as with SQL Server 2008 database to fulfill the client’s requirements.
  • Discussion with the Client through Conference call regarding the clarifications of the project requirements/functionalities.
  • Writing SQL Query and stored procedure to insert, update and Delete transactions in SQL Server 2008 database.
  • Unit testing of the project application with functionality

Show More Show Less

Description

  • The CER Application is the integration project developed by using the BizTalk server artifacts and .Net class libraries for the various validations. This is the insurance domain project where the customer can get the payment instructions to deposit their insurance premium.
  • The BizTalk is used here as the middleware where the legacy systems can interact and get the required information.
  • Analyze the Project’s existing architecture and Designing of various artifacts in the application. Also, analysis of the new requirements for the enhancement in the project.
  • Creating new Schema, Map and modification in the existing Orchestration as per the new requirements.
  • Creating WCF Service to validate the policy information with the Mainframe database.
  • Creating a new Schema’s and Orchestration which will pick the data from various sources and validate it as per new the standards defined by the client.
  • Discussion with the Client through Conference call, Video Conferences regarding the clarifications of the project requirements/functionalities.
  • Writing SQL Query and stored procedure to insert update and Delete transactions in SQL Server 2008 database.
  • Unit, integration and System testing of the project application with functionality.

Show More Show Less

Description

  • The project application Salary Continuation Plan (SCP) is used by the Displacement Services group within the HR Service Center’s Services and Support area. When the decision is made to eliminate positions, Displacement Service is provided necessary information to communicate severance benefits to the team member(s) displaced. Information is added to the SCP database, the calculation of the benefit is done by the application and the results are used to provide letters to the team members and to track the status of the team members.
  • Analyze the Project Requirements and converting the business requirements to the technical specifications.
  • Discussion with the Client through Conference call, Video Conferences regarding the clarifications of the project requirements/functionalities.
  • Creating Database Design, Project Architecture & Design and Coding.
  • Writing SQL Query and stored procedure to insert, update and Delete transactions in Oracle 9i and IBM DB2 databases.
  • Unit testing of the project application with functionality.

Show More Show Less

Description

  • Corporate HR Security Component is designed to provide the departmental security for the Applications inside the Wells Fargo network. This application will provide the security administration for multiple applications. The user will use the Ad-ENT secure login and then they will be able to access the application based on their roles existing in the PeopleSoft DB2 database. E.g. if a Manager is logged in to the system then they have less restrictions as compared to general employee. To get the roles from the IBM DB2 database, we are using WCF Service (using WSCF.blue tool). This WCF Service will be called automatically, when there is a request made by the user to access the application. Also, with that, we are logging the information regarding the user who tried to access the application. The logging mechanism is implemented using the Oracle 10g database
  • Analyze the Project Requirements and preparing the requirement specification document for the project application.
  • Discussion with the Client through Conference call, Video Conferences regarding the clarifications of the project requirements/functionalities.
  • Creating Functional System Design (FSD) document.
  • Created the WCF service to check the authentication of the user while logged in to the Wells Fargo domain and accordingly provides the access privileges to various other applications.
  • Creating Database Design, Project Architecture & Design and Coding.
  • Writing SQL Query and stored procedure to insert, update and Delete transactions in Oracle 9i and IBM DB2 databases.
  • Unit testing of the project application with functionality.

Show More Show Less

Description

Inprotech is designed specifically for IP attorney firms. It is an extremely flexible system that handles all IP and practice management demands. It allows full IP and practice management and because of the clever modular design it can be set up to exactly meet the demands of individual clients whether that covers currency, language, or format. Online and secure, the system can also be accessed wherever and whenever required, making it highly efficient and cost effective. The project contains several modules like Case and Name: Central repository for all your case and name information, Timesheet: Capture time in online or batch manner, File Tracking: Track paper files using bar code technology, Fee Generation/List: Register scale fees as well as official and other disbursements, Cost & Revenue Tracking: Collect and evaluate information about the cost of managing IP, Billing etc.

Technologies Used:

Visual Studio 2010/2008, .Net 4.0/3.5/2.0, ASP.Net with C#, JavaScript, MS AJAX, JSON, HTML, CSS,

Multithreading, Silverlight 4/3, MVC4, WCF Service Create and Consume, SQL Server 2005, Aspose, HTTP Watch,

IE Developer Toolbar, JS Lint etc.

Responsibilities:

  • Analyze the Project Requirements and solving the issues given by the Client in the project application.
  • Discuss with the Client/Business Analysts through Chat, Conference call, Video Conferences regarding the clarifications of the issues/functionalities.
  • Creating Functional and Technical specs of the issues given by the clients and Business Analysts.
  • Creating Views, Model classes and View Model classes for the module.
  • Creating WCF Services for the various CRUD operations in Silverlight application to interact with database.
  • Coding & Unit testing with the appropriate Standards. Also, maintenance of the old Asp.net application

Show More Show Less

Description

  • This project was developed as the product which contains various modules and reports facilities. The project mainly consists of 12 various modules i.e. MIS, Administration, Students, Staff etc. The various modules have the security features, based on which the user can logged in and do the required functions. It also has the reports which can be used for the top-level management for the progress of the institute.
  • Discussion with the Client through Chat, regarding the clarifications in the Requirements.
  • Coding and Integration of the project.
  • Planning of the project and resources required.

Show More Show Less

Description

  • VevoCart Shopping Cart is an e-Commerce Solution for small businesses. It provides a simple solution to create an online store with e-Business functionalities and professional Design. It contains two sectionsAdmin and Users. Admin can change the design as well as he can modify the functionality of the website while user can use it with those functionalities.
  • Planning of the project and resources required.
  • Analyze the project implementation and the issues given by the client.
  • Changes in the Code as per the issues given by the client.
  • Changes the DLL’s of the project as per the requirement of the client issues.

Show More Show Less

Description

  • The purpose of this application is to launch a Web site where people can come and find a unique way to analyze a price chart. This chart could belong to any of the stocks listed on NASDAQ or New York Stock Exchange. This chart could also be of any of the commodities in the following categories which are traded in the United States exchanges: currencies, energy, grains, stock indices, interest rates, meats, metals, and soft &fibers. If any user can visit to this website and gives input like “stock symbol" then it returns "stock chart" on that symbol along with indicators. This mainly consists of two basic indicators.
  • Analyze of the Client’s Requirements and Coding for Charts (ASP.Net with C#).
  • Discussion with the Client through Chat, regarding the clarifications of Requirements.
  • Coding with appropriate standards.

Show More Show Less

Description

  • The purpose of this application is to work on the Touch Screen Monitor through Keyboard by a user inside the Hospital. Key board will display on the screen with all the Numbers as well as Alphabets so that one can enter all necessary items of a healthcare documentation by touching the alphabets ‘keyboard’ displayed on the screen.
  • Analyze of the Client’s Requirements and Designing the SRS Document.
  • Discussion with the Client through Chat, regarding the clarifications of Requirements.
  • Coding and Integration of the Project.
  • Prepared resource plan and conducted various trainings during the project progress.
  • Evaluation and review of the team members work.

Show More Show Less

Description

The Project Application ACATS (Automatic Customer’s Asset’s Transfer System) mainly consists of transferring the Assets (Shares) from one account to other. The Customer can transfer his/her all/Partial Asset’s to another firm. For each transfer, ACATS workflow submits a Request to NSCC (National Security Clearing Corporation). Customer can walk to the related firm and Fill the TIF (Transfer Instruction Form) and Handover to BO. The BO fills the Data Entry TIF into Workflow. The Workflow will do rest of the process accordingly by Using BizTalk and SSIS with UI.

Technologies Used:

Visual Studio 2005, ASP.Net, C#.Net, XML, JavaScript, BizTalk Server 2006 R2, AJAX 1.0, CSS, SQL Server 2005.

Responsibilities:

  • Designing and coding of the Account Search Screen, Assets Transfer Full Details Page.
  • Writing the Stored Procedures to Add, Update, Delete Assets, and Account Search etc.
  • Writing BL (Business Library) and DAL (Data Access Library) Methods etc.
  • Creating BizTalk Schemas, Maps as per the business requirements

Show More Show Less