PROFESSIONAL SUMMARY:

• 14 years of Total IT experience in Data warehousing and Business Intelligence Solutions using SAS 9.1.3, 9.2, 9.4 BI Suite, Base SAS, SAS - Procedures and SAS-Macros, SAS/GRAPH, SAS/CONNECT, PROC SQL, SAS Management Console, SAS Enterprise Guide, SAS Data Integration Studio, SAS CI studio, SAS Environment Manager, SAS Administration and Informatica Power center Administration.
• Expertise in SAS 9.4 Administration. Have good knowledge and experience in supporting and maintaining the SAS 9.4 M7 environment in AIX, Linux, and windows platform.
• Have good knowledge and experience in SAS 9.4 M3 to SAS 9.4 M7 version upgrade, SAS CI Studio 6.4 to SAS CI Studio 6.6 version upgrade and RHEL6 to RHEL7 OS version upgrade.
• Have good knowledge and experience in installing SAS components, applying hot fix, server decommissioning, Disaster Recovery, maintaining GPFS filesystem, fixing the vulnerabilities reported in SAS servers and SAS License renewal.
• Have good knowledge in UNIX commands and shell scripting. Developed shell scripts for calling and executing SAS Codes through UNIX and automated various processes in UNIX environment.
• Have good knowledge in SAS Management console and performed various process like user profile creation/modification, creating database connections and authentication, library creation for various databases.
• Have good knowledge in SAS DI studio and performed various deployments, library creations and table registrations in SAS DI studio.
• Expertise and very good in developing SAS codes for creation of new analytics reports and for the enhancement of the existing report as per the business needs.
• Proficient with SAS/BASE, SAS/MACROS, Data step programming, PROC SQL, PROC REPORT, PROC FORMAT, PROC FREQ, PROC MEANS, PROC TABULATE and PROC SUMMARY.
• Expertise in Design, development, and deployment of generating Analytical reports using SAS 9.4 BI Suite.
• Expertise in support and handling the SAS Merchandising suites namely Size profiling & Pack Optimization and Mark down Optimization and have a very good knowledge on that.
• Strong SAS programming background for creating, maintaining existing code, ad hoc reporting and supporting the reporting functions.
• Extensively worked in connecting various databases like Oracle, SQL Server, DB2 and Netezza from SAS and accessed data from various databases.
• Extensively worked as part of SAS Centre of Excellence in Cognizant.
• Have good knowledge and experience in Informatica 10.1 to 10.4.1 upgrade.
• Have worked on support and enhancement projects in Informatica.

TECHNICAL SKILLS:

Data warehousing Tools: SAS 9.1.3,9.2,9.4 BI Suite (SAS Management Console, SAS Enterprise Guide, SAS DI Studio, SAS CI Studio, SAS Add in Microsoft Components), Base-SAS 9.2 & 9.4, SAS-Macros, SAS/CONNECT, SAS/GRAPH, PROC SQL, SAS Environment Manager, SAS-Administration.

Ab Initio: Informatica

Data Base: Oracle 9i, Netezza, SQL Server, DB2, Teradata

Operating Systems: Windows, AIX and RHEL

PROFESSIONAL EXPERIENCE:

Confidential

Team Lead

Responsibilities:

• Successfully completed the SAS software upgrade from SAS 9.4 M3 to SAS 9.4 M7 version.
• Successfully completed the SAS Customer Intelligence Studio application upgrade from 6.4 to 6.6 version.
• Successfully completed the operating system upgrade from RHEL6 to RHEL7 version.
• Performed the SAS Teradata TTU client version upgrades from 1 .10 version and 1 .20 version.
• Have worked on analyzing the Nexpose vulnerabilities reported on the SAS servers and applying fixes for those vulnerabilities.
• Performed SAS system administration support, monitoring servers and performance of systems for proper sizing and capacity to function within expectations.
• Extensively worked on creating user profiles for new users and modifying the privileges for existing users through SAS Management console.
• Created libraries for various databases like Oracle, SQL Server, DB2, SAS datasets and registered tables for those libraries through SAS Management console and SAS Data Integration studio.
• Created the ODBC connection setup for the Maria DB and SQL server databases and get it successfully connected to from various SAS Applications.
• Identified and applied fixes for cleaning up Security vulnerabilities reported on the SAS Platform Servers.
• Work on various SAS client installations and upgrades such as SAS EG, SAS DI Studio, SAS Add in Microsoft plugins etc.
• Scheduling the campaign process flow through the LSF scheduler and to maintain the LSF services.
• Worked on SAS maintenance release version upgrade and installation of SAS client tools for various users.
• Performed SAS system maintenance activities by bringing down/bring up the SAS services and validating them through SAS management console and SAS EG to ensure proper functioning of the SAS environment.
• Created database connections using SAS management console for various databases like Oracle, SQL server, DB2, Teradata etc.
• Developed Unix shell scripts and windows batch scripts and successfully automated the SAS Services start and stop process across Unix, Linux and windows servers through IWS jobs.
• Worked with multiple users and brought the GPFS mount space within threshold and created a dashboard through splunk and automated the GPFS mount space monitoring process.
• Performed decommission of RMPO servers from the SAS existing environment and successfully carried out the server decommissioning process.
• Analyzed problems occurred within SAS system find the root cause and applied fixes for the issues.
• Performed SAS releases and deployed SAS Data Integration studio jobs to QAT and Production environments.
• Applied and validated SAS License keys over Dev, QAT and Production environment.
• Worked on various user created incidents and fixed issues in various SAS components such as SAS Enterprise Guide, SAS Data Integration Studioand SAS Management Console.
• Performed vendor technical support management with SAS Institute like creation and escalation of vendor support tickets up on various issues.
• Worked with the SAS Institute and applied hot fixes performed testing and implemented changes as per the recommendations provided by the vendor.
• Worked in Informatica administration support and having good experience in performing Informatica administration TASKs.
• Successfully completed Informatica power center upgrade from 10.1 to 10.4.1 version in AIX platform.

