Mukesh Kumar Upadhyay

Project name is BANCS Securities. TCS provides a platform for their institutional and Retail clients like HSBC Securities, Haitong securities, HDFC Securities for Trading in share market. This project has three modules. One is the Front End where dealers can Buy or Sell shares in Stock Market i.e NSE and BSE. Second is Backend called OMS (Order Management System) where we are validating the orders and maintain the latency of the order. Third is RMS (Risk Management System) this is Data Base module where all the transaction and master data are stored.

• Worked as a Module lead of Order Management System(OMS). I had 5 members in my Team.
• OMS developed in Pro C and ORACLE 19 c.
• Adding new features which are raised by either stock market i.e. NSE or BSE or client requirement.
• Adding/Modifying code based on requirement with maintain latency of the order.
• Working on PR raised by QA team.
• Working on Production issue raised by Clients. Direct interaction with client to investigate production issues.
• Working to set up client-side SIT, UAT and Production Environment including Linux DB migration and Installation.
• Having 2+ years of experience as an Onsite person.

IKEA is a Swedish multinational conglomerate that designs and sells ready-to-assemble furniture, kitchen appliances, decoration, home accessories, and various other goods and home services. This project is part of IKEA name is DWP (Dimension Weight and Packaging). In this project we do calculate the lowest Rate, Type of Packaging and Handling cost of Products.

• Creating various DML and DDL statements using Oracle PI/SQL and SQL.
• Modified existing programs by writing appropriate C modules to add new functionalities in software to enhance the product as per client requirements.
• Developed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• Tuned some existing queries using Hints to improve execution time of the queries.
• Provided user training and production support. Improved the performance of the application by rewriting the SQL queries.
• Writing scripts using SQL, PL/SQL, stored procedures, functions and packages.
• Writing and modifying packages to fetch complex data from different tables in remote databases using joins and sub queries

It's a Multifunctional Printer produced by XEROX Corporation capable of performing photocopy, print, scan to email, finishing and fax functions for the users. These Printers are capable of processing various sizes of papers with a maximum speed of 35-90 pages per minute (ppm). The five major components involved in the software are the User Interface (UI), Copy Controller (CC), Network Controller (NC), Image Input Terminal (IIT), and Image Output Terminal (IOT).

• Doing code level analysis to fix the bugs of Xerox machine.
• Developed new features in Network controller and maintenance of existing features and bug fixes in NC module.
• Simulation and root cause analysis and fixing the customer defects
• Documenting BRD (Bug Resolution Document) of my Analysis and code changes used tofix the defect.
• Writing and implementing Test scenario and Test cases.
• Unit testing of defects is fixed to verify the functionality and performed the Release testingfor delivering the releases to the customer.
• Resolving issues logged by testing team during Unit/Integration/Sanity/Regression Testing.
• Following Agile Scrum methodology for development.
• Participate in review meetings and status update to client.
• Understanding and information gathering on various aspects of defects.

MetLife is the holding corporation for the Metropolitan Life Insurance Company. It has many Policies for different age groups. Based on the policies, we had to develop the validations and calculation, after that we had to put the data on server for other Applications. It has three Major components: one is Front End (UI), Backend for data validation and calculation and third is Data base.

• Modified existing programs by writing appropriate Pro C code to enhance the product as per client requirements.
• Debugging written program code to identify bottlenecks and bugs, and devising solutions for those modules to make it error-free
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Coordinated with team to design, develop, compile, and execute the programs to meet client expectations, and completed projects within deadline
• Assisted to prepare technical documentation and user manuals for various software products for the clients to ensure they face no difficulties in operating it.
• Worked on preparing Production, SIT and UAT environment.