SUMMARY:

• Over 6+ years of experience as a Business Analyst in IT Industry with proficiency in Business gathering, reporting, documentation, process mapping, scheduling, planning, and data analysis.
• Proficient in documenting business Process Design, creating business Requirements Document (BRD), Use case Specifications, Functional Specification Document (FSD), Detailed Design Specifications (DDS), User Interface Specifications (UIS).
• Excellent knowledge in manipulating, cleansing &processing data using Excel, Access, and SQL.
• Exposed to various development methodologies like Waterfall, SDLC, Rational Unified Process, Agile (Scrum), sprint planning, sprint review and sprint retrospective.
• Experienced in gathering business requirements, JAD Sessions, Gap Analysis, UML diagrams, Process Flows, Business Documentation, Data Mapping/ Modeling.
• Proficient in analyzing and creating Unified Modeling Language (UML) diagrams such as Use case diagrams, Activity diagrams, Sequence diagrams, Data flow diagrams, Business flow diagrams using MS Visio.
• Experienced in performing Gap analysis by identifying the existing application, Quality assurance, documenting the enhancements to meet the end - state requirements.
• Comprehensive knowledge, a practical exposure and documenting the As-Is/To-Be processes exercises.
• Extensive experience to analyze and document Business Requirements and System Functional Specifications (SRS) including use cases.
• Outstanding organizational skills including the ability to multitask, prioritize, and manage complex issues. Strong verbal and written communication skills.
• Strong experience with Scrum methodology and well versed in writing user stories in the Jira, pivotal tracker.
• Served as Scrum Master to manage the project and the stories with sprint planning and scrum meetings.
• Experience with Unified Modeling Language (UML) diagrams such as Use Cases, Activity Diagrams, Data Flow Diagram, and Process Flow Diagram using Visio and Axure.
• Proficient in MS Word, Excel (graphs, pivot tables, VLOOKUP), Visio, MS Project and Power point skills.
• Expert in tracking and managing requirements through Requirement Traceability Matrix (RTM)
• Strong Experience in writing Test Plans and Test Cases for User Acceptance Testing (UAT), managing test script execution for System/Integration Testing, Regression Testing, Progression Testing, and conducting Smoke Test.
• Basic understanding of creating dashboards with Tableau and Qlik View software.
• Actively participated in Change Management, performed Impact Analysis, maintained Change Log and closely with the Change Control Board (CCB)
• Creating and maintaining project migration schedule with project documentation requirements.
• Worked with a client relationship focus to ensure full awareness of client business workflow, strategy, issues, requirement, and tools.
• The excellent track record of meeting deadlines and submitting deliverables on time. Experience in reviewing Test plans, Test cases and Test case execution using Test Director.
• Extensive experience in performing Functional, Usability and Stress Testing along with ensuring that the software meets the system requirements.
• Expertise in Database Administration of Test Environment Databases, Data Pools and identifying the performance issues due to inefficient Database Administration.

SKILLS:

Ms access, Sql server, Oltp, Oracle, Pl/sql, Sql, Html, Ms project, Visio, Rational, Rational rose, Uml, Use cases, Etl, Informatica, Molap, Olap, Rolap, Sharepoint, Uat

TECHNICAL SKILLS:

Project Methodologies: RUP, Waterfall, Agile (SCRUM)

Business Modeling Tools: MS Visio, Rational Rose

Test Management / Testing: HP Quality Center / Application Lifecycle Management (QC/ALM), Rational Quality Manager

Databases: Oracle (11g/12C,10g), SQL Server, MS Access, SQL, PL/SQL

Tools: MS PROJECT, SQL, HTML, SharePoint, MS Office

Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, MOLAP, Oracle, Query/Reporting, Multidimensional Analysis

BI/ETL tools: Informatica, SSIS, OBIEE 11g, Informatica Power Center, SQL * Loader

Operating System: Windows, Linux, Unix, Mac, Solaris.

Documents & Processes: SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modelling, Project Planning & tracking

WORK EXPERIENCE:

Business Analyst

Confidential, Washington

Responsibilities:

