Samarth Pathak Email & Phone Number

• Associated with Field operations, Sales and Communications teams for BAU/Project related activities to provide Data insights related to BI using MicroStrategy• Prepared best practices to support continuous process of automation for data ingestion and data pipeline workflows• Designed MicroStrategy Schema/Public objects and added to reports and dashboards• Constructed Complex Cube and Dossier designs according to Charter guidelines • Performed performance tuning of reports/cubes using MicroStrategy VLDB settings• Adhered to MicroStrategy Design best practices and organizational guidelines and processes• Executed system/unit testing for MicroStrategy reports/cubes and provided UAT/PROD implementation support• Analyzed/implemented/maintained enterprise interactive and dynamic custom reports/Intelligent cubes using BI Platform• Created wireframes and mockups to validate the reports/dashboard/dossier designs across web and desktop platform• Extensively utilized/written SQL queries for data validation and to create MicroStrategy freeform SQL reports and Intelligent cubes• Demonstrated effective communication skills and ability to work efficiently in fast-paced environment as a Team player• Improved existing schema/public objects designs in MicroStrategy environments to adapt the modified business requirements and enhancements

Swiftwater, Pa

• Analyzed vaccine sales data using BI Tool (MicroStrategy) to forecast the revenue• Evaluated and Validated CRM (Customer Relationship Management) data to improve the customer interface• Developed Dossiers and KPI analysis for Deputy Directors and Managers in order to enhance the decision-making • Resolved user report visualization issues, using scripted Ad-Hoc SQL queries which modified the report objects • Experienced working in Fast Paced and Highly Challenging environment with Business Professionals

Bethlehem, Pa

• Designed a customize High throughput tribometer (under $5k) for NSF project, can test multiple specimens simultaneously• 3D modeled and FEA in SolidWorks to validate the design in fatigue loading and load distribution by varying spring length • Drafted 5 heads with cantilever design with custom load dampening and strain gauges to measure normal and friction force • Built a custom data acquisition system, capable of measuring 10 strain gauges at 1 kHz acquisition with encoders and TNCs • Obtained cycle resolved friction data which is used to define friction co-efficient of specimensTools: SolidWorks, ANSYS, MATLAB, MS Excel

Gujarat, India

• Completed training in manufacturing of ball and roller, used in heavy duty ball and roller bearings.• Involved with wire drawing, wire cutting, heat treatments and surface finishing processes of balls and roller. • Involved with Design and Continuous Process Improvement of high-speed steel ball/roller bearing • Performed fatigue loading test to determine ball surface characteristics and mechanical properties under loading • Gathered PDI, FTT data and applied Pareto analysis to determine major defect modes causing high vibration and noise • Analyzed data from test using SPC and examined the failure modes for steel balls under dynamic loading • Conducted Root cause analysis and recommended changes in design and processing according to ABMATools: Creo, GD&T, NDT, DFMEA/PFMEAManufacturing: Steel Heat treatment, Lapping, Cold drawing

Master Of Engineering - Meng, Mechanical Engineering/Mechanical Technology/Technician

Bachelor Of Engineering - Be, Mechanical Engineering