Data Tableau

GLARY CRASTO

Boston, MA ***** ***********@*****.*** 617-***-**** https://www.linkedin.com/in/glary-crasto-31098512b/ TECHNICAL SKILLS & CERTIFICATIONS

Languages: Python, SQL, JavaScript, CSS3, R, Java, PHP, HTML5 Databases: Oracle, MySQL, MongoDB, MS Access, AWS Redshift, Microsoft SQL Server, Azure DW & BI Tools: Tableau, Power BI, MS Visio, Qlik, Adeptia, ServiceNow, Advance MS Excel, QuickSight, Jira Certifications: Tableau for Business Analytics, Google Analytics, SQL Essential, Statistical Foundation EXPERIENCE

Synthesis Health Systems, Boston Jan. 2020 – Mar. 2020 Business System Analyst Intern

• Collaborated with stakeholder groups across the organization to ensure business and technology alignments

• Developed and implement optimal design approach and carry out operational activities including functionality checks, usability checks, and deployment

• Worked with cross-function teams to convert user requirement to deliverable by aggregating ServiceDesk data into the dashboard using tableau which improved team productivity by 40%

• Constructed complex queries to retrieve, analyze and perform data cleansing to remove inconsistent and redundant data which improved decision-making, application performance and, overall customer experience

• Created Business Requirement document and Functional Requirement document and maintaining the Requirement Traceability Matrix related document

TechHighway Systems Pvt. Ltd., India Jul. 2017 – Jul. 2018 System Engineer

• Developed and manage long-term solutions for the efficiency of the company’s IT systems

• Created data-driven visualization using tableau and presented status reports for business meetings

• Developed solutions for key business initiatives ensuring alignment with future state analytics vision

• Performed testing of the integrated system for troubleshooting layouts, technical issues and, bug fixing

• Design and implemented PHP web applications, streamlining high server traffic resources configuration and allocation

• Improvement performance of existing ETL process and SQL queries for weekly CRM summary data

• Utilized Google Analytics and Google Tag Manager to implement new scripts that increased performance by 25%

EDUCATION

Northeastern University, Boston Sept. 2018 – Jun. 2020 Master of Science in Analytics

University of Mumbai, India Aug. 2014 – Jun. 2017

Bachelor of Engineering – Computer Science

ACADEMIC PROJECT

ACME CRM Integration (Advanced MS Excel, MS Visio, Star UML, Anaplan, MS Project) Mar. 2020 – Jun. 2020

• Designed a data transformation model to transfer company’s legacy data management system to new SAP CRM system

• Designed UML diagrams, gathered requirement and determined the scope of the project

• This improved customer management, firm strategy development and efficient resource allocation

• Created budget reports using excel for data validation project and response time to clients as per the agreement Stock Market Prediction (Sentiment Analysis) Apr. 2019 – Jul. 2019

• Performed analysis using twitter and New York times which retrieved positive, negative and neutral emotions

• Analyzed the company’s future profitability on the basis of its current business environment and performance

• Predicted stock prices based on the tweets with the accuracy of 57% Data Analysis with Excel Pivot Tables (Advanced MS Excel, SQL, and Tableau) Jan. 2019 – Apr. 2019

• Gathered Boston living dataset and created a pivot table to analyze, filter and summarize a raw dataset

• Used calculated values and items to get valuable insights from the dataset and pivot charts to display

• Designed visualization using Tableau to depict interactions amongst various elements and analyzed functional specifications as well as database design for the system

Contact this candidate