SUMMARY

• Over 5 Years of experience in Analysis, Design, Development, Implementation and support of RDBMS in Production, Development and Test environments using Oracle Tools in client server environments.
• Experienced in using Oracle tools like SQL*Loader, Toad, SQL Navigator, SQL Developer and Data Loader.
• Hand on experience developed SQL Loader control programs, interfaces and PL/SQL validation scripts to transfer flat file data into oracle database and Oracle Applications base tables.
• Involved in entire Software Development Life Cycle (SDLC) from business analysis to final deployment and testing.
• Expertise in writing UNIX shell scripts in order to automate and schedule tasks.
• Developed Data Mapping and Data Conversion scripts using SQL, PL/SQL.
• Expertise in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections.
• Hands on experience in developing and customizing Oracle Forms and Reports using Oracle Forms10g/9i/6i, Reports10g/9i/6i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Involved in query tuning using Explain plan and TKPROF.
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity - Relationships, UML, Use Cases.
• Involved in debugging andTuning the PL/SQL code, tuning queries, optimizationfor theOracledatabase.
• Experience in migrated Oracle forms from version 6i to 10g by compiling them for any errors in the 10g version and deployed them to the server.
• Expertise in writing PL/SQL stored procedures, functions, packages and triggers using PL/SQL developer.
• Experience with XML packages, XML parsing and loading into oracle.
• Hands on experience in performance tuning of SQL statements and PL/SQL modules using Explain Plan, SQL Trace for optimizing the cost and evaluating the performance.
• Expertise in full life cycle implementation of Data migration projects.
• Knowledge in defined Unique and non-Unique indexes on database tables for faster retrieval of data and to enhance DML (UPDATE, DELETE and SELECT) performance.
• Hands on experience in troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Developed various Oracle Applications using PL/SQL, SQL*Plus, Reports, Workflow Builder, and Application Object Library.
• Experience in OLTP like Oracle, SQL server.
• Managing the end-to-end implementation of the project including designing, development, testing, implementation and support of software applications.
• Very strong in writing simple and complexSQLqueries using DML, DDL, Table joins.
• Knowledge in Informatica transformations like Source Qualifier, Sorter, Aggregator, Sequence, update strategy, Lookup, Joiner etc.
• Good understanding of Data warehousing concepts, ETL Processes and Data modelling concepts such as Design of the Dataflow, ER Diagrams, Normalization and De-normalization of Tables.
• Strong communication, analytical problem solving, and design skills.

TECHNICAL SKILLS

Databases: Oracle11g/10g/9i, SQL Server, MS Access.

Operating Systems: Windows series, UNIX, Oracle LINUX.

Languages: SQL, PL/SQL, PRO*C, C, C++, Java

Scripting Languages: Perl, HTML 5, XML, XSD, UNIX shell scripting, Perl Scripting.

GUI’s Technologies: Oracle Forms and Reports 11g/10g/9i/6i, Oracle Apex, Crystal Reports, SQR, MS Visio, ERWIN, ER Studio

Utilities: SQL* Plus, SQL Loader, SQL Navigator, Toad, SQL Developer, UTL File, ETL tools Informatica Power Center, Oracle Discoverer, AB Initio.

Packages: Microsoft Office Suite- MS-Word, MS-Excel, MS-Power point, MS-Visio

Version Control and Ticketing: SVN, Visual Source Safe, IBM Rational Clear Case and Clear Quest, Service Now, Track Studio, JIRA.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

• Expertise in designed and developed database objects like Tables, Indexes, Sequences and Views.
• Hands on experience in developing and handling the PL/SQL Packages, Procedures, Functions and Database Triggers.
• Involved in the generation of User Interface using Oracle Forms by extensively creating forms as per the client requirements.
• Experience in developed various Reports utilizing Oracle Reports Builder for day-to-day validations.
• Knowledge in used Oracle Forms 10g to create new forms and maintain existing forms.
• Involved in design, development and Modification of PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Developed custom batch programs inPro*Cand developed customFunctions, Procedures and PackagesScripts implementation.
• Hands on experience in troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Expertise in SQL*Loader to load flat files into database tables.
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using Joins, Sub Queries and Correlated Sub Queries.
• Involved to created CTL files to load the data into Oracle database using SQL Loader.
• Written several Procedures, this uses Explicit Cursors to select data and Exception Handlers to raise errors.
• Expertise in responsible for writing and modifying Shell scripts in UNIX and scheduled CRON jobs.
• Involved in Data Extraction using UTL FILES in PL/SQL.
• Worked with Informatica to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Involved in Database Performance Tuning using Oracle Hints, Partitioning and Indexes.
• Involved in debugging andTuning the PL/SQL code, tuning queries, optimizationfor theOracledatabase.
• Experience to usePL/SQLTables, Array structures as a part of Oracle Collections and Used Bulk collect and for all in stored procedures to improve the performance and make the application to run faster.
• Involved in Performance Tuning using Explain Plan, and SQL trace.
• Involved inUnit testingand Integration testing offorms and reports.
• Extracted the data from legacy systems into production database usingSQL*Loaderand Pro*C.

