SUMMARY:

Data Warehouse Architect, SAS Developer with over 25 years of successful Information Technology technical and management experience. MBA in Finance and Management Information Systems from Vanderbilt University’s Owen School of Management. Demonstrated competency in developing efficient and effective solutions to address diverse and complex business opportunities.

• Advanced SAS training and experience as a SAS BI Platform Administrator
• Supported full life cycle process, with project management experience including resource allocation, load leveling, and tool selection.
• Broad array of software languages, database tools, and advanced quantitative methods.
• Expert in use of relational database systems and in cross platform data integration.
• Implemented solutions across a range of platforms including SAS 9 BI Platform, Win/s NT, RS/6000, AIX, AS/400, OS/390 MVS ESA, z/OS, UDB2, DB2, Oracle, MS SQL Server, NCR Teradata.
• Design with Erwin, Power Designer, Designer 2000, Rational Rose, Riverton’s HOW.
• ETL experience with Informatica’s Power Mart, MS SQL Server DTS, Data Stage, including vendor research and product evaluation for clients.
• Manager with track record of mentoring and developing the finest IT teams of skilled practitioners.
• Facilitated application design and data modeling sessions with departmental users, technical developers and business analyst audience.
• Analyzed business process, developed logical and physical models at enterprise architecture level for IT organizations expanding with rapid business change.
• Experience in banking, finance, telecommunications, pharmaceutical, manufacturing, and software consulting industries.
• Completed an IBM International Technical Support Residency in MQ Series Workflow Manager for z/OS V3R3 at the Poughkeepsie ITSO Lab.

WORK EXPERIENCE:

Confidential

Sr.SAS Developer / Admin

Responsibilities:

• SAS program reverse engineering and data mapping to source systems for newly installed SAS reporting and analytics at First Niagara Financial Group

Skills used: Base SAS, SAS Macro

Confidential

SAS Architect / Developer

• Design and develop SAS reporting framework to support Comprehensive Capital Analysis and Review (CCAR) at PNC Bank, including audit trail repository for regulatory submissions.
• SAS subject matter expert for configuring deliverables for easy and consistent use by client
• Work closely with onshore and offshore statisticians to assist in configuring data access and highly formatted reporting and graphics output to MS Power Point and MS Excel
• Implement TortoiseSVN and Subversion for change control.

Skills used: SAS Enterprise Guide, SAS Information Map Studio, SAS OLAP Cube Studio, SAS Web Report Studio, Base SAS, SAS Macro, Subversion, TortoiseSVN

Confidential

SAS EBI Technical Architect

• Senior thought - leader, providing on-site knowledge, definition and expert direction on how and why SAS EBI and EG should be leveraged within the Federal Government environment
• Provide expertise on related client interfaces, and the overall enterprise SAS-related architecture.
• Participate in the design and implementation of complex SAS solution architectures
• Correlate technical concepts to SAS System applications and user needs
• Participate in development of new SAS-based analysis and reporting system for CMS, the federal agency responsible for Medicare/Medicaid
• Data extract from EDW, including proper handling of data summarization required for enrollment data
• Develop OLAP cubes for Medicare/Medicaid enrollments and submissions using PROC OLAP to allow for completely pre-aggregated data in lieu of using wizards in SAS OLAP Cube Studio

Skills used: SAS Enterprise Guide, SAS Information Map Studio, SAS OLAP Cube Studio, SAS Web Report Studio, Base SAS, SAS Macro, SAS/Access

Confidential

SAS Administrator

• Administration of SAS BI Platform v9.2
• Technical support for SAS Marketing Automation application
• Troubleshooting for performance problems, including SAS Stored Process Servers, SAS Workspace Servers, SAS Object Spawner, requiring detailed understanding of the logging architecture in order to trace problems through various logs to identify root cause and remedy
• Create users and assign them roles and groups in SAS Management Console
• Install and configure SAS clients on user workstations
• Maintain and modify SAS Information Maps
• Development and maintenance of SAS Stored Processes
• Development and maintenance of custom nodes used by SAS Customer Intelligence Studio
• Work closely with consultants from The Confidential to fine tune SAS servers
• Assist IT Application Support in applying maintenance patches / upgrades to SAS environment, including upgrade from SAS MA 5.3 to SAS MA 5.4

Confidential

Sr. Software Analyst

