Customer Service Data

TONY MAYO

Forest Park, IL ***** 815-***-**** www.linkedin.com/in/tony-mayo-b1b147 aczp0n@r.postjobfree.com

SAS ARCHITECT, DBA, SAS DEVELOPER, RESULT DRIVEN, STRATEGIC LEADER

Highly motivated SAS professional with 22+ years of hands-on experience and specialization in SAS, SAS EBI/BI, SAS Solutions, SAS architecture and installation. Solid working knowledge of architecture, lifecycle and processes. Ability to identify and resolve inefficient procedures. Specialize in evaluating client needs and delivering appropriate technology solutions. Currently seeking a position which will effectively utilize all skills, certifications and areas of expertise below:

OUTSTANDING LEADERSHIP ACHIEVMENTS

Achieved SAS Alliance Partner of the year award 1984 and co-wrote the base SAS Certification Exam

Mission-driven Change Agent, committed to producing “out of the box” solutions, exceeding all client expectations and service guidelines, communicating the vision persuasively and effectively.

Recognized as a highly tenacious Information Technology Leader who engages progressive initiatives in government, the legislative environment, and the business community, resulting in maximum viability and performance.

Conceptualized and established processes, systems, and reporting initiatives to track metrics that deliver scalability and reliability across risk management, security, policy development, enterprise development, strategic planning and implementation.

Lead internal and external staff for IT, engineering, testing/QA and IT development groups in multiple locations.

Partnered with senior executive leadership to plan and implement long range city-wide policy, management and strategic issues, in coordination with overall city operations.

Innovative leader and negotiator, with a successful track record of communicating goals, mitigating risks, resolving QA issues and successfully navigating tactical challenges organization-wide.

PRIMARY SKILLS:

•SAS Versions 5.18 -9.4

•RDBMS: Oracle, Teradata

•SAS Strategic Performance Management

•SAS 9.1 Solution Implementation

•SAS Management Console

•SAS Information Delivery Portal (IDP)

•SAS Enterprise Guide

•SAS Data Integration Studio

•SAS Web Report Studio

•SAS Information Map Studio

•SAS Programming

•Sas Environment Manager

•ActiveBatch Schedule

•Neteeza RDBMS

•Business Intelligence

•Data Warehousing

•Enterprise Architecture

•ETL

•Consulting

•Enterprise Architecture

•Requirement Analysis

•Business Analytics

•Data Management

•Financial Analysis

•Change Management

•SDLC

•Analytics

•Unix\cubes

•Requirements Gathering

•Visio

•Predictive Modeling

•Databases

•System Analysis

•Data Mining

•Quality Assurance

•Software Development

Solution Architecture

•SAS 9.1 Enterprise Business Intelligence Solution. (SAS BI/SAS EBI)

•SAS Component: Base, Macros, SQL, MDDB, AF, EIS, Access, Connect, Share, SPDS, SPDE

TECHNICAL SKILLS:

Data Modeling (ErWin), JCL, Extra, Endeavor, Brio, BI/Query, Toad, PVCS, Rational Rose, Microsoft Office Products

PROFESSIONAL EXPERIENCE

Bluestem Brands: Minneapolis, MI

SR. SAS SOFTWARE CONSULTANT (CONTRACT) JAN. 2017-PRESENT

Supports strategic initiatives across the company by enhancing and evolving the BI advanced analytics capability and ensuring business goals are met

Builds advanced analytic solutions using statistical and machine learning methods for per BI Developers to scale as a service

Designs experiments to learn new insights and correlations to advance operational efficiencies or reveal revenue opportunities

Manages R and SAS applications, servers, users, and EBI platform administration, including implementation, configuration, upgrade, migration, maintenance, coordination, problem resolution, testing, usage and performance monitoring and the design/development of system infrastructure

Conducts one on one sessions with power users (Site Owners), gathers requirements, designs, develops and deploys

multiple workflow solutions across the organization

Coordinates planning phase, implementation, deployment, security and network with IT team specialists

Actively manages improvement efforts to customize search function with unique features such as customized search result

display, scope search and user profile search

TME INC. Forest Park, IL

OWNER JAN. 1994-PRESENT

Team Lead and business to IT liaison.

Installed SAS 9.13 BI/EBI

Part of the team that wrote the initial SAS Certification Exam.

