PROFESSIONAL SUMMARY:

• Results oriented IT Professional over 9 years of experience with expertise in design, analysis, development, testing, and implementation of Oracle E - business Suite applications11i/R12 using Oracle Relational Database Management Systems (RDBMS).
• Implementation and technical expertise in Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Extensive experience in writing stored procedures, triggers and very strong in PL/SQL.
• Having good Experience materialized views for data replication in distributed environments
• Expertise in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables and Dynamic SQL, Collections and exception handling.
• Solid Experience in working with Bulk Binds, Bulk Collects, Oracle Collections like Index-by tables, Nested tables and Varrays.
• Extensively Used the DBMS XMLGEN and DBMS XMLSTORE package to generate and insert XML files in Oracle 11g
• Experienced in designing tables, views and materialized views for use in OBIEE
• Created/modified Metadata repository using the OBIEE 11g's Physical, Business Model and Mapping and Presentation Layers.
• Experienced with performance tuning for OBIEE
• Design, test and modify OBIEE security using roles, privileges in Enterprise Manager (EM), Administration Console to Access security
• Involved in Data Modelling using Erwin tool and created star and snow flake schemas.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace and TKPROF utilities and Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, PowerShell scripting, Performance Tuning.
• Have experience on the Partitioning (Hash, List and Range partitioning) of tables in OLAP and OLTP data bases.
• Implemented SQL*Loader to load data into tables and also used Dbms Utility package.
• Experienced in Performance Tuning and analyzing using TKPROF, SQL Trace, and Explain Plan
• Have experience on Oracle EBS (11i/R12) Oracle Financial and Supply Chain Distribution (SCM) Manufacturing: Accounts Payable s (AP), Account Receivable (AR), General Ledger (GL), Fixed Assets, Order Management (OM), Oracle Inventory (INV), Oracle Purchasing (PO), HRMS.
• Extensive Experience in Oracle Business flow in Order to Cash (O2C) and Procure to Pay (P2P)
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, UAT, Cut-Over and Project Coordination activities.
• Experience in designing, developing, implementing and customizing RICEFW (Reports, Interfaces, Conversions, Extensions, Forms and work flow) Components.
• Technical Skills include SQL, PL/SQL, Forms 6i/10g, Reports 6i/10g, Form Personalization, Oracle Discoverer, XML/BI Publisher, Conversions, Data Migration, SQL*Loader, Interfaces for Cross-System Integration and Oracle APIs.
• Expertise in bug fixing and interacting with oracle support, and experience in designing and developing inbound and outbound interfaces for Oracle Applications.
• Strong programming experience in creating Procedures, API, Packages, Functions, Triggers, and other database objects using SQL and PL/SQL also extensive experienced in fine-tuning code for better performance.
• Have good experience in Data mapping between source systems and Target systems for ETL coding.
• Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.
• Good knowledge about Topology, Designer, Operator in Oracle Data Integrator (ODI).
• Worked with knowledge modules like LKM, IKM and CKM
• Good knowledge on No-SQL (Mongo DB) which I trained in this technology for new project.
• Self-starter, result-oriented team player with an ability to manage multiple tasks simultaneously.

TECHNICAL SKILLS:

• C, C++, JAVA, SQL, PL/SQL Developer 2000 (Reports 6i/10g, Forms 6i/10g), Unix Shell Script
• Oracle Applications 11i, R12
• Oracle Financial GL, AP, AR, PO, INV, OM
• Oracle Distribution/Supply Chain/Manufacturing (INV, PO, OM, BOM, WIP, iStores, Advanced Pricing)
• Oracle BI/XML Publisher, OBIEE 11g, Oracle Data Integrator (ODI)
• Oracle, No-SQL (Mongo DB)
• TOAD,SQL*Loader, PL/SQL Developer, Kintana, Clear Case, Mercury QA, PUTTY, Data loader, SQL*Plus

PROFESSIONAL EXPERIENCE:

Confidential, TX

Oracle Developer

Responsibilities:

• Discussing the requirements with business partners and preparing the high level design for the business changes and review with business users and get the approvals for the high level design document s.
• Develop complex search SQL queries based on the business requirements. Troubleshoot the long running queries in production and tune the scripts after review AWR reports.
• Create low level design document on the basis of the high level design derived from requirements.
• Develop the code based on the low level design document and follow the coding standards and test the code. Correct the errors by making appropriate changes and then rechecking the program to ensure that the desired results are produced.
• Perform design and code reviews to ensure high-quality deliverables.
• Created new objects: PL/SQL procedures, functions, and packages for data population and manipulation as per user requirements.
• Extensively Used the DBMS XMLGEN and DBMS XMLSTORE package to generate and insert XML files in Oracle 11g
• Involved in Data modelling for the Source of Wealth by using Erwin tool. Created new tables and indexes for Source of wealth Worked on data mapping between source systems and target systems and closely worked with Abinitio team.
• Closely worked with business team and provided profiling results for them from large database.
• Developed complex search queries and tuned the queries to improve the performance.
• Discussing with offshore team on the project requirements and assigning work to team.
• Preparing and executing unit test cases and provide support for User Acceptance Testing and System Integration testing.
• Resolve UAT issues and production issues on specified SLA tracked through HP Quality Center tool.
• Working on the ad-hoc requests from different lines of business (Retail Banking, Brokerages and Cards) .
• Created/modified Metadata repository using the OBIEE 11g's Physical, Business Model and Mapping and Presentation Layers.
• Collaborated with Business Analysts, discussed and identified the analytics requirements to be obtained from various user groups.
• Created star schemas in the repository. Used the foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer to form relationships between fact and dimensional tables.
• Worked on complex mappings using various transformations like lookup, expression, aggregator, router, sequence generator, external procedure, stored procedure.
• Set up security to authenticate users and grant permissions and privileges to appropriate users thus facilitating efficient web use in a large environment.
• Experienced in designing tables, views and materialized views for use in OBIEE.
• Experienced with performance tuning for OBIEE.
• Created users and groups and setup the Data Level Security as well as Object Level Security. Created BI answers reports and dashboards.
• Create prompts, Ad Hoc reports and customized reports.
• Design, test and modify OBIEE security using roles, privileges in Enterprise Manager (EM), Administration Console to Access security.
• Unit testing was done and compared the expected and actual results with data in source to that of target by running SQL queries.
• Worked with LOB partners on multiple occasions to create requirements for OBIEE reporting solutions.
• Debugged complex SQL queries.
• Worked with Golden Gate team on COB replication issues from Production.
• Involved in implementing business logic for the CCID generation based on different rules.
• Worked on Problem tickets raised production team.
• Working on the critical production issues and modify the production code in lower environments and deploy in production after proper testing. Ensure documentation of problems received and resolution method identified.
• Provide RCA (Root Cause Analysis) of each issue. Created Indexes on Tera DB tables to solve the performance issues
• Trained on Mongo DB and conducted knowledge sharing sessions with the team.

Environment: Oracle 11g, Tera DB, SQL, PLSQL, UNIX, OBIEE 11g, No-SQL (Mongo DB), Service Now, MDM

Confidential, Seattle

Oracle Apps Techno Functional Consultant

Responsibilities:

• Analyzing the Business Requirements and System Specifications to understand the application.
• Coordinated and documented detailed gap analysis between client requirements and Oracle R12 functionality.
• Worked with oracle team for CEMLI objects.
• Modified PL/SQL procedures, functions, and packages for data population and manipulation as per user requirements.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries)
• Worked on Customized objects.
• Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts to populate the PO interface tables and invoked seeded import programs to populate the base tables.
• Worked on custom objects
• Created custom reports, forms, packages, workflows.
• Understand the different types of parts (Expendables, Rotables and Repairable) which are using in the aircraft.
• Good working knowledge of PL/SQL and UNIX in Production Support.
• Working closely with appropriate Boeing personnel for effective problem resolution.
• Created the reports as per client requirement.
• Created new supplier setups.
• Creating Customers, Profile Classes & Bank information.
• Involved in preparing Test plan and Test cases and regressive testing in all the phases.
• Created test cases for different test scenarios.
• Participating in the analysis and design of various reports and forms using OBIEE, XML/BI Publisher, Oracle Discoverer and Reports and Forms.
• Created different types of invoices in Account Payables and tested the customized reports.
• Created Security profiles as per client requirements.
• Created the recurring generals (formula and Skelton journals) in GL module.
• Involved in developing the auto lock in Account Receivables.
• Analyzing and resolving the functional and technical problems raised by the users on Order management, Inventory and purchasing modules, Account receivables and Payables.
• Resolved the customer facing issues in finance modules.
• Designed Created and Tested Reports in the Dashboard and created the adhoc report according to the client needs.
• Tested the application end to end cycles (P2P and O2C cycles) and created defects in QC.
• Every week providing the test execution status to the client.
• Helped the end user while doing UAT
• Have experience in opening, managing, and resolving Oracle TAR's with Oracle Support/ Metalink.
• Involved in solving the post production issues.

