Data Engineer at Wells Fargo

Designed and developed ETL pipelines using Python, SQL, and Azure Data Factory to integrate customer accounts, payments, and loan data from multiple financial systems. Built and managed a data lake on Azure Data Lake Storage for structured and semi-structured datasets supporting reporting and compliance. Modeled financial datasets into Azure Synapse Analytics to support credit risk, liquidity, and capital adequacy reporting. Automated daily and incremental data loads with ADF pipelines, Databricks notebooks, and Azure Functions, improving processing efficiency by 35%. Implemented data quality rules for reconciliation of transaction records, account balances, and loan portfolios to ensure accuracy for downstream reporting. Collaborated with cross-functional teams to support Basel III, CCAR stress testing, and SOX reporting requirements.

Data Analyst at Bluecoat Systems

Designed and executed SQL queries to extract and analyze large datasets from customer activity and security logs. Developed and maintained dashboards in Tableau/Power BI to monitor product adoption, license usage, and KPIs. Partnered with product and engineering teams to analyze customer behavior patterns, improving product performance and user experience. Conducted trend and variance analysis to track revenue from software licensing, subscriptions, and support services. Created data models consolidating information from multiple sources (CRM, ERP, ticketing systems) into a unified reporting view. Automated data cleaning and transformation with Python (pandas), reducing manual effort by 40%. Built ETL workflows to automate recurring reporting pipelines, ensuring timely delivery of executive-level reports. Delivered quarterly business review (QBR) reports for leadership, highlighting churn risk, customer satisfaction, and revenue trends. Collaborated with finance teams to forecast subsc