Sr. Oracle Developer Resume
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