SUMMARY:

• Business Systems Analyst professional wif over 8+ years of extensive experience in IT Industry, working experience in Insurance, Logistics, Mortgage & Banking
• Extensive experience in Software Development Life Cycle (SDLC) methodologies and Well experienced in working wif Waterfall, Agile Scrum, RUP and Waterfall - Scrum hybrid methodologies
• Techniques wif expertise in Requirements Gathering, Requirements Analysis, Design, Development, post-production support and maintenance of various applications
• Experienced in conducting various Elicitation techniques like JAD session, SWOT ANALYSIS, INTERVIEWS, USER STORIES & BRAIN STORMING and DOCUMENT ANALYSIS wif business to gather requirements
• Excelled at conducting GAP Analysis using AS-IS and TO-BE business processes
• Possess excellent Business writing skills in creating Business Requirements Document (BRD), Functional Specification Document (FSD), Systems Requirements Specification (SRS), Process models, Test Plan, Test case and Test reports
• Knowledge of web services related concepts like XML, Ajax, SOA, HTML5, XHTML, CSS, Ajax and JavaScript
• Well versed wif various protocols related to web-services and SOA (Service Oriented Architecture) like SOAP, REST and the Internet Protocol Suite like HTTP (Hyper text transfer protocol, TCP, FTP (File transfer protocol)
• Skilled in documenting Unified Modeling Language (UML) diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams, Data Flow diagram, Business process modeling and Business Flow Diagrams using MS Visio
• Well versed wif the Net and Java platforms, especially wif 3 tier architecture which involves User Interface, API, Middle Tier, Data Layer, IIS, Tom Cat, Apache, and Application Servers etc
• Expert in creating Specifications and designing Conceptual, Logical and Physical Entity-Relationship diagrams (ERD) using VISIO & ERWIN
• Extensive involvement wif Databases, Operational data store, Data Warehousing, Data Modeling, Dimensional Modeling, Data Analysis, Data Mapping, Data dictionary and Normalization
• Extensive Knowledge working wif ETL tools like Informatica Power center, Data stage, Microsoft SSIS
• Proficient in creating reports using Business Intelligence tools like Tableau, Qlikview, spot fire and IBM Cognos
• Working knowledge of SQL in generating DDL, DML, & DRL Excellent understanding on PLSQL & TSQL
• Proficient Knowledge in working wif Database management system (DBMS), DATA Warehouse Management Systems (DWMS), Logistics Management, Claim processing system, Mortgage processing system
• Extensive years of experience in Business Process Re-engineering, It security, project life cycle management
• & Data Analysis
• Facilitated scrum ceremonies in Agile Scrum Methodology as Scrum Master and responsible for solving impediments, conflicts and conducting the various ceremonies like backlog refinement meeting, scrum planning, daily scrum, scrum review and scrum retrospective meetings
• Proficient in writing user stories, conducting Planning poker, T-shirt sizing, Moscow, Kano, Silent writing and other techniques in Scrum Process
• Proficient in management tools like TFS, JIRA, Rally, Version One, HP ALM, MS OFFICE and MS Project
• Used MS SharePoint for document sharing, team collaboration, content management and websites creation
• Designed & executed test plans, test cases and tracked defects and got them resolved
• Possess experience in Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing & Performance Testing in different projects
• Strong balance of operational, business, technical aptitude and comprehension of their respective needs
• Adept in team management, problem-resolution, conflict management and people management interpersonal skills
• Highly experienced in leading different groups wifin different levels of management satisfying business needs of company
• Strong leadership, listening and excellent critical thinking skills has always made me an great scrum master
• Confident in taking ownership and leading teams during the entire life cycle of the project
• Energetic, positive, and self-motivated Ability to adapt quickly to challenges and changing environments

TECHNICAL SKILLS:

Methodologies: Agile, Agile Scrum, Waterfall, Waterfall-Agile Scrum Hybrid, Rational Unified Process

Operating Systems: Windows XP, Vista, 7, 8, Mac OS X, Linux

Microsoft Tools: MS Office, MS Project, MS SharePoint, Version One, Word press, Mock up screen

Programming Knowledge/Frameworks: C, C++, Java/J2EE, net fame work, c#

Web technologies: XHTML, PEGA,HTML 5/CSS, JavaScript, Ajax, XML,WSDL, HTTP, XML, SOAP,JSON

Databases: My SQL database, Oracle, MS SQL database

Designing Tools: MS Visio, ERWIN, Balsamiq, Mocking Bird

Domains: Insurance, Mortgage, logistics, Banking

ETL/Reporting Tools: Informatica, SSIS, SSRS, Tableau, Qlikview, IBM Cognos, Spotfire

Data Warehousing: OLTP, Data modeling, ETL, data staging, ODS (Operational Data store), Data warehouse, Facts & dimensions table, Data marts, OLAP, BI Reporting, Data mining

Methodology Tools: JIRA, TFS, RALLY, Version one, HP ALM

Testing Tools: HP ALM/QC, HP Load Runner, Smart bear

PROFESSIONAL EXPERIENCE:

Confidential

SENIOR BUSINESS SYSTEMS ANALYST/SCRUM MASTER

Responsibilities:

• Established a Business Analysis methodology around the SCRUM and WATER FALL hybrid methodology
• Performed the gap analysis to define the current and future business requirements for the new functionalities by analyzing As-Is/To-Be states
• Conducted JAD sessions, document analysis & one to one interviews for the requirements elicitation
• Prepared FSD, Use Case diagrams, Activity Diagrams and other UML diagrams
• Created Business process models to improve the business process reengineering
• Performed Data analysis for cleaning, transforming the data and created Data models (conceptual and Logical ERD diagrams)
• Created Data mapping and ETL documentation to migrate data from source and target databases
• Documented proper business rules in creation of facts and dimension tables & also generated Analytical reports
• Used SharePoint 2013 for Content management, team collaboration and creating websites
• Worked on creation of prototypes using HTML/CSS, mockup screens, wire frames and Paper proofs for better visualization and understanding of the software solution
• Understood the importance of Three tier architecture and interacted wif the development team on the same
• Worked wif developers in providing them Business rules for development on net framework
• Played a key role in User Acceptance Testing, Integration testing and performance testing and writing test cases, test plans and RTM (Requirements Traceability Matrix)
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle
• Acted as an agile coach in making the team understand the importance of scrum
• Facilitated all the scrum ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming)
• Implemented the time-boxes, solved many impediments and conflicts wifin the team and halped them in working wif good collaboration
• Made the team understand the importance of scrum and got a smooth transition from waterfall to scrum
• Wrote the user stories & tracked team velocity using Sprint burn down chart and Product burn down chart
• Enable the team to improve their agile maturity by implementing TDD, Paired programming, spike solution,
• Coding dojos
• Motivated the scrum development team to collaborate and self-organize for the maximum productivity and efficiency
• Involved in handling and management of requirements churn
• Collected feedback from the various stakeholders and product owner during sprint review meeting

