• Developed and managed Snowflake Cloud environments, optimizing performance through advanced SQL and PL/SQL query tuning, as well as database performance enhancements and stored procedure development.• Engineered scalable Data Warehouse systems by creating Snowflake views on raw data in compliance with domain specifications, facilitating efficient data retrieval and reporting.• Designed robust ETL processes using Matillion, ensuring data accuracy and seamless integration with Snowflake to support analytics and reporting.• Built and maintained Power BI dashboards, leveraging M Query and DAX to deliver actionable business insights, while automating data workflows to enhance operational efficiency.• Engineered end-to-end data pipelines with data ingestion using SSIS Data Flows ensuring efficient data flow into SQL Server for real-time visualization and analysis.• Collaborated with onsite and offshore teams to deliver high-quality data solutions, enhancing project outcomes through effective communication and teamwork.• Monitored daily usage of Snowflake, tracking long-running queries and optimizing throttling capacities to improve Power BI performance and user experience.• Automated Power BI report subscriptions by creating data flows in Power Automate, ensuring timely and accurate delivery of paginated reports to clients.

• Developed API integrations for Accertify TBI Authentication using NodeJS, TypeScript, and JavaScript, enabling secure and efficient data flow between systems.• Monitored database connectivity for web services via Node Oracle DB using Oracle SQL Developer, ensuring consistent data availability and performance.• Analyzed and optimized web services performance through extensive testing with Postman and JIRA, ensuring optimal system reliability and responsiveness.• Implemented encrypted transaction processes using advanced security algorithms (Triple DES, AES), ensuring data protection and secure communication with front-end systems.• Collaborated with cross-functional teams including DBAs and developers, ensuring seamless integration and data flow across multiple systems and environments

• Architected complex data models in Snowflake, ensuring scalability and optimized performance for large datasets across multiple business functions.• Maintained MyGeotab API integration using JavaScript and SQL, enabling smooth data flow and retrieval processes, contributing to real-time data-driven decision-making.• Developed and automated Power BI dashboards using M Query and DAX, delivering key business insights and automating data workflows, resulting in reduced manual effort and faster reporting cycles.• Designed Data Flows for inserting stored procedure data to SSIS tables• Implemented Snowflake security features, including role-based access control and data masking, ensuring compliance with data protection policies and safeguarding sensitive information.• Spearheaded automation of data retrieval and processing pipelines with custom scripts, minimizing manual intervention, improving system reliability, and optimizing operational efficiency.• Managed software updates and version control for MyGeotab servers via the MyAdmin portal, ensuring system stability and enhancing user experience.

Engineered and deployed a responsive website for HiTech Bay using HTML5, CSS3, JavaScript, and React, with SQL Server 2012 serving as the backend Leveraged AWS for deployment, utilizing AWS EC2 instances and S3 buckets for scalable database storage solutionCollaborated with testing and DevOps teams to perform rigorous testing, debugging, and optimization of applications, ensuring smooth deployment and operational stabilityDeveloped inventory monitoring solutions, integrating Amazon Central Server to track real-time sales and stock levels for Amazon and Best Buy orders, optimizing supply chain management and sales tracking

• Collaborated with cross-functional teams to design, develop, and implement scalable data pipelines, supporting efficient data processing for analytics and reporting.• Utilized Snowflake for data warehousing, data modeling, and ETL processes, enabling seamless data ingestion, transformation, and integration across multiple platforms to support business intelligence and reporting needs.• Developed and maintained data visualization dashboards using Power BI, providing key insights and enabling data-driven decision-making for stakeholders.• Acted as a system administrator for data platforms to optimize the performance of ETL pipelines and data warehousing solutions during deployment and integration.• Contributed to end-to-end data engineering projects, using tools like Python, SQL, and cloud-based solutions (e.g., AWS/Azure), to ensure data availability, consistency, and scalability across systems.• Debugged and tested data workflows using unit/regression tests, and documented processes using JIRA and Confluence, ensuring efficient collaboration and data governance compliance.