Vamshi Alampally

About Vamshi Alampally

IT professional with 15 years of diversified background in Operations, Business…

Experience

1. Data Architect

   Reach Partners

   Mar 2023 — Present · Austin, TX, US

   Spearheaded the development of a robust Datawarehouse solution architecture, leveraging Google BigQuery for optimized database performance and advanced data modeling to support organizational analytics needs.• Led end-to-end integration processes using Domo Magic ETL and implemented dynamic reporting solutions with Domo, enabling real-time insights and data-driven decision-making.• Advised C-level executives and business leaders on cloud data strategy, aligning technology solutions with business goals to drive revenue growth and operational efficiency.• Partnered with finance teams to build ROI models for data investments, supporting funding approvals and strategic planning.• Mentored and coached junior architects and data engineers, fostering a culture of continuous learning and innovation.• Led the architecture and development of a data warehouse across three banners, utilizing Microsoft Azure Synapse, Star Schema Modeling, Azure Data Factory, Azure Data Lake, Azure Analysis Services, PowerBI, SSIS, SSRS, and SSAS for seamless integration and reporting.• Led digital transformation initiatives by implementing Azure-based data solutions, ensuring stakeholder alignment and organizational adoption.• Established and managed the entire Azure cloud practice, overseeing SQL Server databases, virtual machines, app servers, Microsoft Dynamics ERP, Logic Apps, and Azure DevOps, while ensuring performance tuning, disaster recovery, and high availability for all systems.• Delivered executive presentations and business cases demonstrating the impact of Azure data solutions on business KPIs and digital transformation.• Led the migration of on-premises data Oracle Databases to Amazon Web Services (AWS), designed and implemented application database architecture in PostgreSQL, and utilized AWS Database Migration Service to ensure seamless Oracle to PostgreSQL and Oracle to DynamoDB migrations.

Education

• California State University, Fresno

  Master's degree with Honors

  2007 — 2008

• Sant Samarth Engineering College

  Bachelor of Engineering (B.E.)

  2002 — 2006

Skills

• Team Leadership
• Red Hat Linux
• Sql Server Reporting Services (Ssrs)
• Oracle Fusion Midlleware Admin
• Windows System Administration
• Cognos
• .net Framework
• Data Warehousing
• Mysql
• Sql Server Dba
• Vmware
• T-Sql Stored Procedures
• Internet Information Services (Iis)
• Microsoft Sql Server
• Powershell
• Ibm Cognos
• Pure Storage
• Attunity Oracle to Sql Server Cdc
• Bmc Control-M
• Business Intelligence
• Oracle Database Administration
• Mysql Dba
• Databases
• Retail Pro Pos Administration
• Sql Server Integration Services (Ssis)
• Database-Driven Web Applications
• Pl/Sql
• Integration