We provide IT Staff Augmentation Services!

Sr. Oracle Pl Sql Developer Resume

ChicagO

SUMMARY

  • Over 8 years of experience in various phases of Software Development Life Cycle involving Analysis, Design, Development and Maintenance of Business Applications using Oracle Relational Database Management System.
  • Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
  • Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
  • Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Extensively worked in Client - Server application environment using Oracle 10g/9i/8i/7.x on Windows, UNIX/LINUX platforms and profound knowledge on Oracle 11g.
  • Very Good experience with UNIX Cron Jobs, shell scripting, Batch Processing with highly complex data model.
  • Good Knowledge on Technical architecture and functional flow of Oracle Applications modules such as General Ledger, Account Payables, Account Receivables, Purchasing, Inventory and Order Management.
  • Implemented performance tuning techniques at application, database and system levels
  • Experience in data extraction from heterogeneous sources using Informatica Power center
  • Experience in UNIX shell programming.
  • Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies and Meta data management.
  • Expert in coding complex and advanced PL/SQL programs using Oracle’s Object-Oriented programming, collections, records, index-by tables, object types and methods.
  • Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries to generate reports, Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors.
  • Good experience in designing Entity Relationship Diagram (ERD), Schema, Logical and Physical data models and Data Flow Diagram (DFD) for different database applications.
  • Extensive experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge etc
  • Excellent proficiency in Data Transformations and loading using Export/Import and SQL*Loader and worked on External tables and Transportable table spaces.
  • Experience in Query optimization & Performance tuning using Explain Plan, Performance Monitor.
  • Experience in developing user interface for database applications using the Oracle Apex.
  • Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism
  • Experience in Oracle Apps 11i GL, AP, AR, OM modules.
  • Worked on Oracle development tools like SQL Developer, Oracle Enterprise Manager, PL/SQL Developer, and used TOAD in many development projects.
  • Expertise in working with different data sources like flat files, XML, Teradata, DB2, and Oracle.
  • Experience in using Informatica to populate the data into Teradata DWH.
  • Experience in SQL tuning using Hints, Materialized Views.
  • Expertise in understanding Fact Tables, Dimension Tables, Summary Tables
  • Experience in using Automation Scheduling tools like Autosys and Control M.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x

Databases: Oracle 11g/10g/9i/6i, Teradata 12.0/13.x/14.10, DB2, SQL Server 2005/2000

Reports: Oracle Forms 11g/10g/9i/6i, Oracle Reports 11g/10g/9i/6i

Programming Languages: C, SQL, PL/SQL, C++, Shell Scripting.

Scheduling tools: Control-M, Maestro Tivoli, Autosys

Operating System: Windows 9x/NT/2000/XP, UNIX/LINUX

Others: Toad, Teradata SQL Assistant, ERWin, View point, MS Word, MS Excel, MS PowerPoint, Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Sr. Oracle PL SQL Developer

Responsibilities:

  • Involved in getting the User Requirements, Data Modeling & Development of the system
  • Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
  • Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
  • Created PL/SQL Packages for easier application design and improved Performance.
  • CreatedRecords, Tables, Objects, Collections, Views,Materialized viewsand Global temporary tables(Nested Tables and Varrays), and performed Error Handling.
  • Extensively usedCursors, Ref Cursors, Dynamic SQL and Functions.
  • Participated inPerformance TuningusingExplain Plan.
  • Tested, Installed, Documented and provided On Call Support for the Applications.
  • Developed UNIX Shell Script as required.
  • Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
  • Performed Data replication and Data transformation.
  • Export and import of database objects using Data pump utilities EXPDP and IMPDP.
  • Involved in Periodical backups of Databases using RMAN
  • Involved in database Restoration and Recovery.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Migrated data from Flat Files to Oracle database using SQL*Loader.
  • Encapsulated PL/SQL procedures and functions in packages to organize application.
  • Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
  • Performed complex data manipulation using foreign functions written in C and PL/SQL language.
  • Created and managed primary data base objects such as Tables, Indexes, Sequences, and Synonyms, materialized views.
  • Developed aConceptual modelusing Erwin based on requirements analysis.
  • Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
  • Involved in trouble-shooting production database problems and report problems.
  • Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
  • Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
  • Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures using TOAD tool.

Environment: Oracle 11g, SQL*Plus, PL/SQL, Toad, SQL Loader, Sun Solaris, ERWin, Clear Quest, MS VSS, ETL, SVN, JIRA, Perl, XML, Crystal Reports

Confidential, Los Angeles CA

Sr. Oracle PLSQL developer

Responsibilities:

  • Experience in writing Technical design documents and developing unit test documents.
  • Created or Modified the SQL Script (.sql file) to point to the current source.
  • Experience in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
  • Created the tables and sequences for the experimental data load capture.
  • Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from the flat file to the tables.
  • Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
  • Modified the queries by using less functions in the Where condition for reduction of time for Performance issues.
  • Loading the Data into tables using SQL loader and using PLSQL Package UTL FILE (ETL).
  • Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • Wrote the Unix scripts for scheduling or running the scripts for day to day transactions.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
  • Modifying the queries by using BULK COLLECT and FOR ALL to reduce the time for performance issues.
  • High End-Client Interactions for solving User Acceptance Testing (UAT) issues.
  • Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL Enhanced it with creating exceptions for error handling.
  • Extensively worked with third party database tools like TOAD & PL/SQL Developer.
  • Hands on Exposure on 2010 TFS Version Control. This includes splitting and merging of code branches in various Release and Version Management. Experience in Checking in checking out the code in TFS (Team Foundation Server).
  • Written complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators.
  • Designed entity relation diagrams (ERD) using Erwin.
  • Rich experience in writing SQL queries, Anonymous blocks, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
  • Created materialized view on remote database and automated scheduler of refreshing of materialized view on source side.
  • Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect.
  • Experience in using the Trace files and TK proof whenever required for performance issues.
  • Responsible for Unit, System and UAT testing the data.
  • Involved in UAT testing, Bugs fixing and the code was sent to Production.
  • Resolving the Tickets and pulling the data from the Transactional database and Archive database for the reports.

