Prachi P. Email & Phone Number

Canada

• Conducted in-depth data analysis and visualization using Power BI, and advanced Excel, transforming complex financial data into actionable insights for key stakeholders• Leveraged strong SQL expertise to query, extract, and manipulate data, ensuring data accuracy and providing critical support to various banking function• Developed SQL queries and ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with the data warehouse• Designed and developed… Show more • Conducted in-depth data analysis and visualization using Power BI, and advanced Excel, transforming complex financial data into actionable insights for key stakeholders• Leveraged strong SQL expertise to query, extract, and manipulate data, ensuring data accuracy and providing critical support to various banking function• Developed SQL queries and ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with the data warehouse• Designed and developed high-quality dashboards and reports using tools Power BI, SSRS, Excel, PowerPivot, and Tableau• Created and maintained a data dictionary to ensure new data is properly maintained, categorized, and linked within existing reporting structures• Utilized Power Query and DAX within Power BI for sophisticated data modeling, significantly improving the precision of financial forecasting and planning Show less

Vadodara, Gujarat, India

• Engaged with clients to understand their needs and provide tailored solutions, ensuring high customer satisfaction.• Utilized Microsoft Power BI, SSRS, SSIS, and Power Automate to conduct analysis, documentation, testing, implementation, and user support for healthcare platforms.• Implemented data solutions using Google Cloud Platform (GCP), enhancing data processing and storage capabilities.• Developed solutions to streamline tasks using Oracle, T-SQL, SQL Jobs, SSIS, and Power… Show more • Engaged with clients to understand their needs and provide tailored solutions, ensuring high customer satisfaction.• Utilized Microsoft Power BI, SSRS, SSIS, and Power Automate to conduct analysis, documentation, testing, implementation, and user support for healthcare platforms.• Implemented data solutions using Google Cloud Platform (GCP), enhancing data processing and storage capabilities.• Developed solutions to streamline tasks using Oracle, T-SQL, SQL Jobs, SSIS, and Power Automate.• Performed database development in MS SQL, creating stored procedures, functions, and views while adhering to best practices in data modelling and database concepts.• Generated comprehensive reports with diverse datasets using SSRS, Excel, Tableau, and Power BI to enhance clients' KPIs.• Conducted data transfer activities by identifying and employing methods for data sources not previously encountered, ensuring smooth integration and migration processes. Show less

Vadodara, Gujarat, India

• Updated and enhanced the recruiting platform's front end using C#, .NET, and JavaScript, improving user experience and platform performance.• Designed and maintained Power BI reports and dashboards for the executive team by gathering requirements from various departments and delivering actionable insights to inform decision-making.• Optimized SQL procedures and jobs for efficient data management and retrieval, leveraging SSAS to transform live SQL data into a presentable format for… Show more • Updated and enhanced the recruiting platform's front end using C#, .NET, and JavaScript, improving user experience and platform performance.• Designed and maintained Power BI reports and dashboards for the executive team by gathering requirements from various departments and delivering actionable insights to inform decision-making.• Optimized SQL procedures and jobs for efficient data management and retrieval, leveraging SSAS to transform live SQL data into a presentable format for real-time Power BI reporting.• Communicated project statuses and updates to internal and external clientsto ensure the timely and successful delivery of project deliverables. Show less

Vadodara, Gujarat, India

Gujarat, India

• Developed an Android application with the assistance of an internal team with project management and data analysis tasks.• Gained hands-on experience in mobile app development, collaborating closely with cross-functional teams to deliver efficient software solutions.

Graduate Certificate, User Experience(Ux) Design

Graduate Certificate, Big Data Solution Architecture

-Good understanding of R, Python, SQL, and Excel. I've also worked with NoSQL databases such as MongoDB, Couch DB and Cassandra. I also.

Bachelor Of Engineering - Be, Information Technology