RAVI REEHAL

E-mail: ravi_reehal@[Link]
Mobile: 312.451.8811

SUMMARY OF QUALIFICATIONS
Dedicated, determined, focused and results-driven SAS BI Enterprise Technical Architect / Platform
Administrator Consultant with recent experience to SAS 9.2 Enterprise Business Intelligence (EBI)
Architecture with Financial Management, Data Integration, Information Mapping, Web Report Studio,
Portal, Stored Processes and Enterprise Guide 4. Also offering broad-spectrum business experience including
advanced SAS skills, knowledge of data management practices, generating analysis, statistical reports, strategic
planning, data analysis, project management, and resource allocation. Demonstrated and proven to be a strong
leader and communicator, with skills capable of building cohesion between cross-functional diverse groups. In the
past provided innovative solutions also skilled in delivering results in diverse and challenging situations.

AREAS OF EXPERTISE

- SAS 9.2 EBI Architecture (ETL / DI Studio) - Data Warehouse Management (OLAP)
- SAS Web Tools (App Dev Studio - Process Design/Improvement (CMM)
3)
- JAVA J2EE (JSP & Servlet - System Development Life Cycle Methods
Technology)
- Databases (Oracle, Teradata, SQL - E- Commerce (ROI)/ Web Initiatives
Server,DB2 )
- Web Servers (BEA WebLogic, IBM - Technical Writing / Documentation
WebSphere)
- UNIX (HPUX Itanium, IBM-AIX,SUN-Solaris) - Project Management

PROFESSIONAL EXPERIENCE

WALT DISNEY COMPANY – DATA WAREHOUSE DIVISION LOS ANGELES, CA

SAS V9.2 EBI ARCHITECTURE DEVELOPMENT OCT 2009 – PRESENT
SAS PLATFORM ADMINISTRATOR / TECHNICAL CONSULTANT
 SAS V9.2 EBI/DI on HP-UX 64 bit Administration and Configuration responsibility [M3 Upgrade].
 Sustained and overall responsibility for the effective operation of the Analytics Environment.
 Developed administrator processes, document the processes, and then train other client users.
 Manage overall SW environment. Plan upgrades, to SAS software (maintenance releases / hot fixes,
etc.).
 Enhanced SAS practices to reduce data set creation/storage and utilize HP Neoview DB environment.
 Monitor and log SAS servers and optimize memory usage or tune servers for optimal performance.
 Responsible for executing proof-of-concepts area of the SAS Intelligence Platform (i.e. DI, IDP,
OLAP).
 Focus on areas of capability, interoperability, scalability and enterprise class issues (i.e. like failover).
 Expert resource in support of the business user community for the Central Analytics Environment.
 Act as a liaison to SAS Technical Support for SAS users at the clients site

GE - HEALTHCARE RESEARCH & ANALYTICS PORTLAND, OR

SAS V9.2 EBI ARCHITECTURE DEVELOPMENT OCT 2009 – JAN 2010
SAS DATA INTEGRATRATION / BI CONSULTANT
 SAS V9.2 EBI/DI on IBM-AIX 64 bit Administration and Configuration responsibility
 Modified SAS Applications for migration from SAS V9.1.3 to SAS V9.2/IBM-AIX Environment.
 Developed/Coordinated migration/test plan user code and data sets from SAS 9.1.3 dev to SAS 9.2
prod.
 Responsible for executing proof-of-concepts area of the SAS Intelligence Platform (i.e. DI, IDP,
WRS).
 Performed conversions and migrations of SAS technology and custom solutions.
 Maintain all system configuration documentation by collecting, storing, and updating the
documentation
 Via SAS Management Console, controlled user access to various parts of the SAS system, granting
permissions to read, write, create or view reports and data within the system and ensured that users see
only the information that they are authorized to access.
DELOITTE CONSULTING, LLC - FEDERAL PRACTICE WASHINGTON, DC
SAS V9.2 EBI ARCHITECTURE DEVELOPMENT MAR 2009 – OCT 2009
SAS PLATFORM ADMINISTRATOR / TECHNICAL CONSULTANT
 Installation/Configuration of SAS Enterprise BI V9.2 on Unix platforms on multi server / LPAR setup
 Modified SAS V9.1.3 Application migration from Windows to SAS V9.2/IBM-AIX P595
Environment.
 Responsible for executing proof-of-concepts area of the SAS Intelligence Platform (i.e. DI, IDP,
OLAP).
 Provided ADHOC reporting support by analysis and resolution to correct errors for QA.
 Performed conversions and migrations of SAS technology and custom solutions.
 Maintain all system configuration documentation by collecting, storing, and updating the
documentation

