Hardware

Software Products

Tools

IBM PC with Pentium Technology

Operating Systems / Environments:

Windows XP,

Windows7 Professional and Windows8.1

Languages:

SQL, PL/SQL

RDBMS:

Oracle 9i,

Oracle 10g

ERP:

Oracle Applications 11i, R12, Oracle ASCP,GOP,Production Scheduling.

• TOAD
• PL/SQL Developer
• Oracle SQL Developer
• HP Mercury Quality centre
• Rally
• HP ITG Tool for Change Control and Tollgates approvals
• MS-Office
• Clarify
• Service Now

Project

Oracle ERP and VCP Implementation.

Customer

Confidential

Period

Confidential

Role

Lead implementer

Solution Environment

Oracle R12.1.3.8 ERP and VCP . GOP with CTP and Capacity constraint and ASCP with Demand Constraint in an ATO Manufacturing environment.

Responsibility

• Lead implementer of Oracle GOP and ASCP modules.
• Requirement gathering from end users and functional owners.
• Analysis of TO-BE process requirements and creation of design models to satisfy them like ATP Rules, CTP, Sourcing rules and assignment set ,ATP for Option based routing , Plan options.
• Configuration of GOP and ASCP modules.
• Execution of Proof-of-Concepts to establish proposed solutions and get sign-off from user.
• Preparation of functional design documentation MD50 for custom objects, preparation of Setup Documents BR 100 to be used as baseline for all setups and configuration.
• Preparation of Test scripts
• Work with Oracle for Service requests.
• Plan and Drive the Integration testing for the VCP modules.
• User support and Functional validation of ATP and ASCP during integration testing cycles.
• Defect resolution
• Work with master team to correct the data issues like BOM, Routing and Lead times etc.

Work Location s

Confidential

Project

Oracle ASCP ,GOP and Manufacturing Support and Process Improvements

Customer

Confidential

Period

Confidential

Role

ASCP,GOP and Manufacturing Modules Support and Process Improvements

Solution Environment

Oracle R12.1.3, ASCP with Distribution Planning, GOP, Discrete Manufacturing with WMS.

Responsibility

• Support ASCP,GOP Modules
• Support Manufacturing Modules like BOM, WIP, Costing, Inventory and Purchasing Modules.
• Simplifying theATP and Sourcing rules for correct scheduling.
• Process Improvements on the Planning and Manufacturing functions.
• POC for Production Scheduling.
• Establish the business process for Cycle count.
• Simplifying the OSP Business process.
• Establishing the end to end Planning to Inventory consumption to reporting Business process for Customer provided Inventory
• Identify the Simplification of existing Design and Improve the same

Work Location s

Confidential

Project

Oracle ERP and ASCP Implementation for Winston Salem, North Carolina,USA

Customer

Confidential

Period

Confidential

Role

ASCP and SCM modules Inventory, Purchasing and Order Management Functional Consultant

Solution Environment

Oracle R12 with Process Manufacturing, ASCP, WMS.

Responsibility

• Requirement gathering from end users and functional owners and identification of gaps between AS-IS and TO-BE systems
• Analysis and Categorization of Gaps and designing solutions to close the gaps
• Analysis of TO-BE process requirements and creation of design models to satisfy them
• Configuration of ASCP and Supply chain Management Modules modules Inventory, Purchasing and Order Management
• Mapping of various business functions in existing system with Oracle Application Supply Chain modules and existing custom solutions within the target ERP instance.
• Execution of Proof-of-Concepts to establish proposed solutions and get sign-off from user
• Preparation of functional design documentation for custom reports, notification System to be developed as a part of deployment as per business requirements and gap analysis/study
• Preparation of Setup Documents to be used as baseline for all setups and configurations at go-live
• Preparation of Test scripts to be followed by functional team and end-users during various testing phases of the project
• Facilitate Conference Room Pilot CRP testing and UAT with functional users and resolution of issues

Work Location s

Confidential

Project

Planners, Order to Remittance Shop floor , Inventory and Warehouse KPI's DashboardDesign and ERP Optimization and Business process changes and ASCP and Manufacturing modules support.

Customer

Confidential

Period

Confidential

Role

Solution Architect

Solution Environment

Oracle R12,ASCP,OAF,Project Manufacturing with Average Costing

Responsibility

• Requirement gathering from end users and functional owners and identification of gaps between AS-IS and TO-BE systems
• Analysis and Categorization of Gaps and designing solutions to close the gaps
• Analysis of TO-BE process requirements and creation of design models to satisfy them
• Execution of Proof-of-Concepts to establish proposed solutions and get sign-off from user
• Working with the Development team to ensure Development is as per the design.
• Preparing test cases
• Functional design document preparation

Work Location s

Confidential

Project

GE Oil and Gas Warehouse Management System WMS Go-live support

