Siddharth Swarnkar Email & Phone Number

Raipur, Chhattisgarh, India

Pune, Maharashtra, India

• Developed Dashboards in Periscope using MySQL query for Data preparation to Analyze Call Center CRM KPIs such as Handling Time, Call Resolution and Disposition for Customer Success and Performance Management.
• Migrated Dashboards from Outgoing reporting software Periscope to Sisense along with converting stored MySQL snippets containing Business Metric Logic into JAQL stored formulas.
• Developed Automated Data Validation and Alert methodology for stored Data Sets optimizing Great Expectations and alerting channels such as Slack Webhook and Gmail SMTP server.

Austin, Texas, United States

• Developed Award winning Self Service Analytics Reporting Platform for Texas Department of Transportation using Tableau Prep and Tableau Server with Ready to Use Data available anytime to both internal and external.
• Created Several Unified Data Sets incorporating multiple calculated fields, statistical calculationsand complex business logic, optimizing the Data with Cleaning, Deduplication, Aggregation, and Manipulation operations.
• Developed fully Integrated and interactive Tableau Dashboards for Project Letting andProject Performance Analysis in Texas State using Automatic Data refresh connection showcasing Line Chart, Combined bar and Line.
• Developed and Managed Reports in JasperSoft Reporting Studio using SQL query to provideweb based reporting solutions to both external and internal clients for Bidding and Lettingdata.
• Provided User Training to several Districts and Divisions in Tableau Desktop and TableauServer with Practical Demonstration & Support on Dashboard development and Servercontrol.
• Managed Tableau Server access as Tableau Server Administrator per business users accessneeds and requirements for Dashboard Sharing and Distribution.

Austin, Texas, United States

Phoenix, Arizona Area

• Data Analysis and Data Modeling of Relational and NoSQL Database optimizing multiple Datasets across multiple Data Sources with Tabular export to Big Data Platforms.
• Innovation Award winner in Cox wide Intern Challenge for Improving Self Install capability of Cox Cable products with $10 million annual operational cost reduction.
• Analyzed Big data structures of Citrix, ExtraHop including server and system logs of Cox Communication with ETL design and development of the Talend & SQL mappings, sessions and workflows to implement the Business Logic.

Arizona State University, Tempe, AZ

• Analyze and Report Operations, Sales, and Inventory metrics enhancing Customer Success for Campus Retail in Excel.

Raipur Area, India

• Optimized heat transferring structure of composite material with 78% of weight reduction without compromising strength and heat transfer rate as compared to conventionally used Aluminium Alloy (Al1060) structure.
• Author of International Research paper "Comparison of Heat Transferring Fins of Conventional Aluminium and Metal Matrix composites" published in Journal of Technological Advances and Scientific Research (JTASR).

Bhilai Area, India

• Developed process models and reports based upon analysis in the fields of production planning and control, operations and logistics.
• Designed an inventory control model of raw materials in ERP modelling and analysis tool, effectively reducing waiting time by 10%.

Master Of Science (Ms), Industrial Engineering, 3.2/4.0

Activities and Societies: Institute of Industrial and Systems Engineers• Graduated in Industrial Engineering major with specialization in.

Master Of Business Administration - Mba, Computer And Information Sciences And Support Services

Bachelor’S Degree, Mechanical Engineering, 8.61/10

Activities and Societies: Student Welfare Association of Mechanical Engineering• Graduated with Honors in Mechanical Engineering. •.