PROFESSIONAL SUMMARY:

• 9 Years of programming experience as Sr. Oracle PL/SQL Developer, Business System Analyst and Data Analyst in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery.
• Worked as a Business Systems Analyst as well using the iterative software development lifecycle principles with extensive experience in the field of business analysis, business modeling, document processing, etc to manage, develop and test Telecom Systems.
• Worked as Lead with experience in handling Onsite - Offshore Model, followed the assigned tasks to completion through maintenance of different deployment and progress trackers.
• Proficient in ensuring that business goals are met throughout the product lifecycle.

  Proficient in creating Behavioral and Structural UML diagrams including Activity, Sequence, Data Flow, ER Diagrams, Logical Data Modeling and Physical Data Modeling.

• Complete knowledge about Risk Management Life cycle and Expert in creating process flow diagrams and data flow diagrams to define Business schemes.
• Experience with Oracle SQL and PL/SQL programming and used Database utility tools like PL/SQL Developer, TOAD and SQL Navigator.
• Experience in Oracle SQL and PL/SQL including all database object: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Experience in tuning the application using Explain Plan and SQL Trace to optimize the cost and for higher efficiency.
• Experienced in loading data using SQL *loader and using SQL *Plus. Good in writing complex SQL queries according to business rules.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Good understanding of Oracle data dictionary and Normalization techniques. Experienced in Oracle 11g/10g/9i systems.
• Experienced in analyzing index, quality assurance, Performance Tuning of Oracle SQL and PL/SQL applications using- TKPROF Explain Plan, SQL HINTS.
• Experience in the preparation of Technical Design documents and involved in Unit Testing, Systems Integration Testing(SIT) and documented the same.
• Experience in developing UNIX Shell Scripts, scheduling and executing jobs through Autosys, Control-M and Crontab schedulers.
• Experienced in Test Case preparation, Test Case Execution and Bug Reporting using HP Quality Center Tool.
• Experience with creating Disaster Recovery Plans and carrying out half-yearly Disaster Recovery tests for application.
• Expert in Incident Management working through critical incidents. Manning command center and conducting Incident resolution bridge calls.
• Excellent communication skills, technically competent with strong problem solving skills enabling effective interaction with project sponsors, testers and business users.
• Ability to work independently and as part of a team, deliver under pressure and tight deadlines.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i

Oracle Tools: SQL * Loader, TOAD,PL/SQL Developer, SQL Developer, SQL Tool, SQL Navigator, Import/Export

Programming Languages\Scripting: SQL, PL/SQL, C, Java, JSP, XML, HTML, JavaScript, Unix Shell Scripting, Perl Programming

Performance Tuning: SQL Trace, TKPROF, Explain Plan, HINTS

Scheduler: Autosys, Cron Job Utility

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Data Modeling Tools: SQL Navigator, Microsoft Visio 2003, TOAD and Eclipse

Version Control Tools: IBM Rational Clear Case, Visual Source Safe

GUI: Oracle Forms 6i, 9i, 10g and Reports 6i, 9i, Oracle 11g version Reports, XML Publisher Reports, BI Publisher Reports

Issue Tracker Tools: HP Quality Center, Issue Tracker, Defects resolver

Operating Systems: Win 98, XP/NT, Windows 2000, Red Hat Linux7

PROFESSIONAL EXPERIENCE:

Confidential

Sr. PL/SQL Developer/Lead

Environment: Oracle 10g/11g, UNIX, PL/SQL Developer, SQL Loader, SQL developer, Toad, Kintana, Clear Case, HTML, XML, Telelogic DOORS, HP Quality Center, Incident Management Tool

Responsibilities:

