- Created process maps and decision trees to map logic for optimizing and finding inconsistencies in financial metrics, such as cost, profit, demand, etc.- Identified and addressed root causes for negative profitability in the supply chain, leading to a 15% increase in overall profitability.- Implemented automation algorithms using SAS from process map logic utilizing historical big data, paving way for processing of almost million parts per day rather than the usual 2-3 parts manual inspection per day.- Implemented text file database on shared drives, importing data from DB2 mainframe tables and Teradata tables, for a subdivision in Caterpillar using SQL via SAS, IBM QMF, Teradata, and Microsoft Access.- Used custom SQL and calculated fields in Tableau to create financial dashboards and other visualizations from connections to remote DB2, Teradata tables.- Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart, and refresh strategies.- Design and development of different data models according to user specifications in the development of databases for small applications.- Used Kafka producer to ingest the raw data into Kafka topics run the Spark Streaming app to process clickstream events.- Implemented a text file database on shared drives, accommodating a diverse set of data types and sources, resulting in a 30% improvement in data retrieval efficiency.- Designed and implemented time series forecasting models for estimating server provisioning on the cloud environment which resulted in accurate demand forecasting for cost optimization and budgeting.- Implemented Agile Scrum methodology, leading to a 15% reduction in software development life cycle durations and faster delivery of quantitative value-driven features.