Data Analyst

Shravya Pathuri www.linkedin.com/in/shravya-pathuri-6a727961 Bellevue, WA •425-***-****

•**************@*****.***

EDUCATION: Jawaharlal Nehru Technological University - CMRTC Hyderabad, India (Bachelor of Technology) SKILLS:

● Programming - Kusto, Python, SQL

● Cloud Expertise - Azure Data Factory, Azure Data Lake, Azure Data Explorer, Data Bricks

● Tools - Power BI, SQL Server, Kusto Explorer

● SDLC methodologies: Waterfall, Agile (Scrum)

WORK EXPERIENCE:

Motive, Bellevue

Data Analyst Client: Microsoft April 2020 - July2020

● Analyzing larger telemetry data sets with Customers experience sites that encourage them to discover and engage with developer tools, content, and resources.

● Develop, manage, and troubleshoot refresh issues in Power BI reports/ dashboards connecting to various data sources such as Azure Data Explorer (Kusto), Azure Data Lake.

● Created aggregated tables within Kusto from large data sets with Optimized SKU clusters.

● Creating and automating pipelines using Azure Data Factory for daily ingestion of data into aggregated tables.

Team Lease Pvt Ltd, Hyderabad.

Data Analyst Client: Deloitte Oct 2018 - May 2019

● Worked on tracking Multi-factor Authentication usage for Deloitte applications that provides an additional level identity verification.

● Created Dashboards by analyzing disparate data sources for identity and access management teams which helped them make business decisions that led an increase in multi-factor usage from 60%-65%.

● Compared the adoption of different kinds of Multi-factor Authentications and exposed their provisioning user experience which led the business to improve the user experience in terms of allocating resources.

Tech Mahindra, Hyderabad.

Associate Software Engineer Client: Virgin Australia Airlines Dec 2015 - Oct 2017

● Analyzed the data, worked on multiple KPIs, and developed a set of reports which provides data -driven insights to the team.

● Worked with upstream data source teams for any data discrepancies, worked together with the data engineering team for any failures with respect to data loads.

● Connected to different data sources like On-Prem SQL, Excel, Azure SQL to import the data and develop visuals in power BI.

● Performed data transformations, data cleaning on the data sets to generate business reports.

Tech Mahindra, Hyderabad.

Associate Software Engineer Client: Queensland Urban Utilities May 2014 - Nov 2015 05/2014 – 11/2015

● Performed Data Completeness, Data Transformation & Data Quality for various data feeds coming from different sources. Reviewed Source to Target mappings, identified data dependencies.

● Performed data validation on the Dimensional, Fact and Lookup tables and ensured that type 1 and type 2 slowly changing dimensions are handled correctly. Working knowledge of Snowflake and Star Schema models.

● Investigated data retrieval issues, Date load failures, data redundancy and data inconsistency defects.

● Prepared test plans and test cases including documentation of test procedures, Regression tests, UAT testing, Bug reporting and test results using HP-Quality center.

Contact this candidate