Project Sales
Resume:
HARISHANKAR AWASTHI
Cell - 517-***-****
Email - ****.*******@*****.***
CAREER OVERVIEW
IT professional with a total of 15+ years experience of which 10 years
experience in design, development and implementing software solutions.
Successfully implemented and supported Oracle E-Business Suite Applications
for OTC and ATR
Experience in Implementation, customization, design, development, testing
and production support of Oracle I-procurement, Oracle Inventory, Order
Entry,Advanced Pricing, Purchasing, Cost Management, Planning Products,
Work In Process, Bill of Material, Oracle Accounts Payables, Oracle
Accounts Receivables, General Ledger, Oracle Fixed Assets, and Oracle EDI
Gateways, Oracle Advanced Planning and Scheduling(APS), Order Configurator.
End to End implementation including analyze business requirements and user
requirements, design, document and CRP, Integration and UAT testing using
AIM methodology.
Delivered training on ASCP Fundamentals at Oracle Education that included
Model Supply chains, generate plan (Constrained/ Unconstrained), use
Planner workbench, Review and resolve exception messages, Analyze demand
and supply and planning strategies.
R12 Implementation
Supported I2 Demand planning.
Build enhancement for Supply Chain planning.
Implemented Ecommerce Gateway for Inbound and Outbound transactions.
Experience in using Application Implementation Methods, doing gap analysis,
working on sizing.
Experience in Conversion and Migration from Legacy Systems to Oracle
Applications.
Project executed in Discreet and OPM manufacturing tracks.
Rich experience, which includes project management, application design,
application development, architecture and technical leadership.
Strong analytical, planning and forecasting, problem solving and management-
client liaison skills.
Excellent track record of on time delivery and customer satisfaction.
PROFESSIONAL EXPERIENCE
AT&T, Atlanta US.
April `10 - Till date
Description
AT&T is a telecom giant with more than 61 million subscribers who use the
nation's largest digital voice and data network. AT&T is dedicated to
providing customers with wireless technology designed to enrich their
lives. AT&T has upgraded Oracle Apps (11.5.10) for their Forward logistics
and reverse logistics. AT&T Financials are on R12. The project enables AT&T
Wire Line business to consolidate purchases from suppliers with single
application. The project empowers AT&T users to do strategic negotiations
with suppliers and better control. Across AT&T multiple applications were
used to procure Field and office supplies. The project was 1st phase of
phased roll out. Modules involved were Iprocurement, Isupplier, Contracts,
Purchasing and Account Payables.
Roles and responsibilities
Technical Architect
Business Process Analysis - Current State and Future State Analysis.
Requirement gathering and Solution approach
Design Custom Catalogs based on Item usage/account
Design Custom Catalog access security
Setup I-procurement, purchasing module
Spearheading Regression testing, CRP, UAT effort.
Create Training documents and new process flows for Super users
Production set ups and Go-Live and Post Go Live Support.
AT&T, Atlanta US.
July `09 - Mar '10
Description
AT&T is a telecom giant with more than 61 million subscribers who use the
nation's largest digital voice and data network. AT&T is dedicated to
providing customers with wireless technology designed to enrich their
lives. AT&T has upgraded Oracle Apps (11.5.10) for their Forward logistics
and reverse logistics. The project enables AT&T Mobility (ATTM) to deliver
Wire Line UVERSE products to Customers that requires Self Install. UVERSE
is delivered to customer using a combination of products are self installed
and technician Installed. Modules involved were Oracle Order management,
Oracle Shipping, Order Purchasing, E-commerce Gateway, Oracle Bill of
material, Oracle Work In Process, Oracle Quality and Inventory modules.
It required backward integration with Red Prairie WMS for Pick, pack and
ship.
Roles and responsibilities
Technical Architect
Gather business requirement, Build use cases for Purchasing process
Define new business process
Design the Purchase Order import process
Design enhancement for WIP to integrate with WMS Red Praire
Configure BOM
Design the return process with / without return Authorization
Spearheading testing effort.
Prepare Cut over strategy
Business Objects BI reports
Production set ups and Go-Live and Post Go Live Support.
AT&T, Atlanta US.
Jul `08 - Jun '09
Description
AT&T is a telecom giant with more than 61 million subscribers who use the
nation's largest digital voice and data network. AT&T is dedicated to
providing customers with wireless technology designed to enrich their
lives. AT&T launched U-verse to deliver better television experience than
Cable. AT&T mobility will support the supply chain for this new product
launch across 16 states. AT&T has upgraded Oracle Apps (11.5.10) for their
Forward logistics and reverse logistics This project enables AT&T Mobility
(ATTM) to deliver Wire Line CPE (Customer Premise Equipment) / DSL
/Worldnet products on behalf of ATT 2.0 to AT&T work centers and directly
to AT&T End Users, as applicable, from inventory maintained at Distribution
Centers. The Project will re-define ATTM supply chain (SCM) to handle many
different customers instead on a single Mobility customer as it does today.
This will mean that ATTM will generate and track inventory, forward and
reverse data specifically for the ATT Wire line business domains (VDSL 9
states South East). Modules involved were Oracle Order management, Oracle
Shipping, Order Purchasing, Ecommerce Gateway, Oracle Work In Process,
Oracle Quality and Inventory modules. It required backward integration
with Red Prairie WMS for Pick, pack and ship.
Roles and responsibilities
Oracle Functional lead
Design EDI layout Mapping for incoming Order request to oracle POI 850.
Configure E-Commerce gateway for new Feed
Develop API to extract Order statues from Oracle for CSR
Item Conversion
Brainstorm and Design BOM for new items
Design API to interface WIP Job with WMS
Business Objects BI reports
Spearheading testing effort.
AT&T, Atlanta US.
Nov `07 - Jun '08
Description
AT&T is a telecom giant with more than 61 million subscribers who use the
nation's largest digital voice and data network. AT&T is dedicated to
providing customers with wireless technology designed to enrich their
lives. AT&T has upgraded Oracle Apps (11.5.10) for their Forward logistics
and reverse logistics This project enables AT&T Mobility (ATTM) to deliver
Wire Line CPE (Customer Premise Equipment) / DSL /Worldnet products on
behalf of ATT 2.0 to AT&T work centers and directly to AT&T End Users, as
applicable, from inventory maintained at Distribution Centers. The Project
will re-define ATTM supply chain (SCM) to handle many different customers
instead on a single Mobility customer as it does today. This will mean
that ATTM will generate and track inventory, forward and reverse data
specifically for the ATT Wire line business domains (13 states). Modules
involved were Oracle Order management, Oracle Shipping, Order Purchasing,
Ecommerce Gateway, Oracle Work In Process, Oracle Quality and Inventory
modules. It required backward integration with Red Prairie WMS for Pick,
pack and ship.
Roles and responsibilities
Oracle Functional lead
Design EDI layout Mapping for incoming Order request to oracle POI 850.
Configure E-Commerce gateway for new Feed
Design pre-processor for Importing orders in Oracle
Design API to interface WIP Job with WMS
Build BO reports to support management review and control
Production set ups and Go-Live and Post Go Live Support.
Item Conversion
Build Alerts to preempt order processing delays and meet fulfillment SLA
AT&T, Atlanta US
Aug `07 - Oct '07
Description
Erstwhile Cingular now AT&T is a telecom giant with more than 61 million
subscribers who use the nation's largest digital voice and data network.
Cingular is dedicated to providing customers with wireless technology
designed to enrich their lives. Cingular has implemented Oracle Apps(11.5.8
) for their Forward logistics and reverse logistics. They have a custom
solution for stores sales. Apple launched iPhone in collaboration with
AT&T. The project involved on boarding Apple as Supplier in AT&T Supply
Chain. Solution involved setting up EDI transactions (850, 860, 810) for
Apple.
Roles and responsibilities
Oracle EDI Functional lead
Design EDI layout Mapping for outgoing Order request to oracle POO 850,
POCO 860 and INI 810.
Gap analysis for standard maps of POO 850, POCO 860 and POCO 860
Configure and set up E-Commerce gateway for new Feed of 850 with custom
extension
BR30, BP80, Test scripts, MD50, Setup documentation
EDI reconciliation for every transaction
Design interfaces to report daily sales and daily on-hand to Apple at each
store for serial number granularity.
Load testing iPhone Launch across stores
Cingular Wireless, Atlanta US
Feb `07 -Jul '07
Description
Erstwhile Cingular now AT&T is a telecom giant with more than 61 million
subscribers who use the nation's largest digital voice and data network.
Cingular is dedicated to providing customers with wireless technology
designed to enrich their lives. Cingular has implemented Oracle Apps(11.5.8
) for their Forward logistics and reverse logistics. They have a custom
solution for stores sales.
Roles and responsibilities
Business System Analyst
My role involved preparing the design documents using AIM methodology
(BR30, BR100, MD50, MD70, TE40).
Redesigning and improve the processes to improve the cycle time.
Solution Error handling for custom interfaces of Inbound
Inventory,Workflow, Purchase order receipts and RMA receipts from WMS,
Outbound Sales Order to WMS.
Build Alerts to monitor data processing at each stage of Order fulfillment
Designing and testing extensions to support error resolution in OM/PO/INV
modules.
Ingersoll Rand, Davidson US
Jul `06 - Jan '07
Description
Ingersoll Rand is fortune 500 company with worldwide businesses comprising
an enviable roster of leading industrial and commercial brands. Ingersoll
Rand's Industrial Technologies business is implementing Oracle Apps and
Siebel. The project deals with development of extensions in Oracle Apps
(11.5.8) and integration with Siebel using EAI web methods.
Roles and responsibilities
Gather business requirement for building extensions on Financials AR, AP
and GL
Review BR100 for AR, AP and Chart of account
Develop use cases for new business process
Write functional design document MD50 for extensions
Develop test cases
Enhancement and global Production support for i2
Toshiba Corporation, Tokyo Japan
Dec `05 - June '06
Description
Toshiba Corp has implemented i2 SCM application for its Consumer Products
(Audio Visual Division) and Storage Devices Division. The modules
implemented are SCP, DP, DF and FP. The project is 24x7 production support
for i2 and custom applications.
I was the delivery manager for Toshiba Corporation US. Role involved
addressing enhancement request, configuration changes, simulation request
and resolution of issues. Also required competence building in support team
and building knowledge base.
Implementation and customization for Oracle 11i OTR and Manufacturing
Matsushita Electric Works, Osaka, Japan
May '05 - Dec `05
Description
Matsushita Electric Works is Electrical and Electronic Giant of Japan with
Brands such as National and Panasonic. Turnover stands at $10.7 billion
with a workforce of 15 thousand plus workforce in Japan alone. Overseas
operation is spread across 37 countries with overseas sales of $140+
billion. Its products comprises of Industrial as well as consumer durables.
The project was implemented for their Automation Control Division in Japan.
The modules involved for implementation and customization are Order
Management, Inventory, Purchasing BOM, WIP and Advanced Supply chain
planning. The implementation was done by other vendors Fujitsu, Toshiba
and Oracle Japan. The add-on customizations were done by TCS.
1 Role: Project Leader
Client Interfacing with aid of interpreter and bilingual consultant
Review the requirement specification and design documents for enhancement
request
Evaluate / Modify the requirements/ designs
Offshore co ordination for progress on development and functional inputs
for customization development
Design Inventory structure
Prepare Set ups for inventory and Advanced supply chain modules
Conduct CRP and UAT for Inventory and Advanced Supply Chain module
Ensuring the testing from client, and delivery of all the bug fixed add-
ons.
Implementation and customization for Oracle 11i OTR
GE Healthcare, Beijing China.
Jan '04 - April -05
GE Healthcare is a US based conglomerate that has been newly incorporated
by merging the businesses of GE Medical systems, Instrumentarium and
GEMS Information Technology. They are implementing Oracle Applications for
their worldwide operations.
Datex Ohmeda was a part of Instrumentarium for which GE Healthcare is
implementing Oracle. Project is to implement Oracle in select countries as
a pilot run. China was a part of this pilot run. There is a global design
in place for the implementation, which has to be modified to suit the site
requirements.
2 Role: Project Leader - OTR Functional Lead Consultant
Implementation involved
China site specific business Process Study, User Requirement Study, Gap
Analysis, Process Mapping and Solution fitment.
CRP testing, Integrated testing and evaluation of defects
Data migration from the legacy systems through Interfaces and data load.
Suggestions for probable improvement in the business processes of the
client
Handle the entire life cycle implementation of Order Management Shipping,
Pricing, Discrete Inventory and Purchasing.
Customized implementation of Web enabled Quoting tool (Sales Work bench),
Order management tool eOM (eOrder Management) were tested and implemented.
Production set ups and Go-Live and Post Go Live Support.
Conduct various training sessions for new functionalities introduced during
the project to Super user
Implementation and customization for Oracle 11i OPM
Walkers Snack Foods Ltd. Reading UK
April '03 - Nov '03
Description
Walkers is Britain's favorite snack food and the biggest chips
manufacturer, employing over 4,000 people in 15 locations. It is estimated
that 11 million people will eat a Walkers product EVERY DAY.
The modules involved for implementation and customization are OPM
Inventory, OA Inventory, OPM process Planning, OPM Costing, Formula
Management.
1 Role: Project Leader
Preparing the requirement specification and design documents for
enhancement request and new reports across all modules.
Offshore co ordination for progress on development progress monitoring and
functional inputs for customization development
Ensuring the testing and delivery of all the customization
CRP, Production Setup, and Go Live /Post Go live support
Global Support for Oracle 11i OPM/OM/PURCHASING/ Financials
HEMPEL Pte. Ltd, Singapore
Aug '02 - April '03
Description
The first HEMPEL factory was opened in 1915 in Denmark. Today, the Group
has grown to become a world-wide enterprise comprising three research and
development facilities, 24 manufacturing plants, 128 sales offices and more
than 160 stock points strategically situated on all five continents. The
product ranges from Marine paints, protective Paints, Container Paints,
Decorative paints and Yacht Paints.
The modules involved for support are OPM Inventory, OA Inventory, OPM
process Execution, OPM process planning, Account receivable, Account
Payable, cash management and Order Management. The instance is MULTI org
enabled with two operating units, one for Singapore and One for Korea. I
was responsible for OPM and Distribution onsite support. There was offshore
support for Finance.
2 Role: Senior Consultant -Onsite Coordinator/ ROLL-OUT lead Consultant
Client Interfacing
On site Bug fixing for OPM and Distribution modules incidents
Preparing the requirement specification and design documents for
enhancement request and new reports across all modules.
OPM and GL reconciliation, costing
Offshore co ordination for progress on bug tracking, progress monitoring
and functional inputs for incidents
Ensuring the testing and delivery of all the bugs raised in time line.
Solution testing that included unit testing, system testing and in the
process of CRP2 acceptance testing.
Rollout E biz for Malaysia manufacturing Plant
Key user training and documentation.
REPORT DEVELOPMENT OPM/OM/Financial 11i. (11.5.3)
HEMPEL Pet. Ltd, Singapore
April '02 - July '02
Description
The first HEMPEL factory was opened in 1915 in Denmark. Today, the Group
has grown to become a world-wide enterprise comprising three research and
development facilities, 24 manufacturing plants, 128 sales offices and more
than 160 stock points strategically situated on all five continents. The
product ranges from Marine paints, protective Paints, Container Paints,
Decorative paints and Yacht Paints.
The modules involved for development were OPM Inventory, OA Inventory, OPM
process Execution, OPM process planning, Account receivable, Account
Payable, cash management and Order Management. The reports were developed
on Discoverer 3.1 and Reports 6i
Role:
Implementation involved
User Requirement Study and specification, Solution Design.
Building test cases
Testing for completeness and accuracy
End-user acceptance.
IMPLEMENTATION OF ORACLE PROCESS MANUFACTURING 11i
ITC Agro tech, Hyderabad India
July 2001 - March 2002
Description:
ITC Agro-Tech, 51% subsidiary of ConAgra the world's fourth largest food
company, has been
re-christened as AgroTech Foods Limited. The company's key businesses
include oilseeds and edible oil and branded packaged food products. The
company's branded oil business and has host of packaged food products under
the parent Conagra's well-known brands - Healthy World and Act II. The
company has 19 manufacturing plants (Own/Leased) across India and has a
strong distribution network with more than 60 stock points.
The objective of the project was to seamlessly integrate (Manufacturing,
Distribution and financial) all the business entities for updated supply
chain information and guided decision-making.
3 Role: Functional Consultant
Implementation involved
Business Process Study, User Requirement Study, Gap Analysis, Process
Mapping and Solution Design. An extensive training for the end-users was
carried out.
CRP testing was carried out in coordination with the end-users.
Requirements not being met by the standard product were customized.
Data migration from the legacy systems was done through Interfaces.
Giving suggestions for improvement in the business processes of the client
was also part of the implementation
Handled the entire life cycle implementation of OPM Inventory, OPM Physical
Inventory, OPM Process Planning (MRP/MPS), OPM product development.
Customization and implementation of Rebate calculation for Rebate on in
coming raw material quality Systems (Customized Module for PURCHASING).
Suggestions given for business process improvements and accepted by the
client.
Supported the Purchasing post implementation for refining the clients
requirement
Global-e-procure
ISPAT Industries Ltd. Mumbai India
March 2001 - May 2001
Description:
Integration of E-procure suite with SAP and upgrading the offline module of
E-procure from Access executable to VB6. DLL. The EAI bridge would be
called through this DLL from SQL Server using extended stored procedure.
This would integrate the modules of E-procure suite with a third party
solution
Role: Team Leader
Study the existing architecture and the design of the application.
Detail design of the interface
Integration testing
Sales and Distribution and ERP
Milton Plastics Ltd. Mumbai India
July 2000 - March 2001
Description:
Milton Plastics is in the business of manufacturing Plastic House hold
items such as Water bottles, Casseroles and lunch packs with more than 60%
market share in India. It has 3 manufacturing facility and 16 stock points
for distribution.
The project deals with connecting the C&F-dealer distributor distribution
network of client spread across the country to the Head office located at
Mumbai and the manufacturing plants at Bombay, Pune and Daman. The network
of C&F and distributor would access the application locally with
replication of data at regular intervals from Head Office.
Distribution planning and manufacturing planning
Receipts and Distribution of goods at C&F
Invoicing and payment collection at C&F and at HO
Finance and accounts
Sales promotion analysis and sales force daily sales reports
Distributors accounts payable, credit / debit note, claim management
Role: Project Leader
Macro level business study at plants and the distribution channel.
Devise a prototype for the proposed model using NetObjects
Detail business study as is and business process re-engineering
Prepare SRS
Facilitate team members for preparing Functional Road Map, Technical
Architecture
Preparation of Use Cases, Sequence diagram, DFDs and IR diagrams using
Rational Rose
Design and develop database
Plan, Monitor and control project progress
Prepare and Conduct UAT test plan
Sales Force Automation and CRM
Product - Gold Mine and ACT 2000
TATA housing, BNP bank, Mumbai, India.
Jan '2000 - June'2000
Description:
Maintain Prospect / Client database and track transaction history
Plan and control activities for sales force and their efficiency evaluation
Mass mailing and auto mailing
Role: Team Member
Customization Analysis and SRS
Testing
Implementation & End user training
Project Planner
Hindustan Dorr Oliver (I) Ltd. Mumbai, India.
Aug '98 - Jan ' 99(6 months)
Description:
Maintain all Technical and Commercial details and their subsequent
revisions of purchase order of Client
Maintain detail BOM of Equipment for invoicing
Maintain invoice values for items in BOM
Forecast and actual monthly shipment reports
Progress reports on projects
Planning reports (Vendor wise, item wise and Job wise)
Reports for design action pending and purchase action pending
Invoicing (Performa and actual invoices)
Role: Team Member
Design table structures, forms and reports for this module
Coding,
Testing, Bug Fixing
Implementation and User Training
Functional experience:
Employer GTL limited
End-To-End IT Solution Provider
Designation Consultant
Duration March 2001 - April 2002
Scope study, "As is" and "Would be" scenario for Key business processes for
Oracle Apps
Conduct scope demo for Oracle Apps and E-procure suite
Prepare Functional road map, technical architecture, integration points for
E-procure
Estimate Man months and prepare Project Plan
Implemented Oracle Process Manufacturing (OPM Inventory, OPM Product
Development, OPM Process Execution, OPM Process Planning and OPM Sys-
Admin.)
Employer Hindustan Dorr Oliver (I) Ltd. Bombay. India
Project Consultants for Solid Liquid Separation processes
Designation Engineer
Duration March'96 - Dec '99 (3 years and 10months)
2 Engineering Functions & Responsibilities:
Project appraisal (Commercial and Technical)
Project execution, scheduling & project monitoring using software Yojana.
Yojana is project management package.
Forecast shipment, Cross functional Coordination, Vendor control,
Invoicing and Despatch
Employer Mahindra & Mahindra Ltd., Automotive Division, Bombay. India
Designation Engineer (Campus Recruitment)
Duration Oct'94 - Feb '96 (1 year 5 months)
Functions & Responsibilities:
Manpower planning, Troubleshooting during shifts, Cross functional
Coordination
Updating production status on MAPPICS
EDUCATION:
3 B.E. Production from University Of Bombay, 1994.
TRAINING
4 Training Attended/Conducted:
Training courses Attended
Oracle Apps (11i) at Oracle Education for following modules
WIP and Manufacturing Scheduling, Supply Chain
Costing, Quality
Oracle Process Manufacturing (OPM)
Configurator
12 weeks course on JAVA At NIIT
14 weeks course on BAAN At NITIE
Training course Conducted:
ASCP fundamentals at Oracle Education
1
2 References:
References will be provided upon request.
Contact this candidate