We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

St Louis, MO

PROFESSIONAL SUMMARY:

  • Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
  • Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data warehousing tools and technologies such as ODI.
  • Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling (Data Marts, Facts and Dimensions.
  • Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.
  • Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and Varrays), Records, Object types and Database Triggers.
  • Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, SQL*plus, iSQL*plus, SQL Developer and SQL Navigator.
  • Expertise in generating customized Forms and Reports using Oracle Forms and Reports 6i/9i.
  • Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.
  • Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance.
  • Strong experience in Oracle ETL data loading techniques like UTL FILE, SQL loader, Copy Command and External tables from various business source environments.
  • Strong knowledge of UNIX Shell Script on Sun Solaris 2.8/2.7 and HP UNIX 12.x/11. x and Worked on KORN Shell Scripts to write maintenance script for Oracle.
  • Exposure in Oracle Applications 11i Oracle Financials (AR, AP, GL modules of Oracle Applications 11i in multi Org, multicurrency environment
  • Experience in writing ANT build scripts to automate the compilation, creating directory structures, generate classes from WSDL, deploy the services onto the Web Server, and generate JAR and WAR files.
  • Ability to work in a team environment and as an individual with strong technical and communication skills, and good zeal in adapting new technologies in a fast-paced environment.

TECHNICAL SKILLS:

Oracle 8i/9i/10g/11g, MS: SQL Server 7/2000, MS Access.

Languages: C, C++, COBOL HTML/DHTML, XML, PERL and T-SQL.

Scripting: SQL, PL/SQL, UNIX Shell Scripting.

Reporting Tool: Business Objects, Crystal Reports.

ETL Tool: ODI.

Query Tools: TOAD, SQL Developer, Pro*C, SQL Navigator, SQL* Plus, iSQL* Plus.

Operating Systems: HPUX, Solaris 7.0/8.0, MVS, Windows 2000/NT/XP/7/98 and UNIX.

Developer 2000: Forms 6i/9i, Reports 6i/9i.

Micro Soft Office Suite MS: Word, MS-Excel, MS-Power point.

Other Tools: SQL*Loader, MS-Visio, MS Project Professional 2003, PVCS, VSS, IBM

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Oracle PL/SQL Developer

Responsibilities:

  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DBMS SQL and PL/SQL collections and used BULK binding involved in writing database procedures, packages and functions for front end module.
  • Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic using SQL Navigator.
  • Used SED and AWK in Unix shell scripting to correct the data issues in the SQL-Loader data file.
  • Extensively used the advanced features of PL/SQL like Records, Tables, ObjectTypes and DynamicSQL.
  • Programmed in UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
  • Oracle Forms developed and deployed in all UNIX environment through Dev, Test and Prod in an Oracle Applications environment.
  • Build proper test cases for QA team.
  • Coordinated with different teams in designing and implementation of business process enhancement plans.
  • Provided technical assistance for development and testing of functional design for new solutions.
  • Used Informatica file watch events to pole the FTP sites.
  • Extensively used SQL Loader and UTL FILE methods to load the fixed length, csv and pipe delimited flat files from Mainframe and DB2 into the Oracle database.
  • Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.
  • Involved in ETL code using PL/SQL to meet requirements for Extract, Transformation and Loading of data from source to target data structures.
  • Extensively used ODI ETL tool to create data warehousing OLAP model.
  • Experience in ODI designer, Topology, Operator and ODI tools.
  • Maintained documentation for technical systems.
  • Responsible for preparing as well as review of all documents.

Environment: Oracle 10g, 11g, 12c, SQL PLUS, PL/ SQL, SQL*Loader, TOAD, SQL Developer, Shell Scripts, UNIX, Pro*C, Windows XP, MS-Excel

Confidential, Herndon, VA

Oracle PL/SQL Developer

Responsibilities:

  • Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic using SQLNavigator.
  • Created database objects Tables, Views etc.
  • Generated server side PL/SQL scripts for data manipulation and validation for remote instances.
  • Involved in creating Unix Shell Scripting. Defragmentation of Tables, Partitioning, compressing and Indexes for improved performance and efficiency.
  • Designed and Developed SSIS Packages.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DBMS SQL and PL/SQL collections and used BULK binding involved in writing database procedures, packages and functions for front end module.
  • Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in System Development Life Cycle.
  • Used principles of Normalization to improve the performance.
  • Utilized Oracle technical tools such as SQL Developer, TOAD, and Oracle Workflow to develop solutions to support the business and to enhance functionality based on business requirements.
  • Involved in ETL code using PL/SQL to meet requirements for Extract, Transformation, Cleaning and Loading of data from source to target data structures.
  • Filtered and Loaded data from different formats of data sources into database tables.
  • Prepared and Validated QA, UAT and PROD Release scripts/Packages.
  • Used SED and AWK in Unix shell scripting to correct the data issues in the SQL-Loader data file.
  • Involved in the continuous enhancements and fixing of production problems.
  • Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.
  • Provided the Production and Technical support for the users.

Environment: Oracle 10g, 11g, 12c, SQL PLUS, PL/ SQL, SQL*Loader, TOAD, SQL Developer, Shell Scripts, UNIX, Pro*C, Windows XP, MS-Excel

Confidential, Minneapolis, MN

Oracle PL/SQL Developer

Responsibilities:

  • Designed and developed Packages, Procedures and Functions
  • Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data Loading Process and Reporting systems.
  • Involved in performance tuning of codes.
  • Providing support during implementation.
  • Oracle installation, configuration, management and support. (12c, 11g, 10g)
  • Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, functions, procedures, packages, triggers and cursors.
  • Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partitioned tables).
  • Build proper test cases for QA team.
  • Extensively used the advanced features of PL/SQL like Records, Tables, ObjectTypes and DynamicSQL.
  • Process annual redeterminations for Medicaid clients that are associated with Family health plans.
  • Processed 60 to 80 claims daily.
  • Determined if a Claim is payable via regulations,plan benefits as well as policies and procedures.
  • Involved in ETL code using PL/SQLto meet requirements for Extract, Transformation and Loading of data from source to target data structures.
  • RAC configuration Oracle 9i/10g/11g/12c.
  • Designed and Developed Oracle Forms and Reports using Forms 11g and Reports 11g, including Forms based on stored procedures.
  • Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analysts.
  • Developed Forms screens used by Oracle developer suite for Forms Procedures, Functions and Packages generate to end product of forms.
  • Responsible for preparing as well as review of all documents.
  • Extensively used SQLLoader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
  • Developed Complex UNIX shell scripts and Autosys jobs for the scheduling and automation of the application jobs execution.
  • Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
  • Applied technical skills using SAS, Tableau and SQL in data collection, data analysis and reporting to procure data from data structures to report and provide solutions to client requests in a timely manner.
  • Installed ODI. Set up the ODI connection with Oracle and Flat files.
  • Created ODI packages, scenarios using interfaces, variables, procedures.
  • Performance tuned the ODI interfaces.
  • Used ODI commands like ODI file move, ODI fileappend, odifilecopy etc.
  • Used Data Warehousing tools like OBIEE, ODI and JDeveloper.
  • Developed mappings/sessions using Informaticapowercenter 9.6 for data loading
  • Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 10g, 11g, 12c, SQL PLUS, PL/ SQL, SQL*Loader, TOAD, SQL Developer, Shell Scripts, UNIX, Pro*C, Windows XP, MS-Excel

