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.
• 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 Systems : 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 , QualityCenter, LoadRunner.

Experience

Confiaential

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
• 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.

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

Confiaential

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 DB 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

Confiaential

Role: Sr. Oracle Applications Developer

Responsibilities:

• Interacted with users in implementing Order Management, WSH QP modules.
• Involved in the team for setting up different setups like Pick Slip Grouping Rules, Release Sequence Rules, Release Rule, Ship Confirm Rules, and modifier for freight and special charges etc.
• Responsible for Order processing at different stages which includes Booking, Hold Release, Pick Release, Move Order, Ship confirm, Interface Freight Charges, Close trip using Interface Trip Stop SRS OM INV , progress invoice eligible orders using Work Flow, Interfacing to Receivables, Complete Line Work Flow and Complete Order Work Flow .
• Customized Pick Release API to launch custom program instead of Pick Slip report
• Customized Order Header Work Flow to close orders on next day
• Responsible for integrating the oracle apps open orders with Production Planning Database for a batch which runs along with Oracle standard Pick Release Program.
• Responsible for design and development of Shipping Freight charges interfaces for the deliveries ship confirmed in Pride Production Planning Control system. Several Oracle API's are used in this process to split line, update shipping attributes, delivery action, and create/update freight costs
• Responsible for creating RMA Orders from Pride Tech Service Module
• Created a program to cancel order/order lines from Pride Production Planning Control using Process

Confiaential

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 9i/10g, SQL, PL/SQL, SQL Loader, Forms 9i/10g, Reports 9i/10g,Oracle Enterprise Manager, UNIX Shell Script, Windows NT.