We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

3.00 Rating

NapervillE

SUMMARY

  • Over 8+ years of experience in Analysis, design, development and testing of various business applications using Oracle SQL, PL/SQL, UNIX shell scripting, technical production support and 4 Years of experience in Informatica Power Center 9.x.
  • Expertise in handling multiple projects simultaneously and development of client/server and multi tired applications.
  • Extensive working experience in writing various modules likes functions, stored procedures, cursors (Implicit, Explicit, REF), packages, triggers and creating tables, views and materialized views using Oracle SQL and PL/SQL.
  • Strong knowledge in Oracle cursor management and exception handling.
  • Extensive knowledge of using DBMS Oracle supplied package like UTL FILE, DBMS SCHEDULER, DBMS OUTPUT, DBMS UTILITY etc.
  • Expertise in creating summarized tables and materialized views for efficient reporting and improved performance
  • Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer.
  • Experience using SQL* Loader, writing PL/SQL procedures to facilitate data import/export from staging tables to production tables.
  • Experience in creating UNIX shell script, filter the data using the script and scheduling the job using cron tab.
  • Performed unit testing and supported integration testing and end user testing. Extensively worked on production issues with effective defect management. Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
  • Excellent experience with performance tuning, Normalization and Demoralization, Partitioning of Tables. Experience in writing the technical specification for the development team to work.
  • Over 4 years of ETL Data warehousing experience using Informatica Power Center 9.x (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager and workflow Monitor).
  • Worked extensively with Data migration, Data Cleansing, Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
  • Worked with different data sources non - relational Databases such as Flat files, XML files, and other relational sources such as Oracle, SQL Server. used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
  • Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.
  • Extensively used Informatica debugger for troubleshooting.
  • Experience in SDLC and Agile methodologies.
  • Supporting the production issues 24/7 for the top priority tickets.

TECHNICAL SKILLS

Databases: Oracle 8i, 9i,10g,11g, SQL Server 2000/2005, Microsoft Access.

Operating System: Windows NT/2000/2003/XP, Linux, UNIX.

Programming Languages: SQL,PL/SQL,Shell Scripting,VB,HTML,XML.

Version Control Tools: PVCS,Clear Case, Microsoft version control.

ETL Tool: Informatica Power Center 9.x.

Tools: /GUI/UTILITIES: TOAD, SQL Developer, SQL * Loader, SQL navigator, VI Editor, FTP, SFTP,PGP,Connect Direct, Explain Plan, Microsoft Excel

Scheduling Tool: Autosys,Control M

PROFESSIONAL EXPERIENCE

Confidential, Naperville

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Analyzing the Requirement and System to get the full Technical details to accomplish Business requirement
  • Writing Technical Design Document and share the knowledge with the Team members for Development
  • Created PL/SQL Packages, Views, Functions, Procedures, Indexes, Primary key, foreign key and Triggers according to the requirements.
  • Created Dynamic SQL statements in procedures.
  • Developing, Modifying, Debugging SQL Queries according to the requirement
  • Interacting with other Systems Teams to get the details How They are processing and Populating the data into Tables
  • Involved in Created database objects like Table,Indexes,Procedure,packages etc
  • Involved in Creating the physical data model for OLTP system.
  • Created file transfer script using ftp and scheduled the cron jobs in UNIX environment.
  • Analyzing and resolving Defects raised by UAT and the users. Interacting with UAT Team and the Users to get more details of defect and clarifying the questions.
  • Created tables and macros in MS Access database.

Confidential

Sr.Technical and Implementation consultant