• Responsible for taking requirements from business users, understanding Business Needs by scheduling meeting one regular basis.
• Involved in creating the Project templates, use case specifications, Change request form, functional specification documents, and Business Requirement documents.
• Mentor teams to effectively use the agile ceremonies like sprint planning, daily stand-ups, and retrospectives and sprint reviews to provide working outcomes in every sprint.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on agile methodology.
• Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models;
• Designed and developed business flow diagrams, activity diagrams, sequence diagrams, object-oriented models using MS Visio.
• Conducted Model reviews with project team members; Publish and communicate models to various IT and business-based teams.
• Conducted data mapping to collect and show relations between data from dashboard function to the ODS table on PeopleSoft database, represented this mapping using ERDs, and Process Modeling DFD's on MS Visio.
• Proactively prepared scenario analysis of different product mix and identified the areas of improvement and solutions to meet the customer needs.
• Organized JAD sessions to flush out requirements, performed Use Case and workflow analysis, outlined business rules, and developed domain object models.
• Utilized Management Information Software (MIS) and Financial Accounting Software (FAS) that ensured daily balancing of accounts and vendor reconciliation. Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Interacted with the development team to ensure they get all the details for developing the stories.
• Produced and updated daily morning reports of campaign success metrics and used analysis from this report to correctly allocate budget in Double Click Manager and The Trade Desk. Designed Specification SDS, Requirement Traceability Matrix RTM and testing documents and confirming integration of Order Management System and Work Order Management System. Propose technology solutions to enable the business to meet/exceed those goals
• The gathered requirement for the application of the Salesforce CRM with the Customer Portal Strongly involved in preparing Business Requirement Document and Functional Requirement Document.
• Created workflow rules and defined related tasks, time-triggered tasks, email alerts, filed updates to implement business logic.
• Made reports to assist marketing managers and configured various report folders for different user profiles based on the needs of the organization
• Conducted performance tuning to primarily focus on writing efficient SQL Queries to generate reports. Documented Business and Test Plans based on gathered requirements; involved in executing existing test scripts, writing and updating new test scripts.
• Designed, developed, and maintained various business unit reports by using Teradata, SQL and MS Excel.
• Produced daily, weekly and monthly reports, on-time and accurate, on the process and business performance to various stakeholders
• Documented functional specifications for multiple components for achieving the ability to send and receive currency or cash via various Electronic Funds Transfer System (EFT) such as CHIPS and ACH. Assured that all Artifacts are in compliance with corporate Agile Policies and guidelines.
• Involved in Defect Reporting, Defect Tracking and in Preparation of Defect Report using HPQC.
• Wrote SQL queries to understand data relations and variances from other source systems.

Environment: Agile, MS Visio, MS Project, Reporting tools, Gap Analysis, GIT, RTM, RCM, SQL, Jira, MS Office, Oracle and Windows.

Business Analyst

Confidential, Lansing, MI

Responsibilities:

• Analyzed and gathered business requirements, identified system interfaces and created the requirements specification document.
• Wrote User Requirements Specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Conducted sprint planning meeting, sprint review meeting, sprint retrospective meeting and backlog refinement meetings.
• Performed Requirement Analysis to Develop Use Cases, Activity Diagrams and Sequence Diagrams.
• Documented conceptual design of Application in System Specification Document.
• Controlled project scope identified and resolved key issues and risks.
• Conducted JAD sessions and meetings with developers, QA team, and users for communicating primary requirements, also discuss different versions of requirements, queries, and clarify the issues.
• Extensively interacted with both user group and development team in coming up with structured charts, Class and sequence diagrams.
• Managed and tracked change control process of requirements and design changes using Rational Requisite Pro.
• Documented the changes, issues and their impact on the system design and delivery.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners &stakeholders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Used Global Data Synchronization Network (GDSN) which connects suppliers and retailers, operators, providers, distributors, and other recipients to the GS1 Global Registry via selected Data Pools.
• Managed plan and design of backup data Center infrastructure build-out and participate in business continuation/disaster recovery planning.
• Facilitated and managed meeting sessions with a committee of SMEs from various business areas including estimating resource and budget requirements.
• Designed and implemented basic SQL queries for QA testing and report, data validation.
• Managed plan and design of backup data center infrastructure build-out and participate in business continuation/disaster recovery planning. Imported data from various transactional data sources residing on SQL Server, DB2, and Flat files and loaded into Oracle database.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Conducted daily scrum meetings and noted impediments and progress of tasks and transferred information to Jira.
• Played a key role in User Acceptance Testing (UAT).
• Developed test plan, test scenarios, test cases and implement test plan with QA team using Mercury Quality Center /Test Director.
• Involved in creation of test data in Salesforce, API testing, interface testing, system testing verification and validation of test scenarios.
• Involved in system testing, UAT testing, the creation of test plans and test cases, use cases, traceability matrix and test scripts Conducted many demos and presentation sessions with business folks to walk through the application and functionality.

Environment: MS Project, MS office suite, MS Visio, MS PowerPoint, HTML, Gap Analysis, SQL, Agile, Oracle, Microsoft Office Suite, Microsoft Project, SharePoint, ETL testing, SQL.

