Pasupulati Anil
*********.**********@*****.***
Mobile: 408-***-****
Sr. Programmer/Systems Analyst
Summary
Mr. Anil Kumar Pasupulati has over eleven years of experience in Oracle
Applications System, excellent implementation experience Using Application
Implementation Methods, doing gap analysis, Specialized in Distribution &
Manufacturing 11i & R12 Modules: Oracle Inventory, Oracle Purchasing and
Oracle Order Management/Shipping, Advanced Pricing and four years Domain
experience in Manufacturing Industry. Mr. Kumar is proficient at
functional aspects, testing, implementing and training. He has excellent
functional skills in the areas like Extensions, Conversion, and Reports.
Mr. Kumar has broad functional experience of modules in Order Management,
Shipping,Advance Pricing, ipayments, Oracle Warehouse Management, Oracle
Purchasing, iProcurement,isupplier,Oracle Costing, Bills of Material, Work
In Process, Advanced Supply chain planning,Quality, ECO and Service
Contracts (OKS), Payables and Receivables. He has exposure in varied
business processes of many fortune companies. Mr. Kumar has outstanding
organizational skills, work ethic and drive to succeed. He has good
interpersonal skills, ability to work well and hard with multidisciplinary
teams, excellent communication skills, experienced in handling large
workforce, skilled & unskilled, wish to learn new things and concepts. Mr.
Kumar is certified R12 Oracle Inventory Management & Order Management
Fundamentals.
Knowledge
. Technologies: Oracle 9i,TOAD PL/SQL Developer Oracle Utilities
. Functional Expertise: Oracle Applications 11.5.10, R12, Fusion
Costing and Modules of Order Management, Oracle Advance Pricing, TCA,
Service Contracts (OKS), Oracle Configurator, Oracle Purchasing,
Oracle Quality, Oracle Inventory, Oracle Shop Floor Management, Oracle
Bill of Material, Oracle Work In Process,ECO,ipayments,TCA and
Service Contracts (OKS), Payables and Receivables modules
. Industry Expertise: Manufacturing Industry, Educational Services
Hitachi Consulting Experience
PPG
SCM WMS Functional Lead Jun2014 - Till Date
Location: Pittsburgh,PA, USA.
. Responsible for key areas of cross-functional integration, including
organization structure.
. Created BR-100 documents for WMS, Purchasing and Inventory
. Worked on set-ups for WMS replenishment tasks. Created WMS picking
rules and all WMS set ups. Worked on customizations in WMS
. Worked on various warehouse management systems Process like
Receiving, put away, replenishment, slotting, picking, packing,
shipping, labor management, Customer Orders, shipments, Purchase
Orders, Receipts.
. Created new functional design documents (MD.050), Business Requirement
Documents for the enhancements
. Performed Demo about Oracle WMS to the business users.
. Multiple Custom extensions,Conversion,Interfaces, Shipping document
reports
. Own entire Data Conversion of OM, PO and INV from their legacy
Tandem system to Oracle and accurate import & validation has been one
of the most critical areas in this project
. Worked on designing new label formats (LPN labels and Material
labels).
. Worked on Inventory Item Open Interface for bringing items into
Inventory
. Designed the outbound interface that extracts Items that do not have
categories assigned for a given category set category assignments
. Involved in EBS - OTM Integrations. Inbound, outbound Shipment
Integration with BizTalk Middleware.
. Responsible for setting up standard testing environment as well as
perform monitoring of system test phase
. Interact with the end-users in resolving major issues and also during
gathering requirements for new enhancements
. Developed the TE40 for internal orders and conducted unit testing.
. Coordinated multiple rounds of integration testing to ensure business
processes were thoroughly addressed by the solution from Operations
perspective
. Successfully executed CRP1, CRP2, and UAT
Nintendo
SCM O2C Functional Lead Jan 2014 - Jun 2014
Location: Redmond, WA . USA.
. Business process documentation.
. Responsible for key areas of cross-functional integration, including
organization structure.
. Multiple Custom extensions designed to fit gap the order process Flow.
. Brain storming sessions with, key business users and business
process/application owners and the Entire IT Development team to
finalize a high level solution approach on major business
areas/functions and also to bring in most of the painful offline
business functions into single integrated process.
. Process Centric Integration and Process automation using oracle
workflow customizations.
. Event Driven Integration through Business events.
. Solution design for the third party Integration Interface for external
Shipping systems FED-EX, UPS through SOA Based Integration.
. Payload Template Design for the payloads Interface mapping.
. Order import Integration through various sources by Integrated SOA
Gateway.
. Implemented Oracle SOA payload template design and B2B module using a
B2B adapter to read and send messages to third party partners.
. Inter-enterprise integration with internal data and processes by
linking them with customers and other corporate enterprises,
heterogeneous enterprises to interact in diverse business
transactions.
. Credit card Payment process through Chasepaymentech servlet
configuration.
. Credit card Tokenization, Auth, Capture through out of box designed.
. Customer Tier based price solution through Advanced Pricing solution.
. Involved in Order Management, Shipping execution, Advance pricing,
oracle payments, iprocurement, quality, Advanced collections, Credit
Management.
. Customer Return process through reverse logistics through Depot
repair.
. Supporting production issues in SCM and Finance modules.
Symmetricon
SCM Functional Lead Dec 2012 - Jan 2014
Location: San Jose, CA . USA.
. Project is Upgrade of Oracle Applications 11.5.10 to 12.1.3.
. Business process documentation.
. Value Added objects enhancements done for business critical objects
with respect to R12.
. SCM Distribution CEMLI objects Impact study and Modified with the new
Tables and API's.
. SCM pre-upgrade,post -upgrade activities done for SCM modules INV,
PO, OM, Advanced Pricing, BOM, WIP, Quality, ECO, iProcurement,
iSupplier, ASCP.
. All Personalization affectivity compared with 11.5.10 and R12.1.3.
. All Business Flows Tested end to end Cycles.
. Enhanced Functionality in R12 User manuals created and user training
provided.
. Continued with Client Regular production support issues parallel with
Hitachi AMS Support.
.
Spectrum Chemicals
SCM Functional Lead Jun 2012 - Oct 2012
Location: Hyderabad, India
. Project is Upgrade of Oracle Applications 11.5.10 to 12.1.3.
. SCM Distribution CEMLI objects Impact study and Modified with the new
Tables and API's.
. CRP / UAT Cutover time before upgrade Count has been Taken and after
upgrade count will be compared with data accuracy.
. All Personalization affectivity compared with 11.5.10 and R12.
. All Business Flows Tested end to end Cycles.
. Enhanced Functionality in R12 User manuals created and user training
provided.
. R12 Enhanced Picking Rules issues Resolved.
. R12 Advance Pricing Qualifier data migration issues resolved.
. R12 Enhanced Material Statuses issues resolved against Sales Order
Picking/shipping.
. Coordinated, supervised, and lead design efforts to build the new
system.
. Purchasing module with Purchase order functionality, Receiving,
Payment cycle executed with Accounting. Worked on accrual Accounting
Reconciliation process.
. Supplier migration issues and new Supplier setups.
. Supplier accounting values default to all new supplier sites for the
new supplier.
. Banking Details page to record the supplier bank accounts that
suppliers and supplier sites use for payment transactions.
. Define supplier bank accounts, Supplier Bank Account migration issues.
. Supplier and key purchasing and payment setup information for supplier
sites.
. Purchasing and payment options for supplier sites setups.
. Taxpayer ID Validation, Tax Registration Number Validation.
. Supplier Audit Report reconciled for the Duplicate supplier data.
Beach Body Inc.
Functional Lead May 2011 - May 2012
Location: Hyderabad, India
. Implementation Functional lead role to design business process mapping
from legacy system to applications.
. Established the vision and roadmap for the legacy system and ad-hoc
templates and requirements, analysis, and design.
. Ensured the initiatives adhered to the user experience standards and
best practices for the new application system.
. Worked in iPayment Module with Order management Module for different
Types of Payment Method Modes Enhancements and UK Roll-out Project,
another Business Currently working in Legacy (By Design) system
migrating to 11.5.10 Existing system.
. Client Portal business integrated with Oracle application system with
SOA BPEL Integration layer Mapping established.
. Coordinated, supervised, and lead design efforts to build the new
system.
. Assessed and coordinated efforts to configure a new implementation of
the Oracle E-Business.
NetApp
Functional Lead Mar 2011 - May 2011
Location: Hyderabad, India
. 3 month role to Responsible for data migration for upgrade master data
in to R12 Instance.
. Designed Interface for live data migration from base 11.5.9 instance
to R12 for the Multilevel Instance.
. Responsible for the creation of conversion interface and test
documents for foundation objects.
. Tested and validated the foundation objects in R12 Instance and
delivered.
Prior Work History
Amway
Offshore Functional Lead Jun 2010 - Mar 2011
Location: Hyderabad, India
. Project is Upgrade of Oracle Applications R12.0.4 to 12.1.1.
. Solely responsible for Analysis on Upgrade impact on Customized
extensions and Existing Business Flows.
. Project Delivery, Resourcing, establishment of Support Process &
effective monitoring.
. Responsible for the delivery of the Customer technical & functional
solution from offshore.
. Data Migration, Business System Integration Testing, Data verified and
tested.
. Involved in Co-ordination between the Customer onsite team and the
offshore team.
. Created Unit Scripts and Business Scenarios which reflect the
requirements.
. Customized user interfaces that met the needs of their high-volume
repair operation and integrated the solution with Teleservice, Service
Contracts and Install Base.
. Lead the cross functional teams in developing the extension that
included multiple modules (Quoting/ OM/ Pricing/ Service Contracts).
Determined and negotiated the deliverables and delivery schedule with
the client.
. Involved in setup and implementation of Service Contracts depending on
functional setup changes/enhancement.
. Registration of process definitions to validate the service contracts
created from quotes.
. Executing and testing of Quotes created from Service Contracts which
is known as Super Quotes using oracle standard APIs.
. Development and testing of Quotes created from Service Contracts which
is known as Super Quotes using oracle standard APIs.
. Involved in conversion programs for Items and Service Contracts using
Oracle PL/SQL and Standard APIs.
. Responsible for development of service contacts conversion program.
. Worked on Data Conversion of Contracts data.
. Developed utilities to change the Billing Amount, Billing Frequency
for a Service Contracts in Service Contracts Module.
. Customized the Contracts Approval Management Workflow to check for the
Profitability Analysis of the Contract.
. Defined the Custom Rule Groups and Rules in the Contracts Module.
. Involved in Customized Service Contract Electronic Renewals.
. Worked as a business analyst for project to expand the implementation.
. Of Service Contracts (SC/OKS/OKC) and Install Base.
. Defining the Different Contract type items like Service, Warranty,
Subscription, and Usage.
. Work breakdown, deciding on Timelines, Estimations and Tracking.
Oracle India Pvt Ltd.
Oracle Fusion Apps Development & SI Testing in Costing Feb 2010 - Jun
2010
Location: Hyderabad, India
. Fusion Apps Costing Architecture overview.
. Fusion Apps Costing Inventory Transactions Accounting Flow Validated
through Test Scripts.
. Fusion Apps Costing Receipt Accounting Flow Validated through Test
Scripts.
. Fusion Apps Costing, Analysis for item Cost at lower Granular level.
Boar's Head
Offshore Functional Lead Nov 2009 - Deb 2010
Location: Hyderabad, India
. Created Module Design documents for Shipping Documents Pick Slip, Pack
Slip, and BOL Reports.
. The project involves meeting the client requirements.
. Prepared MD50 Documents and CV40 Documents for Conversions.
. Worked closely with development team for CEMLI development and
testing.
Art.com
Offshore Functional Lead, Implementation Oracle Application R12 Aug
2008 - Nov 2009
Location: Hyderabad, India
. Responsible for the delivery of the Project objects.
. Involved in Co-ordination between the Client, Onsite Team and the
offshore team.
. Work breakdown, deciding on Timelines, Estimations and Tracking.
. Assisted the team in understanding the Requirements, design of various
algorithms and the Performance requirements of the system.
. Fit gap analysis on the requirement. Proposing solutions for gap using
extensions. Worked on approx. 30+ extensions.
. Coordination with development team, testing of the new designs
including extensions, conversion, interfaces and reports.
. Conceptualization on Picking and shipping processes to meet the
business requirement. Coordinate for development and testing of the
new picking and shipping solution. Third party interface validation
for shipment.
. Custom solution with OM work flow modification to meet the specific
business requirements.
. Modified Oracle Configurator flexibility to fully customize runtime
UIs, can leverage seeded templates to generate UIs .Users can
represent model nodes, including BOM nodes, with a number of different
UI controls, including drop-downs, tables, and radio button groups.
. Implemented E-Biz Tax with exceptions & custom Level tax calculations
for shipping charges.
. Integration Objects Cross checking with Account Payable, Account
Receivables & General Ledger Modules.
. Involved in Test cases reviews.
. Do analysis of the change requests and provide the client with the
expected person-hours required to close the request Develop, maintain
and modify the customized reports programs and database triggers.
. Preparation of full cycle Test Cases and coming out with Unit
Testing/System Testing.
Herbalife
Offshore Functional Consultant, Oracle Application Implementation 11i
Aug 2008 - Nov 2009
Location: Hyderabad, India
. Involved in OM global Roll out for India, AS a part of the initial
phase of Implementation of the project the AS-IS Process study was
being conducted for the business Flow to Fill the Gap.
. Do analysis of the change requests and provide the client with the
expected person-hours required to close the request Develop, maintain
and modify the customized reports programs and database triggers.
. Preparation of full cycle Test Cases and coming out with Unit
Testing/System Testing.
CVRD-Vale
Offshore Functional Lead, Support Project Oracle Apps 11.5.10 Dec 2007 -
May 2008
Location: Hyderabad, India
. Worked with AMS Team on Production Support, Solving the Production
Tickets, like Transaction issues, Setup change issues & Custom Code
issues.
. Do analysis of the change requests and provide the client with the
expected person-hours required to close the request Develop, maintain
and modify the customized reports programs and database triggers.
. Preparation of full cycle Test Cases and coming out with Unit
Testing/System Testing.
Worthington Industries
Offshore Functional Lead, Implementation Oracle Apps 11i Mar 2006 - Nov
2007
Location: Hyderabad, India
. Analysis for the MD.050, Requirements, Business Processes and work
with the development team to fix the issues, testing and deliver.
. Custom objects covering various extensions, reports and interfaces on
discrete manufacturing, Order Management, Shipping execution,
Inventory and Purchasing.
. Supported EDI Transactions Inbound & outbound. Standard Customer
Profile with Oracle ecommerce Gateway.
. Supported Oracle Shop Floor Process with multiple extensions.
. Supported multiple Quality Extensions for Shop Floor process
-Nonconformance and Disposition solutions with related collection
plans,ISO 9000:2000 and QA9000 - 4.13 - Control of Nonconforming
Product,AS9100 - Clause 8.3 - Control of Nonconforming
Product,nonconformance sources : Quality Inspection Collection plans
for receiving, work-in-process, and finished goods .Other quality
collection plans, such as testing, and packaging .Nonconformance
identified by suppliers, Equipment nonconformance's.
. Corrective Action Requests via a pre-configured set of seeded
collection plans. Notifications through Workflow. Quality Results
Report Writer - reporting on a single collection plan. Oracle
Discoverer - analyzing data across multiple plans and providing an
enterprise view of corrective action requests across multiple
organizations. Through customized Work flow Depend on Item
Specifications. Post Production Support & New enhancements.
. Analyzing the issues reported on the custom solutions.
. Interaction with system engineers and business users for the post
production issues.
. Do analysis of the change requests and provide the client with the
expected person-hours required to close the request Develop, maintain
and modify the customized reports programs and database triggers.
. Full cycle System Testing was done successfully taking full ownership.
Bharti Tele ventures Ltd (Airtel)
Functional Consultant May 2005 - Feb 2006
Location: Delhi, India
. Support Analyst for the Issues Resolvation for Inventory, Purchasing
Modules with Indian Localization.
. Key Role in Month End Closing Process.
. Hands on Sql Queries for Trouble shooting& Reconciliation.
. Involved in Migration Process 11.5.3 &11.5.8 to 11.5.10, Multi
Instances to single Instance
. Knowledge of troubleshooting for the Month end Closing Issues with
Account Payable, Account Receivables & General Ledger Modules.
. Work on the technical problems that come up during the month-end and
quarter-end closing.
. Provide the necessary Training to the IT helpdesk to enable them to
support End users and Business.
. Man Resource Planning according to the quality, importance and
priority of work.
MRF Tyre Manufacturing Industry
Functional Consultant Jun 2003 - May 2005
Location: Andhrapradesh, India
. Develop business requirements for ERP Implementation and analyze the
scope.
. Worked with the ERP Taskforce in business process mapping.
. Hands on experience with setting up multi-org structure and set up
steps in Inventory, Purchasing, and Order Management.
. Involved in the development and user testing of in-house ERP software.
MRF Tyre Manufacturing Industry
Production Engineer Mar 1998 - Jun 2003
Location: Andhrapradesh, India
. Responsible for production management and control, product scheduling
and inventory management. Responsible for quality assurance and
maintenance of Statistical Process Charts. (SPC).
. Audit Production Departments for 5S compliance. Production Planning,
Scheduling, inventory management and prompt supply of materials to the
demanding warehouse.
. Ensure implementation of procedures and standards.
Education and Certifications
. B.Tech in Mechanical Engineering from Jawaharlal Nehru Technological
University, Hyderabad
. Diploma in Mechanical Engineering from JNGP, Hyderabad
. Pursuing Diploma in Project Management from Central University of
Hyderabad, Hyderabad
. Oracle Certified Expert in E-Business Suite R12 Oracle Inventory
Management & Order Management Fundamentals and Supply Chain Management
Implementation Specialist: Oracle Purchasing
. In-house training in Service contracts, Analysis on Service Contracts
depending on functional setup changes. Service contracts from quotes,
Ensured the dependencies of Service contracts with pre-existing
module.