We provide IT Staff Augmentation Services!

Oracle Specialist Resume

SUMMARY

  • 10+ years of IT Experience with 8yrs exclusively worked as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g, 11g in Production, Staging, Development environments.
  • Experience in banking & financial, retail and telecom domain.
  • Documentation of projects for software requirements, and specification (Software Requirements Specification) documents, Functional Requirement Spec (FRS), Use case Spec, ER - Diagram, Test Plan and Test Script & Test Cases.
  • Designing, Testing Development & Support of Oracle 9i, 10g, 11g in Production, Staging, Development environments.
  • Coordinate and support software professionals in installing and analyzing applications and tools.
  • Perform complex analysis, designing and programming to meet business requirements.
  • Expertise in creating SQL Queries, PL/SQL Package, function, stored procedure, Ref Cursors, triggers, and cursors.
  • Created database objects like tables, views, materialized views, sequences, synonyms, Indexes.
  • Interface with end-users and software consultants.
  • Responsible for analyzing new software applications and submitting detailed report to management.
  • Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP and ETL tools using Informatica Power Center Designer.
  • Experience in data reduction, analysis and reporting.
  • Define specifications for complex software programming applications.
  • Exposure & knowledge of designing logical & physical Data Model in RDBMS.
  • Worked on Data Modeling - ER Modeling and Dimensional Modeling.
  • Good knowledge on use cases, class diagrams, interaction diagrams and sequence Diagrams.
  • Maintain, manage and modify all software systems and applications.
  • Worked on Oracle XML Parser.
  • Resolve complex issues relating to business requirements and objectives.
  • Have worked in fast paced AGILE environment & attended daily scrum meeting.
  • Assisted QA Teams in writing Test cases, test plans and scripts and validation against the system for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
  • Analyze, design and develop modifications and changes to existing systems to enhance performance.
  • Making structural changes to the database objects.
  • Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP.
  • Experience in working high-transacted OLTP systems and OLAP Systems.
  • Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
  • Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS

Databases: Oracle 12c/11i/10g/9i, MS Access, MS SQL Server 2008/2005.

Programming: PL/SQL, SQL, UNIX shell scripting, Visual Basic, Java Script

Tools: TOAD 8.6/7.5/7.0, Oracle SQL Developer, SQL * Loader, SQL*Plus, Putty, CA

Erwin DM and ODM, Oracle Developer Suite (Forms & Reports Builder)

ETL Tools: Informatica Power Center, Autosys, Tableau, Crystal Reports

BI/Data Analytics Tool: Sisense

Operating System: Windows 98/2000/XP/NT, UNIX

Others: XML, HTML, CSS, jQuery, SVN, VSS, Confidential, Eclipse

PROFESSIONAL EXPERIENCE

Confidential

Oracle Specialist

Responsibilities:

  • Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing.
  • Involved in creation of DB Object synonyms and Cursors,writing several complex Queries, usage of Joins and Data Loading.
  • Evaluate database performance and provide architecture changes to improve quality and efficiency.
  • Working closely with Development Project Managers and Business Analysts to produce accurate delivery estimates and manage the transition from analysis through to design and delivery.
  • Responsible for analyzing new software applications and submitting detailed report to management.
  • Document, analyze and resolve highly-complex problems
  • Involved in creation of the Stored Procedures, Functions and Packages, Views, Refcursors and Exceptions using Oracle SQL Developer tool.
  • Performing Extract, Transform and Load (ETL) and Data Conversions.
  • Recommend processes for the monitoring and review of standards and policies for consistency.
  • Facilitate quality assurance objectives for assigned projects
  • Identify problems and recommend corrective actions.
  • Usage of Redmine Tool for posting and tracking application defects during the development process.
  • Tuning SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization.
  • Analyze and troubleshoot functional issues in a timely manner.
  • Develop new business processes or enhance existing processes to improve business efficiency.
  • Assisted in completing a comprehensive project to log all legacy applications.
  • Designed and maintained coding standards to enhance application development and maintenance.
  • Experience in GIT and GITHUB tool for software development version control.
  • Assist in all phase of project Lifecycle to ensure quality and timely deliverable .
  • Assist QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.

Environment: PL/SQL, Oracle SQL Developer, SQL Plus Erwin

