My Portfolio

About me

Database and Data Engineering professional with 9+ years of experience specializing in database design, architecture, data engineering, data analytics and visualization techniques.
Recognized as thought leader with expert ability to successfully implement end-to-end architecture and design of database and cloud for OLTP, analytics and reporting applications
Illinois Institute of Technology Master of Science in Data Science alumni with major focus on Big Data Technologies, Machine Learning, Natural Language Processing, Bayesian Computation, Data preparation and Analysis and Project Management
Worked as Database expert with projects involving Database design, development, migration, upgrade, maintenance and management of different database platforms
Worked on various Data Science projects involving Big Data Technologies, Machine Learning, Natural Language Processing and Bayesian Computation
Proficient in Database administration, performance tuning, capacity monitoring, data security, backup and recovery of major commercial database engines (Oracle, Greenplum, PostgreSQL, Mongodb, MySQL,and Microsoft SQL server)
Proficient in Oracle RAC & ASM Administration/Installation with multitenant architecture, SQL Tuning in an Oracle Environment and Standby/Failover Administration
Proficient in data analytics and visualization techniques using python, R and tableau
Experience in Amazon RDS, Lambda, Redshift, Data migration Service (DMS), s3 bucket and glacier configuration
Solid knowledge and experience in programming languages: Python, R, SQL, PL/SQL, Shell
Website development using HTML, CSS, JavaScript to automate the monitoring of databases, server and report viewing
Worked on global delivery model (onsite - offshore model) for 5+ years
Worked in the Waterfall and Agile Scrum methodologies
Worked in Advertisement and Banking domain

Experience

Capital One, Chicago, United States

Database Architect

Designed, developed and implemented metadata auto registration tool for various datasets (including tables and S3 files datasets)
Implemented Serverless architecture using AWS lambda, S3 buckets, HTML, CSS, javascript, DynamoDB, API gateways with Snowflake
Managed and developed metadata registration dashboard using Tableau, Python, Snowflake and AWS EC2

Mediaocean, Pune, India

Database Architect

Led data services team in successful upgrade of Oracle and Greenplum databases for end-product
Performance tuned and redesigned ETL queries to reduce the overall completion time by 60%
Assesses application, environment, network, or storage issues and makes recommendations to improve overall performance
Work to establish best practice and methodology in the area of architecture, design and development
SQL Tuning including analyzing existing code and providing recommendations for improvement
Architecture design & development of ETL in Talend to load the transaction data from Oracle to Greenplum
Design and development of complex and interactive reports and dashboard using Tableau software
Research database technology, propose changes & develop database platform-based implementation plans
Advise management on technology purchases, environment upgrades and future projects
Introduced & successfully implemented AWS RDS, EC2, redshift and DMS services
Created database standards allowing for rapid deployment, optimum performance & business customer flexibility using RAC, ASM, Data Guard and 12c Multitenant architecture
Provided direct assistance to leadership team in acquiring a business deal breakthrough with vendor partners
Responsible for development, design, maintenance and management of Oracle, Greenplum, Mongo, MySql and Microsoft SQL Server databases

Atos, Pune, India

Consultant

Design, development and implementation of database systems, backup and recovery process
Optimize database systems for performance and operational efficiency
Provides database support by coding utilities, responding to user questions, and resolving problems
Responsible for building and deploying database updates to real-time production, working with several environments and QA process

Tata Consultancy Services, Pune, India

IT Analyst

Tuned queries and database, performed backup/recovery, data export/import using Data Pump, authentication, auditing, database monitoring, patch installation and other DBA tasks (24x7 support)
Designed and implemented security monitoring tool to capture real time alerts
Website development using JSP, Oracle for report viewing & download in .gz format of more than 1300+ branches
Fine-tuned oracle financial application queries to reduce query time by 80%
Upgrade Oracle E-Business Suite from 11.5.10.2 to 12.1.3
Led 12 members of Database & System admin team & responsible for task assignment training & performance
Maintain, tune, monitor and administer development, stage and production databases; including application integration points
Daily, Weekly, Monthly and Quarterly backup policy implementation. Backup type includes Flash copy, RMAN Tape Backup, Expdp utility
Data Guard setup on RAC and NON RAC with Oracle 10g and 11g
Database migration from old hardware to new hardware with less downtime
Periodically perform DC-DR Drill (Physical Standby Database switch over)
Responsible for backup and testing the validity of backup on test instance, including RMAN Backup and Recovery

Resume

Projects

Chicago Crime Dataset Data analysis

Built prediction model for predicting type of crime irrespective of preparator using logistic regression model and random forest classifier, the predictive model achieved an accuracy of 63 %.

Technology : Python, R , Apache Pig, Apache Hive, Apache Spark, Hadoop and HDFS

Code

Bayesian Prediction on Game of Thrones Book Series

Used Bayesian computational analysis to make predictions for the number of chapters told from the point of view of each character in the next two novels of George R. R. Martin’s A Song of Ice and Fire series by fitting a random effects model to a matrix of point of view chapters of earlier novels.

Technology : R, Python

Code

Text classification model to address the task of native language identification

Trained a text categorization model using BERT in order to predict the native language attribute of data. Used trained model to make predictions on data, produced appropriate evaluation metrics for each class, and identified the frequencies of misclassifications between each pair of classes.

Technology : Python

Code