Solutions Architect

PRABHATI SAHU ********@*****.*** 979-***-****

SUMMARY

Results-driven IT professional with over 16 years of experience, including 3 years as a Solutions Architect at Snowflake. Extensive expertise in designing and implementing Snowflake architectures, data governance, ETL processes, and enterprise data solutions. Skilled in leveraging Snowflake’s cutting-edge data platform to design and implement scalable solutions that drive business transformation. Expert in working with stakeholders across engineering, product management, and business teams to deliver high- performance, cost-effective data architectures and solutions. Certified in Snowflake Core and Snaplogic Developer, with deep knowledge of Agile methodologies and modern data integration tools. TECHNICAL SKILLS

• ETL Tools: Amazon Glue, Informatica Power Center, IICS, Ab Initio, DataStage, Snaplogic

• Databases: Snowflake, Oracle, DB2, Teradata, SQL Server

• Reporting Tools: Tableau, Cognos, Business Objects, D3

• Languages: SQL, PL/SQL, Python, JavaScript, UNIX Shell Script

• Cloud & Scheduling: Amazon S3, AWS Glue, Azure, Google Cloud, Control-M, Autosys, Jenkins

• Version Control: GitHub, VSS, SCM

PROFESSIONAL EXPERIENCE

Solutions Architect Snowflake — May 2022 – Present

• Architect and implement Snowflake environments for diverse clients, including Disney Experience, BMW, Clayco, Arisglobal, and MGB.

• Lead the design and implementation of large-scale cloud data architectures using Snowflake, AWS, Azure, and Google Cloud, ensuring scalability, performance, and cost-efficiency.

• Provide technical guidance and best practices for customers on data modeling, ETL processes, and integrating Snowflake with various BI tools and applications.

• Design and optimize data models, fact and dimension tables, and data pipelines to support complex analytical queries and reporting needs.

• Collaborate closely with customers to understand their business needs, translating them into actionable solutions that leverage Snowflake’s cloud-native architecture.

• Guide customers through Snowflake best practices, performance tuning, and cost optimization strategies.

• Work cross-functionally with product, engineering, and support teams to continuously improve the customer experience and enhance platform capabilities.

• Assist in pre-sales activities, including creating and presenting demos, technical presentations, and proof-of-concepts to prospective clients.

Sr. Integration Developer McKinsey & Company — May 2020 – May 2022

• Built a data lake in Snowflake to identify whitespace clients by integrating data from Salesforce, Outlook, and multiple databases.

• Designed and implemented ETL workflows using Amazon Glue and Python scripts, loading data from various sources to Snowflake.

• Develop and configure Amazon Glue jobs, Python scripts, and stored procedures to automate data ingestion, transformation, and loading processes.

• Created stored procedures and complex SQL queries to transform and synthesize data for advanced analytics and reporting.

• Managed a team of 4 developers, overseeing project execution and ensuring adherence to Agile processes.

Informatica Consultant Burton — Nov 2019 – May 2020

• Implemented and configured Informatica Data Governance tools, including AXON, EDC, and Secure@Source.

• Led GDPR and CCPA compliance efforts, establishing standardized data definitions and governance policies.

• Conducted system installations, configurations, and environment migrations across DEV, QA, and PROD environments.

Previous employers

• IBM, Littleton MA Feb 2018- Jun 2019

• HealthEdge Software Inc. Burlington MA Nov 2013- Nov 2016

• Wolverine Worldwide Waltham MA Jun 2011 – Oct 2013

• DELL Bangalore INDIA Jun 2005 - Mar 2008

• AZTEC (Dendrite) Bangalore INDIA Apr 2004 - Jun 2005

• PCS (Patni Computer Systems) Chennai INDIA Aug 2002 - Mar 2004 EDUCATION

Master of Computer Applications (MCA) Utkal University, Bhubaneswar, India — 1999-2002 CERTIFICATIONS

• Snowflake Core Certification

• Snaplogic Developer Certification

Contact this candidate