Adithya V Email & Phone Number

Requirements Analysis & Migration Expertise: Collaborated in requirement gathering sessions, working closely with system analysts to understand data formats and patterns. Executed successful data migrations from RDBMS to NoSQL databases, providing comprehensive solutions for diverse data ecosystems.End-to-End Data Solutions in Azure: Designed and deployed end-to-end data solutions on Azure, encompassing storage, integration, processing, and visualization. Leveraged Azure PaaS services to architect modern data solutions, supporting advanced data visualization capabilities.Cloud Database Management & Migration: Designed and configured Azure Cloud relational servers and databases, aligning them with current and future business needs. Proficient in migrating data from on-premises SQL servers to cloud-based solutions like Azure Synapse Analytics and Azure SQL DB.Pipeline Orchestration & Monitoring: Orchestrated data pipelines using Azure Data Factory, implementing custom alerts platforms for proactive monitoring. Proficient in data ingestion, processing, and visualization across multiple Azure services, ensuring seamless data flow and operational efficiency.

Data Format Optimization & Efficiency: Streamlined data processing by converting raw formats like Avro and Parquet, reducing processing time and enhancing network efficiency.Hadoop Pipeline Development: Designed end-to-end data pipelines on Hadoop platforms, ensuring smooth data flow and optimized processing.Scripting & Transformation: Utilized Python scripting for Informatica mappings and Scala programming for transforming HiveQL into Spark transformations, enhancing data processing workflows.Visualization & Integration: Designed Tableau dashboards integrating multiple data sources, and integrated Alteryx for enhanced data preparation and transformation capabilities, contributing to improved insights and efficiency.ETL Workflow Customization: Built custom ETL workflows using Spark/Hive, optimizing data cleaning and mapping processes for improved data quality and integrity.

AWS Migration & Scalable Solutions: Designed and implemented scalable distributed data solutions on AWS, including planning and executing migration from on-premises Cloudera Hadoop to AWS based on business requirements.Data Modeling & Analysis: Collaborated with design teams to create conceptual data models and flows. Analyzed Hadoop clusters and big data analytic tools like Hive, Spark, Python, Sqoop, and Oozie.Streaming Data Processing & Integration: Implemented transformations on streaming data and datasets, configuring HDFS for distributed data storage. Utilized Kafka for ingesting streaming data, and integrated with Spark for real-time processing and migration to AWS EMR.Cloud Deployment & Management: Configured, deployed, and supported cloud services on AWS, including EMR, EC2, S3, RDS, and Redshift. Developed data pipelines with Airflow for scheduling PySpark jobs and migrating ETL processes.Advanced Data Analytics & Visualization: Implemented advanced procedures like text analytics using Apache Spark and Scala. Developed real-time stream processing applications using Spark, Kafka, Scala, and Hive. Utilized Tableau for dashboards and visualizations, collaborating with data scientists for forecast model integration. Employed Airflow for automated data ingestion pipeline scheduling, and version control tools like GitHub for code sharing among team members.

Data Systems Enhancement & Advising: Spearheaded the creation and enhancement of data systems for collection, management, and reporting, advising on technology strategies to boost efficiency and foster a data-driven culture within the organization.Business Process Documentation & Modeling: Assisted in documenting business processes for data collection, entry, and reporting, strengthening performance management practices. Implemented logical and physical data modeling to streamline data architecture.Stored Procedures & Crystal Reports Development: Developed PL/SQL stored procedures to fulfill end-user reporting requirements. Created Crystal Reports and integrated them with Business Objects for easy access via WEBI on both intranet and extranet platforms.Multidimensional Analysis & Technical Solutions: Created queries for multidimensional analysis and recommended technical solutions to address complex business needs, enhancing the reporting environment for user communities and clients.Performance Tuning & ETL Development: Conducted performance tuning of SQL queries and stored procedures using Database Tuning Advisor in SQL Server. Developed SSIS packages for loading data from Oracle to SQL Server, transforming data with various transformations. Utilized SSIS Reusable Packages for ETL processes and updated cubes with current data using Analysis Services proce

Requirements Collaboration & Documentation: Partnered with business analysts to understand project requirements and develop Technical Specification Design documents, ensuring alignment with business objectives.Cross-Functional Data Support: Collaborated with marketing, communications, and operations teams to address their data needs, facilitating efficient cross-functional collaboration and support for campaigns and service operations.Real-Time ETL & Data Storage: Implemented real-time streaming ETL pipelines using Kafka Streams API, leveraging Hive for web interfacing and data storage.Migration & Optimization: Migrated MapReduce programs to Spark transformations, enhancing processing speed and efficiency. Utilized Spark scripts for data access and quality checks, optimizing data workflows.Cloud Infrastructure & Automation: Managed scalable infrastructure on AWS, deploying CI/CD pipelines with Jenkins for automated builds and deployments. Utilized AWS services for data exchange, backup, and processing, ensuring efficient cloud integration and management.