Saju Malayil

Leading a team of highly skilled Data Scientist in developing an early warning system gleaning insights from quality/warranty and social media data to identify emerging issues using tools like Python, Pyspark, Alteryx and QlikView. This analytic has impact in multiple areas (Quality, Product Development, Manufacturing etc.) of the enterprise. Democratize data science tools (Alteryx, Tableau, QlikView) with various Business Partners to facilitate better and more accurate Business Intelligence products while reducing workload. Managing global team of four to deliver results. Lead the transition from the business intelligence model to an Analytics model for the descriptive analytics team. Lead a team of Data Scientist in various projects transitioning some of the earlier BI reports to full blown Analytics using Alteryx for data munching and QlikView for visualizations. Developed the curriculum and lead the Analytics Boot camp, a nine-day training program, for GDIA where we focus on modern Data Science methodologies and tools. Trained 2000+ employees around the world to create business analytic solutions.

Developed and implemented Production Inventory Analytic System (Snurk) within North American Manufacturing Operations. Developed using Microsoft SQL server, this application links multiple relational databases (Oracle, Teradata, Informix etc.) and various Excel data sources into a one stop shop for information relating to Production and Non-Production inventory, Timekeeping and Internal Control organizations. This application has facilitated in over $100 million cash flow improvement and a $20 million year over year cost savings. Designed and developed an application that integrated Microsoft SharePoint, Microsoft Access and Microsoft SQL server to support the Manufacturing internal control organization with the requirements relating to the Sarbanes Oxley regulations. The three different technologies were used due to the internal system limitations. Designed, developed and implemented a global daily cost reporting for Manufacturing plants on labor, overhead, supplies, scrap, obsolescence and production counts. Process interfaced with over 35 different systems, harmonized the data, provided a user interface for target setting, three levels of reporting (total plant, manufacturing area, and transaction detail) and provided the data before morning start up meeting. Tools used included Microsoft SQL Server Reporting Services, Oracle SQL, SQL Server and Microsoft Excel for target setting. Developed a streamlined application to manage the Scrap revenue billing process. This process audited the revenue earned by the sale of scrap materials generated by plant operations. At the heart of the new process was a Microsoft Access Application to manage the audit process, an Excel application to control the generation of the Price Index file and Excel files as output used by the Inventory Analysts at the Plants to audit the process.

Developed various Database applications that support the day to day operations of the Controllers office at Sterling Axle Plant. Developed a Microsoft Access application to manage the planning of weekend labor resources. This data was previously managed using scattered Excel files and consumed an entire weeks’ worth of for an analyst. After implementation, the task was able to be completed in a day and with greater efficiency.

Developed various Database applications that support the day to day operations of the Controllers office at Sterling Axle Plant. Plant Labor and Overhead system comprised of a Microsoft access application that interfaces with multiple Oracle and SQL server databases and generated a slew of performance and operational reports that supported multiple plant organizations like Finance, MP&L, Operations and Quality to name a few. This application was built using Visual Basic for applications (VBA) and incorporated system generated emails for delivery of report and messages relating status of process. Developed a Visual basic application (called the Quickie) that served as the portal for the Labor and overhead reports for the users outside of the Plant controllers office. This application was built from the ground up using Visual Basic and ActiveX controls.

On contract to Ford/Visteon Supporting various internal reporting and internal control applications.