Data Analyst R&A at Verscend

Master's degree From University of Utah
Greater Salt Lake City Area


Data Analyst R&A
September 2018 - Present
(1 year and 12 Months)

University of Utah

BI Analyst Intern
-Performing data analysis of the University’s LMS data warehouse (Canvas). This includes analysis on 40 fact tables and 51 dimensions tables and a comparative analysis of data stored in the ERP system (PeopleSoft). -Responsible for the creation of an automated data profiling mechanism for the University’s operational data store (ODS). Created SQL procedure to calculate out table statistics automatically for all schemas and tables. Created Informatica mapping and workflow for the scheduling and monitoring. Designed and deployed Tableau dashboard to provide easy analysis for future data science projects of 48 schemas and 5117 tables. - Designed and developed an analytical JIRA reporting environment for employee performance statistics. Backward engineered JIRA tables to extract, transform, and load data in to an operational data store (ODS). Created Tableau reports focusing on service groupings, time logging, and issue categories. -Designed ER Diagrams, based on star schema design, for the University’s data warehouse. Analyzed physical specification documents to ensure logical models were correct and were available for end users of the data warehouse. … see more
September 2017 - August 2018
(12 Months)

Tata Consultancy Services

System Engineer
-Worked in the development of Web Based Application System for the Income Tax Department using the n-tier web, and client-server environments including Java Platform, Enterprise Edition (Java EE), Enterprise Java Bean (EJB), Java Server Pages (JSP), Java Servlets, Struts, and Java database Connectivity (JDBC) technologies using Agile techniques. -Experienced in analysis, design, development, testing, maintenance, performance tuning and deployment of internet and client-server applications. Worked with MVC Architecture using Hibernate, Apache Struts, Spring Frameworks - Developed SQL functions which can be used for performing CRUD operations on all the tables for a particular module. This single procedure can perform operations instead of 8-9 functions per module -Worked on optimizing the SQL query performance reframed the queries making joins and creating indexes, reduced the execution time of the query from 10 minutes to 30 seconds. - Designed an automated system to scan the card transactions information from different tables and raise an alert to the corresponding Officer about any fraudulent or unaccounted transfers. - Handled project files by using version control tools like CVS, SVN, GIT and PVCS and bug tracking tools like Jira. Developed Test Cases using Junit … see more
March 2015 - July 2017
(2 Years and 5 Months)

University of Utah

Information Systems
Master's degree
Not available

Gayatri Vidya Parishad College of Engineering (Autonomous), 530048(CC-13)

Electrical, Electronics and Communications Engineering
Bachelor of Technology - BTech