• Developed analytical dashboards and reports using Power BI for executive decision-making.• Utilized Amazon Redshift, MongoDB, AWS, and Azure SQL Data Warehouse as primary data sources for data analysis and reporting.• Created custom visualizations with D3 JavaScript and TypeScript.• Applied DAX functions like SUMX, CALCULATE, and RANK for advanced data calculations.• Implemented drilldowns, drill throughs, and bookmarks for enhanced report navigation.• Conducted data cleansing using 'M' Language, Power Query, and MongoDB aggregation pipelines.• Managed parameters for different environments (development, test, production).• Developed dynamic dropdown measures and calculated columns.• Created descriptive, predictive, and prescriptive reports.• Implemented dynamic and static row-level security for secure data access.• Configured Power BI gateways for scheduled report refreshes.• Wrote SQL queries for data quality verification and used MongoDB queries for NoSQL data integration.• Designed data models using STAR, SNOWFLAKE, and GALAXY schemas.• Handled relationships in Power BI Desktop.• Deployed reports in Power BI Report Server and embedded them into custom .Net applications.• Worked with both Direct and Import Query Modes in Power BI.• Utilized AWS services and Azure Data Lake/Data Factory for data movement and scheduling.• Developed pipelines, activities, and U-SQL scripts in Azure Data Factory.• Managed backups/restores and configured integration runtime in Azure Data Factory V2.• Used Polybase for loading data into destination databases from Amazon Redshift and MongoDB.

• Generated periodic reports for Marketing and Logistics using SAP BW, Salesforce, and Excel.• Designed and developed interactive Power BI dashboards with various visualizations.• Created solution-driven views and custom visualizations, including Heat Maps, Pie Charts, and Histograms.• Utilized Power Query to extract and transform data from external sources.• Implemented custom themes for meaningful report visualization using JSON files.• Published Power BI reports to end users via mobile and content packs.• Applied conditional formatting in visuals for data representation.• Designed trend analysis visuals by Year, Quarter, and Month.• Utilized geography data visualization tools like MAP, ArcGIS, and Globe Map.• Conducted weekly presentations of Power BI prototypes to stakeholders, providing training as needed.• Conducted data cleansing in Power BI Desktop, including Merge Columns and Pivot operations.• Developed KPIs and presented them to business users weekly.• Managed user roles and groups, providing row-level security.• Analyzed SAP BW data dimensions and created a data dictionary.• Utilized TypeScript, D3 JavaScript, HTML, and CSS to develop custom visualizations.• Created operational reports for Marketing, including daily reports.

• Extracted data from various sources such as Electronic Health Records (EHR) systems, healthcare databases, spreadsheets, APIs, and databases like Teradata, Oracle, and SQL Server.• Cleaned and preprocessed healthcare data to ensure accuracy, consistency, and usability for analysis, adhering to data governance policies.• Created visualizations such as charts, graphs, and dashboards in Power BI and Tableau 8.x (Desktop/Server) to effectively communicate insights to healthcare stakeholders, including physicians, administrators, and policymakers.• Segmented patients based on demographic, behavioral, or clinical characteristics, creating profiles to understand their needs and preferences for personalized care.• Developed predictive models to forecast healthcare outcomes such as patient readmission rates, patient adherence, and disease progression.• Monitored key performance indicators (KPIs) and metrics to track the effectiveness of healthcare strategies and initiatives, using Power BI and Tableau for real-time updates.• Ensured compliance with HIPAA regulations and other data privacy standards when handling sensitive patient data in Power BI and Tableau.• Utilized Power BI's dataflows and data gateways, along with Tableau's data extracts and live connections, to integrate and refresh healthcare data from multiple sources, including Teradata and Oracle.• Developed custom Power BI templates and themes, and designed Tableau dashboards to standardize reporting across the healthcare organization.• Utilized tools like Power Designer and MS Visio for data modeling and process mapping, ensuring the integrity and efficiency of healthcare data systems.• Managed projects from conception to completion using JIRA Microsoft for task tracking and MS Visio for documentation, specifically for healthcare analytics initiatives.• Presented findings and recommendations to healthcare stakeholders using Power BI and Tableau for visual storytelling.

• Segmented users for targeted marketing campaigns and personalized customer experiences using MS Excel for data analysis and Tableau 8.x (Desktop/Server) and Power BI Desktop for visualization.• Analyzed transaction data in MS Excel and Power BI Desktop to optimize business processes, identify bottlenecks, and detect fraudulent activities, ensuring data accuracy and consistency.• Calculated Customer Lifetime Value (CLV) in MS Excel and visualized high-value customer segments in Tableau and Power BI to tailor retention strategies and maximize ROI.• Predicted churn risk using Power BI Desktop and implemented targeted retention campaigns, sharing insights with stakeholders via MS Teams for collaborative decision-making.• Mapped out the user journey across multiple touchpoints using Tableau to identify areas for improvement and enhance customer experience.• Conducted A/B tests, analyzing results in MS Excel and visualizing outcomes in Tableau and Power BI to optimize product features, user interfaces, and pricing strategies.• Implemented machine learning algorithms and visualized fraud detection results using Power BI Desktop and Tableau, safeguarding company assets and customer trust.• Monitored sentiment on social media platforms and customer support interactions, utilizing MS Excel for data aggregation and Tableau for sentiment analysis visualization.• Ensured compliance with data privacy regulations and implemented robust security measures in Power BI and Tableau to protect sensitive customer data.• Leveraged predictive analytics in Power BI Desktop and Tableau to forecast future trends and customer behavior, informing strategic planning and decision-making, with collaboration facilitated through MS Teams.