SUMMARY

• Over 6+ years of experience in developing and implementing database applications as oracle PL/SQL developer.
• Excellent skills in designing and development of applications using Oracle 11g/10g/9i, SQL and PL/SQL.
• Created Business Requirements Specification (BRS) document that gives detailed information about the requirements.
• Good knowledge of data modeling techniques includes virtually every flavor of Entity - Relationship (ER) modeling, Physical and Logical data modeling.
• Involved in all phases of Software Development Life Cycle (SDLC) including gathering requirements, Analysis, Design, Development, Testing, Implementation and supporting database applications.
• Experienced with high transaction based (OLTP) and analytical (OLAP) environments.
• Profound knowledge on Oracle and ETL tools like SQL*PLUS, SQL Developer, TOAD, Informatica Power Center 8.6/9.5 and used them in development of applications.
• Proficiency in solving issues after an application release in production.
• Experience in translating business requirements into creation of Database objects.
• Expertise in creating database objects like Tables, Synonyms, Sequences, Triggers, Indexes, Views and Materialized Views.
• Expertise in using Analytical functions, Bulk Collect, Oracle supplied packages like UTL FILE and DBMS LOB.
• Proficient in writing Packages, Stored Procedures, Functions and Triggers using SQL and PL/SQL in Oracle.
• Good at PL/SQL advanced features like Cursor variables, Ref Cursors, Varrays, Nested tables and Dynamic SQL.
• Used ETL tools like Informatica to extract, transform and load needed data.
• Experienced in extraction, transformation, loading data from various sources into Data Warehouses and Data Marts using complex SQL and PL/SQL code.
• Proficient in developing SQL with various relational databases like Oracle, Sybase and SQL Server.
• Experienced in query performance tuning by analyzing tables and using utilities like Explain Plan, SQL Trace and TKPROF.
• Good at using various Oracle Hints, Indexes and Partitions effectively to optimize SQL queries.
• Excellent experience with tuning the database applications, normalization and denormalization, partitioning of data and indexing of partitioned tables.
• Good experience in User Acceptance Testing (UAT), Unit testing and System Integration testing (SIT).
• Very good at writing user acceptance test cases based on the business requirements and technical documentation.
• Working knowledge of migration of code from Development to SIT, UAT and Production.
• Good Knowledge of UNIX Shell Scripting.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Proven ability to interface and coordinate with cross-functional teams and cultures, to design and implement database solutions.
• Versatile to learn and work with new technologies.

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/XP/7/8, Windows 98/95, LINUX and UNIX

Software/ Applications: Microsoft Outlook, MS Visio, Microsoft Office

Databases: Oracle 11g/10g/9i, SQL server, Sybase 12.5/15.5

ETL: Informatica Power Center 8.6/9.5

Tools: SQL developer, SQL* PLUS, Toad, Eclipse, WinSCP, FileZilla, Putty, Power Designer 15.3, BMC Control-M 8.0.00, JIRA

Languages: SQL, PL/SQL, PostgreSQL, UNIX Shell scripting

PROFESSIONAL EXPERIENCE

Confidential, Jamesburg, New Jersey

Sr.Oracle PL/SQL & ETL Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Responsible for designing and developing new Databases, Schemas and Table spaces.
• Worked extensively in an Agile environment utilizing a Test Driven Development approach to design and code the application.
• Used JIRA v6.3.12 to create user stories, plan sprints, track issues and assign the user stories to respective people.
• Analyzed the system requirements and created logical and physical data models using Power Designer v15.3 and Toad Data Modeler v4.1 tools.
• Maintaining high level of documentation by following proper naming standards to the entities and relationships.
• Performed data validation after loading the data to staging database.
• Wrote complex SQL queries to generate the status reports for management activities.
• Created PL/SQL Packages, Functions and Procedures to implement the business logic.
• Created Database Triggers for audit and validation purpose.
• Developed complex SQL and PL/SQL queries required to retrieve data from data repository using cursors, joins and sub-queries.
• Used Bulk Collect, Implicit and Explicit Cursors for performing complex data.
• Involved in archival of historical data to maintain the database space.
• Extensively used Informatica Power Center v8.6 to load data from flat files into the staging tables.
• Involved in performance tuning and query optimization for faster execution and bulk load process.
• Used Oracle hints like Append, Append Values (11g feature) or Bulk inserts to optimize insert performance.
• Worked to improve the performance of database applications and user reports, by analyzing Explain Plan for various scripts, partitioning and indexing the large tables.
• Developed UNIX shell scripts to generate flat files from the oracle database by executing the stored procedures.
• Responsible for Database Migration from Oracle 10g to 11g.
• Prepared UAT and SIT Test Cases based on the functional and technical documents.
• Performed data analysis, testing, debugging, audits and disaster recovery.
• Involved in transferring the files from one server to other using FTP (File Transfer Protocol) and SFTP.

Environment: Oracle 10g/11g, SQL*PLUS, SQL Developer 2.1.1, Toad Data Modeler4.1, Eclipse 5.0.0, Informatica Power Centre 8.6/9.5, Agile, JIRA.

Confidential, Omaha, NE

Oracle PL/SQL Developer

Responsibilities:

