Download PDF

With 5 years of programming experience in Oracle PL/SQL to Analyse, Design and Implement Business Applications using the Oracle Relational Database Management System (RDBMS). Involved in all phases of the SDLC (Software Development Life Cycle).  Expertise in Dynamic SQL, Collections and Exception handling. Knowledge of key Oracle performance related features such as Query Optimiser, Execution Plans.  Also experienced in ETL techniques, Analysis and Reporting. Autodidact in SSIS, Informatica & UNIX. Excellent communication, interpersonal, analytic skills and strong ability to perform as part of a team. Oracle certified associate in PL/SQL programming.

Work History

Jul 2015Present

Connect StoreApp Operations

 TATA CONSULTANCY SERVICES

Synopsis: Relevant maintenance of the application and managing the team from Onsite

Key Responsibilities

  • Support & maintain the developed applications
  • Drive regular cross vendor meetings to analyse and understand any gap
  • Provide on the spot resolutions to major incidents in order to mitigate any business impact
  • Gather requests from business users and assign them to the offshore teams with relevant priority 
  • Co-ordinate & represent changes to the change council 

Achievements: Client & inter Vendor appreciations for dealing the issues and managing the client efficiently without any escalation. In order to reduce the client's effort on monitoring, I have proposed a system which will holistically provide an overview of all the applications currently in place and will send notification automatically to relevant stakeholders. This idea has been appreciated by the customer and is now being worked upon.

Jan 2014Jul 2015

Connect StoreApp Development

Tata Consultancy Services

Synopsis: In order to embrace the advantage of the information technology and to improve the business model, ASDA (client) was all ready to digitize their existing logistics system under the brand name Store Connect. It allows ASDA to receive & manage parcels in store and dispatch it to the customers with minimum effort via a handheld mobile device. Performance of the application was set on top priority.

An application of this caliber is unprecedented in the UK retail industry.

Key Responsibilities:

  • Understanding the application to be developed by regular meetings with the business architect, users and analysts.
  • Propose solutions to the challenges faced either technically or via change in process
  • Design data models and develop 'proof of concepts' to address specific business requirements.
  • Application database performance management

Achievements: Developed a system which replaced google API for locating ASDA stores in an area. This has reportedly generated huge profit for the client. ASDA has appreciated this effort and acknowledged it by an appreciation certificate. TCS provided  'On Spot' award for the dedication & commitment to the work. 

Aug 2013Dec 2013

International Sales and Stocks

Tata Consultancy Services

Synopsis: International Sales and Stocks (ISS) was developed for Marks and Spencer's (client) which provides overall business insights on sales and stocks in areas like Merchandising, Food, Petroleum for countries outside United Kingdom.

Key Responsibilities:

  • Gather business flow information and design data from data architect
  • End to end testing from data loading to the reports generation
  • Proper documentation of the self designed automated testing procedures
  • Regular client meetings to understand any requirement and also to discuss on areas for improvement

Achievements: Many team appreciations. Awarded by client (Marks & Spencer's) recognizing my efforts to automate the testing.

 Sep 2012Aug 2013

General Store Merchandising

Tata Consultancy Services

Synopsis: General Store Merchandising (GSM) deals with stock management for Co-Operative (client). It defines the stock value in the system segregated under two categories, which are 'Store' and 'Warehouse'. The location, arrangement of the stocks within the store are also managed through GSM. It is the upstream source to many other applications which forms the SMART system developed for better retail management.

Key Responsibilities: 

  • Analysis of data models and design the solution
  • Develop codes to cater the business requirements and test them with valid data
  • Delivering presentation of the application developed to the Support team
  • Understand and document the issues & challenges faced

Achievements: One of the few billed resource for client. Published paper in TCS on ORACLE PL/SQL best practices.

Oct 2011Aug 2012

Stock Exit Management

Tata Consultancy Services

Synopsis: Working with Co-operative (client), the business required to develop a system that could manage the sale of the products which are near to their expiry. Based on proper analysis, forecast and threshold calculation, discounts are generated on the 'near to expire' products thus promoting faster sell of those products.

Key Responsibilities :-

  • Develop the codes to cater the design requirements
  • Conduct performance tests to optimize the application for best service and operation
  • Interaction with clients regarding delivery procedures  and change requests
  • Business documentation
  • Provide a walkthrough of the developed codes to the support team

Achievements: Gained knowledge on tuning database codes through hands-on.

Jun 2011Sep 2011

National Scholarsip Program

Tata Consultancy Services

Synopsis: National Scholarship Program ( NSP ) was an initial learning project at Tata Consultancy Services (TCS). 

Key Responsibilities: 

  • Understand the SDLC phase and implement them accordingly.
  • Deliver presentations on multiple solutions proposed to a problem.
  • Business documentations and assigning the work to the team members
  • Routine team meeting to discuss and overcome any challenges faced

Achievements:  On successful completion of the project, it garnered quite a positive feedback from everyone.

Skills

Databases:

  • Oracle 10g 
  • Oracle 11g 
  • Microsoft SQL Server 2012 (Beginners)
  • DB2 (Beginners)
  • PLSQL
  • Triggers, Partitioning
  • Query Optimzation

Data Modeling:

  • OLTP logical Data modelling
  • OLTP Physical Data modelling
  • OLAP Housekeep Data modelling
  • Aware of Ralph Kimball's Data Modelling

ETL Tools:

  • SSIS
  • Informatica

Java

  • OOPs concept
  • JDBC

Operating System:

  • Basics of UNIX

Reporting Tools:

  • SAP business objects

Certifications

Dec 2014Present

Oracle Certified Associate in PL/SQL programming

Oracle
Feb 2015Present

Advanced Retail Business Management

TCS business academy

Education