Summary:

• Oracle PL/SQL developer with over eight years of experience in Analysis, Design, Data Modeling.
• Implementation and Management of projects using Oracle
• Analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions as per Business Requirements.
• Solid experience in translating business requirements into creation of Database Objects, and working with Oracle 9i/10g/11g including PL/SQL programming.
• Expert in creating SQL Queries, PL/SQL Packages, Function, stored procedures, triggers, and cursors, Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL Plus, SQL Developer and Toad.
• Efficient in developing the Data model, ERD Diagrams and organizing the data as per the Business requirements.
• Robust knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables.
• 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.
• Created UNIX Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Worked on source control management tools like VSS, SVN and CVS.
• Experience in working with migration and development based projects.
• Hands on experience working on basic DBA tasks like deploying database objects, checking validity of newly created schema objects data pump activities, monitoring query performance on TOAD, checking table space before loading tables in a schema.
• Excellent analytical and interpersonal and communications skills and ability to work independently interacting with people at levels.
• Excellent communication skills and ability to act as a bridge between the users and management.
• Good knowledge and hands on experience in SDLC methodologies like Agile, Scrum to ensure efficient project management.

Technical Summary:

Experience:

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Understanding the current process of sending the files to the state from the plan partners
• Created PL/SQL Packages, Procedures, Functions and Triggers.
• 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
• 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

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

Confidential

Senior 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 OracleForms 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

Tools: 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

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 functions as 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.

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

Confidential

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.
• 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

Tools: TOAD 10.5, Putty, Autosys WCC , Informatica 7.1.2

Confidential

Oracle Developer Analyst

• Collected and collated appropriate data for use in databases and conduct related research.
• Coordinated with Business Analysts to convert Functional Requirements into technical Specifications.
• Worked on updating existing Oracle HR, Payroll MD 0.70 documentation.
• Tested already developed interfaces for usability.
• Prepared the required documentation to help the users navigate through the Oracle Applications.
• Analyzed the existing system and suggest necessary upgrades for Discoverer version.
• Modified existing procedures and packages.
• Participated in User Meetings to modify the existing HRMS applications.
• Extensively wrote custom packages, stored procedures, triggers, materialized views, functions using PL/SQL.
• Developed Year End reports using Sub queries, functions and procedures in PL/SQL and Oracle Reports Developer.
• Developed triggers and indexes for efficient data management.
• Defined expense report types that control reimbursement for different groups of employees.
• Developed control files for SQL Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system.
• Performed Data Validations, Data Conversions for bringing the data from legacy system to Interface Tables.
• Developed Perl Scripts, UNIX scripts for access to Oracle Database.
• Performed SQL tuning of existing procedures, packages and functions for faster query execution using Hints, TK Prof and Explain Plan utilities.
• Developed Dynamic SQL code for runtime query execution.
• Performed automation using UNIX/KORN shell scripts.
• Interacted with the DBA team for Performance Tuning and database issues.
• As a part of a team, successfully completed the design, development and implementation of the system.
• Worked on production support, bug fixing and enhancements.

Tools: Linux, Oracle 9i, TOAD, Java,Oracle Import Exports,SQL Developer, Oracle Human Resources and Payroll Applications, Discoverer, TOAD

Confidential

Role: Oracle Developer

Responsibilities:

• Performed database and query tuning and performance monitoring.
• Enforced database integrity using primary keys and foreign keys.
• 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.
• Managing Tablespaces, Rollback segment, Indexes for various applications like Financials Accounts, Inventory Control System and Payroll Personnel Administration System.
• Created parameterized reports and customized existing reports for presentations using Cross-Tab reports and Sub-reports and Running Totals/Formulas in crystal report.
• 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.
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.

Tools: 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:

• Writing code for stored procedures, functions according to the requirements.
• Designing Tables, Views, Cursors, Triggers according the requirements given in the design document.
• 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.

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