Data Analyst


      Verscend
  

-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
      
    



The University of Utah, located in Salt Lake City in the foothills of the Wasatch Mountains, is the flagship institution of higher learning in Utah. Founded in 1850, it serves over 31,000 students from across the U.S. and the world. With over 72 major subjects at the undergraduate level and more than 90 major fields of study at the graduate level, including law and medicine, the university prepares students to live and compete in the global workplace. Known for its proximity to seven world-class ski resorts within 40 minutes of campus, the U encourages an active, holistic lifestyle, innovation and collaborative thinking to engage students, faculty and business leaders.

The University of Utah became a member of the PAC-12 conference in July 2011.

Technology and Commercialization
The University of Utah is tops in the country for creating start-up companies from university research, according to a ranking by the Association of University Technology Managers (AUTM). See http://unews.utah.edu/news_releases/u-of-utah-no-1-for-startups for more information.

Forbes magazine’s recent ranking of the “Best States for Business” pointed to “an educated labor force” as a big reason Utah came in at number one. The U supplies many of the employees for companies that keep expanding their operations in Utah, such as Goldman Sachs, Adobe, Omniture, Oracle, Ebay and many others. http://pac12info.utah.edu/commercialization-of-innovation/

Healthcare
University of Utah Health Care recently ranked first in the nation in a prestigious national study. The University Health System Consortium’s 2010 Quality and Accountability Study compared 98 of the nation’s top academic medical centers and ranked them based on core quality measures, patient safety indicators, mortality rates, re-admission rates, and patient satisfaction scores. See more about University of Utah Health Care at http://healthcare.utah.edu/index.php

University of Utah

-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
      
    



About us

  Tata Consultancy Services is an IT services, consulting and business solutions organization that partners with many of the world’s largest businesses in their transformation journeys. TCS offers a consulting-led, Cognitive powered, integrated portfolio of IT, Business & Technology Services, and engineering. This is delivered through its unique Location Independent Agile delivery model, recognized as a benchmark of excellence in software development. A part of the Tata group, India's largest multinational business group, TCS has over 394,000 of the world’s best-trained consultants in 46 countries. The company generated consolidated revenues of US $19.09 billion for year ended March 31, 2018 and is listed on the BSE (formerly Bombay Stock Exchange) and the NSE (National Stock Exchange) in India. For more information, visit us at www.tcs.com.


      Tata Consultancy Services
        
  

Gayatri Vidya Parishad College of Engineering (Autonomous), 530048(CC-13) is a higher education company based out of Madhurawada, VISAKHAPATNAM, Andhra Pradesh, India.

Data Analyst R&A at Verscend

Verscend

Data Analyst R&A

University of Utah

BI Analyst Intern

Tata Consultancy Services

System Engineer

University of Utah

Information Systems

Master's degree

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

Electrical, Electronics and Communications Engineering

Bachelor of Technology - BTech