• Support Technical Lead and Senior SAS Developer to develop SAS programs for the eHARS National Data Processing Project at Centers for Disease Control and Prevention.
• Compliance with implementation of eHARS NDP Requirements, design, and change control
• Develop SAS programming for NDP program modules
• Create Unit Test plans and execute unit testing
• Participate in peer reviews of code
• Support Technical Lead and Senior SAS Developer to successfully deploy and deliver the National Data Processing software package meeting client requirements on time.
• After the NDP implementation date, provide prompt support for customer requests and to implement any requested changes or defect repairs.
• Provide technical mentoring, training, and guidance to the development and QA teams with respect to SAS and SQL.
• Review SAS and SQL programming created by the development teams.
• Make recommendations to improve NDP Team's use of SAS.
• Research technical issues regarding appropriate use of SAS features not currently included in the design (e.g., MP Connect, Windows pipes, data views). Provide subject matter expertise, training to other team members for implementing these features, and knowledge transfer documentation so customer can quickly train their maintenance and support team in the use of these features.

Skills used: SAS 9.2, Base SAS, SAS Macro, SAS/Access, SAS/Connect, MS SQL Server, ClearQuest

Confidential

Data Warehouse, SAS Application Development

• Maintain and optimize production code for Mortgage Portfolio Overview
• Maintain and optimize code for Mortgage Loss Reporting
• Assist in running monthly reports used for reporting to OCC regulators, reporting to investors, and for statistical analysis in risk management
• Computing environment is primarily PC/SAS with RSUBMITS to an AIX server, some use of SAS Enterprise Guide, and both Informix and Oracle

Confidential, Seattle, WA 

SAS Administrator for SAS Business Intelligence Platform

• SAS BI Platform running on Unix
• Install and configure SAS BI Platform, SAS Enterprise Guide 4.1, SAS Enterprise Miner 5.2
• Technical environment configuration, performance monitoring, tuning, user standards and procedures, security administration, metadata management, software license administration
• Technical liaison with Confidential and data mining vendors
• Provide technical knowledge transfer to bank staff
• Reconfigure data mining code for deployment within SAS Business Intelligence platform using SAS Enterprise Guide
• Completely responsible for Marketing Services production operations
• Provide technical support for users regarding SAS BI Platform, Oracle, MS SQL Server in data mining and analytics group
• Application data management for retail banking scoring models
• Oracle query optimization
• Advise management regarding technology issues with SAS products, including new product evaluation
• Provide leadership for Confidential SAS Users Group
• Most recently, supporting Consumer Deposit Product Risk Department as SAS Administrator for SAS Business Intelligence Platform, and other duties similar to those mentioned above.

Skills used: SAS BI ADMIN, SAS Management Console, SAS 9.1.3, SAS BI, SAS Enterprise Guide 4.1, SAS Enterprise Miner 5.2, SAS Forecast Server, SAS Base, SAS Macros, SAS/Access, SAS/Share, Oracle, MS SQL Server, UNIX, Erwin.

Confidential, Jersey City, NJ

SAS Application Development

• Support for the installation of the SAS Corporate Compliance Solution for Sarbanes-Oxley
• Utilized MS Project Professional 2003 for managing timeline, critical path and staff resources
• Installed SAS in UNIX and NT environments, as well as PC/SAS on Win2000 PC, including related SAS products, such as SAS AppDev Studio
• Wrote Master Test Plan, Test Strategy, and modified vendor-supplied test cases and test scripts for the Confidential environment
• Guided project team with application security design, testing and deployment, and application data management
• Reviewed, modified, approved, and archived all system documentation
• Provided knowledge transfer to IBM for ongoing production support
• Responsible for all system migration instructions, and for coordinating Weblogic and UNIX system administrators, and Oracle DBA to migrate system from development, to QA, to production environments
• Performed contingency and recover testing
• Configure security definitions for users
• Main point of contact for managing all technical issues with the vendors for deployment and problem resolution during system and user acceptance testing

Skills used: SAS 8.2, SAS Base, SAS Macros, SAS/Access, SAS/Share, SAS for Windows 8.02, Oracle, UNIX, ERwin, Remedy, Rational Rose Enterprise Edition, UML, RUP, Rational ClearCase, Requisite Pro

Confidential

SAS Architect

• Design and development of a new platform for deploying and managing fraud defenses and other data mining applications
• Assisted in the writing of system use cases, development of class models, logical and physical data models
• Developed Teradata DDL from ERwin-generated Oracle DDL for one major subsystem and used it to generate the tables and indexes in Teradata for use in proof of concept
• White paper on “Controlling Asynchronous Parallel Processing in a SAS / Teradata / UNIX Environment”
• Product and strategy evaluations regarding Office of Foreign Asset Control (OFAC) regulations

Skills used: SAS 9.1.3, SAS BI, SAS Enterprise Guide 4.1, SAS Enterprise Miner 5.2, SAS 8.2, SAS Base, SAS Macros, SAS/Access, SAS/Share, SAS for Windows 8.02, Teradata V2R5, BTEQ, FastLoad, MultiLoad, TPump, DDLP, Oracle 8.1, MS SQL Server, UNIX, ERwin 3.5.2, Rational Rose Enterprise Edition, UML, RUP, Rational ClearCase, Requisite Pro

Confidential, Lake Forest, IL

Technical Architect

• Collected and evaluated current state scope, architecture, resources and toolsets for approximately 75 ongoing client IT projects.
• Designed functional architecture allowing client to crystallize a vision for the future while leveraging current investments.

Skills used: Power Point, Visio, MS Access, MS Excel

Confidential, White Plains, NY

Senior Technical Advisor, SAS Developer

• Analyzed ETL process for company’s enterprise data warehouse
• Gathered requirements, designed, developed data mart for customer relationship management
• Wrote extensive SAS mainframe programs to document legacy system business rules
• Worked directly with support personnel at Microsoft to resolve cross platform connection problems between MS SQL Server and DB2/UDB

Skills used: DB2/UDB, SAS, SQL, MS SQL Server OLAP Tool and MS SQL Server DTS, SyncSort, File Aid, JCL, TSO, JES2, COBOL, Informatica, MS Access, MS Excel, Windows NT, OS/390, AIX, RS/6000

Confidential, Washington, DC

Project Manager

• Complete project lifecycle responsibility to deliver new version of OLTP system used by the Armed Forces Institute of Pathology
• Project planning and resource management for a team of 6 professionals
• Introduced new procedures for database monitoring and performance tuning
• Documentation and enhancement of enterprise data model, both logical and physical data models
• New procedures for database monitoring, performance tuning, change control, and quality assurance
• Worked with business community for requirements definition and quality control for all deliverables
• Active participation in user testing, unit testing, end-to-end testing, parallel run and implementation planning, including participation in preparation of test plans, test procedures and test packs
• Wrote and implemented new standards and procedures for developing, executing, documenting and archiving test plans, test procedures, test data and test results, including peer, management and user review
• Train project team members in testing methodology

Skills used: Power Builder 6.5, UML, Visio, SQL, MS/SQL Server 6.5, MS Access, and Windows NT

Confidential, Washington, DC

Team Lead

• Supervised a team of 12 professionals
• Complete lifecycle responsibility for enterprise data warehouse supporting forecasting and budgeting
• Directly involved in designing and developing ETL process, and both normalized ODS and star schema data structures, logical and physical data models
• Developed new processes for data integrity and application data management
• Participated in product evaluation and selection for new products to support version control
• New version control procedures, problem tracking log, project status reports
• Facilitated weekly project review meetings with representatives from senior management and client
• Two major applications to support forecasting and budgeting
• Results used to generate reports to the Secretary and to Congress
• Completely overhauled project planning
• Produced a full life cycle work break down structure, detailed the roles and responsibilities associated with each phase, and established project tracking guidelines and procedures
• Introduced UML, including technology selection and staff training
• Heavily involved in moving department to CMM Level 2
• Risk management, including communication with customer and ATS management
• New procedures to track requirements through analysis, design, development, testing and deployment
• Supervised DBA on database performance tuning and monitoring
• Worked closely with DBA to develop new procedures for database backup and recovery

Skills used: SQL, C++, Power Builder 5.x (upgrading to 6.5) including PFC, MS/SQL Server 7.0, Sybase 11, Sybase IQ, Erwin, UML, MS Access, HTML, JavaScript, Cold Fusion, MS Project, PVCS, Power Point, Windows NT

Confidential, Reston, VA

Data Architect, Data Warehouse Architect

• Developed data architecture for enterprise data warehouse, integrating several COTS, including site acquisition, sales force automation, order entry, billing, and trouble tickets
• Worked closely with the technical and application teams to identify, evaluate, and recommend the specific technology architecture necessary to support both functional and non-functional requirements
• Participate in evaluation and recommendation of third party products
• On-time delivery of both logical and physical data models
• Developed specifications covering extract, cleaning, and transformation of data from COTS for use by development team
• Developed specifications for moving customer data from central data entry to various COTS
• Produced and managed project plan
• Application design using Rational Rose

