Senior Oracle Pl/sql Developer Resume
Harrisburg, PA
SUMMARY
- 9+ years of programming experience as an Oracle PL/SQL Developer and ETL in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
- Solid experience in translating business requirements into creation of Database Objects.
- Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
- Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
- Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, PL/SQL Developer and SQL*LOADER.
- Strong programming experience in creating PL/SQL Stored Procedures, Functions, Stored Packages, Database Triggers, SQL* Loader scripts, Shell scripting, Forms(6i/10g), Reports(6i/10g), Conversions, interfaces, Oracle Alerts and Oracle Workflows.
- Excellent understanding and implementing the Order-to-Cash (O2C) and Procure-to-Pay (P2P) business process.
- Good working knowledge in designing technical documents using AIM Methodologies (MD50, MD70, CV40ANDCV70).
- Excellent understanding of the AOL, System Administration and Application Developer module.
- Experienced in Developing Technical Specification and Design Documents.
- Experienced in data migrations from legacy systems into Oracle Applications.
- Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
- Strong experience in Data warehouse concepts, ETL.
- Good knowledge on logical and physical Data Modeling using normalizing Techniques.
- Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
- Developed materialized views for data replication in distributed environments.
- Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
- Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
- Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
- Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
- Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
- Worked extensively on Ref Cursor, External Tables and Collections.
- Proficient in tuning queries used in the application.
- Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
- Experience in advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
- Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
- Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
- Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
- Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
- Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
- Very Good experience with UNIX Cron Jobs, Batch Processing with highly complex data model.
- Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
- Familiar with Oracle Applications Framework (OAF) technology, especially with personalization of existing OA Framework pages.
- Technical (Production Support, Developer etc.) activities: Automation of daily routine activities through scheduled scripts, Archival activities, identifying technical gaps, designing custom solutions, programming, scheduling, producing documentation, and providing post production support.
- Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
TECHNICAL SKILLS
Operating Systems: UNIX(Sun Solaris, LINUX, HP UNIX, AIX), Windows NT/98/95/2000 & Windows XP.
Languages: Oracle (SQL, PL/SQL) and Unix shell scripts
Databases: Oracle 12c, 11.x, 10.x, 9.x, 8.x, 7.x, MS SQL Server 2012
Incident Management: Remedy Expert Desk, HP Open View Service Desk 4.5, UTS, VSTS
Data Modeling: Erwin 3.5.2,4.0
Applications & Utilities: Oracle Applications 11i /R12, OEM, SQL*loader, tkprof, SQL Developer, TOAD, SVN Tools.
ETL Tools: Informatica (Power Center 5.1/6.2/7.1/8.6.1/9.1.0 ), PowerMart 5.1, MS SQL Server Integration Services (SSIS) and SQL*Loader.
Reporting Tools: Cognos, Business Objects and SSRS(SQL Server Reporting Services), Crystal Reports
Other Tools: AutoSys, Control-M, Tidal, PVCS, MS-VSS, Clear case, WIN CVS, Git, TFS, Informatica Data Quality, jdeveloper, BI Publisher(XML publisher).
PROFESSIONAL EXPERIENCE
Confidential, Harrisburg PA
Senior Oracle pl/sql Developer
Responsibilities:
- Requirement gathering with business users through regular meetings.
- Migrating legacy system data to new system using batch jobs.
- Designing table structure and relationship between in new system database.
- Migration data from legacy system to new oracle database.
- Designing workflow process for the system.
- Creating the batch jobs, scheduling and monitoring the jobs.
- Creating packages in new system with additional business requirement.
- Performance tuning the queries which are using ADF screens and packages.
- Building new database completely new with all database objects.
- Code reviews which should match defined standards.
- Building RTF reports for the business process related documents.
- Creating automation of test cases for developed packages.
- Preparation of go live activities for DB related objects.
- Supporting production system.
Environment: Oracle 11g/12c, SQL, PL/SQL, SQL Developer, SQL * Plus, SQL*Loader, BI Publisher, Oracle forms/Reports, GIT, Unix Shell Scripting, Autosys, FTP, UNIX (Putty).
Confidential, Warren NJ
Senior Oracle Developer
Responsibilities:
- Designed/developed/modified Planning and replenishment systems and reporting based supply chain applications.
- Created approach, design documents, review documents and prepared test cases.
- Implemented almost 30 measures for Devices and Accessory items in JDA S&OP system.
- Developed various important measures like Actual Sales, Base forecast, Total forecast and Pallet Count.
- Redesigned and developed forecasting systems with respect to implementation of SAP system.
- Design and Developed job monitoring dash board and alert mechanism over the email.
- Designed OSC intermediate system to exchange the data between SAP and Planning systems.
- Performance improvement activities in existing systems for smooth and faster operations.
- Reduced job execution time from 20 min to 2 min using optimization techniques.
- Altered existing Email functionality package to send mail as HTML to users.
- Created Separate S&OP Schemas for VDSI and masked the data in all required tables.
- Implementation of Same day delivery (SDD) and Ship from store (SFS) Initiatives.
- Implementation of data migration process from legacy system to SAP system using Informatica.
- Reduced execution time of the jobs using performance tuning and redesigning structure.
- Prepared test cases and supported UAT issues
- Maintaining version control and prepared go live action items for smooth process.
- Involved in upgrade activities of JDA S&OP applications.
- Involved in migrating schemas abppmgr and sop stg schemas.
- Involved in SCPO installation.
- Designed and implemented archival policy for systems.
Environment: JDA, Oracle 10g/11g/12c, SQL, PL/SQL, TOAD, SQL * Plus, SQL*Loader, ETL, Informatica Power Center 9.6, JDA, Unix Shell Scripting, Autosys, FTP, UNIX (Putty).
Confidential
Senior Oracle Technical Consultant
Responsibilities:
- Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
- Involved in Oracle applications Migration activity 12.0.6 to 12.1.3
- Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
- Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
- Used SQL loader to load the data from the files provided by the interfacing applications.
- Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping.
- Developed WU specific File handler program for handling all inbound programs for easy monitoring.
- Developed interface between PO and Marketing system for details exchange like PO and invoice information.
- Developed interfaces on WU SAS functionality.
- Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
- 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.
- Wrote PL/SQL Database triggers to implement the business rules in the application.
- Created external tables to handle huge volumes of data which is not used frequently.
- Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
- Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
- Implemented all modules logic by using Triggers and Integrity Constraints.
- Creating table spaces, tables, views, scripts for automatic operations of the database activities.
- Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
- Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
- Developed Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
- 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.
Environment: Oracle Applications 11i /R12, Oracle 10g/11g/12c, SQL, PL/SQL, TOAD, SQL * Plus, SQL*Loader, Workflow Builder, Oracle AME, XML/BI Publisher, UNIX Shell Scripting, Forms 10g/6i, OAF, Web services(SOAP), Unix Shell Scripting, Autosys, FTP, UNIX (Putty), ETL, Informatica Power Center 9
Confidential
Oracle Technical Consultant
Responsibilities:
- Involved in the $40 million project setting up the development environment, QA environment, performance environment and the production environments.
- Created database objects such as tables, views, indexes, sequences using TOAD
- Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
- Created PL/SQL program units to include DML, DDL statements using dynamic SQL
- Developed complex SQL queries for data retrieval from various database objects including tables and views.
- Fine-tuned procedures for maximum efficiency in various schemas across databases usingOracle Hints, execution plan.
- Optimized and tuned PL/SQL subprograms to reduce the loading process
- Tuned the database where in the job which was taking more than 7 hours is now taking 5 hours.
- Performed various database activities which include monitoring, tuning, capacity planning, troubleshooting, and consulting.
- Investigate, troubleshoot and resolve database issues.
- Provide consultation to application development teams on technical issues.
- Responsible for purging and archiving the production databases.
- Coordinate downtime with the application development teams and system engineers to implement approved changes
- Developed complicated stored Procedures, Functions, Database Triggers and Packages, Shell Scripts.
- Involved in handling Exceptions through PL/SQL Blocks.
- Developed SQL *Loader scripts to load data from flat file to Oracle 10g database tables.
- Preparing test plan for QA for testing before moving from PreProd to Production environment.
- Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
- Analyzed the AWR, ADDR reports and implemented the changes accordingly.
- Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
- Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
- Maintenance of the Partitioned tables (Range Partitioned), purging the old data, which involved taking the export of the partitioned data, dropping the partitions and importing the data back, this was done to improve the response time of the query.
- Provided on-call support for databases 7 X 24 on a rotation.
Environment: Oracle Applications 11i, Oracle Forms/reports 6i, Oracle 9i/10g, SQL, PL/SQL, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Created database objects such as tables, views, indexes, sequences using Oracle 9i
- Developed PL/SQL stored procedures, functions and packages in TOAD
- Created PL/SQL program units to include DML, DDL statements using dynamic SQL
- Fine-tuned procedures for maximum efficiency in various schemas across databases usingOracle Hints, execution plan
- Optimized and tuned PL/SQL subprograms to reduce the loading process
- Developed row level and statement level triggers for auditing tables in PL/SQL
- Created partitions on the tables to improve the performance
- Wrote complex SQL queries to retrieve information from the databases depending on the requirement
- Generated sequences that can be shared by multiple users to generate unique integers
- Implemented PL/SQL scripts in accordance with the necessary business rules and requirements
- Wrote complex queries involving multiple-joins to generate user reports
- Participated in the ongoing process enhancements and modification requests
- Used UTL FILE package to check if the flat file existed before the SQLLDR script was executed, and also to check the log file to find the number of bad row inserts
- Developed scripts in UNIX for daily backup using Cron tab
- Tested, installed, documented and provided on call support for the applications Statements.
Environment: Oracle 9i/10g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL Developer, UNIX Shell Scripting, Putty, Linux, and Windows