SUMMARY

• Information Technology solution provider with extensive experience as a Technical lead/Techno functional/Sr. Applications developer using SDLC/Agile methodologies.
• Specialized in building various business applications using Oracle Relational Database Management System RDBMS , upgradations, implementations using Oracle e-Business Suite, Oracle RICEW components and Java.
• Combine business acumen, consulting background, subject matter expertise, and technical skills to engineer enterprise solutions using Oracle e-Business Suite modules Oracle Financials, Procure to pay, order to cash, Projects, HR Compensation Work bench, Performance Management, Advanced Benefits, Recruitment and CRM to define solutions by Configuring the applications, gathering business requirements, identifying gap analysis, provide workaround solutions, Techno/Functional Analysis on open interfaces/Legacy conversions, Customizations and enhancements.
• Provides Leadership and coordinates with multiple stakeholders Business, cross functional IT teams, infrastucture, QA, business analysts,external vendors for application projects with varying levels of complexity.
• Engineer enterprise solutions by building applications and RICEW Components with oracle tools, Integrating Oracle Custom build forms using different Oracle Libraries, by customizing Workflows and Form Personalization.
• Experience in working in off-shore/on-site model, on-call 24/7 rotational support model and SME support when required.

Core Skills

Technology Skills

Industry Skills

Professional Experience

Confidential

SR.Oracle EBS Developer

Responsibilities:

• As a Lead Engineer, experience in ERP full life cycle deployment, RICEW technical design, development, testing, and implementation, providing solutions/technical support to Weight watchers E-Business Suite and Back office systems, preparing technical design MD70 ,MD120, identifying the gaps, translating business issues/requirements into technology solutions, code migration activities and documentation, functional setups Finance AP, AR, GL, expenses , Oracle Projects, HRMS, iRecruitment, iProcurement, Performance management, Compensation Work bench CWB and Order to Cash.
• Works closely with onshore and offshore resources in application development by creating Technical design documents and providing technical clarification for other development team members as needed . Interact with PMO team, Functional Leads/ Business Analysts to identify requirements
• All the deliverables were completed within project timelines and by following all the defined coding standards.
• Deep technical knowledge and understanding of Oracle ERP data model.
• Defined strategy to upgrade global weight watchers.com, Canada implementations .
• Extensively used system administration activities and Application object library.
• Extensively used PL/SQL, Java, BI Publisher, Linux, Forms, Reports, Workflow, TOAD, SQL Plus, AME, OAF, Jdeveloper .
• Extensively worked on weightwatchers Order to Cash process and Procure to pay flow customizations and interfaces, Implementation of Member Refunds project, Bottom Line, created Interface between JPMC and weight watchers to load iexpenses into AP , Built interfaces using PL/SQL to load invoices from Leased Rents and Granite systems into Accounts Payables. Created AR Receipts Interface, Lock Box Processes between Weight Watchers and external banks JPMC, US BANK, paymentech . Created a process to validate and load transactions with proper revenue, receivable and unearned accounts, return transactions from different sources in to AR, customized auto accounting or validate accounts, generate sales transactions Subsidy or cash into different revenue account, developed a interface to load customers into TCA, customization of Leader dunning letters reports ,Developed BI and ADHOC reports, provided solutions to implement flex pricing/service contracts project, materialized views, nelly decommission project, Consolidation of billing invoices using reports 6i, load adjustments ,Apply receipts against invoices process, Active Link invoice transactions, WW.COM Transaction Import, customization of customer entry screen using CUSTOM.pll. Customized PA Approval Workflow using AME, PA time cards information to OTL, expenditure transactions outbound to Hyperion.
• Created a process to validate and load different types of orders using API's into Order Management from external systemS like DOTCOM, CS Portal, BOSS systems. Customization of Back order tracking, Pick release, field physical entry report, PTA entry form changes, Form Personalization's.
• Provided solutions in Customizing and implementing applications like Success Profiles and Objectives conversion, Appraisal Workflow, Critical Success Factors generation, OAF customizations and personalization, Appraisal update process, fast formulas, purge appraisal process, XML publisher reports, Appraisal print in Performance Management and CWB. Created fast formulas and functions.
• Implemented iRecruitment and provided solutions to Applicant Interface, Gallup Interface, Alerts, Vacancy Approval Workflow using AME, Default Recruiter page customization, Gallup Search Fields customizations using OAF and Java programs, XML , Self-Service extensions to control access to TMA in iRecruitment. Customization of UHC medical interface and Audit Report configuration in HRMS.
• Created an interface/conversion process to load sub inventories, locations, items to INV. Customized kitting/de-kitting, duplicate sub inventory.
• Created GL balances transfer to Hyperion, DOTCOM/Canada GL balances and Journal conversion, Audit Query Reports in General Ledger.
• Involved in code reviews, VSS code check in and check out to deliver the code properly to higher instances and also prepared Migration documents . Assisted DBA's in migration of code to UAT, QA and PSUPP, Production instances.
• Actively troubleshooted complicated issues across multiple systems, regardless of architecture and driving the effort to a successful conclusion. Expert in learning new skills related rapid growing technologies.
• Communicated proactively on all technical aspects within the scope of work specifically.
• Assisted in fixing/trouble shooting,creating oracle SR's, the production or back office support issues related to Finance, HR and Supply Chain modules so month-end activities went through successful.
• Assisted with following change control Release Process , Job scheduling through Control-M, version control systems, defect tracking systems quality center set in place by department and follow the guidelines set in the Development process.

