- Led Firco projects regarding implementing FircoTrust and Continuity and conducting filter upgrades - Designed and conducted daily auto trust screening on individual customer, legal entities and vessels through control-M jobs. - Conducted continuity real time screening on SWIFT payment and Fedwire Payment- Validate updated KZ file through FMM to ensure newly added individual entities or vessels required by different regulators are reflected in the KZ file.- Worked with Compliance team to write and modify rules in FML to suppress false positive alerts - Worked with production support team to design Control-M jobs to Monitor Firco trust- Worked with Compliance team to implement list of high risk customers and exceptions list to increase efficiency of alerts. - Worked with Vendor Company to upgrade Filter Engine and watchlist file to the latest version in the marketplace to provide better monitoring results- Designed KZ file generation process with developers and production supporting team. - Drafted, tested, and deployed various complex, new rules in Continuity with Firco Continuity and Firco Trust - Used Firco Utilities to perform different tasks. Used FFF classic to conduct testing, FMM to manage KZ file, FML to write, modify and maintain rules. - Conducted testing in staging environment to ensure it functions properly- Automated simple reporting and data manipulation processes utilizing Visual Basic (VBA) programming language in conjunction with an Open Database Connection (ODBC)- Gathered business requirements through JAD sessions to write business/functional requirement document

- Extracted data from different sources (DB2, Teradata, Oracle Databases and flat files) and load it into Oracle Database 19c- Designed Executive Reports using Power BI for value propositions and/or other Executives Status Reports and Executive Dashboard Summary for each project - Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses- Controlled and tracked project performance, time allocations, cost, and quality by evaluating project progress and conducting regular team status meetings. - Determined and defined business requirements based on clientele specifications to devise individualized plan structures that align with needs and client vision. - Identified & promoted best practices, provide oversight within the Team, contribute to the dynamic Repository for Re-usable knowledge assets.- Used SQL to group transactions by Year and Quarter, find total amount of money in an account using from different services from the bank, and update Account balance.- Assisted with automation of daily tasks and advanced analytics department’s manual processes by writing Power Automate Desktop code and using macros and formulas to increase speed of processes and maximize accuracy - Leveraged Microsoft Visio and Lucidchart to construct use cases, class diagrams, activity diagrams, workflow process diagrams, and assemble use case narratives - Guided project teams through structured problem-solving approaches, highlighting pressing issues and formulating analytical engagement solutions. - Authored & manage self-service Business Intelligence (BI) design specifications, develop, review & test reporting Semantics (models), Dashboards & Visualizations.

- Used PowerBI to identify high-potential prospects and customers, target products and services to prospects or customers and track revenues and expenses and report monthly KPIs- Mapped employees and their projects into resource management system. Created Heatmap of hours worked, so that workload is more evenly distributed. - Facilitates and lead daily and weekly standup status meetings including meeting minutes and building Dashboard Summary to track project timelines and mitigate issues. - Improved quality and accuracy of financial statements by identifying and remediating data quality issues credit card transaction. - Involved in expansion of zero-dollar online trade benefits, enabling unlimited commission-free stock, exchange-traded fund.- Gathered requirements for Merrill Edge Self-Directed platform to enable client access to market research and make informed investing decisions. - Conducted User Acceptance Testing for Mobile Banking App so that it enables clients to begin application for new credit and complete it at a later time within the app. - Worked with teams and customers to understand the data sourcing and integration requirements for each of the assigned program work streams, ensuring long lead integration activities are identified, coordinated and feed into the portfolio planning, data governance, data quality and master data management activities - Collaborated with cross-functional departments to build automated dashboards, utilizing Tableau and Python, that assist leadership leverage key data. - Collaborated with key stakeholders/application teams to understand, document and prioritize the critical data elements (CDEs) required to support key business measures / KPIs needs - Performed data analysis by accessing the data using queries or reporting tools including mapping the business functions to the data and data model, data reconciliations, gap analysis

