We provide IT Staff Augmentation Services!

Sr. Pl/sql Developer Resume

San Antonio, Tx

SUMMARY:

  • Oracle PL/SQL with 7+ years of experience in Design, data modelling, analysis, performance tuning.
  • Experience working with Oracle 8i/9i/10g including PL/SQL programming.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Solid experience in translating business requirements into creation of Database Objects.
  • Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
  • Experience in metadata modeling, development of all three layers (Physical, Business Model and Presentation).
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Having a good knowledge and experience in STAR Schema, FACT and Dimension tables.
  • Experience in supporting 8 mission critical application, 10 critical application and 7 non critical applications.
  • Experience working in model of Client, vendor & IT management team.
  • Implemented many industry best practice, IT standards, guidelines and process.
  • Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
  • PL/SQL: Strong back - end programming experience using PL/SQL, SQL, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes - B - tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad - hoc queries using SQL.
  • Developed procedure / packages for OLTP, OLAP data warehousing environment.
  • Good experience in Unix Cron jobs, batch processing with highly complex data model.
  • Expert in monitoring query performance using OEM, TOAD.
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Knowledge of architecture/technology needs of the organization based on business priorities, strategies, goals, and economic viability.
  • Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
  • Significant experience in 24/7 Production Environment Support.
  • Knowledge on Informatica Power Center.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, C, Shell Programming (Bourne, Korn), Perl Scripting, Visual Studio.NET 2003/2005.

Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008, MySQL, MS Access.

Reporting Tools: Oracle Forms & Reports 6i/9i/10g, Crystal Reports 8.0, SQL Server Reporting Services (SSRS), SSIS

Tools: TOAD 8.x/9.x, SQL Developer, PL/SQL Developer, Humming Bird 10, F-Secure 5.3, SFTP, Rational Rose, Microsoft Visio, ER-Studio, Erwin, MS Visio, BI, DWB.

DB Utilities: SQL Loader, Export / Import, Data pump, Explain Plan, TKPROF.

Operating Systems: UNIX, LINUX, Sun Solaris 5.X, Windows NT/XP/Vista/7/8.1, Windows 95/98/2000, Windows Server 2003/2008.

WORK EXPERIENCE:

Confidential, San Antonio, TX.

Sr. PL/SQL Developer

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. 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.
  • 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.
  • 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 11g, Toad, PL/SQL, Reports10g, Forms10g, Data Modeling, Data migration, SQL Navigator, Unix Shell Scripting, Window NT, AIX, FTP, SFTP, NDM, PL/SQL Developer, SQL*Loader, Version Control Software CVS, Elemental for Production Support.

Confidential, Austin, TX.

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Developed stored procedures to extract the data from different sources and load it into data warehouse.
  • Analyzing the data and Mapping the data requirements developing Stored Procedures, Functions and Triggers.
  • Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
  • Maintaining daily batch cycle and providing 24 hour production support. Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.
  • Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
  • Utilized SQL*Loader to load flat files into database tables.
  • Created SQL*Loader scripts to load data into temporary staging tables.
  • Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
  • Partitioned tables and indexes for better performance of application
  • Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
  • Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
  • Involved in handling the changes in compiling scripts according to the database changes.
  • Developed reports using complex queries as per client request as a part of production support.
  • Provided on call support, solved the user issues and made necessary changes.
  • Resolving Production severity Issues in time and meeting the SLA.
  • Writing high quality and well documented code according to standards.

Environment: Oracle 10g, SQL Server Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL Developer.

Confidential, Spartanburg, SC.

Oracle PL/SQL Developer

Responsibilities:

  • Support in requirements gathering from the end users.
  • Update design documents according to the changes made to the application.
  • Designed/developed/Modified tables, views, stored procedures, packages and functions.
  • Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
  • Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
  • Developed various Reports using the BI Publisher.
  • Used SQL loader to load the data from the files provided by the interfacing applications.
  • Created new Procedures, Functions, Triggers, Materialized Views, Packages, 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.
  • Implemented all modules logic by using Triggers and Integrity Constraints.
  • Good understanding of database objects and ability to triage issues.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Code SQL Stored Procedures and integrated with application.
  • Involve in Unit Testing for the application developed using test cases.

Environment: PL/SQL, Oracle 10g, 11g, Java, Unix shell scripting, Oracle Forms, Oracle Reports, SQL Developer, BI Publisher, Informatica Power Center, Eclipse.

Confidential, Florence, SC.

Oracle PL/SQL Developer

Responsibilities:

  • Involved in the maintenance and enhancement of the application.
  • Maintaining Logical and Physical structure of the database.
  • Creating table spaces, tables, views, scripts for automatic operations of the database activities.
  • Coded various stored procedures, packages and triggers to in corporate business logic into the application.
  • Used the technical document to design the database tables.
  • Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping
  • Created control files for SQL*Loader.
  • Gather Database and User Level Statistics and Analyse Overall System Performance.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions.
  • Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
  • Develop UNIX shell scripts to administer the system.
  • Extensively worked with Dynamic SQL, Composite data types & Global Temporary tables.
  • Responsible for purging and archiving the production databases.
  • Used UTL JOB to automate the PL/SQL procedures and packages.
  • Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.
  • Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
  • Communicate issues and progress to project manager.
  • Performed logical backup using export and import utilities.
  • Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
  • Involved in Unit Testing Stored Procedures and Functions.

Environment: PL/SQL, Oracle 10g, 11g, Java, UNIX shell scripting, Oracle Forms, Oracle Reports, SQL Developer, BI Publisher, Informatica Power Center, Eclipse.

Confidential, Burlingame, CA.

Oracle Developer

Responsibilities:

  • Analyzing the requirement specifications.
  • Developed several Oracle Stored Procedures
  • Generated reports for management to review for system functionality as against the old legacy reports.
  • Created forms for data input.
  • Wrote Form Triggers, and Program Units.
  • Involved in generation of monthly status of order reports.
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Identifying test execution strategy and scope and Establishing test acceptance criteria.
  • Supporting the application throughout the production release life cycle.
  • Documenting Business Requirements Document (BRD) and Project Initiation Review Checklist (PIR).
  • Strong analytical and problem solving skills.
  • Creating database objects like tables, indexes, views, packages and procedures using PL/SQL Developer.
  • Participated in system analysis and data modeling.
  • Worked on XML along with PL/SQL to modify/create interface between systems.

Environment: Oracle 9i, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP.

Hire Now