SAI TARUN JALADI

Oracle ERP Business Analyst

Email: adbo4g@r.postjobfree.com / Contact: 937-***-****

PROFESSIONAL SUMMARY:

5+ years of experience in leading and implementing ERP (Oracle 11i, R12) based business solutions, using Oracle modules for clients across industries.

Worked on 2 Oracle implementations involving large scale and complex business transformation.

Hands-on experience in designing complex integrations using SaaS (Software as a service) platforms such as Salesforce CPQ, Oracle CPQ Cloud and CLM with Oracle ERP by using Cast Iron, Informatica and Oracle SOA as middleware.

Extensive Experience on configuration enhancements, RICE customization, setups, process design of Manufacturing and Distribution modules AND SCM( OM, AR, AP, INV & PO), Adv. pricing, I-supplier, I-procurement,Service Contracts and Install Base Modules.

Well versed with AIM Methodology. Created BR100’s, MD050’s & contributed towards MD070 to document configurations Functional and Technical specifications.

Comprehensive knowledge in all aspects of software development life cycle (SDLC) such as performing fit-gap analysis, writing functional specifications, implementing/customizing oracle applications to suit client requirements, solution design.

Proven track record of delivering projects in agile methodology.

Very strong in Oracle SCM modules and experience in analyzing business requirements.

Developed solutions for RICEW Components.

Involved in R12 SCM (Procure to Pay and Order to cash and Quote to cash) Implementation Projects.

Worked with oracle support, using metalink, to resolve issues using knowledge base, SR/TAR.

Worked Effectively on TOAD on 9i and 10g Database, SQ Developer, XML and BI publisher.

Worked on implementation of supplier life cycle management (SLM).

Worked in Production support and involved in activities like Monitoring, trouble shooting, documenting.

Involved in testing of different oracle modules functionality as and required during the roll outs.

Worked on ad hoc reports to provide the financial data as per business and user needs.

Integration of third party tools/software to Oracle EBS.

Experienced in designing business processes, documenting standard operating procedures and training business users in these procedures. Also training client users at various levels from clerks through super-users.

Experienced in functional testing, integrated testing, setups, design validation and conducting conference room pilot.

Technical experience with Design, Development, Implementation, Customization and Production Support of Oracle Applications.

Has technical knowledge on review the objects like packages, procedures, and report scripts.

Experience in writing SQL queries.

Well versed with traceability and Audit and Familiar with SOX procedures.

Dedicated fast learner with good commutation, interpersonal skills,

Skill Set:

Oracle Supply Chain Management

Oracle CPQ Cloud

Oracle ERP Cloud/SaaS/PaaS

Strategic Planning and Business Process Analysis/Change

Project Management

Agile Methodology

Scrum Master

Work History:

CDK Global, Hoffman Estates, IL April 16 to till date

Role: Oracle Business System Analyst III

Modules Worked: Order Management (OM), Oracle Account Receivables (A/R), Oracle Inventory (INV), Oracle Account Payables (AP), Pricing, Oracle Service Contracts (OKS), Oracle Install Base (IB) and Oracle Purchasing (PO), eProcurement.

Accounting: Revenue Recognition (RevRec) including Costing.

Other Systems: Quoting Tool, Contracting Tool, Oracle CPQ (Configure Price Quote), SFDC (Sales Force Dot Com), RODOPI, Data Warehousing, Zycus.

Middleware: Cast Iron, Informatica.

Reporting: Cognos, Salesforce

Tools: Toad, Excel, Winscp, XML, Microsoft Word, Microsoft Project, Microsoft Visio, Jira.

Projects:

CDK Smart Quote (Oracle CPQ)

Revenue Recognition (Revenue and Costing)

Zycus Procurement Cloud (Source to Settle/Procure to Pay)

Oracle Price Increase into OKS

ELEAD One (Sage CRM)

Oracle EBS-Requirement, Analysis and Design

oQuote to Cash (Q2C), Order to Cash (OTC), Procurement Activities.

Key Responsibilities:

Designed and documented the integration of cloud applications to/from on-premises legacy systems using APIs, middleware and SFTP.

This development created seamless communication between existing CDK systems (Internal) and cloud applications.

CDK Smart Quote: Oracle CPQ is a cloud application which provides a cloud based configure, price and quote (CPQ) system that offers extreme ease of use and configurability.

oResponsible for implementing the Oracle CPQ which automated and streamlined the opportunity to order conversion cycle and which acted as a bridge between front end CRM processes and the back end Order Management and fulfillment systems.

oConversion Information: Master Data Management (MDM) include Catalogs, Customers, Pricing, along with Service Contracts, Install Base and Rodopi (IPNS Billing).

oIntegrated Information: Contracts Information flow from CPQ to Oracle OM to Contracting system, Service Contracts to SFDC, Install Base to SFDC, Order Release Integration from Quoting and Contracting Tool to Oracle OM to SFDC, Catalog integration to SFDC, Pricing integration to CPQ, Customer Integration (Include Bill to Override and Bill to Default) to CPQ, Service Contracts main billing to AR.

oResponsible for building reports for the users using the COGNOS.

oResponsible for all the Legacy attribute setup in Oracle ERP (Lookup creations, Value Sets creation and DFF Setup) and responsible for conversion and delta information integration from legacy system to Oracle APC (Advance Pricing Catalog).Familiar with all PPV, PRH setups in Oracle APC.

oInvolved in customizing seeded workflows including workflow background process.

oInvolved in discussions with DEV and Cast Iron (Middleware) and SFDC team on design work through sessions, POC sessions.

oInvolved in blue print/requirement gathering sessions with business to collect requirements around quote to order processes like pricelist upload, bracket pricing, qualifier setups, items conversion/integration, receipts interface, inventory adjustments, shipping and sales order interface, IB and OKS records creation.

oCoordinated with Oracle DEV, SFDC, Cast-iron & legacy applications team during the design, development, testing & migration phases of the project.

oInvolved in sorting out billing issues related to CDK Smart Quote project.

oProduced charts and diagrams to assist with problem analysis.

Revenue Recognition (Revenue and Costing): Purpose is to automate revenue accounting across CDK Global in order to be compliant with ASC 606, the new revenue recognition standard and ASC 340-40, other assets and deferred costs – contracts with customers.

oImplementing/Configuring ASC 606 accounting standard in RevPro application.

oUnderstanding the business data from Oracle ERP, specifically Order to Cash data flow for revenue process and other 3rd party systems for cost process.

oInvolved in processing the OKS/SO orders, Invoices for Revenue Recognition using Oracle ERP.

oInvolved in performing all the completeness checks before sending the file for processing into Revpro.

oResponsible for large amount of data conversion from below systems as retrospective method to adapt to ASC606 was decided.

COMMISSIONS

CALLIDUS

SFCOM

TIME TRACKING

Salesforce

Recreation (Task Ray)

Focus

Wand (PRO Unlimited)

TIME & EXPENSE

Concur

FREIGHT (Oracle ERP)

oResponsible for AD-hoc reporting requests from the Revenue/Costing team.

oResolved issues raised by the respective teams while processing the files to Revpro.

oWorked with the Zuora team to get closures on the issues raised by the revenue/costing teams.

oResponsible for all the Salesreps commissions flow from the CDK Internal Systems (CLM) to Revpro which originates in CALLIDUS and SFCOM.

oResponsible for all the Cost Amount calculations for all the source systems taking the POB/SSP into considerations.

oInvolved in customizing the seeded workflows.

oPrepared high level costing data flow (VISIO) from individual source systems to Revpro.

oInvolved in providing technical assistance to DW (Data warehousing) team to build COGNOS reports for costing.

oInvolved in designing the WEB PAGES for Users to view the Cost Summary and Detail data using the UI as well as developing function to run Month End interface via WEB PAGE.

oInvolved in implementing the rules for CAPTIAL EXP GL, CAPTIAL DEF EXP GL, AMAORTIZE EXP GL, and AMORTIZE EXP GL deriving for Revpro balancing.

