JOHN HENRIQUES

adbc8o@r.postjobfree.com 401-***-**** East Greenwich, Rhode Island

QUALIFICATION HIGHLIGHTS

Proficient on enterprise System Development Life Cycles processes, Change & Project Management Framework, Waterfall, and Agile.

Highly experienced in system design and architecture, data mining, data analysis, application development and support, Identity and Access Management (IDM).

Exemplary problem-solving skills: able to identify problems and implement corrective processes, proficient in wide variety of disciplines including software development life cycle, business processes, complex business logic, multiple platforms, networking, and hardware.

Experience in: Sailpoint IdentityIQ (IIQ), Identity and Access Management (IDM), Visual Studio, VB.net, VBA (Microsoft Office Macros ), VBScript, SAS, Siebel, HTML, CSS, Java, JavaScript, Cobol, CICS, JCL, EZTrieve, SQL, LDAP, SharePoint, SharePoint Designer, WordPress, Adobe Fireworks (graphics editing), Oracle, SQL Server, Sybase, MS Access, MS Project, MS Excel, MS Word, MS PowerPoint, MS Visio, Teradata (Data Warehouse), Content Management Systems(CMS), CRM, RTC, Jira, Rally, MS Windows, Windows Server, Active Directory, Mainframe.

Self-motivated and highly organized; willing to accept challenges and train for new situations.

Strong positive communicator.

WORK HISTORY

John Hancock (Whitridge Associates) – Boston, MA

IT Security Consultant July 2018 - Present

Responsible for conducting quality review of all SOX (Sarbanes–Oxley) Application integrations into Sailpoint IdentityIQ (IIQ). The initial project scope included 45 applications with 9,858 unique entitlements and 45,236 reviewable items.

The quality review focused on validating all configuration parameters with the objective of improving application access model and data quality, standardizing entitlements descriptions, creating application roles and establishing separation of duty (SOD) policies when appropriate.

Defined project approach, developed priorities and timeline, established process and selected project tools. Defined metrics, tracking means and management reporting.

Developed tools to automate document generation of project artifacts, creation of job aids, and data analysis processes.

Guided design of SharePoint team site and created new application master inventory.

Citizens Bank – Cranston, RI

Senior IT Security Professional/Department Manager (Vice President) March 2015 – July 2018

Responsible for managing technology and operations for enterprise Identity Management Solutions Department.

Oversaw system development and support activities for Sailpoint IdentityIQ (IIQ), ITSS (in-house access self-service portal), Generic ID Repository (authoritative source for non-human identities), and Operations Database (intake queue management, decision support, reporting, task automation).

Managed core SailPoint integration staff of 10 Business Analysts and 5 software developers, coordinated activities between core staff and extended project resources from 2 partner SailPoint integrators.

Led the Identity Management Solutions team through the following accomplishments:

oUpgraded from SailPoint 6.0 to 7.0 (LCM).

oIncreased the number of SailPoint integrations from under 200 to 400+ applications.

oRolled out Self Service Request (SSAR).

oDeliver Quarterly User Access Reviews for all integrated applications (1.2 million entitlements reviewed) while reaching and sustain 100% completion rate over the last 4 quarters).

oDeliver individual User Access Reviews for colleagues moving to new internal positions.

oBuilt rules for Segregation of Duties Policy and Toxic Combinations.

oRedesigned business processes and tools for engagement and service delivery.

oStandardized and partially automated Quality Assurance testing (QA) procedures.

Worked closely with technology teams to assess, propose and design SailPoint integrations across all enterprise technology platforms and components.

Collaborated with Project Management Office (PMO) to develop and deliver training sessions for project managers planning new SailPoint integrations or managing technology changes affecting existing application.

Worked with Risk and Audit to identify and resolve open issues.

Delivered case study presentation of Citizens IDM Project “phase 1” to 2016 SailPoint Regional User Groups in New York and Boston.

Fidelity Investments – North Smithfield, RI

Senior Systems Analyst/Project Manager December 2012 – December 2014

Performed analysis for medium and large-sized projects, documented requirements and design for Employee Compliance Group ensuring conformity with Financial Industry Regulatory Authority (FINRA) rules, U.S. Securities and Exchange Commission (SEC) Regulations and Fidelity policies.

Managed large data sourcing project allowing Employee Compliance systems to consume data directly from Fidelity International Limited (FIL) systems. The project covered Investment Research data, analyst assignments, and fund trades facilitated establishment of information barriers between Fidelity affiliates by removing dependency on a central repository.

Coordinated project to migrate all Employee Compliance Applications to new security reference database. The project delivered a new common Data Access Layer comprised of Database Views and Stored Procedures and oversaw the migration by the various application development teams.

Managed project to automate data aggregation and report generation to ensure compliance with Pay-to-Play laws. Maintaining data had been a highly manual and cumbersome process using MS Access databases.

