Senior Business System Analyst Resume
Santa Clara, CaliforniA
SUMMARY
- Having 9 years of IT & Functional Experience as an Oracle Applications Financial Consultant including Implementation & Production Support of Oracle Financials & SCM with Versions R12 & 11i Applications.
- Functional Experience in Configuration and regulatory testing with products like Accounts Payables, Payments, Accounts Receivables, Fixed Assets, General Ledger, Cash Management, SLAM, Purchasing, E - BusinessTax, Inventory, Workflow, General Ledger, iExpenses, Web ADI, iReceivables, iPayments, Order Management & System Administrator.
- Experienced on Implementations, Supporting & Maintaince Projects.
- Worked on Documentation, As-is BP-040, To-Be BP080, Setups BR-100, Gap Analysis MD050.
- Experienced on Preparing User documentation For Financials modules.
- Defined MIS and Ad-hoc reports using the FSG Functionality in General Ledger.
- Excellent knowledge on configuring applications by gathering business requirements from client and providing solutions at runtime thereby enhancing my Client facing skills.
- Process full range of accounting and administration skills including AP, AR, GL Analysis and Fixed assets accounting and Reconciliation, Book close Reconciliation.
- Experience on Procure to Pay, Order to Cash, and Assets to GL Cycle’s Using Multi-Org Business model.
- Experienced on SQL PLUS, Toad, Conversions, interfaces, Data migration, customization.
- Experienced on preparing test cases TE020, 030, 040.
- Knowledge on Accounting Concepts GAAP, IRFS,SOX well versed with Sections 302,404 Etc.
- Mentored Accounting professionals by providing End User Trainings, and motivation.
- In addition to Functional experience, expertise spans functional analysis and support for operations executives.
- Experienced on Localizations for Spain, Europe Countries.
- Knowledge on SYSADMIN in Oracle applications with mapping application user setup’s,defining responsibilitities,valuesets,Flexfeilds,Registeringmenus,forms,concurrent programs, Request Groups, Providing support to end-users for any functional issues.
- Created and maintained documentation as part of production handbook using AIM.
- Conducted in CRP & UAT testing.
- Worked extensively with development team members in resolving issues by Creating TAR(s) and obtaining one-off solutions using METALINK.
TECHNICAL SKILLS
Oracle Apps: GL,AP,AR,FA,CM,PO,PA,INV, Hyperion, OM,SLAM,EBusinessTax,OBIEE,DBI
ERP: Oracle Apps, JD Edwards & PeopleSoft.
Self-Service: iExpenses, iAssets, iReceivables, Oracle reports & Forms (D2k), Workflow, ADI
Tools: Toad, SQLdeveloper, Discoverer, XML,SQL*Loader, EDI
Languages: Oracle 8i/9i/10g, SQL, PLSQL, Interfaces, OAF, XML, Java, UNIX shell scripting.
PROFESSIONAL EXPERIENCE
Confidential
Senior Business System Analyst
Responsibilities:
- Currently working on FA Period Close Automation for all regions.
- Worked on Customizing Global Web ADI and Global Post Mass Additions for fixed Assets module.
- Worked on Global Post Mass Additions customization for Fixed Assets.
- Customized MAC Auto Journal creation process for incorrectly categorized Assets in Fixed Assets.
- Designed Solution for Confidential CIP Assets Capitalization using OA Framework.
- Working on FA Reconciliation Process with General Ledger with respective of Asset and General Ledger Reconciliation Reports.
- Working as a liaison between developers and clients to enable product development with a close fit to client’s requirements.
- Working on Mass additions, Mass transactions, depreciation methods and Mass copy and Periodic Mass copy functionalities.
- Map Client business requirements to oracle functionality and identify gaps and setup application in the Test, Development and Production environment.
- Conducting in orientation training, CRP, UAT and Rollouts strategies for implementations
Environment: (Oracle Apps 11.5.10.2): AP, AR, GL, CE, PO, INV, OM, FA, Alerts, HFM and Markview170
Confidential, Santa Clara California
Oracle Business system Analyst
Responsibilities:
- Full cycle implementation involving meet with senior management to develop and agree project methodology and plan for project implementation approach.
- Evaluation of organization structure, reporting needs, business need to plan the chart of accounts as well as defining them.
- Analyzed and mapped the business requirements analysis into Oracle FA module.
- Mapped the future process requirements into Oracle fixed assets module and identified the Gaps and analyzed the gaps and offered solutions.
- Define the COA, Ledgers (Sob’s) and Journal Types like Mass allocation & Recurring Journals.
- Grouped assets associated with specific project, department, and location to track the CIP assets in the Organization.
- Defined Oracle assets for Mass additions.
- Experienced on ADI, Report Manager, Web ADI, Hyperion,Markview-170, SQL PLUS, Work Flow, OAF & Toad.
- Experienced on Functional setups, Support Trouble shootings & configured the Workflow.
- Involved in knowledge transition from the project to the production support team.
- Involved in pointing out the probable issues coming out of the proposed solutions in the project.
- Interacting with the users in training the new solutions & applications some new functions.
- Maintained Issue Log and tracked all the issues to resolutions.
- Handled Period Close, Accounting Issues arising in the Support.
- Responsible for Smooth Reconciliation between AP, AR, & CM
- Prepared test scripts and carried out system and integration testing including conversion of legacy data.
- Carried out the end user training and provided the post production support.
Environment: (Oracle Apps 11.5.10): INV, OM, PO, AP, AR, FA, GL, Lease Management, iExpenses,iReceivables & Mark view-170,Web ADI.
Confidential
Oracle Applications Solutions Specialist
Responsibilities:
- Studied the Existing business process of client.
- Performed on-site requirement analysis and developed functional specifications for the modules.
- Prepared the various documents required under the AIM methodology.
- Done documentation RD-050, BR-100 & MD-050 Using Spain localization.
- Conducted business process review and gap analysis to determine business requirements.
- Configured the AR System Options, Profile classes, Dunning and Statement letters, Remit to address and Defining the Customer Bill and ship sites.
- Defined the Transactions & Receivables types, Source for Imported and Manual Transactions types.
- Worked on the Transactions Imported Process from Other Sources Of Applications.
- Defined the Invoicing & Accounting rules for revenue recognition.
- Scheduled the Revenue Recognition & Document sequencing.
- Transferred transactions from sub ledgers to General Ledger.
- Tested Customized programs under simulated environment.
- Worked on the API’s and Stored procedures & Test cases TE020, 030, 040.
- Tested the functionality of financial flows.
- Worked on the Customer Profile classes, Customers & Journal Import Process for Sub ledger Transactions.
- Experienced on Web ADI, Hyperion, SQL PLUS, Work Flow & Toad.
- Experienced on Functional setups, Support Trouble shootings & configured the Workflow.
- Participated in user acceptance testing.
- Created user-manuals for programs and user procedures Using UPK.
- Customized the XML templates according to the report requirements.
- Data migrations from legacy to Applications (Interfacing) like Suppliers, Items & Customers data Using Data Loaders & Sql* Loaders.
Environment: (R12.0.5):GL,PO,AP,CE,AR,INV,OM,HRMS,E-BusinessTax,SLAM,Hyperion,Costing,iExpenses,BOM, WIP, iReceivables,Work flow, Web ADI.
Confidential
Oracle Financial Consultant
Responsibilities:
- Full cycle implementation involving meet with senior management to develop and agree project methodology and plan for project implementation approach.
- Evaluation of organization structure, reporting needs, business need to plan the chart of accounts as well as defining them.
- Analyzed and mapped the business requirements analysis into Oracle FA module.
- Mapped the future process requirements into Oracle fixed assets module and identified the Gaps and analyzed the gaps and offered solutions.
- Define the COA, Ledgers (Sob’s) and Journal Types like Mass allocation & Recurring Journals.
- Grouped assets associated with specific project, department, and location to track the CIP assets in the Organization.
- Defined Oracle assets for Mass additions.
- Experienced on ADI, Hyperion, SQL PLUS, Work Flow, OAF & Toad.
- Experienced on Functional setups, Support Trouble shootings & configured the Workflow.
- Involved in knowledge transition from the project to the production support team.
- Involved in pointing out the probable issues coming out of the proposed solutions in the project.
- Interacting with the users in training the new solutions & applications some new functions.
- Maintained Issue Log and tracked all the issues to resolutions.
- Handled Period Close, Accounting Issues arising in the Support.
- Responsible for Smooth Reconciliation between AP, AR, & CM
- Prepared test scripts and carried out system and integration testing including conversion of legacy data.
- Carried out the end user training and provided the post production support.
Environment: (Oracle Apps R12.0.l): INV, OM, PO, AP, AR, FA, GL, Lease Management, iExpenses,iReceivables & Web ADI.
Confidential
Accounts Analyst
Responsibilities:
- Preparing the Business Documents.
- Issuing the Credit notes to the Customers.
- Preparing the Daily outstanding Reports for Increasing the Collections Effectiveness.
- Sending the Dunning Letters, Statements to customers
- Responsible for Banking activities.
- Preparation of Monthly Commission statement.
- Sending the Daily Business Reports to Head-Office.
- Worked on the financial statements.
- Reconciliation of System Stock with Physical Stock.
Environment: BSAP Birla Sales Accounting Package .