Haripriya Subramanian

Roles and Responsibilities:

* Worked for Siemens Health Care IT Team, Variant IT reports Integration and Process Mining.

* Responsible for gathering requirements, system analysis, design, development, testing, and deployment.

* Reports, flows, and Apps are Developed for Project Benefit, Business Value, Compliance, Incident Management, Problem Management, Microsoft Intune Data (My Mobile and My Mac), Risk management, Service Management, User satisfaction survey Data, and IT Training using the Microsoft Power Platform.

* Worked in AGILE Methodology and SCRUM Process.

* Worked closely with Developer, Product owner, Scrum master, QA team, Process Owner.

* Actively participated sprint and Sprint retrospective meetings.

* Successfully created Use Cases, User stories, UML diagrams, Functional Requirements Specifications (FRS) and User Requirement Specification (URS) documents and implemented processes, procedures, guidelines.

* Worked in Data Design, Transformation and Loading, Data Analysis, Data migration, Data preparation, Data Validation, Data Quality, Data Profiling Reporting, and Documentation.

* Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Power BI :

* Created interactive reports customized for the business using Power BI Desktop.

* Built Power BI dashboards based on generated reports.

* Developed calculated columns and measures using DAX in Power BI.

* Created action filters, parameters, and calculated sets for preparing dashboards and worksheets using Power BI.

* Built analysis reports and visualizations using DAX functions like table function, aggregation function, and iteration functions.

* Performed Power BI Data modeling, which cleans, transforms, and mash-up Data from multiple sources.

* Created reports and dashboards using Bar charts, PIE Charts, Donut charts, Gauge, MAP, Waterfall Charts, Filters, and Slicers.

* KPIs, KCIs, and KRIs: Expertise in identifying, defining, and tracking Key Performance Indicators (KPIs), Key Control Indicators (KCIs), and Key Risk Indicators (KRIs) to measure business performance and assess risks.

* Developed and maintained comprehensive Power BI dashboards and reports to monitor and analyze key business metrics, KPIs, KCIs, and KRIs.

* Conducted data analysis and identified trends, patterns, and anomalies to identify areas of improvement and risk mitigation.

* Serve as a liaison between development, business stakeholder governance and end users throughout the application development lifecycle and understand the relationships between the various modules.

* Created Audit pipelines to store pipeline history logs in ADF and configured dataflows in Power BI service.

* Custom Visual Creation using Micro Soft research tool (Charticulator)

* Mastered the ability to design and deploy rich Graphic visualizations with drill-down and Drop-down menu options and Parameters using Power BI.

* Published reports to Power BI services and scheduled subscriptions and various sharing options (workspace, content pack, and Apps).

* Combined data from different sources such as SharePoint Online, SQL Server, MS Access, Excel, CSV, and Text files by using Power Query data blend.

* Created end-to-end Data pipelines to load data from On-premises to Powerbi Services.

* Developed Data Flows and consumed in Powerbi reports.

* Used datamart in Powerbi Services for report generation.

* Worked on building the data pipeline using Azure Services like Data Factory to load the data from the Legacy, SQL server to Azure Data warehouse using Data Factories and Databricks Notebooks.

Power Automate:

* Developed automated workflows using Microsoft Power Automate to streamline business processes and increase productivity.

* Designed and implemented Power Automate flows to automate repetitive tasks, such as data entry, file management, and email notifications.

* Implemented data-driven decisions by integrating Power Automate with Power BI to analyze and visualize workflow data.

* Created various types of flows including automated flows, scheduled flows, button flows, and business process flows to meet specific business requirements for different Teams in IT.

* Implemented instant cloud flows to trigger actions based on events in cloud services like SharePoint, and Outlook.

* Implemented error handling mechanisms to handle exceptions and ensure smooth flow execution.

* Created approval flows to allow automated approval requests and tracking.

* Integrated various applications and services using flows. Created integration flows, such as connecting Microsoft 365 apps to automate data exchange and ensure seamless workflows.

