We provide IT Staff Augmentation Services!

Credit Marketing Data Quality Analyst Resume

Charlotte, NC

SUMMARY

  • A Senior IT Business Data Analyst with over nine years of professional experience in addition to Bachelors Degrees in Computer Science and Mathematics. I have recent project management experience working in a highly secure banking position performing data analysis for CCAR using HADOOP, Teradata SQL and SAS EG.

TECHNICAL SKILLS

  • Project Management
  • Teradata SQL
  • ORACLE SQL
  • BASE SAS
  • SAS Dataflux
  • Aginity Workbench for Netezza
  • Eclipse
  • SSIS
  • SSRS reporting
  • COGNOS
  • TIM.net
  • Cold Fusion
  • PHP
  • C++
  • VB Script
  • JavaScript
  • JDA Channel Clustering
  • Sage Business Works 2009 - 11
  • Sage ACT 2009-11
  • Microsoft Office (97- 13)
  • Viewpoint
  • MapInfo
  • AS400 Systems
  • ICOMS
  • UNICA Campaign Management
  • VISIO
  • HADOOP
  • RALLY
  • TOAD
  • CCAR
  • Ab Initio

PROFESSIONAL EXPERIENCE

Confidential - Charlotte, NC

Credit Marketing Data Quality Analyst

Responsibilities:

  • Ensuring data quality issues are identified, tracked, reported, analyzed and resolved in a timely manner, and determining if escalation is required while retaining ownership throughout.
  • Partnering with key stakeholders to ensure completeness and accuracy of data used within the Market Risk platform in Teradata.
  • Connecting with Business and Technology partners to ensure remediation of data quality items.
  • Supporting the implementation of metadata management standards to allow consistent definition of risk data elements at the enterprise level.
  • Acquiring a deep understanding of the Ab Initio reporting data to facilitate testing, establishing baseline data sets, and assist in development.
  • Documenting the required business and technical metadata attributes, respectively with input from data stewards/subject matter experts (SME) and technology custodians.

Confidential - Charlotte, NC

Sr. Technical Business Analyst / Project Manager

Responsibilities:

  • Created high level design (HLD) and metadata documentation, and perform UAT and post deployment testing for the Enterprise Risk Teradata migration to HADOOP using TOAD and SAS Enterprise Guide.
  • Participated in Agile ceremonies, specifically Confidential planning, backlog grooming, daily standups, team retrospectives and Confidential review/demo sessions for the teams using RALLY and Version One.
  • Helped engineer a storyboard process flow between the stake holders and IT in RALLY and Version one for 15 Enterprise Risk projects. This flow included High Level Design, Grooming, Low Level Design, Development, Function System (Unit) Testing, System Integration Testing, User Acceptance Testing, Production Review, Project Management Artifact Review and Story Completion
  • Continuously identified areas of improvements and opportunities to apply agile best practices into daily team activities in running bi-weekly 15 minute Confidential meetings.
  • Analyzed different quantitative scenarios in the Moody’s EL Calculator for regulatory requirements, Marketing Risk Management (MRM), and risk appetite to assist in the strategic and risk management portfolio.
  • Created scripts in SAS for current quantitative models for the purpose of charting Moody’s vs. Confidential ’s Risk model for the Comprehensive Capital Analysis and Review (CCAR) and back testing purposes.

Confidential - Charlotte, NC

Sr. Business Analyst

Responsibilities:

  • Participated in development of enterprise standards around data management,integration, and systems interoperability
  • Produced documented applicationframeworks, architectures, and data mapping designs
  • Researched development in assigned technology,determined business requirements, proposed changes, developed migration and implementationplans
  • Provided input into thetechnology plan for the Wholesale organization, and ensured that plans for their assigned applicationsintegrate effectively with other aspects of the technical infrastructure
  • Advised onapplication and supported technology purchases and on environmentupgrades / modifications

Confidential - Charlotte, NC

Sr. Technical Business Analyst / Project Manager

Responsibilities:

  • Created business requirement documentation in consultation with the anti-money laundering business and technology stakeholders for the proprietary Operational Risk Rating Customer Assessment (ORRCA) system.
  • Facilitated daily Confidential meetings discussing process flow progress for the various stories in each project release with the off-shore technology team
  • Executed analysis using Teradata SQL, explained results and made recommendations on updates to the system.
  • Approved and validated the SAS updates in SIT and UAT and authorizing these updates to be moved into production by the Anti-Money Laundering technology team.
  • Interpreting final results of the process in Tableau and validated the data for the final reports sent to the federal regulators.

