Sas Admin
Resume:
Chaitanya Medasani adex3h@r.postjobfree.com
PROFESSIONAL SUMMARY:
Over 12+ years of IT experience including SAS administration, SAS Grid administration, and SAS Viya
Extensive hands on SAS 9.1.3, 9.2, 9.3, 9.4 and Viya administration including Base SAS, SAS Management Console, SAS Metadata Server, SAS Enterprise Guide, SAS Enterprise Miner, SAS Object Spawner, SAS Stored Process Server, Work Space Server, Data Integration Studio, Web Report Studio, SAS Information Delivery Portal, SAS OLAP Server, SAS Studio, SAS Customer Intelligence, SAS Real Time Decision Manager, SAS Merchandise Intelligence Server, SAS Stratum Risk Governance and Frame work and SAS Connect server
Experienced in migrating from one datacenter to other datacenter
Experience in migrating users and data from SAS 9.2 to SAS 9.3 on UNIX environment
Experience in migrating users and data from SAS 9.4 to SAS9.4 from Solaris to Linux
Experience in migrating from RHEL6 to RHEL 7
Excellent installation & configuration experience of SAS servers and client applications in grid environment
Installation and configuration experience of Platform LSF, RTM for SAS grid environment
Experienced in installing, configuring and supporting web applications like Tomcat, Apache, and JBoss
Experienced and good knowledge on IBM Spectrum Scale (GPFS) file system
Experienced on Disaster Recovery
Responsible for monitoring, reporting and controlling SAS server usage
Possess extensive experience in analyzing problems and resolving issues of end users
Experience in Ticket and Change Management products and procedures
Experience in providing 24/7 call support for production environment and L3 support
Experience in migrating SAS from Oracle cloud Gen 1 to Oracle cloud Gen2
Technical Skills:
SAS BI Tools : Base SAS, SAS 9.1.3, 9.2, 9.3 9.4 & SAS Viya
: SAS Enterprise Guide 4.1, 5.1, 6.1, 7.1 & 8.3
: SAS Enterprise Miner 6.1, 7.1, 12.1 & 14.1
: SAS Web Report Studio 4.2, 4.3, 4.4
: SAS OLAP Studio 4.3, SAS Studio 3.4
: SAS Merchandise Intelligence Server
: SAS Customer Intelligence and RTDM
: SAS Stratum IRM
Operating Systems : Solaris, Red Hat Linux, AIX & Windows
Storage : SAN EMC & NAS Isilon
File System : GPS, ZFS and IBM Spectrum Scale (GPFS)
Databases : MSSQL, Oracle, Teradata & Hadoop
Middle – tier : Web Sphere, Apache & Tomcat
Service Management Tools : HP SM, Remedy & Service Now
CITI Credit Card Services,
Engineering Lead Analyst – Vice President
Jacksonville, FL Sep 2021 – Present
Responsibilities:
Responsible for leading a variety of engineering activities including the design, acquisition and deployment of hardware, software and network infrastructure in coordination with technology team
Coordinating between business end users and SAS supports on various project works and issues
Administering SAS grid environment, SASViya installed and configured on Red Hat Linux & Solaris
Serving as a technology subject matter expert for internal and external stake holders and provide direction for all firm mandate controls and compliance initiatives
Ensure that all integration of functions meet business goals
L3 support activities like creating change requests and troubleshooting SAS and infrastructure related issues and ensuring the overall SAS grid health.
Supporting various third party applications like NDM that connect using SAS and downstream applications
Setting up Autosys jobs to perform SAS Metadata Sync and adding required Positions for Stratum Risk Application
Performed various admin activities such as Metadata backup/restore, SAS servers refresh & hot fix/patch installations for SAS 9.4 M7
Maintaining Yearly SAS licenses for all SAS servers, platform LSF and SAS LASR servers
Created Metadata folders for each group and assigned permissions to that group only. Created Metadata objects such as Libraries, users, groups and projects, etc
Configured F5 load balance VIP’s for web tools
Installed the client applications on user’s machines and worked with desktop support team to create SAS packages
Responsible for Access control Management & user privileges
Responsible for tuning and providing best practices recommendations to user community
Support backup/restore the data using cold backups
Responsible for failover/failback to DR
Monitoring the incidents and create report for audit purpose and make sure there is no SLA breaches with proper updates
Configure/Establish connectivity from SAS to various databases like MSSQL, Oracle, Teradata and Hadoop
Starting and stopping the whole SAS during the maintenance activities and outages.
Monitoring the SAS services, filesystem and server resources usage and ports using different SAS tools like Environment Manager
Monitoring CPU, I/O and memory using NMON
Setup scripts for cleaning the SAS work space, orphaned processes, rolling logs nightly and setup clean work utility
Configure security using Unix ACL’s and SAS ACT’s
Created various service now templates for users to create incidents related to various SAS platforms and environments
Created training/informative documents for users such as how to onboard to Grid platform, how to use different client and web tools like EG, SASGSUB, SAS studio, Enterprise Miner, and Stratum IRM applications. etc
Responsible for on call production support
Yugady Technologies & Services Inc,
Applications Developer
Client: Horizon
Johns Creek, GA Aug 2020 – Sep 2021
Responsibilities:
Administering SAS grid environment installed and configured production environments in Red Hat Linux & AIX
Installed and configured second Mid-Tier node and configured High Availability
Performed various admin activities such as Metadata backup/restore, SAS servers refresh & hot fix/patch installations for SAS 9.4 M7
Configured SASPY
Yearly SAS licenses for all SAS servers, platform LSF and SAS LASR servers
Created Metadata folders for each group and assigned permissions to that group only. Created Metadata objects such as Libraries, users, groups and projects, etc
Configured F5 load balance VIP’s for web tools
Installed the client applications on user’s machines and worked with desktop support team to create SAS packages
Responsible for Access control Management & user privileges
Responsible for tuning and providing best practices recommendations to user community
Participate in weekly meetings with client Horizon
Prepared periodic status report and shared with agreed stakeholders
Support backup/restore the data using cold backups
Responsible for failover/failback to DR
Monitoring the incidents and create report for audit purpose and make sure there is no SLA breaches with proper updates
Configure/Establish connectivity from SAS to various databases like MSSQL, Oracle, Teradata and Hadoop
Starting and stopping the whole SAS during the maintenance activities and outages.
Monitoring the SAS services, filesystem and server resources usage and ports using different SAS tools like Environment Manager
Monitoring CPU, I/O and memory using NMON
Setup scripts for cleaning the SAS work space, orphaned processes, rolling logs nightly and setup clean work utility
Configure security using Unix ACL’s and SAS ACT’s
Work closely with users to resolve their issues and SAS TS as needed
Created training/informative documents for users such as how to onboard to new Grid platform, how to use different client and web tools like EG, SASGSUB, SAS studio, Enterprise Miner, SASPY etc
Responsible for on call production support
Macys Technology,
Senior Systems Engineer
Johns Creek, GA Oct 2017 – June 2020
Responsibilities:
Migrated SAS 94 M3 from oracle cloud gen 1 to oracle cloud gen2
Upgraded SAS 94 M3 to SAS 94 M6
Installed and configure Metadata Cluster on already established SAS 94 M3 non-prod and production environments in Red Hat Linux
Updated the host names with server alias names
Installed and configured second Mid-Tier node and configured High Availability
Performed various admin activities such as Metadata backup/restore, SAS servers refresh & hot fix/patch installations for SAS 9.4 M3
Performed various admin activities such as Metadata backup/restore, hot fix/patch installations and security patches for SAS 9.4 M3
Yearly SAS licenses for all SAS servers, platform LSF and SAS LASR servers
Created Metadata folders for each group and assigned permissions to that group only. Created Metadata objects such as Libraries, users, groups and projects, etc
Configured F5 load balance VIP’s for web tools
Installed the client applications on user’s machines and worked with desktop support team to create SAS packages
Supporting SAS Real Time Offers servers where Macys provides real time offers to their customers in online and stores
Responsible for tuning and optimization of SAS Campaigns that run using SAS Customer Intelligence Studio, SAS Marketing Automation, SAS Marketing Optimization and monitoring the daily triggered campaigns
Supporting SAS Real Time Decision Manager servers where Macys provide real time offers to their customers in their 650+ stores
Supporting SAS Size Optimization application that run using SAS Merchandising Intelligence client and profile editor
Set up and support SAS Size daily and weekly jobs for Size optimization using control-m
Support backup/restore the data using cold backups
Monitoring the incidents and create report for audit purpose and make sure there is no SLA breaches with proper updates
Configure/Establish connectivity from SAS to various databases like MSSQL, Oracle, Teradata and Hadoop
Starting and stopping the whole SAS during the maintenance activities and outages.
Monitoring the SAS services, filesystem and server resources usage and ports using different SAS tools like Environment Manager and third-party tools Kibana, Soap UI and Dynatrace
Monitoring CPU, I/O and memory using NMON
Setup scripts for cleaning the SAS work space, orphaned processes, rolling logs nightly and setup clean work utility
Configure security using Unix ACL’s and SAS ACT’s
Work closely with users to resolve their issues and SAS TS as needed
Responsible for on call production support
BioInfo Systems LLC,
SAS Administrator
Client: PNC BANK, OH Mar 2016 to Oct 2017
Responsibilities:
Installed and configured SAS 9.4M3 Grid environment on GPFS shared file system with AFM and Asynchronous replication to DR site on RHEL platform
Migrated different applications (LOB’s) from standalone Solaris to RHEL grid platform
Migrated data from one data center to another datacenter
Handling data compatibility issues using PROC Migrate, PROC CEXPORT and PROC CIMPORT
Installed and configured LSF 7.1 & 9.1
Configured LSF queues for work load balance
Configured Kerberos authentication
Performed various admin activities such as Metadata backup/restore, hot fix/patch installations for SAS 9.4 M3
Yearly SAS licenses for all SAS servers and platform LSF in SAS9.4 grid environment
Created Metadata folders for each group and assigned permissions to that group only. Created Metadata objects such as Libraries, users, groups and projects, etc
Configured F5 load balance VIP’s for web tools
Installed the client applications on user’s machines and worked with desktop support team to create SAS packages
Responsible for Disaster Recovery fail over and fail back testing
Support backup/restore the data using GPFS snaps and Avamar
Monitoring the incidents and create report for audit purpose and make sure there is no SLA breaches with proper updates
Configure/Establish connectivity from SAS to various databases like MSSQL, Oracle, Teradata and Hadoop
Compiling Unix odbc drivers and libraries for database connectivity
Created training/informative documents for users such as how to onboard to new Grid platform, how to use different client and web tools like EG, SASGSUB, SAS studio, Enterprise Miner, etc
Created few other documents such as Database connectivity, Incident Management, Mainframe Connectivity from SAS, etc,.
Monitoring the incidents and create report for audit purpose and make sure there is no SLA breaches with proper updates
Configuring production jobs and scheduling through CA7
Starting and stopping the whole SAS grid during the maintenance activities and outages.
Monitoring the SAS grid services, filesystem and server resources usage and ports using different SAS and third-party monitoring tools like RTM, Environment manager, Zenoss, ITCAM, etc,.
Promoting code between different environments using Udeploy and GIT repositories
Setup scripts for cleaning the SAS work space and orphaned processes and setup cleanwork utility
Configure security using Unix ACL’s and SAS ACT’s
Work closely with users to resolve their issues and SAS TS as needed
Responsible for on call production support
Bio Info Systems LLC. March 2012 to June2015
Software Test Analyst
Client: Deloitte
Worked for Deloitte Touché for client Department of public Welfare of Pennsylvania and involved in a project with iCIS (Integrated client information system), iCIS sub systems has COMPASS (Common Point of Access for Social Services), eCIS (Electronic Client Information System) and CIS (Client Information System).
Responsibilities:
Leaded the team of 5 people and project manager to plan and implement the testing effort for one of the module for ACA initiative and
Worked with a team of 25 on various Work Orders and Maintenance initiatives within the iCIS project
Analyzing and reviewing Business Requirement documents/Functional Requirements and Use Case documents.
Preparing Test strategy detailing test approach, data used, & test environments.
Prepared high-level test scenarios and test cases.
Created and executed system, regression, negative & positive test cases using Automated Tracking System (Internal Tool used by DPW) & Microsoft Test Manager
Performed Regression testing using QTP & Microsoft Test Manager
Executed test cases to determine the eligibility of various benefits offered by DPW
Experienced in determining the eligibility for various benefit programs like Medical Assistance, Cash Assistance, Long Term Living, Select Plan for Women, Family Works, Child care works, Low Income Home Energy Assistance Program (LIHEAP)
Preparing the Test results along with data used to execute test cases.
Interacting with the business team for the requirements and also interacting with developers.
Worked on various initiatives within the iCIS project
Worked on Affordable care act (Obama Care) to ensure the developed software is working as per the design
Experienced in Mainframe testing & batch testing
Used Oracle SQL Developer to run the query to retrieve the data from the data base
Used SOPA UI to generate XML scripts.
Responsible to validate the Eligibility Results
Experienced in validating 834 files, Monthly Standalone files
Experienced in issuing EBT (Electronic Benefit Transfer) cards, OTI amount (One Time Issuance)
Responsible to manage Medical Providers & LIHEAP providers using CP Admin & Financial Management Modules
Experienced in working with data exchanges by calling web services
Experienced in validating the Client Notices that are generated through nightly batch process
Responsible for defect logging and tracking using Team Foundation Server
Implement test schedule, track defects and assigning them to developers based on the priority.
Maintain defects report and status.
Overall test execution report has been maintained and reported to the management on daily basis
Infoville Inc, NJ Feb 2010 to Sep 2010
Sr. QA Analyst
Client: Edifecs
Worked for Edifecs - The Edifecs5010™ Solution helps healthcare organizations navigate the complexities posed by the HIPAA 5010 migration requirements. The Edifecs5010™ Solution uniquely combines the capabilities of the Edifecs Healthcare Suite with online services, consulting services, tools and guidance to provide step-by-step guidance for HIPAA 5010 migration upgrade.
Responsibilities:
Analyzing and reviewing Business Requirement documents/Functional Requirements and Use
oCase documents.
Preparing Test strategy detailing test approach, data used, & test environments.
Prepared high level test scenarios and test cases.
Responsible for preparing automation framework using automation tool QTP.
Created and executed system, regression, negative & positive test cases.
Performed Regression testing using QTP
Executed test cases to verify implementation and configuration of Edifecs software.
Preparing the Test results along with data used to execute test cases.
Interacting with the business team for the requirements and also interacting with developers.
Performed System Integration Testing to ensure Edifecs product has been integrated within BCBS-MA.
Performed User acceptance testing.
Experience in validating HIPAA 1-5 level validations for all real time and batch files.
Responsible for validating the generation of acknowledgements whenever a claim fails HIPAA 1-5 level validations.
Good understanding in EDI 4010A and EDI 5010 transactions.
Experience in validating HIPAA X12 files for 834 Enrollments, 270/271 Eligibility Inquiry/response, 276/277 claim status and notification, 837(I, P, D)/835 claims and Remittances, 820-Health plan premium payments & 999 0r 997 acknowledgements.
Testing the JMS queues for splitting the claims at transaction level.
Experience in validating healthcare claims.
Real time execution status using Quality center that will provide BCBSMA with date/time stamps/status of execution at test case level on daily basis.
Provided fixes for critical & high severity bugs during testing.
Worked closely with the client BCBSMA project team with training planning
Wrote & Executed SQL queries used for data validation.
Extensively worked on validating data loads during ETL process
Implement test schedule, track defects and assigning them to developers based on the priority.
Maintain defects report and status.
Overall test execution report has been maintained and reported to the management on daily basis.
Master Labs INC, Aug 2008 to Feb 2010
Programmer Analyst
Client: Free Life
Worked for Free Life - Free Life is a global enterprise, yet Free Life’s web sites do not consistently reflect that global perspective. They do not deliver actionable information on Free Life’s products and services in a customer-oriented fashion to all of our local markets. Language, Free Life’s complex organizational structure, lack of search engine relevance and poor site design, all create barriers to our customers getting the product information that they need to learn about and access Free Life’s products and services via web.
Responsibilities:
Analyzed and Reviewed Business Requirement Documents/Functional Requirement Documents (&RDD), Use Case Documents
Created Test plan, Test strategy, and Performance Test Plan and User Acceptance Test plan in an Agile (Scrum) Methodology.
Defined activities required to prepare for and conduct Functional Testing, Integration Testing, Regression Testing, GUI Testing, Backend Testing, Performance Testing and User Acceptance Testing
Responsible for reviewing Test Cases & creating the Traceability Matrix
Created Users and maintained all the requirements, User Stories, Tasks in Rally
Executed test cases and the recording of test results in Rally
Created Test automation scripts for QTP to test UI
Developed and executed a complete end-to-end test strategy for assigned products and features including verification of functionality, performance and scalability.
Continuously streamlined and improved the testing life cycle to ensure test planning, execution, and reporting are effective and coordinated.
Wrote & Executed SQL queries to validate data saved in database
Maintaining the defect status for every release for management review.
Interacted with Business Team for the requirements and also interacting with developers.
Maintained team Defects report though Quality Center and reported to the management on daily basis
Reported to Test Admin when defect was closed.
Infovision Solutions PVT Limited June2006 to Jan 2008
Chennai, India
QA Analyst
Infovision solutions provide various software solutions to various clients like ABN, HSBC, AMEX credit card services to track and maintain the credit card holder information. Developed a eCOMMERCE application for the clients to achieve the desired results and to reach the goal
Responsibilities:
Worked with the team of 3 people and the project manager to plan and implement the testing effort.
Worked for ABN & HSBC credit cards within Infovision Solutions
Reviewed design documents and business requirements used to create Test plan.
Analyzed System specification document, business requirement document and developed both manual and automated test scripts.
Performed both manual testing and automated testing
Performed regression testing, smoke testing, Performance testing and end-to-end testing
Used Unix to check the performance of the application
Developed and executed SQL queries as part of backend testing
Developed Test Metrics and conducted Defect Logging and Reporting
Responsible for complete functional and regression testing using Quick Test Pro.
Responsible for setting the environment, creating the scenarios based on the performance test objectives, setting the monitors, running the scenarios and analyzing the test results.
Conducted Compatibility Testing of the site on different browsers, different versions of browsers and different Operating Systems.
Performed baseline testing ensuring functionality and performance of the application is improved and not degraded compared to earlier builds.
Performed data driven testing
Logged defects using PVCS.
Regularly interacted with business teams and development teams regarding bugs.
participate in weekly meetings and provided timely status reports
EDUCATION:
Post Graduate Diploma in Computer Applications.
Bachelor’s Degree in Computer Science.
Certificates:
SAS Training completion in SAS Marketing Automation – Defining the Data and Structure for Campaigns
SAS Training completion in SAS Marketing Automation – Designing and Executing Outbound Marketing Campaigns
SAS Training completion in SAS Marketing Optimization – Maximum Campaign Efficiency
Contact this candidate