Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Srinivasa SKN Ambati

Srinivasa SKN Ambati

Richmond,VA

Summary

Results-driven professional with over 18 years of experience in the IT industry, specializing in the design, development, and administration of software applications across various Analytical Platforms such as SAS, SAS Viya, AWS, Hadoop, BigData, Python and Multi Cloud Technologies like AWS, AZURE and GCP and AI based tools. Adept at leading and executing software architecture implementation, upgrades, and migration strategies. Extensive experience in cloud technologies, data warehousing, ETL, RDBMS, and business intelligence solutions. Strong communicator with proven ability to lead teams and work collaboratively with stakeholders across all levels.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Engineer Lead

Elevance/ANTHEM INC
06.2019 - Current
  • Lead the creation of data solutions that support analytics, Business Intelligence (BI), and advanced Cloud and AI based applications
  • Ensure the architecture supports the development of data visualization tools, dashboards, and reporting systems
  • Establish policies for data governance and data quality
  • Implement secure data architectures to manage sensitive and confidential data, adhering to industry standards and regulations
  • Define and maintain the access control policies for data assets to ensure authorized use
  • Evaluate and select appropriate tools, platforms, and technologies for data management, analysis, and reporting
  • Keep up-to-date with emerging technologies and trends in the data and analytics domain (Big Data, Cloud, AI, etc.)
  • Design architectures that can scale to handle increasing volumes of structured and unstructured data
  • Optimize the architecture for high performance in data processing, storage, and retrieval operations
  • Work closely with business stakeholders to understand data needs and translate business requirements into technical solutions
  • Collaborate with cross-functional teams, including Data Engineers, Data Scientists, and Developers, to implement data solutions
  • Design solutions for efficient data lifecycle management, ensuring data is captured, stored, and archived appropriately
  • Define policies for data retention, backup, and recovery
  • Develop comprehensive documentation of the data architecture, models, and processes
  • Establish and enforce data architecture standards and guidelines across the organization
  • Establish monitoring systems to track data quality, system performance, and data processing activities
  • Create and manage disaster recovery plans and ensure system resilience
  • Manage and oversee the installation, configuration, and maintenance of SAS and SAS Viya suite, Python, RStudio, Datameer, and other cloud-based analytical tools
  • Lead the migration of SAS systems and architect LSF-based SAS GRID architecture
  • Coordinate with cross-functional teams to develop and implement future technology roadmaps
  • Ensure system stability by managing resources and addressing capacity planning, licensing, and patch updates
  • Develop and maintain automated scripts to optimize operations and reduce manual workload
  • Environment and Platforms: Multiple Analytical Systems which includes but not limited to SAS Grid Computing, R, Python, Datameer and LSF, AIX, SAS EBI, SAS RTM, UNIX Shell Scripting, Big Data Analytical tools
  • Multi Cloud Technologies like AWS, GCP and IBM Cloud platforms

BI Developer Advisor