Environment: Oracle Applications R12 Financial/Supply Chain (OM, PO, INV, QP, AP, AR, TCA, GL, EBTAX ), Oracle, Toad 8.0.0.47, Reports, Forms, XML/BI Publishers, UNIX, SQL*Plus, Windows XP, VSS

Confidential

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.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to 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-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.

Environment: SQL, PL/SQL, Oracle Applications R12 Financial (PO, AP, GL, SLA), Oracle, Oracle SQL Developer tool, Toad 8.0.0.47

Confidential, Chicago, IL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Analyzing the Business Requirements and System Specifications to understand the application.
• Worked on setups for Inventory, Purchasing and Order Management.
• Involved in user requirements gathering, organization setups, filed/attribute mappings, design and development of interfaces, conversions, reports and extensions.
• Validated Setup steps for Inventory like Inventory Organizations, Source Types, Item Templates, Category Sets, UOM, Classes and Conversions.
• Worked on conversions like purchase orders, payable invoices, AR Invoices, vendors etc using APIs/Interfaces
• Participating in the analysis and design of various forms and reports using Oracle Discoverer 10g, Reports 6i, BI/XML Publishers
• Designed and Developed PL/SQL Procedures, Functions and Packages as per client requirement.
• Involved in Development and testing of outbound interfaces and conversions.
• Worked on custom PL/SQL packages, which support functionality of project.
• Develop the code to load rates from external system.
• Created/modified Metadata repository using the OBIEE 11g's Physical, Business Model and Mapping and Presentation Layers.
• Collaborated with Business Analysts, discussed and identified the analytics requirements to be obtained from various user groups.
• Created star schemas in the repository. Used the foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer to form relationships between fact and dimensional tables.
• Worked on complex mappings using various transformations like lookup, expression, aggregator, router, sequence generator, external procedure, stored procedure.
• Set up security to authenticate users and grant permissions and privileges to appropriate users thus facilitating efficient web use in a large environment.
• Involved in System test plan creation based on the requirement and design document.
• Involved in testing at the time of application downtime.
• Resolving the problems related to different interfaces.
• Creating Change Requests to resolve the data fix issues
• Creating Kintana and clear case for change requests.
• Doing set ups in the production for new releases.
• Attending KT calls before releases to production
• Involved in Creation and review of test Scenario and test Case based on requirement and design document
• Tracking the Test Plan/Test Specification vs. Requirements
• Tested the functionality and involved in resolving issues.
• Code Migration by using HP Kintana (Migration Tool).
• Version Control tool by using Clear case.

Environment: SQL, PLSQL, Oracle Applications R12 Financial/Supply Chain (OM, PO, INV, QP, AP, AR, TCA and GL ), Oracle, Toad 8.0.0.47, Reports, Forms, XML/BI Publishers, OBIEE 11g, UNIX, SQL*Plus, Windows XP

Confidential, Chicago, IL

PL/SQL Developer/Support

Responsibilities:

• Understanding the production environment, business and different tools and different interfaces used in production.
• Analyzing and resolving the functional and technical problems raised by the users on finance modules and supply chain modules.
• Involved in production code changes (L3 Activities like code change on existing production code)
• Modified the procedures/functions/Packages.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Created automated SQL scripts to monitor the application issues.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Created Indexes on the customized oracle tables for faster retrieval of the data to enhance the data base performance.
• Modified UNIX shell Scripts to fix the issues.
• Interacting with customers on crated issues to know more information about the issues and resolved the issues within SLA.
• Understand the issues and raise change request if it is a code change or functional setup to resolve the issues and work on change request based on the priority of the issues.
• Worked on invoice errors and PO issues.
• Worked on month end close activities to close the period smoothly.
• Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files into oracle database by using ODI.
• Good knowledge about Topology, Designer, Operator in Oracle Data Integrator (ODI).
• Worked with knowledge modules like LKM, IKM and CKM
• Involved in the application downtime activities in the weekend and closely worked DBA team.
• Involved in testing at the time of application downtime.
• Resolving the problems related to different interfaces.
• Creating Change Requests to resolve the data fix issues
• Creating Kintana and clear case for change requests.
• Doing set ups in the production for new releases.
• Attending KT calls before releases to production
• Initiating bridge and involving in SRT’s if any critical issue.
• Involved in enhancements

Environment: Oracle Applications R12 Financial/Supply Chain (OM, PO, INV, QP, AP, AR, TCA and GL ), Oracle, Toad 8.0.0.47, Reports, Forms, XML/BI Publishers, ODI (Oracle Data Integrator), UNIX, PVCS, SQL*Plus, Windows XP