SUMMARY

• Over 8+ years of experience in requirement gathering, analysis, development, testing, implementation and deployment phase involved in software and systems design process.
• Possess a deep understanding of challenges faced by start - ups and constant pressure in big organizations.
• Possess excellent verbal & written communication and interpersonal skills required for client interactions to define scope and status reporting.
• Strong involvement in requirement gathering/analysis and peripheral involvement in succeeding phases.
• Well versed in administrative activities including software installation & update, configuration management, defect logs management and application deployment, update & testing.
• Proficiently played the role of an “Agent of Change” and gauged the change impact on existing and planned operations; leveraged “parking lot” concept from going astray during SDLC process.
• Expert at decomposing abstract and unambiguous data into relevant and systematic relationships required in order to support data intelligence team’s reporting systems.
• Played a scrum master by acting as a servant leader and not letting difference in opinions and impediments become a catalyst of conflict.
• Possess experience working in agile, sequential and hybrid SDLC methodologies, including Scrum for high-risk and iterative software requirement and Waterfall & Hybrid for a low-risk and planned requirement.
• Experienced in elicitation techniques such as JAD sessions, surveys, interviews, observation, focus groups, job shadowing, prototyping, scenario planning, mind mapping, etc.
• Experienced in conducting Gap Analysis and creating As-Is/ To-Be process models, identifying pain points.
• Adept at creating mock-up screens, wireframes and prototyping static and dynamic UI with HTML4, Mockup Screens, Balsamiq, MS Visio, Lucid Charts.
• Efficiently captured, traced and analyzed requirements using Rational Requisite Pro and ClearQuest to validate adherence as per Requirement Traceability Matrix (RTM).
• Well acquainted with workflows and Unified Modeling Language (UML) diagrams, Use Cases, Activity charts, Sequence diagrams and Data flow diagrams (DFDs) using Rational Rose, MS Visio.
• Skilled in creating Business Requirement Document (BRD), System Requirements Specification (SRS), Functional Requirements Document (FRD), Technical Requirements Document (TRD), Business Continuity Plan (BCP) and Behavior Driven Development (BDD) & Test Driven Development (TDD) ancillary documents.
• Experienced working with database designers in grouping data to avoid any anomalies, data redundancy and spurious relations in data management.
• Experienced in CRM Customization & Administrationtasks like Manage Users, Set up Company Profile, Security Controls, Communication Templates, Translation Workbench, Data Management, Outlook Configurations, Chatter Desktop Settings and Email Administration.
• Comprehensive knowledge of OLTP, OLAP, Bill Inmon’s Top Down, Ralph Kimball’s Bottom-Up concepts as well as Normalization and Denormalization in a Relational database management system (RDBMS).
• Well versed with RUP, Scrum of Scrum and Kanban methodologies
• Experience using project management tools: Spreadsheets, MS Project, Keynote, PowerPoint, and Shared online collaboration tools such as Box.com, Dropbox, Google docs, Slack, SharePoint.
• Well versed with Customer Portal, Partner Portal, Creating Custom Apps, Objects, Report Types, Creating Workflows and Approvals, Apex Classes, Triggers.
• Possess a good understanding of schemas, facts grains, slow changing dimensions,attributes, entities, primary keys, foreign keys etc. required to create Fact Tables and Dimensions to extract meaningful data.
• Knowledgeable about XML parsers and SQL Queries for data manipulation.
• Proficiently conducted Cost Benefit Analysis (CBA), Critical Path Analysis, Earned Value Management (EVA) and maintained Gantt Charts, Burn Down/Up Charts.
• Expert at Scrum methodologies such as coaching teams to prioritize and estimate user stories using Moscow & Planning Poker techniques and defining acceptance criteria as a collaborative exercise at the start of iterations along with the scrum team.
• Skillfully used Fishbone Diagrams for cause & effect analysis to discover root problem and bottlenecks.
• Has an experience in breaking down EPICS into user stories, and conducting events called SPIKE.
• Involved in Behavior, Test & Automated Test-driven development (BDD, TDD & ATDD) as well as Blackbox, Functionality, System, Integration, Regression, Load/Stress, Performance, Smoke, Sanity and User Acceptance Testing (UAT).
• Worked with testing team on HP quality center/HPALM, Rally, Version One, Cucumber, FitNesse and on add ons: Bonfire, Snagit, and Usersnap to manage bugs.
• Extensively used DocuSign for electronic signature, Lync & GoToMeeting for web conferencing, SmartSheet, Jira, other SaaS tools for Project Collaboration.

