SUMMARY:

• Business Analyst with over 7 years of experience in Financial, banking and Investment Banking Sectors with all phases of the Project Development Life Cycle.
• Excellent knowledge of the Misys Loan IQ Batch Execution Framework
• Expertise in development with Misys Loan IQ APIs
• Expertise in underlying Misys Loan IQ data model and components
• Very good understanding of implementing trading applications and managing projects involving entire bond trading work flows.
• Mapping data in Tableau Automating and transforming workbooks and delivering capabilities in the user friendly GUI.
• Strong Experience in Agile, Waterfall, Object Oriented Analysis and Software Development Life Cycle (SDLC) processes
• Experience in Requirement gathering through participating in interviews, workshops, and JAD sessions with clients, developers, and QA Analysts, and referring to existing system documentation and procedures.
• Well - versed in documenting Business Plan, Requirement documents, Functional Specification documents, and Standard Operating procedures
• Experience in Conducting Market Research, Feasibility Studies, and Data analysis, System Analysis, Gap Analysis and Operational Risk Analysis.
• Experience in creatingUML (Unified Modeling Language) diagrams such as workflow, activity, use case, sequence, collaboration and deployment diagrams.
• Knowledge of Fixed Income Securities, Equities, Stocks and Bond Management
• Strong Knowledge of Supply Chain Management, Financial Analysis, Fixed Income Securities (bonds, stocks etc.) and Mutual Funds.
• Experience in conducting GAP Analysis, Risk Analysis, SWOT Analysis, Cost-Benefit Analysis (CBA), Return on Investment Analysis (ROI), and Break Even Analysis.
• Possess advanced SQL programming skills, strong understanding of data warehousing concepts and experience working with large relational databases.
• Knowledge of Capital Markets, Asset Management, Financial Services.
• Performed data query, extraction, compilation, and reporting tasks using SQL application.

TECHNICAL SKILLS:

Operating Systems: Office 365, Windows 7/XP/Vista, Mac OS X.

Business Modeling Tools: Microsoft Visio

Databases: SQL Server, Oracle, MS Access.

Project Management: Microsoft Project Professional, Microsoft Office Suite, and ITIL

Programming/Languages: Java, HTML, ASP.Net, C#, SQL Server; Visual Basic, JavaScript

Testing Tools: HP QC/ALM

Design & IDE Tools: MS Visual Studio.

Office Tools: MS Word, Excel, PowerPoint, Outlook, Publisher, and Photoshop

Requirement Management Tools: Caliber RDM, Caliber RM, SharePoint

Defect Tracking Tools: JIRA, HP QC-ALM

Methodologies: UML

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Manage deliverables of the Banking and Lending program i.e. leading sub-projects through analysis, design, testing, migration and implementation.
• Lead functional requirements gathering sessions with the business. Document and validate functional requirements with the business. Assist in the review of functional requirements with IT.
• Experience with application development methodologies such as Agile including writing user stories/epics and acceptance criteria using Jira.
• Knowledge of cloud-based subscription service office 365.
• Managed combining various apps like Excel and Outlook with powerful cloud services like OneDrive and Microsoft Teams.
• Create and share information and documents through Office 365
• Proficient with financial services: Commercial lending, Syndicated lending, Payments, Funding
• Knowledge of Capital Markets: Loans, including Operations, Deal Structure, Loan Types, and the various businesses that support Loans
• Interface with business users to help define the business processes as well as gather, analyze, and document business requirements.
• Created Use Cases / Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model. Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle
• Assisted and provided information to support Suspicious Activity Reports (SAR) or equivalent for regulatory filing.
• Excellent sharepoint Skills
• Maintain a strong investigative skills; the ability to work independently, demonstrated extensive banking and Compliance knowledge.
• Ensures the process outputs needed by the project team are created in a timely fashion including business and functional requirements, use cases, flow diagrams, etc.
• Tracks the key output documents and notifies the project team of changes and potential impacts to project requirements; initiates change request when needed. Support the Development Lead and the Project Manager to maintain the artifacts in Delivery Tracker on time
• Liaise with key stakeholders to determine priorities and challenges
• Conduct workshops and interviews with stakeholders
• Define & manage business specifications end-to-end and act as facilitator between the Operations Change the bank team, IT and other areas such as reporting, finance, legal & compliance etc.
• Knowledge of Confidential payment processing that enhances banking operations by originating payments, deposits and payroll direct deposits for corporate and retail customers
• Understanding of Confidential returns and Notices of Change (NOC).
• Execute Analysis & Design in different stages of the project
• Detailed test planning and coordination of testing activities front-to-back in cooperation with other involved areas
• Conduct workshops and interview with stakeholders
• Work with QA and Business Owners to develop QA/UAT test plans/cases.
• Excellent knowledge of the Misys Loan IQ Batch Execution Framework
• Expertise in development with Misys Loan IQ APIs
• Expertise in underlying Misys Loan IQ data model and components
• Expertise in Loan IQ table maintenance
• Good SQL skills
• Ability to troubleshoot / follow a methodical approach to problem resolution
• A sound knowledge of loan transactions and processing, including P/L events and fees
• Experience of Event Manager configuration and setup
• Knowledge of Loan IQ GL accounting
• Experience of working with data feeds and interfaces from Loan IQ
• Interpersonal skills + good verbal & written skills required to interact with global teams
• Strong analytical and organizational skills
• Proficiency with MS Office programs, such as Excel, PowerPoint, Visio
• Knowledge of Equity and Securities based Lending products

