SUMMARY:

• Over Sixteen years of IT experience in software development and implementation.
• Over Fourteen years of expertise in Oracle Applications in general, General Ledger, Accounts Receivable, Project Accounting, Oracle Purchasing, Oracle Payables and Oracle Receivables in particular. Involved in all aspects of the system life cycle. Expertise in developing Data Exchange Systems between various ERP Applications (SAP Inventory, People Soft Human Resources and Ariba Purchasing).
• Involved in GAP analysis, design, defining and implementing Business rules.Involved in Design, Develop and Implementation of complex extensions for COTS package (Oracle e - Business Suite) implementation life cycle for Confidential .
• Lead Development and Deployment teams both onsite and offsite.
• Level set stake holders with Project Scope and Timelines.
• Responsible for deliverables and was Liasion between Federal SMEs and Implementation & Support Teams.
• Involved in Localizations and Globalizations of business processes post implementation of ERP suite.
• Responsible for Corporate Consolidation, Translation and Revaluation processes. Team member for Global Implementations, which includes Multi-Org, Multi-Currency and Multi-Language.
• Worked with Clients conducting JAD sessions for business process review, analysis, Business Process Reengineering and Automation for their Global Implementations. Responsible and Lead support team for worldwide supports, which involved direct interactions with different end user communities.

ORACLE APPLICATIONS EXPERTISE:

• 5 Full System Development Life Cycle Implementations of Oracle Applications
• Over 14 yrs of Oracle Business Suite & other ERPs
• Expertise in Global Implementation
• Oracle Financials 12x, 11x, 10.7, 10.6, 9.4
• Oracle Federal Financials
• Accounts Receivables
• Accounts Payables
• General Ledger
• Oracle Project Accounting
• Oracle Grants
• Oracle Workflow, Purchasing and Alerts
• Other ERP Integrations SAP, Peoplesoft, Ariba.
• System Administration
• Oracle Enterprise Manager (OEM)
• Oracle Discoverer
• Business Objects XI Suite
• Oracle DBI & Balance Score card (AP & AR)

CONSULTING SKILLS:

• Global Implementations Expertise
• Analysis & Design
• Configuration Management
• Business Requirement Gathering
• Functional Team Lead
• Standardization for SDLC
• Business Process Automation
• Interface Support
• Organization Skills
• Communication Skills
• Implementation Methodologies
• PDLC (Project Development Life Cycle)
• Oracle OUM & AIM
• Ascendant’s Methodology
• Visio, Oracle AIM, Microsoft Project, Microsoft Excel, Microsoft Word, Power point, OUM

PROFESSIONAL EXPERIENCE:

Confidential

Functional SME

Responsibilities:

• Architecting the overall R12 solution using latest R12 technologies including SLAs & Financial Accounting Hub
• Gap analysis and design documents for General Ledger
• Overall Gap analysis and design deliverable for NBS project
• Routing six different GL interfaces through Financial Accounting Hub
• Implementing Chart of Account changes for SGL & Object Class segments
• Remediating NBS GL customizations for R12
• SLA configurations for Supply accounting (AADs, JLDs, ADRs, custom SLAM)
• Redefining Month End Close process to R12 requirements
• Realign and remediate Year End Close process to R12 compliance

Confidential

Functional SLA SME

Responsibilities:

• Ensure financial footprints for transactions sourcing from Purchasing with custom SLA rules
• Design, create, modify Application Accounting Derivation Rules (AADRs) for Accounting Flexfield segments for GTAS compliance
• Analyze and verify end-to-end user reconciliation for PO, Payables SLA and GL modules
• Map replace transaction code with SLA rules
• US Mint product line accounting alignment to Financial accounting using SLA custom sources
• PLA flexfield derivations and overrides using SLA’s & JLTs
• Design custom functions to match requirements for USSGL derivation based on custom business rules for State, Confidential
• Documenting business scenarios for US Mint R11 and mapping to R12
• Review P2P processing for US Mint and realign them R12 Payment processing features

Confidential

Project Lead & Sr. Functional SME

Responsibilities:

