Data Engineer

• Aug 2018 - Present

IT Assistant

• Aug 2016 - Jan 2018

 Worked as an IT Assistant and done research under analytics in InterLabs Research institute and to develop an in-house tool for the Bradley University called Learning Analytics.  This tool notifies students, their performance in an academic year. It takes input from the professors through grades, assignments etc. Through these factors the tool would give an overview of the student’s performance in his class by letting him view his level by skills, by his grades, by his peer-peer review etc. • Researched on various analytical tools such as Tableau, Google Analytics etc to imitate their dashboard in our tool with high end functionalities. • Designed the tool using Python on Django Framework and developed scalable applications, built reusable code and libraries for future use. • Worked on Relational Database design (RDBMS) and wrote, executed various MYSQL database queries from python using Python-MySQL connector. • Used Object-Relational mapper (ORMs) like SQLAlchemy for data abstraction and manipulation, built all database mapping classes using Django models. Worked on Requests, NumPy, SciPy, and Pandas python libraries Show less

Software Developer

• Aug 2015 - Jul 2016

 Datapoint is a Software Development company that deliver high quality Business Management Solutions, Custom Software Solutions, Application Development, Project Management, Software Testing and Quality Assurance.  Key projects include build and maintain remote events website, build and maintaining library database, etc for the University client. ▪ Primary focus of development involved client-server (front end/back end) database applications. ▪ Designed user Interfaces, Web pages, Web forms using HTML, CSS, Java Script, Bootstrap. ▪ Gained knowledge in MYSQL, Oracle 11g and worked on complex queries using joins, views, stored procedures and triggers. Show less

Summer Internship

• Apr 2015 - Jul 2015

▪ Developed and created the new database objects including tables, views, index, stored procedures, ability to perform tasks under functions, triggers, advanced queries and updated statistics ▪ Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases ▪ Database monitoring, performance tuning, high-availability strategies with SQL Server 2012. ▪ Got working knowledge of Microsoft SQL Server Management Studio 2008, 2012 ▪ Database Replication, Database Mirroring Performance/Tuning MS SQL Server ▪ Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options. Show less