Nikhil Agarwal Email & Phone Number

New York City Metropolitan Area

Washington, District Of Columbia, United States

Washington, District Of Columbia, United States

Greater Pittsburgh Area

Practical data science research focused on using satellite images to map poverty.• Created a unique dataset from satellite images (using Google Static Maps API) and census information of Pittsburgh• Classified the images using Convolutional Neural Network, a deep learning technique• Computed useful image features with a pre-trained VGG-16 network and then classified the images by wealth level• Releasing the dataset for extended analyses

Pittsburgh, Pennsylvania, Usa

Graduate Research position with the Department of Civil and Environmental Engineering (CEE):• Engineered the data-pipeline to automate the retrieval of data sources using Python and SQL Server 2016

Pittsburgh, Pennsylvania, Usa

Teaching Assistant for the course Database Management (95-703):• Held office hours and SQL Labs to assist students with assignments and database concepts• Graded homework assignments, projects, and exams

Kuala Lumpur, Malaysia

• Proposed predictive maintenance for HILTI tools and researched implementation using Hadoop• Developed skills using Hortonworks Hadoop Sandbox on HDFS, Hive, Pig, MapReduce, YARN, Spark and Zeppelin• Used Python’s NLTK package to perform data cleaning of English and German Customer Care Notes (CCN)• Analyzed CCN using k-means algorithm to generate clusters of top 10 topics

Pune Area, India

Role: Business Intelligence Developer• Using Informatica, UNIX scripting, Batch scripting, PL/SQL, Autosys & BIRT tool for development and performing Unit testing • Automated Portfolio creation and management system using Informatica, saving 10 man-hours a month • Optimized Informatica workflow to improve the performance, saving approximately 10-12 hours of processing time per month • Developed interactive reports using Business Intelligence and Reporting Tools (BIRT) and embedded it in clients application; provided the client with a potential business profit of approximately $1.5 million • Effectively used Autosys to periodically schedule Informatica tasks, batch scripts and UNIX scripts • Documented the existing process and created a knowledge repository about the BIRT Reporting tool for future reference. • Responsible for gathering client requirements, preparing high level design documents. Worked on project in waterfall and agile methodology; worked through all phases of SDLC • Experience in working with geographically distributed teams located in London, Zurich and Singapore • Optimized and standardized the reporting process for Infosys FSICSI portal by using Qlikview and IBM's Cognos • Led independent R&D efforts to Implement BI Reporting on Mobile platforms like Android, IOS, Blackberry and Windows; presented the idea in Infosys to Senior Managers, receiving appreciation for innovative thinking Role: Trainee• Trained on Business Intelligence in Infosys and secured a CGPA of 4.5/5 in training assessment • Subjects included: MS SQL Server 2008, UNIX and Scripting Language, Intro to BI Framework DW and Applications, Advanced Microsoft Excel, Multi-dimensional Data Modeling concepts, Data Integration - Transformation (ETL) and Quality, Microsoft SSIS, Data analysis and metric management, Microsoft SSAS, BI Practice methodology and DW Administration, Enterprise reporting using IBM’s Cognos

Mumbai Area, India

Role: Website Designer and Developer• Responsible for creating presentations and gathering requirements from clients distributed geographically throughout India• Worked on Photoshop for designing web templates and Dreamweaver for developing websites• Created Web UI pages using HTML, HTML5, CSS, XHTML• Enhanced the design of websites to a responsive layout that can be viewed on different screen resolutions

Master’S Degree

Bachelor'S Degree