Yureka Valli U
Summary
Experienced data analyst with 4 years of experience, skilled in translating complex data sets into actionable insights for strategic decision-making. Proficient in statistical analysis and data visualization tools, consistently optimizing processes and guiding business decisions. Expertise in utilizing Power BI, Tableau, SQL, Excel, and Python to develop robust data solutions and provide strategic recommendations. Collaborative team player with a focus on adaptability, delivering reliable results in fast-paced environments. Demonstrated track record of using data analysis to drive business success.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
BN ASSOCIATES
12.2023 - Current
- Expertise in Power BI, Power BI Pro, Power BI Mobile. Developed a high-level test matrix based on the business requirements, functional and technical specifications.
- Having Experience on Microsoft Power BI (Desktop, Service, Mobile), Database performance tuning.
- Assists and Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
- Created powerful analytic dashboards on Power BI Desktop to be used to give deep and meaningful insights to the data.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report.
- Developing the Excel Power Pivot models to the Power BI Desktop and making them accessible to the Power BI cloud Service to the use of report consumers.
- Experience in working with large datasets and performance optimization and developed reports by using advanced chart types and custom visuals in Tableau workspace.
- Processed industry and company Tableau best practices for visual analytics and storytelling to maximize the impact of visualization products.
- Generated reports using Query Editor, DAX and visualizations with Power BI Desktop based on measures and dimensions required by end users. Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources.
- Extensively worked on how to import, shape, and transform data for Business Intelligence (BI) Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
Data Analyst
Tata Consultancy Services
05.2022 - 05.2023
- Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
- Involved in various SDLC Life cycle phases like development, deployment, testing, documentation, implementation & maintenance of application software
- Communicate with clients and capturing site scheduled dates and production Lines and manufacturing equipment's information.
- Attending project discussions & meetings with SME and business users.
- Worked on Snowflake data warehouse concepts for maintaining the infrastructure and to manage the data using the snow SQL language as a query optimization
- Used Snowflake warehouse to connect with several BI tools for Data Analysis.
- Developed Power BI model used for reporting. Writing complex queries using DAX functions in Power BI and Power Pivot.
- Used various sources to pull data into Power BI such as SQL server and Oracle etc. Created refresh- based reports and automatic refresh in Power BI service.
- Worked on all kinds of reports such as yearly, monthly and daily. Created stored procedures and queries to pull data into Power pivot model.
- Used joins and sub queries to simplify complex queries involving multiple tables. Developed reports for different areas include quality, Production and Warehouse based on the user needs.
- Utilized Power BI view to create various analytical dashboards that depicts critical KPIs such as efficiency, quality and availability of the equipment's.
SQL Developer
Tata Consultancy Services
08.2021 - 05.2022
- Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
- Involved in various SDLC Life cycle phases like development, deployment, testing, documentation, implementation & maintenance of application software.
- Responsible for Database Analysis, Database Testing, ETL procedures, and creating numerous reports using custom SQL or stored procedures.
- Designed and developed SSIS packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
- Communicate with clients and capturing site scheduled dates and production Lines and manufacturing equipment's information.
- Used joins and sub queries to simplify complex queries involving multiple tables. Developed reports for different areas include quality, Production and Warehouse based on the user needs.
- Installed SQL Server 2014 and Management tools using SQL Server Setup program
- Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
- Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
- Performed DML and DDL Operations as per the business requirement.
- Created views and prepared the Business Reports.
- Resolved production issues by modifying backend code as and when required.
- Documented data such as entity relationships and attributes, file descriptions and definitions.
- Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Evaluated new technologies related to SQL development for potential implementation opportunities, facilitating innovation within the team''s workflow.
SQL Intern
Tata Consultancy Services
01.2021 - 04.2021
- As an intern, I worked on building an Inventory Management System designed to automate and optimize the tracking of stock levels, orders, and inventory replenishment for a growing e-commerce company.
- Designed and implemented an efficient database schema using MySQL/SQL Server, which included tables for products, inventory, suppliers, orders, and stock levels.
- Ensured data integrity and normalization by creating appropriate relationships between the tables using foreign keys and indexes.
- Developed complex SQL queries to fetch real-time data on stock levels, sales, product availability, and order history.
- Automated the process of tracking stock movements (additions, sales, returns) using stored procedures and triggers to ensure data consistency.
- Created dynamic SQL reports to track top-selling products, stock trends, and historical sales data.
- Implemented a low-stock alert system that automatically flagged products with stock levels falling below a set threshold.
- Integrated this system with the company’s order management platform, sending alerts to the purchasing department when items need to be reordered.
- Developed SQL-based reports that provided managers with actionable insights such as stock turnover rates, monthly sales, and inventory status.
- Designed automated reports that ran at scheduled intervals and emailed key stakeholders, ensuring that inventory data was consistently updated and reviewed.
- Project - Inventory Management System
- Project Description – Inventory Management System designed to streamline the tracking of product stock levels, manage orders, and automate inventory replenishment. The system aims to reduce manual errors, improve order fulfillment efficiency, and prevent stock-outs by automating key processes.
- The project involved designing a robust database to store detailed product information, sales, transactions, and inventory status. I created complex SQL queries, stored procedures, and triggers to handle inventory updates in real-time, track stock movements, and send low-stock alerts. By automating inventory tracking, this system allowed the company to maintain optimal stock levels, improve warehouse operations, and ensure timely restocking of products.
Education
Bachelor’s - computer science
Jawaharlal Nehru Technological University
01.2021
Skills
- BI tools: Microsoft Power BI, Tableau
- Data visualization and Modelling
- Data query language: SQL, DAX, Azure SQL
- Data warehousing and analytics
- Microsoft BI stack (SSIS, SSRS, SSAS)
- Microsoft Excel (Advanced: VBA, Macros, Pivot)
- Paginated Reports & SSRS Reports
- Python
- Data visualization and presentations
- Data analysis
- Excel functions
Certification
Microsoft Certified: Power BI Data Analyst Associate(5281A3-1C741F)
Timeline
Data Analyst
BN ASSOCIATES
12.2023 - Current
Data Analyst
Tata Consultancy Services
05.2022 - 05.2023
SQL Developer
Tata Consultancy Services
08.2021 - 05.2022
SQL Intern
Tata Consultancy Services
01.2021 - 04.2021
Bachelor’s - computer science
Jawaharlal Nehru Technological University
Similar Profiles
Kiano RamosKiano Ramos
Ammunition Chief / Platoon Sergeant/ Barracks Manager at Headquarters and support BnAmmunition Chief / Platoon Sergeant/ Barracks Manager at Headquarters and support Bn
Miriah AcuffMiriah Acuff
Battalion Logistics Officer at 302nd Intelligence and Electronic Warfare BNBattalion Logistics Officer at 302nd Intelligence and Electronic Warfare BN
Danny P RupprechtDanny P Rupprecht
Platoon Sergeant (Sergeant First Class [SFC]) Senior Construction Supervisor) / Operations Sergeant at 902d ECC, 15th EN BN, 18th MP BDEPlatoon Sergeant (Sergeant First Class [SFC]) Senior Construction Supervisor) / Operations Sergeant at 902d ECC, 15th EN BN, 18th MP BDE
Manoj Singh RawatManoj Singh Rawat
Data Analyst/Data Migration Analyst at Sopra SteriaData Analyst/Data Migration Analyst at Sopra Steria
Lenina MirzaLenina Mirza
Data Analyst (Customer Support Data Analyst) at Mazda Australia Pty LtdData Analyst (Customer Support Data Analyst) at Mazda Australia Pty Ltd