- Worked with various departments to gather requirements for implementing Ink Business Unlimited Card, including account opening, overdraft protection, minimum payment, rewards program and available leverage- Conducted analysis, design and development, on credit card application and issuing- Created mapping documents outlining data flow from sources to targets, established Entity Relationship diagrams, and developed design specifications - Directed task delegation and performance management of developers, ensuring alignment with scope and quality objectives - Performed User Acceptance Tests (UAT) to facilitate system migration from financial data warehouse to SQL Server and ran monthly production parallel. - Led design and development walkthrough, participated in data models and database design reviews, and delivered key contributions to implementation of best practices and standards for data integration environment. Provided technical assistance to team members and bolstered troubleshooting and alternative development solutions. - Developed ETL jobs utilizing various transformations as per technical specifications, extracted data from flat files and other databases into staging area and populated onto RDBMS data warehouse- Generated reports with pivot tables and Power BI that visualize revenue generation by market, company performance for business partners and the senior leadership.- Liaised with key stakeholders and subject matter experts across multiple disciplines within the company to understand their priorities and align the outcome of the program with the organization's overall business goals

- Worked with various stakeholders to gather requirements and develop solutions via code, reports, to testing and release/deployment - Identified and documented Functional/Non-Functional and other related business decisions for implementing new system to comply with AML regulations. - Worked with development to create key Loans and Securities lending application to improve onboarding of new clients onto the lending system. - Designed workflow diagrams, wireframes, and mockups to allow customers to securely transfer wire money via Apple Pay and earn cashback rewards - Analyze calculations and verifications of income & assets, and evaluations of credit reports, purchase contracts, appraisals, title commitments, and other loan pertinent documentation - Facilitated requirement review meetings via workshops, interviews, case studies and any other effective means. Document and maintain Operational Processes including capture of As Is Processes and definition and mapping of To Be Processes - Performed system by system analysis of the “As is” state of the investment bank’s internal system across the entire institution in relation to specific KDE sets and its related metadata - Performed data analysis by accessing the data using queries or reporting tools, including mapping the business functions to the data and data model, data reconciliations, gap analysis - implemented dashboards, reports, and visualizations that are optimized for performance and use best practices - Assisted in facilitating the migration of the bank’s legacy data feeds to a new strategic cloud based Tableau platform with a long-term goal to create a centralized data source for trade surveillance and regulatory reporting

- Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of ETL jobs and reporting jobs. - Conducted Testing on Clearing and Settlement Mechanism and User Acceptance Testing for Real Time Payment System - Aligned architecture to company strategy to deliver structured, efficient, sustainable & adaptable IT solutions in line with the business needs for Swift Processing and Clearing Systems RTP- Designed pre-funding QC audit report based on data generated by Bank Loan Portal to ensure all loan documents are complete, accurate, and comply with the terms and conditions of the lender. - Prepared and analyzed financial data for loan portfolios, providing senior management with analysis and recommendations for decision making - Coordinated the user acceptance testing between client and their customers.- Liaise with key stakeholders and subject matter experts across all disciplines within the bank to understand their priorities and align the outcome of the program with the organization's overall business goals - Assisted with automation of daily tasks and advanced analytics department’s manual processes by writing VBA code and using macros and formulas to increase speed of processes and maximize accuracy - Ensured that risks posed by products and services offered, customer risk profile and geography risk are covered by transaction monitoring scenarios in place. - Performed data manipulation, transformation, and cleansing to create pivot tables and reports to present to clients and management using SQL, MS Access, Excel, and Visual Basic script - Operated SWIFT messages service for financial messages, such as letters of credit, payments and securities transactions, between member banks worldwide. - Reviewed requirements from the customer to test their files and provided feedback to customers for corrections. - Created business flow and test documents and for management and customer base.

- Wrote Business Requirements and test cases for Transactional level receipt imaging so that customers can upload and manage receipts directly on their mobile devices.- Wrote test case for Android Pay to make sure that when customers pay with their mobile, they receive a notification on both the app and on text messages.- Maintained versions of Business Requirements Documents in Sharepoint, broke down User Stories for execution for the development team. - Reviewed requirements from client to test their files. Coordinated User Acceptance Testing between client and customers. Created business flow and test documents for management and customer base. - Diagrammed workflow for client onboarding process and improve customer experience by minimizing manual data entry. - Compile and validate data that support performance improvement activities - Prepare, review and generate closing documents according to client specifications ensure all compliance requirements - Extracted and analyzed data using various tools such as SQL, Access, and Excel - Interviewed various groups to gather requirements for simplifying Enrollment Forms to improve customer onboarding experience. - Conducted Gap analysis to identify products that are not being monitored and look for redundancies on transaction monitoring scenarios in place.