SUMMARY

• Accomplished and resourceful IT professional with nearly 12 years of experience in ERP, including developing, customizing, testing and implementing Oracle SCM, HRMS and Financial Modules like GL, AP, AR, FA, CM and PM
• Hands - on experience in client/server technologies and Oracle Applications V (Release 12, 11.5.10, 11.5.9), with domain expertise in telecom, real estate, banking, manufacturing and trading sectors
• Excellent track record of working within large-sized teams on various Oracle R12/11i support, enhancement and implementation projects for the delivery of services and solutions to global clients in USA, UAE, Saudi Arabia and Malaysia
• Excellent knowledge of Oracle 11G SOA suite
• Experience in analysis, design and development of enterprise applications using SOA, BPEL, Java, J2EE, and Database technologies.
• Large-scale SOA/EAI implementations using Oracle Fusion Middleware (Oracle JDeveloper, Oracle SOA Suite, Oracle OSB, Oracle BAM and Oracle Web logic)
• Solid understanding in Service-Oriented Architecture and its related technologies like BPEL, Web Services, WSDL, SOAP, XML, XSD, XSLT and Web Service Security.
• Specialized in areas like Global HR, Oracle Time & Labor, Absence Management in Oracle Fusion HCM. Having experience in Creation of Security Profiles and Roles in Fusion HCM.
• Having Knowledge on HCM Data Loader (HDL), Spreadsheet Data Loader and BI Publisher (OTBI) Reports in Fusion HCM. Experience in developing HCM Extracts/BI Reports for Global HR, Payroll Interface.
• Proficient in Oracle Forms & Reports, SQL, PL/SQL, XML Reports, BI Publisher Reports, Chart Reports, RICE components, Custom Reports like RDF & Discoverer Reports, OA Framework, creating Oracle Alerts, customizing menus, personalizing forms, and implementing inbound and outbound integrations to Oracle ERP, and automating tasks using Unix Shell scripts, C and Java.
• Responsible for providing on-going support to application customers as it relates to troubleshooting Order Management, Payables modules related issues.
• Worked on production issues, involved in debugging, testing and implementations of Custom solutions.
• Worked closely with clients to document business requirements. Created documents such as requirements documentation, test cases, technical design documentations, etc.
• Analyzed and documented business processes, user requirements, and functional needs.
• Analyze and develop comprehensive understanding for customer needs, create documents and detailed programming specifications and design implementations of any client specific customization.
• Strong ability to prepare resource estimates, user manuals and other technical documents, test cases, perform code reviews & document reviews, along with project management and collaborative skills to work with geographically distributed teams and key stakeholders to manage priorities in a high-pressure environment

TECHNICAL SKILLS

Languages: SQL, PL/SQL,C and Java

Database: Oracle 10g

Tools: Forms 6i/10g, Reports 6i/10g, XML Publisher, Discoverer Reports, TOAD, SQL*Loader 8.0, OA Framework, Oracle Workflow

Operating System: Windows (7, XP)

ERP: Oracle Applications Release 12, 11i (11.5.10 & 11.5.9)

Modules: Inventory, HRMS, Purchasing, Order Management, Payables, Receivables, Property Manager, Projects

Cloud ERP: HCM, Absence Management

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Project Lead / Offshore Team Member

Responsibilities:

• Developed XML publisher reports, RDF reports
• OAF personalization, Customizing OAF pages.
• Worked on Forms Personalization
• Prepared technical documents
• Prepared resource estimates
• Developed Inbound and outbound Interfaces

Confidential, Philadelphia

Project Lead / Offshore Team Member

Responsibilities:

• Prepared resource estimates, developed and delivered Interfaces, XML Reports and BI Publisher Reports
• Developed XML publisher reports as
• OAF personalization to hide fields on Employee Re-hire page. Customized OAF pages.
• Worked on Forms Personalization
• Prepared technical documents

Confidential, Ann Arbor, Michigan

Project Lead / Offshore Team Member

Responsibilities:

• Successfully implemented Global HR and Payroll, Absence management module
• Initialized the users for setting up and implementing the oracle HCM.
• Experience in creation of Business Unit, Business unit set assignment in Fusion HCM.
• Having strong knowledge on ESC, Job, Position Structure Creation and Deployment.
• Managed absence plans and absence categories, and eligibility profile.
• Worked on fast formulas for absence management module.
• Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.
• Creating Oracle Fusion BI Reports and Analytics.
• Streamline Recruiting & On boarding processes with Core HR applications.
• Build Custom Security for Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Designed and built SOA composites and BPEL processes that polled the legacy system for incoming customer data, performed filtering and transformation operations on it before inserting into EBS system.
• Worked extensively on the File Adapter, developed XSD Schema to format the data in extracted file as per requirement, using pipeline delimiters.
• Used service components like Mediator, BPEL and Human Task.
• Worked on configuration plans to deploy composites in different environments.
• Prepared resource estimates, developed and delivered Interfaces, XML Reports and BI Publisher Reports
• Customized standard reports for layout change
• Prepared technical documents
• Order Management: Created Sales Order notifications sent through emails using trigger and package
• Prepared Sales Order Audit report for change in quantity and price at line level

Confidential, Irvine, California

Project Lead / Offshore Team Member

Responsibilities:

• Prepared resource estimates, developed and delivered Interfaces, XML Reports and BI Publisher Reports
• Customized standard reports for layout change
• Developed an Inbound Interface for Receipt Creation and an Outbound Interface with Invoice details in Receivables as well as for Item Master, Customer Master and Sales Order
• Worked on Forms Personalization and Oracle Alerts
• Created Chart Report
• Prepared technical documents

Confidential

Project Lead / Offshore Team Member

Responsibilities:

• Prepared resource estimates, developed and delivered Interfaces, XML Reports and BI Publisher Reports
• Customized standard reports for layout change
• Worked on Forms Personalization
• Prepared technical documents
• Order Management: Modified custom.pll for warning to eliminate mismatch of base price on Pricing & Availability Form
• Licensing: Developed Reports on Licensing

Confidential

Offshore Team Member

Responsibilities:

• Prepared resource estimates, developed and delivered Custom Forms and OAF pages
• Enabled attachment feature in Standard/Custom Forms
• Developed 4 Custom Forms for Sourcing Module which is used to capture auction details and committee member details for an RFQ (Request for Quotation)
• Developed OAF pages in HRMS for capturing OT details and calculating OT hours of employees
• Developed a custom OAF page for iSupplier Bolt-on, which captures serial numbers, and this page is called from the standard page. Also, provided controller extension on the standard page

Confidential

Project Lead / Offshore Team Member

Responsibilities:

• Prepared resource estimates, developed and delivered Interfaces and XML Reports
• Performed code review, documents review and guided the team in resolving issues
• Scheduled reports
• Enabled attachment feature in Standard/Custom Forms
• Wrote code for uploading bank statements for reconciliation by customizing the standard package/views, that is, Ce 999 Pkg/ce 999 interface v
• Created Oracle Alerts in HRMS, LDT files for concurrent programs, lookups, value sets, XML data definitions, templates to migrate from one instance to another using FNDLOAD and XDOLOAD
• Customized standard reports for layout change
• Maintained on-time delivery and quality of deliverable

Confidential

Offshore Team Member

Responsibilities:

• Comprehended business requirements & planned the development schedule accordingly
• Wrote the data migration code for HRMS data migrations
• Developed data migration scripts for uploading inventory items using API’s and many Alerts in HRMS
• Customized standard reports
• Developed the technical design documents for different interface programs in Finance for modules AR, AP and XML reports in OM, PO, OPM
• Conducted testing of programs according to functionality and requirements