SUMMARY

• 8 years of experience in the development of client/server and multi tired applications using Oracle Database, SQL, and PL/SQL on different platforms like Windows NT/2000/98/95./XP, UNIX.
• Extensive experience in the database analysis, development and maintenance of business applications using Oracle 11g,10g, 9i, 8i, PL/SQL Developer.
• Excellent understanding of the software development lifecycle (SDLC).
• Expertise in developing SQL, PL/SQL scripts in oracle distributed environment.
• Experience in Database design using Normalization and E/R diagrams.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views and Table Partitioning.
• Worked with data transformations and loading using Export/Import file packages and SQL* Loader and also created external tables to manage data which is stored at the operating system.
• Created Instead of triggers for updating join views with DML operations.
• Created Global temporary tables to maintain session data and improved the performance of data retrieval and created views, indexes, triggers on them.
• Expertise in Oracle Stored subprograms, Packaged subprograms, Cursors, Cursor Variables, Collections, Triggers, Native Dynamic SQL.
• Experience in Data Extraction, Migration Transformation and Error handling.
• Extensively used oracle tools like TOAD and SQL Navigator.
• Knowledge in Data modeling forData Warehouse/Data Martdevelopment, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.Created
• Experience in Data Migration processing including data loading from flat files to the database tables using SQL*Loader.
• Experience in OLTP like Oracle, SQL server.
• Expertise in RDBMS development including Oracle SQL, PL/SQL database backend programming with stored procedures, Functions and packages.
• Experience in writing complex SQL Queries, created materialized views.
• Expert in Export, Import and SQL*Loader Utilities.
• Experience in data extraction, data migration and Data loading.
• Excellent communication and interpersonal skills, with the ability to manage responsibilities individually or as part of a team environment.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, SQL*PLUS, Export/Import, SQL*Loader, Erwin, Epic ER modeler, MySQL.

Languages: SQL, PL/SQL, C, C++, Java, HTML, XML

Tools: TOAD, SQL Navigator, SQL*Plus, SQL Loader, SSIS

Operating systems: Windows XP/NT/2000/98/95,Windows vista, MS DOS, UNIX,, Oracle Enterprise

Office Tools: MS Word, Excel, Power Point, Visio

Others: Object Oriented Designing Methodology, RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr.Oracle Developer / Sr.PL/SQL Developer

Responsibilities:

• Gathered and analyzed requirements from business analyst.
• Created database objects like tables, synonyms, sequences, triggers, and views.
• Created, edited procedures and functions for improved business requirements.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
• Conducted impact analysis and designed structures to enhance performance.
• Involved in data cleaning, merging and conversion.
• Modified tables, synonyms, sequences, views, stored procedures and triggers.
• Generated SQL and PL/SQL scripts to create and drop database objects.
• Enforced constraints for data validation.
• Pro - actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Fixed performance issues and bugs with packages and stored procedures using explain plan.
• Created B-tree and Bitmap indexes.
• Created ETL mechanism to transform the data from OLTP source to the newly created OLAP model.
• Loaded flat file using as SQL *LOADER into database.
• Used TOAD & SQL Developer for debugging application.
• Written cursors and REF Cursors for transaction processing.
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Developed RDBMS including PL/SQL database backend programming with stored procedures, Functions and packages
• Implemented database triggers based on the business rules and requirements.
• Assisted in Functional Requirement Specification & Use Case Diagrams to streamlining the business flow.

Environment: UNIX, Oracle 10g/11g, PL/SQL, Sun Solaris 5.8, Oracle SQL Developer,Informatica 8, VI Editor, MS SQL 2005, HTML, Toad, MS Visio 2005.

Confidential, San Diego, CA

Oracle PL/SQL Developer

Responsibilities:

• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Created tables to capture errors and data that failed Validation Checks.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in Staging and Destination schemas.
• Used direct path loading via SQL*Loader/ SQL INSERT statement, create table as select statements, table spaces, parallelized SQL statement execution where appropriate tables.
• Developed a package with stored procedures, functions and database triggers for transferring the date from Source to warehouse.
• Developed dynamic SQL used in procedures and function for the data extraction and loading process.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Created dynamic procedures to drop and create Index for the Staging environment to facilitate faster loading of data.
• Developed RDBMS including PL/SQL database backend programming with stored procedures, Functions and packages
• Involved in Tuning SQL queries using Explain Plan and Tkprof utility to improve performance of the queries.
• Created the documentation for explaining all the process involved in the ETL mechanism.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL to test the model.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Involved in the database administration and creating objects such as database, users, schema and table spaces.
• Involved in managing security, granting and revoking privileges on database objects.
• Tested the ETL process in testing environment and created test cases

