We provide IT Staff Augmentation Services!

Oracle Plsql Developer Resume

Foster City, CA

SUMMARY:

  • Around 7+years of IT experience in Design, Development, Implementation and support of RDBMS in Production and Development Environments using Oracle Tools.
  • Involved in complete Project Life Cycle including requirements gathering and Analysis, Database design, Database development, Application development, Testing, Implementation and Support of the application software and extensively on Production support.
  • Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views, partitioned tables using Oracle PL/SQL database programming language.
  • Extensively used Cursors, REF Cursors, composite data type and Collections in writing the backend PL/SQL code.
  • Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources using PL/SQL and SQL*Loader.
  • Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes, Gathering Statistics.
  • Experience in using Oracle APIs for Payables and Receivables Modules.
  • Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating data to load data from staging tables to production tables.
  • Extensive experience withvarious test efforts like data validation, integrity testing and Unit testing.
  • Experiences in implementing update strategies, incremental loads and change data capture.
  • Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
  • Excellent in Query Optimization Techniques, Creating, Replacing & modifying database entity models and maintenance.
  • Used Oracle APIs for Oracle Financials Domain.
  • Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
  • Created and validated XML, XSD, DTD files and Style sheets for Client validations and testing requirements.
  • Experience in using Oracle Forms 9i,Reports6i&2.5 for developing end user screens and reports and also adept in using Oracle Tools like SQL* Plus, Toad, SQL Developer, SQL Loader, Data Loader, SQL navigator, Oracle API.
  • Good team player, quick learner and detail oriented, strong technical, organizational and report writing skills combined with self-motivation.

TECHNICAL SKILLS:

RDBMS: Oracle 12c, 11g, 10g, 9i, 8.x, SQL Server 2000/2005/2008/2012 , MS Access, and MS-Access, SQL*Plus, SQL*Loader, TOAD 7.0, and Developer 2000,Forms 6i/9i/10g, Reports 6i/9i/10g.

Modeling: UML, ERWIN, TOAD, Data Modeler, Putty

Operating Systems: Windows Vista/ XP/2000/2003, Linux.

Oracle Utilities: SQL*LOADER, UTL FILE, Export/Import, Data Pump

Languages: SQL, PL/SQL, Confidential, UNIX Shell Scripting

Database Tools: SQL Loader, TOAD, SQL Navigator

ETL tool: Informatica, Data Transformation Services (DTS)

Developer Tools: SQL*PLUS, SQL Developer, Oracle Developer Suite(Forms and Reports),Oracle Reports Builder.

3 rd Party tools: MS Visio, PowerBuilder, TOAD,SQL Navigator, SVN Tortoise, Hp Quality Center, JIRA, Service now, TFS Repository.

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Oracle PLSQL Developer

Responsibilities:

  • Designing and developing tools, techniques, metrics, and dashboards for insights and data visualization.
  • Drive an understanding and adherence to the principles of data quality management including metadata, lineage, and businessdefinitions.
  • Build and execute tools to monitor and report on data quality.
  • Performing Source to Target data analysis and data mapping.
  • Developing PL/ SQL triggers and master tables for automatic creation of primary keys.
  • Improving the performance of the application by rewriting the SQL queries.
  • Experience in developing the existing SQL queries due to performance issues.
  • Working on complex PL/SQL queries, and correlated sub queries, Views and procedures for effective Business Applicationdevelopment
  • Data profiling for accurate and better reporting and analysis. Proficient in developing and maintaining of packages, functions,triggers, tables, views.
  • Understand the data visualization requirements from the Business Users.

Environment: SQL Developer, Service Now.

Confidential, Pasadena, CA

Oracle PLSQL Developer

Responsibilities:

  • Provided tier 3 support by working with software development and QA teams.
  • Provided Tier 3 support and root-cause analysis for incidents and/or service requests
  • Providing tier 3 application support by monitoring internal software applications in the application (client).
  • Submitting bugs and tasks in Service now issue tracking software development and coordinating with offshore digital teams.
  • Experience in working with the Service now ticketing tool.
  • Identified, documented, and troubleshooted application computing issues as they arise.
  • Experience in working with UNIX and PUTTY Environments.
  • Experience working as L2 production support.
  • Proficient in developing and maintaining of packages, functions, triggers, tables, views.
  • Resolving customer reported tickets in Service now. Related tasks and completing application support requests.
  • Worked with SQL Joints on tables for performance reasons.
  • Experience in developing the existing SQL queries due to performance issues.

Environment: SQL Developer, UNIX, WINSCP, Microsoft Office, Putty.

