Aryan Gupta Email and Phone Number

• Writing and optimizing SQL queries to transform and load data. Creating and managing Snowflakedatabase objects such as tables, views, and stored procedures. Performing data validation and integritychecks to ensure client requirements were met.• Transitioned data storage from on-premise databases to Snowflake. This involved designing andimplementing data models, optimizing storage, and ensuring efficient retrieval.• Designed Talend jobs to replicate SSIS package functionalities. Optimizing data transformation logic toimprove performance and scalability. Implementing error handling and logging mechanisms to ensuredata integrity and operational transparency.• Conducted an in-depth analysis of existing SSIS extract transform load pipelines to understand dataflows, dependencies, and complexity. Developed a comprehensive migration plan outlining the required steps, timelines, and resources.• Conducted extensive testing to validate data accuracy, completeness, and performance of the migratedETL processes. This included unit testing, integration testing, and performance benchmarking

• Assisted in gathering and documenting business requirements for process improvement projects.• Conducted SWOT analysis and developed strategic recommendations for client projects.• Created process flow diagrams and business models to illustrate current and future state processes• Supported the development of project plans and timelines, ensuring timely completion of deliverables.