Srihitha Sivannagari

626-***-**** admhrz@r.postjobfree.com LinkedIn Tableau Public GitHub Profile

PROFESSIONAL SUMMARY

Analytically skilled professional with proven experience performing data analysis and developing results for making businesses decisions in an operational and analytical sector.

Expert in creating interactive dashboards and reports using visualization tools.

Worked extensively with Advance Analysis Actions, created Complex Calculations, Parameters, dynamic sets, groups, tooltips, dashboard actions, table calculations, LOD expressions, timeseries blending, dynamic Reference Lines, joining and blending data, multiple tables joins to create, custom SQL to develop interactive reports in Tableau.

Experience in various versions of Tableau products Tableau Desktop 2020.1, 2019.1, 2018.x, 10.x, Tableau Server, Tableau Online, Tableau Prep, Tableau Public, Tableau Reader and with Tableau administration (group permissions, row level security, views etc.).

Expertise in writing SQL queries to generate reports, data manipulation, normalization, standardization, and dashboards migration.

Familiar with Python Libraries like Numpy, PySpark, Matplotlib, Beautiful Soup and Google Doctor.

Experienced in writing SAS, Python and R scripts to perform ad-hoc analysis and data manipulation.

Proficient in Advanced Excel, emphasis on creating PowerPivot tables, look ups and charts.

Experienced in collaborating with teams located worldwide to track deliverables in tools like Microsoft Project Server, Planner, Jira, Clear Quest and QMET.

Good understanding of Agile Scrum and Waterfall methodologies.

Used Business Intelligence Reporting Tools to define and create KPIs to improve corporate profitability measures and comparative financial analysis.

Exposure in Machine Learning Algorithms and in Data Science.

Demonstrated asset to organization, through exceptional cross-functional teamwork, leadership skills, quantitative and logical aptitudes, and motivation to complete projects to the best of my ability.

Skills

LANGUAGES

SQL, PL/SQL, PYTHON, JAVA, HIVE QL, PIG, SAS

BI TOOLS/ REPORTING TOOLS

TABLEAU, R STUDIO, POWER BI, MS EXCEL, POWER POINT, THOUGHTSPOT, SPOTFIRE

WEB DEVELOPMENT

JAVASCRIPT, HTML5, CSS, REACT, REDUX

DATABASES

MySQL, ORACLE, MS ACCESS, AWS REDSHIFT, BIG QUERY, POSTGRES

PROGRAM MANAGEMENT TOOLS

SAP, JIRA, MS PROJECT, SMARTSHEET, SALESFORCE (GAINSIGHT, LIGHTENING)

DATA SCIENCE

MACHINE LEARNING ALGORITHMS, AZURE ML, HADOOP, SPARK ML PySPARK.

Experience

NOV 2020– PRESENT

Business Intelligence Analyst/ Palo Alto Networks – Santa Clara, CA

Developed SQL scripts in Big Query to generate views and tables that can be leveraged across teams.

Collaborated with Customer Success Leadership to develop dashboards for product Click Analysis and customer success account team’s Survey Analysis across product line.

Developed dashboards using Tableau to analyze the deployment status of the products after purchase.

Developed custom logic to switch between periods, flexible data table with parameters as columns with several global filters, click through visualizations to generate relevant filtered data tables.

Migrated over 30 dashboards from Postgres to Big Query. Rewritten the SQL code and evaluated the data load time for both sources to generate same values.

Maintained and evaluated dashboards against Gainsight (Salesforce). Obtained Gainsight data and ran unit tests for data consistency.

Enhanced existing dashboards by reducing the worksheets for optimization, added dynamic global filters and features. Standardized reports added About tabs for all the CS dashboards for easy consumption.

Tracked ETL pipelines in daily scrum meetings for dashboards migration and developments.

JAN 2020 – OCT 2020

Business Intelligence Developer / Cisco – San Jose, CA

Developed Operational and executive dashboards, story boards using Tableau desktop and Server – Used LOD’s, row level security, complex calculation fields, scheduled refreshes, custom parameters for switching between Fiscal and Calendar year and sales levels etc.