Confidential, PA

Oracle Consultant

Responsibilities:

  • Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing.
  • Working on development activities and managing custom application development projects, customization of Oracle Applications.
  • Provide technical and functional support to project teams.
  • Assisted in creating a team that was responsible for analyzing all new software applications and keeping updated reports for management.
  • Involved in creation of Schema, Users, Tables, Constraints, Indexes, Triggers, Cursors, sequences, synonyms. Involved in writing several complex Queries, usage of Joins and Procedures.
  • Develop reports using the Oracle Reports to cater to business specific reporting needs.
  • Develop workflow processes and generate routine and ad-hoc project reports.
  • Evaluate database performance and provide architecture changes to improve quality and efficiency.
  • Analyze and troubleshoot functional issues in a timely manner.
  • Worked closely with software application developers to create efficient control software for several industrial applications.
  • Responsible for maintaining all software reports and submitting a summary report each month to management.
  • Involved in identify potential risks and develop mitigation strategies
  • Designed Physical and Logical Data model and Data flow diagrams.
  • Communicate project status to customers on regular basis.
  • Develop new business processes or enhance existing processes to improve business efficiency.
  • Extensively involved in test data preparation test case creation, test plan document, etc.

Environment: PL/SQL, Oracle SQL Developer, SQL Plus Erwin, Oracle Reports, XML

Confidential, IL

Sr. Oracle PL/SQL Developer / Production Support

Responsibilities:

  • Participating in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
  • Feasibility study, planning, implementation, testing, deployment and close-out.
  • Involved in Business Requirements, System analysis and Design of the application.
  • Documentation of projects for software requirements, and specification (Software Requirements Specification) documents.
  • Assists with on-the-job training and provides guidance to other developers.
  • Assisted QA Teams in writing Test cases, test plans and scripts and validation against the system for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
  • Recommend processes for the monitoring and review of standards and policies for consistency.
  • Designed Physical and Logical Data model and Data flow diagrams.
  • Created logical and physical Database Design, data structures, Data Modeling, Schema Design
  • Involved in creation of Schema, Users, Tables, Constraints, Indexes, Triggers, Cursors, sequences, synonyms.
  • Guiding QA team in developing test plans/cases, and with automated functional testing, to ensure outstanding solution quality.
  • Involved in writing several complex Queries, usage of Joins and Procedures.
  • Tuning SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
  • Built database objects like Tables, Views.
  • Used joins, Explain Plan, Indexes effectively in where clauses for Query optimization.
  • Involved in the Data Modeling - E R Modeling and Dimensional Modeling.
  • Worked on the Sisense BI and Data analytics tool to design and create new custom reporting dashboards for enhanced decision analysis to end users.
  • Involved in working on different kind of filters.

Environment: PL/SQL, Oracle SQL Developer, Erwin, BI Reporting

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing.
  • Involved in Business Requirements, System analysis and Design of the application.
  • Involved in creation of SRS (Software Requirements Specification) documents, (FRS) Functional Requirement Spec, Use case Spec, Test Plan and Test Script & Test Cases.
  • Facilitate quality assurance objectives for assigned projects
  • Designed Physical and Logical Data model and Data flow diagrams.
  • Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
  • Involved in writing several complex Queries, usage of Joins and Procedures.
  • Defined conceptual, logical and physical data structure using Erwin.
  • Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.
  • Filtered and Loaded data from different formats of data sources into Database Tables.
  • Extracted, transformed and loaded data from different formats of data sources into Database Tables using Informatica.
  • Extracted required data from the database tables and exported the data to different sources.
  • Experience in Generating Reports.
  • Used joins, Explain Plan, Indexes effectively in where clauses for Query optimization.
  • Proficient in Quality Center QC for Test Planning, test designing, test Analysis, test Execution, and Defect Reporting and Tracking
  • Guiding QA team in developing test plans/cases, and with automated functional testing, to ensure outstanding solution quality.
  • Responsible for Performance testing loading staged test cases and analyzing performance metrics at each run.
  • Responsible for finding performance bottlenecks by validating the performance at each tier and comparing them with non-functional metrics, etc.

Environment: PL/SQL, Toad, Oracle SQL Developer, Informatica, Erwin

Hire Now