Data Analyst

PRATHYUSHA NAGAVALLI

510-***-****, **********.*********@*****.***, https://www.linkedin.com/in/nprathyusha/

PERSONAL SUMMARY

Self-Driven Data Analyst with 7+ years’ experience in interpreting, integrating, and analysing data for driving business solutions. Proven track record developing analytics dashboards and automating workflows with Power platform. Strong stakeholder communication and a user first mindset in BI design.

5 Years experience in Healthcare.

SKILLS:

Office Tools

Microsoft Office, Excel (Pivots, VLOOKUP, Macros), PowerPoint

BI Tools

SSIS, SSRS, SSAS, Tableau, Power BI, MS Visio, Cognos, Embrace

Analytical Techniques

Machine Learning, Artificial Intelligence, ETL, Data Mining, Data Warehousing

Programming Languages

SQL/TSQL, Python, VBA

Cloud Services

Azure, Salesforce, Snowflake, Teradata, Databricks, Hive

Other Tools

TFS, Jira, Confluence, Redgate, Alteryx

PROFESSIONAL EXPERIENCE

Nike, Beaverton, Oregon January 2023 - Current

Data Analytics Manager

Responsibilities

Lead development and execution of reporting and analytics products across a focused area of the Nike business value stream.

Lead structured, end-to-end analysis to inform product strategy, data architecture and reporting decisions.

Analyze existing datasets and interfaces using Snowflake and Databricks, Hive to understand and document current state data architectures. Design future state data architectures by applying data requirements, data profiles and business rules to current state architectures in alignment with best practices and standards.

Support standard methodologies in data analysis, data integrity, unit testing, data quality control, system integration testing, data modeling, validation, and documentation.

Develop complex SQL queries and data visualizations to fulfil analysis requests and ongoing reporting needs.

Possess valuable skills for building, maintaining, and utilizing data pipelines.

Pacific Dental Services, Irvine, California March 2021 – December 2022

Business Data Analyst

Responsibilities:

Analyze the data and understand how the data will be used by providing the business users with proper analytical explanatory and visualization reports.

Create data sets, extract, and synthesize data, conduct, and interpret quantitative and qualitative analyses.

Working as a key resource in development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Source to Data Warehouse.

Perform Data mapping and filtering, consolidation, cleansing, Profiling, Integration, ETL, Data Modelling to develop Data Warehouse.

Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures. Analyze large databases and recommend appropriate optimization for the same.

Develop SQL Scripts to validate the data after the loading process. Modify and test PL/SQL stored procedures. Coordinate tasks with onsite and offsite team members.

Use Power BI Power Pivot to develop data analysis prototype and use Power View to visualize reports. Create new Power BI reports using various data sources.

Perform root cause analysis to understand and resolve issues.

Migrate data from various data sources and stage it in Data Hub and Load into Data Warehouse.

Work with multiple systems with dirty and large data and find bridge between the systems to unite them in data warehouse.

Scan Health Plan, Long Beach, California

Governance Data Analyst Feb 2019 – Jan 2021

Responsibilities:

Communicated and collaborated with business partners and project teams to analyse High Level business needs and translate them into requirements to ensure accuracy in gathering Business Requirements, analysing data workflows, and documenting the details.

Performed verification of data that is quantified and qualified after ETL process is like the original source Data.

Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Source to a Data Warehouse.

Involved in migration of various objects like stored procedures, tables, and views from various data source to SQL Server.

Created various SQL Schema, Triggers, views, index/keys and stored procedures along with compiling them in SQL server and troubleshoot errors. Used complex query statements like, sub queries, correlated queries, derived tables, CASE functions to insert the data depending.

Use data mining, model building, and other analytical techniques to develop predictive models.

Created data sets, synthesized, and extracted data, conducted, and interpreted quantitative and qualitative analyses.

Extracted, Compiled and Analysed data to generate reports from various databases.

Develop solutions that utilize the highest standards of analytical rigor and data integrity.

Knowledge of data governance best practices and principles.

Created reports in Power BI and Excel with Graphs, Pivot tables, VLOOKUP, Formulas.

d visualize data

SCAN Health Plan, Long Beach, California May 2018 – Feb 2019

Business Intelligence Analyst

Responsibilities:

Drive development of quantitative models necessary for evaluation and implementation of new strategies with product managers.

Use data mining, model building, and other analytical techniques to develop predictive models.

Create Dashboards, reports, as needed using Tableau Desktop and Tableau Server

Develop solutions that utilize the highest standards of analytical rigor and data integrity.

Excellent analytical skills with demonstrable experience in the compilation, interpretation, and analysis of management information desirable.

Excellent written and verbal communication skills, strong customer focus and demonstrated ability to work in geographically dispersed teams.

Reporting of key insight trends, using statistical rigor to simplify and inform the larger team of noteworthy story lines.

Analyze and solve business problems at their root, stepping back to understand the broader context.

Write high quality code to retrieve and analyse data.

Prospect Medical, Orange, California March 2017 – May 2018

Data Analyst

Responsibilities:

Interact with the users and stakeholders to gather Business Requirements, analysed data/workflows, defined the Project scope and performed Cost/benefit analysis.

Develop Use Case, Business Flow, and Activity Diagrams using Rational Rose so that developers and other stakeholders can understand the business process.

Conduct gap and impact analysis and create Source to Target Mapping (STM) documents for data migrations.

Retrieve, Insert, Update customer data in relational database tables by SQL Queries using DML SQL for database verification.

Work with architects and senior developers to design and enforce established standards for building reporting solutions.

Extensive knowledge of SQL for extracting and manipulating data for verification and validation for data in warehouse after OLTP.

Extensively work on the ETL mappings, source data analysis, source to target mapping and documentation of OLAP reports requirements.

Analyse data to determine if there are outliers or data accuracy issues and work with related departments to make the corrections.

EDUCATION:

Master’s in computer science (M.S) from Texas A&M University Kingsville, Texas, USA (2015-2016)

Bachelor’s in computer science (B.E) from Osmania University, Telangana, India (2011-2015)

Contact this candidate