SUMMARY

• Senior Business Analyst overall 10+ years of progressive career in IT consulting focused on improving and enabling business processes through technology.
• Financial Services Domain: Compliance MIFID, BASIL III, RDARR, Volker, IFRS 9, TMS, FATCA and CRS.
• FI Business Knowledge: Anti Money Laundering (AML), Counter Terrorist Financing (CTF), Targeted Economic Sanction, Transaction Monitoring, Fraud Management.
• Previous experience in Risk Management (Market Risk, Liquidity Risk, Loan Risk)
• Previous experience in Data Warehousing projects at Confidential, Confidential and Confidential
• Knowledge of SQL queries, MS Excel, Word, Access, PowerPoint, Visio, Project, RDBMS and ETL concepts.
• Experience in SDLC, Agile methodology, Requirements gathering, BI & BW, Data Migration, System Testing and UAT support.
• Strong Capital Markets Knowledge Fixed income, Trade life Cycle (Brokerage), Clearinghouse, Securities, Derivatives (Forward, Future, Option, Swap), Fixed Income and Mortgage Products.
• Certified Financial Analyst - CFA (In Progress)

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst/ Lead

Responsibilities:

• This project migrates Sixty large schemas primarily caters to Capital Market, Risk Management, Compliance and AML Team.
• Capture client’ s as is process for Capital Markets, Trading (Brokerage), client onboarding, back office-middle office- front office end to end trade clearing process,
• As part of capturing loan risk (mortgage)/ process documented mortgage department’s (Annual Reviews, Mandatory Repairs, Holdbacks and Undertakings, Loan Modifications, Property Inspections, Default Management, Management, Investor, Rating Agency and Regulatory Reporting etc.)
• Perform gap analysis to create new to be process/ use cases in Hadoop, consulting with tech team (System architect, Data architect, Developers etc.).
• Collect requirement from client team (Loan Risk Management, AML and compliance) of upto Forty users “virtual and in person).
• Present project artifacts and their status to higher management (up to senior VP), explaining them critical analysis, discuss various dependencies/solutions - “their challenges and opportunities”.
• Conduct and present meetings (up to 40 people) this includes business and technology + 3rd party vender resolving technical issues to meet business solutions.
• Create various project documents, BRD, Test cases, data lineage documents, STM (source to target mapping), context diagram, process diagram etc. This requires structured, clear and concise drafting skills.
• Use and upgrade confluence tool to upload and obtain data which in turn used by large project and stakeholder community.
• Work effectively with large stakeholder/ client (> 170) community. This requires strong relationship management, communication, negotiating and organizational skills.

Confidential

Sr. Business Analyst

Responsibilities:

• Loan IQ processing, technology, configuration and reporting (Advanced Commercial Banking System).
• Integrated Loan IQ modules i.e. front-office origination, syndication, deal structuring, documentation, credit approval, portfolio monitoring and trading with back-office servicing and accounting processes.
• Capture as is process for Loan IQ products (Lines of Credit, Loans, and Overdraft Protection).
• Business requirement for current Exposure at Default (EAD) calculation for OSFI reporting.
• Data mining using SQL scripts to utilize various source data (e.g. ACBS, Calypso, Murex, WSS, Bloomberg, Reuters) from front office (RiskWatch/ SAG) for analysis prior to loading to enterprise repository in an end to end process flow.

Confidential

Sr. Business Analyst

Responsibilities:

• Project: RDARR (Risk Data Aggregation and Risk Reporting). This application is built for Confidential Capital Markets and CTLRM ( Corporate Treasury Liquidity Risk Management) which is part of TMS-“Treasury Management System”, data is consumed by various downstreams for OSFI and BASEL III reporting.
• Developed various high end enhancement request doc, use cases, data element mapping doc to meet multiple requirement for our project.
• Developed data lineage/Source to Target mapping off BOR to client master data base to Data Lake to final xml file for Basil reporting.
• Utilizing MS Visio, mapped data migration process to facilitate solution developer in creating accurate strategies.
• Conducted complex SQL statements for testing, results in confirming Pass/Fail of test cases.
• Created Data Catalogue (Integrated Master Layout)) and their mapping referring various source system raw files and consulting business team, this required extensive use of SQL queries.
• Created and updated agile framework for JIRA tool and remove any blockers on the way.
• Created new daily agile reporting template which is heavily used by IT and business.
• Project: EDH (Enterprise Data Hub/Hadoop Data Lake). This project is run by EDH team; specific to CRM (Credit Risk Management) and GOW (Global Operational Workbench).
• Confidential wealth data were stored in Confidential Wealth Client Master applying end to end Data Warehouse/BI strategy. Data were staged/transformed/loaded/analyzed and reported using MS SQL tools i.e. SSIS, SSAS and SSRS.
• Elicitate requirements from various Risk teams develop BRD document. Create IA (Interface Agreement) doc consulting development team, this is consumed by EDH.
• Discuss Risk teams reporting requirement elicitate their data requirement, work with EHD team to understand their data and map them as per Risk requirement. In this entire ETL process work closely with Informatica BDE/Teradata/Scoop/Podium (Big Data Edition) and Hadoop/Hive developers. This needs extensive engagement with business intelligence “BI” as part of risk data strategy.
• Follow-up with third party/off shore to explain requirement, asking questions to understand complexities and resolving them in timely manner.

