Rohan Pisal

Chicago, IL ***** 309-***-**** ac9zmy@r.postjobfree.com

Professional Summary

Diligent PL/SQL Developer with over 3 years of experience working in IT industry. Sound understanding of backend as well as front-end application development with knowledge of diverse programming languages. Good knowledge of data gathering, cleansing and analysis. Well versed in BI and other business tools.

Skills

Databases

Programming languages

Business tools

Oracle (11g, 12c)

PL/SQL

Tableau

MS SQL Server

Python

MS Visual Studio

SQLite3

C#

MS Excel

MS Access

Java

SPSS

Work History

PL/SQL Developer, 10/2018 to Current

Reply Industrie, LLC – Chicago, IL

Create PL/SQL procedures and functions to execute complex tasks using Oracle 12c

Build and configure database objects/message actions to support Java application

Develop printing procedures to create printing labels using ZPL (Zebra Printing Language)

Tuned database performance to achieve query results 5 times faster than before

Extensively use applications like JIRA, BitBucket, Git to manage and track projects

Perform reverse-engineering to solve and suggest solutions for database and application problems

Data Analyst, 08/2017 to 08/2018

Illinois State University – Normal, IL

Assisted on creation and optimization of SQL queries for data modelling.

Designed and implemented QA automation script as technical solution for manual QA process, using PL/SQL functions & procedures, saving around 1 hour spent to QA every table.

Developed packages as ETL solutions using MS SQL Server and SSIS for data manipulation and transfer.

Profiled data and performed data mining to filter out potential cheaters from a data of 10,000 students for home-based test.

Conducted Source-Target Mapping and GAP Analysis on complex SQL queries with over 1000 lines of code, to implement modelling queries.

Performed data extraction from over 250 Data Warehouse tables containing data of over 20,000 students and analysed in excel.

Improved quality of SQL tables by 12% through regular quality checks for auditing columns, naming conventions, etc.

Data Processing Programmer, 05/2014 to 05/2016

Ugam Solutions Pvt. Ltd – Thane, Maharashtra

Profiled and tabulated survey data of over 5,000 respondents per survey, for creating reports.

Created reports, score cards, and dashboards in Tableau 10 for data visualization.

Derived insights through data analysis using SPSS.

Performed data cleaning and wrangling using looks-ups and formulas in Microsoft Excel.

Achieved "Client appreciation" for "Quick turn-around time" and "First-time right" in 2 out of 3 projects completed.

Trained & mentor a team of 5 people.

Education

Masters: Information Systems, August 2018

ILLINOIS STATE UNIVERSITY - Normal, IL

GPA: 3.8, Skills Learned: Programming, Data analysis, Project management, System analysis & Design, Database Design & Management, Business principles

Indian Student Association Treasurer

Bachelors: Information Technology, August 2013

PUNE UNIVERSITY - Pune, Maharashtra

Certifications

Systems Analyst, Illinois State University (2018)

UserTesting Partnered Course, UserTesting (2017)

Projects Completed

Marking attendance using Face Recognition, (2018)

LinkedU, (2017) (website to connect universities and students)

Comparison between Java & Javascript questions on StackExchange using R, (2016)

Contact this candidate