SUMMARY:

• Over 15 years of excellent hands on working experience as Sr. SAS Administrator / SAS Solution Architect / SAS Guru / Technical Lead / SAS Subject Matter Expert (SME).
• Over 15 years of excellent hands on working experience in Base SAS, SAS/Macros, SAS/ETL, SAS/EBI, SAS/DI, SAS Grid, SAS Visual Analytics, RTM for SAS, SAS/CI Studio, SAS Marketing Automation, SAS/EM, SAS/MDDB, SAS/AF, SAS/Graph, SAS/Stat, SAS/EG, SAS Grid, SAS/ITRM, SAS/Warehouse Administrator, SAS Forecast Server, Campaign Management, Dataflux, SPDS, SAS/Share, SAS/Connect, SAS/Access to Oracle/DB2/ Teradata, PC SAS and UNIX SAS.
• Excellent hands on working experience in SAS Grid Computing, SAS Grid Manager, Distributed Enterprise Scheduling, Workload Balancing, Parallelization of workloads.
• Good experience with Platform RTM for SAS to monitor and configure the Grid Environment.
• Excellent hands on working experience in installation, configuration, maintenance and administration of SAS/EBI tools such as SAS/Data Integration Studio, SAS Information Maps Studio, SAS Management Console, SAS/Campaign Management Studio, SAS/OLAP Cube Studio, SAS Information Delivery Portal, SAS Web Report Studio, SAS Web Report Viewer, SAS Web OLAP Viewer & SAS/Enterprise Guide.
• Excellent hands on working experience with Teradata, Data Distribution on AMPS and PIs.
• Excellent hands on experience writing and tuning complex Teradata and Oracle Queries.
• Excellent hands on working experience with several RDBMS like Oracle 9i, 10g, Teradata, DB2, MS SQL Server, MS Access, Informix, Sybase, Oracle Clinical & Clinical Trails Databases.
• Excellent hands on working experience in writing complex UNIX Shell Scripting - awk and sed.
• Excellent hands on working experience migrating SAS/Oracle Environment to SAS/Teradata Env.
• Excellent hands on working experience Migrating SAS Platforms, Applications, Data and Catalogs from older SAS versions to 9.3 using Proc Migrate procedures and Migration Guidelines. Re-engineered SAS Code to leverage the enhance features of SAS Version 9 for streamlining the complex job streams and processes.
• Led a Sr. Technical Team to conduct POC (Proof of concepts) on various leading vendor technologies in their head quarters and advanced labs, Netezza in Marlborough MA, Teradata in San Diego CA and HP in Cupertino, CA to determine the capabilities and power of their hardware.
• Excellent hands on working experience writing comprehensive documentations, flowcharts, illustration, empirical analysis, and systems’ processes. Translating functional requirements into technical requirements, creating BRD, TRD, FD and Power Point Presentations.
• Excellent hands on working experience in complete Software Development Life Cycle (SDLC), requirements gathering, Data Management Principles, Data Warehouse Design, Data Mapping, Dimensional Modeling, Star Schema, Data Analysis and Design, Data Quality Techniques, Database Development and Test Plan Development.
• Excellent hands on working experience in Extraction, Cleansing, Transformation & Loading (ETL) as per business requirements. Created and standardized generic and complex mappings.
• Excellent hands on experience with Informatica Power Center and Informatica Power Connect with SAS. Administered multiple Informatica SPI Servers.
• Good experience in SPDS Version 4.x. Created and administered several domains, users’ accounts and profiles. Installed and maintained several instances and domains of SPDS & SAS.
• Good experience working on complex OLTP, Data Warehouse, Data Mining, OLAP & Data Marts applications.
• Good experience in Data Mining, Neural Networks, Memory Based Reasoning, finding patterns and hidden relationships in extremely large datasets.
• Created and administered several Standard Operating Procedures (SOPs), Technical Operating Procedures (TOPs) and Validation Guidelines.
• Good experience in migration of SAS Environments on cross server platforms, Mainframe SAS to UNIX SAS, PC SAS to UNIX SAS and vice versa.
• Written various test scripts based on functional requirements, determining data needs for a system test, developing test plans and test strategies, executing test scripts, managing testers to write and execute test scripts.
• Strong experience working in SAS under multiple platforms such as Mainframe (MVS), UNIX (HP-UX, Sun Solaris, Linux and AIX), and Windows NT.
• Good experience in writing Installation Qualifications (IQ’s) Operational Qualifications (OQ’s) and Performance Qualifications (PQ’s) for various Operating Systems and numerous Software.
• Installed several Software including Base SAS, EBI, SAS/Warehouse Administrator, SAS Forecast Server in multiple instances such as development, staging, QA, testing, training and production environments. Written complex shell scripts, configured runsetups, .profiles to execute the instances.
• Installed Datastage, Informatica Power Center, SyncSort, Health Care and HIPAA compliant software DRG, APDRG, HCFA, etc. in UNIX environment.
• Good experience working in compliance with FDA, HIPAA and SOX.
• Created and modified several Oracle / DB2 stored procedures, functions, packages, triggers, alerts and objects.
• Good experience loading DB2 Tables into Oracle using DB2 Gateway and SQL Loader. Used Bulkload to load the SAS Datasets into DB2 tables. Executed runstats on DB2 tables to optimize the indexes.
• Strong exposure in Business Analysis, design and training of users. Ability to work independently or in a team environment. Ability to comprehend complex processes and absorb technical knowledge quickly.

