Kumar Rajat Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

• Evaluated customer requirements and formulated the necessary specifications, followed by the design, testing, and integration of solutions.• Established project priorities, set key milestones, defined deliverables, and determined the criteria for success.• Calculated effort estimations for proposed changes, conducting thorough analyses to guarantee on-time completion.• Performed Business Analyst (BA) reviews throughout the development phase to maintain alignment with the intended functionality and addressed any Functional Specification (FS) queries.• Administered risk management, monitored project dependencies, and proactively addressed obstacles to maintain project momentum.• Orchestrated team releases, ensuring compliance with release protocols for seamless deployment.• Identified gaps in the Functional Specifications and maintained a tracker for clarifications to establish a precise scope for upcoming releases, committing to the agreed timelines.• Monitored the resolution of development-related bugs in accordance with the release schedule.• Conducted code reviews for completed tasks and evaluated proposals for new feature enhancements.

Bangalore

• Understanding customer requirements and managing deliveries end to end.• Design, development and support are some of the high level activities as part of my role.• Documented technical challenges faced in all phases and placed them in SVN for reference, reducing resource dependency.• Initiated reusable component development and rendered KT sessions for new technologies.• Helping team members in case of technical difficulties.• Debugged calls in UAT instance for Issues and Demos for module progress.• Analyzed RCA and Impact Analysis every day and considered the next steps.• Interacted with businesspeople/SMEs on support-related issues and new enhancements.

Bengaluru, Karnataka, India

PROJECT: SYMPHONY GOLD• Technology: SQL, PL/SQL and Shell script• Project Description:o GOLD provides global optimization for all channels with an agile, integrated supply chain and customer-driven fulfillment network. It provides replenishment and allocation strategies and execution which optimizes your inventory levels, supply chain and logistics to support a customer-driven service delivery model – minimizing capital spend and decreasing operational costs.• Responsibilitieso As part of GOLD, handled concepts like purchase orders, Transfer, Allocation and Distribution, ASN, GRN, Inventory Adjustments, Creation of Warehouses, Return to WH, Replenishment, Master Data (includes Item Creation, Store Creation, Supplier).o Involved in database activities in writing complex SQL queries, PL/SQL Procedures, functions to handle new changes in Staging data Master Data Inbound data Outbound datao Involved in the development of CR’s (Change Requests) received from Business Team to add new changes to the current system.o Involved in the critical production issues handling while supporting project individually.o Maintenance and support of customized GOLD module.

Bangaon Area, India

Bengaluru Area, India

PROJECT: RISK MANAGEMENT• Technology: SQL, PL/SQL, Extjs , HTML, JavaScript, Jasper, Fusion chart, MetricStream Appstudio• Project Description:o The Risk Management is the process of identifying, quantifying, and managing the risks that an organization faces, as the outcomes of business activities are uncertain, they are said to have some element of risk, these risks include strategic failures, operational failures, financial failures, market disruptions, environmental disasters, and regulatory violations.o The Risk Management application provides a comprehensive approach to identify potential risks and a powerful framework to evaluate and assess them based on various factors on a periodic basis.• Responsibilitieso Involved in database activities in writing complex SQL queries, PL/SQL Procedures, functions to Handle Risk Management Solution workflow. In creation of Risk dashboards that use risk heat maps and color-coded charts to provide increased visibility into the bank’s risk profile across the enterprise using HTML and JavaScript. In creation of risk reports that allow for comprehensive tracking and reporting of Risk status, business action plans and changes in risk rating over a specific period of time along with all above activities.o Designed and created front end forms using HTML and scripting using JavaScript.

Bengaluru Area, India

• Expertise in writing complex SQL, PL/SQL Code (Procedures, fucntions, triggers etc.) • Creating and Maintaining Oracle Database • Performance Tuning and Health Monitoring • Expertise in Oracle Import/Export • Writing scripts to automate work (Batch files)