Elevance/ANTHEM INC
05.2014 - 06.2019
  • As a Developer Advisor, I was responsible for managing the multiple analytical systems at anthem which includes but not limited to Install, Configure and Maintain such as SAS and SASViya suite of products, Python, Rstudio, Datameer and other Cloud Analytical tools
  • Responsible for evaluating and implementing new innovative and market leading analytical technologies by updating existing architecture like Implementing LSF based new SAS GRID architecture, Migration of SAS from older version of SAS to latest version of SAS like SAS Viya, SAS Visual Analytics, Python, Rstudio, Datameer and other Cloud Analytical tools
  • Defining a different types of future Application and Technology road maps needed to fill the business needs in the Data and Analytics space
  • Capacity planning and work on adding resources as and when needed to upgrade the systems in terms of CPU, Memory and etc
  • Integration and Configuration of new advanced technologies like Cloud based Analytical tools and other advanced technologies like Redshift, Snowflake etc
  • Install and configure such as SAS Viya, SAS Visual Analytics, Python, Rstudio, Datameer and other Cloud Analytical tools
  • Install and configure different Database engines like Hadoop, Netezza, Sybase, Netezza, Greenplum
  • Provide new updated client versions like, SAS EG, AMO, OLAP, IMAPs etc
  • Work on Job scheduling functionality on GRID for users and Admin activities
  • Work on legacy system user migration to newly built SAS GRID environment
  • Proactively monitor the SAS product licensing and apply them on time to avoid the disruption of services of installed products
  • Keep monitor the system and analyze the required hotfixes and apply them on regular basis to keep the system up-to-date
  • Coordinate with Project Teams and Application teams to keep the system up to date by installing all required technology patches
  • Proactively monitor the system resource utilization (Space, memory, cpu etc...) and take necessary corrective actions
  • Analyze issues and fix them as per SLAs and make sure to have the RCAs in place of the issues occurred
  • Support users to resolve their issues quickly to gain their confidence on new system
  • Finding simple & innovative solutions to make the things easy to address the recurring issues
  • Make sure to document the problem, solutions and corrective actions for each issue
  • Make sure to document each and every system change that part of day to day routine works
  • Develop smart automated scripts to reduce the manual dependency in day to day operations
  • Lead Vendor Support teams
  • Environment and Platforms: Multiple Analytical Systems which includes but not limited to SAS Grid Computing, R, Python, Datameer and LSF, AIX, SAS EBI, SAS RTM, UNIX Shell Scripting, Big Data Analytical tools
  • Multi Cloud Technologies like AWS, GCP and IBM Cloud platforms

Sr. Associate

COGNIZANT
11.2013 - 05.2014
  • As SAS Lead Administrator, I was responsible for Analysis, Design, implementation and support of SAS Anti-Money Laundering (AML 5.1) system and successfully build the built HA Architecture (High Availability Architecture) by scaling the current system for AML 5.1 system
  • Responsible for Designing and Implement the stall and Configuration of SAS AML5.1 based on the design specifications, including scenarios, thresholds, and workflows
  • Develop ETL (Extract, Transform, Load) processes to ingest data into the SAS AML system
  • Ensure data mapping aligns with the system’s requirements
  • Defining and updating the SAS Metadata for the User Authentication and Data Management
  • Configuring the PAM Authentication with SAS and ADS Servers
  • Troubleshooting of all SAS and performance tuning
  • Regular Maintenance of the system like Install SAS Hot fixes, Maintenance upgrades, SAS License renewal process and Its Management
  • Securing the SAS configuration and maintaining the High Availability
  • Monitoring the Servers and maintaining the regular server backups
  • Setup and secure the data sources connections
  • All other Administrative tasks
  • Environment: SAS Anti-Money Laundering (AML 5.1) system, Linux, Oracle and Websphere7

Technical Lead

