Experienced Business Analyst with a strong background in investment banking and financial services, specializing in the KYC lifecycle, AML, and sanctions risk management. Proficient in Agile and Waterfall methodologies, database design, data modeling, and data quality management. Skilled in AWS services, web development technologies, and integrating Python scripts into Java applications. Excellent communicator with a proven ability to manage large projects and collaborate with diverse teams. Passionate about leveraging technology to improve healthcare delivery and patient outcomes.
· Modified and tuned stored procedures, triggers, views, and indexes to optimize performance.
· Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.
· Evaluated wire transfers and other payments for potential fraud, money laundering, patterns, and inconsistencies.
· Analyzed clients' databases to create Customer Monitoring Reports.
· Prepared Daily Recon Reports, weekly, and monthly metrics for MI dashboards using MS Excel and SQL.
· Interacted with bank management on suspicious transactions conducted by customers.
· Involved in research, writing, and reviewing Suspicious Activity Reports daily to ensure compliance with federal regulations.
· Performed Enhanced Due Diligence on high-risk customers, suggesting account restrictions or closures based on institutional risk.
· Worked closely with team members and other financial institutions to fulfill USA Patriot Act Sharing of Information requests.
· Stayed updated on current Red Flags and industry trends related to AML.
· Proficient in front-end development using HTML, CSS, JavaScript, and popular frameworks/libraries like React, Angular, and Vue.js.
· Experienced in using .NET Framework, ASP.NET, and .NET Core to create intuitive and engaging user interfaces.
· Solid understanding of DevOps practices and tools for continuous integration and deployment on AWS, including AWS Code Pipeline and AWS Code Deploy.
· Participated in Daily and Weekly meetings, providing status updates.
· Prepared weekly presentations and decks for PRB meetings and monthly review calls.
· Conducted data analysis to identify key trends and insights, providing actionable recommendations to support strategic decision-making using MS Visio and SQL Server Management Studio (SSMS).
· Created numerous processes through MS Visual Studio (SSIS, SSAS, and SSRS).
· Developed and maintained interactive dashboards and reports using BI tools such as Tableau and Power BI, delivering critical business metrics to stakeholders.
· Designed complex T-SQL queries and User Defined Functions.
· Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures, and Triggers.
· Ensured data accuracy and integrity through rigorous validation processes, implementing data governance standards to maintain high-quality data assets.
· Collaborated cross-functionally to understand business needs and translate them into data-driven solutions, effectively communicating findings to non-technical stakeholders.
· Continuously monitored and evaluated BI processes and methodologies, seeking opportunities for optimization and improvement to enhance organizational efficiency.
Databases
Microsoft SQL Server 2005, 2008, 2008 R2, 2012, 2016, and 2019 and PLSQL Developer,
DB Visualizer, MS SQL Server 2008, MS SharePoint, Confluence, MS Team Foundation Server (TFS), Data Flux DF Power Studio 822
Web Development
HTML, JavaScript, C# and SQL, PL/SQL, PowerShell
Languages
Java, Python, SQL
Tools
Visual Studio, SQL Server Management Studio (SSMS), SQL Server Management Studio (SSRS), Papyrus, Tri Resolve, Microsoft Visio 2010 and 2013, Oracle eBusiness Suite 11i, Billyzee, Tally 81, Tally ERP 9, GIT Bitbucket, Jira, AWS CloudWatch, AWS Command Line Interface (CLI), Tableau, Power BI Service
Operating System
Windows 2003/2008/2012/2016/2019, MacOS