About

Venkataraman Sriram is a Senior Software Engineer at Zendesk with over 7 years of experience in data integration and Salesforce. He is highly skilled in SQL, database design, and enterprise business systems such as Salesforce and NetSuite. Venkataraman's experience also includes using ETL tools to build data pipelines and working cross-functionally to automate business processes. Prior to Zendesk, Venkataraman worked at Intapp as an Integration Engineer and Salesforce Developer. He led a team of two developers and focused on project planning and resource management. Venkataraman incorporated robust error handling practices by designing a data audit framework using S3 and Aurora DB. He also automated the Customer Lifecycle process by developing integration in Workato to create Sales Orders in NetSuite from Quotes in Salesforce. Venkataraman improved forecasting in Salesforce by developing a real-time integration in Workato to bring in financial data from NetSuite using SuiteScript and Workato listener services. He delivered product usage insights for the business by creating views in RedShift and visualizing them with dashboards in Sisense. Venkataraman implemented an Apex batch program to run nightly to identify past-due invoices and notify the Customer Success team. He wrote an Apex trigger with a handler to track product ownership details on the Accounts. Venkataraman is leading the migration effort to move all the integrations from Workato to Boomi. He reconciled data between NetSuite and Salesforce by querying the data warehouse and generated a weekly digest report using XSLT stylesheets in Boomi. Venkataraman created custom SQL queries for ad-hoc data requests from business stakeholders. He optimized queries using Common Table Expressions and Window functions to bring in JIRA data from the data warehouse in the required format and then updated corresponding support status fields in OpenAir Projects. Venkataraman has a Master of Science (MS) in Information Technology and Management from the University of Texas at Dallas and a Bachelor of Technology (BTech) in Electrical, Electronics and Communications Engineering from Shanmugha Arts, Science, Technology and Research Academy. His tech stack includes Software Engineering, Salesforce, SQL, Integration, ETL, Data Warehouse, and Test.