PRADEEP KUMAR G
Software Engineer
Bengaluru,Karnataka
Summary
Seeking a challenging position which provides career growth and skills enhancement.
PROFESSIONAL SUMMARY (Total: 13+ Years) .
Total of 13+ years’ experience in data automation and analytics in multiple domains.
Designed and developed various data automated applications and solutions.
Good knowledge in data analytical tools like Tableauand Microsoft Power BI.
Good Knowledge in python application development, automation, WebApps and Artificial
Intelligence. Also, good knowledge in data analytics and visualization by using python modules
like OpenCV, Pandas, Numpy, Matplotlib, Plotly and AI modules like Keras, Tensorflow &
Pytorch.
Good knowledge in BOT technologies like Automation Anywhere, Alteryx and UIPATH.
Good knowledge in MQTT, WebSocket’s event/message brokers development.
Good knowledge in SQL Server 2012, 2014, 2016 and 2019 and in Oracle DB.
o Database architecture development
o Creating and Managing Database Users & Security Roles.
o Implementing and scheduling SQL Agent Jobs.
o SQL Server Reporting Service (SSRS) Development.
Good knowledge in working with Version Control System - Git.
Good knowledge in working with Data Lake (Red Lake in Bosch).
Good knowledge in UI development, data connectivity and integrity.
Good knowledge in Web application Hosting in Apache, IIS and troubleshooting the issues
related to application pools, configuration etc.,
Have exposure to ML & AI have learnt on working with Image Recognition and classification
Have exposure to android application design and development with Flutter.
Have exposure to SAP modules in Finance, Logistics and Supply Chain Management.
Have worked with multiple domains like Banking, Finance & Controlling, Sales, Logistics, HRA,
Supply Chain Management and ICO.
Overview
14
14
years of professional experience
Work History
Senior Data Specialist
Bosch Rexroth Canada Corp
Welland
12.2021 - Current
- Working on development, and customization of Bosch proprietary application built & customized specific to
- Rexroth Corporation Canada
- Data and Web development in Thingworx, Coldfusion & Python o Working on Intelligent pick process for service (ThingWorx) (Automation of warehouse material picking process) - Industry 4.0 Projects o WebApps Development Special Pricing Agreement (SPA) Production Order tracking Tool (Application for tracking customer order) Production order Confirmation using MQTT- solace (Internet of Things (IoT)) protocol
- Working with Automation Anywhere, alteryx and Python based BOT development
- O Order Tracking Tool – Bot for SAP download, data processing and SQL upload
- O Delivery Report - Material & Customer data automation – Development of Bot for SAP
- Download, pre-processing with Python, Alteryx and process data to various destinations like
- Digital Dashboards, Applications, SQL Servers and Email Services
- Worked on development of RedLake (Data Lake) based solution to extract data from various SAP views by using SSIS package and agent jobs
- SQL Server Development, administration, upgradation, and configuration to multiple applications
- O Administrator for Multiple Database and Servers o Design and development of Database Architecture and Roles o Development of Automated Reports by using SQL Server Reporting Services, SQL Power BI reporting Service
Senior Data Specialist
Bosch Rexroth Corporation, BetP
06.2016 - 12.2021
- Worked on Data Analytics, Automation, VBA and Web development projects for various domains
- Web development in Thingworx & Coldfusion o Working on Intelligent pick process (ThingWorx) (Automation of warehouse material picking process) - Industry 4.0 Projects o Product Order Tracking(PTT) WebApps Development (ColdFusion)
- SQL Server Development, administration and Configuration to multiple applications and services o Administrator for Multiple Database and Servers, Database Architecture and Roles development o Development of Automated Reports by using SQL Server Reporting Services
- Worked on VBA application development for multiple domains a) Inventory Report Automation Application (IRAA) b) Stock Transfer Reporting Application (STRA) c) Material Picture Database Application d) Secondary Cost Allocation Module (SCM)
- Worked with Automation Anywhere, alteryx for BOT development
- O Order Tracking Tool – Bot for SAP download, data processing and SQL upload
- O Material & Customer data automation – Development of Bot for SAP Download, pre- processing with Alteryx and process data to SQL server
Senior Process Associate
Robert Bosch Engineering and Business Solutions, RBEI
03.2012 - 05.2016
- Worked on Supply Chain Management department with Data Automation, Analytics and Web development projects
- Analytics and Automation Applications: BetP/CTG, BetP/TEF, GS/BPS, PTNA, GS-MFC, I-BUY
- Successfully developed many automation tools by individual and with the team by combination of SQL,
- Tableau, VBA for internal customers in BOSCH
- With the creative ideas and right technology adoption, I reduced effort, time and improved quality in many projects
- List of data automation and reporting tools developed: a) Work Efficiency Reporting Tool b) Inventory Management Tool c) Production Planning Reporting Tool d) P-card Monitoring and Reporting Tool e) DCUS Reporting Tool f) Cost Center Consolidation Tool g) HD, Sears and Wal-Mart Debit Memo Conversion Tools h) I-Buy Order Confirmation & Order Placement Templates and SQL integration i) CP/AB7 Tracker and Department Effort trackers j) Wiki Tool for I-Buy
- Monthly Reports - GS-CPC & PT-BEU/MFP
- Supported GS-CPC for the 11 months and have refined the process steps to meet the customer requirement
- (Inventory Reports & Supplier Performance Review reports) a) Upgradation of application to latest Microsoft office applications and other related software’s b) Database integration to SQL server
- Content Management System – SHIP Web Tool (AEENP) a) Was part of the content management team for the 11 months and the responsibilities include
- Editing content on the SHIP web tool as per business need
- B) Performed 3 content releases
- C) EHB views development using web application technologies
- Initiatives
- Taken additional responsibility of Asset Manager for managing and organizing assets inside the department
- Taken additional responsibility of Effort Manager for managing effort around 100 associates
- Guiding team in multiple stages of development, supporting team in finding creative ideas and best type of solution which fits for customer requirement and in successful completion of projects
- Helping team with multi-platform training and improving leadership skills
- Achievements
- Received appreciation from BetP/CTG for the analytical tool Dynamic Cost Management
- Received appreciation from AEENP customer and from management for successful completion of
- Content Release & Editing Task
- Received appreciation from PTNA customer for Data Automation.
Process Associate
TATA Consultancy Services Ltd, Deutsche Bank
06.2008 - 02.2012
- Develop and maintenance of VBA applications for data consolidation, report preparation, MIS & Dashboard generation
- Automated report extraction from various data sources like SQL Server, MS
- Access, MS Excel
- Developed many automated solutions which helped team in improving productivity and quality
- Achievements
- Received appreciation certificates and Awards from the organization for finding process improvement from Management
- Received TCS GEMS Certificate from HR Global head for innovative idea and process improvements.
Education
MBA - Information System Management
Sikkim Manipal University
B.Sc - Computer Science, Mathematics, Statistics
Bangalore University
(Government Science
College
Six Sigma Yellow belt certification. - undefined
Skills
COMPUTER SKILLS SOPERATING SYSTEMLinux (Ubantu, CentOS), MS-DOS, WINDOWS 98, XP, 7, 8, 10, 11LANGUAGESPython, JAVA, Visual Basics, Flutter, ColdFusion, VBA Macros, phpDatabase : SQL SERVER (2012, 2014, 2016, 2017), MySQL, Oracle, MariaDBMangoDB, RabittMQ, Hive, SharedPreference, Hive, SQLiteAPPLICATIONS : Automation Anywhere, Alteryx, Tableau desktop and Server, UIpathMS-Office, Open Office, SAP, Microsoft Power BIStack Development : Flutter (Android, IOS & Web), Python (Flask, Django, FastApi)Git, MQTT, WebSockets, RestAPI, Micro Servers, Structured Data(YAML, XML, JSON)Frontend Development : HTML, CSS, Java Script, Thingworx, Dreamweaver, JoomlaPython WebApps(Flask, Django), Photoshop, Adobe XD
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Advanced (C1)
Tamil
Advanced (C1)
Hindi
Advanced (C1)
Telugu
Intermediate (B1)
Timeline
Senior Data Specialist
Bosch Rexroth Canada Corp
12.2021 - Current
Senior Data Specialist
Bosch Rexroth Corporation, BetP
06.2016 - 12.2021
Senior Process Associate
Robert Bosch Engineering and Business Solutions, RBEI
03.2012 - 05.2016
Process Associate
TATA Consultancy Services Ltd, Deutsche Bank
06.2008 - 02.2012
MBA - Information System Management
Sikkim Manipal University
B.Sc - Computer Science, Mathematics, Statistics
Bangalore University
(Government Science
College