• Maintenance of Quote to Order track for Trilogy Project where the Orders are accepted through different sources like Order Entry System, iStore and EDI.
• Providing Monthly, Quarterly and yearly maintenance and on time support from Quote to Order Track from Onsite.
• Maintained user provisioning process through custom logic for iStore, ireceivables, iSuppliers, eModules and Web Money web application services.
• Maintained the progress and deployment trackers on the assignment and resolution of the critical incidents, assigned tasks to the teams members through Onsite-Offshore Model.
• Maintenance of stored procedures, functions, triggers and packages to facilitate consistent data entry into the database.
• Understanding the system issues and working on permanent solutions which would include the developing the custom logic to overcome the issues.
• Updated more than 40 procedures, functions, triggers, and packages based on the change request through Problem Management Process.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Extensively used UTL FILE, DBMS CLOB, TKPROF, and EXPLAIN PLAN Utilities as part of improving the performance.
• Extensively involved in usinghints to direct the optimizerto choose an optimumQuery Execution plan.
• Code Configuration is done using Kintana and Clear case tools which migrates the code from one environment to another at ease.
• Developed Unix Shell scripts for FTP file transfers and extracting the data into the Oracle Tables and scheduled the auto-run jobs using Crontab.
• Prepared Unit Test Scripts, Performed Unit Testing and captured the results which provides as demo of the real time scenarios to the release managers.
• Involved in Preparing System Integration Test (SIT) Cases which involves different tracks integration and normal functioning between the same as designed.
• Provided full scale support during SIT with different teams/tracks involved to check on the designed functioning process achieved without effecting the present functioning process.
• Performed exclusive Knowledge Transfer (KT) to end users on how to submit the jobs and check the flat file contents.
• Helped End-Users performing User Acceptance Testing (UAT) over the regions involved across the globe.
• Carried out Disaster Recovery Tests for application on half-yearly basis to ensure no loss of data to deal with disasters.

Confidential, Schaumburg, IL

Business Systems Analyst

Environment: Oracle 10g Database, Unix Shell Scripting, TOAD, PL/SQL Developer, Savvion BPM Tool, Unified Modeling Language(UML), Telelogic DOORS, HP Quality Center

Responsibilities:

• Designed Functional Process Flow of Legacy Systems by analyzing requirements, constructing workflow charts and diagrams, studying system capabilities, writing functional specifications. Improved systems by studying current practices and designed modifications accordingly.
• Determined operational objectives by studying business functions, gathering information, evaluating output requirements and formats.
• Defined project requirements by identifying project milestones, phases, and elements. Prepared a detailed Business Requirements documentation for the desired system process to be implemented.
• Presented Proof of Concept(POC) on the expected system process with respect to the current business system process.
• Prepared the functional flow of the process from the defined system to the third party systems using Savvion BPM Tool.
• Monitored Project Progress by tracking activity, resolving problems, publishing progress reports and recommending actions.
• Provided s for users by writing and maintaining User Documentation, providing help desk support and the users.
• Complete knowledge about Risk Management Life cycle and Expert in creating process flow diagrams and data flow diagrams to define Business schemes.
• Reviewed the detailed Technical Design Document documentation with proposed solutions which meets the business requirements.
• Gathered data, segmented into smaller modules, identified trends to increase efficiency for campaign operations and lead generation to acquire new customers, cross sell and reduce attrition.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Technical review of components like PL/SQL Packages, Functions, Anonymous Scripts, PL/SQL tables is provided whether the components has met the functional requirements.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeExplain Plan, SQL*TRACE, TKPROFandAUTOTRACE.
• Defined the Unix Shell scripts for FTP file transfers from third party systems into Oracle by extracting the data into the Oracle Tables.
• Reviewed all the business scenarios involved in the project with the help of Unit Test Scripts.
• Performed Unit Testing and System Integration Testing and captured the results which provides as demo of the real time scenarios to the release managers.
• Involved in testing System Integration Test (SIT) Cases which involves different tracks integration to check on the designed and expected functioning and provided the full scale support.
• Suggested on the Disaster Recovery Tests for application on half-yearly basis to ensure no loss of data to deal with disasters.

Confidential

Oracle PL/SQL Developer

Environment: Oracle 10g Database, Unix Shell Scripting, TOAD, PL/SQL Developer, XML Publisher, Telelogic DOORS

Responsibilities:

• Translated Business Requirement Documents into Data Models. Created Multiple Subject Areas for Various Schema Creations in Database for handling different modules in project for Front end teams / Back end teams to understand and access data in an Optimal Way.
• Analysis of the existing legacy systems - COF(Customer Order Fulfillment) system & its subsystems to provide the technical design of the proposed process.
• Prepared a detailed Technical Design Document documentation for proposed solutions which meets the requirements.
• Created more than 30 PL/SQL Packages, Functions, Anonymous Scripts, PL/SQL tables with Bulk Collections, Triggers, Custom Procedures, and FTP Scripts.
• CreatedRecords, Tables, Collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developed complex SQL queries including Joins, Sub queries, Correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Extensively involved in usinghints to direct the optimizerto choose an optimumQuery Execution plan.
• Extensively used UTL FILE, DBMS CLOB, TKPROF, and EXPLAIN PLAN Utilities as part of improving the performance.
• Developed XML Burst Scripts and XML/BI Publisher reports to provide the view of the data to the end customers.
• Developed XMLP Reports which are emailed to the business users to review on the monthly, quarterly and yearly input of the orders.
• Code Configuration is done using Kintana and Clear case tools which migrates the configured setups from one environment to another at ease.
• Prepared Unit Test Scripts for all the business scenarios involved in the project which helped in unit testing.
• Performed Unit Testing and captured the results which provides as demo of the real time scenarios to the release managers.
• Performed Knowledge Transfer (KT) to support teams on how to submit the jobs and check the flat file contents.
• Helped End-Users performing User Acceptance Testing (UAT) over the regions involved across the globe.

Confidential

Oracle PL/SQL Developer

Environment: Oracle 9i Database, Reports, TOAD, PL/SQL Developer, Unix Shell Scripting

Responsibilities:

• Provided Monthly, Quarterly and yearly maintenance and on time support from offshore team by presenting through different reports.
• Maintenance of stored procedures, functions, triggers and packages to facilitate consistent data entry into the database.
• Understanding the system issues and working on permanent solutions which would include the developing the custom logic to overcome the issues.
• Updated more than 40 procedures, functions, triggers, and packages based on the change request through Problem Management Process.
• Developed complex SQL queries including Joins, Sub queries, Correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Responsible for the successful running of the various interfaces in Production for transferring data from and to the business system and legacy system.
• Extensively used UTL FILE, DBMS CLOB, TKPROF, and EXPLAIN PLAN Utilities as part of improving the performance.
• Code Configuration is done using Kintana and Clear case tools which migrates the code from one environment to another at ease.
• Performed Unit Testing using Unit Test Scripts and captured the results which provides as demo of the real time scenarios to the release managers.
• Performed exclusive Knowledge Transfer (KT) to end users on how to submit the jobs and check the flat file contents.
• Helped End-Users performing User Acceptance Testing (UAT) over the regions involved across the globe.

Confidential

Oracle PL/SQL Developer

Environment: Oracle 9i Database, TOAD, PL/SQL Developer, Perl, Unix Shell Scripting, JSP

Responsibilities:

• Prepared Technical specification design document that gives the comprehensive details about the requirements.
• Meeting Service Level Agreements as defined and daily status updates on the same.
• Co-ordinate with onsite team for data validation and conversion using standard API’s.
• Created PL/SQL Packages, Functions, Anonymous Scripts, PL/SQL tables and custom Procedures.
• Developed complex SQL queries including Joins, Sub queries, Correlated queries, and Nested queries, Unions, Intersect and Aliases.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Worked on performance tuning for queries using Explain plan and analyzing indexes for standard oracle tables by running gather index statistics.
• Extensively used UTL FILE, DBMS CLOB, TKPROF, and EXPLAIN PLAN Utilities as part of monitoring and improving the performance.