TECHNICAL SKILLS

Modeling Tools: Rational Rose, Balsamiq, MS Visio, Mockup Screens

SDLC Methodologies: Waterfall, Waterfall-Scrum Hybrid, Agile-Scrum

Business Skills: SWOT, PESTLE, Change Management, Risk Management, Business & Technical Impact Analysis, Cost-Benefit Analysis

Requirement Management: MS Office, JIRA, HP ALM 11.5, Rational ClearQuest, Rally

Project Management Tools: MS Project, MS SharePoint, Clarity PPM, SmartSheet, Google Docs, Dropbox, Keynote, Slack, DocuSign, GoToMeeting, WebEx

Testing Tools: HP QC v10.0, HP ALM V11.5, Load Runner

ETL Tools: Informatica, Data Stage, SSIS, Business Objects

Reporting tools: Tableau Desktop, IBM Cognos v10, MS Office Suite, Spotfire, MS SSRS, Oracle BI Publisher

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up

Databases: MYSQL, Microsoft SQL (T-SQL), Oracle 9i and 10g (PL/SQL)

Miscellaneous: Java, Apache Tomcat, JavaScript/jQuery, Eclipse, Hibernate Spring, .Net, Asp.Net, Internet Information Server (IIS), MS Visual Studio, Angluar JS, Ajax, Team Foundation Server (TFS), MS SQL Server, SSIS, SSRS, SSAS

PROFESSIONAL EXPERIENCE

Confidential - Akron, OH

Sr. Business Analyst/ Scrum Master

Responsibilities:

• Performed a thorough analysis of existing documents on business processes, business rules, memos, customer feedbacks, company’s organizational structure and existing system’s functional specifications.
• Conducted Gap Analysis to identify the delta between As-Is and To-Be process models, followed by risk analysis through SWOT, PESTLE, Value Stream Mapping, Feasibility and Impact Analysis.
• Used active, passive and explanatory observations and JAD sessions to gather requirements and devise a plan of action (POA) in accordance with agile principals.
• Documented BRD, FRD and SRS artifacts by taking into consideration the inputs and outputs of each project phase, version, stakeholders grid, business objectives, scope, actors, limitations, assumptions, business rules catalog, desired functionalities, probable risks, technologies involved, relevant links and a glossary.
• Played the role of a scrum master to halp decompose the scope from the BRD into INVEST able user stories and SMART tasks by scheduling time-boxed ceremonies with the product owner and the development team
• Prioritized user stories using MoSCoW and facilitated user story points’ estimation using Planning Poker.
• Removed team’s impediments assessed their Scrum maturity and coached them to maintain the velocity.
• Assisted Project Manager with Proposal drafts, Budget Allocations, Project Charter, Earned Value Management (EVM) & Work-Breakdown Structures (WBS).
• Supported the Product Owner with respect to grooming and managing the product backlog.
• Empowered project members in clearly defining roles and resolving overlaps by using RASCI matrix.
• Partnered with teams to deliver a reporting platform to investigate out-of-stock, overstock and projections.
• Assisted the technical team establish a foundation for web services using ASP.net as the scripting language, XML for data description in Simple Object Access Protocol (SOAP).
• Defined test plans and associated test case scenarios to ensure all acceptance criterions had been met.
• Assisted Test Lead to halp avoid any technical debt accumulation and in conducting UAT and Beta Testing.
• Ensured acceptance criteria and considered DONE before Demo during sprint review meeting.
• Did extensive analysis on reference & market data by generating ad hoc SQL queries using joins, database connections and transformation rules to fetch data from the SQL Serverdatabase systems.
• Worked on CRM tool with standard objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Forecasts, Activities, and Dashboards & Reports, which halped avoid Bullwhip effect.
• Developed conceptual & logical ER diagrams using Lucidchart, maintained a Data Dictionary, used MS Visio for Business Process Modeling and assisted in simplifying complex information and bridging gap between strategic planning & operational execution.
• Involved in building data marts by reorganizing OLTP into OLAP in multidimensional cubes.
• Used Burn-Down/Burn-Up Charts to ensure iterative & incremental development in the form of PSPIs.

ENVIRONMENT: Waterfall Scrum Hybrid SDLC, Wireframe, Balsamiq, SQL Server 2012, MySQL, ASP.net, XML, Web Services, SOA, SOAP UI, HTML 5, SSRS, SSIS, SSA, IIS7, MS Excel, MS Word, MS Visio, MS SharePoint 2013, Team Foundation Server 2013, Jira, HP ALM, Lucid Chart, EDI, Slack, Google Docs, GoToMeeting

Confidential - Houston, TX

Sr. Systems Business Analyst

Responsibilities:

• Interacted with users and internal/external stakeholders to identify business needs and evaluate solutions.
• Used open/close-ended questions, research, Job shadowing and Joint Application Development (JAD) followed by Joint Requirement Planning (JRP) with Subject Matter Experts (SMEs) to elicit requirements.
• Worked on the Risk Management Plan (RMP) with the Project Manager through risk identification, analysis, planning, tracking and escalation and maintained risk management log (RML) by updating risk impact, probability, exposure, severity, timeframe and priority.
• Worked with Design, Development and Implementation (DD&I) Team to develop user manual processes.
• Helped create Class Responsibility Collaborator (CRC) Cards on scenarios outlining system requirements by hosting brainstorming sessions with Business Domain Experts (BDEs).
• Successfully migrated project documentation and project progress tracking systems to the SharePoint collaboration site for quicker and easier project monitoring and controlling.
• Identified critical path activities, dependencies, timeframes, responsible parties and deliverables for phases.
• Assisted the project manager with monitoring of triple constraints.
• Arranged bi-weekly project team meetings with Change Control Board (CCB) consisting of Project Business Sponsors, Project Manager, Director and IT Lead to discuss any requirement change and reduce the possibility of business & technical scope creep.
• Conducted weekly team lead meetings to discuss the project schedule and to identify technically sound improvements having high benefit-to-cost ratios to enhance overall business performance.
• Worked in adherence with the Project Management Methodology (PMM) and state approved policies
• Involved in the development of Snowflake schemas used for dimensional modeling by architects to support fact tables with different levels of granularity using INFORMATICA.
• Documented business rules and workflows using Business Process Modeling Notation (BPMN) Version 2.0 and created models using Rational Rose and MS Visio.
• Assisted the Project Manager in setting realistic project expectations, and established Incident Reporting and Change Control procedures using Clear Quest.
• Built SQL queries to retrieve data from data warehouse to verify the integrity of data and developed Test Plans along with the testing team to ensure testability, reliability, usability and performance.
• Documented User Acceptance Testing (UAT) plan and assisted in test scripts to resolve defects.
• Performed lookups, parse, worksheet formatting, pivot tables, charts and graphs in Excel.
• Created Mock-Up Screens and Wireframes using UI components such as Radio Buttons, Data-Entry Fields, Check Boxes, Drop-Down lists to create prototypes.
• Created Deployment Flowchart in conjunction with the development, infrastructure, and network teams containing instructions for maintaining the application.
• Maintained a record of relationships built, technologies used and problems faced during the project.

