SUMMARY

• 8+ years of consistent experience as a seasoned Business/System/Data Analyst with discrete understanding of Business process flow modelling using UML tools, Use Case Modelling and Entity Relationship Modelling in the domain of Finance.
• Experienced in Financial reporting, Financial Spreading, Risk Management (Market Risk, Liquidity Risk, Credit Risk, Operational Risk, Stress Testing, Risk Modelling),Risk Ratings Systems, Basel II/III Implementation, Comprehensive and Capital Adequacy review (CCAR), Dodd Frank Act, Loan Pricing, Financial Statements Analysis, Fixed Income Products, Bonds, Equity research & forecasting.
• Proven track record of successfully driving all phases of SDLC including Analysis, Designing, Testing, UAT and end user training. Worked on different software development life cycle methodologies for example Waterfall, RUP, and Agile.
• Experienced in performing Gap Analysis for all kinds of Business processes like BPA, BPI and BPR. Experienced in Change management best practices and performing Impact analysis where needed
• Strong knowledge of OTC Securities (Swaps, Options and Futures) Risk Analytics, Equity, Fixed Income Products like Treasury (Bonds, Notes, and Bill),Mortgaged Backed Securities (MBS),Municipal Bonds, Corporate Bonds, Junk Bonds and Convertible Bonds.
• Strong knowledge of trading life cycle, securities accounting, financial products including Equities, Options, Futures, Swaps and Fixed Income products. Good understanding of Market Data providers like Bloomberg, Capital IQ and Thompson Reuters.
• Highly organized and focused on key issues and capable of addressing facts and providing recommendations when needed.
• Hands - on experience with Data Warehousing, Data Mapping, Entity Relationship Diagram Modelling, Data Modelling, Extract Transform and Load (ETL), Data Indexing, and Data Normalization.
• Ability to present a professional, enthusiastic attitude through effective communication skills
• Strong analytical problem solving skills using creative thinking and brainstorming techniques
• Ability to work effectively under tight schedule without sacrificing the quality of work
• Excellent communication and interpersonal skills to gather requirements from business users.

TECHNICAL SKILLS

Project Methodologies: Rational Unified Process (RUP), Agile, Waterfall

Requirement Management Tool: Sybase Power Designer

Requirement Modelling Tools: SmartDraw, MS Visio, PowerDesigner

User Interface Design Tools: SnagIt, SmartDraw, MS Paint, Just in Mind

Database Tools: SQL Access, MS SQL Server

Operating Systems: Windows 10/NT/XP/Vista/2003, Mac OS X

Programming Languages: Java, C++, Python, VBA, Javascipt

Software: Bloomberg, Microsoft Office Suite (Visio, Excel - Pivot Tables, Access, PowerPoint, Word, and Outlook), SAS, Tableau, Qlikview, Bloomberg, Morningstar, Capital IQ.

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Business Analyst

Responsibilities:

• Developed financial spreading module for Banking, Life Insurance, Property & Casualty Insurance, Leasing, Housing Finance, Micro Finance, Investment Fund, and Distressed Assets Recovery Program (DARP) Sectors. Considered financial and non-financial data, including industry type, geographic location, scale of project, phase of project, balance sheet health.
• Conducted in-depth research on different sectors to identify sector specific financial ratios and factors that integrate with S&P’s scoring module to lead JAD sessions between Standard & Poor’s (S&P) team and internal SMEs to determine the metrics to be used for calculation of risk.
• Performed risk modelling to calculate market risk, liquidity risk and checked integration of the models with credit risk. Conducted high level testing by calculating aggregated risk for the portfolio based on random sampling of existing clients from different sectors to ensure accuracy and provide sign off for Production of application.
• Used Qlikview and Tableau to create a risk management dashboard which allowed the users to view dynamic visualizations of changes in risk metrics and key ratios.
• Worked in a data science capacity by using programming and scripting languages such as Matlab & Python to create Autoregressive models for treasury and equity forecasting analysis.
• Worked on regulatory risk (CCAR and Dodd Frank Act) to successfully integrate reporting systems (IDesk) with IRP credit risk models and upgrade them to reflect Basel iii standards.
• Assisted in development and maintenance of Basel iii liquidity coverage ratios framework.
• Identified the key financial ratios based on Capital and Earnings, Asset Quality, Business Position, Liquidity and Funding, Covenants to analyze the gaps relative to internal benchmarks.
• Used data modelling techniques such as mentioned in the UML 2.0 standards to develop schemas for the end application.
• Led sessions between internal team and Vendor team for drafting of Low Level Design Document (LLDD) and identification of creative solutions that reduced the expense whiteout losing any functionality.
• Guided the testing team in designing testing scenarios, determining the priority of defect and in identification of solutions and assisted in regression testing.
• Developed detailed mapping between old and new accounts and assessed impact of each account through the entire application to ensure right calculations in different modules and error free data load.
• Coordinated and conducted the UAT sessions with business users, identified defects, improvements bugs and show stoppers.
• Worked on Application Lifecycle Management (ALM) tool for managing and tracking the business requirements and defects.
• Participated in daily stand-up meeting and worked closely with the team in resolving issues that could potentially cause delays in the sprint completion.
• Guided the UXM team for development of the training manual.
• Initiated proactive efforts to resolve issues reported by business post-production.

Environment: Agile, Moody Financial Analytics (MFA), HP ALM, UML, MS Visio, JIRA, SQL, and Excel.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Worked on business requirement documentation for financial risks and non-financial risks, specific risk rating systems, wrong way risk trades, RWA enhancements, risk capital charge, asset value correlation factor, Monte Carlo Simulation, counterparty ratings, collateralized counterparties.
• Developed model for estimating the fixed income returns relative to different periods and interest rates. Conducted sensitivity analysis by applying different shocks to yield curves for different securities.
• Performed risk modelling to estimate market risk and liquidity risk. Worked on designing solution to reduce fee at risk for the real estate services business division. Created proprietary modules using VBA & python to perform data modelling techniques such as linear regression, logistic regression and correlation testing.
• Led due diligence with CEOs/CFOs of private companies; created region / business / products and services-based dashboard reporting; presented and advised risk officers, business management, Firm risk committees on risk mitigations; developed and trained a global team; conducted training for risk officers and other stakeholders.
• Gathered and documented requirements after analyzing the gaps in the Index Mapping and Sensitivities process for VaR (Value At Risk) calculations. This involved creating data models such as ER, sequence & activity diagrams, documenting the AS-IS process of how the Market Risk Managers review these and then kick-start a process of VaR (Value At Risk) calculations once they approve the Volatility Data. Worked on integration with external sources like Bloomberg and Reuters.
• Work with solutions/delivery teams to implement data quality processes during acquisition, ETL, and delivery stages for Business Intelligence solutions and changes to Data Warehouses.
• Used Python & VBA to automate the risk and data modelling and estimation process.
• Used Qlikview to track real-estate competitors and perform comparable analysis
• Responsible for the quality and accuracy of data in all new large-scale projects for the Mortgage Division.
• Analyzed and Documented the process and specifications for the Reconciliation of trades using SQL and Microsoft Excel sent from the Broker Dealer to the Capital Calculation engine which calculates LGD, EAD, etc. and those sent back to the Broker Dealer source systems for Allocation of Capital Charges to Traders and Trading Desks.
• Successfully coordinated System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Initiated the data center information management project; developed project plan; analyze process flow and market trends; created business requirement document, develop rating metrics and scorecards; led executive briefing, communication with IBD, management, and strategic clients.
• Performed (UAT) once QA Manager approved the application and it was migrated to the User Acceptance Testing Environment.
• Documented user stories where needed and participated in the preparation of burn down charts. Participated in daily stand ups and Sprint planning meetings.

Environment: SPSS, Agile, Capital IQ, Rational Requisite Pro, MS Visio, MS Project, Oracle, SQL, UNIX.

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Computed bonds’ value using different maturity dates and interest rates, conductedduration and convexity analysisfor fixed-income securities and estimated exposure toYield to Maturity (YTM), Yield to First Call (YTFC), Normal Yieldcalculations.
• Successfully coordinated to design and document Business Requirement Documents, Functional Specifications and Technical maps for Asset Management stream.
• Documented the ongoing assessment of thecreditriskmanagement processesthrough process flow diagrams and also documented the to-be processes.
• Responsible forintegration of Wall Street on Demand and Nasdaq Level II streaming quotes with the front end systems.
• Created macros in Qlikview to automate the portfolio risk alert process. This functionality automatically generated an analysis report when certain risk thresholds were violated and e-mailed it to the portfolio managers.
• Documented “As-is” and “To-be” process maps as part of Gap Analysis for new functionality requirements, and thereafter prioritized them in order to align them with the project requirement.
• Developed Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
• Planned and managedcounterpartycreditrisktechnologyand process improvement
• Accountable for Functional and Regression testing onCCRT's Proprietary Financial, Securitization, and Debt Management applications.
• Tracked and monitoredcreditriskposition, reporting exposure to management, quarterly.
• Supported other business analysts in conducting Feasibility and Complexity Analysis to recognize technically functionalities of the project, and determine thelevel of effort (LOE) needed to attain them.
• Arranged to documentSprint Backlogsto identify and monitor the activities performed in the time boxes.
• CreatedUser Interface document (UID),Wireframes, andPrototypesto help developing user interfaces.
• Maintained frequent interaction with customers and compared their expectations with designed “User Interface” to determine ways to improve the UI to have better customer experience.
• Coordinated with theSCRUM masterin facilitating daily SCRUM meetings,sprint planning, review and retrospective meeting.
• Provided walkthrough to both developers and testers to developTest Casescenario from user stories.
• Created UAT test cases and assisted senior business analyst in conducting UAT test.
• Initiated proactive efforts to resolve issues reported by business post-production.

Environment: Agile,Rational Rose, Java, VISIO, PL/SQL, HTML, Visio, DB.

Confidential, Washington, DC

Business Analyst

Responsibilities:

• Worked with key stakeholders of the projects to identify and finalize the requirements
• Collaborated with clients, end users, and developers and ensured technical requirements are thorough using standard tools and modelling techniques.
• Established solid working relationships with open communication with customer and business via meetings and interviews.
• Created mock-ups and prototypes for the JAD sessions
• Responsible for creating the Business Requirements Specification Document (BRD) and the Functional Specifications Document (FSD)
• Designed Business Process Model (Activity diagrams, Sequence diagrams and Collaboration diagrams)
• Documented detailed analysis of end-to-end business processes, functional design, workflow mapping and action items, issues and ensured information is accurate and complete.
• Created the Requirement documents and traceability matrix using Requisite Pro
• Created design document with more detailed and technical information on the requirements.
• Evaluated selection, develop strategies, project and implementation plans based on thorough research and input from stakeholders.
• Resolved conflict with business units to overcome conflicts in requirements and arrive at common feasible solution.
• Managed changed by working with business units to determine and document the business process and workflow changes.
• Being the main POC for the RMEW team for the production support, provided support to the users to troubleshoot the issue within the SLA.
• Created Project management plans for managing on time delivery using MS Project along with writing test cases, unit and systems integration test plans in Test Director

Environment: Agile, Rational Rose, Rational Requisite Pro, MS Visio, MS Project, Oracle, SQL, UNIX