OBJECTIVE

T pursue a challenging and growth oriented position in an organization in the area of Database design, Application Development and Systems Architecture, where I can use my diversified abilities t contribute t the growth of the company.

PERSONAL SKILLS

Comprehensive problem solving abilities, excellent verbal and written communication skills, Ability t deal with people diplomatically, ability t achieve targets and results, Flexible within the working environment,willingness t learn and share, Team facilitator.

EXPERIENCE PROFILE

Confidential

Asst.Systems Engineer.

Confidential

Programmer Analyst.

TECHNICAL ENVIRONMENT

• Database - Oracle 11g /10g,9i ,Teradata v2r6 .
• Database Utilities - SQL Loader , Oracle Data pump , External Tables.
• ETL Tools - Informatica Power center 9.x 8.x, Informatica Power Exchange
• Languages - SQL , PL/SQL, C,C .
• Scripting - Unix Shell Scripting.
• RAD Tools - TOAD ,SQL Developer ,SQL Navigator.
• Reporting Tools - Crystal Reports , Forms Reports6i.

PROFFESSIONAL SUMMARY

• 8 Years of Oracle Database project lifecycle experience and 4 years of Professional experience in Data warehousing Applications. This includes Data Design , Walkthrough, Development, Code Walkthrough, Application Tuning and Implementation.
• Extensively worked in Client-Server application development using Oracle Database 11g,10g,9i,8i,7, Oracle Forms and Reports 6i,5,4, Oracle Application Server 9i,6i, SQL, PL/SQL, SQL Loader, TkProf , Import, Export Utilities.
• Good Knowledge in Oracle RDBMS Architecture.
• Strong work experience in Oracle Backend programming and experience in managing Database related tasks.
• Experience in Performance maintenance and tuning, Optimization using Oracle Hints , Table Partitioning and PL/SQL optimization .
• Experienced in System Analysis, Design, Data modeling , administration and Implementation of business applications.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, Materialized Views, PL/SQL tables, Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Experience with data dictionary techniques, database normalization theory.
• Experienced in evaluating, reviewing and assisting developers create data models.
• Good knowledge on Informatica Power center and Informatica Power Exchange for Extraction Transformation Loading Mechanism.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager t move data from multiple sources int targets.
• Good Experience in ETL and Data Integration , Developing ETL Mappings and scripts Using Informatica Powercenter , Using Designer ,Repository Manager ,Workflow Manager Workflow Monitor.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling Star Schema and Snow Flake Schema .
• Experience on slowly changing dimensions SCD Type 1, and Type 2 methodology for accessing the full history of accounts and transaction information.
• Good Experience on workflow Manager and workflow Monitor for creating and monitoring workflows.
• Experience in creating Reusable Transformations Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank and Mappings using Informatica Designer and processing tasks using Workflow Manager t move data from multiple sources int targets.
• Extensively worked on developing and debugging informatica mappings , mapplets ,sessions and workflows.
• Good Knowledge on Unix shell scripting and autosys for scheduling the workflows.
• Complete analysis of all 13 applications and 40 components. This includes impact analysis and risk analysis.
• Writing a Unix shell scripts and test scripts t accommodate the applications int new server .
• Testing and Debugging of the applications on Productions .
• Performed tuning of SQL Queries and Stored Procedures for speedy data retrieval.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup Connected and Unconnected and Filter.
• Worked with production team t resolve data issues in Production database of OLAP and OLTP systems.

Environments - Oracle 11g , Unix ,Teradata, Informatica Power center 8.5

Confidential

Role : Sr Database / ETL Developer

Roles Responsibilities :

• Worked as the Onshore Lead Developer for the ICDW Offshore Development Team.
• Involved in Design, Development and impact analysis for the given requirements.
• Involved in writing Teradata Scripts and Views for Semantic Layer .
• Applied Security levels t each attribute on the view using Macros.
• Involved in writing a Teradata scripts such as BTEQ for loading data int Target table.
• Preparing Design Document and Pseud code for initiating the design model as per the standards.
• Implemented CDC by tracking the changes in critical fields required by the user.
• Delegating the task t the Team and preparing the check list for the same.
• Identified performance bottlenecks in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Preparing and using test data/cases t verify accuracy and completeness of ETL process.

Environment : Teradata ,SQL, Informatica Power Center 8.5

Confidential

Role - Oracle Developer

Responsibilities :

• Designing, Creating and Maintaining the Oracle Database Application Schemas for various applications . Responsible for resolving all the Oracle Database schema related issues on a daily basis.

Supportive role in the successful implementation of project which involved introducing clustered server environments for all applications.

• Responsible for application level security implementation using object privileges, system privileges, grants, roles, procedures and packages.
• Optimization of various SQL and PL/SQL Indexes, Hints and other basic tuning techniques.
• Responsible for leading and managing a Team.
• Created Shell scripts t generate oracle reports and send t e-mail.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Conducted PL/SQL training session for co-workers t educate about the latest PL/SQL features, PL/SQL performance tuning.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Integration of various data sources like Oracle, , Sybase, SQL server and MS access and non-relational sources like flat files int staging area.
• Made use of Post-Session success and Post-Session failure commands in the Session task t execute scripts needed for clean up and update purposes.
• Trouble shooting of long running sessions and fixing the issues.
• Actively involved in production support. Implemented fixes/solutions t issues/tickets raised by user community.

Environment : PL/SQL , Oracle 10g, Informatica 7.x,Unix

Confidential

Roles Responsibilities

• Design, Coding Implementation of the System.
• Design and development the Backend Procedures , Packages and Triggers for the application
• Testing and Debugging the application.

Confidential

Role -Oracle Programmer

Description : T migrate a data from Winterthur database AXA System Database as part of integration of Winterthur and AXA Belgium.

Responsibilities

• Responsible for Design, Coding Implementation of the System.
• Responsible for testing and debugging the applications.
• Responsible for Tuning the SQL and PLSQL code.
• Responsible for SQL tuning and optimization using AWRs and Explain Plans.
• Involved in implementing data migration with Oracle Stored Procedures, Functions using PL/SQL.

Environment : PL/SQL , Oracle 9i.TOAD,SQL Developer

Confidential

Description :PMT, was developed t monitor the Amount Receivable part from the customers as well as the Amount Payable t the Vendor at different phases Delivery / Installation / Satisfactory working . Systems was designed t generate reports such as Statement of Accounts for the Department as well as for the Vendor at any given snapshot.

Roles Responsibilities

• Responsible for Design, Coding Implementation of the System
• Responsible for designing the backend Procedures, Packages and Database Triggers for the applications.
• Responsible for application level security implementation using privileges, roles and table views.

Environment : Oracle 9i.,Windows XP,PL/SQL,SQL Developer,Toad.

Confidential

Roles Responsibilities

• As programmer analyst responsible for coding some of the modules such as
• Payroll Module , General Ledger Module , Stock Module and Sales Module.
• Design Forms and Reports for Software Application
• Various reports were generated at regular intervals for data analysis.

Environment : Oracle 9i.,Windows XP,PL/SQL,SQL Developer,Toad

SKILLS/STRENGTHS

• Calm and determined under pressure.
• Effective problem solver.
• Customer focused.