SUMMARY

• SAS administrator with 6+ years of experience in providing support to SAS applications, updating software patches, handle server connectivity issues, user authorization and security.
• SAS Metadata and ETL developer with extensive knowledge of building & implementing metadata repository & metadata security
• Expertise in SAS Data Integration (DI) studio, SAS Management console and SAS BI suite
• Strong knowledge of installation, configuration and troubleshooting of SAS Information Map Studio, SAS OLAP Cube Studio, SAS Information Delivery Portal and SAS Web Report Studio
• SAS ETL developer with expertise in design and development of Extract, Transform and Load processes for data integration projects to build data marts
• 6+ years of experience on SAS Intelligence Platform and its components
• Statistical data analyst with extensive experience in business data mining, database marketing and statistical modeling using SAS
• More than four years of experience as a SAS Programmer and expert in data mining, database marketing, direct marketing, predictive modeling, customer profiling, clustering and segmentation modeling using SAS Enterprise Miner & SAS EG
• Extensive knowledge of using Base SAS, SAS/Macros, SAS/SQL, SAS/STAT & SAS EG
• Advanced knowledge of statistical models such as clustering, segmentation, predictive modeling, ANOVA, regression analysis, decision tree, CHAID, neural networks and survival analysis
• Proficient in design and development of SQL queries and crystal reports
• Advanced MS Excel user with ability to use solver, scenario, macros, goal seek analysis and pivot tables
• Proficient in working on UNIX (Sun Solaris, HP UX, AIX) and Windows platform
• Possess outstanding analytical and interpersonal skills with strong problem solving skills

COMPUTER SKILLS
SAS Skills: SAS Data Integration (DI) Studio, SAS Management Console, SAS Enterprise Guide, SAS Enterprise Miner, SAS BI Suite, SAS Information Map Studio, SAS OLAP Cube Studio, SAS Information Delivery Portal, SAS Web Report Studio
SAS V8.2/V913/9.2, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/GRAPH, SAS/SQL, SAS/STAT, SAS/ODS, SAS/CONNECT
Database Platform: SQL Server 2005, ORACLE 9x/10x, DB2, MySQL, MS Access 2003/07
Programming Languages: C, C++, UNIX Shell Script, ASP.NET, ADO.NET, HTML, XML, JavaScript, MATLAB
Application Software: MS Office, MS Project, MS Visio, Visual Studio 05, SPSS
Operating Systems: UNIX, LINUX (Sun-Solaris, Ubuntu), Windows 98/XP/Vista/7

PROFESSIONAL CERTIFICATION

• Predictive Modeler Using SAS Enterprise Miner 5.3
• Graduate Certification in Business Data Mining
• Certified SAS Data Miner

PROFESSIONAL EXPERIENCE
SAS ETL Developer/ SAS Administrator Dec 08-till date Confidential,Phoenix AZ

• Administered, installed and maintained windows and SAS/UNIX systems & servers
• Managed SAS application software operations, SAS components , updates, patches and fixes
• Worked closely with SAS user to meet their needs on SAS server environment
• Handled efficiently transition from SAS9.1.2 to SAS9.1.3 and helped users on new environment
• Administered SAS software and server user access and security
• Designed, developed and maintained metadata repository, metadata security modules and implemented metadata server
• Maintained users application for server connectivity, proper user authorization and users security
• Provided technical support to end users regarding SAS applications, tools & server related issues
• Handled server expansion project efficiently which involves user access permissions, user groups and allocation of space to users.
• Provided technical support to end users on SAS, SAS Enterprise Miner, SAS Enterprise Guide, SAS Data Integration Studio and SAS BI Suite
• Coordinated activities with SAS technical Support team to open tickets for SAS related issues, escalate issue and close ticket
• Contributed for maintenance of SAS software applications, development of back up strategies, performance tuning, capacity planning and develop strategies for efficient and effective use of SAS applications
• Managed software licensing, created and updated system documentation for SAS environment and documented problems and solutions for future reference

Environment: UNIX, Sun Solaris, SAS 9.1,9.2, SAS DI Studio, SAS BI Suite, SAS Management Console, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/CONNECT, SQL Server 2005, Oracle 7x/8x

