Nitin Saini

Title : Automation for health check of OFSAAI installed environment
Duration : January 2015 to present
Technology : Shell Scripting and JAVA

Development of a shell script to do the following tasks:
• Fetch all the necessary information from the client’s environment and database required for proper functioning of OFSAAI
• Fetch all the required logs from the client’s environment required by support team to check for the issue in any module under OFSAAI
• Perform… Show more

Title : Automation for health check of OFSAAI installed environment
Duration : January 2015 to present
Technology : Shell Scripting and JAVA

Development of a shell script to do the following tasks:
• Fetch all the necessary information from the client’s environment and database required for proper functioning of OFSAAI
• Fetch all the required logs from the client’s environment required by support team to check for the issue in any module under OFSAAI
• Perform necessary checks and recommend client to make changes in the environment after analyzing the environment variables

Development of JAVA based utility to perform the following tasks:
• Check for necessary values at all the location in the client’s environment and provide a recommendation based on that
Show less

Title : OFSAA Global Support for Infrastructure
Client : ING, NAB, AMEX, BARWA, WELLSFARGO, HDFC, CITI
Duration : September 2013 to present
Technology : OFSAA 7.3.x, OFSAA 8.0, Web logic10.3.5, WebSphere Application Server 7.0.0.x, Tomcat 7.0.x, Oracle SQL 11g/PL-SQL, OBIEE, XML and UNIX

Roles and Responsibilities
• Analyzing and solving the configuration issues related to infrastructure.
• Root cause analysis for the Client… Show more

Title : OFSAA Global Support for Infrastructure
Client : ING, NAB, AMEX, BARWA, WELLSFARGO, HDFC, CITI
Duration : September 2013 to present
Technology : OFSAA 7.3.x, OFSAA 8.0, Web logic10.3.5, WebSphere Application Server 7.0.0.x, Tomcat 7.0.x, Oracle SQL 11g/PL-SQL, OBIEE, XML and UNIX

Roles and Responsibilities
• Analyzing and solving the configuration issues related to infrastructure.
• Root cause analysis for the Client Issues.
• Strong in DEFQ, Data Quality Framework, Rules Framework, Security Management, External Scheduler (ESIC).
• Installation and Upgrade of OFSAA and its applications like LRM3.0, BASEL6.X, and GL3.0.
• Upgrade of Infrastructure from 7.2.x to 7.3.x, then higher versions.
• RPD deployment as a part of OBIEE.
• Identified many critical bugs and reported the same to the development team and followed up with DEV.
• Giving Guidance to the fresher’s about the OFSAA Infrastructure.
Show less

The project aims and design and development of solar powered two wheeler. The vehicle uses Brushless DC motor ( 48 Volts, 750 watts) and is powered by four 12 V lead-acid batteries connected in series. MPPT control algorithm is implemented with Buck-Boost converter to harvest solar energy that can be used to charge the batteries. Over voltage protection and low voltage cutoff are also provided.

The project aims at development of a vehicle which works in two different modes:
1. User controlled
2. Autonomous

1. Predicted if a customer is going to repeat a certain transaction when a certain offer is provided
2. Reduced customer transactions dataset with 350 million transactions to 30 million that were useful for training the model
3. Developed a Tableau Dashboard for exploratory data analysis of the products on offer and customer behavior on those offers
4. Created 26 additional features for each customer for the companies, brands and categories were on offer
5. Conducted K-Fold Spot… Show more

1. Predicted if a customer is going to repeat a certain transaction when a certain offer is provided
2. Reduced customer transactions dataset with 350 million transactions to 30 million that were useful for training the model
3. Developed a Tableau Dashboard for exploratory data analysis of the products on offer and customer behavior on those offers
4. Created 26 additional features for each customer for the companies, brands and categories were on offer
5. Conducted K-Fold Spot Check analysis to train 18 models & identified Gradient Boosting Classifier with the highest accuracy of 74.3%
6. Designed pipeline to optimize the model using hyper tuning parameter and improved the efficiency to 75.2% Show less

1. Designed my own startup’s database in Oracle DB to keep track of inventory, billing, users and licenses on the platform
2. Created an enhanced entity relationship diagram for the business model & developed a SQL script to create all the tables and insert the necessary data using stored procedures & sequences
3. Designed SELECT statements to fetch output of 15+ business queries being used on a daily basis at the startup

1. Utilised 2 years of time-series data of a solar photovoltaic system in India to forecast energy based on weather conditions
2. Transformed time-series dataset to non time-series & sanitised it based on business understanding
3. Ran a linear regression model [full & reduced] in R to predict the energy of solar photovoltaic system & achieved ~85% efficiency on validation & test data set based on residual analysis
4. Analysed all model variations using R-square, RMSE, MAE, AIC, BIC… Show more

1. Utilised 2 years of time-series data of a solar photovoltaic system in India to forecast energy based on weather conditions
2. Transformed time-series dataset to non time-series & sanitised it based on business understanding
3. Ran a linear regression model [full & reduced] in R to predict the energy of solar photovoltaic system & achieved ~85% efficiency on validation & test data set based on residual analysis
4. Analysed all model variations using R-square, RMSE, MAE, AIC, BIC, ANOVA to identify the best model Show less

1. Utilised 4 years of data of Airbnb listings in Paris to predict the optimal price of new listings in that area
2. Cleaned the dataset by removing missing values, outliers, unwanted attributes, multicollinearity to get a final dataset with 45000 records and 16 attributes
3. Ran linear regression, decision tree, neural network and kNN models in JMP to predict the optimal price of new listings
4. Compared all the models using R-square, RMSE, AIC and BIC to eventually choose the linear… Show more

1. Utilised 4 years of data of Airbnb listings in Paris to predict the optimal price of new listings in that area
2. Cleaned the dataset by removing missing values, outliers, unwanted attributes, multicollinearity to get a final dataset with 45000 records and 16 attributes
3. Ran linear regression, decision tree, neural network and kNN models in JMP to predict the optimal price of new listings
4. Compared all the models using R-square, RMSE, AIC and BIC to eventually choose the linear regression as the best model
5. Identified that the dataset needs to be divided into low price and high price listing segments to deliver the best results in each segment with different models outputs Show less

Developed a system which use solar energy to light up one LED bulb, a small fan and a mobile charger by using solar PV panels. The system efficiently converts solar energy to electricity and is stored in battery. The system is rugged, modular and uses less space than the usual when not in use.

This Project is based upon the advanced use of occupancy and motion sensors in our day to day lives. Here, we are using it to compile how much amount of electricity is wasted everyday. Hence the device is programmed such that it automatically switches off the lights when unoccupied. The amount of energy saved by this device can be calculated with the help of a data logger device (also designed by us).

- Content creation for social media marketing