DR

Dinesh Ramachandran

Lead for Part Data Interface Process (PDI) · Caterpillar India Pvt Ltd

Bangalore, KA

In My Own Words

• Working as an Advance Inventory Analyst with 10+ years of experience as a SAS Programmer.
• Overall 14+ year of work experience out of that 9+ years of experience in Banking Domain and 5
years of experience in Inventory and supply chain Domain
• SAS BASE / SAS ADVANCE certified from SAS Institute
• Good knowledge in supervised and unsupervised machine learning algorithm.
• Hands on exp in ML model deployment in Azure, AWS EC2, Google Cloud and Heroku.
• Basic knowledge about Apache Spark, Pyspark, SAS2PY & Docker
• Expertized in Python data extraction and data manipulation, and widely used python libraries like
NumPy, Pandas, NLTK, SciKit learn, SciPy, Seaborn and Matplotlib for data analysis.
• Extensive knowledge in Extracting, Transforming and Loading data from different database Source
like Snowflake, Hadoop Impala, DB2, Teradata, Oracle and MS Access
• Extensive knowledge in SQL and Python and intermediate in R and UNIX command.
• Extensive knowledge in SAS Automation, Scheduling SAS jobs, Sending email alert and notification
via options emailsys SMTP in SAS
• Created complex and reusable Macros and in same or another SAS program by Options Mstored,
sasmstore Mautosource and Sasautos
• Experience in Developing Dynamic Dashboard, Data blending and Published reports using Power BI
& Tableau and connected various data source like SAS Dataset and Oracle using R Scripts &Dataflow
• Excellent ability to train people in SAS Basics and SAS Advance.

Work Experience

Lead for Part Data Interface Process (PDI)

Caterpillar India Pvt Ltd

2015 – 2020

Bangalore, India

Caterpillar is the world's leading manufacturer of construction and mining equipment, diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives.

Roles and Responsibilities: • Worked as Lead for Part Data Interface Process (PDI) • Successfully Transitioned 6 process from US Morton Team to Caterpillar Bangalore. Process like Dealer testing, Dealer Demand Validation, PIC Simulation prod setup process, Weighted lead Time Report, PIC Value Tracker report, Dealer performance Metric Report • Actively involved in modeling project using Regression, Logistic, Decision Tree, Random forest, AdaBoost, Gradient Boost, KNN, and Clustering by K-means and Agglomerative algorithms. • Worked on data cleaning and ensured data quality, consistency, integrity using Pandas, NumPy. • Explored and analyzed the customer specific features by using Matplotlib, Seaborn in Python and dashboards in Tableau. • Performed data imputation using Scikit-learn package in Python. • Participated in features engineering such as feature generating, PCA, LDA and label encoding with Scikit-learn pre-processing. • Understanding the business problems and analyzing the data by using appropriate Statistical models to generate insights. • Developed NLP models for Sentiment Analysis. • Deployed the ML model in Microsoft Azure, AWS EC2 instance, Google Cloud and Heroku • Developed Dynamic Dashboard like DPM and PIC Value Tracker report in Tableau & PIC Ontime Order recommendation, NPI Service Loss Analysis in Power BI • Assigning work, monitor, Quality check, preparing the Team Metrics, Process document • Interaction with Process Partners on the requirement and monthly discussions on future tasks. • Understanding detailed business requirements and developing the project. • Extensive experience in 6 sigma projects as a 6 sigma Green Belt. • Trained more than 50 resource on SAS & SQL

Achievement • Received 2 Remarkable Result award for automating the PDI - Field to Field testing process and Dealer Demand Validation process for automating the reading the input files using SAS Dictionary.

Data Analyst

WNS Global Services Pvt Ltd

2012 – 2015

in Customer Insight team for client M&T Bank based at Buffalo, USA

Roles and Responsibilities: • Download the Weekly and Monthly data text files from ftp site to the local machines. • Decrypt the secure files and the import the same to the SAS Servers and create datasets. • Worked on the Daily reports and Weekly reports on the received data. • Generated Green Book report, it is a key metrics of the Bank customer • Developed sub-reports to capture and explain trends by isolating noise from data issues • Mentor for Associates and Sr. Associates in their respective MIS reports and SAS codes.

Education

MBA

Annamalai University

MBA

Bachelor's Degree in Computer Applications

Annamalai University

Bachelor's Degree in Computer Applications

Diploma in Computer Technology

Meenakshi Ammal Polytechnic

Diploma in Computer Technology