Leveraged SAP FIN BI (Teradata-TSQL), Salesforce Lightening, Tableau Desktop, Tableau Prep, third party sources (IDC, Gartner) and Excel for bookings and Market share analysis.

Performed extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulations in Excel for WBR’s.

Tracked strategic Wins/Losses every week to help management have a view into the market trends. Automated the process using SAP, SFDC, Python, Excel, and Smartsheet via Outlook to drill down the reasons for losses due to quote to cost, pricing, or technology limitation buckets.

Tracked Bookings and Progress to forecast unit quantities for Bookings target Business Units.

Coordinated with cross functional teams, Sales, Product Management and Finance teams for pricing analysis using Python.

Developed and maintained weekly report (WBR) for the for leadership to provide weekly status.

Tracked deals in the pipeline for the quarterly (QBR), year over year analysis and discount rate.

Drove strategic programs and promotions & tracked ROI with success metrics with the sales segment assigned.

JAN 2019 – DEC 2019

Data Application Developer / Bayer Crop Science – Sacramento, CA

Analyzed requirements, ensured system enhancements, and integrated application components.

Utilized Python String methods to develop scripts for automating data standardization and management for Bacteriology and Virology plate image analysis.

Developed dashboards for current Lab capacities, sample volume forecast, people analytics, strategic finance, and Operational reporting in Tableau and in Spotfire.

Developed data flow for Customer data interface, results database, and seed certificate generation.

Created custom solution for sample submission portal for customer using Nintex forms.

Automated sample handoff communication between different tier/ platforms using dependencies.

Coordinated with lab experts, stakeholders and technicians in data gathering, analyzing, and uploading into SAP to generate PSN values.

JUNE 2018 – JAN 2019

Business Data Analyst / Qualcomm – San Diego, CA

Developed and published customized interactive reports for scheduling releases, milestone tracking, resource management, AI tracking and CR tracking using Tableau server (2018.1).

Managed permissions for users, groups, task schedules and repositories and monitored performance threshold, as a part of Tableau Server administration.

Collaborated with engineers in defining KPI’s to understand the area, productivity, performance, quality, and other new initiatives related metrics taken by engineers for product analytics.

Developed Chip portfolio KPI metrics in QMET to generate reports for financial decisions.

Created weekly status reports for Core Lead Engineers in ThoughtSpot to mitigate project risks.

Coordinated with over 180 teams located worldwide to clearly define, document and track Action items, Change Requests and Jira Tickets.

Tracked milestones, deliverables, dependencies with clients and internal teams for various cores for multiple project releases in Microsoft Project Server and Utilized Python String methods to develop scripts for automating data standardization and management for

NOV 2016 – DEC 2017

Data Analyst / Jones Lang LaSalle– Los Angeles, CA

Performed ad-hoc analysis using Tableau and operationalize for repeatable use.

Validated reporting results against requirements and analyzed data issues within reports.

Identify and coordinate data retrieval and aggregation from AWS Redshift.

Developed Python script for data lineage.

Partnered with data scientists in efforts to create data that could be used for BI applications.

Developed data management and analytic processes to support ad hoc data and information delivery for assigned projects.

MAY 2014 – JUNE 2016

Software Developer Intern/ V-Empower – Hyderabad, TG

Created database objects like data tables, indexes, views, and stored procedures using MySQL.

Created SQL queries to extract data for reporting.

Knowledge on MSSQL server installation, Migration, Upgrade of relational databases.

Installed packages, patches, and fixes for the database.

Participated in developing SQL jobs (agents, alerts).

Maintained copies of backup log files before SQL server upgrade. Gathered software requirements and consolidations from clients and end users.

Education

Master of Science in Information Systems / California State University, Los Angeles (2017 – Dec)

Co-developed Predictive Analysis using Azure Machine Learning, PySpark in Databricks (Supervised Learning-Classification) Performed Big Data Analysis(historical) using Pig and Hive QL. Constructed a Predictive model using Azure Machine Learning (Supervised Learning – Regression) R Programming Tableau Python.

Bachelor of Computer Science Engineering / Osmania University (2016-May)

SQL React Redux HTML Java frames Java C, C++ SDLC Computer Networking Java

Contact this candidate