Pl/sql Developer Resume
NJ
SUMMARY
- Around 7+ years of diversified experience in analysis, design, development, testing and implementation of applications in the Client Server environment.
- Expert level skills as an Oracle developer includes PL/SQL, SQL, APEX; stored procedures, packages, functions, cursors, triggers, constraints, Perl Scripting., UC4
- Expert in developing the user interface forms and reports using APEX.
- Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
- Experience in using TOAD, SQL Developer and PL/SQL Developer.
- Conceptual knowledge of Oracle SQL, PL/SQL.
- Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
- Experience in data extraction, data migration and Data loading.
- Technical documentation of different lifecycle deliverables and user manuals.
- Strong Knowledge on Application Implementation Method (AIM).
- Sound working knowledge in UNIX Operating system.
- Extensive knowledge on Performance Tuning procedures.
- Analyze data quality and report the anomalies to business users using SQL Developer.
- Client handling skills and proven experience.
- In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
TECHNICAL SKILLS
Databases: MS Confidential 2000, SQL*Plus
Programming and GUI: SQL, PL/SQL, SQL*Loader, SQL*Plus, Pro*c, TOAD, PL/SQL developer, SQL Developer, APEX3.2, UC4, PERL Scripting
Operating System: Windows 9X,Windows NT, Windows XP,7,8, UNIX
PROFESSIONAL EXPERIENCE
Confidential, NJ
PL/SQL Developer
Responsibilities:
- Analysis of new business requirements and major developments.
- Impact analysis for the proposed changes were made and documented.
- Preparation of System Test Plan, Functional Specifications, User Manual, Data Model using the normalization process.
- Client interaction through meetings & presentations.
- Involved in developing various Forms, Reports, Procedure, Functions and the PL/SQL Libraries to support the GUI application.
- Involved in Extraction and loading of data in between the schemas using oracle Export and Import utilities.
- Trouble - shoot performance issues and bugs within PL/SQL packages, forms and reports.
- Documented all the PL/SQL Procedures, changes and modifications, configurations, Backup strategies, standby database setup.
- Worked on creating stored procedures, functions, triggers and packages.
- Worked on performance tuning using the execution plan, explain plan and oracle hints.
- Worked on materialized views and table partitioning for the better performance.
- Used SQL * Loader to load large flat files in the database.
- Production Support & User Acceptance Testing Support.
- Domain Knowledge sharing within & across projects.
- Trouble shooting within & across projects.
- Production support and version releases. Was available 24*7 to resolve production issue.
Environment: PL/SQL, SQL* Loader, SQL*PLUS, Oracle 11g
Confidential, Newedge, IL
PL/SQL Developer
Responsibilities:
- Using the Toad and SQL Developer tool to Design, Develop and tune the SQL code
- Designing and developing SQL procedures, Triggers, tables, views, query performance tuning and packages
- Creating, modifying and reviewing Procedures, Packages and functions and cursors to suit business requirements
- Creating indexes and partitions on various tables in order to enhance performance
- Providing support and played a major role in debugging errors during implementation and deployment
- Creating database objects like synonyms and sequences
- Optimizing the SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modifying some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways
- Using EXPORT/IMPORT to do table level and full database d-fragmentation. Used UC4 for the automation process.
- Using composite data types like %ROWTYPE and %TYPE
- Using the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
Environment: Oracle 11g, SQL Developer, Toad, UC4, MS Office 2010, Windows XP
Confidential, MI
PL/SQL Developer
Responsibilities:
- Designing module wise Oracle 8i database structure and its implementation on the client server
- Used PL/SQL table to avoid mutating problem in database trigger
- Develop tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types
- Involved in Data Extraction using UTL FILES in PL/SQL.
- Created database objects like tables, views, indexes, partitions.
- Taking logical backups using export at object and schema level.
- Worked on tuning the SQL queries and stored procedures.
- Query performance using better joins and used Hints appropriately
- Developed packages, procedure and functions for complex Reports
- Modified Stored Procedures and Stored Packaged Procedures.
- Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
- Provided support for production issues In Discoverer/Forms/Workflows
- Scheduling different activity using Perl scripting
- Created documentation for the application.
- Used shell scripting to change and modify the data
- Using the corn tab in UNIX for automatic tasks.
Environment: Oracle 10g, Forms 10g, Sun Solaris 2.6, Toad8.0, Windows 2000/NT, SQL plus, PL/SQL, UNIX
Confidential, IL
PL/SQL Developer
Responsibilities:
- Designed and developed SQL procedures, Triggers, tables, views, query performance tunings and IOP packages
- Designed the Unit testing plan for the issues worked on for the testing purpose, Worked on the System design document.
- Designed Jacl scripts, XML Files, bat files for the link to the MS Confidential (front end).
- Develop underlying data models and databases
- Ensure compliance of standards and conventions in developing programs
- Design, develop and implement life cycle of IOP
- Translate business requirements into software applications and models
- Resolving, supporting and troubleshooting existing Client Reporting Applications
- Maintain and manage all versions of data models for production, testing and developing databases
- Strengthen client relationships and be knowledgeable about their marketing objectives
- Positive client feedback on Service Level Agreements
- Worked as an ETL tester
- Creation of client specific perl modules that stage/parse raw client data from a variety of formats and render documents into postscript and/or pdf formats
- Debugging, troubleshooting and maintenance of existing perl scripts and modules
- Worked on Functional Requirement Documents.
- Developed the POC (Proof of concept) to Demonstrate options.
- Performed code reviews
Environment: Oracle 10g, IOP,, PL/SQL Developer, SQL developer, Excel 2003/2010
Confidential, VA
APEX-PL/SQL Developer
Responsibilities:
- Analysis of new business requirements and major developments.
- Coded and debugged the stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
- Created Users, Admin accounts for teammates.
- Created Oracle Apex Application from Scratch.
- Created, modified and reviewed Procedures, Packages and functions and cursors to suit business requirements
- Created Apex triggers for different functions of the application including database and report triggers.
- Created and defined Row Sets, Columns Sets and Content Sets.
- Developed and verified forms and Reports on 10g using Oracle Application Express (APEX3.2).
- Created maintained and compared objects in multiple schemas for developers
- Performed import and export of schemas, objects using data pump utility in 10g
- Written shell scripts for rebuilding existing databases to keep up with the latest developments
- Performed tuning for PL/SQL procedures and packages and modified code accordingly to improve performance
- Created indexes and partitions on various tables in order to enhance performance
- Written shell scripts to load data into various subsystems using SQL loader
- Provided production support and played a major role in debugging errors during implementation and deployment
- Modified code to maintain user jobs running on regular intervals performing data transfer from staging area to log tables
- Designed and developed customized Reports, Forms, PL/SQL packages, Workflow.
- Performed code reviews on PL/SQL and SQL
- Created database objects like tables, views, synonyms, indexes, and sequences.
- Used shell scripting to change and modify data.
- UsedSQL Server SSIS toolto build high performance data integration solutions includingextraction, transformationandload packagesfordata warehousing.
- Extracted data from theXMLfile and loaded it into thedatabase.
- Integrated, tested, debugged and implemented application systems.
- Optimized SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modified some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways.
Environment: Oracle 11g, Pl/Sql Developer, SQL Developer, REDHAT LINUX, Forms 10g, Clear Case, Clear Quest, APEX 3.2
Confidential
APEX-PL/SQL Developer
Responsibilities:
- Developed PL/SQL procedures and functions to assign sensitivity levels to specific data based on a set of rules.
- Developed PL/SQL stored procedures and functions to implement customer specific rules
- Performance tuning and optimization using explain plans, partitions and indexes.
- Worked with systems and business analysts to establish data warehouse design.
- Used ETL tool Informatica to convert code from other DBMS versions to Oracle
Environment: Oracle 10g, Oracle PL/SQL, SQL, TOAD
Confidential
APEX-PL/SQL Developer
Responsibilities:
- Done analysis of the project by interacting with the user at different levels
- Involved in application design, development, testing, Integration and implementation
- Creation of tables, indexes, views
- Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
- Used Power exchange for mainframe sources.
- Creation of PL/SQL procedures, functions, cursors, packages
- Performed code reviews on PL/SQL and Linux development
Environment: ASP, ORACLE 9i, PL/SQL, Red hat Linux, APEX