DIEGO LOPEZ

*** *** **** **, ***** City, NJ, ****7 Cell: 347-***-**** adbuoo@r.postjobfree.com

EXPERIENCE

Ernst & Young (contractor) October 2019- Present

Assurance Data Analyst New York, NY

• Standardize and close financial statements by analyzing transactions within a company, avg over 10M lines of data per client

• Update workflows with SQL codes within Alteryx to normalize data and obtain right calculations

• Analyze and manipulate data in excel to create charts and evaluate financial statements using IFs, VLOOKUPS, etc

• Create and update documentation on processes completed. Detailing steps by step how analysis was done

• Update and process tasks via JIRA to communicate to stakeholders Wells Fargo (contractor) April 2019- Aug 2019

Data Analyst New York, NY

• Constructed/analyzed workflow and dataflow diagrams in MS Visio from requirements gathering and parallel processes

• Manipulated and analyzed data in excel to create charts, graphs to visually aid management in evaluating large sets of data

• Assisted in data gathering and reviewing with development teams, to understand data structures and determine validity

• Lead the effort of creation of data base for short/long term storage of Data Lake project

• Worked on DFFS (Dynamic Forms for SharePoint) to create forms for Data Lake project HSBC (contractor) Jul 2018-March 2019

Information Security- Cramer Analyst New York, NY

• Led global initiative in the North/Central/South American Region to ensure compliance within inventory software

• Worked with engineers ensuring devices were properly connected to network and troubleshooted those not in compliance

• Checked global inventory of network devices (Cramer), taking data export and analysis, and investigating gaps in data

• Produced and updated dashboards to assess progress of data quality issues to stakeholders and upper management

• Ran calls with engineers to understand, took ownership of compliance issues and ensured they got resolved in timely manner BNP Paribas (contractor) Jan 2018-Jun 2018

Information Security- Identity and Access Management and Regulatory Controls Jersey City, NJ

• Performed reconciliation on 60+ apps within the technology space. Ensuring details such as: users, account names, proper entitlements, etc. matched with app records for recertification and audit purposes using software as CyberArk and SailPoint

• Held frequent meetings with MDs/Application owners to explain, directed and requested information for reconciliations

• Worked with users, line managers, provisioning teams to ensure all data was corrected and implementations were accurate

• Took ownership of process of addition/removal of entitlements and active directory groups from beginning to end

• Worked with upper management to prepared data and documentation for external auditors’ ad hoc request JP Morgan Chase (contractor) March 2017- Dec 2017

Information Risk Analyst- Technology Control Jersey City, NJ

• Supported CIOs/CTOs of each Line of Business in reporting metrics for their monthly Technology Control decks

• Ensured 100% accuracy of data in monthly PowerPoints for reporting in TCOs presentations

• Automated reports by VBA and creation of excel files to capture multiple metrics across different data sources by nesting complex excel formulas as well as numerous V-lookups and pivot tables, IFS statements, AND/OR

• Worked with technology controls/application owners to performed risk assessment and assess technology integration

• Utilized JIRAs to track and assessed current and upcoming requests by clients and ensure proper workflow MDSL- (Market Data Services Limited) May 2015- Feb 2017 Data Analyst New York, NY

• Assisted our clients, top financial institutions such as Jefferies, Nomura, UBS to reduce their operating expenses in the telecom space by conduction deep analysis and recommending strategies to reduce their day to day costs

• Created reports for clients and stakeholders, detailing in depth analysis of data, metrics and recommendations on areas of potential savings utilizing SQL, excel and VBA

• Analyzed large volume of data from multiple sources to identify trends, variances and additional insights using SQL/VBA

• Investigated billing discrepancies thought the use of VLOOKUP, filters, pivot tables, what if analysis; ensuring accurate allocation of charges and credits were applied, accomplishing auditing within a 98% accuracy MICHAEL C. FINA Sep 2014- May 2015

Billing Analyst New York, NY

• Analyzed past sales revenue for specific corporate segments and calculated commissions based on contract reports

• Computed commission for top third party clients, following methodology while making accounting adjustments LEADERSHIP EXPERIENCE

Process Improvement Committee (MDSL) - Secretary Oct 2015- Feb 2017

• Selected by senior leadership to develop and implement strategic/execution plans that continuously improved operations SKILLS

• Strong skills on: Oracle/SQL, Excel, Power Point, VBA. Working knowledge of R, D

• Able to work under pressure in a fast-paced environment and multi-task as priorities change ● Native Spanish EDUCATION

BARUCH COLLEGE/ CUNY Dec 2012

Bachelor of Business Administration: Major in Finance, Minor in Economics New York, NY

Contact this candidate