Sukhbir Singh

Aiming to play an energetic role in separation activities

Gathering information for applications on the roadmap from on-premises to cloud

Freight management from Customer to destinitions through in Depot and Sorting Operations Enhancing and maintaining applications encompassing customer data inception , Sorting on floor and Trak & Trace for visibility. All these applications are optimized for fast and cost effective operations. Applications support freight journey for domestic as well as international customers.

Reverse Engineering - Current team is managing more than 20 applications, some of which were developed by old teams. These old applications have limited or sometimes no updated documentation. Always volunteers in understanding design of such applications and suggest team with solution. Created detailed technical documentation for many older applications for migrating their functionalities in new Digital Solutions like MyToll. At times when there are critical production issues and no code is available, reverse engineered binaries, persisted code in repository and fixed the issues. Created comprehensive documentation to get confidence of Operations.

Integration with MyToll on AWS Stack - My Toll is company's digital presence which combines track trace activities under one umbrella for many subdivisions. It involves uploading of relelevant data for individuals divisions to Amazon’s S3 buckets. Data is furtner processed by Apache Storm, AWS Kinezis before it gets persisted in EMR. At times, during development of a functinaslity utilize Splunk and Hbase layer for solution verification and design.

Load Planning Advice - Was seconded to Toll IPEC for creating solution to record track material and vehicle movement. The solution comprises of a web based Single Page application, integration with Legacy Linehaul application and creation of Gate House applications for Security. The application is responsive and is supposed to be used on tough IPads mounted on Fork Lifts.

Sorry We Missed You - Whenever a delivery is missed by Toll driver due to unavailability of customer a Card is left at the customer’s location. The card guides the customer to open an online application and choose a redelivery option as required by customer. After all data input customer gets a Service reference number which can be used to liaise with Toll Priority if required. Application architecture consists of a responsive UI plus email windows service and a schedule consoled application to process failed CRM requests. Application also helps customer with prepopulating data with the help of event tracked by Mobile Data Terminal (MDT).

Customer Portals - Developed an online portal as required by an Enterprise Customer for aid their Supply Chain Management. Customer is able to use the portal for selecting a Predefined service. System integrates with Billing system, Toll Fast for their services and SIEBEL CRM for booking Pickups. The system is mostly data driven which have been successful to cater to rapidly changing market and Customer Company’s restructure.

Worked in various projects - Played key development role in Company’s present development applications which involved services for Vocational Education & Training department plus Department of Infrastructure and Transport.Challenge was to quickly understand the domain and hit the ground.

PETROL (Personal Trading Online) - Pursuant to the company’s Personal Investment Policy, all employees are required to disclose to the firm any employee or employee related brokerage accounts. Furthermore employees are required to obtain pre-approval before doing any trade whilst in the employment of Nomura. Web application is used by compliance and employees based on their roles. Comprehensive notifications will keep the employees, management and compliance on same page. At present 3 instances of application are there to cater UK, India an Asia Ex Japan regions. Complete revamp of application workflow is happening to support complex workflows in Asia region. System is to be integrated with lot of other systems like OTW(over the Wall), Permanent Insider data etc.

Compliance Management System (CMS) - The application allows Compliance to manage and distribute Watch List, Stop List related data. This also helps compliance to manage different OBA and OBI items. Such data is used extensively in Compliance world. CMS provides all such data to lot of other systems like (PETROL, OTW etc). Stop list created and distributed by system is very critical internally and externally due to regulatory reasons.

DataLegal - The primary purpose of DataLegal is to store derivative agreements(ISDA/CSA) made with Nomura’s counterparties and track any changes made to their status as they move from drafting through to confirmation. It has functionality to manage Legal Terms/Options, netting related data, jurisdictions for different Agreement Types. The system also facilitates data feeds to downstream applications. Scanned agreements are held on Documentum. The application gives data to Collateral management systems also.

Contracts Db - The application is used to store information of all Services related Contracts. The system facilitates renewal of such contracts by informing Business in advance. Vendor management and physical contracts management in Documentum is also provided. Scope of application has increased from UK to Global regions. India team is working on such enhancements so that application can be used smoothly in all regions globally.

