Summary
Overview
Work History
Education
Skills
Websites
Certification
Github
Awards
Projects
Timeline
Generic

NITHYA P C

Pune

Summary

A highly motivated results-driven and detail-focused Business Analyst with knowledge in business requirement gathering, interpreting and presenting large datasets to improve efficiency across organizations. Led the business analysis in in multiple modules and achieved 45% errors and 60% increases in data accuracy. Adapt in collaborating with cross functional teams and delivering projects on-time and on-budget.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Analyst

Tata Consultancy Services
09.2021 - Current
  • Work closely with the Business Stakeholders, Data Architects, Technical SME of multiple source systems to understand the business processes of the applications and the data
  • Mapping client's requirement in BRD , performing system analysis and finalization of technical / functional specifications and high-level design documents for the project
  • Drive through the End-to-End ingestion process for CBA's Enterprise Data warehouse (EDW)
  • Data analysis on huge volume of big data and data profiling and proposing data quality measures, Data Extract and load pattern determination
  • Handled Multiple source system Analysis and its ingestion that are having several SAP Data store objects and has lookup dependencies.
  • Created Metadata template for code generation, code validation, code packaging and code deployment using Ab Initio automated tool
  • Ensure the use of standard methods / processes to deliver projects that adhere to the Project Delivery Process standards
  • Lead the development team through the working phase of the project by researching and answering questions about the defined work, identified bugs and assisting in technical roadblocks -escalating as defined in the project's technical escalation process
  • Created End to End(E2E) documents in confluence pages for tracking and sign off activities
  • Deliver high quality, detailed business requirements, process design documentation, cost benefit analysis, and clear choice estimations
  • Data Modelling and design the data objects based on the Business processes and Data requirements
  • Involved in Data governance Discussions and work closely with the forum
  • Coordination with QA team on creating Test plans, strategies and executing the System Integration Testing/ User Acceptance Testing(UAT) accordingly
  • Coordinated with Release Management Team in Production release activities and monitor the data quality.
  • Customized processes in line with the guidelines specified by the client, ensuring smooth project implementation and product go-live
  • Ability to work independently, prioritize tasks, and meet deadlines in a fast-paced work environment.
  • Trained junior analysts on best practices, improving overall team performance and productivity.
  • Maintained up-to-date knowledge of industry trends and advancements in data analytics, enhancing the adaptability of solutions provided.
  • Keep up-to-date with industry best practices and emerging trends in data analysis, presenting opportunities to improve organizational performance
  • Assessed Business priority and risks associated with it.
  • Increased data accuracy by implementing thorough data validation and cleansing processes.
  • Streamlined reporting processes for enhanced decision-making and business insights.
  • Enhanced database performance with optimization techniques, reducing query times and improving overall efficiency.
  • Collaborated with cross-functional teams to identify key metrics and develop relevant dashboards for tracking business performance.
  • Created comprehensive documentation of analytical methodologies, ensuring consistency and reproducibility in future analyses.
  • Provided actionable insights from large-scale datasets by employing advanced statistical techniques such as regression analysis and cluster analysis.
  • Work with data and analytics experts to strive for greater data quality maturity in our data systems
  • Build and Maintain Data Quality dashboards using Tableau
  • Communication with internal team members and stakeholders in other time zones for the purpose of requirements clarification and progress reporting

QUALITY ANALYST

Tata Consultancy Services
03.2021 - 09.2021
  • Understanding existing business model and customer requirements
  • Validated reconciliation of data between source systems and targets
  • Skillful in SCD Type2 Testing and Audit field validation
  • Tracking of bugs and follow ups on the bug status with Dev team
  • Triggering the Ab initio workflows / Ab initio jobs to load the data from Source to Target
  • Performed Data Validations between Source and Target according to Mapping Document
  • Extensive experience in Writing Test Cases, Executing the Test Cases and Raising the Defects by using in JIRA Management tool
  • Developed, Reviewed & Executed Test Scripts in Test Management Tool.

Education

BACHELOR OF TECHNOLOGY -

GEC Wayanad
09.2020

Skills

  • SQL (MySQL, PostgreSQL, Oracle)
  • Python (Pandas, NumPy, Matplotlib)
  • Data Visualization (Tableau, Powerbi)
  • Excel (VLOOKUP, Conditional Formatting, Pivot Tables, Data Validation)
  • Big data, Data Warehousing, Hive, Hadoop, ETL
  • Unix Shell Scripting
  • Google Data Studio
  • Data Validation
  • Data Modeling
  • Data Profiling
  • Ab-initio (Control>Center, Express>It)
  • Snowflake

Certification

  • SQL Hackerrank 5 star badge
  • Tableau A-Z Training for Data Science - Udemy
  • Data warehousing and SQL - Udemy
  • Microsoft Excel from Beginner to Advanced - Udemy
  • Data cleaning using Excel - Udemy
  • SQL BootCamp - Udemy
  • Data Analysis with Python Numpy and Pandas - Udemy
  • Data visualization using Seaborn and Matplotlib - Udemy
  • The complete Oracle SQL Bootcamp - Udemy

Github

GitHub

Awards

TCS Special Initiative Award Appreciation from clients in Project townhall

Projects

DATA SCIENCE JOB MARKET EDA - Personal Project, 04/2023, Analyzed 7000 data science job listings and gain insights on what it takes to land a job in analytics. Performed Bivariate analysis to find average salaries based on experience level and employment types. Implemented Regex techniques to comb through fields in the dataset and identified the key requirements. This EDA and data modelling using pandas and matplotlib will reduce 90% effort of data aspirants to select the suitable role. WALMART RETAIL DATA INSIGHTS - Personal Project, 02/2023, Designed a Tableau dashboard to understand retail analysis of Walmart store over different areas. The final dashboard was effective at displaying the trend of sales, profit and discount in the states of USA, allowing users to understand the data and make informed decisions. This dashboard could help to identify that the quarter 4 in 2012 has highest average profit of ~$800 and age above 90 people are making loss in business. HR DATA ANALYTICS - Personal Project, 02/2023, Created a Tableau dashboard to track employee data for the HR team, including employee count, attrition count, active employees and attrition rate in percentage. The dashboard streamlined HR processes and increased efficiency. This Dashboard can save 3-4hrs of work for the HR during internal auditing data collection. NETFLIX MOVIES AND SHOWS ANALYSIS - Personal Project, 03/2023, Performed in-depth Excel data validation on data from various netflix movies and shows of different genres. A map, bar charts, area chart, bubble chart, text sheets with filters are used to provide a detailed analysis for the end user. Built a tableau dashboard covering different KPIs (top genres, movies and shows distribution %, ratings, duration in minutes) to track the types of programs that viewers interested and trends over years. This Dashboard can potentially save 70% of time during the analysis Netflix users over the world and their interest in shows. PIZZA HOUSE EXPLORATORY DATA ANALYSIS - Personal Project, 11/2022, Data cleansed and transformed using SQL. Calculated the number of pizzas that had at least 1 change and how many had no changes, maximum no. of orders using CTE. This analysis could help to find cancelled orders and the reason for cancellation and thereby reduce the order cancellation by 50%.

Timeline

Data Analyst

Tata Consultancy Services
09.2021 - Current

QUALITY ANALYST

Tata Consultancy Services
03.2021 - 09.2021

BACHELOR OF TECHNOLOGY -

GEC Wayanad
NITHYA P C