Management Project

Moumita Majumder

Oracle Apps Functional Consultant/Business Analyst

Email: ********.********@*****.***

Ph: +1-862-***-****

EXPERIENCE SUMMARY

Around 5 years of experience in the IT industry in Requirement Gathering and Analysis, Solution Architecture, Gap Analysis and Gap Bridging, Testing and Implementation of full life cycle using Oracle E-Business Suite release 12

Worked in Tata Consultancy Services till May 2015 as System Engineer with a role of Functional Consultant/Business Analyst

Excellent knowledge and experience of the complete Procure to Pay (P2P) and Order to Cash (O2C) process.

Sound functional knowledge in Oracle Apps Module – Purchasing (procurement), Inventory, Order Management Account Payables, Approval Management Engine

Has also worked in other modules like Cash Management, i-Procurement

Excellent knowledge of Oracle Base Tables

Worked on solution design and setup of Inventory, Purchasing & Order Management as per the client requirements and suggested business process changes

Extensive experience in designing custom solution and implementing Oracle Purchasing Quotation, Purchase Order and Invoice Approval process

Proficient in providing end-to-end delivery from requirement analysis to system study, Application Testing, documentation and implementation.

Extensive experience in Manual testing using Black Box testing techniques.

Extensive experience in developing test plans, test cases and procedures as well as execution of manual and automated tests using Black Box Testing techniques.

Data Migration specialist

Interacted with Oracle support team and technical support team to resolve application issues, bugs and TAR/SR management

Good experience with onsite-offshore model of project execution with extensive experience at both client site and offshore.

Highly motivated professional with excellent communication, analytical, interpersonal and client facing skills. Flexible, adaptable, proactive and can handle things independently.

Team player: Willing to provide guidance and help to other team members. Quick learner.

Believe in Learning and sharing knowledge.

Ability to grasp new tools and technologies.

EDUCATION

Netaji Subhash Engineering College (NSEC) Kolkata, India

Bachelor of Technology, Information Technology

Secured a high CGPA of 8.51/10.00

SKILLSET

Conducting requirement analysis for understanding client business processes & mapping them to required standards.

Suggesting appropriate as well as technology-based solutions for enhancing functional efficiency of the organization and achieving business excellence.

Managing the setups of various oracle apps modules

Cross-module integration – Purchasing, Inventory and Payables

Hands on knowledge on SQL and PLSQL

Interacting and building relationship with clients. Engaging with clients for addressing challenging issues.

Executing projects, collaborating with project teams, interfacing with clients and deploying technology to build successful solutions for clients.

Hands on experience in developing test plans, test cases and procedures as well as execution of manual and automated tests.

Expertise with Bug Tracking (using Quality Center).

Sound knowledge of test management tool HP Quality Center & HP Application Lifecycle Management

Ensuring smooth implementation and testing

Providing post-implementation, application maintenance and enhancement support to the client with regard to the product

Other Tools: HP ALM (Quality Center), SQL, PL/SQL, Data Loader, Toad, SQL loader, MS Office, WinSCP and Textpad.

Career Recital

Projects:

Wyndham Exchange and Rentals, Parsippany NJ Jul 2015 – Current

Role –Oracle EBS Business Analyst

Project Description – Client remains the leader in vacation exchange, offering the world’s largest vacation exchange network and providing unrivaled products and services to enhance the vacation ownership experience overview. This project was to implement purchase and inventory modules and provide warranty support to end users

Responsibilities

oInteracted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data.

oResponsible for Solution design and Implementation.

oSetting up the eBS structure for various Oracle modules. Setup of Purchase (Procurement) and Inventory Module

oDesigned and developed all the setups and configurations for Inventory management and procurement flow

oResponsible for the documentation of Requirement gathering, To be process, Functional Design documents, Test scripts, setup document (BR100) and User manuals.

oFunctional and Regression testing of all the custom components developed to bridge the Gaps

oConducted and coordinated CRPs, UAT - unit testing, integrated testing

oConducted User Trainings

oLiaison between IT and internal business customers

oParticipated in planning of major and minor production releases

oMaintained track issue gaps and following it till closure

oPlayed key role in project Implementation

oProvided post production support for all issues – standard, custom, and some legacy system issues.

Environment – Oracle R12 (Account Payables, Purchasing, Inventory, i-procurement), SQL Developer, Toad, Data Loader, HP ALM

TATA CONSULTANCY SERVICES Ltd. - Kolkata, India

Oman Insurance Company, Dubai/Kolkata Sep 2014 – May 2015

Role – Oracle EBS Functional Consultant (Team Member)

Project Description – Client was one of the largest insurance solutions providers in the Middle East. This project was to implement oracle e-business r12 financial suite for their financial activities across UAE, Oman and Qatar. Key highlights of the project were the integration between the eBS system and the front end (TCS-BaNCS) system for Master data management and transactions integration. The project also had solution design for the Banca insurance process and outward and inward integration with banks.

Responsibilities

oInteracted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data.

oResponsible for Solution design and Implementation.

oSetting up the eBS structure for various Oracle modules

oWorked towards the proof of concept and involved in defining the organization structure.

oResponsible for the documentation of Requirement gathering, To be process, Functional Design documents, Test scripts, setup document (BR100) and User manuals.

oDesigned functional documents for various Gaps and interfaces

oOwner of the entire Data Migration Activity

oProvide Test Estimation to the Client and get approval after providing a run down on the same.

oCreation of Test Strategy document and Test plan document

oFunctional and Regression testing of all the custom components developed to bridge the Gaps

oPlanned and conducted CRP’s

