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.

TECHNOLOGY:

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

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Technical Business Analyst / Project Manager

Responsibilities:

• Create high level design ( Confidential ) and metadata documentation, and perform UAT and post deployment testing for the Enterprise Risk Teradata migration to HADOOP using TOAD and SAS Enterprise Guide.
• Participate in Agile ceremonies, specifically Confidential planning, backlog grooming, daily standups, team retrospectives and Confidential review/demo sessions for the teams.
• Continuously identify areas of improvements and opportunities to apply agile best practices into daily team activities.
• Analyze 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.
• Create 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 application frameworks, architectures, and data mapping designs
• Researched development in assigned technology, determined business requirements, proposed changes, developed migration and implementation plans
• Provided input into the technology plan for the Wholesale organization, and ensured that plans for their assigned applications integrate effectively with other aspects of the technical infrastructure
• Advised on application and supported technology purchases and on environment upgrades / modifications

Confidential, Charlotte, NC

Sr. Technical Business Analyst / Project Manager

Responsibilities:

• Creating business requirement documentation in consultation with the anti-money laundering business and technology stakeholders for the proprietary Confidential system.
• Executing analysis using Teradata SQL, explaining results and making recommendations on updates to the system.
• Approving and validating 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 Jaspersoft and validating 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, Charlotte, NC

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 ( Confidential ).
• 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.
• 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

Confidential, SC

Store Manager

Responsibilities:

• Assist in the recruiting of, recommend for hire, and train, positive individuals to become members of the Confidential Team, ensuring excellent customer service
• Implement and enforce established daily operating procedures to ensure store is clean, adequately stocked, organized, and well kept.
• Ensure all merchandise is stocked and displays are attractive, priced correctly, and displayed in a safe manner.
• Supervise, and discipline all store employees (and assistant manager) according to company policy.
• Monitor daily retail gasoline competitors and sending the prices to the corporate office in a timely manner as established by management.
• Complete daily paperwork and computer entry in a timely manner as established by management.
• Monitor cash over/short, inventory shrinkage, and drive offs daily.