• Responsible for gathering requirements from client and designing application based on requirements.
• Participated in transforming the Business requirements into Functional specs and technical design documents.
• Developed and maintained complex data models and logical database designs.
• Worked very closely with the functional team to understand their development related requirements.
• Designed and developed Table structures along with Triggers, Sequences, Partitions, Indexes like Bitmap and Function based Indexes.
• Created many generic Packages, Stored Procedures, Functions, Database Triggers, Tables, Indexes, Views and Sequences using SQL and PL/SQL.
• Developed Unix Shell scripts and PL/SQL Procedures to extract and load data into database.
• Created appropriate Cursors, Ref Cursors, Collections, Records, Bulk Collect and For All for accessing complex data resulted from joining of large number of tables.
• Wrote complex SQL queries using joins, sub-queries and correlated sub-queries.
• Extensively used SQL and PL/SQL programming in back end and front end Functions, Procedures and Packages to implement business logics/rules.
• Used PRAGMA AUTONOMOUS TRANSACTION to avoid mutating problem in database triggers.
• Hands-on experience in Exception handling and Cursor management in PL/SQL.
• Improved the performance of procedures in legacy applications by rewriting the logic with collections.
• Developed new Procedures to load eligible data into the target table on various business criteria using the MERGE statement.
• Tuned SQL queries to enhance performance by using Explain Plan, SQL Trace, TKPROF and AWR reports.
• Involved in performance tuning of application with the help of other team members and Oracle support.
• Involved in creating unit test cases and SIT Test Cases, code reviews and status updates to closely monitor the development throughout its life cycle.
• Responsible for validating all the database changes, when the changes are migrated to different environments and supporting them.

Environment: Oracle 10g/9i, TOAD, SQL Developer, Toad Data Modeler, Tortoise, Winscp, Putty, Agile.

Confidential, New York

Oracle PL/SQL & ETL Developer

Responsibilities:

• Responsible for designing schemas to ensure that the relationship between data is guided by unique key constraints.
• Involved in designing Technical specifications from Functional Specification documents.
• Created database objects like Tables, Views, Indexes, Partitions, Sequences, Synonyms and Triggers for the database application development.
• Extensively worked on Explicit Cursors for manipulating row-by-row in one of oracle database applications.
• Responsible for generating new files, modifying or updating the existing files as needed by using the oracle supplied package i.e UTL FILE.
• Used SQL* Loader and Unix Shell scripts to load data from various sources into an Oracle Database.
• Developed Materialized Views for the base tables of other databases in order to avoid redundancy of data.
• Involved in extracting, cleansing, transforming and loading data from flat files, Excel files into Oracle database using PL/SQL Procedures, Functions and Packages.
• Used various partitioning methods like Range, Hash, List to reduce the cost of storing and retrieval of large amounts of data.
• Extensively used advanced PL/SQL concepts like Varrays, PL/SQL tables, Nested Tables and User defined object types.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created Indexes and partitions on tables for faster execution of SQL, PL/SQL queries and to enhance the database application performance.
• Extensively used oracle supplied packages like DBMS PROFILER, DBMS JOB and DBMS SQL.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Developed Shell Scripts for batch processing and database transactions.
• Involved in application testing, preparing and maintaining documentation in the upgrade of Oracle 9i to 10g.
• Extensively involved in production support and solved critical issues, after the database application moved to production.
• Developed complex SQL and PL/SQL queries to generate reports as per business request, as a part of production support.

Environment: Oracle 10g/9i, PL/SQL, SQL*PLUS, SQL Developer, SQL*Loader, Toad, UNIX Shell Scripting, Putty, WinSCP, Water Fall Model

Confidential

Oracle PL/SQL & ETL Developer

Responsibilities:

• Actively participated in different phases of application development like Requirements gathering, Designing, Coding, Implementation and Maintenance using primarily Oracle PL/SQL batch processing.
• Involved in designing and maintaining Physical and Logical Data Models for the project.
• Participated in application designing and preparation of DCD (Database Change Document) based on the client requirements.
• Developed SQL scripts to create and drop database objects including Tables, Views, Indexes, Constraints, Sequences, Synonyms and Grants.
• Developed database Triggers, Packages, Functions and Stored Procedures using PL/SQL and maintained the scripts for various data feeds.
• Created various validation scripts for business teams to validate the batch against business requirements.
• Developed Inline Views and Materialized Views for data recovery of the reports.
• Wrote complex SQL queries using Inner/Outer joins, SET operators and Analytical Functions.
• Extensively used Index algorithms like B-tree, Bitmap for faster retrieval of information and to enhance the performance of application.
• Involved in loading data from flat files into database tables using External Table (Oracle 9i feature).
• Extensively created UNIX shell scripts, stored procedures and processes to extract data from various sources such as SQL Server and Oracle 9i.
• Involved in supporting and maintaining oracle Import, Export and SQL*Loader Jobs.
• Good at performance tuning, debugging and error handling.
• Involved in performance tuning of complex PL/SQL queries using Explain Plan and Hints.
• Worked with QA team to perform UAT testing and troubleshooting.

Environment: Oracle 9i, Oracle PL/SQL, SQL*PLUS, SQL Developer, Toad, SQL*Loader, UNIX