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