INFORMATION TECHNOLOGY PROFESSIONAL
Expertise In: Oracle PL/SQL Application Development/Maintenance

Experience in the analysis, development and maintenance of business applications using Oracle 9i/10g/11g.
Sound knowledge of ORACLE Database and PL/SQL Engine Architecture.
Possess expert skills in the development of applications utilizing Oracle tools including Oracle PL/SQL, SQL Plus, SQL Loader, and experience with PL/SQL back-end programming - Database Triggers, Packages, Stored Procedures, Functions, and Management of Schema Objects.
Experience in using Linux/UNIX platform commands.
Beginner to Intermediate level DBA skills. Familiar with Data Dictionary views (V$views, DBA_xx views etc...). Installed Oracle 9i/10g database on Windows and Linux. Creation and maintenance of Tablespaces, Datafiles, Users, and Profiles etc. Good understanding of Backup and Recovery procedures and database tuning. Experience in Data loading using SQL Loader, Export and Import utilities.
Worked with query tools like Toad, SQL*Plus, SQL Developer.
Ability to quickly learn new tools, concepts and environment.
Ability to work in fast paced environment and meet deadlines.
Excellent communication and interpersonal skills, with the ability to manage responsibilities individually or as part of a team environment.
Ability to explain technical concepts and communicate with users and system administrators at all levels.

Technology Snapshot : SQL, PL/SQL, Mod PL/SQL, APEX, Oracle 9i/10g/11g, Oracle Discoverer, Oracle Discoverer Plus, TOAD, SQL Navigator, PL/SQL Developer, SQL Developer, DBArtisan, Windows, Unix, Linux


Education
S. No.
Degree
University
1
M.Sc (IT)
Punjab Technical University
2
B. Com
Delhi University

Trainings
S. No.
Title
Organized By
1
Oracle 9i SQL
Oracle Corporation
2
Oracle 9i PL/SQL
Oracle Corporation
3
PMP
Satyam Computer Services Limited
4
Oracle 11g DBA
Wilshire Software Technologies


Project Details

Project Name
Matsushita Global Transaction System(MGTS)
Client
Panasonic Marketing Europe, Germany/Hyderabad
Role
Project Lead/Senior Oracle Developer
Organization
Satyam Computer Services Limited, Germany
Duration
09/2008 – 10/2009
Contribution
Data Conversion.
Change Request Development and troubleshooting user request.
Data transformations, conversion and interface, data loading, database modeling.
Oracle Back-end PL/SQL Development i.e. Packages, Stored Procedures, Functions & Triggers.
Inter-relation of different system environments.
Usages of External Tables / Partitioned Tables / Materialized views.
User Creation for different Environments.
Preparing System for UAT.
Code migration from Development to Production.
Implementation and user training.

Project Name
Vendor Information Processing System (VIPS)
Client
Credit Suisse, Singapore
Role
Senior Oracle Developer
Organization
Satyam Computer Services Limited, Singapore
Duration
10/2006 – 5/2008
Contribution
Senior Developer to Team Lead functions.
Review of functional specifications.
Balancing stakeholder needs and requirements.
Coordinating with front end and testing team.
Installation of Oracle Database on Windows.
Converted data from legacy system to Oracle using SQL*Loader and PL/SQL programs.
Data transformations, conversion and interface, data loading, database modeling.
Oracle Back-end PL/SQL Development i.e. Packages, Stored Procedures, Functions & Triggers.
Ongoing maintenance & support.
Appreciated in CS Hall of Fame newsletter for revamping complete application and delivering it within highly constrained timeline .

Client
Oracle Sales Force
Role
Software Engineer
Organization
Oracle India Private Limited, Bangalore
Duration
09/2005 – 09/2006
Contribution
Complete ownership of the project.
Getting the documentation of the application prepared.
Planning, work allocation, tracking.
Development using SQL, PL/SQL, HTML, Oracle Application Express, Oracle Discoverer.
Created SQL*Loader scripts to load data from external system to oracle.
Responsible for creating complex views for EUL of Oracle Discoverer.
Responsible for developing new reports using Oracle Discoverer Desktop/Plus.
Responsible for modifying/creating Business Areas using Oracle Discoverer Admin.
Developed PL/SQL (Stored Procedures & Packages) for implementing complex business logic.
Patching process across servers.

Project Name
Sales Order Processing System
Client
Delve Software Infotech
Role
Team Member
Organization
Delve Software Infotech
Duration
01/2005 – 08/2005
Contribution
Develop the database Tables.
Design/program GUI for all the modules. Programming all necessary validation checks using PL/SQL.

Project Name
Ad Tracker
Client
Advertisement Department
Role
Team Member
Organization
The Hindu
Duration
04/2004 – 12/2004
Contribution
Understanding the system requirement to formulate database design.
Design & program the GUI for all the Forms.
Programming all necessary validation checks.

SSI                                                                       
Responsibilities
Developing course competencies and outlines.
Hiring and evaluating adjunct and contract faculty.
Teaching a wide range of technical courses.
Teaching co-faculties under Faculty Professional Upgradation programme.
Creating and Conducting programme certification exams.
Head of CA foundation mandatory Computer training.

Courses Taught
Oracle 9i:  Introduction to SQL.
Programming in HTML, C, and JavaScript.
Object-Oriented Programming in Java.
Programming With Visual Basic 6.
E-Commerce Fundamentals.
Working with Ms Word, Ms PowerPoint and Ms Access.
250 Hour Mandatory training as instituted by Institute of Chartered Accountants of India.