Oracle Pl/sql Developer Resume
Juno Beach, FL
SUMMARY:
- An Assertive professional with 5 years and 6 months of IT experience handling all phases of SDLC like analysis, design, development, implementation and deployment of large software products in both Client/Server and Web Server Environment.
- Experience in Lean, Agile, Scrum and Kanban, specializing in business value identification and realization.
- Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g/12c using SQL, PL/SQL.
- Expertise in Database Design, Development, and Enhancement and Maintaining using Oracle 12c/11g/10g/9i/8i, Web deployment, PL/SQL Forms 10g/9i, Oracle SQL Loader in Windows and UNIX environments.
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
- Expert in Designing SSIS Packages to Extract, Transform and Load (ETL)/ DTS data into the data warehouse from heterogeneous databases such as Oracle, DB2, MS Access.
- Expert in migrating the DTS Packages to SSIS Packages by using Package Migration Wizard.
- Proficient in using T - SQL for creating Stored Procedures, Tables, Views, Indexes, SQL joins and performance-based query writing.
- Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
- Proficient in PLSQL programming, designed and developed Stored procedures, Functions, Triggers, and Packages to provide database access and manipulation functionality
- Developed and Automated batch load process using SQL*Loader, Shell scripts and Crontab
- Used oracle features like Collections, Ref cursors, Analytical functions, Global temp tables, External tables and Materialized views
- Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer & full suite of Oracle Tools including development and customization of Oracle Developer (Reports & Forms) and Oracle discoverer.
TECHNICAL SKILLS:
Databases: Oracle 8i/9i/10g/11g/12c, MySQL 5, MS SQL SERVER 2005/2008, DB2/UDB, SAP Tables and MS Access
Other Technologies: HP Project and Portfolio Management (PPM), HP ALM/QC, Oracle E-Business Suite 12, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM)
Programming Languages: SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, Perl, XML, HTML, VB.NET
ETL Tools: IBM Info Sphere Data Stage, Informatica
Data Warehousing: Star & Snow-Flake Schema Modeling, Erwin, Sybase Power Developer, SSIS, SSRS, OWB, ODI
Dev. Tools: Windows/Linux/Mac OS Environment, Eclipse, Git, XCode, Subversion (SVN), CVS, ClearCase.
Tools:: TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Crystal Reports, Forms 6i/9i/10g, Reports 6i/9i/10g, Work Flow Builder and XML Publisher.
PROFESSIONAL EXPERIENCE:
Confidential, Juno Beach, FL
Oracle PL/SQL Developer
Responsibilities:
- Worked on the bulk uploading of huge amounts of statistical data to the database.
- Wrote Loader scripts using SQL Loader/External tables to load large tables.
- Designed and developed the classes using core Java for thread safety in money transactions using Multithreading.
- Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.
- Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required.
- Performed maintenance work on the database.
- Analyzed data integrity problems and provided assistance in giving solutions.
- Actively involved in troubleshooting database issues.
- Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications.
- Developed Oracle Stored Procedures, Functions and Packages to effectively in corporate Business rules.
- Worked with Dynamic SQL, Global Temporary Tables. Created materialized views, Inline Views & normal views where business requirements needed.
- Worked in Oracle reports and forms version 6i and 10g.
- Worked on Pro*C programs and PL/SQL Scripts to generate full extracts of large tables.
- Extensively used bulk collection in PL/SQL objects for improving the performing. Developed stored procedures and packages. Extensive work in PL/SQL. Developed Reports and forms using Oracle Designer.
- Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.
- Worked on developing/supporting Oracle APEX applications. Our group supports numerous Oracle APEX applications.
- Resources are needed to help support additional applications that will be acquired by our team. They will need to provide run the engine and production support. They will also be asked to perform risk assessments and add needed controls to close any control gaps.
- Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation. Knowledge of both Microsoft and Linux operating systems.
Environment: UNIX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Oracle Pro*C, Microsoft Excel, TOAD, APEX 4.4.2 SQL, PL/SQL, SQL*Loader, Reports6i, Toad, HP-UX UNIX, XML
Confidentia, Rochester, NY
Oracle PL/SQL Developer
Responsibilities:
- Generated Drill down, Drill through, Adhco, Matrix Reports, parameterized reports using MSBI (SSRS).
- Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column.
- Created various database objects like tables, views, materialized views, procedures, functions and packages using oracle tools like Toad, SQL Developer and SQL* plus.
- Extensively used bulk collection in PL/SQL objects, partitioned the fact tables and materialized views for improving the performance.
- Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
- Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
- Transferred SQL and Korn shell programs into ODI and created data extracts.
- Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
- Involved in Importing and exporting the Tables, Users, and Schemas.
- Designed DW tables, scripts, ETL maps and ODI Extracts, Configured ODI modules and ETL tools and supported accessible applications, and Documented and maintained ETL specifications and processes.
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
- Created tables, views, stored procedures, functions, CTEs and indexes to support database and ETL applications.
- Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using SSIS.
- Designed and tracked specialized metrics to provide transparency through Agile maturity process, including cost per point, estimation variance, team velocity and release scheduling.
- Data migration (import & export - BCP) from Text to SQL Server.
- Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources (SQL Server, Oracle, DB2 etc.).
- Experience with custom development of data warehouse, operational data store, and OLTP systems.
- Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.
- Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, TOAD, UNIX, Shell scripting, MS SQL Server 2014/2012, SSIS/SSAS/SSRS.
Confidential, Pittsburg, PA
Oracle PL/SQL Developer
Responsibilities:
- Involved in development, maintenance of Triggers, Joins, Cursors and Views.
- Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
- Created Shell scripts to access data and setup runtime environment, and to run Oracle Stored Procedures, Packages.
- Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
- Optimized the performance using PL/SQL table types and record types.
- Provided Lean/Agile process development and improvement advisory services to enable and enhance value delivery from work intake process to deployment and evaluation.
- Did SQL and PL/SQL programming for ODI and oracle.
- Developed AR Credit memo and AR Customers forms.
- Worked extensively with ODI Designer, operator and metadata Navigator.
- Played a key role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
- Participate in upgrading Oracle database(s) and Oracle Warehouse Builder to Version 11.2.0.4
- Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
- Wrote SQL queries to developed test data for use during test execution.
- Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.
- Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers.
- DataStage jobs were scheduled, monitored, performance of individual stages was analyzed, and multiple instances of a job were run using DataStage Director.
Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g,CVS, TOAD, UNIX, Shell scripting, HP PPM, Oracle Warehouse Builder 11.2.0.2, Subversion (SVN), CVS, Perl, MS SQL Server 2012/2016, SQL Server Integration Services (SSIS).
Confidential, Miami, FL
PL/SQL Developer
Responsibilities:
- Created/Migrated packages from SSIS 2012 to SSIS 2014.
- Developing SQL database and BI solutions using T-SQL, SSIS, SSRS, SSAS, MDX, query performance tunings, database development, implementation, support of data, and underlying data models.
- Converted custom forms using Forms in Installed base for global update of instance.
- Worked with business analysts for formulating the ER diagrams and data flow diagrams.
- Interaction with client / business teams for clarifications / updates.
- Developing Sql Loader to insert bulk data into staging tables from flat files.
- Participated in developing a Data Warehouse using Oracle Warehouse Builder. Created universes and business objects using SAP Business Objects. Wrote ETL using Oracle Warehouse Builder.
- Involved in Extraction, Transformation and Loading of data and store the data into staging tables for further various analyses.
- Was responsible for testing the integration of Intrepid Asset Management solution with SAP Linear Asset
- Customized the reports for Financial Module (GL, AP, and AR) using Report Builder.
- Involved in database development by creating PL/SQL functions, procedures and packages
- Developed Database Triggers to enforce Data integrity and additional Referential Integrity
- Developed Triggers for inserting/updating of tables
- Developed optimized PL/SQL API using Collections, Bulk Collect, Result Cache, Materialized view, Pipelined, Java Stored Procedure, External Procedure, various DBMS and UTL package.
- Used inner joins, outer join, union, union all and sub queries for filtering the Data
- Created views to analyze complex queries
- Tuning SQL and PL/SQL code using Statistic Collection, Oracle Hint, Table Partition, Parallel, TKPROF, Explain Plan and Automatic SQL Tuning techniques.
- Involved in generating Web Base Reports for Clients
Environment: SQL Server 2005/2008, Oracle 10g, Oracle Forms 9i/10g, Reports 9i/10g, IBM Web Sphere Data stage and Quality Stage, Cognos 8 BI, Sybase TOAD, Crystal Reports, Erwin, Forms and Reports, UNIX.
Confidential
Oracle Developer
Responsibilities:
- Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
- Designed database structures for effective data extraction, validation, run detail notification and error logging.
- Used SQL* Loader and PL/SQL stored procedure for data conversion and interfaces processes.
- Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
- Assisted in day-to-day duties of DBA work like taking backup and recovery of database environment.
- Performed several Automations written in Perl-DBI/DBD and UNIX Shell scripting in an Agile environment.
- Involved in data loading using PL/SQL and SQL*Loader and cron jobs calling UNIX scripts to download and manipulate files
- Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
- Involved in fine tuning and optimization of different SQL queries to insure faster response time.
- Assisted in designing End User Layouts (EUL’s) for Oracle Discoverer Reports based on the user/client requirements.
- Resolved Priority Production Support Issues and Defect Fixes.
Environment: Oracle 9i/10g, Forms 6i/10g , Perl, UNIX, shell script, SQL*LOADER, TOAD, SQL*Loader, Toad.