Ellen M. Walczak

**** *. ****** **** ****

Glendale, AZ 85310

bq8ack@r.postjobfree.com – 623-***-****

Senior SAS Programmer Analyst

Data Analysis – Compliance - Detail & Solution Oriented – SAS – SQL

Six Sigma / Analytical – Team Member – External / Internal Clients

Software Testing – Project Management – Multi Tasking- Strong Problem-Solver

Profile

Over 20 years SAS programming experience, strong Technical and Project Management skills.

Certified Six Sigma Black Belt, driven to exceed the expectations of both internal and external customers.

Quantitative abilities including knowledge of statistics and financial analysis.

Ability to think strategically and analytically.

Analyst with over 20 years experience in analytics, working with large datasets, analysis and process controls and validations. Excel in roles that require a mix of creativity, analytical thinking and project management skills. Greatest strengths lie in my ability to thoroughly understand a process and make data-based decisions. Strong problem solver and enjoy the detective work required to get to the root of the issues and find the best solutions.

Technical Experience

Operating Systems: VMS, MVS, Windows

Software: OS/MVS, TSO/ISPF, Easytrieve, Microsoft Word, Excel, Project, PowerPoint, Visio, Minitab, Irfanview, Lotus Notes Domino Designer, Sybase SQL Advantage, Tumbleweed Secure Transport

Languages: SAS 5 – 9 (Base, Macros), SQL, Syncsort, JCL

Professional Experience

Bank of America/Merrill Lynch-Equity Methods, Scottsdale, Arizona

Financial Data Analyst -Ajilon (2009 – Current)

Reporting to the Assistant Vice President of Data Management, key role in serving both internal and external customers data requirements.

Prepared and analyzed data to ensure it is structured for accurate financial reporting

Investigated data issues, debugging and troubleshooting within SAS program code while maintaining data integrity and structured programming logic.

Worked directly with Equity Methods Customer Relationship Managers and Customers to communicate data needs and issues.

Built and managed data processes and Quality Control Procedures and SAS Macros.

Mentored new team members.

American Express Company, Phoenix, Arizona

Senior Manager, AXPrivacy (2002-2009)

Built SAS programs and SAS macros to automate and complete hundreds of project requirements to launch the Enterprise Privacy Event Notification Capability, which enabled the Privacy Office to quickly and effectively respond to incidents of data compromise.

Created annual process to certify Privacy policies to ensure regulatory compliance, and build a quality culture within the department. Built Process Risk Assessments using Excel for each of the Privacy policies. Built Lotus Notes Database to capture certification approvals, joint sign-off at the Vice President level. The database also had the ability to store documents, technical translations and process maps.

Produced Privacy Performance Metrics Reports using SAS, SQL and Excel. These reports increased the awareness of the impact customer privacy choices had on Direct Marketing and spending.

Designed, developed and managed databases which included reporting functionality and project management tools for the implementation of an enterprise wide policy to reduce the risk of exposure of customers personal information by eliminate the sharing of Social Security Numbers, National Ids and American Express Account numbers.

Manager, Re-engineering and Six Sigma Team, Risk Information and Banking (RIB) (2000-2002)

Using Six Sigma methodology established significant reductions in cycle time and on time delivery. Six Sigma projects produced over $10M in re-engineering saves.

Developed monthly Scorecard and established metrics using SAS, SQL and Excel. This facilitated the cultural readiness levels within the department and the ability to manage by metrics.

Conducted training on Six Sigma, Metrics, Business policy, and programming. Mentored six Green Belts in Six Sigma methodology.

Technical Lead Programmer, MIS Team, International Customer Information Management (1999-2000)

Supervised a team of programmers for EMEA, JAPA, and Canada International regions for the MIS department.

Developed and taught SAS training to the Campaign Execution teams and received Rings of Reward for this training.

Delivered MIS reports and content Expert for ESG Business related issues.

Achieved 99% on time delivery and 35% reduction of rework by re-writing historical SAS code making the code more efficient.

Senior SAS Programmer/Analyst, Comsys – Consultant with American Express International CIM (1997-1999)

Provided analytical support and MIS for Marketing Teams in 3 International regions.

Accessed complex data structures in various formats to provide detailed and/or summary reports using SAS and SQL.

Owner Analytical Computer Solutions, South Bend, Indiana (1989-1997)

SAS programmer and consultant for various Fortune 500 clients.

Prior to 1989

Computer Task Group SAS Programmer/Analyst

Information Resources, Inc. Senior Research Analyst

The Test Marketing Group Research Analyst

Education

Purdue University Calumet Campus, Hammond Indiana

Concentration in Computer Science

University of Phoenix, Phoenix Arizona

Classes in Business Management

Certified Six Sigma Black Belt from American Express

Contact this candidate