SUMMARY

• Over 15 years of Professional Experience in SAS Programming, Development, ETL, Data Mining, Report Writing, and Web Development in the Financial, Retail, Airline, Energy, Consulting, and Health Industries.

TECHNICAL SKILLS

Languages: SAS, SQL, Korn Shell Scripting, ASP, JavaScript, VBScript, HTML

SAS: Base, EG, Data Integration Studio, OLAP Cube Studio, IMAP Studio

Software: Microsoft Office (Excel, PowerPoint), Visio, Tortoise SVN

Databases: Oracle, Teradata, DB2, SQL Server, MySQL, Greenplum

Macromedia: Front Page, Dreamweaver

Servers: UNIX HP - UX, AIX, Solaris, Linux; Windows 2008 Server;

PROFESSIONAL EXPERIENCE

Confidential

SAS Administrator

Responsibilities:

• Provided day to day administration support of the SAS grid user base
• Collaborate with necessary groups to understand data and disk requirements
• Granting/Removing user access via SAS Managagement Console
• Troubleshooting SAS Code from users to automate processes via BASE SAS and Macros
• Perform Data Analysis, test models, and documents model performance and tracking
• Test and validated SQL Server data using SAS EG and creating reports to highlight findings
• Automated existing SAS processes to streamline monthly and quarterly processes
• Assisted with the development and implementation of routine analytics and reports

Confidential, IL

Sr SAS BI Data Analyst

Responsibilities:

• Developed processes in SAS EG to support dashboard, data profiling, and tactical reports
• Built structures within Data Mart to extend capabilities to reporting for business users
• Automated existing SAS processes to load data into Qlikview
• Documented SAS programs using Enterprise Analysis to create flowcharts
• Pulled Monthly transaction data from DB2 to validate transaction records and counts
• Develop and support processes in SAS EG while creating controls and monitoring reports
• Modify and migrate legacy code to streamline and automate processes
• Created multiple data checks to ensure data quality, no duplications, and calculations
• Guided junior programmers to program efficiently in SAS/Macros and SQL
• Pulled Daily data from Teradata to validate customer records and do analysis

Confidential, NC

SAS Marketing Analytics Developer

Responsibilities:

• Lead campaign efforts on new mortgage acquisitions for the confidential department
• Develop segmentation and selection analytics in SAS EG and Campaign Management
• Produce backtesting results, audit workbooks, model algorithms, technical documentation
• Identify data discrepancies, update business rules, and research marketing methodologies
• Mentor junior programmers on programming efficiency, process flows, change management
• Develop new programs based on business requirements that report compliance defects
• Translate business needs into technical requirements
• Automate compliance testing and enhance monitoring controls in Marketing via SAS EG
• Develop SQL code to filter, aggregate, and extract data from the Teradata warehouse
• Report writer for Discover s Marketing Risk credit card department

SAS ETL Developer

Responsibilities:

• Implemented enhanced mortgage reporting application to replace legacy system
• Mapped data and reporting fields from legacy system to target
• Conducted unit testing of application and validation of outputs between legacy and target
• Optimized queries to source data efficiently from SQL Server and Teradata
• Documented ETL architecture, business logic, and programming routines of target system
• Migrate SAS - based clinical trial applications from 9.1 UNIX O/S to 9.3 Windows O/S
• Inventory SAS programs, catalogs, macros, excel file inputs/outputs, shell scripts, custom templates, autoexecs, data libraries and map them all to target environment
• Validate migrated applications in Dev Tier and promote to Test, Prod, and DR Tiers
• Rewrite legacy SAS Programs to leverage new software and hardware capabilities and used Tortoise SVN as change management tool
• Developed financial applications on healthcare premiums and claims data for Finance Dept
• Responsible for standardizing applications across platforms into secure Unix environment
• Gather business requirements including sizing requirements and service level agreements
• Created SAS macros and scripts to automate reporting and email functionalities
• Automate quality assurance on programs and output before delivery to financial analysts

