• 3+ years as a Business Analyst at Google (via Vaco), supporting the Salesforce platform for stakeholders from Finance, Product, and Strategy & Operations• 5+ years of writing SQL queries, data analysis, project management, and collaborating with technical and non-technical audiences
Private
-
Senior AssociatePrivate Jul 2024 - Present
-
Business AnalystGoogle Jun 2019 - Mar 2023Mountain View, Ca, Us*Contracted via Vaco• Wrote SQL queries and leveraged Google Sheets and dashboards to manipulate, extract, and clean Salesforce data from tables as large as 200k+ rows for revenue reporting and analysis• Launched rollout of Salesforce CPQ by prioritizing top 100 customers, migrating key data, and devising a transition strategy for remaining customers • Saved $XXM on fees by collaborating cross-functionally with stakeholders to streamline contracting workflow and improve data quality by 30% • Optimized billing setup by identifying active contracts per customer, resulting in a 70% deletion of obsolete contracts• Reduced data refresh time of Salesforce updates by ~40 hours/month by automating SQL queries to run from biweekly to daily• Managed 5 Salesforce objects by understanding business requirements and enforcing data integrity• Built reports through SQL, Salesforce, and Google Sheets for stakeholders to provide visibility on data• Managed a vendor Contracting team of 4 by designing project plans and providing training on tasks• Performed user acceptance testing (UAT) to ensure implemented processes satisfy business requirements• Handled multiple ad-hoc requests based on priority -
Business AnalystRealogy Holdings Corp. Jan 2019 - Apr 2019Madison, New Jersey, UsProject: Integrate multiple company websites into one modernized portal to be used by 50,000+ real estate agents. • Assisted the Product Owner by writing high level visions and cleaning up user stories to support business needs • Analyzed the business system to understand the backend engineering and data flow• Worked in the Agile technology team with Product Owner, Developers, QA and Automation, and UX/UI• Updated and maintain Confluence documentation that support high level vision of Epics -
Junior Business AnalystSml Group Limited Jun 2016 - Dec 2018Hong Kong, Hk• Managed 7 external clients by gathering business needs, creating project workflow, and interacting with IT team to create technical specifications • Acted as a liaison between internal Key Account Managers (KAM) and developers in IT department to meet client demands and requirements• Maintained and improved EDI/ETL processes between multiple systems to track data flow; tracked root cause of data related issues by running SQL queries• Analyzed Java code to troubleshoot online ordering system (E-Platform)• Wrote technical documentation for each client to highlight workflow• Provided training and troubleshooting assistance regarding E-Platform to clients and SML colleagues -
Data & Research Associate81Qd May 2015 - May 2016New York, New York, Us -
Associate Talent BrokerHays Jul 2014 - May 2015London, England, Gb
Sonal K. Education Details
-
Rutgers UniversityEconomics And Human Resource Management
Frequently Asked Questions about Sonal K.
What company does Sonal K. work for?
Sonal K. works for Private
What is Sonal K.'s role at the current company?
Sonal K.'s current role is Senior Associate | Data & Operations.
What schools did Sonal K. attend?
Sonal K. attended Rutgers University.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial