SUMMARY

• Senior SAS Developer/Data Analyst wif extensive experience in Systems and Technical Analysis.
• Strong skills in SQL, SAS, Data Warehouse, Data Quality/Remediation, Data Validation, Reporting and Excel.
• Experience developing SAS procedures, macros, merges, data steps for data cleaning, formatting and reporting.
• Banking experience includes: Credit Risk, Mortgage/Home Loans, Consumer Lending, Risk Analytics, Customer Offers, Marketing Campaigns, Online Banking, Global Investment Banking, AML/Regulatory Compliance, Performance Analytics, Reporting, Capital Markets, Debit Card, Credit Card, Deposits,
• Funds Transfer, Client Information Systems, General Ledger,
• Fixed Assets, Bank Mergers and Conversions.

TECHNICAL SKILLS

Platforms: UNIX/Linux, Windows, IBM Mainframe

Software: SQL, SAS Enterprise Guide, Base SAS, SAS/Macro, SASGrid, WinSCP/TectiaTOAD for Oracle, HTML, XML:

Teradata SQL Assistant, SQL Analyzer, Ultra - Edit, Putty:

Database: Teradata, SQL Server, Oracle, MS Access, Informix, DB2

Desktop: Excel, Word, Visio, Publisher, Lotus Notes, Outlook, Sharepoint, Infopath

Testing Tools: HP Quality Center

Methodologies: Six Sigma - DMAIC

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SAS Developer/Data Analyst

Responsibilities:

• Performed data analysis and report development for teh Global Risk and Consumer Data Management teams, using SAS Enterprise Guide, SAS Grid, Unix/Linux, Teradata, SQL Server and Proc SQL.
• Produced monthly, quarterly and yearly mortgage reports to assist management wif maintaining lending decision models and wif determining customers' financial credit risk.
• Participated in creating teh CIP (Customer Identification Program) and CDD (Customer Due Diligence) reporting, which provides summary views of teh quality of customer business and personal data, and were used to direct data remediation efforts.
• Key contributor in teh migration and automation of Teradata SQL to SAS scripts for teh CIP/CDD
• Worked closely wif teh Project Manager to provide technical analysis, design specifications and best practice recommendations for implementing business requirements in accordance wif data quality business rules.
• Created large datasets typically pulled from multiple sources to review, analyze, discover trends or provide insights according to business needs.
• Conducted QA audits wif team members to review Production code and validate final output files.
• Generated Excel metrics reporting via SAS, sorted by segmentation and displaying high level risk data for consumption by management, auditors and other stakeholders.

Confidential, Charlotte, NC

SAS Developer/Data Analyst

Responsibilities:

• Performed data analysis and development for teh Customer Offers and Targeting team, using SAS Enterprise Guide, SAS Grid, Unix, Teradata, and Proc SQL.
• Participated in marketing campaign list production including Direct Mail, Salesforce and Segmentation files for consumer, commercial and small business customers.
• Used SAS/SQL queries against teh Teradata Data Warehouse and MDP, applying selection criteria and suppression/exclusion logic according to campaign requirements.
• Performed QA audits wif team members to review code and validate final output files.
• Completed ad hoc reporting requests for Consumer and Small Business Direct Mail and Salesforce files.
• Created cell grouping metrics using SAS PROC FREQ to verify counts.

Confidential, Charlotte, NC

SAS Developer/Data Analyst

Responsibilities:

• Performed data analysis and development for Enterprise Marketing, using PC SAS, Unix, Oracle, Teradata, and Proc SQL.
• Participated in list production for customer campaigns across a variety of products and marketing channels.
• Assisted in updating and running programs for recurring standardized campaigns.
• Used SAS/SQL queries for merging and splitting data into files/cells according to campaign list requirements.
• Performed QA audits to ensure that all delivered files were validated by matching teh output results to teh business requirements.
• Created cell grouping metrics using SAS PROC FREQ to verify counts.

Confidential, Richmond, VA

SAS Developer/Data Analyst

Responsibilities:

• Performed data analysis and development for teh Consumer Bank Risk Analytics team.
• Monitored Consumer Credit performance and analyzed risk and profitability for auto, mortgage and home equity personal loans.
• Using SAS/SQL queries, extracted data for metrics reporting from a variety of systems, including Loss Mitigation, Recovery and Business Banking.
• Conducted Consumer Lending analysis to evaluate financial risk and loss and to predict default loan performance.
• Developed analytical processes, statistical models and quantitative approaches, leveraging SAS ad hoc and automated reporting capabilities.
• Played a key role in teh 'SQL Server to SAS' report conversion project.
• Utilized SAS procedures, Proc SQL, Proc Report/ODS, Proc Freq and Proc Tabulate, while consulting wif business users, to create and modify required reports.

Confidential, Charlotte, NC

SAS Developer/Data Analyst

Responsibilities:

• Performed data analysis and development for Targeted Marketing, using PC SAS, Unix SAS, and
• Performed end-to-end marketing campaigns from design, coding, to analyzing post campaign results.
• Developed campaign populations for multiple channels such as Email, OST, Splash pages and Secure Messages.
• Provided campaign population insights and interacted/coordinated wif Marketing analysts.
• Used SAS/SQL queries targeting specific banking products, i.e., online banking, bill pay, and brokerage, merging and splitting data into files/cells according to campaign list requirements.
• Validated campaign cell groupings using SAS PROC FREQ to verify counts.
• Used SAS PROC EXPORT to package final data files into Excel or Access.
• Send and transfer campaign files to mailbox via DTS.

Confidential, Charlotte, NC

Sr Data Analyst

Responsibilities:

• Performed data analysis for Global Consumer and Small Business AML/Regulatory Compliance.
• Demonstrated understanding of business rules to identify high risk customers for review and defect reporting purposes.
• Applied defect identification processes and methodologies to produce reports on non-compliant account openings for Small Business Loans and Consumer/Small Business Card.
• Researched existing Consumer and Small Business Card, and Mortgage defect identification logic to facilitate automation of defect and dashboard reporting.
• Queried and researched teh Teradata Data Warehouse (teh W) and Bacardi (Card) databases using
• Performed business and data analysis for teh CIBR Deals Reporting Database wifin teh CRM Services Financial and Performance Analytics Team.
• Supported RDB, an MS Access database which extracts, transforms and loads (ETL) Deals data from Oracle data sourcing systems and teh Deals Data Mart.
• Performed data mapping, data transformation, validation and documentation.
• Facilitated, researched, tested and deployed systems requests, providing data for Client Metrics' customized reporting used in upper level management decision-making.
• Wrote and executed SQL data extraction queries against production Oracle databases using TOAD.
• Conducted systems research for teh Extended Account Database (XAD) Development Team for Merchant Offers Engine, a Debit Card application which provided teh ability to reward debit card customers for their transactions.
• Performed data conditioning and file validation for component and systems integration testing, using SAS and SQL.
• Gatheird requirements for High-level Design (Functional) and Low-level Design (Technical) documentation.
• Created and documented requirements in document repositories like Sharepoint or Discovery.
• Developed and prepared use cases and test plans for requirements documents, and entered test plans and test cases into Mercury Quality Center.
• Improved Quality Assurance deliverables through peer reviews of requirements documentation, test plans and source code.
• Calculated and documented budget estimates of project tasks, phases and resources.
• Wrote process flowcharts and other project related documentation.

Confidential

Sr Technical Analyst/Developer

Responsibilities:

• Participated on teh DBMS Risk Remediation Access Management Project team.
• Performed systems research and development for teh DB Access Registration and Renewal process which enabled teh recording of user/database access and provided teh ability to review, renew or deny teh continuation of that access.
• Evaluated new extracts and reports for teh DBMS Quality Management (QM) Process.
• Attended project team meetings, and contributed to technical design documentation.
• Researched, implemented and documented teh process of generating all system reports for n-line viewing.
• Developed unit test plans, user acceptance tests, and performed data conditioning for component and systems integration testing.
• Participated on teh Enterprise Funds Transfer Monitoring Solutions team.
• Performed technical research and development for teh Corporate Investment Banking - Anti Money Laundering reports project.
• Performed ETL for new BI data extracts and reports to enhance monitoring capabilities from teh Wire Transfer Data Warehouse.
• Developed unit test plans, user acceptance tests, and performed data conditioning for component and systems integration testing.