PROFESSIONAL SUMMARY

• 8 years of diverse work experience as Business Analyst in Banking, Financial and Bioinformatics industry
• Solid Knowledge in Comprehensive Credit Analysis Review CCAR regulations and reporting, that focuses on the Retail FRY-14 M Schedules and Wholesale FRY-14Q Schedules
• Extensive Knowledge of financial service products in Retail that includes the First Lien Mortgages, Home equity line of credit mortgages HELOC and Home equity loans HELOAN with reasonable exposure in the Commercial Real Estate CRE and Corporate Loans CORP
• Decent Exposure to the Bankruptcy Process and Rules needed to report Bankrupt Mortgages
• Fair Knowledge in profiling Purchased Loans, Troubled Credit Loans and Real Estate/Bank Owned Loans
• In-depth knowledge of Equity Common Stocks, Preferred Stocks, Corporate Bonds, Municipal Bonds Munis , Convertible Bonds, Treasury Bills, Treasury Notes, Treasury Bonds, CMO, Options, Futures, Forward, Swaps, Currency Swaps, CDS, Interest Rate Swaps
• Extensive experience in project development using different SDLC methodologies including AGILE Scrum, AGILE XP, Rational Unified Process RUP , RAD, Iterative, Incremental, and Waterfall
• Expertise in interacting with business users - gathering, analyzing, and documenting business requirements BRD , converting requirements into specifications and documenting Functional Specifications FSD and High Level / Low Level Design Document
• Well versed in building UML diagrams Use Case Diagrams, Activity Diagrams, Swim Lane Diagrams, Sequence Diagrams, Class Diagrams, State Diagrams, and Process Workflows
• Proven expertise in data mapping identifying data source and target tables / columns along with business rules, validation rules, null rules, and transformation rules to construct the ETL process
• Extensive experience in SQL including writing complex queries and stored procedures for data manipulation, application development, and researching data issues
• Expertise in assisting Data Modeling team to build Entity Relationship ER diagram establishing relationship between entities along with data dependencies and constraints
• Understanding of Dodd Frank, EMIR, Basel II / III regulations for compliance monitoring
• Knowledge of financial networks protocols like FIX, FIXML, XML, SWIFT, and FpML
• Valuable experience in performing project management tasks project plan scope management liaising between end users, Dev, QA team setting timelines resource allocation and status updates
• Hands-on experience in GAP analysis capturing existing functionalities and future enhancements
• Strong experience in organizing participating in project meetings such as JAD sessions to obtain business requirements from project stakeholders and subject matter experts SMEs
• Strong experience in analyzing financial risks such as Interest Rate Risk, Default Risk, Credit Risk, Inflation Risk, Operational Risk, Systematic Risk, Market Risk, Counterparty Risk and measuring risk using metrics such as Greeks, VaR, Duration, and Convexity
• Knowledge of Pricing Models such as CAPM, Discounted Cash Flow, Binomial Pricing, Black-Scholes, Time Series Analysis, and Arbitrage Pricing
• Strong experience in working with QA team to document Test Plan, Test Scenarios, Test Cases, Test Matrices, Test Reports, and Test Scripts and performed Functional testing, Integration testing, System testing, GUI testing, Performance testing, Load testing, Smoke testing, Regression testing, and UAT
• Proficient in managing Defect Tracking Lifecycle - identifying, tracking, analyzing, reporting defects
• Proven expertise in developing Requirements Traceability Matrix RTM mapping across various project deliverables such as business requirements, functional specifications, and test cases

TECHNICAL SKILLS

WORK EXPERIENCE

Confidential

Business Analyst

Responsibilities -

