Technology Used: VS.NET 2017

Front End: ASP.NET and C#

Scripting Language: JQuery

Back End: SQL Server 2017 R2

This is a HRMS application hosted in cloud and deals on Employee clocking, Employee Leave, Employee Payroll, Appraisal, and Scheduling. This application is accessible via both web and mobile.

ETMS – Management of employee entry and exit time from biometric devices or from mobile.

ELeave – Employees’ leaves are calculated – hourly and monthly.

EPayroll – Employees’ salaries and payslips managed in this module.

EAppraisal – Appraisal process managed in this module.

EScheduling – Employees’ scheduling is managed here.

I was responsible to gather the requirements and develop as per the requirement and make it go live

Technology Used: VS.NET 2010, 2013

Front End: ASP.NET and C#

Back End: SQL Server 2008 R2

Model: Agile

Setup System is an operations tool that helps client team(s) create a customized bled of U2X Benefits portal that meets every client specific needs.

Since U2X is a 1: n application, the setup system becomes a critical tool that does all the heavy lifting behind the scene to put up the client specific UI on the U2X application.

The setup system can be broken into following high level logical sections:

• Client Information Setup
• Benefits Design Setup
• Rates & Rules Setup
• Custom Website Setup

Other Setup Management

• Client Information Setup
• Benefits Design Setup
• Rates & Rules Setup

Custom Website Setup

Technology Used: VS.NET 2010, 2013

Front End: ASP.NET and C#

Back End: SQL Server 2008 R2

Infobahn application supports below major and high-level business process.

• Infobahn forms an essential component of BMW financials. eContracting uses Infobahn through data which originates from the dealer DMS. Alphera dealers use Dealer Track and Route One to submit credit apps or view decisions.
• Dealer submits credit applications to BMW FS for decisioning, one of the most important business processes supported in Infobahn.

o Credit approval is a pre-requisite to contracting with BMW FS

o Rate tiers are assigned during the credit decisioning process, and these rate tiers define the promotional rates available to the customer.

• Dealer validates the key contract information and submits for payment via Self-Serve Funding.
• Infobahn accesses external system namely Appro which is used to determine the credit worthiness of the customer.
• Dealer tracks their various portfolio, such as looking for new customer sales opportunities or ensuring that all lease end customers have been contacted.
• Dealers can generate payoff quotes.
• Dealers can perform Pre and Final Inspections.
• Dealers tracks their progress through PIA and Reporting.
• Dealers going through various bulletins published. Infobahn enables dealers to view bulletins to stay aware of applicable rate programs and policy changes.
• Dealers use Infobahn screens to manage users at their dealership.

In addition to the dealer-facing functionality described above Infobahn provides support for business processes used by internal users, including Dealer Security management and Bulletin publication.

My role in this project involves providing support to clients on issues or enhancements related to the application. It happens in onshore-offshore model where onshore coordinator understands the requirement and we develop accordingly. Following are the cyclic phases for each release which happens every quarter –

1. Requirement gathering and preparing requirement document for the TFS items.
2. Build phase where we code and check in. Do unit testing and upload them to the SharePoint site.
3. Integration testing once the items is deployed.
4. UAT phase where we work on the fixing of defects.
5. Production Deployment phase.

Post Production defects phase. In parallel, use to work on the requirement gathering for the next release items

Technology Used: VS.NET

Front End: ASP.NET and C# (.Net Framework 1.1, 2.0, 3.5)

Back End: SQL Server 2005, Oracle 8i

This project is based on downstream international of Shell and provides end-to-end application development, maintenance and support to clients based across Europe region. The applications are basically web based applications designed to upload documents or users in Livelink where a windows services are involved to perform these activities. The team provides support for application based on Java, .Net, SAP Netweaver, Livelink and Database support.

My role in this project involves providing support to clients on issues or enhancements related to the applications based on .Net (Framework - 1.1, 2.0, 3.5). I lead the .Net team in understanding the issues occurred or get a detailed view from the clients if any enhancement needs to be done and monitor regularly if all the applications are working fine. As a module lead I used to send a weekly status report of the tasks done. In HP service manager 7 (SM7) I used to assign the problem or incident tickets to my team members

Technology Used: VS.NET 2010

Front End: C# (.Net Framework 4.0)

Back End: Teradata

This is a service developed in C# and backend as Teradata to calculate the train loading for a railway network (MRT & LRT) for Land Transport Authority in Singapore. Firstly, different types of Route path has to be generated based on some algorithms like Floyd Warshall, Dijkstra, Graph Theory etc. –

1. Least Travel Time Path – A passenger reaching his destination station at Least travel time.
2. Least Interchange Path – A passenger reaching his destination station making least number of interchanges.
3. Return Path - A passenger going back 2-3 stations up to the terminal station to ensure a seat.

After these Route generations, passengers from the last day’s travel history, has to be allocated to these routes based on the following logic –

Route Allocation is the methodology for estimating the route taken by a passenger between 2 points (entry and exit), within the RTS network. The system does not know exactly which route was used by the passenger for a ride between a given Origin-Destination pair because the data points to capture this data are not available (we only have entry station id and exit station id but we do not have any way of tracking a passenger’s path within these 2 points). Based on the set of rules defined by the business user groups, the possible route set is generated and the passenger is allocated to a particular route. Route allocation is the process of allocating a train ride to a set of possible routes.

Finally Train Ride Information is calculated through some reports based on parameters like originstationid, destinationstationid, directionid, line and for a particular time range –

1. Passenger per direction
2. Daily Train Loading
3. Passenger per direction per train
4. Daily Train Loading per train
5. Number of passengers boarding.
6. Number of passengers alighting.
7. Number of passengers making interchanges.
8. Number of passengers making transfer boarding.

Number of passengers making transfer alighting

Technology Used: VS.NET 2008

Front End: ASP.NET and C# (.Net Framework 3.5)

Back End: SQL Server 2008

This is a website which is actually an Administrator-Distributor-Dealer network for the transaction of BSNL products like recharge coupons, vouchers and powers. An administrator creates distributors and dealers under that particular distributor’s belt on his request. He can see all the transactions made by a distributor or a dealer. Here a distributor can make transaction to his dealer or any customer and the dealer can make transaction to the customers only. A dealer makes an order to his distributor for certain products irrespective of his stock. The distributor’s stock is maintained by the administrator. Distributor’s stock is being fetched from Axapta Database to SQL Server Database through a migrating tool. This tool is used whenever some record is required to transfer or to fetch from Axapta Database to SQL Server Database. If the product ordered by the dealer is in distributor’s stock, he can deliver the product. All the records of security codes of BSNL top up coupons or serial numbers of any product sold by a distributor or a dealer is maintained here. They can export the security codes or serial numbers to an excel file.

Apart from this, the BSNL transactions can also be made through WAP application and the records are maintained in the portal. An exe made by socket programming is made to run in the Enhancement server. Here a dealer or distributor enters a mobile number and recharge value and the exe does rest of the work. They can also check the status of any recharge by a mobile number or the date of transaction.

Roles & Responsibility: UI Designing, Coding, Publishing the site in client’s server