Project 1 Mobile Banking The project involved a new Mobile Retail Banking application for all homeowners, providing loan pre-approval application facility, loan approval facility, and helping clients to choose the right kind of loan. The other areas of the project focused on adding features in Mechanics website to check their balance, depositing checks through Mobile devices, transferring funds, and paying bills online. I worked closely with Marketing, Customer Service Center, Operations, Legal and Compliance to help analyze, document business requirements, process flows, and data needs to leverage a smarter way which allows customers to carry out banking operations such as: Select Accounts, Credit Cards, Access electronic and wire Transfers and Payments, and Display Pending and Scheduled Transfers and Payments (Mortgage). The project encompassed Retail banking, Credit Cards, SOX, Basel lI, PCI compliance and Mortgage Applications. Responsibilities:
• Provided administrative support by working closely with Project Manager (PM) to create and maintain project documents and have written grant proposals.
• Aggregate and preprocess data using R and MySQL.
• Interact with SME's for gathering requirements and specifications for the applications and preparing business requirements document.
• Facilitate effective status update and sign-off meetings with Executive Board Members and PMO Representatives.
• Conduct requirement gathering, walkthrough sessions with business requestor, testing and Development team.
• Review Business Requirement Documents (BRD) and prepare Use-Case Specifications and Functional specification documents (FSD).
• Chair Requirement Gathering Sessions, Joint Application Development (JAD) sessions and lead the effort to get Business and System requirements baseline (stakeholder approval).
• Utilize Agile development methodology SCRUM as a lightweight process we used to manage and control software and product development.
• Take a major part of the Change Control process and followed up all the Change Request (CR) with impact analysis on Scope, Schedule and Budget constraints and worked with the Change Control Committee.
• Develop the Business Requirement Document based on the research & analysis of PCI.
• Gather and Document PCI regulations and requirements for credit card payments.
• Create Use Cases to document alternate business scenarios and designed UML diagrams.
• Propose requirements for the future state system by applying payment domain knowledge and information collected by interacting with legacy system users.
• Develop prototypes and screen mock-ups using MS Visio to facilitate interactive discussions with stakeholders and developers.
• Optimize the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Review Logical and physical database design using Erwin Tool.
• Using Business Intelligence development studio (BIDS) create Dynamic ETL SSIS Packages to validate, extract, transform, and load data from different sources like web services and also involved in checking data quality, data cleansing and data transfer.
• Worked on huge data transfers from & to SQL Server Databases using SSIS and used configuration files for production deployment.
• Determine the level of formality required and considered options for documenting and packaging requirements based on project type, priorities, and risks.
• Conduct Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current (AS IS) environments versus the Target (TO BE) environment.
• Clarify QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested the same.
• Initiate and Exercise various strategies involved in website Usability, Functionality, and Compatibility testing.
• Conduct User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues. Also familiar with testing tools to design and develop test plan and test scripts. Environment: UML, Agile (SCRUM), Use Case Analysis, MS Word, MS Power Point, MS Excel, MS SQL server, MS Outlook, T-SQL, SSIS 2012, MS Visio, MS Project, Quality Center. Project 2 Nice Actimize Solutions (AML Reporting) Enhancement of NICE Actimize solutions for the Anti-Money Laundering (AML) Transaction Monitoring System which enables end-to-end coverage for the detection, scoring, alerting, workflow processing, and reporting of suspicious activity. The project is focused on the preparation of CTR (Currency Transaction Report) and SAR (Suspicious Activity Report) as per the AML compliance laws using the NICE Actimize software. Responsibilities:
• Assist in the administration and review of Client Risk Scoring, Client Identification, Client Onboarding, identifying Key Risk Indicators (KRI) and KYC documentation oversight/management requirements.
• Led and implemented end-to-end AML KYC process and platform transformation initiative to improve AML Customer Due Diligence (CDD), Enhanced Due Diligence (EDD), Customer Risk Profiling processes to comply with OCC consent order requirements and AML regulations.
• Troubleshoot CDD and WLF alert issues working with Actimize and identified and reported trends of fraudulent inquiries to senior management.
• Thorough understanding of various modules of AML including Watch List Filtering, Suspicious Activity Monitoring, CTR, CDD, and EDD.
• Prepare Business & Functional requirement documents for securities reporting application using standard SDLC templates in MS Word.
• Maintain SDLC standards by documenting Project Request Document, Project Planning Document, BRD, FRD, Scope Document, RISK Scorecard, and Planning Phase End Metrics.
• Developed Tableau Data Visualization using Pareto's, Combo charts, Heat Maps, Box and Whisker plots, Scatter plots, Geographic Map, Cross tabs and Histograms.
• Write business requir