SUMMARY:

• Over 12.5 years of Experience in Development and Production support in IT.
• Experienced in Banking, Telecom, Healthcare, Manufacturing and GIS.
• Proficient in SQL, Oracle Spatial, PL/SQL, Oracle 9i - 10g-11g.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages,Triggers,Collection, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Sequences, Database Links, and User Defined Data Types.
• Experienced in Oracle Automatic Diagnostics Pack and AWR Report.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables, Cursors and Dynamic SQL for DML operations for better performance.
• Extensively used DDL, DML operations in support and enhancement activities.
• Expertise in Tools such as SQL Developer, TOAD for Oracle SQL.
• Experience with Partitioning of Tables like Range, List, Hash, Interval partitioning etc.
• Expertise in Queries, fine tuning of Queries using Explain Plan and unit testing.
• Used package like DBMS STATS, UTL FILE and UTL MAIL.
• Demonstrated ability to effectively understand and translate business requirements into technical solutions.
• Created System Requirement Document (SRD) and Functional Specification Document (FSD)
• Lead manage offshore teams
• An organized, hardworking, and highly motivated professional, with strong communication and interpersonal skills, and the ability to perform individually or as a dedicated team member

TECHNICAL SKILLS:

Software: Oracle 11g, Oracle 10g, Oracle 11g Spatial, PL/SQL, VB, Sql Server

Tools: Developer 2000, Forms and Reports 10g

Domain Experience: Domain in Utility, Banking, Railway Financial Management System, Material Management and Retail Management System

PROFESSIONAL EXPERIENCE:

Confidential,Rosemead, California

Technology Lead

Responsibilities:

• Gathering and working on requirements and creating functional specifications, with the business team.
• Converting business logic, validation and rules into Technical design document.
• Developed Procedures, Functions, Packages, Triggers etc.
• Preparation of logical Data model using Enterprise Architect tool.
• Identification of long running SQLs generated from AutoCAD Map3D, ESRI Arc GIS etc. using AWR report.
• SQL query tuning using different techniques like Explain plan, Optimizer hints, Parallelism etc.
• Partition of large tables.
• Baselining of SQL execution plan.
• Pl/SQL performance tuning using best practices.
• Creation of thousands of complex views as part Data mart.
• SQL and PL/SQL code review for the entire team before sending to QA team.
• Participation in UAT.
• Work distribution among the offshore team members.
• Preparation of weekly project status report.

Environment: UNIX - on Database Server, Oracle 11g PL/SQL, Enterprise Architect

Confidential,Rosemead, California

Technology Lead/Technology Analyst

Responsibilities:

• Understanding the Requirements and Analysis of the specifications provided by the clients
• Query Tuning With implementation-> Usage of Hints
• Monitoring the database health with STATSPACK Report and TKPROF
• Analysing of Indexes
• PL/SQL extensively for producing Billing reports and reports for statutory
• Design and Development
• Database management
• Testing - unit testing & integration testing
• Responsible for overseeing the Quality procedures related to the project.
• Exports, Imports and working with Global temporary and External Tables.

Environment: UNIX - on Database Server, Windows 2003 Server -on Application Server, Windows XP pro-on client machines, Oracle 10g and PL/SQL as Back-end and VB.Net

Confidential

Senior Software Engineer

Responsibilities:

• Worked as a PL/SQL developer.
• Production support for FinOne product.
• User query handling and Fixing bugs and enhancements.
• Creation of new user interface using Oracle 10g Forms and Reports as part of minor release.
• Co-ordination with QA team.

Environment: UNIX - on Database Server, Red hat 4 Linux -on Application Server, Windows XP pro-on client machines, Oracle 10g and PL/SQL as Back-end and iDS as Front-end tool.

Confidential

IT Engineer

Responsibilities:

• Preparation of SRS document interacting with business team.
• Detailed level design document and approval.
• Data migration from MF COBOL to Oracle 10g using SQL*Loader.
• Creation of GUI using Oracle Forms and Reports.
• Creation and maintenance of multiple database schema.
• Leading and mentoring development team.
• Regular client interaction.

Environment: Red hat 4 Linux - on Database Server, Red hat 4 Linux -on Application Server, Windows XP pro-on client machines, Oracle 10g and PL/SQL as Back-end and iDS as Front-end tool.

Confidentia

IT Engineer

Responsibilities:

• Production support for MMIS and AFRES module.
• Root Cause Analysis of production issues and providing temporary and permanent fixes for data as well as program.
• Develop PL/SQL Procedures, Functions, Triggers and Packages to implement business requirements.
• Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator, Normalizer and joiner.
• Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.
• Understand requirements through regular interaction with business analysts and end users at client’s office.

Environment: Tru64 UNIX - on Database Server, Windows 2003-on Application Server, Windows XP pro-on client machines, Oracle 9i and PL/SQL as Back-end and Developer 2000 as Front-end tool.

Confidential

IT Engineer

Responsibilities:

• Understand games rules for Cycling, Diving and Judo events and convert into technical specification.
• Design and coding for the modified GUI.

Environment: Windows 2003-on Application Server and Database Server, Windows XP pro-on client machines, Sql Server as Back-end and VB as Front-end tool

Confidential

Software Developer

Responsibilities:

• Detailed study of Blood bank operation.
• Technical specification preparation.
• Creation of user data entry forms and multiple reports.
• User training and support.

Environment: Windows 2003 - on Database Server, Windows 2003 -on Application Server, Windows XP pro-on client machines, Sql Server as Back-end and VB as Front-end tool.