Suite of ASIA applications supported( CODES, COMPMON, Business Trip Information)Provider Claim Management System - These applications were developed in ASIA region and will be supported from India. These includes Employee Affirmation, business trips information. One application is taking feed for Positions , transaction etc and displaying reports to users.

Establishment of Production Services in Wealth Management Reporting - Understood WMR (Wealth Management Reporting) application thoroughly which involves many subsystems like CRC(Client Reporting Configurations), IC (Investment Catalogue), PR (Performance Review), DC (Data Consolidation for actual deposits and withdrawals), AI (alternative Investments like Hedge Funds/ Private Equity), CR (Client Review for rendering actual reports and did knowledge transfer to Lehman India. Also covered Operation Tools used by middle office. Achieved required results in time even system were large in size and complex. Played an energetic role in getting run books/Ops Manuals created for Production Services. Established the department for Investment Management Division India from scratch. Analyzing and fixation of any daily issues encountered.

e-Delivery(Electronic Delivery Engine) - This application allows other application to send electronic deliveries of trade confirmations, state ments and other notifications. It gives the full track of mail for compliance purposes. It also allows client application signups for static messages and also allows dynamic mail contents through web service. It also provides a bridge for Mainframe applications for sending traceable mails. Internally it does track message deliveries by bounce messages/delivery receipts returned to a POP3 mail box and mail gateway logs. It also uses .NET remoting.

Reporting Applications (Quarterly Performance Report, Tactical Client Reporting, Client Portfolio Report) - This application serves the High Net Worth Clients for PIM and PAM world. Data is taken from a lot of upstream systems for actual trades, holding and performance. Reports are adhoc and periodic in nature.Consolidation, archival, distribution and version management are main features of the applications.

S-I-S-T-E-R 2(System of Information on strategy, Tasks and Evaluation of Results) Application Enhancement - This application manages the work flow for executing, planning and monitoring tasks by UNESCO. There are different hierarchies of dependent tasks which UN is executing in some country.This application was built in .NET 1.0. Now it has been up graded to .NET 2.0 with many enhancements.This application processes messages through MSMQ and also interacts with SAP. It is using MVC design pattern for presentation layer.We also have to provide offline functionality for field offices using smart client.

Provider Claim Management System - Provider Claims and Management Project involves building a software application to enable concerned Healthcare Company users to manage providers and process the claims those providers submit to the Healthcare Company. The project involves basic internal workflow management for providing such services as defining Insurers, Plans, and Providers, maintaining payable rates for each provider, adjudicating claims received from providers, and cutting cheques back to providers for services rendered (claims submitted). This is an N-Tier application on layered C# Architecture following OOPS. We are providing Web like interface in windows application. History and In-Progress data is managed like Internet Explorer. Every class is again encapsulated in Singleton. Application talks to data service through Web Services.

Practice Management System - This application deals starts with scheduling an appointment of a patient with a doctor and ends with creating a charge for the service which was delivered by the doctor. A patient can pay directly to the doctor or an insurance company can take care of the payment for the patient depending upon whether patient is having any insurance plan or not. This application is fully integrated with 2 other applications.

Clinical Desktop Application - This application is used by clinicians for making service notes, doing assessment, diagnosis, making treatment plan and many other customizable documents depending upon the need of the client. This application also works offline using Microsoft Smart Client. This has been implemented in application to enable staff work in non-network locations.

Global Quality Audit – Tracking System - System provides a Web Interface for Scheduling Audits of different Vendors. The system is a work flow between GQA, SMS Departments and Vendors. A Pre-Audit questionnaire is sent to vendor to Qualify for Audit as per Company Policies. After completion of this questionnaire by vendor and review by GQA (Global Quality Audit) Audit Plan is built by GQA Department and is approved by GQA or SMS Department. Then Audit is executed and objectionable points are mentioned in the Audit Report. The Audit is closed after the objectionable points are corrected by Vendor and Re-Audit is also scheduled at this time if required. During Audit Different alerts are raised by system through E-mail and complete tracking of Work Flow is done by the system.

Training Scheduling & Feedback System System - provides a Web Interface for Scheduling Normal /GMP Trainings as per Company Policies. System Owner Schedules the different Trainings and Invites for Nominations. Automatically a Mail is sent to respective Department Heads. They open the system and send the Nominations, then Final Schedule is sent to Chosen Participants (By Mail).It also covers Attendance marking and Trainees can also give their feedback.

RCCP (Rough-Cut Capacity Planning System)- System was designed as per Ranbaxy INDIA SAP System. It covers almost all the Pre SAP-APO functionalities like Integrated Planning Process a Production Resource Planning and Scheduling. This system was changed due to complete different SAP system configuration at Ranbaxy USA.

Crystal Reports - Designing and Scheduling Crystal reports with back end SAP. Reports cover mainly MM, QM and PP modules. These reports are scheduled and made available to User on mail or Internet, daily or last used as required.

Distribution Requirement Planning(a Supply Chain Management Tool) - Brief Description: A tool for International Marketing using Microsoft’s development tools (Visual Basic, MS Access, MS Excel) for installation. System will be interfaced with MS Excel to upload the input data. It handles of Multi country DRP through single run and DRP for all kinds of SKUs (India Products, Other country Products) Main Outputs are a) NRR – (Net Receipt Requirement) at the final stocking location. b) NDR – (Net Demand Requirement) on the stocking location before the final stocking location in the supply chain.

