Oracle Ebs Project Manager/sme Indirect Tax/solution Architect Resume
AtlantA
SUMMARY:
- Over 15 of years of IT experience with ERP Systems, Tax Technology software’s across various industries with thorough knowledge of full life cycle implementation, Support, Upgrade, enhancements and testing. Demonstrated business acumen with ability to accurately assess technical challenges and transform creative ideas into workable solutions.
- Extensive work experience in analyzing business processes, design, requirement gathering, mapping, GAP analysis, Functional architecture, functional analysis, process re - engineering, solution re-design recommending solutions, workarounds and implementing necessary solutions to insure automated functionality. Project Budgeting and Planning, Project Risk and Scope, Management of Offshore Resources and Documentation.
- Comprehensive understanding of Software Development Life Cycle (SDLC) process ranging from analysis and design to construction, implementation and maintenance.
- Experienced in Oracle EBS end2end process flow, transaction flow, workflow process, Sys admin setups & configurations, API’s, interfaces, conversions/migrations, Reports, Forms and Customizations. Excellent Techno/Functional knowledge in Account Payables (AP), General Ledger (GL), Account Receivables (AR), Fixed Assets (FA), Order Management (OM), Purchasing (PO), Project Accounting (PA), SubLedger Accounting (SLA), ERS Invoicing, Inventory Management, Warehouse Management Systems (WMS), Application Object Library (AOL) in R12.2.5, R12.2.4, R12.1.3,, 11i(11.5.10.2) with underlining base tables.
- Expertise in Implementing and Configuring Transaction Tax Automation with OneSource Determination ( Confidential ), Vertex, eBTAX, Taxware and SUT. Indirect tax Integration Install, Tax profile, events, Regime2Rate, and ERP Configuration. Indirect Tax server Install, Load balancing, performance tuning, Configuration, Tax entity setup, rules, classification, allocation, qualifiers, nexus, workbench testing, advance configurations, zones, rates, tax authorities, vat registration, exemptions, tax content, product mapping harmonize, non harmonize, rounding, xml attributes mapping, trans editors, system configuration and user administration.
- Managed Projects with proven PM Methodology’s (AIM and Agile methodologies). Conducted CRP(Conference Room Piloting), integrated testing, design validation and setups, Proof of Concept, Unit Testing, UAT and User .
- Experienced Oracle and Transaction tax automation professional. Worked as Project Manager, Subject Matter Expert, Project Lead, Senior Implementation Consultant, Technology Specialist, Technical Consultant, Techno-Functional Consultant, Senior Systems Analyst and Software Programmer/Analyst.
- Ability to deliver high quality results with attention to details. Excellent Analytical skills, Result Oriented, Organized, self-motivated, taking initiative, resourceful, systematic in undertaking responsibilities, work efficiently in a multi-tasked environment and good interpersonal, written communication skills.
TECHNICAL SKILLS:
ERP Application: Oracle E-Business Suite R12.2.5, R12.2.4, R12.1.3/11i; Kerridge Autoline System (Rev 8.3, 7.4); eMAS ERP (6.x). Oracle Fusion
Tax Technology: OneSource Determination ( Confidential ), Reports; Integration Modules P2P, O2C; SUT; Taxware.
Oracle Application Modules: eBTAX, Trading Community Manager, General Ledger (GL), Payables (AP), Receivables (AR), Project Accounting (PA), Assets (FA), Purchasing (PO), Inventory (INV), Order Management (OM), Payroll, HRMS, iSupplier Portal, System Administration, Application Object Library (AOL) and Workflow Administration.
Database: Oracle Database 11g/10g/9i/7.3.x; SQL Server 2008/2005, Microsoft Access.
Language: SQL*PLUS, PL/SQL, SQL * Loader, UNIX basic shell scripting.
Tools: Oracle Enterprise Manager, SQL Navigator, SQL * Trace (tkprof), Explain Plan, TOAD, Oracle, Microsoft office Visual Basic, Word, Excel and Powerpoint, Remedy Incident Management, OnePCC, Kintana, ALM, Confluence Web Tool, JIRA, Business Intelligence Reports.
Operating System: Windows, Windows Server 2003/2008, AIX RS6000, Linux, HP-UNIX, SCO-UNIX, MS-DOS.
PROFESSIONAL EXPERIENCE:
Confidential - Atlanta
Oracle EBS Project Manager/SME Indirect Tax/Solution Architect
Responsibilities:
- Project vision, milestones, checklist, planning, project charter tasks and estimation.
- Team management, mentor, work allocation, roll over
- Meeting agenda, minutes of meeting parking lot action item follow up
- System readiness, cutover planning impacting multiple systems and groups
- Impact analysis, Risk mitigation and contingency planning
- Analyze and define clients’ business strategy and determine system architecture requirements to achieve business goals.
- Formulate strategic plans for component development to sustain future project objectives.
- Gather detailed business requirements and use cases, and translate technical specifications into product requirements.
- Create team strategies and establish project scopes of work; communicate project deliverable timeframes and benchmarks to clients.
- Develop data architecture design to facilitate targeted customer analysis.
- Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize object-oriented software and database development.
- Identify strategies in launching new business processes change management
- Release management, change management and end to end CRP/UAT testing/Cutover/Go Live
- BR100 Configuration, Customization RICE MD50 and VAT Test cases, user
- Resolve cross functional dependencies, control code release migration approval
- Lead OracleR12 Implementation, Integrations, Customization, Proof of Concept, Unit Testing and Hyper care Production support
- Worked on Fusion Implementation for GE Healthcare, and involved in Financial implementation
- Guidance on Oracle Financial Module Functional Setups, Technical Guidance to Offshore team.
- Architected, Design & Developed Standards for managing Oracle R12 Integration projects.
- Overall guidance of Indirect Tax Integration projects (Implementation, upgrades and enhancements).
- Responsible for defining and enforcing Tax Integration standards for Oracle Projects and best practices to be adopted by different project teams; maintained overall responsibility for quality of solutions.
- Developed Transaction tax integration standards, update and maintain Confluence pages for OneSource P2P and O2C adapters.
- Designed & Architected ERS and SLA solution.
- Developed Transaction tax Integration user PL/SQL coding standards and best practices to be adopted by different development efforts and teams.
- Lead OneSource Indirect tax Integration Installation and configuration, troubleshooting install issues with resolution.
- Designed and implemented various Complex transaction tax Solution for EMEA, APAC, South and North America regions.
- Guidance on OneSource Determination Indirect tax solution configurations.
Confidential - San Jose
Oracle ERP Project Manager/SME
Responsibilities:
- Project management, planning, team management, cross functional task assessment, miles stones, status reporting
- Vendor Management, Resource allocation and Budgeting and costing.
- To conduct requirement gathering workshop, CRP/UAT, Understand business practices to reengineer common Oracle process
- Develop roadmap, plans coordinating global IT, infra, business for system readiness Identify business impact, risk of transition process in EOL of old tools and customization
- Led team to plan, design, and implement applications and software.
- Collaborated with business analysts, developers, and technical support teams to define project requirements and specifications.
- Lead design efforts to modify and add new functionality to Oracle E-Business Suite (EBS) Financials, including designing functional specifications for RICE (Reports, Interfaces, Conversions, Extensions) items.
- Launched complex recovery solutions to safeguard mission critical data.
- Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
- Configure BR100 all modules in Financials, OTC, P2P and Manufacturing with Testing
- Author RICEW MD50, MD70 and mentor local and offshore team for development
- Creating TAR (Technical Assistance Request) on Metalink for Technical/Functional Support with Oracle while finding issues in existing Oracle Applications Standard Applications Functions during Implementation, Production Support or while customizing existing Oracle Financial Standard Modules for Company’s new or enhanced business requirements.
- Oracle SR, OWC Session, escalations, follow up Oracle Account manager.
- Service request management, change control, code migration
- Meeting agenda, minutes of meeting parking lot action item follow up.
- To provide one point Oracle SME support to Business Leads, Offshore Team and Users
- Release management, change management and end to end CRP/UAT testing/Cutover/Go Live
- Manage Offshore team, Follow-up, case closure in timely manner.
- Monitor Incident in Remedy Tool and assigning task it to team member.
- Resolve Problem Management Incidents related to design change or enhancement.
- Cross functional dependencies resolution, Conflict handling
- Skill assessment, sourcing, mentor onshore/offshore resources, team building, work allocation, roll over
- Guidance on deploying the production bug fixes using Kintana tool.
- Configuring, using & administrating version control systems like Visual SourceSafe (VSS), CVS and PVCS.
- Trend Analysis Incident Report and Monthly management reports from Remedy Incident.
- Transaction Reports from Business Intelligence Tool.
- Bi Weekly meeting with Stake holders to update with Case reduction status and overall team performance.
- Designed and architected several complex solutions to resolve production bug fixes and enhancements.
- Responsible for enforcing new/existing tax rules in OneSource Determination
- Periodic Tax content upload in OneSource determination and leading the testing team complete regression testing to validate tax rules.
- Actively Participate in Monthly, Quarterly and Yearly end closing to resolve any tax related issues
Confidential - Oregon
Project Manager / Senior Implementation Consultant
Responsibilities:
- Worked at various levels for several clients.
- Involved in most of the stages of project development including requirement analysis, design, code development, enhancement, implementation and documentation.
- Gathering Tax requirements, Solution design, and Technical design for Use/Sales Tax and VAT. Preparing Project plans, scheduling meetings, status calls with client, maintaining issue log list.
- Project documentation includes technical & functional specification, Integration testing plan for P2P/O2C. Post install configuration setup document.
- Onsite installation and integration of Confidential product base for a Fortune 500 customer base. Installation of Confidential Solution, Reports in various technologies stack along with configuration. Install Confidential Connections Integration for P2P and O2C with Oracle R11i, R12 along with post install configuration.
- Develop Confidential precalc-postcalc user extension code using PL/SQL language for Sales & Purchase transactions with unit testing for Sales, Use Tax and VAT.
- Preprocessor program, Develop several scripts to automate concurrent request program, value sets and custom system profiles.
- Designed, Architected and developed the US Sales/Use Tax rate extractor program for POS system for one of the fortune 500 base company.
- Designing and configuring various custom tax rules in Confidential solution to meet the tax requirements and other business requirement for accurate tax results.
- Configuring various Trans editors, list, Product Mapping, Tax content, Custom Authorities, Other Tax rules to meet the tax requirements for Sales/Use tax and VAT.
- New Company setup, Customer exemptions setups and nexus establishment, exemptions, workbench testing, product mapping (harmonize, non harmonize, US and International), trans editors, advance configuration, zones, rates, list, allocation, rounding, xml attribute mapping, vat registrations, custom tax rules and tax authorities for special taxation.
- Upgrading Confidential Tax Application, P2P/O2C Integration from older version to newer version. Troubleshoot and debugging tax issues and providing a fix, research and analysis for unknown issues.
- Configuring eBTAX setups, tax events mapping, Regime2Rate flow setups
- Geography location setup for tax validation for applicable countries.
- Implemented Complex VAT projects for several clients.
Confidential San Diego
Project Lead
Responsibilities:
- Tax Requirement gathering, Project documentation include Technical design document
- Install and Configuration of Confidential Tax engine version 5.1.2.0
- Define and setup Confidential Tax rules, Trans editors, Nexus, Product Mapping, Direct Pay permit exemption s.
- Integrating Confidential Sales Connections adapter version5.0.3.0 with Oracle Apps 11i.
- Porting/writing precalc and postcalc extensions to make it compatible with current installed integration to meet the tax requirements.
- Confidential post install Oracle configuration (Functional and Sys admin) setups for tax results.
- Developed Pre-processor program that sets the status flag for the eligible invoices prior to running the Confidential Tax Process.
- Business use cases were tested various levels for all the operating units to verify taxation.
Confidential - Texas
Technical Consultant
Responsibilities:
- Install, upgrade Confidential Tax Application 5.1.0.0 along with Configuration in tax engine
- Install Confidential Reports and configuration.
- Integrating Confidential Sales and Purchase Connections 5.0.3.0 with Oracle Apps 11i.
- Verify installation and unit test sales and purchase tax automation.
- Technical Project Plan, Issue Log list, Project technical, functional documentation and scheduling meetings and Weekly Status call with client.
- Confidential related configuration, Functional and Sys admin setups in Oracle Payables and Receivables module to communicate with Confidential Tax application for tax results.
- Business use cases were tested various levels for all the operating units to verify taxation.
Confidential - Oregon
Techno Functional Implementation Consultant
Responsibilities:
- Worked at various levels for several clients.
- Several New implementations, Tax Adapter upgrades from 11i to R12.
- Tax engine upgrades from 4.x to 5.x.
- Requirement gathering for VAT, Project documentation include technical & functional specification, use cases and Oracle configuration Confidential connections post install setup document.
- Preparing Project plans, scheduling meetings, status calls with client, business requirement & analysis, maintaining issue log list to debug along with fix.
- Confidential Tax engine installation & configuration, Reports installation & configuration,
- Integrating Confidential Connections for sales and purchase along with installation & configurations with Oracle R11i and R12.
- Writing Confidential precalc-postcalc user extension code for Sales & Purchase transactions along with unit testing for Sales, Use Tax and VAT.
- Designing and configuring various Transeditors in Confidential tax application to meet the VAT requirements and other business requirement for accurate tax results.
- Define tax rule, Product mapping, Customer exemptions, custom authorities and nexus setup.
- Develop Tax rate extract program for custom integration.
- Upgrading Confidential Tax Application and Connections from older version to newer version, troubleshooting, resolving tax issues research and analysis for unknown issues.
- Import Tax contents for US and International monthly basis.
- Regime2Rate flow setup and configuration.
- Troubleshooting Install errors and resolving in timely manner.
- System configurations for clustering and performance in Confidential tax engine.
Confidential - Atlanta
Project Lead/ Techno Functional Consultant
Responsibilities:
- Tax Requirement gathering, Solution design, Project documentation include Technical design document
- Integration of Confidential adapter 5.0.2.0 for sales and purchase with Oracle Apps 11i
- Confidential related Configuration, Functional and Sys admin setups in Oracle Payables and Receivables module to communicate with Confidential Tax application for tax results.
- Tax engine configurations and setups includes (Nexus establishment, Define Trans editors, create tax rules, customer exemptions, list)
- Developed Confidential Precalc-Postcalc user extension code to meet the business requirements.
- Use cases were tested various levels for all the operating units to verify taxation.
Confidential
Project Lead
Responsibilities:
- Project lead on several efforts while supervising team of up to 5 engineers/developers spread across multiple locations along with techno-functional support in resolving major issues.
- Organize the status meetings and send the status report (Daily, Weekly etc.) to the Client.
- Scheduled Weekly Status Calls with stake holders on the project status covering testing status, testing results, defects, release management and delivery.
- Utilized excellent communication skills, to conduct responsive liaison and coordination with staff and management to achieve increased productivity.
- Managed oracle apps integration with Confidential tax solution applications from conception to implementation resulting in planned releases of functionality leading to improved processes and a reduction in man hours.
- Designed, enhanced, and maintained the collaborative applications including highly automated virtual team rooms, issues tracking, and discussion databases.
- Within a very narrow sdlc time frame, analyzed the user requirement, set up procedures for implementation of the development co-coordinating with the various stake holders of the project. Provided architectural design direction to the development team, Monitored the development cycle and overseen the testing activities of the application.
Confidential - North Carolina
Project Lead
Responsibilities:
- Tax Requirement gathering, Project documentation include Technical design document
- Involved in Apps Financial implementation with ERP Project Implementation team.
- Confidential tax connection was integrated with with Oracle Apps 11i for sales and Purchase.
- Sales & Use tax was implemented for United States; implementation includes the connections installation and configuration, Oracle Configuration, Sys admin setups in and Super User Confidential Post install setups Business used cases were tested various levels for all the operating units to verify taxation.
- Project documentation includes Confidential BR100 for AP and AR, Confidential Technical specification for precalc-postcalc user extension code, use cases document for United States and based on business requirement transeditors were designed and configured in Confidential tax application.
Confidential
Oracle Apps Sr. Functional Consultant / IT System Accountant
Responsibilities:
- Functional Lead for implementation of the Oracle Release 11.5.3 Oracle Financials, Order to Cash and Procure to Pay (P2P) modules.
- Reviewed all implementation deliverables both functional and technical.
- Provided feedback to Program Management Office (PMO), stakeholders, and system implementers. Deliverables covered all phases of the systems lifecycle including requirements, gapfit analysis, design documents, interface design, data conversion, User, and User
- Acceptance test test plans.Developed User guides
- Managed postimplenetation production support.
- Modules implemented: General Ledger, Budget Execution,
- Provided feedback to the Program Management Office (PMO), and stakeholders. Deliverables covered phases of the systems lifecycle including project plan, requirements, gapfit analysis, design documents, interface design, data conversion, User, and User Acceptance test test plans.
- Functional experience to integrate the Business application with Purchase, Sales, Finance, Costing, Store Inventory & Production Modules.
- Having strong analytical skills of gathering business process & evaluating end-user requirements.
- To facilitate mapping of the Business Processes with Applications to implement the project deliverables leading to end users for their satisfaction and to improve the efficiency & productivity.
- Work-around solutions; identify the Process-Change requirements. Customization Needs, Data Migration, validation and generating Reports as per requirements and the Interface needs.
- As-Is and To-Be Analysis, process mapping, GAP analysis. Mapping business requirements (Requirement Analysis).
- Supporting implementation team in preparation of required documents for project implementation with the management approval.
- Conducting sessions to IT core team and to Super users.
- Assisting IT Manager in preparation of Annual Budget and reviewing monthly expenditure for IT department.
- Preparing Detailed Process Flow for functional requirements.
- Project Library maintenance using Aims Methodology.
- Involved in creating and configuring various sub-modules viz. Post Dated Cheques, Letter of Credit, Landed Cost, Yard Management, Item Planning with Implementation team.
- Involved in designing and executing test plans and gap analysis to ensure that business requirements and functional specifications are tested and fulfilled with implementation team.
- Data Conversion strategy & planning. Apps Administration - Users, Menu, responsibilities, forms, reports and Concurrent request registration.
- Report Fit Analysis for all Business reports as well as Financial Reports.
- Involved in Core Oracle setups for the modules GL/ AP/OM/AR/INV and other profiles.
- Created many descriptive flex fields to record extra info viz. ledgers, divisions, product codes, delay reasons, change of schedule dates with reason etc.
Confidential
ERP System Analyst
Responsibilities:
- Studying the existing process for determining the ERP process requirements.
- Interact with Kerridge software consultants during the new software Setup.
- Involved in testing and implementation of the ERP system.
- Leading the IT team and Supporting installations, Responsible for sending MIS data as per the data transfer schedule.
- Imparting user for new applications.
- Resolving all day-to-day Kerridge Software related issues.
- Financial period roll up; Setting up new location.
- Creation of new account codes and cost centre codes as when required; Adhoc enquiries.
- Financial report designing; Familiar with Fixed Assets Module; Advance Analysis.
- Providing online support and communicate with users on all levels.
- ERP Software system to users, to identify maximum use of their systems.
- Installation and configuration of the ERP system, System Trouble shooting and providing technical support to the staff.
- Interacting with network application and helping them in setting up the connectivity between client and the Server as and when required.
- Designed and Developed MIS reports like:
- Management Summary Report, Trend Analysis, Comparison report
- Balance Sheet Summary Report, Income & expenditure/budget reports
- Transaction detail reports; Ageing report, Invoice reports
- Yearly Statistical Review Analysis based on overall performance of the company, Monthly Stock & Sales Summary report by Cost centres.
- Debtor’s outstanding analysis by salesman / by segment etc.