We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume

0/5 (Submit Your Rating)

San Jose, CA

SUMMARY:

  • 14+ years of IT experience mainly in Analysis, Design, Application Development, Data Warehousing, Datamart, Data Analysis, testing, implementation and documentation using Oracle technologies.
  • Highly skilled in Client - Server application development using Oracle 12c/11g/10g/9i/8i Sql Plus, SQL, PL/SQL. Worked extensively in developing Packages, Stored Procedures, Functions, Cursors and Triggers, Indexes, Materialize Views, Snapshots, Dynamic SQL, PL/SQL Collections, Oracle XML, Partitioning, Exception handling etc. for applications and reporting tools. Expertise in PL/SQL coding, Unix Shell Scripting and Data Migrations
  • Well versed in Oracle RDBMS design, advanced Oracle features such as Oracle XML, Indexing, Collections, Dynamic SQL, job schedulers and other Oracle features. Proficient in Oracle tools and utilities such as SQL*Loader, Import/ Export, Toad, SQL Developer. Experience with other tools like Kintana, QC, Jira, Squish, Remedy etc.
  • Conversion of Hadoop/Scala queries to Oracle Queries
  • Extensive experience in Performance tuning of and Optimization
  • Worked in Oracle Apps AR and GL Modules
  • Expertise in data modeling, schema design, ETL, data loading, data retrieval, data mappings, Data analysis, Data validations, Data massaging, archival techniques and data migrations.
  • Experience in Data Migration Utilities. Extraction of XML to data.
  • Expertise on Datamart projects, home grown ETL mechanisms and Informatica
  • Experience on working with Oracle Forms and Reports.
  • Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and testing implementation and production support.
  • Good understanding of software standards such as CMM Quality procedures and QMS
  • Strong technical and analytical and problem solving skills, able to take full ownership. Self-motivation, Good organizational and time management abilities.
  • Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena. Documentation Savvy and Dedicated to data integrity.
  • Worked with high profile clients like Cisco (5+ years), Confidential, Google, Confidential, Confidential, GE, Confidential, Confidential, World Bank (5 years), Ford Motors, and Confidential Communications etc.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i/8i/7.x

Operating Systems: Windows 10/7/XP/NT/2000/98/95, Linux/Unix, MAC

Languages: Oracle PL/SQL, SQL

ERP: Oracle EBS R12 - AR & GL Modules

Tools: TOAD, Rally, Tableau, QC, Kintana, PVCS/CVS, Perforce, Sql Developer, SQL Navigator, Eclipse, Informatica, SQL Lab, JIRA, Remedy, IMPACT, Squish, Autosys, HPSM, Forms 9i/6i/4.5.3, Reports 6i/3/2.5. HP PPM

PROFESSIONAL EXPERIENCE:

Confidential, San Jose CA

Responsibilities:

  • As Sr. Oracle Developer prepared TSDs, responsible for Development, Enhancements, Modification of Application code, data cleansing using Oracle Packages, Procedures, etc.,
  • Performance tuning and Optimization of queries and fixing bugs
  • Creating packages, procedures as part of enhancements to the current applications.
  • Converting queries written in Hadoop/Scala to Oracle
  • Perform QA, application release to various environments through Agile / ERMO Processes.
  • Create, schedule and monitor jobs using APP DB Tool for daily incremental loads
  • Interaction with various stake holders like PMO, Infra, QA, DBA, Business, Golden Gate teams etc.

Environment: Oracle 12c (PL/SQL), Windows, Linux, SQL Developer, Toad, APP DB, Rally

Confidential, Mountain View CA

Responsibilities:

  • As Sr. Oracle Developer responsible to prepare TSDs, Development, Enhancements, Modification of Application code using Oracle Packages, Procedures, Collections, Views etc.,
  • Development of New Programs and Reports in GL module for Germany GDPDU.
  • Fix issues/ bugs in Virtual trader which is used as ICO transfers in GL module.
  • In AR module develop process and packages for manual upload of Credit/Debit Memos.
  • Performance tuning and Optimization of various queries, fixing bugs in existing application and jobs
  • Perform QA, application release to various environments
  • Create Shell scripts and jobs, upload data using SQL Loader
  • Interaction with various stake holders like PMO, Infra, QA, DBA, Business, offshore teams etc.

