$100

Hourly Consulting Rate

Sanjeev Khurana

Independent Consultant

Industry Experience

Accounting

Financial Services

Information Technology/IT

Insurance

Logistics/Procurement

Transportation

+ 2 More

Location Supported

Worldwide

Canada

India

United Arab Emirates

United Kingdom

United States

Langauages Supported

English

Hindi

Punjabi

Skills

  • Functional consultant
  • Project management
  • Application development
  • Security/compliance governance
  • Business intelligence
  • Analytics
  • ERP
  • +3 more

Product Specialization

  • Oracle ERP Cloud
  • Tableau Software
  • Oracle E-Business Suite

About

11+ years of experience working large scale and complex projects with diverse business/technology needs.Proven track record of successful implementation of Oracle E-Business Suite ERP (Enterprise Resource Planning) projects in IT/Manufacturing/Transportation/Financial/Insurance and Supply Chain Management domains such as Sun life Financials, Metrolinx/Go Transit, General Electric, Canon Eagles (Legacy System), Tube Lines (London Subway) etc. Expert in Oracle E-Business Suite 11i, R12, Fusion (Cloud based) ERP in SCM (Procure to Pay, Order to Cash), Finance (Account Payables, Account Receivables, General Ledger, Fix Assets, iExpense and Cache Management, Project Accounting, Oracle Discoverer Reports, XML BI Publisher reports, Tableau, Inbound and Outbound Interfaces etc.

Top Project Highlights

SIRIS Oracle

SIRIS stands for SLF Integrated Reporting Information System. SLF definition for SIRIS contains many modules in Oracle E-Business Suite- General Ledger, including the Financial Data Repository (FDR), Discoverer, Tableau, Longview Financial Close and Tax, eFreedom and Accounts Payable & Purchasing, Banking tools - Payment Inquiry (PID), CATT, Banking Information Directory (BID) and The Banking System (TBS).

Integrate Metrolinx

Integrate Metrolinx is a multi-year Enterprise Resource Planning (ERP) program, which includes many projects that enhance existing technologies or introduce new ones.

One of the largest projects in Oracle ERP. It automates, simplifies and integrates key business processes so that Metrolinx improves the way it enters, saves, manages and analyzes data in groups, such as Human Resources, Finance, Procurement Services, IT and the Capital Projects Groups.

GE SSS PMO Re-implementation

Objective of this project was to multiple country re-implementations from Oracle Apps version 11i to R12 and intended to provide new Buy to Pay Operating Units for USA and Canada in Oracle Apps R12 environment and oracle Siebel CRM. Application has been connected with several ERP’s and CRM system. This project has been kicked off in January 2014 and went live in November 2015.

Canon Eagles (Legacy system)

Objective of this project was to enhancement of (L2) base project implemented under Order to cash and Procure to Pay cycles. Canon has divided their business into CIG (Consumer Imaging System) and BIG (Business Imaging System) part.

Employment

Business Systems Consultant - Oracle Financials

2009 - Present
    • Responsible for Requirement gathering, finalization, elicitation, Project timelines, scope, budgeting, costing etc.
    • Responsible for leading team in various financial applications like Oracle EBS, Tableau Reporting, Longview, Aptitude ALAE, Aptitude Accounting Hub- AAH, Concur, SAP Ariba etc.
    • Involved in Project Management tasks and assisting Project Manager for weekly and biweekly review meetings with all team and track status.
    • Involved in Business Production support related to Procurement P2P and Financials modules like General ledger, AP, AR, iExpense, Cash Management, Tableau, Discoverer, Aptitude Accounting Hub,  ALAE, Longview Close and Tax, StatementPro etc.
    • Responsible for Business Production support along with Enhancement with end-to-end implementation.
    • Involved in preparation and distribution of quarterly SOX reports (APPO and GL) and responsibilities, Access to Business users among different Business Areas.
    • Involved in leading Projects and working closely with technical team (Developers) to have walkthrough on requirements.
    • Managing and controlling Securities with respect to roles and responsibilities of Business users for their access.
    • Planned and defined system requirements to Use Case, Use Case Scenario and using UML.
    • Involved with QA testing team for validation of test scenarios for SIT and UAT to ensure that the delivered data regarding orders and corresponding invoices.
    • Analysing the tables on performance base regularly. Involved in daily monitoring activities of Business.
    • End-to-end review and analysis of IT solutions submitted by different teams and making sure each solution aligns with the all others.
    • Responsible for Code Migration activities as change coordinator to review change requests and approve/reject based on criteria.
    • Delivered detailed artefacts such as requirements documents, use cases, prototypes, traceability matrices, as-is and to-be process flows etc. to clarify business process requests and expected functionality of project. 
    • Document and analyze business processes, system requirements, screens and report layouts, output levels, and conduct data flow analysis and business process modelling
    • Work with business stakeholders and technology partners (internal and external) to analyze, develop and    recommend technical solutions, which support business strategies.
    • Responsible for Requirement gathering, elicitation, Project timelines, scope, budgeting, costing etc.
    • Involved in Project Management tasks and help PMO team for reporting etc.
    • Involved in production support activities, resolve SR’s, Incidents and on call stand by etc.
    • Involved in Production issues resolution and debugging coding etc.
    • Participates in implementation and post implementation activities (e.g. Deployment, Contingency Planning, First Occurrence Verification and Lessons Learned).
    • Preparation of Oracle Functional documents MD50 as per requirement from Business.
    • Preparation of Oracle BR100 setup documentation and involved in Operating Unit setups as per requirement.
    • Involved with Development team to walkthrough Functional specification documents as per Business requirement and to help them to prepare MD070, MD120 release notes etc.
    • Expert in Procure to Pay, Order to cash, iProcurement, Purchasing, AP, AR, GL, FA, CE, Internet Expenses, Project Costing and HRMS etc.
    • Worked on Oracle Fusion Financials modules like AR, AP, GL, Expense Management, Asset Management and Cash Management etc.
    • Created new oracle alerts as per business requirements, prepared the SQL scripts for creating the Oracle Alerts in Oracle EBS allocation.
    • Worked on Account Payables, Account Receivables, Order Management, Tax systems, General Ledger, Advance EBS, Purchasing, Channel Revenue Management and Hyperion GL Reports etc.
    • Provided post implementation support to Business on issues like Requisitions, Purchase orders, invoices stuck in workflow, order not scheduling, and invoice payment not happen, accounting entries in GL balancing etc.
    • Coordinate with end users, application and technology groups to ensure accurate and effective workflow, operating procedures and implementation of services.
    • Planned and defined system requirements to Use Case, Use Case Scenario and using UML.
    • Involved with QA testing team for validation of test scenarios for SIT and UAT to ensure that the delivered data regarding orders and corresponding invoices.
    • Worked with HP ALM/QC, QTP tools for run test scripts and defects creation process in SIT1, SIT2 and UAT.
    • Analysing the tables on performance base regularly. Involved in daily monitoring activities of Business.
    • Responsible for oracle E-Business Suite R12 Requirement elicitation, Project timelines, scope, costing etc.
    • Worked Closely with Scrum manager for daily scrum meetings and product owners as well.
    • Delivered SIT on time and budget to Application Delivery Senior Management and business owners.
    • Involved in Oracle E-Business Suite SCM, Finance, HCM, OAB and HRMS specific implementation setups.
    • Involved in ERP Financials implementation and support – Account payables, Account Receivables and General Ledger.
    • Worked on Inventory, Oracle Advance Benefits, Human Capital Management, Account Payables, Account Receivables, Order Management, vertex, Tax systems, Sabrix, General Ledger, Advance EBS and Purchasing etc.
    • Provide business new benefit plan types, rates, coverage, life events etc.
    • Involved in data migration activities from one ERP system to another.
    • Worked on HRMS Employees payroll, Assignments, Projects etc.
    • Involved in Data Ware housing.
    • Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
    • Provide on-call support to production system to resolve any issues.
    • Gather requirements and design of data warehouse and data mart entities.
    • Worked closely with Development team and QA testing team for development of required functionalities and testing as per Business requirement.
    • Involved in Month end specific activities, preparation, period closing and generating reports with business.
    • Worked closely with RBC for GE specific requirements related to Payments, Checks design and layouts etc.
    • Managed issue/gap meetings and requirements traceability document updates for vendors, project team, and executives.
    • Running JAD sessions with different IT units and business to finalize the solution.
    • End-to-end review and analysis of IT solutions submitted by different teams and making sure each solution aligns with the all others.
    • Presented project team demo in front of the audience of 50+. Provided timely updates to Sr. Management
    • Reviewed QA's work, test execution and completion. Ensure adherence to daily progress agreed
    • Directly communicated with shareholders, business owners and senior management on project progress
    • Managed Shakedown (Smoke Tests) activities. Facilitated beginning/end of day project status reviews
    • Presented project team demo in front of the audience of 30+. Also, facilitated retrospective meetings, Stand up meetings, Cost estimation sessions and participated requirement elicitation sessions. 
    • Reviewed QA's work, test execution and completion. Ensure adherence to daily progress agreed
    • Directly communicated with shareholders, business owners and senior management on project progress
    • Participated in operational work stream meetings, identifying and validating business requirements for the corporate and commercial credit card application 
    • Worked closely with System and manufacturing for User Acceptance Testing (UAT) to support the design of end-user tasks for the corporate and commercial credit card application. 
    • Supported end-users and other team leaders in daily reconciliation efforts 
    • Participated in Threat Risk Assessment (TRA) and performed (SWOT) analysis for the project. 
    • Participated throughout the project from initial stage to Go-live.
    • Delivered detailed artefacts such as requirements documents, use cases, prototypes, traceability matrices, as-is and to-be process flows etc. to clarify business process requests and expected functionality of project. 
    • Liaised with third-party external organizations to fully understand business requirements and to identify effective project/program solutions (i.e. Regulatory Bodies, Strategic Partners, and Suppliers of IT solutions) 
    • Supported the project manager throughout the project life cycle to ensure business requirements and timelines are met.
    • Document and analyze business processes, system requirements, screens and report layouts, input costs and output levels, and conduct data flow analysis and business process modelling
    • Work with business stakeholders and technology partners (internal and external) to analyze, develop and    recommend technical solutions, which support business strategies.
    • Involved in production support activities, resolve SR’s, Incidents and on call stand by.
    • Participate in implementation and post implementation activities (e.g. Deployment, Contingency Planning, First Occurrence Verification and Lessons Learned).
    • Preparation of Functional designed documents MD50 as per requirement from Business.
    • Involved with Development team to explain them Functional specification documents as per Business requirement.
    • Good Experience in Procure to Pay, Order management, Purchasing, Order to cash, Payables, Receivables and General Ledger.
    • Created new oracle alerts as per business requirements, prepared the SQL scripts for creating the Oracle Alerts in Oracle EBS allocation.
    • Worked on Account Payables, Account Receivables, Order Management, Human Capital Management, Oracle Advance Benefits, vertex, Tax systems, Sabrix, General Ledger, Advance EBS, Purchasing, Channel Revenue Management etc.
    • Involved in ERP Financials implementation and support – Account payables, Account Receivables and General Ledger.
    • Provided post implementation support to Business on issues like orders, invoices stuck in workflow, order not scheduling, and invoice payment not happen, accounting entries in GL balancing etc.
    • Coordinate with end users, application and technology groups to ensure accurate and effective workflow, operating procedures and implementation of services.
    • Planned and defined system requirements to Use Case, Use Case Scenario and using UML.
    • Worked with QA team for validation of test scenarios for UAT to ensure that the delivered data regarding orders and corresponding invoices.
    • Analysing the tables on performance base regularly. Involved in daily monitoring activities of Business.

Education

B.Tech Computer Science
2004-2009

B.Tech Computer Science

Certification

B.Tech
2004-2009

Ooops!

Maximum of Three products are allowed for comparision