SUMMARY:

• 8 Years of U.S experience in Database Development using SQL and PL/SQL
• 3 + Years of excellent experience in Oracle Data Warehousing having large database of size 4 Terabytes .
• Excellent experience in SQL Loader, Toad, UNIX shell scripting and batch processing
• Very good experience in Normalized Database Design and Data Modeling (Logical and Physical design of database).
• Very good experience with data flow diagrams, Entity relation modeling and design techniques, database normalization theory.
• Extensive work experience in Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i Oracle 8 databases.
• Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers.
• Strong knowledge in Oracle cursor management and exception handling, Collections, Ref Cursor, Bulk Collections, Bulk Exceptions, Dynamic SQL, PL/SQL Collections and Exception handling, Oracle in - built packages.

TECHNICAL SKILLS:

Operating System: Windows 95/98/2000/XP/NT, Red Hat Linux, Sun Solaris UNIX

Languages: SQL, Oracle PL/SQL

Databases: Oracle 11g/10g/9i/8i/8/7.3

Modeling Tools: TOAD

Reporting Tools: Oracle Reports, Crystal Reports

Tools /Utilities: SQL*Plus, SQL Developer,Toad, SQL Navigator, SQL Loader, Data pump, TOAD, Cisco Tidal Scheduler, Autosys job scheduler JIRA, SVN Version Control, VSS Version Control,WinScP

Good experience in: UNIX Shell Scripting using Korn Shell

Limited Exposure to Front end Tools: Oracle Forms /Reports, Oracle Designer

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Oracle Developer

Responsibilities:

• Involved in developement of various projects for the company.
• Involved in inbound and outbound interface modules: Data files are coming from various departments, then process those data through SQL Loader, load in Oracle databse and validate through customized pacakages, all jobs are automated using Autosys .
• Also involved in sending weekly data files to other departments,interface partners from Linux server.
• Developed complex Oracle PL/SQL stored procedures, Functions, Packages, SQL queries,facilitate the functionality for various modules.
• Developed customized Functions, Procedures based upon the business requirements.

Environment: Oracle 11g, Oracle PL/SQL Developer, Linux,Autosys

Confidential, Concord, NC

Sr. Oracle Developer

Responsibilities:

• Worked as a Lead Oracle Developer in Confidential and handled complex Module of Bonus Calculations for company's IBOs.
• Data comes from different countries through Data files and loaded in Oracle database through SQL Loader, all jobs were automated using Asched Web Job Scheduler.
• Each month new Bonus generated based on different business rules and different criteria for each country and also based on IBO’s performance: means how many new customers IBO brought to the company, how many sales products IBO has installed this month .
• Based on last month’s business trend & profit earned in different country, requirements for next month has been decided by Confidential ’s business experts.
• Developed complex Oracle PL/SQL stored procedures, Functions, Packages, SQL queries to facilitate the functionality for various modules.
• Developed customized Functions, Procedures based upon the business requirements.
• Involved in Production Support for team and resolved production issues.

Environment: Oracle 11g, Oracle PL/SQL Developer

Confidential, Charlotte, NC

Sr. Oracle Developer

Responsibilities:

• Involved in Development of various Projects for the Company's Department. Which supports business decisions by collecting, consolidating, and organizing data for different departments and different applications.
• Developed complex Oracle PL/SQL stored procedures, Functions, Packages, SQL queries to facilitate the functionality for various modules.
• Involved to create various database tables, indexes, triggers and other DB objects for several projects as per business requirement.
• Developed customized Functions, Procedures and Triggers based upon the business requirements.
• Used Bulk Collect, Bulk exceptions features to improve performance.

Environment: Oracle 11g, Oracle PL/SQL Developer

Confidential, Charlotte, NC

Sr. Oracle Developer

Responsibilities:

