Mehwish Raja
Land O' Lakes, Florida,Florida
Summary
Demonstrated success in identifying relationships and building solutions to business problems. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. Coordinated with product designers to evaluate for common and debilitating scenarios early in testing process. Identified issues and reported anomalies promptly.
Overview
14
14
years of professional experience
Work History
(SVP) Data Integration Lead Analyst
Citigroup Inc
10.2023 - Current
- Organized system operating procedures to strengthen controls.
- Educated stakeholders on data protection tactics to reduce breaches.
- Planned computer systems using information engineering, data modeling, and structured analysis.
- Presented business leaders with ROI estimations to drive project planning.
- Support definition of scope, risk reduction metrics, issues, and data requirements for Risk, including Wholesale, Retail, Price, and Operational Risk Types.
- Monitored delivery of Tactical and Strategic Fixes as required by the Citi Data Operating Model (DOM) for Risk use-cases. Support testing and documentation of successful fix implementations
- Provided Risk input to adoption RBCM deliverables, including Data Lineage, Authoritative Repository designation and Data Certification.
- Ensured all audit artifacts are complete and accurate. Support IA Validations.
- Monitored progress against risk reduction metrics linked to the Risk use-cases; documenting and escalating any risks, issues or challenges that might impact our ability to meet those targets.
- Monitored BAU issues raised outside of the Consent Order via the Data Concern Remediation Management process to ensure that issues are appropriately prioritized and addressed.
- Provided backup and assistance for administration of physical and virtual server infrastructure and storage area networks.
- Developed diagrams to describe and lay out logical operational steps.
- Investigated system issues and implemented resolutions to reduce downtime.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Designed and developed data pipelines to acquire, clean and process data.
- Implemented business intelligence solutions to increase operational efficiency.
(SVP) IT Tech Analyst
Littelfuse
05.2023 - 08.2023
- Authored technical requirement documentation to suit business goals and technological limits.
- Designed and maintained consistent data collection protocols and standards across numerous databases and projects.
- Communicated technical findings via lay terminology to keep interdepartmental teams informed on vital developments.
- Advised project managers on simultaneous technical workstreams, aiding in alignment of broader business goals.
- Collaborated on readiness and acceptance tests.
- Gathered and documented requirements for projects.
- Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
- Validated results and performed quality assurance to assess accuracy of data.
(SVP) DATA/BUSINESS SYSTEM ANALYST
Citizens Bank
02.2022 - 04.2023
- Lead workstreams of acquisitions, divestitures, and commercial deals from assessment to execution
- Analyzed open orders, backlog, and sales data to provide sales team with insights.
- Assembled reports and presentations to share insights and recommendations with stakeholders.
- Devised data visualization dashboards to make complex data more accessible to stakeholders.
- Created successful test scripts to manage automated feature testing,
- Tailored testing procedures to obtain data most relevant to understanding underlying causes of production limitations.
- Met with quality assurance, developers and project managers to assess scope and sequence of project.
- Identified bugs and issues within system and applied troubleshooting techniques for mitigation purposes.
- Collaborated on implementation of collection strategies with collections, risk and fraud teams.
- Produced accurate and timely collections reports, facilitating measurement, decision-making and engagement with customers.
- Trained and mentored analysts on SAS programming, analytics and influential communication.
- Formulated knowledgeable forecasts for business, industry and overall economic conditions based on available financial information.
- Assessed liquidity and market risk levels and applied risk-based approach to oversee financial activities.
- Conducted statistical analysis and evaluated risk via use of portfolio management software.
- Wrote optimized SQL queries for integration with other applications.
- Analyzed data to uncover insights and identify key opportunities to inform strategic decisions.
- Applied problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Performed gap analysis to identify areas of improvement.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Develop and produce a mortgage portfolio for the commercial or consumer market.
- Generated FRDs, BRDs and custom reports to provide insights into business performance.
- Tracked feedback at all levels and researched resolutions for common concerns.
- Utilized data visualization tools to effectively communicate business insights e.g. Tableau, Panorama, qlik sense
- Organized system operating procedures to strengthen controls.
- Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
- Determined root cause of data quality errors and recommended long-term solutions and Data Remediation
- Updated and developed SQL scripts and queries to extract and analyze data from multiple sources.
- Created and automated data visualizations to present insights and tell compelling stories.
- Collaborated with business analysts and software development team to identify and convert business goals into data requirements.
- Designed and developed data pipelines to acquire, clean and process data.
- Developed and executed data cleanup measures.
- Evaluated large datasets for quality and accuracy.
- Coordinated data migration and consolidation efforts.
- Created, shared and reviewed conversion reports to confirm accurate data conversions.
- Created both preview and production environment and populated with converted data through existing conversion tools.
- Manage strategic client relationships supplying highest quality work across multiple projects
- Coordinated issue escalation process through development and support departments when necessary for swift conflict resolution.
- Completed initial data mapping activities based on existing best practices and drove custom mapping process with primary client project partners.
- Communicated and explained business requirements to team members to understand and implement functional demands.
- Developed diagrams to describe and lay out logical operational steps.
- Assessed business requirements to create focused solutions.
- Organize market analysis on new country entries
- Function as Senior Manager on appointed deals directing team of two advisors
- Coach, mentor, and foster junior staff engagement
- Coordinated and performed data extraction from source data platforms.
- Collaborated with project team members and led clients through data conversion process.
- Analyzed software, detected and diagnosed issues, assessing code, making improvement suggestions to developers, and documenting bugs.
- Checked color, shape, texture and grade of products and materials against established templates, charts, and samples.
- Recorded inspection and test results on data sheets.
- Assisted members with correcting accounts, service, and system issues by educating on required forms and technical processes
- Created collaborative relationships with members of over twenty cross-functional teams, consistently fostering productive teamwork to build consensus and solve complex business issues
- Nominated subject matter expert (SME) consulting on various aspects of M&A and divestiture strategies, including options analyses and recommendations
- Assisted members with correcting accounts, service, and system issues by educating on required forms and technical processes
- Helped large volume of client every day with positive attitude and focus on client satisfaction
- Learned internal systems and related service role duties to provide skilled team backup in handling client demands
- Generated account activity reports to identify upgrade and sales opportunities
- Handled complaints with prompt, courteous service to uphold professional reputation
- Resolved client issues through thorough dispute investigation
- Developed, implemented, and collated client satisfaction surveys for improved insight
- Maintained updated knowledge of internal processes and industry best practices to optimize service delivery
- Verified client identification and documentation for compliant transactions
- Maintained and managed client files and databases
- Worked closely with UX and product teams to define visual and functional requirements.
- Conducted live user testing of components and functionality to evaluate effectiveness of designs and enhancements.
Senior Data Analyst
Choice Payment Services
09.2021 - 02.2022
- Implemented Agile/SCRUM methodology of Software Development life cycle to develop business process models and was responsible for documenting various project activities and deliverables for MLA Loan Origination Module
- Evaluated large datasets for quality and accuracy.
- Devised site maps and mockups for designs based on proven methodologies and end-user feedback.
- Experience in creating triggers, tables, stored procedures for various applications.
- Collaborated with QA team to test software quality through manual and automated testing.
- Teamed on planned tests and time-sensitive ad hoc requests.
- Wrote and optimized test cases in JIRA and ADO.
- Designed and maintained consistent data collection protocols and standards across numerous databases and projects.
- Defined and identified test cases for new application development.
- Supported management by processing invoices and documents with consistent on-time delivery.
- Managed complex problem-solving for upper management in order to complete projects on-time and within budget.
- Effectively communicated with clients about payment needs and kept updated, detailed and accurate ledgers.
- Organized system operating procedures to strengthen controls
- Identified needed business improvements and determined appropriate systems required to implement solutions.
- Organized system operating procedures to strengthen controls.
- Identified patterns and trends in large data sets and provided actionable insights.
- Utilized data visualization techniques to present and explain complex data sets.
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
- Improved business direction by prioritizing client s and implementing changes based on collected feedback.
- Conducted user interviews, gathered requirements, analyzed, and documented Project Scope Agreement (PSA)
- Facilitated and managed Meetings and Focus Group Sessions with both domain and implementation Subject Matter Experts (SME) from various business areas to understand existing business and workflow processes
- Conducted Elicitation and translated Elicitation results into Business Requirement Document (BRD)
- Supported initiatives to enhance operational risk reporting to address regulatory issues
- Maintained procedures for regulatory reporting environment
- Collaborate with colleagues in gathering documents and completing applicable credit reviews
- Evaluate creditworthiness of companies within technology media and telecom and consumer, retail, and healthcare
- Analysis of company's overall ability to continue performing on its outstanding debt
- Acquire better understanding of company's ability to repay debt and interpretation from accurate information and historical trends
- Responsible for identifying and managing data elements, requirements scope, risks, and issues
- Involved in Designing activities and developed Use Cases, Activity Diagrams, and Prototypes
- Responsible for Active Directory Global Access Management
- Actively participated in Structured Walk-through of Prototype and was responsible for getting sign-off from business members
- Collected data to analyze, prepare and submit all Regulatory Reports
- Liaison with Operational Group Leaders to address pressure points and irregularities between financial management group and operational partners
- Involved in requirements analysis and translated high-level requirement from BRD and Use cases to detailed Functional Requirement Document (FRD) per approved prototype.
- Tested and deployed scalable and highly available Data using SQL
- Determined root cause of data quality errors and recommended long-term solutions.
Business Risk Analyst
First National Bank Of Pasco
01.2021 - 09.2021
- Collaborated with sales and marketing departments to support client acquisition.
- Identified and pursued valuable business opportunities to generate new company revenue and improve bottom line profit.
- Communicated directly with customers and partners to build strong business networks and relationships.
- Negotiated client contracts and agreements to cultivate profitable business transactions.
- Utilized market trends, mission priorities and customer goals to envision, shape and close new opportunities.
- Developed short-term goals and long-term strategic plans to improve risk control and mitigation.
- Designed and monitored underwriting scorecards and related predictability.
- Taught employees how to control risks at front line.
- Monitored industry, technological and economic developments to stay current on potential risks.
- Compared industry-specific securities against outside metrics and each other to develop recommendations.
- Conducted statistical analysis and evaluated risk via use of portfolio management software.
- Looked at current and new merchants and individual sales to evaluate fraud, chargeback and compliance risks.
- Informed financial decisions by analyzing financial information to forecast business, industry or economic conditions.
- Processed management reports on monthly basis through effective collaboration with various departments.
- Analyzed and documented company processes for executive leadership and suggested areas for improvement.
- Gathered documentation and created reports on assessed information.
- Conducted walk-through demonstrations of proposed process changes.
- Designed process models to provide clear, understandable tools for presenting complex business processes to individuals with minimal knowledge on topic.
- Offered data-driven recommendations to align company strategies and process improvement initiatives.
Senior VP, Corporate Banking
PNC Bank
06.2017 - 12.2019
- Worked with members of the application development teams to design and integrate applications with Role-Based Access Control system RBAC
- Identified needed business improvements and determined appropriate systems required to implement solutions.
- Identified opportunities to improve business process flows and productivity.
- Hired and managed employees to maximize productivity while training staff on best practices and protocols.
- Led restructuring and turnaround through development of new leadership team.
- Presented and discussed strategy and initiative progress with senior business leaders.
- Developed measurement tools, dashboards and reports to track metrics on adoption and effectiveness of initiatives.
- Analyzed financial and supporting documents on incoming applications consistent with internal and insurer policies for Mortgages
- Worked with AML Investigators, Analysts, and Auditors in recognizing the process flows to improve the workflow to develop a Case Management Tool
- Maintained full compliance with trade laws and regulations by tracking changing conditions.
- Supported implementation of new trade partners and monitored KPIs for performance optimization.
- An understanding of Basel II Credit Risk RWA calculations and regulatory reporting processes
- Organized system operating procedures to strengthen controls.
- Created and achieved product quality objectives and met product specifications.
- Preserved compliances by ensuring that the organization’s regulations, policies, procedures comply with work including Bank Secrecy Act (BSA), Anti Money laundering (AML), BASEL III, Sarbanes Oxley Act (SOX), Know your Customer (KYC), Enhanced Due Diligence (EDD), CDD, and Customer Identification Program (CIP) and regulations
- Performed GAP analysis by reviewing the existing AS-IS process, proposing possible areas to improve to achieve the TO-BE system
- Used XML to do data mapping
- Ensured there was the establishment of Process Alignment between Business Process Objectives, Performance Measures with organizational objectives and strategies to avoid conflicts and inept activities
- Transcribed user stories and acceptance criteria and crisscross if they passed the criteria of INVEST rule
- Worked closely with product owner in effectively maintaining and prioritizing the Product Backlog and release plan
- Facilitated Knowledge Transfer sessions between the team leveraging JIRA for project planning, scheduling, drafting epics, stories, sprint burn up, burn down charts, expectation charts, and status reporting while using KANBAN board for the visual flow of the process
- Created detailed Use cases, BPMN flows, Functional Specifications, UML diagrams to remove the ambiguity of the requirements communicated by clients or SMEs leveraging VISIO
- Executed SQL queries including complex joins and multi-level filters by leveraging MS SQL on large data sets for exploratory analysis, research analysis, extracting data and ad-hoc reporting, KPI reporting
- Assisted in SOA by determining along with the team how the best requirements and Business Rules can be crafted and grouped for maximum efficiency and visibility during SOA (Service-oriented architecture)
- Assisted the project management team in identifying/mitigating project risks and analyze/streamline KPI, business processes, workflows, and project scheduling
- Instigated communication using Rest with data type XML/JSON, documented APIs on Swagger and web service requests and responses; took part in API/ Webservice testing and leveraged SOAP UI for load and performance testing of web APIs
- Familiar with UI development which was designed and developed in Java and JavaScript including REST Interfaces
- Used SharePoint as a collaboration tool for Knowledge sharing, Artifacts sharing, and as a communication tool
- Assisted stakeholders in defining the boosting of incident deflection to reduce the rate of creating incidents and volume
- Developed and documented several Incident Management process models, SLAs for the role of Incident Manager
- Facilitated UAT sessions and Performing UAT requirements analysis, write and execute UAT scenarios
- Leveraged Tableau, Excel V-lookups, and Pivot Tables, VBA for building KPI dashboards, ad-hoc reporting, automating project status, and getting insights from data for business needs.
- Complied with established internal controls and policies..
Sr. Business Development Officer
SunTrust
06.2015 - 06.2017
- Implemented Agile/SCRUM methodology of Software Development life cycle to develop business process models and was responsible for documenting various project activities and deliverables for the MLA Loan Origination Module
- Conducted user interviews, gathered requirements, analyzed, and documented Project Scope Agreement (PSA)
- Strategized with sales team to prospect and qualify potential customers within assigned geographic territories.
- Facilitated and managed Meetings and Focus Group Sessions with both domain and implementation Subject Matter Experts (SME) from various business areas to understand existing business and workflow processes
- Conducted Elicitation and translated the Elicitation results into Business Requirement Document (BRD)
- Supported initiatives to enhance operational risk reporting to address regulatory issues
- Maintained procedures for the regulatory reporting environment
- Delivered campaigns to solidify new client opportunities and generate new business.
- Collaborate with colleagues in gathering documents and completing applicable credit reviews
- Evaluate creditworthiness of companies within technology media and telecom and consumer, retail, and healthcare
- Analysis of company's overall ability to continue performing on its outstanding debt
- Acquire a better understanding of a company's ability to repay debt and interpretation from accurate information and historical trends
- Responsible for identifying and managing data elements, requirements scope, risks, and issues
- Involved in Designing activities and developed Use Cases, Activity Diagrams, and Prototypes
- Responsible for Active Directory Global Access Management
- Actively participated in a Structured Walk-through of the Prototype and was responsible for getting the sign-off from the business members
- Collected data to analyze prepare and submit all Regulatory Reports
- Liaison with Operational Group Leaders to address pressure points and irregularities between the financial management group and operational partners
- Involved in requirements analysis and translated the high-level requirement from BRD and Use cases to a detailed Functional Requirement Document (FRD) per the approved prototype
- Created and maintained a Requirements Traceability Matrix (RTM) for tracing, approaching, and managing changes in requirements
- Partner with Technology Leads to spearhead GAP analyses between finance business leaders and the current BOA proprietary platform
- Collaborate with other technical teams such as developers and QA to walk through and explain the requirements and answered all questions and provided clarification
- Involved in creating Test plans by providing and deriving estimates
- Performed End-to-End Testing of MLA Loan Origination Module by testing both UI and backend
- Production Release and Project Success Verification.
Business Development Analyst
BBVA Compass
06.2010 - 06.2015
- Gathered and documented requirements for the Master Data Management perspective with the help of various tools including but not limited to Use Cases, Process Flow Diagrams, Business Rules for Source-To-Target Mapping
- Involved in detailed discussions for End-to-End Process for various business processes like Account Level Reporting, Balance Transaction Reporting, Payments, and Statements Processing
- Performed Data Profiling of the current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data, and formulating solutions for the same
- Gathered requirements for sourcing and delivering the data and Interface requirements between various Partner Systems for Payments Processing for Corporate Banking purposes which involved detailed understanding of Payments and Processing Standards like IBANs, SWIFT, ACH, etc
- New report programs for credit card transactions have been developed
- New custom fields have been introduced in the Credit process
- Coordinated and hosted meetings with multiple cross-functional groups involving Users and Product Managers from distinct Business Groups to understand business requirements, formulate a solution and discuss timelines
- Collaborated with the QA Team to help build test scenarios and test cases and do some ad-hoc manual testing using SQL
- Responsible for getting Agreements and Approvals for Requirements and Implementations from Technology System Partners and Business Owners
- Maintained extensive knowledge of company products and services to provide top-notch expertise to customers.
- Lead and monitor the development team in terms of prioritizing tasks, creating milestones, and providing business context to development efforts
- Formed advanced SQL Queries and used Microsoft Excel to investigate data issues in the Data Warehouse and worked with the Users and Technology Team to formulate a solution to resolve the issue.
Education
MBA - Human Resources Management, Information Technology
NUML
Remote03.2007
Skills
- Compliance risk management
- Excellent Communication
- Analytical and Critical Thinking
- Risk mitigation
- Stop-loss reporting tools
- Predictive modeling
- Equity derivatives
- Business process mapping
- Expert to create functional Requirements Specs for Cloud services in past projects
- Competitive analysis
- Solution testing and implementation
- Personnel training
- Maintained and scheduled iteration time frames and analyzed development efforts require per each sprint
- Extensive knowledge in Anti Money Laundering processes, Small Business Loans, and Delinquencies, Identity Access Management, Identity Access Governance, Risk-Based Access
- Knowledge of Mortgage Loan Origination Systems, Loan Servicing, Payment Card Industry, Data Security Standards (PCI, DSS), and PA DSS requirements and compliances
- Extensive involvement in Bug tracking and defect management processes through using tracking tools like JIRA and VSTS
- Agile expertise
- Extensively experienced in agile scrum environment were delivered as Business Process Manager/ Scrum master at times
- Extensively worked with DevOps Engineers to plane ART (Agile Release Train) in order to get effective planning for smooth transitions on build dependencies and deployments
- Expertise in Unified Modeling Language (UML) for creating Use Case Diagrams, Class Diagrams, Activity Diagrams, Sequence Diagrams, and Workflow Diagrams using Rational Rose and MS Visio
- Ability to Strategize Product development roadmap in collaboration with Business stakeholders
- Ability to provide direction to Agile Development team in line with Product Vision and collaborate with various cross‐functional teams
- Documenting expertise in BRD, Requirement Traceability Matrix (RTM), Use case documents, and User stories
- Extensively Used SQL and T‐SQL Queries for data manipulation and reading/ add business logic to application Back-end system
- Well experienced in different management scenarios like Change Control, Quality Assurance, Defect Tracking, System Integration, and Scheduling
- Technical Expertise:
- Gap analysis
- FINANCE DOMAIN KNOWLEDGE
- Credit Risk Analysis Certification
- SOFTWARE DEVELOPMENT LIFE CYCLE
- Kanban, Agile-Scrum, Waterfall - Agile hybrid, Waterfall, RUP, SAFE
- BUSINESS SKILLS
- Financial Modelling, Forecasting and Budgeting, DCF Analysis and Business Valuation, ROI Analysis, Release Planning, Change Management, Competitive Analysis, Risk Management, User Testing, Conflict Resolution
- BUSINESS MODELLING TOOLS
- Lucid Chart, MS Visio, Rational Rose, Mockups,
- PROJECT MANAGEMENT, TESTING, and PERFORMANCE TOOLS, TOSCA QTEST
- Manual Test Analysis
- System Validation
- Develop Test Cases
- Bug Tracking and Resolution
- Key Performance Indicator Tracking
- Client Requirements
- Test Implementation
- JIRA, HP ALM, HP-QC, Confluence, Cucumber, MS Project, MS SharePoint, Jenkins, Soap UI, Swagger, Postman, Load Runner
- BI AND REPORTING TOOLS
- IBM Cognos, Tableau, MS Power BI, MS Office Suite (Excel, Word, PowerPoint, Access)
- Service-Oriented Architecture (SOA), Microservices N - Tier Architecture, 3 Tier Architecture,
- DATA WAREHOUSING
- Mergers & Acquisitions
- Data organization
- Data Modeling
- Data analysis
- Data Mapping
- Business planning
- Sprint Tracking
- Defect Resolution
- Manual Test Case Preparation
- Software Development Tools: JIRA, Confluence
Timeline
(SVP) Data Integration Lead Analyst
Citigroup Inc
10.2023 - Current
(SVP) IT Tech Analyst
Littelfuse
05.2023 - 08.2023
(SVP) DATA/BUSINESS SYSTEM ANALYST
Citizens Bank
02.2022 - 04.2023
Senior Data Analyst
Choice Payment Services
09.2021 - 02.2022
Business Risk Analyst
First National Bank Of Pasco
01.2021 - 09.2021
Senior VP, Corporate Banking
PNC Bank
06.2017 - 12.2019
Sr. Business Development Officer
SunTrust
06.2015 - 06.2017
Business Development Analyst
BBVA Compass
06.2010 - 06.2015
MBA - Human Resources Management, Information Technology
NUML
Similar Profiles
SALOMON KOFFISALOMON KOFFI
Securities and Derivatives Associate Analyst 2 at Citigroup IncSecurities and Derivatives Associate Analyst 2 at Citigroup Inc
Aravind Pitchai GuruswamyAravind Pitchai Guruswamy
Digital Transformation Lead (Transact & Servicing) at Citigroup IncDigital Transformation Lead (Transact & Servicing) at Citigroup Inc
RENAUD SIFFORTRENAUD SIFFORT
Fund Accounting Assoc Analyst at Citigroup IncFund Accounting Assoc Analyst at Citigroup Inc