SUMMARY

• Senior business systems analyst/business analyst with over 14 years of experience in the IT industry with in - depth knowledge and experience in various domains such as finance and banking.
• ISI certified scrum master with extensive knowledge, expertise and hands on experience in various software development life cycle methodologies such as Waterfall and Agile(Scrum).
• Proficient in business requirement gathering, process re-engineering, change management, risk management, transaction processing, documenting enhancement requests, business process flow and process modeling.
• Experience in eliciting,documenting business and functional requirements using various techniques such as brainstorming,requirements workshop, joint application development (JAD), job shadowing, interviews, document analysis, survey/questionnaire, reverse engineering, interface analysis and prototyping.
• Skilled in analyzing and documenting artifacts such as business Requirement Document (BRD), Functional Requirement document (FRD), Non-Functional Requirement Document(NFRD)andse case specification.
• Well versed in conducting Feasibility study, GAP analysis, Cost-Benefit and Impact analysis
• Led project meetings with stakeholders, SME, UI/UX team, developers to gather and prioritize requirements.
• Proven track record in conducting gap analysis,risk analysis, ‘AS-IS’ and ‘TO-BE’ system analysis.
• Served as a key liaison between the management, design and development team.
• Skilled at breaking-down an Epic in the Product Backlog into User Stories that abide by the INVEST criteria.
• Expertise in product backlog prioritization techniques (Mo Scow, Business Value, Kano, walking skeleton and Technical Risk) and estimation techniques (Planning Poker, T-shirt sizing and Relative mass evaluation) to assist the product owner in selecting the Product Backlog Items (PBIs) to commit in each sprint.
• Adept in handling requirement churns by evaluating the change request and performed technical and business impact analysis.Experience in mentoring the team and provided business value oriented conflict resolution.
• Seasoned in facilitating the Scrum Ceremonies including daily stand ups, sprint planning, sprint review, sprint retrospective and backlog refinement meeting using various custom techniques for productivity of the sprint.
• Proficient in requirements management, sprint planning, issue tracking, impediment management, and task distribution workflow management tools like Rally,JIRA, HP ALM and Version One to track the sprint progress.
• Expertise in preparation of Unified Modeling Language(UML) diagrams such as Activity Chart, Use Case, Process, Sequence, Data Flow and ER Diagram using Rational Rose, SharePoint designer and MS Vision.
• Developed and maintained requirement traceability matrix (RTM)to verify adherence.
• Worked on service oriented architecture (SOA), REST, SOAP, XML, API.
• In-depth knowledge of concepts such as data warehousing, data structures, sachems and dimensional modeling.
• Skilled in OLAP operations such as roll-up, drill-down, pivot, slicing and dicing based on reporting requirements.
• Proficient at generating data mapping artifact and identifying transformations to cleanse and improve Data Quality.
• Designed and developed prototypes UI screens, wire frames and mock-up screens to perceive and visualize the graphical user interface (GUI) using various tools such as Balsam, Mock ups and Mock up Screens.
• Developed test cases, test plans, test scripts, procedures and documented defects using HP QC and HP ALM.
• Experience in functional testing, regression testing, integration testing, performance testing and actively involved in conducting user acceptance testing and production verification testing and documenting any defects.
• Skilled in OLAP operations such as roll-up, drill-down, pivot, slicing and dicing based on reporting requirements
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) to ensure data integrity and timely reporting.
• Knowledge of Business Intelligence tools and created interactive, analytical dashboards,master detail, drill down, using Tableau and IBM Micro strategy.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile Scrum.

Project Management/ Collaboration tools: JIRA, Rally, MS SharePoint, MS Project,MS Office Suite, HP ALM, Version One, Unified Modelling Language (UML 2.0).

Graphical and Modeling Tools: MS Vision, SharePoint Designer, Balsam, Wire frames, Mock-up screens

Testing Tools: HP QC, HP ALM, HP QFT, HP Load Runner, SOAP UI, Oracle Application Testing Suite (OATS), Selenium.

ETL and Business Intelligence Tools: Informant Power Centre,Spot fire,IBM Micro strategy.

Languages: SQL, HTML, XML.

Databases: SQL Server 2000,2008 R2, Oracle 9i, Oracle 10g,11g,12c,MS-Access, MySQL.

Data Warehousing: Data Modelling, Data Marts, OLAP, OLTP

