Data Analyst Solution Architect

Hrushikesha Sahu

Solution Architect

Mobile: +1-203-***-****

Email: ***********.****@*******.***

Innovative Solution Architect with 22+ years of experience designing scalable cloud and data solutions across Banking, Retail, Manufacturing, and Healthcare. Expert in architecting end-to-end solutions using Azure, AWS, GCP and modern cloud technologies, driving digital transformation and operational excellence.

Skilled in cloud-native application development, data platforms, and infrastructure design, with deep expertise in Azure, Snowflake, Databricks and PowerBI. Strong track record in data warehousing, governance, replication, and analytics. Proven ability to collaborate with stakeholders to deliver tailored, high-performance, future-ready architecture.

Trusted leader in technical strategy, risk management, and change control, with experience in GenAI-driven solutions and innovation initiatives including POCs and product briefings.

Certifications

Azure AI-102 – Design and Implementation of AI solutions.

Google Vertex AI certified engineer

Databricks certified GenAI engineer

Microsoft - Architecting Microsoft Azure Solutions (MS 70-535)

Microsoft - Implementing Microsoft Azure Infrastructure Solutions(MS 70-533)

Microsoft - Designing and Implementing Cloud Data Platform Solutions (MS 70-473)

Snowflake cloud developer.

Cloud-era - Developer for Apache Hadoop CDH4 (Big-data/Hadoop echo system)

MongoDB - Cluster Administration (M103)

MongoDB - MongoDB Performance tuning (M201)

Completed PMP Training

Core Competencies/Skills

Core Competencies

Data Architecture & Modeling (Visio, Erwin and PowerBI)

Data Integration & Pipeline Design (ETL, Data Flows, Data Lake)

Full-cycle Program & Project Management

IT Infrastructure Planning & Security Hardening

Application Architecture (MS Visio, MS Projects)

Cloud Platforms & Services

Azure:

Azure Data Factory, Azure Synapse Analytics, Azure Blob Storage, Azure Data Lake, Azure Data Lake Store

Azure Stream Analytics, Azure Machine Learning, Azure Cognitive Services

Azure PaaS & IaaS, Azure Automation (PowerShell, JSON templates)

Azure Production Hardening (self-healing, monitoring, fault tolerance)

Azure ARM, Terraforms

AWS:

EC2, Lambda, VPC, Route53, S3 and AWS DMS.

AWS RDS (MySQL, PostgreSQL, Oracle) and Redshift

AWS Glue, AWS CloudFormation

GCP:

Cloud Data fusion, BigQuery, Cloud Storage

Vertex AI and Gemini AI platforms.

Data & Analytics Tools

PowerBI (Dashboards, Data Modeling)

SSRS, Tableau (Reporting)

SSIS, Informatica, Talend, Pentaho (ETL Development)

Databricks (Setup, Integration, PySpark)

Hadoop and bigdata

Programming & Scripting

Languages: Python, Scala, PySpark, PowerShell

Databases: MySQL, MSSQL, MongoDB, PostgreSQL, Oracle, Snowflake, Cosmos DB, Azure Synapse

Big Data: Apache Spark, Hadoop

Professional Accomplishment

Enterprise Data Warehousing: Expertise in data migration, database architecture, performance tuning, and multi-cloud data integration for scalable analytics.

Data Architecture & Analytics: Extensive experience in data analysis, data modeling, and designing Power BI dashboards to drive business insights.

BI & Data Engineering: Expertise in SQL Server Reporting Services (SSRS), Power BI Report Server, Power BI Service, and Azure Synapse Analytics, ensuring seamless data visualization.

ETL & Data Processing: Implemented robust ETL processes using SSIS, Informatica, Talend, Pentaho, and Python scripting for efficient data extraction, transformation, and loading.

Data Security & Governance: Skilled in database security, risk management, compliance, and identity-based governance for secure data access.

Advanced SQL & Query Optimization: Strong command over T-SQL, Power Query, MDX, ensuring high-performance query execution in large-scale environments.

Cloud Data Platforms: Strong knowledge of Azure SQL Database (Standalone, Elastic Pool, Serverless, Managed Instance, Hyperscale) with experience in cloud storage solutions including Azure Blob Storage and AWS S3 for scalable data management.

Databricks & Big Data: Hands-on experience with Databricks, Delta Lake, and Apache Spark, optimizing large-scale data pipelines and transformations for AI-driven analytics.

Technical Adaptability: Proven ability to learn and integrate new technologies, keeping pace with emerging trends in cloud computing, AI, and data engineering.

Experiences and Achievements

Deloitte Consulting Oct 2022 - Present

Role: Solution Architect

Texas State Govt – HHS (Health and Human Services) Sep 2023 – Present

Role: Solution Architect

Responsibilities

oLed data analytics and reporting initiatives for Immunization and Trauma Center projects, providing actionable insights to improve operations and patient care.

oDesigned and implemented data pipelines in Snowflake for seamless data integration across systems, ensuring efficient data flow and accuracy.

