Work History
Overview
Education
Timeline
Work Preference
Skills
Additional Information
Certification
Summary
Work Availability
Accomplishments
Software
Languages
Websites
ResearchAssistant
Haripriya Subramanian

Haripriya Subramanian

Solution Architect / Senior Engineer - Data And Analytics
Fremont,CA

Work History

Senior BI Analyst/ Data Engineer

Bristol Myers Squibb,
Redwood City
09.2023 - Current
  • Optimized Data Processing: Implemented efficient ETL pipelines, streamlined database design, enhancing data quality through thorough cleaning, validation, transformation tasks.
  • Power BI Development: Designed, developed, tested, and maintained Power BI reports with rich visualizations, drill-down options, and Row-Level Security (RLS) for data access control
    and compliance.
  • Automation and Productivity: Utilized Microsoft Copilot and Python scripts to automate routine tasks, increasing team productivity and reducing manual errors by 20%.
  • Migration and Customization: Successfully migrated complex compliance reports from Tableau to Power BI, maintaining data integrity and creating customized dashboards with integrated SQL from Teradata and Oracle.
  • Incident Management and Data Warehousing: Streamlined processes by linking Snowflake with Azure Data Lake Storage and utilizing Celonis for Process Mining, optimizing SQL queries, and developing stored procedures for enhanced data processing.

Solution Architect / Senior Engineer-IT Operations

Siemens Healthineers
06.2021 - 09.2023
  • Created a comprehensive dashboard for monitoring key performance indicators, improving
    decision-making and operational efficiency.
  • Developed a robust CI/CD pipeline for automated testing and deployment, reducing release
    cycle times and increasing code quality.
  • Automated the approval process for document management, reducing processing time by
    50% and improving accuracy.
  • Developed a centralized document repository with automated version control and approval
    workflows, enhancing team collaboration.
  • Created an Intune compliance dashboard, providing real-time insights into device status and security compliance, improving IT response times.
  • Spearheaded the migration of legacy systems to modernized architecture, reducing operational expenses while increasing overall functionality.
  • Provided technical leadership and mentoring for junior team members, fostering a supportive learning environment that promoted skill development and career growth.

Business Intelligence - Team Lead

Cognizant Technologies (3M client) – Enterprise So
05.2016 - 06.2021
  • Led the 7 member team for business intelligence utilizing SAP BI, Power Platform, QlikView,Qlik Sense, and SAP Analytics Cloud.
  • Engaged in data analysis, data migration, and governance report generation.
  • Implemented Snowflake for data warehousing and performed ETL processes.
  • Developed and optimized SAP Crystal Reports achieving a 95% satisfaction rate from end-users.
  • Conducted thorough testing ensuring 99% defect-free reports.
  • Established clear performance metrics for the team which helped in tracking progress towards set targets effectively.
  • Coached team members in techniques necessary to complete job tasks.

Overview

8
8
years of professional experience
6
6
years of post-secondary education
1
1

Certifications

40
40

Dashboards Developed

Education

Master of Science - Data Science And Engineering

Birla Institute of Technology
03.2021 - 04.2023

Bachelor of Science - Electronics And Communications Engineering

Sri Krishna College of Technology
08.2012 - 04.2016

Timeline

Senior BI Analyst/ Data Engineer

Bristol Myers Squibb,
09.2023 - Current

Solution Architect / Senior Engineer-IT Operations

Siemens Healthineers
06.2021 - 09.2023

Master of Science - Data Science And Engineering

Birla Institute of Technology
03.2021 - 04.2023

Business Intelligence - Team Lead

Cognizant Technologies (3M client) – Enterprise So
05.2016 - 06.2021

Bachelor of Science - Electronics And Communications Engineering

Sri Krishna College of Technology
08.2012 - 04.2016

Work Preference

Work Type

Contract WorkFull Time

Work Location

RemoteHybrid

Important To Me

Career advancementWork-life balance401k matchPaid sick leaveWork from home optionPaid time offStock Options / Equity / Profit SharingHealthcare benefits

