Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
Celi Walia
Celi@yahoo.com
PROFESSIONAL OVERVIEW
Celi Walia has over 10 years of experience including live Implementation, Post-implementation Support, Data Conversion, Quality Control, Training ERP and Project Management. He has been involved in all stages of project development including requirement analysis, design, code development, testing and performance evaluation and tuning, documentation, implementation, and training of end users. He is closely involved in implementation of Oracle Application, third party software (SQL Sever, Tibco, Concur, Hewitt and SAP) integration with Oracle application and has excellent knowledge in Oracle financial applications, Rel R12, 11i, 11.0.3, 10.7 .
Celi Walia brings complete package of skill set to the table when working on a project including his broad Functional experience in PO, AR, AP, GL, AP,FA, PA,OM and INV. (Procure to Pay) in MultiOrg environment Of Oracle Application.
Walia has worked on several Oracle Implementation projects on Functional, Technical and QA roles. His work on consulting assignments has exposed me to a variety of Industries including Banking, Government secured projects, Manufacturing, Logistic, Utility, Energy and Supply Chain Consumer products.
He is proficient at project delivery using AIM Methodology, designing, developing, implementing and training. This has provided him with valuable experience of how to succeed under challenging and demanding conditions. His outstanding Team lead, Excellent Communication, organizational skills, work ethic and drive make me a valuable addition to any team.
MANAGEMENT SKILLS
Change Management§
Data Conversion§
System Design§
Project Estimation§
Project Management§
Addition of Self Service Modules to existing Apps installations.§
Quality management§
Regression Testing Efforts§
Cutover Deployment§
FUNCTIONAL SKILLS
Oracle Payables§
Oracle Assets§
Oracle General Ledger§
Oracle Workflow§
System Administration§
Oracle Application Object Library§
Oracle Alert§
Oracle Receivable§
Project Accounting§
ADI/GLDI/FADI§
Internet Expenses/OIE§
Internet Procurement§
Data Loader§
XML Publisher/BI Publisher§
iSupplier§
Sourcing§
Procurement Contracts§
TECHNICAL SKILLS
Oracle Application Object Library§
Oracle General Ledger§
Oracle Alert§
Oracle Assets/iAssets§
Oracle Purchasing§
Oracle Payables§
Oracle Receivables§
Oracle Reports§
Oracle Forms§
SQL/SQL*Plus§
PL/SQL§
Celi@yahoo.com
PROFESSIONAL OVERVIEW
Celi Walia has over 10 years of experience including live Implementation, Post-implementation Support, Data Conversion, Quality Control, Training ERP and Project Management. He has been involved in all stages of project development including requirement analysis, design, code development, testing and performance evaluation and tuning, documentation, implementation, and training of end users. He is closely involved in implementation of Oracle Application, third party software (SQL Sever, Tibco, Concur, Hewitt and SAP) integration with Oracle application and has excellent knowledge in Oracle financial applications, Rel R12, 11i, 11.0.3, 10.7 .
Celi Walia brings complete package of skill set to the table when working on a project including his broad Functional experience in PO, AR, AP, GL, AP,FA, PA,OM and INV. (Procure to Pay) in MultiOrg environment Of Oracle Application.
Walia has worked on several Oracle Implementation projects on Functional, Technical and QA roles. His work on consulting assignments has exposed me to a variety of Industries including Banking, Government secured projects, Manufacturing, Logistic, Utility, Energy and Supply Chain Consumer products.
He is proficient at project delivery using AIM Methodology, designing, developing, implementing and training. This has provided him with valuable experience of how to succeed under challenging and demanding conditions. His outstanding Team lead, Excellent Communication, organizational skills, work ethic and drive make me a valuable addition to any team.
MANAGEMENT SKILLS
Change Management§
Data Conversion§
System Design§
Project Estimation§
Project Management§
Addition of Self Service Modules to existing Apps installations.§
Quality management§
Regression Testing Efforts§
Cutover Deployment§
FUNCTIONAL SKILLS
Oracle Payables§
Oracle Assets§
Oracle General Ledger§
Oracle Workflow§
System Administration§
Oracle Application Object Library§
Oracle Alert§
Oracle Receivable§
Project Accounting§
ADI/GLDI/FADI§
Internet Expenses/OIE§
Internet Procurement§
Data Loader§
XML Publisher/BI Publisher§
iSupplier§
Sourcing§
Procurement Contracts§
TECHNICAL SKILLS
Oracle Application Object Library§
Oracle General Ledger§
Oracle Alert§
Oracle Assets/iAssets§
Oracle Purchasing§
Oracle Payables§
Oracle Receivables§
Oracle Reports§
Oracle Forms§
SQL/SQL*Plus§
PL/SQL§
L§
Personalization§
Fortran§
Java§
Basic Unix Scripting§
Internet Expenses§
Oracle discoverer§
Workflow Builder§
Quality center§
QTP§
UPK§
EDUCATION
University of Birmingham Birmingham , England MS Computer Sc. 2000
University of Pune Pune, India BS Electronics 1994
PROJECT HIGHLIGHTS
R12 Upgrade May 2011-Current
Coach America
Dallas , Texas
Lead Functional Consultant
This is an upgrade project from Oracle R11i to R12. Assisted client in :
Configuring payables, Suppliers and Payment module
Data cleaning in legacy systems
Creating process flow documents BP090 for AP, Suppliers, Payments, GL and FA.
Creating Setup documents BR100 and MD50
Creating Test plan, test scripts and training manuals. Trained end users with new functionality.
Post production support.
iProcurement Portal Implementation-R12 i Dec. 2010-May 2011
AtmosEnergy
Dallas , Texas
Lead Functional Consultant
Implementing iProc for Inventory/Non Inventory purchases for Atmos procurement division. Some of the duties include working with business to compile requirements. Documented functional and technical design documents, Set up purchasing and iProcurement configuration in Oracle EBS. Create testing , training documentation and train the end users. Key functionality include:
Design shopping catalogs and load into iProc
Setup Punchout and data mapping
XML PO relay to trading partners
Data Loading
Customize PO PDF Template
Automation Req. to po process
Auto Sourcing Req. to Pos
Workflow customizations
Designed Test plan and test scripts for CRP,QA and UAT testing cycles.
Create Training manuals
Create MD50 and BR100 Documents
R12.1 iSupplier Portal & Procurement Contracts Implementation Sept. 2010-Dec 2010
Dresser - Rand
Houston, Texas
Lead Functional Consultant
Configuring iSupplier portal, Key Functionality includes PO relay, PO acknowledgment, PO Changes, Supplier Profile, PO communication, Receipts, Invoice and payments
Configure procurement Contracts which includes setting Clause, variables, document layout template, descriptive flexfield , Approvers and personalization
Designed Process flow documents and training manuals
R11i iSupplier Portal & Sourcing Implementation June 2010- Sept. 2010
General Dynamics
Burlington. Vermont
Lead Functional Consultant .
Implemented iSupplier portal and Sourcing modules with minimum customization for General Dynamics
ATP operations.
Worked with business for requirements and functional design documents.
Configured iSupplier Portal setups.
Led Analyzing, Design and Build phase.
Conducted successful CRP with the business users.
Customized iSupplier portal using Self service Personalization.
Created Test plan, Unit Test, UAT test cases and guided users during integrated test cycle.
Created Supplier training manual and end user training.
Assisted DBAs on DMZ configuration.
Created Supplier on boarding process.
Created Functional Design MD50, Unit Test TE20, Cutover task list and BR100 setup documents.
Key Functionality includes PO relay, PO acknowledgment, PO Changes, ASN, Supplier Profile, PO communication, Receipts, Invoice and payments.
Setup Sourcing negotiation (RFI,RFQ,Auctions) configurations, Templates, notifications, Output Stylesheets.
R11i iProcurement & iExpense Implementation Mar 2010- June 2010
NCH Corporation
Irving TX
Lead Functional Consultant
Implemented iProc for Non Inventory purchases for their European procurement center in UK. Gathered business requirements. Documented processes, Set up purchasing and iProcurement to meet business requirements. Create training documentation. Train end users. Upload vendor catalogs into iProcurement. Automation of Requisition to PO creation process.
Setup iExpense for UK division, conducted CRP and UAT test cycles with the business users and developed Training material.
R12 Assessment/Upgrade-EB Tax Nov 2009 Mar 2010
DRS Technologies
Gaithersburg MD
Lead Functional Consultant
Gathered business requirements through individual interviews with department heads and compiled current state. Future state and gap analysis. Map these requirements into Oracle Applications. Created test scripts, conducting Conference Room Pilots and UAT. Worked with end-users and management to resolve issues and bridge business process gaps. Conducted end-user training.
Worked with business to develop as is process for Financial and Purchasing module and future R12 process.
Evaluation of the New Release and planning the upgrade. Designed Blue print for SLA and EBtax functionality.
Prototype new business processes.
Conducted CRP with Business users
Design legacy date conversion, configure application and create test scripts
Partner with Oracle support team, business team and other vendor parties to identify and remedy key issues introduced by upgrade
Develop test scripts and perform all system testing and UAT testing cycles.
Provide user guide, process flow and Training documents.
Conducted end user training classes.
R12 Upgrade NOV 2009 Jan 2010
TRIZETTO Group
Denver
Lead Oracle Functional Lead
This was an upgrade project my role was to assist in improving process in the procure to pay cycle. Created process design documents, Gap Analysis, Test design and training manuals for Payable, Purchasing, iProcurement, iSupplier and Sourcing modules.
R11i iSupplier Portal and Inv. Implementation June 2009 NOV 2009
Atrium Group of Companies
Dallas TX
Principal Oracle Functional Consultant
Implemented iSupplier Portal and Configured Inventory module
Worked with business and supplier community to create requirements and functional design documents.
Involved in Analyzing, Design and Build phase.
Conducted successful CRP with the business users.
Major activities include setting up Inventory Organization, Subinventory, Item locators
Customized iSupplier portal using Self service Personalization, Customized PO approval and Supplier Registration Workflows and external server DMZ configuration.
Created Unit Test and UAT test cases and guided users in UAT.
Created Supplier training using UPK recording
Created Supplier on boarding process.
Created Functional Design MD50, Technical Design MD70, Unit Test TE20 and Setups BR100 documents.
Created installation scripts to move customization to Production and Instance readiness check and cutover task.
INVENTORY
Major activities include setting up Inventory Organization, Subinventory, Item locators,
Set-up of modules with user data, Coding of custom programs to load item data into interfaces, migration of Item categories, migration of On hand inventory quantity, Coding of custom programs to load cost of items, Migration of Locator and Sub-inventory, Coding of custom programs to load catalogs into Oracle Application and Preparation of Detail Design (MD050, MD070 using AIM2.0).
PepsiCo May 2005 May 2009
Plano TX
Senior Oracle ERP Consultant- R11i and R12
Oracle Financial migration and integration with SAP ONE UP Project for PepsiCo Group of Companies
Release1 This was an integration project of Oracle financials (Multi Org and Multi-instances) with SAP (ERP). The functional synopsis of this project is to purchase all OG&S items (Indirect Procurement) in SAP for PepsiCo Group companies and pay from Oracle Accounts Payables. This requires inbound and outbound interfaces (Invoices, Payments,iExpenses, Vendors, Budgets, Projects, GL accounts , Accruals, Commitments, Items and Categories and Re-conciliation). Conversions of initial data (Vendors, UOM, Locations, Pos List of values, Accounting Code Combination, PO and Invoice Accrual and materials group), mapping of functional requirement. My role is to interact with the Operations business team interpret requirement and recommend solution, design functional compatibility of Oracle application to SAP, Design FMD, reviewing of MD050 documents.
Release 3 and 5 Conversion of all the data from Oracle Tropicana and Pepsi Instances( GL,AP,PO,PA, Concur, CCDS and Vertex) to SAP and interface new GL feeds and reconciliation reports from Oracle GL to SAP. Validation of recon reports from data warehousing for Oracle and SAP data. Retirement and sun setting of Oracle instances and data Archiving for Tax and Audit purposes. My role is to design functional compatibility of Oracle application to SAP, SME for Oracle, Functional Oracle presentation and training to the Achieving solution team reviewing of MD050 documents, creating and maintaining BR100 documents.
R12 Assessment and Upgrade: Conducted interviews with business to document current as is process for Procure to Pay cycle. Contributed to the blue print for the R12 re-implement project for Fritolay division.
QA Responsibilities:
Designed Master test Strategy, test plans and test cases for each release and reviewed with the developers and end users and managed test entry, success and exit criteria.
Executed test scripts in Quality Center test lab as part of System Test and UAT test cycles.
Organized and managed the testing process by appropriately dividing test cases among the testing resources, ensured that the testing effort was delivered on schedule, reporting on metrics related to the status of the daily testing effort.
Developed and managed a repository of test data to support testing efforts for regression testing and testing Technology Stack upgrade.
Coordinate the development of documentation, such as Test summary documents, Test Plan, Defect management review, Project Deliverables Matrix, Business user approval document as per SOX Compliance.
Participated in the complete software development life cycle including analysis, design, and operational rollout of developed features
SME for Oracle and training Business users on the new functionality and test execution cycles during UAT.
Monitored test environment build and availability during different test cycles and phases. Maintained application Set ups in the test instances as per the BR100 document.
As a lead, chair test Coordinator meeting, risk management and Defect Management reviews for Oracle apps and report to higher management
R11i 7-Eleven Corporation July 2004 May 2005
Dallas
Sr Oracle Apps Consultant
Worked as a Functional/QA consultant for the iSupplier, Sourcing, iProcurement and iExpenses implementation.
Business Area include Sourcing, Negotions(RFQ &Auctions) Requisition, Catalog management, iSupplier portal, UOM, AP workflow approval, AP, GL, Projects and APC(Advanced product catalog).
iSupplierWeb page configuration(Home page, Order page, Shipment and planning page)
Application configuration for Purchasing and Payables.
End User procedures- Register suppliers, enter advance shipment notice, create Invoices and Order Acknowledgment. Workflow configuration for Supplier registration, PO approval, Advance shipment Notice.
Involved in Set up configurations in full business cycle. Full understanding of Functional and business cycle from sourcing, requisition, PO creation, Payables, Alerts. PO approval rules, projects mapping and HR employee mapping. Invoices approval workflow and AME Rules.
Responsibilities include writing Requirement, Functional Design, Gap Analysis, writing test design, test cases using Test Director, writing Auto test scripts using Win runner.
Close liaising with Business analyst, development team and Users group. Involved in Integration testing, Regression, defect management reviews and User acceptance testing. Conducted and chaired meetings with different business units, from collecting requirements, design and development stage using AIM methodology
Business user group training.
Involved in Sun setting database to improve storage space and performance for test instances.
R11i Alpha Natural Resources Virginia Feb 2004 - July 2004
Sr Oracle Apps Consultant- Financial
Worked as a consultant for a coal mining company in Virginia. Modules FA,AP,AR,GL,OM and INV. Tools ADI, Discoverer. Muti ORG environment.
Implemented UOP(Unit of production) depreciation rule in FA. Carried on all configuration and Setup rules.
Created new assets using ADI. Full understanding of all the functionality in loading assets through standard interface table and rules in adding assets to Corp and Tax books. Good understanding of Mass addition, retiring assets, depreciation rules and data flow.
Written FSG and Standard reports using Oracle reports 6i.
Implemented an interface in AR, loading AR invoice from legacy system ( SQL Server). Using AR standard interface using Autoinvoice. Performed configuration setup for AR interface.
Involved in design, gathering requirement closely working with business analyst. Carried on all AR setup and written scripts to load data from SQL server to Oracle. On a Linux platform.
Worked on Discover 6i user and administration group.
Setups for item codification and categorization
ATC Logistics Dallas Oct 2003 - Jan 2004
Sr. Oracle 11i Consultant
Worked as Functional/Technical consultant for AFTERMARKET TECHNOLOGY CORPORATION at Dallas Fort Worth.
Involved with the upgrade from oracle 11.03 to Oracle 11i 5.8.
Data conversion from the legacy system to 11i.
Written Interface to import GL Transaction and net activities in GL balances.
Written interface in AP to import open invoices and mapping with purchase orders.
Also wrote extensive code to import Historical paid invoices into AP. SQL/PLSQL KORN SCRIPT, SQL LOADER.
Multiple org environments.
Written technical and functional specs in consultation with the business analyst.
Tax and Corp Book Conversion in Fixed assets from legacy system.
Customized standard forms and new reports in Order Management.
Major Accomplishments:
Worked under strict deadline constraints. In a short time worked long hours to migrate all the data from the legacy to the current 11i system.
Can work on upgrades for AP, AR, GL, FA.
Understood the business requirement strong technical and functional knowledge.
Cap Gemini UK
Dec 00 to Oct 2003
Oracle Apps Consultant
Worked as a Baseline support analyst at British Defense Housing Executive
Involved with development of a complex classified secured Oracle financial 11.5.7 application for Ministry of Defense Housing main modules AP, AR,GL, FA,PO
Confident with design and working with Workflow 2.6,Discoverer, Toad
Participated in the full life cycle of implementation from requirements gathering, design, development, QA testing, (including documentation) and application support.
Developing functional specifications for new user requirements and change requests, writing PL/SQL scripts, Korn scripting, SQL*Loader and custom development of forms and reports 6i on Oracle DBMS 8.1.7.1, extensively used AOL (Application Object Library). TKProf, Explain Plan, SQLLab.
Good knowledge of the Oracle 11i data model, full knowledge of navigations through applications and data flows.
Detailed knowledge on the integration of all the Financial modules. Responsible for system administration task, Create user profile, attaching to responsibility, registering forms, reports, concurrent manager setup. Resolve Printing issues.
Application setup GL,AP,AR,PO,FA and configuration in Oracle 11i environment application architecture in AIX Unix context.
Extensive customization of standard Forms and Reports, FSG reports, also good knowledge of writing Interface scripts to extract and import data from the financial module to third party system including troubleshooting problems, maintaining, and upgrading the applications.
Built an application to extract data into interface, using various J2EE technologies including HTML, JSPs, Servlets, Java Beans. Main products used are JBuilder 5 Enterprise Edition, Weblogic 5.1/6.0/6.1
Experience in opening, managing, and resolving Oracle TARs with Oracle Support
Major Accomplishments:
Worked on live project, work under continual deadline constraints have the ability to conceptually relate technology to a business' needs on a global scale demonstrate ability to establish, manage, and strengthen customer relationships.
Have strong problem solving, quantitative, and analytical abilities, the ability to maintain a high-level of discretion and confidentiality.
Have Excellent written and verbal communication given the highly interactive nature of the job, ability to work independently.
Bull Info System/Steria, UK Sept 99 to Dec 00
Oracle Apps Developer
Designed and Developed Interfaces to upload data into AP and GL Financial module using Korn shell scripting data conversion from 10.7 to 11i.
Involved in requirements gathering, design from scratch, development, testing and documentation.
Also worked on desktop integrator to import data into the oracle financial module.
Customized new forms and reports to enable end users to extract data and data validations.
Worked on functional side of the financial suite, setting up set of books, account structure and application setup. Responsible for all application administrator tasks.
Major Accomplishment:
Worked independently to strict deadlines. Improved my functional understanding of the Oracle financial suite.
Northern Rock Investment Bank Plc -UK
Test Engineer
Involved in implementing testing specs and test plans to match user business requirements.
Worked alone and with team members on integrating functional and regression testing, creating, executing, maintaining test plans, and working with the development team to achieve a stable software solutions, test lead experience and strong development methodologies, ability to write reports and document testing procedures, ability to effectively communicate with managers, test team, and customers, ability to solve practical problems, and to interpret a variety of instructions.
Fluent in writing SQL scripts and worked intensively on Unix Aix Platform.
Resolved issues with session management and security.
Involved in the full Life cycle of the project QA's role at each phase along the way, from requirements through system release.
Major Accomplishments:
Provided a test automation solution to speed up test integration.
Promoted to a Team lead with in two months of joining the company.
Worked with client and helped in resolving lot of the day-to-day software quality issues.
Do power point presentation to client and explain the system that was being integrated at the customer sites.
Trained junior engineers.
K.K.Nag Ltd., Pune, India Aug 95 to Sep 98
Software Engineer.
Oracle Application Developer
Responsible as a System Design analyst for Front-end application development.
Worked on client server application with Developer 2000,Oracle7 on Windows based system.
Developing complex forms and reports also wrote pl/sql scripts, triggers and was involved in migration of data.
Converting business requirement to Functional specification design, implement and support application and systems integration.
Major Accomplishments:
This experience gave me an excellent start in commercial software development, improved my team working and time management skills and gave me an insight into large-scale software development projects.
Personalization§
Fortran§
Java§
Basic Unix Scripting§
Internet Expenses§
Oracle discoverer§
Workflow Builder§
Quality center§
QTP§
UPK§
EDUCATION
University of Birmingham Birmingham , England MS Computer Sc. 2000
University of Pune Pune, India BS Electronics 1994
PROJECT HIGHLIGHTS
R12 Upgrade May 2011-Current
Coach America
Dallas , Texas
Lead Functional Consultant
This is an upgrade project from Oracle R11i to R12. Assisted client in :
Configuring payables, Suppliers and Payment module
Data cleaning in legacy systems
Creating process flow documents BP090 for AP, Suppliers, Payments, GL and FA.
Creating Setup documents BR100 and MD50
Creating Test plan, test scripts and training manuals. Trained end users with new functionality.
Post production support.
iProcurement Portal Implementation-R12 i Dec. 2010-May 2011
AtmosEnergy
Dallas , Texas
Lead Functional Consultant
Implementing iProc for Inventory/Non Inventory purchases for Atmos procurement division. Some of the duties include working with business to compile requirements. Documented functional and technical design documents, Set up purchasing and iProcurement configuration in Oracle EBS. Create testing , training documentation and train the end users. Key functionality include:
Design shopping catalogs and load into iProc
Setup Punchout and data mapping
XML PO relay to trading partners
Data Loading
Customize PO PDF Template
Automation Req. to po process
Auto Sourcing Req. to Pos
Workflow customizations
Designed Test plan and test scripts for CRP,QA and UAT testing cycles.
Create Training manuals
Create MD50 and BR100 Documents
R12.1 iSupplier Portal & Procurement Contracts Implementation Sept. 2010-Dec 2010
Dresser - Rand
Houston, Texas
Lead Functional Consultant
Configuring iSupplier portal, Key Functionality includes PO relay, PO acknowledgment, PO Changes, Supplier Profile, PO communication, Receipts, Invoice and payments
Configure procurement Contracts which includes setting Clause, variables, document layout template, descriptive flexfield , Approvers and personalization
Designed Process flow documents and training manuals
R11i iSupplier Portal & Sourcing Implementation June 2010- Sept. 2010
General Dynamics
Burlington. Vermont
Lead Functional Consultant .
Implemented iSupplier portal and Sourcing modules with minimum customization for General Dynamics
ATP operations.
Worked with business for requirements and functional design documents.
Configured iSupplier Portal setups.
Led Analyzing, Design and Build phase.
Conducted successful CRP with the business users.
Customized iSupplier portal using Self service Personalization.
Created Test plan, Unit Test, UAT test cases and guided users during integrated test cycle.
Created Supplier training manual and end user training.
Assisted DBAs on DMZ configuration.
Created Supplier on boarding process.
Created Functional Design MD50, Unit Test TE20, Cutover task list and BR100 setup documents.
Key Functionality includes PO relay, PO acknowledgment, PO Changes, ASN, Supplier Profile, PO communication, Receipts, Invoice and payments.
Setup Sourcing negotiation (RFI,RFQ,Auctions) configurations, Templates, notifications, Output Stylesheets.
R11i iProcurement & iExpense Implementation Mar 2010- June 2010
NCH Corporation
Irving TX
Lead Functional Consultant
Implemented iProc for Non Inventory purchases for their European procurement center in UK. Gathered business requirements. Documented processes, Set up purchasing and iProcurement to meet business requirements. Create training documentation. Train end users. Upload vendor catalogs into iProcurement. Automation of Requisition to PO creation process.
Setup iExpense for UK division, conducted CRP and UAT test cycles with the business users and developed Training material.
R12 Assessment/Upgrade-EB Tax Nov 2009 Mar 2010
DRS Technologies
Gaithersburg MD
Lead Functional Consultant
Gathered business requirements through individual interviews with department heads and compiled current state. Future state and gap analysis. Map these requirements into Oracle Applications. Created test scripts, conducting Conference Room Pilots and UAT. Worked with end-users and management to resolve issues and bridge business process gaps. Conducted end-user training.
Worked with business to develop as is process for Financial and Purchasing module and future R12 process.
Evaluation of the New Release and planning the upgrade. Designed Blue print for SLA and EBtax functionality.
Prototype new business processes.
Conducted CRP with Business users
Design legacy date conversion, configure application and create test scripts
Partner with Oracle support team, business team and other vendor parties to identify and remedy key issues introduced by upgrade
Develop test scripts and perform all system testing and UAT testing cycles.
Provide user guide, process flow and Training documents.
Conducted end user training classes.
R12 Upgrade NOV 2009 Jan 2010
TRIZETTO Group
Denver
Lead Oracle Functional Lead
This was an upgrade project my role was to assist in improving process in the procure to pay cycle. Created process design documents, Gap Analysis, Test design and training manuals for Payable, Purchasing, iProcurement, iSupplier and Sourcing modules.
R11i iSupplier Portal and Inv. Implementation June 2009 NOV 2009
Atrium Group of Companies
Dallas TX
Principal Oracle Functional Consultant
Implemented iSupplier Portal and Configured Inventory module
Worked with business and supplier community to create requirements and functional design documents.
Involved in Analyzing, Design and Build phase.
Conducted successful CRP with the business users.
Major activities include setting up Inventory Organization, Subinventory, Item locators
Customized iSupplier portal using Self service Personalization, Customized PO approval and Supplier Registration Workflows and external server DMZ configuration.
Created Unit Test and UAT test cases and guided users in UAT.
Created Supplier training using UPK recording
Created Supplier on boarding process.
Created Functional Design MD50, Technical Design MD70, Unit Test TE20 and Setups BR100 documents.
Created installation scripts to move customization to Production and Instance readiness check and cutover task.
INVENTORY
Major activities include setting up Inventory Organization, Subinventory, Item locators,
Set-up of modules with user data, Coding of custom programs to load item data into interfaces, migration of Item categories, migration of On hand inventory quantity, Coding of custom programs to load cost of items, Migration of Locator and Sub-inventory, Coding of custom programs to load catalogs into Oracle Application and Preparation of Detail Design (MD050, MD070 using AIM2.0).
PepsiCo May 2005 May 2009
Plano TX
Senior Oracle ERP Consultant- R11i and R12
Oracle Financial migration and integration with SAP ONE UP Project for PepsiCo Group of Companies
Release1 This was an integration project of Oracle financials (Multi Org and Multi-instances) with SAP (ERP). The functional synopsis of this project is to purchase all OG&S items (Indirect Procurement) in SAP for PepsiCo Group companies and pay from Oracle Accounts Payables. This requires inbound and outbound interfaces (Invoices, Payments,iExpenses, Vendors, Budgets, Projects, GL accounts , Accruals, Commitments, Items and Categories and Re-conciliation). Conversions of initial data (Vendors, UOM, Locations, Pos List of values, Accounting Code Combination, PO and Invoice Accrual and materials group), mapping of functional requirement. My role is to interact with the Operations business team interpret requirement and recommend solution, design functional compatibility of Oracle application to SAP, Design FMD, reviewing of MD050 documents.
Release 3 and 5 Conversion of all the data from Oracle Tropicana and Pepsi Instances( GL,AP,PO,PA, Concur, CCDS and Vertex) to SAP and interface new GL feeds and reconciliation reports from Oracle GL to SAP. Validation of recon reports from data warehousing for Oracle and SAP data. Retirement and sun setting of Oracle instances and data Archiving for Tax and Audit purposes. My role is to design functional compatibility of Oracle application to SAP, SME for Oracle, Functional Oracle presentation and training to the Achieving solution team reviewing of MD050 documents, creating and maintaining BR100 documents.
R12 Assessment and Upgrade: Conducted interviews with business to document current as is process for Procure to Pay cycle. Contributed to the blue print for the R12 re-implement project for Fritolay division.
QA Responsibilities:
Designed Master test Strategy, test plans and test cases for each release and reviewed with the developers and end users and managed test entry, success and exit criteria.
Executed test scripts in Quality Center test lab as part of System Test and UAT test cycles.
Organized and managed the testing process by appropriately dividing test cases among the testing resources, ensured that the testing effort was delivered on schedule, reporting on metrics related to the status of the daily testing effort.
Developed and managed a repository of test data to support testing efforts for regression testing and testing Technology Stack upgrade.
Coordinate the development of documentation, such as Test summary documents, Test Plan, Defect management review, Project Deliverables Matrix, Business user approval document as per SOX Compliance.
Participated in the complete software development life cycle including analysis, design, and operational rollout of developed features
SME for Oracle and training Business users on the new functionality and test execution cycles during UAT.
Monitored test environment build and availability during different test cycles and phases. Maintained application Set ups in the test instances as per the BR100 document.
As a lead, chair test Coordinator meeting, risk management and Defect Management reviews for Oracle apps and report to higher management
R11i 7-Eleven Corporation July 2004 May 2005
Dallas
Sr Oracle Apps Consultant
Worked as a Functional/QA consultant for the iSupplier, Sourcing, iProcurement and iExpenses implementation.
Business Area include Sourcing, Negotions(RFQ &Auctions) Requisition, Catalog management, iSupplier portal, UOM, AP workflow approval, AP, GL, Projects and APC(Advanced product catalog).
iSupplierWeb page configuration(Home page, Order page, Shipment and planning page)
Application configuration for Purchasing and Payables.
End User procedures- Register suppliers, enter advance shipment notice, create Invoices and Order Acknowledgment. Workflow configuration for Supplier registration, PO approval, Advance shipment Notice.
Involved in Set up configurations in full business cycle. Full understanding of Functional and business cycle from sourcing, requisition, PO creation, Payables, Alerts. PO approval rules, projects mapping and HR employee mapping. Invoices approval workflow and AME Rules.
Responsibilities include writing Requirement, Functional Design, Gap Analysis, writing test design, test cases using Test Director, writing Auto test scripts using Win runner.
Close liaising with Business analyst, development team and Users group. Involved in Integration testing, Regression, defect management reviews and User acceptance testing. Conducted and chaired meetings with different business units, from collecting requirements, design and development stage using AIM methodology
Business user group training.
Involved in Sun setting database to improve storage space and performance for test instances.
R11i Alpha Natural Resources Virginia Feb 2004 - July 2004
Sr Oracle Apps Consultant- Financial
Worked as a consultant for a coal mining company in Virginia. Modules FA,AP,AR,GL,OM and INV. Tools ADI, Discoverer. Muti ORG environment.
Implemented UOP(Unit of production) depreciation rule in FA. Carried on all configuration and Setup rules.
Created new assets using ADI. Full understanding of all the functionality in loading assets through standard interface table and rules in adding assets to Corp and Tax books. Good understanding of Mass addition, retiring assets, depreciation rules and data flow.
Written FSG and Standard reports using Oracle reports 6i.
Implemented an interface in AR, loading AR invoice from legacy system ( SQL Server). Using AR standard interface using Autoinvoice. Performed configuration setup for AR interface.
Involved in design, gathering requirement closely working with business analyst. Carried on all AR setup and written scripts to load data from SQL server to Oracle. On a Linux platform.
Worked on Discover 6i user and administration group.
Setups for item codification and categorization
ATC Logistics Dallas Oct 2003 - Jan 2004
Sr. Oracle 11i Consultant
Worked as Functional/Technical consultant for AFTERMARKET TECHNOLOGY CORPORATION at Dallas Fort Worth.
Involved with the upgrade from oracle 11.03 to Oracle 11i 5.8.
Data conversion from the legacy system to 11i.
Written Interface to import GL Transaction and net activities in GL balances.
Written interface in AP to import open invoices and mapping with purchase orders.
Also wrote extensive code to import Historical paid invoices into AP. SQL/PLSQL KORN SCRIPT, SQL LOADER.
Multiple org environments.
Written technical and functional specs in consultation with the business analyst.
Tax and Corp Book Conversion in Fixed assets from legacy system.
Customized standard forms and new reports in Order Management.
Major Accomplishments:
Worked under strict deadline constraints. In a short time worked long hours to migrate all the data from the legacy to the current 11i system.
Can work on upgrades for AP, AR, GL, FA.
Understood the business requirement strong technical and functional knowledge.
Cap Gemini UK
Dec 00 to Oct 2003
Oracle Apps Consultant
Worked as a Baseline support analyst at British Defense Housing Executive
Involved with development of a complex classified secured Oracle financial 11.5.7 application for Ministry of Defense Housing main modules AP, AR,GL, FA,PO
Confident with design and working with Workflow 2.6,Discoverer, Toad
Participated in the full life cycle of implementation from requirements gathering, design, development, QA testing, (including documentation) and application support.
Developing functional specifications for new user requirements and change requests, writing PL/SQL scripts, Korn scripting, SQL*Loader and custom development of forms and reports 6i on Oracle DBMS 8.1.7.1, extensively used AOL (Application Object Library). TKProf, Explain Plan, SQLLab.
Good knowledge of the Oracle 11i data model, full knowledge of navigations through applications and data flows.
Detailed knowledge on the integration of all the Financial modules. Responsible for system administration task, Create user profile, attaching to responsibility, registering forms, reports, concurrent manager setup. Resolve Printing issues.
Application setup GL,AP,AR,PO,FA and configuration in Oracle 11i environment application architecture in AIX Unix context.
Extensive customization of standard Forms and Reports, FSG reports, also good knowledge of writing Interface scripts to extract and import data from the financial module to third party system including troubleshooting problems, maintaining, and upgrading the applications.
Built an application to extract data into interface, using various J2EE technologies including HTML, JSPs, Servlets, Java Beans. Main products used are JBuilder 5 Enterprise Edition, Weblogic 5.1/6.0/6.1
Experience in opening, managing, and resolving Oracle TARs with Oracle Support
Major Accomplishments:
Worked on live project, work under continual deadline constraints have the ability to conceptually relate technology to a business' needs on a global scale demonstrate ability to establish, manage, and strengthen customer relationships.
Have strong problem solving, quantitative, and analytical abilities, the ability to maintain a high-level of discretion and confidentiality.
Have Excellent written and verbal communication given the highly interactive nature of the job, ability to work independently.
Bull Info System/Steria, UK Sept 99 to Dec 00
Oracle Apps Developer
Designed and Developed Interfaces to upload data into AP and GL Financial module using Korn shell scripting data conversion from 10.7 to 11i.
Involved in requirements gathering, design from scratch, development, testing and documentation.
Also worked on desktop integrator to import data into the oracle financial module.
Customized new forms and reports to enable end users to extract data and data validations.
Worked on functional side of the financial suite, setting up set of books, account structure and application setup. Responsible for all application administrator tasks.
Major Accomplishment:
Worked independently to strict deadlines. Improved my functional understanding of the Oracle financial suite.
Northern Rock Investment Bank Plc -UK
Test Engineer
Involved in implementing testing specs and test plans to match user business requirements.
Worked alone and with team members on integrating functional and regression testing, creating, executing, maintaining test plans, and working with the development team to achieve a stable software solutions, test lead experience and strong development methodologies, ability to write reports and document testing procedures, ability to effectively communicate with managers, test team, and customers, ability to solve practical problems, and to interpret a variety of instructions.
Fluent in writing SQL scripts and worked intensively on Unix Aix Platform.
Resolved issues with session management and security.
Involved in the full Life cycle of the project QA's role at each phase along the way, from requirements through system release.
Major Accomplishments:
Provided a test automation solution to speed up test integration.
Promoted to a Team lead with in two months of joining the company.
Worked with client and helped in resolving lot of the day-to-day software quality issues.
Do power point presentation to client and explain the system that was being integrated at the customer sites.
Trained junior engineers.
K.K.Nag Ltd., Pune, India Aug 95 to Sep 98
Software Engineer.
Oracle Application Developer
Responsible as a System Design analyst for Front-end application development.
Worked on client server application with Developer 2000,Oracle7 on Windows based system.
Developing complex forms and reports also wrote pl/sql scripts, triggers and was involved in migration of data.
Converting business requirement to Functional specification design, implement and support application and systems integration.
Major Accomplishments:
This experience gave me an excellent start in commercial software development, improved my team working and time management skills and gave me an insight into large-scale software development projects.
Download Resume Format
.JPG)
0 comments:
Post a Comment