Provided analyst support to the TSA Financial System Modernization project to replace customized financial system with Oracle R12 fully integrated standardized solution. Activities involved include analyzing and validating configurations, data analysis, mapping crosswalks, and validating data to be migrated. Review business processes, training materials, and creating UPK scripts for UAT scenarios.• Assisted with reviewing and updating configuration templates for implementation of Oracle 12.2.7.• Reviewed configurations in Oracle 12.2.4 to validate configuration templates.• Cross walked current of Line of Accounting data to future configuration.• Reviewed business process mapping and training procedures.• Created Oracle User Productivity Kit (UPK) scripts for User Acceptance Testing (UAT) scenarios.• Analyzed extracted datasets for accuracy, completeness, and integrity in preparation for data migration.

Provide analyst support to the USCG Financial Management System Improvement Initiative (FMSII) project to replace customized financial system with a fully integrated standardized solution. Activities involved include data analysis, cleansing recommendations, mapping crosswalks, and documenting methodology to ensure processes are repeatable and auditable in preparation for data migration to Oracle Federal Financials (OFF) R12.• Analyze large datasets for trends, anomalies, duplicative and erroneous data to prepare for migration.• Develop SQL & PL/SQL queries using TOAD for analyzing Oracle 11.5.10 data for cleansing recommendations, data conversion, and data migration to Oracle R12.• Provide feedback on data cleansing and data crosswalk mapping requirements.• Provide support with project planning, management, and strategy to ensure project is on target.• Document methodology used for data analysis, SQL formulation for analyzing data, data cleansing recommendation, data conversion, and data migration to ensure changes are tracked and processes are repeatable.• Ensure methodology of data conversion is repeatable for MOCK conversions and data migration.• Analyze post load of data to conversion templates for anomalies and errors in preparation for MOCK conversions.• Assist with update / refresh of database used for data analysis.• Analyze objects and relationships within ORACLE database to ensure the data conforms to future system configuration.• Create schema crosswalk of USCG ORACLE 11.5.10 data to Oracle R12 templates to prepare for data conversion load to templates, MOCK conversions, and migration to new system.

Provided support to the USCG Financial System Modernization (FSM). Supported the Financial Management Services Improvement Initiative (FMSII) to improve financial, procurement, and asset management systems by upgrading to ORACLE R12. Supported activities involved in Organizational Planning, Improvement, Support, Change Management Planning (CMP), and Requirement Traceability Matrix (RTM).• Supported the RTM review requirements related to configuration design, functional design, specifications, test plans, and user acceptance testing (UAT).• Reviewed the RTM for inconsistencies related to the supporting documentation.• Supported reviews and updates to project deliverables and design documents.• Supported Testing & Evaluation (T&E) initiatives including script reviews, collection of internal test data, test report generation, user acceptance testing (UAT) and reviews.• Facilitated planning meetings including recording meeting minutes.• Tracked and analyzed program reviews in support of FMSII.• Supported activities related to CMP including research, gathering, identifying, analyzing, and compiling data regarding program initiative.• Participated in the Business Processes Re-engineering (BPR) review and design meetings.

Provided support on FEMA’s Financial System Modernization (FSM) effort for Data Migration and Data Cleansing. Analyzed current core financial systems and other feeder systems that are being utilized to process day to day business. Supported the determination regarding data elements to be cleansed and data to be migrated. Reviewed and assessed the overall data strategy for migration to SSP. Provided FEMA with assistance on data strategy including data profiling, cleansing, and migration effort that will be part of the completed overall system replacement. • Analyzed the data using SQL statements to determine cleansing recommendations and prepare for data crosswalks. • Provided data assessment and recommendations for conducting data cleansing.Developed and ran Oracle/ SQL scripts to assess data errors requiring cleansing.• Gathered schema for the current FEMA system and mapped for assessing data requiring cleansing.• Conducted Data verification, reconciliation, validation, and testing to prepare for the migration to new solution.• Developed /Maintained technical and functional design documents.• Collected and analyzed data and developed decision support materials.• Worked on the development of the Data Management Plan, Data Strategy Plan, Data Cleansing Plan, Data assessment Report and Data Flow Diagrams.• Communicated with FEMA up and down the chains of command.

Provided functional / technical support, de-bugging & problem-solving on software for 5K nationwide users, managers & consultants; minimized down time & unscheduled outages. Served on implementation team for deploying company-wide Oracle R12.1.3 & upgrade team for Oracle EBS 11.0.3 to R12. Provided System Integration Testing (SIT), User Acceptance Testing (UAT), post-implementation functional and technical support. • Experienced in Oracle system administration meeting business requirements: created / updated custom responsibilities; menus & form personalization; registered concurrent programs & reports; enabled / disabled profile options; set up printers using pasta utility.• Created users; assigned direct & indirect responsibilities & roles, Workflow Administration, & Role-Based Access Control (RBAC). Created & managed request sets, notifications, maintained jobs & worked with functional analysts & DBAs, troubleshooting jobs & interface failures. • Utilized SQL to create ad-hoc queries & LANDESK to investigate user software issues• Governance, Risk Management & Compliance met by implementing system changes in accordance with current change control process & documented via LANDesk & Subversion. • Interfaced with management & users, investigating requests, gathering requirements, & analyzing needs focusing on business-process improvement.• Wrote functional, technical documentation, User Manuals & conducted training for application users & application analyst team. • Provided day-to-day functional & technical support for Oracle modules: Accounts Payable, Purchasing, Projects, Inventory, Bills of Material, training, documenting processes & resolving issues. • Provided support for legacy PeopleSoft Financials using SQL ad-hoc queries to retrieve data, fulfilling Department of Defense (DOD) Defense Contract Audit Agency (DCAA) audits & user requests.• Handled Oracle R12 yearly 1099 software update & functional support, resulting in 1099 on-time filing.

Provided user functional / technical support, issue solving, debugging and programming for PeopleSoft Financials 7.5. Supported users on Oracle EBS 11.0.3, Concur, and Kronos, included debugging and problem solving. Served on implementation team of Oracle EBS 11.0.3, Enterprise Resource Planning (ERP) and PeopleSoft Financials 7.5 and provided post-implementation support. Managed Accounts Payable 1099 yearly software upgrade and processing.• Utilized expertise providing functional and technical support for PeopleSoft Financials modules: General Ledger, Assets, Budgets, Billing, Accounts Receivable, Accounts Payable.• Developed, tested, implemented, and maintained custom reports using Structured Query Reporter (SQR).• Provided support for DOD and DCAA audits on financial data, using Query and SQL to retrieve data.• Supported Oracle functional users and resolved user issues on modules: Accounts Payable, Purchasing, Projects, Inventory, Bills of Material.• Diagnosed and resolved user issues, creating and resolving Oracle Service Requests using My Oracle Support (Metalink).• Designed and managed technical documentation, procedures and training materials, reflecting process improvements.• Handled change documentation, test scripts creation, coordination of locking out individuals, testing, and migration of approved changes from development and testing environments to production environment, in accordance with Sarbanes-Oxley (SOX).