SUMMARY

• A dynamic IT professional with 5+ years of professional experience as Technical Business and Data Analyst in Finance and Retail domain.
• Excellent knowledge with Capital Markets, Trading, Equities, Fixed Income, Treasury Securities, Municipal Bonds, Stocks Trading Cycle.
• Methodologies: In depth knowledge of Agile, RUP, Waterfall, RAD, Prototype
• Hands on expertise in Requirement Gathering and Management
• Expertise in facilitation of interviews, conference and Rapid Application Development (RAD)sessions
• Adept at requirements gathering, Surveys/Questionnaire development, Business Requirement Documents (BRD), Functional Requirement Documents (FRD)
• Excellent in performing feasibility studies and perform Impact Analysis, Gap Analysis and Risk analysis
• Expertise in change request/requirement change management across teams
• Excellent in creating Use Cases, Activity Diagrams, Sequence Diagrams and strong knowledge of Unified Modeling Language(UML)
• Strong knowledge and hands - on experience in SQL and Relational Databases. Experience in complex querying of databases for Data Analysis and testing
• Experience in Data Analysis and Regression Analysis
• Experience in Data Modeling, and Solid understanding of Relational DB, Object-Oriented DB
• Solid skills in Data Warehouse, writing SQL queries, and procedures using SQL editors
• Experience in User Acceptance Test (UAT)

TECHNICAL SKILLS

Requirements Management Tools: Rally, JIRA

User Interface Design Tools: Smart Draw, MS Visio, Just in Mind, MS Paint

Languages, Tools: SQL, Python, R, SAS, Tableau, XML, HTML 5, CSS, JavaScript

Project Management Tools: MS Project, MS Office (Word, Excel, PowerPoint, Access)

Databases& Data Cache: SQL Server, MS Access, Oracle

PROFESSIONAL EXPERIENCE

Technical Business Analyst

Confidential

Responsibilities:

• Constant interaction with Capital Market business users for job shadowing, understanding certain issues which I need to deal with for completing Proof of Concept.
• Interacted closely with stakeholders and Subject Matter Experts (SME) for gathering requirements
• Took part in meetings for prioritizing Sprint backlogs and managed changes to Product backlogs
• Worked with requirements analysts and Subject Matter Experts to identify, understand, and document businessneeds for the liabilities trading and security data
• Performed requirement gathering and knowledge extraction about the Capital markets using both formal and informal sessions through JAD sessions
• Prepared for GAP Analysis; identified and documented improving areas to meet capital markets requirement regulations.
• Created and maintained User Stories in Rally by brainstorming, and one to one meetings with the business users to communicate requirements to development and testing teams
• Developed mapping document for development and testing teams to provide detailed mapping logic
• Helped development teams to break down large user stories. Involved in various walk-through sessions with developers and testers and conducted presentations to help them understand the end user needs
• Created and regularly updated the Stakeholder Requirements Document every sprint
• Held daily Stand-up Meetings, documented and updated the Burn-Down Charts
• Used SQL queries to retrieve, validate and test data which is stored in Gem fire data cache in TDS system
• Assisted testing teams to build test plans, test scenarios and approved test cases for functional requirements verification and to check the functionality of the application
• Conducted validations for automation team to make sure they use the correct test data and expected output for testing
• Provided status updates to project manager for the daily progress made and milestones achieved

Environment: Agile Methodology, Rally, MS Excel, Gem fire, MS Visio

Business Data Analyst

Confidential

Responsibilities:

• Thoroughly studied the capital market structures and account reconciliation systems to have a clear understanding of the Financial business processes and associated system workflow
• Interacted closely with stakeholders and Subject Matter Experts (SME) for gathering requirements and created Product backlogs
• Collaborated with Scrum Master and Scrum teams in Sprint Planning meeting and Sprint review meetings
• Prioritized Sprint backlogs and managed changes to Product backlogs
• Actively tracked the ROI for various components of the project
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Actively worked with the Capital Market and financial trading team to develop Equities, Futures, Forwards, Options, Derivatives online trading facility
• Offered data support and checking using SQL/Query and developed complex spreadsheets using VBA\SQL.
• Worked with requirements analysts and Subject Matter Experts to identify, understand, and document businessneeds for the data flow to create marketriskand creditriskmodules
• Implemented and calculated risk metrics using MSCI Risk Metrics
• Played lead role in conducting JAD/JAR sessions, got requirement specification documents including Project Objectives, Business Requirements, and Business Rules sign off
• Consulted the business users and SMEs, helped to create Product Backlogs to prioritize features and subsequently created Sprint Backlogs
• Preparation of periodic MIS forDodd-FrankRegulatory Reportable trades
• Held daily Stand-up Meetings, documented and updated the Burn-Down Chart
• Helped development teams to break down large user stories. Involved in various Walk-through sessions with developers and gave presentations to help them understand the end user needs
• Performed rapid prototypingand screen Mock-up utilizing I Rise
• Used SAS and SQL to retrieve, validate and manipulate data
• Assisted Testing teams to build test plans, approved test cases for functional requirements verification and to check the functionality of the application
• Examines and evaluates the purpose and content of currentbusinessreports in an effort to identify opportunities for improvement and automation through macros,VBA, or SQL.
• Collaborated with QA team to create and implement test plan and test cases for User Acceptance Testing (UAT).Involved with the whole UAT to ensure the performance of the system and application
• Developed User Manuals, presentations and manuals as per project specifications and timelines
• Provided status update to the Project Manager of progress made on work products and milestones achieved
• Reviewed with scrum team and BA team to improve their performance,

Environment: Agile Methodology, SAS 9.3, SQL, Oracle 9i, Windows XP, MS Visio, MS Visual Studio 2005.

Data Analyst

Confidential

Responsibilities:

• Handled and integrated large volumes of data from various sources and automated creation of reports on the data as per specifications.
• Performed Mining of the data and implemented predictive/scoring models etc. to enable the Decision Support System
• Elicited requirements from Business owners, SME’s, RMR’s, and concerned teams via conducting JAD sessions, Brainstorming, Interviews etc.
• Documented elicited requirements into Business requirement document (BRD), Functional Requirement Document (FRD) and Software Requirement Specification (SRS)
• Performed independent data/risk/business/financial analysis and report to the senior management
• Wrote extremely complex SQL queries and assisted in SQL testing
• Developed Wireframes, Mockups using MS Visio

Environment: Waterfall, SQL Server(v-10.5), Business Objects(v-3), Oracle(v-8i), Java SE(v-5), MS Office Suite(v-2007), UML, MS Visio(v-12.0). Star Schema and Snowflake Schema, QC(v-10.0)

Business Systems Analyst

Confidential

Responsibilities:

• Assisted in creating a project plan, estimates, schedules, scope statement and establish project milestones.
• Elicited requirements from a range of stakeholders from end users to high level management executives through interviewing, conducted JAD sessions to analyze and prioritize competingbusinessneeds.
• Created Wireframes, Mock ups after closely collaborating with the business users.
• Helped the Product Owner prioritize the Product Backlog Items for developing Sprint tasks by taking suggestions from cross-functional development team.
• As a Scrum Master, facilitated and time-boxed the Scrum ceremonies (Sprint Planning Meeting, Daily Standups, Sprint Review Meeting, Sprint Retrospective Meeting and Grooming Sessions)
• Created and maintained Sprint Burn down chart, Sprint Burn-up chart, Product Release chart, white board to keep track of the team’s progress and the team’s velocity for better estimation of the sprints.
• Worked with the Product Owner during the Sprint Review Meeting for the Potentially Shippable Product Increment (PSPI) and help decide which feature are DONE
• Created H Base, tables to store the final aggregated data from Hadoop system.
• Implemented Continuous integration& deployment CICD through Jenkins for Hadoop jobs.
• Assisted in creating detailed test plans, test cases for integration, regression, end-to-end, smoke, sanity, functional, performance and stub testing.
• Assisted the QA team to create the readiness document to move the system from testing environment to Pre-production environment.
• Documented best practice implementation plans and continuously measured project outcomes for desired results.
• Developed Release Notes, User Manual and Manual for the project.

Environment: Agile-Scrum framework, Jira(v-7.3), Retail, MS Office suite 2013, Oracle(v11g), Sql Server, SQL, TFS, MS-Visio(v-15.0), Process Improvement, Web services.