Data Analyst

Naga Lakshmi Prasanna Gottipati

P: +1-832-***-**** E: *********************@*****.***

Professional Summary:

Seasoned Data Engineer with 3+ years of experience in cloud-based data solutions, specializing in data visualization. Proficient in AWS and Azure technologies, including Databricks and Data Factory. Expert in creating interactive dashboards with Power BI and Tableau, transforming complex datasets into actionable insights. Skilled in both relational and non-relational databases such as SQL Server and Cosmos DB. Education:

• University of Houston, Houston, TX: Masters in Data Science Dec 2023

• SASTRA University, India: Bachelor of Engineering in Computer Science May 2021 Certifications:

• Microsoft Certified: Azure Data Engineer Associate – DP 203

• Microsoft Certified: Power BI Data Analyst Associate – PL 300`

• Microsoft Certified: Azure Data Fundamentals – DP 900 Technical Skills:

• Data Pipelines and Automation: Python, Apache Spark, HDFS, MapReduce, Airflow, ETL/ELT tools, API integration, Automation

• Cloud Platforms: Microsoft Azure (Data Factory, Databricks, Blob, Data Lake, Active Directory), AWS (EMR, EC2, S3, Redshift)

• Data Modeling & Warehousing: Snowflake, SQL (Oracle, SQL Server, MySQL), Docker

• Data Quality and SQL: SQL, SSIS, SSRS

• Visualization, Reporting, and Additional Tools: Tableau, Power BI, Reporting, R, Scala, PyCharm (IDE for Python), Alteryx

• Soft Skills and Additional Abilities: Strong Internet Research, Time Management, Presentation, Communication, Team Collaboration Work Experience

Data Analyst SBS Corp, Houston, TX Apr 2024 – Present

• Led the design and implementation of Power BI dashboards, with a strong focus on data pipelines, data quality, and automation.

• Utilized advanced techniques such as pre-processing, indexing, blocking, and record comparison/classification to optimize the performance of large-scale data pipelines in Snowflake.

• Constructed and maintained robust ETL pipelines for seamless data movement, integrating Snowflake's capabilities for efficient data warehousing.

• Leveraged advanced technologies (Snowflake, Hadoop, Spark, Kafka, Apache NiFi, Apache Airflow) for efficient data processing, specializing in data pipelines using Snowflake, Azure Data Factory, ETL/ELT, cloud platforms, and API integration using Python.

• Collaborated with Business Analysts, aligning analytics with organizational needs for effective decision-making and processes. Power BI Analyst Stone Grid LLC, Remote, US Nov 2022 - Apr 2024

• Led Azure project, improving inventory and sales data management with a focus on data pipelines and automation.

• Designed Power BI dashboards, offering spending portfolio insights, emphasizing data warehousing and ETL/ELT tools.

• Conducted cohort analysis, applying predictive modeling techniques, and integrating findings into Power BI to provide valuable insights for informed decision-making.

• Conducted cohort analysis, applying predictive modeling techniques, contributing valuable insights for informed decision-making, and showcasing skills in data pipelines, data quality, ETL/ELT, cloud platforms, API’s (REST, GraphQL) integration, Python, and Spark. Business Intelligence Analyst Ford, Chennai, India Aug 2021 – Jan 2022

• Managed reporting environment with robust data processing using Microsoft SQL Server, focusing on data pipelines and automation.

• Extracted data from diverse sources in formats like CSV, XML, and JSON, ensuring efficient processing and scalability.

• Designed Tableau dashboards, granting stakeholder access to interactive campaign data, emphasizing data warehousing and ETL/ELT.

• Enforced AGILE methodology in SDLC, ensuring streamlined project management tool JIRA, development processes, and API integration. Data Analyst Symfore, Hyderabad, India May 2019 – Aug 2021

• Designed and developed interactive Tableau dashboards, offering comprehensive insights into key business metrics, and supporting data-driven decision-making.

• Optimized Tableau dashboard performance by implementing best practices for data ETL processes.

• Collaborated with cross-functional teams to gather requirements and create dynamic Tableau dashboards that align with company goals.

• Implemented stringent security on dashboards, prioritizing data integrity, documenting data linage, and using Git version controllers. Academic Project Experience

• Data Warehousing and Business Intelligence: Implemented BI tools and data warehousing solutions, showcasing expertise in optimizing data infrastructure, fitting the responsibilities of a data engineer.

• Improving Patient Outcomes through Predictive Modeling: Constructed hospital readmission models and analyzed electronic health records, showcasing proficiency in data engineering.

Contact this candidate