Environment: Oracle 12c (PL/SQL), EBSR12, Windows, Linux, SQL Developer, Toad, SQL Loader

Confidential, San Jose

Responsibilities:

  • As Sr. Oracle Developer / Analyst, responsible to prepare TSDs, Development, Enhancements, Modification of Application code using Oracle Packages, Procedures, Collections, Views etc.,
  • Performance tuning and Optimization of various queries, fixing bugs in existing application and jobs
  • Support the Release process
  • Interaction with various stake holders like QA, DBA, Business, offshore teams etc.

Environment: Oracle 12c (PL/SQL), Windows, Unix/Linux, SQL Developer, Toad, Ubiquity, HP PPM

Confidential, San Jose

Responsibilities:

  • As Sr. Developer / Analyst, responsible to prepare TSDs based on FSDs provided by BSA’s
  • Development, Enhancements, Modification of application code using Oracle Packages, Procedures, Collections, Views etc.,
  • Performance tuning and Optimization of various SQL’s which are significant bottle necks.
  • Fixing of various bugs in existing application and jobs
  • Interaction with various stake holders like BSAs, Foundry Management Team, QA teams, offshore team etc.

Environment: Oracle 11g (PL/SQL), Windows, Unix/Linux, SQL Developer, Toad

Confidential, San Jose

Responsibilities:

  • As Sr. Systems Analyst / Sr. Developer, responsible to prepare technical design documents based on FSD,
  • Development of new application code using Oracle procedures, packages, views, etc.,
  • Fine tuning and Optimization of various SQL’s in the application.
  • Fixing of various bugs and code drop to Production using the ERMO process
  • Preparing various metrics docs and interaction with PMO team.
  • Interaction with various stake holders like Business Analysts, Infra teams, QA teams, offshore team etc.

Environment: Oracle 11g (PL/SQL), Toad, Windows, Unix/Linux, Kintana, PVCS, SVN, Tortoise

Confidential, Seattle WA

Responsibilities:

  • As Sr. Developer / Sr. Systems Analyst, responsible to prepare technical design documents,
  • Development of new application code like views, procedures, packages and Shell Scripting etc.
  • Fine tuning and Optimization of various SQL’s in the current application.
  • Fixing of various bugs in the existing systems and rolling to production
  • Interaction with multiple stake holders like Business, QA, Infra, DBA teams etc.
  • Offshore team coordination.

Environment: Oracle 11g (PL/SQL), Toad, Windows 8/Unix

Confidential, CT

Responsibilities:

  • As Sr. Developer / Sr. Systems Analyst, responsible to prepare technical design documents,
  • Development of new application code like views, procedures, packages and other Oracle Objects and Shell Scripting etc.
  • Fine tuning and Optimization of various SQL’s in the current application.
  • Fixing of various bugs in the existing systems and rolling to production
  • Production support.
  • Interaction with multiple stake holders like Business, QA, Infra, DBA teams and ERMO teams.
  • Co-ordination with offshore team.

Environment: Oracle 10g (PL/SQL), Toad, Windows 8/LINUX

Confidential, San Jose CA

Responsibilities:

  • As a Sr. Systems Analyst/ Sr. Developer responsible to prepare technical design documents and development of application code, deployment.
  • Optimization and fine tuning of various SQL’s
  • Development of application code like views, procedures, packages, Triggers and other Oracle Objects and Shell Scripts for Jobs and host files.
  • Interaction and coordination with various stakeholders, offshore team, QA team, and Support teams.
  • Post production Support

Environment: Oracle 10g (PL/SQL), Toad, Windows 8/LINUX, Kintana, PVCS

Confidential, San Jose CA

