We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Chicago, IL

Professional Summary:

  • Over 8 years of IT experience in Analysis, Design, Modeling, Development, Testing and Implementation of Data Warehousing Business Applications.
  • Excellent skills in designing and development of applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL good knowledge on Oracle tools like SQL*PLUS, PL/SQL, SQL, T-SQL scripts , and used TOAD in many development projects.
  • In depth Knowledge and experience of Data Warehouse/Data Mart design and implantation concepts.
  • Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.
  • Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
  • Experience in Bulk Data loading using Oracle utilities namely SQL*Loader, External Tables, working on both OLTP and OLAP databases and creating performance benchmarks and generating SQL*Plus reports.
  • Extensive experience in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized View, DBMS packages and exception handling, Global Temporary tables and Troubleshooting Oracle database issues.
  • Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader, UTL File Utilities and worked on External Tables and Transportable table spaces.
  • Good knowledge of Data Modeling using ETL tools, OLAP and OLTP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
  • Excellent in developing reports using Cognos Tool.
  • In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL and PL/SQL using database tools like Toad, SQL Navigator.
  • Profound knowledge in UNIX shell scripting of files and process manipulation.
  • Proficient knowledge of PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections and creation of database objects like tables, views, synonyms, sequences, Indexes, Triggers, Table partitions, Sub-partitioning, Database links etc.
  • Refined database reports to extract selected data useful for creating training monitoring plan.
  • Experience in creating ETL transformations and jobs using Pentaho and Pentaho Data Integration Designer and scheduling them on Pentaho
  • Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.

Business/Technical Skill:

Dimensional Data Modeling, Star and Snow-Flake Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin, TOAD, SQL Navigator, Oracle 11g/10g/9i/8i, SQL Server, Sybase, SQL, PL/SQL, UNIX Shell Scripting, Windows XP/2003/2000/NT/98/95, UNIX, Control M, AutoSys, ETL (Pentaho).

Projects Summary:

Confidential, Chicago IL.

Oracle PL/SQL Developer

Confidential is a French banking and financial services company that is split into three main divisions: Retail Banking, Corporate and Investment Banking (Derivatives, Structured Finance and Euro Capital Markets) and Global Investment Management and Services. The project is about maintaining client and securities data across 3 schemas’s like staging, history and prime and provide reporting in terms of positions balances, activity and transactions that are carried out by prime clients. The application has a real time reporting interface which is supported by an Oracle database. The database receives start of day feeds from the upstream systems like clearing and execution teams and processes the data to the staging tables. The prime and historical tables provide T-1 and 18 month period reporting functionality.

Responsibilities:

  • Ensure conformance to code standards and documentation requirements. Used Dynamic SQL programming technique to build and process SQL statements.
  • Creation of database objects like Tables, Indexes, Views, Stored Procedures, Functions, Triggers, and Synonyms.
  • Used TOAD, PL/SQL developer tools for faster application development.
  • Constructed standard and materialized views for viewing and extracting usable data from various sources to get a clear real-time view of business-critical information
  • Extensively involved in developing PL/SQL packages that includes advanced PL/SQL concepts like REF CURSOR, BULK COLLECTS, for all, etc.
  • Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data form staging tables into base tables.
  • Performed exception handling and analyzed table structures and integrity constraints for report-creation strategies.
  • Production support for data fixes and debugging aborted processes.
  • Extensively involved in Oracle query (SQL) tuning, PL/SQL execution optimization, Explain Plan, SQL Trace, tipoff, Stats Pack and SQL*PLUS Auto trace.
  • Performed functional testing for the procedures and packages.
  • Extensive use of UC4 in windows environment for scheduling routine tasks.

Environment: Oracle 11g, PL/SQL, TOAD, PL/SQL Developer, SQL*Loader, Windows, SQL*PLUS, Windows XP/07, MS Excel, Solaris, SQL Navigator, UC4.

Confidential, Pennsylvania.

Oracle PL/SQL Developer

Confidential is a multi-line insurance company, offering auto, home, commercial and life insurance through a network of independent insurance agents. The project aim is to manage claim management system into the transactional database by loading the flat files to the Oracle Server using advanced PL/SQL techniques and to generate Crystal reports as per the Business Requirement.

Responsibilities:

  • Worked with the Business Analysts and Users in understanding the business requirements for the project.
  • Participated in different phases of a project analysis phase, preparing the technical specification, development and testing.
  • Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
  • Created database objects like tables, views, procedures, packages, and cursor using TOAD.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Handled Exception extensively for the ease of debugging and displaying the error messages in the application.
  • Interacted with Business Users in creating Unit and System Testing for new development application.
  • Application support in resolving production problems for existing application and ensure all issues get resolved accordingly.
  • Delivered tasks accurately in time provided.
  • Extensive use of Control M in windows environment for scheduling routine tasks.
  • Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic SQL.
  • Developed Oracle partitions, and performance tuning/query tuning.
  • Experience in creating ETL transformations and jobs using Pentaho and
    Pentaho Data Integration Designer and scheduling them on Pentaho.

