SUMMARY

• Around 8 years of IT experience in developing software applications using Oracle 11g/10g/9i and its products in wide range of applications including Manufacturing, Health care, Banking and Telecommunication applications.
• Solid experience working on Oracle 10g/9i/8i/8.0/7.x, Developer 2000/6i (Oracle Forms 6i and Reports 6i), PL/SQL, UNIX and Discoverer.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi - tier and client/server architectures.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.
• Designed database schema's using Entity relationship modeling with ER diagrams& database normalization principles.
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Experience creating Work Flow Dependencies in Informatica, Creating Mappings and ETL flows.
• Knowledge on Oracle Forms, Reports and Menus.
• Solid experience in writing and debugging stable and robust PL/SQL code, handling various kinds of Exceptions, SQL, Dynamic SQL, C, and UNIX Confidential scripts.
• Supported advance PL/SQL using Cursors, REF Cursors, and Native Dynamic SQL.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Implemented Autonomous transaction and Distributed transaction processing in PL/SQL, Non-Distributed transactions, Distributed transactions, Remote transactions.
• Moved columns of data into and out of database tables using PL/SQL program units by passing collections as parameters to program units.
• Experienced with SQL performance tuning and optimization using execution plans.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind (ForAll) features with Collections instead of using cursors and FOR loops, and DBMS PROFILER package and GET TIME in DBMS UTILITY package.
• Excellent analytical, verbal & written communication, interpersonal, team work skills and assertive leadership abilities with a high degree of professionalism and dedication to exceptional quality.
• Ability, willingness, and passion to learn new technologies and acclimatize to diverse work cultures.
• Solid managerial and administrative skills with good business understanding and excellent versatility and adaptability to manage multiple tasks.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading in a corporate-wide-ETL Solution using Oracle.
• Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.
• Enforcing data integrity using integrity constraints & database triggers.
• Good understanding of Oracle Data Dictionary and Normalization Techniques.
• Expertise in Database Design, Database programming and SQL.
• Experience in using SQL TRACE and TKPROF tools for SQL tuning.
• Extensively worked with Oracle Utilities like UTL FILE, DB Links, and FNDLOAD,TOAD, UNIX Confidential Scripting, Imports/ Exports and SQL * Loader.
• Self-motivated and enjoy working in a technically challenging environment.
• Ability to work under stringent deadlines within a team as well as independently.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, MS SQL Server 2000, DB2, MS ACCESS 2007

Languages: SQL, PL/SQL, C, C++, Java 1.4/1.5

Tools: TOAD, SQL Developer 3.0, Oracle Enterprise Manager 10g, SQL*PlusSQL*Loader, Oracle Forms and Reports 10g/9i/6i, Pro*C, Oracle FrameworkMS Office 2007, Open Office 3.3

Internet Technology: HTML 5.0, JavaScript, XML, PHP 5.0, CSS 3, DHTML.

Scripting: Unix Confidential Scripting, Java Script

Operating Systems: HP-UX 11.0,UNIX, Windows 95/98/2000/NT/XP/Vista and AIX

PROFESSIONAL EXPERIENCE

Confidential, New Orleans, LA

Oracle PL/SQL Developer

Responsibilities:

• Involved in creating detailed Functional Documentation, which includes all Business requirements and Technical specifications.
• Worked with the data conversions by application screens.
• Created data mapping files for the data coming from different web services.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• CreatedPL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application-usingTOAD.
• Used reports to display formatted data. Reports can be viewed in the database where they were Created or printed. Saved reports as snapshot files so they can be viewed outside an Access application.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
• Involved in Confidential scripts to automate the loading, balancing and extraction process.
• Involved in handling the changes in compiling scripts according to the database changes.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Verified the functionality of data in the front-end whether it is displaying properly or not.

Environment: Oracle Database 11g, TOAD, Microsoft Windows Server 2008 R2, PVCS, SQL, PL/SQL, Oracle 10g/11g, SQL*Plus, SQL*Loader, MS Office, Windows XP

