SUMMARY

• Over 6 years of Information Technology experience including data analysis, data design, data support, data mining and migration of Oracle RDBMS systems on various platforms i.e., UNIX/LINUX and WINDOWS Server platforms.
• Worked Over 6 years on different oracle database versions, which are Oracle 8i/9i/10g and 11g, SQL and PL/SQL, SQL Loader, Physical database design, Logical database design, Gap Analysis, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning & Optimization.
• Solid 6 years of experience on Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Strong experience on various programming techniques, BULK COLLECT with FOR ALL, User defined exceptions, MERGE, Global temporary tables.
• A sturdy hold on performance tuning using AUTOTRACE, EXPLAIN PLAN, SQLTRACE/TKPROF using external Hints.
• Experience on working and designing Physical/Logical data models during initial phase of project blueprint.
• Hands on experience on various database utilities like SYS CONTEXT, LISTAGG, PIVOT, UNPIVOT, DBMS UTILITY, DBMS SCHEDULER.
• Strong experience on full life cycles of software development including requirement gathering, blue print design, development, testing and support.
• Worked in different non Oracle database applications, MS Access, Tera data, SAP R3, J2EE, Microsoft reporting tools.
• Proficiency on using various Oracle utility tools, Sql Plus, Sql PlusW, TOAD, PL/SQL Developer, Sql Navigator, Sql *Loader, Export/Import with data pump.
• Strong experience on XML manipulations using XMLTYPE/CLOB with XMLTABLE, XMLELEMENT, XMLFOREST, DBMS XMLSAVE, DBMS XMLGEN.
• Experienced in working different environments and having capability of directly coordinate with business and other technical teams.
• Expertise in problem solving and diagnostic analytical skills and ability to communicate with different kind of individual at all stages.
• Good in team leading skills including assigning and coordinating the work with offshore teams and on shore peers.

TECHNICAL SKILLS

Database systems: Oracle RDBMS 8i/ 9i/10g/11g, MS Access, Tera Data.

Programming Languages: SQL, PL/SQL, Unix Shell Script, HTML, Java Script, VB Script XML, Perl Scripting, Pro C.

Tools: & Utilities: TOAD 8x/9x/10x, SQL Plus, SQL Loader, ERWIN, Auto trace, Explain Plan, Microsoft reporting tools, AdHoc reporting tools, Execution Plan, SQL Developer, Autosys. PL/SQL Developer, MS Office, Putty, telnet, FTP.

Operating System: UNIX, LINUX, DOS, WINDOWS 7/XP/VISTA/2000/2003.

ERP: SAP R3 6.0.

Scripting: UNIX korn/bourne shell scripting, PERL Shell Scripting.

Version Control Tools: SVN, Adhoc versioning system

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle pl/sql Developer

Responsibilities:

• Involved in designing the business and technical specification in development phase of the project.
• Participated in designing logical/physical database during designing of database model.
• Involved in all stages of system development life cycles, which includes requirement gathering, blue print design, development, testing and maintenance of application.
• Responsible to generate sql/plsql programs based on specification requested by users/business users.
• Experience in writing Oracle stored procedures/Functions/Packages/Triggers/DBLINKS and performed testing on them.
• Involved in performance tuning on sql using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Used several 11g new oracle sql/plsql features like LISTAGG, PIVOT, UNPIVOT, CONTINUE, SIMPLE INTEGER.
• Created several utility packages to handle specific functionality for the business context.
• Experience in using various utilities like PRAGMA AUTONOUMOUS, BULL COLLECT FOR ALL, DYNAMIC SQL, NO COPY.
• Created different XML transformations to send/receive the data back and froth from JAVA and Oracle relational tables using XMLTYPE, XMLTABLE, DBMS XMLGEN.
• Designed a variety of ETL transformations/transformation programs using Oracle sql/plsql.
• Experience in using various oracle pl/sql collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2
• Worked with large database data types CLOB inside XMLTYPE while generating XML inside oracle stored program objects.
• Used Autosys for monitoring and scheduling the Autosys jobs in several environments.
• Performed various activities in Autosys on daily basis to start, stop, hold, ice, kill using Autosys commands SENDEVENT: FORCE STARTJOB, KILL JOB, JOB ON HOLD etc.
• Provided constant support on the existing program and newly developed programs.
• Involved in working with INLINE CURSORS, EXPLICIT CURSORS, REF CURSORS.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.

Confidential, Princeton, NJ

Oracle pl/sql Developer

Responsibilities:

• Experience in acknowledging key attributes in entities define on domain level.
• Involved in attending daily scrums and different team meetings based on the issues.
• Created master and transaction tables using the functional requirements.
• Experience in designing the various key database schemas in project, i.e., STAGING, USER CREDENTIAL, APPLICATION PROCESS etc.
• Developed various Oracle Anonymous blocks, PROCEDURES/FUNCTIONS/TRIGGERS.
• Created several complex Oracle pl/sql packages for business activities using Oracle collection objects.
• Used dbms jobs, dbms scheduler to schedule the oracle jobs in a sequential order to process several programs in a single go.
• Developed several automation scripts to move data between staging area and other schemas related to the application.
• Involved in creation of various indexes on relational tables, which are, BTREE, BITMAP, FUNCTION BASED.
• Used several Oracle predefined functions NVL, NVL2, DECODE, TO CLOB, CASE STATMENT.
• Used various database DML triggers using PRAGMA AUTONOMOUS technique.
• Worked in several UNIX scripts in implementing of Oracle automated program calls.
• Involved in various data loading techniques using SQL LOADER, UTL FILE, EXTERNAL TABLES.
• Create various user defined EXCEPTIONS to control the process based on the business requirement.
• Involved in generating numbers for PRIMARY KEY VALUES using Oracle SEQUENCE objects.
• Created various alphanumeric RANDOM VALUES using DBMS RANDOM package.
• Used SYS CONTEXT to generate user id, session id and various column inside various Oracle objects.
• Implemented various OLTP transaction using sql/plsql.
• Worked on ASCII Sql based on specific requirements.
• Used AUTHID & DEFINER in procedures/function/packages with NO COPY option.
• Good knowledge on rule based and cost based optimizers in different Oracle flavors.
• Used various clauses in Sql statement like IN, EXISTS, GROUP BY, ORDER BY ASC, DESC.

