We provide IT Staff Augmentation Services!

Senior Oracle Consultant Resume

NY

PROFFESIONAL SUMMARY:

  • 10 years of experience in Oracle development, Analysis and Design.
  • Database administration and Web-based multitier application design.
  • Certified by Oracle in advanced PL/SQL development and can work independently.
  • 1.5 years of experience in Banking Domain (Investment Banking).
  • 5 years experience in Insurance Domain.
  • 3.5 years experience in Manufacturing Domain.
  • Experience in Agile development methodology and Waterfall model too.
  • Expert in Performance tuning and code optimization analyzing AWR/ADDM reports.
  • Proficient in writing Oracle PL/SQL code including procedures, packages, triggers, etc.
  • Experienced in using Oracle XML DB options to save and display data in XML formats.
  • Experience in UNIX shell scripting.
  • Proficient in RDBMS Concepts and Database modeling (Erwin tool).
  • Experience in all phases of SDLC, Business Requirement Gathering and Analysis, Application
  • design, Implementation, Testing, Maintenance. User training, Documentation of activities,
  • Processes.
  • Excellent communication, interpersonal and problem solving skills. Highly motivated with
  • strong commitment towards quality, customer service and Integrity with the company.
  • Interaction with business customers to understand the business case or problem area and
  • Providing solutions.
  • Process and DB design using Erwin and Rational Rose.
  • DB batch job creations and maintenance using tools like AppWorx and Autosys.

EXPERIENCE:

Confidential

Senior Oracle Consultant/Analyst

RESPONSIBILITIES:

  • Working as a Senior Oracle consultant and Designer.
  • Following Agile Software development model.
  • Designed and developed various business critical products like PFGx and Deal attribution.
  • Handling business critical production and UAT issues.
  • Database modeling for each and every new product or enhancement within Banker portal.
  • Developed Stored packages and procedures containing Dynamic sql implementation,
  • analytical functions and collections.
  • Using Oracle Change data capture utility for capturing each and every change in a Database.
  • Designing Procedures for Lucene search implementation in BP UI.
  • Expertise in Analytical, Pipelined and Aggregation Oracle functions.
  • Interaction with various external systems like SAP and Datamart.
  • Performance tuning of DB objects before releasing it to Production, enabling SQL trace sessions.
  • Maintaining all DB environments from Development to Production.
  • Supporting Business customers in real time with their daily DB dumps requirements and other
  • Problems.
  • Co-ordination with global development team, QA and Release management team.
  • Managing various security levels and respective privileges across BP applications.

Confidential

Project Lead /Senior Analyst

RESPONSIBILITIES:

  • Worked as project lead and an oracle administrator, leading a team of PL/SQL developers.
  • Designed and developed various business critical functionalities like Advance Booked to
  • Financial policy conversion, Earnings, Exposure period earnings, Coverage provided.
  • Developed Stored packages and procedures to calculate daily and monthly earnings of issued
  • policies and used various Record types and REF Cursors. This functionality had replaced the
  • system which used to take 32 days to process a policy.
  • Created Balance and control functions to reconcile various Policy transaction amounts and to
  • raise a flag to suspend processing.
  • Designed De-normalized SUPERSET table to keep transaction key information ready for nightly
  • Downstream batch processing which caters financial and revenue information to 55 downstream ystems.
  • Daily and monthly reconciliation scripts which has saved 80% of customers time on doing it
  • Performance tuned and optimized named queries for CLAIMS module which improved
  • Created tables using the compress option to free-up data blocks, utilized the
  • DBMS STATS.GATHER TABLE STATS procedure to gather statistics, created indexes, and
  • analyzed those objects for data mart Applications like CMI.
  • Also used XMLElement, XMLAttributes and XMLForest etc to generate XML data control
  • files from Database.
  • Coordination with Production DBA’s to get Prodcopies refreshed for development team.
  • Taken necessary steps to improve performance of monthly and long running feeds by using
  • UTL FILE package to extract data.
  • Maintaining Pipeline Code between all 5 environments and 18 different schema users.
  • Re-designed the PDR (Policy Data Retrieval) and NFB (Non Funded billing) services completely
  • Efficiently in PLSQL packages, collections, Nested tables which was earlier implemented i
  • Created DB links to communicate and access data from another traveler’s application called CSI.
  • Handled responsibilities in user security granting and revoking privileges and roles.
  • Maintaining OLTP database, batch-processing scripts, regression and smoke tests
  • and UAT of the applications.
  • Worked with Architects to redesign batch-processing mechanism for downstream feeds,
  • which had allowed customers to issue policy anytime during the business day.
  • Used database cloning to perform Weekly and monthly reporting activities to avoid bottlenecks
  • during transaction processing.
  • Created alert mechanism to send alert emails to application users in case of table space issues,
  • missing financials or if any missing transactions from the superset and staging tables..
  • Performed Optimization by analyzing execution plan using EXPLAIN PLAN, TKPROF utilities.
  • Debugging manually and via DBMS DEBUG package modules.
  • Working with modelers to keep every DB environment in sync with various model changes
  • across BI before every Production release.
  • Recovered business critical data in various situations using Flashback recovery option of oracle.
  • I have also contributed to the tasks like design and use case walk-through with client, Estimation
  • And Requirement gathering, Code Reviews, Co-ordination between onsite and Offshore

