Senior Analytics & Reporting Analyst Resume Charlotte NC - Hire IT People

TECHNICAL SKILLS

Languages: C++/C#, VBA, T - SQL, PL/SQL, VB.net, VBScript

Platforms: Windows 9X/2000/XP/Vista/Windows 7/Windows 8.x, DOS

Databases: SQL Server (2000/2005/2008 ), Oracle (9i/11g), Teradata (13/14), Microsoft Access

Tools: Microsoft Office Suite, Microsoft Project, Microsoft Visio, QRM MB, Quest Toad, LPS Director/Passport, MSP, SAS Base 9.2

Business: Root cause analysis, process mapping/ flowcharting, process improvements, process documentation, user testing, data modeling, information risk modeling

PROFESSIONAL EXPERIENCE

Senior Analytics & Reporting Analyst

Confidential

Responsibilities:

Act as the data management subject matter expert for the Pricing & Analytics division of Confidential . Responsibilities include data modeling of existing systems and integration of new systems into the Ally data workstream.
Advise the Pricing team on data governance best practices for accessing, utilizing, and reporting of the various data elements within the system.

Analytics Consultant

Confidential, Charlotte NC

Responsibilities:

Served as data steward for the Model Risk System (MoRS) application used by Confidential ’s Model Risk division. In this capacity, I maintain the full spectrum data dictionary (physical, logical, and metadata) for the application along with the data lineage mapping and data quality checks to correspond to the data governance mandates given by the Basel Committee for Bank Supervision (BCBS) and internal Confidential guidelines.
Advised the CMoR Governance team on technical issues regarding the MoRS platform and pertinent technical operation actions such as data governance and best practices for accessing, utilizing, and reporting of the various data elements within the system.
Act as day over day support for the model risk teams to troubleshoot and correct any issues with the MoRS platform. This consists of first level analysis to determine if the issue was due to operational failures such as bad procedures or user error or if the issue was due to a systemic failure within the application.

Risk Architecture

Confidential, Columbus OH

Responsibilities:

Acted as a lead tester for the conversion of multiple business critical data warehouses and data marts from a DB2 platform to an integrated data warehouse platform built on Teradata. Performed ETL regression testing, data model testing, and data unit testing against risk metric information that was utilized for regulatory reporting and data governance mandates given by the Basel Committee for Bank Supervision (BCBS) and Comprehensive Capital Analysis and Review (CCAR).
Supported the risk modeling and analytics teams in determining best practices for data risk and privacy levels for attributes housed within the risk data marts. Performed audits of the access administration and user roles built around these marts to ensure compliance with the information risk best practices for JPMC.
Acted as day over day support for the risk modeling and analytics teams to troubleshoot and correct any issues with the Teradata platform. This consisted of first level analysis to determine if the issue was systemic to the overall platform or localized and would either correct if able or escalate to the technical support teams.

Business Operations Analyst Senior

Confidential, Florence SC

Responsibilities:

Provided operational and technical support for the special loans line of business (LOB) on site.
Acted as the senior analyst for the team, becoming engaged on projects and analytics that crossed lines of businesses or required timeframes and deliverables that could not be met with normal resources. This included highly complex data extractions from internal or legacy systems and performing root cause analysis on data or operational gaps for the loan servicing portfolio.

Database Analyst

Confidential, Columbia SC

Responsibilities:

Provided operation and technical support for a risk documentation database utilized to track security vulnerabilities and security risk exceptions within the company.
Responsible for process streamlining and task automation in the day to day operations of the group that enabled the group to respond quicker to security incidents.

Business Data Analyst

Confidential, Florence SC

Responsibilities:

Provided operational support for the Quantitative Risk Management (QRM) system, the primary point of record for the company’s multi-billion investment banking division.
Supported existing reporting systems along with creating custom reports and systems as requested by the senior traders, risk analysts, accounts, and executive management to isolate trends and metrics for the ever changing market conditions.
Acted as the technical support analyst onsite for the QRM system. This involved researching and correcting data anomalies that were received from upstream processing systems or occurred as a result of extract/transform/load errors within the system.

We provide IT Staff Augmentation Services!

Senior Analytics & Reporting Analyst Resume

Charlotte, NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship