SUMMARY:

• Proficient in PL/SQL programming (Functions, Procedures, Packages, Triggers, Indices, Materialized Views and Database Objects). Experience in Stored Procedure and Query Performance tuning using Explain Plan, TKPROF, Query Analysis, Rephrasing Joins and Search Arguments Analysis
• Creating / Writing SQL statements, PL/SQL programs, Views, Materialized views
• Managed and created several technical design documents, user manuals, installation instructions, implementation notes and detailed test scripts
• Developed and presented Power Point presentations for new system procedures and functionality to the federal customers and also created user student guides for one on one and group presentation teams of 10 - 12 for both client and federal customers
• Created standard operating procedures for Help Desk analysts to resolve tickets and communicate to users in a professional and timely manner
• Tracked, logged and resolved Remedy help desk tickets by providing technical solution to the clients and as well as the federal customers
• Performed Unit Testing, Regression Testing, User Acceptance Testing(UAT) and resolved issues in all phases of testing
• Experience with Microsoft Office tools such as MS Power Point, MS Word, MS Excel, and Microsoft Outlook
• Collaborating with client stakeholders to manage issues to resolution and developing practical tracking measures and status reports, training end users on procedures and functionality
• Experience in Multiple modules of oracle applications implementation such as Purchasing, Oracle General Ledger, Oracle Payables, Oracle Receivables, Project Billing and Costing, Sub ledger Accounting, and also Workflow Administration.
• Experience with the integration of Oracle Financial/Purchasing Applications with MSC - FMS and BPS.
• Diversified experience in all phases of the software development life cycle, from requirements definition through testing and deployment
• Highly self-motivated and goal-oriented professional with exceptional problem solving and sound decision making capabilities, recognized by associates for providing complete, accurate, and alternative solutions to complex problems.
• Implementation and support Enterprise Resource Planning (ERP) systems Oracle Applications 11i with focus on Federal Financials, procure to pay (Purchasing, Account Payables, General Ledger), Order to Cash Modules (Receivables, GL).
• Experience in process and functionality gap analysis, solution design, developing functional Technical specifications, process flows, data migration, reports, Data Warehouse and Discoverer Reports.
• Conducted Conference Room Pilot (CRP) sessions, Developed test plans for module testing, system integration testing and User Acceptance Testing.
• Supported business users questions and concerns related to new software capabilities, benefits and process changes and business process re-engineering. Strong experience in development, and Implementation of Oracle Applications Internet and Intranet applications
• Worked with business users on business process reengineering, performance improvement, business process design, Supplier management, risk mitigation, approved suppliers list, supplier relationship and access to online invoicing, payments and transactions, supplier master data management issues and processes
• Participated in defining application security, role, responsibilities, processes and standards.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Release 11i and R12, PO, AP, AR, PA, GL and Federal Administrator

• Currently supporting the training team in developing business process work instructions to reflect DNDO-FAAMS business.
• Creating step by step scenario based work instructions and providing one on one user support resolving day to day issues in P2P, CLM Awards, B2R, Projects
• Created training manuals, scenario based exercises, student hand guides and setting up formal FAAMS training to the user community and captured and updated the training notes/meeting minutes/issues to reflect the same in modifying the Business Process.
• Worked closely with the change management team in creation/modified the Business Process documents to reflect the current DNDO system to To-Be
• Supported the Data migration team in data conversion from PRISM to the Oracle federal financial system in all stages
• Identified the Contract IDs, Document ID numbers and matched the dollar amounts from PRISM to oracle system and to the CLM Awards
• Closely assisted the Users in validation testing verifying the migrated contracts from Prism to Oracle financial system with CLM Awards
• Simultaneously involved with the training team and created the training materials for specific scenarios validating them against the DNDO system
• Analyzed client requirements related to enhancement and customizations as per the new business demands
• Traced problems/issues analyzed and formulated solutions for the same.

Confidential, Falls church, VA

Oracle EBS Release 11i and R12, PO, AP, AR, PA, GL and Federal Administrator

• Hands on experience in troubleshooting system and application issues and managed daily issues/help desk tickets. Worked on the control charts and delivery dashboard
• Managed the Service Request and periodically reviewed the performance based the severity status of varying levels of 1, 2 and 3. Prepared a status report of the Service Requests based on the SR’s Opened, SR’s Backlog, SR’s Resolved, critical SR’s logged and closed within 24 hours
• Analyzed client requirements related to enhancement and customizations as per the new business demands
• Traced problems/issues analyzed and formulated solutions for the same.
• Logged Technical Assistance Requests (TAR)/Service Request (SR) and worked with Oracle Metalink Support to resolve the issues
• Entered Project and Task budgets and baseline them so that purchasing documents (PR, PO) can pass the funds check
• Resolved Funds check failure issues by researching into the Project costs /General Ledger a/c's ( Commitments, Obligations and Expenses) from the Project Status Enquiry form to calculate the available budget and reported to the Financial Operations office.
• Generated GL trial balance, AP Invoices reports based on the CR on as needed basis using the OBIEE - Business Objects reporting tool
• Created new projects based on the project templates
• Supported the Training team in creating/updating the training manuals/documents for every enhancement/release.

