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

SQL Developer

Responsibilities:

• Gathered Business Requirements and assisted team in scripting Test Cases and formulated action plans to support the business needs.
• Did review and testing of code to ensure that the code is functioning perfectly.
• Interacted with end users and functional architects for mapping the legacy data to the 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 the existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for the 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 the status of these service requests.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Extensively used Export Import, Sql Loader, Toad, FTP.
• The 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 the merge process to load the data into the target tables.
• Involved in uploading of the data from flat files into Databases and validated the 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 the 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 the database based on the 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 the customer information according to given date and also to get the policy details such as policy number, expiration date and issuing date with the 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 the proofs of insurance policy, which would link with the associated client record.
• Database was later on migrated to Oracle 9i to enhance the 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 the System Study & Business Requirements Analysis & Documentation
• Extensively involved in writing shell script to Merge the data from one instance to other instance for Policy and Claims tables.
• Extensively involved in loading the flat files data into Oracle tables using SQLLoader while in the Merge Process.
• Developed a system for data files of different formats from Mainframe systems to load into staging environments using SQL*Loader and then used PL/SQL code to perform data transformations and implement business logic.
• Involved in Debugging the 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 the database features according to the test database instances while merge task.
• Developed the logic to re-startable UNIX shell script while error/failure situations for the Merge Process.
• Responsible for Oracle System Administration, Database Migrations, Installations.
• Extensively involved in writing the PL/SQL procedures for the Billing and Cash data and Installments Data into target Confidential 's BI Database.
• Involved in extracting the data from CPS system to load into Confidential 's BI Data warehouse.
• Extensively used Oracle's performance tuning techniques to fine tune the Procedures and SQLs.
• Undated the 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 the 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 the 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 the 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 the design, development and import of invoice information into Oracle Receivables.
• Maintaining concurrent manager and assigning priorities.
• Creating users & modifying the privileges for users. Creating appropriate roles and assigning it to users.
• Migrated the data from excel sheets, text files into the 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 the 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 the scheduling and monitoring of mappings in Information Warehouse.
• Extensively worked in the analysis and tuning of the Application code (SQL).
• Monitor all the Production, System Test and developments boxes for any errors in the logs and fix them as needed.
• Was responsible for tuning the SQL statements using Explain Plan, SQL Trace, TKPROF, Clusters and Optimizer Hints.
• Used UNIX shell scripts to run the batch PL/SQL procedures.

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