Confidential

Business Analyst

Responsibilities:

• Review and conduct analysis of the BRD (Retail Non Personal i.e. mortgage clients, wealth management non-personal and personal) and SRS (business requirement document and system requirement specification) to ensure proper gap analysis to meet requirements in the test cases, use cases, and process flow - finally pass into production (SDLC).
• Write master test plan and execute test cases/ script for client risk rating (CRR), results produced for audit utilizing HP-ALM.
• Write CRR Scoring test cases based on business rules as per the BRD.
• Developed CRR Calculator spreadsheet to execute client risk rating score card in order to arrive at an expected result, this in-turn compared against CRR engine result summarized in dashboard.
• Write procedural documents for granting access of new employees and deletion of users from privileges and rights utilizing Access database
• Analyze the current process, identifies opportunities for improvement, establishes baselines, designs the to-be process, identified the process deployment strategy.
• Conduct gap and audit assessments of current processes, compliance to applicable technology standards, and conduct review sessions with relevant teams to understand and close gaps.
• Support/contribute to Technical Design specifications in adherence to the standard client ( Confidential ) methodology.
• Participate in requirement walk-through with developers and QA testers, provide bug fix support to the IST/UAT/Production environment.

Confidential

Business Analyst

Responsibilities:

• Consults and coordinates with stakeholders to design and map business processes and procedures
• Participate in detailed requirement phases and identify, track, escalate and/or resolve requirements issues.
• Captured end of the day value against each Capital Markets instruments (Fixed Income, Swaps, Options and Mutual Funds).
• Draft business requirements by consulting various user and stakeholder groups, formulate business process flow charts, proposed a new Business Process solution for FEA/FATCA tool.
• Define data migration scope, conduct data migration analysis and document data requirements for loads into the centralized onboarding technology platform. Artefacts involved data lineage, source to target mapping etc.
• Develop business test strategies and test scenarios, conduct user acceptance testing (UAT) and report results for system acceptance. Assist with root cause analysis of defects and their resolutions.
• Employing structured analysis techniques such as use cases modeling or user stories, decision tables to ensure completeness, clarity and non-ambiguity of requirements via use of requirements catalog, and a traceability matrix reflecting everything from business to functional requirements to test cases
• Working with technical teams, business users and support teams to determine transition requirements for the implementation phase of projects.
• Working with stakeholders in ensuring the needed level of research is completed to accurately define the solution benefits and risks.

Confidential

Business Analyst

Responsibilities:

• Translate the business and user requirements into system requirements. Creating and Executing Test Scenarios.
• Analyzed and consolidated data across the business and made effective planning decisions.
• Liaison with the QA, downstream teams, Vendors, and business users to create and finalize test plan/scenarios.
• Execute testing cycles, document results, and create testing sign-off documentation
• Leverage thorough understanding of the business process and related information systems to create current business process map (as is process map) and future business process map (to-be process map).
• Facilitate business requirements gathering sessions with the business owners and key technical resources.
• Elicit business and user requirements from business partners using a variety of Industry Standard/Best Practices techniques.
• Validate requirements for quality attributes, such as clarity, conciseness, correctness, completeness, testability, and traceability.
• Leverage thorough understanding of business process and system processes to make recommendations and propose technical/non-technical solutions to meet business requirements.
• Collaborate with business partners to define project vision and scope.
• Responsible for servers migration on a new domain and coordinated all related team activities including phone conferences and meeting preparation, creation documents.

Confidential

Business Analyst

Responsibilities:

• Project: This project involved an Enhancement and maintenance of Service Desk tool (ManageNow) to Confidential tool (Clearview).
• Demonstrated experience in domain core concepts, elicitated requirements from key subject matter experts and was involved in complete Project life cycle (PLC).
• Analyzed and reviewed current processes and implement new workflows that minimize loss and update quality control checks and balances.
• Conduct feasibility study, develop strategies, prepared business case with cost benefit analysis.
• Participated and reviewed in the RFP process and sub contract documentation.
• Defined statement of work for project and co-ordinated with venders to execute SOW.
• Managed and retained responsibility for operational requirements and improvement initiatives.
• Worked with team on the development and implementation of new system design to improve system functionality, business or customer experience.
• Prepared training material on system improvements together with communication plan prior to implementation.
• Analyze, interpret and synthesize data from desperate sources and translate data findings into actionable information with a specific focus around call pattern/behavior and requirement insight.
• Liaise proactively with business line leaders to ensure analytical solutions are tailored to their needs. This may include configuring ticketing tool and conducting workshops with key stakeholders to build out identified analytical competencies.
• In partnership with LOBs, ensure the client database backend is structured for business agility.

Business Analyst

Responsibilities:

• Project: Confidential Bank’s internal Health Benefit and Claim tool upgrade.
• Conducted weekly status meetings with development team, quality control and business team to track the progress of the project.
• Used different requirement gathering techniques such as interviews, surveys etc.
• Worked collaboratively with Confidential Bank to understand product specifications.
• Conduct walkthroughs involving business stakeholders, development team and quality control, record minutes of meeting and effect changes in the SRD.
• Performed Use Case JAD session with developers and Subject Matter Experts on the future state of the system.
• Eliciting Requirements from stakeholders using a range of elicitation techniques.
• Analyzing and documenting requirements including: modeling and model storming techniques to ensure completeness.