ENVIRONMENT: Waterfall SDLC, MS Office, MS Visio, MS SharePoint 2010, MS Project, Oracle DB, Web Services, SOAP, HTML, XML, AJAX, Java Script, Java Hibernate, IBM Cognos, Rational Rose, SQL, Informatica, HP ALM, SQL, Eclipse.

Confidential - Framingham, MA

Jr. Project Manager

Responsibilities:

• Performed cost benefit analyses (CBA) to compare the cost of in-house development versus procurement of an off-the-shelf solution to validate the feasibility of the concept proposal before initiating the planning and requirement gathering phase.
• Identified peaks and valley points of the project workflow in advance to bring forth the opportunity to catch-up and reprioritize user stories accordingly.
• Played a Scrum Master to facilitate Sprint Planning, Daily Scrum, and Backlog Refinement & Sprint Review.
• Played a servant leader to resolve organizational, managerial, operational and process impediments, thereby maintaining the pace of team’s predicted velocity.
• Used FURPS+ model (Functionality, Usability, Reliability, Performance, and Supportability) to classify software’s functional and non-functional attributes.
• Used CRUD (Create, Read, Update and Delete) and decomposition of external/ temporal/ state events as techniques to validate, analyze and better understand data flows between different systems.
• Elicited requirements to document BRDs and FRDs, which halped drive a logical decision-making process and track open issues, thereby reducing the amount of time spent rehashing previous discussions leading to requirement churn.
• Maintained healthy dynamics amongst a cross-functional and self-organizing team by resolving conflicts through arbitration, negotiation and reasoned discussions.
• Defined the UI with inputs from the data architect and developers for system using mockup screens.
• Managed GUI Context Testing, Functional Testing, Regression Testing, Integration Testing, User Acceptance Testing, Stress Testing, Performance Testing and Negative Testing along-with the QA team.
• Utilized SharePoint as an administrator for document management, version control and team dashboards.
• Assisted in client/server side validation and writing verbiage for validation using Java Script & Ajax.
• Used JIRA to maintain an internal voting system and an access to information on brainstorming results, account management, tasks’ progress and quality control.
• Assisted technical team in developing business logics for the web - based application-programming interface (API) using SOAP in reviewing XML documents for Web Service and Data mapping.

ENVIRONMENT: Waterfall & Scrum Hybrid SDLC, Web Services, SOAP, HTML, XML, AJAX, Mock-Up Screens, SharePoint, Oracle DB, JavaScript, Java Hibernate, JIRA, MS Office, Cognos, Informatica, Eclipse, Clarity PPM.

Confidential

Business Analyst

Responsibilities:

• Assisted the project manager to develop the project plan including scope, schedules, resource allowances and baseline management plan.
• Worked with the grape growing, wine producing, distribution and packaging team autonomously to assess any specific policy and systems guidelines.
• Gathered and integrated requirements using formal & informal brainstorming discussions, closed & open interviews and virtual & in-person feedback sessions with focus groups.
• Used mind-mapping tools to prototype ideas using “What-If” scenarios and to park the unsuitable ones.
• Maintained a separate requirements traceability matrix for each working group in the supply chain.
• Played an integral role in controlling all changes through a formalized change request procedure, conducting a thorough business and technical impact analysis, including impact on service level agreements (SLAs) and in discussing the repercussions with the Change Control Board (CCB).
• Created process flows using UML Diagrams, Sequence Diagrams, Flowcharts and Use Case Diagrams.
• Conducted gap analysis between existing and proposed business functionalities to identify inadequacies.
• Developed and administered a measurable system and user acceptance test plans dat accurately checked system functionalities and operational readiness.
• Arranged bi-weekly meetings within the projectized organization to maintain a healthy and a balanced matrix work environment open to constructive criticism.
• Worked with the project manager in estimating best/worst case scenarios and tracking progress with weekly estimates of remaining work by conducting informal and ad hoc meetings.
• Trained new team members, drafted Standard Operating Procedures (SOPs) and worked in collaboration with the Architecture and Development teams to improve existing business procedures.
• Analyzed Inbound/Outbound communication, ERP/legacy files and database-to-database movement files.