Business Skills: Process Modeling, Change Management, feasibility study, JAD Sessions, Project Scheduling, GAP, Impact, SWOT, Risk and Cost-Benefit Analysis.

Operating Systems: Windows XP, 7-10, Mac OS, Linux

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. Business Analyst

Responsibilities:

• Led the project from inception through to deployment by establishing and adhering to time boxed project plans, proactively identifying and resolving risks, and regularly communicating progress against defined milestones.
• Conducted GAP and SWOT analysis by identifying AS-IS and TO-BE business process models and process flows.
• Collaborated with SME ’s and Stakeholders to elicit and analyze requirements for prioritization.
• Conducted questionnaires and facilitated JAD Sessions with business users, developers, and database design team to deal with back end synchronization problems accompanied with interviews and document analysis.
• Designed prototype Mock UI screens for each template of Web/Mobile application using Balsamiq Mock ups.
• Worked in close conjunction with the architecture team to design the Conceptual and Logical Model of the system.
• Created Use Case diagrams, Activity Flow diagrams and Business Process Flow diagrams in Microsoft Vision.
• Assisted in drafting the Artifacts by collaborating with technical teams and stakeholders.
• Worked with the product owner and development team in deciding and negotiating the definition of done and acceptance criteria for Potentially Ship able Product Increment (PSPI).
• Participated in scrum ceremonies, such as sprint planning, daily scrum meetings, sprint review, sprint retrospective and backlog refinement with cross functional scrum development team.
• Assisted the Product Owner in prioritizing the product backlog in the backlog grooming meeting using various prioritization techniques such as Moscow, Kano Analysis, Walking Skeleton and Business Value.
• Coordinated and communicated with Scrum Masters to relegate dependencies during the sprint.
• Tracked the progress of project using Rally. Knowledge service oriented architecture (SOA), REST, SOAP, XML.
• Assisted in removal of impediments and monitoring defect logs, which in turn assist in velocity and capacity calculation for superior planning of upcoming sprints.
• Responsible for decomposing EPICS into manageable user stories by applying the INVEST criteria.
• Used MS Office extensively (Word, Excel, Access, PowerPoint, Outlook, Project) for calculations, graphs, analysis, presentation and documentation throughout the project.
• Worked with the UI team verifying the completeness of client side validations by developing exhaustive test cases and test scenarios and assisted in the automation of the UI testing process using tools like Selendroid and HP QTP.
• Created and maintained the Requirement Traceability Matrix (RTM) throughout the project execution.
• Responsible for business and functional requirements in the test strategy and participated extensively in User Acceptance Testing at the client environment. Also, involved in Regression Testing, Black box Testing.

Environment: Scrum methodology, Rally, JIRA,MS Office Tools(Word, Excel, PowerPoint), MS Visio, MS Project, JIRA,Mock-Up Screen, MS SQL Server, SharePoint,UML.

Confidential, New York

Business System Analyst

Responsibilities:

• Studied and understood the state of art processes by interacting with stakeholders and in-depth documents analysis, also performed GAP analysis Project Manager in planning the transition.
• Worked closely with business groups to gather requirements, define business strategy, create a centralized reporting capability for users to perform analytical reports.
• Facilitated JAD sessions and questionnaires as moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
• Prepared business requirement document (BRD) and assisted in preparing system requirement specification (SRS).
• Performed a SWOT analysis of business rules, business and system process flows, user administration and business requirements, mapping the requirements to the new system and thoroughly documenting the same in the BRD.
• Assisted the business intelligence team in providing the insights on types of reports to be extracted.
• Identified the attributes that were vital based on the reporting requirements and ensured they were available.
• Worked on gathering requirements for different Relational Database Management systems(RDBMS) in extracting the data into staging area and populating them onto Data Warehouse
• Assisted and worked with ETL developers and data modelers to make sure the model being developed is according to the business requirements
• Developed Conceptual and Logical ER diagrams identifying the entities, constraints,relationships and carnality.
• Responsible for Creation of Use Cases and developed Use Case Diagram and Activity Diagram using MS Vision.
• Prepared and maintained Data Dictionary, Meta Data Registry and Data Mapping Document for the data models.
• Ensured Data Integrity using various techniques such as performing Data Normalization, Data Validation and Data Validity to enforce accuracy and effectiveness of data.
• Assisted BI developers in creating various types of reports/sub-reports and drill down like standard and cross tab-reports with bar chart, pie chart and line-chart graph representation reports using Micro strategy
• Worked in Micro strategy report studio in extracting reports using filters and framework manager in creating data models
• Worked in dimensional modeling process such as star schema and snow-flake schema.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries on MS SQL Server. Also, used JOINS and nested queries to export data from the database.
• Managed and tracked requirements of the Application Life-Cycle using HP ALM.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing
• Handled change requests by performing impact analysis on the business and technology fronts and submitted it for approval from the change control board (CCB).
• Served as a key liaison between the management, design and development team and assisted the project manager in project tracking and completing tasks according to the project charter.

