OBJECTIVE

I am an Oracle certified PL/SQL developer with over 7 years of experience working on Oracle databases. Complementing my technical expertise are my sound oral and written communication skills.

PROFESSIONAL SUMMARY:

• Over 7 years of IT experience in Analysis, Design, Development, Implementation and support Of RDBMS in Production, Development and Test environments using Oracle Tools in client server environments.
• Involved in entire life cycle of implementation SDLC from business analysis to final deployment and testing.
• Experience in using Oracle related tools like SQL Loader, Toad, SQL Navigator and SQL Developer
• Experience using Erwin and SQL Developer tools to perform data modeling on Oracle databases.
• Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections.
• Coded test packages and performed unit testing of PLSQL code using utPLSQL framework and the SQL Developer unit testing package.
• Experience with Views, Materialized views, Cursors Implicit and Explicit , Ref Cursors, and External tables, table partitioning, Index partitioning and nested loops
• Extensive working knowledge on SQL Loader control programs, and PL/SQL validation scripts to transfer flat file data into oracle database tables
• Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables
• Advanced skills in Oracle database programming using PL/SQL Stored Procedures, Functions, Packages and Triggers , standard built-in Oracle packages
• Strong technical expertise in UTL FILE, DBMS SQL, DBMS OUPUT, DBMS UTILITY, DBMS JOBS packages.
• Experience in SQL or server level tuning using Explain Plan, TKPROF, STATSPACK Extensively used Cursors, Composite data type and Collections in writing the backend PL/SQL code
• Experience in writing UNIX shell scripts Korn, Bash, AW and SED in order to automate and schedule tasks.
• Excellent analytical skills, logical reasoning, interpersonal skills, problem solving skills and communication skills
• Strong management, administrative and leadership skills while working in a team.

TECHNICAL SKILLS

WORK EXPERIENCE

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Transformed and cleaned up the data from disparate schemas based on the mapping documents provided by the business owners. Loaded the data into the target tables to adhere to the business rules.
• Used Erwin to perform data modeling tasks like creating a relational model by creating various entities and developing relationships between the various entities in the database.
• Performed data modeling to create one to many and one to one relationships between various database objects based on the business rules.
• Extensively utilized various character, number, date and conversion functions.
• Good experience with Data Warehousing concepts and OLTP concepts. Wrote packages to perform updates to the Aggregate tables in the data warehouse. Also built queries and views against the star schema tables to feed the BI tool Business Objects .
• Created PL/SQL procedure to write out a shell script in order to run into the SQL loader tool. This was achieved through the use of the built in UTL FILE package.
• Also used the UTL FILE package to write data from RDBMS tables into a flat file XML and TXT which will reside on the local directory of the oracle machine.
• Utilized the utPLSQL framework to perform unit testing of the PLSQL code. Identified various test cases, built test packages and ran the unit tests to verify the PLSQL procedures and functions.
• Built SQL queries using the data dictionary that would provide insight into a table's structure and its foreign key and primary key relations. Also used the data dictionary to view the source code and also get information about various database objects.
• Further wrote PL/SQL programs that migrated data from a data warehouse database server to the data mart server while adhering to business rules. Business objects BO was used to given meaningful intelligence to this data in the RDS MARTS schema.
• Mentored junior interns and provided technical assistance. Conducted code review and suggested changes to improve the code readability and maintainability.
• Implemented performance tuning on the SQL statements to optimize the cost and cardinality of the query. Avoided full table scans through judicious and careful use of indexes. Reviewed the outer joins that were written by the team to make sure they didn't adversely affect the performance of the query.
• Rewrote some cumbersome queries on older Oracle 10g to use newer features of Oracle 11g like using Compound Triggers and using LISTAGG to get the correct results.
• Loaded data from different sources into the temporary data backup environment using SQL Loader
• Conducted testing of load procedures and packages to make sure that the business rules were correctly implemented. Helped junior developers with debugging their code when they were facing problems identifying where the load logic was breaking which lead to missing or erroneous data being loaded.
• Called the Procedures/Functions in separate audit packages in order to calculate event timestamps, various errors that were occurring along with their codes. Analyzed the audit log and audit error tables to identify occurring errors and rectify them through debugging.
• Involved in creating system documentation such as Technical Specification, Unit Test Plan, and Data Flow Diagram using MS-Word.
• Used SQL NAVIGATOR by Quest Software for the development and the applications and program units in PL/SQL.