Skills

  • Cloud Technologies: Microsoft and Amazon
  • Databases: MySQL, MS-SQL Server, Teradata, Snowflake, Oracle, DB2
  • Programming Languages: SQL, T-SQL, DAX, M Query, Python
  • Tools: Power Query, Visual Studio (SSIS/SSAS), SQL Developer, SQL Navigator, SQL Server Management Studio,Power App, Domo, MS teams, MS 0365, SAP Analytics Cloud, Qlikview, SAP BO 41,42,43, HP service Manager, Servicenow, Jira, Power Automate (flow), Power BI (21287510 - April 2024)/Tableau services, Power BI Gateway, Copilot
  • Cloud Services: Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure SQL Database, NoSQL DB,
    Azure DevOps, Azure Data bricks
  • Operating Systems: Windows 10/7/XP, UNIX, LINUX
  • Visualization/ Reporting: Tableau, Power BI, SSRS, SAC, Domo
  • Methodologies: Agile/Scrum, Waterfall
  • Applications: Microsoft Office Suite (Word, Excel, Visio, PowerPoint)
  • Document Management: Share point online

Additional Information

* Led the 7 Member Team from Offshore for complete BO, Qlikview, and Power Platform Activities.

* Trained the juniors for BO, Qlikview, and Power platform.

* Created RFP and planned, assisted other accounts to create BOBJ upgrade plan, approached and provided the required solution to upgrade from BI 4.1 to BI 4.3.

* Conducted Technical Interviews for the recruitment.

* End to End handling of Data Migration to Snowflake from Traditional DB.

Certification

ITIL Foundation V4 - Sep 2022

Summary

Highly skilled Business Intelligence Specialist with 8+ years of experience in data analytics, engineering, and visualization.
Demonstrated proficiency in designing, developing, and maintaining robust data solutions across various domains.
Core Competencies:
* Business Intelligence Tools: Expert in SAP BI, Power BI, QlikView, Qlik Sense, SAP Analytics Cloud, Tableau, Crystal Reports, and Domo.
* Power BI: Extensive experience with Power BI Embedded, REST APIs, Data Gateway, Data Flow, Workspaces, Data Pipeline, Streaming Data Sets, Dashboards, Reports and Scheduled Refresh.
* Performance Optimization: Specialized in tuning report performance within Power BI Desktop, On-Premise Power BI Server, and Power BI Service.
* Tableau: Advanced in creating interactive dashboards and reports, utilizing features. Skilled in Tableau Prep for data
cleaning and using Calculated Fields, Parameters, LOD Expressions, and Data Blending.
* Power Apps: Developed custom business applications using Power Apps, leveraging Canvas Apps and Model-driven Apps
for efficient data entry and workflow management.
* Power Automate: Automated business processes using Power Automate, creating flows for approval workflows, data synchronization, and automated notifications.
* Technical Proficiency: Competent in SharePoint Online, Microsoft Fabric, Data Verse, Data Mart, and Copilot.
* Advanced Analytics: Strong in exploratory data analysis, machine learning models, and statistical analysis using R,Python.
* Azure Cloud Services: Expertise in Azure Data Factory, Azure Data Lake Storage, and Data bricks.
* ETL and Data Warehousing: Developed complex ETL solutions with SSIS, and experienced in designing and supporting data warehouses on SQL Server, Azure SQL DB, and Oracle.
* Snowflake Integration: Skilled in integrating Snowflake with various data sources and managing data processing
pipelines.
* Data Modeling: Proficient in dimensional and relational data modeling, including star and snowflake schemas.
* Production Support: Provided 24/7 support for ETL and visualization tools.
* Database Architecture: Knowledgeable in OLAP/OLTP database design, data migration, and data warehousing concepts with ETL emphasis.
* SDLC and Agile: Experienced in all SDLC phases and agile methodologies, including user stories, sprint demos, and retrospectives with JIRA and Azure DevOps.
* Process Mining: Worked with Celonis for incident management.
* Training and Support: Trained developers and customers on project documentation and technologies.
* Soft Skills: Dynamic team leader and Solution Architect with a proven track record in fostering collaboration and driving project success. Adept at navigating complex challenges and implementing innovative solutions in demanding environments.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Accomplishments

* Awarded by Cognizant for an exceptional performance as the Team Lead.

* Appreciated by many clients for completing all the daily activities on time.

* Appreciated by the project manager for handling the whole project and working hard to complete all daily activities.

* Best Microsoft Power Platform Trainer in Siemens Healthineers Academy for Entry-Level Joiners.

Software

Microsoft Office Suite (Word, Excel, Visio, PowerPoint)

Languages

English
Full Professional
Tamil
Full Professional
Telugu
Elementary
Malayalam
Elementary

Similar Profiles

CREATE PROFILE
Haripriya SubramanianSolution Architect / Senior Engineer - Data And Analytics