We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

Ashburn, VA

SUMMARY

  • 10+ years of experience as Oracle PL/SQL Developer in Oracle 11g, 10g, 9i & 8i versions and IT experience in Software Development/Maintenance & Support Projects
  • Technical areas of experience related to PL/SQL, UNIX & Shell Scripting
  • Experienced in complete life cycle Implementation of PL/SQL Development
  • Proficient in writing complex SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Collections, Performance Tuning and Query Optimization
  • Experienced in Object Oriented Programming concepts with Oracle types and member functions
  • Performance tuning and optimization using Explain Plan, SQL*Trace, TKPROF and Oracle Optimizer hints
  • Experienced in PL/SQL Performance Tuning using Bulk Collections and other optimization techniques
  • Expertise in Dynamic SQL and Exception Handling
  • Experienced in performing Oracle DBA monitoring activities
  • Expertise in Data Integration of data from various data sources like SQL Server, Oracle, Flat Files, and delimited files and Data Migration
  • Worked with various performance tuning techniques using tools provided by Oracle like SQL*TRACE, TKPROF, HINTS, DBMS STATS etc
  • Experienced in importing data from Flat files from Legacy Applications to Oracle DB using SQL Loader
  • Creating Users, Roles and Profiles, Privilege management with role - based security.
  • Experience as a database architect and worked as data modeler.
  • Experience on handling the team and overall project and offshore team.
  • Good experience on Exadata and oracle 12 c
  • Experince on designing datawarehouse and datamart
  • ETL design and development for extracting data from the heterogeneous source systems like SQL Server,Oracle, Teradata, flat files, and loading into Staging and Data Warehouse Confidential .
  • Maintenance of user accounts and privileges to maintain database security
  • Experienced in performing basic Oracle DBA activities like importing and exporting Confidential between databases
  • Expertise in Data Warehousing and ETL concepts
  • Work experience on n-Tier systems
  • Good Exposure to Informatica Transformation concepts
  • Expertise in handling 24/7 Production Support projects
  • Good exposure to Development, Testing, Production Support, Debugging, Implementation and Documentation
  • Experienced in Requirements Gathering and Preparing Use Cases
  • Comprehensive and in-depth experience using the System Development Life Cycle (SDLC)
  • Expertise in working with Projects in Agile Methodology
  • Developed tasks for SCRUM sprint meetings in Agile Methodology
  • Strong Team Building & Leadership capability and excellent Mentoring Skills
  • A self-motivated, responsible and reliable team player with a set of strong technical skills
  • Good experience on installing the applications on oracle cloud environment.
  • Good experience on develop a reports and dashboards using oracle data visualizer.
  • Strong conceptual, business, analytical skills and innovative problem solving abilities
  • Good communication, interpersonal and problem-solving skills

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/XP/2003, UNIX, Red Hat Linux 9

Databases: Oracle 8i/9i/10g/11g/12c, 18 C SQL Server, Oracle cloud

Database Tools: Import/Export, SQL*Plus, SQL loader, Explain plan & TKPROF, T-SQL, TOAD, Data Pump

Languages: SQL, PL/SQL, HTML, XML

Scripting: Vi Editor, Shell, Perl Scripting

ETL Tools: Informatica

Analytical Tools/Reporting tools: OBIEE, Oracle Data visualizer, qlik view

Version Control Tools: Confidential Rational Clear Case, Dimensions, TFS,SVN

Service Desk Tools: HP Service Desk, BMC - Remedy, Rally

SCM Tools: I2/JDA SCM Tool

PROFESSIONAL EXPERIENCE