Environment: Oracle 9i, 10g,11g, Oracle Data Modeler, Oracle SQL Developer, Informatica 8, Erwin, Sun Solaris, Windows 2000, MS Outlook 2007,MS Office 2007.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed all business functionality related to back-end database interfaces and utilized PL/SQL developer tool in developing all back-end database interfaces.
• Designed the conceptual, logical and physical model according to the requirements using Erwin.
• Worked on Logical and Physical Data Modeling to gather the business requirements and convert them into models and design the databases.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Used UTL file in packages to read/write the data from/to a flat file and SQL*Loader for migrating flat file data into target.
• Involved in OLTP Process.
• Created tables using Toad as well as created and managed roles for different users to access database objects.
• Written various Triggers, Stored Procedures to perform or automate many of the tasks.
• Optimized SQL queries used in Reports and Stored Programs (Procedures, Functions and Packages) to improve performance drastically.
• Created Database Triggers, bypassing the mutating table errors, use of row and statement level triggers for advanced auditing of changes made to a table and Oracle Functions and Procedures to centralize the business logic in the database.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries
• Develop the supply chain management application go-live support environment, construct the transition plan from the project team to the support team, and support and maintain the client applications and technology infrastructure
• Monitored the Performance during Beta - Testing phase of the application.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets.

Tools: and Technologies: Oracle 10g (PL/SQL),11g, SQL*Loader, MySQL, UNIX, Toad 8, Crystal Reports XI/8.5 Designer 2000, Windows 2000, Erwin 4.1,MS Excel 2007, Windows 2008 Server.

Confidential

Oracle Developer / PL/SQL Developer

Responsibilities:

• Intrinsic Cleansing (Basic Data Cleansing, Removal of Duplicate Items in Master Data, New Items Appending, Inactive Item Exclusions, Vendor Name Standardization).
• Data Enrichment (Item Details Enrichment, Modular Item Descriptions, Item Attributes, Vendor Information Update Vendor Parent/Child Hierarchy) through PL/SQL stored Procedures, functions, packages, and triggers.
• Generation of Price Parity Reports for the Hospitals and writing stored Procedures, functions for the same according to the Client requirement.
• Creation of Database and location of initial data files, redo log files, control files and multiplexing them editing database initialization parameter files.
• Creating users, roles, profiles, assigning roles and profiles to users. Creating table spaces, Data files, Log files and control files.
• Used direct path loading via SQL*Loader/ SQL INSERT statement, CREATE TABLE AS SELECT statements, table spaces, parallelized SQL statement execution where appropriate tables.
• Create queries and other SQL scripts for test execution and execute them against SQL Server databases
• Involved in ETL process and evaluated different strategies and approaches for optimal performance of the process. Automated ETL loads, Back-up, Recovery
• Involved in development, enhancement and maintenance of PL/SQL interfaces.
• Have knowledge in supply chain management.
• Provided complete operations services for Supply chain application management, custom development, and business process outsourcing for clients.
• Performed SQL and Procedures tuning to maximize performance
• Prepared test data, test cases. Developed and executed test cases using SQL queries.
• Expertise in deriving test requirements from UML analysis such as use cases.
• Have performance testing experience and be able to devise strategies for test automation.
• Designed and created appropriate Indexes on tables and materialized views.
• Involved and interacted with clients for requirements gathering, tracking requirement changes and building functional test scenarios.

Environment: Oracle 9i, SQL *Plus, Golden, HTML, Windows XP, Benthic Software, SQL Query Analyzer, SQL*Loader, Microsoft Excel, J2EE, Java, JavaScript, Manual test process.

Confidential

Oracle Developer

Responsibilities:

• Developing control files, SQL*Loader scripts, Oracle import and export scripts for data loading and backup of Oracle data
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers
• Worked on tickets to fix the issues reported by the end users
• Optimized the performance using PL/SQL table types and record types
• Involved in designing the data model (logical/physical) by creating new objects and by using existing objects of the data mart as per the business requirements
• Developed SQL scripts for Extraction, transformation and Loading of Data and designed source Entities for Oracle
• Generating software upgrade scripts for cross functional teams
• Heavily involved in writing Test Cases and Unit Analysis and Testing (UAT) to test each and every logical branch of the stored Procedure.
• Responsible for Developing the New Reports using Reports 10g.
• Developed Discoverer workbooks and work sheets for reports.
• Involved in trouble shoots Discoverer tool related issues and limitations in Desktop Version.
• Wrote SQL queries to developed test data for use during test execution
• Worked on complete SDLC(Software Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
• Participated in meetings to gather functional and non-functional requirements with experts and end-users
• Generated various reports using Reports 6i like loan reports, savings report, fixed deposits etc
• Analyzed the performance of the SQL queries and created the scripts for indexes

Environment: Oracle 9i, SQL, Reports 10g, Discoverer 9.i,WINDOWS XP, SQL,PL/SQL, SQL *Loader, Toad, PL/SQL Developer, Oracle d2k forms and reports