Professional Summary

• Over 10 years of IT experience in Oracle SQL and PL/SQL, External tables, SQL Loader, Oracle Apps, Workflow, Informatica, MS SQL Server, SSIS and SSRS. Experienced Techno Functional with focus on Business Requirements Analysis, Implementation, Application Design, Upgrade, Coding, Development, Set ups, Testing and support of Business applications using RDBMS, Oracle Applications for different clients.
• Having excellent analytical and problem solving skills. Has strong ability to learn new technologies in a short span and implement independently.
• Excellent at writing Functional specification and technical design documents Including MD50, MD70 .
• Excellent skills in writing Oracle SQL, PL/SQL Programs Procedure, Function, triggers Packages and performance tuning.
• Experience in advanced PL/SQL constructs like Oracle supplied Packages, Nested tables, arrays, Records, Types, Dynamic SQL.
• Extensive knowledge on oracle dictionary views and standard sys packages
• Experience in Query Optimization, Debugging, Tuning and improvising database performance, using the Oracle AWR, partitioning, parallel, Hints, Explain plans, Bulk collects, bulk binds, TKPROF, SQL Trace and Indexing etc.
• Experience in working with External table, SQL Load and Oracle Import/Export utility
• Excellent skills in writing T SQL Programs Procedure, Function and triggers .
• Excellent skills in Forms, Reports designing and Development.
• Excellent skills in Interfaces, Conversion and extractions.
• Having work Experience in Oracle Apps Modules OM, AP, AR, PO, GL
• Experienced in designing database models from ground-up and implementing complete flow.
• Having knowledge in SQL Administration tools.
• Having strong working Experience in SSIS and SSRS.
• Having strong working Experience in Informatica.
• Having working experience of Master Data Management MDM implementation.
• ERWIN: Used Erwin during physical modeling stage of system design.
• Visio: Used Visio during logical modeling stage of system design.
• Version/source code control tools - PVCS, Kintana and Perforce.

Technical Skill Set:

Employer: Confidential

Client : Confidential

Description:

Confidential software automates the modeling, design, administration, reporting and analysis of pay-for-performance programs for organizations ranging from hundreds to hundreds of thousands of sales people. Our customers use Confidential to design, test and implement sales compensation plans that reward based on the profitability of the sale, discourage excessive sales discounts, encourage team selling, and promote new product introduction or other sales activities that customers wish to encourage.

Role : Technical Consultant: ETL and Oracle PL/SQL Developer.

Responsibilities:

• Discussing the custom requirements from the client..

• Working on data analysis and digging to find out the dependent fields for transformations and manipulations of data.
• Involved in developing the various informatica workflows for validating and pulling the data from different source systems to the Confidential database.
• Involved in developing the workflows for validating the manual files and upload to the Confidential database.
• Created Workflows to generate the CDR, CDX files after the PIPELINE process completion.
• Involved in designing BO reports and extensive experience in creating the report publications.
• Good working knowledge on importing the reports, creating the folders, groups, users, and profile setup in CMC.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Extensive use of SQL commands with TOAD environment to create target tables.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Extensively worked in Performance tuning of custom PL/SQL programs.
• Code check-in and check-out in Perforce.
• Code deployment in the various environments.
• Technical documents preparation for CR's

Environment: Callidus Confidential 7.0, Oracle11g, Informatica 9.1.0, Business Objects 12.14.1, Unix, Perforce

Description:

Confidential is a custom application built within the systems infrastructure at NetApp to enable the Sales Team for the business processes like Hierarchy Management, Territory Goal and Forecast Data Management, Compensation Plan Data Management, Participant Data Management, Goal Sheet Administration and Reporting Management.

Role : Technical Consultant: Oracle PL/SQL database Developer

Responsibilities:

• Gathering Requirements from the Business users and reviews.

• Working on data analysis and digging to find out the dependent fields for transformations and manipulations of data.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Extensive use of SQL commands with TOAD environment to create target tables.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Designed, developed, debugged Packages, triggers, views, tables, indexes, pipe functions, types. optimized SQL and PL/SQL code to reduce CPU Overhead Buffer cache LIO reads , Disk read PIO and to find out the elapsed time due to wait events contentions that are impacting performance using Explain plan Oracle plan execution , SQL trace, TKprof, Hints, V Performance views, Analytical functions and parallel techniques.
• Optimized the performance using PL/SQL table types and record types.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints.
• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Extensively worked in Performance tuning of PL/SQL programs.
• Code check-in and check-out in Perforce.
• Code deployment in the various environments through WebLogic.
• Technical documents preparation for CR's

Environment: Oracle11g, JEE, Struts, spring, BO 12.1.0, Web logic 12.1 Application servers, Apache server, Unix, Perforce

