We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

El Segundo, CA

SUMMARY

  • 7 years of experience as Confidential Software development consultant with expertise in working with database development projects.
  • Expert in writing complex queries in Confidential SQL, developing PL/SQL stored procedures, functions and packages.
  • Expert in developing reports, exports, imports and interfaces using Confidential PL/SQL.
  • Expert in designing and deploying partitioned tables and indexes to improve data retrieval performance.
  • Experienced in Coding PL/SQL subprograms to develop exports, imports, batches and reports.
  • Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
  • Involved in the creation and testing of database objects like tables, views, stored procedures, functions, packages, triggers, Indexes, and Collections based on project modules requirements.
  • Extensively worked on QUEST Tools (TOAD) and PLSQL Developer.
  • Hands on Experience in Unix Shell Scripting.
  • Reviewed Business requirements, Technical specification and preparing Test Plans and Test Strategies.
  • Worked on Informatica as ETL tool to load data to Hyperion database.
  • Prepared technical documents and Unit Test Cases.
  • Experienced in running data loads for Hyperion Load Process on a daily basis and supporting Hyperion Essbase w.r. Confidential different databases and maintenance of it on a regular basis as per the changes.
  • Effort Estimation & Prepare high level design document of new client requirement.
  • Developed back end code to generate reports as per client requirements.
  • Worked to resolve the implementation performance issues to improve the performance of reports.
  • Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
  • Good experience in development, testing, implementation of ODI, OBIA and experience in developing OBIEE Reports. (Migrated Excel reports to OBIEE).
  • Extensively worked on Database Conversion, Archiving, ETL and Data warehousing projects.
  • Worked on DBMS MVIEW, DBMS JOBS, DBMS SCHEDULER, DBMS DDL, and UTL FILE Confidential Server supplied packages in PL/SQL blocks.
  • Good knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
  • Excellent planning, analytical, written Communication and Interpersonal skills.
  • Involved in Development, Testing, Implementation, Migration & Support projects in Confidential BI.
  • Hands on Experience knowledge modules like RKM LKM, IKM, CKM, JKM.
  • Good understanding of ODI studio components like Designer, Topology, Operator and Security Navigators.
  • Experience in developing ODI interfaces/Mappings, packages, procedures, sequences and scenarios, Load Plans.
  • Creating and customizing OBIEE reports and developing dashboards, promps, filters, variables.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

TECHNICAL SKILLS

DBMS: Confidential 12c, 11g, 10g, SQL Server

Database Tools: TOAD, PL/SQL developer, SQL developer

Languages: SQL, PL/SQL.

Reporting Tools: OBIEE11g

Operating Systems: Windows, Linux.

ETL Tools: ODI 11g, Informatica.

OBIA: BI Apps 11.1.1.9.1 , BI Apps 11.1.1.10.1

PROFESSIONAL EXPERIENCE

PL/SQL Developer

Confidential, El Segundo, CA

Responsibilities:

  • Handled multiple Conversion Projects and interacted with SQA team from offshore on daily basis.
  • Worked on different conversion batches ( R1 to R6 ) on Multi Dwelling Unit (MDU) project.
  • Worked on various Data Sets based on business requirements.
  • Designed and developed Confidential PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
  • Experienced in performance tuning and optimization, using troubleshooting tools and techniques including complex queries as well as procedure and indexing strategies.
  • Experienced in using AutoSys tool to set up scheduled jobs within a Windows environment that run Confidential PL/SQL.
  • Worked on JIL files for deployment and running ETL jobs of all shell scripts in Autosys and interacting with Performance Testing team.
  • Worked on Database Links to Access data from remote Database.
  • Involved in coding, debugging and testing as well as performance tuning of SQL Queries.
  • Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
  • Experienced in developing project estimates, plans, schedules and budjets.
  • Experienced in Developing standards and procedures affecting database management, design and maintenance, data dictionaries and documentation across multiple computing environments.
  • Worked on TDP and SDR tickets and interacted with DBA team until the issue is resolved.
  • Worked on file validations and reported data issues to SQA team to resolve the data issues.
  • Worked Closely with DBA team and Performance Testing team during Database and Performance issues
  • Worked on Release implementation plan and post implementation validation for database and unix objects to check if all the objects are deployed in the SQA environment.

Technical Consultant

Confidential

Responsibilities:

  • Analyze the Service Center and AskIT tickets raised by business and implement the best suitable solution.
  • Convert mindjogger reports developed in perl into PL/SQL and schedule them using dbms scheduler.
  • Employ UTL SMTP Confidential utility to send out emails with attachments.
  • Improve performance of Advisory workbench reports by evaluating the best possible alternative sql suggestions from SQL Optimizer.
  • Perform periodic Password Rotation activity on Confidential Applications 11i.
  • Review daily Database Health Check reports to look for any impending issues, errors in the alert log and implement the necessary corrective action.
  • Responsible for preparing technical design documents.
  • Create and schedule jobs and chain jobs using DBMS SCHEDULER Confidential supplied package.
  • Writing complex reporting queries in Confidential SQL.
  • Coding Confidential stored subprograms like Views,functions, procedures, packages, triggers.
  • Coding PL/SQL subprograms to develop exports, imports, batches and reports.
  • Employ DBMS MVIEW in order to create and manage materialized views, DBMS JOBS to create and manage Confidential jobs, DBMS SCHEDULER to schedule jobs Confidential various timings, DBMS DDL to work on database objects definitions and UTL FILE (convert data from database into flat files) Confidential Server supplied packages.
  • Using SQL*Loader to move data from flat files into database and sql copy to move data from one database to another. Employ UTL FILE utilities to write data from database into flat files.
  • Developing new code components for new implementations.
  • Bug fix as part of maintenance releases.
  • Involved in interaction with the End Users and implemented reviews of the application.
  • Involved in PL/SQL coding, Designing and Deployment of Reports.
  • Involved in the creation and testing of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes, and Collections.
  • Developed Functions & Procedures for Extracting data from different tables using Joins and inserted them into a Table.
  • Involved in coding, debugging and testing as well as performance tuning of SQL Queries.
  • Running data loads for Hyperion Load Process on a daily basis and supporting Hyperion Essbase w.r. Confidential different databases and maintenance of it on a regular basis as per the changes.
  • Took Level0 backup of the data and updated sub - variables in essbase on monthly and quarterly basis.
  • Used Informatica as ETL tool to load data to Hyperion database and experience in checking the error logs of all the workflows and running the workflows accordingly.
  • Updated Calculation scripts,and modifying informatica workflows and formulas of members as per the requirement.
  • Hands on Experience knowledge modules like RKM LKM, IKM, CKM, JKM.
  • Good understanding of ODI studio components like Designer, Topology, Operator and Security Navigators.
  • Good understanding of the architecture of ODI and running ODI in different environments.
  • Created several reverse engineering models as per the requirement.
  • Experience in developing ODI interfaces/Mappings, packages, procedures, sequences and scenarios, Load Plans.
  • Strong Knowledge in debugging the ODI interfaces/Mappings.
  • Developed several Interfaces/Mappings with transformation logics like, filters, joins, lookups, Confidential functions etc.
  • Developed Interfaces/Mappings to union multiple tables of the same structure using data sets.
  • Developed Customized knowledge modules as per requirements.
  • Developed interfaces for incremental update and full load loading.
  • Created and customized OBIEE reports, dashboard pages.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

Hire Now