ENVIRONMENT: Waterfall SDLC, MS Visio, MS Office, MS Project, Rational Rose, JIRA, Web Services, SOA, SOAP, XML, SQL Server, MySQL, ASP.Net, SSRS, SSIS.

Confidential

Business Analyst/ Sr. Merchandising Manager

Responsibilities:

• Gathered requirements through interviews and video conferencing with stakeholders across continents.
• Analyzed competitors’ sites to provide the right product assortment with competitive pricing & high margins, implemented strategies and effective visual merchandising to increase gross profit/unique visitor.
• Conducted an in-depth research on populare-commercefunctionalities desired by the business owners and provided insight to the management on a regular basis on key performance indicators (KPIs) by analyzing traffic sources, using Google analytics and researching customer feedbacks, product ratings and responses.
• Created Project management plan and Work breakdown structure (WBS) with timelines for managing on-time delivery usingMS Project.
• Generated initial use-case diagrams using UML in Rational Requisite, prepared mock-ups for several kinds of configuration use cases and created an intuitive UI for the website, with an aim to enable “seamless user experience with minimal lead time”.
• Monitored keywords and suggested ways for an effective content for search engine optimization (SEO).
• Created and tracked thetraceability matrixfrom conception of requirements to implementation phase.
• Involved in gathering data from multiple sources and building a central repository of historic data warehouse for analytical purposes.
• Developed detailed and summary reports including line/pie charts, trend analysis reports and sub-reports as per business requirements using SQL Server Reporting Services (SSRS).
• Worked oneasy-to-use online catalogandorder management including shipping and payment options.
• Tracked ongoing design work using the SharePoint web user interface, workflow creation and maintenance, web content management, navigation and taxonomy.
• Prepared performance reports by analyzing the data related tostore visits, product views, Gross Profit/Unique Visitor (GP/UV) and other important consumer behavior variables.
• Generated daily, weekly and summary reports for event performance, including Advertised vs. non-advertised sales, Power Hours, BOGO and other themed events and deals.

ENVIRONMENT: Waterfall SDLC, MS Office, MS Project, Google Analytics, Web Services, Rational Requisite, SQL DB, SSRS, SSIS, Skype.

Confidential

Jr. Business Analyst

Responsibilities:

• Supported software development with support documents for each phase Responsible for continuous process improvements deployable throughout the enterprise using Waterfall Methodology with support documentation for each SDLC phase.
• Frequently used SQL with stored procedures, complex queries and complex user defined functions.
• Determinedfunctional and non-functional requirements of the business and halped create vision and scope documents; business process models, use case diagrams, activity diagramsandstate chart diagram.
• Organized requirements into high level Use Cases and low level Use Case Specifications and modeled them into Use Cases Activity using MS Visio.
• Created and maintained relevant documentation Standard Operating Procedures (SOPs) to support business continuity of reporting and involved in SWOT analysisof project plan.
• Documented existing system’s processes to use as baseline documents against proposed implementation.
• Created Reports using different views (Pivot Table, Drill Downs, Drill Ups, Charts, Column Selector).
• Developed project document templates based on SDLC methodology.
• Conducted UAT as one of the most critical software development procedure before rolling out the features.
• Defined quality attributes, external interfaces, constraints, and other nonfunctional requirements and represented requirements using alternative views, analysis models (diagrams), prototypes, or scenario.

ENVIRONMENT: Waterfall SDLC, HP QC, MS Office Suite, MS Visio, Rally, Microsoft Suite, IBM Cognos, Oracle 9I