SUMMARY

• 6.5 years of experience in analysis, design, development, implementation and maintenance (Complete software development lifecycle) of Oracle database software in the Client/Server environment on UNIX & Windows NT/2000 Platforms.
• Highly proficient in writing Optimized Stored Procedures, Stored Functions, Database Triggers, Packages using PL/SQL and SQL.
• Expertise in using Oracle PL/SQL Collections (Associative Arrays, Varrays and Nested Tables), Performance enhancement using Bulk binding, bulk updates, bulk collect and short circuit evaluation techniques.
• Logical and physical data modelling. Experienced in Dimensional Data Modeling and Entity Relationship Modeling. Rich experience in Normalization and De - normalization techniques.
• Responsible for Oracle 9i, 10g logical and physical database design, implementation, and maintenance on Windows NT and UNIX Sun Solaris.
• Expertise in Oracle query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF, Hints and dynamic performance views provided by Oracle. Perform data intensive tasks using Parallel queries. Materialized views, query re-write and creating and maintaining indexes etc.
• Hands on experience on using Automatic SQL tuning, SQL Tuning advisor, SQL Profiles.
• Oracle Advanced Queuing. Setting up the queuing environment, starting the enqueuing and dequeuing.
• Partitioning (including Composite Partitioninig) to increase performance, enhancing manageability and scalability.
• Enforcing security by creating roles, granting system and object privileges on the objects.
• Creating and Managing users in Oracle and setting up the proxy users.
• Rich experience in using Oracle data dictionary views.
• Experienced in Oracle 11g/10g/9i/8i utilities, SQL*Loader and SQL*Plus, Logical backups using Export and Import.
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle.
• Automating data loading, extraction using UNIX Confidential scripting.
• Proficient in using Oracle development tools like Oracle SQL Developer, TOAD and PL/SQL Developer.
• Good Hands on experience on Business Objects XI R2, Designer, Webi and Deski.
• Knowledge of Franchise Finance domain, Card Sales reporting, Collections domain management Reporting.
• Written complex SQL’s using joins, sub queries and correlated sub queries, Analytical Functions.
• Highly motivated with excellent team spirit to achieve targeted goals well within deadlines.

TECHNICAL SKILLS

Operating System: UNIX (Sun Solaris), Windows 95/98/NT/2000/XP.

Languages and Web Technologies: SQL and PL/SQL. Visual Basic 6, Concepts on MS Dotnet.

RDBMS and Application Server: Oracle 11g/10g/9i/8i/, SQL*PLUS, Export/Import, SQL*Loader, Toad, Oracle Enterprise Manager.

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, Automatic SQL Tuning, SQL Tuning advisor.

SQL Editors: Oracle SQL Developer, Toad and PL/SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Oracle Developer

Responsibilities:

• Involved in Design, Development of logical and physical data modeling.
• Involved in re-engineering the whole application and database. Preparing the ER data models, flow charts and normalization.
• Analyze the old code and port to the new application keeping sync with the existing business logics.
• Interacts with app owners and business to document the changes and taking their sign-off for change management.
• Support System Testing and Production migration by providing bug fixes, migration check lists.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.
• Interaction with end users for production support issues and resolving them.
• Provide recommendations for the maintenance and support of the environment as well as managing the change management.
• Performing Fine Tuning of SQL, PL/SQL Procedures.
• Developed back end interfaces using PL/SQL stored procedures, packages, functions, Object Types, DB triggers, Indexes and Collections.
• Manage internal databases, from planning and testing stages through implementation and support.
• Creating new users, maintaining them, setting proxy users, providing them proper roles.

Environment: Oracle 10g, Java, Hibernate, Oracle SQL Developer, SQL, PL/SQL, Putty, TOAD.

Confidential

Oracle Developer and Team Lead

Responsibilities:

• Involved in understanding the technical direction of the programming staff from a Back end database design and development perspective.
• Created and managed many objects in large Oracle Databases containing millions of records.
• Created logical and physical database objects - table spaces, tables, indexes, referential integrity constraints and triggers to development needs.
• Performed Fine Tuning of SQL, PL/SQL Procedures.
• Developed PL/SQL packages for performance reporting, daily reporting etc.
• Troubleshooted performance issues and bugs within packages, forms, and reports using dbms output, explain plan and TKPROF.
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS & IOTs.
• Analyzed the performance of the jobs during the project. Utilized standard techniques for enhancing the performance.
• Worked on database tuning and optimization using Analyze, EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Created job sequences and schedules for automation.
• Implemented Confidential scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them through cron jobs.
• Tuned the SQL statements using execution plans generated using.
• Responsible for technical support for Oracle databases related issues.

Environment: Oracle 10g, Business Objects XI R2 (Designer, Webi and Deski), SQL, PL/SQL, Toad, UNIX Sun Solaris, Confidential Scripting(Bash), Oracle SQL Developer.

Confidential

Oracle Developer

Responsibilities:

• Responsible for requirement Analysis, Coding, Testing and Implementation of data warehouse.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Developed PL/SQL procedures and functions to migrate data between Oracle Databases.
• Loading data by using SQL* Loader to custom tables.
• Coordinating with the users all around the Europe to gather the data specific to Profit and Loss statements.
• Worked on Partitioning (Simple and Composite).
• DBMS JOBS for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Worked on load data from excel into Oracle Table using PL/SQL.
• Conducted performance tuning of applications through SQL*TRACE, TKPROF, Explain plan, Parallel queries utilities.
• Used Oracle Enterprise Manager, TOAD for developing and managing pl/sql scripts.
• Worked on technical documentation and status reports of the application.

Environment: Oracle 9i, Windows 2000, Pl/Sql, SQL *Plus, TOAD, Business Objects 5.6.1, Ms Excel.

Confidential

Oracle Developer

Responsibilities:

• Production support.
• Writing complex SQL / PL-SQL code for complex tasks.
• Debugging the PL/SQL and Visual Basic 6 code.

Environment: Oracle 9i, PL/SQL Programming, Visual Basic 6, COM+, OOPS methodology.