Dhruv_Jain_Resume
no image
Dhruv_Jain_Resume

Dhruv Jain
------------ / ------------ | ------------
------------/in/DhruvKJain | ------------/jainda09
SUMMARY
Enthusiastic and Resourceful Data Analyst and Software Developer actively looking for Full time/ Internship Opportunities

INTERNSHIPS
Data Analyst Intern at Taken Mind May 2015-January2017

• Conducted business user workshops, data analysis and data compilation for financial data for external customers different SAS environments like SAS/BASE, SAS/ODS, SAS/MACROS, SAS/SQL, SAS/CONNECT, SAS/GRAPH, SQL and also integrating with different reporting tools including Tableau.
• Involved in designing, building, maintaining and troubleshooting daily, weekly, and monthly reports using SAS, reporting tools like Microstrategy and scheduling them to run at specific time.
• involved in writing code using BASE SAS, SAS/MACROS and SAS Enterprise Guide to clean and validate data collected from multiple data sources like SQL server.
• Performed basic SAS analysis on existing customer's data and database segmentation using PROC MEANS, FREQ, SUMMARY and TABULATE.
• Scheduled daily, weekly and monthly reports using SAS/MACROS and performed data analysis, statistical analysis like ANOVA, T-tests, CHI Square tests , generated reports and graphs USING BASE SAS, SAS/MACROS SAS/GRAPH, SAS/SQL, SAS/CONNECT, SAS/ACCESS.
• Assisted reporting teams to export SAS Enterprise, Enterprise Guide files to different tools and particularly on how Tableau assists SAS in exploring data and providing insights.
• Created macros and developed SAS programs for data cleaning, validation, analysis and report generation using newly created as well as existing macros.
• Analyzed data using various packages of Python, including Pandas, NumPy and Matplotlib. Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope and assisted in preparing business requirement documents (BRD) and documented software requirements for the application
• Managed and developed financial reports that aligned and simplified monthly business reviews, annual planning, and forecasting processes. Created technical documentation and presented information to senior management including ad-hoc analysis and reporting as per user requests for managerial meetings and discussions.
• Partially involved in all phases (SDLC) of this project from planning, requirement gathering, designing, development, testing and implementation which included applying subject matter expertise and advanced level of understanding of best practices and standards of using either SAS or Tableau for different approaches.
• Performed parallel testing or production testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the user acceptance warranty testing. Involved in doing security and negative testing of the application


Development of Wireless Sensors at Eduvance Training Centre. January 2017
• Developed a wireless sensor network with NRF module and FRDMKL25Z board for wireless communication over different pipes and same carrier frequency.
Developing Data Acquisition systems with Embedded Systems and Internet of Things.(IoT) July 2017
• Developed a data acquisition for a wireless communication system using Bluetooth and IoT technologies and Mbed C programming for acquiring data for various sensors.

PROJECTS

Banking Data Analysis Using Apache Hadoop: Current
• Data Integration and Ingestion from RDBMS to HIVE with data encryption on sensitive data and performing data analysis such as finding out users with outstanding loan payments/outstanding credit payment/reviews on the service

Database Driven Student Management System Website using HTML, PHP and SQL Spring 2018
• Built a basic Website which would not only allow content entered in the site to reside in Database but also pulls content dynamically as per response given by the user. There is HTML page in front end which User accesses, Content of the site is stored in tables of My SQL and PHP Scripting Language is used as Interface between Frond end and Back-end to process the requests
.
• Whenever a site is accessed by the user, Apache Server fires up PHP Interpreter to execute the code and PHP variables hit the Database to to request the content as per the requirement. Then PHP handles the copy of HTML page to Server and this is the output that User expects.

Embedding SQLite Databases Spring 2018
• R was used to communicate with SQLite databases: using the RSQLite package and using the sqldf package.
• Used RSQLite to map data from flat databases to relational databases. Normalization of data using sqldf and dbplyr packages into R data frames which were imported into databases.

Online Transmission Portal Fall 2017
• File distribution and Transmission using TCP and UDP sockets.
• Tested on Linux, Mac OS and Windows. Used Apache Web Server, implemented using Java and PHP. CSS,HTML and AJAX was used for Web development.

Web Server Development Fall 2017
• Developing Web server using Tcp/Ip and UDP sockets implemented with Python to handle HTTP and SMTP , connections and also multiple requests for DHCP,ARP, Ethernet, ICMP protocols were handled and analysed using WireShark.
MANET Attack Simulation, Final Year B.Eng Project Fall 2016-Spring 2017
• The different attacks ,responsible for network and packet losses were simulated for analysis in Wireless ad-hoc networks using NS-2 simulator. Modified AODV ,OLSR and other ad-hoc protocol were also implemented using TCl scripting in a Linux environment.
Automatic Number Plate Recognition System Spring 2016
• Scanning a large dataset of the number plate images and using various image processing techniques including editing, compression and restoration to identify and differentiate between the different types of number plates used to represent the different types of vehicles in India.

SKILLS and HIGHLIGHTS
• Tableau , SAS Enterprise Miner, IBM Cognos, T-SQL, SQL Server Management Studio, Hadoop, Hive, Microstrategy, Netezza, Toad, WEKA, RStudio, SAP NetWeaver, Adobe Photoshop, MS Office (Word, Excel, PowerPoint), MS Access, MS SharePoint, HTML 5
• Development/Testing Tools- Visual Studio, Notepad++, JUnit
• Languages – R, SQL, UML, SDLC, C++, JAVA, CSS, JavaScript, JQuery, PHP, C++, Java,V------------, C# MbedC , Json, Tcl, Python, R, Matlab, CSS, JSS, SAWscript, ,ACL 2
• General Skills - Backup/Restore Utilities, Configuration Management, Help Desk, Support, Troubleshooting
• Operating Systems like MS DOS, Windows 95/98/NT/2000/XP/Vista/7/8/10, Unix , Worked on Mac Os, Linux and Microsoft Operating systems
• Databases like SQL, RSQLite, MySQL , MongoDB, MsSQL server.NoSql
• Working with Tableau ,working functionalities of Cognos and Power BI and also having undergone online course on Excel (pivot tables, v Lookup , formula calculations)as Data Analytics through LinkedIn’s L------------ and familiar with OLAP cubes technicalities
• Familiarity with working in Agile and Waterfall environments.
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages. Proficiency with Microsoft Office applications with experience in using Microsoft Excel, Word and PowerPoint and Microsoft Access.
• Strong dependability and reliability to handle a variety of office tasks. Good oral and written communication skills. High customer service and interpersonal abilities.

EDUCATION
Masters of Engineering, Computer Science Fall 2017-Present
University of Cincinnati, Cincinnati, Ohio (3.417 GPA)