We provide IT Staff Augmentation Services!

Sr Oracle Pl/sql/ Developer Resume

Boston, MA

SUMMARY:

  • Over 9+years of professional experience in IT industry as Oracle SQL/PLSQL/data modelingand Analysis, Design and Modeling.
  • Strongknowledge on oracle architecture and data base design.
  • Strong Data modeling experience using ER diagram, Dimensional data modeling, Logical/Physical Design, Star Schema modeling, Snow - flake modeling using tools like Erwin, ERStudio.
  • Good knowledge of Data modeling using ETL tools, LAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams
  • Excellent skills in designing and development of applications using Oracle, SQL,PL/SQL Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.
  • Experienced in all phases of Software Development Life Cycle (SDLC).
  • Excellent SQL skills, experience writing complexqueries and working with database objects like tables, views, sequences, synonyms .
  • Expertise in developingadvancedPL/SQL code throughvarious stored procedures, functions, cursors, triggers, packages and materialized views.
  • Experience in Bulk Data loading using Oracle utilities namelySQL* Loader and External Tables.
  • Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQLTrace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.
  • Working Knowledge on Unix and Windows.
  • Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export , SQL*Loader and UTL FileUtilities .
  • Developing reports using Informatica ETL tool.
  • Created Database constraints like Primary key and foreign key using RDBMS concepts.
  • In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL,T-SQL using database tools like Toad, SQL Navigator.
  • Worked on Version Control Software.
  • Experienced in using Business intelligence toolOBIEE.
  • Expertise in Mathematical and Modeling and Numerical Analysis.
  • Excellent planning,analytical, written communication and Interpersonal skills.

TECHNICAL SKILLS:

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake ModelingFACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin

Frontend tools: TOAD, SQL Developer, PLSQL Developer.

Databases: Oracle 11g/10g/9i/8i.

GUI: Oracle Forms 6i/9i/10g and Reports 6i/9i/10g, Sales Force.

ETL & BI Tools: Informatica, ETL, Knowledge on OBIEE 11.1.1.7.1 , Knowledge on ODI 12c

Programming: SQL, PL/SQL, T-SQL, UNIX Scripting.

Operating Systems: Windows XP/2003/2000/NT/98/95/7, UNIX.

WORK EXPERIENCE:

Confidential, Boston, MA

Sr Oracle PL/SQL/ Developer

Responsibilities:

  • Writing complex packages, SQL, PL/SQL, stored procedures, functions, and triggers.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus , SQL Developer, PL/SQL Developer and TOAD.
  • UTPLSQL for unit testing plsql packages.
  • Merge statement to insert and update existing records.
  • Modified and debugged several PL/SQL programs for performance tuning SQL queries using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
  • Worked onOnline transaction system, handled high volume of data.
  • Work with developers to design and write complex packages to support their needs.
  • Experience working in a development and/or production database environment for a large scale, complex application involving on-line and batch environments.
  • Work with Database Administrators to implement design changes and new packages.
  • Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching. Global temporary table to generate the data dynamically for reporting purpose.
  • Used Materialized views for by weekly reporting and refreshing on demand.
  • Writing SQL*Loader and External table scripts for the DDL's. Fixing bugs in .txt,.csv and. dmo files.
  • Created Bat files and run in batch environment.
  • Worked with Bulk Collects and for all to improve the performance of multi-row queries by reducing the context switching. Worked on Types and type records.
  • Experience in database designs based upon identified business rules and using Oracle 10g/11g or higher.
  • Created Database constraints like Primary key and foreign key using RDBMS concepts.
  • Experience in performing knowledge transfers to client staff of Oracle database administrator techniques supporting the development of database structure for the new architecture.
  • Created indexes on some of the columns on the tables to increase the application's performance.
  • Worked on informatica mapping to load data from file to oracle table.
  • Writing pl/sql procedures for ETL process.
  • Unit testing using UTPLSQL.

Environment: Oracle 12c/11g r4,Informatica, pl/sql developer, GIT, Jenkins, Jira U deploy, UNIX, Putty, SQL Developer, TOAD, Citrix, HTTPS and SSL.

Confidential, Albany, NY

Sr Oracle PL/SQL/ODI Developer