Environment: Oracle Applications 11i 11.5.10 /12.0, Linux, BI Publisher ,OA Framework, JDeveloper, SOA, Java and .net, XML Publisher/BI, Forms , Form personalization's, Reports , Work flow, CUSTOM.pll, AME, PL/SQL

Sr. Oracle EBS Developer

Confidential

Responsibilities:

• Designed and Developed AP invoice inbound interface programs for different legacy sources to load the invoices into FGI Payables System using AIM methodologies.
• Designed and Developed Rems,Payroll,Cash Control, Cost Centers, SIFT American Express Payments,
• Designed and Developed Custom Citibank, Bank of Montreal Format and Payment extraction programs Using PL/SQL in Oracle Payables.
• Extensively used informatica to create mappings.
• Designed and Developed custom programs like API's, Mapping Procedures and gateway programs using PL/SQL for General Ledger GL . Extensively used Discoverer to build GL reports.
• Actively supported in resolving production related issues with Business Users. Collected the user requirements, converted into functional and technical specifications.
• Actively supported month-end activities in GCS and Financial reporting...
• Designed and Developed GL outbound programs to Merrill Lynch Insurance group MLIG
• Designed and developed custom forms for GL Interface Gateway.
• Designed and Developed customer invoice interface program to load the customers from IBK to Oracle Receivables AR . Performed tuning for various PL/SQL scripts.
• Extensively created Autosys JIL and shell scripts for job scheduling.
• Loading the AP, GL spread sheets data into APPS using web ADI.
• Experience in fixing the issues using PL/SQL, performance tuning and enhancements with the ability to support environment processing large volumes of data required in financial systems.
• Wrote PL/SQL wrapper program to call standard GL GCS process.
• Created different cash flow processes between Merrill Receivables and external banks.
• Resolved month-end issues or interface issues between Merrill trading systems and GL.
• Completed AP functional setups like Payment terms, Banks, payment programs, and formats, organizations, profile options , tax codes, flex fields, lookup codes, Multi-org, Multi-Currency.

Confidential

• Provided solutions to complete regression testing of all custom programs like forms, reports, and in-bounds and out-bound PL/SQL programs for AP, GL, FA and AR modules.
• Prepared the test plan and test case documents for up gradation. Created oracle SR's and worked with Oracle Support. Performance test results were documented and published to Business.
• Prepared the integrated test plan and executed test scenarios in accordance.
• Involved in setup of UNIX environment files, directory structure and Autosys jobs for 11.5.10.
• Extensively Involved in Performance, Load testing of 11.5.10 suite.

Confidential

• Created a process to convert/interface Base rates, FX rates into FDM GL. Designed, developed and tested GL outbound programs Incremental Process, P L, FDM Rates and Rules using PL/SQL, Java classes and shell script. Created the SQL server scripts to extract the data from BUCS system. Involved in designing and developed the programs, to convert and interface the data from BUCS system to oracle GL using SQL server, Autosys and PL/SQL.

Confidential

• Designed and developed, testing the programs to convert JD Edwards data from SQL server to Oracle. Involved in converting the Legacy GL, AP reports into Discoverer 10G.

Environment: Oracle 9i/10g, Oracle Receivables, AP, GL, FA, Workflow Builder 2.6 , PL/SQL, Forms 6i,

Reports 6i, Discoverer 4i/10G, SQL plus, SQL Loader, Windows 2000, Autosys, UNIX, SQL server,TOAD

Oracle 7.3, Oracle Apps 10.7 SC GL,AP,PA,AR,PO , PL/SQL, Developer/2000, Reports 2.0, UNIX