Gautam Varma Email & Phone Number

Menlo Park, California, US

Souderton, PA, US

• Spearheaded the enterprise's key cloud initiative by architecting a Microsoft Fabric Lakehouse framework and directed the successful migration of critical bank data to Azure.
• Directed a team of 3 junior and senior data analysts, optimizing projects and workloads with a Kanban system.
• Co-chaired the enterprise Data Governance Council, safeguarded data integrity and quality, and formulated comprehensive data policies, standards, and documentation.
• Managed comprehensive data architecture revamps across the organization, shifting from legacy reporting to self- service dashboards and merging data from multiple vendors into a single cloud platform.
• Designed essential measurement metrics and KPIs to monitor the performance of strategic enterprise initiatives, providing insights to senior executives in marketing and product development.

Philadelphia, PA, US

• Pioneered the design and architectural development of key reporting solutions within the Audit department, aligning with and advancing organizational strategic goals.
• Manager of and key liaison for a critical cybersecurity monitoring platform, widely adopted by leaders across the enterprise.
• Initiated and led a transformative project to integrate automated enhancements into the cloud and network platform audit processes, boosting efficiency and accuracy.
• Championed the establishment of governance standards and led the implementation of comprehensive change management processes and documentation standardization across diverse reporting environments.

Dublin 2, IE

• Client: Leading Hospital & Healthcare Provider (Remote)
• Served as Project Manager and Lead BI Developer at one of the largest healthcare consortiums in the US, spearheading key data initiatives and driving innovation in business intelligence to enhance healthcare.
• Developed enterprise-ready dashboards across key business areas, managing end-to-end processes from requirements gathering and data architecture to user acceptance testing, enhancing decision-making.
• Functioned as the lead Tableau developer and data visualization subject matter expert (SME) across multiple workstreams, enhancing analytical capabilities and insights.Client: Largest health insurer in Kansas (Topeka.
• Reengineered enterprise Tableau dashboards, significantly enhancing the efficiency of incoming data queries on IBM DB2 data marts, resulting in faster data retrieval and improved performance.

Chicago, IL, US

• Oversaw the complete design and release cycle of production dashboards for clients, ensuring seamless delivery.
• Crafted advanced visualizations in TIBCO Spotfire, employing JavaScript, HTML, and CSS to elevate UI/UX design and implement custom features, significantly enhancing user engagement and functionality.
• Developed complex stored procedures in SQL Server to establish a robust back-end data infrastructure and pipeline for reporting systems, optimizing data processing and accessibility.
• Implemented CI/CD methodologies in code development and deployment, actively contributing to the migration of the development environment from TFS to Azure DevOps, which streamlined project workflows and collaboration.

San Diego, California, US

• Client: Nike WHQ (Beaverton, OR)

Beaverton, OR, US

• Forecasted global marketplace inventory balances and enhanced visibility into performance across all product tiers using advanced forecasting models developed in Alteryx, leveraging data extracted from Teradata.
• Expanded global forecasting models enterprise-wide by converting Alteryx models into optimized SQL, T-SQL, and ETL.
• Served as the lead developer and acting product owner for scalable enterprise Tableau dashboards, specifically designed for in-depth scenario planning and broad-scale analysis.
• Specified requirements for complex statistical models, facilitating their construction in R and Python to support sophisticated data analysis and decision-making processes.
• Directed the migration of data to cloud platforms, including Snowflake and Amazon S3, overseeing the strategic shift to more scalable, secure, and efficient data storage solutions.

Arlington, VA, US

• Redesigned KPIs for procurement and operations teams, increasing engagement and performance by over 50%+.
• Provided data and strategic recommendations to senior leadership, directly influencing multiple successful initiatives, including a 30% reduction in purchased inventory and a 15% decrease in late deliveries for a major.
• Deployed streamlined SQL Server databases and enhanced metrics by developing dashboards in Tableau and automating business processes with Macro Express, VBA, and Python, collectively saving 5,000+ labor hours annually.
• Enhanced analytical capabilities by implementing a local SQL Server instance, developing custom views, stored procedures, SSIS packages, and rewriting major queries and T-SQL scripts to optimize data handling and.
• Developed numerous interactive Tableau dashboards with advanced features such as multiple parameters/panels, global/context filters, and calculated fields, leveraging cleaned, standardized, and normalized source data.
• Prototyped various ETL processes using custom Python programs, pioneering innovative data transformation and loading techniques to improve data integration and workflow efficiency.

Franklin, TN, US

• Developed a model to estimate patient fees based on customizable parameters, which saved the admitting department 500+ hours of labor; initial analysis was done via SAP BusinessObjects, data warehousing and pipeline.
• Designed encrypted intranet portals using HTML for managers to access confidential budgeting and financial reports
• Identified areas of inefficiency and suggested changes in the check-in process to increase throughput