SUMMARY

• Over 9 years of programming experience as an Oracle PL/SQL Developer with Oracle 9i/10g/11g/12c in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Strong experience inData warehouse concepts, ETL and good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developedmaterialized viewsfor data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTPand dimension modeling forOLAP.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Experience with Oracle Supplied Packages such asDBMS SQL, DBMS JOB, UTL FILE and Partitioned large Tables usingrange partition technique.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO), usingExplain PlanandHINTS.
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution Plans,Indexes and Experience withPerformance Tuningfor Oracle RDBMS
• Experience inETLtechniques and Analysis and Reporting including hands on experience with the Reporting tools such asCognos.
• CreatedShell Scriptsfor invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• PL/SQL: Strong back - end programming experience using PL/SQL, SQL, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes - B - tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad - hoc queries using SQL.
• Experience in developing complex Oracle forms and reports and OBIEE 11g.
• Knowledge on deploying applications on Oracle Web Logic 11g.
• Heavily worked with SQL HINTS, INDEXES (B*Tree, Bitmap, Unique, function based, Clustered indexes) for performance improvements.
• Extensively used Oracle built-in Packages such as UTL FILE, DBMS JOB, DBMS SQL, DBMS SCHEDULER and DBMS UTILITY.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Developed and supported Extraction, Transformation and Load process (ETL) using PL/SQL and to populate the tables in OLTP and OLAP Data warehouse environments.
• Excellent ability in writing specifications and gathering requirements from the user to develop reports using Oracle Forms, Oracle Reports and APEX as per the needs of the client and maintain documentation of the reports for future reference.
• Experience working with UNIX shells scripting.

TECHNICAL SKILLS

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008 , DB2/UDB, Teradata, SAP Tables and MS Access.

ETL Tools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0 , PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, MainFrame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader

Reporting Tools: Business ObjectsDeveloper Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5

Operating Systems: UNIX(Sun Solaris, LINUX, HP UNIX, AIX), Java, XML, C and Cobol, Windows NT/98/95/2000 & Windows XP

Data Modeling: Erwin 3.5.2,4.0

Other Tools: AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0

PROFESSIONAL EXPERIENCE

Confidential, Austin TX

Sr. PL/SQL Developer

Responsibilities:

• Involved inLogical & Physical Database Layout Design.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from DB2 database to Oracle database.
• Implemented 11g and upgraded the existing database from DB2 to Oracle 11g.
• Involved inLogical & Physical Database Layout Design.
• Was a part of conversion team and have taken part actively in propose an idea to convert data from DB2 database to Oracle.
• Introduced a view related approach to convert the data.
• Introduced BULK COLLECT approach to the team to pull the records faster.
• Was in charge of performance tuning several programs and was successful in getting the run time down for more than 90 percent.
• Assisted my team lead in proposing a new way of writing the procedures and have written a set of coding standards and provided it to the team which was followed by everyone.
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, DB2, Shell Scripts, UNIX, IBM Rational Clear Case version control, Clear Quest Client

Confidential, Los Angeles CA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Understanding the current process of sending the files to the state from the plan partners
• Worked on their flat file conversion from the plan partners to the state format
• Created PL/SQL code for the conversion of NCPDP 2.2/4.2 file to DHCS new format.
• Performed tuning of ongoing monthly automated process using Explain plan, Trace utility
• Documented all the schema packages, tables and procedures
• Loading of the data from the plan partners to state using BULK COLLECTIONS
• Involved in Requirement Analysis, Design, Data Mapping, use cases and Client Interaction. This involves analyzing Functional Spec and designing Technical Spec.
• Technical Assistance for Development. Design and Develop of Logical and physical Data Model of Schema
• Gather the requirements and define the objective of your database, Gather Data, Organize in tables and Specify the Primary Keys, Create Relationships among Tables Relational Database Design
• Providing productions support for all the ongoing automated process which takes place weekly, monthly.
• Worked on LA Care Pharmacy Historical Capitated Claims Data Transfer to APS
• Understanding the existing business processes and Interacting with Super User and End User to finalize their requirement.
• Created PL/SQL Packages, Procedures, Functions and Triggers.
• Wrote PL/SQL code for data Conversion in there Clearance Strategy Project.
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.
• Initially application is in Access, architecture and designed whole application into Oracle forms 6i for user friendly.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 10g.
• Have extensive experience in developing efficient PL/SQL code for OLTP environment and ETL code for the Data Warehouse environment.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
• Created Batch jobs, daily jobs, one time jobs and queues.
• Developed complex Oracle Forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc.).
• Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
• Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
• Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
• Written PL/SQL Functions that return complex data types, collections and ref cursors to interface with Java programs.
• Maintaining different version of software (version control) using PVCS.
• Providing production support solving Tickets created using the software Element Tool.
• Preparing test plan for QA for testing before moving from PreProd to Production environment.
• Developed PL/SQL packages, collection of procedures and user defined functions for complex calculations and bundle them into stored package

Environment: Oracle 11g, SQL Server, PL/SQL, Reports10g, Forms10g, Data Modeling(Erwin), Data migration, SQL Navigator, Toad, Unix Shell Scripting, Window NT, AIX, FTP, SFTP, NDM, PL/SQL Developer, Informatica, SQL*Loader, Version Control Software CVS, Element Tool for Production Support.

