PROFILE:

• 10+ Years of programming experience as an Oracle PL/SQL developer in Analysis, Design and Implementation of Business Applications using the Oracle RDBMS.
• Extensive experience with analysis, design, development, customizations and implementation of software applications including ERP applications.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Developed Complex database objects like Stored procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle supplies packages, Dynamix SQL, Records and PL/SQL Tables. Loaded Data into Oracle tables using SQL Loader.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL*Loader.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Experience in handling all XML specific storage models (Unstructured, Structured - Schema Based and Binary XML ).
• Extensively Used the DBMS XMLGEN and DBMS XMLSTORE package to generate and insert XML files in Oracle 11g/12c
• Firsthand experiences in setting up Oracle Golden Gate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication.
• Good Knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, SQL profiling and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Database development in MySQL using Workbench 6.2 client
• Developed Data migration scripts considering the high volume data movement from the legacy system to the new system
• Strong database skills, Object Oriented Programming and development knowledge
• Experience in leading and managing teams. Handled multiple roles - Project Lead, Team Lead, Software Architect, Developer and Application Database Admin.
• Expertise in Oracle PL/SQL and Application DBA (ADBA).
• Experience in GIT as Version control system tool.
• Well-acquainted with the software development life cycle (SDLC).
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• 5 times recipient of ‘IBM individual award for outstanding contribution.

SKILLS:

Oracle 12c/11g/10g, MS Access, MySQL, SQL, PL/SQL, UNIX Shell Scripting, Oracle GoldenGate 11gR2/12c data replication. *Loader, SQL*Plus, XML,TOAD, Explain Plan, Execution Plan, SQL Developer, Git, SVN, SCME MS Visio, UNIX, Windows, Red Hat Linux, Oracle PL/SQL, VB 6.

PROFESSIONAL EXPERIENCE:

Oracle PL SQL Developer

Confidential, Middletown, NJ

Responsibilities:

• Responsible to write Oracle PLSQL code to UI application which is built using Java and Oracle ADF.
• Responsible to deliver complex PLSQL procedures, functions, Triggers, cronjobs to UI application.
• Worked on SQL*Loader to load data from flat files.
• Worked on Oracle External tables to load the data from external files.
• Involved in the continuous enhancements and fixing of production problems. Generated PL/SQL code for business logic.
• Created scripts to create new tables, views, queries, Materialized views, procedures and packages using Oracle tools like TOAD,PL/SQL Developer and SQL*plus for new enhancement in the application using TOAD.
• Extensively Used the DBMS XMLGEN and DBMS XMLSTORE package to generate and insert XML files in Oracle 11g/12c
• Involved in the Re-Design of the XML Schema for the Content Store XML-Database.
• Developed PL/SQL API’s to provide the linking information in the form of XML’s.
• Monitored Indexes (XMLType: XMLIndex) and analyzed their status for performance tuning and query optimization.
• Developed a Custom Package which parses and compares fields from a XML using DBMS XMLDOM package.
• Developed and Optimized Contractor Management package making use of Bulk Collect and Bulk Insert features in PL/SQL.
• Involved in one-way, two-way/bi-directional data replication using Oracle Golden Gate.
• Manage all aspects of the OCG design, Implement and support in development,UAT and production environments.
• Identify and resolve OCG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning).
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysis etc.
• Created Indexes on the tables for faster retrieval of the data to enhance query performance.
• Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Performed SQL and PL/SQL tuning and application tuning using EXPLAIN PLAN, TKPROF and SQL*Trace.
• Implemented/Created MySQL tables, scripts for log monitoring UI.
• Implemented cronjobs in UNIX Shell scripts to monitor database jobs.
• Provide support to developers with trouble-shooting and performance tuning, including SGA analysis, latch contention analysis, disk subsystem tuning and SQL tuning of Oracle and custom views and queries.
• Fulfill ADBA daily activities, including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.).
• Sound knowledge on OEM, SQL plus
• Configuring DB alerts using Crontab .
• Involved in database schema refresh activities from production to stage.
• Tablespace maintenance like adding and resizing datafiles.
• Maintaining, Administering of Oracle Databases and Applications.
• Schema backups using export and import utilities.
• Monitoring DB alert log errors, Tablespace usage, Locks in a Database.
• Extensive experience in working of Version control system tools like GIT.
• Experience in database application development, Query Optimization, Performance tuning and DBA solutions and implementation experience in complete System Development life Cycle.
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Responsible to code my module, integrate code from all the developers from every single module and test the code to meet the requirement given. Also he was responsible for code review to check code methodology been followed in all module.
• Responsible for providing technical direction for the development, design, and systems integration across multiple client engagements from definition phase through implementation. Appling significant knowledge of industry trends and developments to improve service to our clients. Suggesting alternative technical solutions to meet client requirements more efficiently, and/or with greater reusability, and / or longer life. Executing development plans across multiple projects and revises as appropriate to meet changing needs and requirements. Identifying reusable code required for our code library and ensures the high-quality creation of the code. Defining communicates and enforces coding standards.
• Responsible for end to end delivery of both enhancement and maintenance projects. My responsible included like creating a Project Plan, estimating for the projects, track the project and update the Project plan in Work Breakdown Structure to get the status from the project team, to make sure proper review happened for all the deliverables and issues.