• The users able to get transparency and insight to the system processing and correlate the same to the financial footprints for both transactions within and external to the financial system of record.
• Improved end-to-end user reconciliation procedures by leveraging standard R12 functionality
• Financial reports assisting month end, quarter end and year end closing
• Client appreciated the Quality Assurance and delivery methodology and were planned to be implemented on other internal projects
• Configuration documents (BR100) to register/define custom PRICEW objects and including them as part of deployment package
• Functional Design (MD050), document, walkthrough and sign-off for In-Transit, Income statement by product
• Technical Design (MD070), reviews, walkthrough and sign-off on Order-to-Cash reconciliations
• Build scripts for migration using LDT files and fndload APIs
• Creating use case transactions, run processes using Sub-Ledger Accounting (SLA) rules Oracle seeded and custom ones to ensure reconciliation between sub-ledgers modules and multiple ledgers
• Assisted Technical resources in understanding the transactional data relationships between SLA tables (XLA schema) and multiple ledgers
• Multi-Org Access Control (MOAC) set-ups that enabled required users have access to data and reports across Organizations
• End-to-End process reviews and providing recommendations to using standard R12 functionality and limit customizations and/or extensions were possible

Confidential, Baltimore, Maryland

Project Lead & Sr. Functional SME

Responsibilities:

• Solution development and drive Key business decisions by formulating and leading Core, Steering Committee user groups
• Baseline project scope, managing stakeholders and conducting conference room pilots (CRP) across financial and P2P modules
• Led the IT solutions team both functional, technical to perform requirements gathering
• Create Requirements Traceability Matrix (RTM) for standard and customized processes
• Mapped standard R12 solutions on detailed requirements and leverage more with new R12 features
• Create and document use cases to ensure expected outcomes on sub-ledger accounting rules
• Configuring set-ups and creating transactions with required uses cases
• Create and maintain BR100 setup documents for all payable options and components
• Presenting options and alternatives to business group on key decisions on extensions and customizations
• Analyzing a decade of customizations and limiting them where possible by adapting new Release 12 features
• Design and led solutions on finalizing Chart of Accounts, Legal Entity, Operating units, Ledger Sets Design for streamlining operational procedures and achieving Corporate level consistency and insights
• Create end-to-end use cases for benefits of new architectural changes for single transaction source and multiple reporting ledgers that can simply operations and attain regulatory compliance
• Conducted CRP sessions for Payables, Receivables and Cash Management modules
• Obtaining User sign-offs on R12 solutions

Confidential, New York City, New York

Project Manager & Functional SME

Responsibilities:

• Leading solution development and delivery Key business decisions
• Upgrade benefit analysis, value and business agility
• Analyzing a decade of customizations (CEMLI) and implement and adapt to new Release 12 features
• Design and develop Global solutions like creating and mapping Legal Entity, Operating units, Primary, Secondary Ledgers, Ledger Sets
• Design, develop solutions with Release 12 features and limit R11 customizations by using Accounting Methods, Multi-ledgers Cash and Accrual reporting ledgers and global consolidation ledgers
• Lead strategies for design, development, test, CRPs, UAT with R11 use cases
• Project lead and owner for end-to-end General Ledger and Payables solutions
• Configuration set-ups for CRP instances and BR100 baseline
• Conducted Global CRP sessions for Global users
• Setup management using Oracle Applications Change Management Pack to migrate configurations across instances.
• Sandbox test for Applications Management Suite compare setups across multiple instances
• Implement industry best practices and redesign business processes to eliminate huge customizations
• Standardize, streamline business processes to use new Release 12 features like MOAC, SLA, ledgers, Payment manager, AGIS, Cash Management, Organizational restructure, integrate HR modules.

Confidential, Boston, Massachusetts

Functional Lead & SME

Responsibilities:

• Requirement gathering from Project stakeholders and sponsors
• Lead solution development and delivery
• Configure and document using Application Implementation Methodology (AIM)
• BR100 setups with screenshots and deployment instructions
• Conduct CRP1, CRP2, UAT, Production readiness, transition and Go-Live
• User documentation and training assistance
• Coordination and integration with their Enterprise systems, including i-procurement, purchasing, projects.

Confidential, Washington, DC

Functional SME

Responsibilities:

• Conducted workshops with stakeholders and end user community on assessing the required functionality
• Impact analysis on Sub - Ledger Accounting (SLA) and mapping with transaction codes
• Detailed analysis in identifying Confidential Custom extensions for Projects, Receivables, GRANTS, FAS reconciliation, GCA600, CAN/BACs and providing R12 alternatives
• Assessment on Release 12 features and detailed impact analysis for Projects, Receivables, Payables and Federal Administrator modules
• Impact on custom extensions and design changes to accommodate continued functionality in R12

Confidential, Rockville, MD

Functional SME

Responsibilities:

• Functional SME for Confidential Operations & Maintenance - Incident, Change, Oracle Service Requests and Release processes
• Functional SME for Projects, Receivables, GRANTS, FAS reconciliation, GCA600, CAN/BACs & ADI
• Key contributor for successful Confidential Year End close across Confidential
• Standardize reconciliation process across Confidential with Global solutions and process improvements
• Conduct Change Control Board (CCB) Meetings with Stakeholders
• Review global and site specific solutions and alternatives
• Support Confidential Month End close, UAT, Regression Test (RT) including FIT reviews on Change Requests
• Expertise in conducting Tickets/CR analysis and process improvements for recommending annual Confidential Global Strategic Initiatives (FY09, FY10)
• Oracle Enterprise Manager (OEM) to monitor performance issues during month and year end close
• Authored white papers and presentations on Confidential Global issues including Year End close and performance tuning
• Support cross functional teams including Confidential Site Support, CORE, Confidential User community
• Functional Lead for Confidential Cash Management Strategic Initiative Confidential Experience includes Confidential Global O&M Team (2 years) and Confidential Go-Live (10months as part of Confidential Implementation Team)
• Lead O&M activities, includes troubleshooting; service requests; issue resolutions; Confidential status updates; alternatives and workarounds for production issues for Confidential Year End Close, Projects, Receivables, GRANTS, CAN/BACs & ADI modules.
• Lead requirement gathering & SDLC to Design, Develop Global Extracts for Federal Aid to States (FAS) required by US Census Bureau.
• Impact Analysis for APPSTACK (11.5.10 upgrade); outlined Impact Analysis and LOE on Global Extensions, Business Functions, User Interface, and Upgrade Enhancements for Projects & Accounts Receivable modules.
• O&M POC for Confidential Knowledge Transition on Confidential Extensions & Operational Reports from Confidential Implementation Team.
• Facilitate by providing Functional Inputs to PSC Site Support on White Paper contrasting PSC s Projects Implementation vs CDC & Confidential .
• Analysis on Global vs Site specific setups and maintain them in corresponding BR100s
• Implemented custom Global Business Rules to make form fields required using Logical Apps.
• Facilitated data clean-up activity across Confidential .
• SME for production issues encountered during Month End Close; analyze ROOT Cause analysis and alternatives & Global Solutions to address issues.
• Liasion between cross functional site support teams; Federal SMEs; Development; Testing and Infrastructure teams.

Confidential, Rockville, Maryland

Functional Analyst

Responsibilities:

• Design, Development of custom reports to meet Confidential Operational and Management requirements.
• Confidential top 30 reports include reports from Purchasing, Projects, Accounts Receivable, General Ledger, PRISM and Fed Admin modules.
• Liasion between GDC Development team and Confidential SMEs. Responsible for requirement gathering for Confidential business rules and requirements for modules implemented for Confidential within Confidential .
• Functionality and Reconciliation of reports with respective modules within Confidential and PRISM.
• Designed reports for Discoverer Tool. Some reports involved in understanding of PRISM functionality and pre - population processes that populate reporting tables.
• Requirement Gathering, Design, Development lifecycle for Confidential Receivables Aging report. Responsible in defining custom receivable aging buckets per Confidential business rules.
• Requirement Gathering, Design, Development lifecycle for Confidential Project Funding and Project Status reports. Responsible in implementing Confidential business rules for Capital and Reimbursable projects.
• Requirement Gathering, Design, Development lifecycle for Confidential Requisition Activity, Unliquidated Obligations, Open and Blanket Purchasing Reports.
• Requirement Gathering, Design, Development lifecycle for Confidential Income Statement. Report was custom and specific to Confidential needs. It involved in working closely with Confidential Management Finance to identify the Confidential specific business rules and requirements. Report was based of Confidential General Ledger module and derivative of standard Trail Balance reports.
• Requirement Gathering, Design, Development lifecycle for Confidential Invoice on Hold and Aging reports within Confidential Payables module.
• Involved in configuring Projects module, include creation of project templates; define project types and class; dataloads for project lookups; setup DFFs to capture and store client specific custom data feed sourced from transaction interface.
• Create budget types, entry methods, change reasons for project budgets.
• Define expenditure categories, types and classes. Define transaction sources for custom interfaces for project expenses.
• Design custom reports to reconcile cash based costing. Reconciliation of PSI screens with across modules sub-ledger data that interface with projects accounting.
• Reconcile Projects details with Obligations, Commitments from Purchasing; Disbursements from Payables and posted transactions with USSGL accounting.
• Conduct Walk through meetings with cross functional, IV&V and Confidential teams for requirement reviews and design approvals.
• Conduct working sessions between cross functional groups to do gap analysis and finalize requirements for design specifications.
• Worked as a liaison between the development team and Confidential SMEs(Subject Matter Experts) to find work around for certain Discoverer limitations.
• Involved in data requirements for data extract feeds for FRS (Financial Reporting System).
• Worked proficiently with tight deadlines by multi tasking and managing deliverables.
• Worked closely with end users in presenting standard COTS reports and to understand their current reporting solution to contrast pros and cons of implementing using discoverer reports