Performed analysis and migrated 14 departmental SharePoint sites into single collaboration site (15,000 documents). Developed content for new site and managed site membership.

Acted as Agile Facilitator for team working as scrum master, planning development iterations, team capacity, cadence meetings, and tracking work items and project issues.

Produced weekly and quarterly senior management presentations and release gate meetings detailing project status and team performance.

Bank of America – Providence, RI

Operations Consultant, (Vice President) October 2012 - December 2012

Performed evaluation of Call Center Audit review system. Gathered business requirements and developed new reporting prototype.

Bank of America – Providence, RI

Process Design Consultant (Vice President) August 2009 - June 2012

Responsible for continuous improvement of Waterfall Software Development Life Cycle enterprise process. Organized and managed work groups representing various Business Technology Groups and Technology Support Areas to develop and update Waterfall methodology.

Led Waterfall redesign and content migration from the old Process Navigation Tool into the Technology Process Portal allowing team to deliver content updates more rapidly and little reliance on technical support teams.

Supported the Change & Project Management Framework (C&PMF) work to remediate high severity audit issues ensuring that the Waterfall minimum standards and common enterprise technology practices were aligned to the overall C&MPF.

Created new enterprise templates to capture technology solutions conceptual and logical design and implemented automated traceability from design requirements to test specification.

Participated in the Enterprise Release Master Control Room as a Defect Tracker and Problem Facilitator during enterprise release events.

RBS Citizens Bank (Reliance Systems) - Providence, RI

Business Analyst/Project Manager (Consultant) June 2009 - August 2009

Tasked with evaluation of Operations Risk Management reporting procedures, data quality, data sourcing, and process optimization.

Designed and built prototype reporting package for Operations Risk Management area at Citizens bank reducing reporting cycle from 20+ days to less than one week.

Provided guidance to Business Intelligence Group on design approach, and strategy for long term solution.

Bank of America (Fleet/Boston legacy) - Providence, RI

Service Delivery Consultant (Assistant Vice President) June 2006 - February 2009

Managed Architecture Network Review for Client Connection Integrated Desktop (CCID) deployment, maintained issues lists, and project plans, worked with National Computing Group (NCG) and EDS (network vendor) to resolve all issues.

Led the business requirements and supporting documentation for Global Wealth and Investment Managements “Anti Money Laundering/Know Your Customer” Account Express integration project.

Led Streetscape application monitoring project which enabled National Financial Services (Fidelity) to monitor application availability over frame relay links.

Created support model for Client Connections Integrated Desktop application, coordinated efforts with National Computing Group (NCG), business units, various support groups. Engaged Premier Resource Support (PRS) and Broker Support Group (BSG) to assume responsibility of specific support issues, defined business process, provided documentation and training (on-site and remote) as a result the CCID Administration group experienced a drastic decrease in outstanding monthly open support issues (went from 700+ open issues at the end of each month to zero outstanding open tickets each month).

Analyzed and resolved issues across various technology platforms: Wrote CCID technical troubleshooting guides used by the Help Desk, Business Support Group, Premier Resource Support, and Technology Delivery Teams. Ultimate ownership of all CCID escalated issues

Researched and corrected approach for tracking usage of Siebel Licenses.

Performed data analysis using various databases including Oracle, SQL Server, Sybase, Access, Teradata (Data Warehouse). Handled all aspects from parsing raw data, designing and creating databases, analysis and generation of specialized reports. Created reporting Database and ran daily reports for Sales & Service team; Created data repository that aggregated data from multitude of sources (Oracle, Siebel, Teradata, Active Directory, Corporate Directory, and Microsoft Outlook) to provide an end to end view.

Designed and produced monthly senior management reports detailing key performance metrics and usage indicators; created ad-hoc reports.

Designed and built working prototype Contact Management/Leads Referral application which was used as a model for the Bank of America’s Maestro application. Made initial design and infrastructure recommendations used by Maestro application.

Conducted Business Analysis, documented business requirements; design documents, process maps, test plans and test scripts.

Bank of America (Fleet/Boston legacy) - Providence, RI

Business Technology Integrator August 2004 - June 2006

Worked with business partners and technology partners to develop technology solutions based on line of business needs.

Designed and developed custom add-on applications to GIM 2000 accounting system.

Managed server software certification under new operating systems, desktop and server upgrades projects for Columbia Management Group legacy applications.

Bank of America (Fleet/Boston legacy) - Providence, RI

Application Systems Developer June 1991 - August 2004

Designed built and supported applications used in Investments Area: portfolio accounting, retirement plan services, human resources, payroll processing, relationship tracking, project resource tracking.

EDUCATION

Johnson & Wales University - Providence, RI

Bachelor of Science, Computer Science

Bryant College – Executive Development Center

Project Management Certification

Contact this candidate