oResponsible for creating reports for SOX Audit purposes.

oResponsible for validating and get sox approval for RRC-07 and RRC-06 controls for both CDK Internal Audit and Deloitte Audit team.

Zycus eProcurement (Source to Settle/Procure to pay): Source-to-pay or S2P/P2P is the entire end-to-end process involved in procurement. It spans every process, right from spend management, strategic sourcing and vendor management to purchasing, performance management and accounts payable.

oConducted requirement gathering sessions and documenting business processes from the end users.

oResponsible for below Integrations from Oracle to Zycus and Zycus to Oracle (Outbound and Inbound):

Users

Suppliers

GL Accounts

Invoices

Credit Memos

Payments

Payment Reversal

Apportionments

Apportionments Reversal

oResponsible for designing the US tax rules and CAN tax rules for the US/CAN Invoices processing.

oResponsible for designing the US/ CAN Tax amount classifications

oResponsible for validating the expedite UAT and Software Development Life Cycle (SFDC).

oResponsible for using the Account Payables; EFT (Electronic Fund Transfer) for Zycus related vendors.

oResponsible for designing the exception report for each integration to ensure users have enough information to fix any possible errors for reprocessing.

oInvolved in designing the data flow via XML files for both INBOUND and OUTBOUND Integrations.

oWell versed with all modules like iSupplier, eInvoice, and I-Procurement.

oWell versed with Zycus functionality, like creating Invoices, Credit Memos and accessing the Master Data.

oActively worked with Zycus support team on the Service Requests closed in timely manner.

oResponsible for writing I-spend analysis query and providing outputs to Zycus team.

oCoordinated and managed testing process with customer from engagement to deployment.

Oracle Price Increase to Service Contracts (OKS): This enabled a new feature for client to provide Price Increase for customer, Price Increase was given Quarterly and Monthly.

oInvolved in designing and oversaw development of Price Increase Application that integrated to Oracle Service Contracts (OKS).

oPricing Team will run the application monthly to modify hundreds of thousands of service contract lines and generate millions (Approx. 20Mil) in revenue every year.

oPrepared high level Visio flow of Price Increase flow (starting from exceptions, limitations, price protection to update service contracts billing schedule).

oProvided training for the users on how to use the Price Increase functions created in Oracle ERP and documented the execution process for each sub process (like how to add/remove exclusion).

oInvolved in developing COGNOS reports for users to view Forecast and Actual Price Increase.

oResponsible for developing the Forecast process for users to view the customers who are eligible to get Price Increase in next 4 quarters and next 12 months.

oResponsible for developing a process to send the Price Increase emails to the customer based on the Forecast.

ELEAD ONE (Sage CRM): Acquisition (By CDK)à Shutdown (Existing Sage CRM Legacy system)à Startup

oInvolved in Joint Application Development and Requirement sessions.

oResponsible for managing end to end conversion effort, coordination of Master Data elements, including Traceability and Audit.

oEnd to End conversion include, Master Data setup, required lookup, DFF enable, creating the contracts in existing legacy systems and pushing it to Oracle OM for sales orders and then to Oracle Service Contracts (OKS) and then to AR for billing.

oInvolved in creating a custom process of contract integration from Gold Digger CRM Application to Oracle ERP via GMBI process.

oInvolved in designing the cross reference WEB APIS for Customers, Catalogs and Sales Reps for ELEAD Team to read the CDK data.

oResponsible for custom solution on handling Catalog Limitation (SW MLTQTY=’1’) for creating contract lines via contracting process.

