We provide IT Staff Augmentation Services!

Senior Oracle Pl/sql Resume

Dallas, TX

SUMMARY:

  • Accomplished results oriented PL SQL/Oracle Architect with over 9 years of extensive experience in Design, Development, Testing, Authoring Documentation and Support.
  • Extensively worked in Client - Server application environment using Oracle 11g/10g/9i/8i/6i7.x on Windows, UNIX/LINUX platforms and profound knowledge on 11g, SQL*Plus and Developer.
  • Experience in handling very large data files using Export-Import Utilities.
  • Experience in migration and conversion from Flat Files/MS Access/SQL-Server to Oracle and Oracle Applications base tables using Oracle SQL* Loader.
  • Well-acquainted in working with complex SQL queries with joins, inline functions, creating inbound and outbound interfaces, creation of automated processes using SQL Loader, External tables, BULK Load and UTL FILE.
  • Working as an Architect for the last 4 years in my current and previous organizations. My work lies grooming team members with advanced technologies Oracle SQL & PL/SQL etc., working with Senior Managers and Directors for scoping PoC’s.I also act as a Technical Delivery Manager for delivering on time and within budget, by creating BRS, HLD,DLD design documents for development, Customer Interaction, Getting Requirements, Managing Resources and Delivery.
  • Experience in translating complex business needs into technical specifications
  • Experience in managing projects from concept through implementation within time and budgets
  • Decisive and engaging leader combining impeccable relationship building skills
  • Talent for building and mentoring top-tier teams at different geographic locations
  • Worked as IT liaison to gather multiple non-IT development teams’ needs and convey requirements to executive management for approval
  • Experience of multiple SDLCs with Project Management skills
  • Experience of Business Continuity and SLA Implementation
  • Well versed in compliance
  • Solid experience in customer-facing environments
  • Experience in vendor interaction and negotiations
  • Skilled in detailed and meticulous documentation
  • Strong knowledge in Oracle Cursor management, Exception Handling, troubleshoot production problems and also revamped performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints.
  • Proficient in UNIX shell scripting to automate the FTP processes for receiving and sending the files and automating data loading, extraction, reports generation.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shells scripting, SQL, PL/SQL and implementing ETL design and development concepts, such as direct-path loading and parallel SQL.
  • Participated on building processes with sources from Flat Files, Mainframes, SQL Server, Oracle and also maintained documentation, definitions and mappings to support knowledge transfer to other team members.
  • Extensive Programming experience in deploying reports using Reports 12c/11g like matrix reports, group above reports and designed user interfaces with Forms 12c/11g on the web.
  • Strong knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling and also experience in Data warehousing concepts and Data mart building, Decision Support Systems using Informatica.
  • Experienced in preparing and analyzing Data flow diagrams, Data dictionary, Database Normalization theory techniques, E-R Modeling and design techniques.
  • Hands on experience with Arrays, Records, REF Cursors and Dynamic SQL.
  • Expertise in Designing, developing & Fine-tuning data Migration and data-retrieval scripts.
  • Translating business requirements into creation of database objects like Packages, Tables, Indexes, Constraints, Triggers, Stored Procedures, Functions, Triggers and Materialized Views.
  • Adept in using Oracle Tools like PL/SQL Developer, Toad, SQL Developer, Data Loader, SQL navigator and UTL FILE.
  • Good experience with the Partitioning tables, partitioning exchanges with the large size tables, parallelizing the DMLoperations based on the partition and sub partitions.
  • Experience in using Composite Data Types in Oracle and also using long data types like BLOB and CLOB.
  • Efficient in creating Test cases and performed data validation and process testing for application moving into production.

TECHNICAL SKILLS:

Project Management Tools: MS Project, Office, Excel, Visio, PowerPoint