Environment: Waterfall-Agile Scrum Hybrid Methodology, MS Office, VISIO, TFS(Team foundation server), HTML/CSS, JAVASCRIPT, MOCKUP Screens, net frame work, SharePoint 2013,Informatica Power Designer, Tableau, Oracle 12c Database

Confidential

BUSINESS SYSTEMS ANALYST/SCRUM MASTER

Responsibilities:

• Conducted JAD sessions and one-on-one interviews wif the stakeholders for the requirements elicitation
• Prepared BRD (Business requirement document) & FSD (Functional specification document)
• Created UML diagrams such as activity diagram, use case diagram and data models like conceptual & logical diagrams
• Created ETL documentation, data mapping documentation and performed ETL (Extraction, transformation & loading) to extract data from OLTP system and load the data onto staging area
• Documented proper business rules in creation of facts and dimension tables
• Created Business process models to improve the overall business process
• Helped the developers in enhancing the GUI by using HTML5, Java script and AJAX programming
• Wrote complex SQL queries to filter out data from the databases
• Made Requirements Traceability Matrix (RTM) for tracing the test cases back to the requirements, ensuring requirements are met
• Served the QA team to develop the test plans and test cases to perform the UAT testing and black box testing
• Acted as an agile coach in making the team understand the importance of scrum
• Walked through the scrum ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming) and tracked team velocity and sprint progress using Sprint burn down chart and Product burn down chart
• Solved many impediments and conflicts wifin the team and halped them in working wif good collaboration
• Involved in handling and management of requirements churn and also worked on burn down charts
• Imposed the time-boxes and sorted out the impediments and conflicts faced by the scrum development team

Environment: Waterfall-Agile Scrum Hybrid Methodology, NET, MS OFFICE, SharePoint 2010, MS VISIO, JIRA,SQL Server Database, SSIS,SSRS

Confidential

BUSINESS SYSTEMS ANALYST

Responsibilities:

• Performed the gap analysis to define the current and future business requirements for the new functionalities by analyzing As-Is/To-Be states
• Went through the process of Waterfall software development life cycle (SDLC)
• Conducted JAD sessions and one-on-one interviews wif the stakeholders for the requirements elicitation
• Prepared BRD( Business requirement document ) and FSD(Functional specification document)
• Created UML diagrams such as sequence, activity and use case diagrams
• Created BPMN to understand the entire business process and perform Business process reengineering
• Worked on creation of prototypes using mockup screens, wire frames and Paper proofs for better visualization and understanding of the software solution
• Helped the developers in enhancing the GUI by using HTML5, Java script and AJAX programming
• Performed data mapping, Maintained and distributed various documents to the stakeholders using MS SharePoint 2010
• Performed Extraction, Transformation and Loading (ETL)
• Wrote complex SQL queries to filter out data from the databases
• Worked on web services, Service-Oriented Architecture (SOA), SOAP, XML and API
• Designed, developed, implemented, and supported QlikView dashboards
• Integrated data sources and databases wif QlikView, and designed and developed data models and backend queries for presenting data
• Served the QA team to develop the test plans and test cases to perform the UAT, and defect management
• Made Requirements Traceability Matrix (RTM) for tracing the test cases back to the requirements

