Data Warehouse Oracle Ebs
Resume:
Michael T. Washington, Sr.
Upper Marlboro MD 20772
**************@*****.***
Relevant Experience
CBS Experience
NOAA Experience
Functional Experience
Commerce Business System (CBS) Web Portal and Functional Modules
•Oracle EBS Finance Tool (All Modules)
•Oracle Fusion Cloud
•Core Financial System (All Modules)
•Web Portal
•Department of Commerce and NOAA Data Warehouse
•Discoverer
•Commerce Purchase Card System (CPCS)
•NOAA Data Warehouse
•CBS E-Mailing System
•CBS Job Scheduling System
•User Account Certification Notification and Management
•Government-wide Treasury Account Symbol Adjusted Trial Balance (GTAS)
•Central Accounting Reporting System (CARS)
Interfaces:
•mLINQS Permanent Change of Station
•SmartPay3 (SP3)
•ORSI Interface
•CBA Interface
•Travel Interface (ETS2)
•Express Small Purchases System Interface (ESPS)
•Telecommunications Interface (TEL)
•Motorpool Interface
•ASAP Interface
•Labor Interface (NFC)
•Account Receivables Interface (ARSI) and Account Payables Standard Interface (APSI)
•Department Seafood Acceptance Interface (DSFA)
•C.Award/C.Suite
•Grants Online / TIBCO
Technical Experience
•CBS Tech Refresh
•Software Development Life Cycle (SDLC)
•Oracle 12c RDBMS, Forms, and Reports
•Oracle Web Portal
•Operating System: UNIX/Solaris, MS-Windows (all versions
•Oracle Hyperion Planning,
•MS Office Suite (Excel, Word, PowerPoint, Outlook and Access),
•PeopleSoft FMS, 9.2
•MS SharePoint
•PL/SQL, SQL*Plus
•Core Skills & Tools
•• Agile/Scrum & Waterfall Methodologies
•• Oracle EBS, PeopleSoft (GL, AP, AR, BI, CM)
•• Hyperion, Smart View, Essbase
•• SDLC, UAT, Regression Testing
•• Business Process Analysis
•• Jira, Service Now, SharePoint
•• SQL, PL/SQL, Java, Oracle 12c
SUMMARY
Solutions-oriented Business Analyst / Oracle PeopleSoft Tester with 15 years of experience in the Mortgage - Financial industry which includes financial modeling & analysis, systems analysis, data analysis, end-user training, reviewing software defects, UAT testing, deal costing and securitizations.
●Understand Permanent Change of Station (PCS) travel regulations, policies, procedures, and guidelines issued by National Oceanic and Atmospheric Administration (NOAA).
●Well versed with SDLC, Waterfall and Agile methodologies.
●Provided decision-making data analysis and financial modeling to leadership
●Designed and developed a fully integrated and repeatable regression test, ensuring that all code promoted to production meets NOAA’s business requirements and will support NOAA’s mission.
●Provides strong customer service support and problem-solving skills and has built a strong reputation as a team player with excellent analytical, oral, written, and interpersonal communication skills.
●Possesses an in-depth knowledge of NOAA’s business practices and requirements, as well expertise with the CBS application that are in demand when critical production issues arise.
●Key functional resource for requirements gathering, design and development efforts supporting NOAA’s Financial Systems Division (FSD).
●Serves as a subject matter expert, supporting each of the NOAA FSD teams and provides analysis and ‘troubleshooting’ support for issues identified.
●Team player with a keen awareness of project deadlines and quality.
EXPERIENCE
July 2019 – Feb 2025 National Oceanic Atmospheric Administration (NOAA) Silver spring, MD
Management Analyst Supervisor – Sr QA Manual Tester
●Assist with effective delivery to help desk support and training staff members; provide guidance in formulating appropriate responses to inquiries relating to financial management and administrative issues; and serve as lead analyst.
●Provide E2 traveler and Oracle EBS BAS customer service for customers across NOAA and its cross-serviced bureaus. Researching and troubleshooting outstanding issues.
●Provide support for organization operations; apply analytical skills to resolve problems/issues; respond to request information.
Testing and Application Support
●Provided the coordination and management of all Quality Assurance and Software Configuration Management for CBS/CBSDW production and non-production activities.
●As the Quality Assurance Team Lead is instrumental for the continued operations of the NOAA CBS/CBSDW environment as well as for the development of the NOAA Tableau FMRCCB Reports.
●Coordinated the prioritization, scheduling, monitoring, and documenting of the Request for Development ISM tickets for internal software changes, CSC approvals for NOAA SQLs, DOC CSC ARs, spot tests, promotion of code to test, and the promotion of code to production.
●Coordinated the readiness of all QA test environments to accommodate target test and production dates, and coordinated all the software installs and catchup code. On a quarterly basis, Robyn coordinated the installation and testing of the JRE, JDK, Oracle Web Tier, Oracle SC patches, Critical Oracle Security Patches, CIS Baseline Fixit scripts, JAR files, Code Sign Certificates, as well as updates on items identified in the vulnerability scans across the QA production/non-production environments.
●Collaboration with other departments and team members significantly contributes to NOAA’s overall success, as evident from her efforts and colleagues' comments.
Oracle Business Application Solution (BAS) User Acceptance Testing
●Designs and implements application configurations to meet business process and application requirements. Writes scripts and sets up test data for unit, performance (load, stress) and system integration testing particularly packaged application configurations
●Supports UAT and long-flow testing provides technical (L2/L3) support for applications. Act as Subject Matter Expert on Oracle EBS Financials, produce scalable, efficient, and supportable solutions with appropriate technical solutions utilizing Oracle and related technologies
●Support global Oracle EBS Financial system interfacing with multiple regional systems and 3rd party applications. Work with global team members of finance clients, IT Developers, other support teams, and third party vendors. Collaborate with business leaders and other IT leaders in developing an architecture and application roadmap that cost effectively meets or exceeds the business requirements
●Manage implementations of technical and functional Oracle EBS solutions. Responsible for project financials including development of financial plans.
Production Support
●Provides support to the Client Services Team, utilizing his broad depth of knowledge of the CBS system in researching and analyzing issues encountered in production by NOAA end users.
●Provided CBS systems training to the Client Services team and to the Finance Office end user community.
●Developed a detailed data recovery checklist in support of the NOAA Disaster Recovery/COOP team that is followed in the event of a disaster that negatively impacts the NOAA production environment and results in the restoration of some or all of the NOAA CBS production environment at an alternate site.
●Provides analysis and ‘troubleshooting’ support for issues that arise in the CBS production environment.
●Provide ongoing production support to the Grants Online and C.Suite user communities.
●Researches and provides solutions for production issues that are unable to be resolved by the NOAA Help Desk for both NOAA-developed as well as CSC-delivered code.
●Serves as a liaison with the CSC technical staff in reviewing major new software releases to ensure they meet NOAA business and mission objectives and provides early beta testing to ensure a successful implementation of code by the target dates.
●Served as a liaison to the Systems Support branch, representing the QA team during the implementation of Mercurial/TortoiseHg for software configuration management (SCM), ensuring that QA’s functional requirements and that NOAA Finances SCM needs were met.
System Interfaces
●Led the Quality Assurance test team in successfully testing initial deliveries of the software, providing the CSC or NOAA developer with proper feedback on AR’s identified and ensuring that the final code delivered met NOAA’s business requirements and provided the level of functionality needed for NOAA to meet its mission objectives. The interfaces listed below are now part of the CBS system and are tested as part of the Standard Regression Test Model.
oAccounts Payable Standard Interface (APSI)
oAutomated Standard Application for Payment (ASAP)
oExpress Small Package System (ESPS)
oFTE Enhancement (Surcharge and Over/under Processes)
oGSA Motor Pool
oGovernment Travel Account (GTA)
oMass Reclassification Enhancement
oNFC Interface
oORSI/CSTARS Implementation
oCAWARD
oSmartpay3
oSummary Level Transfer (SLT)
oTelecommunications Interface (TEL)
oTravel Interface (ETS2)
oMLINQS
May 2017 – May 2019 Freddie Mac McLean, VA
Business Analyst/PeopleSoft Tester
●Requirements Gathering & Analysis: Gathered non-technical functional requirements from stakeholders and translated them into actionable technical deliverables, ensuring alignment with business needs.
System-Level Requirements Documentation: Wrote system-level requirements (functional process models, user stories, software requirement specifications) and worked closely with IT and business leads to validate that solution outcomes met business objectives.
Reporting & Data Issue Troubleshooting: Worked on reporting, troubleshooting data issues, and recommending/implementing resolutions. Managed ad-hoc reporting, dashboards, and tracked production-related issues via IT Service Now tickets.
Test Planning & Execution: Created and implemented detailed test plans and test cases to validate software applications against functional and non-functional requirements.
User Acceptance Testing (UAT): Executed UAT testing to ensure software functionality met business and user requirements before deployment.
Manual & Automated Testing: Conducted both manual and automated testing to identify, document, and track software defects, ensuring issues were resolved before release.
Test Automation: Developed and maintained automated test scripts, executed regression tests, and improved testing efficiency to ensure code changes did not negatively impact existing functionalities.
Defect Management & Collaboration: Worked closely with developers to communicate defects, provide detailed bug reports, and ensure timely resolution. Validated bug fixes and enhancements to ensure they met quality standards.
System Performance & Security Testing: Employed various testing tools and methodologies to assess system performance, functionality, and security, while participating in continuous improvement initiatives to optimize testing processes.
PeopleSoft Modules Expertise: Worked extensively on PeopleSoft modules, including General Ledger (GL), Accounts Payable (AP), Expenses (EX), Cash Management (CM), Accounts Receivable (AR), Business Intelligence (BI), and Project Costing (PC).
PeopleSoft Query Management: Updated and maintained PeopleSoft Query tables for accuracy and completeness across all modules.
User Training & Support: Trained end-users on PeopleSoft Query Manager and Hyperion Essbase, ensuring effective adoption and usage.
Financial & Reporting Systems Support: Supported systems like Forecasting, Credit Loss Accounting System, and Accounts Reconciliation Management Reporting (SPRO). Delivered end-user support for Hyperion reporting applications and Smart View.
Security Access Reconciliation: Executed Java Scripts to reconcile security access between PeopleSoft and Hyperion, ensuring data integrity across platforms.
PLM & Team center Knowledge: Applied solid functional knowledge of Product Lifecycle Management (PLM) and a deep understanding of Team center to streamline product data management and lifecycle processes.
Sep 2004 – Sep 2010 Fannie Mae Washington, DC
System Analyst/PeopleSoft Tester
Contractor, Multifamily Division Full-Time, Single Family Division
Professional Experience
System Analyst / Financial Professional Contractor, Multifamily Division Full-Time, Single Family Division
Multifamily Division (Contractor)
Managed User Acceptance Testing (UAT) for systems, ensuring compliance with bond payment processes.
Authored and executed test scripts to validate payment systems, driving smooth implementation.
Collaborated with cross-functional teams to identify and resolve system-related issues.
Single Family Division (Full-Time)
Oversaw the processing and weekly reconciliation of mortgage insurance payments to Fannie Mae.
Ensured accurate payment processing and maintained financial integrity through routine audits.
Coordinated with internal teams to resolve discrepancies and align processes with company policies.
Financial Analyst Role
Prepared and reviewed 10-K and 10-Q reports for regulatory compliance and accurate financial reporting.
Conducted monthly reconciliations to identify and resolve discrepancies in financial statements.
Delivered detailed analyses to senior management, enhancing decision-making and reporting processes.
Key Skills
Expertise in LOB/Intercompany Allocations and internal billing for subsidiaries.
Proficient in Oracle SmartView, multidimensional reporting cubes, and Oracle EPBCS.
Advanced skills in Excel, including macros, data visualization, and pivot tables.
Experience in Month-End Financial Reporting and Executive Documentation.
Skilled in developing Training Materials and procedural guides, including white papers.
Strong background in Forecasting at the product level for strategic planning.
Agile requirements gathering and documentation using JIRA.
Jun 03 – Sep 04 E*Trade Arlington, VA
Financial Analyst
Oct 98 – Mar 03 Freddie Mac McLean, VA
Portfolio Analyst
HIGHER EDUCATION
●College Courses (Accounting I & II)
●Oracle Hyperion Financial Reporting
●Essbase & Planning, SmartView
●Oracle Fusion Cloud
Contact this candidate