Oracle Technologies: Oracle 12c,11g/10g/9i/8i/7.X, Oracle DBMS Installation on Oracle Enterprise Linux,, Created Partitions (table level, index level), RMAN Backup and Recovery, DataPump Export/Import, Oracle Enterprise Manager (OEM), Oracle Advanced Replication, SQL, SQL PLUS, SQL*Loader, External Tables for Data Loads, Stored Procedures & Packages, Triggers & Cursors, RefCursors, Snapshots, Materialized Views, Collections, BULK Collect, PL/SQL Developer Integrated Development Environment, PL/SQL Developer, Database design, Data extraction and data analysis, Oracle Performance Tuning and Optimization, Explain Plans.Oracle 11g/10g, RHEL Linux, IBM AIX, Sun Solaris, Windows, SQL, PL/SQL, C, Ksh, EMC Storage, NetApp Storage, SAP-Basis, MS Office Suite, SAP ECC 6.0, i2/JDA Technologies

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior Oracle PL/Sql

Responsibilities:

  • Worked in Data Warehouse Environment.
  • Having good expertise in all stages of full software development life cycle implementation (SDLC).
  • Good and thorough understanding of system development process, from initial planning through deployment.
  • Detailed user requirement Analysis, Design of systems and create ER diagram for project development.
  • Proficient in Unix Shell and awk scripting.
  • Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL, Informatica).
  • Developed PLSQL Packages/Procedures/Functions to populate data in to stage tables.
  • Solid experience in writing complex SQL queries and PL/SQL procedures to extract data into flat files from various source tables.
  • Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
  • Coordinated with DBA in creating and managing indexes, db links and privileges.
  • Testing and taking measures for maximum performance utilizing optimization hints.
  • Designed and developed data cleansing, data validation, load processes ETL using Oracle SQL and PL/SQL and UNIX.
  • Experience in working with relational databases such as Oracle and Netezza.
  • Well experienced in writing complex views for the reporting team.
  • Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes
  • Used SED and AWK in UNIX Shell scripting to correct the data issues.
  • Proficient in loading data from flat files into database tables using SQL*Loader scripts.
  • Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using inbuilt application.
  • Developed batch programs using UNIX shell scripts
  • Created relevant staging tables to load the CSV files, identified the business validation rules. Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
  • Tracked defects on regular basis and brainstormed offshore team to prevent the re-occurrence of the defects.
  • Good communication, interpersonal, analytical skills and strong ability to perform as a part of team.

Environment: Oracle Database 12c, Windows 10, UNIX, Toad, XML, SQL, PLSQL, UNIX Scripting, WINSCP, Putty, Visual Studio, SQL*LOADER.

Confidential, Los Angeles, CA

Sr. Oracle Pl/Sql Developer

Responsibilities:

  • Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures, Functions, Packages.
  • Developed both inbound and outbound interfaces to load data into targeted database and extract data from database to flat files.
  • Used FTP to transfer the files into different servers as per needed by the business users.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
  • Developed complex SQL queries using various joins and developed various dynamic SQL’s throughout the project.
  • Seasoned in optimizing query performance using Explain Plan, SQL Trace utilities
  • Created Custom Staging Tables to handle import data.
  • Involved in Unit testing of the Reports and PL/SQL Stored procedures.
  • Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions /enhancement on Oracle application.
  • Resolved deadlocks & contention issues.
  • Worked with different FTP clients (WinSCP) for loading data from the windows environment to the Unix environment.
  • Extensive experience in using Cursors and Ref-cursors for processing of data.
  • Tested the original and optimized codes thoroughly for failures before exporting to other environments.
  • Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Responsible for drafting documentation for end user usage and develop training materials.

Environment: Oracle Database 11g, Windows 7, UNIX, Toad, XML, SQL, PLSQL, UNIX Scripting, Oracle Forms Builder 10g, WINSCP, Putty, Visual Studio, SQL*LOADER.

Confidential, Wilmington, NC

Sr. Oracle Developer

