Aditya Velkur
Arlington,TX
Summary
Detail-oriented IT Developer with 3 years of experience in cloud-based data warehousing solutions and platform administration. Demonstrated expertise in Snowflake security setup, role-based access control, SQL, Python, and Power BI. Proven track record in developing scalable ETL processes and delivering advanced analytics and dashboards that drive business value. Committed to collaborating with cross-functional teams to enhance operational security and data integrity.
Overview
6
6
years of professional experience
Work History
IT Developer-Snowflake Platform
Radiant InfoTech
10.2023 - Current
- Developed comprehensive Snowflake security protocols by creating user roles and hierarchical systems to ensure strict access management.
- Integrated OAuth and SSO solutions ensuring safe access to Snowflake via external applications.
- Implemented Power BI tools to oversee Snowflake activities, enforce security protocols, and evaluate user interactions.
- Set up domain-specific access in Snowflake for controlled data visibility.
- Performed routine security assessments to track and address unauthorized access.
- Set up and managed ETL pipelines utilizing Informatica Cloud for seamless connectivity between local and cloud-based systems.
- Aligned with governance teams to implement data masking protocols for confidential fields, securing compliance with GDPR and CCPA.
- Increased consistency in role assignments and security configurations through Python-based automation.
- Created and applied comprehensive RBAC structures, facilitating safe access differentiation for various user groups.
- Assisted in configuring data pipelines within Azure Data Factory, automating data extraction, and transformation processes into Snowflake.
- Collaborated with senior engineers to identify and resolve issues in Unix scripts.
- Designed and maintained access control mechanisms using SQL.
- Worked alongside consultants on secure, scalable Snowflake solutions.
Jr Data Platform Engineer
Canan Technologies
12.2019 - 11.2020
- Assisted with the upkeep and oversight of Snowflake and other cloud data platforms.
- Generated detailed reports about usage metrics, performance statistics, and other key indicators.
- Implemented authentication mechanisms using OAuth2 protocol and SSO solutions.
- Supported the execution of role-based security measures, guaranteeing adherence to governance policies.
- Collaborated with governance teams to establish data lifecycle management policies.
- Suggested optimizations after analyzing solution architecture, leading to improved platform roadmaps.
- Developed Python scripts to automate data extraction processes, cutting manual effort by 30%.
- Delivered timely technical support to business users, ensuring the resolution of data platform issues within SLA guidelines.
Data Analyst Intern- SQL and Power BI
CCG Technologies
01.2019 - 11.2019
- Assisted in developing Power BI dashboards to visualize key performance metrics for sales and marketing teams.
- Created and executed SQL queries to extract and clean data from relational databases, improving data accuracy by 15%.
- Supported the automation of recurring reports using Python scripts, reducing report preparation time by 40%.
- Collaborated with senior analysts to gather business requirements and develop tailored analytics solutions.
- Monitored dashboard performance and implemented optimizations to enhance data refresh rates.
- Documented data analysis processes and presented findings to internal teams, receiving positive feedback for clarity and actionable insights.
Education
Master of Science - Computer Science
The University of Texas Arlington
Arlington08.2023
Bachelor of Technology (B.Tech.) - Computer Science and Engineering
Visveswaraya Technological University
Bengaluru, India05.2020
Skills
Cloud Data Warehousing: Snowflake (Administration, Security, Development)
Data governance: security protocols, role-based access control (RBAC), and data platform optimization
Programming: Python, SQL, and Unix scripting
Analytics and Reporting: Power BI, Tableau
ETL Development: Informatica Cloud, dbt
Data Analytics Platforms: Snowflake, GCP, and Azure
Documentation: Creating technical roadmaps, platform best practices, and production rollout approvals
Problem-solving: troubleshooting platform issues, and suggesting architectural improvements
Projects
E-commerce Data Warehouse
- Implemented a star schema data model using SQL, developed Python ETL scripts reducing data loading time by 20%, and created interactive React.js visualizations for enhanced sales and customer insights.
Build Your Neural Network
- Spearheaded the development of a Python and TensorFlow-based SPA, increasing user engagement by 15% and enabling CNN training with personalized datasets, improving model accuracy by 20%.
KDP Analytics Security Overhaul
- Designed and implemented Snowflake security setup for KDP Analytics, ensuring seamless adherence to company governance and security protocols. Worked with the Change Control Board (CCB) to evaluate and approve platform changes.
Timeline
IT Developer-Snowflake Platform
Radiant InfoTech
10.2023 - Current
Jr Data Platform Engineer
Canan Technologies
12.2019 - 11.2020
Data Analyst Intern- SQL and Power BI
CCG Technologies
01.2019 - 11.2019
Master of Science - Computer Science
The University of Texas Arlington
Bachelor of Technology (B.Tech.) - Computer Science and Engineering
Visveswaraya Technological University