State University Data

Nisarg Pandya

Phone: 562-***-**** Email:*********@*****.***

Current: Long Beach, CA https://www.linkedin.com/in/nisarg-pandya-76186b43/ A solution seeker and dedicated professional with a niche for positive transformation. An optimist and adherent of continuous learning. Ambitious about being a contributor for creating a better world. EXECUTIVE SUMMARY

2 years of extensive experience in database administration, database management, data extraction, data reporting, statistical analysis and data visualization using Tableau.

Proficient in writing SQL and PL/SQL scripts, handling ETL processes for extracting data from multiple sources and various file formats, data migration, Indexing, CTE and delivering workflow automation using SQL Stored procedures and Scheduled Jobs. Enhanced understanding of Excel reporting using pivot tables, macros, lookups and publishing Tableau dashboards to server. Developed and tested highly scalable Web applications using Java, J2EE, JSP, Servlet, JDBC, C#, HTML, CSS, and JSON. SKILLS

Languages : SQL, PL/SQL, Java, Python, C#, Android, HTML, CSS

Databases : Oracle 12c, SQL Server, MySQL, SQLite, Microsoft Access, MongoDB

Tools : Tableau Desktop, Tableau Server, SQL Developer, Microsoft Excel, Eclipse IDE, PyCharm, Android Studio RESEARCH WORK

Health Data Analysis and Predictions California State University, Long Beach January 2017 - Present

Analyzed the public health dataset to find patterns related to different diseases and relationships exist among patients by creating data models (e.g. graph) using available packages and libraries of Python. EMPLOYMENT AND WORK EXPERIENCE

Data Analyst & Tableau Developer California State University, Long Beach June 2016 – Present

Query and administrate the Oracle database of California State University.

Build reporting tables, views, SQL stored procedures, and maintain row level security.

Prepare and build reports by collecting, analyzing, and summarizing data and trends.

Utilize Tableau for creating interactive dashboards using Tableau calculated fields, action, filters and table calculations.

Assist with handling ad-hoc requests, documenting business processes and performing workflow automation.

Verify and validate accuracy of data, write SQL and PL/SQL scripts for effective data analysis and perform SQL Tuning. Accomplishments

Independently carried out efficient and on schedule migration of a system based on SAS DW to Oracle Data warehouse.

Automated a workflow through PL/SQL stored procedure to automatically create daily enrollment reports.

Migrated traditional Excel reports to user friendly Tableau dashboards.

Built and published interactive Tableau dashboards for historical trend analysis of Student Admission and Enrollment. Software Engineer and Technical Trainer Tata Consultancy Services (TCS) India October 2015 to January 2016

Proficient in assortment of technologies like Agile Methodology, SDLC, J2EE, JDBC, Servlets, and JSP with SQL Server database in MVC framework to create Web application for management of events at organizational level.

Lead technical training and facilitation for SQL, PL/SQL and Java trainees at the wide scaled training department of TCS. Accomplishments

Delivered a scalable and efficient web application designed to add, track, notify and manage the major and minor events throughout the organization.

Built and delivered a robust System Asset Management system to organize, track and ease the wide scale use of assets across the organization.

OTHER PROJECTS

Yelp Data Challenge California State University, Long Beach November 2016

An optimized Java application to parse and load JSON Yelp dataset to Oracle database. Query and filter the same using GUI application designed in Java. Migration of the database application to MongoDB. Inventory Management System Birla Vishwakarma Mahavidyalaya College of Engineering India May2015

Innovated time-saving and robust Web application to automate the process of inventory management of a large scale mechanical industry using C# and Microsoft Access. EDUCATION

Master of Science, Computer Science California State University GPA: 3.63/4.0 January 2016 – December 2017 Bachelor of Computer Engineering BVM College of Engineering, India GPA: 3.88/4.0 June 2011-May 2015

Contact this candidate