Environment: ORACLE 10g/11g, SQL NAVIGATOR, utPLSQL, PL/SQL, SQL, SQL LOADER, Erwin, UNIX

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Aetna offers health care, dental, pharmacy, group life, disability, and long-term care insurance and employee benefits, primarily through employer-paid fully or partly insurance and benefit programs, and through Medicare. I was working as part of the backend database team on Oracle 10g. Was involved in development and maintenance of the various database objects like packages, procedures etc.
• Rewrote from the ground up, five separate packages with very similar logic into a single package. This was possible through parameterized procedures and by using dynamic SQL. Helped code maintenance and issue identification through debugging in a dramatic way.
• Extensively involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation and loading of data from source to target data structures.
• Created packages to implement the logic and provide backend support to a customer/claims application whose front end was written in JAVA. Implemented REF CURSORS to return record sets to the java application front end. Various selections and filtering of criteria were implemented into meaningful SQL queries. As this a front end application, users needed quick response time, hence utilized the explain plan to make sure the cost was low through implementing indexes.
• Utilized PLSQL tables and bulk collections to perform very quick loading of data. Used ROWID to write the queries to perform updates across the entire breadth of the data set. Again PLSQL table and bulk collections were used to perform even updates at a very quick pace.
• Used SQL Developer to perform data modeling tasks. Used SQL Developer to create ERDs Entity Relationship Diagrams for the selected tables in the particular schema.
• Used SQL Developer data modeler tool to create entity relationships and also to create database objects by generations DDL statements.
• Rewrote the entire PLSQL package which was being used to send daily load status updates to the testing team. The email formatting was not elegant and had a lot of misalignment. Used HTML tags in PLSQL to deliver a well-organized and readable email status update to the testing group.
• Also did unit testing of the PLSQL code by using the popular utPLSQL framework. Have experience using the SQL Developer to build test packages as well.
• Actively involved in optimization and tuning of SQL queries through utilizing the explain plan to find out the problem area of the query.
• Also performed optimization of PLSQL procedures. Resolved cursors of huge cost through proper used of splitting into parameterized cursors and then used inner loops to perform the needed operation much quicker.
• Extensively used SQL LOADER to load data into the target tables. Wrote control files based on the both positional mapping and for comma separated or tilde separated values.
• Provided support for the reporting team which was using crystal reports on the database. Analyzed and corrected the SQL queries to give the expected values.
• Wrote UNIX shell scripts to schedule time based loads for the Cron jobs.
• Implemented triggers that fired on detecting only updates that occurred on the column for logging purposes.
• Created VIEWS in order to support the reporting team and the BI team. Performed tuning of views and resolved cross joins that occurred and held up the BI team.
• Extensively worked with the BA and QA team to fix the defects that were logged through testing.
• Quest software's TOAD was used to do the PL/SQL development.

Environment: ORACLE 10g, TOAD, SQL Developer, PL/SQL, SQL, utPLSQL, JAVA STRUTS, CRYSTAL REPORTS, SQL LOADER, UNIX

Confidential

Role: Oracle PLSQL Developer

Responsibilities:

• Involved in development of an online banking application, which enables the bank's customers to access their various accounts through the Internet. The application also allowed the users to submit account related queries to the bank including, ordering checks, requesting copies of checks and statements, etc
• Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application
• Designed and developed master tables, views, sequences and synonyms
• Developed various Complex Queries, Views for Generating Reports
• Written Korn Shell Scripts, control files to load data into staging tables and DW tables
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Prepared final design documents and general instruction to follow during development.
• Performed the uploading and downloading flat files from UNIX server using FTP
• Fine-tuned the SQL queries using Explain Plan and applying appropriate hints and indexes
• Analysis of customer reported issues, which could be a code issues, Data fix issues, performance issues, setup issues, functional issues or an RDBMS issue.
• Effective Interaction with Support and other Application groups through on call for high priority issues
• Tuned SQL queries using Explain Plan, Analyze, Hints utilities to improve performance.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema

Environment: SQL, Oracle 10g, TOAD, PL/SQL, SQL LOADER, Reports 6i, Forms 6i, UNIX

Confidential

Role: PL/SQL Developer/Analyst

Responsibilities:

• The Hewlett-Packard Company is a multinational IT company. It offers products, technologies, software, solutions and services to consumers, enterprises, including customers in the government, health and education sectors.
• Involved in all stage of system Development Life Cycle SDLC : Scoping, Analysis, Design, Construction and testing
• Worked very closely with Business Analyst and Participated in business process evaluation/improvement activities
• Created Technical Design documents for major developments and attended Technical Design Reviews
• Designed and developed database stored procedure, package, functions and triggers
• Performed data modeling including reverse engineering using the Toad Data Modeling tool
• Loaded data in base tables from temporary tables using BULK COLLECT in stored procedure
• Used PL/SQL tables, array structures as a part of oracle collections
• Involved in data Integration send/load received data from different source
• Tuned SQL queries using EXPLAIN PLAN, Hints and SQL Plus Auto trace report for query optimization
• Working closely with quantitative analysts in a highly fast-paced environment to fix production issues and provide enhancements as per requirements

Environment: SQL, Oracle 9i, TOAD, PL/SQL, SQL LOADER, Reports 6i, Forms 6i, UNIX

Confidential

Role: Associate Database Developer

Responsibilities:

• Birlasoft is an Information Technology Services provider founded in 1995 and headquartered in India. The company provides software and consultancy to the banking, financial services, insurance and manufacturing industries.
• Wrote SQL queries, PL/SQL stored procedures and functions, following best practices regarding QA and implementation standards. Implemented the business logic using PL/SQL.
• Created and managed the database triggers and subprograms.
• Provided application support on a rotational basis for a number of intranet applications.
• Created documentation. Gathered requirements, wrote technical specifications, workflow diagrams.
• Conducted manual testing on applications. Created and executed test cases. Ensured bugs are logged and tracked through closure.
• Evaluated, examined and implemented user roles and assigned relative database access privileges. Conducted technical skill evaluation of new interns on the topics of SQL queries and PL/SQL stored procedures.