Confidential, Cary, NC

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in full development cycle ofPlanning, Analysis, Design, Development, TestingandImplementation.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX Confidential Scriptsaccording to the changing needs of the project and client requirements.
• WroteUnix Confidential Scriptsto process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server sidePL/SQL scriptsfor data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• CreatedPL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application usingTOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*LoadercallingUNIX scriptsto download and manipulate files.
• Worked in Production Support Environment as well asQA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching betweenSQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthefact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objectsfor improving the performing.
• Createdrecords, tables, collections(nested tables and arrays)for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features ofPL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle Database 11g, TOAD, Microsoft Windows Server 2008 R2, UNIX, PUTTY, PVCS, WinSCP, SQL, PL/SQL, UNIX Confidential Scripting, Oracle 10g/11g, SQL*Plus, SQL*Loader, MS Office, Windows XP

Confidential, Grand Rapids, MI

Oracle PL/SQL Developer

Responsibilities:

• Involved as a key team member for Implementation of Affordable Care Act (ACA).
• Confidential is a regional Health Plan company in Western Michigan.
• Priority is modifying their claims process system (Facets) to implementing Affordable Care Act.
• Main responsibilities include developing a new process to generate Invoice extract as per new Federal regulations and Health care laws.
• At Priority Health the Data warehouse (ODS System) is updated on a nightly bases with Transaction system date (Facets).
• As part of the ETL team that is responsible for extracting the data from Facets, I was responsible for understand the business requirements to extract the data from Facets using PL/SQL coding.
• Responsible for developing the Informatica Mappings between Source system and Target system. I was responsible for debugging and making necessary changes to fix the issues.
• The ETL process flow was seamless as the instructions configured in the Mapping were precise.
• Complex project which involved understanding the whole existing business logic and various new health care regulations.
• As part of ACA development team I am responsible developing a new process to generate Invoice extract as per new Federal rules and regulations.
• Built new procedures to accomplish the functionality requested.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• This Invoice extract process extracts data from various Facets (Claims Processing System) tables.
• The code is developed in PL/SQL, with 9 packages, Cursors, triggers, various invoice extract application specific tables.
• Designed and extensively worked on Project Documentation using TWiki.
• Agile driven development. Constant Scrum meetings, interaction with the other team members to discuss on the roadblocks.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle Database 11g, TOAD, SQL Developer, Informatica Power Center, Informatica Mapping Designer, PUTTY, TWIKI, Cisco VPN, PL/SQL, Oracle 10g/11g,SQL*Plus, SQL*Loader, PUTTY, MS Office, Windows XP, Erwin, Tortoise SVN

Confidential, Winston Salem, NC

Oracle PL/SQL Developer / Forms & Reports Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Involved in writing backend Packages extensively in PL/SQL.
• Involved in Code Reviews and preparing Unit test cases.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards besides reviewing the code.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Actively Involved in Integration and Deployment in Production Environment.
• Customization of code as per the user requirements.
• Involved in the analysis of the existing database.
• Responsibilities included Oracle reports, Discoverer reports, packages, procedures, functions and custom tables.
• Designed and extensively worked on Project Documentation.
• Separating Tables and Indexes on different locations for reducing Disk I/O Contention.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Used Bulk Binds and Bulk Collect.
• Designed Pragma Autonomous Transactions.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle Database 11g, TOAD, Microsoft Windows Server 2008 R2, UNIX, PUTTY, PVCS, WinSCP, SQL, PL/SQL, UNIX Confidential Scripting, Oracle 10g/11g, SQL*Plus, SQL*Loader, MS Office, Windows XP, Oracle Reports 10g, Oracle Forms 10g

Confidential, Plano TX

Oracle PL/SQL Developer / ETL Data stage Developer

Responsibilities:

• Design Technical Specifications from Functional Specification (Detail Design) documents.
• Used SQL*Loader/Perl Script to load data from various sources into an Oracle database.
• Validated data using functions and procedures.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
• Wrote PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Created database triggers for data security.
• Verified coded logic by testing and correcting programs via unit tests.
• Involved in Integration test, System test and Implementation.
• Proficiently developed test cases in Quality Center.
• Extensively developed complex PL/SQL packages for Pricing.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test the mapping and fixed the bugs.
• Worked with pmcmd to interact with Informatica Server from command mode
• Applied Performance Tuning logic to optimize session performance.
• Attended business user sessions to make changes in warehouse loads.
• Developed UNIX Korn Confidential scripts to process file feeds.
• Involved in production support during deployment.
• Examined, reviewed, and/or changed code to adapt to changes in requirements.
• Developed Confidential scripts for batch processing and database transactions.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, Oracle Application Server 10g, PL/SQL Developer, TOAD, MS-Windows 2003, UNIX, PUTTY, PVCS, WinSCP, Unix Confidential Scripting, Quality Center, Oracle 9i/10g, SQL* Plus, PL/SQL, CVS Version Control, SQL SERVER 2005/2008, Microsoft Visual Studio, Erwin Data Modeler r7, Windows XP.

Confidential, CA

Oracle Developer

Responsibilities:

• Involved in Requirement Analysis and developing the Project Definition Document.
• Responsible for developing XML documents to generate SQL dynamically for all the business roles.
• Used XDB UTILITY packages to load XML documents into database tables.
• Worked with CLOB and LOB data types to load large XML documents into database tables.
• Responsible for developing PL/SQL database objects like Functions, Procedures and Packages.
• Developed a PL/SQL conversion program and SQL*Loader program for validating and migrating the legacy agents information into Oracle base tables.
• Involved in Performance Tuning of various custom PL/SQL reports and PL/SQL packages.
• Involved in migrating the application from Oracle Database 9i to Oracle Database 10g.
• Extensively wrote PL/SQL code to customize various forms pertaining to Contracts and data load.
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Used Dynamic SQL and autonomous transactions for error handling.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
• Developed UNIX Confidential scripts for job scheduling.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Conducted meeting with System Analyst to explain the application functionality.
• Debugged Packages, Procedures, and Functions and fixed them according to the business requirement.
• Tuned the existing SQL queries to improve the performance.
• Involved in the Data Modeling phase of the application.
• Used ETL tools like SQL Loader to load the flat file data into database tables.
• Also written UNIX Confidential scripts to automate the nightly data load from third party servers.
• Extensively involved with end users to make the enhancements.

Environment: Oracle Database 10g, SQL, PL/SQL, Oracle Reports, Oracle Forms, PL/SQL Developer, SQL* Plus, Windows 2000, Confidential / PERL Scripting, UNIX, XML, FTP, SQL*Loader, Discoverer 4i, Oracle 9i (SQL, PL/SQL), Oracle Developer Suite 10g, Oracle forms 9i/11g, Oracle reports 9i/11g, TOAD 9.0, Erwin 4.0

Confidential, South Carolina

Oracle PL/SQL Developer

Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Created numerous web based Forms and Reports using Oracle Developer 6i.
• Defined Editors, created List of Values and Record Groups in Oracle Forms 9i.
• Designed, developed and tested Reports using Report 6i and Discoverer 4i.
• Loaded traffic data logs into staging tables using SQL loader and Confidential scripts.
• Developed Forms, Packages, Triggers and Confidential Scripts to load the staging table data into Traffic Mart System.
• Writing scripts to create partitions, exchange partitions, analyze for performance tuning.
• Responsible Co-ordination with Client.
• Analyzing the Design and functionality.
• Developed packages, functions, procedures, database triggers as part of the ETL process.
• Worked with Star schema and Snow Flake schema.
• Used UTL FILE (file handler), DBMS JOB, DBMS ALERT and other utility built-in Packages in PL/SQL.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like tables, views, procedures, packages using SQL* Plus and PL/SQL.
• Performed Data validations and mappings at staging table level.
• Created Complex Dynamic / Static / Parameterized Reports and Charts using Report 6i.
• Assessed the efficiency of the SQL statements using SQL Trace and TKPROF.