Ankur J

ANKUR JYOTI BHATTACHARJEE E-mail- B-Tech. (ISE) Ph: - --------------------------------------------------------------------------------------------------------------------------------------------------- About Me: - Projects & Operations with competent skills, Determination, Dedication and Discipline. Education: - BTech. In Information Science Engineering.S.E.A College Of Engineering, Bangalore (Viswaswaraya Technological University) 12th Swadeshi Academy, Guwahati (SEBA) 10th BBES, Guwahati (SEBA) Personal: Hometown: Katahbari ,Guwahati, Assam INDIA Language: English, Assamese, Hindi,. Technical Skills: Programming JAVA, VISUAL BASIC, DBMS Web based Development Languages: HTML, CSS, BOOTSTRAP, JAVASCRIPT, JQUERY, PHP Server: MS-SQL, MYSQL, Apache Hosting: C-panel, Wordpress, JooMla Operating system All Windows OS,Server,2012, LINUX,FEDORA,UNIX,UBUNTU,Raspberry Network DNS Management, IP configuration/troubleshooting, Security, Firewall configuration. Tools Wonderware: Intouch, Historian Server, Historian Client, Archestra Toolkit, Skelta BPM, Application Server, Device Integration, Wonderware MES Dream Report Microsoft: MS Sql, Visual Basic, Adobe PS, .NET, MS VS-asp.net Siemens: TIA Portal, WinCC Flexible, WinCC Comfort, WinCC Basic. Mitsubishi: E-Designer, IX Developer, EX Works OPC: KEPWARE, TOP SERVER, Matricon OPC Software Skills:- PLC: - Siemens, Allen Bradley, Schneider Electric, Mitsubishi,Fanuc,Toshiba, Sanyo Denki ,Sanmotion CNC Machines:- Fanuc, Matsui,Tsugami,Nitokku,Fanuc.(Integration) SCADA: - MC Works64, WinCC v7.4, FT View, GE-Cimplicity, Wonderware Intouch 2017,Simatic IT(UADM). DRIVERS: - KEPWARE, TOP SERVER, Matricon OPC,IGS Gateway. HMI: - Siemens, Allen Bradley, Schneider, Mitsubishi, Fanuc. VFD: - Siemens, Allen Bradley DATABASE: - Ms SQL, MySql,MongoDB,Oracle DB. Reporting: - SSRS/SSDT,PowerBI,Dream Report Non-Technical: ¤ Honest and Hardworking. ¤ Willingness to learn ¤ Ability to rapidly build relationship and set up trust. ¤ Good team player. ¤ Good communication skills, optimistic and positive attitude. CERTIFICATIONS: ¤ CSP Wonderware Intouch. (Schneider Electric) ¤ CTP Wonderware Intouch 2014R2 SP1.(Schneider Electric) ¤ Application Server.(Schneider Electric) ¤ Historian. .(Schneider Electric) ¤ Device Integration.(Schneider Electric) ¤ Certified in Computer Applications. WORK EXPERIENCE: ❶ 18 months experience as an Software Engineer at Dalisoft Technologies Pvt Ltd.(Bangalore) From the Period of Aug 2018 to Feb 2020. Projects: 1. Digitization of Chassis Assembly Line 1 & 2 Company: Ashok Leyland,Hosur India Scope of Work: ●Logically Tracking Every Chassis on the line Vin Number wise.(Barcode scan at 1st station) ●Capture all the CTQ’s associated with the Vin. ●Integrated with ERAD, Atlas Copco & Dai-Ichi Torque tools & Nut Runners using Tool logic on AB Data Concentrator. ●SAP Integration for Production planning with MC Works. ●Directly integrated with Marks Pryor Marking Machine using serial communication. ●Developed an .net Console Application to upload Vpart or Model Part type list in an excel format and store in a SQL database. ●Tracked the vehicles using conveyor indexing on the line of 18 stations. ●Programmed newly added indexing proximity on the 2nd conveyor. ●Added Interlock for every process until operation gets completed. ●Conveyor Stoppage Downtime. ●OEE. ●Auto report generation at the end of line for every completed vehicle. ●Data Logging using VB.Net. ●Jscript for Screen functionality,Cusomised Dropdowns,etc. Tools used: Mc Works,Mx-Opc server,ScriptWorks(VB.Net),J-Script,Kepware,SSDT,VS2019,MsSQL,RS Logix 500 & 5000,Studio 5000,Siemens Simatic manager,GX &GT Works. 2. Performance Management & Production Management(Bosch & Metz Line). Company: Carbodium Universal (Murugappa Group),India ●Integrated 4 Machines, Monitored Poke yoke activities, production related data’s & Critical Parameters. ●Build up Performance & Production modules for OEE,AR,PR & QR. ●Developed the whole OEE dashboard on SSRS used SQL Stored procedures for calculation. ●Modified HMI for Operator Login,Reason Entry, Breakdowns,Losses,Sub-Losses,etc. Tools used: AB FactoryTalk View,Kepware,SSDT,VS2019,MsSQL,RS Logix 500 & 5000,Studio 5000. 3. Yard Management System. Company: Bajaj Auto Ltd. Waluj India ●Managing of every Vehicles on the lot,Which are to be loaded on the assigned truck for delivery. ●The whole ground consisting of around 30-50 thousand of 2wheelers of different models. ●All two wheelers are associated with RFID Tags where models and Chassis no. can be identified and accordingly arranged as per the plan. ●Every Vehicles are marked on the designated location, by the operators and managers using handheld device. Developed Gyro Cad marking application for android handheld devices. Helps in finding the vehicle. Tools used: Mc Works,Mx-Opc server,ScriptWorks(VB.Net),J-Script,Kepware,SSDT,VS2019,MsSQL,RS Logix 500 & 5000,Studio 5000,Siemens Simatic manager,GX &GT Works. 4. PPMS implementation on Fuel Injection Line. Keihin Fie, Bangalore ●Integration with CNC Machines. (Matsui, Tsugami, Nitokku,Sanmotion,Brothers) ●Total 70 different machines taken under scope. ●Hardwired some of the signals from CNC Machines into Data concentrator PLC. ●Shop floor screen displaying OR,Actual Production of each Machine,Machine status,Real time monitoring. ●Developed HMI screens for each machines.Operator login,rejection entry,downtime reason entry,production planning, etc. ●Rejection trend,Downtime chart,Operational Ratio chart,Stock Chart,Operator performance. ●Reporting done in SSRS. ●Developed Console application for SAP data manipulation into MSSql database. Tools used: Mc Works,Mx-Opc server,ScriptWorks(VB.Net),J-Script,Kepware,SSDT,VS2019,MsSQL,GX & GT Works. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- DECLARATION: I state that the information furnished above is true and complete in all respect to the best of my knowledge. Date: Place: (Ankur Jyoti Bhattacharjee)