Oracle Pl/sql Developer Resume
3.00/5 (Submit Your Rating)
Atlanta, GA
SUMMARY
- 7+ years of experience in IT, primarily in Enterprise Oracle database, reports and Datawarehousing assignments.
- Experienced in delivery of small projects as a nearshore project Lead.Currently seeking a position where I can utilize and enhance my experience built with the past work assignments.
- Expertise in execution of all phases of the software life cycle including analysis, development, testing, maintenance and production support.
- Domain exposure includes banking, retail and healthcare.
- Competent in learning and adapting quickly in a fast paced environment. Efficient enough to multitask and prioritize tasks to deliver value.
TECHNICAL SKILLS
- Languages
- Oracle Database - 11g(SQL/PLSQL).
- Familiar with Oracle Developer Suite(forms/report builder)(11g).
- Familiar with Oracle Application 9i
- SQL/PLSQL
- Software
- Oracle Database
- Oracle form and reports
- Toad
- Microsoft SQL
- Oracle Data Integrator (ODI)
- Microsoft Office
- SQL*Loader
- Putty
- Bugherd
- Exago - Reporting Tool
- Version Control Systems
- MS Visual Source Safe
- GitHub
PROFESSIONAL EXPERIENCE
Confidential - Atlanta, GA
Oracle PL/SQL Developer
Responsibilities:
- Written PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL.
- Created database triggers, sequences, stored procedures, and other database objects using Toad.
- Developed data model, PL/SQL Queries, SQL Query tuning process, and Schemas.
- Created and designed new web pages using HTML5, CSS3, and JavaScript.
- Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
- Worked on enhancements & defects as per the business requirements.
- Performed SQL, PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.
- Developed UNIX Shell scripts to automate table creation, execute procedures.
- Worked with DBMS XMLGEN and DBMS XMLSTORE package to generate and insert XML files in Oracle.
- Worked with developers to repair and enhance current base of PL/SQL packages to fix testing issues.
- Built new functionality and improve processing time through code optimizations and indexes.
- Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions, and DB Triggers.
- Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
- Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
- Used SVN version management to manage various versions of the procedures and functions of the application.
- Created complex SSIS packages using proper control and data flow elements with error handling.
- Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
- Involved in migrating from mainframes to Oracle 11g.
- Partitioned the fact tables and materialized views to enhance the performance.
- Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
- Involved in Unit testing and Integration testing of forms and reports.
- Have worked in fast paced AGILE environment & attended daily scrum meeting.
- Create Subscriptions in Data Mirror with different Mapping Types.
- Wrote SQL and PL/SQL programming code for ODI and oracle.
- Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
Confidential, Bentonville, AR
Oracle PL/SQL Developer
Responsibilities:
- As a team member interact with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.
- Involved in developing Logical and Physical Data Models.
- Created different schemas and maintained schema objects.
- Wrote PL/SQL overloading stored procedures, functions, packages, triggers, cursors and package constructors to enforce business rules.
- Developed multiple reports using Exago Reporting tool for listing the customers who visited the center
- Was engaged in performance tuning and end-to-end integration testing, before providing the final delivery.
- Written effective SQL queries for extracting data as per business requirements.
- Developed PL/SQL code as per the project requirement including Functions, Stored Procedures, Packages, Cursors, Triggers, and Views.
- Performed Data Analysis on legacy system data before loading into Oracle database.
- Developed and maintained SQL Loader Scripts for loading data from legacy systems to Oracle database.
- Was responsible for creating and modifying the PL/SQL stored procedures, functions and packages, which load data from temp tables to interface tables and do data validations.
- Created indexes to improve performance of SQL and PL/SQL scripts.
- Used Oracle Trace and Explain Plan utilities to catch the poor performing queries and analyze their execution plans.
- Used SQL Server SSIStool to build high performance data integration solutions including extraction, transformation and load packages for datawarehousing. Extracted data from the XML file and loaded it into the database.
- Designed and developed Oracle forms & reports generating up to 60 reports.
- Performed modifications on existing form as per change request and maintained it.
- Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
- Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
- Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target datastructures.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Gathered requirements and worked on the basic application design of application with the client.
- Worked on enhancing various oracle stored objects like packages, procedures, functions and triggers so as to meet the customers’ requirement. This involved migration of medical codes from ICD9 format to ICD10 format.
- Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer to extract the data from multiple source systems that comprise databases like Oracle to the Staging area then to the Data Marts.
- Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
- Utilized Partitions to fine-tune SQL data load.
- Used Toad as an advanced SQL - PL/SQL editor.
- Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
- Involved in generating Web Intelligence Reports to satisfy ad hoc request
- Provided support to the QA team whenever issues were raised during the testing phase and was involved in the project deployment.
- Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
- Designed logical and physical data models for star and snowflake schemas using Erwin.
- Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
- Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
- Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
- Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
- Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
Environment: Oracle 11g, SQL, PL/SQL, Microsoft Visual Studio
Confidential
Oracle PL/SQL Developer/Junior Informatica developer
Responsibilities:
- Worked extensively on migrating data from another database like DB2
- Wrote new procedures for PL/SQL development (functions, packages, procedures, triggers, Anonymous Block).
- Was solely responsible for gathering requirements, developing and maintaining some of the critical project modules.
- Wrote complex SQL queries involving multiple joins, sub queries and including use of CTEs, merge and dynamic SQL .
- Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
- Monitored and maintained existing ETL packages to fix issues and bugs and troubleshooting.
- Wrote multiple error handling logics in oracle to handle exceptions.
- Involved in end to end functional testing during different migration cycles.
- Worked with business team to create multiple training guides for training team.
- Developed UNIX Shell scripting for job automation and daily backup.
- Involved in performance tuning using with TKPROF.
- Documentation of the business process through Designer.
- Writing backend stored procedures.
- Writing event driven Triggers, Functions and Packages as needed.
- Writing SQL queries, Cursors using embedded SQL, PL/SQL.
- Testing and debugging of the applications.
- Separating of tables and indexes on different locations. Reducing Disk I/O Contention.
- Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS. Oracle query tuning and optimization.
- Extensive Use of Bulk Binds, Bulk Collect.
- Extensive Use of Pragma Autonomous Transactions.
Environment: Oracle PL/SQL, Informatica, TOAD,Oracle10g, Informatica, SQL Developer, UNIX.
Confidential
Database Developer/Informatica developer
Responsibilities:
- Analyze all business requirements and document all technical specifications.
- Created and maintained PL SQL scripts and stored procedures
- Designed and Developed application using packages, stored procedures and functions to manipulate the database and to apply the business logic according to the user specifications.
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
- Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source Oracle tables to target tables.Created multiple Mapplets, Workflows, Tasks, database connections using Workflow Manager.
- Extracted data from Oracle, flat files and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
- Worked on performance tuning using various PL SQL tuning techniques for query optimizations.
- Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.
- Conduct unit testing according to the business requirements.
- Involved in writing Test cases documents.
- Worked under tight schedules for successful development and implementation.
Environment: Oracle PL/SQL, UNIX,MDF
Confidential
PLSQL Developer
Responsibilities:
- Designed, built and deployed effective mappings and workflows.
- Developed PLSQL packages with stored procedures and functions as per the technical requirement
- Implemented stored procedures and effectively used oracle queries.
- Translated requirements from the business and analyst into technical code.
- Designed and Developed application using packages, stored procedures and functions to manipulate the database and to apply the business logic according to the user specifications Ensure the best possible performance and quality in the packages.
- Provide support and fix issues in the packages
- Wrote UNIX Shell Scripts to automate the daily process as per the business requirement.
- Writing Tuned SQL queries for data retrieval involving Complex Join Conditions.
- Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also extensive Usage of Indexes.
- Read data from flat files and load into Database using SQL*Loader.
- Created the External Tables in order to load data from flat files and PL/SQL scripts for monitoring.
Confidential
PLSQL / Junior ETL Developer
Responsibilities:
- Developed PLSQL packages with stored procedures and functions as per the technical requirement
- Worked on enhancements for specific modules based on customers’ input
- Performed extensive oracle database programming and tuning of SQL queries
- End to end module testing to assess the working of the functionality
- Coordinated with the testing team to fix the bugs reported
- Analysis, design and development of PL/SQL ETL processes for new incoming clients.
- Design, development, and maintenance of applications written in PL/SQL, Oracle 6i forms, Oracle 6i reports and Unix.
- Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader.
- Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures
- Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, and other database objects.
- Create PL/SQL packages, stand alone procedures, and stand alone functions.