A self-motivated professional with 2+ years IT experience as a Database Engineer by leveraging Big Data and Data Management techniques to find insights and drive business growth
-
Experience
• Evolved in a team of 50 to maintain a website using Oracle, PostgreSQL, and SAP HANA to manage business operations and services for 400,000+ employees by maintaining 100+ PROD/ UAT/ DEV databases
• Analyzed real-time trends in the large datasets using TABLEAU and SQL Programming to provide analytical solutions
• Assists with development teams to lead design efforts, ensure and validate operational feasibility of the database systems
• Maintained various Data Pipelines, and built recovery strategies to ensure data is highly available, secure, and recoverable
• Monitored and diagnosed symptoms using Enterprise Manager to maintain performance of production database and application
• Achieved 10+ Oracle Database Migration from UNIX to LINUX platform using Transportable Tablespace (TTS) and Export-Import method to streamline the functionality of the database
• Handled variety of tools such as HANA studio, Business Objects Data Services (BODS) and Sybase Replication Server (SRS) to generate financial reports
-
Projects
Bank Customer Churn Prediction
• Developed Supervised Classifier, preprocessed features with Python, evaluated 5 models Logistic Regression, KNN, Decision Tree, Random Forest, Support Vector Machine, allows to make new marketing plans to reduce the churn rate of customers
• Recommended Decision Tree, with Recall score of 98% on test data, balancing using SMOTE analysis
Machine Learning Predictions to Assist Cybersecurity Analysts
• Refined data with data mining techniques, developed 3 Supervised Classifiers Decision Tree, Logistic Regression, and Naïve Bayes, to enhance the Data Loss Detection App built for verification of alarms, empowering security analysts to deliver pertinent action
• Recommended Logistic Regression, with accuracy rate of 99% on unseen test data, using RapidMiner tool
Data Analysis of Airplane Crash Data
• Designed an efficient relational database for Airplane Crash data to analyze and assist in crisis management
• Processed crisis information using SQL based on large data volume and perfect data modeling with Entity Relationship Diagrams