SUMMARY

• Over 10+ years of experience as BA/BSA in Financial Services, Banking & Retail Industry with the ability to work independently and in teams to meet business deliverables with a result oriented approach
• Experienced in Requirement gathering, Business Process flow, Business Process Modeling (BPM), Process Redesign, Process Reengineering, Change Management, Documenting Enhancement Requests, Automatic and manual testing, etc. with a keen awareness of developers and end - users needs and able to dealt with user groups at all levels efficiently
• 8+ years of IT experience in RDBMS & Data warehousing, design support, ETL mapping documentation, testing, implementation and support business intelligence report requirements.
• Proficient in using Agile/Scrum methodologies, performed roles of Scrum Master following sprint/stand-up sessions and used Excel extensively to write user stories, analysed the Iteration Burn Down charts and reviewed defects.
• Excellent understanding of Trade Life Cycle(Trade Execution, Capture, Validation, Confirmation, Match, Enrichment, Settlement, Reconciliation and reporting) and working experience with Front, Middle and Back office teams of Capital Market, Asset Management, Wealth Management, Portfolio Management, Brokerage Institutions, Prime Brokerage Services of various asset class such as Fixed Income, Equities, Derivatives, Money Market Instrument and OTC Derivate
• Implemented effective technology solutions to enrich business standards to comply with Canadian and US GAAP, Basel- Credit, Counterparty, Market, Operational & Liquidity risk, internal compliance and the new BASEL implemented RDARR( Risk Data Aggregation and Risk Reporting )
• Able to adhere to the executives and stakeholders reporting requirements, issues and other results using various BI tools and enterprise solution tools such as SAP business objects, Congo's, SQL, sound understanding of Tableau, MS Access, SAP ERP, excel modeling

PROFESSIONAL EXPERIENCE

Confidential

BUSINESS ANALYST

Responsibilities:

• Involved in project computing Risk Weighted Assets ( RWA ) for Wholesale and Retail exposures using Basel III Advanced and Standardized approaches to keep minimum Capital Adequacy Ratio( CAR ) reporting for Office of the Superintendent of Financial Institutions (OSFI)
• Involved in project scope meetings with the project manager and scrum masters to understand the type of change management requests and issues handled in the sprint and documented the high level business requirements(HLBR/HLRD) to the product backlog using JIRA/Confluence
• Re-engineer the existing data models and data profiling to find the GAPs in legacy to Enterprise Data Management - EDM (Hadoop) system of Retail like mortgage(Mortgage Hub), Loan(OLBB,OLMS), Credit Card(TSYS) & Wholesale products such as Fungibles(Stocks, Bonds, future contracts) for RIBS, RIMMS, ACBS, AVALOQ, Muni DSS etc systems in order to source data to support the regulatory requirement for Risk Weighted Assets (RWA) calculations
• Drafted and maintained business, data mapping and technical requirements documents in order to outline Foreign currency (FX) conversion API project needs, assumption and constraints
• Worked closely with source system owners to become proficient in the underlying current state complex data structures and schemas in Oracle DB, Mainframes, RDBMS to the future state Big Data Schema
• Provide status report via Tableau of the bank’s reconciled data by legal entity, source system, business segment, GAAP, Transit and GL which also include timeliness, completeness and the aging of reconciling items to product controller and management to take corrective actions
• Adhered to existing processes and standards, including the System Development Life Cycle (SDLC), business technology architecture, production capacity guidelines, and escalate issues where necessary
• Hands on experience in documenting solution approach for maintaining HIVE partitioning, bucketing and performing regular and join queries on HIVE tables
• Documented Process Flow Diagram/Activity Diagrams, Test Cases, Use Cases, Traceability Model and performed IST,UAT & Regression testing

Confidential

BUSINESS ANALYST

Responsibilities:

• Developed and published quality standards and supporting guidelines for Data Quality, Reference & Master Data Management (MDM)
• Defined Data Quality measurements by determining quality expectations of data consumers by defining critical processes and services in IDRA mapping document
• Calculated metrics and analyses as well as condensed multiple points of interest and large amounts of complex data set into concise targeted information summaries and reports for management
• Created reports for executives to show quality and quantitative trends to define key metrics
• Utilized DQ dashboards and reports to monitor data quality indicators, issues, perform root cause analysis, define action and remediation plans
• Provided production/release support for upgradation of Big Data analytic tool, Datameer from version 6.3 to 7.1
• Designed and created Data Quality baseline flow diagrams, which includes error handling, Testing Strategy and Planning
• Involved in creating HIVE tables, loading data and writing HIVE queries to test the data in Big Data