Oracle PL/SQL Developer Resume Profile, TX

Reference Id: 83091     Posted on Friday 18th September 2015      Oracle PL-SQL



Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

Oracle PL/SQL Developer Resume Profile, TX

PROFESSIONAL SUMMARY

  • 7+years of experience inITindustry with emphasis onAnalysis, Design, Development, Implementation and Managementof projects usingOracle (Sql, PL/SQL).
  • 7years of experience working withOracle 8i/9i/10g including PL/SQL programming.
  • Solid experience in translating business requirements into creation ofDatabase Objects.
  • Strong Exposure in writingSimpleandComplexSQLs, PL/SQL Functions and Procedures, Packagesand creation of Oracle Objects -Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
  • Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
  • PreparedBRS (Business Requirement Specifications)document that gives the detailed information about the requirements.
  • Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such asImport/Export, SQL*Loaderand SQL*PLUS.
  • Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
  • Proficient intuning queriesused in the application.
  • Highly skilled inPerformance tuning- analyzing query plans and query tuning using the tools such asEXPLAIN PLANand usehintswherever required.
  • Experience in advanced PL/SQL concepts likeBulk collectandfor all.
  • Expertise inDynamic SQL, Records, Arrays and Exception Handling.
  • Very Good experience withUNIX Cron Jobs,Batch Processing with highlycomplex data model
  • Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
  • Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
  • Possess excellent oral / written communication and interpersonal skills.
  • Good ability to quickly grasp and master new concepts and technologies.
  • Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
  • Significant experiencein24/7 ProductionEnvironment Support.
  • Knowledge onInformatica Power Center

TECHNICAL SKILLS

Databases

Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers),Confidential SQL SERVER 2000/2005/2008,DB2/UDB, Teradata, SAP Tables andConfidential Access.

Reporting Tools

Business ObjectsDeveloper Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5

Operating Systems

HUNIX(Sun Solaris, LINUX, HP UNIX, AIX), Windows NT/98/95/2000 & Windows XP.

Data Modeling

Erwin 3.5.2,4.0

Languages/Utilities

SQL, PL/SQL, Unix shell scripts,Java, XML, C and Cobol.

Other Tools

AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0 Developer/Analyst, TPump, Fast Load, BTEQ

cal Center At Brackenridge)

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Designed/developed/Modifiedtables, views, materialized view, stored procedures, packagesandfunctions.
  • 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.
  • UsedSQL loaderto load the data from the files provided by the interfacing applications.
  • Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Createdpartitioned tablesandpartitioned indexesto improve the performance of the applications.
  • WrotePL/SQL Database triggersto implement the business rules in the application.
  • Createdexternal tablesto handle huge volumes of data which is not used frequently.
  • Optimized lot ofSQL statementsandPL/SQL blocksby 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 asViews, Functions, Triggers, ProceduresandPackagesusingSQLandPL/SQLlanguage for the top management for decision making.
  • Implemented all modules logic by usingTriggersandIntegrity 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.
  • Createdmaterialized viewsrequired for the application.

Environment: C, C++, UNIX Shell Scripting, Forms, PL/SQL, Oracle 10g,11g.

Confidential

Responsibilities:

  • DevelopedPL/SQL Packages, ProceduresandFunctionsaccordance with Business Requirements for loading data into database tables.
  • Involved inUnit Testing Stored ProceduresandFunctions.
  • CreatedMaterialized Viewsandpartitioning tablesfor performance reasons.
  • Worked on variousbackend ProceduresandFunctionsusing PL/SQL..
  • Troubleshooted performance issues and bugs within packages, forms, and reports using dbms_output, Forms debugger, explain plan.
  • Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
  • Coordinate with the front end design team to provide them with the necessarystored packageandproceduresand necessary insight into the data.
  • Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
  • Development of C modules for activation, deactivation and modification of these plans in Clarify Front End
  • CreatedSQL*Loaderscripts to load data into the temporary staging tables.
  • DesigningTables, Constraints, Views, andIndexes in coordination with the application development team
  • Used TOAD, PL/SQL developer tools for faster application design and developments
  • Developed procedures usingDynamic SQL.
  • Developed database objects includingtables, Indexes, views, sequences, packages, triggers and proceduresto troubleshoot any database problems
  • Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
  • CreatedMaterialized Viewsandpartitioning tablesfor performance reasons.
  • Resolving the issues on priority basis.
  • Responsible for Analyzing and Implementing the Change Requests.
  • Involved in handling the changes in compiling scripts according to the database changes.

