Data Analyst Power Bi

ADARSH DATTA INTURI

Data Analyst

*********************@*****.*** +1-270-***-****

OBJECTIVE:

Seeking a challenging role as a Data Analyst to leverage my expertise in data analysis, visualization, and reporting to provide actionable insights and drive data-driven decision-making. Proficient in utilizing tools such as Python, SQL, Power BI, and Tableau, I aim to contribute effectively to data-driven projects and enhance business intelligence.

PROFESSIONAL SUMMARY:

Experienced Data Analyst with expertise in data analysis, visualization, and reporting using Python, SQL, Power BI, and Tableau.

Proficient in extracting, transforming, and loading (ETL) processes to ensure data integrity and accuracy.

Developed automated data validation frameworks in SQL and Python to ensure data quality and consistency.

Collaborated with cross-functional teams to deliver data-driven insights and recommendations.

Skilled in creating dynamic visualizations and customized reports for business intelligence.

Conducted performance tuning and optimization of data processes and dashboards.

Trained and supported teams in data analytics, fostering a data-driven culture.

Presented strategic performance reports to senior leadership for informed decision-making.

TECHNICAL SKILLS:

Data Analysis & Visualization: Power BI, Tableau, Microsoft Excel

Programming Languages: Python, SQL

Data Storage: PostgreSQL, AWS S3

ETL/BI Tools: AWS Glue, Azure Data Factory (ADF)

Big Data Technologies: PySpark, Apache Hadoop, Apache Spark

Version Control: Git

CI/CD: Jenkins

Serverless Services: AWS Lambda

Databases: Snowflake, Databricks, Teradata, Oracle

Security and Compliance: AWS Well-Architected Framework, CIS Benchmarks

Skill Set: Microsoft PowerPoint

PROFESSIONAL EXPERIENCE:

CNSI, Gaithersburg, MD AUG 2023 – Present Data Analyst

Played a key role in migrating healthcare data from Teradata to AWS Snowflake, ensuring data accuracy and integrity throughout the process. Utilized AWS Glue for constructing ETL pipelines to streamline the migration.

Developed robust Python scripts to automate data extraction, transformation, and loading processes. These scripts improved efficiency and reduced manual intervention.

Worked closely with the marketing team to analyze customer data, leading to optimized campaign strategies and improved marketing effectiveness through data-driven insights.

Created detailed performance reports and strategic proposals for senior leadership, enabling data-driven decision-making and strategic planning.

Designed and implemented a data validation framework using SQL, which automated the comparison of data between Teradata, PostgreSQL, and AWS Snowflake, ensuring data consistency post-migration.

Leveraged AWS S3 as a staging area for intermediate data storage during migration, optimizing data handling and processing workflows.

Configured Jenkins for continuous integration and deployment, streamlining ETL pipeline updates and ensuring timely delivery of data solutions.

Developed dynamic visualizations and customized reports in Power BI, enhancing data accessibility and user experience for stakeholders.

Conducted training sessions for marketing staff to improve their understanding and interpretation of analytics results, fostering a data-driven culture within the organization.

Performed extensive performance tuning and optimization of ETL pipelines and data dashboards, significantly improving data processing speeds and reporting efficiency.

Gathered and documented business requirements, collaborated with stakeholders to understand their needs, and translated them into effective data models and reporting solutions.

Demonstrated leadership by guiding the team in Agile methodologies, writing user stories, and building and planning roadmaps.

Participated in all phases of testing, including system, integration, and user acceptance, creating use cases, test conditions, and reviewing outputs.

Tata Consultancy & Services, Bangalore, India JAN 2021 to JUL 2022

Junior Data Analyst

Assisted in the migration of an on-premises Oracle platform to Azure Databricks, enhancing the organization's advanced analytics capabilities.

Utilized Azure Data Factory (ADF) to orchestrate ETL workflows with PySpark, ensuring efficient data integration and transformation.

Designed and implemented ETL pipelines using PySpark, managing data flow from source to various stages (raw, staging, gold) for comprehensive data processing.

Developed a SQL-based data validation framework to ensure the accuracy and consistency of data post-migration, automating the comparison between source and target datasets.

Conducted thorough data quality checks and validation to maintain high standards of data integrity and reliability. Integrated Jenkins into the development workflow to automate CI/CD pipelines for ETL processes, ensuring continuous delivery and deployment.

Implemented automated scripts and tools to streamline data processing workflows, reducing manual intervention and increasing efficiency.

Worked with diverse teams to gather requirements and deliver customized data solutions.

Collaborated with stakeholders to understand business needs and translate them into effective data models and reporting solutions.

Created and optimized Tableau dashboards incorporating complex SQL queries, providing stakeholders with actionable insights and enhancing data visualization.

Developed dynamic visualizations and interactive reports to support data-driven decision-making across various business functions. Developed services to import data from various sources, including APIs and log files, ensuring seamless integration and accurate data flow.

Implemented scalable data processing platforms for real-time analytics, enabling timely insights for business improvement.

Conducted performance tuning and optimization of Tableau dashboards, significantly improving efficiency and user experience.

Identified and addressed bottlenecks in data processing workflows, enhancing overall system performance.

Prepared functional and detailed system design documents and participated in all phases of testing, including creating use cases, test conditions, and reviewing output

Data Analyst Intern JAN 2020 - MAY 2020

Verzeo, Bangalore, India

Worked on transforming raw data into structured formats suitable for analysis and reporting, utilizing SQL queries and Python scripts to clean, validate, and enrich the data.

Assisted in the design and implementation of data pipelines using Python and SQL, ensuring seamless extraction, transformation, and loading of data from various sources.

Developed and executed data validation checks to ensure the accuracy and reliability of transformed data.

Documented data transformation processes, including detailed descriptions of data flows, transformation logic, and pipeline architecture.

Created basic Power BI dashboards to visualize key metrics and trends, supporting data-driven decision-making processes.

Collaborated with senior analysts to develop and refine visualizations and reports for various business stakeholders.

Worked closely with senior engineers and analysts to address complex data challenges and develop innovative solutions that enhanced data quality and operational efficiency.

Participated in team meetings to discuss project progress, challenges, and solutions, contributing to collaborative problem-solving efforts.

Maintained comprehensive documentation for data transformation processes and analysis workflows, facilitating knowledge sharing and onboarding of new team members.

Prepared and presented progress reports to supervisors, highlighting key achievements and areas for improvement.

PROJECTS:

Masters Project. Implemented a Natural Language Processing (NLP) system to analyze social media sentiment using Python and NLTK. The project included data collection, preprocessing, sentiment analysis, and visualization of results, providing insights into public opinion on various topics.

Bachelors Project. Developed an Online Hospital Management System integrating a robust database to streamline operations, enhance patient care, and ensure compliance with regulations, utilizing Node.js, React.js, MongoDB, and secure authentication.

EDUCATION:

Bachelor’s in information technology, R.V.R & J.C. College of Engineering, India (APR 2022).

Master’s in computer science, University of Central Missouri (DEC 2023).

CERTIFICATIONS:

AWS Certified Solutions Architect Associate

-https://www.credly.com/badges/dc9e82f8-b4a9-45c0-94c8-67c9647d4eb5/linked_in_profile

AWS Certified Cloud Practitioner

-https://www.credly.com/badges/8a144e48-08d3-4187-ad34-f943fd2890fe

Contact this candidate