Responsibilities:

  • Created PL/SQL Packages, Views, Functions, Procedures, Indexes, Primary key, foreign key and Triggers according to the requirements.
  • Created Dynamic SQL statements in procedures.
  • Developing, Modifying, Debugging SQL Queries according to the requirement .
  • Created cursors,Tables,Sequences,Materialized views and used the DBMS JOBS built in packages.
  • Created tables and macros in MS Access database and loaded the data into oracle tables.
  • Activate the Expense types for the policy.
  • Configure the Workflow. configure the ledger and receipt notice information.
  • Update the Receipt Handling system.
  • Configure the Car Configuration for the new Policy.
  • Configure VAT for the new Policy.
  • Configure the TA for the new Policy.
  • Load the new Employees to the system.
  • Assign the Amex Card system for the new Employees.
  • Migrating the Interfaces from FTP to SFTP

Environment: Oracle 9i,10g,Concur, MS Access, Toad, Windows, VB Script, Shell Script

Confidential, Burbank CA

Sr.Oracle PLSQL/ETL Developer

Responsibilities:

  • Involved in requirement analysis, design, development and implementation of the system.
  • Participated in various discussions with the users in developing the functional specifications
  • Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
  • Worked on Materialized Views.
  • Involved in Creating the physical data model for OLTP system
  • Developed load programs using SQL*Loader, PL/SQL functions and procedures to load latest two years of data into the tables.
  • Extensively used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN, SQL*TRACE to significantly improve the system response time and efficiency.
  • Developed stored procedures, functions and triggers using TOAD.
  • Used Informatica designer for designingmappings and mappletsto extract data fromSQL Server, Sybase and Oracle sources.
  • Created differentparameter files and changed Session parameters, mapping parameters,and variables at run time.
  • Extensively usedSource Qualifier Transformationto filter data at Source level rather than at Transformation level.
  • Created different transformations such asSource Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
  • UsedDebuggerto test the data flowand fix the mappings.
  • Running the daily ETL Mappings to pull the data from different source system and load in to the staging tables using InformaticaPower Center 9.x Workflow manager.
  • Created and monitored workflows and taskusing Informatica Power Center Workflow Manager.

Environment: Oracle 9i,Informatica 9.x MS Access, Toad Developer, Windows NT

Confidential, Dallas Texas

Oracle PL/SQL Developer

Responsibilities:

  • Extraction of data from different flat files into Oracle Database using SQL* Loader.
  • Gather Business rules from the end users that are to be incorporated into the system.
  • Design, development and implementation of complex ETL Processes with Informatics 9.x
  • Changed existing logic within the packages for optimum performance using Oracle Hints, Explain Plans and Trace Sessions.
  • Worked on Materialized view by creating an estimated cost and solved costing issues in Production release.
  • Worked with Bulk Collects to improve the performance of multi-row queries.
  • Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
  • Worked on Database Links to import/export data.
  • Involved in Created database objects like Table,Indexes,Procedure,packages etc
  • Worked on DBMS SCHEDULER to automate jobs.
  • Involved in fixing the UAT case issues.
  • Analyzing and resolving Defects raised by UAT and the users. Interacting with UAT Team and the Users to get more details of defect and clarifying the questions.
  • Involved in creating the Change request in service management system and get the approval for the changes to move into production.

Environment: Oracle 9i, MS Access, Toad Developer, Windows NT,VB Script, shell script

Confidential

Software Engineer

Responsibilities:

  • Handling the request according to the User Specifications.
  • Created Grants of roles and privileges to the user.
  • Resolved application problems to maintain high level of customer satisfaction.
  • Created various tables, indexes, constraints, views sequences, synonyms and stored program units.
  • Developed SQL* Loader scripts for data extraction and transformation.
  • Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
  • Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
  • Developed database triggers required for the Integrity constraints.
  • Analyzed current procedures, recommended and implemented improvements as needed.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
  • Written PL/SQL cursors for transaction processing.
  • Written Queries for the management in the form of stored procedures and packages.
  • Involved in writing complex queries to generate reports as per client request as a part of production support.
  • Extracted data from Flat files, Oracle and SQL server sources.
  • Designed and generated reports using Crystal Reports.

Environment: Oracle 9i, PL/SQL Developer, Solaris 5.9, Toad, PVCS, Windows 2000, Crystal reports.

We'd love your feedback!