RUPAL COELHO, PMP
** ********* *****, ********, *** Jersey 08873
LinkedIn Profile - http://www.linkedin.com/pub/rupal-coelho/3b/a1b/953
Phone: 732-***-**** Email: jd20wg@r.postjobfree.com
OBJECTIVE-To seek a challenging position as an Oracle Functional Analyst and specialize in Oracle modules.
SUMMARY
Oracle EBS Analyst with accounting background. Demonstrated knowledge Business Analysis, Quality Assurance and Project Management functions. Proven analysis, system configuration, attention to detail, time management, multi tasking, partnering, and project management skills with track record of delivering projects on time. Experienced in Oracle 11.5.10 - GL, AP, FA modules and OBIEE.
Experience with Systems and Processes within the Financial Systems Architecture:
Experience with Systems and Processes within the Financial Systems Architecture:
Financial Systems:
Middleware - Enterprise Accounting Facility (EAF)
Oracle e-business suite (GL, AP, FA)
Query Tools-Oracle Business Intelligence (BI) and SQB
Reporting tools - Hyperion, PFAP, GAAP Package, PASS
Forecast P&A - Clarity, OFA
Financial Processes:
Data flow from initiation to data warehouse /reporting
Hierarchies/Chart of Accounts creation and maintenance
Inter-book processes in a global environment
Job streams and Batch processes
Sub-ledger to GL integration
SKILLS: Oracle, SQL, Sharepoint, MS Office, MS Project, Rational Robot
ORACLE ANALYST /QUALITY ASSURANCE EXPERIENCE (In a Cross Functional / Global Environment)
Performed Systems Analysis and detailed Testing for following Initiatives:
o Oracle AP Implementation for Prudential Real Estate and Relocation Services.
o Oracle GL, AP and FA Implementation for India Insurance and International Retirement groups.
o Oracle GL - Customization of Journal Approval process.
o MS Office 2007 roll-out to Financial Management group.
o Oracle Financial Analyzer Implementation for Statutory Reporting group.
PROFESSIONAL EXPERIENCE
ZENOSYS CONSULTING, Princeton, NJ 2011 - Present
Consultant at ETS–Managing schedules, resources, budget, project plan, processes for multiple projects.
PRUDENTIAL FINANCIAL, Financial Information Services, Newark, NJ 1994 – 2011
Manager (2008 – 2011)
Specialized in Oracle Accounts Payable and Fixed Asset modules. Managed SDLC and test phases – Unit, Integration and UAT for Financial System Implementations/ Releases.
As Oracle Analyst for Oracle EBS ( e-Business suite)-
• Implemented solutions in conjunction with Oracle Support for customized user requests.
• Provided production support, performed analysis, trouble shooting and resolution of BAU issues.
• Configured Oracle AP module for Pru India Investments Trustee Co and FA module for Pru of Taiwan.
• Implemented TDS certificate generation process for Prudential India Investments and Trustee companies.
• Standardized responsibility matrix across all operating units.
As Manager -
• Partnered with End Users to Collect and document Business Requirements during design phase of SDLC.
• Communicated business process and functional requirements to development team while serving as a liaison between developers and end users.
• Prepared Decision documents for consideration by Senior Management and communicated status updates.
• Managed project scope, change controls and documented items for future releases.
• Collaborated with Development, Quality Assurance and Infrastructure support teams to setup test environments for testing.
• Created Project Plan in conjunction with SMEs and team leads. Managed Project Plan and Batch processes.
• Coordinated creation of Test Cases and Expected Results.
• Chaired Daily status meetings, maintained Issues log and tracked resolution of issues.
• Documented User procedures, Training documents and Lessons learned. Facilitated process improvement.
• Provided System demo (using Power Point), Training and Post-Implementation Support to end users.
RUPAL COELHO, PMP
http://www.linkedin.com/pub/rupal-coelho/3b/a1b/953
Page 2
Phone: 732-***-**** Email: jd20wg@r.postjobfree.com
PRUDENTIAL FINANCIAL, Financial Information Services, continued
Quality Assurance Specialist (2001 – 2008)
• Oracle conversion – as a member of the Oracle conversion team, worked on various fronts of the project.
• Supported project management and served as subject matter expert / analyst / lead tester for conversion of the following applications from Sybase to Oracle: Prudential Financial Analysis Package (PFAP), GAAP Package and OFA Corporate and Other. Created and executed detailed test scripts. Also supported integration and user acceptance testing.
• Assisted with creation of Oracle Chart of Accounts To-Be segment values, mappings (Smartstream to Oracle) and hierarchy development.
• Served as Lead Tester / Analyst for major financial system implementations and releases. For each implementation, partnered with Corporate Comptrollers, Regulatory Reporting and Development Team to understand the process and data flow. Built test scenarios that simulated the internal customer’s system usage and verified system calculations by creating test data and simulating all possible combinations of application algorithms within spreadsheet models. Prudential Financials systems tested included:
o GAAP Package application: implementation of Financial, Supplemental and Consolidation modules through automation of Financial and Supplemental reporting from excel based spreadsheets.
o Guaranteed Funds Assessment (GFA) implementation: this involved automation of assessment calculations, and all necessary regulatory and tax reporting relating to guaranty fund assessments.
o Prudential Financial Analysis Package (PFAP) implementation of Income Statement, Balance Sheet and Management Discussion Analysis modules: this involved automation of Variance analysis for Income Statement, Balance Sheet and MD&A (Management Discussion and Analysis) modules.
o Financial Data Collection System (FDCS) releases 1.7, 1.6 and 1.5: system upgrades to enhance performance.
o Smartstream releases: system upgrades to incorporate additional functionality.
• Managed testing of following processes:
o Rollover of financials from EOY to BOY 2003.
o INTRADAY process: this initiative was designed to provide the business users with ‘real-time” processing by incorporating a mid-day batch. Coordinated testing effort across all applications.
Business Analyst - Corporate Center Ops and Systems (1999 – 2001)
• Performed analysis and testing for BAU system enhancements.
• Tested Y2K for Smartstream Fixed Asset module.
Portfolio Accountant - Global Ops, PRU Investments (1996 – 1998)
• Reported derivative activity on Prudential’s Schedule DB and Potential exposure on all open futures and forward contracts to Risk Management.
• Performed accounting functions for Futures, Forwards, Options and Currency Swaps.
• Proved schedules (STAT) to General ledger (GAAP) and documented differences.
• Processed Corporate Actions (distributions, mergers, stock splits, purchase orders and rights).
Staff Accountant - Equity Products, PRU Investments (1994 – 1996)
• Performed accounting functions for investments in Stock – recorded transactions in PRISM (Investment software) and proved to ledger. Served as lead cash reconciliation coordinator.
EDUCATION / CERTIFICATIONS
Bachelor of Commerce (major in Accounting) MMPS College, Bombay, India
Chartered Institute of Bankers (Credits in Investment, Management & Finance), U.K
Masters Certificate in IT Project Management: George Washington University, U.S.A
Project Management Professional (PMP) Project Management Institute, U.S.A