Atulya Gupta Email & Phone Number

🚀 Passionate Data Professional | Driving Insights & Solutions 📊Welcome! I'm a data enthusiast skilled in ETL processes, data modeling, and Tableau visualization. I thrive on solving business challenges through data-driven insights. 💡🔍 Key Highlights:💻 SQL:Expertise in SQL for data manipulation, querying, and optimization. Skilled in creating and managing database objects, implementing advanced SQL techniques for data analysis and transformation. Experienced in implementing advanced SQL techniques including Common Table Expressions (CTEs), window functions, and recursive queries for data analysis and transformation.🛠️ SSIS:Skilled in utilizing SSIS components such as control flow tasks, data flow tasks, and event handlers to automate and orchestrate data pipelines. Experienced in handling error handling, logging, and monitoring within SSIS packages for robust data integration solutions.🐍Python:Skilled in Python programming for data manipulation, validation, and automation. Capable of implementing data migration tasks from one server to another using Python, ensuring smooth and accurate transfer of data.📊Tableau:Advanced proficiency in utilizing Tableau features such as calculated fields, parameters, sets, and groups for complex data analysis and visualization. Proficient in working with multiple data sources and blending data for comprehensive insights.☁️AWS:Proficient in leveraging AWS services for data management and processing, including Glue jobs, S3 buckets, and Amazon Redshift. Proficient in managing Redshift clusters, including schema design, data loading, and query optimization.💡 Looking Ahead:Passionate about exploring new tools and technologies related to data. I am eager to collaborate with like-minded professionals on projects that involve solving complex business challenges through data-driven insights. Let's connect to explore how we can leverage data to drive business growth and innovation together!🤝

Listed skills include Leadership, Arduino, Linux, Autocad, and 32 others.

• 

  Data Engineer

  Quantiphi

  Jul 2021 - Present - Mumbai, Maharashtra, India

  - Led the design and implementation of SCD2 structures in data warehouses, enhancing historical data tracking.- Built an ETL pipeline to combine data from multiple warehouses, generating category-wise pipe-delimited files to capture transactional activity and key field updates using SSIS and Python.- Conducted requirement gathering, source-to-target mapping, and pipeline development to generate sampling data for a POC project using SQL and SSIS, facilitating decision-making for business users.- Developed an SSIS ETL package to process 5,000+ XML files, parsing XML data using SQL, SSIS, and Python to create a tableau dashboard, replacing Excel-based manual reporting, thus saving time and manual effort.- Designed 30+ Tableau reports showcasing key KPIs, comparing data through visualizations, and highlighting monetary impacts, aiding day-to-day business operations.- Optimized the data load process for historical data using composite indexes, CTEs, and bulk operations for SQL queries and stored procedures.- Increased data retrieval speed for reporting and business extracts using AWS Redshift, S3, and Tableau.- Implemented Python and SQL-based data reconciliation procedures, significantly reducing data errors and enhancing data integrity and reliability.- Automated crosstab downloads and report sharing from Tableau using Python, reducing manual intervention and ensuring the timely transfer of critical business reports.- Developed an ETL process for generating monthly data extracts for a large dataset containing 400+ columns using Python, Pandas, and SSIS.- Migrated SSRS reports to Tableau, replicating report structure, functionality, and data filters while performing rigorous data validation and testing to ensure accuracy.