Confidential

Team Lead

Responsibilities:

• Supported and maintained SAS merchandising application suite Size profiling & pack optimization and Mark down optimization have very good technical and functional knowledge on these applications.
• Worked as a SAS Admin, supported and maintained the SAS Applications and SAS Servers.
• As a SAS Admin have good experience in maintaining the SAS services bringing down and bring up the SAS Instances and validating the SAS applications.
• Have good knowledge in SAS Management console and involved in adding new users to the SAS environment, creating SAS Libraries and SAS Groups.
• Worked with SAS Institute in resolving admin related issues with Size profiling & pack optimization and Mark down optimization applications.
• Applied SAS hotfix in the middle tier environment of the SAS Size profiling & pack optimization application by coordinating with SAS Institute.
• As a SAS Admin involved in SAS License renewal by coordinating with SAS
• Institute.
• Worked with the business users and resolved their requests and created ad hoc reports for their analysis.
• Have good knowledge in Splunk app and automated various SAS process through splunk application.
• Worked in many AVM related applications like Service now, Splunk, ESP Scheduling and Netcool alerts etc. and have good knowledge in them.
• As a team lead, I involved in coordinating with the offshore team and explained them the business in terms of enhancement and daily support of our applications.
• Fixed/Resolved issues and applied permanent fixes for problems occurred with SAS applications
• Fine-tuned some of the SAS process codes to have better performance and save lot of time for the business.
• Supported Informatica processes across all merchandising applications and worked on problem fixes in Informatica.
• Fine-tuned Informatica jobs and fixed various problems with Informatica jobs and implemented successfully.
• Supported Merchant Tool Kit Pricing applications which involve SAS and Informatica.
• Worked in Service now application and have good knowledge in creating and maintaining incidents, problems and changes using service now.
• Fined tuned Informatica jobs source queries to show better performance and to improve the process run times.
• Developed SQL queries in Oracle Exadata, DB2 and Netezza for analyzing the issues and applied permanent fix for those issues.
• Supported and enhanced Netezza sql scripts for Marketing - CIA application.

Confidential

Team Lead

Responsibilities:

• Developed SAS codes to create Executive Dashboard reports in order to view the week level sales trends over various channels, Group purchasing organizations (GPO’s) etc
• Developed SAS macros for frequently used procedures and data steps which in turn reduce the time in resolving the Data Warehouse adhoc projects
• Developed SAS codes to create the weekly Sales Analytics reports for the products PROLIA and XGEVA in order view the performance of the products against its competitors in PMO and SRE Markets respectively
• Involved in developing SAS codes in order to resolve the business analytics queries raised by the clients on requirement basis
• Provided support for the above developed report on Weekly basis and developed QA/QC process for the same

Confidential

Team Lead

Responsibilities:

• Involved in development of SAS codes to create reporting tables which will be used for product launch analysis by end users for their analytical needs
• Involved in fetching the source data from ORACLE database into the SAS server in order to perform the user requested analytics queries on calls data
• Involved in customer calls level analysis to view the sales representative’s calls performance over each customer.
• Involved in product launch analysis for XGEVA and PROLIA to compare its sales against the SRE and PMO market products respectively
• Developed a customer view report which shows the detailed information about the customers and their corresponding sales over the products PROLIA and XGEVA by week
• Handled a key role in performance improvement of the current business unit. Responsible for all the deliverables sent from offshore after exhaustive and extensive quality checks

Confidential

Team Member

Responsibilities:

• As a team member I owned the entire responsibility and delivery of modules for Oncology business unit and Corporate Accounts business unit from offshore
• Involved in developing SAS codes for creation of new reports and enhancement of the existing report
• Involved in Analyzing and understanding business requirements and data to provide sales reports
• Provided support for the regular reports (Weekly and Monthly) and developed QA/QC process for the same
• Created documentation of the Weekly and Monthly Reports describing the business rules involved in each report