Professional Summary:

• Over Seventeen years of experience in Oracle RDBMS and Oracle Applications : Implementation, Interfaces Design, Customizing the modules, Data Conversion from legacy systems into Oracle Applications and Application Software Development in Oracle
• Extensive knowledge in all phases of Software Development Life Cycle, systems development methodologies and Oracle Applications Implementation Life Cycle.
• Can effectively work as an individual contributor or a team member.
• Expertise in Functional and Technical aspects of Oracle applications/Oracle E-Business Suite (EBS) R12/11i Financial modules (GL,AR, AP,FA), manufacturing (OM/OTC, Purchasing/PO/P2P/PTP), CRM (Install base, Service Contracts, Fieldsales,Telesales, Teleservice, Marketing, Quoting, OCO, AME,DQM/CDH/TCA/HZ) and SSWA(iProcurement)

Areas of Focus:
Functional / Consulting

• Business process analysis, Process re-engineering, Translating business requirements to technical specifications (FDD/TDD), Fit/Gap Analysis
• Data Conversion/Mapping - Preparing conversion/mapping documents (CV) and Data Cleansing
• Interfaces/Extensions - Preparing Customization/Extension documents (MD)
• Project Deliverables- Design Specifications, Plans, Strategies and Implementation Procedures like Vanilla, Phased, AIM (BP, BR, TE etc),ADI,Post Production support
• Act as liaison to other Oracle Application teams and be a focal point for cross-application integration issues
• Accept, track and coordinate the resolution of user-initiated application support requests. As part of a support team, resolve application support issues by providing a technical solution or assigning responsibility to the appropriate team member for rapid resolution.TAR will be logged for a bug in Out of box functionality
• Assist with Unit testing of new or enhanced Oracle application functionality; assist with Regression testing of upgrades and patches; coordinate User Acceptance testing (UAT) with internal users and business process owners in a test instance prior to implementation.

Technical

• Analysis and Design – Process Modeling, Data Modeling/ERWIN(Conceptual, Physical and Logical database design), Data Analysis/Mining, and Module Design.
• Development of Oracle CRM/ERP Applications– (RCE/RICE/RICEW/RICEWF) Reports, Interfaces, Conversions, Extensions, Workflow customization, Forms Personalization,CUSTOM.PLL,Performance Tuning, Data Migration, Data Massaging/Transformations,PL/SQLAPI,OLTP/Normalized Modeling, ETL/DSS/OLAP/Dimensional Modeling/Star Schema
• Good working knowledge in System Administration, Data synchronization (FNDLOAD,WFLOAD) and AOL (creation of users ,profiles, menus, registering concurrent Programs, responsibilities,valuesets, form functions,menu,request sets, request-groups,KFF,DFF registration in Oracle Applications)
• Design and Development of database objects – tables, materialized views, triggers, procedures, functions and packages

Tools and Methodologies:

ERP/CRM: Oracle R12/11i (12.1/11.5.5/11.5.9/11.5.10.2) OM, PO, A/R, A/P, G/L,
Service Contracts, Install Base, TCA, Fieldsales, Telesales,
Teleservice, Marketing, Quoting, OCO, DQM, CDH, TCA, HRMS,
SSWA (iProcurement)
Languages: Java, J2EE, PL/SQL, C, Pro*C, HTML, XML, PERL, JavaScript, CSS,
Shell scripting (Korn/C/Bourne)
Oracle Tools: Developer 6i/9i/10g (Forms 6i/9i/10g, Reports 6i/9i/10g),
Oracle SOA 10g/Fusion Middleware (BPEL, OSB),
Siebel Analytics/OBIEE 10g (Dashboards/Answers/BI Publisher),
Designer 10g, OWB 10g, Oracle Discoverer 10g, ERWIN,
SQL*Loader/SQLLDR, Workflow 2.8, Export/Import, Oracle AQ, PVCS,
Visual Source Safe, MS Visio and MS Project
IDE: TOAD 9.0, SQL Developer, Jdeveloper 10g
Framework: APEX 3.2/4.0, OAF, ADF 11g
Databases: Oracle 9i/10g/11g
Platforms: Windows NT/XP/ Vista/Windows 7, UNIX (Sun Solaris, Sco-Unix,
HP-UX, AIX, Linux)
Industries: Financials, Manufacturing, Insurance, Services, Pharmaceutical,
Utilities and Telecom

Professional Experience:

Confidential, PA
Duration Apr’11 to Oct’11
EAM Migration: PPL has selected the Ventyx Asset Suite enterprise asset management (EAM) solution as its companywide standard for tracking equipment and infrastructure across all of its operating subsidiaries.
Responsibilities Include:

• Gathering requirements and preparing high level design documentation
• Created data mapping document with source and target column details
• Created PL/SQL package which will mask and cleanse source data and then creates an outbound flat file to be loaded into target database
• Prepared test cases and test scenarios for data migration
• Created various reports with Discoverer 10g

Environment: UNIX, Oracle11g, SQL Developer, PL/SQL, SQL*Loader, Shell
Scripting,Informatica 8.6

