Rajesh Myla
Plano,TX
Summary
Dynamic Data Analyst with a proven track record at Advithri Technologies and XUNTOX SOFT TECH, specializing in data visualization, Python programming, and analytical problem-solving. Achieved a 15% reduction in forecasting errors and enhanced data management efficiency by 25% through innovative dashboard designs. Expert in SQL and adept at transforming complex data into actionable insights.
Overview
3
3
years of professional experience
Work History
Data Analyst
Advithri Technologies
08.2023 - Current
- Assisted in gathering business requirements and contributed to designing data maps and models.
- Supported relational data modeling for creating logical and physical database designs and ER diagrams using various modeling tools.
- Helped design, develop, test, and deploy internal analytics solutions with SSRS and dashboard tools, improving weekly and monthly reporting functions.
- Developed ETL workflows for data ingestion and transformation using Python and AWS Glue.
- Used Azure Data Factory, T-SQL, Spark SQL, and U-SQL for data ingestion and processing tasks.
- Applied query optimization techniques in SQL, reducing execution times by 20%.
- Maintained and updated Business Requirement Documents (BRDs) in ALM for reporting updates.
- Troubleshoot existing reports and technologies to ensure seamless functionality.
- Documented processes for working with Tableau Desktop and evaluating business requirements.
- Participated in development processes and SCRUM meetings to support agile project goals.
- Assisted in designing ETL packages in MS SQL Server for data integration from multiple sources, utilizing SSIS.
Data Analsyt
XUNTOX SOFT TECH
05.2021 - 01.2022
- Developed predictive models for sales forecasting using Python and R, reducing forecasting errors by 15%.
- Created a time series analysis model in Python to support sales trend forecasting.
- Prepared and presented monthly sales data reports for the executive team, enabling data-driven decision-making.
- Utilized advanced Excel functions to produce ad-hoc reports, increasing report generation efficiency by 20%.
- Designed data visualization dashboards in Power BI, improving data accessibility and management efficiency by 25%.
- Employed SQL to manage large databases, optimizing data retrieval processes.
- Gained practical experience in data cleaning, transformation, and validation processes to ensure data accuracy.
Education
Master of Science - Business Analytics
University of New Haven
West Haven, CT12-2023
BBA - Business Analytics
Kl University
Vijayawada, India05-2021
Skills
- Data Visualization and Presentations
- Data Analysis
- Python Programming
- Excel Functions
- SQL
- SQL Databases
- Analytical Problem Solving
- Tableau
- R Programming
- ETL processes
- Data Mining
- Microsoft Visio
- Visual data representation
- Data Cleaning
- Statistical Analysis
Languages
English
Professional Working
Timeline
Data Analyst
Advithri Technologies
08.2023 - Current
Data Analsyt
XUNTOX SOFT TECH
05.2021 - 01.2022
Master of Science - Business Analytics
University of New Haven
BBA - Business Analytics
Kl University
Similar Profiles
Ganesh PuliGanesh Puli
Senior DevOps Engineer at Advithri TechnologiesSenior DevOps Engineer at Advithri Technologies
Ambika Prasad PatiAmbika Prasad Pati
Data engineer at Advithri TechnologiesData engineer at Advithri Technologies
Mahender VoddiMahender Voddi
Cloud DevOps Engineer at Advithri Technologies LLCCloud DevOps Engineer at Advithri Technologies LLC