oIntegrate health care data from IQVIA, Axtria, VaxCare, CDC HealthCare system and Provider IMS data to centralized state HHS repository.

oDeveloped a Power BI reporting application, streamlining data visualization and enabling end-users to easily access and interpret key metrics.

oManaged the Snowflake environment, ensuring optimized performance, security, and scalability for large-scale data operations.

oAutomated key business processes using PowerApps and Dataverse, reducing manual intervention, improving process efficiency, and ensuring data consistency.

California State Govt – Water Board Mar 2023 – Aug 2023

Role: Data Conversion lead

Responsibilities

oData Migration: Led data migrations from multiple sources to Snowflake, ensuring seamless and accurate data transfer and integration. Snowflake pipeline developments.

oData Processing: Utilized Python, Pandas, and SQLAlchemy for data processing, performing complex data transformations and optimizing workflows.

oData Integration: Integrated data across various platforms, including ESRI GIS, Salesforce, and DOC EDGE, streamlining data flow and ensuring consistency across systems.

oReal-Time Data Integration: Managed real-time data integration of flow meter data using AWS Kinesis Firehose, enabling continuous and reliable data streaming.

Texas State Govt – HHS (Health and Human Services) Oct 2022 – Mar 2023

Role: ETL and data integration Architect

Responsibilities

oData Integration: Led the integration of data from multiple sources, including PostgreSQL, Oracle, and MongoDB Atlas, into Snowflake data warehouses, ensuring seamless data flow and consistency across platforms.

oData Processing & Transformation: Applied Python, Pandas, and SQLAlchemy to process and transform complex datasets, optimizing performance and enabling scalable data workflows.

oData Ingestion: Managed both batch and real-time data ingestion from Oracle to Snowflake using Python scripts, ensuring efficient and accurate data movement for analytics.

oIntegration Runtime Configuration: Configured and managed Self-Hosted Integration Runtime for on-premises servers, enabling secure and reliable data transfer between on-prem and cloud environments.

oPartner System Integration: Developed and implemented ingestion mechanisms for multiple partner systems, streamlining data exchange and ensuring smooth collaboration across business units.

oApplication Modernization POC: Led the proof of concept (POC) and proposal for application modernization using Dataverse and PowerApps, driving innovation and improving business application workflows.

oReporting Application Development: Designed and developed an interactive Power BI reporting application, delivering actionable insights and empowering stakeholders with real-time data visualizations.

Previous Experiences

Tata Consulting Services Feb 2022 - Oct 2022

MetLife Investments Feb 2022 – Oct 2022

Role: Azure Solution Architect

Working with business team & engineering team for developing, enhancing and maintaining cloud compatible solutions.

Responsibilities

oData Integration & Migration – Ingest data into Azure Data Lake & Synapse, migrate across Azure SQL & ADLS.

oData Processing – Implement ETL workflows via ADF, Function Apps, Mapping Data Flows.

oInfrastructure & Monitoring – Maintain SLA reports, configure self-hosted integration runtime, set up alert mechanisms.

oPipeline & Partner Integrations – Build ingestion pipelines for Dayforce, Braze, Smartsheet, AWS, and others.

oBusiness Intelligence – Develop Power BI solutions for reporting and insights.

oDevOps & CI/CD – Manage Azure DevOps for SDLC, automate deployments via CI/CD pipelines.

Wipro Ltd. (www.wipro.com) Sep 2006 – Feb 2022

Quest Diagnostics Inc Nov 2016 – Feb 2022

Role: Cloud Data Architect

Working with business team & engineering team for solution designing, designing infra layout, building database, application, web servers, Security Implementation, AD Integration for development/migrations/upgrade projects. Working multiple projects on premises, cloud, and hybrid projects.

Responsibilities

oAzure Migration & Infrastructure – Lead IaaS, PaaS, and SQL Managed Services migrations, transitioning on-prem applications to Azure.

oData Engineering & Integration – Manage Azure Data Lake & Synapse, optimize replication, HA, and DR strategies.

oTechnical Solutions & Assessments – Identify migration challenges, conduct feasibility studies, and provide solution estimations.

oArchitecture & Automation – Develop PoCs for Azure services, automate workflows with JSON Templates & PowerShell.

oGovernance & Security – Document Azure processes, ensure cloud security, vulnerability management, and encryption.

oProject & Resource Management – Oversee project planning, timelines, and development team collaboration.

Pitney Bowes – Danbury, CT, USA Mar 2016 to Oct 2016

Role: Database manager

Responsibilities

oProject Planning & Execution – Collaborate with the sales team to define requirements, scope, and budgeting for database projects. Assign responsibilities and oversee stakeholder involvement.

oDatabase Management & Support – Lead operations for 1200+ DB servers across SQL, Oracle, and MongoDB, ensuring optimal performance and availability.

oChange & Quality Management – Oversee change requests, provide installation feedback, and maintain database reporting and trend analysis for performance insights.

