Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Nivedita Tiwari

Aldie,VA

Summary

Senior Data Analyst with extensive experience at Infosys, specializing in Power BI and SQL. Developed data solutions that improved KPI tracking and provided valuable insights for stakeholders. Expertise in data validation and technical documentation, transforming complex data into actionable strategies while promoting team collaboration.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Senior Data Analyst

Infosys
Virginia, USA
06.2024 - Current
  • Client: Molina Healthcare.
  • Project: Delegated Entities Performance Dashboard (Azure Cloud).
  • Engineered Delegation 360 solution to automate data capture from Salesforce to data lake.
  • Developed Power BI dashboards for stakeholders to monitor delegated entity performance through KPIs.
  • Defined and implemented technical requirements for data ingestion into data lake.
  • Designed key performance indicators in Power BI to facilitate data analysis.
  • Created mapping documents and conducted detailed data analysis to specify business logic.
  • Provided technical support, including SQL code debugging and issue resolution for development team.
  • Executed data ingestion, analysis, and validation using Azure Databricks Notebook and SQL.
  • Utilized Power BI as a primary tool for business intelligence reporting.

Business System Analyst

Infosys
Virginia, USA
10.2022 - 06.2023
  • Client: AmeriHealth Caritas.
  • Project: Data Migration to the Azure Data Lake 2.0
  • As a Business System Analyst responsible for ensuring the quality and integrity of data throughout the data lake platform.
  • Perform data analysis and data profiling using Azure Databricks Notebook, SQL, and IDQ (Analyst Tool).
  • Validate, test, and maintain the performance of scorecards on the IDQ Tool.
  • Report any anomalies found in the data to the development and ETL team.
  • Coordinate with the Development and ETL Team to resolve the defects.
  • Demonstrate the performance of the IDQ Tool to the Business Team.
  • Develop SQL scripts using business rules for data validation.
  • Create and maintain the business rules and data mapping documents.

Data Analyst

Spectra Medix Inc
New Jersey, USA
03.2021 - 10.2022
  • Client: Blue Cross Blue Shield Nebraska
  • Developed multiple Data Analytics reports using Tableau for informed decision-making.
  • Conducted extensive data quality and discovery analysis on claims and revenue data.
  • Built complex SQL queries to design backend tables for analytical reports in Tableau.
  • Automated SQL scripts by developing Python scripts, enhancing operational efficiency.
  • Created dashboards from scratch based on client requirements in Tableau Desktop and Server.
  • Managed monthly refreshes and resolved bugs in Tableau reports to maintain accuracy.
  • Utilized version control system SVN to track changes and collaborate effectively.
  • Employed Agile tools, including JIRA, to manage project tasks and timelines.

Business Analyst BI Applications

Tenon and Groove (Option Town)
New Delhi, India
05.2013 - 10.2014
  • Conducted market-based data analysis to inform marketing strategy for aviation client Air Asia.
  • Developed UI prototypes for consumer feedback forms to enhance user experience.
  • Transformed rough feature requests into detailed business requirements through collaboration with stakeholders.
  • Designed and automated reports using Excel VBA and Think Cell to improve efficiency.
  • Created forecast models utilizing advanced Excel formulas for data-driven decision making.
  • Generated airline data reports in PowerPoint and Think Cell to present insights effectively.
  • Executed ad hoc projects and utilized PARS for SQL server-based data extraction.

Education

Bachelors - Engineering

Indian Institute of Technology
Varanasi
05-2013

Skills

  • Microsoft Azure Cloud
  • Azure Databricks
  • BI Tools - Power BI, Tableau
  • Informatica Data Quality (IDQ) Tool
  • Microsoft SQL Server
  • SQL
  • Python
  • Data profiling
  • Data analysis
  • Dashboard Designing
  • Reporting
  • Agile Tool - JIRA
  • Advance Excel

Certification

Microsoft Certified - Azure Fundamentals, AZ-900

Timeline

Senior Data Analyst

Infosys
06.2024 - Current

Business System Analyst

Infosys
10.2022 - 06.2023

Data Analyst

Spectra Medix Inc
03.2021 - 10.2022

Business Analyst BI Applications

Tenon and Groove (Option Town)
05.2013 - 10.2014

Bachelors - Engineering

Indian Institute of Technology

Similar Profiles

CREATE PROFILE
Nivedita Tiwari