Smriti Singh

Operations Specialist

Amazon

Hyderabad, Telangana

03.2017 - Current

Well versed with Microsoft tools, machine learning tools and libraries, R, Python, Advanced Excel, macro and VBA, SharePoint, SQL and analyzing large data sets using Tableau and Power BI .
Wrote complex SQL scripts to improve the performance as the volume of the data was heavy.
Generated advanced Tableau dashboards with quick/context/global ﬁlters, parameters and calculated ﬁelds that allowed to track and improve customer complaints by 20% within a month.
Good experience in dashboards designing for large data volumes from different data sources (SQL servers, teradata etc).
Automated reports and data ingestion processes for 4 programs using SQL, Excel VBA, and Python tools.
Worked with leadership and stakeholders to understand business needs and translated those business needs, generated business insights using Python, R and created interactive data analysis report by analyzing data sets in Tableau server for the team with global ﬁlters and parameters that helped saving the manual efforts of 15 hours every week.
Generated Business insights for process improvements by performing data analysis using advanced excel and SQL and identified root cause for the trending customer issues which helped in reducing customer's issues by 2ppm.
Text-mined the review/complaint data to identify the issues that customers had which helped reducing the customers complaints by 21%.
Predicted data inflow with 98% accuracy which helped tagging the data without missing the ETA.