Summary
Overview
Work History
Education
Skills
Certification
Additional Information
Accomplishments
Timeline
Generic
NADIYA M

NADIYA M

Data Analyst

Summary

Dedicated data analyst with expertise in SQL, python programming. Proficient in statistical analysis, data visualization, and dashboard creation using Power Bl. Skilled in data modeling and interpretation to drive data-driven decision making. Proven track record in data mining, cleansing and reporting tor business intelligence purposes. Strong problem-solving skills .Willingness to take on added
responsibilities to meet team goal.

Overview

2
2
years of professional experience
4
4
years of post-secondary education
4
4
Certifications

Work History

Info Technology Sr. Associate

NTT DATA
10.2021 - 07.2023
  • Collect, analyze, and interpret complex data sets from Informatica PowerCentre, Oracle sql developer, Mainframe,Control M.
  • Conduct meetings and gather requirements to ensure accurate and relevant data analysis.
  • Communicate effectively with stakeholders, translating technical concepts into non-technical language to facilitate understanding and decision-making.
  • Developed complex SQL queries using Joins , Sub Queries ,Views ,Triggers, Procedures to clean and analyze data sets.
  • Written the SAS code to analysis the existing data .
  • Comparison of data on-premises with the data lake using SAS by cleaning and transforming the data ,handling duplicates and missing values.
  • Demonstrate excellent proficiency in Excel, including advanced formulas, functions, pivot tables, data visualization .

Education

Bachelor of Technology - Computer science

Siddharth Institute of Engineering & Technology, JNTU University
01.2017 - 04.2021

Skills

    SQL

undefined

Certification

Java Developer -Level 1

Additional Information

  • Total 1 year 8 months of experience in IT industry Knowledge on Java, SQL, Scala, Spark, HIVE, SQOOP, PLSQL, Linux/Unix Operating Systems. Worked on Spark, Scala, Hive, Informatica Power Centre, SQL, PL/SQL, Mainframe, Control M and SAS, OPERATING SYSTEM, MS-Office365. Communicating with the business user to gather the requirements. Manage and maintain data required by the users. Perform data extracts, transformations and loads using Power Centre. Written the SAS code to analysis the existing Data. Comparing the data present on-premises with the data lake. Created, modified/Updates SAS code to incorporate changes in new releases of the product. Validating the data by analyzing the mappings, workflows and some functions based on data extracts. Provide quality assurance of imported data if necessary. Documenting the data quality procedures and their outputs. Monitoring the jobs required by the user and checking how the data is loading from different sources (Control M, Mainframe). Developing SQL queries to validate data, such as checking duplicates, null values, and truncated values and ensuring correct data aggregations. Prepare and consolidate data for established, periodic review and maintain data quality dashboards. Define and perform data quality checks. Review the data loads to ensure they match the migration requirements. Basic knowledge of Control M and Mainframe. Technical Experience Java SQL IntelliJ PLSQL Linux Oracle Control M HDFS SAS PostgreSQL Hadoop AWS

Accomplishments

    Google data Analytics Certifiaction

    AWs certified Developer -Associate

    HackerRanker SQL certification (Basic& Intermediate)

    Agile And Scrum internal program (NTT Data)

    Certified Java Developer(NTT data)

Timeline

Info Technology Sr. Associate

NTT DATA
10.2021 - 07.2023

Bachelor of Technology - Computer science

Siddharth Institute of Engineering & Technology, JNTU University
01.2017 - 04.2021
NADIYA MData Analyst