Prashanth S Email & Phone Number

Experienced Senior BI Developer and Data Engineer with around 6 years of expertise in Snowflake, Azure Services, SQL servers, Tableau, Power BI and data migration projects, driving efficient data-driven decisions. Worked on Database Migration from SQL and Oracle to Snowflake Database. Proficient in data warehousing, database design, and development using Microsoft technologies, including Tableau, SSIS, SSRS, SSAS, SQL Server 2014 to 2019, and Power BI. Strong background in OLTP, OLAP, and various data stores, including RDS, NoSQL, Hive, MySQL, and Snowflake, ensuring data accessibility and usability.Key Highlights:- Monitored and interpreted the query performance to revamp and optimize existing database objects in Snowflake, leading to enhanced performance. -Wrote complex SQL queries and stored procedures to extract and manipulate data for reporting purposes. - Conducted performance tuning to optimize database queries and improve overall system responsiveness.- Enhanced existing Python programs for Governance, Risk and Compliance teams and executed weekly and monthly, for extracting data from Third Party Risk Management Portals.- Orchestrated seamless data flow by moving files to AWS S3 external staging through Snowflake staging and running stored procedures for final data ingestion.- Led data migration efforts, ensuring data integrity and optimal performance.- Developed and maintained ETL and ELT pipelines with data from various sources, enabling seamless data integration into data lakes and data warehouses for reporting and analytics.- Facilitated migration of reports to Snowflake DB, optimizing data storage in a cloud-based environment.- Designed and maintained ETL/ELT pipelines using Apache Airflow for seamless data ingestion and transformation.- Leveraged Azure DevOps for version control and CI/CD of BI solutions, streamlining development and deployment.- Proficient in Power BI report publication, web client availability, and automated refresh scheduling.- Collaborated with cross-functional teams to meet business data requirements effectively.- Implemented data normalization and denormalization strategies for data consistency and real-time reporting.- Developed IBM Cognos frameworks, dashboards, and reports for real-time business insights.- Applied SDLC best practices within Agile and Scrum methodologies.- Expertise in converting complex business logic into SQL tools, including Stored Procedures, User Defined Functions, Views, and Data Modeling.