Provide support and planning for utilization and migration of SAS’s emerging technologies (including SAS BI/EBI v9.1.3 & v.9.2).

Designed, developed and deployed SAS data warehouses.

Provided end user technical support with Base SAS, SQL and Enterprise Guide.

Worked in tandem with clients to write requirements and/or translate them into technical specs for developers.

Develop reports in WRS, OLAP Cube Studio, Enterprise Guide, Stored Processes and Base SAS.

Built and maintained data models to be used by SAS from Teradata and Oracle.

Worked one on one with end-users to produce reports and tune code for best performance.

Performed duties as SAS Administrator using SMC (SAS Management Console) to control users, tables administration, server administration and application security

CVS CAREMARK: Northbrook, IL

SR. SAS DEVELOPER SEP. 2015-FEB. 2016

Rewrote legacy SAS code for retrieval and transformation of claims data from Terada

Analyzed new requirements and revised code to conform to macro driven architecture.

Developed new macros for standardization.

NLB Services-BlueCross/Blue Shield: North Carolina

SAS DEVELOPER (TERADATA) JUNE 2014-MAY 2015

Optimized the SAS code used for extracting Medicare and Medicaid Claims and provider data.

Performed QA of SAS code

Provided SAS best practices

Identified and document possible failures in current processes.

Visa/Discover Card

SAS DEVELOPER (TERADATA) JUNE 2014-MAY 2015

Optimized the SAS code used for calculating refunds and exceptions to payment matching reports.

Developed ETL code using SAS EG to create SAS Stored Processes, Macros and Programs

Set up Reporting Standards for the Marketing Risk Control department.

Identified and documented possible failures in current processes.

Designed an overall process to capture data transfers from one system to another.

Mindtec/High Mark-Blue Cross/Blue Shield

SAS DEVELOPER (TERADATA, ORACLE) JULY 2013-DEC. 2013

Objective is to create graphical interface to report sales information and health care reporting.

Developed ETL code using SAS EG to create SAS Stored Processes, Macros and Programs

Registered SAS tables using SAS Management Console.

Created OLAP cubes in SAS OLAP Cube Studio to be used with Information Map Studio used in creating reports.

Used SAS Web Reports Studio to create reports with filters, drill downs and user prompts.

Used Information Delivery Portal to surface list reports and drill down reports created in SAS BI Suite.

Used Enterprise Guide to create Stored Process.

Zencos-State of NC Medicaid Medicare

SAS DEVELOPER (TERADATA, ORACLE) MAR. 2013-JULY 2013

Objective is to create an interactive Medicare/Medicaid Claims reporting system for the State of North Carolina.

Developed ETL code using SAS DI Studio to create SAS tables and views.

Registered Oracle tables and views using SAS Management Console and SAS DI Studio jobs.

Migrated SAS Enterprise Guide code and SAS DI Studio code between DEV, UAT and Production.

Created OLAP cubes in SAS OLAP Cube Studio to be used with Information Map Studio used in creating reports.

Used SAS Web Reports Studio to create reports with filters, drill downs and user prompts.

Used Information Delivery Portal to surface list reports and drill down reports created in SAS BI Suite

Medical Leave of Absence June 2012-Dec. 2012

Gallup

SAS DEVELOPER JAN. 2012-JUNE 2012

Created SAS programs that report on Beer polls

Created SAS programs for production reporting

Updated and maintained production SAS programs

Decoded older SAS program for documentation and correction.

Documented un-documented processes

Performed trouble shooting and researched errors in development and production

Performed data Integration to transform data

Valence Health

SAS BI REPORTING JUNE 2011-OCT. 2011

Created ETL Process to extract Medical Patient and Provider Data

Created Prototype ETL and Information map process for production

Created Information Maps with custom data Items

Created WRS reports for testing of provider data.

Created custom reports using Information Maps and Information Delivery Portal.

.

Sun Life of Canada

SAS WEB REPORT STUDIO CONSULTANT FEB. 2011-JUNE 2011

Evaluated requirements and recommended design for interactive reporting mart with architecture team.

Created ABM data mart SAS Data Integration Studio

Created WRS reports and OLAP cubes using SAS 9.2 EBI software.

Created custom reports using Information Maps and Information Delivery Portal.

Created Static reports, Excel reports and Stored Processes.

Applied custom security model as required by client utilizing SAS Management Console.

