PROFESSIONAL SUMMARY:

• About 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. Good experience of Performance AnalysisandSQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, Explain Plan, And Tk - prof.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level.
• Develop many front end applications using APEX 4.2.
• Worked on Oracle Forms10g/9i/6i Reports10g/9i/6i.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Extensively used PL/SQL to built Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• Experienced in Tuning Queries for better performance with large volume of data. Extensive experience in developing applications using Oracle Forms / Reports. Experience in almost all the versions of Forms/Reports.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).
• Experience in migration of source code using version control system(CVS, Arch, Visual source safe, svn, TFS).

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Unix Shell Scripts, JSP, C, C++, java, CSS, HTML, XML.

RDBMS: Oracle 11g/10g/9i/8i, MS-SQL Server 2000/2005, Sybase, DB2 MS Access.

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer, TOAD.

GUI Tools: APEX 4.2,3.2,Oracle Forms 10g,9i,6i and Reports 10g,9i,6i, ERWIN,VISIO, Golden gate, Autosys Control-M, JIRA and HP quality center.

WORK EXPERIENCE:

Confidential | San Diego.

Sr.Oracle Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in designing ER diagram using VISIO, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Experience with Oracle partitioned tables and queries.
• High-Transaction environment experience.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling..
• Created scheduled and schedule now reports.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Using Swing Concepts in Java Front End Forms are designed.
• Using Oracle Jdeveloper Database tools to write triggers and procedures, Function.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF and AUTOTRACE.
• Using Bash script for database connectivity using DBI which connects to backend database drivers.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for the scheduled batch processes.
• Expertise in creating shell scripts and used Crontab in UNIX environment for scheduling routine tasks.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PL/SQL, TOAD, UNIX, MS Windows 7, VISIO, GOLDEN GATE.

Confidential, Phoenix, Arizona

Sr. Oracle Developer

Responsibilities:

• Involved in designing ER diagram usingERWIN and VISIO. To set the logical and physical relationships of database.
• DevelopedStored Procedures, Functions, Packages and SQL ScriptsusingPL/SQL.
• Developed data model,SQL Coding,SQL Query tuning processandSchemas.
• Migration of dbms jobs tocontrol M.
• Scheduling jobs incontrol Mand handling them.
• Usedtortoise svn versioncontrol for changing the codes.
• Making changes to the existingapexapplications in the production.
• CreatedSQL*plus reportsas per client's various needs, and developed business objects.
• DevelopedSQL Scripts, Packages and Proceduresfor Business rules check to implement business rules.
• UsedBulk Collections, Indexes, and Materialized Viewsto improve the query executions.
• UsedRef cursorsandCollectionsfor accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling..
• Atomized routine jobs usingDBMS JOB.On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• DevelopedSQLandPL/SQLscripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) usingPL/SQL and SQL*Loader.
• DevelopedProceduresfor efficientError Handlingprocess by capturing errors into user managed tables.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Worked with java developers to repair and enhance current base ofPL/SQL packagesto fix production issues and build new functionality and improve processing time throughcode optimizations and indexes.
• PerformedSQL and PL/SQLPerformance tuningand ApplicationTuningusing various tools likeTKPROF, AUTOTRACE and DBMS SQLTUNE.
• DevelopedUNIX Shell scriptsto automate table creation, execute procedures.
• Used Oracle Sql developerfor creatingPL/SQL(trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PL/SQL, TOAD, UNIX, MS Windows 7, Apex 4.2, SVN, ERWIN, VISIO.

Confidential

Data Modeler

Responsibilities:

• Involved in gathering the requirements and system specification from the users.
• Responsible for Analysing requirements, designing, maintaining and updating data models using ERWIN.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Involved in ETL process bulk transfer of data using SQL loader and SSIS.
• Involved in Developing and handling PL/SQL Packages, Procedures and Triggers
• Involved in performance tuning of queries using EXPLAIN PLAN and TK PROF.
• Design and development of user interface using Forms 10g and APEX 3.2.
• Modified the existing Sql code according to end userrequirement to generate reports using business objects and Reports 10g.
• Involved in unit testing and integration testing.
• Experience in working with Autosys Admin team to resolve latency issues in Autosys by checking Event Processer logs.
• Schedule Autosys jobs through inserting, deleting and updating jobs in various production instances.
• Providing interaction design and usability testing to the Excite Studios organization.
• Involved in handling the bulk production data.
• Involved in importing the production data to work environment through TOAD.
• Involved in handling changes of compiling scripts according to database changes.
• Coordinate with different teams while doing production support and critical problem resolution.
• Worked as a part of a team and provided 24 x 7 supports when required.

ENVIRONMENT: Oracle 11g, SQL, PLSQL, SQL*Loader, SSIS, TOAD, Oracle Forms 10g, Reports10g, Oracle Apex 3.2., Autosys.

Confidential - Buffalo, NY

Oracle Developer

Responsibilities:

• Participated in client requirement sessions to analyze and gather business requirements.
• Involved in the Analysis, Design, Coding and Testing of the application and participated in discussion meetings about requirements.
• Involved in logical and physical database design.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Created and Modified PL/SQL Triggers, Procedures, Functions and packages
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms 10g.
• Converted oracle form application 6i to 10g using migration assistant.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Developed SQR’s for loading data from feed file to staging tables.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN etc.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.

ENVIRONMENT: Oracle 10g, SQL, PLSQL, SQL*Loader, TOAD, UNIX Oracle Forms 10g, Reports10g.

Confidential

Oracle Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering, Built complex queries using SQL and wrote stored procedures using PL/SQL
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Implemented Complex business Logic as per the client requirement.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Creation of database objects like tables, views, synonyms, materialized views, Stored procedures, packages using oracle tools like SQL* plus.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Involved in moving the data from flat files to staging area tables using SQL * Loader.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF and AUTOTRACE.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Worked closely with Production Support team to Troubleshoot and fix any production issues using tools like visual source, clear case, M.K.S integrity Clint.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL) program asynchronously.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Prepared daily reports from the invoice data received for different department like sales, marketing and monthly reports to extract the monthly sales information.
• Developed complex SQL queries, triggers for building reports using Form, form letter and mailing label report styles.
• Developed Master Detail, Detail reports using tabular and Group above reports.

