Oracle Pl/sql Developer Resume
Charlotte, NC
PROFESSIONAL SUMMARY:
- About 7+ years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
- Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design.
- Solid experience in vertical segment Automotive, Banking, Retail management system and financial management system.
- Good Knowledge in Relational Data Modeling.
- Expertise in using tools such as TOAD, SQL developer, PL/SQL developer.
- Strong knowledge of Oracle 9i/10g/11g, PL/SQL.
- Excellent Analytical, conceptual and root cause analysis and problem solving skills.
- Strong Experience in designing and developing oracle objects Tables, Views, Indexes PL/SQL Packages, Functions, Stored Procedures, and Triggers.
- Strong knowledge in Oracle Cursor management, Exception Handling, REF Cursors
- Worked on advanced PL/SQL constructs like Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
- Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
- Experience in PL/SQL collections, Bulk collections and Exception handling.
- Extensively worked with various SQL scripts for relational databases.
- Knowledge of working with the Oracle Application server for the Forms and Reports application in various projects.
- Extensively worked on PL/SQL features like Forms, Triggers, Data blocks, Report Layout, Parameter forms, Report Triggers.
- Experience in designing and developing various reports using Oracle Reports
- Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
- Experience with database query optimization and performance tuning using Explain Plan, SQL - Trace, TK-Prof oracle utilities and creating relevant system and users documentation
- Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL)
- Expertise in understanding Slowly Changing Dimensions Type1, Type2 and Type3.
- Providing assistance in logical/physical data modeling using ERWIN.
- Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
- Experience in Database modeling and database object definitions using tools like Oracle Designer.
- Experienced in Unit testing and Integration Testing with excellent debugging skills.
- Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
- Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
- Great Team player with Strong interpersonal skills, communication skills and documentation skills
TECHNICAL SKILLS:
RDBMS: Oracle 11g/10g/9i, TOAD, SQL Developer, SQL * Plus
Database tools: PL/SQL Developer, Forms10g/9i/6i, TOAD, Oracle Enterprise Manager
Operating systems: UNIX, Windows NT/2000/2003/XP/7
Languages: C, C++, JAVA, SQL, PL/SQL, UNIX Shell Scripting
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte, NC
Oracle PL/SQL Developer
Responsibilities:
- Participated in complete process of functionality testing of all AutoSys applications.
- Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
- Responsible for problem identification and resolution of failed processes or jobs and assisted in troubleshooting issues with applications in AutoSys.
- Proactive in finding issues and seeking and implementing solutions.
- Used PL/SQL to create PACKAGES, FUNCTIONS, and PROCEDURES.
- Executed PL/SQL blocks using cursors, REFCURSORS, exception handling, Collections, Index of Table and Dynamic SQL.
- Designed Batch Processing system for applications using AutoSys. Developed standardized scripts for job implementation.
- Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.
- Used AutoSys job scheduler for automating the daily regular run of DW cycle in UAT environments
- Involved in Database Designing and Creation.
- Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
- SQL tuning using SQL Trace and TKPROF, Explain Plan for performance issues resolution.
- Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
- Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
- Created ETL Procedures for more than 600+ tables and views on top of these tables.
- Tested and corrected errors and refined changes to database.
- Tuned performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
- Used Bulk Collect feature for improve performances to handle large amount of table data.
- Wrote Test case/ data preparation, execution including verification of the test results.
- Loading data from flat files into Oracle 10g database using SQL*loader and UNIX script.
- Create User Schemas, TABLES, INDEXES, SEQUENCES, and VIEWS.
- Used Scrambled and Unscrambled functions to Encrypt and Decrypt the sensitive data.
- Worked with DBA to create the physical model and tables.
- Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.
- Developed job sequencer with proper job dependencies, job control stages, triggers.
- Verify, validate data using SQL queries.
- Interacted with the business users to better understand the requirements and document their expectations, handling the current process, modifying and created the jobs to the updated requirements, handle the load process to data mart and eventually data warehouse.
- Analyzing the code written by different developers to understand the transformation applied on columns to document them.
- Data Modeler with strong Conceptual and Logical Data Modeling skills has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
- Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
- Worked extensively on forward and reverse engineering processes.
- Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
- Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
- Documented the Excel formulas and pivot tables used for data cleansing.
- Gathering requirements for summary data sets for each stakeholder group. Includes elements, configurability; logic for trending reports, history tracking and other aggregations, and Created/maintained/modified data base design document with detailed description of logical entities and physical tables..
- Sorting logical data grouping for originations source data that to be loaded into analytics.
- Experience in complete life cycle of Design, Development, Maintenance and Documentation of Conversion Process.
- Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
- Extensively used Microsoft Visio for documentation.
- Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables.
- Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
- Participated in weekly status meetings.
Environment: Oracle 11g/10g, SQL, PLSQL, UNIX, AUTOSYS, SQL*LOADER, MICROSOFT VISIO, FLAT Files, ERWIN 3.5.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Excess Equipment is a Web Application for all plants to Request Equipment’s.
- Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
- Participated in system analysis and data modeling, which included creating tables, views, indexes synonyms, triggers, functions, procedures, cursors, and packages according to the new business measures.
- Worked on PL/SQL tool TOAD to run SQL queries to validate the data.
- Modifying existing web application GUI as per the need from the look and feel point of view using HTML, Java script.
- Extensively used HTP and HTF package used to dynamically build webpage from PL/SQL.
- Developed stored packages with Oracle's Web Toolkit.
- Worked with front end application developers with their queries/stored procedures while building User-Interface for the project.
- Wrote complex SQL queries using Joins, Sub queries and Group functions.
- Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
- Good experience in communicating with offshore team.
- Worked closely with end-users and team members to understand business requirements that drive the analysis.
- Extensively worked with Data Stage Job Sequences to Control and Execute Data Stage Jobs and JobSequences using various Activities.
- Used server jobs to Extraction, Transformation and Load.
- Wrote complex SQL queries using Joins, Sub queries and Group functions.
- Worked on package more than 15000 lines.
- Extensively used Parallel Stages like Join, Merge, Lookup, Filter, Remove Duplicates, Row Generator, Modify etc. for development and debugging purposes.
- Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
- Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms, Import and export items between different DataStage systems or exchange metadata with other data warehousing tools.
Environment: Oracle 11g/10g, SQL, PLSQL, UNIX, TOAD, DATA STAGE 8.5x, 9.1 xs
Confidential
Oracle PL SQL Developer
Responsibilities:
- Worked in the Dynamic Pricing Portal team, to support the business team.
- Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
- Developed stored procedures and triggers to facilitate consistent data entry into database.
- Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
- Utilized SQL*Loader to load flat files database tables.
- Initialized utilization of Data Warehouse ETL software during conversion of data to Oracle DB.
- Used UNIX Shell Scripts to automate backend jobs.
- Executing and maintaining the data warehouse extract transform load (ETL) process.
- Gathered statistics and analyzed tables and Indexes for performance tuning.
- Used performance tuning utilities like EXPLAIN PLAN, SQL Trace and DBMS PROFILER to improve the performance by reducing the run time of queries on the database.
- Based on the data loaded in the target database (oracle) various business reports are developed.
- For the reporting purpose extensively used SQL Scripts.
- Wrote complex SQL queries using Joins, Sub queries and Group functions.
- Involved in modifying various existing packages, procedures, functions and triggers according to the new business measures.
- Worked as an application DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
- Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
- Used Cursors, Native Dynamic SQL and Bulk Collections to implement the Bulk Load.
- Used Materialized views in order to improve the performance.
- Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
- Trouble shooting performance issues within packages using DBMS OUTPUT
- Coordinating with the business users for System Test and User Acceptance Test.
- Developed scripts for validating the UAT deployment for the schema objects.
- Responsible for Documentation of all the project developments and methodologies followed for the defect-fix, as per the standards defined and the system requirements.
- Resolving problems by reviewing and analyzing software documentation and production outputs to identify causes - troubleshooting
- Handling every week’s production deployment.
Environment: Oracle 11g, SQL, PLSQL, UNIX (Sun Solaris).
Confidential
Web Developer
Responsibilities:
- Access library catalog, electronic databases and library information through smart phone devices.
- Responsible for Monitoring and Managing site development and regular web site maintenance.
- Redesigned and improvised the user interface in searching, finding the library material content using Ajax, JQuery and JavaScript, CSS.
- Played a major role in migrating the library website to Word Press.
- Designed and developed a web application for managing and tracking IT resources.
- Extensively worked on Java, JSP, JSTL, PHP, SQL, HTML, and CSS.
- Worked closely with designer and converted Photoshop images into web pages consistent with
Environment: Java, JSP, JSTL, PHP, SQL, HTML, JavaScript, Ajax, JQuery, CSS, Word Press, Apache Tomcat, MySql.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Developed various PL/SQL stored procedures and functions
- Developed data model, SQL Queries, SQL Query tuning process and Schemas.
- Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, DBMS MVIEW and UTL FILE.
- Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
- Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
- Utilized SQL*Loader to load flat files database tables.
- Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements.
- • Created rationalized domains to bring consistency in the tables.
- Involved in Writing, debugging and optimizing PL/SQL code using optimizer hints.
- Involved in migrating database from Oracle 9i to 10g database.
- Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database
- Involved in the ETL process of developing new tables from the existing views and materialized views.
- Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Bulk collections and Exception handling.
- Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
- Worked in SQL, PL/SQL development and database support as well as maintenance.
- Developed and implemented various migration scripts for various schema objects migration.
- Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views
- Performing Unit, Integration and System testing, and setting up UAT for the project modules.
- Used EXPLAIN PLAN, TKPROF to tune SQL queries.
- Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
- Worked closely with end-users and team members to understand business requirements that drive the analysis.
- Participated in Peercode reviews and verifying coding standards.
- Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
Environment: Oracle 9i, 10g, SQL, PLSQL, SQL*Loader, UNIX, TOAD.
Confidential
PL/SQL Developer
Responsibilities:
- Analyzed requirements, designed, developed, deployed and documented software components.
- Designed ER diagram using Erwin, to set the logical and physical relationships of database.
- Developed the SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views to handle the Online and Batch processes.
- Created database Triggers for the security purposes.
- Used Oracle snapshots for replication between various sub branches.
- Loaded the data into database using the SQL*Loader from various sources.
- Creating SQL, Object Views, and PL/SQL database objects. Developed the stored procedures for data transformation purposes.
- Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.
- Fixing bugs according to the software change requirement.
- Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
- Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
- Developed test plan documents for all back end database modules.
- Responsible for unit testing, and documentation of the interfaces.
Environment: Oracle database 8i/9i, Java, Servlets, PL/SQL, SQL Plus, SQL*LOADER, Windows 2000 Professional, and UNIX, Erwin 3.x