Responsibilities:

  • As Sr. Developer/ Sr. Systems Analyst, responsible for development, migration, testing, bug fixes, deployment
  • SQL fine tuning/optimization of various SQL’s in the current modules
  • Preparation of migration scripts, testing in different test cycles, QA, and product ionization.
  • Fixing of issues identified and streamlining the migration process.
  • Interaction with business stake holders, QA teams and Support teams.

Environment: Oracle 9i, 11g (PL/SQL), Toad, Windows XP/UNIX

Confidential, San Jose CA

Responsibilities:

  • As a Sr. systems Analyst/ Developer responsible to Prepare technical & Design specs/documents and development,
  • Lead the team and interact with various stakeholders
  • Development of code using the Oracle Pl/Sql
  • Optimization and fine tuning of various SQL’s
  • Interaction with offshore team.

Environment: Oracle 10g (PL/SQL), Toad, Windows XP/UNIX, Kintana

Confidential, San Jose CA

Responsibilities:

  • As a Senior developer/ data Analyst and Team lead, responsible to prepare technical & Design specs/documents, coding, Data assessment, data quality analysis, source-to-target mappings for data migration and integration, and testing, implementation
  • Prepare Proof of concept for Custom data catch-up scripts, Optimization and fine tuning of various SQL’s
  • Lead the team and interact with various stakeholders
  • Development of application code like views, procedures, packages, Triggers and other Oracle Objects and Shell Scripts for Cron Jobs.

Environment: Oracle 10g (PL/SQL), Toad, Windows XP/UNIX, Kintana

Confidential, Cupertino CA

Responsibilities:

  • Prepare technical and design documents and development and testing, interaction with various stake holders.
  • Identify and fine tune the SQL’s / Queries for improvement in the performance of the application and optimization, Analyze the Daily AWR Reports
  • Partition the tables, Development of new Archival and Purge process
  • Developed Shell scripts to run new batch jobs for archive and purge process, for Autosys jobs
  • Interaction with offshore team, Deployment of changes to Production and support

Environment: Oracle 10g (PL/SQL), SQL*PLUS, SQL Developer, Mac/UNIX, Autosys, SVN, Eclipse, JBoss, Cocoa Client, Shell Scripts

Confidential, San Ramon, CA

Responsibilities:

  • Data analysis, data quality analysis, source-to-target mappings from existing IPS application to new IMPACT application for data migration and integration, and testing
  • Preparing technical, functional and design documents, Development and testing and implementation.
  • Interacting with various business and stake holders users for preparation of specifications.
  • Development of application code like views, procedures, packages, Triggers and other Oracle Objects and Shell Scripts for Cron Jobs.
  • Preparing Gap Analysis documents to identify the gaps between the existing application and new IMPACT ®Tool in data mappings while identifying source and target data mappings.
  • Preparing on impact Analysis Documents by analyzing the existing system and the new IMPACT system

Environment: Oracle 10g (PL/SQL), Toad, IMPACT®, Windows XP/UNIX, Oracle RAC Cluster, eRoom (document Management system), SQL Navigator, Shell Scripts

Confidential, Washington DC

Responsibilities:

  • Handling end to end activities of the projects, prepare technical, functional and design documents, coding, testing, implementation. Identifying the Core Meta Data for Multilingual conversion, coordinating with Translation teams for multilingual translation
  • Data assessment, data quality analysis, source-to-target mappings for data migration and integration, and testing, implementation
  • Coding using PL/SQL, Oracle XML, testing and production support
  • Design of the multilingual Data handling mechanisms, procedures, packages, jobs, shell scripts without disturbing the existing English versions.
  • Designing and development, testing, deployment of the applications to in corporate multilingual features.
  • Conversion of existing modules to Multilingual languages such as French, Spanish, Arabic, Russian and Chinese
  • Enhancements of existing applications like Operations Projects, ED (Executive Director’s) Module, Client Connections, People Pages, Primadat,External Projects with new requirements parallel working on multilingual application development.
  • Responsible for day to day support activities to meet adhoc requests of Users.
  • Migration of databases to Oracle 10g RAC environment from Oracle 9i, includes two major databases with multiple internal and external applications, coordinating with various stake holders, preparing the schedules, planning the migration, preparing necessary validation scripts, preparing the Delta Scripts, Rollback plans and scripts,
  • Development of Home grown ETL Data harvesting procedures/mechanisms, data massaging from various systems like SAP, PeopleSoft and Sybase and other Oracle DB’s.
  • Monitoring Informatica for the daily runs and modifying /creating new worklets, workflows and other objects, bug fixes
  • Preparation of Migration scripts for Release Management.
  • Production Support, Offshore Co-ordination

