Charles Russell

Experience

• 

  IBM

  Jul 1995 - Aug 2002

  Advisory Information Technology Specialist

   Primary point of contact for customer relationship management (CRM) help desk tickets (level 3). Provided CRM software support, business analysis, data analysis, programming, testing, and QA.  Recognized for performing an instrumental role in the transitioning of software project activities for a startup company from a large development group to a stable environment supported by a small team. Worked with managers and users to determine business requirements and resolve software issues. Validated data integrity of customer records by identifying and correcting Oracle database information. Performed application conversion and modified mainframe programs for new Retek data repository. Trained team members in software conversion process and documented procedures.Advisory Information Technology Specialist/IBM - Nationwide Insurance  Led the Commercial Insurance hotline team providing application support to agents across the country. Recognized for maintaining the lowest backlog of problem tickets in the team’s history.  Resolved issues through customer communication, analysis, programming, and quality assurance. Analyzed Y2K impacts and modified code to eliminate issues for Ryder, Goodyear and Barnett Bank. Worked on-site at Bank of America to inventory, assess, and analyze Year 2000 date impacts. Performed as a DB2 database administrator and provided support for internal and external customers. Created, maintained, supported, and administered security for multiple database objects. Show less

• 

  Preferred Medical Marketing Corporation

  Jan 2003 - Jan 2003

  Client Support Manager

   Provided software support services to healthcare clients for accounting and budgeting software. Profiled, analyzed, and validated data with Access for import into SQL server database.

• 

  Food Lion

  Jan 2004 - Jan 2005

  Database Analyst

   Designed, developed, maintained, and updated databases for department using Access, SQL, and VBA. Provided demographic, sales, competitor, and real estate data to management for decision making. Researched and analyzed data and statistics on new store sites, existing stores, and competitor events. Presented reports to senior executives on expansion opportunities and competitor activities.  Used GIS and demographic software to provide reports on company and competitor locations. Show less

• 

  Asset Management Technology Solutions

  Jan 2005 - Jan 2006

  Data Quality Analyst

   Provided quality assurance of commercial lease data abstracted into custom real estate software.  Supervised small team of abstractors and provided them with training in commercial leases.

• 

  Nextra Solutions

  Jan 2005 - Jan 2005

  Database / Business Analyst

   Designed, developed, and updated database and spreadsheet applications in Access and Excel.  Produced summary reports, charts, and graphs for lawyers on pending legal cases. Gathered business requirements for legal database and programmed tables, queries, and reports.  Performed database administration, analysis, and support using Access, Concordance, and Steelpoint. Provided metrics, quality assurance monitoring, and financial analysis on document review process.

• 

  Discovery Communications

  Jan 2006 - Jan 2006

  Data Analyst

   Analyzed and resolved errors and data inconsistencies necessary for move to new affiliate database.  Performed data research, mapping, and reconciliation for the company’s finance and sales databases.

• 

  Time Warner Cable

  Jan 2006 - Aug 2007

  Data Analyst

   Reported, analyzed, and updated tax and billing system data using Access, Excel, Vertex, and CCH. Managed department databases by responding to questions, resolving issues, and performing updates. Performed data analysis, verification, and reconciliation using Access, Oracle, and Peoplesoft Financials. Created multiple Access database tools using VBA to streamline processes used by the department. Worked with business partners to gather, interpret, analyze, reconcile, and update tax data. Developed procedure manuals for updating monthly tax data and reporting monthly tax returns. Show less

• 

  Wachovia Corp

  Sept 2007 - Oct 2008

  Senior Quality Assurance Specialist

   Completed data quality production validations for Wachovia’s data warehouses using SAS and SQL. Effectively communicated production data issues to business partners in a timely manner. Successfully balanced Retail Portfolio source data of $300 billion to GL within 1% variance each month. Provided analysis and reports for GL Reconciliation to Basel group to meet regulatory requirements. Developed and documented detailed GL Reconciliation process and continuously increased efficiency. Performed as Test Lead for the Retail General Ledger Reconciliation Project by creating documents and testing data.  Identified application, report, and data defects and improvements through analysis and testing. Recognized for Teamwork, Coordination, Dedication and Unmatched Customer Service. Show less

• 

  Wells Fargo

  Oct 2008 - now

  Business Systems Consultant

  - Designed innovative and highly complex process to automate the production of data quality metrics.- Created SQL code and technical logic to perform data validation of customer data.- Designed automated daily process that identified millions of data quality issues from incoming sources.- Developed 150+ business/data rules to determine and measure quality of customer profile elements.- Facilitated collaborative efforts between business and technical teams to implement the best solutions.- Developed data quality metrics and analytics for enterprise customer profile elements using SQL.- Developed data visualizations using Tableau to report, trend and monitor data quality.- Delivered reporting solutions to provide leaders the ability quickly understand large volumes of data. - Identified and resolved production data issues. Communicated impacts to business units.- Led quality assurance testing, discovered and recommended resolution to coding defects.- Developed project plans. Coordinated and tracked project tasks, status, and responsibilities for team. - Recognized for efforts to identify and remediate data exception issues for addresses and TINs. - Highly respected by business partners for ability to analyze very complex processes and data.- Partnered with One Wells Fargo to design, develop, and report Enterprise Customer Data Quality.- Provided analysis and metrics of customer data including Email, Mobile, Phone, TIN, and Birth Date. - Mentored and provided training within internal team and to external partners.- Presented and shared expertise with leaders at higher levels of the organization. - Managed requests for customer data and provided information to drive business decision making.- Analyzed customer account product codes and statuses to define an Active Customer Definition.- Developed customer data files and metrics for successful Digital Sales and Marketing Campaigns.- Recipient of Gold Coin awards for proactive business partnerships. Show less