Business Analyst

Confidential, Tampa, FL

Responsibilities:

• Participated in the creation of Business Process Workflow Diagrams and data flow diagrams (DFD) with Stakeholders involved throughout the System Development Life Cycle (SDLC) - AGILE.
• Translated high-level requirements into the functional specification, acted as a liaison between users and the technical team in order to clarify the Business System Design and Process Mapping diagram in Swim Lanes.
• Worked on the coordination of software-mediated data transmission process of State Exchange Data File (SDX) among system users and external agencies as well.
• Worked in an exclusively Agile environment, accepted changes along the project and implemented them by taking it into Change Request Board, performed Impact Analysis that the change may have in the project.
• Experience in conducting JAD sessions in order to understand the feasibility of the requirement in presence of the entire team.
• Perform stakeholder analysis to perform identify team members and build a communication plan to interface with different user groups Document detailed Business Requirements Documents (BRD) and Functional Requirement Documents (FRD) using Rational Requisite Pro.
• Documented system requirements and business requirements and created Requirement Traceability Matrix (RTM) Experienced in conducting User Experience (UX) session by testing the data in each release and getting approval from the Product Owners.
• Extensively compiled Use Cases after gathering requirements from different business units by taking account of Business Rules, Actors, Pre-condition and Post-condition and Trigger. Mapped HIPAA compliant EDI transactions for 837: healthcare claims and 835: payment advice transactions
• Recommended changes for system design, methods, procedures, policies, and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats and accredited standards like ANSI. Developed Stored Procedures for the Dataset to build the reports for the client requirements.
• Designed packages that utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column. Wrote triggers, stored procedures, functions and packages in PL/SQL to support report groups to utilize by Crystal Report/Oracle Report.
• Worked with development teams in the design of physical databases and in the modification.
• Hand on experience on Oracle database wrote PL/SQL Packages, Store procedure, functions to manipulate data.
• Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
• Supported DBA to design, develop and maintain database objects (stored procedures, functions, packages, triggers, views, sequence, indexes, database link, synonyms and table space).

Environment: HIPPA ANSI X12, SDLC, Net, CPT and ICD-9 Coding, Rational Rose, Rational Requisite Pro, Microsoft Visio, SAS, Java, MS Word, MS Excel, MS Outlook, MS Access.

Business Analyst

Confidential

Responsibilities:

• Worked and understood the state of art processes by interacting with stakeholders and in-depth documents analysis, also performed a GAP analysis to assist Product Owner and Project Manager in planning the transition.
• 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.
• Conducted group sessions to gather and document the functional and non-functional requirements with the SMEs and business units.
• Working as a liaison between stakeholders and technology team to interpret business needs
• Created & prioritized User Stories using MOSCOW technique and acceptance criteria, along with the Scrum stakeholders.
• Created the Project Charter, User Stories and set the business objective following Agile methodology Prepared Use Cases, Use Case Scenarios and elaborated those using UML diagrams like Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Business Process and Data Process Model using MS Visio
• Responsible for Creation of Use Cases and developed Use Case Diagram and Activity Diagram using MS Visio. Ensured Data Integrity using various techniques such as performing Data Normalization, Data Verification, and Data Validity to enforce accuracy and effectiveness of data.
• Responsible for performing Data Profiling and Data Mapping using Informatica Data Quality (IDQ).
• Performed an OLTP system analysis in place to assess the data quality and completeness Assisted the ETL team in integrating various OLTP to the OLAP by using Informatica and Cognos for reporting.
• Worked in dimensional Modeling processes such as star schema and snow flakes chema.
• Utilized Consolidation transformations to create unique records to aid in the optimization of OLAP performance.

Environment: Waterfall methodology, MS Office, MS Visio, MS Project, HP ALM, Wireframes, Mock-Up Screens, MS SQL Server, SharePoint, Data Modeling, Data Verification, Data Mining, OLTP, OLAP, Cognos.

Data Analyst

Confidential

Responsibilities:

• Provide expertise and recommendations for physical database design, architecture, testing, performance tuning and implementation.
• Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server. Wrote simple and advanced SQL queries and scripts to create standard and Adhoc reports for senior managers. Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Ability to manage multiple projects simultaneously tracking them towards varying timelines effectively through a combination of business and technical skills.
• Good understanding of clinical practice management, medical and laboratory billing and insurance claim with processing with process flow diagrams.

Environment: OLTP, Oracle 9i, DB2, Metadata, MS Excel, Mainframes MS Visio, PL/SQL, etc.