Serving as a consultant between multiple BI groups and IT for developing new ETL pipelines.Creating and maintaining ETL pipelines using Python, Hive, Presto, PySpark, AWS EMR, and AWS Glue, and publishing complete data lineage to a Collibra repository.Ensuring new data sources comply with risk, data retention, and privacy protection regulations.Working with business leaders to create concise and uniform definitions for reports, business measures, and KPI's.Mentoring business analysts via weekly sessions to develop their programming and data engineering skillset.

Served as a process SME and coordinated with business management to develop a Tableau reporting suite.Maintained the dashboard portfolio for a division of 10 distinct departments and 1,000+ employees.Employed visualization best practices to develop new reports showing employee and operational performance.Migrated a large number of Access and VBA-based data processes to an on-prem Cloudera Hadoop cluster using the Hive and Impala SQL engines.

Built a unified data infrastructure for Vanguard's newly launched retail financial advice platform which incorporated data from IBM Cognos, IBM DB2, and Oracle data sources.Partnered with business management to define their key business measures. and set operational targets.Provided ongoing data support to team members and conducted multiple analysis projects to track operational performance.Worked with IT to define process requirements and reporting capabilities, and operationalize the original MVP reporting suite.

Maintained an in-house developed reporting system tracking performance data for 1,000+ employees.Created reports to visualize performance trends, identify correlations and relationships between data pointsPerformed ad-hoc analysis when needed using Minitab, Excel, and Access.

Providing investment advice and information via phone, mail, and web channels and executing transactions on client accounts on a daily basis. Includes problem resolution, researching, and correcting various details on investor accounts to remain in compliance with Federal and State regulations.

Providing thorough risk-based credit recommendations to multiple client institutions and managing the day-to-day personnel and staffing. Reported to management on efficiency, productivity, and accuracy statistics with recommendations for future changes to company policies and procedures.