Snehalatha Nanjanapalli
Michigan
Summary
Data Analyst with 5+ years of experience in data analysis, data mining, and analytics solutions. Skilled in Python, SQL, and statistical techniques to analyze large datasets, build predictive models, and generate insights. Hands-on experience with databases such as Oracle, Redshift, PostgreSQL and Data-bricks. Experienced in collaborating with cross-functional stakeholders, converting Business to Technical requirements, and communicating findings to support business decision-making. Expertise in establishing data standards, managing metadata and enforcing data governance policies across enterprise systems.
Overview
5
5
years of professional experience
Work History
Data Analyst
JB Hunt Transport Services
10.2024 - Current
- Data mining: Executed complex SQL queries on large datasets to uncover hidden logistical trends, improving business insight generation.
- Date Modeling: Involved in designing conceptual logical and physical data modeling, star/snowflake schemas, Source-to-Target Mapping.
- Data Analysis & Reporting: Collect, manipulate, and analyze financial or operational data to monitor key performance indicators (KPIs) and support business decisions.
- Technical Problem Solving: Utilize SQL, Python, or other tools to extract data and solve complex problems related to freight movement and supply chain logistics.
- Cross-functional Collaboration: Partner with engineering, technology, and business units to translate business requirements into functional technical solutions.
- Data Quality Assurance: Identify and address data quality issues, ensuring data integrity and accuracy across downstream analytics solutions.
- Process Improvement: Identify bottlenecks, analyze business models, and recommend improvements to enhance operational efficiency.
Data Analyst
Adecco(Client: Capital One)
07.2022 - 10.2024
- Data Analysis: Analyzed datasets using SQL across Hive and Databricks platforms to accelerate query performance for financial reporting.
- Source-to-target Mapping: Converted business to technical requirements by defining how data travels from source to target.
- Data Lineage: Track the data from various sources using audit columns to ensure seamless, zero-loss data migrations and cross-platform system integration.
- Data Dictionaries & Documentation: Responsible for Maintaining data dictionaries, business glossaries for a subject area, which helps to improve data discovery and understanding.
- Data Governance: Reviewing incoming project data elements against established business requirements to prevent non-compliant data from entering production.
ETL Developer
Adecco(Client: Cigna)
04.2021 - 07.2022
- Exploratory Data Analysis: Conducted deep-dive analysis using Oracle SQL on large datasets.
- ETL Development: Developed Informatica ETL workflows as per technical requirements using various transformations. Data integration using heterogeneous sources such as Flat files, Mainframe and Relational databases.
- Unit and Integration Testing: Performed unit testing and Integration testing defect fixes to ensure data accuracy.
- Scheduling: Automated and monitored jobs using Control-M and Tivoli scheduling tool.
Education
Bacherlor's Degree - In Computer Science And Engineering
Jawaharlal Nehru Technological University
Anantapur, India05-2014
Skills
- Analysis & Modeling: Data modeling, Exploratory Data Analysis (EDA), Statistical Analysis, Data Mining, Predictive Modeling
- Languages: SQL, Python (Pyspark, Pandas)
- Data Visualization: Tableau, MS Excel (Advanced Pivot Tables, VLOOKUP)
- Big Data & Cloud: Databricks, Hive, Hadoop, Redshift
- ETL & Databases: Informatica PowerCenter & PostgreSQL, Oracle
- Tools & Systems: UNIX Shell Scripting, Control-M
- Data analysis
Timeline
Data Analyst
JB Hunt Transport Services
10.2024 - Current
Data Analyst
Adecco(Client: Capital One)
07.2022 - 10.2024
ETL Developer
Adecco(Client: Cigna)
04.2021 - 07.2022
Bacherlor's Degree - In Computer Science And Engineering
Jawaharlal Nehru Technological University