SUMMARY

• Business Systems Analyst with 8+ years of experience in Business Intelligence/ Business Process Development, System Analysis, Scrum Master and proven ability leading cross - functional and self-organizing teams in various business settings.
• Extensive experience in working and implementing various Software Development Lifecycle Methodologies (SDLC): Waterfall; Agile Methodologies such as Waterfall-Scrum (Hybrid) and Scrum, RUP.
• Experience in eliciting Business Requirements with various techniques, Joint Application Development (JAD), Observation, Interviews, Prototyping, Document Analysis, Interface Analysis, and Survey.
• Expertise in Business Process Re-engineering (BPR), Business Process Modeling (BPM) and Data Analysis.
• Experience in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and translating them into functional specifications.
• Experience in developing workflow analysis and design, user interface design, data flow diagrams, Entity-Relationship (ER) diagrams and process flow modeling.
• Collaborated in identifying Key Performance Indicators (KPIs), Scorecards, Metrics to accurately analyze the needs of clients leading to optimization of the business processes, which eventually led to value creation for the organization and customers.
• Proactively interacted with Business Stakeholders, Subject Matter Experts (SME), Product Owner, Developers to understand the business process flow, workflow, and system flow.
• Experience in applying and conducting business analysis tools like GAP analysis, Risk analysis, Cost benefit analysis, Impact analysis, Change process Management, Feasibility study, SWOT, PESTLE and Porter’s Five Forces analysis
• Extensive years of experience in Business process improvements, Historical data reports analysis and in creating Business Requirements documents (BRD), Functional Requirement document (FRD) Use-Case Specifications, System Requirements Specifications (SRS) and version controlling.
• Expertise in preparing Test cases, Test plans, Test documentation, Test scenarios in different test environments.
• Collaborated in various types of testing such as User Acceptance testing(UAT), Regression testing, Unit testing, System and Integration testing(SIT), Black Box and Smoke testing
• Experience in performing Data Modelling to create Conceptual and Logical model to capture the user requirements.
• Understanding the concepts of Data Warehousing, Data structures, Schemas, Data marts, Data migration from OLTP’s to OLAP using ETL. Worked on Data Migration techniques using Informatica- Power Center.
• Skillful in XML technologies like XML, DTD, XSL, XSLT, SOAP and WSDL.
• Experience using Google Analytics and Open Tracker for deriving key metrics, KPI’s to create actionable insights.
• Proficient in writing complex SQL queries, extracting data from different data sources, generating custom reports.
• Experience working with RDBMS & Data Warehouse projects assisting the Data/SQL Server Developer analyst in preparing and mapping documents and defining ‘end-state’ of data warehouse solutions.
• Assisted the PM in creating Work Break Down (WBS), tracking schedules, budgeting, milestones, evaluating the impact of changes.
• Extensive implementation knowledge of fact-dimensional schemas, OLAP operations such as Roll-up, Drill-down, slice and dice.
• Involved in extensive client interactions and converting business functionalities into Service Oriented Architecture (SOA) models across heterogeneous IT environments and also working in three-tier architecture.
• Skilled as a Scrum Master in facilitating scrum process and ceremonies(Backlog grooming, Sprint planning, Daily Scrum, Sprint Review and Sprint Retrospective) to improve team’s performance and handling team dynamics. Managed the break-down of Epics into User Stories (INVEST format).
• Experience in writing User Stories and managing Requirements Churn in Scrum efficient in performing, prioritizing effective leveraging analyzing techniques like Planning poker, MoSCoW, T-shirt sizing.
• Excellent communication, analytical, business, presentation, management, technical, problem solving and writing skills; eager to learn new technologies; dedicated and self-motivated with the ability to work in a challenging atmosphere and driving the tasks to create business value.

TECHNICAL SKILLS

SDLC METHODOLOGIES: Waterfall, Scrum, Waterfall- Scrum Hybrid, RUP

REQUIREMENT MANAGEMENT: MS Office, JIRA, HP ALM 11.5, Rational Rose

BUSINESS SKILLS: Requirement Churn/Change Management, Risk Analysis, Impact Analysis, SWOT, JAD Sessions, Reporting, Interviewing, Use Case Modeling, Project Planning, Creating Application Prototypes, Analysis and Reporting

MODELING TOOLS: MS Visio, Mock up Screens, Rational Rose, Wireframes, Balsamic