IBM
05.2011 - 11.2013
  • As SAS Lead Administrator, responsible for Analysis, design, implementation and support of RAMP (Rapid Analytics and Modeling Platform) project for deriving business insights from data, In-depth analysis capabilities, and powerful predictive modeling environment to achieve increased merchant demand for Card acceptance at American Express Network Products/Services
  • Responsible for evaluating and implementing new innovative technologies by updating existing architecture like Implementing LSF based new SAS GRID architecture, Migration of SAS from SAS9.2 to SAS9.3, Migrating stand alone Citrix Servers to VSS (Volume Shadow Copy Services) farm for SAS Client tool access
  • Integration and Configuration of new cutting edge technologies like Netezza, Hadoop and Zementis PMML (Predictive Model Markup Language) and so on
  • Defining and updating the SAS Metadata for the User Authentication and Data Management
  • Identifying the security gaps in the architecture fix them as per company standard compliance process
  • Leading a project team in delivering solution to our customer American Express in the financial and Data warehousing sector
  • Deliver new and complex high quality solutions to clients in response to varying business requirements
  • Interact with Technology Strategy Team to develop Reference Architecture for Analytics
  • Modeling and BI (Business Intelligence) Solutions
  • Evaluate various tools, technology and make critical technical decisions on design and use of technology and tools as acceptable by American express technology team
  • Responsible for planning, tracking, change control, Design and Development aspects of the project using Subversion tool
  • Responsible for budget and schedule Planning, Control and reporting of project to Customer
  • Responsible for understanding business needs and converting into functional requirements after deep analysis
  • Responsible for effective communication between the project team and the customer
  • Provide day-to-day direction to the project team and regular project status to the customer
  • Establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results using cutting edge solutions in Data warehousing and Business Intelligence using SAS suite of BI products
  • Utilize in-depth knowledge of Technical experience in SAS, Unix Shell Scripting, C and other leading-edge technology in conjunction with industry and business skills to deliver solutions to customer
  • Development and support of SAS ETL jobs, batch programs (shell scripts and batch programs)
  • Customer query handling and adhoc reporting
  • Responsible for Module Design, testing, support and Development aspects of the project
  • Responsible for effective communication between the module team and the customer
  • Establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results
  • Utilize in-depth knowledge of Technical experience in SAS, shell scripting and other leading-edge technology in conjunction with industry and business skills to deliver solutions to customer
  • Environment: SAS Grid Computing and LSF Windows2003, Citrix Metaframe, AIX, Base SAS, SAS Macros, Customized BI tools in SAS (e.g
  • SAS DI Studio, SAS ETL, SAS EM, SAS EG, SAS Management Console), Unix Shell Scripting, C, XML

Application Developer

IBM
08.2010 - 05.2011
  • Worked as a SAS Tech lead and SAS Administrator, As a SAS lead responsible for coordinating the offshore&Onsite teams and the customer for the Project GART2.0
  • GART 2.0 is a global analysis and reporting system for warranty claims, vehicles, dealers and other early warning quality data to reduce GM warranty costs and frequency while continuing to improve GM product quality
  • GART 2.0 is developed to support a common set of processes for all business units to use for quality analysis and reporting
  • GART 2.0 application uses a custom application solution using SAS v9.2 components like SAS thick clients such as SAS Enterprise Guide, SAS Enterprise Miner, and SAS Text Miner
  • SAS Add-in for Microsoft Office (AMO), and SAS web applications such as SAS Web Report Studio (WRS), SAS Information Map Studio (IMS), SAS Information Delivery Portal (IDP)
  • The Query and Reporting User can have access to summarized and raw data
  • Implementation of Q&R tools and access will be managed by GM based on the processes and governance models established between IS&S and business teams
  • Responsible for SAS BI Administration, installation & Configuration of SAS BI Servers, troubleshooting the Servers during outages, Metadata Management using SAS Management Console, Start/Stop services, etc
  • Responsible for assigning the permissions to the users in SAS Portal and in Enterprise Guide using SAS Management Console
  • Responsible for creating ETL and Data campaign codes using SAS V9
  • Implementing Error Handling and Automation of ETL scripts for the application
  • Generating weekly and monthly graphical reports using SAS Enterprise Guide
  • Analyze Defects / Fix Defects using the ticket handling system Remedy
  • Maintaining the Change Control and Version control for the codes using PVCS version Control tool
  • Checking data from CARD 3.0 and other interfaces is available to GART 2.0 Application
  • Delegating work to the offshore team members and monitor the progress
  • Participate in the weekly Business meetings to identify the potential data corrections / update using data campaign activities
  • Creating high and detail level design for the new developments as well as for the new change requests
  • Involved in the code-fix, code review and deployment process for the quality of deliverables
  • Environment: SAS9.2 & 9.1, base SAS, SAS/Macro, SPDS 4.4, SAS/Share, Enterprise Guide 4, SAS Management Console, SAS/AMO, IBM AIX 5.3, Xythos, WebLogic 8.1.6, SAS Portal (IDP), SAS Stored Processes, Unix/Shell Script

Sr. Software Engineer

