Tarun Khatri
469-***-****;*************@*****.***
https://www.linkedin.com/in/tarunkhatri03
EDUCATION
The University of Texas at Dallas, TX expected May 2016 M.S., Information Technology and Management GPA 3.80 Jaypee University of Engineering and Technology, India (JUET) June 2012 B.Tech. Computer Science. GPA7.7/10
COMPUTER SKILLS
Visualization Software: SAP Universe Design tool, SAP BO Web Intelligence Rich Client, Tableau Desktop, ERwin Data -Modeler, MS Excel, Visual Paradigm, Microsoft Visio, Microsoft Project Analytics Software: SAS Enterprise Miner 13.1, SAS Programming, Google Analytics 2.0, R programming, Python Database: MySQL, SQL, MS Access
Other Software/Technologies: GitHub, IBM RTC, MS SharePoint, HTML5, CSS3, J2EE, Jenkins, Toad Certification: ITIL (expected Feb 2016), SAS Institute Certificate in Business Intelligence and Data Mining, Microsoft Specialist in html5 programming with JavaScript and css3, Java-Infosys Technologies Limited EXPERIENCE
Data Analyst Intern, Health Fitness Corporation, Lake Forest, IL June 2015-August 2015
Created system and source data dictionary by primarily utilizing the advanced features of MS Excel
(VLookUp, HLookUp and Pivot Tables) and SharePoint to implement the tasks
Developed and tested storage strategies and disaster-recovery plan for Health Fitness operational database
Audited the data warehouse and ETL model and identified the scope of improvement
Enhanced end users' understanding of database systems by conducting workshops, delivering group training sessions and creating user-friendly training materials Systems Engineer, Infosys Technologies Ltd, Bangalore, Karnataka, India January 2012-June 2014
Performed business analysis on automation of business process of fund setup by evaluating the system requirements and recommending mandatory changes for Fidelity, hence reducing company's cost by 30%
Accomplished programming requirements and created multiple dashboards using Tableau for inventory management and pre and post sales, analysing the latest trends in the automobile sector
Developed and documented functional requirements for an interactive notepad targeted on the blind audience by taking vocal inputs and speaking vocal outputs
Created test scripts and JUnit test cases for QA testing and UAT scenarios
Managed a team of 4 and designed database for a role based web application for issue tracking
Learned Agile SDLC and performed the duties of scrum master for 2 iterations ACADEMIC PROJECTS August 2014 –Present
Planned business deliverables and designed sequence and class diagrams using Visio for a real time delivery management system that enabled customer to track his delivery on real time basis on the day of delivery
Successfully completed fissure simulation being a scrum master of an agile team and created multiple projects using MS Project
Participated in IT Service Management Forum Student case competition, 2015 and defined a service based delivery model (using ITIL concepts), that enabled the business units to pay per use for the services and IT to deliver services at the speed of business
Prepared and analyzed multiple dashboard reports on Twitter sensitive data analysis using Tableau Desktop
Created and analyzed the impact on sales by studying various factors such as competitor distance, holidays, assortment type, and promotions for Rossmann stores
Designed universes for motor database using SAP Universe Design Tool 4.1 and generated reports using SAP BO Web Intelligence Rich Client 4.1
Designed and implemented ER and Dimensional models for an ITSM Application using ERwin Data Modeler
Planned and implemented a model predicting the forest cover type (the predominant kind of tree cover) from strictly geographic variables using SAS Enterprise Miner 13.1 resulting in 72% accuracy LEADERSHIP AND ORGANIZATION EXPERIENCE August 2014 –Present
Organized two Information sessions as a member of Intelligence Analytics Society, UT Dallas
Co-ordinated for sports day for 300 blind participants as a member of Infinity Lions Club, UT Dallas