System Administrator/ SAS Programmer Tech. Support Aug 07-Dec 08
Department of Mathematics & Statistics Confidential,

• Windows/UNIX system administration, installation and maintenance of servers & labs
• Provided technical support to Statistics Department faculties regarding software & server related issues
• Assisted Statistics Department faculties on Data Mining, Statistical Modeling, predictive analytics projects involving SAS Enterprise Miner and SAS Enterprise Guide
• Managed SAS/MATLAB/Mathematica/Maple software operations, application upgrades, patches, fixes, application maintenance and support of SAS components
• Management of software licensing, user access, security, authentication and authorization
• Designed web sites (HTML, .NET, ADO.NET) to add, delete and update SQL & MS Access database

Environment: UNIX, Ubuntu, Sun Solaris, SAS 9.1,9.2, MATLAB, MAC OS, Visual Studio 05

SAS Administrator/ ETL Developer/ SAS BI Developer May 05-Aug 07
Confidential,Columbus, OH

• Used SAS Data Integration Studio to develop various job processes for ETL (Extract, transform and load) data warehouse database.
• Involved in design & testing of ETL code, interface integration & database structures to build data marts
• Worked on installation, migration, maintenance and troubleshooting of SAS BI shared environment.
• Acquired, applied and implemented details knowledge on SAS Server Architecture to use SAS applications and its components efficiently and effectively
• Contributed for SAS BI architecture, capacity planning and performance tuning activities and implemented best industry practices for SAS BI
• Applied core expertise in SAS BI suites of product including Enterprise guide, Information map studio, Web report studio and Information delivery portal for efficient use of SAS applications
• Contributed for SAS Analytics projects involving SAS Enterprise Miner and SAS Forecast Server
• Administrated SAS on Sun-Solaris platform and worked on projects involving SAS on AIX platform
• Worked on various database platforms including ORACLE, MS SQL server and DB2
• Developed, implemented and maintained enterprise business intelligence (EBI) strategy that incorporates both reporting and distribution processes
• Identified, evaluated and implemented business intelligence (BI) tools that support the current business needs as well as allowing for future growth and expansion
• Provided guidance and technical expertise to business power users who are responsible for developing reports and conducting ad-hoc data analysis

Environment: UNIX, Sun Solaris, SAS 9.1, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/CONNECT, SAS Data Integration Studio, SAS BI Suite, SQL Server 2005, Oracle 7x/8x

Statistical Quality Analyst/ Failure Analyst/SAS Programmer May 03-May 05
Confidential,Columbus, OH

• Daily activities involved collection of product failure data, data preparation, extraction, manipulation and data analysis using SAS
• Interpreted and presented statistical findings graphically and minimized product failures from 40% to 30% within one year
• Developed standardized SAS graph reports on energy consumption, load and demand of electricity and reduced electricity consumption by 5% per month
• Developed SAS macros programs to automate repetitive task to improve accuracy and to utilize time
• Utilized SAS to create reports on large product testing data, analyze patterns & detect failures
• Created and analyzed SAS database to support product production, planning, failure reduction, cost improvement, error prediction and detection
• Integrate data from various system sources (flat files, CSV, text form, and other formats) using SAS
• Accomplished project: Developed clustering and product segmentation models (K-means clustering, principle component analysis, RFM and segmentation profiling models) for large customer data. Created customer profiles and analyzed the models for maximum profit
• Accomplished project: Developed predictive model using SAS EM & EG to predict best location for energy resource manufacturing plant. Created models (regression & neural network) & compared expected profit margin
• Accomplished project: Developed direct product marketing model using SAS EM/EG. Developed and suggested statistical models (Logistic Regression, Decision Tree, Neural Network, and Ensemble Model) that will allow management team to market to customers more effectively, reduce costs and increase revenue. 6% increase in profit is achieved by sending offers to the customers from the model

Environment: SAS 9.1, SAS Enterprise Guide, SAS Enterprise Miner, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/GRAPHS, MS Office, SQL Server

EDUCATION
M.S. (Management Information System-MIS/Business Data Mining)