Murthy Venkataswamy

Experience

• 

  IHS Inc

  Dec 2010 - Dec 2012

  Data Engineer

  Description: IHS Global Insight will provides information and analysis to support the decision-making process of businesses and governments in industries such as aerospace, automotive, chemical, energy and technology.IHS provides comprehensive information management solutions for Environmental, Health and Safety (EHS). Responsibilities: Capturing EHS data in Excel and SQL database which converting this into advanced chart types, visualization, reports and dashboard. Automated MS application using VBA programming language. Show less

• 

  Thermo Fisher Scientific

  Jan 2013 - Apr 2016

  MIS Analyst

  Description: Thermo Fisher Scientific is American multinational, Biotechnology product Development Company. Thermo Fisher produces Laboratory Equipment such as Analytical instruments, equipment, Reagents and consumables, software and services for research, manufacturing, analysis and diagnostics.Responsibilities: Service team were managing the Incident, Change and Problem Management where the Tickets and CI Asset data was presented in Monthly and Weekly Reports and Dashboards.

• 

  NTT

  May 2016 - Jul 2021

  Data Analyst

  NTT Ltd. is a London based ICT company which give Support and Managed services to the Configuration Items for the products from Cisco, EMC, VMware and others. Responsibilities: Project1: Client SuccessDeploying ETL Packages using SSIS 2013, Creating cube /table in SQL server which will be connected to Power BI and create reporting and Dashboard for Descriptive and Diagnostic Analytics.Creating Customer success data model in SQL server for Support and Managed services which will be used in monthly dashboard Descriptive Analysis.Adoption, Expansion and Renewal (AER) data for regional CSM will be created in monthly dashboard.Project2: Operation and salesMSEN and MSDC operational data like CMDB, Incident and Service are stored in SQL Server and MySQL by writing Procedures, data warehousing using SSIS Packages.Presenting the TASK, SLA and OLA service Tickets reports and Dashboard in Power BI on weekly and monthly basis.Extracting Data from ITSM using SQL Scripts and preparing client reports on monthly basis.Creating and Scheduling ITSM reports in Service now.Providing Utilization metrics of all the resources to their managers to monitor workload and understand over/under utilization of the resource in the team. Show less

• 

  Tata Consultancy Services

  Jul 2021 - Apr 2024

  Assistant Consultant