Siddharth Agarwal Email & Phone Number

- Created automated big data pipelines using apache hive for data science, analytics, and big data projects.- optimizing data storage, retrieval, and querying.- preparing data for ingestion in reporting software’s like tableau- creation of dashboards using tableau- conducted research on botnet data for identifying malicious DDoS attack activity.- Assisted in requirements gathering and translating them to production code.- Optimized and maintained existing machine learning models for fingerprint image classifications, such as CNNusing Python’s Keras and tensorflow to detect falsified fingerprints- Created TFRecord image data ingestion pipeline using tf.Data API, making them scalable and enabling training ofmodels with datasets larger than CPU memory- Automated training and optimization of model hyperparameters to quickly conduct and test 50 different variationsof the model, storing the results and generating automated reports- Created tooling and scripts to further data exploration efforts for other data scientists, helping them become moreeffective at exploring the data and other tasks- Productized existing TensorFlow models by converting them to tflite format, allowing integration with existing C++and android applications- Conducted Transfer Learning using ResNet 50 pretrained model by freezing the bottom layer and retraining toplayers with fingerprint images- Achieved Half Precision (FP16) training on Nvidia Titan RTX and Titan V GPU for TensorFlow 1.14

Bengaluru, Karnataka, India

• Analyzed client’s business requirements and processes through document analysis and workflow analysis for designing a data warehouse and transform the data into interactive data visualizations.• Collaborated with database engineers to implement ETL process, wrote and optimized SQL queries to perform data extraction and merging from SQL server database• Performed data profiling and data mining to cleanse the data in the database and raise the issues found.• Involved in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.• Created and modified Stored Procedures, Functions, and Indexes.• Developed SQL Scripts to Insert/Update and Delete data in MS SQL database tables.• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.• Developed firm knowledge on Excel, SQL and SAS for large dataset manipulations.• Developed key performance indicators to monitor sales and improve cost efficiency.• Developed, validated and implemented statistical models to solve strategic and challenging business problems.• Converting data models into business insights and proposing actions based on analysis.

Noida, Uttar Pradesh, India

• Worked with leadership teams to implement tracking and reporting of operations metrics across global programs• Worked with large data sets, automate data extraction, built monitoring/reporting dashboards and high-value, automated Business Intelligence solutions (data warehousing and visualization)• Gathered Business Requirements, interacted with Users and SMEs to get a better understanding of the data• Performed Data entry, data auditing, creating data reports & monitoring all data for accuracy• Designed, developed and modified various Reports• Performed data discovery and build a stream that automatically retrieves data from multitude of sources (SQL databases, external data such as social network data, user reviews) to generate KPI's using Tableau. • Wrote ETL scripts in Python/SQL for extraction and validating the data. • Create data models in Python to store data from various sources. • Interpreting raw data using a variety of tools (Python, R, Excel Data Analysis Toolpak), algorithms, and statistical/econometric models (including regression techniques, decision trees, etc.) to capture the bigger picture of the business. • Created and presented dashboards to provide analytical insights into data to the client• Translated requirement changes, analyzing, providing data driven insights into their impact on existing database structure as well as existing user data.• Worked primarily on SQL Server, creating Store Procedures, Functions, Triggers, Indexes and Views using T-SQL.