Confidential, Ashburn, VA

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in requirement analysis, ETL design and development for extracting data from the ETMS and call center source systems in SQL Server, Oracle, Teradata, flat files, to load into Staging and Data Warehouse Confidential Confidential .
  • Create PL/SQL Packages which has Procedures, Functions and Triggers
  • Performance tuning for the SQL Queries with Explain plan to modify all full table scan paths for faster query execution for complex reports,
  • Used Oracle Types, Analytical functions, Collections, UTL File Package, Parallel execution, Dynamic SQL concepts in Oracle PL/SQL Development
  • Perform Unit Testing to validate the code which was modified as a part of requirement change
  • Used PL/SQL to create Packages, Functions, and Procedure.
  • Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
  • Worked on external tables to load the data in stage area.
  • Worked on pipe line table functions to retrive data faster in collections
  • Worked on plsql collections and ref corsors. create domains in oracle cloud interface and install the applications(java,m-queue) in oracle colud interface environment.
  • Create dashboards and reports using oracle data visualizer and migrate the legacy reports from obiee to DV.
  • Explain Plan, Hints to reduce the response time.
  • Perform Integration testing to make sure the modified code doesn’t affect the the other processes
  • Create Documentation for the proposed change
  • Run the applications with Tomcat, Apache and Maven servers
  • Work as release management cosultant.
  • Working on designing datawarehouse and datamart

Confidential, Miamisburg, Ohio

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like SQL Server, Oracle, Teradata, flat files, and loading into Staging and Data Warehouse Confidential .
  • Create PL/SQL Packages which has Procedures, Functions and Triggers
  • Performance tune SQL Queries with Explain plan to modify all full table scan paths for faster query execution
  • Used Oracle Types, Analytical functions, Collections, UTL File Package, Parallel execution, Dynamic SQL concepts in Oracle PL/SQL Development
  • Perform Unit Testing to validate the code which was modified as a part of requirement change
  • Used PL/SQL to create Packages, Functions, and Procedure.
  • Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
  • Worked on external tables to load the data in stage area.
  • Worked on pipe line table functions to retrive data faster in collections
  • Worked on plsql collections and ref corsors.
  • Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
  • Perform Integration testing to make sure the modified code doesn’t affect the the other processes
  • Create Documentation for the proposed change
  • Run the applications with Tomcat, Apache and Maven servers
  • Work as release management cosultant.
  • Working on designing datawarehouse and datamart

Confidential, Tampa, FL

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like SQL Server, Oracle, Teradata, flat files, and loading into Staging and Data Warehouse Confidential .
  • Maintain and Support the creation of legal entities and corp gov related modules
  • Create PL/SQL Packages which has Procedures, Functions and Triggers.
  • Used bulk collect and forall futures the retrive data fast and insert bulk operations.
  • Used data compression and parllel processing techniques.
  • Performance tune SQL Queries with Explain plan to modify all full table scan paths for faster query execution
  • Used Oracle Types, Analytical functions, Collections, UTL File Package, Parallel execution, Dynamic SQL concepts in Oracle PL/SQL Development
  • Perform Unit Testing to validate the code which was modified as a part of requirement change
  • Extensive use of Unix Shell Scripts, Cron jobs and Autosys to automate process.
  • Perform Integration testing to make sure the modified code doesn’t affect the the other processes
  • Create Documentation for the proposed change

ENVIRONMENT: Oracle PL/SQL, Oracle 11g, java, Banking Domain

Hartford, CT

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Estimate, plan, execute and monitor Projects
  • Gather requirements for change requests with the Business team and create design documents
  • Provide User Access to Business End Users to the Front end tools after getting the required approvals
  • Create PL/SQL packages for implementing Change Requests for adding new functionality to the application
  • Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers .
  • Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions
  • Performed SQL and PL/SQL tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE
  • Extensively used Oracle Hints to direct the optimizer to choose an optimum query Execution Plan
  • Extensively used Bulk Collection in PL/SQL Objects for improving the performance
  • Handled errors using Exception Handling extensively for debugging and maintainability.
  • Automated Oracle and Informatica workflows using Unix Cron Utility in Unix Environment.
  • Responsible for writing Unix Shell scripts for loading data using SQL*Loader . The Control Files for the tables were created and automated through UNIX shell scripts to perform data load in to Oracle tables. Used SQL Loader and PL/SQL scripts to load data into the system application.
  • Performed Data Cleansing to weed out erroneous Orders from the DWH tables
  • Extensively used Toad to develop Oracle PL/SQL Packages
  • Create Procedures and Functions in SQL Server to migrate data from Legacy servers to Oracle Datawarehouse tables
  • Create Informatica worflows (7.0 for Flat Roll/9.0 for Tubular implementations) for implementing business logic
  • Worked on Sessions & workflows for variety of loads starting from Source to Target
  • Created Parameter Files to override session properties for source directory, Bad file Directory, Source, Target & created Mapplet parameters for Mapplets
  • Created Mappings using Designer, Extracted the data from the flat files and other RDBMS databases into staging area and loaded onto Data Warehouse
  • Developed the Informatica Mappings by using Aggregator, SQL Overrides by using Lookups, source filter by using Source Qualifiers and Data Flow Management into multiple targets using Router Transformation
  • Developed reusable Workflows, Worklets, Mappings and Mapplets using transformations including Router, Aggregator, Lookup, Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union
  • Create Perl & Shell scripts for automating the business logic
  • Deploy the code across the environments to main code consistency and update the same in Clear Case for version control
  • Create Test Cases for verification and validation of the Change Requests