Confidential, Englewood, CO

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Requirement gathering.
  • Creating Functional design.
  • Reviewing technical design and code.
  • Offshore coordination.
  • Implementation and execution.
  • Pl/SQL programming which includes Packages, Stored procedures, Functions, Cursors, Triggers.
  • Build proper test cases for QA team.
  • Coordinated with different teams in designing and implementation of business process enhancement plans.
  • Provided technical assistance for development and testing of functional design for new solutions.
  • Used Informatica file watch events to pole the FTP sites.
  • Effectively worked in Informatica version 9.6 based environment and used deployment groups to migrate the objects.
  • Designed Oracle Forms and Reports for complex projects.
  • Programmed in UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
  • Oracle Forms developed and deployed in all UNIX environment through Dev, Test and Prod in an Oracle Applications environment.
  • Support modules for implementation using PL/SQL scripts, UNIX shell scripts and Pro*C.
  • Upgraded and supported Oracle Business Intelligence and trained end users.
  • Developed SQL scripts, BI architecture and units for documentation and analysis
  • Designed data mart using dimensional data modelling using ETL tool.
  • Extensively used ODI ETL tool to create data warehousing OLAP model.
  • Experience in ODI designer, Topology, Operator and ODI tools.
  • Maintained documentation for technical systems.
  • Responsible for preparing as well as review of all documents.

