We provide IT Staff Augmentation Services!

Senior Oracle Pl/sql Developer Resume

Greater New York, AreA

SUMMARY

  • 10+ years of expertise in developing Oracle Database applications along with ETL/ELT in Various domains: Banking, Pharmaceuticals, Retail, Utilities and Telecom industries.
  • Expertise in building and developing high quality database applications with Oracle SQL and PL/SQL with proficiency in Oracle 12c/11g/10g/9i and UNIX Shell Scripting.
  • Proficient in developing and maintaining PL/SQL Packages, Procedures, Functions, Triggers, Joins, Sub Queries, Correlated Sub Queries, Views, Partitioning, Cursors and Ref - Cursors, Constraints, Transactions, Tables, Views, Materialized Views, DB links, Data Dictionaries and Indexes.
  • Excellent skills in writing SQL Complex queries using sub queries, nested sub queries and co-related sub queries along with set operators.
  • Expert in working with advanced concepts like Pipe Row, Nested Tables, Varrays, Records, Types, Bulk Collects and Bulk Variables.
  • Extensively used various techniques to analyze SQL queries and improve performance by tuning and optimization by using Hints, Indexes, Explain Plan, Trace Utility and TKPROF.
  • Good experience in Data Migration techniques using Oracle External Tables, SQL Loader, Import/Export and Batch Processing.
  • As an ETL developer, I have expertise in Datawarehouse and reporting tools like Informatica, Cognos Qlik view and OLTP and OLAP implementations and normalized data structures.
  • Experience in Data warehousing application development using Informatica Power Center Tools, i.e. Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Informatica Server and Repository Server manager.
  • Experience across all stages of Software Development Life Cycle (SDLC) including Requirement gathering, Design, Development, Unit Testing, Systems Integration and User Acceptance Testing and preparing technical design documents.
  • Extensive experience in Data base Development, Data base Modelling and advanced data analytics using tools like ErStudio, Erwin.
  • Extensive working with Incident management tool, service center, GIT and other tools for problem managements while working on applications.
  • Expert in working with ORDS installations and using the endpoints to fetch and consume XML formatted data from Views.
  • Extensive hands on with Oracle Golden gate technology to replicate the data.
  • Extensive hands on experience in tools like Toad, SQL Developer, Tableau, Putty, Control-M, Autosys, UC4, HP Service center, ITSME... etc.

TECHNICAL SKILLS

Databases: Oracle 12c, 11g, SQL Server 2012.

ETL Tools: Informatica Power Center, SQL Server SSIS

Reporting Tools: Tableau, Cognos, SSRS, QlikView

Languages: Oracle PL /SQL, T-SQL, SQL, Unix Shell Scripting, Python, Perl, Core Java

Tools: Toad, SQL Developer, Putty, SQL * PLUS, FileZilla, ERWIN Data Modeler, UC4, Autosys, Control M, HP Service Center, GIT hub, SVN, PVCS, ORDS, Oracle Golden Gate.

Operating Systems: Windows server 2010, windows 7, HP UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Greater New York Area

Senior Oracle PL/SQL Developer

Responsibilities:

  • Created scripts to create tables, views, queriesfor new enhancement in the applications.
  • Working with business analysts to gather new requirements and documenting them properly by writing technical/ functional design specifications documents.
  • Worked withSSIS packages to load data from flat files obtained from various facilities every day.
  • Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
  • Developed brand new PL/SQL and SSIS jobs to archive, restore, purge data from the system.
  • Extensively used Pivot, Unpivot concepts for creating reports from the views.
  • Developed reports with the help of Hierarchical and Analytical Query logics.
  • Involved in data loading from different source files usingPL/SQLandSQL*Loader.
  • UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Worked withmaterialized viewsto enhance the performance while retrieving the data.
  • Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
  • Implemented ORDS concepts to access the data directly from the views with a Token key and produce the same in XML format for business applications.
  • Worked with Golden Gate concepts to load or replicate the data from ARM database to Gas central Database.
  • Worked with DBAs to schedule or checking the performance related issues for Jobs.
  • Environment: Oracle 12c, PL/SQL, TOAD, SQL Developer, SQL Server Developer Tools, ORDS, UNIX, Shell Scripting, Visual Studio, UC4, HP Service center.

Confidential, Basking Ridge, NJ

Senior Oracle PL/SQL Developer

Responsibilities:

  • Involved in logical data modeling, including developing and maintaining data model diagrams E-R Diagrams, implementing physical designs, and facilitating data model requirements gathering.
  • Documenting business requirements, functional specifications and test requirements.
  • Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, SQL Developer.
  • Designed and Developed Triggers and Packages using PL/SQL
  • Created indexes on tables and Optimizing Stored procedure queries
  • Wrote Scripts for batch processing and data loading using SQL Loader.
  • UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Worked on both proactive and reactive SQL Tuning and Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of databases.
  • Partitionedthe tables andmaterialized viewsto enhance the performance.
  • Extensively usedbulk collectionin PL/SQL objects for improving the performing.