KAISER PERMANENTE – ANALYTIC CENTER OF EXCELLENCE DENVER, CO

SAS V9.1.3 EBI ARCHITECTURE DEVELOPMENT JAN 2009 – MAR
2009
SAS ADMINISTRATOR / TECHNICAL CONSULTANT
 Reviewed, validated, documented and mentored Colorado SAS Admin regarding SAS environment.
 Documented best practices for the SAS Application server from a scalability need.
 Provided best practices related to ensuring security measures are established and implemented
 Performed conversions and migrations of SAS technology and custom solutions.
 Outlined a training curriculum and provided SAS Documentation for SAS Admin support role.

IBM / GENERAL MOTORS – VEHICAL ENGINEERING DETROIT, MI

SAS V9.1.3 EBI ARCHITECTURE DEVELOPMENT JUN 2008 – NOV 2008
SAS ADMINISTRATOR / TECHNICAL ARCHITECT (LEAD CONSULTANT)
 Supported 500 Global SAS Power Users utilizing the Global Analytical Reporting Tool for Claims
 Focus on areas of capability, interoperability, scalability and enterprise class issues
 Modified SAS V9 Application for migration from IBM AIX P590 to IBM AIX P595 Environment.
 Installation/Configuration of SAS Enterprise BI on Unix platforms on multi server / LPAR setup
 SAS Administration and Configuration responsibility

HORIZON / BLUE CROSS BLUE SHIELD OF NEW JERSEY NEWARK, NJ

SAS V9.1.3 EBI ARCHITECTURE DEVELOPMENT FEB 2008 – JUN 2008
SAS ADMINISTRATOR / TECHNICAL ARCHITECT (LEAD CONSULTANT)
 Responsible for guiding and coordinating all aspects of the SAS EBI project implementation and
analysis.
 Requirements gathering, project planning, timeline development and team coaching for Informatics.
 Outlined knowledgebase of SAS EBI technical specifications and product inter-dependencies.
 Built an enterprise data warehouse / data mart with SAS Datasets and OLAP Cubes.
 Automated processes and reports using SAS Web Report Studio, Portal, EG, SAS Macros

MACY’S, INC. / MERCHANDISE INTELLIGENCE & FINANCIAL MGMT SAN FRANCISCO, CA

SAS V9.1.3 EBI ARCHITECTURE DEVELOPMENT AUG 2007 – FEB 2008
SAS ADMINISTRATOR / TECHNICAL ARCHITECT (LEAD CONSULTANT)
  Reviewed, validated, documented and mentored SAS Admin and team regarding SAS environment.
 Documented best practices for the SAS Application server from a scalability need.
 Reviewed with Macy’s the Merchandise Intelligence, FM Solution and integration to EBI architecture.
 Active role in updating and migrating existing SAS environments to SAS9 and the efficiencies.
 Outlined a training curriculum and provided SAS Documentation for SAS Admin support role.

SAS / ENTERPRISE EXCELLENCE CENTER CHICAGO, IL

SAS V9.1.3 EBI ARCHITECTURE DEVELOPMENT AUG 2006 – AUG 2007
SAS ADMINISTRATOR / TECHNICAL ARCHITECT (CONSULTANT)
 Responsible for executing proof-of-concepts area of the SAS Intelligence Platform (i.e. DI, IDP,
OLAP).
 Focus on areas of capability, interoperability, scalability and enterprise class issues (i.e. like failover).
 Assisting customers in evaluating their current BI environment and planning a new architecture.
 Active role in updating and migrating existing SAS environments to SAS9 and the efficiencies.
 HP Service Guard failover development for SAS Metadata Server-HP Itanium Acceleration
Program.

WELLCARE HEALTH INSURANCE TAMPA, FL

SAS V9.1.3 EBI ARCHITECTURE DEVELOPMENT MAY 2006 – AUG
2006
SAS ADMINISTRATOR / TECHNICAL ARCHITECT (CONSULTANT)
 Architected SAS infrastructure ensured proper connectivity to data sources & configurations.
 Provided best practices related to ensuring security measures are established and implemented.
 Developed the best practices approach for the Customer Marketing team access OLAP cubes.
 Performed conversions and migrations of SAS technology and custom solutions.
 Modified SAS technology and solution configuration settings due to ongoing IT infrastructure
changes.

SAS / LIMITED BRANDS – VICTORIA’S SECRET COLUMBUS, OH

SAS V9.1.3 ARCHITECTURE DEVELOPMENT MAR 2006 – APR 2006
SAS ADMINISTRATOR / SOLUTION ARCHITECT (CONSULTANT)
 Deployed/configured SAS V9/E Miner Server Architecture UNIX IBM-AIX64 server environment.
 Provided ADHOC reporting support by analysis and resolution to correct errors for QA.
 Administer the SAS V9 BI Architecture environment at the Meta Data level.
 Modified existing SAS code for migration from V8 to V9 BI Environment.