Confidential, Houston, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Understanding the existing business processes and Interacting with Super User and End User to finalize their requirement.
• Created PL/SQL Packages, Procedures, Functions and Triggers.
• Wrote PL/SQL code for data Conversion in there Clearance Strategy Project.
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 10g.
• Have extensive experience in developing efficient PL/SQL code for OLTP environment and ETL code for the Data Warehouse environment.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
• Created Batch jobs, daily jobs, one time jobs and queues.
• Developed complex Oracle Forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc.).
• Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
• Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
• Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
• Written PL/SQL Functions that return complex data types, collections and ref cursors to interface with Java programs.
• Maintaining different version of software (version control) using PVCS.
• Providing production support solving Tickets created using the software Element Tool.
• Preparing test plan for QA for testing before moving from PreProd to Production environment.
• Developed PL/SQL packages, collection of procedures and user defined functions for complex calculations and bundle them into stored package.

Environment: Oracle 11g, SQL Server, PL/SQL, Reports10g, Forms10g, Data Modeling, Data migration, SQL Navigator, Toad, Unix Shell Scripting, Window NT, AIX, FTP, SFTP, NDM, PL/SQL Developer, SQL*Loader, Version Control Software CVS, ElemenTool for Production Support.

Confidential, Houston, TX

Senior Oracle PL/SQL Developer

Responsibilities:

• Use Agile methodology for application development
• Support in requirements gathering from the end users
• Update design documents according to the changes made to the application
• Designed/developed/Modified tables, views, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Developed various Reports using the BI Publisher.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Cursors, Dynamic SQL, Table functionsas part of Project/Application requirements.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Implemented all modules logic by using Triggers and Integrity Constraints.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Code SQL Stored Procedures and integrated with application
• Involve in Unit Testing for the application developed using test cases.

Environment: PL/SQL, Oracle 10g, 11g, Java, Unix shell scripting, Oracle Forms, Oracle Reports, SQL Developer, BI Publisher, Informatica PowerCenter, Eclipse.

Confidential, CT

Senior Oracle PL/SQL Developer

Responsibilities:

• Analysis and enhancement upon source to target mappings
• Experience in data analysis & data cleansing
• Designed and developed database tables and loaded into new target Databases
• As - Is system analysis with special emphasis on system integration and data migration needs.
• Involved in Requirement Analysis, Design, Data Mapping, use cases and Client Interaction. This involves analyzing Functional Spec and designing Technical Spec.
• Technical Assistance for Development. Design and Develop of Logical and physical Data Model of Schema
• Gather the requirements and define the objective of your database, Gather Data, Organize in tables and Specify the Primary Keys, Create Relationships among Tables Relational Database Design
• Created an MS Access database to collect data systems in order to provide lists, status reports and management overview reports
• Designing the overall architecture for the system integration and data migration based on functional requirement.
• Review of the developed code to check for non - compliance to the technical specification and the coding standards and suggesting improvements to the same.
• Review of the performance testing results and providing inputs to the developers on how to modify the code to improve the performance.
• Providing the technical inputs to the DBAs and Data Modelers on the release.
• In addition to the aforementioned responsibilities, I also used to provide the technical assessment on the developed application in time to time.
• Causal analysis and fixing of the defects/bugs uncovered during the development.
• Attaining daily client meeting and providing reports to the project manager on the development quality.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Technology: Oracle 10g/11g, Red Hat Linux

Environment: PL/SQL, Oracle 10g, 11g, Access,Java, Unix shell scripting, Oracle Forms, Oracle Reports, SQL Developer, BI Publisher, Informatica Power Center, Eclipse.

Confidential, Dallas, TX

Oracle Developer

Responsibilities:

• Performed database and query tuning and performance monitoring.
• Involved in Requirement Analysis, Design, Data Mapping, use cases and Client Interaction. This involves analyzing Functional Spec and designing Technical Spec.
• Technical Assistance for Development. Design and Develop of Logical and physical Data Model of Schema
• Gather the requirements and define the objective of your database, Gather Data, Organize in tables and Specify the Primary Keys, Create Relationships among Tables Relational Database Design
• Monitored growth of data and managed space allocation accordingly.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity.
• Extensively written PL/SQL code for stored Procedures, Functions, Packages, Libraries and other database triggers etc. Written interfaces to transfer/interact data with various external systems.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Used package like DBMS JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.
• Backup strategies, scheduling the backups. Backing up and restoring the databases whenever necessary.
• Actively involved in coding SQL statements in PL/SQL.
• Developed various Complex Queries, Views for Generating Reports.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Used Quest TOAD to tune query performance.
• Performed off site on call 24x7 production support for Oracle 9i database administration activities.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Used Cursors both implicit and explicit to capture many rows within a PL/SQL block, and applied business rules on them.
• Created public synonyms on the database links for easy reuse.
• Created database links to retrieve data from multiple servers.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Made Forms customization on various existing forms.
• Use built-in functions in oracle forms.
• Created layout wizard and data block wizard in oracle forms.
• Created LOVs, record group in oracle forms.

Environment: Oracle 9i, PL/SQL, Windows 2000, SunOS 5.8, Crystal reports 9, SQL*Loader, TOAD 8.5, SQL Navigator, Oracle Forms 6i/Oracle Report 6i.

Confidential

PL/SQL Developer

Responsibilities:

• Designing Tables, Views, Cursors, Triggers according the requirements given in the design document.
• Writing code for stored procedures, functions according to the requirements.
• Involved in Requirement Analysis, Design, Data Mapping, use cases and Client Interaction. This involves analyzing Functional Spec and designing Technical Spec.
• Technical Assistance for Development. Design and Develop of Logical and physical Data Model of Schema
• Gather the requirements and define the objective of your database, Gather Data, Organize in tables and Specify the Primary Keys, Create Relationships among Tables Relational Database Design
• Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions extensively in coding.
• Executing the scripts and inserting data into the tables.
• Used SQL*Loader to load the database from flat files.
• Adding constraints, updating and altering tables according to the changes in the design documents.
• Documentation of Tables and Views.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.

Environment: Windows XP, Oracle 9i, UNIX, Toad, SQL *Plus.