IT Business Analyst
Chalhoub Group
Total years of experience :17 years, 7 Months
Over 11 years of quality focused end to end experience as Techno-Functional Consultant and Business Systems Analyst in Oracle ERP systems implementation, upgrade and managed services.
PRINCE2 Practitioner with extensive experience in all project phases and aspects - project management & controlling, business process analysis, change and stakeholder management, agile technical delivery (RICEFW/CEMLI) and release management.
Adept in retail business processes with competency in Oracle RMS (retail merchandising system), ReIM, ReSA and their integration with Oracle EBS Financials.
Proficient in O2C (order to cash) and P2P (procure to pay) business flows from Finance perspective. Thorough technical and functional knowledge in AR, AP, FA, CM, GL, iPayments, EB-Tax (VAT), Property (PN), AGIS, PO, OM modules.
Oracle Certified SOA 11g Specialist in systems integration using Oracle Fusion Middleware with expertise in AIA integration flows, Oracle PIPs, BPEL, OSB, Mediator and Business Rules.
Proficient in PL/SQL, performance tuning, D2K (forms/reports), open interfaces (API), SOA/XML gateway, Workflow, JDeveloper, UNIX shell scripting and other technical tools.
Understand the end to end business flows and processes relating to the retail business of Alshaya and gain insight on the overall system architecture
Lead the IT ops team for effective ticket response and resolution meeting agreed SLA norms
Liaise with Business/Process owners on various IT issues and identify areas for improvement and devise plan for implementation
Work with process owners on month/year end activities and ensure smooth and trouble free closure of periods.
Manage the defect fixing team and control the open defect count by effectively triaging issues based on criticality
Coordinate with the customer IT team on defect prioritization and release management
------------------------------------------------------------------------------------------
Effectively lead the team to monitor the batch and reported issues/incidents resulting in smooth execution of batch.
Achieved 100% SLA compliance and reduced the open, aged incident count from 100 to less than 15 in a month’s time
Provided solutions for various technical and functional problems relating to application integration, Invoice processing, Automatic Receipt creation, FA depreciation etc.
Devised various plans for effective incident and problem management and implemented them effectively
Introduced the knowledge management framework for defects, thereby improving throughput of team members in resolving repeated defects
Architected and designed the integration solution in conjunction with the customer architecture team, and proposed many best practices during the design.
Lead the development team to deliver high quality code providing inputs on various technical issues
Designed the AIA components of ABCS, EBS, customizing the required schemas as well as creating consumers for EBiz events.
Proposed and created web service based rejection handler which was reused across all the other integration projects in UL
Trained the internal development teams on SOA 11g and AIA concepts for better understanding of the project
Lead the development team to deliver high quality code providing inputs on various technical and functional issues
Designed the custom servlet integration with the external payment solution providing seamless integration for the super critical credit card payments.
Delivered complete documentation for the payments module with the end user workshop, to educate the users on the new processes
Trained the internal development teams on payment system integration with respect to Oracle ERP.
Achieved on-time delivery of all objects with minimal defects and with high quality codes, commended well by the clients
Provided numerous solutions and designs for re-engineering of
various processes like vendor payments, cash application and lockbox reconciliation
Effectively designed and lead the team in value added services by creating reusable components and productivity tools greatly reducing effort in entire practice
Conducted numerous workshops and training for practice as part of technology incubation for resources and streamlined the processes
Created RD020, BR100 and other functional documents as an outcome of the initial requirement discussions with users
Devised technical solutions for OCR and Garnishments invoices interface with storing the actual invoice image as an attachment
Configured and elucidated the entire EBTax solution with the complete regime to rate setup and exceptions for jurisdictions. Created custom solution for US UseTax calculation.
Effectively led the team for on-time delivery of technical components which include forms, XML Publisher reports, interface programs.
Redesigned and brought immense improvements to the payments business process by devising the EDI solution, as well as check printing using XML Publisher
Effectively lead the team to monitor the batch and reported issues/incidents resulting in smooth execution of batch.
Achieved 100% SLA compliance for over 3 quarters as the shift lead, with high turnaround on reported issues.
Provided solutions for various technical and functional problems relating to BPEL/SOA, Invoice processing, Statement Import etc.
Involved in the process re-engineering of the custom POS solution which resulted in high revenue recognition and customer satisfaction, thereby helping huge sales.
Devised various plans at the account level for effective incident and problem management and implemented them effectively with the support of practice managers.
Conducted various Practice level training on business processes, technology and methodologies.
Initiated and implemented a project for effectively deploying rookies into support activities. Successfully deployed 7 campus recruits and made them billable without compromising on the quality of deliverables.
Resolved various BPEL issues and redesigned many BPEL processes for scalability and performance considerations
Received client and onsite commendation for various production support activities
Effectively lead the team to monitor the batch and reported issues without any breach of SLA.
Analyzed the performance issues of key processes and worked with the DBA team to resolve them, for instance the lockbox performance improvements
Was able to provide various process improvements that resulted in smoother execution of the batch
Involved in the analysis of various business critical defects (such as iPayment Settlement, AP invoice interface, Collections queue etc) and resolved them
Planned and executed the defect drive down activities by leading the team effectively without any compromises to the quality of the deliverables
Trained new team members on the business processes and technical details of the client
Resolved various BPEL issues and redesigned many BPEL processes for scalability and performance considerations
Received client and onsite commendation for various production support activities
Involved in the design and development of Automatic requisition loader avoiding manual efforts to load thousands of PO requisitions
Involved in the development of credit card settlement processing with the third party provider called AJB viz iPayment Servlet and reported it through Web PL/SQL
Consolidated the custom Payables Invoice interface program for invoices from third party systems using BPEL integration
Designed and developed real time supplier interface to systems like GSS(DB2), PeopleSoft and RMS using BPEL
Built various inbound and outbound interfaces like GL journal creation, Cash reconciliation, lockbox processing, credit check, MQ polling, invoice payments using BPEL, ESB and OAGIS standards
Involved in the performance tuning activities of various reports and program units thereby improving throughput
Developed the Supplier audit report using Flashback features of Oracle 10g
Solutionized and Designed the SetupSync (instance consolidation) tool and lead the development team for successful delivery
Traveled to the US to support cutover and go-live activities, received good commendations from client on successfully go-live of the EBS modules without any major issues.
Discussed with clients on viable options for the XLAR interface to upload AR transactions to Oracle through Excel
Designed and developed the XLAR interface using VB Macros - it's a highly automated tool to load AR transactions into Oracle
Transitioned the knowledge on VBA for Excel as well as the XLAR component to other team members
Received client commendation for the successful implementation of the XLAR interface
Developed inbound and outbound interfaces for NowDocs system (part of Demand, Print and Ship) to Oracle Apps using BPEL PM, Oracle AQ and business event system.
Customized the standard Process PO 007 XML message for Supplier outbound using XML gateway and integrated the trading partner system
Designed and developed customized Supplier Inventory Feed process to update on hand inventory quantity realtime using BPEL and Forms 6i.
Developed the PO Acknowledgement process for supplier feedback using BPEL.
Designed and developed the Custom Objects Explorer tool as part of the CoE offering to Office Depot.
Course Institution Board/University Year of Passing Percentage/CGPA MS, Software Engineering Wipro Academy of Software Excellence (WASE) BITS, Pilani 2010 8.67/10
B.Sc Mathematics DG Vaishnav College Madras University 2006 90.1%
AISSCE (XII) Kendriya Vidyalaya CBSE 2003 76.8%