Environment: Oracle 11g (SQL*PLUS), Java J2EE, External Table, UNIX, PL/SQL Developer, Toad, SQL/Plus, MS Office, Windows XP/07, Erwin r8, Crystal 6, MS Visio, ETL (Pentaho), Control M, Linux, SQL, PL/SQL.

Confidential, Manhattan, NY

Oracle developer

Blackrock is one of the world's preeminent asset management firms and a premier provider of investment management, risk management and advisory services to institutional, intermediary and individual investors around the world. The project was responsible for integrating data from various source systems, Data Conversions, Batch process and to develop solutions leveraging data integration techniques against database.

Responsibilities:

  • Worked with Oracle database consisted of more than 50GB sized tables.
  • Extensively used EXPLAIN PLAN and TKPROF for SQL tuning.
  • Tuned approximately 100 complex SQL queries.
  • Used Optimizer HINT for tuning SQL and Advanced PL/SQL.
  • Generated the trace files for more than 40 batch jobs to find the optimal queries.
  • Tuned auto generated SQL - created INDEX based on the requirement of the table.
  • Worked with DBMS PROFILER to tune PL/SQL Procedures.
  • Created log on trigger and new user to run batch jobs for collecting the trace files.
  • Used cursor, ref cursor, bulk collect and bulk insert (Bulk Binding) in procedure to reduce its execution time.
  • Created packages and stored procedures for data conversion by using DBMS RANDOM package
  • Worked with DBMS SCHEDULER to schedule jobs.
  • Created Materialized Views to reduce the network load.
  • Extensively used TOAD for tuning, for database monitoring.
  • Created UNIX shell scripts for regular tasks and used UNIX commands as per needed.
  • Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
  • Optimize existing T-SQL code.
  • Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
  • PARTITION 4 to 5 tables (size of those tables are more than 100GB) to manage database and to improve the performance.
  • Experienced in using AutoSys tool to set up scheduled jobs within a Windows environment that run Oracle PL/SQL.
  • Experience in creating ETL transformations and jobs using Pentaho and
    Pentaho Data Integration Designer and scheduling them on Pentaho.

Environment: Oracle 11g, Oracle SQL Developer, SMS Office (Excel, Word), TOAD, SQL*Loader, FTP, Windows XP, AutoSys, Linux, Pentaho, SQL.

Confidential, Jacksonville, FL

Oracle Developer

Confidential is a leading provider of title insurance, mortgage services and diversified services. FNF is the nation's largest title insurance company through its title insurance underwriters that collectively issue more title insurance policies than any other title company in the United States. The projects cover up across various elements of the Health Insurance namely treatment billing records and Medicare Supplement.

Responsibilities:

  • Involved in gathering Business Requirements and implementing the Conversion and Implementation of Software Development Life Cycle (SDLC).
  • Responsible for creating and maintaining the stored procedures, Function, Packages and Triggers.
  • Interacted with the business users on a regular basis to collect business requirements and specifications.
  • Provided Security for the Oracle database objects.
  • Created database objects such as tables, views, synonyms, indexes, clusters,
  • Sequences and database link as per business requirements.
  • Involved Database Administration of database objects, including tables, clusters, Indexes, views, sequences, packages and procedures Troubleshoots with regards to database problems and QA defects.
  • Maintaining the Database changes according to the client’s requirements.
  • Tested new enhancements and bug fixes before deployment into the production Environment.
  • Worked as part of a team to launch new releases under strict time deadlines.
  • Developed Control files using SQL*Loader to perform bulk data loads into database Tables from external data files.
  • Generated Dashboards by joining multiple complex tables.
  • Developed various dashboards, used context filters, sets while dealing with huge volume of data.

Environment: Oracle 10g, Oracle SQL Developer, SMS Office (Excel, Word), TOAD, SQL*Loader, FTP, Windows XP.BI Software/ Programming languages Tableau, T-SQL.

Confidential

Oracle PL/SQL Developer

Confidential is a provider of deposit loans, retail loans, credit cards and debit cards. The Company operates in four segments: Treasury, Corporate / Wholesale Banking, Retail Banking and Other Banking Operations.

Responsibilities:

  • Monitored Usage Processing of Billing System.
  • Extensively Performed back end database development tasks such as PL/SQL, Trigger, SQL Queries, Functions and Packages.
  • Involved in performance tuning and monitoring, tuned SQL queries using Explain plan.
  • Added hints, indexes and parallel processing techniques for the queries.
  • Created SQL to delete the duplicate values from the datable table.
  • Extensively used UNIX commands as per requirement.
  • Used DDL statements to create new database objects like tables, views, sequences, functions, synonyms, roles and granting privileges by incorporating business standards

Environment: ORACLE 9i, TOAD, UNIX, C#, Windows NT, SQL

Hire Now