Information Technology Data

Suyash Karanwal

Unit ****, ****- Prairie Shores, South King Drive, Chicago, IL - 60616

Tel No: +1-872-***-**** Email: **************@*****.***

Summary:

* ***** ** ********** ** the Information Technology field with comprehensive hands-on expertise in development, production database administration and database application development. Also performed different tasks like installation, configuration, upgrades, patches, database refresh, performance tuning, backup and recovery, cloning, space management, database security.

Education:

Illinois Institute of Technology, Chicago Aug 2015- May 2017

Masters in Information Technology & Management - Data Management GPA- 3.8

R.N.S. Institute of Technology, Bangalore, India Sep 2008 – Jun 2012

Bachelor of Engineering – Instrumentation Technology GPA- 73%

Technical Skills:

Languages : SQL, PL/SQL, Shell Scripting, Pentaho DI, Java, JavaFX, SAS, R

Databases : Oracle, MySQL, SQL Server, MS Access 2013

Software Expertise : OEM, TOAD, puTTY, SQL Developer, vi Editor, Tableau, Eclipse, SAS EG 5.1

Operating System : LINUX, UNIX, HP-UX, Sun Solaris, AIX, RHEL, Windows

Work Experience:

Infosys Limited, Pune (Astra-Zeneca) – SQL/Oracle Database Administrator June 2011 –June 2015

Supported 1200 SQL and Oracle Databases 24X7 including Production.

Comprehensive knowledge in Oracle Database Architecture & Implementation, Data Models, Database design, Normalization & System study.

Knowledge of Database Build, Database Migration, Cluster Upgrade, Database Upgrade, CPU Oracle patching.

Experience in Oracle Real Application Clusters (RAC) Installation, administration and troubleshooting.

Knowledge of various DR solutions like Mirroring, Clustering, Replication, Log Shipping and AlwaysOn.

Setup, Configured and Maintained Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.

Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.

Experience in refreshing the Databases from Production to Development Environment.

Experience working with the client side, doing requirements gathering, providing innovative solutions, client interfacing and support for application and queries.

Promoted to the role of Senior Systems Engineer for my outstanding performance and contribution to the Organization.

Conducted Knowledge Transfer sessions for Oracle 12C and enabled a team of 10.

Academic Projects & Trainings:

University Data warehouse Aug 2016 - Dec 2016

Designed and implemented data warehouse for University Admission Process using components of Kimball Methodology like Surrogate keys, Slowly Changing Dimension, Star Schema.

Extracted data from MySQL tables using Pentaho DI to load in a single data warehouse repository.

Involved in design, analysis, implementation, testing & support of ETL process using Pentaho DI.

Performed analytics using Tableau Desktop on the newly built data warehouse.

Text Analytics using R on DEF14A filings Jan 2016 - May 2016

Extracted the Q&A section from SEC’s DEF14A filings of Yahoo using R.

Data cleansing using Corpus function & created a Term Document Matrix all words & its frequencies

Analyse the most often used words and the context used in the DEF14A.

Concluded the analysis of company’s performance w.r.t. Stock Awards, Option Awards & CEO Salary

Desktop Application for Knowledge Based Community Sharing System Sep 2015 - Dec 2015

Created a real-time desktop application using MVC architecture.

Designed the front end of the application using SceneBuilder and FXML.

Implemented normalization techniques and built a Database using MySQL.

Performed Analytics using Data Mining techniques.

Extra-Curricular Activities

Participated in Microsoft Dreamspark Event and was among the top two teams.

Won First place in the “Sudoku” event at Parichay Fest of College in 2011.

Won first prize in the government technical show KKMBD while presenting school at Film City, Noida, India.

Organized and coordinated various college fests Evolution and Parichay in 2010.

Arranged a trip to an orphanage near the college under the supervision of Prof. Y.S. Sumathy.

Contact this candidate