oInvolved in implementing the Bill to Override function to the OTL process, which pushes the lines directly to A/R for billing as Right to Bill (RTB0.

oInvolved in testing the OEM stuff for GM IMR, Ford Direct customers.

oResponsible for custom modifications in the invoice process to display the comments on the invoice PDF for customers.

oInvolved in catalog setup for New Sales (Post Conversion) like the PRH, PPV, Bill via Oracle and other Item Categories.

Involved in active discussions with cross-functional teams, team members and project stake holders during the design phase for all quote, contract and order release process.

Involved in oracle implementation which includes participating in RICE component activities, requirement gathering, creating MD50 documents, CV40 documents functional testing (FT), system integration testing (SIT), user acceptance testing (UAT), Go-live and production support activities.

Responsible for monitoring the assignments and project tasks of each project resource and follow up for assignment completion.

Involved in rebuilding the quote to contract processes and extended Oracle ERP functionality to include OKS and IB.

Involved in customizing the current process to fit the client new projects.

Involved in tracking/fixing the issues via JIRA tool.

Involved in creating end to end test scenarios and end user manuals for Business and IT system integration testing.

Responsible for end to end testing the test cases and getting them reviewed and sign off from Business users.

Responsible for preparing Cut-Over weekend activities with Project Manager for conversion and integration activities.

Writing SQL Queries and working with development team to ensure code correctness.

C&S Wholesale Grocers, Keene, NH October 14 to March16

Environment: Oracle Applications Release 12.2.4

Role: Oracle EBS Functional Analyst

Modules Worked: OM, PO, AP, AR, INV, and Advance Pricing.

Description: CSWG (C&S Wholesale Grocers) migrating the present retail system to Oracle ERP (Release 12.2.4) in a detailed phased approach. The retail system has most of the Oracle modules procure to pay, Order to Cash, Supply chain, Oracle Financials, Demantra and reporting systems like OBIEE, Teradata. SOA is used as middleware in integrating the modules and thirty party systems.

Other Systems: RDS, WWCS, EXE

Middleware: Oracle SOA.

Reporting: OBIEE, Teradata

Tools: Mainframes, SQL Developer, Excel, XML, BI Publisher, Reports, Microsoft Word, Microsoft Visio, Jira.

Key Responsibilities:

Involved in active discussions with cross-functional teams, team members and project stake holders during the design phase for all OTC and PTP processes.

Involved in oracle R12 implementation which includes participating in RICE component activities, requirement gathering, creating MD50 documents, functional testing (FT), system integration testing (SIT), user acceptance testing (UAT), Go-live and production support activities.

Responsible for monitoring the assignments and project tasks of each project resource and follow up for assignment completion.

Involved in scheduling the regular meeting with project team to capture open issues.

Involved in blue print/requirement gathering sessions with business to collect requirements around many P2P/OTC processes like pricelist upload, bracket pricing, qualifier setups, item interface, receipts interface, inventory adjustments, shipping and sales order interface, PO import interface.

Involved in ground work preparation of MD50’sBRD’s, BR100’s for P2P/OTC processes.

Involved in multiple discussions with DEV and SOA team on design work through sessions, POC sessions.

Involved in creating customized reports using BI publisher.

Involved in writing several Queries for customization OTC cycle for test purpose.

Involved in all pricing setups and worked on pricing interface.

Involved in all setups in PROD for the OM, AR, PO, and AP.

Responsible for Coordinating with Oracle DEV, SOA, EDI & legacy applications team during the design, development, testing & migration phases of the project.

Involved in preparation of Cutover list, Migration list, Patch List and seamless migration of all those to Production.

Worked with OBIEE and Teradata team in getting the order management and some purchasing reports from Oracle EBS to OBIEE and Teradata.

Explained the process of EBS transformation to OBIEE team which helped them in consolidated reporting.

Involved in creating test scenarios and end user manuals for Business and IT system integration testing.

Involved in creating MD50 and test scripts for PO import interface, receipt interface, inventory adjustments, shipment interface, item interface, vendor interface.

Involved in working with third party systems like RDS, WWCS, EXE and external system Main Frame.

Involved in developing the appointment interface from third party system (RDS) to oracle and from oracle to other party systems (EXE).

Technical experience with Design, Development, Implementation, Customization and Production Support of Oracle Applications.

EDUCATION:

Jawaharlal Nehru Technology University, India. (2009-2013)

B.tech Electronic Communication Engineering

Wright State University, OH (2013-2014)

Masters Electrical Engineering

Contact this candidate