Professional Summary:

• Around 13 years of Software lifecycle experience in application software design, development, testing and implementation.
• Extensively worked on Backend Programming using PL/SQL Stored procedures, Packages, Database.
• Experienced in working on Oracle 11g/10g/9i database systems.
• Expertise in creating stored procedures, triggers, functions, packages, views, PL/SQL Collections and optimizing query performance
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views Query Re-Write.
• Extensive experience with Oracle 11g which includes Bulk Collect and Bulk Bind. Experience in Performance Tuning using various types of Hints, Partitioning and Indexes, Used Explain Plan to monitor execution path and to decide on which hints to use.
• Experience using Bulk processing, ETL operations, REF cursors.
• Strong Working Knowledge in Oracle's built in Packages.
• Working experience in Customizing, Bug Fixing and Source Code maintaining of Oracle Database, Oracle Forms and Reports.
• Extensive experience in ETL for Data Extraction, Transformation and Loading.
• Broad Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built-in Functions.
• Analyzed Source Systems, Business Requirements, Identify and Document Business Rules for Decision Support Systems.
• Strong understanding of Data Modeling Relational, dimensional, Star and Snowflake Schema , Data analysis, implementations of Data warehousing using Windows and UNIX.
• Experience with AGILE Methodologies.
• Experience on Logical / Physical Data Models, Conceptual Design Data Architecture using Oracle Designer and ERWIN Data Modeler.
• Good experience in UNIX shells scripting with sh, bash, csh and ksh shells.
• Efficient in writing complex SQL queries, hierarchical queries, use of analytical functions, regular expressions.
• Experienced in data migration techniques using Oracle External Tables, SQL Loader, Import/Export and batch processing.
• Experienced in scheduling the jobs using AutoSys and Crontab and monitor the batch processing.
• Knowledge in VB.NET, C .NET, ASP.NET, HTML, JavaScript, VB Script QTP and Crystal Reports.
• Experienced in backend database development using tools SQL PLUS, Oracle Designer, Oracle TOAD and SQL Developer.
• Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases.
• Excellent interpersonal skills, team player and ability to work well with all levels of an organization with effective presentation, verbal and written communication skills.

Technical Skills:

• Operating System : Win 2000/NT/2003 server, Solaris 2.5 9, Red Hat Linux 8.0
• RDBMS : Oracle 11g/10g/9i/8i, MS-SQLSERVER 2008/2005, MS Access.
• ERP : Oracle applications release 10.7
• SC/11.03/11i/12. AR/AP/GL/OM/OE/PO/INV
• Database Tools : SQL Plus, TOAD, SQL Developer, SQL Loader, SQL Navigator,
• Oracle Forms and Reports 9i/10g , MSSQL Server Management.
• Studio, SQL Server 2005 Query Editor and Reporting Server.
• Testing Tools : Quick Test Professional QTP , Quality Center, LoadRunner.

EXPERIENCE

Confidential

Role: Sr Oracle Developer

Responsibilities:

• Designed and Developed ETL process for ECC/Purge process.
• Is the Primary Developer for projects for Support Maintenance projects : ECC/RPM/PTS/MYPO/CCC/FAQ/GOPOST
• Worked in the data migration.
• Created the Shell scripts for Inbound and Outbound files for Ctrl M.
• Created the Materialized Views/Procedures/Triggers/Packages based on the business requirements for Microstratergy reports.
• Tuned the long running queries in the application, In order to better perform the application.
• Responsible for management of complete software development efforts and applying project management best practices.
• Responsible for the design of data model and underlying features of the software.
• Development and maintenance of comprehensive set of PL/SQL scripts for maintaining data integrity and periodic data cleanup
• Extensively worked on writing complex SQL queries cursors, ref cursors, sub queries, correlated sub queries . Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
• Worked with multiple vendors to facilitate integration of systems during merger. Effectively documented and archived historical data for future auditing purposes. Responsible for production support and troubleshooting production issues. Experience working with huge database size of 5-10 TB.
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade. Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms.
• Implemented various automated UNIX shell scripts to invoke pl/sql anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
• Involved in implementing table partitions using Range, Hash, Composite techniques.
• Refresh the development and test databases using export/import utilities.
• Work with the executive team and clients to identify requirements and finalize the scope of the product and project.
• Involved in documenting the existing architecture of the projects.
• Involved in creating the generalized scripts for data partitioning, which were deployed across all the clients with minimal efforts.
• Performed SQL and PL/SQL tuning and Application tuning using EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE tools.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Improved the performance of the slow SQL queries by implementing indexes, using FORALL and BULK COLLECT.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding
• Created and modified several PERL Scripts according to the changing needs of the project and client requirements.
• Debugging the scripts and jobs written in RHEL/ UNIX Shell and PERL on Development and UAT Server.
• Worked extensively in UNIX Shell scripting to load the data in to the Staging tables thru SQL Loader handling multiple flat files.
• Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
• Involved in Impact analysis of the defects to the associated functionalities and modules in the Production environment.
• Worked with product managers to give work estimates and advised on design.
• Troubleshooted, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Provided 24 7 on call support to production environment.

Tools and Technologies:Oracle 11g, PL/SQL.SQL Loader, Toad 8.5, UNIX

Confidential

Role: Oracle Developer/Technical Business Analyst

Responsibilities:

