Sr. Oracle Pl/sql Developer / Technical Lead Resume
Cleveland, OH
SUMMARY
- Over 8 years of experience in the development of client/server and multi tired applications using Oracle Database, SQL and PL/SQL of different platforms like Windows NT/2000/XP, UNIX and Linux.
- Knowledge on Oracle E - Business R12.1.3, Oracle E-Business Tech Stack, Oracle EBS Forms, Reports and PL/SQL.
- Technical expertise in Order Management, Shipping, Inventory, Purchasing, Payables, WMS, BOM, WIP, AR, AP, GL, HRMS, OTL and Payroll modules.
- Expertise in Oracle 12c/11g/10g/9i, PL/SQL, DBA back end applications, Toad, PL/SQL Developer, SQL PLUS, UNIX and working knowledge of UNIX editors, Debuggers.
- Expertise in Oracle Forms DS10g/DS9i/6i/5.0/4.5 and Reports DS10g/DS9i/6i/3.0/2.5.
- Excellent designing skills OBIEE Dashboards, BI Answers and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse.
- Ability and willingness to quickly understand the Custom Application Environments, Business Processes and Integration around the Custom Applications with Oracle Financials to take the ownership.
- Good knowledge of key Oracle performance-related features such as Query Optimizer, Execution.
- Hands on experience in Coordinating and maintaining the Operational Readiness Review Database.
- Experience with AGILE Methodologies.
- Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
- Experience in using CRON, CONTROL M and AUTOSYS to schedule batch jobs.
- Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews.
- Skilled in SQL Business Intelligence tools, Data Warehousing and ETL processes & strategies using SQL server Analysis and Integration Services.
- Experienced in RDBMS design, data modeling, data normalization and SQL tuning using Indexes.
- Good conceptual knowledge in Data warehouse STAR Schema and SNOWFLAKE schema. knowledge on Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Packages.
- Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
- Strong expertise in SQL, PL/SQL, Stored Procedures, Triggers, Packages, Cursors, SQL*Loader, UNIX Shell scripting, Performance tuning, SQL*Plus and Query Optimization.
- Knowledge on warehousing tools, Data Mapping, Data Analysis, Unit Testing, Conversions, Process Documentation and Migration.
- Experience in performance Tuning and Explain plan, SQL loader, DBMS Scheduler, Utl File, Triggers, Indexes, Import and Export utilities and Shell scripting for auto process.
- Expertise in Data modeling for creating Logical and Physical Design of Database.
- Strong knowledge on Dynamic SQL, Exception handling and PL/SQL Collections.
- Knowledge on Nested tables, Dynamic SQL and Analytical Functions.
- Experience in onsite-offshore business model and coordinating with team in off-shore.
TECHNICAL SKILLS
ERP: Oracle Applications R12 (12.1.3), 11i (Order Management, Order Entry, Accounts Receivables, Inventory, Purchasing, Accounts Payables, General Ledger, HRMS, OTL, AOL, EDI, Work Flow)
Operating Systems: DOS, Windows XP/NT, Red Hat Linux AS/ES 3.0, UNIX, OS X
Languages: SQL, PLSQL, C, C++, Java developer
Scripting Languages: JQuery, JavaScript, HTML and XML
GUI’s Technologies: Oracle Forms DS10g/DS9i/6i/5.0/4.5, Reports DS10g/DS9i/6i/3.0/2.5, BI Publisher Developer Suite 10g/6i (Forms, Reports), Crystal Reports 9/10, Erwin, ODI, Oracle APEX, Forms Migration Assistant
Databases: Oracle8i/9i/10g/11g,12c, SQL server 2000, Oracle XML DB, Oracle AIX, Oracle AQ, MS Access
Products/Packages: MS Office Products, Microsoft Visual Studio, Visual Studio Team Foundation Server 2013
Utilities: SQL* Plus, SQL* Loader, Toad, Discoverer10g, SQL Navigator, Informatica Power Center
PROFESSIONAL EXPERIENCE
Sr. Oracle PL/SQL Developer / Technical Lead
Confidential, Cleveland, OH
Responsibilities:
- Creating new Custom FORMS & REPORTS from scratch to provide Enhancements to the existing Application and for Migration of Legacy LINUX Application.
- Gathered Requirements, Designed, Developed and Tested solely for Cost Center Nucleus (CCN) Application.
- Responsible for Migrating Data from Legacy Mainframe Systems for CCN into Oracle.
- Responsible for extracting Oracle standard PO, Invoice data and send it to PeopleSoft in their required format through PL/SQL and SSIS packages.
- Responsible for writing UTL files to extract the data and write the data to a file
- Created PL/SQL packages and procedures containing interfaces for CCN database to refresh the database from staging tables, two inbound interfaces and two outbound interfaces.
- Designed, Developed, Implemented Custom Design using OA Framework, BI Publisher, AOL(Application Object Library) integrating with Oracle R12 AR/GL for CCN application.
- Responsible for developing custom packages, functions and procedure for converting the data.
- Responsible for developing UNIX shell scripts to support conversion of data.
- Created System Requirement Specification document containing Functional, Business and Technical requirements based on the requirements gathered from the end users.
- Created Process flow diagrams for all the interfaces using Microsoft Visio Professional to demonstrate to the end user on how the application process works.
- Conducted brain storming sessions with the business users and stakeholders..
- Implemented the approved suggestions and modified the current process flows.
- Created Requirement Traceability Matrix to make sure the current project requirements are being met.
- Developed numerous Custom Oracle Forms and Reports using Forms 6i/10g and Reports 6i/10g to interact with the Staging tables created through SSRS packages on daily bases as per the user requirement.
- Developed PL/SQL procedures, functions, packages and triggers for building customized code in SQL Developer and TOAD.
- Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters, and Program units by using PL/SQL procedures and functions of OOPS methodology
- Created page level and item level validations using in Oracle Forms 10g
- Tested the Forms, debugged and fixed the Forms after the testing
- Worked on Oracle Web Logic Server web clients include Business Process Management and Data Mapping functionality.
- Developed Web Procedures, Functions, and Oracle Tables to customize the data as integrated with HTML and CSS.
- Worked on PL/SQL cartridge for an application logic stored in databases as stored procedures.
- Responsible for performance tuning activities in oracle.
- Developed various Shell scripts, processes to set up batch jobs and data loads using Oracle PL/SQL
- Performed the role of the Systems analyst lead and Test lead. The role includes resource planning, work distribution among test team.
Sr. Database Developer / Data Migration Analyst
Confidential, Atlanta, GA
Responsibilities:
- Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
- Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
- Experienced in the use of Agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
- Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
- Used Oracle 12C for auditing /compliance reporting and remediation.
- Worked on Oracle 12C Grid Control including monitoring/setup and performance tuning purposes.
- Integrated BI Publisher with OBIEE. Created Templates such as Employee Account Attendance Detail, Reports such as Turn Over/Period/Department, Prompts such as Customer Name in BI Publisher
- Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
- Used SQL*loader to load the data from the files provided by the interfacing applications.
- Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
- Created partitioned tables and partitioned indexes to improve the performance of the applications.
- Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings.
- Responsible to tune ETL mappings to optimize load and query Performance.
- Extensively used for all and bulk collect to fetch large volumes of data from table.
- Used RANK, DENSE RANK functions to involve in the development of custom stored procedures, functions, packages, triggers, SQL and PL/SQL.
- Used PLSQL Records, Collections (Nested Tables and Varrays) in complex backend packages.
- Good understanding and ability to create shell scripts/ Windows batch scripts for data management and data administration tasks on Unix/Linux and Windows platforms.
- 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.
- Developed Master Detail, Detail reports using tabular and Group above reports.
- Manage the FTP and SFTP processes for various data transfer processes.
- Developed and optimized SQL queries using TOAD Explain Plan utilities.
- Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKPROF to significantly improve the system response, time and efficiency.
- Good understanding of database objects and ability to triage issues.
- Involved in PL/SQL code review and modification for the development of new requirements.
- Created materialized views required for the application.
Oracle PL/SQL Developer
Confidential, Houston, TX
Responsibilities:
- Business requirements gathering and documentation, data cleansing and extraction, report design and implementation, and testing.
- Responsible for extracting Oracle standard PO data, Invoice data and send it to PeopleSoft in their Required Format.
- Responsible for writing UTL files to extract the data and write the data to a file.
- Responsible for developing custom packages, functions and procedure for converting the data.
- Responsible for developing Unix shell scripts to support conversion of data
- Developed numerous PL/SQL stored procedures, SQL scripts and Bourne/Perl shell scripts to extract and convert legacy data into Oracle readable format.
- Created a secure interface (Pl/sql, Korn shell and cron) to transfer data from the legacy.
- Used ODI commands like ODIFile Move, odiFileAppend & odiFilecopy etc.
- Generated DDL/DML scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, cursors, packages, stored procedures, roles and granting privileges.
- Developed SQL *Loader scripts to load data from flat file to Oracle 10g database tables.
- Involved in writing UNIX Shell scripts for automation.
- Used Jquery, Javascript, MOD PL/SQL to develop the front end UI for the application.
- The RMS modules - Purchase Order, PO Workroom, Inventory Management, Stock Ledger, and Item reclassification.
- Involved in Initial Data Load (IDL) from Mainframe to RMS Application and created numerous data validation scripts to validate after the IDL load to make sure to check the data quality.
- Database design for ANF specific requirements.
- Develop and modify Pro*C and UNIX shell scripts for RMS daily/ weekly stock ledger batch programs.
- Implement and Integrate of Oracle Web util Functionality for uploading excel data to RMS for bulk data processing.
- Develop custom Screens in Oracle Forms & Reports.
- Extensively used Oracle Stored Procedures, Functions, Packages and Triggers, Views.
- Extensively Used Analytical Functions for the various complicated business logics.
- Created hash partition for the custom RPM tables to improve the performance.
- Maintained different versions of the source code through SVN
- Coordinate with the offshore team and get the development done.
- Involved in identifying and fixing the data integration issues between the RMS modules.
Oracle Consultant
Confidential, Las Vegas, NV
Responsibilities:
- Worked in Agile Environment as an Oracle Developer to fine tune and optimize the queries in resolving the defects.
- Unit testing of the modules of the project.
- Created and manipulated stored procedures, functions, packages and triggers using TOAD.
- Responsible for SQL tuning using explain plan, TKPROF utility, optimizer hints to improve the performance.
- Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
- Involved in RDBMS design and developed ER-diagrams using Erwin.
- Good working knowledge on Oracle Pseudo columns like ROWID, ROWNUM.
- Tuning and optimization of the existing as well as new code as needed using Oracle hints.
- Interfaced with system analysts to analyze the schema using excel with macros and provided input for updating the entity relationship diagrams.
- Extensively used for all and bulk collect to fetch large volumes of data from table.
- Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, stored procedure, functions, packages using SQL*Plus.
- Extracted data from various data sources i.e. SAP ECC tables, Hana, Oracle, SQL Server & flat files to provide analytical, BI Reporting & data warehouse solutions in a structured data-centric environment.
- Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder and Oracle Forms builder respectively.
- Creating and reporting Crystals Reports for higher management as business tool.
- Participating in requirement meetings and design walkthroughs.
- Worked on extracting data from the XML file sand loaded it into the database.
Oracle ETL Developer / Data Analyst
Confidential, Washington D.C.
Responsibilities:
- Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
- Developed stored procedures and triggers to facilitate consistent data entry into the database.
- Written Stored Procedures using PL/SQL, functions and procedure for common utilities.
- Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
- Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
- Created Control Files and used SQL* Loader to upload bulk data into database from external files.
- Post migration testing of database by comparing table data in the pre and post-migration environments.
- Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
- Involved in Migration of Informatica workflows/mappings from development region to Test and Production Environments. Responsible for writing UTL files to extract the data and write the data to a file
- Responsible for developing custom packages, functions and procedure for converting the data
- Responsible for developing Unix shell scripts to support conversion of data
- Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, REF CURSORS.
- Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
- Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
- Involved in migrating database from Oracle 9i to 10g database.
- Coordinate with offshore team, provide work guide lines and participate in resource management.
Oracle Developer
Confidential
Responsibilities:
- Design, development, and maintenance of modules for an enterprise wide asset and wealth management application written in PL/SQL operating on an Oracle database.
- Responsible for developing custom packages, functions and procedure for converting the data
- Responsible for developing Unix shell scripts to support conversion of data
- Developed numerous PL/SQL stored procedures, SQL scripts and Bourne/Perl shell scripts to extract and convert legacy data into Oracle readable format.
- Performance monitoring and tuning of SQL code.
- Responsible for creation of new user ids and setting up privileges and policies for protecting data.
- Wrote functions and stored procedures for order entry and other searching applications.
- Creation of database objects like tables, indexes and views.
- Developed packages for implementing business logic through procedures and functions.
- Developed UNIX shell scripts to automate routine tasks.
- Responsible for SQL tuning using explain plans and SQL trace facilities.
