Deepak S. Email & Phone Number

Gurugram, Haryana, India

India

● Designed CEO level dashboard, which was consumed by CEO, Country head and regional managers.● Implemented multiple level user security on dashboard. ● Optimization of dashboard performance ● Interacting with business to understand business logic required for dashboard development. ● Exploring, debugging, and Implementing the UAT feedback for dashboards.● Created extract data sources from impala on UAT and Prod ● Developing Dashboard in Tableau desktop and deploying in Tableau server

Responsibilities● Data discovery – analyzing the existing client data and comparing with the required KPIs/fields to find the out the gaps in data● Data transformation using Tableau Prep ● Users access, project creation, analyzing tableau online issues & work with Data sources● Provide technical support to Tableau Server administrators and end-users.● Managing schedule, Performed UAT to Prod deployment ● Repointing of datasources and scheduling and managing tableau prep flow on server● Coaching and consulting for client's side developers and users.● Developing Dashboard in Tableau desktop and deploying in Tableau server ● Enhance report performance via best practices● Development of dashboardso Migration of legacy BI reports to Interactive tableau dashboard.o Usage of Parameters for more interactivityo Usage of right containers and removing unwanted once for clean layouto Publishing on server and scheduling refresho Data validation and defects rectificationo Documentation for developed dashboard with all technical specifications.

Gurugram, Haryana, India

●Dashboard Development: Created and maintained new Tableau dashboards based on user stories, providing critical insights through daily, monthly, and quarterly matching statistics.●ETL Design and Development: Designed and implemented new ETL workflows using SSIS to load data into staging databases, including the creation of new tables and views to integrate new data sources.●Automation and Scheduling: Managed the scheduling of data source and workbook refreshes using Tabcmd and Autosys, ensuring timely and accurate data updates.●Quality Assurance: Conducted unit testing, resolved defects, and supported users during User Acceptance Testing (UAT) to ensure the reliability and accuracy of data solutions.●Deployment and Governance: Published new dashboards to the production server, following the change governance process to maintain data integrity and security.●User Adoption and Training: Facilitated the adoption of a new strategic BI tool, providing training and support to users, ensuring they could effectively leverage the new system for their reporting and analytical needs.

Tableau Developer-● Tableau certified desktop specialist with experience in designing , analysis, development ,testing and implementation of reports using Tableau .● Exposure in Data Blending and Data Joining designed and developed many analytical reports from multiple data sources by blending data on a single worksheet.● Expertise in visualization as well as tabular, cross tab reporting and created daily ,weekly ,monthly and quarterly reports as per the user's requirement .● Excellent knowledge in dashboards designing with large data volumes from various data sources e.g. SQL Server,ODBC,Excel,csv, flat file etc .● Experience in Design and development of complex data models using SSIS and SQL Views for Tableau reports. developed custom SQL scripts to meet users requirements.● Responsible for transformation or conversion of legacy Business Objects report into user interactive,self driven Tableau visualization. Migrated existing 200+ SAP Business Objects webi reports to tableau dashboards and workbooks.● Efficient in using various functionalities of Tableau like Data Blending,joining ,views, calculations,filters,sorting , aggregation ,LOD, functions, drill downs & ups table calculation .● Responsible for creating complex calculated fields, defining hierarchy, Groups,sets,bin using Tableau Desktop.● Utilized Tableau server to publish and share the reports with the business users.● Exposure to TABCMD for refreshing datasource, scheduling reports, archiving Tableau reports and delivering the reports to end users on a shared drive .● Effectively managing the schedule of reports and ensuring senior leadership has timely access to results of KPIs.● Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues.

Pune Area, India

SAP BO developer● Planning and implementing enhancements, bug fixes of BO reports and universes via complete Change Management process.● Development of Webi reports based on business requirement , used events for scheduling also created publication jobs for reports.● Designing ,configuring and maintaining SSIS packages used to load data from OLTP data sources to staging databases.● Extensive experience in upgrading & Migration of reports and Universes From BOXI 3.1 to SAP BO 4.2.● Exposure to set up a development environment for Visa direct project and created universes for newdatasource.● Exposure to Report management,ad hoc reporting,user management and server management.Troubleshoot issue reported by business users and performing complete root cause analysis of the same.● Exposure to introducing new data sources to existing reports and creating variables and merge dimensions to get correct data.● Performed unit testing and closely worked with the testing team and business user to fix reports bugs● Developed Webi to fetch success status of critical monthly report and deliver it to Team mailbox using publication job.

Master Of Computer Applications - Mca, Mca

Activities and Societies: Computer Science Business Intelligence RBDMS Data analysis

Bachelor Of Science - Bsc, Mathematics