SUMMARY

• Accomplished Business System Analyst with extensive experience in business products, operations and Information Technology on the capital markets space specializing in Finance such as Trading, Fixed Income, Equities, Bonds, Derivatives (Swaps & Options) and Mortgage with sound knowledge of broad range of financial instruments.
• Over 8+ Years of proven track record as value - adding, result oriented professional with hands-on expertise in System Analysis, Architecting Financial applications, Data warehousing, Data Migrations, SOX Implementation and Process Compliance Projects.
• Certified Scrum Master (CSM) with proven ability to work with self-organizing and cross-functional teams in a wide array of Portfolios, Mortgages and financial sectors.
• Proficient as long time liaison between business and technology with competence in Full Life Cycle of System (SLC) development with Waterfall, Agile methodology, as well as broad cross-functional experiences leveraging multiple frameworks.
• Expertise in creating and documenting artifacts like Business Requirements Document (BRD), Functional Requirements Specification Document (FRD/FRS) and Systems/Technical Requirements Specifications (SRS/TRS), Use Case documentation, and Business Rules Spreadsheet.
• Experience in performing various elicitation techniques such as facilitating Joint Application Development(JAD) sessions involving stakeholders, SME’s, project managers, business sponsors and business users as well as conducting one on one interviews, survey/questionnaires, benchmarking, brainstorming sessions, document analysis for gathering requirements and acquires excellent oral and written communication skills.
• Skilled with concepts of Data Warehousing like Data Modeling, Data Dictionary, Data Mapping and Normalization. Also worked on extracting data through writing complex SQL queries.
• Good knowledge of database relationships and concepts; worked on RDBMS like MySQL and MS SQL server.Also possess expertise in designing schemas, creating databases as well as generating DDL, DML and DRL queries in SQL.
• Proven expertise and experience in handling and conducting various Scrum Ceremonies like Sprint Planning meeting, Daily scrum meeting, sprint retrospective meeting, Sprint review meeting and backlog refinement meeting and adoption of agile related techniques (MOSCOW technique, Planning Poker).
• Excellent knowledge of SQL queries which includes viewing and writing JOINTS and hands on experience in creating Entity Relationship Diagrams (ERDs).
• Expertise in creating UML based Modelling views like Activity/ Use Case/Data Flow/Business Flow /Navigational Flow/Wire Frame diagrams using Rational Products & MS Visio.
• Comprehensive knowledge of web services related concepts such as XML, WSDL, HTML, Ajax, SOA, and SOAP Protocol. Comprehensive knowledge of business engines and XML schemas.
• Hands on experience and expertise with tools such as JIRA Green hopper, Version One Rally to document and visualize stories, tasks, and measure sprint performances through Burn down charts/Velocity charts.
• Extensively worked with the On-site and Off-shore Quality Assurance Groups by assisting the QA team to perform Black Box /GUI testing/ Functionality /Regression /System /Unit/Stress /Performance/ UAT's.
• Facilitated change management across entire process from project conceptualization to testing through project delivery, Software Development & Implementation Management in diverse business & technical environments, with demonstrated leadership abilities.

TECHNICAL SKILLS

Business Modeling Tools: Rational Requisite Pro, HPALM,UML, MS Visio, Rational Rose, Adobe Photoshop CS3, Corel Draw 12, Adobe Illustrator.

Methodologies / Frameworks: RUP, Agile/Scrum, Waterfall, Spiral.

Requirement Management: MS Office, JIRA, RALLY, HP ALM 11.5

Database: MS SQL Server 2012/2008/2005, My SQL Work, MS Access

Business IntelligenceReporting Tools: Tableau, Tableau Desktop 8.2, Crystal Reports, Cognos 10 (report & Query studio), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SpotfireProgrammingLanguages (Exposure) Asp.net, Java, JavaScript, .net, C++, C#

ETL Tools: Informatica, IBM Cognos, IBM Infosphere

QA Testing Tools: HP QC, JIRA Green hopper

Documentation Tools: MS Office Suite, SharePoint 2010/2013

Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, DOLAP, MOLAP, HOLAP,Teradata, Query/Reporting, Multidimensional Analysis, Data Mining,Slicing/dicing, Drill Down/Roll Up, MDM

Languages: HTML, CSS, XML, SQL Queries

