SUMMARY

• Eight years of experience in Requirement Analysis, Logical & Physical Database Design, Development, Unit and System Testing, End User Training and Production Support.
• Strong database experience on Oracle 10G/9i/8i/8.0/7.3, PL/SQL,, SQL*Loader, Physical database design, Logical database design, Data Modeling (Designer 2000), Gap Analysis, Data Mapping, Cleansing, Massaging, Transformations, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning & Optimization.
• PL/SQL: 5 years of strong back - end programming experience using PL/SQL, SQL, MS SQL, T-SQL, Pro*C, C, C++, Java, VB, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
• Reports: Oracle Forms 6i/5.0/4.5, Oracle Reports 6i/3/2.5, Oracle Report Writer, Oracle Developer 2000, SQR 3.0.
• Forms: Strong experience with Forms 9i/6i/2000
• Databases: Oracle 10G/9i/8i/ 8.1.6/7.0.3 , MS SQL Server 7.0/6.5, MS Access 7.0, Sybase 12.x, DB2, Teradata V2R4/R5.
• Good experience with Oracle PL/SQL stored procedures and Triggers.
• Tuning: Experience with PL/SQL Stored procedure tuning and SQL tuning.
• Expertise in ETL process using Informatica (Power Mart / Power Center).
• Experience in Extraction, Transformation and loading using Informatica.
• Worked with Data Modelling both Physical & Logical using Erwin/ Designer 2000.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, Pro*C, Perl, Java, XML, Servlets, JSP, HTMLVB Script, UNIX (K/B/C)

Data Modeling: Designer 9i/2000, Erwin

ETL & BI Tools: Informatica ETL

Scripting: UNIX Shell & Perl scripting, SQL scripts, PL/SQL scripts

Tools: Designer 2000/9i, Erwin 4.0, Developer 2000/6i/9i, Query BuilderReports Builder, Forms 10g/9i/6i/4.5, Reports 2.5/6i/9i/10gTOAD, SQL*Plus, SQL*Loader, Explain Plan, Import/Export.

Databases: Oracle 9i/ 8i/8/7.x, MS-SQL Server, DB2, IDMS, AccessOperating System Sun Solaris, HP-UX, Windows 9x/2000/NT, DOS.

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

PL/SQL Developer

Responsibilities:

• Gatheird Business Requirements and assisted team in scripting Test Cases and formulated action plans to support teh business needs.
• Did review and testing of code to ensure dat teh code is functioning perfectly.
• Interacted with end users and functional architects for mapping teh legacy data to teh Oracle tables.
• Involved in testing all forms, PL/SQL code for logic correction.
• Designed and developed Informatica mappings to build business rules to load data. Extensively worked on Informatica Lookup and update transformations to implement complex rules and business logic.
• Studied teh existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for teh data mart.
• Developed custom reports for Payables to list out balances.
• Involved in creating alerts in form personalization.
• Developed a custom workflow for tracking service requests, and notifying users about teh status of these service requests.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Extensively used Export Import, Sql Loader, Toad, FTP.
• Teh data was loaded from various sources such as Text, CSV, SQL servers and other Oracle databases into Oracle database tables using SQL* loader, db links, materialized views.
• Extensively involved in using teh merge process to load teh data into teh target tables.
• Involved in uploading of teh data from flat files into Databases and validated teh data with PL/SQL procedures.

Environment: Oracle R12 10g, PL/SQL, Oracle Tuning, Stored Procedures, SQL* Loader, SQL*Plus, Windows, UNIX.

Confidential, KANSAS CITY, KS

Oracle PL/SQL Developer / Sr Programmer

Responsibilities:

• Developed a Client Management System to maintain client records and all insurance related transactions by using Oracle 9i as backend and Developer 9i with Form 9i as front end on Windows 2003 Advanced Server.
• All teh stations were running on Windows 98 SE, which had simple One-One mapping using a hub.
• Installed Oracle 9i Enterprise Edition with on Windows 2003 Advanced Server ..
• Designed teh database based on teh analysis done which had almost 8-10 database tables.
• Used SQL to define and manipulate database tables.
• Wrote database PL/SQL triggers and procedures to provide backend security and data consistency. Front-end trigger and procedures were created using PL/SQL on Forms 6.0.
• Reports were generated using Oracle Reports 6.0 to look teh customer information according to given date and also to get teh policy details such as policy number, expiration date and issuing date with teh renewal date.
• Perform routine database tuning and administration activities for several Oracle databases.
• This software had a capability of storing pictures in form of TIFF format and all teh proofs of insurance policy, which would link with teh associated client record.
• Database was later on migrated to Oracle 9i to enhance teh software capabilities to new web enabled features such as remote access. SQL * Loader was used to transfer all records to new Oracle 9i database.
• Perform routine database tuning and administration activities for several Oracle databases.
• Extensively worked on report attributes like Report triggers, Program units, Attached libraries and Built-in packages.
• Customized forms by writing block level triggers and item level triggers using Oracle Forms.

