Senior Oracle Projects Consultant Resume
Houston, TX
SUMMARY
- 8 years of IT Consulting, Experience with world - class companies across US. Enriched experience as ERP analyst, software designing, analyzing, configuring, setups, testing, gap analysis, delivery and deployment in finance, supply chain and manufacturing industries.
- Lead the efforts of Business Requirements gathering, GAP Analysis, Test Plan Preparation, Unit Testing, Functional Architecture, System Integration testing, UAT, SDLC processes using AIM Methodology.
- Configured the Oracle application R12/11i based on solution design, performed gap analysis and designed workaround solutions.
- Excellent knowledge on Functional Analysis and Implementation, Techno/Functional analysis on Interfaces/Legacy conversions, Views, Reports.
- Trained the client’s super users and users on the application and conducting pilot testing, integrated testing, design validation and setups of the Financials, Manufacturing and Distribution ERP applications
- Functional documentation for Configurations (Setups), User Training Documents and Customization Documents.
- Performed System Administration tasks related to Menus/Functions, Responsibilities.
- Testing using tools QTP, Mercury Test Directory.
- Possess excellent analytical skills in understanding complex data relationships and in the areas of application programming, database and system design.
- Designed and developed the reports using the FSG, Oracle Discoverer and OFA.
- Worked with the DBA team in performance tuning efforts analyzing the coding and shell scripts. Possess extensive knowledge in Oracle RDBMS, Unix Operating system.
- Developed Interfaces, registering Concurrent Programs, Form Functions, Tables and defining profile values by AOL, System Administration, data migration, Mapping, Validation and exporting and importing data and assisted the software development teams in dealing with performance issues in all custom code released to the production.
- Prepared high-level functional design documents AIM docs i.e., BR100, MD50, CV40, TE40, MD60 for forms, reports extensions, CV docs of Conversion, from one Legacy system to Oracle Applications, Loading Data in to Interface Tables, Handling the Errors.
TECHNICAL SKILLS
Oracle ERP: Release 12.2, 11.5.10 Oracle Discoverer, OFA, ADI (Desktop/Web), FSG Reports, Workflow, Oracle forms, Reports and Designer and Workflows
Oracle Modules: EB-Tax, GL, AP, AR, FA, PO, CE, OM, Lease Management, I-Exp, I-Proc, Inventory, Advanced Collections, AME, PA, Service Contracts, TCA, and SLA.
Data access tools: Toad, SQL Loader, and Data Loader
Reporting Tools: Business Object 5.1, OBIEE, Oracle report manager, Hyperion
Databases: Oracle RDBMS 7.x, and 10g, SQL Server, DB2, MS Access, FoxPro Configuration
Management: PVCS, SharePoint and wincvs
Data warehouse: Zeus, Comshare, Hyperion, Data stage
Languages: PL/SQL, HTML, XML, Java, JavaScript, VB 6.0, ASP 2.0
Operating Systems: Windows NT, UNIX (Linux), Sun (Solaris)
Testing tools: Test Director, QTP
Tax Software: Premium pro, Quantum, Vertex and Sabrix
Remote Connectivity: Citrix server
Protocols: HTTP, TCP/IP, FTP, SMTP
Certification: Oracle Financials 11i.
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
Senior Managing Consultant
Responsibilities:
- Overall Solution Designing and migration custom components
- Implement the EB-Tax and AGIS Modules
- Solution design of Intercompany.
- Coordinate with Technical and DBA Team.
- Post Go-Live production support
Confidential, Alpharetta, GA
Senior Oracle Projects Consultant
Responsibilities:
- Implement Project accounting intercompany feature
- Support Existing Oracle ERP system.
- Demonstrates expertise to deliver functional and technical solutions on moderately complex customer Engagements.
Confidential, New York
Senior Functional Consultant
Responsibilities:
- Gather and Finalize requirements
- Preparing the test plans and instance strategy
- Provide subject matter expertise on functionality and capabilities of the Oracle AP, FA and GL
- Project co-ordination in testing efforts
- Solution design of integrating oracle applications with legacy systems
- Code review and documentation efforts
- Managing the issues and reporting for C-level executives
- Providing the Guidelines for performance testing
- Analyze user requirements and develop/enhance/maintain the Oracle application systems
- Analyze existing RICEW objects in R12 (Reports, Interfaces, Conversion, Enhancements and Workflows)
- Work with both Technical and Functional teams on the impact analysis of change requests to determine the impact on FAH/Oracle environment
- Perform configuration changes necessary to support the changes
- Write business requirements / functional requirements for enhancements or modifications
Confidential, Raleigh, NC
Senior Oracle Project Accounting Lead
Responsibilities:
- Process and application Design of Project accounting billing, costing, OTL modules
- Gather, Finalize requirements with GAP analysis.
- Solution design of PA billing, costing, OTL modules
- Design integrated solution of project accounting with EB-tax, Order Management, AP and PO modules
- Perform the CRP/Proof of concept for PA modules and OTL modules along with integrations
- Finalize the Project accounting Conversion scope.
- Design the MD60 for the Identified FRICEW objects
- Documentation of the proposed solutions for global model
- Identify the deferred requirements with solutions for future considerations
- Involve in resource planning and efforts estimate planning
- Involve the module licensing proposals
Confidential, Norcross, GA
Project Manager
Responsibilities:
- Provide project leadership and financial functional expertise in an Oracle Applications ERP environment to support business processes and objectives
- Lead the development of end-user reporting solutions by understanding user requirements and designing reporting solutions.
- Guide technical team in the development of reports, conversions, interfaces and extensions for Oracle Applications
- Perform gap analysis between current state and future state, develop test plan/test scripts and coordinate testing for enhancements.
- Understand and provide guidance in defining Oracle Application set-ups especially in the Financials, costing and Inventory modules
- Design and implement I-Expenses and Fixed Assets Tax Books
- Implement GL Budgets.
- Provide functional application support in a production environment, during enhancement and upgrade
- Projects Support Financial Modules (AR, AP, FA, GL, Cash Management, Costing).
Confidential, Oakbrook, IL
Senior Functional Associate
Responsibilities:
- Test and Integrate the AR and Property Management
- Implement EB-Tax module.
- Solution designing of Real estate Taxes
- Assess the effort and cost benefits.
Confidential, Grand Rapids, MI
Functional Consultant
Responsibilities:
- Support Financials and EB - Tax modules
- Gather and finalize requirements
- Manage Oracle SR’s
- Test the custom components.
Confidential, Asheville, NC
Senior Business Analyst
Responsibilities:
- Design and developed FSG reports to analyze the financial data at FDC and product segments.
- Proposed the solutions business processes standardization.
- Implementing the control measures for accrual accounting and configuration of the setups in inventory, purchasing, Order Management, WIP, BOM, MRP and financial modules.
- Co-ordinate the technical efforts in developing the custom reports as per business needs.
Confidential, Lowell, MA
Oracle Functional Lead
Responsibilities:
- Requirement gathering of Tax and configuring the module with documentation. Implement the oracle modules with AIM methodology providing the direction
- Implement E-business tax integrating AR, AP, PA
- Prepare the MD-50 solution design documents for the E-Business tax, PA, AR, AP.
- Testing the RICE components and conversion runs.
- Prepare the test scenarios and test scripts and co-ordinate the efforts for CRP end to end presentations.
Confidential, Los Angeles, CA
Oracle Techno/Functional Lead
Responsibilities:
- Coordinated and lead the entire phase of the project which included initial operations analysis, business process evaluation, testing, conversions, customizations and documentation.
- Configure GL COA, CV and Security rules, AR Customer Relationships, and Inventory Organizations.
- Maintain proactive interaction with the client to understand business practices to aid in system configuration.
- Prepare the test scripts and perform SIT Testing. Document the setups and business process flows.
- Design conversions strategy for AR and AP including code migration and cutover activities.
- Develop detailed functional design specifications based on business requirements for interfaces and extensions to provide seamless integration between Oracle Applications and Custom Applications.
- Develop functional design specifications for custom reports based on business requirements.
- Review and approve technical design specifications for custom objects and ensure that the design meets business requirements.
- Design FSG reports and coordinated technical efforts in developing the custom reports
Confidential, Chicago IL
Senior Techno/Functional Consultant
Responsibilities:
- Perform Fit/Gap analysis, pre-production business testing, conference room pilot support and developed presentation outline, collecting materials.
- Design and perform the test scenarios. Prepared the test plan configurations and documentation.
- Collaborated the testing efforts of the team and evaluated the test results to fix the bugs.
- Perform the configurations of General Ledger, Accounts Receivables, collections, Accounts Payables Leasing and Workflow modules.
- Design and develop customizations, interface/conversion mapping, pre-production testing and related documentation.
- Setup Oracle AME rules, attributes, and conditions including the modification of the procedure for invoice approvals.
- Perform the Key Design Decisions for the initial configuration of Chart of Accounts, Flex fields.
- Prepare the test scenarios and test scripts (TE40) and executed the testing activities.
- Configured Receivables Auto Lockbox and Perform the vertex tax configuration
- Implement Vertex Integration to Receivables to facilitate accurate tax calculations.
- Document and test the integration interface of PeopleSoft General Ledger and Oracle General Ledger
- Configure the Multi-org with complex intercompany organization setups.
- Design the FSG Reports for reporting