SUMMARY

• Over 9 years of diversified experience in the field of Information Technology with emphasis on Business Analyst, Software design and development. QA Lead, and Program/Project Manager experience.
• Over 4 years of extensive experience as an Oracle EBS Techno Functional Consultant in implementation, support and enhancement projects of Oracle E - Business Suite focusing primarily on Finance, eBTax and Supply Chain modules
• Experience in working on functional modules in the environment of Order-to-Cash (O2C) and Procure-to-Pay (P2P) cycles
• Extensive experience of Indirect Tax Automation (Technical and Functional) Leveraging Sabrix (One Source)
• Expertise in integration of Sabrix with ebTax for O2C and P2P and Satellite applications.
• Expert in Indirect Global Tax (VAT, PCL, WEEE, GST, US Use/Sales Tax, Canada HST, PST, other taxes as applicable),
• Extensive experience in writing and reviewing QA and UAT test scripts and manage them using HPQC.
• Experience in conducting in CRPs and coordinating SIT and UAT.
• Experience in requirement gathering, solution design and documentation.
• Extensive Experience in eBTax configurations and knowledge of Vertex Integration.
• Expert in Indirect taxation worldwide (VAT, GST, US Use/Sales Tax, India taxation)
• Working with Oracle Support: Identifying the issues that arise as part of Support projects and creating Service Requests (SRs) with Oracle Support and tracking them to closure
• Strong experience in developing automation framework from scratch. Maintaining, upgrading the automation scripts to future application changes.
• Experience in project planning and scheduling the various phases of the project with appropriate timelines, coordination, resource scheduling, work allocation and reporting.
• Exceptional ability in coordinating multi-shore teams in attaining Project Milestones
• Excellent communication, organizational and interpersonal skills with an ability to perform individually or as a team.
• Extensive experience in Pricing Suite (Advance Pricing, Price Manager, Price List Generation, Deal Manger, Profit Analyzer), Oracle E-Business Suite (GL, AP, AR, Purchasing, O2C), OM. Oracle ERP Integration with Satellite systems (Indirect Tax Engine - Sabrix/Onesource) and other web-based applications.
• Expertise in QA Methodologies, Quality Assurance Life Cycle, Defect Management Life Cycle, Software Development Life Cycle (SDLC) methodologies (Agile, Traditional waterfall) and on ISO, CMM & CMMI standards
• Extensive experience in White Box Testing, Black Box Testing, Integration Testing, System and Acceptance Testing, Performance Testing, Regression Testing, Internationalization (I18n) Testing, Ad hoc Testing. Testing of Object-Oriented Systems, Usability and Acceptance Testing.
• Strong Team player and contribute towards the team goals. Ability to work productively and effectively in a team as well as individually. Led multiple Projects with multi-site & multi-cultural teams.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. ERP/Tax Consultant

Responsibilities:

• Worked with Business users on Requirement gathering for various Finance requirements
• Interfacing with customers and technical teams to design, develop, test, and deploy Oracle ERP 11i & r12 Finance based applications to support business requests.
• SME for ERP R12 - Sabrix Integration starting from requirements, design, implementation, testing (IT SIT, Regression, UAT etc.) and Go-live and post go-live support
• Extensive experience in ebTax and Sabrix/OneSource Indirect Tax system.
• Implemented Indirect Global Taxes (VAT, PCL, WEEE, GST, US Use/Sales Tax, Canada HST, PST, other taxes as applicable). Expert in Integration and migration projects. Migrated from Tax Ware (TWE) to Sabrix Integrating with Oracle R12.
• Extensive experience in ebTax setups, Expert knowledge of worldwide taxation.
• Configured Sabrix Trans Editors, US customer exemption certificates, Nexus setups, company setups, TCQ’s, product mapping, managing auto content. etc.
• Gathered complete Indirect tax requirements for all regions (US, APAC and EMEA). Prepared VAT matrix, tax flows, GST, US Tax.
• Well versed with both use and sales Indirect tax.
• Implemented Indirect tax and integrated Sabrix to Oracle P2P and O2C systems.
• PO Work flow customization for Drop Ship PO’s
• Integrated Sabrix One Direct tax integration system to Oracle as part of R12 Re implementation
• Implemented GST, VAT, Use Tax and Sales tax for APAC, EUROPE and US regions.
• Participated and documented tax business requirements from business across the world and implemented the solutions in Sabrix and Oracle system.
• Acted as techno/functional Indirect tax solution expert
• Implemented complex processes in Sabrix to achieve business requirements.
• Invented and implemented various work arounds in Sabrix system and in the integration API’s to meet tax requirements in EMEA and APAC.
• Provided function and technical solution of integration API’s between Sabrix and ERP.
• Implemented complex processes in Sabrix to achieve business requirements.
• Invented and implemented various work arounds in Sabrix system and in the integration API’s to meet tax requirements in EMEA and APAC.
• Ongoing production support of ERP financial and tax systems and developing day to day business requirements through customizations and enhancements.
• Working with business users in Month end and Quarter end closing activities by providing necessary data extracts and helping in reconciliation of data.
• Orchestrated end to end testing covering all functional teams. Starting from Order creation to Invoicing and accounting. Tax validations.
• Preparing test cases and getting them executed through QC, enabling requirements sign-off, design review, code review and user acceptance testing by following SDLC standards.
• Co-ordination with multi-shore teams
• Developed functional, regression test scripts using keyword, data driven and functional framework. Used scripting (Java, VB Scripting), Java and Phython language.
• Extensively used HP ALM tool for requirements, test plan, test lab, defects tracking.
• Developed custom reports and dashboards in HP ALM and publishing the reports to PMO and management.
• Solid experience in backend database testing. Generating reports, working with large data.
• Tested the Webservices using the SOAP UI tool.