Responsibilities:

  • Participated in database design within an existing Oracle database structure.
  • Helping Application Development team in preparing technical designs and perform construction activities.
  • Writing complex packages, SQL, PL/SQL, stored procedures, functions, and triggers.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus , SQL Developer, PL/SQL Developer and TOAD.
  • Worked onOnline transaction system, handled high volume of data.
  • Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
  • Loading data into fact tables using complex pl/sql Packages.
  • Worked onStar and Snowflake Data Models for Enterprise Data Warehouse.
  • Work with developers to design and write complex packages to support their needs.
  • Experience working in a development and/or production database environment for a large scale, complex application involving on-line and batch environments.
  • Work with Database Administrators to implement design changes and new packages.
  • Modified and debugged several PL/SQL programs for performance tuning SQL queries using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
  • Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching. Global temporary table to generate the data dynamically for reporting purpose.
  • Used Materialized views for by weekly reporting and refreshing on demand.
  • Writing SQL*Loader and External table scripts for the DDL's. Fixing bugs in .txt,.csv and. dmo files.Created Bat files and run in batch environment.
  • Worked with Bulk Collects and for all to improve the performance of multi-row queries by reducing the context switching. Worked on Types and type records.
  • Experience in database designs based upon identified business rules and using Oracle 10g/11g or higher.
  • Created Database constraints like Primary key and foreign key using RDBMS concepts.
  • Experience in performing knowledge transfers to client staff of Oracle database administrator techniques supporting the development of database structure for the new architecture.
  • Experience Building and Maintaining Oracle Tables.
  • Experienced in defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules
  • Used Microsoft TFS and Visual Studio for Check out/check in the scripts
  • Created indexes on some of the columns on the tables to increase the application's performance.
  • Convert VB scripting to pl/sql packages.
  • Writing pl/sql procedures for ETL process.
  • Used SVN to check-in the code.
  • Create and used existing PL/SQL stored procedures, packages and views for use in BI Reports on Oracle 11gr2 /12c.

Environment: Oracle 12c/11g r4,ODI 12c,pl/sql developer, SVN, TFS, Quality Center, UNIX, Putty, SQL Developer, TOAD, Citrix, HTTPS and SSL.

Confidential, Rensselaer, NY

Sr Oracle PL/SQL/Developer

Responsibilities:

  • Participated in requirement and design sessions.
  • Working on agile environment.
  • Participated in database design within an existing Oracle database structure.
  • Helping Application Development team in preparing technical designs and perform construction activities.
  • Work with developers to design and write complex packages to support their needs.
  • Perform team lead tasks when necessary.
  • Code checking in Team foundation server (TFS) and adding required projects.
  • Wrote complex functions and procedures for new packages and update existing packages in an established Oracledatabase using pre-defined business rules.
  • Work with Database Administrators to implement design changes and new packages.
  • Performance testing and rewriting of production code/SQLstatements&procedures performing badly, identified by Database Administrators.
  • Provide database support to developers who write code using WCF, WPF and .Net.
  • Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model and physical model.
  • Created Database constraints like Primary key and foreign key using RDBMS concepts.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus , SQL Developer, PL/SQL Developer and TOAD.
  • Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader and External tables .
  • Converted VB codeand SQR reportsinto PL/SQL packages and discuss with the .net developers to change per their requirement.
  • Support the application through the testing and implementation phases, including product test, stress/load test etc.
  • Preparing Analysis and testing documents for testers. Functionality testing.
  • Experience monitoring and tuning the general performance of the Oracle database.
  • Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
  • Worked with Bulk Collectsto improve the performance of multi-row queries by reducing the context switching. Extensively used for all and bulk collect to fetch large volumes of data from table
  • SYS CONTEXT to check the information of oracle environment.
  • Experience in database designs based upon identified business rules and using Oracle 10g/11g or higher.
  • Reverse engineering the exiting data model.
  • Understand and meet referential data integrity requirements
  • Building UNIX shell scripts for data migration and batch processing.
  • Implemented a variety of ODI interfaces, packages, procedures, scenarios for extracting and loading data into target sources
  • Experienced in defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules
  • Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
  • Implementing ETL in pl/sql procedures.

Environment: Oracle 11g r2/ 12c, ODI 11.1.1,, TOAD, TFS, Quality Center, UNIX, SSH Putty, SQL Developer, TOAD, Citrix, HTTPS and SSL.

Confidential, Pittsburgh, PA

Oracle Data modeler/ PL/SQL Developer

Responsibilities:

  • Interacted with the Business Analysts in understanding the business requirements for the project.
  • Working on agile environment. With every day status updates
  • Gathered the requirements from the users and analyzed their business needs and created SRS documents.
  • Involved in SDLC including designing, coding and testing.
  • Implemented Oracle ERP as SalesForce ERP.
  • Writing Technical design documentation. Data warehouse environment
  • Created logical data model (LDM) and made appropriate changes to make compatible with the business logic.
  • Created Physical Data Model (PDM) for the OLTP application using Erwin 9.0.
  • Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
  • Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
  • Table Partitioned by creating a table in to smaller level partitions based on date. Usually we do for Saving storage space and Performance issues instead of querying whole big table.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus , SQL Developer, PL/SQL Developer and TOAD.
  • Defined database requirements and designed data model
  • Extensively used Dynamic SQL for calling procedures, Created Forced Views
  • Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
  • Writing SQL*Loader scripts for the DDL's. Fixing bugs in .txt,.csv and .dmo files.
  • Resolving complex issues and investigating the root cause of the issues.
  • Extensively used for all and bulk collect to fetch large volumes of data from table.
  • Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader . Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
  • Created Indexes for faster retrieval of the customer information and enhance the database performance.
  • Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Developing and maintaining conceptual, logical and physical dimensional data model to ensure the information models are capable of meeting end user and OBIEE developer needs.
  • Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI and CDC.
  • Implemented a variety of ODI interfaces, packages, procedures, scenarios for extracting and loading data into target sources
  • Developing Slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 and Type3 as a part of Performance Tuning in ODI.

