Ellah Gondwe
Columbus,Ohio
Summary
Successful IT Data Analyst with demonstrated skills in performing key analytical and data research functions in the Financial and Health Care Industries. Exceptional skills analyzing and designing throughout the software development life cycle (SDLC), from business requirements, system specifications, programming code, and running SQL queries. Create reports for business analysts and end users. Knowledge of relational databases and proficiency with database management systems.
Overview
17
17
years of professional experience
Work History
Quantitative Analyst
JPMorgan Chase
Columbus, Ohio
10.2022 - Current
- In partnership with stakeholders, work in identifying data quality issues that triggered an incident to occur
- Perform data validation testing in SAS on the data pulled withing a specified period
- Document findings for upper Management to use as a solution to rectify customers who were impacted by an incident.
Control Management - MIS Reporting Analyst
JPMorgan Chase
Columbus, Ohio
04.2021 - 09.2022
- In partnership with stakeholders, evaluated and performed an end-to-end analysis and created solutions that met the needs of various MIS/reporting needs
- As well as evaluated and performed an end-to-end analysis of the business’ risk and control environment to identify significant gaps and weaknesses and determine root cause of control breaks
- Ensured that controls were properly designed, operating effectively, and essential to a proactive risk and control culture that leverages proven evaluation strategies and sound change management protocols
- Performed ongoing analysis of program related data (e.g., KRI/KPI) and develop ad-hoc MIS/reports as requested to support business-related programs and strategies
- Assisted with development of Risk & Control Self-Assessment mapping and documentations through participation in end-to-end process walkthroughs and deep dives with assigned business units.
Business Operations Analyst II Analyst
JPMorgan Chase
Columbus, Ohio
05.2019 - 04.2020
- Responsible for the oversight and management of voice and text complaint processes across CCB
- Led all related analytic, reporting and technology efforts, and managed project lists
- Analyzed and monitored complaint processes, data quality, taxonomy effectiveness and detection accuracy; quantify and escalate identified issues
- Developed recommendations and business cases to improve systemic detection complaint programs
- Produced adhoc analysis and reporting; summarize findings and insights across all management levels
- Monitored and analyzed control findings and trends
- Conducted regular process walk-through meetings and drive follow ups
- Created and maintained related procedures, process flows and documentation
- Served as a complaint program and data subject matter expert
- Designed and developed dashboards, scorecards, controls and reporting
- Maintained knowledge and awareness of issues, trends and changes impacting the business at Chase.
Data Analyst – Consultant
US Bank
Columbus, Ohio
06.2018 - 05.2019
- As part of the Solutions & Emerging Risks (S&ER) team, which is part of the client’s Enterprise Financial Crimes and Compliance (EFCC) organization, led efforts to design and develop best-in class investigative solutions toward identifying and mitigating emerging money-laundering risks
- Worked as part of a High Risk Customer Periodic Review process and be responsible for executing existing processes to create reports on a weekly/monthly/ad-hoc basis
- Operated the data extraction, organization, and delivery procedure for the Periodic High Risk Customer Review Process
- Executed strategies to assemble transaction information across multiple platforms
- Supported broader data analysis efforts related to the EFCC and general compliance issues as needed
- Documented and tracked request inventory, and conduct troubleshooting/gap analysis with report users in Business Lines
- Drove to achieve high quality results in a creative fashion and produce clear, concise work products
- Collaborated with individuals across business and/or functional lines.
IT Risk Business Analyst
JPMorgan Chase
Columbus, Ohio
05.2017 - 05.2018
- Write User Stories and Acceptance Criteria for the developers to use as a basis for enhancement requests from the business
- Identified and analyzed behavioral data and patterns, and techniques variation according to organizational requirements
- Identified, assessed, and documented requirements, recommended and advised business on priorities, options, risks, and costs
- Conducted research to determine whether solutions to business requirements currently exist within or outside the business unit, and if not, whether new solutions are feasible
- Analyzed control data from across the firm and assess relevance as key business metrics and opportunities for enrichment across data sources
- Developed use cases to demonstrate business requirements and specifications to the technology team
- Contributed a business and process perspective during design reviews and entire project lifecycle to ensure that deliverables meet business needs
- Provided relevant test scenarios to ensure that the results correspond to the business expectations
- Translated business requirements into technical options and solutions that meet end user business needs
- Created Business Requirements, User Stories, and Functional Specification documents to ensure the developers deliver high quality product
- Collaborated with business users and technology partners at all level.
Data Management
JPMorgan Chase
Columbus, Ohio
10.2015 - 04.2017
- Wrote Data Quality Rules to trigger columns in a table that have invalid data populated
- Wrote Data Quality Rules to flag incorrect data or format of the data populated in a column
- Reviewed intake requests and data submissions, engaged subject matter experts (SMEs) across Data Domains & CCB Sub-Lines of Business (Sub-LOBs)
- Facilitated analysis work sessions to confirm, scrub, categorize, and align data to appropriate “processing channels”
- Developed new or update reports and maintained and enhanced existing reports as needed
- Mentored the team for development and best practices for coding data quality rules
- Collaborated with customers to understand requests and project requirements
- Provided support to end users using troubleshooting reports and data quality issues, providing correct mapping of information
- Organized multiple work tasks and prioritized to meet deadlines
- Thorough understanding of reporting data in a way that is easily interpreted by end users
- Supported production reports and adhere to deployment protocols
- Adhere to all corporate and departmental standards and policies
- Tune code to provide optimal performance.
Sr. IT Business Analyst
JPMorgan Chase
Columbus, Ohio
03.2014 - 09.2015
- Provide tactical solutions for sharing data in real time across the organization, and produce metrics reports for Senior Management
- Developed a database application for the Data Management Council group, automating the manual process across various teams
- Worked with the Mortgage Banking team including Senior Programmers, Support Staff and Project Managers to plan program code enhancements and changes improving productivity
- Created test and maintained program code
- Perform key analytical and data research functions to drive trends analysis and sales forecasts
- Analyze and design of the application development life cycle
- Wrote and ran Visual Basic and SQL queries and procedures
- Understand business requirements, system specifications and programming codes to drive projects
- Maintaining documentation and creating reports for business analysts and end-users
- Understanding of relational databases, as well as proficient with database management systems
- Provided assistance to the end users for application technical support
- Provided general programming assistance to other programmers and projects as needed.
AVP Data Quality Analyst
JPMorgan Chase
Columbus, Ohio
02.2012 - 02.2014
- Performed key analytical and data research functions within the Data Quality Fair Lending team
- Performed in-depth research, root-cause analysis, and proactive data monitoring for data quality issues relating to mortgage systems
- Focusing primarily on data extraction, data analysis, data life-cycle documentation and documentation of remediation options
- Collaborated with end users of information to research reported data anomalies, identify root causes, and determine remediation steps
- Interacted with data source systems and target systems to identify data issues, data gaps, identify and recommend solutions
- Performed data modeling and data analysis as required
- Created, defined and maintained data life-cycle documentation representing data elements across multiple upstream and downstream systems
- Proactively communicated and collaborated with external and internal customers to analyze information needs
- Liaised between the business units, technology teams and support teams.
Sr Analyst, Proposal Developer
United Healthcare
Columbus, Ohio
02.2008 - 02.2012
- Conducted detailed research, analysis, and reporting of network utilization and determined agreed upon deliverables with customers, and the resources necessary to meet those deliverables
- Enhanced, modified and maintained existing Visual Basic and Microsoft SQL databases and documented changes and processes
- Produced Network Advisory Reports, providing updates on hospitals (including hospital systems) in the UnitedHealth Group Network including recent and upcoming hospital additions
- Contract negotiation status for hospitals within 90 days of contract expiration, based on 12 months of recent claim activity
- Renewals related to all hospital negotiations previously tracked in this advisory
- Contract expirations related to all hospital negotiations previously tracked in this advisory
- Worked with in-house built Data Mart applications i.e
- Galaxy, Sagent and GeoNetworks, to access layers of the data warehouse environment.
Quality Assurance – Consultant
Nationwide Insurance Enterprise
Columbus, Ohio
06.2007 - 02.2008
- Secured requirements, functional design, and internal design specifications, user stories, and other available/necessary information to ensure Quality standards
- Obtained budget and scheduled requirements and wrote test cases
- Determined project-related personnel and their responsibilities
- Identified application's higher-risk and important aspects, then set priorities, and determined the scope and limitations of the tests
- Decided test approaches and methods i.e
- Unit, integration, functional, system, security, load, usability tests and determined test environment requirements i.e
- Hardware, software, configuration, versions, communications, etc
- Obtained needed user manuals/reference, documents/configuration, guides/installation guides and set up test tracking processes and logging and archiving processes
- Provisioned and installed software releases, determined test input data requirements, and identified tasks and those responsible for the tasks, and set schedule estimates, timelines, milestones
- Prepared test plan document(s) and have needed reviews/approvals
- Evaluated and reported results and tracked problems/bugs and fixes and retested as needed
- Maintained and updated test plans, test cases and test environment through life cycle.
Education
Bachelor of Science (Hons) - Information Technology and Business Systems
Middlesex University
London, United Kingdom06-2001
Bachelor of Science - Computing Science
De Montfort University
Leicester, United Kingdom01-1999
Skills
- Information Technology Data Analyst
- Data Analytics Expertise
- Data Analysis
- Experience in Financial Services
- Health Care Experience
- Application Development Lifecycle
- Business Requirement Analysis
- System Requirements Analysis
- Code Development
- Advanced SQL Queries
- Data Analysis Reporting
- Database Management
Languages
English
Full Professional
Swahili
Professional
Timeline
Quantitative Analyst
JPMorgan Chase
10.2022 - Current
Control Management - MIS Reporting Analyst
JPMorgan Chase
04.2021 - 09.2022
Business Operations Analyst II Analyst
JPMorgan Chase
05.2019 - 04.2020
Data Analyst – Consultant
US Bank
06.2018 - 05.2019
IT Risk Business Analyst
JPMorgan Chase
05.2017 - 05.2018
Data Management
JPMorgan Chase
10.2015 - 04.2017
Sr. IT Business Analyst
JPMorgan Chase
03.2014 - 09.2015
AVP Data Quality Analyst
JPMorgan Chase
02.2012 - 02.2014
Sr Analyst, Proposal Developer
United Healthcare
02.2008 - 02.2012
Quality Assurance – Consultant
Nationwide Insurance Enterprise
06.2007 - 02.2008
Bachelor of Science (Hons) - Information Technology and Business Systems
Middlesex University
Bachelor of Science - Computing Science
De Montfort University
Similar Profiles
PASTELL JENKINSPASTELL JENKINS
Vice President of Operations at JPMorgan Chase, JPMorgan Chase & CoVice President of Operations at JPMorgan Chase, JPMorgan Chase & Co
Supraj CBSupraj CB
Analyst at JPMorgan Chase, JPMorgan Chase & CoAnalyst at JPMorgan Chase, JPMorgan Chase & Co
Noemie VillanuevaNoemie Villanueva
Retail Banking Associate at JPMorgan Chase, JPMorgan Chase & CoRetail Banking Associate at JPMorgan Chase, JPMorgan Chase & Co
Kimberly De La RosaKimberly De La Rosa
Waitress at JPMorgan Chase, JPMorgan Chase & CoWaitress at JPMorgan Chase, JPMorgan Chase & Co
Abdimalik AbdiAbdimalik Abdi
Home Health Aide at Aia HealthcareHome Health Aide at Aia Healthcare