ANALYTICS AND REPORTING TOOLS: MS Excel, Google Analytics, Open Tracker, Tableau, Qlikview, Penteho-BI, IBM Cognos, Spotfire, SPSS, SSRS, SSIS, SSAS

ETL TOOLS: Informatica- PowerCenter

DATA WAREHOUSING: OLTP, OLAP, Data Marts, Data Mining, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll up

DATABASES: MySQL, Oracle 9i, PL-SQL, MS SQL

PROJECT MANAGEMENT TOOLS: MS Project, MS SharePoint, JIRA

MS OFFICE TOOLS: MS Word, MS PowerPoint, MS Excel, MS Visio, MS Project, MS SharePoint

TESTING TOOLS: HP QC, HP ALM 11.5, HP LoadRunner

PROGRAMMING SKILLS: HTML5, CSS3, JavaScript, JQuery, .Net, Java, C, C#

CRM TOOLS: Microsoft Dynamic CRM, Salesforce CRM

OPERATING SYSTEMS: Windows XP, Vista, 7, 8, 10; Linux; Mac-OS

PROFESSIONAL EXPERIENCE

Confidential, Basking Ridge- NJ

Sr. Business Systems Analyst/ Scrum Master

Responsibilities:

• Elicited requirements by conducting JAD sessions, Interviews, Focused Groups and Brainstorming sessions with the Business owner and Application development team.
• Conducted one on one sessions with business users, customers for understanding their ‘AS IS’ system and their needs in the ‘TO BE’ system; understanding what business value these enhancements will add to the company’s product line.
• Created Business Requirement Specification (BRD), Functional Requirement document (FRD), Software Requirement Specification (SRS) for the project.
• Coordinated with Product Owner and Project Development team for setting the release date.
• Proposed new Star schemas integrating all the facts and dimension; modified existing schemas to in corporate new requirements/process changes.
• Designed Use cases, Data flow diagrams, ER-diagrams, Work flow diagrams for better understanding the flow of the data and information within the system.
• Helped the Product Owner to prioritize the Product Backlog items for developing Sprint tasks by taking suggestions from the cross-functional development team.
• Assisted Product Owner in creating User Stories from EPICS using INVEST format through the slicing/dicing techniques.
• As a SCRUM Master, facilitated and time-boxed SCRUM ceremonies (Sprint Planning Meeting, Daily Standups, Sprint Review Meeting, Sprint Retrospective Meeting and Grooming Sessions)
• Resolved the external/internal impediments to shield the SCRUM Development team
• Created and maintained Sprint Burn-down Chart, Sprint Burn-up Chart, Product Release Chart, 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 Potential Shippable Product Increment (PSPI) and help decide which feature are DONE and satisfied using the acceptance criteria.
• Migrated their legacy data by working with the ETL team; from their current set up of data sources i.e. Excel spreadsheets to Data Warehouse using Informatica.
• Implemented Change Data Capture (CDC) to record insert, update, delete activities applied to a table before using those transaction logs to be loaded to target data mart.
• Utilized My SQL to query tables in retrieving the data from various data marts.
• Developed the regression testing for all modules and user acceptance testing for the entire system.
• Generated ad hoc SQL queries using joins, database connections and transformation rules to fetch data from the SQL server database system.
• Ensured architectural alignment with data model management standards and naming conventions.
• Worked with Tableau to create analytic dashboards, custom reports and used R to create the statistical reports for past quarters for the employees of XYZ to better analyze the data and make the business decisions accordingly.
• Extensively involved in developing the test cases as well as test scripts for positive, negative test scenario in accordance with the business needs.

Environment: Waterfall-Scrum Hybrid, Wireframes, MS Office (MS Word, MS Excel, MS PowerPoint), MS Visio, JIRA, Tableau, R, SOA, Mock Up Screens, Regression Testing, User Acceptance Testing, GAP Analysis, My SQL server, MS Dynamic ERP, BI360, HP QC, HP Load Runner, HTML5, CSS3, Java, JavaScript.

Confidential, Phoenix-AZ

Business Systems Analyst/Scrum Master

Responsibilities:

• Liaison with the business community to define business requirements and analyzed technical solutions.
• Elicited requirements using techniques like Job Shadowing, Document Analysis, Interviews.
• Created GAP Analysis, Interface Analysis and Porter’s Five Forces Model to understand the AS- IS model and drive the requirements for the system enhancement.
• Involved in completing the Data Dictionary, Data Lineage and Data Flow Diagrams for the Meta data.
• Created Use Case diagrams, Sequence Diagrams, Activity Diagram to better understand the flow of data in the system.
• Involved in creating Entity-Relationship diagrams for the design of database and designing database schema with the Data Warehouse team.
• Coordinated activities between business unit and technical staff, developing new methods, policies, and procedures to meet the business needs, and acted as primary trainer in education of the business unit as it relates to business applications.
• Drafted the definition of DONE and acceptance criteria for the functional and non- functional requirement specifications.
• Identified the Epics, created user stories out of it using a INVEST format.
• Used JIRA for drafting the user stories, managing the requirements and for project tracking and escalation.
• Proven experience in introducing scrum from sprint ‘0’ and handling spikes accordingly.
• Analyzed all data warehousing components like tool integration strategy; source system data ETL strategy, data staging, and data quality strategy.
• Formulated SQL queries to generate reports from Data Warehouse using Informatica.
• Assisted in increasing the Data Integrity by Data Normalization and adding Validation and Verification
• Assisted QA Team in writing test cases; test plans and tested the final application to verify whether all the User Requirements were catered to by the application
• Performed Data mapping, Data cleansing, Data profiling on different data sources to extract the relevant data and implemented different transformation techniques to convert it into the consistent form using Spotfire tool.
• Used HP QC for designing the Test Cases and Test Plans, and was extensively involved in Black Box Testing, Regression Testing, Smoke Testing and User Acceptance Testing.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
• Assisted the higher managers with credit risk management, potential to default, financial reporting.
• Designed and developed the architecture of business intelligence components including data models, ETL, and enterprise reporting.
• Acted as a liaison between the business users and the project development team and assisted the team in post-production maintenance of the system.

Environment: Waterfall- Scrum, MS Office (MS Word, MS Excel, MS PowerPoint), MS Visio, SOA, Mock Up Screens, Black Box Testing, Smoke Testing, Regression Testing, User Acceptance Testing, GAP Analysis, MS SQL server, Interface Analysis, SISS, SPSS, SSRS, SSAS, ETL, HP QC, JIRA.

Confidential, Houston-TX

Business Systems Analyst

Responsibilities:

• Liaison between stakeholders: system users, clients and managers, software development team and the QA team to gather requirements using techniques like JAD sessions, Document analysis, Interviews.
• Drove one on one interview with heads of education department, managers; collaborated with the end users to determine and understand their requirements for the system.
• Produced GAP analysis to understand the AS-IS model and TO-BE model and what value it will add to the users and business.
• Identified the KPI’s and worked with Business users to define new KPI’s to monitor the health of specific business processes.
• Documented Business Requirement Document after determining the new requests from the Business users; created Functional Requirement Document.
• Translated business requirements into conceptual and logical data models to enable technical dashboard development and better understand the system and database structure.
• Re-engineered the system using Waterfall-Agile Methodology.
• Re-designed complete database structure, performed data migration to reduce data redundancy and duplication.
• Developed UI- mockup screens, produced wireframes, storyboards and prototype to demonstrate the project stakeholders, business users and to give them insights of the TO-BE system.
• Implemented and migrated their system modules into MVC architecture i.e. Cake PHP framework.
• Worked with MySQL to eliminated data redundancies and data duplications.
• Documented and maintained Requirement Traceability Matrix using HP ALM tool to validate that all the requirements have been tested.
• Created test scenarios and plans, facilitated user acceptance testing and tested strategies with developers and testers.

Environment: Waterfall- Agile(hybrid), MS Visio, Gap Analysis- (AS-IS and TO-BE system model), MySQL, MVC architecture, Cake PHP framework, Sublime text editor, Unit testing, User Acceptance testing, Rally, Mock-up screen, MS Office (MS Word, MS Excel, MS PowerPoint), HP ALM, HTML5, CSS3, JQuery, PHP.

Confidential, San Jose-CA

Business Intelligence- Business Analyst

Responsibilities:

• Performed Interviews, Document Analysis, Interface Analysis, Job Shadowing with Business users, SME’s for requirement gathering and refinement.
• Reviewed and analyzed the business requirements document to derive the Functional Specifications Document (FRD), Software Requirement Specification (SRS).
• Assigned tasks among development team monitored and tracked progress of project following Agile methodology.
• Used MS Office suite (Word, Excel, Access, Visio, Power Point, Outlook, Project) for project tracking, documentation, and presentation.
• Developed Use Cases, Data Flow Diagrams, Activity Diagram, State Diagram based on the needs of Business Users.
• Assisted the architects in establishing the logical and physical relationships and schemas of the different data in the data warehouse, using the Data Warehousing concepts and architecture.
• Used ETL tool such as Informatica for handling data manipulation, mapping and loading the data into the data warehouse.
• Formulated SQL Queries to generate relevant reports- sales reports, custom reports from the Data Warehouse using Qlikview.
• Created ad-hoc reports using MS-Excel and Pivot tables to do the calculations.
• Optimized their business process; reporting process and increased the efficiency from 4-5 days to 4-5 mouse clicks.
• Extensively involved in User Acceptance Testing phase to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated.
• Prepared technical documentation such as system architecture, functional, design documents.
• Partnered with the technical areas in the research and resolution of system and process problems.
• Conducted benchmarking activities to identify best practices.

Environment: Agile, Informatica, MS Office (MS Word, MS Excel, MS PowerPoint), MS Visio, Qlikview, User Acceptance testing, MS SQL, MS Project, GAP analysis, ETL, UML, SPSS.

Confidential

Business Analyst/ Salesforce CRM

Responsibilities:

• Extracted and elicited the business requirements like extensive search capabilities, sourcing tools from the business experts and architects, developed FRD.
• Conducted GAP analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation.
• Worked extensively on Salesforce CRM to set up new accounts, manage teams and issue resolution.
• Managed reported change request in Salesforce.
• Conducted feasibility study and performed impact analysis for proposed enhancements.
• Responsible for implementing the key process areas and working with different cross- functional teams.
• Generated Use cases, ER- diagrams using MS Visio to depict process flows, work flows, timelines, cost-benefit models.
• Interacted with development and QA team to ensure overall quality and scalability of the software.
• Managed version control, each version of the application was stored in clear case and necessary modifications, updates and analysis was done.
• Involved in writing business rules to support recommendations for resolving business and technical issues.

Environment: Salesforce CRM, GAP analysis, MS Visio, MS Office (MS Word, MS Excel, MS PowerPoint), My SQL, UML

Confidential

SharePoint Application Developer/ Analyst

Responsibilities:

• Accumulated requirements form various Project Managers, Account executives, Business users using Survey/ Questionnaire, Document Analysis, Interviewing and analyzed the feasibility of the requirements.
• Created the conceptual prototypes to demonstrate the system to the stakeholders.
• Expanded SharePoint technologies and designed the system using their apps and web parts.
• Created Sites, Lists, Document Libraries based on custom site template.
• Customized Master Pages, Page Layout, web pages, Web Pages to improve the SharePoint UI.
• Automated the workflows and business processes within the organization and build a single content management platform.
• Worked with QA team for developing the test cases and test plans for the User Acceptance testing.
• Widely involved in Black Box Testing and System Testing for verifying and validating system.
• Worked closely with the Project Managers of different departments for any change request and helped to do impact analysis.

Environment: SharePoint Designer 2010, VB, HTML, CSS, ASP.NET, MS SQL, Ajax, Black Box Testing, System Testing

Confidential

ASP.NET Developer

Responsibilities:

• Prepared technical documentation such as system architecture, functional, design documents.
• Designed the first workflow i.e. processing the enrollee information from system to the fact table using .NET batch application.
• Designed and implemented the application using C#, ASP.NET, HTML, CSS.
• Used Master Page and User Controls to increase code management and reusability
• Implemented interfaces and classes using Object Oriented Programming (OOP) concepts.
• Followed 3-tiers of application (UI Layer, Business Logic Layer and Data Access Layer), designed and implemented corresponding Layers to provide data flow in the application.
• Used ADO.NETtechnology to access data in SQL Server through its objects (Connection, Command, Parameter, Adapter, Data Reader, Data Set, etc.)
• Implemented the Client-side and Server-side validations.
• Involved in writing program specifications and reviewing unit test cases.

Environment: ASP.NET, C#, HTML, CSS, MySQL, OOP concepts, Visual Studio, ADO.NET