PROFESSIONAL SUMMARY:

• Over Eighteen 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 Confidential evelopment 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,FAH), 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:

• 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.
• 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/CEMLI) Reports, Interfaces, Conversions, Extensions, Workflow customization, Forms Personalization,CUSTOM.PLL,Performance Tuning, Data Migration, Data Massaging/Transformations,PL/SQLAPI,OLTP/Normalized Modeling,
• 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

TECHNICAL SKILLS:

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, 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, Selenium

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, PharmaceuticalUtilities and Telecom

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Enterprise Data Architect

Responsibilities:

• Created Logical Data model for Procuremart and worked on EDW by consolidating Procuremart,FinanceMart and PeopleMart
• Worked on discovery process for Map of the world and Oracle Projects
• Performed gap analysis between AS-IS and future procureMart solutions

Confidential, Wayne, PA

Sr Technical Consultant

Responsibilities:

• Created pl/sql package to load data from XML file to Oracle ebs data model
• Worked on filter and match configuration in Oracle configurator (CZ) and Oracle sales cloud which deals with various services offered to customer
• Created custom Item catalog screen in Oracle inventory with oracle forms 10g

Confidential, Jersey City, NJ

Reports Lead

Responsibilities:

• OFSA 4.5 to Oracle Financial Services Analytical Applications ( Confidential 6.1) migration - Created various functions and views in PL/SQL
• Worked on T2T Mapping for PFT,FTP and ALM
• Created Reports rationalization document as per BRD while migrating reports from OFSA 4.5 (Discoverer 4.5) to Confidential 6.1(OBIEE 11g)
• GL Recon - Populated Confidential instrument tables by applying transformations

Confidential, Parsippany, NJ

Functional Lead

Responsibilities:

• Prepared HDD for Oracle Interfaces
• Created outbound interfaces from Oracle GL,AR,AP,OM,HRMS to Black line, Eram Peoplefluent and Getpaid systems
• Created Account reconciliation Reports with Oracle Discoverer 10g and Oracle Reports 10g
• Developed test scripts to automate process of testing in Selenium WebDriver

Confidential, Yardley, PA

Functional Lead

Responsibilities:

• Created inbound and outbound interfaces with PL/SQL and UTL FILE
• Created and modified reports with Discoverer 10g
• User Management - Dealing with new users, assigning Oracle applications responsibilities and terminating users
• Converted Oracle reports(RDF) to BI Publisher (OBIEE) reports
• Production support - Fetched end user issues based on priority basis and fixed them in a timely manner

Confidential, Stamford, CT

Functional Lead

Responsibilities:

• Interacting with functional team for business process requirements gathering and analysis
• Modifications and enhancements of oracle reports and Payables workflows (APINV)
• Data Migration strategy: Prepared CV060/CV040 - Conversion specification documents, Data Validation & Load file preparation to migrate data from SharePoint systems to Oracle ERP
• Creation of audit and error-tracking using Oracle Alerts and UMX
• Worked on Custom oracle form (Servers Refresh form) and forms personalization
• Production Support - Implementation issues, Month end, yearend activities in AR,AP and GL Modules
• Customized the Credit Analysis Report and Pick Slip reports in Order Management OM

Confidential, Stamford, CT

Reports Lead

Responsibilities:

• Analyzed the systems to replace the existing customized processes with new R12 features for order management and purchasing modules
• Replaced all Discoverer business folders(GL/AR/AP/iExpenses/iProcurement/PO/OM/CRM) with custom folders
• Created/modified and fixed issues in discover administrator/desktop issues during upgrade from 11i to R12
• Modified discoverer business folder queries by replacing tables with primary and secondary views created
• Modified seeded Oracle projects forms with form10g as per client's requirement
• Converted rdf reports into xml publisher reports
• Fixed issues related to custom rdf reports during upgrade

Confidential, Allentown, PA

Project Lead

Responsibilities:

• 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

Functional Lead

Responsibilities:

• 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,PN,PO,TCA,OM,CRM 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 (Financials, Property ManagementManufacturing and SCM) SQL Developer, PL/SQL, SQL*Loader, Shell Scripting

Confidential, Whitehouse Station, NJ

Sr Data Modeler

Responsibilities:

• 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

Solutions Architect

Responsibilities:

• 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, JavasriptAJAX