oPlayed key role in Unit testing, UAT

oConducted User Trainings

oMaintained track issue gaps and following it till closure

oPlayed key role in project Implementation

oOwner of defect Management team using HP ALM. All defects opened, fixed, closed were assigned to me for resolution

oParticipated in planning of major and minor production releases

oGo-Live Warranty Support

oFunctional Business Support, and resolving day-to-day critical issues.

Environment – Oracle R12(Account Payables, Cash Management and Subledger Accounting), SQL Developer, Toad, Data Loader, HP ALM

Ferring Pharmaceuticals, Switzerland/US/Kolkata Dec 2013 – Sep 2014

Role – Functional Consultant (Team Member)

Project Description – Ferring Pharmaceuticals is a research-driven, biopharmaceutical company devoted to identifying, developing and marketing innovative products in the fields of reproductive health, urology, gastroenterology, endocrinology and orthopaedics.. This was an implementation, upgrade and support project.

Responsibilities

oInteracted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data

oWorked with Oracle on SR management on high priority issues parallel

oPerformed setup activity for Procure to Pay Transactions and approval process

oWorked with end-users to help them use the system better

oExtensively used Quality Center for logging/tracking defects

oDoing impact analysis of any changes in the application as a result of defect fixes and identifying additional testing if required.

oWrote SQL queries to fetch data from Oracle Base and Interface Table to generate reports

oMaintained Change Design Document

oProvided Root cause analysis for issues and permanent fix

oAnalyzing existing setup and extending the same to the New-operating unit.

oParticipated in setting up modules for a new operating unit to be opened in US

oPrepared Training documents and presentations to assist Business users on newly released functionality in Oracle E-business suite.

Environment – Oracle R12(Account Payables, Cash Management, Order Management, Inventory and Purchasing), SQL Developer, Toad, Data Loader

Eveready Industries India Ltd., Kolkata Sep 2013 – Dec 2013

Role – Oracle EBS Solution Architect

Project Description – Client was the largest battery manufacturer in India and a market leader in its segment. Not just among batteries, it is a powerful brand across categories. This project was to design and implement a custom bolt-on design to facilitate the quotation approval system

Responsibilities

oAnalyzed business requirements and came up with the data flows, solutions

oCreated detailed design documents for the business interface

oDesigned the business processes to depict the data flow and exceptional flow

oDeveloped business processes by configuring business events

oSetting up the eBS structure for purchase and inventory modules

oSetup up the custom approval process for Quotation Analysis to make the procurement process robust

oConducted functional testing. Tested the entire custom bolt on solution solely

oExecuted Test plans using HP ALM

oDesign high level scenarios and derive test scripts

oImplemented the solution and organized user trainings

oProvided end users with proper user manuals

Environment – Oracle R12 (Purchase and Inventory), SQL Developer, Toad, Data Loader, Oracle Forms

Cement Manufacturing Company Ltd., Kolkata Feb 2012 – Aug 2013

Role – Oracle EBS Functional Consultant (Team Member)

Project Description – Client was one of the largest cement manufacturers in North Eastern India. One of the client’s brands of cement is one of the largest in the Northeastern region and among the fastest growing. This project involved in implementing oracle to map their everyday operations, financial reporting and tax compliance. The project also included a custom solution design of mine costing process and weighbridge process.

Responsibilities

oWorked on solution design and setup of Inventory, Purchasing & Order Management as per the client requirements and suggested business process changes

oCreated detailed design documents for the business interface

oWrote SQL queries to fetch data from Oracle Base and Interface Table to generate reports

oWas actively involved in day to day client interaction for requirement gathering and solution acceptance.

oEstablished Purchase Requisition process and Approval hierarchy to manage business flow

oActed as the coordinator of the technical team and was responsible for the periodic reporting of project status to higher management

oInvolved in all data migration strategy planning and activities

oFunctional and Regression testing of all the custom components developed to bridge the Gaps

oPlanned and conducted CRP’s and testing sessions

Environment – Oracle R12(Purchase, i-Procurement, Inventory, Order Management, Accounts Payable, Inter-organization transfers and IL taxes),SQL Developer, Toad, Data Loader, Oracle Forms

Tamil Nadu Newsprint and Papers Ltd., Tamil Nadu/Kolkata Nov 2011 – Feb 2012

Role – Oracle EBS Functional Consultant(Team Member)

Project Description - Client was an acknowledged leader in the technology of manufacture of paper from bagasse – the sugar cane residue. Purpose of the project was to implement Oracle eBS for their finance, P2P and O2C activities.

Responsibilities

oFacilitated User Acceptance Testing to business users

oInterpreted and documented test case results

oConducted CRP’s

oDesigned User Manuals

oCreation of Test Strategy document and Test plan document

oDoing impact analysis of any changes in the application as a result of defect fixes and identifying additional testing if required.

oInvolved in designing Test scenarios and Test Cases based on Functional Requirement Specification document.

oHands on experience in HP Quality Center

Environment – Oracle R11i/12(Purchase, Inventory, Order Management and Accounts Payable), SQL Developer, Toad, HP QC

ACHIEVEMENTS

Have earned appreciation certificates as a recognition of exceptional work done towards client engagements at Tata Consultancy Services

Was the Soft Skill Personality and Development head of PHOENIX (Official Tech Club of N.S.E.C for the year 2008-2009)

Creative head of PHOENIX (Official Tech Club of N.S.E.C for the year 2009-2010)

Certificate in Network Management from NETTECH

Was provided a certificate for Social Service from HELPAGE INDIA

Contact this candidate