SAYALI BHAGAT

Apt *, **** Tremont Street, MA-****0 Cell: 857-***-**** adbvmo@r.postjobfree.com

http://linkedin.com/in/sayali-bhagat https://github.com/SayaliBhagat EDUCATION

Northeastern University, Boston, MA Expected May 2020 Master of Science in Information Systems

(Relevant Courses: Digital Marketing Analytics, Data Management & Data Design, Data Science Engineering Methods, Advance Database Management System, Designing Data Architecture & Business Intelligence, Planning & Management in Information Systems, Application Engineer & Development)

Pune University, MH, India Aug 2012 – Jul 2016

Bachelor of Engineering in Electronics and Telecommunication SKILLS

Programming Languages: Python (SciPy, Numpy, Matplotlib), Java, C++, PL/SQL, MATLAB Operating Systems: Linux, Windows XP, Mac OS

Cloud Platform: Salesforce, AWS, Google Cloud Platform, Azure Database: MySQL, Oracle (11g, 18xe), SQL Server, MongoDB Analytical tools: Tableau, PowerBI, Excel (Pivot Tables), Einsten Analytical Studio, Talend, Altreyx, Qlikview Tools: Sql Developer, Eclipse, Netbeans, WinScp, SVN, JIRA, GIT, MS Project, Visio EXPERIENCE

John Hancock-Manulife, Boston, MA July 2019 – Dec 2019 Platform Data Specialist

• Leaded various Informatica Upgrades to make the 76 applications on Platform Service to be compatible with Azure Cloud and created several reports on Salesforce Fusion Risk Management

• Generated easily accessible dynamic report and queries for Portfolio Manager to have better insight of making decision for their funds and thus increasing their potential for making additional revenue using Power BI, Microsoft SQL Server Management Studio

• Created automated dashboards to visually track, analyze & display KPI, metrics & key data points to monitor the funds & revenue on Power BI & generated automated weekly mail for this health report

• Used MS Project for managing the tasks, Visio for creating different diagrams for the flow of upgrade and JIRA for raising the tickets

Accenture Technology, India Aug 2016 - Jul 2018

Application Development Analyst

• Reviewed, developed, and designed data models, in conjunction with the application development team, created complex Stored Procedures, Triggers, Tables, Cursors, Views and SQL Joins and made extensive use of Dynamic SQL scripting

• Managed database integration issues including migration between disparate databases using SQL Server Integration Services and was a part of CRM team

• Involved in Designing databases utilizing MS SQL Server 2017 and Oracle DB, using data from various data sources

• Generated comprehensive analytical reports by extensively utilizing analytical tools like Tableau, PowerBI as per the business requirements and validated already developed Python reports

• Designed and converted a functional requirement from business end in form of Excel and XML to a technical design for the customer and the enterprise market using Oracle SQL and order management

• Handled Automation of the Siebel Product Catalogue deployment and other development activities using various technologies like Visual Basic, Siebel Workflows and Siebel eScript PROJECTS

Data Integration for Hotel Analysis (Talend, Qlikview, Tableau, AWS, GCP, SQL Developer) Feb 2019 - Present

• Designing & integrating a centralized data warehouse by pipelining data from distinct data sources using Talend

• Validate ETL Mappings & using Amazon Athena to analyze data in Amazon S3 for better performance

• Built interactive dashboards on Tableau & Qlikview to convey stories of the analysis & used GCP for data cataloging Stitch Fix pipeline and Market Analysis (Salesforce, GCP, Python, SQL, Tableau, Qlikview) May2019 - June 2019

• Designed data architecture and custom objects in Salesforce and integrated the output of various algorithms to Salesforce Sales Cloud to analyze the business performance

• Uploaded the data on the GCP big query and connected to Tableau for further data visualization

• Developed a recommendation system for better customer retention using Python and used SQL for data improvement and quality

Housing Price Prediction with Analysis of Dataset (Python, Machine Learning, Power BI, Excel) Jan 2019 - Mar 2019

• Conducted an exploratory data analysis using Python packages (Plotly, Seaborn, Matplotlib) to understand the dataset and created dashboards on Power BI to display key metrics of housing price

• Piloted a thorough feature analysis and used data cleaning techniques to make the data usable for further analysis

• Implemented Linear Regression to build House price prediction model using Sklearn libraries with an accuracy of 82.3% having target variable as price

Customer Relationship Management Database (SQL Server, Excel, MySQL) Oct 2018 - Dec 2018

• Created a CRM database of the products and services provided by the Telecom service for the customers

• Generated widespread diagnostic reports by extensively utilizing analytical tools like Excel

• Created data models and convoluted Stored Procedures, Triggers, Tables, Cursors, Views and SQL Joins

Contact this candidate