We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Anna Arbor, MI

SUMMARY:

  • Working as an Oracle Database developer with 5+ years of experience in the Healthcare, and Financing, Industrial Control System, Dashboard Application for Corporate Information Security and Supply Chain Industry.
  • Good Hands on database developer with a strong technical background with Oracle databases. Have well experience for Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Experience in Medicaid Management Information System with Managed Care and Eligibility.
  • Experience on working and designing Physical/Logical data models during initial phase of project blueprint.
  • Have good Experience with the use of Table Functions, Indexes, Table Partitioning, Collections, and Analytical functions, and Materialized Views, Query Re - Write and Transportable table spaces. Expertise in Dynamic SQL, Collections and Exception handling.
  • Knowledge with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Extensive experience in ETL processes and data migration with data warehousing, mergers and acquisitions and integration from external suppliers.
  • Develop and Deploy objects of Production quality with Change Requests.
  • Strong experience on various programming techniques, BULK COLLECT with FOR ALL, User defined exceptions, MERGE, Global temporary tables.
  • Hands on experience on various database utilities like SYS CONTEXT, LISTAGG, PIVOT, UNPIVOT, DBMS UTILITY, DBMS SCHEDULER.
  • Good in team leading skills including assigning and coordinating the work with offshore teams and on shore peers.

TECHNICAL SKILLS:

Operating Systems: Oracle 11g/9i/10g, UNIX, AIX, Linux, Microsoft Windows NT/2007/XP

Tools: Oracle 11g, 10g new features, C, C++, Java, Java Script, HTML, Visual Basic, Workflow Builder, Application Object Library, Confidential, Shell scripting, cron jobs, Autosys, SharePoint, CVS, Informatica Power center 9.5

Database Applications: Oracle 9i, 10g; iSQL, SQL*Loader, SQL*Plus, PL/SQL new enhancements, Stored Procedures, SQL Developer, Triggers, new and improved data types from 10g, R2 DML Error Logging

PROFESSIONAL EXPERIENCE:

Confidential, Anna Arbor, MI

Oracle PL/SQL Developer

Responsibilities:

  • Develop and manage multiple schemas that represent each layer of Confidential, TST/SIT and Production. Maintained moderate to complex PL/SQL applications including - performance tuning with indexing, native compilation, bulk loads etc.
  • Worked on Source database is Oracle 11g, staging database is 11g. The staging database is hosted inside the Confidential environment.
  • Worked on Oracle database, that has multiple schemas that represent each layer of Confidential, TST/SIT and Prod and Developed ETL Code for producing Extract.
  • Good hands on Medicaid Claims like Provider, Enroll, Pharmacy, Managed Care and Eligibility.
  • Created a convert procedure to create convert file using oracle UTL FILE utility.
  • Worked on Extract for the Confidential has been created on the unix file system to validate the file.
  • Worked on Source to Target Physical Mapping; while loading the data from Source through Oracle, it got formatting the data in the procedure and view while creating the final extract file.
  • Worked on Procedure, Package, Function and good hands on External table, Temp Table and Materialized view and Worked on Provider Data management.
  • Worked and Have good experience with creating Stored Procedures, Views to Pulling the Data.
  • Have good hands on the managing Cursor, Joints and Ansijoints.
  • With data conversion, develop various Oracle 11g Applications using 11g's new enhancements to PL/SQL, ISO/ANSI iSQL, SQL, new and improved data types.
  • Generate Files and Unit Testing of files Using PUTTY and Worked in ETL Error logging and Handle Various Error Tables, Good hands on debugging on various error concepts.
  • Develop and manage moderate to complex PL/SQL applications including - performance tuning with indexing, native compilation; Highly Complex Procedures, Triggers, Materialized Views; Bulk Collects, Bulk loads etc.,
  • Train and manage developers, advising other groups in organization on Oracle development, data warehouse development, SQL Development and ETL development best practices.
  • SharePoint; Conduct code walkthroughs and review peer code and documentation.
  • Created systems for capturing, reporting, and correcting error data.
  • Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
  • Coordinate with business; Gather requirements and design data warehouse and data mart entities.
  • Used SharePoint to view the business requirement from the client.
  • Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance for Data load using SQL Developer and good hands on ETL Batch processing.
  • Provided on call support to resolve any issues of file arrivals, bug fixes, and human errors in the production systems.

