Shashank Sharma Email & Phone Number

Richardson, Tx, Us

Texas, United States

Implemented Tableau, Power BI as a BI tool migrating their existence reporting from MS Excel, for a quick and easy end user controlled dynamic metrics. Administered KPI with their respective CPG for easy analysis of their product depletions from warehouses into retailers. Detailing each location and other providers having data from Nielsen for prices/cases of the products. • Built a team from different groups to focus on Tableau migration. Coached the team to use tableau and the publishing of dashboards onto server for authorizing access to relevant groups.• Developed various dashboards displaying the enormous functionality and dynamic filtering available for end users to control and generate reports.• Built reports for business, marketing & cross teams. Enabled subscriptions to the reports saving lot of manual intervention.• The current project revolves around creating reports for all Retail Store-related reports. Reports include Day to day operational activates of the business. Reports are like Daily, Weekly, Monthly, Quarterly and Yearly Sales information and Stock information.• Developed many LOD functional calculations for YOY, MOM, WOW for sales, inflow and outflow of the products and used them in the reports.• Created Alteryx output files from database to be used in Snowflake as input to automate refreshing and eliminate regular manual refresh activities.• Designed and implemented highly performant data ingestion pipelines from multiple sources using Azure Databricks.• Orchestrated Report Demo to End users. Developed in Excel Based Report Preparation using Pivot and lookups & Excel functions.• Build Daily, Weekly, Monthly Production Reports Support activities.• Scheduled maintenance of the report on feedback by interacting with user for the production related issues.• Organized in POWER BI system Landscape setup and lead Migration activity from DEV to Production Environment.

St Louis, Missouri, United States

Helped build reports and interactive dashboards for clients with respect to their needs. Used Tools such as Tableau desktop, Tableau Online, and server for developing and publishing reports for the end users. Migration projects from On-Prem to Cloud of Tableau instances.• Developed reports on incidents for business and exploring the defects associated with them.• Server setup activities and managed projects within Tableau server and Tableau cloud instances to assign projects, folders, report level access.• Bridge Installation and MFA setup with respect to requirements.• Helped Clients (Investment Banking) migrate from on premise server to Tableau Online.• Validated End to End process ensuring everything is matching pre and post migration during the process.• Documentation of the whole process for further reference.• Made interactive action charts that could be used as a drill down in the reporting.• Worked with action filters and LOD calculations.• Build and organize Tableau Server data sources, including Box, MySQL, NoSQL, Oracle• Databricks as a cloud database for analytics of data and reporting.• Parameters for user interactive selections, Customs charts for easy and user need base• Individual contributor and requirements gathering from business.

Hyderabad, Telangana, India

• Responsible for getting, understanding the business specs, preparing technical Specs, DTS Packages.• Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.• Creating jobs for scheduling the SSIS packages.• Getting data from different data sources.• Worked on report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, Drill Down, Parameterized, Cascaded and Sub-reports using SSRS.• Worked on design and implement processes for Deploying and Extracting data for reporting using SQL Reporting Services (SSRS).• Experienced in Data Warehouse concepts.• Worked on Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).• Experienced working with SSIS Catalogue Database and Data Mapping Environments• Worked on Dimensional Data Modelling, Cube development and manipulations in SQL Server Analysis Services (SSAS).• Worked on Tabular Mode and Multidimensional mode databases.

India

• Worked closely with businesses and was involved in gathering user requirements.• Responsible for writing and modifying stored procedures, functions, and packages for data conversions to create database objects dynamically.• Created indexes, tables, and sequences as per the business requirement and views to maintain data privacy.• Used SQL profiler to identify slow-running queries.• Designed SSIS packages to validate, extract, transform, and load data into staging and Data Warehouse.• Analyzed the requirements and framed the business logic for the ETL process.• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.• Created a package to transfer data between OLTP and OLAP databases.• Created various complex reports and managed them using SQL Server Reporting Services (SSRS).• Deployed and uploaded the SSRS reports to Report Manager and called reports through a URL from .Net API for the end users and involved in enhancements and modifications.• Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights.• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.• Maintained database for inventory, billing and invoice systems and created dynamic stored procedures to retrieve the customer details, and payment history by giving related parameters.• Used Agile Development Methodology.• Point of contact for all production issues.

Master Of Science - Ms, Information Systems, 3.67

Bachelor Of Technology - Btech, Electronics And Communication Engineering, 6.5