Login
English - United Kingdom
Home
Job Search
My JoinVision
Statistics
InfoWorld
Entrepreneur
HR Products
Expert Profile: pchopra
Profile title:
Oracle PL/SQL Developer
JoinVision-ID:
pchopra
Citizenship:
India
Year of birth:
1979
CV
INFORMATION TECHNOLOGY PROFESSIONAL
Expertise In: Oracle PL/SQL Application Development/Maintenance
Role Sought : database professional interested in working as Oracle Database developer
UK Tier 1 General Visa Holder (HSMP)
Experience in the analysis, development and maintenance of business applications.
Sound knowledge of ORACLE Database, PL/SQL Engine Architecture.
Experience with Oracle 8i, 9i, 10g, 11g, working as Oracle Developer and Oracle Consultant, developing back-end modules, such as packages, functions, procedures, triggers, views, materialized views, both Data Warehouses and OLTP systems, in SQL and PL/SQL.
Good knowledge of key Oracle performance-related features, such as cost-based optimizer, execution plans, hints, indexes, partitioning, temporary tables, v$-views.
Good exposure to routine tasks, such as management of users, roles, privileges, schema and objects, developing PL/SQL triggers for user access audit. Experience in data loading, export/import, providing technical support to Oracle users
Well Conversant with Data warehousing concepts and terminology.
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, Oracle 9i/10g/11g, Merge, Multitable Inserts, PL/SQL Warnings, Conditional Compilation, TKPROF, SQL Loader, Explain plan,Oracle Partition management, Index Management, OEM, TOAD, SQL Navigator, PL/SQL Developer, SQL Developer, DBArtisan, CVS, SVN, Putty, Windows, Unix.
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
Project Details
Project Name
Rcube
Client
American Express, Gurgaon
Role
Senior Oracle Developer
Organization
Satyam Computer Services Limited, Noida
Duration
06/2010 – 11/2010
Contribution
Here I participated in back-end development Reports – De-normalizing the tables to get obligor view as per
Project requirements. This system allows business leaders complex reports high-volume Data
warehouse that gets populated on monthly basis with time over reports.
Model and Object creation and performance tuning.
Change Request Development and troubleshooting user request.
Data transformations, conversion and interface, data loading
De-normalizing the tables to get obligor view as per project requirements
Developed back-end logic for business applications, e.g. views, procedures/functions, triggers.
Usages of External Tables / Partitioned Tables / Materialized views.
User Creation and privilege management. Self service DBA.
Code migration from Development to Production.
Project Name
CFD Trading - .ComDirect
Client
CommerzBank, Germany/Hyderabad
Role
Senior Oracle DW Developer
Organization
Satyam Computer Services Limited, Germany
Duration
01/2010 – 05/2010
Contribution
Conversion of LDM to PDM, PDM to schema and creation of Database
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 trading system environments.
Usages of External Tables / Partitioned Tables / Materialized views.
User Creation and privilege management.
Preparing System for UAT.
Code migration from Development to Production.
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 University
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.
preview of the first page of the CV
Experience Profile
Field of activity
Experience [years]
Electronic
0.4
IT Organisation / Analysis
2.4
Marketing/Sales/Accountma...
1.0
Personnel Management
0.4
Project Management
0.4
Quality Management
0.4
Software Development
7.0
Systemadministration/Betrieb
5.5
Skill
Experience [years]
SQL
7.0
Oracle
7.0
Windows
7.0
PL/SQL
7.0
Education
6.5
Data Modeling
2.6
Marketing/Market Research...
2.1
MS-Access
1.7
PMP - Project Management ...
1.6
MS Office
1.5
Unix General
1.4
Linux
0.9
Career aspiration
Type of occupation:
Regular employee or Freelancer
available from:
01/02/2011 at 100 %
Desired position(s):
Co-worker
Desired field of activity:
Quality Management
Electronic
Systemadministration/Betrieb
IT Organisation / Analysis
Project Management
Software Development
Marketing/Sales/Accountmanagement
Personnel Management
Mobility:
middle
Assignment location:
Austria, Belgium, Czech Republic, Denmark, France, Germany, Greece, Ireland, Luxembourg, Netherlands, Norway, Poland, Spain, Sweden, Switzerland, United Kingdom