Confidential, Monroeville, PA

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for conducting user requirement meetings and gathering information from the end users for reporting system and analyzed all the existing system
  • Experience in working with the SPARCS application.
  • Developed and worked on a new screen named as EXTERNALVENDOR screen.
  • Involved in SPP transition project.
  • Created new constraints to identify patients who are eligible for transition based on their drug.
  • Responsible for creating the tables, enforcing the Constraints & Indexes.
  • Responsible for Developing the New Master and Transaction Forms for the data Entry, Updating for data retrieval
  • Created PL/SQL Procedures, Functions and Packages in PL/SQL
  • Responsible for Developing the New Reports using Reports 10g.
  • Responsible for creating the Database Triggers coded to meet the global operation and watch out for overkill.
  • Tested required stored Procedures, Functions, Packages and Database Triggers.
  • Involved in solving the bugs reported by the end user in implementation phase in both Forms and Reports.
  • Involved in performance tuning for slow running Reports using various optimizer hint techniques.

Environment: Oracle 11g/12c, SQL Developer, Oracle Forms and reports.

Confidential, Ashburn, VA

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in Design, Development and Testing of Conversions, Interfaces, Workflow and Reports.
  • Collaborated with Business Analysts and Business Objects team to understand the requirements and translate the requirement into technical specifications.
  • Used PL/SQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
  • Used Bulk Collect, Bulk Insert and For All to decrease query execution time.
  • Defined relationships using primary keys and foreign keys for the entities and normalized the entities.
  • Troubleshooted performance issues and bugs within packages using dbms output, explain plan.
  • Developed stored procedures/packages to run ETL jobs to extract customer information from OLTP database into data warehouse.
  • Responsible for decreasing load times of Data Warehouse by optimizing ETL procedures using PL/SQL.
  • Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
  • Involved in Unit Testing Stored Procedures and Functions.
  • Created SQL*Loader scripts to load data into the temporary staging tables.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
  • Developed procedures using Dynamic SQL.
  • Used Oracle Data Pump for Export/Import of schemas from different DB's
  • Created relevant staging tables to load data identified the business validation rules.
  • Used Autosys to schedule Datastage jobs.
  • Developed Unix shell scripts to call Oracle PL/SQL packages and contributed to standard framework.
  • Tuned complex Stored Procedures for faster execution and developed database structures, according to the requirements.
  • Created Materialized Views and partitioning tables for performance reasons.
  • Experience in writing post validation SQL scripts to verify data is loaded properly once data stage job is completed.
  • Resolving the issues on priority basis.
  • Responsible for Analyzing and Implementing the Change Requests.

Environment: Oracle 11g/12c, SQL Developer, SQL*Loader, TOAD, UNIX, Shell Scripting, Microsoft Office, Putty, Datastage.

Confidential, Herndon, VA

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in Logical & Physical Database Layout Design.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, SQL *Trace, Tkprof and Auto trace.
  • Translated business/functional requirements to create and alter database objects like Tables, Indexes, Constraints, Indexes, Types, Triggers, Grants, Synonyms and Stored Procedures.
  • Created Java Script functions to store in Store Procedure or save in a file. UsedHTML, Java Script, PL/SQL. When user logs in and fills out form, Java Script checks whether input data is valid. If not, message pops up and input is cleared.
  • Used Cursors, Ref-cursors, Bulking techniques, Oracle Supplied Packages, Collections, & Dynamic SQL.
  • Designed and developed the views, materialized views, functions, procedures, packages and triggers
  • Experience with different batch processes (e.g. Mail) that run on a schedule and real-time processes (e.g. web services) to keep the data updated and also to interact with different third-party systems.
  • Worked in FTP to SFTP migrations by public key authentication methods which helps the file to get transferred from local directory to client directory using just the username without any password.
  • Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler for refreshing of materialized view.
  • Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
  • Was in charge of performance tuning several programs and was successful in getting the run time down for more than 90 percent.
  • Assisted my team lead in proposing a new way of writing the procedures and have written a set of coding standards and provided it to the team which was followed by everyone.
  • Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
  • Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make database Faster and easier to maintain.

Environment: Oracle 10g/11g, PL/SQL, SQL Loader, Datastage, Windows NT 4.0/2000/XP and UNIX, TOAD, Java, Shell Scripts, IBM Rational Clear Case version control.

Confidential, NY

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Gathered the requirements from Business Users and passed on the requirements to the team.
  • Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL * Loader.
  • Run Adhoc queries to get client detailed information about their stay and family
  • Design, Develop and Test the jobs in Informatica Power Centerfor the data flow from Flat Files, CARES legacy system to data marts.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
  • Created database objects like packages, procedures, and functions according to the client requirement.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
  • Extracting the data from simple flat text files into operational database.
  • Creation of database objects like tables, views, materialized views, procedures, packages using oracle tools like SQL Loader.
  • Used Golden Gate data selection and filtering for replication and making use of SQLEXEC to interact with database.
  • Created database links to retrieve data from multiple servers.
  • Extensively used for all and bulk collect to fetch large volumes of data from table.
  • Create and run batch files on regular basis.
  • Created records, tables, collections for improving performance by reducing context switching.
  • Created number of database triggers according to business rules using PL/SQL.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Used version control tool VSS, which helps multiple users to access, and make changes to the collection of source code files.