Confidential

Senior Oracle Developer/Analyst

RESPONSIBILITIES:

  • Analyzing business customer’s requirements and designing the logical and physical data models
  • Accordingly, using Erwin.
  • Designed relational database for EOS with 65 tables to accommodate all information required to
  • Writing PL/SQL stored procedures and functions to Access source files into Oracle.
  • Used Collection objects to store all engine parts and subparts into database.
  • Used Oracle XML DB options for generating XML data from the database.
  • Created ROW TO COL and COL TO ROW functionality.
  • Developed additional packages, Cursors which consisted of functions and procedures to validate
  • vendor, parts and subpart’s names, their types and price lists etc.
  • Used SQL*Loader to load Quotes and configuration data files to staging tables.
  • Executed Oracle advanced native dynamic SQL (NDS) while using collections such as
  • associative arrays, Varrays, and nested tables.
  • Used BULK COLLECT to optimize SQL statements for large tables.
  • Created Materialized views to keep daily reporting information optimized.
  • Generated various Statement level and Database level triggers to keep audit on various activities.
  • Developed EOS procedures and objects, Ref cursors that interact with Java modules to display
  • required information from Database.
  • Mentored a team of 12 oracle developers to support various applications within COLS initiative.

Confidential

Senior Oracle PLSQL Developer/Analyst

RESPONSIBILITIES:

  • Gathered requirements for the product.
  • Used various DBMS packages Nested table concepts to display engine configuration details for
  • managers, written Scripts to automate monitoring, data loading, tuning, and user auditing
  • Designed the DB for the applications using ER-Studio.
  • Created Oracle triggers and packages that included structured record types, table types, cursors
  • to meet PLE business requirements.
  • Performed technical and functional reviews to ensure all requirements were met with timely
  • delivery of high quality products
  • Developed some PL/SQL scripts, which will change the server data across all the components in
  • Developed triggers and PL/SQL procedures for automation of jobs scheduling.
  • Developed a tool 'Meta-Load' (to load bulk data) using PL/SQL.
  • Quality assurance
  • Prepared user manual and help document for the product using ROBO help.
  • Trained the team on domain and technology used.
  • Managed performance and tuning of SQL queries and fixed the slow running queries in
  • production with utilities like Explain plan, Trace, TKprof.
  • Prepared schema statistics, data preparation by import/export from external databases in Dev
  • and Quality control databases
  • AppWorx settings to automate daily DB jobs.

Confidential

Oracle PL/SQL Developer

RESPONSIBILITIES:

  • Developed various reporting procedures, which shows information using pagination.
  • Designed complex table Structure, which can handle CLOB and BLOB, fields to keep any type of
  • document attached by end users.
  • Developed PL/SQL programs to compute earned commissions, measure sales Growth against goals,
  • and check for missing information.
  • Reviewed and optimized changes for procedures that handle comparison reports for various market
  • trends and changes.
  • Wrote PL/SQL procedures and functions to efficiently perform complex business logic to
  • summarize data.
  • Implemented the extraction of data from Remote databases and developed the accompanying front-
  • end application to produce margin and research analysis Reports.
  • Used SQL*Loader, External tables to load user research files into Oracle database everyday.
  • Developed a framework for extensible automated production support, in PL/SQL
  • Maintained the system, wrote scripts in Oracle SQL to monitor batch processing to get early
  • warnings incase of wrong data processing.
  • Allocated system storage and planned future storage requirements for the database system
  • Planned for backup and recovery of database information
  • Managed primary database structures (table spaces) and primary objects (table, views, indexes)
  • Exported the database and imported the same into development and test environment wheneve
  • Created Database Users, Roles and managing Security. Implement effective database security
  • Monitored and optimized the performance of the database
  • Performed disaster recovery

Confidential

Oracle PL/SQL Developer

RESPONSIBILITIES:

  • I was part of design and development team to build packages, stored Procedures, Functions, Indexes
  • r the new System.
  • Triggers were defined for keeping track of user entries and Reports, Security Management for
  • sensitive Information handled by creating various roles to grant access to various forms and pages of
  • the application.
  • Created a email functionality to trigger emails to calibration manager whenever tools needs
  • calibration.
  • Created Tables, Views, Constrains, Synonyms, Sequences.
  • Created and used DB-Links to connect to other local & QA databases
  • Built the QA environment for testing DS application and ensured that all the modules work as

Hire Now