Responsibilities:

  • Design, build, deliver, and support solutions to critical business requirements utilizing SQL, PL/SQL and reporting skills.
  • Used exception-handling methods along with RAISE APPLICATION ERROR in order to associate self-created exception names.
  • Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client's secure data transmission server.
  • Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
  • Developed PL/SQL Triggers on one table for automatic replication of data.
  • Experience in using Dynamic SQL, BULK COLLECT and VARRAYS.
  • Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Staging and also used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
  • Used PL/SQL Tables and Records in payroll generation process.
  • Develop various reports from scratch utilizing Oracle Reports for day to day validations.
  • Customized the Reports in Cross Tab Layout and Tabular Layout Formats.
  • Participate in the generation of User Interface using oracle forms by creating forms as per client requirements.
  • Involved in database development by creating PL/SQL Functions, Procedures, Packages, Cursors and Views.
  • Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
  • Created various custom reports like Transaction Aging Report, Credit Card Transaction Report, Active Invoice Register Report, Account Balance Consolidation reports and others using Reports Builder 6i.
  • Worked on Forms Personalization for Different Requirements.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN.
  • Applied Inline Views for coding the Pl/SQL programs building the Queries and Sub-Query's.
  • Data extraction/Transformation/Cleaning/Loading has been implemented using SQL Loader and PL/SQL.
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD.
  • Involved in testing backend SQL queries for query optimization.
  • Designed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
  • Created/Modified PL/SQL stored Procedures, Functions and Packages for moving the data from Staging to the Data Mart.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.

Environment: Oracle Database 10g, Oracle Forms 10g, Oracle Reports 10g, Windows XP, UNIX, PERL Scripting, SQL Developer, SQL* LOADER, XML, SQL, PLSQL, Unix Scripting, SECURE SHELL, TOAD, Clear Quest, Clear Case.

Confidential, King of Prussia, PA

Sr. Oracle Developer

Responsibilities:

  • Involved in all phases from requirement gathering, design, development, testing, production, user training and support for production environment.
  • Worked in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Business Intelligence (BI) applications.
  • Actively involved in Web Service Integration with oracle.
  • Data mapping process initialized and Architect the internal data structure for reporting.
  • Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
  • Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through HP quality center.
  • Used generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.
  • Moved large tables and data utilizing different techniques including bulk collect/for all techniques.
  • Migrated forms from 6i to 11g and recompiled them for validating any decommissioned features.
  • Involved in the generation of User Interface using Oracle Forms by extensively creating forms as per the client requirements.
  • Involved in Data Extraction, Transformation and Loading (ETL process) from source to target and worked on Windows Batch scripting, scheduling jobs and monitoring logs
  • Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
  • Created Mail Scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized Subject and Text.
  • Developed UNIX Shell Scripts with embedded SQL*Loader, expdp/Impdp calls and PL/SQL statements to extract data in the form of flat files for data loading and migration.
  • Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g and generated automating reports by validating converted data.
  • Created and monitored the Oracle DBMS JOBS as a part of weekly tasks.
  • Used CONTROL-M for scheduling the jobs with heavy dependencies.
  • Well versed with Bulk data loading process.
  • Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
  • Contributed with database designs and assisted in increasing response time for APEX reports.
  • Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.
  • Extensively used Hints to direct the optimizer to choose an optimum query execution plan.
  • Load balancing of ETL processes, database performance tuning and capacity monitoring.

Environment: Oracle Database 9i/11g, SQL, PLSQL, SQL Developer, Forms Builder 11g, Reports Builder 10g, ETL, Informatica Power Center 9.1, Pro*C, ERWIN, APEX, XML, UNIX, Perforce, WINSCP, PUTTY.

Confidential

Oracle Developer

Responsibilities:

  • Maintaining the Oracle Coding Standards and reviewing the Code and testing the Components.
  • Advise functional people at requirement time regarding custom components finalization.
  • Contributed in analysis, design and coding of Oracle processes in PL/SQL to build packages.
  • Developed Ref Cursors to accommodate the business rules.
  • Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers, Cursors using Oracle 10g.
  • Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
  • Analyzed the requirements and framed the business logic for the ETL process.
  • Extensively utilized the application object library to register SQL*LOADER programs, PL/SQL procedures, forms and reports.
  • Customized Form filed like enabling, disabling form filed and incorporating oracle alerts using form builder 9i.
  • Developed Grouping report and matrix reports using oracle reports 9i report builder.
  • Automated the source to target loads using UNIX shell scripting and CRONTAB.
  • Troubleshot errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Created Tables, Views, Materialized views, and constraints.
  • Involved in continuous enhancement, optimization and fixing of problems.

Environment: Oracle Database 10g, Oracle EBS, Windows XP, UNIX, SQL Loader, SQL Developer, PL/SQL Developer Oracle Forms 10g, Oracle Reports 10g, Discoverer10g, XML, SQL, PLSQL, VSS, WinSCP, Putty.

Hire Now