TECHNICAL SKILLS:

Hardware: IBM Mainframes 3090 / 3270, HP9000 N & L Class Servers, Sun Ultra Sparc 10 Servers, Compaq Alpha Servers, Pentium Machines, etc.

OS & Protocol: Windows NT, HP - UX, Sun Solaris, Linux, Dec UNIX, Sco UNIX & MVS.

Protocol: TCP/IP.

SAS Software & Languages: Base SAS 9.x, SAS Macros, SAS/DI, SAS/EBI, SAS Grid, SAS Visual Analytics, RTM for SAS, SAS/Warehouse Administrator, SAS/AML, SAS/AF, ETL/STUDIO, SAS Graph, SAS STAT, SAS Access, SAS Connect, SAS Grid, SAS/ITRM, SAS/PH-Clinical, PH.DataWare System, SPDS, SAS/GIS, Dataflux, SAS/SQL, SQL, SqlPlus, PL/SQL, Actimize, UNIX Shell Scripting, Korn Shell Scripting, JCL, Sync Sort, ISPF/TSO, Fortran77

RDBMS: Oracle, Teradata, DB2, Sybase, Informix & MS Access

GUI: Developer (6.0) 2000, Forms 5.0, Reports 3.0

MDM Tool: Data Flux - Data Management Studio 2.4

ETL & BI Tool: SAS/DI Studio, SAS/CI Studio, SAS/Marketing Automation, SAS/EBI, Data Stage, Informatica Power Center, Informatica Power Connect with SAS, Web Focus

Tools: Razor Version Control, Shareweb, PLV2, Autosys, RCS, PRM, TOAD, SQL Loader, Xythos, Apache, SQL Analyse, Export/Import, SQL Trace, TK Prof, Perforce, D&P, PVCS, Test Director, Share Web, Documentum, MS Office, MS Project, Visio, Cognos, Power Point, Excel, Vi Editor, FTP, Lotus Notes, etc.

Papers Author: Written and presented several papers on Data Management, Data MiningData Analysis, Data Mapping and Project Planning subjects.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Excellent hands on working experience in Extraction, Cleansing, Transformation & Loading (ETL) as per business requirements. Created and standardized generic and complex mappings.
• Excellent hands on experience with Informatica Power Center and Informatica Power Connect with SAS. Administered multiple Informatica SPI Servers.
• Good experience in SPDS Version 4.x. Created and administered several domains, users’ accounts and profiles. Installed and maintained several instances and domains of SPDS & SAS.
• Good experience working on complex OLTP, Data Warehouse, Data Mining, OLAP & Data Marts applications.
• Good experience in Data Mining, Neural Networks, Memory Based Reasoning, finding patterns and hidden relationships in extremely large datasets.
• Created and administered several Standard Operating Procedures (SOPs), Technical Operating Procedures (TOPs) and Validation Guidelines.
• Good experience in migration of SAS Environments on cross server platforms, Mainframe SAS to UNIX SAS, PC SAS to UNIX SAS and vice versa.
• Written various test scripts based on functional requirements, determining data needs for a system test, developing test plans and test strategies, executing test scripts, managing testers to write and execute test scripts.
• Strong experience working in SAS under multiple platforms such as Mainframe (MVS), UNIX (HP-UX, Sun Solaris, Linux and AIX), and Windows NT.
• Good experience in writing Installation Qualifications (IQ’s) Operational Qualifications (OQ’s) and Performance Qualifications (PQ’s) for various Operating Systems and numerous Software.
• Installed several Software including Base SAS, EBI, SAS/Warehouse Administrator, SAS Forecast Server in multiple instances such as development, staging, QA, testing, training and production environments. Written complex shell scripts, configured runsetups, .profiles to execute the instances.