New Product Check List - New Product Checklist system has been designed to Plan and monitor the launching of New products for 4 next months and to monitor the activities of CFTs for each product as a separate project. It intends to replace the manual Excel Files. It Upload data downloaded from SAP. Masters are maintained in VB .NET module, User is given WEB Module for interaction in ASP .NET. All SAP data is pushed to SQL 2000 by Stored Procedures.

Work Order System - The system designed to minimize machine downtime allows the end uses to raise work request for maintenance department (electrical / mechanical/ civil and other service departments). The related department can view pending work requests to plan there action. Main outputs generated by the system include work permits, pending work request status, requests executed during the period, breakdown partial breakdown analysis.

MIOS(Material Inward Outward System) System - The system controls movement of General, Canteen and Contractor materials in company.Pending material reports and daily reports required by the security person are given by the system.

EHS (Environment /Health & Safety System) - The system manages Material Safety Data Sheets (MSDS), Safety Procedures for storing and transporting all products. This Information is punched by user or it can be imported from Doc, HTML files. All the MSDS and safety procedures are accessible to users by Intranet.

Inventory Tracking System - The system uses data from SAP R/3 database to keep track of each material (RM/FG/SFG) that contributes to company's total valuation of stocks. This system provides the drill down from consolidated figure at group level down to the particulars of a material that is contributing towards total stock/ undertest/rejection value. The system provides time/value trend analysis graphs.

Document Management System - The quality / production related documents including batch production records (BPR) for finished good (FG) , Standard Operating Procedures (SOPs) for each department , Standard Test Procedures (STP) and specifications for each Raw Material (RM) , Intermediate product and Finished Good (FG) testing , are initiated /revised , approved / reverted at multiple levels and implemented through this system. This three tier architecture contains business object at NT server with Exchange server 5.5 installed. This object is used to provide work flow for using Exchange server Message service via MAPI using CDO. Exchange server is used to replicate the messages generated by the application over WAN between different exchange servers placed at separate locations.

Attendance Recording system (ARS)- Processes data from attendance machine to provide daily late coming, early departure, absenteeism, swap errors, leave status and manpower reports. Attendance register, leave register, overtime sheet is printed and data for payroll is generated at the end of month.

Quality Monitoring and Compliance System - This system allows quality tests data punching for compliance with specifications and standard test procedures (STPs) for all raw materials, intermediates and finished goods. The specifications / STPs are checked and approved by documentation cell as per FDA norms. The salient features is line acceptance /rejection of batches, analytical reports based on historical amendments history, online documentation if quality control.

Production Monitoring and Compliance System - The system provides the interface for punching batch production record (BPR) for each batch produced. The BPR format containing all stages of production and instructions at each stage like temperature/ pressure / process time etc., can be printed by/ authority user (production supervisor) before starting the batch production. Duplicate printing requires approval from higher authorities after complete explanation in a documented form. The BPR format is also documented and carries signature of authority at each production stage. The system hence can be used to investigate the batch production failure.