SUMMARY:

• More than 7 years of experience with 10g and 11g as an Oracle Developer and Oracle Consultant, developing back - end modules such as packages, functions, procedures, triggers, object types, and views for multitier business applications of OLTP systems in SQL and PL/SQL.
• Worked under a complete Agile/Scrum environment and followed all the Agile methodologies and practices
• Extensive experience in writing/debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links (DBLINKS), Sequences, Synonyms, External Tables and Global Temporary tables.
• Experience with Partitioning strategy and design and worked with Oracle Redefinition partition legacy tables
• Performed manual testing and built test script and also worked with the PLSQL Unit testing framework
• Strong knowledge in using Oracle built-in packages (like UTL FILE, UTL SMTP, DBMS JOB, DBMS SCHEDULER), Cursor management, Exception handling etc.
• Vast experience tuning Complex Queries and performance bottlenecks (using Explain Plan, HINTS, SQL Trace, TKPROF and SQL Profiler).
• Experience in version control software such as GIT, PVCS, Clear Case, SVN for code management.
• Experience in the development of Control M scheduling for batch processing
• Experience in database concepts, SQL tuning, materialized views, index strategies.
• Experience in enforcing data integrity using integrity constraints & database triggers.
• Experience in External Tables, SQL*Loader, Export, Import.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle) to Oracle system Using SQL *LOADER, Appropriate Interface tables and APIs
• Experience in all phases of the Application Development Cycle - Design, Coding, Testing, Maintenance and Documentation.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Extensive and very intense SQL coding and development experience for OLTP database.
• Experience using TOAD and PL/SQL Developer for query building, analysis, and manipulations of databases to check compatibility and integrity of RDBMS.
• Fair understanding & working knowledge of UNIX - Shell Scripts.
• Experience in supporting the various production issues addressed by the users from the client side and providing them with required solutions.
• Excellent investigative, interpersonal skills and a team leader with very good communication skills.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g

Oracle Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, SQL*Plus

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003, ER studio, Power Designer

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing.

Scheduling Tools: Control M

ProgrammingLanguages: Oracle Pl/Sql, Unix, XML, Matlab, Labview, C

CI Tools: Bamboo, Maven

Environment: Sun Solaris 2.6/2.7/2.8/8.0, Red Hat Linux, Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

PROFESSIONAL EXPERIENCE:

Confidential, Timonium, MD

Database Developer

Responsibilities:

• Research existing database and develop better solution
• Developed PL/SQL packages and database triggers.
• Designed partitioning strategy and worked with Oracle Redefinition to partition legacy tables
• Designed and created tables, global temporary tables, views, materialized views and other database objects.
• Developed various programs using Native Dynamic SQL and REF CURSORS.
• Wrote PL/SQL packages, functions, procedures for batch framework jobs automated via Control M
• Extensively worked in development of Control M batch processes
• Involved in handling Exceptions through PL/SQL Blocks.
• Assisted in the initial tuning of several database objects.
• Extensively worked on all type of Analytical Functions
• Developed UNIX shell scripts for regular maintenance
• Conducted peer design and code reviews and extensive documentation of standards, best practices.
• Loading data into tables from flat file via temporary tables using SQL * Loader and PL/SQL External Tables
• Developed Database Triggers for the integrity.
• Did manual testing and build test script and also worked with the PLSQL Unit testing framework.
• Wrote push and rollback scripts for any database modifications such was creation, deletion or alteration of any database structures
• Participation in reviewing code and ensuring testing, facilitate code delivery to production environments
• Worked with Account Receivable systems like FDR and TSYS with functional domain knowledge of Payment domain system
• Worked under a complete Agile/Scrum environment and followed all the Agile methodologies and practices

Environment: Oracle 11g, PL/SQL, TOAD, SQL Loader, ER Studio, Putty, Bamboo, UTPLSQL Unit Test, GIT, SVN, Eclipse, Control M

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL packages and database triggers for OLTP systems.
• Designed and created tables, global temporary tables, views, materialized views and other database objects.
• Developed various programs using Native Dynamic SQL and REF CURSORS.
• Wrote PL/SQL packages, functions, procedures etc for Online Transaction Process (OLTP).
• Involved in handling Exceptions through PL/SQL Blocks.
• Assisted in the initial tuning of several database objects.
• Extensively worked on all type of Analytical Functions (RANK, DENSE RANK, LAG, LEAD etc.)
• Developed various UNIX shell scripts for regular maintenance.
• Conducted peer design and code reviews and extensive documentation of standards, best practices.
• Loading data into tables from flat file via temporary tables using SQL * Loader and PL/SQL.
• Involved in the development of a migration tool to convert data from the existing database to the required database format.
• Developed Database Triggers for the integrity.
• Did manual testing and build test script.
• Participation in reviewing code and ensuring testing, facilitate code delivery to production environments.

Environment: Oracle 10g, PL/SQL, TOAD, SQL * Loader, UNIX, SQL*Loader, TOAD, Windows 2000, HP-UNIX.

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system
• Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.
• Use TOAD tool to access the database
• Used PL/SQL developer to create PL/SQL Procedures
• Testing PL/SQL procedures against the test cases.

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database Tools/Utilities, Oracle Enterpris6e Manager (OEM)