Skills used: Erwin 3.5.2, MS Project, Rational Rose ’98, UML, Saville, Siebel, Vantive, Clarify

Confidential, Washington, DC

Team Lead

• Reengineered the Commission's Market Surveillance System from OS390 MVS CA-DataComm legacy environment to client / server environment
• Trained staff in use of Object Modeling Technique, including use cases, business process modeling, business rule identification, and translation of business model into logical and physical design
• Database performance tuning
• Developed queries, stored procedures and triggers
• Analyzed legacy SAS code
• Wrote SAS code to document legacy system business rules and to validate ETL process

Skills used: Power Designer, Power Builder 6.0 including PFC, MS SQL Server 6.5, SAS, SAS Macros, Riverton's HOW 1.2, UML, OS390 MVS

Confidential, Fairfax, VA

Enterprise Data Warehouse Architect

• Full life cycle application support for enterprise data warehouse for Defense Logistics Agency used for managing cost recovery across all branches of U. S. Armed Forces

Skills used: SQL, Oracle, Power Builder 5.0, Designer 2000, Windows 95, Sybase Server, UNIX, Sun

Confidential, Arlington, VA 

Data Warehouse Architect, SAS Developer

• Developed data warehouse integrating customer billing, order entry, and fulfillment for managing MCI products including pagers, cellular phone and calling card services
• Designed and developed integrated normalized ODS and star schema data warehouse to support OLAP reporting with drill down capability to detail transaction records
• Fully responsible for application data management

Skills used: DB2, SAS, SAS Macros, SAS/AF, SAS/SCL, SAS/Graph, SQL, Erwin, Visio, SyncSort, File Aid, TCP/IP, NDM, COBOL, CICS, TSO, ISPF, JES2, MVS ESA Sysplex data sharing

Confidential, Indianapolis, IN

Data Warehouse Architect, SAS Developer

• Supported data warehouse environment in a pharmaceutical clinical trial setting

Skills used: Quest, DB2, SAS, SAS Macros, SAS/Graph, SQL, MS Access, TCP/IP, FTP, JCL, TSO, JES2, MVS/ESA, AS/400

Confidential, Atlanta, GA

SAS Developer

• Business process reengineering for corporate sales contest management system
• Changed architecture from a reporting architecture to an ODS, designed and developed ODS
• Redesigned SAS job stream to allow parallel processing, reducing data extract and load time by 70%
• Developed SAS based sales performance forecasting model
• Designed new data driven model for sales contest system
• Designed and developed star schema and OLAP reporting environment
• Complete life-cycle responsibility for customer service auditing system

Skills used: SAS, SAS/AF, SAS/SCL, SAS Macros, SAS Statistics, SAS/Graph, SQL, SyncSort, File Aid, JCL, TSO, NDM, JES2, COBOL, CICS, MS Access, Visio, Power Builder, MVS ESA

Confidential, Memphis, TN

Manager, Distribution Development, SAS Developer

• Complete project lifecycle responsibility for enterprise data warehouse
• Complete project lifecycle responsibility for Distribution Simulation and Management System— system resulted in savings realized of over $14M for one fiscal reporting year
• Completely responsible for design and administration of TERADATA database
• Designed and developed Retail Mix Optimization Model
• Designed and developed SAS based reporting tools used for retail space presentations to key accounts, resulting in gaining incremental retail presentation space of over 5 miles long by 5 feet tall
• Developed Corporate Planning System, Advertising Stewardship System, Sales Forecasting System, Trade Promotion Analysis And Reporting System

Skills used: SAS Base, SAS/OR, SAS/FSP, SAS/FSCALC, SAS/ETS, SAS Macros, SAS Statistics, SAS/Graph, SyncSort, File Aid, MRP-2, Teradata, MVS/XA, Paradox, TSO, ISPF Dialog Manager, JES2, UNIX, TABOL, X/L, NOMAD, Quattro Pro, Dbase, Harvard Graphics

Confidential, Nashville, TN

Business Analyst

• Wrote Three-Year Strategic Plan as well as Marketing Information System for Energy Business Unit
• First year of plan resulted in 74% increase in sales, same year market leader (Kero Sun) filed for bankruptcy
• Business process analysis led to reorganization of the business unit, allowing introduction of JIT management of inventory, resulting in nearly eliminating inventory holding costs in the first year of implementation
• Recommended order quantity for purchasing over $40M inventory, the largest financial decision in Aladdin history since building the manufacturing plant

Skills used: SPSS, APL, LINDO