* Designed UI flows in Power Automate, which involve automating user interactions with desktop or web applications.

* Provided training and guidance to team members on using Power Automate effectively to automate tasks and streamline workflows.

* Created documentation, including flow diagrams, user guides, and best practices, to facilitate knowledge sharing and ensure consistency in flow development.

Power Apps:

* Designed and developed custom Power Apps solutions to automate business processes and improve operational efficiency.

* Created canvas apps and model-driven apps using Power Apps Studio for Risk Management Data collection, Project Benefits, and Project Go Live dates.

* Utilized Power Apps formulas and expressions to implement complex logic and functionality within apps.

* Integrated Power Apps with various data sources such as SharePoint lists, SQL databases, Microsoft 365.

* Configured connections and data sources within Power Apps to retrieve, update, and manipulate data in real-time.

* Used Power Apps controls, layouts, and themes to create visually appealing and responsive user interfaces.

* Developed mobile-responsive Power Apps to provide users with access to business applications on smartphones and tablets.

* Optimized Power Apps layouts and functionality for mobile devices to ensure seamless user experience across different screen sizes and resolutions.

* Implemented offline capabilities in Power Apps to enable users to work in environments with limited or no internet connectivity.

* Integrated Power Apps with Power Automate (formerly Microsoft Flow) to trigger workflows and notifications based on predefined conditions and events.

SharePoint Online:

* Extensively worked on SharePoint.

* Created a Landing Page for our team and Integrated the Power BI reports, Apps.

* Implemented document management solutions using SharePoint Online to facilitate collaboration, version control, and document sharing among team members.

* Designed document workflows and approval processes within SharePoint to automate business processes and improve productivity.

* Integrated SharePoint with Microsoft Teams, Outlook, and other Office 365 applications to enable seamless collaboration and communication.

* Integrated SharePoint Online with Microsoft 365, Power Automate, Power Apps, and third-party solutions, to automate business processes and streamline workflows.

* Designed and implemented SharePoint workflows, alerts, and notifications to automate routine tasks, notifications, and reminders.

Azure Devops:

* Configured Kanban boards within Azure DevOps to visualize and manage work items, tasks, and user stories.

* Designed board columns, swim lanes, and customizations to reflect the workflow and process of the development team.

* Created and managed work items, including user stories, tasks, bugs, and features, within Azure DevOps Kanban boards.

* Prioritized and organized work items on the Kanban board based on business priorities, dependencies, and team capacity.

* Defined and customized workflow states, transitions, and rules within Azure DevOps Kanban boards to reflect the stages of work.

* Implemented WIP (Work In Progress) limits and constraints to optimize flow and minimize bottlenecks in the development process.

* Was Part of daily stand-up meetings and team discussions around the Kanban board to review progress, identify blockers, and make decisions.

* Utilized Kanban board views and visualizations within Azure DevOps to gain insights into work progress, cycle times, and team performance.

* Generated reports and metrics from Azure DevOps Kanban boards to track key performance indicators (KPIs) such as lead time, cycle time, and throughput.

* Integrated Kanban boards with Agile methodologies such as Scrum principles to foster agility, adaptability, and continuous delivery.

* Incorporated Agile ceremonies and rituals such as sprint planning, backlog refinement, and sprint reviews into the Kanban board workflow.

Service Now Usage:

* Experienced in service now such as Incident Management, Change Management, Service Catalog, or Asset Management.

* Hands-on experience in ITSM using ServiceNow, ability to streamline IT processes, handle incidents using the ServiceNow platform.

* Experienced in generating reports and leveraging ServiceNow's reporting and analytics capabilities. Ability to create dashboards, design custom reports, and provide data-driven insights to support decision-making processes in the Performance Analytics side.

Celonis (Process Mining):

* Explored the Process Mining for Incident Management activities such as Updates (based on Incremental load), Backlog, and Pending details using the Celonis tool.