Environment: Oracle Applications 11.5.10 & R12.1.3 (AR,GL, AP, AR, FA,OM, CDH, PO, Sabrix, eBtax), SQL, PL/SQL

Confidential, CA

ERP Financial Consultant

Responsibilities:

• Worked with Business users on Requirement gathering and prepared Solution Design and approach documentation
• Support Activities on Financial Applications.
• Multi org access control (MOAC) requirements gathering and setups
• Setting up of Revenue Recognition events.
• Supporting AR auto invoice program errors
• Setting up various custom account derivation rule and customizing the SLA to derive accounts as per business requirement
• Revenue Recognition
• Customization of Fixed assets account generator using Oracle Workflow.
• Customization of General Ledger Workflow to route Budget Journals through a custom hierarchy.
• GL AVG rates interface
• Cash Management: Technical design (Shell Script, Control file) and functional setups for uploading new bank statement
• Integration of Vertex third part tax system to ERP through E business tax module and testing of all the tax scenarios in AP and AR
• Raising SR’s for fixes
• Suggesting workarounds for various technical and functional issues in the team
• Understanding the gaps in Customer web page after r12 upgrade and working with business to gather requirements.
• Provided solution to import planned work orders from ASCP into production work orders in EBS instance. Developed a self-service webpage using Oracle Applications Framework to handle this process using Oralce applications Framework.
• Personalization and customization of Self Service web pages using OAF.
• Form personalization on Supply/Demand page to get the nee by date instead of promise date.
• Form personalization on Sales Order page to default the ware house for RMA’s based on different business rules.
• Design, plan and conduct Technical/functional testing
• Monitors on-going usage of ERP applications, identifying issues/opportunities for system improvement.
• Design, plan and conduct Technical/functional testing
• Co-ordination with offshore and on-site SMEs for quick resolution of issues
• Reviewed the design documents from offshore and coordinating the efforts
• Gathering the new requirements from business and documenting the approach

Confidential, NC

Sr. Business Analyst

Responsibilities:

• Strong experience in UAT testing.
• Extracted and analyzed the output XMLs from the EAS (Enterprise Audit Service)
• Provided automated solution, Test Plan for Operations and Functional Team Business Requirements and created test cases and scenarios.
• Performed Functional (Black Box) and Structural and internal logic (White Box) testing.
• Performed Load Testing by running scripts and Analyzed Performance using Load Runner.
• Tested a custom application called Pivot Table report which was developed using OAF.
• Tested all the critical business use cases for Order to Cash in Oracle 11i.
• Testing of data flow between OM, AR, AP, PO and GL modules.
• Tested several reports in OM, AP & AR modules like AP invoice hold report, AP invoice aging report.
• Performed backend testing to test the validity of the data in the reports using complex SQL and PL/SQL queries on the database.
• Involved with UI Navigation, functionalities testing and automating those scenarios using Quick Test.
• Taken Manual Scripts and converted them to automated scripts in QTP.
• Perform proofs-of-concept with QuickTest Professional and TestDirector to show Mercury solutions working in client environments
• Process implementation, Documentation, developing Project Management Plan, Test Plan, Configuration Management and Quality Management etc.
• Customer Interaction and progress reporting.
• Created detailed test status reports, performance capacity reports and graphical charts for Upper Management.
• Forecasting the risks and implementing mitigation plans/work around.