Environment: Oracle 10g, Reports 9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, MS Windows XP/2000, Oracle Development Suite.

Confidential

PLSQL developer

Responsibilities:

• Participated in client requirement sessions to analyze and gather business requirements.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Involved in logical modeling and physical modeling of application.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for Oracle 10g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Used pl/sql tables, pragma autonomous transaction to avoid mutating problem in database trigger.
• Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
• Created records, tables, collections (nested tables and varrays) for improving performance by reducing context switching.
• Worked on data conversion, loaded data from different Sources into the Temp data backup environment using SQL Loader and validated the data before loading it into oracle tables.
• Optimizing PL/SQL code and SQL queries using Explain Plan, Indexes and Hints.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Provided database support to testing team in writing complex SQL queries.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Used UTL FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Involved in designing of required end user forms and reports using Oracle forms 9i & Reports 9i .
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Worked with different triggers in forms like Block processing triggers, Interface event triggers, navigation triggers and validation triggers.

Environment: Oracle 9i, UNIX, SQL, PL/SQL, SQL Loader, Unix shell script, Erwin, Forms & Reports 9i, Sql Developer and Toad.

Confidential

Oracle Developer

Responsibilities:

• Actively involved in interacting with front end Java developers, and gathered User Requirement and Online System Specification.
• Created new logical and physical database design to support multi-year conferences for the tables of employees, histories, skills, experience and payroll.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Normalized to 3NF to acquire least data repetition required by business.
• Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created/ reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Implemented security by creating User logins, Roles and granting Users access to the database according to their role.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/sessions.
• Used UTL JOB to automate the plsql procedures and packages.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Oracle 9i, Windows 2003, UNIX, SQL, PL/SQL, SQL Loader, Erwin and SQL Navigator.

Confidential

Jr. Oracle Developer.

Responsibilities:

• Responsible for analyzing business functionality for the back end processes.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in the Star schema model.
• Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
• Involved in creating user interface Forms and adhoc reports using Oracle Forms/Reports 6i.
• Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.