Deval Panwar
Consultant
Dallas,Texas
Summary
Innovative Decision Scientist talented at discerning and leveraging previously untapped data sources for valuable insight and predictive information. Employs tools such as historical datasets and AI-based analytics to derive exceptional foresight and vital predictions. Positively impacts all ongoing business decisions through careful, proficient data acquisition and analysis.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
6
6
Certifications
Work History
Consultant
Fractal Analytics
Bengaluru, Karnataka
07.2020 - 12.2021
- Working as a Consultant coordinating closely with the stakeholders and Solution Architects.
- Provide high-end consulting to clients at the business head level, help clients sharpen their business strategy by way of developing and implementing analytical solutions/models to realize the business objectives.
- Work with client to align on KPIs and data sources to be used. Defining visuals and key KPIs that enable speed to insights.
- Helping provider of consumer analytics to Insurance carriers, Consumer Banks, CPG and Retail companies by structuring solutions for unexplored areas.
- Defining analytics problem statement in a business context and structure engagements that involve analytics, business, and consulting (ABC).
- Tableau Desktop & Server implementation including live connections with databases like SAP Hana, SAP BW, SQL, Hadoop, Alteryx etc.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
Software engineer
TORCAI DIGITAL MEDIA PVT LTD
Pune, Maharashtra
09.2019 - 05.2020
- With hands-on technologies like Scala, Hive, Spark, Kafka.
- Programmatic ecosystem into components such as Bidder, BI, RTB Analytics, Server-Side Header Bidding, Private Exchange etc.
- Re-engineer complex ad and audience tech workflows and bring in efficiencies with an objective to meet the business goals.
- Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
- Orchestrated efficient large-scale software deployments.
Team Lead
Anand Rathi Pvt. Ltd
Jodhpur, Rajasthan
08.2017 - 06.2019
- Supervised, oversaw, led, managed, and motivated a team of 4 employees as a Team Lead. Prepared detailed reports on updates to project specifications, progress, identified conflicts and team activities.
- Gained end-to-end development experience with Hadoop ecosystem components such as HDFS, Map Reduce, Sqoop,
- HiveQL, Oozie, Map Reduce and excellent expertise in reporting tool Tableau Server and Desktop 2020.4.
- Gained sound knowledge in Data warehousing Concepts, SQL, Dimensional data modeling, Microsoft SQL Server, etc.
- Imported and exported data using Sqoop from Relational Database systems to HDFS and vice-versa.
- Developed Apache Oozie workflows and coordinators and worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
- Designed and deployed data visualizations using Tableau along with creating PowerShell script for auto-mailing and auto-pdf generation.
- Designed and deployed rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
Education
Bachelor of Technology - Computer Science
Vyas Institute of Higher Education
India 07.2013 - 04.2017
Skills
Business Intelligence Analysis
Predictive modeling
Tableau Desktop, Tableau Server
MY SQL
ETL
MS SQL
Post GREs
MS Excel
Certification
Tableau Desktop Certification from Tableau
Additional Information
- Project : MARCO MSC (MONDELEZ SUPPLY CHAIN) Details : To harmonize data across multiple sources(Stackline, Instacart, Rakuten) and present overall view of Total US E-Commerce Market place. Build serf-service Tableau Dashboards and enable users to slice and dice data at different granularities and generate actionable insights.Building specific SKU/E-pack level dashbaords as per business requirements. Project : Verizon Media (Yahoo) is a service that provides developers with RESTful access to mobile search and native advertising results. Details : Worked on the Yahoo Gemini (Native Ad Platform) API, for optimization and native advertising for ad campaigns across repository. Worked on RESTful objects for operations on advertisers and worked on OAuth 2.0 authorization model used by Yahoo to grant access to user data and SPARK for aggregating report data to be used in dashboards. Project : Employee Product Client(EPC) is designed for employees to see their investment in products. Details : - Understanding the data and KPI’s which will be shown on the dashboard. Fulfilling business needs. Connecting Tableau to the database and creating designed dashboards using cross-database joins and different connections.Managing many business users and subscription on Tableau Server.Experience in maintaining clusters performance and up gradation of
Certification
Tableau Desktop Specialist
Oct 2021
Timeline
Consultant
Fractal Analytics
07.2020 - 12.2021
Software engineer
TORCAI DIGITAL MEDIA PVT LTD
09.2019 - 05.2020
Team Lead
Anand Rathi Pvt. Ltd
08.2017 - 06.2019
Bachelor of Technology - Computer Science
Vyas Institute of Higher Education
07.2013 - 04.2017