• Involved as lead developer in development of various Projects in Oracle Data Warehousing to receive data files from NAS server and load data through SQL Loader and validate data as per business rules using complex SQL queries,functions,procedures in packages.
• Involved as lead developer in development of various outbound interface projects to generate data files using complex SQL queries,UTL FILES() utility and FTP them to different TWC departments.
• Developed complex Oracle PL/SQL stored procedures, Functions, Packages, SQL queries to facilitate the functionality for various modules.
• Developed customized Functions, Procedures, Views, Materialized V iews based upon the business requirements.
• Used Bulk Collect,Bulk exceptions feature to improve performance.
• Designed various database tables, indexes as per business requirement.
• Write various UNIX shell scripts as per requirements.
• Work on Tidal scheduler to schedule concurrent program of Oracle Apps.
• Involved in Understanding of Business Process, existing ER and Data Flow diagrams.
• Thorough Data analysis to understand the behavior of data.

Environment: Oracle 11g, Oracle Apps, TOAD, SQL PLUS, UNIX, Tidal Schedular

Confidential, Charlotte, NC

Sr. Oracle Developer

Responsibilities:

• Involved as lead developer in development of various Projects in Oracle Data Warehousing for various Departments, which support business decisions by collecting, consolidating, and organizing data for reporting.
• Working as lead developer for various global sourcing projects for the company.
• Developed complex Oracle PL/SQL stored procedures, Functions, Packages, SQL queries to facilitate the functionality for various modules.
• Developed customized Functions,Procedures and Triggers, Views, Materialized V iews based upon the business requirements.
• Developed Complex SQL queries using various joins .
• Developed generalized modules using dynamic SQL .
• Used Bulk Collect,Bulk exceptions feature to improve performance.
• Designed various database tables, indexes, partitions as per business requirement.
• Write various UNIX shell scripts as per requirements.
• Gathered requirements through detailed discussions and worked e on Oracle Report Builder and other Tools which generate Excel based Report Output as per business logic.
• Involved in interacting with users collecting requirements and converting them into specifications, analysis, designed the Database, and maintenance of the database.
• Involved in Understanding the Business Process, existing ER and Data Flow diagrams.
• Writing complex Oracle Packages, Stored procedures, Functions and Triggers using PL/SQL.
• Load large data using SQL*Loader from different sources into the Oracle Database.
• Thorough Data analysis to understand the behavior of data
• Build various customized shell scripts as per requirement in UNIX environment.

Environment: Oracle 11g, Oracle Reports, TOAD, SQL PLUS, UNIX

Confidential, Ashburn, VA

Sr.Oracle Developer

Responsibilities:

• Involved in development of the Service order entry module of Confidential local services. This module serves as a tool for Confidential local services to create and manage the service plans of the customers. This system can be used to view existing service plans, accept new customer orders, and modify service plans.
• Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Developed Packages and customized functions and Triggers, Views, Sequences based upon the business logics.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Used Bulk Collect feature to improve performance.
• Gathered requirements through detailed discussions and worked extensively on Crystal report to create reports based on the user specifications.
• Thorough Data analysis to understand the behavior of data.
• Build various customized shell scripts as per requirement in LINUX environment.

Environment: Oracle 10g, Crystal Reports, TOAD, SQL PLUS, Oracle Designer, Toad Data Modeler, Linux.

Confidential, St. Louis, Missouri

Oracle PL/SQL Developer

Responsibilities:

• Involved in a repository system development that stores Patient, Prescriber and their prescription information and their related transactions. The main objective of this system is to produce reports on patients, their prescriptions and transactions over a period of time.
• Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts upon the business logics.
• Developed Complex SQL queries using various joins.
• Used Bulk Collect feature to improve performance.
• Involved in creation and modification of different PL/SQL objects like Packages, Stored Procedure, Triggers
• Involved in writing complex SQL Queries.
• PL/SQL Collections were extensively used for high performance stored procedures.
• Involved in fine tuning stored procedures by making use of PL/SQL Collections and BULK COLLECT features.

Environment: PL/SQL, Oracle 10g, TOAD, SQL PLUS, Win.2000