SAS ETL Architect

Responsibilities:

• Developed 40 Reporting Applications for the Reporting and Business Intelligence department of Bank of America using SAS ODS, Custom Templates, Excel Tagsets, PROC Reports
• Primary customers were the Divestitures and Data Information & Strategy departments
• Optimized inefficiently written SAS & SQL queries to run in one - tenth of the time
• Created shell scripts & trigger files in order to control job process flows in AIX environment
• Established archival and promotion processes with Tortoise/SVN version control software
• Create and implement ETL process for the Customer Insight and Analytics Group of Delta
• Streamline 50+ SAS programs to read over 100 Teradata tables using Base SAS, Macros, SQL Passthru in a single job producing a master analytics table for analysts/end users
• Develop several report templates and designs using Proc Report and SAS ODS
• Administer ETL applications, shell scripts, cron jobs, disk usage in the UNIX environment
• Document ETL process and best practices regarding SAS programming, Teradata functions

Confidential, DE

SAS Analytics Specialist

Responsibilities:

• Develop advanced analytics for financial reporting for Credit Card division of confidential
• Publish and distribute executive - level reports using Enterprise Miner, EG, &Stored Processes
• Created Excel pivot tables for analysts & power users via SAS Add-In for Microsoft Office
• Propose recommendations on improving business methodologies based on research findings
• Optimize speed and reporting capabilities of existing financial applications
• Audit financial accuracies of SAS/SQL code modules for Rebate Reporting applications
• Standardize metrics, calculations, extracts in order to maintain cross-platform consistency
• Enhance report layouts, UI functionality, and data retrievals to adhere to corporate standards
• Development & testing environment consisted of UNIX SAS 9, DB2 iSeries Navigator, EG 4
• Document code changes, process flows, maintenance procedures, and UNIX shell scripts

Confidential, TX

SAS BI Developer

Responsibilities:

• Rearchitect SAS8 ETL programs to exploit the BI capabilities and enhancements of SAS9
• Recreate Citigroup s business logic & stored procedures as SAS9 BI transformation modules
• Develop Excel - based financial reports using Proc reports/tabulate & SAS/Graph
• Develop Web-based financial Reports via WRS and Information Maps technology
• Administer SAS environment and Enterprise Guide (Ver.4) users via Management Console

Confidential, TX

SAS ETL Developer

Responsibilities:

• Create specialized prospect lists of multiple vendors for the Marketing Operations Group
• Develop ETL process using SAS macros, SQL Passthru, indexes/keys in UNIX environment
• Develop advanced extraction procedures for accessing large, inconsistent data from Oracle
• Define business requirements, document ETL environment, and develop ad - hoc reports
• Develop ETL processes to evaluate effectiveness of marketing campaigns Develop reports in SAS EG3 using ODS and Procs: Report, Tabulate, Graph
• Automate analytical reporting processes via SAS macros and stored processes in UNIX
• Create data quality checks on raw, client data to ensure data integrity
• Develop SQL Passthru queries to create and pull data from Oracle

Confidential . Dallas, TX

SAS Data Mining Analyst

Responsibilities:

• Develop SAS & Teradata - based, data mining processes for confidentials marketing dept Automate JC Penney sales & market research analysis reports via SAS macros in UNIX Apply advanced optimizations to handle large data (sql passthru, indexes, parallel processing)
• Create adhoc reports via SAS9, proc report & tabulate, and using ODS to output to Excel
• Develop applications to collect statistical data on tables and columns in the Teradata database
• Report writer for American Express s international risk management credit card division Develop web-based, financial graphs using SAS/Graph, Proc Reports, ODS from data mart
• Create adhoc and automated reports using Base SAS, Macros, Proc Summary & Tabulate Extensively used PROC SQL and INFILE to extract and load data from Oracle and text files
• Modify korn shell scripts to streamline execution and scheduling of SAS jobs and processes