Shravani Aedla
Harrison,NJ
Summary
Dedicated Data Analyst with over 2 years of experience in data extraction, transformation, and visualization, leveraging advanced Excel, SQL, R, Python Power BI, Tableau and ETL expertise to drive data-driven insights for informed decision-making.
Overview
2
2
years of professional experience
6
6
Certification
Work History
Data Engineer
Apex Health Solutions
05.2023 - 09.2023
- Developed SQL queries, created and maintained data views, stored procedures aggregating and cleansing data for analysis, resulting in 20% reduction in data processing time,15% increase in data accuracy and providing more structured and business-oriented perspective on healthcare data.
- Designed and developed interactive dashboards in Power BI using complex DAX calculations and measures resulting in 25% improvement in KPI tracking and 30% increase in stakeholder engagement for business stakeholders.
- Excel expert in utilizing advanced pivot table features such as calculated fields, grouping, and slicers for enhanced data analysis
- Proficiency in advanced Excel functions, including VLOOKUP, HLOOKUP, INDEX-MATCH, and array formulas, enabling 25% faster data retrieval and 15% improvement in data analysis accuracy.
- Utilized Tableau Prep for data cleansing, transformation, and data shaping to ensure data accuracy and consistency.
- Designed and managed ETL pipelines in Azure Databricks and Azure Data Factory, organized large volumes of data efficiently using Azure Blob Storage, ensuring data availability and durability.
Software Developer| Data Analyst
Teksolveit
02.2023 - 05.2023
- Proficient in collecting, organizing, interpreting, and disseminating various types of statistical figures using Python modules like Pandas, NumPy and Matplotlib, resulting in 30% improvement in data visualization and 25% reduction in data processing time.
- Experienced in SQL to extract data from relational databases, including complex joins, subqueries, and filtering.
- Capable of efficiently cleansing and preparing data for analysis in Excel, ensuring data quality and accuracy prior to use in pivot tables or lookup functions.
- Demonstrated expertise in using Excel VLOOKUP to retrieve specific data from large datasets, ensuring accurate data retrieval for analysis.
- Leveraged Power Query to clean, transform, and shape raw data from various sources into usable format for analysis in Power BI
- Conducted exploratory data analysis (EDA) in R to understand data distributions, outliers, and potential data issues
- Developed complex calculations and calculated fields in Tableau to support business requirements, such as KPIs, growth rates, and cohort analysis.
Associate Professional| Jr Data Analyst
DXC Technology
06.2021 - 12.2021
- Designed and developed complex calculations, custom fields, and calculated measures within Tableau for creating interactive and visually compelling dashboards to present data-driven insights effectively.
- Utilized Power Query in Power BI to perform data transformations, cleansing, and shaping to ensure data accuracy and quality. Generated reports and dashboards to meet end user requirements.
- Demonstrated expertise in building dynamic Excel dashboards and interactive reports, which led to 25% improvement in data visualization and 20% reduction in report generation time, enhancing data-driven decision-making
- Competence in advanced Excel features such as Power Query for data extraction, transformation, and loading (ETL) tasks, and creating macros and VBA (Visual Basic for Applications) scripts to automate repetitive data processing tasks.
- Extensive experience in writing complex SQL queries, including subqueries, joins, and aggregations, to retrieve and manipulate data, to derive meaningful insights from large datasets.
- Experienced in working with Python queries on different formats like TXT files and CSV files.
Data Analyst Intern
Crest Informatics
10.2020 - 04.2021
- Worked on consulting and research projects in field of Machine Learning, this involved data collection, data cleaning and preparation, implementing ML algorithms and evaluating performance gains over present systems, deploying using docker containers
- Conducted statistical analyses in R to identify patterns, correlations, and trends within datasets
- Created and optimized stored procedures and user-defined functions in SQL to encapsulate business logic for reuse
- Developed basic financial models in Excel for budgeting, forecasting, and scenario analysis, contributing to accurate financial planning
- Utilized Tableau's wide range of charts and graphs to effectively communicate data trends, patterns, and outliers
- Created action filters, parameters, and calculated sets for preparing dashboards and worksheets using Power BI.
Education
Master of Science - Computer Science
New Jersey Institute of Technology
Newark, NJ05.2023
Bachelor of Science - Computer Science
Vignan Institute of Technology And Science
India06.2021
Skills
- Data: ETL, Data integration, Data warehousing, Data migration, creating reports and dashboards
- Cloud: Azure Data Factory, Azure Databricks, Azure DevOps, Azure Blob Storage
- Predictive Analytics techniques: Linear Regression, Logistic Regression
- Machine Learning techniques: KNN, Naive Bayes, Clustering, Decision Trees, Ensemble Models, SVM, XGBOOST
- Programming languages: Python, R, C, C, Java, SQL
- Frameworks: Tableau, Power BI, Advanced Excel
- Databases: MS SQL server
Certification
- Certified in Python Programming by HackerRank.
- Certified in Problem Solving by HackerRank.
- Certified on the course “A.I for Everyone by Andrew Ng” from Coursera.
- Certified on the course “Creating Database Tables with SQL” from Coursera.
- Microsoft Certified: Azure Administrator Associate
- Microsoft Certified: Azure Data Engineer Associate
Timeline
Data Engineer
Apex Health Solutions
05.2023 - 09.2023
Software Developer| Data Analyst
Teksolveit
02.2023 - 05.2023
Associate Professional| Jr Data Analyst
DXC Technology
06.2021 - 12.2021
Data Analyst Intern
Crest Informatics
10.2020 - 04.2021
Master of Science - Computer Science
New Jersey Institute of Technology
Bachelor of Science - Computer Science
Vignan Institute of Technology And Science
- Certified in Python Programming by HackerRank.
- Certified in Problem Solving by HackerRank.
- Certified on the course “A.I for Everyone by Andrew Ng” from Coursera.
- Certified on the course “Creating Database Tables with SQL” from Coursera.
- Microsoft Certified: Azure Administrator Associate
- Microsoft Certified: Azure Data Engineer Associate
Similar Profiles
Keisa CloudyKeisa Cloudy
UM Review at Apex Health SolutionsUM Review at Apex Health Solutions
Keisa CloudyKeisa Cloudy
UM Reviewer at Apex Health SolutionsUM Reviewer at Apex Health Solutions
Ashley JacksonAshley Jackson
Customer Service Specialist at Apex Health Solutions-Memorial Hermann HealthplanCustomer Service Specialist at Apex Health Solutions-Memorial Hermann Healthplan