Gary Cohen Email and Phone Number

• Support enterprise data defect management program through identification and logging of data defects, partnering with stakeholders to document root cause and remediation plans, and completing impact assessments to assist with prioritization efforts. • Serve as Business Resiliency Coordinator, completing regular deliverables to identify key processes, evaluate recovery solutions and strategies, identify and mitigate gaps, and leading annual walkthroughs with senior leadership.• Engage as primary point of contact for audit requests, handling multiple complex research questions and interacting with varied stakeholders to resolve issues within quick turnaround times.

• Create understandable data lineage documentation through analysis of complex source-to-target mappings for a high priority regulatory reporting effort.• Support Enterprise Finance business partners as a relationship manager by facilitating discussions, providing strategic influence, and aligning target data management capabilities. • Manage and facilitate communication routines with stakeholders to ensure ongoing alignment and participation for priorities, resources, upcoming projects, and team needs. • Identified operational risk of major system rollout through analysis of data lineage workflows from over one hundred financial applications.• Collaborate with subject matter experts, system users, architects, and stakeholders to understand and document existing and proposed business processes, data requirements, and system needs.

• Manage a team of seven direct reports tasked with implementing complex changes to a data warehouse application.• Manage portfolio of projects supporting .initiatives to provide database solutions for international programs, enabling the production of daily profit and loss (P & L) and regulatory reports. • Served as technology project manager in an effort to overhaul database design and build significant infrastructure improvements. This involved leading communication across multiple cross-functional groups and partnering with stakeholders to balance competing priorities and address user concerns.• Instituted software development life cycle (SDLC) process across technology and business teams to streamline flow of tasks and enhance application stability. Moving toward this process involved creating a gap analysis, gaining senior leadership buy-in, leading presentations to team members, and monitoring process adoption.• Collaborate with governance committee to set strategic plans for establishing priorities and managing resources to ensure completion of projects on time and under budget.• Negotiate with project managers, business analysts, and other stakeholders when agreeing to timelines.• Initiate resource planning and forecasting to ensure availability of staff to deliver funded projects.• Interview developer candidates and make hiring recommendations.• Responsible for data integrity and successful daily batch processing for all international systems within a 90+ TB data warehouse.• Lead implementation planning reviews for production releases and coordinate with enterprise release management team to ensure compliance with policies • Deliver presentations to senior management and speak in front of large audiences.• Lead multiple status and project meetings per week involving 50+ team members.

• Interpreted and analyzed business requirements to assist with the design, development and delivery of technology solutions that meet end-user needs while maintaining compliance with Wells Fargo change management processes and procedures. • Developed business logic to implement complex accounting solutions within a Microsoft SQL Server 2014 data warehouse containing consolidated balance and transactional detail for wholesale banking activity, which allows product controllers to reconcile daily profit and loss (P & L) to the general ledger.• Implement solutions throughout the software development life-cycle (SDLC).• Demonstrated success leading and mentoring database analysts, facilitating project completion and maximizing productivity. • Developed new documentation, departmental technical procedures and user guides.• Ensured compliance with quality, security requirements, and regulatory reporting.• Provided application design guidance and consultation to less experienced staff.• Provided Level 3 technical support to resolve production issues after hours.• Proficient in Transact-SQL, writing complex stored procedures, performance tuning, slowly changing dimensions, Kimball methodology.

• Built database enhancements and provided production support for a web application serving the tax management needs of mortgage companies and banks.• Followed Agile processes in leading development teams through the integration of new user stories as project manager and scrum master.• Collaborated with enterprise control center to develop failure recovery and risk mitigation procedures.• Implemented performance improvement strategies through defect avoidance plans and code reviews.• Leveraged metadata to assist with troubleshooting and built enhancements to assist with metadata logging.• Programmed in T-SQL to create complex stored procedures and functions.• Created ETL processes in SSIS to load data warehouse from source systems.

• Championed a data warehousing project at United Health Group from project charter to implementation. This involved: - Stakeholder interviews to understand current system flaws and desired results. - Thorough review of all reports delivered to users via legacy architecture. - Creation of source-to-target mappings documenting lineage of all data elements.- Architecture of new data model including conformed dimension and fact tables.- Building physical database objects and ETL processes to populate.- Documentation of proposed system and presentations to senior leadership.• Developed a system to interpret data quality of property records for 60 million homes in an industry-standard residential property database. This involved:- Defining and implementing business rules and standards for processing data.- Building a data model to store inputs from multiple sources and formats.- Coding business logic, including sophisticated algorithms to assign scores to data elements based on their metadata attributes.- Creating process flow diagrams and detailed documentation to present technical architecture to a non-technical audience.• Completed additional short-term consulting assignments across a variety of industries.

• Maintain and support a loan tracking application serving hundreds of users which identified borrowers deficient in property hazard insurance, enabling banks to identify and market services to clients.• Designed and developed enhancements to this system through implementation of business logic, code review, unit and system testing.• Analyzed and fixed defects, coordinating with business users to implement solutions.• Applied performance tuning techniques to optimize queries and ETL processes.

• Managed a team of database analysts to support the information needs of several groups, balancing priorities and streamlining production. • Responsible for ensuring the accuracy of information in multiple SQL Server databases by developing and implementing QC/QA procedures, data flow diagrams, coding business logic, optimizing queries, and creating reports on building cost trends.• Implemented formal quality control and testing procedures by using version control software, and training junior developers to test for errors and document their findings.

• Designed and developed database applications to track the volume and market share of prescription drug sales, based on data collected from ninety percent of all pharmacies in the United States.• Built an automated quality control application to identify data anomalies in Excel spreadsheets, eliminating the need for four hours of manual review per business day. This enabled daily delivery of reports on prescription sales data to be delivered within 36 hours after the close of business.