Environment: Waterfall methodology, MS Office, Micro strategy (report studio, Framework manager, Analysis studio), Informatica Power Center, MS Visio, MS Project, HP ALM, Wire frames, Mock-Up Screens, MS SQL Server, UML, ETL.

Confidential, New York

Business System Analyst

Responsibilities:

• Worked to ensure that business process outcomes were in harmony with strategic goals and worked to help improve the management of a business process.
• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.
• Assisted in drafting the Business Requirement Document and Functional Requirement Document by collaborating with technical teams and stakeholders.
• Facilitated JAD sessions, Questionnaires, Document analysis and Interviews with the stakeholders for the requirements elicitation and documented Business Requirement Document(BRD) and Functional Requirement Document(FRD).
• Created high fidelity mock up diagrams to understand the work flow in user interfaces.
• Created and maintained Use Case documents based on the system’s requirements explained the business process flows and created detailed diagrams such as Use Case diagrams, Data Flow diagrams (DFD’s), Activity diagrams, Sequence diagrams, Entity Relationship (ER) diagrams and Work flow diagrams using MS Visio.
• Proposed and developed a Business Glossary to unify the definition of key attributes in the organization.
• Proficient at generating data mapping artifact and identifying transformations to cleanse and improve Data Quality
• Used Business Process Management Notation (BPMN) for managing and improving the business process efficiency.
• Created ER Diagrams for one-to-one and one-to-many mapping relationships using SQL Server.
• Performed various SQL query operations such as DML and DDL commands and was responsible for supervising the source to target mappings in Informatica Power Center. Responsible for performing Data Profiling and Data Mapping
• Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects and collaborated with system users to conduct the user acceptance test.
• Assisted the ETL team in integrating various OLTP to the OLAP by using Informatica and Tableaufor reporting.
• Prepared and maintained Data Dictionary, Meta Data Registry and Data Mapping Document for the data models and also responsible for performing Data Profiling and Data Mapping.
• Facilitated the team in performing ETL operations to load the data into data marts using informatica power center
• Worked in dimensional modeling process such as star schema and snow-flake schema
• Performed SQL queries using joins and nested queries to fetch data from MS SQL Server.
• Prepared and maintained the Requirement Traceability Matrix (RTM) and Monitored performance testing results for several modules within the application.
• Performed Risk Management in the project by maintaining a risk register to identify and mitigate risks in the project development process.

Environment: Waterfall, MS Visio, MS Project, MS officeTools,UML 2.0, HP ALM, Informatica Power center, Tableau, HTML5, CSS, Balsamiq, Selenium,Data Mapping, Data Transformation, SOAP, XML.

Confidential, New York

Business Analyst

Responsibilities:

• Participated in the system development process life-cycle from concept through testing, implementation, and support.
• Developed and introduces new features and capabilities in CRM application by analyzing information needs and functional requirements to deliver needed artifacts such as Business Requirement Document(BRD), Functional Requirement Document(FRD) and Use Case Document.
• Created activity and sequence flow diagrams for the better understanding of the process
• Interacted with stakeholders and gathered requirements from the business and collected overall system requirement through JAD sessions and Interviews.
• Implemented security configurations, customization and integration for profiles, OWDs.
• Coordinated with the offshore development team on the progression and development of the requirements
• Facilitated with data engineers to conduct data validation and mapping from existing systems into data ETL systems to integrate data to the CRM object and business models.
• Administered and configured profile and role hierarchy and created workflows to adhere to user requirements resulting in enhanced customization.
• Analyzed the defects in UAT and production and categorize, Prioritize them and then assign it to the right resource for fixing the defect
• Pioneered the company’sCRM software training program, curriculum and materials production. Facilitated training for the junior staff on producing critical management sales performance insights.

Environment: Waterfall, Windows 7/8, Microsoft Office Suite, Microsoft Visio, SharePoint, Salesforce CRM, UML.