SUMMARY

• Experienced Business Analyst with 8 years of work experience. Have an aptitude to succeed in a collaborative team environment and independently manage business expectations in a delivery - focused approach to work. Seek opportunities to transform company practices into fresh, cost-effective solutions leading to more efficient operations.
• Knowledge of CCAR report FR Y-14Q and FR Y-10
• Implementation knowledge of reporting tool AXIOM SL
• Conceptual understanding of different capital market products such as Equities, Fixed Income securities (Corporate Bonds, US Treasury, Mortgage Backed Securities), Secured Financing products (Repo, Reverse Repo, Tri-Party Repo) and Derivative products (Futures, Forwards, Options, Swaps)
• Knowledge of trade associated risks such as Credit Default risk and Liquidity risk
• Comprehension of Time-Value of Money (TVM) and Bond Pricing, Valuation and Duration
• Familiarity of Wholesale banking products and Front office, Middle office and Back office operations
• Awareness of Confidential ’s capital and liquidity adequacy guidelines set by BASEL II and BASEL III
• Understanding of impact of economic scenarios as described in Dodd-Frank Act Stress Testing (DFAST) and Comprehensive Capital Analysis & Review (CCAR) regulations
• Acquaintance of the Volcker Rule and its impact on limiting proprietary trading activity and firm’s liability
• Familiarity with various stages of implementation of axiom tool: data set, data model, portfolio, aggregation etc.
• Strong knowledge of development methodologies such as Systems/Software Development Life Cycle (SDLC), Agile Unified Process (AUP), Agile Scrum and Waterfall
• Vast experience in SDLC tasks like requirements gathering analysis, GAP analysis, feasibility analysis, creating Business Requirement Documents (BRD), transforming BRD to Functional Requirement Document (FRD), writing high & low level design documents
• Extensive experience in gathering Business & Functional Requirements through Joint Application Developments (JAD) sessions, Joint Requirement Planning sessions (JRP), walkthroughs, Interviews, Workshops sessions with end-users, subject matter experts (SME), stakeholders and technology team
• Practical experience in managing and conducting several scrum ceremonies and maintaining product & sprint backlog
• Proficient in creating Entity Relationship Diagrams (ERD), Data Flow Diagrams (DFD) and Wireframes in MS Visio
• Experienced in preparing test cases, use cases, test plan and requirements traceability matrix
• Proven ability in conducting unit & integrations testing in SIT environments and regression testing User Acceptance Testing (UAT) with the business and performing Go-Live validations
• Awareness of Extract, Transform & Load (ETL) data integration process from homogeneous and heterogeneous data sources
• Experienced in defect tracking lifecycle by managing known defects and bugs using ALM
• Adept understanding of Relational Database Management System (RDBMS)
• Competent in writing SQL queries in databases to manage and retrieve tabular information
• Proficient in analysis and reporting using advanced MS Excel functions
• Demonstrated experience in project management tools like MS Project and Gantt Charts for planning and managing and reporting Change Requests (CR)
• Expert in implementing PMI project management methodologies in preparing Project Scope, Project Plans, Work Breakdown Structure (WBS) and Change Management
• Experienced in performing SWOT analysis and and creating Risk Mitigation plan for known risks
• Ensured that relevant sign-offs are received throughout the project lifecycle and multiple document versions are archived for audit purposes
• Outstanding verbal and written communication skills along with proven track record in troubleshooting and problem solving while working on multiple projects

TECHNICAL SKILLS

Methodologies: SDLC- Agile(Scrum), RUP, Waterfall Model

Databases: SQL Server, Oracle 9i/10g/11g, Exadata

Project Management Tools: Microsoft Project, MS Office, MS Visio, SharePoint, JIRA

Testing Tools: Quick Test Professional (QTP), Quality Center, HP ALM

Defect Tracking tools: Clear Quest, Test Director

Reporting tools: Axiom sl, Business Objects, Microstrategy, Cognos, Tableau

Software: Rational Rose, Requisite Pro, Clear Case

Operating System: Windows 98/2000/2008, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr Business Analyst

Responsibilities:

• Production of detailed technical design documents to match business requirements
• Work with design and sales team to propose solutions based on functional requirement of the client
• Attending daily standup meetings and walk through meetings with Business and developers to get details on user stories
• Understanding the technical specifications prepared by other team members, ensuring consistency with functional requirements and overall architecture
• Developing regulatory reports within controller view according to functional/technical specifications
• Creation of data models, Shorthands, Portfolios, Aggregations, Free Form, Tabular reports and workflows using Axiom controller view
• Assisting the Solution Architect and Project manager in reviewing design documents and performing code review for other members
• Migration of Axiom components from one environment to other
• Performing Unit Testing and supporting SIT,UAT cycles
• Supporting business users as and when required
• Supporting the Application Production Support(APS) team for production deployments

