· I have worked on various bank integration for lockbox process and receipt application through API.
· Developed and supported technical integrations with various business systems such as Oracle Financials ERP system with Double Click ,Vertex, AdWords systems.
· Enabled Oracle Advanced Collections module (IEX) and customized Customer Scoring, Dunning and Cancellation processes to meet Google needs.
· Designed and developed a new workflow in IEX to mange global collections process.
· Developed AR integration with Oracle XML Gateway to enable Billing in Oracle for B2B Customers such as Best Buy/Amazon.
· Acted as Primary Support Contact to Business during Month End/Quater End /Year End close process for AR Module and helped resolve issues pro-actively to meet the Close activity deadlines.
· Helped business to understand Multiple stages of the Critical accounting that happens during Revenue Recongnaization, Receipt and Credit Memo Application processes.
· Developed crucial reports for Revenue Recongnaization waterfall for audit.
· Extensively worked with Performance issues from SQL Query tuning to addressing multiple performance bottle necks on ERP Jobs.
· Resolved multiple SQL Performance issues using Oracle hints, proper indexes usage, Query Optimzations, reduce CPU consumption with Oracle Programs, Reports wherever required.
· Developed read only module for Advance Collection UWQ and IEX workbench by using OAF.