GRC Consultant

Location:

Posted:

October 18, 2017

Contact this candidate

Resume:

Abhishekh Tiwari

Email: **************@*****.***

Mobile : 973-***-****

Experience : 5 . 6 Years

Employer- Capgemini

Professional Summary

Innovative, results-driven Software Developer with good experience, producing technical solutions with a high degree of customer satisfaction, success and profit. Extensive expertise in full lifecycle product development utilizing object-oriented principles, from initial concept to customer delivery on MetricStream Governance Risk & Compliance (GRC) platform and Archer GRC. Comprehensive knowledge of Oracle SQL, PL/SQL & UNIX, JavaScript and Production Support. Exceptional ability to analyze and translate complex technical information to end-users at all levels. Inventive thinker, with a “make it happen” attitude.

Strengths

Avid learner and innovative.

Ability to lead and motivate colleagues.

Ability to deliver even in harsh conditions.

Ability to live and work in a group excellently.

IT Skill Set

Proficiency

SQL, PL/SQL

Technical Tools

SQL*Plus, PL/SQL

Database

Oracle 10g, Oracle 11gR2

Operating system

Windows(XP, 7), Unix, Linux Based OS(Ubuntu,Fedora, etc)

Software Packages

PL-SQL Developer, SQL Developer, Tableau Developer, Toad, MS-Office, Putty, Eclipse

Professional Experience

Company Name

Designation

Role

Duration

1. MetricStream Infotech Ltd.

Member Technical Staff

Maintenance

May 12 –Dec-14

2. Wipro Technologies

Associate Consultant

Development & Support

Jan-15 –Oct-16

3. Capgemini

Consultant

Development & Support

Nov-16 –Till Date

Project Details (In Reverse Chronological Order):

Project 1:

Title

Citi Bank

Role

Design, Production Support, Coding & Unit testing

Tenure

Jan-15 to Aug -17

Team Size

Tools Used

PL/SQL,RAD tool (ECP, Data Designer, Process Designer, Form Builder)

Environment

Unix, Windows 2003 Server, Oracle 11g

Description:

CITI is a project where we delivered solution for their Operational Risk Management (ORM), Audit, RCM (Regulatory Control Matrix), Business Continuity Management(BCM).

A risk management function (and/or committee) that facilitates and monitors the implementation of effective risk management practices by operational management and assists risk owners in defining the target risk exposure and reporting adequate risk-related information throughout the organization.

Audit Management Solution is designed to help companies to manage a wide range of audit-related activities, data and processes in a single and comprehensive framework. The audit management software provides the flexibility to support all types of audits, including internal audits, operational audits, IT audits, supplier audits, and quality audits.

The goal of the RCM tool is to provide a global platform to flexibly manage the RCM activities as well as the timely and targeted reporting management requires.

Additionally the use of this robust workflow solution will facilitate the timely maintenance of the repository by notifying control owners of changes in requirements as well as notifying requirement owners of changes in controls that may impact their requirements.

Regulatory Control Matrix (RCM) is the association/linkage between selected requirements from the Regulatory Requirements Inventory (RRI) associated controls and assessment in the business / entity.

The Regulatory Control Matrix module for Citi will cover the following

§ Requirements

§ Rules

§ Controls

§ Assessments

Key Accomplishments:

Designing solution with full customer satisfaction.

Design, Supporting, coding and using ECP, Data Designer, process designer and Form Designer tools to make all configurations in one place.

Creating tables, enforcing constraints and implementing normalization. Extensive use of stored procedures (Collection type, cursors, procedures, functions etc) and triggers to handle data manipulation. Also used complex SQL queries for Reports and Charts.

Environment: SQL, PL/SQL, Java Script and Metricstream Tool

Project 2:

Title

Olympus

Client

Olympus

Role

Design, Coding, Production Support & Unit testing

Tenure

May-13 to Dec-2014

Team Size

Tools Used

PL/SQL,RAD tool (ECP, Data Designer, Appstudio, Form Builder)

Environment

Unix, Oracle 11g2R

Description:

OLYMPUS needed a Solution to automate their Risk Assessment, Issue Management and Audits process. With our solution they will first access their Risk. Then they will Audit the accessed risk. They will check for the Laws and Regulation in process. They will check the coverage of risk and Laws and Regulation.

