SUMMARY:

• 14 years of extensive experience in the software development. Involved in software development for various projects, using Oracle tools in various operating system platforms like UNIX, Windows '95/98/00, Windows NT and XP
• Have worked extensively in Full software development life cycle implementation (SDLC) including Business interaction, Requirement Analysis, Software Architecture, Design and Development
• Thoroughly experienced in Oracle 11g/10g/9i/8i, database development experience using PL/SQL, Stored Procedures, Triggers, Functions, Packages, Views, Materialized Views and VArrays, Nested Tables and Oracle Objects.
• Solid experience in Designing, Developing, Reengineering, Deploying and fine - tuning Oracle Stored Procedures.
• Experience with data analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration and data creation.
• Good experience of preparing technical documents like functional requirement document, functional specification document, detailed design documents, Test plans, test cases, Support handover documents.
• Expertise in efficient SQL Query writing and SQL Performance Tuning
• Worked extensively on packages, stored procedures, user defined functions, analytical functions, exception handling and triggers.
• Experience of direct Interaction with the clients by calls, mails, one to one in getting the requirements and clarification on requirement
• Excellent Technical, communication and interpersonal skills with strong customer orientation and client interfacing skills
• Primary responsibilities include estimation, design, development and maintenance of applications
• Expertise in working with global and distributed project teams

TECHNICAL SKILLS:

Operating System: Win XP, Win Vista

Databases: Oracle 11g, 10g, 9i, Sybase12,15

Languages: SQL, PL/SQL, T-SQL

GUI: Visual Basic 6.0

Utilities: SQL*Loader, Export/Import, Explain Plan

Tools : TOAD 10.6, PL/SQL Developer, SQL* Plus,SVN, PVCS 8x

ETL Tools : Informatica 9.5

Scripting : Shell Script, Perl

Schedule Tool : Autosys

PROFESSIONAL EXPERIENCE:

Confidential

Anti-Money Laundering Transaction Monitoring: (AML)

Responsibilities:

• Strong commitment to timely execution of tasks in a fast-paced environment.
• Experience in Requirement gathering and business analysis for extensions to business applications.
• Managed team of 4
• Played a key role in gathering requirements from users for reports development and interface program customizations and in analyzing business process.
• Involved in Tuning the SQL queries.
• Enhanced reports with new requirements from users.
• Developed, monitored and maintained and made upgrades and enhancements.
• Experience in Database design, creation and management of schemas, writing PL/SQL stored procedures, functions, triggers, DDL, DML, SQL query performance tuning, Normalization.
• Modified and developed new features and functionality for the existing application. Performed bug verification and release testing for the existing product.
• Supported users for enhancing of Reports, SQL Programs, Tables, Views, and PL/SQL based on user requirements.
• Created database triggers, PL/SQL stored procedures, functions, packages, collections, indexes and Advanced Queries.
• Used SQL, PL/SQL, Packages, Functions/Procedures, Database Triggers, BULK COLLECT and Advanced Queues as Oracle Back-end.
• Performed performance tuning of various custom programs.
• Used Joins like Inner join, Outer joins and writing complex queries.
• Support the overall reporting infrastructure, with specific focus on the Business environment
• Study of report requirements and preparing the High-level design document.

Environment: SQL, PL/SQL, Oracle 11, PVCS, Informatica, mantas product, autosys Shell Scripts, perl and UNIX, R TC,RLM

Confidential

DOGS

Responsibilities:

• Support the overall reporting infrastructure, with specific focus on the Business environment.
• Strong commitment to timely execution of tasks in a fast-paced environment.
• Experience in Requirement gathering and business analysis for extensions to business applications.
• Developed utilities to Upload/Download Client Local files.
• Loading Data into Multiple Database environments using PL/SQL Packages.
• Performed SQL performance tuning for various PL/SQL packages and Oracle Reports.
• Played a key role in gathering requirements from users for reports development and interface program customizations and in analyzing business process.
• SQL*LOADER to load data into Oracle tables and written spool scripts extract data into flat files to load into another Application.
• Developing several customized Reports and automated which shows output in .CSV, Excel, XML formats.
• Developed, monitored and maintained and made upgrades and enhancements.
• Modified and developed new features and functionality for the existing application. Performed bug verification and release testing for the existing product.
• Publishing universes to the repository and made them available to the appropriate user groups.
• Experience in customization of reports, forms and in data conversions /interfaces.
• Tested the upgraded Reports from 6i to 10g, taking into accounting the significant data model change.
• Generating User defined reports (MIS & other reports).
• Performed performance tuning of various custom programs developed.
• Publishing reports and schedule them to different user groups.
• Used Joins like Inner join; Outer joins while creating tables from multiple tables.
• Study of report requirements and preparing the High-level design document.
• Performed tasks such as PL/SQL tuning, fixing critical bugs in PL/SQL.

Environment: Oracle 10g, TOAD, Perl Scripting, SQL, PL/SQL, SQLLOADER, PVCS, Shell Scripts, Unix, Sybase, T-SQL

Confidential

 GCOT

• I nvolved in identifying the procedure bottlenecks and replace with the efficient
• PL/SQL code in Oracle XML Database
• Involved in SQL tuning using explain plans and driving table concepts
• Proposed the star schema design for this project and implemented successfully to meet the requirements
• Written PL/SQL stored procs, functions and triggers
• Involved in monitoring the SQL performance by the gradual increase of data load in the respective tables and modified the necessary SQLs
• Helped team to write unit test cases and made sure that all test cases are covered.
• Primary responsibilities include estimation, design, development and maintenance of applications
• Documented the impact analysis
• Delegating the tasks accordingly to the offshore counterparts and getting it done
• Participate in all aspects of the software development life cycle, including architecture, development, integration, testing, and maintenance.
• Participate in joint conversations with clients and internal resources to clarify business needs.
• Collaborate with related, non-technical functions to envision and create innovative solutions.
• Design and develop the backend business logic and data access.
• Review technical designs provided by teams.

Environment: Oracle 10g, TOAD, Perl Scripting, SQL, PL/SQL, Autosys, SVN, Shell Scripts, Unix

Confidential

IB-BSAM Portia Support

Responsibilities:

• Application support
• Generation of Reports to suit the functionality.
• Performed numerous data pulling requests involving SQL scripts, UNIX, TOAD.
• Actively involved to develop GUI interface for the applications.
• SQL scripts were written to test the procedures.
• Created Physical and Logical data models. Data Modeling using ERwin. The client requirements were analyzed and translated into logical mode using ERwin. After approval, the logical model transformed into physical model using ERwin.
• Performing in-depth quantitative analysis or data analysis.
• Involved in Tuning the SQL queries.
• Tuned Systems. Optimized the queries/procedures for better performance using Explain Plan, SQL*Trace, Tkprof, Auto trace, Hints.
• Responsible for the system study, analysis, design, development, coding, generation of reports using SQL, PL/SQL, Ms Access, testing and documentation.
• Involved in database designer using Erwin and Oracle Database Designer.
• Used Joins like Inner join, Outer joins while creating tables from multiple tables.
• Developed various reports for upper management, corporate board, and executive board reporting on all aspects of business using Oracle Reports.
• Developed Reports included formatting such as Charting, Mapping, Grouping, Sorting,
• Alerting, Field highlighting, Drill-Down and Parameter prompts.
• Created temporary, derived and volatile tables.

Environment: Sun Solaris and Shell script, Oracle 9i, Perl, autosys.