I am a seasoned Database engineer looking to be a part of a challenging environment where I can learn, upgrade my skill sets and contribute towards the organisational goals, thus ensuring personal and professional growth.

Professional Summary:

• 7.5 years of industry experience in all stages of SDLC including requirement analysis, design, coding, testing, implementation and technical support.
• Extensive working knowledge on SQL and PL/SQL packages, stored procedures, functions, triggers, advanced queues and DB jobs in client-server architectures as well as web based environments.
• Strong hands-on experience on database performance tuning in Oracle.
• Thorough knowledge on RDBMS concepts and expertise in relational databases schema design and modeling.
• Proficiency in UNIX commands, shell scripting and batch scripting windows .
• Working knowledge on MPP database like Netezza.Good understanding of data warehousing and BI concepts with an excellent grasp on Business object reporting.
• Excellent functional knowledge on multi channel Retail E-commerce Order management system OMS , tracking, fulfillment and payment processing systems .
• Understanding of ITIL processes and experience in handling production issues with defined SLA.
• Good analyzing, designing, programming, debugging and troubleshooting capabilities.
• Experience in leading teams at offshore and onsite with successful project deliveries.
• A quick learner, team player and problem solver with good interpersonal skills.

Technical Expertise:

Professional Experience:

Retail Corporate Applications.

Project description:

Gymboree has over 10 different systems to support various departments like planning, sales, finance, tax, fraud, customer service and HR etc. Some of them are in-house and some are third-party systems. Major applications include Retail Merchandising System RMS , Sales Audit, Customer Relationship Management CRM , Loss Prevention, Data warehouse, Axiom, TRECS, and KRONOS etc. These applications are based across a wide variety of platforms like Oracle/Unix, Macros and windows applications in Java / dot net.

Role Responsibilities:

• Developing new packages and scripts to implement new business requirements Creating reports in Business Objects for business users to help drive their decision making.
• Working on the integration of new modules/applications with the existing ones.
• Provide support to business users of the above applications, interacting with business on a day to day basis when issues are identified and help to drive those issues to closure.
• Analyzing the existing system to identify jobs which can be fine-tuned for better performance either through rewriting the code or through server upgrades.
• Working with vendors to apply patches and to perform upgrades for the third party applications within Gymboree IT.
• Working with the other project teams to help in development and integration testing of new features to the Gymboree.com website.
• Hosting monthly and quarterly maintenance activities in the various systems
• Automating several manual processes using oracle PL/SQL and shell scripts to reduce the turnaround time for business.

Confidential

Project description:

Walmart.com CPE Continuous Product Engineering team was handling the web based ecommerce platform for Wal-Mart retail business. This involves all stages of the order processing lifecycle starting from order creation to fulfilment and payment processing. Different sub- modules are Order management system OMS , Payment Processing, Inventory supply chain, fulfilment etc. The project follows the onsite-offshore model, which supports the existing application as well as works on new enhancements proposed by the business teams.

Role Responsibilities:

• Frequently interact with end users and business managers for understanding new requirements and propose better solutions to them.
• High level analysis of the change controls and providing the estimation for those. Providing the fix implementation for the existing bugs and also the enhancements for any new functionality requested by the end users.
• Feasibility study and risk assessment for the new change requests
• Worked on the performance improvement of various backend processes.
• SME for Order Management System OMS
• Coordination among different project teams. Helping team members from technical as well as functional aspects
• Leading a team of 4-5 offshore resources and managing their tasks and utilization.Continuously work with senior management for different process improvements.

Confidential

Project description:

• The project consisted of support and enhancement of the 10 identified applications in IKEA US which include taking order from customers, tracking of orders, forecasting of market, maintaining stocks of warehouses distribution terminals and declare the inventory to customs departments of various countries. Major applications were:
• DIANA is a CPI Central Point of Information , used to collect and consolidate information transactions between systems.
• GRNA Goods Requirement North America handles forecasting, buffer stock calculations and outbound steering labels plan codes .
• GEMINI is a warehouse application that handles orders, inbound and outbound shipments. Data flow between different systems/applications is managed by IDRS IKEA Data Routing System which was serving as the back bone for whole project. Objective of the engagement was: Improve level of service fulfilment with better Quality achieve lower operational cost through efficiency operational scalability. Preventive Maintenance through enhancements required for legal compliance, growth or user needs.

Role Responsibilities:

• Preparing functional and technical documents of various applications. Involved in providing estimation for different Change requests.
• Analysis, design, coding and testing for the major enhancements with impact analysis.
• Peer code review.
• Identifying bugs in existing system and Root cause analysis RCA .
• Preparation of test cases and relevant test data for some of the change requests.
• Performed integration testing and system testing for different modules I worked for.
• Distributing daily tickets among the team members and incident solving.
• Tracking the status of incidents being worked upon and their SLAs.
• Provided training to new team members and guiding them on functional as well as technical aspects.

Confidential

Project description:

The Supply Chain Matrix SCM system enables the IKEA users to manage and visualize the supply chain set-up in a flexible and simple way. It is mainly used to provide the replenishment solution for the people working with the supply of goods flowing from suppliers to distribution centre DCG which is called Inbound Steering Priority ISP and from distribution centre to stores and CDC's which is called Outbound Steering Priority OSP . IKEA retail business gets the following key benefits by using SCM. SCM enables general management, planning, optimization and follow-up of all orders and deliveries.SCM is one common source for supply chain set up. It avoids conflicts in decision making and reduces the time and cost spent in resolving conflicts. Flexible supply structures facilitate the increasing volumes in the Supply-Chain.

Role Responsibilities:

• Involved in designing relevant database objects e.g. tables, views, triggers, synonyms etc.
• Wrote stored procedures, functions and packages for back end. Root cause analysis for the existing problems in the system.
• Supported existing application and worked on enhancements. As a team member handled the service desk.
• Knowledge transfer to new team members.