SUMMARY:

• 7 years of experience in Design, Development, Enhancement and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL . Involved in various phases of System design and good understanding of SDLC .
• Expert in using Oracle PL/SQL Packages , Stored Procedures, Functions, Ref Cursors, Exception Handling.
• Extensively used Collections (Pl/SQL Tables, Nested Tables, and Types) for bulk operations and performance improvement.
• Good - Experience in writing complex SQL queries using Joins, Analytic functions, aggregate functions.
• Conversion functions (String, Numeric, Date). Good-experience in creating Tables, Views, Materialized View, Indexes, Sequences, Global temp tables.
• Strong ability in transforming business requirements into design document and good understanding on business improvement processes.
• Experience in query level performance tuning using Explain Plan.
• Experience in unit testing, writing test plans and test cases .
• Possess excellent communication, interpersonal and presentation skills.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Excellent team player with the ability to work independently and interact with people at all levels.
• Experience in working under high stress environment to meet the project deadlines.

TECHNICAL SKILLS:

Environment : Windows, Unix(Solaris)

Database : Oracle 10g,11g,12c, MySQL

Languages : SQL, PL/SQL, Unix Shell scripting, Siebel eScripting

Tools : Toad, Putty, Siebel

PROFESSIONAL EXPERIENCE:

Confidential, Rahway, NJ

Lead Senior Consultant

Responsibilities:

• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Developed PL/SQL codes to update data in application, created automated jobs to updated/delete data using batch jobs and shell scripts.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Involved in writing several Queries and Procedures.
• Fine-tuned procedures/SQL queries for various efficiency in Oracle database.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Analyzed impact on existing procedures and interface jobs, every time any configuration change was done in application.
• Led entire team from Development to Production Implementation in two projects.
• Participated in project management, created project proposals backed up with thorough research and successfully presented it to higher management and customers.
• Involved in code walk through and review sessions with the development team.
• Involved in production support.

Environment: Siebel Clinical, Oracle 10g

Confidential, Rahway, NJ

Lead PL/SQL Developer

Responsibilities:

• Leading team of 6 individuals through the different-stages of the project's life cycle.
• Daily interaction with client and business teams to close the gap on the requirements and providing estimates, planning based on the Requirements. Identifying the risks and come up with a risk mitigation plan.
• Actively involved in conducting reviews, walkthroughs, Demo and presentation to the end user about new release.
• Manage all changes in accordance to the change management process to prevent the implementation of unauthorized changes and cost exposures.
• Create/modify procedures/packages/functions/triggers as per the business requirements using Oracle PL/SQL (Cursors, analytical functions, collections, exception handling). Creation of Tables/indexes/ required for the application.
• Interacting with Business/vendor team for business clarifications related to issues/tickets and track them to closure within the stipulated SLA’s.
• QA Support - Ensuring quality process compliance throughout the project with highest quality deliverables.
• Providing Release support and post implementation support.
• Team coordination/prioritization, Conduct weekly and monthly status meetings.
• Analyzed the individual performance of each team member and motivated them to perform even better.

Environment: Siebel Clinical, Oracle 10g

Confidential, Rahway, NJ

PL/SQL Developer

Responsibilities:

• Developed PL/SQL code for data correction in Siebel CTMS application.
• Gathered requirement from business and developed PL/SQL and Siebel EIM scripts for same.
• Debugged and analyzed PL/SQ
• Worked with offshore team and business team to carry out L1 and L2 incidents.
• Resolved and debugged high priority and critical issues.
• Coordinated with offshore team for all critical remedy tickets.
• Worked with other team (Oracle and Informatica team) for various CRs and SRs.

Environment: Siebel Clinical, Oracle 10g

Confidential

IT Consultant

Responsibilities:

• Worked on enhancement project to develop SIEBEL Call Center Application using Siebel Tool (Siebel Configuration Tools, eScripting).
• Worked on PL/SQL and Siebel EIM to update, delete and insert data in SIEBEL application.
• Loaded Data into Oracle Tables using SQL Loader.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Interacted with business personnel from companies to understand the business case and suggest solutions in the form of new features and functionality
• Handled various high severity customer escalations during this period and fixed the issue using SIEBEL tool or PL/SQL.

Environment: SIEBEL Call Center Application, Oracle 9i, 10g.