Environment: ODI 11.1.1,Oracle 11g/10g, PL/SQL, SQL Navigator, UNIX, Windows XP, WINCVS, SSH, SQL Developer, PLSQL Developer, TOAD, PowerBuilder 9.0.

Confidential, Roseland, NJ

Oracle Data modeler/ PL/SQL Developer

Responsibilities:

  • Interacted with the Business Analysts in understanding the business requirements for the project.
  • Gathered the requirements from the users and analyzed their business needs and created SRS documents.
  • Involved in SDLC including designing, coding and testing.
  • Created logical data model (LDM) and made appropriate changes to make compatible with the business logic.
  • Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
  • Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader . Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
  • Generated XML using the Procedures, Functions and Packages.
  • Writing Technical design documentation.
  • SQL tuning of queries.
  • Worked in agile mereology environment.
  • Defined database requirements and designed data model.
  • Extracting data from Sql server database to oracle database using Informatica.
  • Created Schema Using the XML schema.
  • Worked on performance tuning and used Explain Plan, TKPROF and SQL trace for tuning the queries.
  • Writing SQL*Loader scripts for the DDL's. Fixing bugs in .txt,.csv and. dmo files.
  • Extensively used for all and bulk collect to fetch large volumes of data from table
  • Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
  • Created Indexes for faster retrieval of the customer information and enhance the database performance.
  • Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.

Environment: Oracle 11g/10g, PL/SQL, OBIEE, SQL Navigator, UNIX, Windows XP, WINCVS,XMLSpy, SSH, SQL Developer, PLSQL Developer, TOAD, Erwin.

Confidential, Stamford, CT

Oracle PL/SQL Developer

Responsibilities:

  • Interacted with the Business Analysts in understanding the business requirements for the project.
  • Gathered the requirements from the users and analyzed their business needs and created SRS documents.
  • Worked in agile mereology environment.
  • Involved in SDLC including designing, coding and testing.
  • Created Data models using ER STUDIO Data Architect 9.1 by understanding the business requirement.
  • Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus , PL/SQLandTOAD.
  • Tuned complex stored procedures for faster execution and developed database structures according to the requirements .
  • Extensively used for all and bulk collect to fetch large volumes of data from table
  • Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
  • Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader . Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
  • Worked on performance tuning and used Explain Plan, TKPROF and SQL trace for tuning the queries.
  • Created Indexes for faster retrieval of the customer information and enhance the database performance.
  • Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
  • Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Used OBIEE Web Catalog to set up groups, access privileges and query privileges.
  • Created and modified several UNIX Shell Scripts per the changing needs of the project and client requirements.

Environment: Oracle 11g/10g, PL/SQL,Oracle Forms 10g, Reports10g, SQL Navigator, UNIX, Windows XP,T-SQL,Putty, Serena Team Track, AIX and, WINCVS, ERstudio

Confidential, Cincinnati, OH

OraclePL/SQL Developer

Responsibilities:

  • Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
  • Worked as part of the development team, along with the Systems Analysts/Business Analysts.
  • Analyzed and fixed the data discrepancies between various systems and identified bad data caused due the data migration from various legacy systems.
  • Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model and physical model.
  • Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, db links and privileges
  • Created PL/SQL Stored Procedures, Functions, Packages, and Triggers; extensively used Cursors, REF cursors, User-defined object types, Records, forms and reports in PL/SQL programming
  • Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
  • Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
  • Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN and TKPROF.
  • Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
  • Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.
  • Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers
  • Effectively used Triggers to track the user profile updates and to send the messages to downstream systems
  • Resolving complex issues and investigating the root cause of the issues.

Environment: Oracle 11g/10g/9i,Oracle Forms 10g, Reports10g, PL/SQL, UNIX Shell Scripting, Toad, ER-Win Windows XP,Net, ERstudio, OBIEE (10.3.4.1)

Confidential

Oracle Developer

Responsibilities:

  • Analyzed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
  • Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
  • Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
  • Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
  • Developed / modified scripts to create tables, views and executed them using SQL Plus.
  • Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
  • Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
  • Prepared the procedures to update the internal structures to reflect the newly loaded data.
  • Used batch scripts to loop from database to database, to perform system-wide functions.
  • Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.
  • Worked with front end Java developers to convert PL/SQL Stored procedure into Java programing language.

Environment: Oracle 9i, TOAD, SQL Navigator, Putty, Windows XP.

Hire Now