ASJIT SODHI

Business Analyst/Program Manager

E: ac2cwp@r.postjobfree.com C# 610-***-**** San Jose, CA

PROFESSIONAL SUMMARY

Seasoned ERP Business Analyst/Program Manager with 10+ experience in Requirements gathering, Analysis, Design, Unit & Integration testing and Implementation of E-Business applications using Oracle ERP 11i/R12.

Business expertise in Procure to Pay, Invoice Management, Revenue Recognition, expertise in Order To Cash and Bookings and Sales Commissions, Customer Master (TCA) and HRMS.

Proficient with the data entities and their relationships in E2E Financial ERP Systems and HR Modules – PO, AP, OM-AR, Bookings, Discount Datamart and Commissions, Revstream, INV, HRMS(US/Latin America) and User Administration.

Expertise in designing Solution Design or Functional Solution Design (SDD/FD/MD50/BR010/FRD).

Facilitating meetings with the Teams – Business and IT/QA during the SDLC phase.

Business expertise in Oracle Setups and Hands-on expertise in Oracle Applications 11i and R12.

Elaborative work experience in RICE customizations (Reports, Interfaces, Conversions and Enhancements).

Ability to interact effectively with business users and Business teams, understanding the project scope & requirements and providing optimum solution and support.

Sabbatical due to child birth From : Nov 2015

WORK EXPERIENCE:

Client: VMware Sep 2014 – Nov 2015

Company: Skoruz Technologies

Role: Oracle Business Analyst

Description: Worked as a Business Analyst with expertise in the Financial systems - AR/Revstream/Bookings/Discount DataMart and Sales Commissions. Acting as a liaison for IT and the Business teams.

Responsibilities:

Hands-on experience in Subscription Delivery Platform for cloud computing implementations in Oracle 11i responsible for Invoice generation and support in Finance domain explicitly.

Worked on Subscription Delivery Platform (SDP), Subscription Purchasing platform (SPP), Hybrid Credits Purchasing Program (HCPP) for cloud computing products and services offered by VMware.

Involved in E2E implementation for SDP, SPP and HPP Business requirements with the Business teams.

Working proactively narrowing down all the tangible requirements and providing a holistic solution design making a robust system.

Delivering Functional Solution Designs per the project requirements and later assisting the QA and Business User Teams to have the project executed in a seamless manner.

Keeping up with scheduled deadlines and providing the Business trainings and conducting the Support KTs.

Environment: Oracle Applications R12/11i

Functional Modules: OTC, Revenue Recognition, OM, AR, Bookings and Sales Commission systems, GL, TCA (Customer Master).

Client: Ricoh Americas Corporation Jan 2011 – Jun 2014

Company: Infosys Technologies Limited

Role: Business Analyst

Description: Worked as Business Analyst for the IT and the Business Teams for the Oracle Finance projects in Oracle 11i and R12.

Responsibilities:

Responsible for Requirement gathering and analysis, working with Business Teams understanding the project requirements and scope.

Responsible for designing and integration testing (CRP/UAT) of custom applications in R12 and Existing 11i customizations.

Working on the solution design catering the business requirements, scheduling/preparing KT plans, working on the Configuration Management, doing Impact Analysis for the new projects.

Responsible for chairing the entire Project Status Reporting, Issue Escalation, Resource Allocation, communicating delivery dates and following up on the deliverables onsite.

Handling of all BAU Activities for AP/AR/GL/OM, Collections and HRMS US Payroll.

Responsible for providing the Strategy Documentation for various migration activities (from Oracle 11i to R12, Oracle to legacy platform, legacy system to Oracle etc.)

Involved in Code Reviews and Document Sign-offs from Business Teams.

Involved in Milestone Acceptance testing, Unit testing and system testing. Involved in end user training & data validation.

Generating the Project Milestone Reports and evaluating effort Vs defect charts.

Managing a development team in offshore including 8-10 team members.

Environment: Oracle Applications R12/11i

Functional Modules: AP, AR, OM, Collections, GL, TCA (Customer Master) and HRMS US Payroll.

Company: Infosys Technologies Limited Apr 2010 – Dec 2010

Role: Junior Business Analyst

Client: ARROW ECS

Description: The project involved maintenance/enhancement, and Production Support of Oracle Application suite projects in 11i. Worked with Business Users post deployment for 24 X 7 Prod Issues.

Responsibilities:

Involved in requirement review sessions with functional team in case of issues for the deployed customizations.

This project was a Support for the deployed customizations, the project demanded knowledge and expertise in AP and OM primarily. Responsible for acquiring knowledge on Pricing and Modifiers in particular and sharing the same with team members.

Handling the 24 X 7 Support for the Arrow ECS account.

Responsible for code review, onsite-offshore coordination, code drop to various instances (QA, UAT, and PROD).

Involved in end user training, data validation.

Responsible for knowledge management – scheduling/preparing KT plans, primary/secondary support etc.

Environment: Oracle Applications 11i.

Functional Modules: AP and OM (Pricing and Modifiers)

Company: Infosys Technologies Limited Oct 2009 – Apr 2010

Role: Functional Analyst

Client: EXTERRAN