Environment: Oracle 11g/12c, Oracle PL/SQL, Oracle ADF, Java

Software Developer

Confidential, Middletown, NJ

Responsibilities:

• Responsible to write Oracle PLSQL code to UI application which is built using Java and Oracle ADF.
• Responsible to deliver complex PLSQL procedures, functions, Triggers, cronjobs to UI application.
• Worked on SQL*Loader to load data from flat files.
• Involved in the continuous enhancements and fixing of production problems. Generated PL/SQL code for business logic.
• Created scripts to create new tables, views, queries, Materialized views, procedures and packages using Oracle tools like TOAD,PL/SQL Developer and SQL*plus for new enhancement in the application using TOAD.
• Extensively Used the DBMS XMLGEN and DBMS XMLSTORE package to generate and insert XML files in Oracle 11g/12c
• Involved in the Re-Design of the XML Schema for the Content Store XML-Database.
• Developed PL/SQL API’s to provide the linking information in the form of XML’s.
• Monitored Indexes (XMLType: XMLIndex) and analyzed their status for performance tuning and query optimization.
• Developed a Custom Package which parses and compares fields from a XML using DBMS XMLDOM package.
• Developed and Optimized Contractor Management package making use of Bulk Collect and Bulk Insert features in PL/SQL.
• Involved in one-way, two-way/bi-directional data replication using Oracle Golden Gate.
• Manage all aspects of the OCG design, Implement and support in development,UAT and production environments.
• Identify and resolve OCG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning).
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysis etc.
• Configuring DB alerts using Crontab.
• Created Indexes on the tables for faster retrieval of the data to enhance query performance.
• Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Performed SQL and PL/SQL tuning and application tuning using EXPLAIN PLAN, SQL*Trace.
• Provide support to developers with trouble-shooting and performance tuning, including SGA analysis, latch contention analysis, disk subsystem tuning and SQL tuning of Oracle and custom views and queries.
• Fulfill ADBA daily activities, including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.).
• Sound knowledge on OEM, SQL plus
• Configuring DB alerts using Crontab .
• Involved in database schema refresh activities from production to stage.
• Tablespace maintenance like adding and resizing datafiles.
• Maintaining, Administering of Oracle Databases and Applications.
• Schema backups using export and import utilities.
• Monitoring DB alert log errors, Tablespace usage, Locks in a Database.
• Experience in database application development, Query Optimization, Performance tuning and DBA solutions and implementation experience in complete System Development life Cycle.
• Work with Confidential & Confidential requirement Engineer in translating business requirements into Functional Requirements Document and to Detailed Design Documents.
• Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact
• Present and defend product designs and architecture to clients
• Coordinate and communicate tasks with developers
• Responsible to code my module, integrate code from all the developers from every single module and test the code to meet the requirement given. Also he was responsible for code review to check code methodology been followed in all module.
• Responsible in ensuring all the issues, risks are resolved in time, escalate to appropriate higher management in case of very propagating risks. Also ensure to have mitigation plan for any issues/risks, track the plan and close.

Environment: Oracle 11g/12c, Oracle PL/SQL, Oracle ADF, Java

Software Engineer

Confidential

Responsibilities:

• Analyzed the customer requirements by analyzing defect information and by conducting advance requirement gathering workshops.
• Delivered complex PLSQL procedures, Functions, Triggers and shell scripts for this application.
• Performed modifications to existing form as per change request and maintained.
• Involved in the continuous enhancements and fixing of production problems.
• Designed, Implemented and tuned interfaces and batch jobs using PL/SQL.
• Developed PL/SQL code and UNIX shell scripts to automate respective database process.
• Actively involved in understanding and resolving issues related to design and implementation.
• Developed the Masters, Transaction Screens & Reports on Investment module mainly using PL/SQL, VB 6.0.
• Written Stored Procedures Using PL/SQL in Oracle 10g for various Reports and Voucher Processing.

Environment: Oracle SQL/PLSQL, VB 6.0, Oracle 10g