Prasad S Email & Phone Number

United States

• Gathered needs and translated healthcare business needs into technical specifications. Used SDLC guides to driveproject development for successful delivery of tailored dashboards and reports.
• Developed a healthcare analytical solution using Power BI. Created interactive dashboards and reports to provideinsights into patient outcomes and operational efficiency, reducing manual data analysis hours by 30%.
• Designed and optimized an ETL pipeline using Informatica PowerCenter. Improved data processing efficiency by20% through enhanced data extraction, transformation, and loading processes tailored to Teradata.
• Utilized DAX in Power BI to create advanced calculations and measures. Implemented a star schema fordimensional modeling, enhancing the analytical efficiency of healthcare data by 25%.
• Automated data validation and cleansing processes using Power Automate. Reduced data errors by 20% andimproved data accuracy, integrating SQL and Python scripts to streamline and enhance data quality.

• Developed a wide sales analytics dashboard using Power BI, SSRS, and SSAS, integrating data from varioussources and reduced data load time by 30%, resulting in a 40% increase in sales performance analysis efficiency.
• Implemented an ETL pipeline using Talend for AWS Redshift, creating customer segmentation dashboards inTableau. This solution enhanced targeted marketing efforts and increased campaign ROI by 25%.
• Led the development of a financial reporting system with Looker and SSIS, automating monthly financial reportsand enhancing data accuracy. This initiative cut manual reporting time by 50%.
• Created an operational efficiency dashboard in Tableau, using data aggregation and transformation withInformatica, SSIS, and MySQL databases. Optimized SQL query performance.
• Designed a supply chain analytics solution in Power BI, SSAS, and Google Big Query, integrating ERP and IoT datafor real-time tracking, reducing data processing time by 35% and enhancing decision-making capabilities.

• Developed a financial analytics system in QlikView, using data modeling techniques and automating Oracledatabase consolidation, which improved reporting efficiency by 60% and enabled real-time financial insights.
• Engineered an ETL framework with SSIS and Informatica PowerCenter for Snowflake, reducing data integrationtime by 50% and enhancing data accuracy.
• Created a customer analytics platform with Tableau and AWS Redshift, incorporating Python for advanced dataprocessing, boosting customer engagement and retention by 20%.
• Assembled an executive sales dashboard in Tableau, integrating SQL Server and Salesforce data with DAX fordynamic metrics, increasing performance metrics by 35%.
• Designed a supply chain dashboard in Tableau, integrating PostgreSQL and ERP data, applying SDLCmethodologies, and enhancing inventory management and operational efficiency by 25%.

Master'S Degree, Information Systems

Bachelor Of Technology - Btech, Electronic And Communication Engineering