Sas Etl Data
Resume:
SURYA CHANDRA KALAPATI
(SAS & Hadoop & DataStage & Tableau LEAD ADMINISTRATOR)
*********@*****.***
PROFESSIONAL SUMMARY:
SAS & Tableau Administrator and Programmer with 10+ years of experience in Administrator, analyzing and troubleshooting in various Pharmaceutical and SAS on Windows, LUNIX environment, SAS administration, SAS VA administration.
Administerting and Configuring Tableau 2019.x and 2021.x versions, managing and maintening current tableau environments.
EBI Administration with a background in LINUX/ UNIX with 24*7 on-call user and production support in Banking, Health Insurance and Pharma Domain.
4+ years of Tableau Server Administration including Installation, patches, configuration, security and HA (High Availability) in Enterprise Platform.
Proficiency in administartoring on SAS (9.4M4 -6), Hadoop (Cloudera/Hprtonworks), Informatica Power Center (9.0 -10.0), Data Stage (9.x, 10.x, 11.x), AWS.
Extensive hands on experience in SAS BI on, SAS 9.1.3 and SAS 9.2, SAS 9.3, SAS 9.4 platforms including GRID administration, SAS Connect, SAS OLAP Server, SAS Metadata Server, SAS Object Spawned, SAS Information Delivery Portal, SAS Management Console, SAS Enterprise Guide, SAS OLAP cube Studio, SAS Data Integration Studio, SAS Web Report Studio, SAS Connect Server, SAS Web Infrastructure Platform, SAS Enterprise Miner and SAS VA(Visual Analytics) Administration.
Experienced in SAS administration for High Availability within GRID environment including Metadata, MidTier and GRID Control Servers.
Installating and Configuring the Data Stage 11.5 & 11.7 versions.
Installating and Condiguring Tableau 2019.1.x – 2021.x versions in windows.Supports for any upgrades of newer versions.
Implementation of SAS EBI, EDI, EM, MM, TM, MDM, FS & VA Tools on SAS versions 9.2, 9.3 & 9.4, suite of products.
Adding Users, Groups, Roles and registering tables, etc. using Management Console. Creating new folders in the metadata repository and collecting the Logs data from the SAS Management console.
Installation of client applications and Troubleshooting technical problems.
Strong experience working with Oracle on UNIX using command line and GUI SQL tools.
Tracking applicable SAS hot fixes and creating implementation plans for respective SAS modules and applications.
Monitoring SAS Server resources and reporting usage(s).
Identifying performance and recommending/implementing tuning of active SAS environment(s) providing projected capacity shortfalls.
Good understanding of the SAS Web tier and SAS Server Tier Architecture with excellent troubleshooting skills.
Designing, implementing, and maintaining security on SAS Metadata and Linux for users.
Designing, implementing, and executing the change control and promotions tasks in SAS.
Establishing best practices and guidelines for SAS BI usage.
Provide guidance and assistance to SAS Developers on operational and technical issues interfacing with the SAS Institute for Support on administrative and system issues.
Experience in using SAS Enterprise Miner, storeprocess, and SAS Enterprise guide.
Experience in ETL Extraction and loading data. Data Stage and Informatica tools data extract process.
Experience in automation of SAS Jobs using the cron and Autosys in Linux. Task scheduler in windows.
Experience in Linux Patches and Windows Patches tools Like GFI.
Experience on Linux file systems NAS, SAN mounts, physical volume and LVM .
Successfully increased portability of existing SAS programs and created new programs using SAS macro variables to improve efficiency and consistency of the reports with macros.
Experience in SSO (singal – sign on) security domins and handling the authacation Errors.
Hadoop servers installation and cluster load balarces maintenaces. Hadoop agents installation process handling (Amberi Server and Amberi agent).
In the SAS Servers agents installed for the continuously monitoring of the server health and services health (Zabbix proxcy and Zabbix agent).
Experience in SAS VA reports building and Web report studio. Package migration to lower environment to higher environments.
Experience Store process packages deployment process and SAS Codes migration process with the release management Team.
Storng knowledge in Creating and maintaining system documentation. Documenting the small issues in server level and application errors troubleshooting.
Proficient in Macro Facility, SAS Procedures, SAS formats, SAS functions, SAS statements, SAS Informants, Merging SAS Data sets, preparing data, producing reports, storing and managing data
Proficient in using Import and Export procedures to handle data in raw data files ORACLE, DB2, TERADATA.
SAS software Upgrades, hot fixes and License. Worked in 9.3 and 9.4 hotfixes and patchs.
Strong analytical, diagnostic skills and ability to work in a fast-paced and team- oriented environment.
Power BI/ SAS /AWS LEAD Administrator
BLUESTEM BREADS, Topeka,KS. OCT 2022 to Present.
Bluestem Brands is a multi-brand portfolio of e-commerce companies that serve a broad range of customers throughout the U.S. The company's subsidiaries include Appleseed's, Blair, Draper's & Damon's, Fingerhut, Gettington, and Haband, among others.
Responsibilities:
Responsible for SAS 9.4 M5 & 6 AWS Administrator maintenance issues and Administrator and Developer.
Upgrade, Installation and configuration of Enterprise Tableau Environment.
Managing and Administroring Viya 3.5 with AWS and Environments on Unix/Linux. CAS server monitoring & CAS table state management.
Administerting DataStage 11.5 and 11.7 complete suite installation and configuration in Linux environment with strong knowledge of UNIX commands and operating system .
BI administration in key areas such as Security, System Utilization/Capacity, Performance tuning/Optimization, and Issue troubleshooting and root cause analysis.
Configuration of different Database connections like SQL, DB2, Oracle.
Administerting and Configuring Tableau 2019.x and 2021.x versions, managing and maintening current tableau environments.
Should have knowledge on Datastage Projects creations, permissions issues, Users Creation and assigning required roles in all environments.
Should have knowledge on Datastage Designer, and Director.
Managing Operating SAS Viya servers and services.
Created SAS Depots for SAS 9.3 & 9.4 and related client installation documents
Support SAS user base application related issues. Good Understanding of SSO Oracle product and proxy (IIS ).
SAS client software installations on PC, laptop and Virtual Desktops via remote access.
Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
Engaging with business users and team to support Tableau Platform.
Provide support to security team and SAS Team. Oracle OAM and OEM product handling experinces.
Preparing shell scripts for starting and stopping SAS services like metadata server, object spawned, connect server, share server, etc. and also mid-tier services like SAS application service, Web logic SAS Managed server.Work closely with the database team, network team, BI team and application teams ensuring that all the SAS jobs are performing as expected.
Prepared the script for Metadata cleanup. SAS ECM, SAS SNA Application maintenance and creating new cases related to the fraud.
Administerting and Configuring Tableau 2019.x and 2021.x versions
Responsible for Managing SAS Visual Analytics (VA) for Distributed system. SAS VA Dashboards reports sending to clients every monthly data.
Responsible for loading data in LASR analytic server.
Responsible for Administration of Tableau Dashboards and Integrating within Tableau Platform.
Working expriances on creating New jobs using the ETL Data stage tool and working on different tools like Data stage, informatica, and SAS data Integration Studio.
Create SAS user accounts, SAS libraries and Database libraries. Adding Users, Groups, Roles and registering tables, etc. using Management Console. Creating new folders in the metadata repository and collecting the Logs data from the SAS Management console.
Responsible for in DR fail-over activities. Operations production support issues handling and providing with the right solution.
Environment: SAS 9.3/9.4 M3, SAS GRID, Unix, Linux, IBM /AIX, WINDOWS, SAS/EG, SAS Eminer, SAS/ SMC, SAS VA 7.3, SAS JMP, SAS EVM, SAS DI STUDIO, Teradata, Tableau, Data Stage, PUTTY.
Capacity planning and estimating the requirements for lowering or increasing the capacity of the SAS Grid Nodes.Monitor the SAS and Hadoop connectivity and performance.
Prepared the script for Metadata cleanup.
Familiar with data and content migration using SAS migration utility for products that relay on metadata.
Have used SAS/ETL for extraction of information and then transforming and loading the information to target.
SAS AND HADOOP/DataStage/Tableau LEAD Administrator
GainWell /HP-DXC Technologies, Topeka,KS. May 2016 to SEP 2022.
Kansas Department of Health and Environment (KDHE), has selected HP to upgrade the state’s Medicaid Management Information System (MMIS). Kansas SURS/FADS unit will use SAS Fraud Detection System and HP PIUR to maintain and operate Program Integrity. With these newly developed and advanced tools, the unit will be even more effective in carrying out its primary directive, which is identification of anomalies in the Medicaid claims data, which encompasses both fee-for-service claims, and encounter transactions. This unit will be the primary user of the below tools offered to meet the requirements for Program Integrity.
Responsibilities:
Responsible for SAS 9.4 Administrator maintenance issues and SAS VA 7.3M3 Administrator and Developer.
Administering SAS 9.4 M7 in stand-alone and multi-tier Grid Environments on Unix/Linux. Other products such as Enterprise Guide, Enterprise Miner.
Administering SAS Viya 3.5 with multi-tier CAS Environments on Unix/Linux. CAS server monitoring & CAS table state management.
Administerting DataStage 11.5 and 11.7 complete suite installation and configuration in Linux environment with strong knowledge of UNIX commands and operating system.
Experiences in managing tableau administrators.
Expriance with Hadoop servers and install of the Hadoop Node’s and maintenaces of the ambari agent and proxy in the Hadoop servers. Hadoop 2.x cluster installation and handling of HDFS & MAPPER.
Administerting DataStage 11.5 and 11.7 complete suite installation and configuration in Linux environment with strong knowledge of UNIX commands and operating system
Configuration of different Database connections like SQL, DB2, Oracle.
Should have knowledge on Datastage Projects creations, permissions issues, Users Creation and assigning required roles in all environments.
Should have knowledge on Datastage Designer, and Director.
Managing Operating SAS Viya servers and services.
Responsible for Migration from SAS 9.3 to SAS 9.4.data migration to Dev to Test and Test to prod.
Monitoring and maintaining SAS server activities. Install of Zabbix agent’s and proxy to morintoring the SAS Servers health and Day to day monitoring of the SAS Applications like(SAS ECM,SNA,VA and WRS).
Created SAS Depots for SAS 9.3 & 9.4 and related client installation documents
Support SAS user base application related issues. Good Understanding of SSO Oracle product and proxy (IIS ).
Troubleshoot basic application issues on SAS Environment and other components. Working on SAS enterprise case management case creation and disposition the cases from SAS SNA or SFF to SAS ECM.
SAS client software installations on PC, laptop and Virtual Desktops via remote access.
Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
Provide support to security team and SAS Team. Oracle OAM and OEM product handling experinces.
Preparing shell scripts for starting and stopping SAS services like metadata server, object spawned, connect server, share server, etc. and also mid-tier services like SAS application service, Web logic SAS Managed server.Work closely with the database team, network team, BI team and application teams ensuring that all the SAS jobs are performing as expected.
Capacity planning and estimating the requirements for lowering or increasing the capacity of the SAS Grid Nodes.Monitor the SAS and Hadoop connectivity and performance.
Prepared the script for Metadata cleanup. SAS ECM, SAS SNA Application maintenance and creating new cases related to the fraud.
Responsible for Managing SAS Visual Analytics (VA) for Distributed system. SAS VA Dashboards reports sending to clients every monthly data.
Responsible for loading data in LASR analytic server.
Successfully completed the SAS JMP application installation.
Worked with SAS Support team for SAS VA 7.3 issues overview.
Working expriances on creating New jobs using the ETL Data stage tool and working on different tools like Data stage, informatica, and SAS data Integration Studio.
Create SAS user accounts, SAS libraries and Database libraries. Adding Users, Groups, Roles and registering tables, etc. using Management Console. Creating new folders in the metadata repository and collecting the Logs data from the SAS Management console.
Responsible for in DR fail-over activities. Operations production support issues handling and providing with the right solution.
Environment: SAS 9.3/9.4 M3, SAS GRID, Unix, Linux, IBM /AIX, WINDOWS, SAS/EG, SAS Eminer, SAS/ SMC, SAS VA 7.3, SAS JMP, SAS EVM, SAS DI STUDIO, Teradata, HADOOP, Sybase, PUTTY.
SAS GRID ADMINISTERING
Capgemini Technology, Fort Wayen,Indian.
MAY 2015 – APR 2016
Description: The consultant will ensure and manage a large and complex Mutli-tier SAS environment. This candidate should have experience administering SAS and GRID. This person will need to have an in depth knowledge of SAS and GRID administration, installation, configuration, monitoring and problem resolution.
Administering SAS 9.4 in stand-alone and multi-tier Grid Environments on Unix/Linux. Other products such as Enterprise Guide, Enterprise Miner.
Converted ORACLE data tables into SAS data files using SAS SQL Pass through Facility uploaded SAS data files into ORACLE tables using SAS db load procedure.
Configured Apache Web Server, Tomcat and SAS Intelligence platform mid-tier Web applications, R, SAS, and PYTHON.
Established DB connections like Oracle and SQL server connections from the grid.
Developed programs using the LIBNAME statement &SAS Views to extract & report error statistics.
Install, configure SAS, SAS Grid, Platform LSF on various environments Monitor SAS jobs on the Grid, assist users on code optimizations.
Used Microsoft Access and Excel to provide output analysis data, Integrate and embed a robust reconciliation and control process throughout the tool.
Successfully used Proc Means to calculate means, standard deviation, sum, median of data. .
Successfully created the reports using the ODS/HTML. Documentation analytic requirements, maintaining standards in the SAS Platform.
Performed time series analysis for prediction using SAS forecasting studio of the change in the meal plan price.
Designed and created SAS datasets from various sources like Excel datasheets, flat files and Oracle, creating reports and files from existing SAS datasets.
Familiar with data and content migration using SAS migration utility for products that relay on metadata.
Have used SAS/ETL for extraction of information and then transforming and loading the information to target.
Used SAS datasets to create reports using Proc Print and Reports. Also used Proc Transpose, Proc Tabulate, Proc Import, Proc Freq, and Proc SQL, developing/administering an R environment supporting an SAS environment, Queries and complex analytics.
Environment: SAS 9.4 on Unix and Windows platform, SAS EG, SAS OLAP Cube Studio, SAS Web Report Studio, SAS/ACCESS, SAS/CONNECT, SAS/Macro, SAS/SQL, SAS/ GRAPH, SAS/STAT, SAS/ETL, Excel, Access.
SAS Developer/Administrator
HDFC Bank,Chennai,In . APR 2010 to APR2013
This project involved in supporting SAS users. Supporting users in various aspects like Application support, Renewal of license, hot fixes and so on, taking backups, restoration. Access related, files archive and restore, file access support for different departments.
Responsibilities:
Responsible for SAS 9.3 and SAS 9.4 EBI Platform Administrator maintenance issues.
Access rights to SAS applications renewal of SAS license and hot fixes on SAS server.
Tested and administered SAS GRID, new tools and modules, GRID configuration and Linux environment.
Creating metadata repositories for each department and giving access rights.
Automation of new jobs and control-M monitoring Code suggestions.
Changing User Id permissions using Smitty, SAS Management Console
Create ACTs.
Created SAS Depots for SAS 9.3 & 9.4 and related client installation documents,
Maintaining Servers & troubleshooting.
Communicate and jointly work with IT departments, database administrators and business lines.
SAS client software installations on PC, laptop and Virtual Desktops via remote access.
Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
Hotfix, backup, and maintenance release installations of the SAS environments,
Preparing shell scripts for starting and stopping SAS services like metadata server, object spawner, connect server, share server, etc. and also mid-tier services like SAS application service, Web logic SAS Managed server.
Hotfixes for SAS Enterprise Guide. Environment: SAS 9.3 9.4, Linux, WINDOWS, SAS/EG, SAS DI Studio, PC SAS, SAS Eminer, SAS VA 7.2, SAS/OLAP, SAS/WRS, SAS/SMC, SAS/AMO.
TECHNICAL SKILLS:
SAS Tools: SAS 9.1/9.2, SAS/BASE, SAS/ACCESS, SAS/ Enterprise Guide.
ETL Tools: Data Stage and Informatica.
SAS Procedures: Proc Print, Means, Univariate, Report, Summary, Tabulate, Freq,
Sort, Format, Copy, Compare, Gplot, functions, Template, Compare, Import, Export, options, Transpose.
Languages: SAS/SQL,C, C++, and SAS Programming.
Office tools: MS office 2003/2007/2010, Word, Excel and PowerPoint.
Operating Systems: Windows XP/2000/98, Linux/UNIX.
Education:
Master of Science in Engineering Management AUG 2013 to APR 2015
Trine University, Angola, Indiana.
Bachelor of Engineering in Electronic and Instrumentation. MAR 2006 to MAR 2010
Jawaharlal Nehru Technological University
Contact this candidate