Data Visualization, Tableau, ETL, Analysis

SURBHI GOLCHHA

Stamford, CT 201-***-**** **********@*****.*** https://www.linkedin.com/in/surbhi-golchha/ SUMMARY

• Certified Tableau Developer with “Tableau Desktop Specialist” certification from Tableau.

• Over 3 years of data visualization & analysis experience with modern BI tools.

• Master of Science in Computer Science from Pace University, New York and Bachelor of Science in Computer Science from Bhilai Institute of Technology, India.

• Always on the forefront of modern BI tools. Incorporated Ask Data (Natural Language Processing), Tableau Catalog, Explain Data, etc. available in the latest version of tableau to derive insights from complex data and provide self service capabilities to the end user. Attended Tableau conference twice to stay ahead of the curve.

• Expertise in transforming data into visualizations by understanding business requirements and presenting a complete story by identifying insights buried deep within the data using complex excel functions, Power Pivot and Power Query.

• Advanced Microsoft Excel for Data Analysis certified professional with proficiency in handling huge amount of data and mining crucial and relevant data using advanced techniques like VLOOKUP, HLOOKUP, XLOOKUP, Pivot Table, Macros and Data Validation.

• MySQL certification along with over 3 years of experience of updating, cleaning and extracting relevant data from complex SQL databases. Ability to write complex custom queries and stored procedures. PROFESSIONAL EXPERIENCE

NYC Department of Citywide Administrative Services New York, New York Data and Strategy Analyst 07/2019-12/2019

• Designed and created complex reports and dashboards in Tableau using LOD Expressions, nested filters, sets, parameters, dashboard actions, etc.

• Storehouse space management: Increased the storehouse storage capacity by almost 20% through analyzing the order history & storage pattern of 1000+ commodities being delivered to 1800 locations. Thus, making it far more cost effective.

• Delivery Efficiency: Helped increase the efficiency of item delivery by analyzing the order history & ordering pattern from all locations & then setting a threshold for minimum items per order by location. This helped reducing overall trips to all locations, saving fuel and time.

• Built interactive dashboards in Excel using nested formulas, connected slicers, pivots and excel charts.

• Expertise in coming up with creative ways for cleaning data in excel and sql along with process automation using Macros in excel.

• Worked directly with various customers to understand their business and help to define and articulate requirements.

• Built an automated reporting package in Excel using Macros and complex data manipulations making it easy for non-technical individuals to generate reports daily.

Frutley Raipur, India

Lead Business Analyst 07/2017 – 05/2018

• Developed complex Tableau Visualizations. Participated in requirement gathering, prepared BRD document. Extensively used parameters, calculated fields, sets, actions and filters in the Report Development.

• Took ownership of the project to build a comprehensive system of report generation and analytics from ground up that can be used by multiple departments within the company to take calculated administrative decisions.

• Acted as a liaison between the technical teams overseas and the leadership in US to understand the business requirements.

• Used SQL database to clean data and generate reports by writing complex queries and thus saving time and effort daily and providing time to work on multiple projects.

• Worked with business stakeholders to design and build Tableau solutions based on requirements gathered or provided. Institute of Dermatology Raipur, India

Business Analyst 01/2015-06/2017

• Analyzed the consumer requirements, market trends, competitor landscape and the best marketing strategies being used by the companies worldwide.

• Used complex excel functions that reduced time consumption and error due to manual work.

• Extensive use of complex functions in Microsoft Excel to extract the data and automate maximum reports to save time and increase efficiency.

• Compelling visualizations of complex and publishing them to the Tableau server.

• Worked directly under the CEO and acted as a liaison between different teams. EDUCATION

Harrisburg University of Science and Technology Harrisburg, PA Master of Science (MS) in Analytics GPA 3.8 02/2022 Pace University, Seidenberg School of Computer Science and Information Systems New York, NY Master of Science (MS) in Computer Science GPA 3.7 12/2019 Bhilai Institute of Technology Bhilai, India

Bachelor of Science (BS) In Computer Science GPA 3.7 06/2013 CERTIFICATIONS

• SQL Server and MySQL certification from National Institute of Information & Technology, India.

• Advanced Microsoft Excel for Data Analysis from Udemy.

• Tableau Desktop Specialist Certification from Tableau. TECHNICAL SKILLS

• Languages: MS SQL, MySQL, R

• Office Applications: Microsoft Word, Excel, PowerPoint, Access, Microsoft Project, Apple Keynote, Numbers, Visual Basic

• Data Visualization: Tableau, Power BI, Adobe Analytics, Domo.

Contact this candidate