PL/SQL Developer - 6 + Years
Resume:
Sandeep Kumar US H*B Visa
Phoenix, Arizona, USA 85027
Mobile: +1-623-***-****
+1-480-***-**** E-Mail: ****************@*****.***
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