Environments: Agile, XBRL, XML

Confidential

Business Systems Analyst

Responsibilities:

• Operated the STP project following highly efficient Agile Scrum methodology
• Ensured entire SDLC cycle is implemented within each sprints (range 2 to 3 weeks)
• Conducted and lead JRP sessions with Project Sponsor, End User, plus special interest groups (SIG’s) such as Data Administration to capture Business Problem Definition and Project Charter
• Partnered with SME’s from Investment, Commercial, Personal Banking and Regulatory departments to prepare high-level BRD and FRD
• Managed and prioritized stories from Production Backlog into the Sprint Backlog using JIRA
• Piloted the daily scrum meetings, stand-up calls, sprint planning & review sessions, story mapping sessions and retrospective meetings as a Scrum Master
• Referred to ‘As-Is’ documentation and created ’To-Be’ processes, development & implementation plans
• Facilitated JAD sessions with technology and controlling teams to ensure regulatory compliance
• Created Product-Attribute mapping document
• Played a pivotal role in creating the aggregation calculator and assumption maker
• Executed SQL queries to validate accuracy of data during testing and design phase
• Created Navigation Flow, Business Flow Diagrams and Work Flow Diagrams for applications using MS Visio and UML tool MagicDraw
• Managed a key part in creating Test Cases, Use Cases and performed Unit & Integration Testing in System Integration Testing (SIT) environments
• Assisted in UAT and Regression Testing in UAT environment
• Tracked, reviewed and analyzed defects using HP ALM
• Provided post-deployment support and organized knowledge transfer sessions to team of end users

Environments: JIRA, MS Office Suite, MS Visio, MS Sharepoint, Oracle 11g, Toad, HP ALM, MagicDraw, SVN, SQL, Java, IBM Cognos, Windows 8

Confidential

Business Systems Analyst

Responsibilities:

• Operated the COS project following the versatile Agile Unified Process (AUP) methodology
• Performed Gap Analysis to understand, re-engineering & upgrade the current system
• Performedfeasibility and adaptability studyto identify the business critical areas from User perspective
• Responsible for Business Analysis and Project Management of a firm-wide cross continental project, users from different regional teams to capture user requirements
• Conducted JAD sessions to with development architects and business leads to develop both high-level and detailed application architecture
• Prepared and conducted walkthrough sessions on high level Business Requirement Documents (BRD) and Use Cases with project team
• Worked closely with with Source Data, Reference Data, FX Data and Data Warehouse team to ensure accurate transfer of data
• Coordinated daily, weekly and monthly meetings with development team and project team to keep track of development and resolve open issues and manage Change Requests (CR)
• Executed SQL queries to ensure accurate mapping of trade data tables to General Ledger (GL) reconciliation tables based on US GAAP compliance
• PerformedRisk Analysis of the requirementsto identify the key business risk areas for the project and prioritized the application development
• Prepared several test and use cases to confirm the beta-application functions within the business tolerances
• Supported UAT and streamlined the defect tracking and rectification effort
• Created Wireframes, Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using MS Visio and Erwin

Environments: MS Office Suite, MS Visio, MS Project, MS Sharepoint, Oracle 10g, MySQL, IBM Cognos, ERwin, Wiki, HP Quality Center, HP LoadRunner, SQL, VBA, Java, Windows XP.

Confidential

Associate Business Analyst

Responsibilities:

• Prepared the detailed project plan with the help of the project manager and estimated the completion of various levels of the project
• Prepares detailed BRD and FSD and assisted in TSD
• Worked closely with the Project Management Office (PMO) in defining timelines & schedules for the project
• Worked with trading team to ensure accurate calculation and exchange of risk figures
• Played a major role in requirements gathering from the users and creating use cases, activity diagrams and process flow diagrams
• Responsible for creating and publishing document templates and UI Wireframes
• Reported weekly status updates to project management and stakeholders.
• Performed intensive testing of use and test cases with the QA team to ensure project alignment and defect detection
• Provided 3-month post-production support to review and rectify bugs with development team

Environments: MS Office Suite, MS Sharepoint, Wiki, Oracle 10g, HP Quality Center, HP LoadRunner, MS SQL Server, MS Access, SQL, Java, Windows 7

Confidential

Associate Software Engineer

Responsibilities:

• Liaised with client team to gathering requirements.
• Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
• Created tables and procedures for the backend
• Liaised with production team to analyze bugs and resolve issues
• Troubleshot and resolved bugs in .NET applications to ensure optimal development environment

Environments: Microsoft TFS, Oracle, XML, HTML