Project Management Tools: MS Project professional, MS Project Server, MS SharePoint 2010,SharePoint Designer, JIRA, RALLY, Version one

PROFESSIONAL EXPERIENCE:

Confidential | Alpharetta GA

Sr. Business/System Analyst

Responsibilities:

• Evaluated existing practices of storing and handling important financial data for compliance.
• Gathered Business requirements pertaining to Trading, equities and Fixed Incomes like bonds, converted the same into functional requirements by implementing the ScrumFramework with the extensive use of SharePoint 2013.
• Designed and developed all Narrative Use Cases and conducted UML modeling like created Use Case Diagrams, Process Flow Diagrams and Activity Diagrams using MS Visio.
• Assisted in preparing Service Level Agreement for utilizing web services from theUniversal Description, Discovery, and Integration.
• Suggested specific web services and web methods to be registered to help interact with the data layer to access data from the database
• Created Static and Dynamic Prototypes using MS Visio and HTML. Also facilitated in implementation of Client side validations using J-Query.
• Suggested the implementation of Ajax to make user experience more dynamic and interactive.
• Created and implemented plans for Web Content Management Systems (WCMS) including Sitecore and Adobe AEM.
• ImplementedBusiness Process Modeling (BPM) using BPMN and UML diagrams using IBM Rational Rose as well as Graphical User Interface (GUI) - Web page Mock Up’s using Balsamiq.
• Assisted UI team in understanding the business rules and implementing client side validations using J-query.
• Directed the team in implementing SOA architecture.
• Identified the different Web Services from the UDDI that would be needed for the project.
• Assisted in implementing Server Side Validations and business logic in the middle tier.
• Extracted, transformed and loaded from the OLTP through the Operational database store on to the database server using IBM Cognos
• Created and maintainedData Dictionaryand pursued to reach consensus
• Performed data analysis and assisted in data mapping and data validation
• Assisted Product Owner to prioritize user stories using the MoSCoW technique and Planning Poker techniques for estimating product backlog.
• Tracked team velocity, burn down chart, burn up chart and communicated with organization.
• Analyzed user requirements, attended Churn Request meetings to document changes and implemented procedures to test changes.
• Facilitated different scrum ceremonies such as Sprint planning meeting, Daily Scrum, Sprint Review meeting and Sprint Retrospective meeting.
• Involved in preparing test cases and test scenarios and coordinated with other QA’s in executing the test plans.
• Supported scrum team by resolving impediments such as the offshore testing team impediment.

Environment: & Tools:Waterfall and Agile, MS Office Suite, SQL, MS SQL Server, XML, HTML, Oracle, Test Director

Confidential | Columbus, OH

Business/System Analyst/Scrum Master

Responsibilities:

• Served as a liaison between mortgage specialists and the project team.
• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same using SharePoint v2
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Used Adobe AEM to create and implement plans for Web Content Management Systems (WCMS)
• Created Static and Dynamic Prototypes using MS Visio and HTML. Also facilitated in implementation of Client side validations using J-Query
• Identified different web services from the UDDI
• Assisted with implementing client side validations and server side validations
• Assisted in implementing the SOA architecture and SOAP protocol
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision making support.
• As Scrum master facilitates Sprint Planning meeting, tracked team velocity and Sprint progress using Sprint Burn down Chart and Product Burn down Chart, conducted time boxed daily scrum meeting.
• Extracted, transformed and loaded data from the OLTP through the Operational database store on to the database server using IBM Cognos
• Suggested the implementation of Ajax to make user experience more dynamic and interactive.
• Extensive experience in Business Process Modeling using Visual modeling tools with professional expertise in MS Visio, IBM Rational Rose.
• Analyzed the Iteration Burn Down charts and reviewed defects.
• Involved in preparing test cases and test scenarios and coordinated with other QA’s in executing the test plans.
• Prepared test plans, write test scripts and execute test scripts as the project develops.
• Have used XML Spy for Data Mapping and Data Modeling for large scale System Integration with Partner Applications.

Environment: & Tools:Rational Rose, Rational Clear Quest, Win Runner, MSOffice2000, XML, XML Spy, OLAP

Sr. Business/System Analyst

Confidential |Durham, NC

Responsibilities:

• ConductedInterviews,brainstormingand Question and Answer sessions to identifyrequirementsand thendocumentedthem in a format that can be reviewed and understood by both business people and technical people.
• PerformedData Analysis and Data validationby writing complexSQL queriesusing TOAD against theORACLE database.
• Involved in Business Process Modeling (BPM) using BPMN and UML diagrams including Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and Data Flow Diagrams using MS Visio.
• CreatedBusiness Requirementsand converted them into detailed Use Cases, Report Specifications and Non Functional Requirements.
• Performed data analysis and assisted in data mapping and data validation
• Analyzed Requirements and created Use Case Diagrams, Activity DiagramsusingVisio.
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision making support.
• Created and maintainedData Dictionaryand pursued to reach consensus.
• Facilitated with implementation of open source and enterprise-level content management systems. Createddata modelsanddata flow diagramsfor the to-be process.
• Created report specifications containing mapping to source data sources.
• Created and executed SQL queries (usingRapid SQLandMS Access) and scripts to validate data movement and generate expected results for UAT.
• Performed Data Mining,Data Analysis and Data Visualization using BI tools such as Tableau Desktop 8.2&Tableau Server.
• Extracted, transformed and loaded data from the OLTP through the Operational database store on to the database server using IBM Cognos
• Involved in preparing test cases and test scenarios and coordinated with other QA’s in executing the test plans.

Environment: & Tools:Waterfall Methodology, MS Visio, MS Project, Windows XP, Rally, MS SQL Server 2005, HPALM

Confidential

Business Analyst

Responsibilities:

• Planned and conducted the requirements gathering sessions with the business team to collect the business reporting standards, security and service level requirements.
• Identified, analyzed and documented business processes and prepared workflows, process diagrams and DFDs using UML.
• Extensive experience in Business Process Modeling using Visual modeling tools with professional expertise in MS Visio, IBM Rational Rose.
• Used ER Diagrams, Class Diagrams and data flow diagrams to define Data Mapping parameters of the system
• Created Static and Dynamic Prototypes using MS Visio and HTML. Also facilitated in implementation of Client Side Validations and Server Side Validations
• Developed and Implemented Requirements Traceability Matrices, test case mapping to requirements, Project Status reports, Issue /defect matrices, UAT test plans and User documents.
• Involved in preparing test cases and test scenarios and coordinated with other QA’s in executing the test plans.

Environment: & Tools: Waterfall, MS Visio, MS Word, HTML/CSS, AJAX, XML, MySQL, SQL, JIRA, Informatica, MS SharePoint 2013.

Confidential

Business/System Analyst

Responsibilities:

• As a part of the project team interacted closely with the business community to define and analyze the business requirements to present possible technical solutions using MS SharePoint.
• Involved in preparing the project scope, objectives and gathered business requirements by conducting interviews, JAD sessions with subject matter experts (SME’s), stakeholders and development team for clarifying requirements and facilitating better communication.
• Conducted gap analysis to derive the requirements for the proposed systems enhancements.
• Worked closely with the business community in gathering the data storage needs to establish Third Party Liability Issues and P&C.
• Assisted in preparing Service Level Agreement for utilizing web services from theUniversal Description, Discovery, and Integration.
• Suggested specific web services and web methods to be registered to help interact with the data layer to access data from the database
• Implemented Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
• Facilitated in Documentation of Test Cases and Test Plans, Test Scripts, Log Defects, and Requirements for future follow up and bug fixing purposes.
• Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT).

Environment: & Tools: Waterfall, MS Office 2000, IBM Rational suite 7.0, UML, MS Project professional 2007, MS Requisite Pro, Test Director, SQL.

Confidential

Business System Analyst

Responsibilities:

• Analyzed and reviewed the current system.
• Communicated with clients to gather and document business requirements.
• Performed requirements analysis and specifications.
• Developed detailed functional requirements and use cases.
• Performed data analysis and assisted in data mapping and data validation.
• Working knowledge of SQL and of a data analysis package such as DB Artisan.
• Wrote functional and non-functional specifications for wealth management applications.
• Created Power point based prototypes.
• Organized, facilitated and conducted Joint Application Design (JAD) sessions to elicit, specify and gain consensus on requirements, system boundary, relative priority of each of the requirements for grouping into development iterations.
• Facilitate User Acceptance Testing sessions.
• Reviewed and assisted in developing test plans for unit test, system test, test cases and acceptance test.

Environment: & Tools: Waterfall, UML, SQL, Visio, Rational tools.