IBM
11.2008 - 08.2010
  • As a SAS Administrator responsible for product upgrading, product installing, performance tracking and tuning, administrating of customized SAS application(GART) for our client General Motors
  • SAS BI 9 application server is the base technology which supports GART2.0 application
  • This application has various other SAS products like SAS Management Console, SAS Enterprise Guide etc
  • The on-shore resource should have enough SAS experience with more SAS Administrative skills
  • Impact Analysis on SAS 9.1 migration SAS 9.2 which includes SAS Servers & Components, Operating System, SPDS (Database), DB2, Weblogic, DB2, JDK/JRE and other client tools
  • Installation, configuration and administration of All SAS9.1.3 and 9.2 components which includes Content, Configuration stored in metadata, Stored processes definitions + Codes, building a custom themes
  • Installation, configuration and administration of client tools Enterprise Guide, AMO, Stored Process
  • Implement Performance changes to GART Phase 1 to improve the Reports Performance by up to 10 times – Redesigned the Data Models and SAS code for UI Reporting to improve performance
  • Setup the Phase 2 environment so that it co-exists with Phase 1 on the same Server
  • Support EDS with Data Management
  • Implemented the specified changes to the ETL process using SAS
  • Implemented Error Handling, Automation of ETL scripts for Phase 1
  • Analyze Defects / Fix Defects / Support in Regression Testing the defects for Phase 1
  • During the 2nd half of the project my role was more of a SAS BI Administrator installing SAS hotfixes, troubleshooting the Servers during outages, Metadata Management using SAS Management Console, Start/Stop services, etc
  • Involved in the SAS Server migration from p590 to p595 and testing to ensure that everything was migrated correctly
  • Utilize in-depth knowledge of functional and Technical experience in SAS and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer
  • Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals
  • Gathering customer requirements, analysis of requirements into design, coding, testing and production releases
  • Responsible for managing scope, planning, tracking, change control aspect of the project
  • Monitoring of service center tool to check for new or updated change requests from the client IT management or end users
  • Resolving problem/ incident requests in the production environment
  • Regular status meets with client to provide the status on the effort on the different assigned change requests and enhancements in service center
  • Implemented Error Handling, Automation of ETL scripts for Phase 1
  • Analyze Defects / Fix Defects / Support in Testing the defects
  • Developed the Shell scripts to automate the Daily&Weekly ETL process
  • Performed data corrections based on the new business rules defined by GM business
  • Environment: SAS9.2 & 9.1, base SAS, SAS/Macro, SPDS 4.4, SAS/Share, Enterprise Guide 4, SAS Management Console, SAS/AMO, IBM AIX 5.3, Xythos, WebLogic 8.1.6, SAS Portal (IDP), SAS Stored Processes, Unix/Shell Script

Sr. Software Engineer

IBM
05.2007 - 11.2008
  • As a Senior Software Engineer responsible for Analysis, design, development, testing and implementation of customized SAS application (QWIK) for our client General Motors USA
  • The Quality With Information and Knowledge (QWIK) application is an analytical tool that provides vehicle quality data in a number of forms including reports, charts, and raw data files
  • QWIK brings the ability to obtain a variety of GM vehicle quality information to the user’s desktop
  • Performing daily maintenance/support to the QWIK application as assigned
  • Gathering customer requirements, analysis of requirements into design, coding, testing and production releases
  • Responsible for managing scope, planning, tracking, change control aspect of the project
  • Monitoring of service center tool to check for new or updated change requests from the client IT management or end users
  • Resolving problem/ incident requests in the production environment
  • Regular status meets with client to provide the status on the effort on the different assigned change requests and enhancements in service center
  • Implemented Error Handling, Automation of ETL scripts for Phase 1
  • Analyze Defects / Fix Defects / Support in Regression Testing the defects
  • Environment: SAS 8.02, SAS/Graph, SAS/IntrNet, SAS/STAT, SAS/CONNECT, Unix/Shell Scripts, SAS AF, SAS/Share

Sr. Software Engineer

