TECHNICAL SUMMARY:

• Innovative and dynamic results oriented professional with 17 years of diversified experience with visible achievements in business intelligence, business integration and system architecture. Industry experience includes Telecommunications, Mortgage, Health and Life Science, Insurance and Energy.
• Broad understanding of the SAS toolset. Skilled in SAS Platform Architecture, design and support of SAS 9.3, SAS 9.2, SAS 9.1.3 environments. Expert level skills in Installation of the SAS Enterprise BI, SPDS, BASE SAS across different configurations and operating systems as needed by the client.
• Administration and Support of SAS Activity Based Management , SAS Enterprise Guide, SAS Enterprise Miner, High Performance Forecast Server, Text Miner, SAS Marketing Automation, DI Studio, OLAP Cube Studio, SAS AMO, SAS PC File Server, SAS SPDS, SAS Access Products: SAS Access/GreenPlum, SA/Access Teradata, SAS/Access DB2, SAS/Access Natezza, SAS/Access PC Files, Other SAS Access Products, SAS/Share, SAS/Connect, SAS Web Report Studio, Information Delivery Portal, SAS OLAP, WEBDAV Xythos / Content Server, LSF, SAS Grid.
• Defined and implemented SAS performance benchmark test suite. Configured, created and deployed installation packages for the SAS environments. Performed SAS conversions from Windows to UNIX environment. Migrated SAS users and applications over to the new environments.
• Created and implemented action plans for outstanding and ongoing operational issues and assisting in daily support and infrastructure maintenance as required. Defined and documented Change Control procedures.
• Worked with each SAS user-groups to understand and analyze their end-user requirements for SAS analytics. Create usage profiles and models to help drive new SAS architecture. Defined and documented SAS usage best practices and standards.
• Developed Functional and Technical Specifications. Designed test plans to ensure correct results. Administered reports on a large-scale application with different types/formats. Enhanced the applications with custom features to meet the needs of the clients. Presented to the executive teams of financial sectors and end customers.
• Excellent problem analysis, Structured and Object Oriented Programming. Design Techniques, Statistical analysis, Data Mining techniques, Design OLAP Cubes, Segmentation, Clustering, Testing Procedures, Documentation, File Manipulation, Relational Database design. Knowledge of Multidimensional Databases, Star Schema and Snow-flake Modeling.
• Excellent project planning project execution skills. Strong team-working multi-tasking skills. Motivational, thorough and detail oriented.
• ETL experience using Informatica PowerCenter 6.x/5.1.2, PowerMart 5.1.2/5.0/4.7.2, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations
• Scripting Experience using PERL, UNIX k-sh, csh, bsh . Working Knowledge of reporting tools like Hyperion, BusinessObjects, Crystal Reports and SQR.
• Sound knowledge of Web Servers : IBM Webshpere 7.x, JBoss 4x, 5.1, Servlet Engines, Apache, Tomcat, Jrun and IIS
• Expertise in relational databases database triggers, stored procedures, functions, and database constraints . Database experience in Oracle 10g/9i/8i, UDB DB2, MS SQL Server 7.0/6.5, Teradata, MS Access.

Current assignment

confidential

Sr. SAS Platform Architect / Administrator

• I have been actively engaged in architectural design, implementation, support of very large SAS EBI Platform encompassing SAS 9.3, SAS 9.2 and SAS 9.1.3 environments across different databases like Terdata, Nateeza, Oracle, Db2, SQL Server, GreenPlum, etc.
• Enabled the growth of the SAS EBI Platform by 850 in a span of 2 years with all the IT Change management procedures, policies and other protocols into consideration. Designed, and managed the platform with 99.97 of System availability there by keeping very minimal downtime.
• Provide senior leadership in the architecture and administration of SAS data warehouse systems including maintenance and verification of extract, transform, and load operations. Provides technical guidance to business liasions and other staff on complex assignments.
• Responsible for providing comprehensive knowledge, leadership, and support in the physical design, testing, implementation, maintenance, and control of the organization's SAS data warehouse applications and database environments across multiple platforms
• Responsible for Capacity Planning, Metadata and UNIX security design. Portal Page Security, DI Security, Dashboard Security.
• Migration Strategy SAS 9.1.3, SAS 9.2, SAS 9.3. Performance Monitoring and Load Balancing the SAS E BI Server.
• Created several prototypes, best practices and technical know- how documents for customers to quickly follow the model casted and best adopt it in a short time.
• Provide support to SAS users in using different SAS tool sets. Supported the following: SAS Enterprise Guide, SAS AMO, SAS Enterprise Miner, High Performance Forecast Server, SAS Marketing Automation, DI Studio, SAS PC File Server, SAS SPDS, SAS Access Products: SAS Access/GreenPlum, SA/Access Teradata, SAS/Access DB2, SAS/Access Natezza, SAS/Access PC Files, Other SAS Access Products, SAS/Share, SAS/Connect, SAS Web Report Studio, Information Delivery Portal, SAS OLAP, WEBDAV Xythos / Content Server, LSF SAS Grid. SAS 9.3, SAS 9.2, SAS9.1.3, ,SAS Base, Macro, SAS/Stat, SAS/Graph, SAS/AF, SAS/SQL, SAS Procedures, SAS/ODS, SAS/ACCESS, SAS/CONNECT, SAS/ODBC , SAS Activity Based Management Information Map Studio, Web Report Studio, SAS Portal, OLAP Cube Studio, SPDS
• Identified product bugs. Communicated to SAS Institute for fixes.