Jaichandra Avanigadda
Atlanta,GA
Summary
Business Intelligence Analyst with 1.5 years of experience in data modeling, ETL, and data pipeline development. Skilled in SQL, Python, Power BI, and Tableau, with expertise in designing Star/Snowflake schemas, optimizing database performance, and automating ETL workflows using Apache Airflow, and DBT.
Experienced in integrating data from multiple sources (Snowflake, Redshift) into scalable data warehouses to enable real-time analytics. Strong Agile background, utilizing JIRA for sprint planning, backlog management, and issue tracking. Adept at collaborating with cross-functional teams to transform raw data into actionable insights, improving reporting efficiency and decision-making.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Bussiness Intelligence Analyst
Accenture Solutions Private
Hyderabad, India
02.2022 - 07.2023
- Developed complex SQL queries to extract and analyze data from multiple sources.
- Provided technical support to other team members regarding ETL development activities.
- Designed and implemented data pipelines for processing structured and unstructured data from multiple sources (APIs, relational databases, and cloud storage).
- Developed data models (Star Schema, Snowflake) for business intelligence dashboards, improving query efficiency by 40%.
- Automated ETL workflows using Apache Airflow, star schema, etc., and optimized SQL queries to enhance data processing time.
- Built real-time dashboards in Qlik Sense and Tableau, providing insights on customer trends and KPIs.
- Extracted data from SQL Server, Google BigQuery, and MySQL databases to create comprehensive datasets for analysis.
- Automated data validation and cleansing scripts using Python, ensuring 99.9% data accuracy.
- Used JIRA for sprint planning, issue tracking, and Agile project management, ensuring seamless collaboration with cross-functional teams.
Education
Master of Science - Computer Science
Auburn University At Montgomery
Montgomery, AL12-2025
Skills
- Databases and Data Warehousing: SQL, Snowflake, MySQL, PostgreSQL
- Data Modeling & ETL: Star Schema, Snowflake Schema, DBT, Apache Airflow
- Programming and Scripting: Python (Pandas, NumPy), SQL
- BI and visualization: Tableau, Qlik Sense
- Cloud Technologies: AWS (S3, Lambda, Glue, Redshift), Azure (Data Factory, Synapse)
- Big Data and Streaming: Apache Spark, Kafka
- Data Governance and Quality: Data Cleansing, Data Lineage, Master Data Management (MDM)
- Project Management and Agile Tools: JIRA, Confluence, Scrum
Certification
- AWS Certified Data Analytics – Associate
Timeline
Bussiness Intelligence Analyst
Accenture Solutions Private
02.2022 - 07.2023
Master of Science - Computer Science
Auburn University At Montgomery
Similar Profiles
Riswin Tom JoseRiswin Tom Jose
Supply Chain Software Development at Accenture Solutions PrivateSupply Chain Software Development at Accenture Solutions Private
Bandari RamuBandari Ramu
Senior Analyst at Accenture Solutions PrivateSenior Analyst at Accenture Solutions Private
Rahul KumarRahul Kumar
Customer Support Specialist at Accenture Solutions PrivateCustomer Support Specialist at Accenture Solutions Private
Sharmistha MoreSharmistha More
Procure to Pay Associate at Accenture Solutions PrivateProcure to Pay Associate at Accenture Solutions Private
Raymond ConwayRaymond Conway
Member Services Specialist at Vystar Credit UnionMember Services Specialist at Vystar Credit Union