Environment: Waterfall Methodology, MS VISIO, MS OFFICE,PEGA, HTML5 /CSS, JAVASCRIPT, AJAX,JSON, HP ALM, HP Load Runner (Share point 2010), Informatica, Qlikview, Oracle Database

Confidential, BOSTON, MA

SR. BUSINESS ANALYST

Responsibilities:

• Performed the gap analysis to define the current and future business requirements for the new functionalities by analyzing As-Is/To-Be states
• Wrote Business Requirements Documents (BRD) by interviewing the business users and also conducted JAD sessions to elicit requirements
• Assisted the project manager on project management tasks such as project scope development, WBS, resource allocation, project estimation
• Created ERD Diagrams (conceptual & logical) data models
• Created Unified Modeling Language -Activity diagrams, Sequence Diagrams and Use case diagrams for business stakeholders to understand the business process
• Worked on creation of prototypes using mockup screens, wire frames and Paper proofs for better visualization and understanding of the software solution
• Wrote test cases for documenting test plans and prepared Requirements Traceability Matrix (RTM)
• Used MS Share point for content management and document management
• Attended Scrum ceremonies like Backlog refinement meeting, Sprint planning meetings, Daily Scrum Meeting, Scrum review meetings & Retrospective meeting
• Assisted scrum master in maintaining the burn down charts and have also created user stories
• Assisted the product owner and the team in prioritization, estimation and retrospective technique
• Performed data mapping to establish mapping between source and target
• Implemented all stages of application development processes including extraction, transformation and loading (ETL) data from various sources into Data warehouse and Data Marts using Informatica Power Center Designer
• Built SQL queries to retrieve data from data base to verify the integrity of data
• Assisted data warehouse team in building fact and dimension table
• Used Tableau to generate internal reports to study and analyze the planned interfaces

ENVIRONMENT: In-house & scrum hybrid Methodology, MS VISIO, MS OFFICE, HTML5 /CSS, Informatica Power Center Designer, Spotfire, JAVASCRIPT, Rally, AJAX, MS SHARE POINT 2007, MYSQL DATABASE

Confidential

BUSINESS ANALYST

Responsibilities:

• Facilitated JAD sessions wif the stakeholders for the requirements elicitation
• Performed the gap analysis to define the current and future business requirements and states along wif the steps needed to overcome that gap for the new functionalities
• Created the UML diagrams such as sequence, activity and use case using MS Visio for proper visualization
• Made the Business Requirements Artifact by documenting all the business requirements, and tan Functional Requirements Artifact by documenting all the functional and non-functional requirements, eventually obtained the sign-off from the stakeholders for the same
• Created Requirements Traceability Matrix (RTM) for tracing the test cases back to the requirements
• Updated and shared the various document using MS SharePoint 2007
• Assisted testing team to develop test cases to perform black box and UAT
• Helped the QA team in defect management and error-reports generation using HP QC

ENVIRONMENT: RUP Methodology, MS OFFICE, HTML /CSS, SQL DATABASE, MS SharePoint 2007, HP QC, IBM cognos, Version One

DATA ANALYST/ DATA MODELER

Confidential

Responsibilities:

• Working wif the Business Analyst and DBA, conducting team meetings and JAD sessions for technical requirements gathering, business analysis, testing and project coordination
• Created Conceptual Data Model (CDM), Logical Data Model (LDM) and Physical Data Model (PDM) for the OLTP application using Visio
• Involved in data model reviews wif internal data architect, business analysts, and business users wif in depth explanation of the data model to make sure it is in line wif business requirements
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards
• Responsible as a member of development team to provide business data requirements analysis services, producing logical and Physical data models using VISIO
• Involved in designing built Data marts by using Star Schema and Snowflake schema
• Closely worked wif ETL process development team
• Experienced in designing the Data warehouse

ENVIRONMENT: Waterfall methodology, SQL DATABASE, MS VISIO, data modeling, SSIS, SSRS

Confidential

DATA ANALYST

Responsibilities:

• Responsible for project management, logical and physical OLTP database and data warehouse modeling, data mappings, data analysis and integration
• Created conceptual and Logical data models using best practices to ensure high data quality and reduced
• Redundancy
• Optimized and updated logical and physical data models to support new and existing project
• Implemented Referential Integrity using primary key and foreign key relationships
• Maintained conceptual, logical, and physical data models along wif corresponding metadata
• Provided the means of system integration by understanding the source and target data and built the data mapping
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models
• Recommended opportunities for reuse of data models in new environments
• Examined new application design and recommended corrections wherever required
• Involved in logical and physical database designs and data mappings between cross functional application and used SQL queries to filter data
• Performed Data Analysis for building the reports and building Enterprise Data warehouse (EDW)
• Assisted wif project and problem analysis, TEMPeffectively communicated wif management and adhered to firm’s policies and procedures

ENVIRONMENT: Waterfall methodology, ORACLE DATABASE, MS VISIO, data modeling, Informatica