Confidential, New York

Business System Analyst

Responsibilities:

• Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis, interaction with business and project stakeholders
• Analyzed business workflows and suggest improvements
• Provided leadership to IT, development teams and business teams throughout the development life cycle
• Worked for trading platform dealing with Fixed Income Securities &Equities
• Define system requirements (BRD - Business Requirements Document) for complex, multi- departmental and multi-functions projects across geography
• Review with user’s functional specifications (FRD - Functional Requirements Document), providing feedback
• Tracked maintained accounts to identify any discrepancies.
• Conducted research and investigation of all discrepancies.
• Updated accounts with accurate information.
• Reconciled discrepancies efficiently and in a timely manner
• Performed Enhanced Due Diligence on customers deemed high risk, and suggested account restrictions and/or account closures based on risk to the institution.
• Manage communication between key project stakeholders (Operations, Technology, Compliance, Business)
• Reviewed and analysis on Moderate Risk accounts
• Conducted enhanced due diligence research of individuals, institutions and trust through LexisNexis and other internet tools.
• Interacted with Bank management on suspicious transactions conducted by customers.
• Conducted user interviews and JAD sessions to get an understanding of client business process
• Performed GAP analysis ensuring business compliance and Risk
• Develop business architecture using requirements such as scope, processes, risks
• Creation of business-process model diagrams, flows & requirements using MS Visio
• Developed Gap Analysis specification based on “as-is” and “to-be” models and mapping of business processes
• As a Scrum Master facilitated the transition from Waterfall to Agile.
• Hands on coaching in all aspects of scrum-daily meetings, scrum ceremonies.
• Analyzed all data warehousing components (e.g. tool integration strategy; source system data ETL strategy
• Created the ETL specification for loading the Data Warehouse using EXCEL.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Developed the test scenarios, test conditions and test plans based on business requirements, technical specifications and/or product knowledge in Quality Center
• Played a key role in the planning User Acceptance Testing and implementation of system enhancements and conversions.
• Created product documentation, including online help, printed user manual, and training materials.
• Assisted in new client onboarding including data entry into several onboarding systems and AML screening
• Interfaced with SMEs to prepare BPR documents for ongoing GDD projects.
• Supervised all compliance related tasks including onboarding and AML/KYC related elements including PEP screening; filed Internal Suspicion Activity Report for Money Laundering
• Working knowledge of AML/BSA risk assessment and mitigation processes
• Daily coordination with team onshore-offshore delivery model
• Performed testing for data analysis using SQL complex queries using MY SQL

Environment: HTML, XML, Visio studio, VB.net, JIRA, SQL, HP ALM QC, sharepoint

Confidential, New York, NY

Business Analyst

Responsibilities:

• Worked as business analyst to support the re-design of the Asset Management System.
• Ensured loan submittals met internal and external eligibility requirements
• Analyzed capital market and trading reports to ensure compliance with MSRB regulations and TRACE reporting. Managed problem resolution at strategic levels
• Balanced the need for loan-volume growth with the equally important necessity of optimum underwriting quality to minimize risk while maximizing profitability
• BIS Foreign exchange and gold services like spot deals, swaps, outright forwards, options, foreign exchange overnight order, safekeeping and settlements facilities, purchases and sales of gold: spot, outright, swap or options
• Analyzed valuation of tradable market securities with data mining and data management software (SQL)
• Prepared monthly custom reports to identify chronically late paying customers.
• Performed regular risk assessments and created reports for management.
• Provided executives with analytics and decision-support tools used as the basis for reorganization, consolidation and relocation strategies.
• Partnered with developers to automate manual processes, saving time and money while decreasing errors.
• Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.
• Performed quality assurance, system integration and user acceptance testing facilitating on-time, on-budget
• Completed in-depth analyses for business-optimization projects, reporting tools, back-office programs and payment-processing apps
• Developed business process models to document existing and future business processes.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Partnered with the technical areas in the research and resolution of system and process problems.

Environment: Windows XP, Loan IQ, DB2, Java, EJB, Cognos, JavaScript, HTML, XML, MS Office & MS Project, sharepoint

Confidential, Jersey City, New Jersey

Business Analyst

Responsibilities:

• Defined project artifacts such as project plan, presentations, requirement traceability matrix, business requirement document etc.
• Designed client on-boarding workflows for existing processes to evaluate FATCA impacts.
• Coordinated FATCA analysis on legal entities with Legal, Controllers, Tax Team and Customer reporting team
• Created static and dynamic prototypes using MS Visio to show as prototypes
• Designed and implemented SQL queries using joins, unions, outer-joins and aggregate functions to extract data from different databases for timely reporting and validation.
• Work environment exposure to Anti-Money Laundering and its various modules such as Know Your Customer (KYC), Suspicious Activity Reporting (SAR) along with Bank Secrecy Act (BSA), FINCEN Office Of Foreign Assets Control (OFAC) policy and systems such as Actimize Surveillance.

Environment: MS Visio, MS Project, PL/SQL, Oracle, iRise, MS Suite, SharePoint, JIRA, Actimize, HP-QC, Regulatory compliance.