Shruthi S Email & Phone Number

San Francisco, Ca, Us

Mountain View, California, United States

• Leveraged SQL to query, extract data from structured/unstructured databases, manipulate and transform data to prepare it for data analysis, and perform various calculations and aggregations to derive insights, I also leverage SQL for data quality checks and validation.• Being a primary point of contact for Finance. Delivering Annual Recurring Revenue (ARR), Gross New ARR, Average Revenue per Account, Churn rates related dashboards and ad-hoc reports. • I used the Salesforce application in conjunction with Egnyte's proprietary billing system to seamlessly integrate data related to quotes, orders, customer billing, and account information. • Utilizing R, Python to perform data wrangling and preprocessing, and prepare data for predictive modeling. This enabled more accurate forecasting, regression and decision-making.• Collaborated with Finance, Product team, Marketing team, Sales Operations Manager and executives to communicate insights analysis, conducting A/B testing for business decisions.• Identify KPI metric issues proactively, analyse, derive solutions, and communicate the outcomes to stakeholders effectively to support BI solutions.• Collaborated with team members to ensure the integrity and functionality of various tools and models, and contributing to streamlined workflows for strategic BI decisions.

Bangalore Urban, Karnataka, India

• Led a team to define business needs, develop, implement and test data sources that provided key insights to the Finance and Accounting leadership teams.• Experience assisting Telecom VP in driving business growth.

Bengaluru, Karnataka, India

• Leveraged SQL Server, Hadoop, Snowflake SQL and Tableau and create comprehensive analyses of network opportunities, transforming intricate data into accessible visual insights for the Cisco Products. • I oversaw two Telemetry reports abroad, providing mentorship to facilitate the team members become successful contributors in their own right. I reviewed their work, conducted quality assurance activities to aid in their development, and ensured the quality and accuracy of their output before presenting it to the leadership team. Additionally, I independently contributed to various projects.

San Jose

• Leveraged SQL Server, Hadoop, Snowflake SQL and Tableau and create comprehensive analyses of network opportunities, transforming intricate data into accessible visual insights for the Cisco Products. • I oversaw two Telemetry reports abroad, providing mentorship to facilitate the team members become successful contributors in their own right. I reviewed their work, conducted quality assurance activities to aid in their development, and ensured the quality and accuracy of their output before presenting it to the leadership team. Additionally, I independently contributed to various projects.

California

Mead Johnson Nutrition Foster City CA May 2015 - March 2019Business Intelligence DeveloperMead Johnson is a nutrition company that develops products for infants & children. They had around 100+ servers (Development, QA, Testing and Prod) for research, sales and products data. • Involved in end to end implementation and enhancements on nutrition products data starting from requirement gathering and dashboard development in tableau desktop. • Studied & analysed similar applications & brainstormed with business team to gather effective requirements from the system. • Created Crosstab charts to display underlying data based on various graphs and charts created for further data analysis. • Experience in creating dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources. • Used Tableau for the data / business predictive analysis, for trend analysis, for finding the pattern of data over the period of time. • Effectively used data blending feature in tableau. • Created worksheets & dashboards by using custom queries & multiple tables. • Analysed the requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop. • Created filters, parameters, groups, sets, hierarchies, drill down and drill up as per the specification. • Executed and tested required queries and reports before publishing. • Developed scatter plots and area map to show states utilizing the child nutritions most v/s least. • Participated in weekly meetings, reviews and user group meeting as well as communicating with stake holders and business team.Environment: Tableau Desktop 9/10, Tableau Reader, Tableau server, Oracle, SQL, Flat files, SQL server, MS-Excel, Statistical files, Microsoft access and Extracts.

Bengaluru Area, India

IBM Bangalore India Sep 14 – May 15Client: Michelin North AmericaBusiness Intelligence DeveloperMichelin is the third largest tire company and it has many (189+) servers for their transaction data, application databases. • Analysis of Business requirements & site specifications to create Business Requirement Document (BRD) & Design Document (Functional and Technical). • Developed various dashboards illustrating data visualizations using tableau Desktop. • Involved in license management SLA's with Tableau support. • Developed proof of concept for best practices in tableau development & Deployment also for ad-hoc reporting. • Design and create innovative and valuable visualizations in Tableau to track KPI's, metrics and other key data points. • Provide data visualizations using Arcadia, Tableau on the Hadoop Landing Zone to help executive leader’s decision making process. • Demonstrate intellectual curiosity and passion about data, visualization and solving business problems. • Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insight into large data sets. • Review stakeholders status reports with project team and created visualization for budget forecasting. • Took backup of the tableau servers on a regular basis by using Tab-admin commands and have also restored when there is necessary. • Involved in trouble shooting and performance tuning of reports and resolving issues within tableau server and reports. • Use Measure name and Measure value fields to create visualization with multiple measures and dimensions. • Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.Environment: Tableau Desktop 8.3/9.0/9.2/10.0, IBM Cognos, SQL Server 2008/2013, Teradata, MS Excel, MS Access, SAP BO, SSIS

Bengaluru Area, India

IBM Bangalore India Jul-14 - Feb-15 Client: Michelin (France)Business Intelligence Developer • Understand requirement, Analysing System and Source Databases. • Communication with client for requirement gathering and reviews. • Analysis of certain reports which are producing errors and modifying them to produce correct results. • Developed the Reference lines in reports by using Parameters. • Published the workbooks and Data sources with offline and online connection. • Have worked on extract some data when there is a requirement, have also worked in depth about Live and Extract data. • Used advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data. • Provided guidance and insight on data visualization and dashboard design best practices in Tableau. • Have worked on Box and whisker plot while providing sales and profit related report to customer. • Have worked on different types of Marks card to show better visualization in the report. • Created Filter Actions, Highlight Actions and URL Actions to link worksheets. • Implement advanced geographic mapping techniques and use custom images and Geocoding to build spatial visualization of non-geographic data. • Involved in creating a dual-axis bar chart with multiple measures.Environment: Tableau Desktop 9.x/8.x, Tableau Server 9.x, MySQL, ETL, SSRS, SQL Server and Windows.