SUMMARY

• Over 15 years of excellent hands on working experience as Sr. SAS Administrator / 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/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 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 in DataFlux Administration, Data Management Server 2.4, Authentication Servers, Creating repositories, Domain, Users and Groups.
• Built complex DataFlux jobs to cleanse the Data.
• Excellent hands on experience creating Business Rules and Monitoring to preserve data quality.
• 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.