Environment: C, C++, UNIX shell scripting, Oracle 10g, PL/SQL, Toad, Clarify.

Confidential

Responsibility:

  • Generate reports using oracle reports
  • Developed new complex stored procedures (sometimes running up to 120
    pages when printed), packages, custom functions and triggers in oracle
  • Develop new data warehouse tables and load data from different sources
  • Analyze and configure databases for various database changes
  • Extensively used SQL * Loader to load data in the
  • Extensively used UTL_FILE to extract data into flat files from the database
  • Used Data profiling to do source system analysis.
  • Developed & supported applications for company's client-server based
    strategic business systems & integrate with existing applications
  • Performance tuned SQL queries using Hints, AUTOTRACE, TKPROF, ADDM,
    AWR, Explain Plan and SQL advisor
  • Used JDBC with Java for connection to database and run queries.
  • Created Materialized views and presented to BI teams
  • Performed bug verification, release testing and provided support for Oracle
    based applications
  • Followed project plans and provide clear status of progress. May include
    participation in daily status meetings & Participated in design meetings to
    gather user requirements from business units
  • Followed the company software development life cycles and conform to
    best practices
  • Reviewed business requirements, detailed software requirements and designs
    ENVIRONMENT: Oracle 10g,11g, Oracle Enterprise Manager 10g,WINDOWS ,
    SQL, PL/SQL, SQL Developer and TOAD, Data pump, SQL*Loader, VSS Outlook,
    and OLAP/OLTP

Environment: C, C++, UNIX Shell Scripting, Forms, PL/SQL, Oracle 10g,11g.

Confidential

Responsibility:

  • Created different schemas and maintained schema objects
  • Created a script for loading data into to read data from flat files to dump to
    Oracle database using SQL * Loader
  • Developed PL/SQL Procedures and database triggers for the validation of input
    data and to implement business rules
  • Created scripts to create new tables, views, queries for new enhancement in
    the application using TOAD
  • Created indexes on the tables for faster retrieval of the data to enhance
    database performance
  • Created new packages and modified existing codes to resolve application
  • Worked with DBA team to deploy the code changes into Test, Integration
    and later into Production environments and with Operations team to publish
    tasks in aforementioned environments
  • Analyze bugs raised by user & created necessary technical documents for
    resolving those bugs.
  • Provide appropriate resolution for each bug by putting in data fixes, updating
    View definitions etc.

Environment: C, C++, UNIX Shell Scripting, Forms, PL/SQL, Oracle 10g,11g

Confidential

Responsibility:

  • Created PL/SQL interface Programs for data merging, log file generating and
    auto job scheduling using PL/SQL, UTL_FILE and DBMS_JOB
  • Functional and Technical understanding of the Telecom domain to validate
    the data
  • Extensively involved in writing procedures, functions, triggers and packages
  • Involved in Analyzing and Performance Tuning of the SQL queries using
    optimizer hints for joins, parallelism and Explain plan
  • Involved in debugging and fixing the codes that had performance issues
  • Involved in Unit Testing the codes.
  • Used Data profiling to do source system analysis.
  • Worked with the Table Partitions to further improve the performance while
    using tables containing large number of columns and rows
  • Used SQL*LOADER to store data in the Oracle database from different types
    of flat files
  • Involved in generating Ad-hoc reports and internal reports required for the
    analysis of the processes going on in the project and that are requested by the
    users
  • Involved in running cron jobs at fixed times
  • Involved in preparing technical documentation
  • Worked closely with the testing team helping them in testing the codes

Environment: Oracle10g, SQL, PL/SQL, TOAD, SQL*LOADER, UNIX, Oracle
Reports 10g, Forms10g, JAVA, ECLLIPSE, Linux, HTML, Lotus notes, PVCS, OLAP

Search Resumes

Looking for I.T Professionals on a Contract basis?