• Currently part of the Comprehensive Capital Analysis and Review Team that proudly won the Chairman's Award in Northern Trust Company
• Led the FAQ Impact Analysis initiative to analyze the FAQ's with respect to the FRY 14M/Q Schedules such as Retail First Lien Mortgages, Heloc-Heloan Mortgage , Wholesale Commercial Real Estate Mortgages, Corporate Mortgages attributes that are to be submitted to the FED on a monthly and quarterly basis
• Created and maintained a comprehensive document to track the FAQ Impact Analysis Results for the different FRY 14M/Q Schedules and introduced unique status using pivot tables for each of the schedules to track the current status on a weekly/monthly basis
• Conducted Meetings and interview sessions with Business users and Subject Matter Experts to discuss the FAQs and the impact it had on the Business Rules of the Attributes in the Schedule Retail, Wholesale and Retail Other
• Identified and documented the gaps in the Existing Business Rules of the FRY 14M/Q attributes and tracked them via Application Lifecycle Management ALM
• Created Source mapping document to map the various sources consumed by Northern Trust Bank to obtain the data for the FRY 14M/Q attributes
• Led Complex Data Profiling Effort to profile data for various attributes in the Retail Schedule
• Communicated and Channelized effectively with IT teams as well as Business units to investigate and resolve issues including inquiries from regulators
• Employed simple and complex SQL queries for data retrieval, data validation, investigate issues and generate reports and created comprehensive profiling artifacts to organize large mortgage data for presenting to Business Users
• Involved heavily in framing the Bankruptcy related rules for the FRY 14 M Retail attribute
• Analyzed more complex CCAR issues and provided recommendations to ensure compliance and risk reduction
• Conducted Several Requirement gathering sessions with Business Users to obtain the requirements needed to frame the Business Rules for attribute in the Retail Schedule
• Analyzed Internal Northern Trust Edit Check Failures and FED prescribed Edit Check Failures and designed an alternate solution to address the Existing Data Quality Issues
• Participated in weekly status meeting and contributed significantly in resolving assigned Quality Center defects with respect to New Requirements, FAQs and Requirement Changes
• Monitored constantly the externally imposed CCAR Requirements from FED
• Supported and participated in the Original Data Store ODS requirement gathering, design and Testing phases
• Built UML diagrams like Process Flow Diagram, Data Flow Diagrams and State Diagrams as part of the Documentation exercise
• Documented over 50 Detailed Business Requirement Documents for FRY 14M individual and group Retail attributes
• Maintained and monitored Version Control of the documents and spreadsheets using MS SharePoint
• Used ALM to manage and create defects, analyze, log, and prioritize defects monitor defect fixes, maintain defect log, periodic status update

Environment -

MS Office, MS Visio, MS Project, MS SharePoint, Oracle, ALM Application Lifecycle Management formerly Quality Center, Data Stage, WebEx

Confidential

Business Analyst

Responsibilities -

• Adopted AGILE Scrum model for application development, assisted Product Owner to analyze requirements, assess the progress and prioritize user stories based on business requirements in the Product Backlog and facilitated all meetings within Agile SCRUM framework
• Conducted several meetings and interview sessions with business users and subject matter experts to gather, analyze, and document business requirements BRD , transformed business requirements into functional specifications, documented functional specifications document FSD
• Coordinated with external data vendors like Bloomberg / Reuters to map market and reference data onto project database along with set of business rules, created data mapping document and assisted ETL team to setup the data load process in data warehouse
• Built several UML diagrams like Use Case Diagrams, Activity Diagrams, Swim Lane Diagrams, Sequence Diagrams, State Diagrams, Process Workflows, and Data Flow Diagrams
• Designed user-friendly GUI screens and their functionalities as per business requirements and SME's guidelines
• Employed SQL queries for data retrieval, data validation, investigate issues and generate reports
• Assisted Project Manager to document the project plan project scope, objectives, deliverables, timelines, gantt chart, pert chart , manage resources, and create project deployment plan
• Assisted Data Modeling team to identify entities and entity types, develop a progressive Entity Relationship diagram by establishing relationships between entities and respective constraints
• Performed GAP analysis to analyze existing system functionalities and document proposed system process flow developed the transition plan to migrate from legacy system to proposed system
• Organized various JAD sessions with end users, SMEs, Dev team, QA team, and project stakeholders to discuss requirements design application architecture and resolve conflicts
• Closely collaborated with QA team to assist in creating test plan, test strategy, test cases, test scripts and conduct various kinds of testing like Functional testing, Integration testing, System testing, GUI testing, Performance testing, Black-box testing, Smoke testing, Regression testing, and User Acceptance testing ensuring a bug free product delivery
• Developed Requirements Traceability Matrix RTM to map / trace the requirements throughout development process, mapping requirements, specifications, and test cases
• Used Quality Center to manage defect tracking lifecycle - analyze, log, and prioritize defects monitor defect fixes, maintain defect log, periodic status update, and generate progress graphs

