Engineer Developer

Arijit Panda

480-***-**** **********@*****.*** arijit7978 Arijit Panda (OPEN TO RELOCATE ANYWHERE IN USA)

Education Arizona State University Tempe, Arizona MASTEROFSCIENCEINCOMPUTERSCIENCE (GPA: 3.8) August2019-Present

College of Engineering & Technology (BPUT) Bhubaneswar, Odisha

B. TECHIN INFORMATION & TECNOLOGY (GPA: 3.35) August2012-May 2016

Experience

DATA ENGINEER Tata Consultancy Services Hyderabad, India

FRONT-END DEVELOPMENT: (Role: Front-End Developer) Dec 2018 – July 2019

• Worked as a Front-End Developer for developing a spring boot application and followed MVC model for creation and deployed to Amazon EC2 servers. Reduced server response time with JavaScript startup optimization. Mainly plain JavaScript was used for development of the application.

DATA ANALYTICS: (Role: Business Intelligence/ Data Warehouse Engineer - ETL Developer) Sep 2017 – Dec 2018

• Worked as a team lead in analyzing and Identifying impacted objects due to table manipulations in upstream and prepared the lineage. Accordingly, I developed required ETL processes in Informatica to handle most of the alterations in system.

• Developed multiple PLSQL stored procedures to synchronize the new data as well as the functionality with the former system. It improved the performance by 80 percent and reduced manual efforts. The project was highly appreciated by the customer as well as from TCS management.

DATA CLEANSING & MIGRATION (Role: Data Engineer) July 2016 – Sep 2017

• Designed ETL processes in Informatica to capture data from various sources and transfer them according to business logic to uncover business trends.

• Migrated the SAS functionality to Informatica by Converting all the SAS code into SQL queries and then implementing the ETL processes to imitate the same functionality in Informatica.

• Prepared complex SQL queries, which were required to prepare the ETL processes as part of SAS to Informatica migration. Improved multiple ETL processes by implementing several techniques like session/Database partitioning etc.

DATABASE DEVELOPER INTERN Iguru Solutions Kolkata, India

May 2015 - Jun 2015

• Worked as a PL/SQL Developer and wrote procedures for effective insert update delete operations instead of multiple SQL queries.

Projects

SECURE BANKING SYSTEM (SBS):

• Developed a skeleton secure banking system (SBS) with limited functional, performance, and security requirements for secure banking transactions and user account management.

• This project involved working in Flask, react, Postgres and implementing the security features. Some of the security features are two factor authentication, OTP, PKI and CA .

IMAGE DATA RETRIEVAL/RECOGNITION FROM 11K :

• Implemented various image feature extraction models such as Color Moments, LBP,HOG, SIFT and dimension reduction techniques such as SVD, PCA, LDA and NMF to perform several operations like efficiently retrieve similar images, find labels etc. according to the user given image.

• Performed numerous tasks such as image labeling, clustering, classification and relevance feedback by implementing LSH, PPR, K-means, SVM, Decision Tree and probabilistic relevance feedback system. These tasks have been completed without using libraries for SVM, Decision Tree and PPR.

VALIDATING FEATURES AND LABELING (MEAL VS NO MEAL) ON CGM DATA:

• Extracting relevant features from glucose level time series data and checking which features are selected after dimensionality reduction in

PCA. Constructed a model to predict labels (Meal vs No Meal) through classification and clustering on reduced dimension space.

AI PACMAN:

• Implemented general graph search and game tree algorithms using Python to solve the corresponding problems modeled in Pacman.

• Utilized reinforcement learning to train Pacman on large complex grids in the presence of adversaries. Here I have also cultivated value/policy iteration algorithms along with Qlearning. Implemented gradient descent optimizers to train neural networks by TensorFlow.

Skills

PROGRAMMING, LIBRARIES, ETL, REPORTING & SCHEDULING TOOLS: Python, SQL, PL/SQL, C/C++, Java, JavaScript, HTML, CSS, Flask, Postgres, MongoDB, pandas, NumPy, OpenCV, scikit-learn, jupyter notebooks, TensorFlow, Informatica, OBIEE, SAPBO, Control-M, Agile, D3.js, Tableau

Additional Experiences/Awards

• Oracle certified associate (OCA) for database administration. Secured good rank in OJEE (among top 2% in Odisha State). I Qualified for multiple merit-based scholarships such as CAFAS, CET merit-based scholarship and NRTS.

• In undergrad as part of a Zairza technical club member I taught SQL, Python and Database Administration and also conducted several coding events. Also worked on various projects in the NSS (National Service Scheme) to help countless people in flood-affected areas.

Contact this candidate