Environment: Oracle 10g, 11g, SQL PLUS, PL/ SQL, SQL*Loader, TOAD, SQL Developer, Informatica, Teradata, Pro*C, Shell Scripts, UNIX, PERL, Windows XP, MS-Excel

Confidential, Pataskala, Ohio

Oracle PL/SQL Developer

Responsibilities:

  • Helping the team members in construction of codes.
  • Fixing code related bugs.
  • Designed and developed Packages, Procedures and Functions.
  • Involved in performance tuning of codes.
  • Providing support during implementation
  • Designed Oracle Forms and Reports for complex projects.
  • Developed custom forms and reports as per client requirements and making them web enabled using oracle reports builder 10g and Oracle forms builder 10g respectively.
  • Programmed in UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
  • Oracle Forms developed and deployed in all UNIX environment through Dev, Test and Prod in an Oracle Applications environment.
  • Performance tuned the ODI interfaces.
  • Used ODI commands like ODI file move, ODI fileappend, odifilecopy etc.
  • Good knowledge on BI(Version 11.1.1.7.140715 Build 140622. bit) tool- OBIEE.
  • Developed and managed complete data migration process in multiple organization.
  • Established a productive data migration system by troubleshooting and generating error free process.
  • Trained team members to evaluate, coordinate and provide error free data migration solution.
  • Fixing code related bugs and testing the migrated data for integrity.
  • Plans data integration process by developing common definitions of sourced data.
  • Validates data integration by developing and executing test plans including data design, test design, networks and hardware.
  • Delivers data integration by implementing shared databases.
  • Strong experience in writing PERL scripts covering data feed handling.
  • Providing workflows and other information required in the development of code of the PERL scripts.
  • Debugging, troubleshooting and maintenance of existing PERL scripts and modules.
  • ETL jobs creation and customization using ODI.
  • Creating variables, sequences, user functions, procedures, packages in ODI.
  • Develop data extracts from the data warehouse environment using ODI.

Environment: Oracle 10g, 11g, SQL PLUS, PL/ SQL, Pro*C, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Tableau, Windows XP, MS-Excel

Confidential, Cleveland, OH

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data Loading Process and Reporting systems.
  • Designed and developed a huge database of 120 tables and its data load process from flat files and also designed complex functional views for Payroll application.
  • Analyzed, Designed and developed Oracle Forms 10g queries, layout, report triggers, parameter form, data models etc.
  • Designed Oracle Forms and Reports for complex projects.
  • Oracle Forms developed and deployed in all UNIX environment through Dev.
  • Extensively used SQL Loader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
  • Designed and developed the Packages, procedures, functions efficiently in loading, validating and cleansing the data. Also worked on creating users and roles as needed for the applications.
  • Extensively used UTL SMTP and windows blat techniques to develop the monitoring processes to automatically notify the source systems, administrators and users through email alerts on missing feed files, unsuccessful job runs and load status of scheduled load processes and backup jobs.
  • Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, functions, procedures, packages, triggers and cursors.
  • Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partition tables).
  • Effectively worked in Informatica version 9.6 based environment and used deployment groups to migrate the objects.
  • Created new mapping designs using various version tools in Informatica designer.
  • Developed mappings/sessions using Informatica PowerCenter 9.6 for data loading.
  • Strong experience in writing PERL scripts covering data feed handling.
  • Providing workflows and other information required in the development of code of the PERL scripts.
  • Debugging, troubleshooting and maintenance of existing PERL scripts and modules.
  • Assisting junior PERL developers in the development of scripts.
  • Experience in development of ELT and ETL mapping in ODI.
  • Resolved ODI related issues faced by the team members.
  • Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
  • Worked on Production support for the backend database and reporting applications.
  • Involved in importing Source Tables from the different databases.
  • Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
  • Involved in continuous enhancement, optimization and fixing of problems.