Environment: Oracle 11g, SQL*Plus, SQL*Loader, PL/SQL Developer, Informatica Power Center, Golden Gate, Unix, VSS.

Confidential, Ashburn, VA

Oracle PL/SQL Developer

Responsibilities:

  • Involved in preparing PL/SQL code to implement business rules using triggers, cursors, procedures, functions and packages.
  • Involved in query tuning to improve the performance using Oracle as backend.
  • Created complex SQL queries, stored procedures, functions for the purpose of data analysis.
  • Used advanced PL/SQL concepts including Global Temporary table, Collections (Bulk Collect, Varrays, Nested Tables and PL/SQL Tables).
  • Work with architects, engineers, and stakeholders to interpret requirements and further refine requirements as input to the design process.
  • Work with the QA Department to resolve any defects and or issues with released software.
  • Participate in weekly intra-team code reviews as both a reviewer and a presenter.
  • Developing Test cases and procedures, mapping the Requirements to Test Cases in quality Center.
  • Involved in fixing the issues after comparing source and output data.
  • Performed Backend testing, writing SQL queries and execute in TOAD.
  • Developed Oracle Forms for form end user using oracle form builder 10g.
  • Experience in using SQL queries to develop complex queries for data validation, inner/outer joins, joining multiple tables.
  • Verified the table’s structure as per the DB design and data in different DB tables as per the requirements.
  • Executed scripts in UNIX environment using putty.
  • Performed regression testing to make sure that new functionalities are not impacting existing functionalities in the system.

Environment: Oracle9i/10g,SQLServer,PL/SQL,SQL*Plus, TOAD, SQL*Loader, eBDR, eProgesa, Quality Center, FTP, DTS package, MS Office, Oracle Forms and reports 10g.

Confidential, San Diego, CA

Oracle PL/SQL Developer

Responsibilities:

  • Extracted data from different sources like flat files and loaded into Oracle data warehouse according to the specifications.
  • Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
  • Created stored procedures, triggers, tables, views.
  • Extensively used Cursors, REF cursors, User-defined object types, Records.
  • Documented all the packages, procedures and functions involved in ETL process.
  • Identifying performance bottlenecks, suggesting and implementing alternative approaches and performance tuning the code to cut down the resources and time consumed and making sure the optimizer pick the right plan at all times while maintain data integrity.
  • Creating database objects such as external tables, staging tables, views, synonyms, indexes, sequences and database links tailored to business requirements.
  • Developed Shell Scripts to automate file manipulation and data loading procedures.
  • Unit and integration tested the target data.
  • Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation.
  • Performance optimization, procedure definition, queries tuning, database design.
  • Use SQL*Loader utility to upload data files into tables, Export and Import Oracle Utilities to move tables between Schemas.
  • Created views and partitioned tables for performance reasons.
  • Analyze SQL statements, reorganize database objects and design indexes to improve query response time.
  • Involved in fine tuning of the existing packages for better performance and providing on-going support to existing applications and troubleshooting errors when occurred
  • Gathered reporting requirements from business end users/clients.
  • Identified key dimensions and facts for analytical reporting and decisions support reporting to develop custom reports.

Environment: Oracle 9i, TOAD for Oracle PL/SQL, SQL*Plus, SQL*Loader, ERwin 4.0, Windows, UNIX, XML, Microsoft VSS.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Involved in the design anddevelopment of user interface (GUI) in Forms 4.5 and table design using Oracle.
  • Developed various Business and ad-hoc Reports.
  • Created Data Flow Diagram, Entity Relationship Diagram from Designer.
  • Involved in Development, Testing, Implementation and Training.
  • Extensively involved in writing SQL queries (Sub queries and Join conditions).
  • Created Database Triggers in PL/SQL to accommodate for data integrity and additional Referential Integrity.
  • Migration from Oracle 9i to Oracle 10g.
  • Developed KornShell Scripts to ingest data on a daily basis from external source (flat file).
  • Involved in developing UNIX shell scripts required for maintaining and processing job.
  • Involved in Package modifications to reflect the changes.
  • Importing/Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
  • Involved in export and import at schema level.
  • Created Object Types in PL/SQL.
  • Performed customization on existing Forms appearance, validation logic, and behavior and incorporating new functionalities for control purpose.
  • Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.

Environment: Oracle 9i, Sun Solaris 2.5, Server Manager, SQL* Plus, SQL*Loader and Developer 2000.

Hire Now