Used Data Integration Studio for sourcing data

Medical Leave of Absence Jan. 2010-Jan 2011

Hewitt and Associates

SAS DATA MODELER JAN. 2009- NOV.2009

Evaluated requirements and recommended design for interactive reporting mart with architecture team.

Created customer service data mart using data stage and Oracle.

Created WRS reports and OLAP cubes for SAS 9.13 EBI software.

Created custom reports using Information Maps, ODS and Information Delivery Portal.

Created Static reports, Excel reports and Stored Processes.

Created migration path/process to moved custom code and metadata from SAS 9.13 to SAS 9.2.

Created library of macros that could be shared among team members.

Connected SAS enterprise guide to be server based instead of pc based.

Automated the process to connect commonly used libraries to enterprise guide.

Applied custom security model as required by client utilizing SAS Management Console.

Barclays Bank

SAS PERFORMANCE CONSULTANT SEP. 2007-JULY 2008

Evaluated Basel II System and Credit Risk Engine Solution for optimization.

Used Information Maps and SAS Web Report Studio for creation of customized web reports.

Created Static reports, Excel reports and Stored Processes.

Tuned the performance of ETL Programs of CRE Solution from SAS to reduce the loading time into Strategic Report Mart.

Used programs for Contingency Reporting

Used ARM tool for Cube Performance.

Migrated programs and data between different environments.

Planned number and size of File Systems needed for SPDS data paths depending on number of CPU and space available on the Box.

Allocated proper space for data paths, indexes, metadata and work areas in SPDS

Defined SPDS work-area (size and number of parallel paths) and performance tuned SPDS system

Determined number of Mount Points needed for Optimal SPDS Performance.

Created Cluster tables in SPDS.

Performed security of SPDS data using ACLS.

Configured SPDS Clients to be used in Unix and Windows through SAS Configuration files.

Defined SPDS libraries in SAS Management Console.

Defined setting of Parallel threads in SPDS.

Reviewed ACL code from the bank to confirm the sas code we built.

Clients: The GAP, Macy’s, United Health Care, Ingenix, CarMax

SAS SOLUTION ARCHITECT (SUB CONTRACT) OCT. 2005- SEP. 2007

Installed and configured multiple MutiTier SAS 9.1 and 9.13 Business Intelligence Platforms (BI/EBI/ABM/SPM/FM).

Provided data architectural leadership in developing enterprise data process models and logical/physical database designs.

Provided SAS technology solutions expertise for SAS 9.1.3.

Updated software with hot fixes.

Customized Information Delivery Portal

Created WRS (Web Report Studio) reports

Created stored processes and custom macros and automated SQL procedures.

SBC Communication

SAS DATA WAREHOUSE ARCHITECT NOV. 2003-OCT.2005

Provided data architectural leadership in developing enterprise data process models and logical/physical database designs.

Provided data and database development, maintenance and production support.

Participated in IT and Business project system definition and requirements.

Provided SAS technology solutions expertise for SAS v8.2 and SAS v9.1.

Constructed and maintained enterprise and application data models.

Drafted recommendation to be used in development, data usage, database policies, standards, guidelines, and procedures.

Developed and consulted on the use of the company's Data Architecture, metadata repository, data warehousing, and data and database tools.

Analyzed performance and utilization of enterprise application and recommend appropriate technical and cost-effective solutions

Project:

Technical Lead and Architect of the SBC Scorecard application, built to gather, maintain and report employee performance metrics.

Designed extract, transformation and load processes for all data sources (SAS/Oracle/Teradata) for this application.

Provided a functional migration path for conversion from SAS v8.2 to V9.1.

Drafted an enterprise process model template to encompass use of SAS 9.1 for all projects under this current initiate.

Designed and built the ELT processes for a prototype system that presented predefine metrics with multiple dimension and drill down paths that addressed authentication and authorization. This balance Scorecard Prototype had few requirements; accelerated time frame

Capitol One

SAS ARCHITECT APR. 2003-SEP.2003

Designed and prototyped a platform that would be capable of deploy fraud defenses programs. This platform would cut down the current development time down from 6 months to 3 weeks, be upgradeable and backwards compatible with given components. Assisted in the writing of system use cases, development of class models.

Applied UML methodology in the design of a SAS based system. This design allowed the platform services to provided predefined and reusable services in SAS, running against an Oracle ODS and a Teradata data warehouse, all in a UNIX environment.