Confidential, Rochester, NY

Oracle Developer

Responsibilities:

• Responsible for conducting and gathering user requirements and develop the Oracle programs based on them.
• Designed and followed Oracle predefined coding standards.
• Implemented DATA CLEANSING, DATA VALIDATIONG, DATA QUALITY, DATA INTEGRITY using Oracle programs in staging area.
• Invloved in creating of Adhoc scripts for specific business needs and used advanced sql techniques like Analytical functions, Aggregate, Mathematical functions.
• Involved in working on Oracle PSUEDO columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
• Tuned several Oracle sql statements using EXPLAIN PLAN, AUTOTRACE utilities.
• Involved in implementing table partitions using RANGE, HASH, COMPOSITE techniques.
• Worked on external hints during the sql optimization to fast up the sql process.
• Experience is working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, PARTITION OVER.
• Designed competent pl/sql programs using pl/sql collections, Records types, Object types.
• Good knowledge on joins, which are, inner join, Left outer join and Hash join, Semi join.
• Implemented various UNIX scripts to generate the data in CSV format.
• Used ASCII functions in Oracle scripts to generate the TAB, NEW LINE and other ASCII values.
• Used Toad EXPORT/IMPORT utility to load the tables and excel, csv files back and forth.
• Experience in using putty, telnet, ftp to communicate with the remote UNIX servers.
• Good knowledge of using various editor tools like TEXT PAD, ULTRAEDIT, NOTEPAD++.
• Experience on using various Oracle front tools like TOAD, PL/SQL DEVELOPER, SQL PLUSW etc.
• Used Toad file compare utility to generate the differences between two files.
• Worked in removing the duplicate values automatically by itself.

Confidential, Littleton, CO

Oracle Developer

Responsibilities:

• Involved in creating of new parent and child tables for the database in various schemas.
• Experience in working directly with top level management, user and other team members to investigate and evaluate the user specifications.
• Used DPIMP/DPEXP utilities to take the database backup.
• Involved in performing data analysis and data cleansing on huge tables with million rows.
• Experience in understanding conventional and traditional data structures.
• Used DBMS UTILITY, DBMS SMTP, DBMS MAIL to perform various tasks in project.
• Worked on Global temporary tables to hold the data on session levels.
• Implemented different Event based triggers on database events like on LOGIN, SHUTDOWN etc.
• Experience in debugging various tools and using DBMS DEBUG package.
• Worked on parameterized cursors and dynamic cursor to perform dynamic operations.
• Good experience in working on UNIX CronTab for process automation.
• Involved in developing various Oracle objects like STORED PROEDURE/FUNCTIONS/PACKAGES.
• Worked with Merge statement to speed up the INSERT and UPDATE process.
• Good experience in writing UNIX wrapper script to schedule and automate the process.
• Performed optimization in sql and pl/sql using various techniques.

Confidential, Cherry Hill, NJ

Oracle Database Analyst

Responsibilities:

• Involved in attending various functional/technical team meetings and business workshops.
• Worked in various stages/releases of project.
• Good working knowledge on working change management process.
• Experience in good working knowledge on insurance domain.
• Used various oracle packages like DBMS OUTPUT, DBMS STATS, DBMS UTILITY etc.
• Used analyze table command to gather the statistics on relational tables.
• Worked on BULK COLLECT for bulk loading the data into various transaction tables.
• Used UTL FILE to load the data into oracle tables from FLAT,CSV and Text files.
• Applied several Oracle program patches to existing process or programs.
• Performed several DDL,DML and TCL operations.
• Involved in writing several data loading scripts for incremental and initial/one - time data loads.
• Experience in coordinating with different non project business teams on data loading issues.
• Involved in extracting data from different data resources.
• Implemented various automated UNIX shell scripts to invoke pl/sql anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
• Worked on inline and correlated sub queries based on business context.
• Implemented various customized Oracle reports using different techniques in Oracle sql/pl-sql.
• Responsible for debugging Oracle pl/sql blocks and optimization of various Oracle stored objects.

Confidential

Oracle Data Mining Analyst

Responsibilities:

• Involved in data mining and data analysis based on the data patterns received.
• Involved and implemented full SDLC for the application.
• Generated various company standards of processing the data based on information gathered from key business users.
• Implemented several PERL/UNIX scripts to load the data into database from various resources like non oracle databases, CSV files, text/FLAT files etc using SQL * LOADER.
• Constantly involved in attending and conducting the team meetings.
• Implemented several Oracle anonymous blocks, procedure and functions based on the requirements.
• Worked on Oracle defined exceptions like NO DATA FOUND, TOO MANY ROWS, WHEN OTHERS.
• Used Oracle BLAST related functions to find and analyze the DNA patterns.
• Involved in sequencing similarity search and Alignment process while matching the patterns.
• Involved in testing Y and MITO process in DNA Pattern search.
• Experience in unit and integration testing.
• Used export/import utilities to save the database/database object.
• Involved in writing Oracle views, inline views sql statement in SELECT, FROM and WHERE clauses.
• Involved in suggesting of different oracle techniques to business users to generate the optimized codes.
• Used mail utility in UNIX to send mails to users.
• Provided on call support and maintenance during non working hours.