SUMMARY:

• Over 9 years’ of experience as Sr. Business Analyst with extensive understanding of business products, operations and Information Technology on the Federal Projects, Health Care Services, Banking and Retail & e - commerce Industry.
• 8+ years of experience in UX/UI & Interaction Design, and Prototyping.
• In depth Knowledge of Software Development Life Cycle (SDLC) methodologies like Rational Unified Process (RUP), Agile/Scrum Techniques and Water fall methodologies.
• Proficient in using Agile Scrum methodologies , following sprint/stand-up-sessions and used Excel extensively to write user stories, analyzed the Iteration Burn Down charts and reviewed defects.
• Accomplishments in analysis of large-scale business systems, Project Charters, Business Requirement Documents, Business Overview Documents, Authoring Narrative Use Cases, Functional Specifications, and Technical Specifications, data warehousing, reporting and testing plans.
• Organized Joint Application Developments (JAD) sessions, Kickoffs, Ad-hoc meetings, walkthrough, Interviews, Workshops sessions with end-user/clients/stake holders and IT group.
• Expertise in creating UML based Modeling views like Activity/ Use Case/Data Flow/ Business Flow /Navigational Flow and/or Wire Frame diagrams using Rational Products & MS Visio.
• Facilitated change management across entire process from project conceptualization to testing through project delivery, Software Development & Implementation Management in diverse business & technical environments, with demonstrated leadership abilities.
• Expertise in creating Business Requirement Documents (BRD), Business Requirements List (BRL), System Requirement Specifications (SRS) and Functional Specification Documents (FSD).
• Deep understanding of Database management system and Data warehousing concepts
• Extensive experience with databases like Oracle, Teradata, SQL Server, DB2, and MS Access.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Cognos, Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Experience in Maintaining & updating all artifacts in SharePoint 2013.
• Experience in writing Test Plan, Test Cases, Test Scenarios working on Automation testing UFT (QTP) and Application Lifecycle Management ALM (HP QC) and Setting up testing environment in conjunction with the Testing team.
• Proficient in performing Gap Analysis, by evaluating the key differences between the as-Is and the To-Be system and identifying the key requirements for system reengineering.

TECHNICAL SKILLS:

Business Modeling: MS Visio, Word, Excel, Outlook, Project

Methodologies: Waterfall, RAD, Iterative, RUP, Agile, Business Modeling.

Configuration Tools: Rational Clear Case, Rational Clear Quest, Rational Rose, Pro-Requisite, UML, DB2, IBM AS400, DOORS

Data warehousing Tools: Informatica, Data Stage, Business Objects, Cognos, Erwin, TOAD, Qlikview.

Project Management: Microsoft Project Plan, Microsoft PowerPoint, MS Excel

Web Technology: Html, XML, Dreamweaver, UI/UX

RDBMS: Oracle, MS Access, and SQL Server.

Operating Systems: UNIX, Windows 95/98/NT/2000/XP/Vista, Windows server 2003

ECM: Microsoft SharePoint 2013

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. Business Analyst

Responsibilities:

• Documented business requirement document (BRD), Scope Matrix, Functional Requirements Specification, Design wire frame, data mapping/Transformations from source to target (STTM), business process flows. Performed Data gap analysis against critical requirements.
• Prepared data distribution strategy documents to deliver data from new source and replaced the legacy system, within the established SLAs between the program and various stakeholders.
• Expert in Business Process Modeling (BPM), Created Use Cases, activity and sequence diagrams.
• Participated in Production release and conducted UAT and Regressions testing to ensure stability of the website.
• Conducted weekly SCRUM to discuss about the progress of the project.
• Developed Wireframe prototypes and presented during refinement of PBIs.
• Established UI and UX requirement documents, interaction modeling using UML diagrams and workflows to gather the requirements to build specific screens.
• Prepared High Level Design documents (HLD) and the Process Flow Diagrams (PFD) to load, process and distribute data sets.
• Played active role communicating with the back end - “database” team and front end - “web” team for resolving the production issues.
• Assisted the project manager with sprint planning and story maintenance using Agile JIRA board.
• Created mock-up reports via reporting requirements for the clients and performance reporting.
• Prepared Test Plan document, which included test data and test scenarios and test results.
• Document all the steps throughout the testing of the business requirements
• Captured action items during the JAD sessions and assigned them appropriately to the business groups
• Identified and tracked changes to scope of the project through change management process using Microsoft SharePoint 2013.
• Prepared RTM ensuring the forward and backward traceability of the Business Requirements to the test Case and vice versa

