Summary
Overview
Work History
Education
Skills
Timeline
Generic

Nishitha Srinivasan

West Hartford,CT

Summary

Detail-focused Data Analyst with proficiency in all phases of Software Development Life Cycle (SDLC), Waterfall, and Agile methodologies. In-depth knowledge in Report Development, writing SQL scripts, and Proficiency in gathering requirements, collecting data, designing, and developing data visualization Reports for decision-making. Well-versed in a Python-based environment, with a good understanding of Text Analytics, generating data visualizations, and creating dashboards using tools such as Tableau, Power BI, and MS Excel. Proficient in SQL querying with databases and a clear understanding of business intelligence, knowledge management, data warehousing, and ETL tools

Overview

7
7
years of professional experience

Work History

Data Analyst

Elevance Health Virginia
12.2022 - Current
  • Worked on migration activities from old system to legacy system as a part of the automation process improving overall efficiency by 85%
  • Performed data analysis using complex SQL on Oracle and Microsoft SQL Server
  • Performed Data Warehousing, Data Profiling, Data analysis, Data Integration, Data Migration, Data Organization, Data Conversion, Data Quality, and Data Modelling in RDBMS databases
  • Designed and implemented SSIS packages to extract and transform data from various sources, ensuring accurate and timely data integration for reporting purposes.
  • Utilized Python libraries like NumPy for Data Cleaning, Data Transformation, Data Validation, and Data Manipulation. PySpark to process and analyze large-scale datasets, improving data quality and efficiency.
  • Creation of MSBI reports using Power BI, DAX query, Power Query, and Power Pivot Excel add-ins. Used tabular
  • Performed advanced Microsoft Excel concepts like VLOOKUP and Pivot table.
  • Created data visualizations and interactive dashboards using R and Oracle tools to present analytical findings to stakeholders.

Data Analyst

Technolytes
06.2021 - 12.2022
  • Worked on Agile Development Team to deliver updates to the business team and project managers
  • Generated various capacity planning reports using Python packages like NumPy, Matplotlib, and SciPy
  • Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data
  • Resolve all the issues related to Rating, Billing, Bill formatting, and the dunning process
  • Performed data cleansing and building an Excel user interface to assist in data collection and metrics
  • Developed Power BI reports using Power Query from SharePoint and different Data sources
  • Used Tableau, and Excel to analyze the number of products per customer and sales in a category for sales optimization.

Data Analyst

Royal Bank Of Scotland
06.2018 - 10.2019
  • Utilized statistical methods to analyze transaction patterns, loan portfolios, and risk assessment within the banking project
  • Produced comprehensive reports and visualizations using tools like Tableau or Power BI for stakeholders
  • Implemented risk management strategies and ensured compliance with regulatory standards
  • Developed predictive models for market trends, customer behavior, and credit risk assessment using Python/R
  • Proficient in SQL for effective data querying and database management
  • Identified and implemented enhancements to streamline project operations
  • Effectively communicated complex findings to non-technical stakeholders and collaborated with various departments
  • Conducted regular checks and cleansing processes to ensure data accuracy and integrity
  • Managed tasks and deadlines, contributing to the timely delivery of reports and insights
  • Committed to staying updated with industry trends, tools, and techniques for ongoing professional growth.

Data Analyst

Olympus Premedia Company
05.2017 - 06.2018
  • Developed business process models of Waterfall to document existing & future business processes
  • Analyzed the partitioned and bucketed data and computed various metrics for reporting
  • Created SQL tables with referential integrity and developed advanced queries using stored procedures and functions using SQL server management studio
  • Implemented Data Exploration to analyze patterns and select features using Python SciPy
  • Embedded Power BI reports to internal Portal to manage access of reports and data for the individual user using based on roles
  • Performed database testing on the data warehouse by using complex SQL queries in SQL Server to validate the data
  • Worked on user management for Power BI
  • Sharing the dashboard access for Power BI online.

Education

Master Of Business Administration - Data Analytics

University Of New Haven
West Haven, CT
05.2022

Bachelor Of Business Administration -

Women's Christian College
Chennai, Tamil Nadu
05.2018

Skills

  • Methodologies: SDLC, Agile/Scrum, Waterfall, UAT
  • Language: Python, R, SQL
  • IDEs: Visual Studio Code, PyCharm
  • Packages: NumPy, Pandas, Matplotlib, SciPy
  • Visualization Tools: Tableau, Power BI, Microsoft Excel
  • Database: MySQL, PL/SQL, Oracle, MS Access, DB2

Timeline

Data Analyst

Elevance Health Virginia
12.2022 - Current

Data Analyst

Technolytes
06.2021 - 12.2022

Data Analyst

Royal Bank Of Scotland
06.2018 - 10.2019

Data Analyst

Olympus Premedia Company
05.2017 - 06.2018

Master Of Business Administration - Data Analytics

University Of New Haven

Bachelor Of Business Administration -

Women's Christian College

Similar Profiles

CREATE PROFILE
Nishitha Srinivasan