Environment -

MS Office, MS Visio, MS Project, J2EE, MS SharePoint, Java, VB Script, UNIX, PL/SQL, Oracle, Quality Center, XML, QTP, Tivoli, Rally, Wiki

Confidential

Business Systems Analyst

Responsibilities -

• Interviewed end users to gather and analyze requirements, documented business requirements BRD , designed application architecture, identified functional specifications, and documented system specifications SRS
• Followed Waterfall SDLC methodology to guide IT development and testing teams during project lifecycle, ensuring a bug-free application is delivered within given timeline
• Generated several UML diagrams for various process flows within the application Use Case Diagrams, Activity Diagrams, Swim Lane Diagrams, Sequence Diagrams, Class Diagrams, State Diagrams, Process Workflow Diagrams, using Rational Rose
• Built data mapping document, mapping data market and reference data from various external data sources to database, via set of business rules and assisted ETL team in setting-up data integration process.
• Executed complex SQL queries to retrieve data, validate data, and build user reports
• Supported Data Modeling team to develop ER diagrams design logical and physical schemas for data warehouse and establishing relationships between various entities
• Assisted project manager in developing project plan includes scope, objectives, timelines, and schedule for project deliverables , resource allocation, and transition plan developed Gantt and Pert charts, using MS Project
• Conducted GAP analysis between existing application and proposed business functionalities to develop migration strategy for transitioning from legacy-to-new platform
• Organized JAD Sessions with end users, developers, project manager, and quality analysts to validate team consensus, develop architectural solution, resolve open matters, manage change requests, and conducted technical reviews walkthroughs
• Closely worked with QA team in developing test plans, test cases and test scripts participated in performing different types of testing like functional testing, integration testing, system testing, GUI testing, performance, black-box testing, smoke testing, regression testing, and UAT
• Used JIRA to monitor defect tracking lifecycle, to investigate bugs, list bugs according to severity, priority, record bugs in bug log, update status periodically in bug log, generate and analyze reports
• Authored and maintained Requirements Traceability Matrix to map business requirements, functional specifications and test cases end-to-end throughout the SDLC
• Authored project reference guide and application user work manual.

Environment -

MS Office, Rational Rose, MS Project, .NET, HTML, MS SQL Server, J2EE, MS SharePoint, MS Access, SQL, Management Studio, JIRA, XML, Autosys, Confluence, UNIX, LoadRunner

Confidential

Systems Analyst

Responsibilities -

• Followed Rational Unified Process RUP Methodology in defining the problem, gathering requirements, business modeling, and communicating with the technical team system development
• Worked on developing data mapping which mapped data from various sources to targets within the application assisted ETL team to integrate source and target data in the data warehouse
• Executed complex SQL queries on the database and performed data analysis to audit the data being retrieved and generate reports
• Interviewed various business stakeholders like SMEs, Traders, Product Controllers, Risk Managers, and Operations staff to understand and document business requirements in business requirements document BRD and functional specifications in functional specifications document
• Assisted Project Manager with project management scope definition, impact analysis, project plan, work allocation, and deployment plan
• Developed several UML diagrams - Use Case Diagrams, Activity Diagrams, Swim Lane Diagrams, Screen Mockups, Wireframes, State Diagrams, Process Workflows, using MS-Visio
• Collaborated with Data Modeling team to develop logical and physical models helped in developing ER diagrams documenting the database architecture
• Liaised with end users, developers, and testing team to clarify specifications as necessary to negate discrepancies in system development and manage deliverables within agreed timeframes
• Performed GAP analysis to document, analyze and develop 'As is' and 'To be' process flows covering all the functionality to satisfy business requirements
• Identified and resolved numerous project related issues identified during all phases of projects by conducting JAR/JAD sessions and also leading all status meetings needed to prioritize, allocate and audit work in progress and report the same to business users
• Involved in developing test plan, test cases, and test scripts and performed various kinds of testing like functional testing, integration testing, system testing, GUI testing, performance testing, black-box testing, smoke testing, regression testing, and user-acceptance testing
• Worked extensively with MS Excel for creating Requirement Traceability Matrix

Environment -

Windows, J2EE, UNIX, UML, XML, MS Project, MS Visio, Sybase, DB Artisan, AquaData, Java, .NET, BugZilla, QTP

Confidential

Business Analyst

Responsibilities -

• Adopted Agile methodology, interacted with the business users to get a clear understanding of the business process flow and application requirements
• Performed GAP analysis to analyze the existing business process workflow and proposed business process workflow and provided recommendations to improve the process as well as documented the findings
• Gathered business requirements and business rules to be incorporated in the new application and documented them in business Requirement Document BRD
• Conducted numerous JAD sessions involving business users, SMEs, IT developers, QA team, and other project stakeholders to brainstorm analyze the various requirements
• Created various UML diagrams like Use Case Diagrams, Activity Diagrams, Swim Lane Diagrams, and Sequence Diagrams, using MS Visio
• Prototyped the application, providing screen shots and creating wireframes for better visualization
• Organized and coordinated with external data vendors to map market and reference data onto project database along with set of business rules throughout the project life cycle by creating data mapping document
• Assisted QA team with development of test plan, test cases, test suite, and test scripts
• Executed functionality testing, usability testing, regression testing and also was involved in User Acceptance Testing UAT

Environment -

MS Project, Windows, UNIX, J2EE, Visual Basic, Oracle, UML, Oracle, TOAD, WinRunner, LoadRunner, MS Visio

Confidential

Business Analyst

Responsibilities -

• Coordinated with stakeholders, end users to analyze business requirements and functional specifications to prepare deliverables like SRS, BRD following Waterfall methodology
• Created Use cases, User Stories, GUI Screen, templates and Interface Designs for updating the Biological Analysis Module of the Ocimum's homegrown product Genowiz
• Generated, Validated and Verified data from databases using SQL queries
• Worked mutually with the Senior Business Analysts, Business Analysts, Software Engineers and Enterprise Architects
• Designed screen mock-ups in coordination with design architects to improve graphic visualization
• Extensively worked on VBA Excel Macros for aiding in template building for automated workflow module
• Performed manual testing, focusing more on functional testing of the biological analysis that required technical knowledge and understanding of the biological components
• Provided test data and prepared test plans with a set of important test cases to assist the QA team in the testing phase
• Assisted in User Acceptance Testing for a successful signoff on finished product
• Prioritized and escalated identified bugs for updated and customized features and promptly coordinated with the software developers to fix the bugs
• Involved in creating user manuals, training materials with screen casts explaining important features
• Monitored Version Controls of company technical documents using Microsoft Visual SourceSafe
• Conducted live product demos to invite new business opportunities and for training purposes
• Extensive experience in analyzing genomics data for preclinical research development and data generated from clinical trials
• Performed data mining and biological data analysis using many internal resources, public databases and publications

Environment -

Windows, MS Project, Visual Safe Source, J2EE, Management Studio, Visual Basic, SQL Server