Customer

Confidential

Period

Confidential

Description

GE Oil and Gas Implemented Barcoding Solution for its existing Inventory organization for all of the Business processes I,e Receiving to Manufacturing to Sales order picking to Improve the productivity of the warehouse personnel and maximise the Warehouse Space usage.

Role

Support Member

Solution Environment

Oracle R12,Intermec Mobile Scanners

Responsibility

• Post Go live support
• User training on new System and Business process
• Preparation of SOP's for users for all the Standard business transaction as per the new System
• Providing the break fix
• SOP preparation for recurring issues
• Working with Oracle through Service requests for go-live issues
• Sanity check of the System after go-live
• Publishing the Dashboard on various transactions status for the day to the Business and IT leads

Work Location s

Confidential

Project

Mobility Solution

Customer

GE Oil and Gas

Period

Confidential

Description

GE Oil and Gas business wanted to build the Mobile Apps which can be accessed from iPhones/iPad, as a POC we build an Ontime Delivery report which reports the Ontime delivery performance of customer shipments of the Selected Quarter/s of a Selected Inventory organization in the graphical picture in various buckets and in Pie chart. Mobile App connects to Oracle ERP on real-time basis.

Role

ERP Solution Architect

Solution Environment

Oracle Application R12,HTML5,Webservices

Responsibility

• Requirement gathering from end users
• Solution Design for Ontime Delivery report
• Solution design for basic framework and front end design of Mobile App UI.
• Coordination on user testing on iPhone and iPad
• Data validation of the report

Work Location s

Confidential

Project

Product Controllership Phase1 Global Supplychain Implementation

Customer

Confidential

Period

Confidential

Description

GE Healthcare had initiated a large scale IT program called Product controllership across it's IT systems to ensure the product it makes and distributes are UDI Unique Device identifier compliant as per the FDA guidelines, so as per this, the existing Supplychain Business processes like Manufacturing and Distribution are redefined to ensure there is a traceability of the product it makes and distributes and also the parts it uses in building the end product.

Role

ERP Track Lead and Functional Consultant

Solution Environment

Oracle Application 11i WIP, Inventory, Order Management Modules eDHR MES System ,OPSM,SOA ,Oracle 9i, SQL, PL/SQL

Responsibility

• Responsible for Delivery of the ERP Track
• As is and To be Business Process flow mapping
• Responsible for Design of the Interfaces 1 eDHR a Manufacturing Execution System MES to GLPROD ERP WIP Inbound Interface 2 GLPROD,ERP to eDHR MES ,WIP Outbound Interface 3 GLPROD,ERP to Oracle Pedigree and Serialization Manager OPSM system for Shipments and RMA Interface 4 Form personalization's on the Item Cross reference and APC module to restrict the GTIN update.
• Preparation of Functional Design documents MD60
• Preparation of User requirements specification URS documents and getting the approval from the stakeholders.
• Lead and Plan the Tollgate approvals Deliverables as required by the GEHC Release Management team
• Authoring the System test scripts
• Co-ordination with Stakeholders , GE architects and IT leaders
• Documentation required for various milestones
• Communication with stakeholders.
• Ensuring the User stories deliverables are met as required in the Sprints.
• Sprint Planning

Work Location s

Confidential

Project

China Bonded Warehouse Implementation

Customer

Confidential

Period

Confidential

Role

Project Manager, Functional Consultant

Solution Environment

Oracle Application 11i BOM,WIP, Inventory, Purchasing and OM Modules Easy TMS, Web Methods,Oracle 9i, SQL, PL/SQL

Responsibility

• Pre Sales activity including negotiation of contract with client and preparation of Statement of Work
• Project Planning and budgeting Estimation of effort, cost and schedule for the project and preparation of Unified Project Plan
• Preparation of Project Induction Manual, Quality procedure and Staffing
• Leading Offshore based team peak team size of 10 members for project execution and delivery
• Preparation and maintenance of project plan
• Responsible for designing the Real-time outbound interface from GLPROD,ERP to EasyTMS application and building 4 custom reports
• Coordinating regular status calls with Clients/Business Leads
• Preparation of Work Breakdown Structure WBS and assignment of roles and responsibilities within the project team members
• Monitoring the quality of deliverables and ensuring process and audit compliance
• Coordinating regular status calls and meetings within the team
• Reporting status and health of project to customer as well as TCS Leadership team
• Risk identification, qualitative and quantitative risk analysis and risk response planning to mitigate risks. Preparation of Risk Register and Risk Management Report.
• Analysing and reporting metrics related to service levels, based on the service level agreements in the statement of work
• Appraising the performance of team members, identification of training requirements and mentoring team members

Work Location s

TCS Bangalore GE GDC,India,Beijing,China

Project