Confidential, Woodlawns, Maryland

Functional Analyst

Responsibilities:

• Application Integration strategy for Confidential & FIS(Financial Information System).
• Identifying key business functions develop strategy and timelines for UAT and integration phases.
• Identify user profiles and average volumes to strategize performance test.
• Work as a liaison between the development team and Confidential SMEs(Subject Matter Experts) to understand their business functionality.
• Document profiles and volumes for Accounts Receivables (A/R), Accounts Payables (A/P), General Ledger (G/L) and Purchasing (PO) modules of Confidential for Stress Testing phase.
• Work with development team and SMEs (both Oracle and Confidential personnel) to simulate a typical Confidential and FIS business day volumes for performance of both applications.
• IV&V task to evaluate and finalize between BI (Business Intelligence) tools and software. Evaluation of software from different vendors Business Objects, Oracle s business score card and DBI modules.

Confidential, Linthicum, Maryland

Techno/Functional Analyst

Responsibilities:

• Accounts Receivables Analysis, as solution provider for GAP Closure Alternatives (GCA), Design Decision Alternatives (DDA) & presentations for Confidential, CMS & its Medicare Contractors Teams
• Implementation of Ascendant’s Methodology for Analysis and Design Phase of the Project Life Cycle
• Involved in providing strategic solutions for phased implementation
• Involved in long-term storage/archival solutions for Digital images related to Accounts Receivables
• Involved in integration of Optio Software with Accounts Receivables Implementation
• Responsible for group presentation for out-of-box features of Oracle Receivables Dunning Process
• Involved in Configuration Management and setting up instances based on BR100 baselines.
• Extensively involved in User interaction and capturing requirements.
• Involved in Technical Design of various custom extensions including code review.
• Presenting Technical solutions to different audiences using Visio, Power point Presentations.
• Involved in Database architecture and process handling and implementation of coding standards.
• Automation of setups using tools like Data Load and Win runner Tools.
• Coding, Develop Test Strategy, Unit Testing, System Testing and identifying system readiness criteria.
• Design, Develop and Deploy custom Forms as per requirements.
• Design, Develop scripts to apply Confidential specific Business Rules and various Regulations.
• Lead development team and extensively involved in cross-functional teams in providing efficient solutions.
• Developing & Documenting possible business scenarios and creating Crude Matrix for capturing different combinations of business rules.
• Design, Develop custom Reports that help reconciliation to General Ledger.
• Involved in meetings with end user both offsite and on site interactively participated through out the project, debugged, tested implemented and documented all the tasks assigned.

Confidential, Parkridge, New Jersey

Applications Lead / Functional Analyst

Responsibilities:

• Involved in all phases of Development Life Cycle for Inventory Reserves Project.
• Designed Interface to General Ledger for creating Journal Entries to offset periodic Reserve Balances.
• Designed Common Business Objects that are shared across applications.
• Designed Reconciliation Tools, which include Complex Summary and Detail reports for various Levels.
• Designed Custom Forms for capturing and storing custom data.
• Designed & Lead Development for Reconciliation Tools to verify Reserves against the GL Account Balances.
• Designed the Net P&L Impact Summary Reconciliation Tools for Inventory Reserves.
• Designed and Lead Development for Inter-company Engine as part of ECubic Project for Cashless Settlements for Accounts Receivable between various Confidential Offices worldwide.
• Designed and mapped SQL*Loader programs to convert settlement data files into AR Receipts using the Lockbox Interface and applying them against the outstanding receivable transactions.
• Designed and Lead Development of custom scripts to create Debit/Credit Memos to settle AR outstanding which are than imported using the AutoInvoice Standard Open Interface.
• Automation of the whole process by designing and registering of Shell scripts which are equipped to email execution summary and detail reports at the end of the process run without any manual intervention.