Sonal K. Email & Phone Number

Mountain 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

Madison, New Jersey, Us

Project: 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

Hong 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

New York, New York, Us

London, England, Gb