Sr. Technical Business Analyst Resume
PROFESSIONAL SUMMARY:
- Result oriented Business Analyst/PM with a proven record of for more than 16 years in financial domain.
- Experienced regulatory compliance (BASEL ii/iii) and reporting (IHC/CCAR) professional with good analytical and communication skills.
- Strong Project Management skills and well versed in Requirement Management, Change Control Management tasks throughout the project life cycle (PLC).
- Excel in the dynamic work environment and achieve all deliverables on time under tight deadlines.
- Expertise in BASEL II/III for CRD - IV and US Standardized and Advanced rules
- Implemented IHC and CCAR/DFAST Reg Reports (FRY 9C, FR Y 14Q, and FR Y 14A )
- Designed control reports and tool to maintain data integrity across IHC/CCAR reports.
- Highly capable of evaluating, investigating and resolving compliance issues and concerns
- Well versed with Trade Life Cycle
- Exposure to MiFID/ MiFIR regulations and good understanding of FRTB changes
- Exemplary knowledge in Financial Investment Banking industry with a conceptual understanding of financial instruments traded as SFTs (Secured Financial Transactions) and Derivatives both OTCs & ETDs.
- Extensively worked on Futures, Forwards and Options along with Repo, Reverse Repo, indemnified Repos, FX, Equities, Swaps, Rates and Commodities etc.
- Exposure to handle internal audit and data lineage
- Have profound experience on-boarding products like Derivatives (ETDs, OTCs), SFTs, Fails etc. from internal and external vendor source systems like Loanet, Broadridge, OpenLink, GMI etc.
- Decommissioned huge legacy vendor source systems like HAMPER, NY Rate etc. used for FX Rates and security pricing and replaced with PMC and SMC.
- Good knowledge of different models like VAR, CMP, CEM, and EPE etc. used to calculate EAD
- Significant experience to carry out POCs and reconcile big $ amounts by using complex SQL queries and proficient excel skills that helped in decision-making.
- Agile Software development experience throughout the full SDLC; manage different sprint planning, daily scrums meetings, update backlog and sprint reviews with testing, development, and change team along with business users.
- Experienced in writing user stories and further break down to balance the sprints time lines.
- Strong communication skill to manage meetings, conference calls, status updates, reviews with different stakeholder (from Business Owner to Sponsor of project and SMEs to Developer and testing teams) responsible for the implementation of projects.
- Experience in timely point out potential risks and successful escalations to resolve issues pertaining to project
- Strong experience to develop test plans, test scenarios in SIT and UAT and get approval from all business and technology stakeholders.
- Excellent team player with ability to work on multiple projects and provide feasible solution acceptable across all concerned stakeholders and ability to resolve any conflict within or other teams.
- Work independently with little supervision and adapt quickly any new business line, acts as liaison between IT and business teams.
PROFESSIONAL EXPERIENCE:
Confidential
Sr. Technical Business Analyst
Responsibilities:
- Perform gap analysis on business requirements; enhance business rules and processes, data interfaces with the consent of business owners.
- Research and resolved Data Lineage for issues and error with for different reports
- Supported internal audit process to track different activities
- Coordinate with Change team and end users to understand and implement the business request based on the FED instruction for all schedule of FR Y 14A Report.
- Gathered CCAR PPNR and supplementary metrics (FRY 14 A) forecast from differentbusiness units.
- Coordinate with different calculators to get the projection (jump of point) for each required line item of different schedules and validate it,
- Manage and enhanced functionality AXIOM View tool for FR Y 14A by providing the facility of bulk and dynamic uploads of different schedules for different applicable FED and Internal scenarios.
- Involved in test evaluation process for Annual and monthly risk reporting and Risk data council meeting result, affirmation and execution followed for federal reporting requirement underCCAR testing.
- Reviewing CCAR to custody Reconciliations to identify the discrepancies and take immediate action to fix the issue. If break is due to an erroneous or missing transaction in CCAR make necessary adjustments.
- SupportedCCAR and FIN (BASEL) teams to validate and reconcile data coming from various systems and reported to FED are in-sync with FIN systems
- Implemented end to end project to carry out archival and locking mechanism for CCAR/ IHC reports
- Created and designed Macro Recon tool to reconcile FRB and firm-level defined Recon Points across IHC/CCAR reports to maintain the integrity and consistency of reports.
- Co-ordinate various stakeholders across the globe to communicate precise expectations during the life cycle of a project and track all activity with a focus on business interest.
- Held sessions and walkthrough to Dev, SIT and UAT teams to covey business understanding and impact due to the changes in new FED instructions on current implementation.
- Designed test scenarios to make sure test results satisfy expectations set by users due to the change request.
- Enhanced data warehouse for the availability, integrity, accuracy, and correctness of values of attributes mandatory across regulatory reports like FRY 9C, FRY-14Q, FRY-14A, FFIEC 009 etc.
- Perform Analysis and carry out POC on business requirements, to provide the feasibility of designing linkage framework, Macro Recon Tool, and control reports
- Designed framework for control Reports like Linkage Report and Recon report to determine the impact of reports (FRY 14 Q and FRY 14A) due to topside adjustment in one report.
Tools: AXIOM Controller View, VISIO, PL/SQL, Toad, Excel (VLOOKUP, Pivot, Macros), PP,Oracle 10g, HP ALM (QC), JIRA, Odyssey
Confidential
Sr. Technical Business Analyst\PM
Responsibilities:
- Created and maintained Dashboard to track weekly status of all activities to implement BASEL III
- Various features like Margining, Cash and Security Collateral, Haircut services, fair values, CCF exception etc. implemented or streamlined for Cleared OTC, ETDs, Clrd, SFTs.
- Implemented CVA as a part of B - III compliance
- Research and resolved Data Lineage for issues and error with fin and risk feeds from different systems
- Saved big $ RWA by implementing correct identification criteria of SOLD OPTIONS for SLR processing of derivatives
- Streamline Notional processing for CEM calculation by mean of reportable Notional, finance Notional and risk Notional with exceptions for composite and power deals trades.
- Captured requirement to implement the SACCR to replace CEM model to calculate EAD
- Enhancement of allocation of EAD/RWA numbers to prevent the across netting set allocation for SFT trades
- Process correctly indemnified Repos by capturing legal information for netting logic of SFT trades
- Enhanced the ALD process by matching agent and principal at different levels based on available information, and saved huge capital charge. Also report ALD plugs properly by apportioning appropriately with CMTM
- Enhancement of BASEL 2 framework to facilitate switching of Risk side numbers to Fin side number for EAD/RWA calculation
- Reflect correct EAD to the desk associated with, for SFT trades by calculating EAD as Account level and apportioned calculated EAD at netting set level with exceptions implemented by complex logic
- Redesigned Fails trades processing under the BASEL framework
- Design/Created OTC/SFT Bar reports with various Matrix to facilitate senior management to take strategic decisions related to the capital exposed in the market
- Migration of Prices and Rate feeds from External vendor (HAMPER) to Citi s internal (PMC)
- Migration of external source of SFT data from Loanet and Broadridge etc.
- Designed new haircut services in OPTIMA to apply appropriate supervisory (Security and FX) haircut to collaterals
- Designed new collateral feed for Exchange Trades Derivatives to take advantage of received collateral for RWA numbers
- Worked independently to coordinate different internal and external (vendors) teams to onboard new feeds in Optima framework.
- Perform Gap Analysis on business requirements, rules, processes, data interfaces and system changes to support the correct calculation of EAD and Risk Weighted Assets (RWA) number that reported to regulatory capital in compliance with Basel III.
- Involved in resolving data qualities issues raised due to various factors like data, enrichment rules, enhancement of the existing logic, for example, CCF usage of the same transaction for different processing under different regulatory rules under US and EMEA etc.
- Global and local data issues resolution after extensive analysis on the data.
- Challenge the existing product classification hierarchy which was causing huge capital charge savings while calculating collateral by means of CCF
- Proposed number of tactical solution where data quality issue would not be resolved at the scheduled time
- Involved creating preliminary BASEL-3 reports to represent the new numbers RWA and ETDs
Tools: VISIO, PL/SQL, Toad, Excel (V-Lookup, H-Lookup Pivot, Macros),, PP,Oracle 10g, SQL Developer, Sybase, HP ALM (QC), JIRA, Odyssey
Confidential
Responsibilities:
- Prepare FRDs based on the impact analysis of the existing logic and new or modified business requirement.
- Prepare (MDD) Minor Development document based on the impact analysis of the existing process and proposed flow of data in Optima to satisfy the business initiated request
- Design test cases scenarios for user acceptance (UAT) with Quality Testing team and SIT teams.
- Planning, Prioritization of tasks, Issue & Status tracking for various requirements simultaneously
- Define new or modify existing business rules for external source changes or to facilitate external vendor’s feed to STAR
- Able to write complex SQL or Sybase queries to get the data fast for POC in the complex proposals like ALD (where new rules were proposed after extensive manual intervention)
Tools: VISIO, PL/SQL, Toad, Excel, PP,Oracle 10g, SQL Developer, Sybase
Confidential
Technical Business Analyst/ Technology Lead
Responsibilities:
- Using the existing FAPB application created FRDs for Nextgen application
- Planning, Prioritization of tasks, Issue & Status tracking for various requirements simultaneously
- Co-ordinate with business owners, subject matter experts, and business analysts
Tools: SQL2000, VB 6, VISIO, VSS, and Windows 2000, Mainframe, MS Excel 2003, MS Office, MS Access
System Analyst
Confidential, NY
Responsibilities:
- Study the existing application and find the scope the integration of the new module with the business logic layer of the already existing application and for memory leakage assignment was to study the existing application which casing memory leakage and to find out the cause.
- Develop the class Diagrams, Sequence Diagram for collection module of the existing application
- Estimated change requests than did Impact Analysis and implemented changes.
Environment: C#, VISIO, XML, UML, CLEARCASE, NUINT, EASSYMAIL, SQL2000, Java 2, JSP, Oracle Web Service, JavaScript and Windows 2000, Visio, UML, .Net Framework, VB.net, ADO.net, WinDbg (Graphic), KD, NTSD (Console) and Dr. Watson