ENVIRONMENT: Oracle PL/SQL, Oracle 11g, SQL Server 2012, Informatica, Java, ABPP, UNIX, Shell & Perl Scripting

Confidential, New Albany, OH

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Create Use case documents for the functional requirements for the Change Request
  • Setup Sprint calls with the End User for Change Requests
  • Weekly calls with the Business and the Management for maintaining Change Requests
  • Daily status calls with the end users during the Requirement Gathering phase to mitigate risks
  • Bring new projects by identifying areas of improvements during discussions with Management team and Business Users
  • Run the applications with Tomcat, Apache and Maven servers
  • Work as release management cosultant.
  • Working on designing datawarehouse and datamart
  • Get the inventory details from the order tables for the CDR’s from CABS and SS7 source systems for MOU and BNC Application
  • Help Developers in translating requirements during coding
  • Deploy Code across all environments and upload the code in Dimensions tool for version control
  • Gather requirements from End Users and SME’s regarding the Change Request and create High Level and Low Design documents
  • Create PL/SQL Packages which contains Cursors, Exceptions, Procedures and Functions to load the daily, weekly and monthly data into the database table.
  • Performance tune End user SQL queries using Explain plan with TKPROF and Oracle Optimizer hints
  • Performance tune DML statements for fetching and loading data into the Oracle database tables using Bulk Binds logic
  • Create Range Partitions based on load date and maintain List/Range sub-partitions for different Circuit ID’s for Vendors
  • Create DML Triggers for updating the audit tables for DML activities on the master tables
  • Create Views for Master tables and Materialized views from DWH tables for End User Queries
  • Load data from Flat files from Legacy Mainframe Applications using SQL Loader scripts
  • Responsible for creating users, granting roles and privilege management
  • Perform SQL Testing for verifying proper loading of data in the DWH tables
  • Create adhoc PL/SQL blocks for User requirements
  • Resolve the database issues of the users whenever in need of
  • Create Programmable blocks using SQL Server to migrate data from Legacy applications to Oracle
  • Provide Data Integration Support by integrating data from all the different systems using the Lavastorm Business Rule Editor(Lavastorm BRE) and load the data in DWH tables
  • Perform Data Integration activity, Data Quality Management and Data Analysis activities using Lavastorm BRE Analytical Tool
  • Create Revenue reports for end users using webFocus reporting tool
  • Created POC for the migration of Lavastorm BRE graphs to Informatica PowerCenter 9.X
  • Create Unit Test cases for verification and validation for the Change Request
  • Created automation scripts in Shell & PERL Scripting
  • Create comprehensive documents of the changes made for the end users

ENVIRONMENT: Oracle 11g, Agile, SQL, PL/SQL, SQL Server 2008, Lavastorm BRE, Informatica, UNIX & Shell Scripting

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Provide the Project Playbooks and the Component Release Notes (CRN’s) for new projects and Change Requests
  • Provide Environments for new projects, Deliver the components using the Clearcase tool
  • Create PL/SQL code for implementing the application logic
  • Ensuring security of the database by creating profiles for each user and monitored the user sessions.
  • Reporting and resolving all serious Oracle alert log messages
  • Responsible for enhancements depends on the client’s functionality
  • Interaction with Development Team in fine tuning the SQL and PL/SQL code
  • Resolve the database issues of the users whenever in need of
  • Created SQL scripts for static data, views, and synonyms
  • Provide Performance Tuning Support to the Client Sql queries

Hire Now