Ankit Rastogi
Business Intelligence
Gola Gokaran nath kheri
Summary
Experienced Smartsheet Lead with a comprehensive understanding of Smartsheet Control Center, WorkApps, Sheets, Reports, Dashboards, Dynamic View, Data Mesh, Data Tables, Data Shuttles, Bridge etc. Proven track record of successfully transitioning multiple Windows applications into Smartsheet for project management processes. Seeking a challenging role where I can leverage my expertise to drive organizational efficiency and productivity through effective Smartsheet utilization.
Overview
12
12
years of professional experience
6
6
Certifications
Work History
Smartsheet Lead
Dell-SAM
08.2021 - Current
- Implemented and managed Smartsheet Control Center for centralized administration and governance of Smartsheet workspaces, templates, and users
- Utilized WorkApps to create customized applications and streamline business processes within the Smartsheet environment
- Designed and configured Sheets, Reports, Dashboards, and Dynamic View to provide real-time visibility into project status, KPIs, and performance metrics
- Implemented Data Mesh and Data Tables to organize and analyze large datasets within Smartsheet, enabling data-driven decision-making
- Leveraged Data Shuttles for seamless data integration and migration between Smartsheet and other business systems
- Utilized Bridge for advanced automation and workflow orchestration, optimizing business processes and reducing manual efforts
- Created and maintained metrics and KPIs within Smartsheet to track project progress, resource utilization, and performance
- Integrated Smartsheet with Salesforce and other connectors to facilitate data synchronization and collaboration across platforms
- Led the transition of multiple Windows applications into Smartsheet for project management processes, ensuring alignment with organizational goals and objectives
- Managed cross-functional project teams in the planning, execution, and delivery of complex projects using Smartsheet as the primary project management tool
- Developed project plans, timelines, and resource allocations within Smartsheet to ensure project objectives were met on time and within budget
- Utilized Smartsheet Reports and Dashboards to provide project stakeholders with real-time visibility into project status, risks, and issues
- Conducted regular meetings and communication with stakeholders to ensure alignment on project goals, milestones, and deliverables
- Monitored project progress using Smartsheet metrics and KPIs, identifying areas for improvement and implementing corrective actions as needed
- Facilitated the transition of project management processes from legacy systems to Smartsheet, providing training and support to team members to ensure successful adoption.
Senior Data Analyst Business Intelligence
Dell (LMS)
08.2020 - 08.2021
- Developed and maintained Power BI reports to visualize and analyze data from various sources, providing actionable insights for decision-making
- Created Smartsheet reports to track project progress, resource allocation, and budget management, improving project efficiency by 70%
- Designed Excel dashboards to monitor key performance indicators (KPIs) and identify trends, facilitating data-driven decision-making processes
- Implemented KPIs across departments, collaborating with stakeholders to define metrics and ensure alignment with organizational goals
- Integrated Smartsheet with other platforms to streamline data workflows and improve data accuracy, resulting in a 80% reduction in manual data entry errors
- Conducted training sessions to educate team members on data analysis tools and techniques, enhancing overall data literacy within the organization
- Assisted in Tableau projects by creating visualizations and dashboards to communicate insights effectively.
Service Delivery Engineer II
SME (HPC)
02.2019 - 08.2020
- Lead the design, implementation, and optimization of high-performance computing systems, ensuring maximum efficiency and reliability
- Provide technical expertise and guidance to cross-functional teams on HPC architecture, hardware selection, software configuration, and performance tuning
- Collaborate with researchers, scientists, and engineers to understand their computational needs and develop tailored HPC solutions to accelerate their workloads
- Evaluate emerging technologies and industry trends in HPC to recommend and implement innovative solutions that improve computational performance and scalability
- Develop and maintain documentation, best practices, and standard operating procedures for HPC systems and workflows
- Serve as a subject matter expert for troubleshooting complex issues related to HPC systems, performance bottlenecks, and software optimization.
Senior Executive
TATA ELXSI
07.2012 - 02.2019
- Implemented and administered SGI Altix 1300, managing all aspects of the high-performance computing (HPC) environment
- Installed and managed Intel compilers to optimize software performance within the HPC cluster
- Administered Scali Cluster Manager for efficient cluster management and resource allocation
- Implemented and administered Altair PBS Pro job scheduler to automate and optimize job execution within the HPC environment
- Conducted Linpack Benchmarking Application to assess system performance and identify areas for improvement
- Developed scripts for job execution and handled MPI pre and post-job errors to ensure smooth operations
- Managed SGI Infinite 4000 SAN with 14 TB usable space, including installation, configuration, and troubleshooting
- Installed and configured EMC Clariion series, Fujitsu ETERNUS DX 400 Series, and SGI Infinite 4000 series for storage administration
- Configured RAID levels 0, 1, 5, 6, and 10 and created LUNs for efficient storage allocation
- Zoned SAN switches and monitored storage logs for analysis and troubleshooting
- Implemented CIFS and NFS sharing of LUNs to facilitate data access across the network
- Installed and configured Brocade SAN switches and Altusen iKVM and KVM switches for server administration
- Managed file system utilization, incidents, problems, and changes within the server environment
- Administered user and group management, file system management, backup, user quota, permissions, and ACLs
- Scheduled jobs using Crontab and managed RPM, YUM, FTP, SYSLOG, and NTP server configurations
- Configured and administered SAMBA and NFS servers, managed data through RAID and LVM, and configured Apache server and IP bonding
- Installed and configured Commvault Simpana V9.0 and V10.0 for backup administration
- Installed media agents and tape libraries, and configured various iDA agents for file system and database backup
- Implemented VSA for virtual machine backup and configured storage policies and schedule policies for various backup types
- Performed full, incremental, and differential backups using LTO cartridges and configured LAN-free backup to optimize network performance
- Provided technical support to clients by preparing SOW, conducting POC, and preparing RCA reports for problem analysis and resolution
- Analyzed storage issues and suggested solutions to overcome challenges, coordinating with client operations teams to meet customer requirements effectively.
Education
B.Tech - ECE
Sachdeva Institute of Technology UPTU
Skills
Smartsheet Control CenterWorkAppsSheets, Reports, DashboardsData Mesh, Data Tables, Data Shuttles,Dynamic ViewBridgeMetrics CreationProject ManagementProcess Transition and Optimization
Certification
Smartsheet 2023 Core App Badge
Timeline
Smartsheet Lead
Dell-SAM
08.2021 - Current
Senior Data Analyst Business Intelligence
Dell (LMS)
08.2020 - 08.2021
Service Delivery Engineer II
SME (HPC)
02.2019 - 08.2020
Senior Executive
TATA ELXSI
07.2012 - 02.2019
B.Tech - ECE
Sachdeva Institute of Technology UPTU