Issue Management is the discipline and process of managing business issues, usually implying technology to electronically automate the process. Issue Management enables you to initiate issues, generate action items, review the issues and finally approve and close the issues once it is resolved. The Issue Management process involves initiating different issues which can be triggered from Audits Management, Compliance Management, Loss Event Management, Risk Management, Survey Management, and GRC Intelligence. Use the ISM application to initiate issues, implement actions and track the issues

to closure.

We developed a number of reports which will be used for decision making for their process.

Key Accomplishments:

Designing solution with full customer satisfaction.

Design, coding and using ECP, Appstudio, process designer and Form Designer tools to make all configurations in one place.

Creating tables, enforcing constraints and implementing normalization. Extensive use of stored procedures (Cursors, Package, procedures, functions etc) and triggers to handle data manipulation. Also used complex SQL queries for Reports and Charts.

Environment: SQL, PL/SQL, Java Script and RAD Tool.

Project 3:

Title

GSEC

Client

Golden Spread Electric Co-Operative

Role

Design, Coding & Production Support & Unit testing

Tenure

Jan-13 to May -13

Team Size

Tools Used

PL/SQL, RAD Tool (ECP, Data Designer, Process Designer Form Builder)

Environment

Unix, Windows 2003 Server, Oracle 11i

Description:

GSEC needed a Solution to automate their Managing issues such as non-conformance, exceptions, loss-events, and process deviations is one of the central functions of an organization's quality, compliance, and risk management units. Relying on stand-alone point solutions or paper-based processes to manage issues is ineffective, as they fail to address systemic problems due to a lack of broad enterprise reach and visibility.

We developed a number of reports which will be used for decision making for their process.

Key Accomplishments:

Gather the requirement and designing solution with full customer satisfaction.

Design, coding and using ECP, Data Designer, process designer and Form Designer tools to make all configurations in one place.

Environment: SQL, PL/SQL, Java Script, RAD Tool

Project 4:

Title

MasterCard

Client

MasterCard

Role

Design, Coding & Unit testing

Tenure

Jul-2012 to Jan- 2013

Team Size

Tools Used

PL/SQL, RAD Tool(ECP, Appstudio,Data Designer, Process Designer Form Builder)

Environment

Unix, Windows 2003 Server, Oracle 10g

Description:

MasterCard was a project where we delivered solution for their Audits, GRC, ISM, RTM.

I was working on RTM(Resource Time Management). Audit Manager and Lead Auditor will request for Resource from Resource manager. There is a number of Resource Pools from which a Lead Auditor or Audit Manager can request Resource. The Resource pool Managers will get a notification for the request. He will check his Resource Pool and allocate/reject the request based on the availability of the resource in his pool.

There are a number of reports to view the resource details from different resource pools. The user working on different task can fill their timesheet. The Timesheet Admin can check the time sheet and Approve or reject the timesheet submitted.

Key Accomplishments:

Gather the requirement and designing solution with full customer satisfaction.

Design and coding of all application in ECP, Data Designer, process designer and Form Designer tools so that all configurations are done in one place.

Environment: SQL, PL/SQL, Unix,Java Script, RAD Tool

Educational Qualifications

10th

Hindu Inter College Zamania Ghazipur U.P.

UPBoard.

64.00%

July-2004

10+2

Hindu Inter College Zamania Ghazipur U.P.

UPBoard

64.00%

July-2006

B.Tech (IT)

IITT College Of Engineering, Nawanshahr,Punjab

P.T.U.

70.72%

July-2012

Extra-Curricular Activities

Got many certificates and rewards from MetricStream for outstanding performance, delivery in time and handling critical projects.

Won prize and certificate in a district level essay writing competition.

Captain of school/college/Metric Stream cricket team.

Badminton and Chess Champion at school/college level.

Event organizer in school & college annual day functions and other technical events.

Personal Details

Date of Birth

12th Nov 1991

Father's Name

Shri Satish Tiwari

Languages known

English, Hindi, Punjabi

Sex

Male

Marital Status

Single

PAN

AMHPT0312R

Passport No

M6657246

Passport validity

24th Feb 2010 To 23rd Feb 2025

Hobby

Reading Books, Playing Cricket

Permanent Address

At+Post-Baruin,Dist Ghazipur,U.P,India,232331

Current Address

#21,Krishnappa Garden, Tavarekhere,Bangalore, 560029

Nationality

Indian

Place: Bangalore ( Abhishekh Tiwari )

Contact this candidate