For proof of concept, developed Teradata DDL and Oracle DDL and used it to generate the tables and indexes needed to confirm our design.

Wrote SAS code for key subsystems and assisted in creation of standardization models need to produce SAS programs used in fraud detection.

Used ACL to identify to errors in our SAS code

Energy Retail Solutions

SENIOR DEVELOPER/TECHNICAL LEAD/SAS SERVER ADMINISTRATOR JUNE 2002-FEB.2003

Led the team of SAS Developers to design and implement the production back office processes that supported the Risk, Settlement, Scheduling, Curve Development, Forecasting and Pricing Teams for Entergy Retail Solutions.

Developed process and programs used to simulate 18 months of weather used in forecasting customer consumption. This information is required for create a personalized price for a customer based on that predicted load, simulated future market prices and Risk factors. Part of this information is provided to the traders to assist in purchasing energy from the market. All of this information is stored in Oracle so that its components can be extracted and used in Risk Dimensions to do Mark-To-Mark, Var and Scenario Analysis.

Utilized SAS, Risk Dimensions (Risk Management Solutions), SAS, FEA, Oracle, Toad and PVCS Software. Due to the resource constraints, served in multiple capacities including Quality Assurance Manager for code walkthrough and reviews, Code Migration Manager (PVCS), SAS Server Administrator and Data Architect/Modeler for the Risk and Marketing Team.

Duke Energy

SENIOR SAS DEVELOPER/TECHNICAL LEAD MAR. 2001-JULY 2002

Developed a database and ETL process to combine information from multiple Deal Capture systems. Used this information as the base for Risk Dimension to produce analytics such as Mark-To-Mark, Var and Scenario Analysis.

Created the production ETL processes as well as dynamic update process for the Oracle database.

Created the code used to define scenarios for Risk Dimension as well as create self generation scenario analysis based on incoming data.

Utilized SAS, Risk Dimensions (Risk Management Solutions), SAS, FEA, Oracle, Toad and PVCS Software.

Merck-Medco

SENIOR SAS DEVELOPER/TERADATA TECHNICAL SPECIALIST SEP. 2000-MAR 2001

Provided the onsite programming and technical support required to extract, load and report on claims stored in Teradata. This warehouse contains over 2 billion rows and in excess of 100 tables that are updated bi-weekly.

Initially created tables and views in Teradata; then set up and distributed a BI/Query model for local users to access the data tables and reports from their PCs.

Used PC/SAS via an ODBC connection to the NCR box as my tool of choice to do extracts for reports. These reports were automatically distributed via email Outlook in HTML format and or Excel files formats to the users/requestors.

Used SAS/V8 on the mainframe in conjunction with Teradata/Fastload to create and load Teradata tables.

Supported Marketing department by extract potential customers from the database using files they created in Access, Excel, Brio, and Queryman.

Provided a tool to automate the campaign tracking and response-processing database maintained in Access feed by SAS

SAS Institute/Sprint

QUALITY ASSURANCE ETL TECHNICAL LEAD MAR. 2000-SEP.2000

Tested SAS applications and programs that were being developed Sprint in their new Marketing Data Warehouse. This Oracle based warehouse used SAS, SAS/Macros, SAS/MDDB, SAS/Warehouse Administrator, Oracle triggers, PL/SQL and Unix Scripts to extract, transform, manipulate, load and transport information spanning multiple platforms Windows, Unix, and MVS .

Identified and resolved actual and potential problems in the current implementation/design of this CRM solution.

Provided assurance that the application met SAS s programming standards as well as the client s specifications and functional requirements.

Ensured that the application was compatible with SAS/V6.12 development version and SAS/V8 recently released to be upgraded to as time and money permitted. These responsibilities required familiarity with SAS/V6.12, SAS/V8, Oracle, NDM and Unix as well as deep understanding of data warehousing in the telecommunications arena.

Recommended modifications during development that avoided potential pitfalls in production and unnecessary rework.

QA duties included reviewing, testing, recommendation and approval of the following items:

Detailed code walk-thru with both the development SAS team and Client Sprint

Provided model revision recommendations to the Database Modelers and Marketing teams

Creation and usage of multidimensional databases for usage with of both static and web reports.

Implementation, usage and QA of the SAS Warehouse Administrator

