Hiring for SQL Consultant in Chennai, for Exp. 3 - 6 yrs at HP India Sales Private Limited.

  • Esteemed client of Orion TrueTech Services India
  • Chennai, Tamil Nadu, India
  • Feb 07, 2018
Full time Others

Job Description

Job Description:Its an Night Shift based Job (Night (6:30 PM to 3:30 AM). Key Responsibilities Focus on bringing value to the Output data and improving the input / coverage Build business models, research both internal and external sources, and extract key insights from data analysis to inform key focus areas and development priorities for the organization Ability to build/trouble shoot reporting and analytics that provide actionable business insights, validate hypothesis, carry out enhancements based on business/stakeholder feedback Collaborate with BI team, IT, regions and global partners to ensure data integrity and gather and analyze updated data for various finance supply chain operations specific analytics initiatives&amp amp nbsp Developing creative solutions in an unstructured environment Work with different stakeholders in the Supply Chain teams to continuously improve the level of reporting and analysis To help build SSAS models by reverse engineering legacy system, checking tables, attributes, joins and calculations To test SSAS models built. Ability to build/trouble shoot SSRS reports that provide actionable business insights, validate hypothesis, carry out enhancements based on business/stakeholder feedback. Ability to build complex reports in DAX and MDX in SSRS Report builder with multiple dynamic parameters and structures Collaborate with BI team, IT, regions and global partners to ensure model, report and data integrity Help extended team in SSRS reporting and DAX querying. Skills Requirement Technical Skills: In Depth knowledge and experience in : Excel: Expert Access: Expert VBA for Excel and Access : Expert SQL Server: Expert SSAS: Intermediate SSRS: Intermediate In Depth knowledge and experience in : VBA, Excel, SQL Server, SSIS, , Windows Server admin Strong competency in VBA programming in MS Excel Very Good with MS Office. Ability to represent data through XL/PowerPoint / PDF Software product development experience - SDLC Database skills maintenance, design and development like SQL language, SQL server, SSIS, OLAP Cubes etc.) Strong with Installing, configuring and supporting Microsoft technology solutions on windows 2003/2008 platform hosting web and database applications, while maintaining security, backups, monitoring and performing routine server maintenance.