Anvesh Chittimalla

• Collaborated with business analysts and data scientists to provide actionable insights from data analytics, directly supporting business decision-making processes.
• Developed and managed ETL/ELT pipelines, notebooks with ADF, Databricks, transforming and consolidating data for analytics solutions, reducing data processing time by 60%.
• Created and managed external tables in Azure Synapse Analytics to query data stored in Azure Data Lake Storage and other external sources, facilitating efficient data integration.
• Monitored data pipelines and cloud resources using Azure Monitor and Log Analytics, proactively addressing performance bottlenecks and system irregularities.
• Facilitated data warehousing solutions dedicated and serverless pools using Azure Synapse Analytics, optimizing data structures for better query performance and reporting flexibility.
• Managed role-based access, lineage tracking, and metadata governance across ADLS, Azure SQL DB and Delta Lake, ensuring compliance with enterprise data governance standards.
• Wrote and optimized complex DAX formulas to meet intricate business logic requirements.
• Extracted, transformed, and cleaned source datasets in Power BI, using Power Query.
• Tech Stack: ADF, Databricks, Synapse, Python, PySpark, U-SQL, Git, EventHub, CI/CD, Functions, PBI

• Collaborated across functional teams in a high-impact role, ensuring seamless end-to-end solution delivery while aligning with business objectives and project scope.
• Created sophisticated ETL solutions with SSIS, integrating diverse data sources like Flat Files, Excel, SQL Server, and DB2 into centralized OLTP, and OLAP databases for analysis.
• Created Event Handlers, Package Configurations, Logging, and User-Defined Variables for SSIS packages, dataflows, streamlining production deployment.
• Designed and developed dynamic self-service reports in Power BI and Tableau, utilizing various custom and default visuals to ensure comprehensive data representation.
• Developed and deployed Power BI dashboards with custom visuals, slicers, and interactive features like hierarchy, highlight and filter actions to enhance user experience.
• Published reports to Power BI Service, configured data connections, scheduled refreshes, and collaborated with end users to deliver tailored solutions.
• Performed rigorous testing and debugging of BI reports to ensure they met high standards of accuracy, reliability, user-friendly, minimizing errors and maximizing data quality and integrity.
• Standardized sourcing strategies for Power BI reports to utilize Tabular models built on SQL Server Data Warehouse and Data Marts with SSAS for consistent organizational reporting.
• Created Alteryx workflows to create end-to-end ETL solutions, created .tde files and moved Tableau extraction files into the Tableau server for reporting needs.
• Tech Stack: SSIS, SSAS, SSRS, SQL Server, Power BI, Tableau, Alteryx, ODI

• Worked closely with cross-functional teams including business analysts and stakeholders, to align data solutions with business requirements, achieving faster delivery times.
• Designed modular and reusable components for ETL processes within ADF, Databricks notebooks, enhancing maintainability and reducing the need for manual adjustments.
• Designed and implemented scalable ETL pipelines in Databricks, Synapseusing PySpark and Delta Lake, optimizing data ingestion, transformation, and storage in ADLS while ensuring schema enforcement, ACIDcompliance with Unity Catalog for enhanced data governance.
• Developed real-time streaming data processing solutions by integrating Azure Event Hub with Databricks, leveraging PySpark structured streaming to process and store event-driven data in Delta Lake, enabling high-speed analytics and improved data reliability.
• Implemented data security and access control policies using Unity Catalogue in Databricks.
• Worked with Avro and Parquet files and converted the data from either format Parsed semi-structured JSON data and converted to Apache Parquet using Data Frames in Spark.
• Created monitoring and alerting mechanisms for data pipelines to proactively address data quality issues, reducing downtime and improving response times for pipeline errors.
• Designed self-service Tableau, Power BI reports enabling business users to generate custom reports while ensuring data accuracy and maintaining security and governance protocol.
• Implemented data security measures using Azure Active Directoryand Azure Key Vault, safeguarding sensitive banking information from potential threats.
• Created storytelling reports using Power BI to provide data insights and recommendations.

Tech Stack: ADF, Databricks, Synapse, Python, PySpark, U-SQL, Git, Cosmos DB, CI/CD, Functions

• Worked effectively with cross-functional teams, stakeholders, and end-users to harness Azure's capabilities for integrating data across multiple business systems and applications.
• Developed Python scripts to facilitate the import and export of data across various systems.
• Set up and managed integrations with Azure Logic Apps to enable event-driven data processing and workflow automation within Azure Databricks using Python and PySpark.
• Created and maintained DevOps release definitions to deploy applications across different environments, streamlining the deployment of Data Factory and Synapse workflows.
• Developed and deployed Medallion ADLS, Delta Lake, and OneLake solutions that offer scalable and cost-effective data storage, processing, and analytics.
• Leveraged Azure Monitor and Azure Log Analytics to track and resolve issues in Databricks, ADF and Synapse pipelines and dataflows, optimizing performance seamlessly.
• Documented DWH architecture and process flows while maintaining comprehensive data dictionaries, metadata, and data lineage to ensure transparency and traceability of data.
• Set up and managed real-time and near real-time streaming data processing in Azure Databricks and Event Hubs, enabling rapid data analysis in Power BI reports.
• Implemented and managed Azure Key Vault to securely store security keys and enforce geo-fencing policies that restrict access based on geographic location.
• Tech Stack: ADF, Databricks, Synapse, Python, PySpark, U-SQL, Git, Cosmos DB, CI/CD, Functions