FORCAM is one of the pioneers of the Industry 4.0 movement. FORCAM has introduced FORCAM Force and Advanced Shop Floor Management Technology continues to harmonize all manufacturing operations from to the top -- to the shop floor and across the global supply chain and enterprise creating the transparent factory environment. Scope of Work: FORCAM every quarter release the FORCAM Force Product with new Features and Improvements. This Product is developed in different modules and by different team. After completion of development, all the modules are merged and Carry of the Integration Testing and Release the Product.My Role: MES Product Quality Assurance includes Understanding the product specification, Writing Test Cases, Module Testing, Product Integration Testing, Ticket Management with JIRA and Test Automation PlanningKey Achievement:Perform Module Testing and Integration Testing successfully as per deadline for every releaseWith my SQL Skills, helped the team to improved performance of the application significantly

Project : MES Implementation for Constellium FranceSoftware/Tools : APRISO FlexNet 9.6 / ORACLE / Crystal ReportProject Description : To replace existing MES system called GIP (Gestion Informatisée de Production) with FlexNet 9.6 at Neuf Brisach, France with FlexNet.Scope of Work and Key Responsibilities :• Manages master data (article, BOM, Production Routing)• Manages work orders (weight confirmation, routine modification) and transfer information to planning & scheduling systems QFS/QCP• Supports quality tracking, decision (scrap, rework…), and traceability• Collects production information to transfer them to Data ware for performance tracking/Analysis

Project : MES Implementation for AGCOSoftware/Tools : APRISO FlexNet 9.4 / ORACLE / Crystal ReportProject Description : AGCO is implementing the MES with using APRISO FlexNet 9.4 Key Responsibilities :• Understand the requirements • Development according to requirement • Designing Reports with Crystal reports• Technical support after Go Live

Project : MES Implementation for Ball Packaging Europe (BPE)Software/Tools : APRISO FlexNet 9.5 / SQL Server 2008Project Description : BPE is implementing the MES with using APRISO FlexNet 9.5 across all the manufacturing plants. Under MES they are implementing the Warehouse Management, Equipment Maintenance, Tool Inventory Key Responsibilities :• Understand and Analysis of the requirements and documentation• Detailed Technical Design• Designing and Development of Module • Database Development and support

Project Name : Shared Service CenterSoftware/Tools : SAP Business Object XI and Oracle 10gDescription : Atos Origin has implemented the HPQC, Rational Clear Quest, Rational Requisite Pro and many more Applications at Atos Global Level to track their different projects Data. Some of the applications have their databases. The Project manager / higher management require the report with respect to their project time to time and for that they request us to design such report. Responsibilities: • Understand and Analysis the requirements• Database Development• Designing Reports with Crystal reports• Scheduling Reports in Crystal repot job server.• Maintaining the Crystal Report Server.Project Name : Columbus Engine Plant– PACCAR, USA – MES Implementation Tools : FlexNet 9.4 (APRISO Corporation), SQL Server 2005Description : PACCAR was implementing the new engine Plan. They have used the FlexNet 9.4 Tool (APRISO Corporation) to implement the Implementation of Manufacturing Execution System (MES) in their plant. FlexNet has its own database.Responsibilities: • Development of Time and attendance and Employee Exception Module • Database Development Understanding of issue and according to check the logic of business and apply the process solution.

Project Name : Module 3 Stabilization (M3SP) – Moody’s Investors Service, USATools : SQL Server 2000Description : Module 3 is one part of an overall IT Architecture Program of the Moody’s Investor Services. Module 3 ensure the consistency of Moody’s internal and external data and enhance efficiency. It provides a single authoritative source for all structure and ratings related data elements and lookup codes across the business lines for the Moody’s.Responsibilities: • Database Development • Understanding of issue and according to check the logic of business and apply the process solution.

Tata Consultancy ServicesProject Name : Quick Quote Service Module (QQSM) – NORTEL, USATools : SQL Server 2000Description : NORTEL mainly deal with the communications systems. QQSM is a Services Quotations System for NORTEL Users in multi regions and in multi segments. This system provides to create quotation for services for different products and their technology like Wireline, Wireless and Optical. Responsibilities: • Configuration of data as per the rule(Logic) given by NORTEL and same is implemented via Stored Procedures, Functions.• Creating the job to transfer the data• Improvement and increase the performance and quality of Database.• Maintenance activity like scheduling jobs for Backup the Database and restoring the Database and also scheduling the Indexing activity-------------------------------.Bombay Stock Exchange (BSE), MumbaiProject Name : Common Front End (CFE)Tools : C#, SQL Server 2005Description : CFE (Common Front End) System is a trading platform for users of BSE to trade in Multi exchange & Multi segments. This system is designed to provide traders to trade using single sign-on facility. It is also designed to facilitate Members with centralized access rights management (has inbuilt Risk Management Server) and enable member to have a centralized Client-level Risk Management at the Broker Office, wherein the risk for a client will be checked across all traders associated with the broker for trading carried out in all segments and on any of the exchanges, centrally at one location. Responsibilities:• Understanding the user requirements Related to BSE Market Watch Module • Software Development of the new requirements• Writing queries, Stored Procedure and Maintaining the Database

ICICI Lombard GIC, MumbaiProject Name : ICICI Lombard Online Manager (Http://onlinemanager.icicilombard.com)Tools : ASP, SQL Server 2000Description : The Online Manager is a complete in-house developed system for the entire insurance products endorsed by ICICI Lombard GIC Ltd. This system comprises of the modules ranging from issuance of Policies, endorsement, Claims, Commissioning and cancellation of policies. The system has an exhaustive 5000+ users operating for their daily business and reporting purposes.Handling Health Product on Online Manager as Software Executive. Development and maintenance of modules for various Health products. Online issuing of insurance policies and extensions of policies. Endorsement & Cancellation modules for all Health products.