• Collaborates with internal customers, external consultants, IT staff to define requirements for data warehousing and Business Intelligence initiatives• Creates and documents detailed data mapping documents that outline movement and transformation of data within the internal data warehouse infrastructure• Works with business to prototype reports and BI dashboards, develops or works with consultants to develop reports and dashboards for business units• Performs complex data analysis on data usage throughout organization and create data visualization for all levels including upper management to help evaluate usage to prepare and plan for decommission of legacy systems• Iteratively work with data vendors to implement data in internal data structure that was previously accessed through API and Office add-in, on an ad hoc basis by business users• Determines and documents data reconciliation control requirements to provide evidence of data accuracy and consistency• Work with team to ensure daily processes are functioning correctly to maintain data accuracy in data warehouse and in downstream consumption for business purposes

• Work closely with business unit leadership teams identifying approach to effectively leverage the available data with Qlik Sense analytics to drive everything from daily workflow to executive decision making• Rolled out Qlik Sense for the Claims Department Management team• Convert SSRS reports to Qlik Sense interactive reports• Implement Qlik NPrinting for static, scheduled reporting• Create ad hoc and ongoing reporting projects using MS T-SQL, MS Stored Procedures and ETL processes

• Develop and maintain Tableau Views and Dashboards, Microsoft SSRS reports for internal and external clients• User and Server Administration of TMG’s Tableau Server• Provide initial demonstration and ongoing support to internal and external clients of TMG’s Analytical Tool, ClearTrend• Collaborate with internal and external clients to provide business insight with ad hoc and ongoing analytical solutions using Microsoft SQL, Analysis Services, Tableau and Alteryx

• Develop and maintain new or existing database applications and systems.• Create requirements, scope and estimates for database projects.• Develop and support SSIS packages as well as convert DTS to SSIS packages.• Write and maintain documentation on databases and processes.• Prepare test data sets for development, testing and staging.• Performance tune queries and tables via index optimization.• Create SQL statements, stored procedures and data extraction processes.• Monitor Database backups and implement database security.• Actively participate as a project team member and lead small projects.• Build strong partnerships with internal and external clients.

• Deliver operational metrics that drove compliance success rates. • Support reports processes to ensure correspondence from Loss Mitigation are sent in accordance with government compliance requirements. • Collaborate with business partners / executive management to identify improvement opportunities for productivity, quality, compliance and process excellence via reporting operations. • Interpret and translate business needs into reporting business requirements using Microsoft SSRS reports and supporting SSIS ETL processes.• Provide ongoing metrics to support OCC compliance.• Team with additional business lines for cross-platform reporting initiatives.

• Promoted and broadened scope to work with marketing analytics team to design, map and implement data from multiple vendors and create proprietary beta tool for Wells Fargo’s Learning Environment data mart. Data mart contained county assessment and recording mortgage document detail for market opportunity exploration.• Also collaborated with EIW group to implement database into production Teradata environment as PLACE data mart.• Supported business users across units to identify specific areas to implement PLACE data for marketing, lead generation, market analysis, fraud prevention and geo-coding. • Provided data receipt logistics and source data improvement as liaison to multiple vendors.

•Acted as a liaison with the Information Technology (TIG) team to identify LIS, LPS and AS400 origination system data elements required to receive data extracts on a daily basis•Worked with a team to design a relational database to store origination system data, real estate partner data, retail finance hierarchical data and Joint Venture and retail employee data for Joint Venture data analysis and reporting•Helped to develop the daily load process of origination system extracts•Responsible for ongoing maintenance to database, update processes, and enhancements•Function as point of contact for 20 Joint Venture Partners on implementation and ongoing data analysis around the CRPR reporting system