Resume

Sign in

Tableau, SQL, Python, BA, BI, DA

Location:
San Francisco, California, United States
Posted:
August 13, 2019

Contact this candidate

Resume:

Srihitha

Sivannagari

626-***-****

ac92l0@r.postjobfree.com

www.linkedin.com/in/srihitha-reddy/

public.tableau.com/profile/srihitha.reddy#!

https://github.com/srihithasreddy

PROFESSIONAL SUMMARY

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

Expert in creating interactive dashboards and reports using BI tools like Tableau, Spotfire and Power BI.

Worked extensively with Advance Analysis Actions, created Calculations, Parameters, 3D Scatter plots, dynamic Reference Lines, joining and blending data to create interactive reports.

Experience with Tableau administration (group permissions, views etc.).

Expertise in writing SQL queries to generate reports from MYSQL database

Familiar with Python Libraries like Numpy, PySpark, Matplotlib, BeautifulSoup 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 enterprise tools like SAP, 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, C, C++, 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

MSSQL SERVER, MySQL, MS ACCESS

PROGRAM MANAGEMENT TOOLS

MPS, JIRA, CLEAR QUEST, TEMPUS, SAP, MS PROJECT

DATA SCIENCE

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

Experience

JAN 2019 – PRESENT

Data Application Developer (General) / Bayer Crop Science

Analyzed requirements, ensured system enhancements and integrated application components.

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

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

Created sample submission portal for customer using Nintex forms.

Developed dashboards for current Lab capacities, sample volume forecast and capacity utilization in Spotfire.

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

Managed weekly and monthly resource management.

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

JUN 2018 – JAN 2019

Business Data Analyst / Qualcomm

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.

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 180 teams located worldwide to clearly define and document Action items.

Managed all the Action Items, Change Requests for the cores in Clear Quest and in Jira.

Tracked milestones, deliverables, dependencies with clients and internal teams for various cores for multiple project releases in Microsoft Project Server.

FEB 2018 – JUN 2018

Data Analyst / Jones Lang LaSalle

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

Aggregated, cleansed and analyzed data from disparate sources and provided insights and trends using Tableau Server and Desktop.

Performed data mining by developing SQL queries to research and troubleshoot data.

Wrote SAS code for transforming and imputing missing values in the properties data.

Performed data discovery through packages like Google Doctor in Python to understand data values and relationships in new property locations data sources.

Developed documentation and data flow diagrams to maintain accurate metadata and data lineage.

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

NOV 2016 – JAN 2018

Tableau Developer / Chrome River Technologies

Performed ad-hoc analysis using SQL and operationalize for repeatable use via Tableau (story telling).

Created executive level presentations based on analytical results and trends using Tableau, helped in making crucial vendor management decisions

Developed interactive dashboards and visualizations per specified requirements and timelines on Tableau Server.

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

Used SQL queries to gather and analyze data to enhance existing features accordingly.

Identify and coordinate data retrieval, normalization, and aggregation from multiple sources.

MAY 2014 – JULY 2016

Data Analyst / V Empower

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.

Assisted in implementing Database Mirroring and Transactional Replication as a part of DR plan.

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.

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

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

AVAILABILTY: IMMEDIATELY

VISA STATUS: OPT EAD (VALID UNTILL AUG 2021)

SPONSORSHIP: H1 – B REQUIRED



Contact this candidate