Environment: Cognos 10.2.2 ( Framework Manager, Report Studio, Analysis Studio, Transformer, Dynamic Cubes), CADIS / Markit, SQL Server Management studio, SharePoint 2013, ALM, UFT, Office Clip, MS Visio, MS Office.

Confidential, Richmond, VA

Sr. Business System Analyst

Responsibilities:

• Interviewed SMEs, clients from different business lines to gather information, understand the user’s needs, define requirements, and develop requirement specifications.
• Organized Joint Application Development (JAD) meetings with the domain and technology specialist to collect, validate, define, and conclude user requirements.
• Prepared UAT test scenarios based on use-cases and low and high level design documents
• Conducted detailed study of existing database and worked out a detailed migration plan for transforming disintegrated databases from multiple platforms into a single integrated data source.
• Communicated with the User Experience (UX) team and the Development team to capture the data from Microsoft Dynamics CRM and interface with the various MMS.
• Conduct workshops with various business and IT resources and SME’s to identify the reportable data.
• Designed UI & UX screens for Citizen Portal, common landing page for all agencies applications, business process flow, and validations at UI, service layer and rules engine levels.
• Identified and reported on trends and metrics using Excel, Business Objects, and SQL queries.
• Prepare meeting minutes for all working sessions and create and update the Functional Requirements Document (FRD) with storyboards, designed wireframes and Data Mapping Specifications, Source to Target Mapping Documents.
• Worked with DOORS for requirements management and to create Requirements Traceability Matrix (RTM).
• Create testing defect reports in Application Lifecycle Management (ALM) and track them to resolution.
• Assist Project Manager in creating and updating the project plans. Created HTML Mockups, and Interactive prototypes.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat.
• Monitored and assisted in designing and development of Use Cases, Workflow diagrams, Activity Diagrams, and Sequence Diagrams using UML Prepared Business Process Models that includes modelling of all the activities of the business from the conceptual to procedural level.
• Perform Data Mapping and Data Analysis and Data Profiling. Used Advanced Query Tools like DbVisualiser for extracting data for analysis and reporting.
• SharePoint 2010 for managing artifacts, version changes, MOM’s, Flowcharts, Activity Diagrams, Use Case Diagrams.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Develop concept diagram for the projects using UML in MS Visio.

Environment: UAT, GAD (Gap Analysis Document), SharePoint, MS Visio, SQL, ALM, ITIL, HTML, Windows, Rational Requisite Pro, Clear Case, Clear Quest, Mercury Test Director Oracle.

Confidential, Philadelphia, PA

Business Analyst

Responsibilities:

• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Eligibility, Enrollment and Claims.
• Managed all the requirements in repository (SharePoint), making requirements available to all team members. Used share point portal for deploying the Cognos reports for end user access.
• Gathered Business Requirements including storyboards, Interacted with the Users, Designers and Developers, & Project Manager to get a better understanding of the Business Processes.
• Assisted the design team to create the User Interface screens, prototype for the website based on the business requirements.
• Created test scenarios based on Use Cases and other multiple sources like process maps, UI & UX Design to enhance effective screen designs.
• Utilized Business Objects Data Integrator for ETL purpose in creation of data mart, as initial data source coming quarterly from Hospital groups through Flat files.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative and was the liaison between the client and developers.
• Performed data analysis and ran various SQL queries to critically evaluated test results and Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Experience in creating Test cases, defect reports using Application Lifecycle Management (ALM).
• Experience in working creating and managing requirements using Requirements Traceability Matrix (RTM).
• Responsible for preparation of cross walk for HIPAA logic (data manipulation) (ANSI 837 I to FACETS XC file and to keyword file extraction)-Inbound and outbound.
• Created UML Diagrams Activity Diagrams, workflow diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), Interaction modeling and Web Page Mock-Ups.
• Documented the dimensional models of ETL system. Develop and maintain reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Used Excel’s functions and various other features like Pivot Table, PivotChart Report and Goal Seek tool for reconciling various reports and for debugging purpose.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Worked in writing SQL Queries in Oracle for data manipulation.
• Worked on data modeling and produced data mapping and data definition documentation.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.

