SUMMARY

• Overall 7 years of solid experience in IT industry with unparalleled accomplishments in various lines of work.
• RSA Archer Certified Administrator with strong experience in implementation, configuration and integrate RSA Archer’s GRC solution framework into business processes.
• Rigorous professional experience in eGRC platform with a focused approach to develop/modify the applications ensuring an exceptional end - product delivery to the LOB.
• Experience in RSA Archer v5.x and v6.x platforms and understanding of configuration features and back-end processes.
• Experience in using Out of the Box Archer Solutions - Enterprise Management, Policy Management, Risk Management, Vendor Management, Incident Management and Issue Management.
• Strong working experience in On-demand Applications, Workspaces, Questionnaires, Sub-Forms, Advanced Fields, Calculations, Data Driven Events, Subscription Notifications, Reports, iView’s, Dashboards, Access Roles.
• Experience in Integrating Archer System with Upstream Archer Data Feeds and Publishing Archer Data to Downstream Applications using Data Publication Services and significant knowledge on Archer Schema.
• Experience in managing SQL Server Databases and creating SQL scripts for business reporting.
• Experience in Server Maintenance, Monitoring Job processes and Infrastructure upgrades.
• Experience in Packaging, installing packages and manual deployment.
• Have good Analytical skills & problem-solving attitude towards trouble shooting issues and enhance productivity in work.
• Worked in Banking & Financial Services and Telecom Industries. Experience in troubleshooting and debugging in the event of issues.

TECHNICAL SKILLS

GRC Tools: RSA Archer

Operating Systems: Windows Server 2008/12, Unix/Linux

Web Technologies: .Net, HTML

Ticketing Tools: JIRA, BMC Remedy

Data Base/scripting languages: SQL Server 2012, Oracle.

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

RSA Archer Admin/Developer

Responsibilities:

• Configuration of the RSA Archer platform with effective solutions and applications that support variety of business needs and to achieve organizational objectives.
• Experience in using Out of the Box Archer Solutions - Enterprise Management, Policy Management, Risk Management, Vendor Management, Incident Management and Issue Management.
• Experience in working on Archer Applications, Questionnaires, Sub-Forms, Fields, Calculations, Access Roles, Security Parameters, Data Driven Events, Notifications, Reports, Workspaces, iViews, Dashboards and designing Mail Merge Templates.
• Experience in setting up campaigns and Findings Generation for Questionnaires.
• Experience in creating Archer Web Service and Database Query Transporter Data feeds based on the business requirements.
• Experience in Integrating Archer System with external downstream databases using Data Publication Services.
• Experience in designing SQL Scripts for business reporting.
• Knowledge in Archer schema used to Query Archer Database for Dirty calculations in Troubleshooting
• Interaction with clients for gathering business requirements and deliver efficiently.
• Administering the changes and taking critical responsibilities during production deployment

Environment: RSA Archer GRC SmartSuite Framework 6.x

Confidential, South Bend, IN

RSA Archer Admin/Developer

Responsibilities:

• Handling Enhancement requests raised by business that include introduction of various new fields, Calculated Fields, DDEs, Notification templates, Modifying Access Roles, Layout changes
• Handling Data Import requests from business
• Experience on Archer web service data feeds and Database Query Transporter data feeds.
• SSIS setup for history log reporting for Micro Strategy
• Experience in creating SQL scripts based on business needs.
• Experience in working on the Archer core solutions - Enterprise Management, Risk Management
• Imported existing information from legacy systems into RSA Archer Applications and questionnaire. Integrated the RSA Archer with External data sources with WebAPI.
• Regularly monitored and assessed risk of critical IT control areas (i.e. vendor management, business continuity, information security, document/record retention).

Environment: RSA Archer Platform 5.5.

Confidential

RSA Archer Admin/Developer

Responsibilities:

• Troubleshooting and debugging in the event of issues using the Archer Instance DB.
• Perform Root Cause Analysis and provide classic solutions
• Monitoring Archer Services and Server Performances.
• Installation of Archer platform - Patch upgrade, migration to new versions.
• Maintenance of servers in all tiers(web, application and database), Monitoring Job processes and Infrastructure upgrades.
• Packaging of applications/questionnaires, installing packages and manual deployment

Environment: RSA Archer GRC SmartSuite Framework 5.x

Confidential

SQL Server DBA

Responsibilities:

• Have hands-on experience in Database administration and development in SQL server for large and complex databases in SQL server 2008 R2,SQL server 2012, and SQL server 2014.
• Have created Maintenance Plans for auto scheduled Backup (full, differential, transaction log) of database and delete backup files after certain duration.
• Design indexes for existing applications, choosing when to add or remove indexes
• Experienced in enhancing performance and troubleshooting issues in SQL server and Windows server.
• Created SQL server agent jobs and alerts for preventing overflow of data in tables and maintain database size and performance.
• Creation of users and logins, configuring permissions and assigning roles to users.
• Experience on working and support in Production environment including DR environment.