SUMMARY:

• Over 8 years of progressive IT experience as an Oracle PL/SQL developer with the strong background of working knowledge in all the phases of System Analysis, Designing, Testing, Development & Support of Oracle 11g/10g with strong analytical, programming skills and having solid functional experience in the production, development, implementation and the maintenance of oracle database.
• Expert in creating SQL Queries, PL/SQL packages, functions, stored procedures, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in SQL performance tuning using Cost - Based Optimization (CBO)
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Expertise in handling errors using Exceptions of PL/SQL programs.
• Making structural changes to the database objects.
• Proven background developing Web services, packages, procedures, and applications/modules of PL/SQL.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
• Knowledge of command in UNIX/LINUX.
• Excellent knowledge in using Views, Synonyms, Indexes, Sequences, Joins and Sub-Queries.
• Proficient knowledge in Data Modeling and ER Diagram.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Expert knowledge in using data modeling tools like ER diagrams with Normalization Techniques for designing database with Relational technology.
• Good knowledge of using Function Based Indexes, Sequences and Inline Views.
• Monitoring and giving 24*7 Application Production Support to meet service level.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team
• Strong interpersonal and communication skills in dealing with customers/Business Users.

TECHNICAL SKILLS:

• SQL
• PL/SQL
• Oracle 10g/11g
• Visual Source Safe
• TOAD
• PL/SQL Developer
• SQL Developer
• SQL*PLUS
• SQL*Loader
• Star Schema/Snowflake Schema Modeling.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Oracle PL/SQL developer/Data modeler

Responsibilities:

• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Involved in writing several complex SQL Queries and Pl/SQL Procedures.
• Built database in PL/SQL objects like Tables and Views.
• Involved in the Database Design (Relational and Dimensional models) using ERwin.
• Defined both logical views and physical data structures using ERwin.
• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Designed Physical and Logical Data model and Data flow diagrams.
• Experience in Generating Reports.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Extracted required data from the database tables using PL/SQL program and exported the data to different sources in different formats.
• Worked with several tools to access and perform several operations on database.
• Used joins, indexes effectively in where clauses for Query optimization.
• Worked very closely with the ETL developers for the Enterprise Data Warehouse Development, Designed Control Tables, and Tuned PL/SQL Blocks for long running jobs and Troubleshooting of various issues.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: PL/SQL, SQL Developer, Toad, SQL* Plus, Oracle 10g/11g, ERwin, UNIX.

Confidential, San Diego, CA

Senior Oracle PL/SQL Developer

Responsibilities:

• Developed applications by using SQL queries and implemented PL/SQL codes by using Procedures, Functions, triggers and Packages.
• Executed and maintained SQL and PL/SQL statements to insert update and delete database applications by using tables, views, constraints and packages.
• Wrote Procedures, packages, SQL sub queries and PL/SQL fundamentals to ensure that data is populated into the correct tables and data integrity is maintained.
• Extensively used SQL loader to load data into the database.
• Utilized performance enhancements feature of Oracle to optimize query and the batch processes.
• Created procedures and work flows pertaining to the collection and assessment of CRA information.
• Optimized the queries.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Performance tuning of SQL Stored Procedures.
• Involved in Troubleshooting, fixed and implemented bug fixes and enhancements within tight deadlines
• Build ad-hoc reports.
• Created SQL Loader scripts to load data into the temporary staging tables.
• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

Environment: PL/SQL, SQL Developer, Toad, SQL* Plus, Oracle 10g/11g, ERwin, UNIX.

Confidential, PA

Data Modeler/ SQL Developer

Responsibilities:

• Involve in project kickoff meetings to understand the need and scope of the project.
• Attend cross team meetings with project business Analysts and technical leads to gather basic requirements to create a high level project diagrams
• Perform data profiling in Production environment to analyze and collect the statistical information.
• Design the logical diagrams according to UHS standards for initial review with Technical leads.
• Analyze the relationship between the entities based on the requirements and define STAR and Snowflake schema models in Erwin.
• Maintain metadata of all the new and existing models in Erwin to be readily available for business users.
• Apply normalization techniques on data set and embed them in the model
• Forward engineer logical models into physical tables with Health data set naming standard class words.
• Analyze the table structure based on the size and design indexes to boost the performance.
• Maintain the script versions in WinCVS to deploy in QA environments.
• Coordinate with DBAs during deployments and troubleshoot the issues if any.
• Document the workflow in high level and detail level for future reference and enhancements.

Environment: PL/SQL, SQL Developer, Toad, SQL* Plus, Oracle 10g/11g, ERwin, UNIX

Confidential, NYC

Database Developer

Responsibilities:

• Built appropriate stored procedures for Oracle database queries which provide report content to implement technical design specifications.
• Extensively worked with Dynamic SQL stored procedures to generate the reports in data driven website.
• Provided Oracle database object suggestions to improve performance for poorly performing queries.
• Worked extensively with Oracle 10g for the generation of new student financial reports.
• Work directly with the application team to build efficient SQL statement to maximize performance
• Monitored long running process
• Design suitable partition table with partition index, materialized view and proper indexing methods to achieve maximum performance
• Developed PL/SQL module(s) to sweep the database and perform maintenance changes.
• Wrote and modified procedures and triggers based on business needs
• Gave recommendations and possible benefits to the Information Systems team

Environment: PL/SQL, SQL Developer, Toad, SQL* Plus, Oracle 10g/11g, ERwin, UNIX.

Confidential,

SQL Developer

Responsibilities:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application

  Environment: Oracle 8.3, SQL * Plus, TOAD, SQL*Loader, Forms 4.5 & Reports3.0 and Windows 2000 professional, UNIX shell scripting.