AMARNADHREDDY.K
East Hartford,CT
Summary
3+ years of experience in data analysis, business requirement gathering, and data warehousing. Proficient in SQL, T-SQL, PL/SQL, and Microsoft Excel for data manipulation, analysis, and reporting. Skilled in using BI tools like Tableau and Power BI to create interactive dashboards and visualizations. Experienced in data migration, transformation, and loading, as well as designing and optimizing databases. Adept at writing Business Requirement Documents (BRD), creating use case diagrams, and utilizing Agile methodologies for project implementation. Strong ability to collaborate with cross-functional teams, troubleshoot data issues, and deliver actionable insights to stakeholders.
Overview
5
5
years of professional experience
Work History
Data Analyst
concentrix
, CA
01.2024 - Current
- Developed interactive Power BI dashboards to visualize complex datasets, enabling data-driven decision-making for stakeholders
- Optimized SQL queries and stored procedures for efficient data retrieval, reducing query execution time by 40%
- Built and maintained ETL workflows using Azure Data Factory and Informatica, ensuring smooth data integration from multiple sources
- Leveraged BigQuery, Snowflake, and Redshift for large-scale data processing and real-time reporting
- Conducted data cleansing, transformation, and preprocessing using Python (Pandas, NumPy) and SQL to improve data quality
- Applied machine learning models to analyze trends, detect anomalies, and provide predictive insights for business performance
- Implemented data governance strategies, ensuring metadata management, data integrity, and compliance with company standards
- Worked with structured and unstructured data from IoT devices, relational databases, and cloud storage solutions
- Evaluated model output accuracy using statistical metrics like Precision and Recall to ensure data reliability
Data Analyst
adhyam solutions pvt ltd
Delhi, India
06.2020 - 08.2022
- Extracted, compiled, and tracked data, analyzing trends and patterns to generate actionable business reports
- Performed data manipulation using SQL, preparing reports on a weekly, monthly, and quarterly basis
- Developed Excel-based reports with Pivot Tables and Pivot Charts for summarizing key insights
- Built and optimized SQL queries and stored procedures, improving reporting efficiency and query performance
- Cleansed and blended multiple data sources to create a unified view in dashboards for better business insights
- Assisted in data collection and preparation for Tableau visualizations, ensuring accurate and meaningful representation
- Designed interactive Tableau and Power BI dashboards, demonstrating the value of BI tools to business teams
- Developed and maintained databases, optimizing data collection and analytics strategies for efficiency and quality
- Used SSIS for ETL operations, importing and exporting data from various external file formats
- Checked for data accuracy and integrity, identifying and resolving invalid or out-of-range data
- Conducted presentations to stakeholders, showcasing the impact of data analytics in decision-making
Education
Master’s Degree - business analytics
Sacred Heart University
12.2023
Skills
- T-SQL
- PL/SQL
- SQL Server
- Microsoft Access
- RDBMS
- Tableau
- Power BI
- MicroStrategy
- Excel
- Data Profiling
- Data Cleansing
- SSIS
- Data Migration
- ETL Processes
- JIRA
- SharePoint
- Rational Team Concert (RTC)
- QC
- MS Visio
- UML
- ERD
- Process modeling tools
- Flow Charts
- Agile
- SDLC
- Data visualization
- SQL querying
- ETL processes
- Business intelligence
- Cloud data management
- Predictive modeling
- Effective communication
- Analytical thinking
- Problem solving
Timeline
Data Analyst
concentrix
01.2024 - Current
Data Analyst
adhyam solutions pvt ltd
06.2020 - 08.2022
Master’s Degree - business analytics
Sacred Heart University
Similar Profiles
Arnold GarciaArnold Garcia
Team Leader - Service Delivery at ConcentrixTeam Leader - Service Delivery at Concentrix
Chynna ThomasChynna Thomas
Customer Service Agent at ConcentrixCustomer Service Agent at Concentrix
Mercedes EllisMercedes Ellis
Case Manager at ConcentrixCase Manager at Concentrix
Praveensai KundetiPraveensai Kundeti
SOC Analyst at ConcentrixSOC Analyst at Concentrix
Christina GomezChristina Gomez
Claims Support Specialist at ESISClaims Support Specialist at ESIS