Confidential,Woodcliff Lake, NJ
Duration Jul’10 to Mar’11
Nextgen (Next Generation Auditing): Nextgen is an automated auditing system consists of various automated auditing procedures built on common enterprise platform. Nextgen audit must identify potentially risky transactions and verify that company policies and procedures have been and are being followed.
Responsibilities Include:

• Created BR document which provides details like “who, what, when, and where” of Oracle ERP transactions as well as giving details of extracting, migrating and maintaining this data in a non-ERP repository
• Created SAP to Oracle Transformation specifications based on AAPs provided by auditors
• Created SAP to Oracle mapping based on Oracle’s key business processes P2P and O2C
• Created PL/SQL script which extracts data from Oracle R12(GL,AR,AP,PO,TCA,OM and INV) modules into a flat file to be loaded into Non ERP repository
• Performed Transformation testing to make sure that AAPs are working properly
• Created test data with audit exclusions/Follow-up items in Oracle R12
• Created various audit reports with Discoverer 11g

Environment: UNIX, Oracle11g, Oracle R12,SQL Developer, PL/SQL, SQL*Loader,
Shell Scripting

Confidential,Whitehouse Station, NJ
Duration Nov’09 to Apr’10
The Global Expert Engagement Management (GEEM) group has been chartered with implementing the appropriate business processes and procedures to ensure FCPA compliance for Merck.
Responsibilities Include:

• Gathered requirements and prepared HDD
• Copied Unicode files from various sources to SQL*LOADER data directory by using Unix shell script
• Manipulated data in inbound Unicode files with AWK,SED and EXCEL
• Data load using PL/SQL,UTL_FILE and SQL*Loader/SQLLDR
• Created PL/SQL procedures, functions, database triggers and packages required to read inbound Unicode data files by encoding them into UTF-8 if necessary.
• Performed validations, scrubbing/transformations and creating outbound flat files as per client’s requirement
• Prepared test cases and load process metrics
• Created end to end load process by creating Unix Shell scripts

Environment: UNIX, Oracle11g, SQL Developer, PL/SQL, SQL*Loader, Shell Scripting

Confidential,Somerville, NJ
Duration Jul’09 to Oct’09
There is a need to provide an Oracle APEX/PL/SQL solution that can support the business processes of Sales Inquiry and START Processes. This solution is intended to help in managing the Sales Inquiry process through its life cycle. In addition, the purpose is to provide Sales representatives the ability to determine whether they really need to submit inquiry or not at the same time, required metrics are given to Sales Planning and Analytics (SPA) to take decisions on closing sales inquiries.
Responsibilities Include:

• Gathering the requirements and performing Gap Analysis
• Prepared SOW,FRS and Traceability Matrix based on requirements
• Developed START and SI enquiry enhancements based on Individual milestones
• Prepared Project management and deployment plan
• Deployed them in production and User documentation

Environment: UNIX, Oracle11g, SQL Developer, APEX 3.2, HTML, CSS, Javasript,
AJAX

Confidential, Wilmington, DE
Duration Oct’08 to Apr’09
CSC is the second largest Registered Agent service company in the world representing hundreds of thousands of business entities worldwide including a substantial number of the Fortune 1000.
Responsibilities Include:

• Performed Map and Gap analysis
• Created Mapping documents for segments
• Documenting all current state process flows, requirements, customizations, mapping/gapping requirements, and making business process improvements, capitalizing on standard functionality to reduce the number of customizations.
• Performed Gap analysis on existing tax system to see whether the existing homegrown tax calculation system could still be integrated into the new E-Business Tax module, or if the standard functionality within E-Business Tax should be used.
• Organized the creation of the tax content rules using Oracle\'s E-Business tax(VAT)application
• Created ADI spreadsheets to upload new assets (FA) and journal entries
• Tested and revised the customized FA account generator that automatically re-classed asset transactions based on fund type
• Tested and assisted in the reconciliation of the converted fixed assets.
• Created mapping sets and Derivation rules in R12 SLA
• Prepared and loaded Cross validation rules(CVR) as per segment changes
• Analyzed the systems to replace the existing customized processes with new R12 features for order management and purchasing modules
• R12 Purchasing setup: Organization Classification,Categories,Buyers and Purchasing options etc
• Used Extension & Personalization features for iProcurement customizations
• Customized ‘PO Doc creation workflow’, ‘PO Approval & Requisition Approval Workflow’ for iProcurement
• Developed interfaces to legacy systems using BPEL in JDeveloper
• Developed UI screens using JSP and OA Framework
• Modified reports using BI Publisher
• Modified FSG Reports as per client’s requirement and used ADI to export into Excel for graphs and charts
• Wrote functional specs for custom financial reports and developed Rxi reports
• Design, plan and conduct functional testing. Develop and maintain test scenarios for end users

Environment:Unix,Oracle10g,Oracle R12(GL,SLA,FA,PO,iProcurement,EBTax),
Oracle Applications Framework (OAF), Developer 10g, Oracle SOA 10g,
Workflow 2.6, Jdeveloper 10g, OBIEE 10g