Spurthi Shetty

Nashville, TN addp1m@r.postjobfree.com 857-***-**** www.linkedin.com/in/spurthishetty Education:

Northeastern University Boston, MA Master of Science (MS), Information systems May 2019 Atharva College of Engineering Mumbai, India Bachelor of Engineering, Computer Science June 2017 Technical Skills:

Languages: Python, SQL, R

Database technologies: MySQL, MS SQL Server, Oracle, PostgreSQL, MongoDB Data Analytics and BI Tools: Tableau, Power BI, Looker, QlikView, MS Excel (Pivot Tables, VLOOKUP) ETL and Big Data Technologies: SSIS, Talend, Alteryx, Hadoop, Sqoop, Hive, Apache Spark, SSMS, Teradata Web Analytics: Google Analytics, Adobe Analytics

IDEs and Tools: Git, MySQL Workbench, Microsoft Azure, AWS (EC2, S3), Data Bricks Work Experience:

Data Services Analyst III The General Insurance, Nashville, TN October 2019 – March 2020

• Performed ETL data integration using Alteryx and developed Tableau dashboards to analyze KPI’s and trends to improve performance of the firm

• Perform data discovery, profiling and data quality using SQL Server (SSMS) and various other tools, like Alteryx ETL Tool for running SQL queries in Agile methodology using JIRA stories.

• Built and maintained end-to-end BI cycle ETL pipelines, implemented Enterprise Report Development lifecycle and created SSIS packages by working with cross functional teams to gather business requirements, defining metrics and KPI indicators

• Automated in migrating reports from Snowflake in Alteryx to Tableau sever and successfully archived reports

• Develop data warehouse and business intelligence architecture, technical standards, centralized technical metadata, data quality scorecards, dashboards and ad-hoc reporting. Maintained and documented ETL mappings from various sources for applications deployed in production

• Integrated data into a central source using cloud platform Snowflake in Alteryx to get all the needs of the customers in various fields perform better analysis using Tableau

Business Data Analyst Radiant Technologies, Mumbai, IN June 2016 – July 2017

• Worked with Analytics team to evaluate & developed organizational change business models with the requirements, also gathered, analyzed and documented business and functional requirements and created UML diagrams for systems analysis

• Designed and Deployed Enterprise Reporting Catalog (Centralized Repository for all Business Reports) using SSIS, SSRS and deployed it on Azure cloud platform

• Extracted and Integrated insights from data, using Teradata platform for executing SQL queries and building visualizations in Tableau to show trends to support decision making by adopting best practices in reporting and analysis

• Translated the business needs into analytic and reporting strategies through the development, execution of data, implemented Python, R to web scrapping and data wrangling processes for structured as well as unstructured data

• Migrated data from OLTP to OLAP by using big data technology Sqoop for ETL process and HIVE to fetch data and performed data visualization to develop BI reports consisting of interactive dashboards, charts to perform trend analysis, using Tableau

• Deployed SQL queries cloud platform Microsoft Azure & AWS Platform for overall better performance & efficiency Academic Projects:

Facial Expression Recognition using CNN in Real Time Python May 2019

• Developed a Facial Expression Detection Predictive Deep Learning model using CNN, Numpy, Pandas, OpenCV

• Automated real time function to detect the emotion using Computer Vision to capture the emotion of any individual in motion using OpenCV by training the model in Convolution Neural Network using TensorFlow and Keras Data Integration & Warehousing on a Retail Store SQL, Talend, Tableau, Qlik View, Power BI December 2018

• Developed a data warehouse, pipelining data from diverse sources such as CSV, MSSQL, Postgres SQL, Oracle, MySQL

• Created mappings to extract, load facts and dimensions into warehouse using various transforms such as filters, joins

• Performed Data Integration with 4M+ rows of data which involved data-conversion, error handling in rejects table, calculating measures using SSIS and Talend and custom dashboards to convey stories of Retail, & Profits in Tableau, Power BI & QlikView Chicago Employee Statistics using Business Intelligence Power BI May 2018

• Developed a data warehouse, pipelining data from diverse sources such as CSV, MySQL for the data insights

• Built interactive visualizations to convey the story of annual, part-time and full-time salary of Chicago city by using Power BI Inventory Database Management System MySQL, Apache Spark December 2017

• Developed a Database Management System on MySQL and Apache Spark to manage the inventory sales efficiently and implemented CRUD operation for product, orders, sales and suppliers and designed ER Model that embodies the functionalities

• Performed joins, procedures and views on certain required tables to generate complex data analysis

Contact this candidate