Environment: & Tools: Oracle11g, TOAD, PUTTY, Shell script, SharePoint, SQL Developer.

Confidential, Raleigh, NC

PL SQL Developer / Informatica Developer

Responsibilities:

  • Successfully integrated numerous data sources to a central platform to streamline various logging systems.
  • Used PL/SQL to validate data and to populate billing tables and Developed Installation scripts for all the deliverables.
  • Involved in SDLC gathering requirements from end users and Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database.
  • Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
  • Performed functional testing for the procedures and packages.
  • Written validation packages using PL/SQL package, used advanced Bulk techniques to improve performance.
  • Developed Database Triggers for audit and validation purpose and used pipelined functions for faster data accessibility.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Worked on Informatica Power Center client tools - Mapping designer, Workflow Manager, Workflow monitor, Repository manager, Mapplet designer and Transformations.
  • Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Created systems for capturing, reporting, and correcting error data and Created and manipulated stored procedures, functions, packages and triggers using TOAD.
  • Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
  • Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
  • Optimized queries using SQL Profiler and Database engine tuning advisor on BI development.
  • Involved in migrating database from oracle 9i to 10g database.

Environment: & Tools: Flat files, Oracle 10g/9i RAC, SQL*Loader, Putty, Erwin 4.0, Toad, Tivoli, Unix scripting, Win SCP Oracle 10g, 11g, Java and XML, Java using JDBC, C/C++ using OCI. UNIX (Solaris), Informatica Power center 8.5.

Confidential

Oracle & PL SQL Developer

Responsibilities:

  • Wrote JOIN Queries to retrieve the data to support the Appeals of the State, harmonized complex tables of data to enhance the Quality and Utility of the business data.
  • Design, modify and update database tables, setting up indexes, data constraints, database views, and referential integrity.
  • Define and develop technical specifications for the automation of the Billing file which is to be sent to the finance team to bill the clients.
  • Attended each KT session to understand the already existing database and the system.
  • Attended all the Shadowing and reverse shadowing sessions and documented everything to upload in the SharePoint.
  • Develop the Confidential and Shell scripts to automate the finance billing file, Write SQL codes to modify business rules to validate and load on database.
  • Translated business requirements and software design specification into Oracle Forms application.
  • Understanding the existing business application, reviewing and analyzing the project requirements.
  • Supported the QA team by writing queries for testing in the IST and UAT environment.
  • Actively involved in the completion of the System Design Document for Account Transfer and is one of the authors.
  • Create CTL files and UNIX shell scripts to read, move and processed data files. Use multiple different ftp servers for file delivery and receipt.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables and worked in Data harmonization to enhance the Quality and Utility of business data.
  • Parameterized the mappings and increased the re-usability, Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
  • Created procedures to truncate data in the target before the session run.
  • Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
  • Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
  • Develop the pre-processor and post-processor scripts in Confidential for the Mercer Funds files to create the index files for the incoming zip files and to update corresponding database instance tables during the post ingestion process
  • Extensively used Informatica debugger to figure out the problems in mapping. Also, involved in troubleshooting existing ETL bugs, created a list of the inconsistencies in the data load on the client side to review and correct the issues on their side.
  • Created the ETL exception reports and validation reports after the data is loaded into the warehouse database and written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Create and maintain scripts with SQL loader to perform data loads for multiple DB instances.
  • Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures, Played role in design of scalable, reusable, and low maintenance ETL templates.
  • Extensively done the data analysis using SQL, PL/SQL and many other queries based on the applications.
  • Added some features for compliance with and maintenance of quality standards in the data load process.

Environment: & Tools: Oracle 10g/11g, SQL developer, PL/SQL developer, Oracle Forms, TOAD, SharePoint, QA, IST and UAT, PUTTY, Shell script, HP Quality Center, Erwin.

Hire Now