Environment: Oracle 10g, 11g, PL/SQL, SQL*Plus, PL/SQL Developer 6.0, Toad, ERWin, UNIX, LINUX, TFS.

Confidential, Minneapolis, MN

Oracle Developer

Responsibilities:

  • Created detailed design and requirements documentation with logic to help better understanding of the system
  • Continuously interacted with Business Analysts and end users to gather business requirements
  • Performed design/code reviews to make sure that the design/code adheres to customers’ standards and meets industry’s best practices
  • Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
  • Designing system work flow diagrams using UML and Visio.
  • Involved in ERD Design for Enterprise Application building.
  • Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
  • Written SQL queries (Sub queries and Join conditions), PL/SQL programming.
  • Involved in development of ETL process using SQL* LOADER, PL/SQL Package.
  • Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
  • Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database
  • Involved in Performance tuning and Query Optimization
  • Documented the errors and solutions to fix them for future use
  • Provided SQL tuning, table indexing, data migration, project migration, program debugging.
  • Created and scheduled SQL jobs to run SSIS packages on a daily basis
  • Scheduling Execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.

Environment: Oracle 11g, SQL*PLUS, PL/SQL developer, TOAD, FTP, Unix sun Solaris(5.8/5.9), ERWIN, ETL, Oracle ware house builder(OWB),Oracle Enterprise Manager (OEM), Unix Shell Scripts, JAVA,SSIS,SSRS, Windows XP

Confidential, NY

Sr. Oracle Developer

Responsibilities:

  • Developed interface to load Invoice data into Account Payables. Developed validations programs to load the data into AP INVOICE INTERFACE, AP INVOICE LINES INTERFACE.
  • Data was loaded into temporary table from flat file and then into AP INVOICE INTERFACE and AP INVOICE LINES INTERFACE tables.
  • Worked with the Business users in Vendor reconciliation process between Great Plains system and Oracle System.
  • Involved in Development of Oracle forms user interface related to GE Energy.
  • Wrote SQL scripts to insert the vendor data into PO VENDOS ALL, PO VENDOR SITES ALL, PO VENDOR CONTACTS.
  • Wrote SQL scripts to create temporary tables and developed SQL*Loader Control files to load the data into the temporary tables.
  • Data was loaded into temporary table from a flat file and then into RA INTERFACE SALESCREDITS ALL and RA INTERFACE LINES ALL tables.
  • Customized and developed reports as per client's requirements using Reports 6i and PL/SQL and registered them with APPS.
  • Develop SQL* Loader scripts for data extraction and transformation.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
  • Responsible for Purging and archiving the production databases by interacting DBA.
  • Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
  • Project Development is done on Iterative and Incremental Software development life cycle methodology.
  • Responsible for troubleshooting the errors that occurred when the production group hit a roadblock (Production Support).
  • Executed Unix Korn shell scripts, directory structures and I/O file handling in Production.
  • Developed reports using complex queries as per client request as a part of production support
  • Responsible for performing code reviews and Incident Management working through critical incidents.
  • Resolving Production Severity Issues in time and meeting the SLA.
  • Writing high quality and well documented code per standards.
  • Provide 24/7 on call production support and resolve production issues immediately.
  • Developed database compare tool to negate manual intervention for database object comparison during data copy to data warehouse/reporting environment. It provides a list and DDLs of Tables, Indexes and Views, which are different among the source and target systems, thus saving considerable time.
  • Did Unit testing, System testing for the Data Integrity and the functionality of the newly created business requirements.

Environment: Oracle Applications 11.5.10.2(AP, AR, GL, PO), Informatica Power center 8.1, Service Now, Oracle 10g, TOAD, UNIX Shell Scripts

Confidential

Software Engineer

Responsibilities:

  • Developed technical design documents (MD70s) using AIM methodology by reviewing MD50s and interacted with functional team to build technical extensions.
  • Developed new reports as per Oracle Applications development standards and customized existing reports in the PO module according to the client’s requirements.
  • Privileged Identity management team works on Oracle Identity and Access Management issues.
  • On call duties for development, staging and production environment.
  • Investigating, determining the cause and fixing all production problems.
  • Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
  • Designing system work flow diagrams using UML and Visio.
  • Involved in the ERD Design for Enterprise Application building.
  • Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
  • Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Written SQL queries (Sub queries and Join conditions), PL/SQL programming.
  • Involved in development of ETL process using SQL* LOADER, PL/SQL Package.
  • Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
  • Participated in Performance Tuning using Explain Plan and TkProf
  • Written stored procedures, functions and packages for application development.
  • Copying of data from development to test and production by using utilities like Export/Import.
  • Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers and user defined functions.
  • Automating data loading, extraction, report generation using PL/SQL coding.
  • Expert in analyzing/troubleshooting and providing technical support for Unix/Oracle applications and their interfaces.
  • Run batch jobs for loading database tables from Flat Files using SQL*Loader.
  • Scheduling Execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables. Utilized tools like TOAD during development of the application.

Environment: Solaris 10, Oracle 9i, HP Quality Center, SQL Plus, Putty, GE Service Now, HP Server Automation Tool

Hire Now