oSecurity & Compliance – Conduct security metrics reviews, assess AV and patch compliance, and manage vulnerability & threat detection. Implement access control and database security policies.

oDevelopment & Operations Collaboration – Partner with development teams for project planning while ensuring seamless database integration.

oPerformance Monitoring & Optimization – Track SLA/SLO metrics, analyze reports, and implement corrective actions to maintain reliability and efficiency.

oThis version is concise yet impactful, clearly highlighting key leadership, security, and operational aspects. Let me know if you need further refinements!

o

Carlyle Group – Arlington, USA Mar 2015 to Feb 2016

Role: Project Manager/Consultant

Responsibilities

oData Center Migration Planning – Collaborate with technical architects to strategize and execute datacenter migration initiatives.

oInfrastructure Design & Architecture – Develop server architecture layouts, including ESX, VMware, EMC storage, MSSQL, PeopleSoft, and Oracle FCM.

oProject Execution & Resource Management – Define migration plans, allocate resources, and manage timelines to ensure seamless transitions.

oSecurity & Risk Management – Oversee vulnerability management, implement security protocols, and ensure compliance with best practices.

Cisco Systems - San Francisco USA – Aug 2014 to Mar 2015

Role: Business Analyst

Responsibilities

oSolution Prototyping & Issue Resolution – Designed and demonstrated Proof of Concepts (POCs) to address critical business challenges, optimize workflows, and support new strategic initiatives.

oBusiness Continuity & Risk Management – Validated Business Continuity and Disaster Recovery Plans to ensure operational resilience, minimize downtime, and protect key business assets in crisis scenarios.

oStakeholder Collaboration – Worked closely with cross-functional teams to assess business needs, refine solutions, and drive efficiency through data-driven recommendations.

oProcess Improvement & Innovation – Identified improvement opportunities by analyzing trends, documenting business requirements, and optimizing existing operational processes.

Lloyds TBS Bank – London, UK July 2012 to July 2014

Role: DB Support Consultant

Responsibilities

oDatabase Administration & Incident Resolution: Managed incident, problem, and change management, ensuring smooth database operations and issue resolution.

oUpgrades & Maintenance: Led database version upgrades, ensuring compatibility, security, and performance optimization.

oTechnical Documentation & Process Improvement: Created and maintained technical documentation, enhancing knowledge sharing and operational efficiency.

oSupport & Error Handling: Provided call handling, error identification, and incident resolution, ensuring minimal downtime and fast recovery

Target Corporation – Minneapolis, USA April 2008 – June 2012

Role: DB Consultant

Responsibilities

oDatabase Architecture & Optimization: Designed and enhanced Redrock Pharmacy application databases, ensuring high performance.

oEnterprise Backup & Recovery: Developed uniform backup policies for 25,000+ databases with proactive failure alerting.

oSQL Server Administration: Managed installation, upgrades, and optimization of SQL Server 2005/2008.

oETL & Reporting Solutions: Built SSIS packages and SSRS reports to streamline data processing and visualization.

oAutomated Governance & Resource Management: Implemented policy-based management, reducing incidents by 30%, and optimized storage with data compression, saving multi-terabytes of SAN space

Genpact Pvt Ltd Sep 2006 to April 2008

Role: Team lead

Responsibilities

oDatabase Management: Oversaw SQL database operations, ensuring stability, optimization, and support.

oETL & Data Architecture: Designed and implemented ETL packages and in-house databases for scalable application development.

oHigh Availability & Replication: Configured Windows Clusters, log shipping, and replication for disaster recovery.

oEnterprise Support: Managed 400+ SQL instances, 1000+ databases, supporting 500+ applications across the organization.

oPerformance Optimization: Tuned applications and database queries for enhanced efficiency and scalability

IBM Global Services India Pvt Ltd April 2005 to Sep 2006

Role: IT Consultant

Responsibilities

oSQL Server Optimization & Monitoring: Implemented automated monitoring, proactively identifying and resolving performance bottlenecks.

oDatabase Administration & Support: Provided on-call troubleshooting, ensuring system reliability and swift issue resolution.

oDatabase Migration & Upgrades: Led SQL Server migrations from version 7.0 to 2000 and 2005, ensuring seamless transitions and enhanced performance.

eMind Software Services India Ltd May 2003 to April 2005

Role: Programmer

Responsibilities

oDatabase Development & Optimization: Designed and optimized VB, T-SQL, and PL/SQL scripts, stored procedures, and indexing for high-performance data processing.

oPerformance & Maintenance: Ensured daily backups, monitored SQL queries, and implemented tuning strategies for efficient database operations.

oBusiness Logic & Compliance: Developed stored procedures supporting critical business logic and integrated new compliance services into database design.

Education and Affiliations

B. Commerce – Berhampur University, India, 1996

MCA From Kakatiya University Warangal, Telangana, India, 1999

MTech (IT) From IASE deemed university completed 2005.

Contact this candidate