Description: The project involved data migration from legacy systems to Oracle Apps 11i and maintenance/enhancement of Oracle Application suite projects

Responsibilities:

Worked on the data migration related activities including data cleansing, exception analysis, design, development, production support for the PLM Module.

Responsible for performing the analysis activities to ensure the accuracy of the data conversion for various entities.

Responsible for performing end to end testing for various conversion entities, including front end validation.

Responsible for scheduling the project, estimation, status update etc.

Responsible for providing the conversion strategy, various validations needed, exclusion criteria, rollout strategy etc.

Responsible for code review, team lead, conducting various audits, scheduling sessions with end users.

Exception analysis and reconciliation during conversion activities

Responsible for knowledge management – scheduling/preparing KT plans, primary/secondary support etc.

Environment: Oracle Applications 11i.

Functional Modules: PLM and Procurement

Company: Infosys Technologies Limited Dec 2008 – Sept 2009

Role: IT Analyst

Client: ARROW Unity Electronics

Description: The project involved Data migration from various Legacy systems or Oracle 11i to Oracle R12. Components including interfaces and conversions was build and deployed successfully to achieve the project requirements.

Responsibilities:

Worked on the data migration related activities including data cleansing, exception analysis, design, development, production support.

Responsible for performing the analysis activities to ensure the accuracy of the data conversion for Partner entities for ARROW.

Responsible for performing end to end testing for various interface/conversion entities, including front end validation and third party legacy systems using the SOA middleware.

Responsible for scheduling the project, estimation, status update etc.

Responsible for providing the conversion strategy, various validations needed, exclusion criteria, rollout strategy etc.

Responsible for code review, Interface team lead, conducting various audits, scheduling sessions with end users.

Exception analysis and reconciliation during conversion activities

Responsible for knowledge management – scheduling/preparing KT plans, primary/secondary support etc.

Worked on the full life cycle of the software development process including requirements definition, prototyping, technical design, interface design and implementation.

Environment: Oracle 11i / R12.

Functional Modules: Customer Master Architecture and Vendor Setups primarily from AP/AR.

Company: Infosys Technologies Limited Nov 2007 – Nov 2008

Role: IT Analyst

Client: Nordstrom Inc Ltd.

Description: The project involved a complete end-to-end RICE development in Oracle Ebiz suite for data migration activities from legacy systems to Oracle.

Responsibilities:

Worked in the IT team responsible for doing risk analysis on the new projects planned to be implemented and documented the FRDs.

Worked on the full life cycle of the software development process including requirements definition, prototyping, interface design and implementation.

Responsible for performing the analyst activities to ensure the accuracy of the data conversion for various entities.

Responsible for performing end to end testing for conversion entities and setups needed.

Involved in various research activities like Oracle iSetup Utility for data migration in 11i etc.

Responsible for conducting demo to the end users to demonstrate the functionality of the new customizations developed.

Responsible for knowledge management – scheduling/preparing KT plans primary/secondary support etc.

Environment: Oracle Applications 11i

Functional Modules: Procurement and General Ledger accounting

Company: Infosys Technologies Ltd Sept 2006 – Nov 2007

Role: Software Engineer

Client: Toshiba of Canada Ltd

Description: This project emphasized on creation of new 6i Reports for Toshiba of Canada Ltd. Reports to review the monthly movement of the inventory, reports to review the monthly accounts and the revenue incurred for the placed orders. Backordering mechanism and traction on the inventory.

Responsibilities:

Responsible for the below

Involved in the meetings with the end users to understand the existing system and preparing documentation (reverse engineering)

Responsible for requirement gathering and requirement document preparation.

Created high/detailed design documents.

Responsible for design/build review for AP, AR, SCM, and Inventory modules.

Conducted trainings to the users to demonstrate the functionality of the new UIs/customizations.

Responsible for configuration/release management

Responsible for end user training and post production support.

Responsible for integration, end-to-end testing.

Environment: Oracle Applications 11i, Oracle 9i

Functional Modules: Order Management and Inventory Modules.

SKILLS/HANDS-ON TOOLS

Oracle E-Business Suite

11i & R12

ERP Modules

Procurement including Purchasing, Oracle Account Payable and Invoice/Payment methodologies.

Invoicing and Revenue Recognition including Account Receivables, Advanced Collections Invoice Management,

OTC including Order Management (OM), Invoicing, Receipts and Lockboxes

Bookings and Sales Commissions including Order Management and Discount DataMart

General Ledger, Customer Master (TCA) and HRMS.

RDBMS Tools

Oracle 9i/10g/11g, MS SQL Server, SQL* Plus, SQL Raptor, TOAD,

Quality Tracking Tools

Mercury Quality Center, HP Quality Center, Salesforce, Service Now.

Microsoft Tools

MS Excel, MS Word, PowerPoint, MS Access, SharePoint, Tableau, Visio

Operating System

Windows 10/8/7/Vista/XP/NT/2000/98/95.

EDUCATION/CERTIFICATIONS:

Bachelors of Technology in Computer Science Engineering, CET (Chandigarh Engineering College, affiliated to Punjab Technical University, Jalandhar, Punjab, India) Chandigarh, India.

REFERENCES:

Provided upon request.

Contact this candidate