Synova Innovative Tech Pvt Ltd
04.2006 - 05.2007
  • As a Software Engineer responsible for Analysis, design, development, testing and implementation of customized SAS applications (QWIK and Warranty Eye) for our client IBM and General Motors US and Europe
  • The Quality with Information and Knowledge (QWIK) application is an analytical tool that provides vehicle quality data in a number of forms including reports, charts, and raw data files
  • QWIK brings the ability to obtain a variety of GM vehicle quality information to the users desktop
  • The Warranty Eye application is a management reporting tool, application is a website that is deployed on web server
  • The report content of the website is generated using programs developed using different SAS Tools
  • The navigational part of the application is developed in HTML and JavaScript
  • Performing daily maintenance/support to the applications assigned
  • Gathering customer requirements, analysis of requirements into design, coding, testing and production releases
  • Responsible for managing scope, planning, tracking, change control aspect of the project
  • Monitoring of service center tool to check for new or updated change requests from the client IT management or end users
  • Resolving problem/ incident requests in the production environment
  • Regular status meets with client to provide the status on the effort on the different assigned change requests and enhancements in service center
  • Implemented Error Handling, Automation of ETL scripts
  • Created reports as per the Client requirement
  • Resolving the Tickets and Abends based on Severity
  • Analyze Defects / Fix Defects / Support in Regression Testing the defects
  • Resolving the Tickets and Abends based on Severity
  • Environment: SAS 8.02, SAS9.1 SAS/Graph, SAS/IntrNet, SAS/STAT, SAS/CONNECT, Unix/Shell Script, DB2

Education

Master of Science - Computer Science

Osmani University
India
04-2003

Bachelor of Science - Computer Science

Kakatiya University
India
04-2001

Skills

  • Architectural Design: Experience in designing scalable, fault-tolerant, and distributed data systems Familiarity with microservices, containerization (Docker, Kubernetes), and serverless architectures
  • Business Intelligence & Data Analytics: Proficiency in Python, SAS (SAS Viya, SAS Grid Manager, SAS Visual Analytics, SAS Enterprise Miner, SAS Model Manager), Datameer, RStudio, Hadoop/BigData Analytical tools
  • Integration Architecture: Knowledge of API-driven integrations for real-time or batch data exchange
  • Cloud Technologies: AWS (Certified Solutions Architect), Google Cloud Platform (GCP), Private Clouds
  • Data Security and Compliance: Strong understanding of data encryption, masking, and anonymization techniquesKnowledge of compliance frameworks like GDPR, CCPA, HIPAA, etc
  • Data Analysis: Strong analytical skills to derive insights and idnteify trends from dataFamiliarity with statistical and predictive modeling techniques
  • RDBMS: Oracle (SQL, PL/SQL), DB2, Teradata, MS SQL Server, Netezza, Sybase, Greenplum
  • Operating Systems: Linux, Windows, IBM AIX, Sun Solaris
  • DevOps for Data Analytics: CI/CD pipelines for data workflows using Jenkins, GitHub Actions, or similar tools Infrastructure-as-Code tools like Terraform, CloudFormation, or Ansible
  • Version Control Tools: GitHub, BitBucket, PVCS, Tortoise SVN
  • Project Management: PMP Certified, Budget Development, Risk Management, Data Gathering,Critical thinking

Certification

  • Project Management Professional (PMP)
  • Amazon Web Services (AWS) Certified Solutions Architect Associate
  • SAS Base Certified
  • Datameer Administration Certified

Timeline

Engineer Lead

Elevance/ANTHEM INC
06.2019 - Current

BI Developer Advisor

Elevance/ANTHEM INC
05.2014 - 06.2019

Sr. Associate

COGNIZANT
11.2013 - 05.2014

Technical Lead

IBM
05.2011 - 11.2013

Application Developer

IBM
08.2010 - 05.2011

Sr. Software Engineer

IBM
11.2008 - 08.2010

Sr. Software Engineer

IBM
05.2007 - 11.2008

Sr. Software Engineer

Synova Innovative Tech Pvt Ltd
04.2006 - 05.2007

Master of Science - Computer Science

Osmani University

Bachelor of Science - Computer Science

Kakatiya University

Similar Profiles

CREATE PROFILE
Srinivasa SKN Ambati