Environment: Oracle 11g, UNIX, SQL*Plus, PL/SQL, SQL, XML, Forms 10g, Reports 10g, Pro*C, Informatica Power Center 8.x/9.x, SQL Loader, TOAD, Secure shell.

Confidential, Dallas, TX

PL/SQL Developer

Responsibilities:

• Expertise to designed, developed, modified Tables, Views, Materialized Views, Stored Procedures Packages and Functions.
• Responsible for migrated Forms from 6i to 11g, by recompiling and modifying the code as needed to support the complex functionality embedded.
• Experience in coded PL/SQL Packages and Procedures to perform data loading, Error Handling and logging. Tied the procedures into an existing ETL process.
• Knowledge in tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted Hints and rewrote code as required.
• Good experience in usedSQL loaderto load the data from the files provided by the interfacing applications.
• Expertise in created new Procedures, Functions, Triggers, Materialized Views, Ref Cursors, Dynamic SQL, and Table Functions as part of Project/Application.
• Designed and developed interactive forms to support data entry, querying and updating the Oracle database.
• Extensively worked with Bulk Collect, PL/SQL Tables and Arrays.
• Good knowledge in increase the performance and to manage large database objects Partitioned Tables using Range Partitioning, List Partitioning.
• Involved in using of features of Oracle 11g like Analytical functions, Flash back Query, regular expressions.
• Expertise in worked on UNIX environment and UNIX Shell scripting for creating Batch Jobs using UNIX KORN, AWK UNIX Shell Scripts and API’s Using PEARL Scripts.
• Improve the performance of the slow SQL queries by implementing indexes, using BULK LOAD, BULK COLLECT and developed various procedures, functions and packages to implement thenew business.
• Experience to writePL/SQL Database triggersto implement the business rules in the application.
• Implemented all modules logic by usingTriggersandIntegrity Constraints.
• Good experience to work with Informatica to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• CreatedExternal Tablesto handle huge volumes of data, which is not used frequently.
• Knowledge in use of Bit map and Function based indexes to improve performance of queries.
• Responsible for creating the technical design document.

Environment: Oracle 10g, Oracle Forms 6i/11g, Oracle Reports 10g, PL/SQL, SQL Developer, SQL Loader, Crystal reports, Clear Case, Unix Shell Scripting.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved inSDLC including designing, coding and testing. Involved in logical and physical database design and Star Schema design, Identified Fact Tables, Transaction Tables.
• Participation in weekly design reviews and walkthroughs with project manager and development team. Worked on database design with the team.
• Created Materialized Views and partitioning tables for performance reasons
• Involved in writing PL/SQL code using the technical and functional specifications.
• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Involved in writing PL/SQL Packages, Functions, Stored Procedures and Data Base Triggers.
• Developed complex queries to retrieve the data. Performance tuning of the SQL queries using Explain Plan. Documented business rules, functional and technical designs, test cases, and user guides.
• Involved in the debugging and error handling.
• Monitored the database growth on daily basis. Worked on Database tuning and performance monitoring. Wrote UNIX SHELL scripts.

Environment: Oracle 10g/9i, SUN Solaris, Reports 6i, Forms 6i, TOAD, SQL*Loader, PL/SQL, SQL*Plus

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in database design, coding and implementation.
• Developed scripts to create Database Tables, Indexes, Synonyms, and Grants.
• Developed Stored Procedures and complex Packages using PL/SQL.
• Developed Triggers, Functions, Cursors, Materialized Views and Procedures.
• Developed UNIX shell scripts to runSQL*Loader processes to insert records to the database.
• Involved in developing Oracle Forms and Reports using Forms and Reports.
• Utilized Erwin and MS Visio to create ER diagrams for the modelled schemas.
• Executed Explain Plans, created indexes and implemented query hints to tuneSQLqueries for optimum results.
• DevelopedPL/SQLmodules to Create Packages, Stored Procedures, Functions and Database Triggers.
• Involved in designing and development of data warehouse for the corporate data repository.
• Used ERWIN to develop logical and physical database models.
• Used Microsoft Visio for Dataflow and Entity relationship diagram.
• Developed automated email notification using UNIX shell.
• Developed Unix Kern shell scripts to extract data from the Production database for daily.
• Used XML to display the reports/forms.
• Created complexSQLand used JDBC connectivity to access the database.
• Preparation of ERD/Data Modelling Design.
• Developed Java script behaviour code for User Interaction.

Environment: Oracle 9i, SQL * PLUS, SQL LOADER, PL/SQL, Forms, Reports 6i, HTML, Java, Pro*C, UNIX Shell scripts, Windows NT, Informatica Power Center 8.1.