Sandeep Kumar US H*B Visa

***** * **** ***. ***#*066

Phoenix, Arizona, USA 85027

Mobile: +1-623-***-****

+1-480-***-**** E-Mail: acsvnn@r.postjobfree.com

Seeking technical & managerial assignments in Oracle PL/SQL Development with a growth oriented organization in IT Sector.

CAREER ABSTRACT

Oracle Professional with around 6 years of qualitative experience of Application Development with Oracle PL/SQL. Currently designated as Sr. Consultant with NTT Data Inc.

Over 6 years of experience as an IT Professional with Business analysis, System Analysis, Design Architecture, Development/Coding, Testing in the Hospitality Domain.

Over 3 years of experience in leading, coordinating with teams in an Onsite-Offshore model.

Proficient in managing functions pertaining to design, development, testing & implementation of various applications. Well versed with the following technologies, Tuning & Programming skill on Oracle RDBMS (9i, 10g and 11g), SQL, PL/SQL Procedures, Function and Package writing.

Live Production & UAT experience at the Client Site & also designing and implementation of Migration Process.

Adept at mapping client’s requirements, custom designing solutions & troubleshooting for complex software related problems.

Extensively worked through the phases of Software Development Life Cycle (SDLC): analysis, design, development, testing, implementation, enhancement and Maintenance.

Sound experience in writing Functional Requirements, Design documents, programming specifications, Unit Test.

Extensively involved in Production Support (24x7) and fixing the problems.

Strong technical background and excellent interpersonal skills with an ability to interact with individuals at all levels.

SKILL SET

FUNCTIONAL

Exposure on Hospitality Domain, Working with Best Western International.

Interacting with users for system study, requirements gathering, analysis and testing of system.

Undertaking design & development, testing, debugging and troubleshooting of the application.

Provide post-implementation, enhancement & maintenance support to client for application / software.

Define best practices for project support and documentation.

TECHNICAL

Operating Systems

Windows XP/2000/NT/98/7/8

Client Server

PL/SQL Server Pages

Programming Languages

Oracle SQL, PL/SQL, SQR, HTML, Shell Script, Perl Script

Databases

Oracle 9i, 10g & 11g.

Package

Pl-SQL Developer, MS Office.

Version Management

Star Team, SVN

Other Tools

MS Office, ITSM, Application Manager (APPWORX) UC 4

PROFESSIONAL QUALIFICATION

Sl. No.

Degree

Branch

Year of Passing

Name of the College

1

B.Tech

Information Technology

2008

Amity University

2

HSC

2004

Lucknow Public School

3

SSC

2002

St. Paul’s School

EMPLOYMENT SCAN

Current Organization : NTT DATA Inc. (Formerly Keane India Ltd.)

Period : Since 04-Dec-2009.

Designation : Sr. Consultant

PROJECT DETAILS

Project Name

Client

Best Western International

Project Description

Best Western has over 4,000 independently owned and operated hotels (2,400+ in the US), making it the world's largest hotel brand by number of rooms. Hotels sport its flag in about 80 countries. Best Western is organized as a not-for-profit membership association, with most of its sales coming from monthly fees and annual dues. The primary business drivers support reservations, brand, quality standards, and various systems for member properties. NTT DATA has been providing maintenance and development services for business-critical systems at Best Western since 2005 utilizing the global delivery model

Environment

Oracle 11g, PL/SQL, SQR, PSP, PL/SQL Developer, Star Team, Winscp, Application Manager (APPWORX), FRS (Front Range IT Service Management), Perl Script, KSH

Duration

From (mm/yy)

12/09

To (mm/yy)

Till date

Role / Responsibility

Incident, problem and change management

Tasks management, managing on-shore and off-shore teams

Played a very critical role in managing the application projects for longer duration and received multiple appreciations from both the business and technology leadership teams.

Responsible for the deliverables to the customer.

Proactively identified the processes costing lot of CPU time and installed fixes as part of the demand management initiative.

Responsible for creating problem tickets metrics, weekly and monthly status reports.

Work on tasks involving identification of impacts likely to be caused by proposed enhancements by the development projects

Technical Support to team members and quality control activities. When required got involved in resolving the critical production maintenance issues where the impact was global across multiple upstream and downstream applications.

Transferring the files from UNIX server of client. Connect to third party servers and verify the files status at their end.

Involved in Post Implementation Support and Maintenance.

Involved in architectural approach and prepared business required solutions.

Resolution of queries for Business, Users and Operations

Involved in planning, application design and worked closely with Business partners and System Architects

Prepared technical specifications and high level design documents.

Resolved incidents within defined SLAs and moving them to Quality center if any code change required, send analysis to BAM

Creating new Batch Jobs for scheduling any new SQR, PL/SQL or Perl scripts

Involved in reviewing the design, code changes and test plan

Contributions

Senior Tech Lead

Team Size

15

PERSONAL DETAILS

Date of birth : 28-Oct-1986

Father’s Name : Mr. Prem Kumar.

Marital Status : Married

Nationality : Indian

Languages : English, Hindi

VISA : US H1B Visa

DECLARATION

I certify that above mentioned information is correct to the best of my knowledge and nothing has been concealed.

Date… (Sandeep Kumar)

Contact this candidate