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.
• 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.
• Developed many LOD functional calculations for YOY, MOM, WOW for sales, inflow and outflow of the products and used them in the reports.

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.
• 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.

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).

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.

Master Of Science - Ms, Information Systems, 3.67

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