Oracle Functional Analyst Resume
Boston, MA
SUMMARY
- Oracle e - Business Suite Functional expert with 7 years of IT Experience including in-depth experience in design, support, and implementation of software applications including experience as a Functional Consultant
- Expertise in Accounts Payables, I-Expense, Fixed Assets, Order Management, Accounts Receivables, Cash Management, General Ledger, Shipping, Inventory, Purchasing modules.
- Extensive experience in the Functional aspects of Oracle Applications 11i and Release 12. Worked across different modules of the Supply Chain Management suite including Oracle Purchasing, Oracle Inventory, Oracle Receivables, WMS, Oracle Order Management, and Oracle Shipping.
- Strong understanding of different methodologies (Agile, Waterfall and Iterative), finance and risk models, operation (six sigma, supply chain services), marketing and engineering.
- Excellent communication skills, managed projects with C Level executives and open source engineers.
- Experience in high volume, high risk, high visibility and low downtime production systems.
- Successfully designed and implemented projects in custom-built products, COTS, version upgrades and services.
- Ensured escalations are met, issues resolved, risk mitigated and task prioritized
- Tools used on projects: MS Office, MS Project, Visio, MySQL and PHP, statistics and risk management modeling.
- Extensive experience with Managing Off Shore and On Site teams.
- Experienced in desktop applications, hosted solutions on server farms and disaster recovery centers.
- Developed several Business Requirement Documents (BRD), Functional Specification Documents (FSD)
- Experience includes execution of 4 full lifecycle Oracle Applications implementations including the exposure to e-Business suite Release 11i and 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction.
- Over 6 years of extensive experience on Oracle Supply Chain Manufacturing Applications consulting including Quote to Cash and Procure to Pay Executed critical projects as Business Analyst, Functional Consultant, Onsite Coordinator, Designer on Functional & Techno-Functional roles.
- Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction skills.
- Adept in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
- Demonstrated abilities in mapping business requirements and translating these requirements into Oracle applications functional specifications and detailed test plans and custom designing solutions.
- Strong communication & leadership skills with an ability to interact with business users and lead business projects.
TECHNICAL SKILLS
Oracle E-Business Suite: Financials and Supply Chain Management (SCM) Applications - 11i, Release 12.0 and Release 12.1
Database: Oracle 8i/9i/10g
Operating Systems: Windows (95, 98, NT, 2000, ME, XP), UNIX
Tools: SQL Plus, TOADProgramming Languages C, VHDL, My SQL, and Matlab.
Scripting Languages: Perl, Unix Shell script.
Tools: QXDM, RSDLite, Xilinx, Model SIM, Source Insight, Clear case, Cadence, AutoCAD, MS VisioDefect Tracking Bugzilla.
Web Technology: HTML, XML.
Network simulators: NS2, Opnet, Wireshark.
Platform: Windows XP, NT, 2000,Vista, Unix, Red Hat, Fedora Core, Ubuntu, MAC, Cygwin.
PROFESSIONAL EXPERIENCE
Confidential, Boston, MA
Oracle Functional Analyst
Responsibilities:
- Prepared Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units
- Worked with the Business team to baseline the ‘As Is’ process and derived the ‘To Be’ flow
- Identified Gaps and collaborated with the Technical team to address the same through Technical Specification
- Performed all setups for AP, iExpense, FA, AR, GL, and CM modules
- Defined Approval Hierarchies and setup AME rules for invoice routing
- Priced business requirement study and documented functional specifications
- Prepared business test scripts with business rules associated with it to test the data integrity of archived data
- Performed flow testing for modules (AP, iExp, AR, GL, FA, CM) to make sure the flow is working without any issues
- Facilitated segregation of Duties in Oracle Applications
- Customized various roles and responsibilities as per SOX control
- Conducted CRP1, CRP2, CRP3, SIT, and UAT and helped users in going through the test cases
- Worked closely with the development team to resolve various issues
- Conducted Pre Project review and Post Project Review
- Jointly worked with the QA team in formulating Test Cases and Test Scenarios
- Involved in making the detailed Project Test Plan regarding the scope and focus of testing
- Worked on Quality Center, Load Runner, and WinRunner for automated tests scripts
- Documented and communicated test results to Test Management and Business Management team
- Converted Supplier and Bank details from legacy system to Oracle AP using a custom conversion program
- Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, iExpense, FA, and AR) and create new ones based on business requirements
- Documented new procedures and was involved in training the business users on the new processes
- Assisted users during their on-job training exercise
- Provided Implementation and Post-Implementation Support
Confidential, Houston, TX
Oracle Functional Analyst
Responsibilities:
- Worked with business users in gathering requirements
- Prepared Business Requirement Documents (BRD) and Functional Specification documents (MD50)
- Worked on setup configurations including Flex Field Values and Value Sets, OM Order Types and Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups and module specific shared entities and objects and their integration
- Worked on the setup of iExpense including setting of several expense reporting templates, setting up the Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, setting up iExpense to support Multi Currency
- Worked with end users to document the business processes
- Defined the Approval Hierarchies, Document Security, Streamlined the Receiving process, setup the Matching Process in Purchasing module
- Worked on Configuring the Sabrix Tax Engine
- Coordinated activities with implementation team on creating test plans, conducting unit testing, correcting bugs and re-testing while meeting project deadlines
- Implemented internal control features using form personalization for AP and iExpense
- Worked in parallel with the client to resolve CRP and post go-live issues with offshore support
- Created test scripts for UAT in TE40 documentation for AP, iExpense, FA, GL, and CM
- Wrote TE 020 Unit Test Scripts for Payment Methods in AP
- Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to R12
- Coordinated with the client through Concalls and WEBEX sessions to get the requirements
- Conducted user training for acquired company's employees
- Solved day-to-day production issues for new acquisitions
Confidential, Addison, TX
Business Analyst
Responsibilities:
- Prepared Business Requirement Documents (BRD) and functional specification documents
- Worked on setup configurations including Flex Field Values & Value Sets, OM Order Types & Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
- Reviewed and analyzed the 'as-is' business scenarios, processes and activities, evaluated end user requirements and custom design solutions and resolved any problems in the process.
- Defined the Approval Hierarchies, Document Security, Streamlined the Receiving process, Setup the Matching Process in Purchasing module
- Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
- Worked on supplier conversion and open invoice conversion during new company acquisition.
- Worked on configuring Install Base to capture Reseller, End User and Distributor information for each Instance item.
- Worked on the Setups of AR, AP, GL, FA, CM, i-Expense and worked on the integration of the modules with AR and AP.
- Worked with end users to document the business processes and functional requirements
- Worked very extensively on understanding the proposed 100% customized business logic of the Business in building the customized solutions for Shipping on OA framework Technology based on the legacy of Oracle application E-business suite 11.5.10. All the above bases business logic was captured in OA Framework code.
- Coordinated activities with Implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines. Facilitated discussions with end-users / managers to gather functional requirements.
- Worked in parallel with the client is resolving the CRP 2 and post go-live testing issues with offshore support.
- Provided KT sessions to the testing and the technical teams.
Confidential
Oracle Techno-Functional Analyst
Responsibilities:
- Prepared Business Requirement Documents (BRD) and functional specification documents
- Worked with business users in gathering requirements
- Participated in preparation of Requirement Traceability Matrix
- Used SQL for checking the output of various reports
- Participated in defect management and bug reporting.
- Wrote Functional Specifications and coordinated with the technical team to develop AP Check Printing, EFT, PO Form and AR Invoice
- Identified Gaps and collaborated with the technical team to address the same
- Performed all setups for AP, iExpense, and FA
- Performed all configurations of Kofax MarkView 5 imaging system
- Prepared business test scripts with business rules associated with it to test the data integrity
- Conducted CRP1, CRP2, CRP3, SIT, and UAT and helped users in going through the test cases.
- Provided Implementation and Post-Implementation Support.
- Facilitated discussions with end-users/managers to gather functional requirements
- Defined Approval Hierarchies and setup AME rules for invoice routing
- Prepared Business Requirement Documents (BRD) and functional specification documents (MD50)
- Facilitated segregation of Duties in Oracle Applications
- Worked closely with the development team to resolve various issues
- Conducted Pre Project review and Post Project Review
- Involved in making the detailed Project Test Plan
- Wrote TE 020 Unit Test Scripts for invoice approvals and routing in AP
- Coordinated CRP and UAT testing with business users.
- Documented new procedures
- Trained the business users on the new processes
- Provided Implementation and Post-Implementation Support