Environment: Oracle 12c, 11g, Toad, SQL Loader, UNIX Shell Scripts, Putty, ERWIN 7.1, Cognos, UC4, HP Service center, GIT Version control tool.

Confidential, Miami, FL

Oracle PL/SQL Developer

Responsibilities:

  • Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
  • DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
  • Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
  • Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
  • Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
  • Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
  • Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
  • UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
  • Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.
  • Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
  • Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g, PL/SQL, TOAD, SQL plus, Informatica, Putty, UNIX, Shell Scripting, ERWIN 7.1, Cognos, UC4, HP Service center.

Confidential, Peapack, NJ

Senior PL/SQL & ETL Developer (CSC India)

Responsibilities:

  • Handled the requirement gathering by participating in meetings with the clients on regular intervals, closely worked with Business Analyst and Project manager for the proper requirements documentation.
  • Analyze the user requirements and prepare proper technical design documents relevant to proceed for the development.
  • Impact analysis on the existing data objects available in the GRW environment.
  • Created and maintained database objects like Tables, Views, Sequences, Synonyms, Indexes, Stored Procedures, Triggers, Transactions, Functions and Packages.
  • Created materialized views to load the data by refreshing it in regular intervals so that it can be useful for the downstream users.
  • Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions.
  • Worked by partitioning table techniques when table is having huge data for data accessing and performance improvements.
  • Worked onSQL*Loader and Import/Exportto load data from flat files obtained from various facilities every day.
  • UsedException Handlingtechniques extensively for the ease of debugging and displaying the error messages in the Application.
  • Created and modified UNIX shell Scriptsaccording to the changing needs of the project.
  • Developed test cases and performedUnit Testing and Integration Testingof the Repositories.

Environment: Oracle 11g, PL/SQL, TOAD, SQL plus, Putty, ERWIN 7.1, UNIX, Shell Scripting, Cognos, Control M, HP Service center, People soft HRMS, GIT Version control tool.

Confidential, New York

Oracle PL/ SQL Developer (CSC India)

Responsibilities:

  • Responsible for proper orders and purchase related data loading into smart-ops optimizer from different inbound systems and similarly processed data back to those out bound systems.
  • Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
  • Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Worked in PLSQL code tuning SystemAnalysis, Design, Coding, Testing, Developmentand documentation.
  • Created and maintained all databaseobjectssuch asTables, views, indexes, sequences, constraints, procedures, functions.
  • Created materialized views to load the data by refreshing it in regular intervals so that it can be useful for the downstream users.

Environment: Oracle 10g, PL/SQL, Autosys, SQL plus, Putty, ERWIN Modeler, Toad, SQL Developer, UNIX Shell Scripting, Control M

Confidential, Cleveland, Ohio

Informatica &PL/SQL Developer (TCS India)

Responsibilities:

  • Analyzed the requirements and framed the business logic for the ETL Processes.
  • DevelopedData AnalysisforErwin LogicalandPhysical modeldesign and worked on ER diagrams.
  • Ensuring proper data quality control after migrations.
  • Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.
  • Worked with millions of transactions/huge volume of data on day to day basis.
  • Extensively used Bulk Collection in PL/SQL Objects for improving the performance.
  • Created Mappings using Designer, Extracted the data from the flat files and other RDBMS databases into staging area and loaded onto Data Warehouse.
  • Performed Unit Test and Integration Test to make sure the deliverable is match with business requirement.

Environment: Oracle 10g, PL/SQL, Informatica Power center, Erwin data modeler, SQL plus, Putty, Toad, UNIX, Shell Scripting.

Confidential

Production Support Executive

Responsibilities:

  • Maintaining the TIPPS frontend application which was developed by using Oracle Forms and Reports.
  • Creating Cursors and Ref cursors as a part of the stored procedures to retrieve the selected data.
  • Extensively used partitioning of tables when working with tables having huge historical data.
  • UsedBulk Collections andBulk Variables forbetter performanceand easy retrieval of data by reducing context switching between SQL and PL/SQL engines.
  • Creating UNIX shell scripts to automate the loading of data from vendors through SQL* Loader and to connect to SQL plus and execute the packages and procedures that are created.
  • Worked on resolving different Analysis requirements ARs, Business requirements BRs and Change requirements CRs.

Environment: Oracle 10g, PL/SQL, TOAD, SQL * Loader, UNIX, Autosys, Putty, FTP and ITSME tool.

Hire Now