SUMMARY

• Strong analytical skills, results - oriented and self-motivated
• Highly experienced in data analysis, data governance, data mining/mapping, data management and risk analysis
• Proficient to resolve issues, problem-solving skills and technical research
• Expertise in operating risk analysis and financial reporting, audit and report generation
• Experience in creating data dictionaries, data lineage, cost estimates and budgets, timelines and schedules
• Strong analytical, evaluation, planning and decision making abilities
• Have solid relationship and project management experience
• Team player with excellent communication, presentation, and interpersonal skills

TECHNICAL SKILLS

• Data Analysis, Reporting, Research, QA/QC, Data-Mapping, Tableau, Power BI, SQL, Oracle, TOAD, Metadata
• HUE/HADOOP, MDR, Access/DB, RDBMS, PeopleSoft, Putty, CITRIX, AS/400, ASC-842, SharePoint, PowerPoint
• Excel, Skype, Teams and various other project mgmt. processes and tools
• Advanced Office and Windows/ Unix based Applications, Vendor Mgmt. and Project Management Experience
• Skilled in advanced Excel i.e. VLOOKUP’s, HLOOKUPS, Pivots, SumIf and other advanced excel functions

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Analyzed and extract data from various Confidential databases/DataMart using SQL/Oracle (toad) queries/codes
• Performed data cleansing and manipulation by using excel VLOOKUP’s, pivot and other advance excel functions
• Creates project presentations for business, stakeholders and clients using MS PowerPoint
• Assisted with preparing the bank’s regulatory Call Reports and ensure consistency with other financial statements
• Research, update, and validate data underlying spreadsheet production; strategically fill gaps using Microsoft tools
• Prepared reports by using and utilizing MS Excel (VLOOKUP, HLOOKUPS, pivot tables, Macros, data points)
• Created Process flow chart, presentations and defects mgmt. using JIRA, Visio, PowerPoint and MS Excel
• Participate in daily Agile and Scrum master meeting to provide feedback and updates on the project
• Managed spreadsheets and maintain data integrity to ensure accurate data availability for higher management
• Follow up with the LOB’s and tech-teams on intake and missing data files, transaction codes and documentations
• Reviewed and discussed proposed issues with line of business, compliance, risk partners, audit teams and SME’s to ensure sufficient details are included, severity is appropriate, and the root cause has been clearly documented.
• Captured end-to-end lineage and ensure proper impact analysis has been performed in the event of changes to data assets as they move across the pipelines.
• Maintain data flow documentation and perform object mapping using BI tools and validation
• Performed QA/QC checks (reviews/compare/validate) for data accuracies and validation
• Maintain and perform process analysis and designing of BI reports as well as opening StoreFront tickets in UAT, DEV and PROD for claim’s team

Confidential

SAP Implementation - Data Analyst

Responsibilities:

• Data lead for UAT accounts and ASC-842 Implementation project
• Provide assistance to prep data and for Implementation of production cutoff procedures
• Maintain and perform data mining, cleansing and validation using excel vlookups and other excel functions
• Extract, analyze and research data from system of origin to the system of record for data accuracy and completeness
• Prepared, validate and participate in designing of over 2500 leases using adv. Excel functions for lease project
• Responsible for all data controls documentations as well as system access testing in Beta environment
• Conducted analysis documentation to identify areas of gaps/risks by using excel charts, pivots and vlookups
• Performed UAT testing in Beta and perform data validation in Production environment of SAP financial implementation
• Followed strict guidelines and controlled processes for data integrity, accuracy and timeliness
• Participate in data cleansing exercises and prep data for load in Beta and Prod.
• Extensively participated with (RU’s) reporting units and controller’s meetings and met with PwC audit teams for walk through processes and sign off validations

Confidential

Business System Analyst

Responsibilities:

• Ensured timely and accurately resolution of merchants and production issues
• Conducted research, identified and coordinate between stakeholders and appropriately remediate the root cause of the issue in a matrixes organization environment
• Create pivot tables and modify spreadsheets to achieve analytical goals
• Worked closely with the Relationship Manager and reporting teams to determine whether issues have broader implications across the company, or rises to the level of a Theme and effectively convey root cause analysis of issues
• Build and maintained strong relationships with JPMC business partners and technology teams to identify process improvement opportunities
• Analyzed credit risk management operating procedures to determine problems and sample the accuracy of data being used
• Provide assistance to senior management in data analysis, data mining/mapping and data cleansing for reporting needs
• Ensured the project activities, as assigned are completed within established time and budget

Confidential

Auditor

Responsibilities:

• Audited and analyzed financial documentation and asset data to determine potential risk appetite
• Established accountability and mitigate identified risks
• Utilized sound analytical skills and demonstrating product, business and technical expertise to review independently execute validation testing for multiple assigned issues and applied effective risk-based audit strategies
• Applied sound project management skills to effectively manage an issues team with the primary objective of completing assignments timely and with a highest degree of quality
• Reviewed and discussed proposed issues with business/Compliance/Risk partners, Audit teams and SME’s to ensure sufficient details are included, severity is appropriate, and root cause has been clearly documented
• Reviewed proposed Action Plans submitted by business partners to ensure the remediation plan is designed to drive timely resolution
• Reviewed and approved detailed Test Plans designed to validate that the businesses and control functions have appropriately remediated the root cause of the issue
• Provide coaching and feedback to issues associates as needed