Ramyasai Kristam

Passionate Software Engineer with 3 years of professional experience building Finacle Applications with a demonstrated history of working in the information Technology and services industry with Agile Methodologies.
Proficient in SQL and Python

CERTIFICATIONS:

• Master SQL For Data Science from Udemy
• Hive to Advance Hive Certification from Udemy

PROJECTS:

Exploratory Data Analysis in Python:

• IMDB Movie Analysis using Numpy and Pandas
• Credit EDA CaseStudy : To identify patterns which indicate if a client has difficulty paying their installments which may be used for taking actions such as denying the loan, reducing the amount of loan, lending (to risky applicants) at a higher interest rate, etc.

Clustering :

• HELP International is an international humanitarian NGO that is committed to fighting poverty and providing the people of backward countries with basic amenities and relief during the time of disasters and natural calamities. It runs a lot of operational projects from time to time along with advocacy drives to raise awareness as well as for funding purposes.

ETL Project for ATM Transaction Analysis Using Spark SQL:

• Making a Snowflake Schema for given ATM transactions data using SPARK SQL Queries
• Loading the data into REDSHIFT Cluster
• Analysis done using SQL Queries on
• Number of ATM failures corresponding to the different weather conditions recorded at the time of the transactions and number of overall ATM transactions going inactive per month for each month
• Most active day in each ATMs from a particular location.
• Top 10 ATMs where most transactions are in the ’inactive’ state and number of failed ATM transactions across various card types
• Top 10 ATMs with the highest total amount withdrawn throughout the year etc....