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

• 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

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.

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.

Master Of Computer Applications - Mca, Mca

Activities and Societies: Computer Science Business Intelligence RBDMS Data analysis

Bachelor Of Science - Bsc, Mathematics