Environment: Oracle 9i, PL/SQL, TOAD, SQL * Loader, UNIX, Discoverer 10g, TOAD, Windows 2000, HP-UNIX.

Confidential, VA

Oracle PL/SQL Developer / Oracle programmer

Responsibilities:

• Responsible for teh System Study & Business Requirements Analysis & Documentation
• Extensively involved in writing shell script to Merge teh data from one instance to other instance for Policy and Claims tables.
• Extensively involved in loading teh flat files data into Oracle tables using SQLLoader while in teh Merge Process.
• Developed a system for data files of different formats from Mainframe systems to load into staging environments using SQL*Loader and tan used PL/SQL code to perform data transformations and implement business logic.
• Involved in Debugging teh PL/SQL procedures while merge process.
• Helped team members in various Oracle Warehouse Builder (OWB) mappings.
• Extracted Data from Various Source files, Flat files, Binary files& COBOL files using OWB.
• Designed and developed full life cycle for data loads about terabyte size Data Warehouses.
• ETL Migration process from legacy scripts using OWB for Data Conversions and data cleaning.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Policy data Import/Export, Policy data Conversions.
• Co-ordinated with DBA to enhance teh database features according to teh test database instances while merge task.
• Developed teh logic to re-startable UNIX shell script while error/failure situations for teh Merge Process.
• Responsible for Oracle System Administration, Database Migrations, Installations.
• Extensively involved in writing teh PL/SQL procedures for teh Billing and Cash data and Installments Data into target Confidential 's BI Database.
• Involved in extracting teh data from CPS system to load into Confidential 's BI Data warehouse.
• Extensively used Oracle's performance tuning techniques to fine tune teh Procedures and SQLs.
• Undated teh address records, using UNIX Sync Sort.
• Developed complex PL/SQL procedures for change data capture to handle million records.
• Scheduled change data capture packages & procedures on daily basis.
• Extensively used PL/SQL procedures to join and lookup processing to load teh warehouse data.
• Developed several SQLs to standardize data for converting dates and business rules to fit into Oracle format.
• Extensively developed UNIX shell scripts to FTP teh sequential files to send Pipe Delimited Sequential files from source to target environment.
• Provided technical documentation for mapping of source and target and flow of teh process.

Environment: Oracle 10G/9i/8i/8.0, Oracle Warehouse Builder 10.2/10.1.0.4 , Unix Shell Scripting, TOAD, Erwin, Windows NT 4.0, IBM AIX, OS/390, COBOL, JCL, change man.

Confidential

Sr Developer

Responsibilities:

• Responsible for teh design, development and import of invoice information into Oracle Receivables.
• Maintaining concurrent manager and assigning priorities.
• Creating users & modifying teh privileges for users. Creating appropriate roles and assigning it to users.
• Migrated teh data from excel sheets, text files into teh respective Oracle Database tables using SQL *Loader scripts.
• Loaded data into oracle tables using SQL*Loader and dbms utility package.
• Responsible for customization of reports according to client requirement in key indicator report and Distribution detail report like Account Status Report, Transaction Detail Report, etc.
• Created teh data flow diagrams using Microsoft Visio.
• Registration of new forms, Creation of concurrent executables and concurrent programs for reports, Opening up Descriptive Flex fields.
• Written scripts to customize customer needs.
• Extensively worked in teh scheduling and monitoring of mappings in Information Warehouse.
• Extensively worked in teh analysis and tuning of teh Application code (SQL).
• Monitor all teh Production, System Test and developments boxes for any errors in teh logs and fix them as needed.
• Was responsible for tuning teh SQL statements using Explain Plan, SQL Trace, TKPROF, Clusters and Optimizer Hints.
• Used UNIX shell scripts to run teh batch PL/SQL procedures.

Environment: Oracle 8i, SQL*Loader, Developer 2000, PL/SQL.