OBJECTIVE

• As a bright ambitious person, I enjoy working in a fast paced, highly motivating position where I can assist others while challenging and expanding my knowledge and understanding of the task at hand. I am seeking a position that will utilize my skills and offer the chance for advancement as well as allow me the opportunity to gain additional skills and experience.

SUMMARY

• 6.5+ years of experience in Application Development, Support and Maintenance.
• Extensive programming experience with Oracle/PLSQL programming.
• Proficiency with Teradata programming
• Working Knowledge of Oracle Reports
• Troubleshoot using SQL queries during integration between various business applications.
• Use of Execution plan analysis to analyze the Queries
• Designing and Implementation of complete automation of an Application.
• Articulate communicator who can fluently speak the languages of both people and technology, blending technical expertise with exceptional interpersonal skills.
• Ability to quickly analyze and come - up with an efficient industry standard solution for a given problem.
• Good communication and presentation skills and ability to quickly adapt to the technical environment.
• Expert level skills in complete MS Office Suite (Word, Excel, Access, PowerPoint
• Excellent team player and proven track record working in various team sizes performing cross-functional roles.

TECHNICAL SKILLS

ETL Tools and Scripting Languages: OWB(Basic),UNIX(Basic) SQL, PLSQL, Datastage(Basic)

RDBMS: Oracle 9i/10g, Teradata.

Tools: Visual Studio 2003, SQL Server 2003,Toad,SQL Navigator, SQL Developer, Business Objects 6.5 Oracle Reports Builder

Platforms: Windows 2K/XP, UNIX.

PROFESSIONAL EXPERIENCE

Oracle Programmer

Confidential

Responsibilities:

• Development and Enhancement of existing Oracle Reports for the business
• Developing PL/SQL objects as per the report requirement
• Interact with the business for requirements
• Creating Design Documents
• Performing Design and Code Review
• Unit Testing and Bug Fixing

Teradata/Oracle Developer

Confidential

Responsibilities:

• Creating Proof of Concepts (POC) for various clients depending upon the nature of requirement
• The requirement includes Migrating the existing code from Legacy System(Oracle, SQL Server etc.) to Teradata as per migration rules
• Converting PL/SQL modules developed in Oracle into corresponding Teradata SQL
• Data Loading using TPT
• Performance Tuning of the modified queries as per requirement
• Validating the existing Oracle and the migrated Teradata code on the basis of functionality and result sets
• Code Walkthrough and Code Review of the existing migrated Code
• Ensuring the migrated code is as per the set of rules created in the checklist
• Understanding the code flow and highlighting the discrepancies if any as per the checklist created
• Creation of test cases for testing
• Understanding the ETL flow of the legacy application data mart
• Creating Impact Analysis documents as required
• Creating mapping objects for the legacy system in Teradata
• Creating mapping documents for the ETL flow for Teradata Migration
• Creation of Cross reference document mapping business fields from the legacy system to Teradata
• Migrating the Oracle code into corresponding Teradata equivalent
• Interaction with Onsite team for new process implementation and design consideration

Oracle-PL/SQL Developer

Confidential

Responsibilities:

• Developed new features using PL/SQL in Oracle during the development phase.
• Being a part of ETL Team, I was involved in development of mappings and procedures for the reports
• Analysis and Fixing of Issues in case of Load Failure.
• Debugging the report query as per user's requirement.
• Developing new modules in oracle as per requirements.
• Interacting with other teams for data analysis.
• Mentoring of associates.
• Understanding the requirements and developing the system in Oracle right from Table design
• Testing the application
• Co-ordinate with Java Team for Front End requirement and testing
• Writing Test Cases
• UAT Deployment and post deployment Sanity Testing
• CR creation and production deployment with sanity testing
• Defect Analysis and Fixing

Oracle-PL/SQL Developer

Confidential

Responsibilities:

• Providing support to Order Management Applications involving ordering of Network Products.
• Provided application support includes working and investigating on various platforms and languages.
• Managing Database of Data warehousing Applications.
• Brief acquaintance with Business Objects Tool which is a report Generating Tool.
• Handling Live Issues faced by the users/clients and providing a quick fix/workaround which requires code fix.
• Performing Root Cause Analysis for a permanent fix.
• Handling and raising Change Requests for Live Releases.
• Acting proactively to stop future live issues.
• Handling Database Objects and managing them as per the issues.
• Communication with the users/clients/interface component teams.
• Testing and Debugging.
• Coordinated with different interface teams for faster resolution of issues.
• Provide business knowledge to the team members.
• Participated actively in the mentoring of associates.
• Handling Client Calls.