SUMMARY:

• Over seventeen years of diversified experience in the field of Information Technology with emphasis on Data Warehousing and Business Intelligence tools using Teradata, Oracle, SQL Server and MySQL.
• Thirteen years of SAS experience developing complex Macros, DATA Steps and PROC SQL (6.3 - 9.3 (SAS Intelligence Platform)).
• SME utilizing ETL methodology for supporting of Extract, Transform, and Load environment using Oracle SQL Loader, Teradata FastLoad, SQL Server Stored Procedures and MySQL to feed SAS *.sas7bdat datasets for analysis.
• Highly experienced in developing, designing, reviewing and documenting data processes like mappings, flow diagrams, joins and data dictionaries for near real-time internet data feeds from Oracle, TeraData and/or SQL Server to SAS.

TECHNICAL SKILLS:

• Oracle (8i-11i) Unix (Solaris, AIX)
• Teradata SAS (6.3-9.3)
• DB2 (AS400) Business Objects (6.1-SAP)
• SQL Server (2015-2012) Redgate

WORK EXPERIENCE:

SAS Admin

Confidential, Fort Collins, Colorado

Responsibilities:

• Extensive use of SAS Management Console for administrative processes such as User Creation, SAS Data
• Integration Studio for job development/scheduling and SAS OLAP Cube Studio with the use of SQL Server source tables.
• Function as SAS Administrator over SAS Metadata server, SAS Compute Tier 1 server, SAS Compute Tier 2 server, SAS Mid-Tier server and SAS Utility server - experience starting and stopping all SAS servers.
• Involved in SAS Intelligence Platform architecture enhancements to increase the performance using various SAS functions to minimize I/O in SAS Intelligence Platform. Use SAS macros to ensure daily reports placed on SAS
• Web Portal (SAS Report Studio) are accurate with current data.
• Experienced reading through SAS logs to work through problems finding root causes and rectifying / interfacing with Confidential directly when necessary.
• Assisted with SAS Client Installation (very specific client prerequisites such as Confidential ).

Consultant

Confidential, St. Louis , MO

Responsibilities:

• Created/updated SQL Server stored procedures to place medical business requirements into daily output for end-user (doctor, nurse) review.
• Involved coordination of various temp tables, data mining and sub-queries to reduce SQL Server contention during heavy analyst utilization.
• Output utilized by medical customer to project potential future patient needs.

Technical Specialist

Confidential, Newark , DE

Responsibilities:

• Contributed history of large-scale technical project converting DB2 code to third party Confidential vendor platform using SAS.
• Executed programming skills in SAS/SQL and understanding of data management principles, such as joining data sets, data aggregation and sub-setting using PROC SQL and DATA STEPS for Confidential customer segmentation.
• Wrote documentation of system procedures, metadata and guidelines for SAS users as well as programs for customer segmentation.
• Specific use of UNIX nohup and SAS Sleep mode for scheduling *.sas analytical programs.

SAS Analyst

Confidential, Las Vegas , NV

Responsibilities:

• Created complex SAS programs utilizing legacy data houses on Mainframe environment.
• Involved detailed SAS macros to ensure accurate PII (Personal Identify Information) is delivered to the mail house for customer communication.
• Developed SAS macros for Data cleaning, Data mining and reporting (MS Excel, *.csv).
• Developed code/procedures to automate and standardize population reporting by implementing DATA STEP, DATA NULL, CALL SYMPUTX, PROC FREQ and PROC TRANSPOSE.

ETL/Report Developer

Confidential, Las Vegas , NV

Responsibilities:

• Managed requirements gathering and script creation of the attributes identified from SQL Server 2005/2008 databases for all Wynn/Encore restaurants.
• Data is staged, integrated, validated and loaded into Teradata Warehouse using SSIS based on insert/update conditionality (SQL Server merge) and then utilized by SAS analysts for casino reporting.
• Communicated with Teradata third party technical partner to create VM Teradata Virtual environment for testing
• ETL from source data housed in SQL Server 2005/2008 databases.
• Created stored procedures for use in SSIS ETL process to Teradata EDW.
• Communication included use of Teradata Unicode Tool Kit to transport SQL Server 2008 Unicode data to
• Teradata tables with Unicode character set.

ETL Developer

Confidential, Las Vegas , NV

Responsibilities:

• Worked closely with management to identify business needs and develop solutions.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Functioned closely with Managers, Project Managers, Technical Product Managers, clients, subject-matter experts, and data modelers to obtain requirements, objectives, and business rules for projects.
• Designed, developed, tested, and supported ETL mappings and scripts for data marts using SSIS and SQL
• Server in a Windows environment.

BI Team/ETL Developer

Confidential, Las Vegas , NV

Responsibilities:

• Provided architectural consulting, business process documentation, design, and implementation of an ETL process to support the development of personal loan business group to support loan application processing and associated rates/fees.
• SQL Server tables produced utilizing linked query to MySQL database based on properly indexed fields.
• Source MySQL database populated with 1 million rows daily to SAS.
• Allowed inserts of new data as well as updates of existing SQL Server tables to be refreshed every 5 minutes for use by SAS Analysts and MicroStrategy.
• Reviewed complex SAS code to ensure source SAS *.sas7bdat data was in accurate format and naming for SAS Merges.

SAS Programmer

Confidential, Las Vegas , NV

Responsibilities:

• Lead business intelligence, data modeling and data warehouse requirements gathering, data architecture, concept/dimensional and physical data warehouse for Confidential and Confidential data.
• Defined the SAS/Oracle strategy and approach to provide reliable, timely, accurate and usable data warehouse for Confidential and Confidential information to support decision making at the bank on UNIX Solaris platform.
• Designed, developed and implemented data-sets on the SAS (UNIX) server implementing Oracle Direct Pass
• Through for monthly data loads to data warehouse with necessary data encryption.
• Involved business expert interviews for efficient SAS data set creation.

Consultant / Programmer

Confidential, Charlotte, NC

Responsibilities:

• Conducted meetings with the business subject matter experts, developed documentation to assist Mortgage business with analysis.
• Utilized Teradata Direct Deposit Account information, customer Mortgage repository and BOA data warehouse with detailed SAS functions (PROC SQL, DATA STEP, DATA NULL, PROC MEANS, PROC FREQ).
• Concurred with Business Partners, Project Managers and fellow programmers to ensure results/final files meet
• Business Requirement Document (BRD) specification.
• Developed and presented additional data load volume, time estimates and benchmarks to meet the DBA's capacity planning review process for additional summarized data necessary to meet Mortgage business reporting implementing SAS process improvements.

Consultant

Confidential, Plano , TX

Responsibilities:

• Participated as lead Data Analyst with vendors and subject matter experts to gather mortgage data mapping requirements, redesign Teradata/SAS platform and implement necessary testing.
• Performed data mapping/migration to create SQL/SAS Teradata data warehouse for business users to extract data/reports.
• Collaborated with DBA's Data Stewards, and Business to engineer Teradata SQL/SAS scripts, execute test plans, and document results for mortgage UAT test cases.
• Ensured quality and consistency of design, development, engineering, full-life cycle testing and deliverables, adhering to SAS data models and compliance guidelines established by DBAs.

Analyst

Confidential, Las Vegas , NV

Responsibilities:

• Developed strategies based on risk tolerance for various sized portfolios performing trend analysis with MS
• Access SQL to assist clients with long run investment choices.
• Functioned as a Contractor working with Confidential 's, investment bankers, and lawyers to ensure compliance was met.

Lead Analyst

Confidential, Las Vegas , NV

Responsibilities:

• Managed small team of SAS Analysts, including virtual analyst in India) to gather requirements from the business experts, document requirements, develop SAS code, execute code and compile results for executive review.
• Oversaw Credit Risk projects by scheduling regular group discussions with business users, system users, technical development personnel and marketing managers.
• Utilized AS400/DB2 SQL/SAS output directly working with GM executives.