Vish Rao
Irvine,CA
Summary
Senior Information Security Consultant specializing in ServiceNow integrations and vulnerability management. Developed risk scoring systems and optimized workflows, enhancing incident response. Led integrations with industry-leading tools, utilizing REST APIs and agile methodologies to deliver impactful solutions.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Sr Information Security Consultant
Innovate Solutions
Atlanta, GA
03.2023 - Current
- Led integrations with Rapid7, Prisma Cloud, and Vericode within ServiceNow VR.
- Developed a dynamic risk scoring system and customized UI/UX for vulnerability tracking.
- Help with reports from complex DB views with custom label functions.
- Troubleshot integration bottlenecks and managed updates via XML and Update Sets.
- Technologies: ServiceNow Vulnerability Response, Rest APIs, ITIL, Rapid7, Prisma Cloud Compute for Container Vulnerabilities, Vericode for Application Vulnerabilities, etc.
Sr Info Security Specialist
US Bank
Minneapolis, MN
11.2014 - 03.2023
- Migrated Tenable custom integration to ServiceNow OOTB, customizing workflows, macros, and notifications to enhance operational efficiency.
- Built end-to-end integrations with Fortify and Prisma Cloud using Flow Designer and REST APIs.
- Designed orchestrations for Data Theorem mobile app findings into VR modules.
- Maintained ServiceNow platform documentation and policies while coordinating agile updates to ensure compliance and streamline processes.
- Technologies: ServiceNow Vulnerability Response, Flow Designer, Integration Hub, Rest API, Data Theorem, Twistlock, BitSight, Tenable, Fortify, BlackDuck, Data Theorem, AWS, Microsoft Defender, GiT Hub, SCM, Javascript, Python 3.0
Sr Info Security Specialist
Elavon
Atlanta, GA
11.2014 - 08.2017
- Operationalized Tenable integrations and implemented deduplication across sources.
- Integrated vulnerability data from FireEye, WhiteHat, CheckMarx, and more into ServiceNow.
- Built metrics reporting engine using Python for compliance dashboards.
- Connected ServiceNow with RSA Archer for GRC data sync.
Sr. Database/Data Architect Consultant
Genuine Parts Company
Atlanta, GA
12.2012 - 11.2014
- Supported NAPA Auto core systems, managed builds/releases, led offshore team.
- Enhanced transactional retail data models using Oracle, PL/SQL, and ERWin.
- Create data models and database designs to store and access data efficiently.
- Optimized existing databases using query tuning and indexing techniques.
- Developed data models for applications, metadata tables, views, and related database structures.
- Developed audit logging and job control frameworks in DataStage and Teradata.
- Created Tableau dashboards and mentored junior ETL developers.
- Performed root cause analysis on technical issues related to the BI stack components.
- Optimized T-SQL stored procedures to improve performance of BI solutions.
- Provided expertise in data modelling, ETL development, and reporting for Microsoft SQL Server Business Intelligence solutions.
- Assisted in developing test plans for verifying accuracy of data transformations within ETL packages.
Sr BI Consultant
Norfolk Southern
Atlanta, GA
05.2011 - 11.2012
Lead Technical Specialist
Emory Healthcare
Atlanta, GA
03.2008 - 05.2011
- Led ETL projects for healthcare data integration using DataStage and Oracle.
- Architected HL7 data parser and optimized PL/SQL pipelines.
- Designed, tested, implemented, and maintained complex software systems.
- Led the resolution of escalated technical issues in a timely manner to ensure customer satisfaction.
Sr. BI Consultant
Solvay Pharmaceuticals
Marietta, GA
05.2006 - 03.2008
- Integrated CRM system using Oracle Streams and PL/SQL-based ETL.
- Built Java stored procedures and optimized DB performance using Statspack.
- Monitored server performance metrics like CPU, disk space, and memory usage.
- Collaborated with stakeholders to identify requirements for new BI solutions and enhancements of existing ones.
Education
M.B.A. - Finance
Robinson School of Business
AtlantaM.S. - Computer Science
Texas A&M University
TexasB.S. - Structural Engineering
National Institute of Engineering
IndiaSkills
- Agile/ Scrum
- AWS
- Black Duck
- Business rules
- CI/ CD
- Custom CI Lookup rules
- Data Theorem
- Evaluator functions
- Exceptions
- Firenze
- Flow Designer
- Fortify
- GCP
- GitHub
- Host import maps
- Incident response
- IRM
- ITIL
- ITOM
- JavaScript
- Microsoft Defender
- MySQL
- Nessus
- Oracle
- PL/SQL
- Palo Alto Prisma Cloud
- Python 30
- Qualys
- Rapid7
- Remediation Rules
- REST APIs
- Risk calculation
- Secure SDLC
- Security Tools
- ServiceNow Development
- Severity mapping
- SQL Server
- Postures
- Tenable
- Teradata
- UI Policies
- Vericode
- Vulnerability Response
- XML/ XSLT
Certification
- Certified Holistic Information Security Practitioner (HISP)
- Certified SOX Professional
- Oracle Database Administration
Timeline
Sr Information Security Consultant
Innovate Solutions
03.2023 - Current
Sr Info Security Specialist
US Bank
11.2014 - 03.2023
Sr Info Security Specialist
Elavon
11.2014 - 08.2017
Sr. Database/Data Architect Consultant
Genuine Parts Company
12.2012 - 11.2014
Sr BI Consultant
Norfolk Southern
05.2011 - 11.2012
Lead Technical Specialist
Emory Healthcare
03.2008 - 05.2011
Sr. BI Consultant
Solvay Pharmaceuticals
05.2006 - 03.2008
M.B.A. - Finance
Robinson School of Business
M.S. - Computer Science
Texas A&M University
B.S. - Structural Engineering
National Institute of Engineering