Environment: Oracle Apps 11.5.9, HP OpenView, Windows NT, Oracle 9i, SQL, PL/SQL, Forms 6i, Reports 6i, Bugzilla, TOAD, QTP 8.2, TestDirector., Quality Center, PL/SQL

Confidential, Palo Alto, CA

Sr Consultant

Responsibilities:

• Review and analysis of requirements, design and mockup documentation
• Participated in Project Kickoff, External meetings, and Internal meetings (Test case review and Status meetings), Design Review calls discussed Enhancement and Modification Request issues
• Involved in writing the test plans, test cases (Manual and Automation Scripts (50%)) and involved in the process of analyzing the expected and actual results.
• Created the Test cases using Business requirements documents, Functional requirements, Use cases and Mockups and tracking the bugs into bug tracking system, timely coordination with developers to close them
• Performed Sanity, Functional, Re-testing, Regression, Integration, System, UAT testing
• Developed QTP automation scripts using (VB scripts, TSL, Shell scripts), Checkpoints and Synchronization are extensively used within the estimated time to meet the overall customer UAT deadline for screening of policies.
• Performed regression, manual testing, ad-hoc testing, functional, integration, JUnit, performance using load runner and user acceptance testing (UAT) for web-based application on both client server and cluster environment.
• Performed extensive White box testing, Database testing using Toad and SQL, Written very complicated SQL Queries, Procedures and triggers to validate the data and Batch processing.
• Used Subversion (SVN) tool get the latest source code and documentation for deployment purpose.
• Tested inbound, outbound integration (Data Validation using SQL) using external sources (SAP, AS-400). Automated the batch process.
• Created several test scripts using QTP, which includes data-driven tests and batch tests.
• Performed load testing against internal applications and services using LoadRunner scripts to emulate users and monitor systems performance.
• Gathered the Test Input data. Test Input data includes Pre-condition, Test Input, and Test Result data.
• Extensively used Quality Center to Add Requirements, Write Test Cases, Execute the test cases, Defect logging and Defect Tracking.
• Interacted with Business Analysts and Developers for the Bug Fixes, Problem resolution and gathered the data for the test cases.
• Involved in Code Walkthrough, Static Verification, Symbolic Execution and Parsers.
• Tested the application on different Versions and browsers compatibility.
• Documented training material and business process and demonstrated to end users/business users/clients.
• Developed comprehensive Risk Analysis Reports, Defect Trend Analysis (DTA) and project trajectory tracking, presenting metrics graphically and in pivot tables
• Working with the offshore/onshore team of developers in prioritizing issues and Led multiple Projects with multi-site & multi-cultural teams, developing Test strategies, Metrics and Measurements

Environment: UNIX, Weblogic8.1, JBoss 5.0, NetWeaver, Java, J2EE, XML, Oracle 10g, TOAD, Quality Center, MS Office. Quick Test Professional 9.0, Load Runner, UNIX Shell Scripting, HP, JUnit, Win CVS, Subversion (SVN), Toad, Eclipse 3.2

Confidential

IT Consultant

Responsibilities:

• Involved in reviewing business requirement documents and the technical specification.
• Used black box testing for working throughout SDLC (software development life cycle) & test environment.
• Assisted the team lead in making the test plans.
• Analyzed system requirements and wrote test cases, test scripts for testing the application.
• Performed manual testing prior to automate testing on the application.
• Actively participated in the team involving test plan analysis, go/no-go decisions based on the QTP test scripts results.
• Involved in execution for testing of database using SQL queries (select, update, Joins, views statements) Interfaced with developers to resolve technical issues and investigated software for faults.
• Reported software mismatches (from the test planning), to the development team using Test Director.
• Automated test cases for GUI, Functionality, Security and Regression testing using QTP.
• Performed regression testing for fixes using QTP and closed the defects in Test Manager.
• Involved in the end-to-end test using QTP and responsible for the Quality-Assurance of this application to complete in record time.
• Responsible for building the environment of hardware and software for System Testing and Parallel Testing on both the client side and the server side.
• Developed Load Runner test scripts to evaluate Corporate Information Security Web based user authentication applications.
• Generate, analyze, and publish Load Runner test results and document the testing process.
• Performed software support as necessary in both production and testing environments on client and server side.
• Resolved defects in testing for software issues with client applications. Reviewed computer logs (UNIX logs & Shell Scripts), reported program-processing errors.

Environment: Windows NT, UNIX, Java, J2EE, SQL Server, Oracle, Quick Test Professional (QTP), LoadRunner and Test Director7.2, MS Office.