GE Healthcare MRP Implementation for Asia Sites, New Inventory org Implementation for GEHC China and Enhancements

Customer

Confidential

Period

Confidential

Role

Functional consultant

Solution Environment

Oracle Application 11i Supply chain Planning, BOM, WIP, Inventory, Costing, Engineering Modules and , Oracle 9i, SQL, PL/SQL

Responsibility

• Requirements capture, Analysis and Functional Design
• Mapping of business model with Oracle Applications standard processes of Supplychain Planning
• Setting up of Supplychain Plan
• Setting up item attributes.
• End user training on Supplychain planning
• End user support during the plan runs
• Setting up the Min/Max Planning for low cost buy items
• Setting up the new Inventory org with Standard costing where all the Supplychain modules Inventory, Costing, BOM, WIP, MPS/MRP, Engineering, Order Management and Quality are deployed and hooking the existing interfaces as part of the global design.
• Solution design for enhancements
• Data conversion
• Implementing the Changes through Full cycle change control process of GEHC.

Work Location s

Confidential

Project

GE Healthcare Oracle ERP and ASCP Global production support

Customer

Period

Confidential

Description

GE Healthcare GEHC Global Production Support is a maintenance project which is required to take care of the various Financials and manufacturing related forms, reports and custom programs for different business units of GEHC spanned globally across multilple sites and poles. The team is responsible for identifying and resolving all functional and technical issues and bottlenecks in Oracle Financials/Manufacturing/Distribution and various customized Modules/Interfaces/Tools to ensure smooth production run. The team is also responsible to handle development, enhancement and new functionality implementation requests involving Requirement Analysis, Design Document Preparation, Testing, Data/Code Migration, User Training, Documentation and Post Implementation support.

Role

Onsite Production Support Team Lead, Track Lead

Solution Environment

Oracle Application 11i, ASCP,SCP, OPM ,Oracle 9i, SQL, PL/SQL,Clarify

Responsibility

• Lead and Coordinate with TCS Production support team and other external teams of GEHC and Oracle Corporation.
• SPOC for Oracle PST for US time zone and Escalations point of contact.
• Drive till resolution any Functional and Technical issues reported.
• Module Expert for Manufacturing and Distribution Modules Change Controls.
• Support the Month end and Quarter Close
• Plan and Lead the special support events like Physical Inventory and Year end and Quarter End closes.
• Primary Support member for APSPROD of BIO where ASCP is implemented
• Ensuring the cases are updated, closed as per the SLA set by the client.
• Ensuring that defined Process followed globally by all the Production Support team members while giving the fix to a Case
• Handling Client escalations.

Work Location s

Confidential

Project

Oracle Apps Implementation

Customer

Confidential

Period

Confidential

Role

Functional consultant -Offshore

Solution Environment

Oracle Application 11i, Oracle 9i, SQL, PL/SQL,

Responsibility

• User Requirement Analysis
• To be Process Flows design
• Application Setup
• Design of Inventory Warehouse Structure.
• Providing functional support to the on-site team on issues related to Inventory and Purchasing Modules.
• Test Scenarios and UAT Criteria preparation for all the custom components.
• User training document preparation

Work Location s

Confidential

Project

Fourth Shift ERP Implementation

Customer

Period

Confidential

Description

Brady and Morris, A medium scale enterprise in to making of material handling equipment's which includes chain pulley blocks etc. and there were Implementing Fourth shift ERP for their business need.

Role

Functional consultant

Solution Environment

Fourthshift ERP

Responsibility

• Study of existing business processes in Manufacturing and Purchasing Dept.
• Mapping the same with Fourth Shift.
• Preparation of Module Walk through Document
• End user Training in Manufacturing Modules.
• Prepared Requirement Study Document RSD for new Customisations.

Work Location s

Confidential

Project

World-class Manufacturing Lean Manufacturing Tools Implementation

Customer

Stumpp Scheuelle and Somappa Pvt Ltd, Cipla Limited

Period

Confidential

Role

Industrial Engineer

Solution Environment

Lean manufacturing

Responsibility

• Improving the Productivity and Optimising the resource utilization.
• Value Stream mapping for major Products, Calculating 'Takt Time', Identifying and removing the bottlenecks through Kaizen and Designing the Work flow accordingly
• Quantifying Resources of the Company.
• Production planning controlling through Gantt chart. Integrating the Other Depts. To meet the Plan
• Developed the System to avoid First Sample Approval for the mass production through SMED Technique, which will reduce the Set-up time.
• Developed Working Progress Kanban CON WIP System, which will maintain minimum WIP based on the Capacity of the cells, thus avoiding the MUDA of over Production.
• Developed and Maintained Raw Material Kanban System, which will maintain the required Raw Material of Size, Quality and Quantity against the Production Schedules.
• Work Place Organization through '5S' activities.

Work Location s

Confidential