Client : Confidential

Description: Confidential is support project with the technologies Oracle Apps, Oracle 10g, SAP and Informatica, Project is divided into three tiers viz SAP, Oracle-track and Shared services. Leap is ERP application and Confidential is reporting datawarehouse for Leap.

Role : Technical Consultant: Oracle PL/SQL database Developer

Responsibilities:

• Gathering Requirements from the Business users and discussed on technical feasibility.

• Enhancing and tuning the PL/SQL packages, procedures and functions.
• Change Requirements Servicing, Bug Fixes, Testing and Integration and releases of the enhanced programs.
• Involved in Unit testing and System Integration testing for PL/ SQL Stored Procedures and Functions.
• Responsibilities include Data loading job i.e. loading GL INTERFACE table from a flat file.
• Loading data from flat files into database tables using SQL Loader.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process.
• Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints.
• For version control and sharing file utilized PVCS.
• Technical documents preparation for CR's

Environment: Oracle10g, Oracle Apps PO, AP, AR, GL , Workflows, Unix, Oracle Reports, Informatca, Perforce.

Client : Confidential

Description: Confidential is the application for managing revenue deferrals related to non-standard deals, all deals or transactions having compliance terms, which require a revenue deferral, a revenue transfer, or an invoice hold of at least Confidential must be maintained in Confidential. The Confidentialthreshold is cumulative per deal and can be incurred over a period. Confidential is the enhancement to the existing Confidential application.

• Overall, the Confidential application strives for greater automation, leading to less manual work, greater scalability, greater flexibility, reduced costs and less probability of human error.
• The solution is based on the Oracle and ADF includes the below application software, group by process in scope

Role : 1. Architect Solution Engineer ASE : Oracle Apps and PL/SQL Developer

Responsibilities:

• Analyzed and discussed the business requirements with the clients.
• Responsible for the analysis, designing and coding of the database.
• Designed Technical Design Document for Revenue Transfer, Loss Provision, Manual Posting and Profile Linkage functionalities.
• As SME/POC of the module, managed a team of 5 personnel for the development of the database, procedures, and functions for Revenue Transfer, Loss Provision, Manual Posting, Profile Linkage and Profile Alerts functionalities.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Experienced in Bulk Collect, Dynamic SQL, PL/SQL Collections and Exception handling.
• Good Knowledge on CCRM over all functionalities and new enhancement in NGCCRM.
• Involved in creating the PL/SQL procedures and functions for data migration from CCRM to NGCCRM for MBA module.
• Involved in development of Interfaces EDI for MDM to NGCCRM.
• Involved in development of Interfaces EDI for NGCCRM to RAE Revenue Accounting Engine and RAE to GL.
• Developed Interfaces EDI for GL-post updated to RAE and RAE to NGCCRM.
• Participated in Technical Design Document Reviews with Client.
• As part of CR's analyzed, designed and developed the new functionalities for Non-buy sell part of Manual Posting, Loss Provision and Revenue Transfer.

Role: 2. Business Analyst: As part of Client Engagement Team CE Analyzed and Prepare FSD on assigned functionalities

Responsibilities:

• Involved in Hold Capability Reviews with Client.
• Participated in Business Requirements Reviews with client.
• Participated in Analyzing Business Requirements with client.
• Designed Functional Specification Document for Manual Posting, Loss Provision, Profile Linkage, Revenue Transfer and Profile Linkage Profiles Alerts Functionality.
• As part of CE team work involved in the FSD review meetings with the client and hosted the reviews.
• Identified and Proposed Interface design for Revenue Transfer, Loss provision, Manual Posting and Profile Linkage and Profile Alerts.
• Order-to-Fulfillment
• Account Receivables
• Purchasing
• Advanced Supply Chain Planning
• Inventory Management

Environment: Oracle10g, ADF, Oracle OWB, Oracle Apps OM, AP, AR, GL , Workflows, Unix, Oracle Reports, SQL Loader, PVCS, KINTANA.

Client: Confidential

Description:

• The Confidential Dashboard product is a vital portion of the CONFIDENTIAL Patient Safety initiative. CONFIDENTIAL Emergency Department visits are increasing in number and complexity of illness. Many of the patients that are later admitted to an Confidential facility are being processed through the Emergency Department first. Therefore, the patient's first impression of CONFIDENTIAL is being formulated in the Confidential.
• ED Dashboard captures and evaluates the wait times and other information in the CONFIDENTIAL Emergency Departments. It is a tool used to monitor and improve CONFIDENTIAL's Emergency Services via the data.

Role: SQL Server Developer,ETL SSIS, Informatica , SSRS Developer

Responsibilities:

• Analyzed, drawing Data Flow Diagrams and Documented existing SQL Stored procedures using MS Visio
• Created Logical and physical designs for OLTP, OLAP and DSS models Using Erwin.
• Enhanced and tuned the existing database objects like Procedures, functions and packages and triggers and created the new database objects procedures, functions and packages
• Extensively involved in writing SQL queries Sub queries and Join conditions , T-SQL programming to extract data from large database.
• Designed Informatica Mappings, workflows and sessions.
• Developed SSIS packages
• Participated in Functional documents and functional flow reviews with client

Environment: SQL Server 2005, Informatica, Teradata and UNIX, Erwin, MS Visio

Employer: Confidential.

Client: Confidential

Description:

• Confidential Reconciliations software aims to deliver an automated, real-time multi-way, multi-transaction model. It is designed to be volume-insensitive to enable organizations to respond to organic growth and market demands.
• Confidential Reconciliations helps to monitor, manage and enrich transactions throughout their lifecycle, from inception to settlement, and is capable of extending the process to include external parties when required. It supports an array of reconciliations requirements, from integrated cash and securities reconciliations through to generic, inter-system reconciliations.

Role: Database Developer and ETL Developer

Responsibilities:

• Created database objects Procedures, Functions and Packages for further enhancement in the Tool PL/SQL Programs .
• Worked with external tables , SQL Loader, UTL, Toad and Oracle Import/Export utility to load and unloaded data for various file/data sources
• Developed Stored Procedures using Oracle PL/SQL programming to apply business logic to the uploaded data and move them from staging tables to the master tables.
• Experienced in Dynamic SQL, PL/SQLCollectionsand Exception handling.
• Involved Creating Dashboards and Workflow Tools
• Involved in writing Matching rules and Data loading.
• Created PL/SQL procedures and functions to migrate data between Oracle Databases.
• Data Migration from various sources to Oracle by using Informatica.
• Query optimization through the use of diagnostic tools like Explain Plan.
• Coordinated with other developers in tuning long running SQL queries to enhance system performance.
• Code walk through to optimize the validated code

Environment: SmartStream's TLM Reconciliations software, Oracle 10g, Business Objects

Client : Confidential

Description: Confidential allows users to upload Inventory data to the database. Then users will manipulate the uploaded data and assign various documents. User will enter FE details, CLS details, Confidential details and other tax details. Later Confidential tool upload the manipulated data in to the mainframe system. Various reports are developed according to the regions and offices and generated into excel sheets.

Role: Database Developer

Responsibilities:

• Analyzing and participated in review meetings of functionalities.
• Designing the Technical Document and database design.
• Creating database objects like tables, Stored Procedures, User defined Functions, Views and Trigger.

Technical Considerations:

• Designing and Creating Database, Stored Procedures, Triggers, and View
• Incorporating filtering options based on back up user and service managers
• Generating reports in Excel Sheets by using Excel Object Library.
• Uploading text file information to the database.

Environment: MS SQL Server, VB.Net and Extra Client System.

Clients: Confidential

Description: Web reporting Engine: This module allows user to load invoice images from Confidential server location to working directories of each location. And then capturing and processing of each invoice image can be done and each invoice image will be placed in one of the buckets Fresh, Pending, Problem, Rejected and Processed logically. Finally various reports can be generated for status of invoice images for each working location, productivity of users per day, week and month. Finally the clients can generate various reports from Web Report Engine.

Role: Database Developer

Responsibilities:

• Analyzing and designing the database for customization
• Created database objects such as Procedures, Functions and Packages for further enhancement in the Tool PL/SQL Programs .
• Involved in designed Front end forms using VB.NET
• Testing and Debugging

Technical Considerations:

• While uploading Invoice images, status of each image can be shown to users. Checking Existence, Duplicate Check, Storing in the Database, Deleting existing Invoice Image
• Automatic mail generation while pushing an Invoice Image into pending bucket/queue.
• Generating Charts in web pages for Web Report Engine.

Environment: MS SQL Server, VB.Net, ASP 3.0, VBScript and JavaScript, Crystal reports

Employer: Confidential

Role: Database Developer

Description:

• Confidential application consist of 4 modules,
• Accounting Engine: This module is to automation of accounts department,
• Inwards: Module is to Business Process Automation of Distance Education Programs.
• Student Alerts: This module is to send email alerts to the students about results, payments, dues and so.
• Subscriptions: This module is to automate the Confidential subscriptions.
• The PAI application provides centralized database access, reduction in paper cost, time and manpower, thus providing effective services to the management and the student.

Responsibilities:

• Involved in Analyzation and Designing of functional specific documents.
• Involved in Designing the Technical Documents.
• Involved in database designing and development.
• Testing and Debugging

Environment: MS SQL Server, VB 6.0 and Business Objects 6.0