نبذة عني
Lead Technical Business Analyst / Data Engineer with experience in data migration, ETL, data governance, and enterprise analytics across automotive, healthcare, financial services, and retail environments. Experienced wi…
Lead Technical Business Analyst / Data Engineer with experience in data migration, ETL, data governance, and enterprise analytics across automotive, healthcare, financial services, and retail environments. Experienced with SQL, Snowflake, Azure Data Factory, AWS, Collibra, Informatica, Power BI, and enterprise data integration and reporting initiatives.
الخبرة
Data Engineer
• Migrate large data sets in Azure Data Factory and Snowflake environments, using technologies including Data Factory pipelines, Azure cloud tools, and various external vendor data ingestion technologies (API, SFTP, CSV, JSON, etc.)
• Led a QA team on an enterprise dashboard project testing data, views, stored procedures, and user interfaces.
• Develop a tagging and identification system of PII data in Snowflake, including development of role strategies and user access reporting.
• Built large ETL processes that managed telemetry data for a subsidiary and ingested data from multiple payment vendors.
• Implemented data governance procedures for handling sensitive information (PII) using Snowflake profiling tools.
• Extensive craftsmanship with SQL and ANSI SQL.
Lead Technical Business Analyst / Data Engineer
Migrate large data sets in Azure Data Factory and Snowflake environments, using technologies including Data Factory pipelines, Azure cloud tools, and various external vendor data ingestion technologies (API, SFTP, CSV, JSON, etc.)
Led a QA team on an enterprise dashboard project testing data, views, stored procedures, and user interfaces.
Develop a tagging and identification system of PII data in Snowflake, including development of role strategies and user access reporting.
Built large ETL processes that managed telemetry data for a subsidiary and ingested data from multiple payment vendors.
Implemented data governance procedures for handling sensitive information (PII) using Snowflake profiling tools.
Extensive craftsmanship with SQL and ANSI SQL.
Project Manager / Senior Business Analyst
Managed complex data flow integrations and data migrations for four teams.
Ensured architectural compliance for existing data sets and cross-organization data sharing.
Created and enforced enterprise-wide data governance process flows for handling sensitive information.
Responsible for gathering requirements, building project plans and writing user stories in Jira.
Engineered financial models and reporting using SQL, Snowflake, and Power BI.
Performed deep analytics from non-standard data sets across multiple systems, vendors, and teams.
Senior Data Strategy Consultant
Managed multiple teams’ data flow processes and workflows.
Established best practices for enterprise data governance.
Mobilized a strategic initiative to build an Electronic Data Catalog in Informatica.
Coordinated training for tools such as Informatica’s product suite and Rally by CA Agile.
Managed internal technology budget and managed staffing resources.
Drove KPI initiatives with supporting data.
Information Technology Manager
Provided multi-site franchise leadership and hands-on support for technical operations.
Managed staffing, technology, and inventory budgets.
Conducted in-depth data modeling and to identify problems in each practice area.
Implemented cloud-based software to track inventory, parts, and accounting.
Restructured ETL between franchisees and corporate using SQL through API gateway.
Data Solution Architect
Launched both a company-wide data dictionary and a metadata management system using Collibra.
Supported and improved mortgage origination systems as well as servicing systems.
Led development of RESTful web services to integrate data sources.
Facilitated implementation of Amazon Web Services (AWS) for multiple product lines.
Constructed data infrastructure for Super Bowl-scale product Rocket Mortgage.
Actively involved in recruiting, interviewing, and mentoring data engineers and architects.
Director, Financial Data Analytics
Created financial reporting analysis using Hyperion Smartview and SAP Business Objects.
Created and reconciled financial statements and mappings using HFM and SQL.
Directed and developed global reporting systems software implementation.
Built a complex data warehouse that sourced data from thousands of sources.
IT Manager
Supported company networks and infrastructure.
Ensured all systems, servers, email servers and networks ran efficiently.
Built and expanded closed-captioned monitoring system.
Created stable VPN and networking for remote workers.
IT Manager
Ran all servers, including backups, disaster recovery, uptime, etc.
Provided technical support for users and systems.
Achieved organic SEO placement in Google search results for specific keywords.
Assisted General Counsel with SOX compliance for the company's IPO.