Confidential - Charlotte, NC

Sr. Business Analyst

Responsibilities:

  • Enhanced data management and reporting environment tools to measure performance trends and enable identification of operational/control break points for various investors using SAS, SQL and SSRS.
  • Transformed large raw datasets in Teradata into information and providing strategic insight that will assist leaders in decision-making processing relative to corporate products, services and process improvements that impact business outcomes.
  • Defined measurement standards and collaborate with business partners to achieve consistent agreement and application of definitions, measurements and interpretation through the use of executive reporting in PowerPoint.

Confidential - Charlotte, NC

Sr. Data Quality Business Analyst

Responsibilities:

  • Identified causes of poor data quality, implemented solutions and communicated findings to employees, management, and stakeholders using Netezza in Aginity workbench, COGNOS, and SAS DataFlux.
  • Served as a project resource for both business and IT teams seeking knowledge and resolution of various data issues.
  • Used Data management techniques to improve data quality in the different systems. Devised, coordinated, and conducted mass data-cleansing initiatives for the purpose of purging and eliminating corrupt or redundant information from databases using SAS and SQL.
  • Designed and implemented data quality monitoring reports, alerts, and processes, and assisted in organizing governance and present findings on a monthly basis to directors and executives.
  • Established processes to continuously monitor data quality.
  • Ensured processes are in place to proactively detect, correct, and prevent invalid data values.

Confidential

Marketing Analyst

Responsibilities:

  • Partnered with merchants in designing a product clustering solution for line reviews that establish product inventory using SAS and best fits with the Teradata enterprise cost reduction and planning processes.
  • Worked on marketing campaign execution process, data and tools, including design of experiment construction, measurement and tracking.
  • Worked with a team of contractors, leads and managers to establish best practices and methodologies in the JDA Channel Clustering analysis tool for home improvement product categories.
  • Conducted reviews and meetings with merchants and other managers to gain insight, determine goals, and create strategies for clustering analysis.
  • Managed and designed clustering project scopes which include coordinating meetings with merchandise assortment planners, creating timelines for project completion, and executing everyday statistical analysis with little to no management supervision.

Confidential - Charlotte, NC

Business Analyst

Responsibilities:

  • Participated and led design, development and implementation of large and complex center wide Microsoft Access database and Excel applications using macros and VB script (VBA).
  • Created and executed project work plans and revised them as appropriate to meet changing needs and requirements. Reviewed project deliverables prepared by team leaders
  • Effectively applied enterprise best practice methodology and enforced project standards.
  • Prepared for and provided regular project reviews and status updates.
  • Created and executed project work plans and revisions as appropriate to meet changing needs and requirements.

Confidential - Charlotte, NC

IT Business Analyst

Responsibilities:

  • Created consistency in IT functionality for sales, sustainability, and production.
  • Prepared and analyzed a wide range of reports, presentations, and core business processes used across the organization. Worked closely with the CEO to identify production improvements, investigate IT issues, resolve reporting discrepancies, and leverage technology to automate and streamline existing processes.
  • Assisted in the development of ad-hoc reports and presentations as needed by the CEO and Vice Presidents to establish current and future ROI.

Confidential - Charlotte, NC

Marketing Data Analyst

Responsibilities:

  • Performed custom programming, reporting (SQL scripts, COGNOS, BASE SAS, UNICA and other tools as needed), integration, and data projects.
  • Corrected data using SQL modification statements.
  • Assisted in the validation of data, including enforcement of sales compensation rules and financial/operational rules and guidelines. Reconciled data against multiple sources, as necessary, to ensure accuracy and reliability.
  • Worked with finance, sales, IT/MIS, and other departments to support sales efforts and reporting.
  • Completed over 30 campaigns with 500,000 total records including dynamic content campaigns specialized for various demographics.

Confidential - Charlotte, NC

Store Manager

Responsibilities:

  • Conduct Store meetings as needed with employees. ( A minimum of one monthly)
  • Understand all information in the daily reporting of store operations.
  • Follow and enforce all Company Policies and Established Procedures in the store Operations
  • Implement Monthly promotions, insure all POS advertising/signage is properly posted at the proper time.
  • Communicate and perform all price change request, mark downs / ups as requested by the Operations Manager.
  • Conduct regular safety and Security Meeting and document with employees attending signatures.
  • Report and process all employee and/ or customer incidents or accidents following company procedure

Hire Now