Environment: Oracle 10g/11g, PL/SQL, SQLLoader, PERL, ODI, SQL*Plus, Windows NT 4.0/2000/XP and UNIX

Confidential, Sunbury, PA

Sr. ETL/ Data warehouse Developer

Responsibilities:

  • Analyzed Business Documents, Internal & External Source systems and Requirements to develop Enterprise Data warehouse (Star Schema) Logical and Physical Model (Facts and Dimensions) and Business Process Model.
  • With Business Analysts and clients, Analyzing and assessing the business specifications and designing and developing the POPS and Equifax applications.
  • Involved in Extraction, Transformation and Loading (ETL) of the data from the Heterogeneous databases.
  • Extensively used SQL Loader and UTL FILE methods to load the fixed length, csv and pipe delimited flat files from Mainframe and DB2 into the Oracle database.
  • Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.
  • Developed stored procedures, functions, packages and DB triggers extending the functionality and for retrieving the data from the database for solving complex queries.
  • Created Stored Procedures, functions and Packages in Oracle 10g using SQL and PL/SQL for the Audit Trail using Oracle 10g as backend.
  • Involved in debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database using Explain Plan, hints and also worked on Partition tables using Range method.
  • Worked on table partitioning (Range and List) and deploying local indexing on partitioned tables.
  • Creating Test scripts for the generated final Reports.
  • Provided the Production and Technical support for the users.
  • Prepared technical documentation of all modules for user level and system level maintenance.
  • Created promotion scripts and documents for migrating objects from one database instance to other instances.

Environment: Oracle 10g, SQL PLUS, PL/ SQL, SQL*Loader, XML, Korn Shell Scripts, Cognos, Windows XP, MS-Excel, Solaris and HP-UX, TOAD.

Confidential - Dublin, OH

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in gathering business requirements, clarification and system design.
  • Extensively worked in End-to-End phases of the application design, development, testing, production deployment and documentation.
  • Prepared prototypes for the system design & approach and participated in business users presentations.
  • Developed Complex UNIX shell scripts and Autosys jobs for the scheduling and automation of the application job's execution.
  • Involved in Source code release to higher environments (QA, UAT and Production) using the IBM Rational ClearCase version control tool.
  • Developed PL/SQL packages, procedures, functions, Indexes, SQL scripts for the implementation of the very complex business requirements.
  • Implemented the COPY command successfully to insert huge amounts of data into the target system from ODS.
  • Developed validation programs to validate the data before importing into the payables table.
  • Designed, developed, tested and implemented using Oracle Forms using Forms 6i/9i.
  • Responsible for Designing, development, testing and deployment of Oracle Alerts, Triggers and debugging for Oracle Forms.
  • Developed PL/SQL packages and database triggers and Improved performance of the extract - loads and existing applications for huge volumes of data by optimizing the queries, indexing and redesigning some of the scripts.
  • Extensively supported production for all the UNIX, Autosys, Oracle and Reporting issues.
  • Used Cron Jobs to schedule various reports.
  • Prepared test data and expected results for the system testing with possible business functional scenarios to make the system bug-free.
  • Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
  • Supported BOXI reports testing and prepared expected results using complex SQL queries.
  • Involved in System testing, Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and walkthroughs.

Environment: Oracle 10g, PL/SQL, SQL*Plus COPY, BOXI, SQL*Plus, Windows XP and UNIX, IBM Rational ClearCase.

Hire Now