* Configured Celonis data connectors to extract incident data from enterprise systems (Service Now) and BI Platforms.

* Utilized Celonis output to perform root cause analysis and identify the underlying causes of process inefficiencies and performance issues.

* Investigated process variants and exceptions to pinpoint areas for improvement and optimization.

* Configured Celonis dashboards and key performance indicators (KPIs) to monitor process performance in real time.

* Tracked process metrics such as cycle time, lead time, throughput, and resource utilization to measure process efficiency and effectiveness.

* Facilitated Incident management initiatives to drive the adoption of Celonis insights and recommendations.

* Collaborated with business stakeholders, IT teams, and data analysts to gather requirements, define use cases, and implement Celonis solutions.

Snowflake Data Lake:

* Explored Integrate Snowflake with Azure Data Lake Storage to leverage scalable storage for Incident management and compute resources for data warehousing and analytics.

* Configured Snowflake external tables to query and access data stored in the data lake directly from Snowflake.

* Implemented data ingestion pipelines to load data from the data lake into Snowflake using Snowpipe, Snowflake's continuous data ingestion service.

* Optimized SQL queries and data processing in Snowflake to leverage pushdown optimization and minimize data movement between Snowflake and the data lake.

* Utilized Snowflake features such as automatic clustering, materialized views, and query hints to optimize query performance and reduce processing costs.

* Worked on Writing Snow SQL scripts to Analyze the monthly metrics that are populated by the IT team in the Snowflake Database.

* Ensured compliance with regulatory requirements such as GDPR, and HDPR by implementing data lake access controls, auditing, and monitoring.

* Built interactive dashboards, reports, and visualizations using Snowflake's integration with Power BI.

Microsoft Intune Data:

* Explored about the Microsoft Intune Data.

* Extracted data from Microsoft Intune using APIs or connectors to access device management, compliance, and security data.

* Prepared and transformed the raw data from Microsoft Intune into a structured format suitable for analysis in Power BI.

* Modeled and integrated Microsoft Intune data with other data sources such as Active Directory, Azure Active Directory, or Office 365 within Power BI.

* Created relationships between Microsoft Intune datasets and other datasets to enable comprehensive analysis and reporting.

* Designed interactive visualizations and KPIs to monitor key metrics and trends related to device management and security for My Mobile and My Mac report.

* Performed Analysis of device inventory data to understand the distribution of device types, operating systems, hardware specifications, and installed applications across the organization.

* Examined compliance data to identify trends, patterns, and areas of non-compliance related to security settings, device configurations, and policy adherence.

* Reviewed security event logs and audit trails to detect and investigate security incidents, unauthorized access attempts, and policy violations.

Environment and Technology: Azure, Azure DevOps, Performance tuning, Data Flow, SharePoint Online, Databricks, DataMart, MS- SQL Server, Python, Powerapps, Power BI, Power Automate, Powerbi Service, Celonis (Process Mining), Microsoft Charticulator, Microsoft Intune, Snowflake.

Responsibilities:

* Worked within the Offshore team for a 3M Client.

* Engaged in all stages of Development related to Business Intelligence reports utilizing SAP BI, Power BI, SAP Analytics Cloud, and Tableau.

* Managed Data Migration and Ensured Data Governance by spot-checking data across tables using Python scripts, Pyspark, and Security management for the environment.

* Possessed substantial experience in uploading, retrieving, manipulating, and handling sensitive data in Teradata, SQL Server Management Studio, and Snowflake Databases.

* Participated in Data Consolidation based on the Data available in databases for monthly Data Analysis for Corporate Planning using BI Tools.

* Demonstrated hands-on Experience in AWS Cloud, Snowflake using Databricks, and Azure Cloud.

* Exhibited strong Knowledge in Analysis, Design, Development, Testing, and Implementation of Business Intelligence Solutions using Datamart and BI tools and client Applications.