Environment: Oracle, SQL, Data modeling, ALM, SharePoint, Test Director, Apache, MS Project, MS office Suite

Confidential, San Jose, CA

Business Analyst / Tester

Responsibilities:

• Worked with business unit, design team, application leads, Stakeholders and architects to define and document accurate and complete functional and system requirements with storyboards.
• Created redlines, user stories, information architecture and screen mockups for content management system using SharePoint.
• Documentation of the application including system specifications, unit test plans, and integration test plans and participated in system testing.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative and was the liaison between the client, developers and stakeholders.
• Building Use Case diagrams, workflow diagrams, Activity diagrams and class diagrams using, end-end experience MS Visio, UML, Rational Rose, and Rational Requisite Pro.
• Performed Gap Analysis by brainstorming with developers, architects and business users.
• Worked extensively with MS Excel and MS Word to understand prepare Requirements and Analysis documents.
• Managed all phases of projects ensuring secure environments for customer data. Worked with design team to create the User Interface and User Experience prototype/wireframes for the website as per the business requirements.
• Managed requirements development, design, test scripting, testing, project training development and reporting.
• Overhauled numerous systems and processes through extensive review, analysis and upgrades.
• Created user interface using SharePoint and developed/designed SharePoint sites
• Planned and facilitated UAT, resulting in successful project implementations.
• Developed reports, charts, graphs, and process maps and maintain data files.
• Delivered Power point presentations on EVM financial reports, Budgets Developments.
• Developed reports, charts, graphs, and process maps and maintain data files, used crystal reports.
• Thorough knowledge of, and demonstrable experience with, Microsoft SQL Server 2000/2005 (including T-SQL and DTS).
• SQL Server database installation and configuration, Data import and export scheduling, building basic SQL queries for the Data extraction and reports generation based on business needs.

Environment: MS Project, MS Visio, Test Director, Windows 98 / NT, Rational Rose, Rational Requisite Pro, SharePoint, Clear Quest, SQL, Rational Unified Process (RUP), UML, Rational Test Manager, Windows, MS Office, HTML.

Confidential

Business Analyst

Responsibilities:

• Business requirements discussions & coordination with Onshore lead.
• Responsible to prepare documents i.e. low-level design, test cases, release notes, Implementation manuals etc.
• Mentor team for analyze, design, code, unit test the requirements and helped onshore in module integrations & implementations.
• Organized Joint Application Development (JAD) meetings with the domain and technology specialist to collect, validate, define, and conclude user requirements.
• Coordinated work plans between the project manager and clients using Microsoft Project.
• Worked on detailed migration plan for transforming disintegrated databases from multiple platforms into a single integrated data source.
• Extracted data from different sources like flat files excel data sheet, access database and SQL & Oracle relational databases and processed data to upload in to the target database.
• Trained Internal Users and their partner & management employees in the new web Based online applications.
• Assisted Business Intelligence team to develop the reports for various management levels related to past business as well as to predict the future expectations.
• Involved in writing use case scenarios and test cases.
• Conducted functional walkthroughs and User Acceptance Testing (UAT) sessions and assisted the QA team to prepare the User Manuals for customers.
• Wrote SQL queries to fetch data from the databases.
• Trained Internal Users and their partner & management employees in the new web Based online application.

Environment: MS-Project, MS-Visio, Rational Requisite Pro, Quality Center, SQL Server 2005.