• Worked extensively on PL/SQL Packages, anonymous PL/SQL blocks, functions and procedures.
• Involved in BASEL-II Risk Management Program using Oracle Reveleus tool.
• Was involved in Mortgage String testing, E2E testing and Production Emulation cycles.
• Involved in analyzing the Mortgage Bace Id's required for Capital calculator.
• Used OBIEE reporting tool to customize regulatory reports.
• Involved in writing Mortgage E2E test cases for validation of End reports.
• Validated FFIEC, RWA and Data Quality Reports related Mortgage work stream through DB and also from business perspective and managed the defects in QC for better resolution.
• Keep Track of all the defects related to Mortgage data flow starting from Source system's to Capital Calculator End Reports.
• Worked on Data profiling for Latin America loan and Lease contracts.
• Identified test data for unit testing Oracle Reveleus rule configurations and scorecards.
• Performed data loads using SQL Loader into Development and testing regions.
• Modifying the Stored procedures, functions and Data Base objects with respect to the business requirements.
• Involved in performance tuning of the queries which are already existing.
• Developed complex queries for data retrieval.
• Create Test Plans, Test Cases and perform unit and integration testing.
• Performance tuning of code using Pipelined Functions, Ref Cursors, Records and Collections.
• Worked extensively on Sub-Queries and Correlated Sub-Queries, Dynamic SQL and Union Queries.
• Created Materialized views to generate BIL reports.

Tools and Technologies:Oracle Reveleus, OBIEE, Oracle 9i/10g R2/11g, Sql Developer, HP QC 10.00, Erwin, Windows XP

Confidential

Role: Sr. Oracle Applications Developer

Responsibilities:

• Wrote Technical MD70 design documents and Conversion Mapping Documents for various interfaces.
• Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
• Developed and Customized Supply Chain, Manufacturing and Financial modules OM, INV, AR, WIP , Interacted with end users to gather requirements and Draft specifications for development Phase.
• Developed a Custom API to load ATO, Standard Sales Order lines from custom order entry application, using Configurator data to link top model, option and shipment lines.
• Invoked Standard API's within custom packages for creating and updating customer accounts, account sites, account site uses, customer relationships, customer profiles, and contact in Account Receivables.
• Responsible for development and trouble shooting of custom internal requisition process Internal Sales Orders and Drop Ship Order processes.
• Responsible in developing API's for items, item categories, item catalogs, material transactions, material statuses ,item costs , item locators and item on-hand in Inventory.
• Designed and involved in Development and Testing of a Custom program to link child and parent Work Orders in WIP, the custom package helped in design of work order report as per requirements
• Responsible for Supporting Day-to-Day activities.
• Understanding the implementation customization and consolidation of requirements and providing solutions for the issues raised by the business users, which includes oracle application setups, solving problems and handling request in Finance, Distribution and Manufacturing modules
• Developed Prides Customer Pricing Reports to list pricing for all finished goods specific to individual customer.
• Developed report to display on hand quantity and average quantity details of the items with in a particular duration.
• Customized Workflow to Automate shipsets and fulfillment sets to associate line items to the configured line.
• Involved in Software Development Life cycle starting from requirements gathering and performed object oriented analysis and design to implementation maintenance
• Development and customization of new forms and reports as part of support initiative.
• Tuning the long running jobs in Production and achieved performance improve of 90 .
• Raising SR's with Oracle to resolve Oracle issues.
• Responsible for creating and modifying the PL/SQL Procedures, Functions according to the business requirement.
• Created database objects like views, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.
• Wrote and modified Oracle PL/SQL, SQL statements procedures and functions that are called in the Java Scripts, JSP and EJBs.
• Created PL/SQL Procedures that can be called from the Web FOCUS procedure using SQL pass thru statements.
• Extensively used PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Performed SQL tuning using Explain Plan, TKPROF, Hints and indexes.
• Created and executed test cases. Ensured bugs are logged and tracked through closure.
• Proficient in using the UNIX vi editor.
• UNIX Shell Scripting to automate procedure execution from UNIX box.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages
• Extensively involved in tuning SQL queries used in the applications to improve performance.

Tools and Technologies: Windows NT, UNIX, Java, FTP, XML, Oracle Applications 10.7/11i, Oracle9i/10g, PL/SQL, SQL, TOAD, HP QC 10.00, Erwin, Developer2000 Reports6i and Forms6i .

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Installed and configured Oracle 10g using Oracle Universal Installer on Windows platform.
• Written Back-end PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using TOAD. And Unix Scripts for Automation of Unix jobs
• Used Cursor Variables to pass query results sets between PL/SQL programs and client application.
• Worked extensively on various kinds of queries such as Sub-Queries, Correlated Sub-Queries, Dynamic SQL and Union Queries and concentrated much on Query tuning, also worked extensively on hierarchical queries.
• Worked on data migration from SQL Server to Oracle 9i.
• Wrote SQL statements to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity.
• Used Oracle features like Global Temporary tables, Analytical functions, and Table functions.
• Created ad-hoc queries and stored procedures for generating reports-.
• Writing UNIX Shell Scripts to automate load process, Scheduling batch jobs in Crontab.
• Wrote SQL code to create JOINS, VIEWS on various tables. Worked on external tables and global temporary tables.
• Worked on DBMS packages like DBMS UTIL, DBMS PROFILE, and UTL RAW.
• Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema.
• Created indexes to large tables for tuning and wrote SQL scripts utilizing indexes for better performance.
• Created SQL, PL/SQL programs to retrieve data using cursors and exception handling.
• Worked on Partitioning and Indexing concepts on partition tables
• Involved in Extraction, Transformation and Loading ETL process of populating data into the database.
• Developed forms, menus, Object libraries and PL/SQL libraries using Oracle Forms 9i.
• Documented the whole process flow, PL/SQL Packages, log files, locations and description, log tables and possible error messages, process codes and description.
• Created Developer's Documentation and User's Manual.

Tools and Technologies: Oracle 8i, SQL, PL/SQL, SQL Loader, Forms, Reports, Oracle Enterprise Manager, UNIX Shell Script, Windows NT.