Ranadeep Reddy Dasari
GRC Consultant
Dallas,TX
Summary
A Qualified IT Professional with 9+ years of experience including 7 years of experience as Archer GRC Consultant. Experience on RSA Archer with full lifecycle implementation of GRC solution including requirements analysis, design, configuration (e.g., user navigation, workflow, access control, data feeds, reports, Workspace, Dashboards, iView’s and package migration). Comfortable handling RSA Archer Control Panel for trouble shooting of issues. Hands on experience working in Risk Management, Compliance Management, Vendor Management, Incident Management, Finding and Policy Management solutions. Involved in End-to-end Archer development process. Have hands on experience with Questionnaire, Applications, Fields, Events, Notifications, Reports, iViews and Dashboards, Complex Calculated Fields, Custom Workflows, Training and Awareness Campaigns, Datafeed. Gained experience with Privacy Technologies such as One Trust. Expertise on Archer solution definition, Solution design and configuration of both on demand applications and all Core Solutions. Configuring access control on Solution level, application-level, record-level and field-level access control. Exceptional ability to analyze business processes for automation purposes, while balancing and prioritizing activities to meet deadlines and quality expectations. Understanding of IT service management (ITSM) and the ITIL business process. Maintain service level agreement (SLA) and monitor an SLA workflow. Creating High Level and Low-Level Design documents designs, Data Dictionary, Data migration plan, Test scripts which are used for testing the applications by the client. Worked on RSA Archer 5.x and 6.x versions. Experienced in configuring Single-Sign-On and LDAP in the RSA Archer platform. Continuously seeks to improve work processes that impact self, team members and the Customer Relationship Management (CRM) experience. Hands on experience in Writing JavaScript Custom Objects & HTML codes to meet requirements. Thorough and meticulous Financial Risk Specialist accomplished in helping organizations manage investment, industry-specific and general economic risks. Detail-oriented in reviewing data and identifying impactful trends. Brings great presentation and interpersonal communication skills.
Overview
8
8
years of professional experience
4
4
Certifications
Work History
GRC Consultant
American Airlines
04.2020 - Current
- Responsible for collecting requirements, designing, and implementing RSA Archer applications in the eGRC environment
- Create custom data feeds that connect to various data sources to import and modify data within Archer applications
- Responsible for handling Regulatory & Corporate Compliance, Issues Management, Operational Risk Management, IT Security Risk management and Policy Program Management Modules
- Collaborated with the GRC team on the development of the GRC solution, Experience with having contact with support to get resolutions/fixes for application issues/ enhancements
- Reviewed existing systems and processes against the GRC framework and prioritized remediation plans based on business risk
- Assisted Directors, Managers and other Internal Audit team members to fully engage in the risk assessment process and principles
- Identified and evaluated complex business and technology risks, internal controls to mitigate risks and related opportunities for internal control improvement
- Compiled and submitted regular reports to update senior management on operations and progress
- Developed and documented Operational risk management systems
- Involved in Integrating Archer with One Trust & Cherwell applications
- Experienced in rebuilding search index on Archer application
- Imported existing information from legacy systems into RSA Archer Applications and questionnaire
- Developed and implemented disaster recovery plans and quarterly tests to ensure successful data recovery offsite
- Performed system administration such as disk management system problem and change management
- Expertise in Archer Control Panel with General Settings, Database, single sign-on and Data Feed Manager setting configuration
- Troubleshooting Services running on Archer Web and Application Server for example Queuing, Data feed, Job Framework configuration, job framework service, job processor
- Analyze business problems and develop solutions in archer to resolve existing issues
- Hosting workshops to gather additional requirements from business
- Providing pointers/training to other team members on how to develop, maintain, and troubleshoot functionality
- Played a key role in Applications Architecture to work with client Governance teams to align with the Enterprise Architecture standards and roadmaps
- Involved in upgrading Archer platform from 6.5 to 6.9 and 6.13 P1.
GRC Consultant/Archer Developer-Admin
Toyota Financial Services
02.2019 - 03.2020
- Work with business teams, including stakeholders, project managers and business analysts, to develop the organization’s IT GRC capabilities through development of the RSA Archer solution using RSA Archer 6.x
- Analysis of existing core and 'on-demand' applications in RSA Archer to facilitate business process improvements to meet client needs in RSA Archer v6
- Involved in team grooming sessions for finalizing the user stories for sprint
- Attended the daily Scrum standup meetings and provided updates on user stories
- Assisted with Risk Control Self-Assessments (RCSAs) to include monitoring RCSA requests, requesting pre-assessment documentation
- Handle incidents and service requests independently raised through ServiceNow and provide root cause analysis and effective resolutions on time to avoid SLA breach
- Configure Archer applications based on technical requirements using SDLC concepts and agile methodology
- Helped assess risks in accordance with the company’s risk hierarchy, coordinate risk response and corrective action plans, and develop Operational Risk Management reporting and dashboards
- Responsible for raising support tickets with RSA and co-ordination to get the issues resolved
- Supporting additional 'on-demand' applications, questionnaires, and custom authoritative source content for clients in Archer v6
- Responsible and maintained new datafeeds for HR data migration from legacy systems (Workday)
- Maintained Solution dictionaries and prepared client documents (both technical and functional)
- Developed several questionnaires to meet various needs specified by clients including Vendor Assessment, PCI self-assessments and others
- Involved in UAT and developed Qtest scripts for UAT.
RSA Archer Developer/Admin
Santander Consumer USA
07.2017 - 12.2018
- Gather the requirements from business to customize the core solution to fit as per their requirements
- Develop on-demand applications, Questionnaires
- Workflows based on calculated fields, dynamic record permissions, events and notifications
- Setup user accounts and groups according to the security needs
- Create Payment Card Industry Data Security Standard (PCI DSS) related control procedures and PCI system and application inventory SAQ categories
- Creating Reports, Workspaces, Dashboards
- Configured Archer to Archer Data feeds
- Develop mail merge template
- Develop custom objects in Archer using Java script
- Migrate the code from one environment to other using packages
- Work with RSA on SaaS platform issues
- Interfaced with team leaders, identify and analyze the given information, procedures and decision flow.
RSA Archer BSA
CVS HealthCare
02.2017 - 06.2017
- Worked closely with developers, business stakeholders and acted as an integral part of the software development team using iterative development process
- Developed and executed test scripts for custom data feeds that connect to various data sources to import and modify data within Archer applications
- Performed Failure testing and penetration testing for the backend services
- Hosting workshops to gather additional requirements from business units
- Introducing possible approaches to meet requirements as well as benefits and issues with each approach allowing client to make final determination on strategic direction
- Worked in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims
- Documented Runbook, FRD’s
- Worked on data import and data export feature
- Modify / create new access roles for new / existing Applications
- Prepared test cases, test scenarios and performed User Acceptance Testing (UAT)
- Drive the client review meetings, prepare, and brief weekly status reports for the issues/requests addressed.
GRC Consultant/Archer Developer-Admin
Wells Fargo
10.2016 - 01.2017
- Experience with Archer core solutions, on-demand applications, and data feeds
- Experience creating fields, reports, iViews and dashboard experience in configuring access control, record permissions, events and notifications
- Field creation and configuration - cross-reference fields, calculated fields, custom value lists
- Managing access control of the users on Archer
- Adding new users to the platform rapid application development tools
- Workflows based on dynamic record permissions, events and notifications
- Creating fields, reports, iViews and dashboards and configuration of workspaces and reports
- Creation of questionnaire from scratch
- Configuring access control using application-level, record-level, and field-level access control functionalities of archer
- Worked on Calculations, Data-Driven-Events and Reports
- Designed Compliance Assessment in Archer as per customer requirement
- Worked on Access Control feature in Archer
- Worked on various types of Data Feeds like Archer-to-Archer web services, FTP, HTTP & Database transporter
- Troubleshooting and administration of Archer web server
- Worked on generating weekly Digest Notification, mail merge and campaigns
- Worked on Packaging for Archer solutions and analysis of issues/warnings
- Responsible for raising support tickets with RSA and co-ordination to get the issues resolved
- Perform package migration activity for new releases
- Automatic and manual generation of findings.
SQL DBA/BSA
Xpress Global IT Solutions
8 2010 - 06.2013
- Maintained various client databases in MS SQL Server 2000, 2005, 2008, 2008R2 versions
- Wrote stored procedures for ease of administration and management
- Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance of the SQL Server
- Scheduled maintenance on databases and capacity planning to increase performance and productivity
- Administer client reports using Reporting Services (SSRS) in native and SharePoint integrated mode
- Troubleshoot and minimize production down issues
- Created and implemented, scheduled maintenances and backup procedures to the database to enhance overall performance and disaster recovery methods
- Extensive use of DTS/SSIS and scripting for various ETL processes
- Maintained 60 plus database instances in dev, test, stage and prod
- Performed SQL Server database consolidations, migrations, upgrades and downgrades
- Configured and Managed Standby databases using Log Shipping
- Installed, configured, and maintained SQL Server Clusters
- Implemented Backup and Restore in SQL Server using Third party tools like LITESPEED and Sandpiper
- Actively involved in capacity planning
- Co-ordinated with Oracle team on various administrative and development activities
- Apply security updates/patches on Oracle Databases
- Perform Oracle backups and recovery
- Installed Oracle clients
- Actively involved in the upgrade of oracle databases from 9i to 10g.
Education
Bachelor of Technology in Computer Science Engineering -
AIIT
Master’s in software engineering - undefined
Stratford University
Master’s in Management Science of Information Technology - undefined
Campbellsville University
Skills
Windows
Certification
One Trust Certified Professional
Timeline
GRC Consultant
American Airlines
04.2020 - Current
GRC Consultant/Archer Developer-Admin
Toyota Financial Services
02.2019 - 03.2020
RSA Archer Developer/Admin
Santander Consumer USA
07.2017 - 12.2018
RSA Archer BSA
CVS HealthCare
02.2017 - 06.2017
GRC Consultant/Archer Developer-Admin
Wells Fargo
10.2016 - 01.2017
SQL DBA/BSA
Xpress Global IT Solutions
8 2010 - 06.2013
Bachelor of Technology in Computer Science Engineering -
AIIT
Master’s in software engineering - undefined
Stratford University
Master’s in Management Science of Information Technology - undefined
Campbellsville University