Arpit Uttam

About Arpit Uttam

I am working as a Data (Business Intelligence & Big Data) Engineer at Intel. I have more than 11 years of professional working experience. My work is primarily on Microsoft BI stack (SQL Server, SSIS, SSAS, Power BI), Bigdata stack (Hadoop, Hive, Spark) working on solution designs of BI Applications and Database solutions. I am a Microsoft Certified Solutions Expert in Data Management & Analytics.Over the past few years, my responsibilities have included:• Developing Database Design/Modelling, Performance Analysis and Performance Tuning, Recovery, Capacity Planning, Scheduling and Server Monitoring to meet business requirement• Developing Power BI Reports on top of Excel data source, and SQL Server engine• Developing multiple SSIS packages to extract data from upstream sources cleanse them so that they can be used for reporting needs• Preparing custom user stored procedures that would use business rules to show appropriate data• Developing SSAS multidimensional cubes as per requirements that solves the reporting needs of the customer• Making development plans, project documentation and user test cases by providing input toclient for data representation for user perspective• Functioning in the audit team to ensure that every team member follows proper standards in testing, coding and other company process• Troubleshooting production issues and provide resolution for the same• Automating build deployment for a project• Participating in regular conference calls with onsite and customer team and elicit requirements from themAlso,• Communicated directly with clients to gather requirements, assess business needs, and gain user journey/experience insight.• Collaborated within global project teams working with other consultancy firms and small local project teams to design, develop and implement BI solutions.• Provided flexible client-focused work that required the ability to learn new technologies quickly and apply the technology to the client’s business needs.

Experience

1. Msbi Lead

   Intel

   Apr 2020 — Present · Bangalore Urban, IN

   Roles/Responsibilities• Participating in the full life cycle of development, from requirement gathering and design throughimplementation, deployment, testing and maintenance of various projects• Working on Agile Software Development for continuous build releases and automatedBVTs for backend verification• Participating in daily calls with On-site POCs to provide updates, as well as to elicit newrequirements, and also in internal/external code reviews to maintain better code quality• Providing reporting solutions to client using Microsoft SQL Server 2012 / 2014• Analyzing and mapping the data fields provided in clients\' mock-ups to upstream datasources• Designing and developing ETL packages (using SSIS) for creating Data Warehouses, andData Marts• Developing Multidimensional data models (Cubes using SSAS) for managing hugeData Marts, and presentation of data in various enterprise reporting projects• Developing Table dashboards on top of Excel files, SQL Databases, and Multidimensional Cubes• Actively involved in effort estimation, deployment plans, test plans and peer code reviews• Mentoring the new recruits on backend-related technologies like T-SQL, SSIS, and SSAS• Resolving critical architectural/implementation issues and provided optimized solutions tothe stakeholders

Education

• KRISHNA INSTITUTE OF ENGINEERING AND TECHNOLOGY, GHAZIABAD

  Bachelor’s Degree, InformationTechnology, First Class

  2009 — 2013

Skills

• Sql
• Angularjs
• Sql Server Integration Services (Ssis)
• Javascript
• Data Analysis
• Bootstrap
• Ssas 2008
• Microsoft Sql Server
• Jquery
• Cascading Style Sheets (Css)