Shubham Sharma

--https://www.linkedin.com/in/shubham-sharma-0a59141a7/ SHUBHAM SHARMA Summary Senior BI Developer specializing in developing and building Reports/Dashboards. Having 9.5 years of experience in Microsoft Business Intelligence. Proficient in developing and deploying complex reports in Power BI. Looking forward to continuing my career in Microsoft BI & Data Analytics (Power BI, Excel BI add-in, SQL, SSAS , SSIS, SSRS and Azure) Skill Highlights     Project management Strong decision maker Complex problem solver Self-motivated, proactive, and autonomous.     Creative design Innovative Service-focused. Able to adapt to changing of priorities and cope with deadline pressure Experience BI Architect developer - 11/2020 to Present DDI, Mumbai  Administer Microsoft Power BI platform and On-Premises Gateway, lead upgrade planning, configuration, and capacity planning.  Coordinate with Microsoft Premium Support and other IT team members when troubleshooting and resolving performance issues.  Optimize Workspaces and datasets to promote ease of self-service, and provide a secure, structured organization of workspaces, apps, data sets and dashboards.  Work with business partners to migrate the existing workspaces and data sets into an organized catalog of information areas and data sets.  Has a solid understanding of Power BI security capabilities (access control, data row-level security, use of roles to control sharing, publishing, data export)  Creating report using SAP data source  Responsible for Create App Workspaces and content packs to share your insights.  To import data from Azure and build the dashboards as per the requirement.  Scheduling the dashboards according to frequency (daily, weekly)  Responsible for creating Workspaces and share insights to specific business customers/partners and stockholders.  Hands-on experience of SQL Server / SQL Language  Leading team of 6 members, interpersonal, analytical skills and a good team player.  Graphic design UI/UX ensure the usability of the site and changes management to assist in the analysis and outreach in the adoption of the data. Senior BI Engineer - 11/2018 to 09/2020 CAPGEMINI, Mumbai      Designed Finance and Marketing reports, dashboard, and mobile report to analyze and forecast purpose for management decision of the client’s organization. Having knowledge of the business and ability to understand users’ needs and problems, commercial finance understanding. Modifying existing reports and making necessary changes to smooth run of business requirements. Developed SSIS packages that can extract data from various sources and merge into one onlysource for Power BI reports. Involved in automating SSIS Packages using SQL Server Agent Jobs. Testing of visualizations, reports, dashboard, mobile report, and application testing. BI Developer - 08/2017 to 11/2018 ACENDRE, Bangalore  Participated in daily SCRUM meeting and weekly SPRINT meetings communicating project /task deliverable updates.  Created POWER BI Visualizations and Dashboards as per the requirements.  Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.  Modified SSIS packages reflecting changes to ETL process resulting from new business requirements.  Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting, and data cleansing from different Sources into Company Formats. Junior BI Engineer - 01/2016 to 08/2017 NTT DATA, Bangalore  Created SQL queries used to audit financial source table.  Modifying SSIS packages  Develop and modified Power BI reports & effective dashboards after gathering and translating end user requirements.  Update stored procedures to reflect changes in business requirement logic using SQL server.  Created stored procedures used in creating new end-user reports. Education Bachelor of Engineering: Computer Science -%) Staffordshire University, UK HBSE 12th (79%) - HBSE 10th(68%) - Certifications  SQL level  Power BI