Confidential

Senior BA & Functional Consultant

• Provided support as a Business Analyst by understanding and gathering Business Requirements.
• Provided Functional solutions to the Development Team during the build of custom objects for the ACAMS Portal
• Designed Functional solutions for Geospatial mapping structure to identify the Emergency Responders
• Conducted User Acceptance Testing (UAT) sessions with the customer, logged defects and resolved them
• Supported the QA team in all phases of the testing with regression, Integration, System testing and as well as updating/creating the test cases and use cases
• Involved in discussions with the Development team for modifying and updating the new business requirements on an as needed basis
• Resolved Help desk issues for ACAMS users. Tracked the number of tickets issued/resolved and logged them
• Created User accounts for ACAMS Users by contacting the State POC or by reaching the higher personnel for the account holders
• Helped training team with the development of training materials
• Assisted in setting up the webinars and tutorials for the ACAMS users within the team

Confidential

Senior Oracle Data Modeler

• Served as Oracle Data Modeler for Information Protection (IP) Information Data Management Branch (IDMB) in support of DHS data discovery process
• Supported Homeland Security as an Oracle Functional in assisting DHS Data Discovery Process for IP Conceptual model
• Identified the available ER models for systems like ( PCII, ACAMS, NIEM, EAIR, SAV, IST, etc.,) by using ERWIN tool
• Created the Data Dictionaries using the ER Models for mapping the IP Conceptual Data Model to HLS ECDM - Homeland Security Enterprise Data Model
• By understanding the IP Physical Enterprise Architecture, developed the IP data discovery document focusing on the major artifacts that were discussed and reviewed by the client.
• Created and provided the Gap Analysis document from “As-Is” to “To-Be” state to match the IP Physical Enterprise Architecture
• Created and presented power point presentations in all stages as needed by the client
• Captured meeting minutes and action items for upcoming events
• Gathered all the necessary documents by reaching out to the POC

Confidential

BA & Functional Analyst

• Worked closely with Program Comptroller office users in gathering requirements, supporting and training users
• Worked on requirement analysis and provided gap analysis solutions
• Worked on the Operations and Maintenance of Oracle Financials
• Worked on AP, PO, GL, Projects Interfaces and Customizations. Written Concurrent programs and sql loader scripts.
• Worked on interfaces like DTS (Defense Travel system) Inbound Purchase order Interface. Register-6 Inbound Payables invoices Interface and DCPS (Defense Civilian Payroll System) Inbound payroll expenses to projects interface.
• Involved in the design and preparation of Technical Design Documents (MD-70 and MD-120).
• Written ETL (Extraction and Transformation) programs to transfer GL entries into FDM (Financial Data Mart System), Validates and Summarizes.
• Developed reports using Oracle applications Business Areas (folders and custom folders) using discoverer desktop and giving access to appropriate responsibilities to add security so that access to these reports from Oracle Application modules will be possible by END users who have these responsibilities assigned.
• Developed Discoverer reports off of FDM system like Profit and Loss, Net Operating Results, Budget Analysis, Budget to Actual variances analysis etc.
• Supported the development team in identifying data source from FMS system
• Involved in END user training on new variance analysis reports
• Designed reconciliation profit and loss, variance analysis reports after each month close of GL books

Confidential

Business Analyst

• Assisted in maintaining and developing SPS-PD2 Integration translators using Web Methods with other NAVSEA software systems
• Provided Functional and Technical specification for SPS-PD2 integration
• Manually migrated contracts from legacy systems to SPS-PD2 using Microsoft word and excel
• Involved in enhancements and testing on SPS-PD2

Confidential

BA and Functional Analyst

• Served as a technical support to the Department of the Navy, Military Sealift Command (MSC)
• Supported helpdesk calls in troubleshooting technical issues and created helpdesk tickets
• Provided Functional solutions to the Development Team during the build of custom objects for the application
• Conducted User Acceptance Testing (UAT) sessions with the customer, logged defects and resolved them
• Supported the QA team in all phases of the testing with regression, Integration, System testing and as well as updating/creating the test cases and use cases
• Involved in discussions with the Development team for modifying and updating the new business requirements on as needed basis
• Resolved Help desk issues for BPS users. Tracked the number of tickets issued/resolved and logged them
• Created User accounts for BPS Users and supported them in logging to the Discoverer reports navigation
• Helped training team with the development of training materials
• Created user manuals for new enhancements

Confidential

QA Consultant

• Developed test cases to check Front Office and Back Office Reports
• Performed GL Code adjustments and reports such as Standard Field Account System (SFAS), End of Clerk’s Day (EOCD), International Aviation and Security Measures. Developed matrices for various projects to carry out regression testing.
• Conducted User Acceptance Testing (UAT) sessions with the customer and resolved them
• Logged defects in defect tracking tool using test director
• Supported testing in all phases of the testing with regression, Integration, System testing and as well as updating/creating the test cases and use cases
• Involved in discussions with the Development team for modifying and updating the new business requirements on as needed basis
• Resolved Help desk issues for USPS users. Tracked the number of tickets issued/resolved and logged them
• Created User accounts for USPS users
• Helped training team with the development of training materials
• Created user manuals for new enhancements