SNOWFLAKE ARCHITECT Resume SAN DIEGO, CA - Hire IT People

SUMMARY

Snowflake, Microsoft SQL Server, Python - Pandas, Numpy, Jupyter Notebook, Matplotlib, AWS- EC2, S3, Lambda, AIM, Power BI, Power BI Report Builder, Google Analytics, Google Big Query, Adobe Analytics, XML, JSON, HTML5, Jira, Confluence, Salesforce, Office 365, Sharepoint, Visual Studio

PROFESSIONAL EXPERIENCE

SNOWFLAKE ARCHITECT

Confidential - SAN DIEGO, CA

Responsibilities:

ELT - Snowflake- streams and tasks, Snowpipe, S3, SnowSQL, Python, FiveTran, dbt
SCRUM - Microsoft Planner, GIT Hub
Software Development - Python, dbt, SQLAlchemy, Numpy, Pandas, GIT
Data Analysis - Snowflake, SQL, Jupyter Notebook, Tableau
Data Engineering - Snowflake, Python, FiveTran, dbt
Design, architect, develop, and implement data warehouse from disparate sources.
Build, test, deploy, and maintain data pipelines.
Establish RBAC, Row and Column level security policies, data shares using reader accounts.
Develop best practices, coding standards, governance documentation disseminated via department SharePoint site.
Train super users on running analytics in Snowflake.
Work closely with data owners, stakeholders, and analysts to complete projects.
Promote business continuity through the automation of routine tasks.

data WAREHOUSE engineer

Confidential

Responsibilities:

ELT - Snowpipe, S3, SnowSQL, Python, MySQL, Presto, Redshift, Informatica Cloud/Power Center, FiveTran, dbt, Snowflake
SCRUM - Jira, Confluence, GIT Hub
Software Development - Python, dbt, SQLAlchemy, Numpy, Pandas, GIT
Data Analysis - SQL, Jupyter Notebook, Looker
Data Engineering - Snowflake, Python, Informatica, dbt
Build, test, deploy, and maintain data pipelines.
Consolidate Snowflake data warehouses via database replication.
Create data governance controls via the use of Snowflake role based policies and data shares.
Work closely with data owners, stakeholders, and analysts to establish terminology based on shared cultural context.
Promote business continuity through the automation of routine tasks.

DataEengineer

Confidential - Woodland hills, CA

ETL - Snowpipe, Python, Informatica, SSIS
SCRUM - Jira, Confluence, BitBucket, GIT Hub
Software Development - Visual Studio, Python, Snowflake SQLAlchemy, SQLAlchemy, Numpy, Pandas, Selenium, S3, Azure Blob
Data Analysis - SQL, SSRS, SharePoint, Jupyter Notebook, Google Analytics, Adobe Analytics, PowerBI, Tableau
Data Engineering - Snowflake, Python, Power BI, SSRS migration using Power BI Report Builder, Google BigQuery, Informatica
Build, test, and deploy data visualizations for use in department dashboards, interdepartmental presentations, and automated reporting.
Work closely with data owners and stakeholders to identify technology and analytic needs, critical metrics and KPIs, providing actionable insights to decision-makers.
Promote business continuity through the automation of routine tasks and creation of standardized departmental reporting.

Ba Governance Risk

Confidential, CA

Responsibilities:

ETL - MSSQL Server, SSIS, Python
SCRUM – Jira, Confluence, GIT Hub
Software Development – Visual Studio, Python, SQL Alchemy, Numpy, Pandas
Data Analysis - SQL, SSRS, SharePoint, Jupyter Notebook, QuickBase, PowerBI, Tableau
Data Engineering – MSSQL Server, Python, Power BI
Assist with testing and development of on-prem Enterprise Data Warehouse
Develop complex SQL queries for use in governance reviews; providing analysis to data owners.
Design, build and maintain databases to be used for regulatory reporting and internal analytics.
Build, test, and deploy data visualizations for use in department dashboards, interdepartmental presentations, and automated reporting.
Assist data owners and stakeholders to identify technology and analytic needs to obtain actionable business insights.
Produce statistical samples from datasets for use in business reviews.
Develop, test, and deploy tools that assist in automating regulatory and internal reporting.
Perform gap analyses, providing feedback for updating policies and procedures.

Customer Advocate

Confidential

Responsibilities:

Responsible for providing written responses to regulatory complaints received from state and federal agencies, attorneys, and political officials.
Data Analysis - SQL, SharePoint, PowerBI
Ensure compliance with MERS data integrity policies through monthly data reconciliation audits; working with Data Owners to remediate any data discrepancies or deficits.
Develop SQL queries to be used in regulatory reporting; working with Data Stewards to ensure accuracy and integrity.
Data Analysis - SQL, SSRS, SharePoint, QuickBase, PowerBI
Serve as policy and procedure steward assisting business partners in identifying actionable solutions for issues identified in QC reviews.
Responsibilities include but not limited to: procedure writing, build and deploy SQL based QC audits, and data visualizations.