* Conducted data migration from legacy systems to new databases like Snowflake, AWS Services such as Redshift, and EC2 for BI reports.

* Accumulated extensive hands-on experience in BI reports migration from SAP BI Legacy environment to Cloud (SAP BI 4.3), Qlikview Dashboards migration and Development as well.

* Strong Skills in Data Analysis, Data Gathering, Data Management, Data Migration, and Governance report Generation.

* Utilized Snow SQL scripts to analyze monthly metrics populated by the IT team in the Snowflake Database, including Snow DB tracing and enabling caching setup at the server level.

* Integrated AWS and Azure resources, establishing secure connectivity and enabling seamless communication between cloud environments.

* Configured AWS services - Amazon S3, EC2 and Azure services -Blob Storage, and Active Directory for optimal performance.

* Implemented data transfer mechanisms between AWS and Azure using AWS DataSync, Azure Data Factory, and custom API integrations.

* Monitored and managed the integration using AWS CloudWatch and Azure Monitor, ensuring high availability and performance.

* Generated critical reports to facilitate tactical responses, provide strategic planning inputs, and address various business requirements.

* Served as a Power BI Gateway Administrator, ensuring corporate access for Power BI reports and Paginated reports.

* Installed and maintained On-premises Power BI gateway to provide secure data transfer between on-premises data and the Power BI service.

* Possessed significant experience with the Power Platform (Power BI, Power Apps, Power Automate) in the healthcare sector.

* Played a major role in coordinating with onsite business partners to ensure timely deliverables as a Technical Team Lead.

SAP Analytics Cloud:

* Intermediate proficiency in SAP Analytics Cloud.

* Developed stories with responsive and canvas layout that includes all types of filters (page, story, input).

* Applied Data Blending concepts, Calculated Measures, Dimension, Data Calculation concepts.

* Created a Geo Map with Drill down functionality using Geo enriching data By Coordinates.

* Have hands-on experience in creating Stories and Analytics application in SAC.

* Part of a team in which we did POC in creating a sales dashboard for Volkswagen and Audi using SAP Analytics Cloud Analytical Application.

* Build a Chat Bot Interface Custom Widget in SAP Analytics Cloud.

SAP BO Environment:

* Creation of Web Intelligence reports for usage metrics.

* On demand support by reaching out to users on call or through instant messengers to solve the issue.

* Knowledge of proactive and swift measures to make sure environment is available to users 24X7.

* User provisioning (providing access), Security management (folder, universe, connection).

* LDAP configuration.

* Handling close to 5000 schedules that delivered to users on a daily basis.

* Incident handling (assisting users for BO end errors).

* Service Request (Report, universe migration between environments).

* Scheduling of Jobs, monitoring and re-scheduling of failed jobs.

* Fixing issues and bugs encountered when trying to run or develop Web Intelligence, Crystal or Lumira Reports.

* Assisting users in IDT/UDT universe and connection retrieval issues.

* BI 4.3 Environment with Snowflake enabled and testing for user assistance.

* Created Auditing reports for the BO environments and validated with Original data with complex structure.

* Developed Geo Map based reports using Lumira Dashboard.

* Leaded the team from the offshore in migration for 3M Thailand from BO 4.1 to BO 4.2 and assisting the end users with all the testing post upgrade.

* Part of the team for migration of business reports for Australia users from BO4.1 to BO4.2 and assisting in post upgrade testing

* Worked with the development team and assist the users for the post migration issues.

* Done the migrations to 4.3 BO (AWS Cloud and Snowflake DW) from 4.2 BO environment.

* Upgraded 4.3 BI SP00 to 4.3 BI SP 0 Patch 4 to fix the Bugs in Dev, QA, Prod Environment.

* Closely collaborate with the internal teams to integrate tool in SAP BO environment for user flexibility and reduce manual effort.

* Setup the tool and the No SQL DB for the tool in BO environment 4.1 and 4.2