Environment: Oracle 10g (PL/SQL), SQL*PLUS Toad, Informatica, SQL Lab, Jira, Remedy, CVS, Windows XP/ UNIX, Oracle RAC Cluster, Oracle XML, Eclipse, Shell Scripts

Confidential, Washington DC

Responsibilities:

  • Preparing technical, functional and design documents, coding of the applications using Pl/Sql, Oracle XML, testing, implementation and Production Support, with end to end responsibilities of the application .
  • Development of External Projects applications which handles Projects, Loans, borrowings, Lendings, based on Millennium Development Goals
  • Development of applications like Internal Projects Operations Applications, GDLNAMS, SWIMS (client Connections), RAPMAN, PRIMA using Oracle objects/ code.
  • Data assessment, data quality analysis, source-to-target mappings for data migration and integration, and testing, implementation
  • Development of Home grown ETL Data harvesting procedures/mechanisms, data massaging, staging of data from various systems like SAP, PeopleSoft and Sybase and other Oracle DB’s, applying business rules to the harvested data from above systems.
  • Monitoring Informatica for the daily runs and modifying /creating new worklets, workflows and other objects, data integrity, data quality and analysis.
  • Preparation of Migration scripts, Development, testing, Production move and Production Support
  • Interaction with stake holders, various teams, Co-ordination with offshore teams
  • Handled and resolved production data issues with less turnaround time and proposed solutions to avoid repetitive operational tasks

Environment: Oracle 10g (PL/SQL), Toad, Informatica, SQLLab, Jira, Remedy, CVS, Windows XP/ UNIX, Oracle RAC Cluster, Eclipse, Shell Scripts.

Confidential

Responsibilities:

  • Development of the application using Informatica, Oracle PL/SQL and preparing various documents
  • Development of People Pages Modules code using procedures, packages, triggers, Oracle XML, etc.
  • Testing and Implementation by following the defined and various processes.

Environment: Oracle 9i (PL/SQL), Forms 9i, Reports 9i, Toad,Jira, CVS, Windows 2000

Confidential, San Jose

Responsibilities:

  • Upgrading the Objects from Oracle Apps 11.0.3 to 11.5.8
  • Preparing impact analysis documentation, Modification of Packages, Views, Procedures, SQL etc.,

Environment: ERP: Oracle Apps 11.0.3/11.5.8, Oracle 8i (PL/SQL),Developer 2000 (Forms 6i, Reports 6i),Toad,SCCSWindows 2000

Confidential

Responsibilities:

  • Developing the user interfaces using Forms 6i, Reports 6i, Pl/Sql code using Procedures, Packages, triggers testing and Documentation.

Environment: Oracle 9i,Developer 2000,Toad, Windows NT, Persoft version Control#14. Project Name: QUEST/ POPS - (Port Operations) Phase II

Confidential

Responsibilities:

  • Developing the user interfaces using Forms 6 and Reports 6, f Packages, procedures and other oracle backend objects and Testing and Documentation, implementation

Environment: Oracle 8i (Pl/Sql),Developer 2000 (Forms 6i, Reports 6i), Toad, Windows NT

Confidential

Responsibilities:

  • Developing the user interfaces using Forms 6, Reports 6, Procedures, Packages and other Oracle Objects, testing, Documentation and implementation

Environment: Oracle 8i (PL/SQL),Developer 2000 (Forms 6i, Reports 6i),Toad, Windows NT

We'd love your feedback!