SUMMARY

• Seasoned IT Professional with 8+ years of work experience in roles such as Sr. Business System Analyst, Business Analyst in domains such as Finance, Insurance and Banking.
• Hands on work experience in Software Development Life Cycle processes such as Waterfall, Agile (Scrum), Hybrid of Waterfall and Agile methodologies.
• Working knowledge of industry standard methodologies such as Rational Unified Process (RUP), XP (Extreme Programing), Spiral and Kanban.
• Experience with Change Management, Risk management, Business Continuity Planning in waterfall methodology.
• Extensive knowledge of Process Re - Engineering, Business Process Improvements, Data Analytics along with experience in Discovery Sessions, Interviews, Joint Application Development(JAD), Focus Groups, Prototyping, Document Analysis.
• In-depth knowledge of Software Development Life Cycle (SDLC) that includes Requirement Elicitation, GAP analysis, Impact Analysis, SWOT Analysis, Cause & Effect Analysis, Cost Benefit Analysis, Risk Analysis, Feasibility studies.
• Experienced in writing User stories and handling the Requirement Churn in Scrum. Efficient in performing prioritizing techniques such as MoSCoW, KANO, Walking Skeleton, Validated Learning and Business Value Based.
• Extensive experience creating requirement artifacts such as Business Requirements Documents (BRD), Functional Specification Document (FSD), Use-Cases, UML, Data Mapping Document and System Requirements Specifications (SRS).
• Experience creating Requirement Traceability Matrix (RTM) to determine relationship by correlating baseline documents.
• Experience in successfully communicating with Subject Matter Experts (SME’s), Business Sponsors and Project Stakeholders.
• Extensively used JIRA, Rally, Version One for generating Scrum Artifacts and User Story Tracking.
• Facilitated Sprint Ceremonies (Backlog Grooming/Story Time, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) for Agile Scrum Methodology as Scrum Master. Created and maintained Scrum Artifacts such as Sprint Burndown Charts, Sprint Tasks, Sprint Backlogs, Product Backlog Item (PBI), Product Backlog, Product/Release Burndown Chart.
• Extensive experience in employing Estimation techniques such as Planning Poker, T-shirt sizing, Relative Mass Evaluation.
• Experience creating Business workflows and Unified Modeling Language (UML 2.0) diagrams including Use Cases, Sequence Diagrams, Data Flow Diagrams, Activity Charts and ER Diagrams (Entity-Relation Diagram) using Rational Rose, MS Visio.
• In-depth experience in creating customer centric ad-hoc reports, story points and dashboards using Tableau.
• Experience using QC tools such as HP Quality center/ HP ALM. Experience reviewing Test Cases, Test Plans, Test Scripts, Test Analysis Reports, UAT Test Cases, UAT Test Plans and Test Scenarios.
• Expertise in documenting process models by Business Process Modeling (BPM) software such as TIBCO.
• Good Understanding of Project Management, proficient with Project Management Tools, Testing and Defect Reporting Tools.
• Knowledge of Databases, Data Warehouse, Data Vault, Data Lake, Data Table Structures, Schemas (Star, Snowflake, Galaxy/Multi-Star), Data Marts, ODS, OLTP and OLAP.
• Experience eliciting and converting business functionalities into Service Oriented Architecture (SOA) models. Knowledge of programing languages such as SQL, JavaScript. Experience working with Three-Tier architecture/n Tier Architecture, J2EE.
• Experience in projects involving Web Services. Conceptual Knowledge of SOA, SOAP, WSDL, REST, HTTP, XML DTD’s, XML Schema, Database Adapters, JDBC and ODBC. Assisted in creating XML Tags and validating Request and Response XML.
• Knowledge of MVC (Modeler, Controller and View) architecture, SOAP and HTTP Request and Response.
• Gathered business requirements and ensured correctness and completeness of Client Side and Server Side Validations.
• Worked with developers during Content Negotiation and designing of Restful API as per Richardson Maturity Model.
• Experience working in all stages of ETL (Extract Transform and Load); Knowledge of Pipelined and Multistage Transformation.
• Assisted Data Analyst during Data Profiling to ensure Data Integrity using Informatica Data Quality (IDQ).
• Created Data Mapping Documents using Mapping Manager. Understanding of Mapplets, Transformation Logic, OLAP cubes, Facts in Fact Table, Hierarchy in Dimensional Lookup Table; Worked with Slowly Changing and Fast Changing Dimensions.
• Extensively used SQL Queries including JOIN, Nested Queries, Data Triggers and Constraints to ensure Data Integrity.
• In depth knowledge of Microsoft Excel, Macros, VBA (Visual Basics for Applications) for MS Office programs.
• Worked with Data Migration team for source system exploration. Also worked with ODS (Operational Data Storage), Staging Area and OLTP (Online Transactional Processing) systems. Experience creating Ad-Hoc reports using Tableau, IBM Cognos.
• Created of ER Diagrams, Conceptual Data Models using tools such as Enterprise Architect, MySQL Workbench.
• Knowledge of different types of OLAP cubes such as HOLAP, ROLAP and MOLAP. Hands on experience in OLAP Cube operations such as Roll-up, Drill-down, Slice, Dice and Pivot. Successfully gathered requirements for OLAP cube dimensions and measures.
• Facilitated Black-Box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load, Stress and Performance Testing.
• A dedicated team player, with proven track record in producing high quality work under tight deadlines.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Hybrid Waterfall-Scrum, Rational unified Process, Scrum, Extreme Programing, Kanban

Project Management Tools: Unified Modeling Language (UML 2.0), MS-Project, MS Share Point, Rally, JIRA, Version One, MS Visio, Erwin, Enterprise Architect

Requirement Management: JIRA, Confluence, HP ALM 11.5, MS Office (Word, Excel, Power Point, Access, Project), Share Point, TIBCO

Reporting Tools: Tableau, MS office Suite, IBM Cognos, Spotfire, SSRS

Database: Teradata, SQL Server 2000/2005, Oracle, IBM DB2

Office Tools: MS Word, MS Excel, MS PowerPoint, MS SharePoint 2013, MS Project, MS Visio

Testing Tools: HP QC, HP ALM 11.5, Soap UI, SeleniumHQ

ETL Tools: Informatica, SQL Server Data Tools-Business Intelligence (SSDT-BI), SSIS

Languages: HTML, CSS, XML, SQL, Excel- Macros, VBA and Java

Defect Tracking tools: JIRA, HP ALM, HP QC

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Cube operations such as Slicing, Dicing, Drill Down, Roll Up, Pivot, ODS, Informatica Data Quality, ETL, Mapping Manager

Graphical Tools: Mock-Up Screens, Wireframes, Balsamiq

Statistics: Data Modeling and Analysis, Regression, Hypothesis testing, R Programing, JUMP (SAS), Minitab

PROFESSIONAL EXPERIENCE

Confidential, Monterey Park, CA

Sr. Business System Analyst/Scrum Master

Responsibilities:

• Knowledge of Gramm-Leach-Bliley Act (GLBA), Bank Secrecy Act, PATRIOT Act and PCI-DSS.
• Created Mockups using Balsamiq to represent User Interface and gathered feedback from users and development team.
• Created Use Case Documentation for system requirements, Business Process, Information Flows and mockups using MS Visio.
• Incorporated Agile engineering techniques such as Test Driven Development (TDD), Acceptance Test Driven Development (ATDD), Continuous Integration (CI) and Pair Programing.
• Conducted JAD sessions, Document Analysis, Job Shadowing, Survey/Questionnaire, Interviews, Focus Groups with Subject Matter Experts (SME’s) and Business Stakeholders to elicit and analyze requirements.
• Worked with Fraud Analysts/Risk Analysts to conduct GAP Analysis, SWOT Analysis, Feasibility Studies, Cost Benefit Analysis (NPV Calculation) to derive and analyze requirements for the enhancement of Fraud Detection System.
• Initiated Scrum Process, conducted Scrum Workshops and coached team on Agile implementation and adapting to Scrum.
• Facilitated User Story Writing Sessions to decompose BRD into User Stories and determine Acceptance Criteria and Definition of Done for Potentially Shippable Product Increment (PSPI).
• As a Scrum Master, facilitated Scrum events/ceremonies including Backlog refinement/Story Time, Sprint Planning, Stand up meeting/Daily Scrum, Sprint Review and Sprint Retrospective Meeting.
• Assisted the Product Owner to Prioritize the Product Backlog items; decomposed Sprint Backlog into Sprint Tasks by taking suggestions from the cross-functional, self-organizing scrum development team.
• Used prioritizing techniques like MoSCoW, KANO Model, Business Value, Walking Skeleton for prioritizing the user stories in the Product Backlog at Backlog Refinement Meeting. Created Story Mapping Chart to better understand requirements.
• Created and Maintained the Sprint Burndown charts, Release Burndown Chart, Defect Logs, Impediment Lists.
• Created and maintained Scrum Artifacts such as Sprint Burndown Chart, Release Burndown Chart, Sprint Backlog, Sprint Task to keep track of team’s progress. Calculated team’s velocity for better planning of sprint life cycle.
• As an experienced Scrum Master anticipated and removed impediments from project team’s path and pushed them to deliver quality results and assisted Product Owner in increasing ROI (Return on Investment).
• Assisted with User Acceptance Testing, developing and maintaining requirement artifacts, and ensuring that appropriate versions of documentations are maintained. Assisted Quality Analysts in Black Box, Functional, UAT and Regression Testing.
• Extensively involved in the User Acceptance Testing phase to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated.
• Tracked requirement for the software application using HP ALM and verified adherence to Requirement Traceability Matrix (RTM).
• Assisted UI team in gathering requirements and validating completeness and correctness of Client Side Validations.
• Identified important entities, attributes and cardinalities and Used MySQL workbench to create a Conceptual Data Model.
• Facilitated code reviews to ensure security testing of API to prevent SQL injection, memory leaks, man in the middle attack.
• Assisted ETL team in creating Data Mapping document to accurately map attributes of source system to target repository.
• Identified Entities and Relationships (Association, Aggregation, Composition, Specialization) to create ER diagrams using ERwin.
• Created multiple regression models using SAS (JUMP) to identify attributes that impact transactional fraud based on historical data.
• Used XML Spy to modify and update XML Nodes and create XML Schema. Used SQL Queries to fetch data from databases.
• Used JIRA for issue tracking, user story management, requirement traceability and creating Sprint Burndown Chart.

Environment: Scrum - Waterfall Hybrid, MS Visio, MS Project, MS office, Fraud management, Risk management, UML 2.0, AJAX, JavaScript, Apache Tomcat V7, JAVA 2 EE, Oracle 11g, JIRA, Informatica v9x, Wireframes, Eclipse, Balsamiq, Tableau, HP ALM, HTML, CSS

Confidential, Strongsville, OH

Business System Analyst/Scrum Master

Responsibilities:

• Experience working with ETL analyst during Extraction, Transformation and Loading (ETL) using Informatica.
• Designed conceptual data models and conducted normalization, de-normalization of data; Used OLAP cubes for Slicing and Dicing, Roll Up, Drill-down operations for analytical decision making support.
• Worked on Service Oriented Architecture (SOA), SOAP, XML; Used AJAX and JavaScript for validations and integrating business server side components on the client side within the browser.
• Involved in Data Mining using SQL Queries (CRUD Operation) to analyze the data for business needs and check Data Integrity.
• Analyzed Gaps in the existing Anti-Money Laundering infrastructure and documented road maps to achieve enhancements.
• Analyzed the prior documentation and business processes for full understanding of the project requirements. Interviewed AML experts, BSA officer to gather requirements and facilitated communication between the business and technical staff.
• Conducted JAD sessions, Interviews and Document Analysis with the stakeholders for the requirements elicitation.
• Conducted Story Writing Session with the Product owner and Scrum Development Team; Also defined Definition of Done, Definition of Ready and Acceptance Criteria for the Agile project.
• Created User Stories and led the Planning Poker game to estimate complexity in Sprint Planning /Backlog Grooming meetings.
• Facilitated Scrum Ceremonies (Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective).
• Assisted Product Owner with prioritization of the user stories using Relative Mass Evaluation, KANO and MoSCoW Techniques.
• Tracked and updated Agile Team’s velocity and facilitated self-organization by creating Sprint Burndown Chart and Product Burndown Chart/ Release Burndown Chart; Enforced Time Boxes and Supported the Agile team by resolving impediments.
• Ensured User Stories were written as per INVEST criteria; Conducted Scrum Workshops to encourage team adapt Scrum.
• Involved in Test Planning, Test Preparation, Test Execution and Issue Resolution and Test Analysis Report generation to assure that all aspects of a project are in compliance with the business and regulatory requirements.
• Logged and tracked the defects in HP ALM and created an RTM and managed the testing process with the QA team.
• Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios; Extensively used RALLY throughout the project.
• Handled Requirement churn during the project by performing Impact Analysis by checking the feasibility in maintaining the Triple Constraint and discussing them in Daily Scrum.
• Created Deployment Flow Chart, Data Dictionary, Meta Data Registry and Data Mapping Document.
• Create ad-hoc reports and assist in data analysis to Quantitative research team and trade desk support analysts
• Identified expected and unforeseen data complexities to mitigate their impact on the analytic outcome and business decisions.
• Created Dashboards and ad-hoc reports using Tableau. Extensively used OLAP cubes to retrieve analysis from data warehouse.
• Proven record of Team Management, Project Management, Conflict Management and Leadership Skills.

Environment: Scrum - waterfall Hybrid, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Visio, HTML, CSS, JavaScript, Asp.net, C# .net, Visual studio, MS SQL 2008, Tableau, RALLY

Confidential, Boise

Business Systems Analyst

Responsibilities:

• Facilitated joint interactions with users and Subject Matter Experts (SME’s) to Identify Gaps, Elicit Business Requirements.
• Evaluated multiple solutions for existing business problems using Cost Benefit Analysis, Risk Analysis, SWOT analysis.
• Successfully gathered business requirements by conducting JAD sessions, interviews for business users, SME’s and stakeholders. Also ensured the team understood the precise customer requirements by conducting Document Analysis.
• Ensured that the team understood the requirements by conducting joint sessions with Data architect, Enterprise architect and Solution advisors.
• Ensured focus on extensive Documentation to comply with Waterfall Methodology. Prepared PowerPoint presentations to provide clear and consistent information about project status to development team and external stakeholders.
• Used MS Visio for Process modeling, Process Mapping and Business Process Flow Diagrams.
• Understood the AS-IS system, developed the TO-BE system concepts and also prepared the System Process Maps.
• Documented Data Dictionary, Data Mapping Document, OLAP Requirements, Transformation Logic to assist ETL Analysts.
• Prepared Business Requirement Document (BRD/HLD) and Drafted Systems Requirement Specification (SRS).
• Developed Conceptual and Logical ER model for OLTP and ODS. Identified Entities, Constraints, Relationships, Cardinality.
• Created Data Dictionary, Meta Data Registry and Data Mapping Document for the data models.
• Assisted QA team to design and develop Test Plan, Test Scenarios and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Assisted ETL team to integrate multiple OLTP to the OLAP, using Informatica as an ETL tool and used Tableau as reporting tool.
• Knowledge of Bill Inmon’s and Ralph Kimball’s Paradigms; Knowledge of Data Warehouse and Data Marts.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification, Triggers and Constraints.
• Performed Data Mining to find correlation and pattern in existing data using SQL queries (CRUD operation).
• Used ETL Tools to map data and assemble data repository and created Data Marts.
• Assisted in the implementation of Enterprise Data Warehouse with individual data marts to address areas of business interest.
• Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules.
• Designed and developed all Use Cases and UML Models using MS Visio and Enterprise Architect.
• Created Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams and Class Diagrams.
• Performed SQL queries using Join and Nested Queries to fetch data from multiple tables in Relational Database.
• Created Deployment Flowchart for the development, infrastructure, network teams containing instructions for maintenance.
• Co-Authored Change Control Procedures and Incident Reporting.
• Managed cross functional Project Teams and Ensured Optimal Utilization of resources for successful project completion.

Environment: SDLC, Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS SQL, Informatica, Tableau.

Confidential, Columbus, OH

Business Systems Analyst

Responsibilities:

• Elicited business requirements for the project using Interviews, Document Analysis, Surveys, Site Visits, Use Cases.
• Conducted Joint Application Development (JAD) sessions with Subject Matter Expert (SME) sessions.
• Understood Insurance Process and gathered requirements in reference to the Insurance Regulations.
• Elicited and documented Functional requirements, business requirements AS-IS and TO-BE business process models.
• Analyzed and gathered requirements for preparation of Functional Specifications Document (FSD) and Use Case Document.
• Created comprehensive documentation as per Waterfall Methodology. Provided clear and consistent information about project status both internally, IT team and stakeholders.
• Designed Test Plans and Test Cases for User Acceptance testing (UAT) with the help of QA teams in HP Quality Center.
• Prepared Business Process Models using Visio to create process flow diagrams for management and mapping the logical aspects of the process.
• Utilized Informatica for Extraction, Transformation and Loading; IBM Cognos for report generation of the data to be analyzed from the data warehouses and data marts.
• Created the following types of documents mainly: Functional Requirement Specification (FRS), Functional Test Summary, Chance Control Documentation and Validation Specification.
• Ensured proper guidance to software architects and developers during the design and development phase of Software Development Life Cycle. Ensured completeness of requirements for SOA (Software Oriented Architecture).
• Created documentation (Requirement Artifacts) required for the using MS Word, MS Excel and MS Visio.
• Involved in User Acceptance Testing (UAT) for successful implementation of requirements and generation of reports.
• Prepared Requirement Traceability Matrix, Test Analysis and Test Strategy Reports and interacted with QA team to ensure quality of software.

Environment: SDLC Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), HTML, CSS, JavaScript, Asp.net, C# .net, Visual studio, MS SQL 2008, IBM Cognos, JSON, AJAX (JSON and XML)

Confidential

Business Analyst, Scrum Master

Responsibilities:

• Assisted Product Owner and Scrum Development Team to decompose EPIC ’s into smaller User Stories.
• Documented project requirements using JIRA for better visibility of requirements to the agile team.
• Facilitated User Story Writing Sessions with an objective to decompose BRD (Business Requirement Document) into User Stories and determined Acceptance Criteria and Definition of Done for Potentially Shippable Product Increment.
• Assisted product owner to prioritize the Product Backlog Items (PBI’s) during Backlog Refinement and Sprint Planning Meeting.
• Assisted Product Owner in managing the Product Backlog and created User Story Mapping for better understanding requirements.
• As a Scrum Master removed Organizational and team Impediments to enhance project team’s ROI (Return on Investment).
• Negotiated feature trade - offs with the stake holders on a regular basis.
• Used JIRA for issue tracking, user story management and requirement traceability.
• Time Boxed Scrum Ceremonies during Scrum and ensured team delivered PSPI (Potentially Shippable Product increment).
• Build a trusting and safe environment where problems can be raised without fear of blame during Sprint Retrospective Meetings.
• Responsible for Process Improvements toward consistent delivery of working product
• Experience supervising Functional Testing, Black-box Testing, User Acceptance Testing (UAT), and Performance Testing.

Environment: MS Visio, REST, JSON, Scrum Methodology, JIRA MS Word, MS Excel, SQL, MS Access, ClearCase, ClearQuest, Java /J2EE, Spring framework, Rest Web service, GitHub, HP QC, SOA, HTML / CSS / JavaScript, jQuery.

Confidential

Business Analyst

Responsibilities:

• Functioned as a Liaison between development team and Business-users during requirement elicitation.
• Successfully used techniques such as Questionnaires, Document Analysis, Interviews, Requirement Workshops, User Interface Mockups, JAD/JAR Sessions and Brainstorming to gather businessuser requirements.
• PreparedUse Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio, Rational Rose.
• Performed GAP analysis (As-Is / To-Be) to conceptually understand requirement and implement enhancements.
• Used MySQL workbench to Assisted data architect in developing Conceptual and Logical Data Models.
• Assisted Project Manager in Data Analysis, Feasibility Analysis and SWOT Analysis.
• Used Business Process Management (BPM) for managing the business operations within the organization, improving the business process efficiency.
• Documented BusinessRequirement Documents (BRD), System Requirements Specification (SRS) and Use Case Document.
• Formulated and managed schedules, deadlines, resources and the project tasks using MS Project Professional
• Coordinated with the Business Analysts for compiling Data Mapping Document and facilitated ETL team during Data Profiling, Data Cleansing, Data Extraction and Integration to the data mart by using the Informatica Power Center.
• Assisted in writing SQL queries like Select, Update, and Joins to retrieve desired information.
• Compiled and managed Requirement Traceability Matrix (RTM).
• Prepared and presented progress and status reports on a weekly basis to stakeholders.
• Assisted in developing Release Notes, User Manual and Training Manual for the project.

Environment: Waterfall, UML, MySQL, MS Office (MS Word, MS Excel, and MS PowerPoint), MS Visio, MS Project, SharePoint 2007, Wireframes, Web Services, SOA, SOAP, XML, HTML, CSS, Informatica Power Center, Mockup Screens, V model, Tableau, Apache Tomcat.

Confidential

Jr. Java Developer

Responsibilities:

• Involved in designing the user interface using HTML, user interactions using JSPs on Eclipse and developed custom tags using Java Server Pages Standard Tag Library (JSTL) to support custom UI’s; Also worked on struts framework.
• Worked with Servlets and used JDBC for database connectivity to MySQL. Created modules using AJAX.
• Used AJAX and JavaScript for validations and integrating business server side components on the client side within the browser.
• Created Wireframes and Mock Up Screens using various UI components such as Drop Down Box, Radio Buttons, Text Box etc.
• Assisted in gathering requirements for the GUI (Graphical User Interface) Screens and designing.
• Created Use Cases and designed Use Case Diagrams, Sequence Diagrams and Activity Diagrams using MS Visio.
• Prepared Project related Presentations using MS PowerPoint.
• Created System, Integration and User Acceptance Test Cases to ensure products compliance to Business Requirements.
• Facilitated code walkthroughs/ Code Reviews and knowledge transfer sessions.
• Conducted Impact Analysis for Request for Change. Presented the results to the Change Control Board/ Governing Council.

Environment: Waterfall, MS Office, MS PowerPoint, MS Excel, MS Access, Java, J2EE 1.4, JSP 2.0, DHTML, Load runner, Rational Rose, Spring MVC, MS Project windows 2000, Clear Case, WebLogic Application Server, UML, Eclipse 3.1, MySQL and Bugzilla.