SUMMARY

• Over 8 years of Oracle Implementation experience with strong functional skills in Procure to Pay,
• Project Billing and Costing, Order to cash. Has strong experience in implementing Oracle Applications E-Business Suite solution 11i and R12 for U.S. Federal agencies US Navy, Military Sealift Command MSC , DHS
• Experience working with Oracle 10g/11g, 11i, 9i/8i/7.x, Developer 2000/Oracle 9i Suite Forms, Reports , PL/SQL, UNIX, SQL Plus, SQL Loader, MS SQL Server 2000/7.0/6.5, MS Access 7.0/2000/2002, SQL, Win 3.x/95/98/2000, Win NT 4.0, Toad
• 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.

Professional Experience:

• 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.

Confidential

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

Environment: Oracle, Java, Case Complete, Windows XP, MS word, Excel, Visio, Selenium, Bugzila

• The Automated Critical Asset Management Systems ACAMS is a Web enabled information service portal that helps state and local government build Critical Information CI protection program in their local jurisdictions. ACAMS provides a set of tools and resources that help law enforcement, public safety and emergency response personnel. ACAMS also provides state and local jurisdictions with a practical way to implement the National Infrastructure Protection Plan NIPP , including the NIPP Risk Management Framework.
• 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

Environment: Oracle, ERWIN, Window XP, MS word, Power point, Excel, Visio

• 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

Environment: Oracle Federal Financials 11.5.7 and 11.5.10, R12.0.0 Upgrade, Oracle Forms, Reports, Discoverer, Oracle 8.i 9i and 10g. Sun Solaris

• FMS is Oracle Federal Financials R11i EBS Suite with PO, AP, Oracle Projects, General Ledger, Fixed Assets, Accounts Receivables modules. FDM is Financial Data Mart system is a historical data warehouse system, gathers data from FMS system after month end close of books. Worked as Developer in FMS and FDM team.
• 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

Environment: EDW, SPS-PD2, Oracle, MS word, excel

• 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

Environment: Oracle financials, Data ware house, Oracle PL/SQL, SQL, JAVA, JDeveloper 8i/9i, My SQL, Toad, Supportrac.

• 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

Environment: Sybase, Oracle, test director, QTP

• Application developed by NCR Corporation for United States Postal Service. This application keeps track of all the USPS Clerk and Supervisor functions performed on daily basis. This application is a Client Server application with front-end written in C and the database being Sybase.
• 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