BRIDGESTONE/FIRESTONE USA NASHVILLE, TN

SAS V9.1.3 BI ARCHITECTURE DEVELOPMENT OCT 2004 – MAR
2006
SAS ADMINISTRATOR / SOLUTION ARCHITECT (CONSULTANT)
 SAS Warranty Analysis Solution (WAS) Development and support role.
 Deployed/configured the SAS V9 BI Server Architecture for the Windows Server 2003 environment.
 Provided ADHOC reporting support by analysis and resolution to correct errors for QA.
 Administer the SAS V9 BI Architecture environment at the Meta Data level.
 Modified existing SAS code for migration from V8 to V9 BI Environment.

SAS / BRIGGS & STRATTON MILWAUKEE, WI

SAS V9.1.3 BI ARCHITECTURE DEVELOPMENT AUG 2004 – OCT 2004
SAS ETL DEVELOPER (CONSULTANT)
 Performance Monitoring and Enhancing and migration to Briggs & Stratton Environment
 Installed and configured the SAS V9 BI Architecture for the UNIX IBM-AIX environment
 Installed MS Office add ins for Microsoft Integration for the BI Architecture
 Tutored administrators and users the new offerings of the V9 BI Architecture
 Modified existing SAS code for migration from V8 to V9 BI Environment
SAS / ALLEGRO MICROSYSTEMS ROCKVILLE, MD

PROCESS INTELLIGENCE DEVELOPMENT APR 2004 – JUL 2004

SAS APPLICATION DEVELOPER (CONSULTANT)
 Process Intelligence (PRI) Installation and Customization according to Allegro’s system
specifications
 Defined System Requirements Specifications Documentation for PRI Implementation at Allegro
 Compiled Software Configuration Management Plan Documentation for Allegro
 Performance Monitoring and Enhancing and migration to Allegro’s System Environment
 Process Intelligence Custom Task Development according to Allegro Specifications

SAS / FREIGHTLINER LLC SOUTHFIELD, MI

WARRANTY ANALYSIS DEVELOPMENT SEP 2003 – MAR

2004
SAS APPLICATION DEVELOPER (CONSULTANT)
 Defined Technical, Functional, and Business Requirements for Warranty Implementation at
Freightliner
 SAS Warranty (WAS) Installation and Customization according to Freightliner’s system
specifications
 Introduced Warranty Application enhancements to R&D for future version release
 Maintained development application and resolve any errors/bugs for production release
 Continued to work with LSF Job scheduler to diagnose job failures

HOME SHOPPING NETWORK TAMPA, FL

MARKETING DATABASE MANAGEMENT APR 2003 – JUN 2003

SAS DATA ANALYST (CONSULTANT)
 Defined Technical, Functional, and Business Requirements for a Customer Retention Program
 Designed Intranet website and SAS Applications and SAS Data Warehouse for Marketing Dept.
 WebAF, AppDev Studio & PC/SAS 8.2 as Platform Tools To Build Website
 Developed SAS-based programs to infile flat-files and various formats of raw data and test for
production

VERIZON COMMUNICATIONS DALLAS, TX

DATABASE MARKETING CAMPAIGN MANAGEMENT JAN 2003 – APR

2003
SAS DATA ANALYST (CONSULTANT)
 Designed and Developed Intranet website and SAS/VB Statistical Forecasting Application
 Build SAS/VB Applications to Efficiently Use SAS Macros & Procs and Accept UI (Web) Inputs
 WebAF, Interdev, & PC/SAS 8.2 as Platform Tools To Build Website
 Programmed UI in Java (Servlets, JSP), VB, SAS, JavaScript, & html
 Maintained production application and resolve any errors/bugs

CIGNA HEALTHCARE INSURANCE CHATTANOOGA, TN

HEALTHCARE DATA ANALYTICS DEC 2001 – DEC
2002
SAS/WEB DEVELOPER (CONSULTANT)
 Created Application using Server Side Web Development for Cigna clients to view reports online
 Created Database structure to improve efficiency of report writing and extraction
 Analyze, modify and redesign existing pharmacy and medical reports for production
  Provided ADHOC reporting support by analysis and resolution to correct errors
 Maintain application production environment and resolved any error handling issues

Education & Training

UNIVERSITY OF PHOENIX CHICAGO, IL
Bachelor of Science in Information Technology

SAS INSTITUTE CARY, NC

WEB TOOLS: Server-Side Development using WebAF applying JAVA J2EE and JSP/Servlet Technology