* Closely work with Java team to fix the webpages available for user accessibility and feasibility.

Snowflake

* User role set up for the DB access, Data warehouse configuration and moving the DB to Cloud (AWS).

* Transformation of the data (ETL and ELT).

* Cleansing activity as user requested.

* Staging area set up for Long-term data.

* Training: Provided Snowflake training to Onsite team for college hires.

Power BI Development and Power BI Gateway:

* Power BI dashboard creation for Safety and Industrial Business Group (SIBG). Have coordinated with client and developed the dashboard per requirement based on Complaints data.

* Maintained and fixed the timely issues in the Covid details Power BI Dashboard for the Health care team. It has details about reported cases in the USA and Globally. In specific, it shows data about affected workers.

* Enhanced the Qlikview based and SAP BO based Power BI dashboard. Fixed the issue in it.

* Developed the Covid details Dashboard for Health care team.

* Enhanced the Covid return to work Dashboard for Client Industries plants.

* Public Gateway installation and on premises configuration in windows server

* Gateway connection creations for databases (Teradata, Hana, SQL, Oracle, Analysis services, etc)

* Power BI workspace and Dashboard Publish assistance to User end.

* Personal Gateway set up guidance for USAC region users.

* Connection error fixing while Dashboard refresh on Power BI gateway.

* Fixing Schedule refresh failure

Power Automate and Power Apps

* Created Web page, Developed forms and workflows using Power Apps to automate business processes and streamline data entry and approval processes for Environment, Health and Safe Department.

* Integrated Power Apps with various data sources, such as SharePoint, SQL databases, and Microsoft 365 services, to create dynamic and data-driven applications.

* Created canvas apps from scratch, leveraging Power Apps' extensive library of controls, formulas, and connectors to build functional and responsive applications.

* Designed and configured model-driven apps using the Power Apps framework, enabling users to work with data and entities in a structured and organized manner.

* Integrated Power Apps with Power Automate (formerly Microsoft Flow) to automate tasks and trigger actions based on specific conditions or events within the application.

* Developed Canvas app for SIBG process

* Set up the Model driven app using Jquery in TEBG process

* Embedded the Power Apps in sharepoint for security express automation

* Gateway set up assistance for users in Power Apps and Power Automate.

* Set up the schedule flow in power automate for SIBG process

* Created instant flow for HCBG process in Power automate

DOMO - POC

* Replicated the Executive Dashboard based on Power BI into Domo using Cards and specifically using gauges.

* Analyzed the Data loading time in Domo and compared with Power BI.

* Explored the lots of functionalities in Domo.

SQL server Administrator: APAC region SQL server configuration and DB import to the server that has hosted with US Data center. Handled DB creation, existing DB allocation activity.

Qlikview environment:

* Creation of QV Task.

* Modifying the existing Tasks (Changes in security, reducing methods, etc.)

* Migration of the applications (From Development to Test to Production),

* Manual Execution of Jobs (Addressing ad-hoc requests, rerunning failed ones),

* Monitoring and Recycling of Hung QV Services.

* Creating Server Data Source Names for QV applications

* Setting up of QV 11 environment, migration of applications, publishing tasks and licensing.

* Creating External Schedules from Windows Task Scheduler in Qlikview.

* Migration of 1000+ applications and their bookmarks from QV 11 version to QV 12 Version.

* Qlikview automation using Macro: Qlikview apps automated to extract the data, which is being used as Data source in Power BI dashboard.

Environment: Power BI, SSRS, SSAS, DAX Studio, Dataflows, Power Query, MDX, M Query, SQL Server 2017, SQL Server Management Studio (SSMS), Azure, Azure Data factory, SQL, Power BI Services, Power BI Desktop, Power BI Gateway, Tableau 9.x, Tableau Server, SAP BI 4.1, 4.2, 4.3, Qlikview , SAP Analytics Cloud, Power APPS.