Ameritech/SBC-Centralized Account Marketing

SENIOR SAS DEVELOPER ANALYST JULY 1997-JAN. 2000

Used SAS, created an automated process that identified data integrity errors in the Marketing Data Warehouse Teradata based and Remarking Data Warehouse Oracle based. Both warehouses needed to be reconciled and in sync prior to movement of account information between the sources to assure proper customer service. Due to the high volume of data in both warehouse 3.4 million/12 million rows and the short time period that both warehouses were static 3-5 days’ manual intervention was not an option.

Created the process to automatically extract data from both warehouses using SAS/SQL/Macros. Used the information gleaned from interviews with the analyst about undocumented processes and procedures to create logic that automatically produced reports and flat files to be used to review suspect accounts. The nature of the data required that the process be dynamic enough to determine incorrect or abnormal records and process the records accordingly.

Developed programs and tools used to audit and quantify processes used by Ameritech to transfer data between systems, identify relationships within a known corporate structure, report sales and product market penetration. This tool had to be revamped due to Ameritech s expansion outside of the 5-state region into a nationwide presence. Customer Service, Sales and Marketing and Finance departments use this tool to verify proper processing of accounts.

Co-developed the account summarization processes used in feeding the Oracle Data Warehouse. Provided the code used for account error identification and statistical reporting within the data warehouse. Reviewed, tested, corrected and refined the process currently used to identify and properly distribute 2.9 million business customers in 5 states. This process is the basis for identifying which business unit within Ameritech has the capability to best service the customer needs. Provided Ad hoc reports from Teradata used in determining new rules to further enhance customer to business unit distribution for both data warehouses.

Provided statistical reporting of customer inquiries included revenue, products, and movement across segments and or loss.

Developed an application that automatically generates reports to provide confirmation of account changes and to identify errors, thereby eliminating the need for manual intervention by analyst.

Ameritech/SBC-Consumer Marketing Information Services

SENIOR MARKETING DATABASE DEVELOPER OCT. 1995- JULY 1997

Provided SAS expertise needed in the development of an Oracle data warehouse used by the Marketing team to perform direct marketing analysis and statistics using SAS 6.11. I retrieved data from outside data sources Acxion, Trans-Union as well as in-house Oracle, Teradata, Flat file and PC s and created SAS datasets to be used by other members of staff.

Prototyped the development of the customer loss tracking programs used to track and report accounts lost due to new competition in the telecommunications market. This application also identified customers most susceptible to loss to the competition. These applications were instrumental in reacquiring 50 of the customer base lost to competition due in 1997.

Introduced and set up automatic distribution process for departmental report to distribute via electronic mail and fax with little or no intervention required from staff.

Performed detailed analysis to create list of prospective clients to market product and services.

Trained users in Advanced SAS techniques and JCL, reducing the resources and time required to process 15 million accounts.

Ameritech/SBC-AIMS Production Support

SAS DEVELOPMENT PROGRAMMER JAN 1995-OCT. 1995

Performed analysis, coding, testing, implementation and troubleshooting on production reports and tables, as well as producing ad hoc reports using SAS.

Worked with business analyst and management during various stages of analysis and design.

Provided user support for reports generated by the team. Provided 24/7 emergency support of production process that maintained a 15 million customer’s database.

Wrote new specifications or modified the outdated ones to reflect the current requirements of the users.

Sears-Marketing Support

TESTER/TECHNICAL SUPPORT JUNE 1994-DEC. 1994

Developed testing cases/scripts and requirements to test the relationship between the working code and the specification.

Documented areas in the code or specifications that could fail or allowed bad data to be passed through the system.

Sole on-site network support staff for 20 testers. Duties included installing, monitoring and repairing all servers, PC s, printers and fax machines.

I SO 2000 Certified Analyst at Sears

EDUCATION

BA in Economics - Northwestern University (1987-1991)

AA in Accounting- Harold Washington College

AA in Business Administration- Harold Washington College

US Navy Air Traffic Control Training (Millington, TN)

CERTIFICATIONS:

•Quality Assurance

•Analyst Oracle

•SAS - Professional V6

•US Navy Air Traffic Controller

•SQL Specialist

•Implementation Specialist

•SAS Advanced Programmer

•Warehouse Development Specialist

•Teradata – Professional

I SO 2000 Certified Analyst

Contact this candidate