PROFESSIONAL SUMMARY:

• Business Analyst with 8+ years of experience in developing, implementing, and managing complex projects in Financial, Healthcare, Pharmaceutical, Banking, Retail, and Marketing. As a Business Analyst, I focused on various SDLC, SAFe and Agile Methodologies.
• Possessing Knowledge of eliciting, analyzing, validating, and verifying requirements, escalating project risks, managing change request document, preparing, and delivering progress reports and developing business strategies.
• Excellent team player with superior analytical, negotiation and problem - solving skills with experience in leading teams of diverse backgrounds to make sound business decisions based on analysis of short-term and long-term business needs.
• Proficient in preparing Business Requirement Document (BRD), Software Requirement Specification (SRS), System Design Specification (SDS), Functional Specifications.
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Project Life Cycle, Rational Unified Process (RUP)
• Proficient in gathering and converting User Requirements into Business Requirements and Functional Requirement Specifications (FRS) and use Modeling tools like Caliber RM, Rational Rose and Microsoft Visio for requirements modeling.
• Proficient in elaborating & consolidating the business requirements into Epics, Features, User Stories, Acceptance Criteria and User Story Mapping and uploading them into the tracking systems.
• Experience in using JIRA, Rally, Team Foundation Server (TFS), HP Agile General Manager (AGM) and other Agile-Scrum reporting tools.
• Proficient in content authoring and publishing through Adobe Experience Manager(AEM) V5.6 & 6.2 and Web Experience Manager
• Expertise in HP ALM on creating test cases, test scripts and maintaining defects throughout the process.
• Proficient in analyzing the metrics through Adobe Analytics to identify the bottle necks and derive business justifications
• Excellent understanding of Data services, ETL, Teradata and MS Access and accessing it through Teradata SQL Assistant and other SQL query tools
• Experience in creating Dashboards and Reports to consolidate metrics and performance scorecards
• Exposure in creating and analyzing Data flow diagrams, and Entity Relationship diagrams
• Experience in facilitating Joint Requirement Planning (JRP) sessions withBusinessUser Groups with Project team members.
• Experience in Graphical User Interface (GUI) design, wire frames, prototypes and screen mock-ups
• Experience in creating/conducting Functional Flow charts, Workshops and Brainstorming Sessions and extensive exposure to UML diagrams using MS VISIO.
• Involved in development and maintenance of Work Breakdown Structure (WBS)
• Proficient in performing and documentation of GAP analysis, Feasibility study, User Acceptance Testing (UAT), SWOT analysis, Risk analysis, and ROI analysis.
• Extensive experience in modeling the AS IS and TO BE ecommerce solutions
• Involved in automated testing for efficiency and Quick Test Pro.
• Hands on experience with QNXT and CWS & Facets.
• Hands on experience working with various PeopleSoft applications, compliance, and risk management.
• Knowledge of cloud based technology Amazon Web Services (AWS) and salesforce application.
• Hands-on, end-to-end SDLC experience and a thorough understanding of CRM concepts, as demonstrated supporting Microsoft Dynamics CRM
• Proficient in identifying bottle necks in processes by using Six Sigma Techniques & Business Process Reengineering (BPR)
• Worked on healthcare standards such as HIPPA 4010, 5010, ICD-9 ICD 10
• Adequate knowledge in Health Administration - Claims processing, COBw, EOB/Drafts, Medicare Advantage Plans (Part C), Claims pricing and testing, HIPAA, enrollment, EDI, Medicare, Medicaid, CDHP
• Hands on experience working with Trauma Registry System
• Hands on experience with understanding of Financial Market practices, Lending services, payment types and liquidity management techniques.
• Experience in conducting Joint Application Development (JAD) sessions and White Board Sessions with end-users, Subject Matter Expert (SMEs) team, Architects and design group development and QA team for project meetings, walkthroughs, and customer interviews commensurate with excellent communication skills.
• Experience in writing queries/scripts for data analysis and QA report testing, Quality Testing and Quality Center.
• Proficient in Creating and Maintaining Requirement Traceability Matrix (RTM)
• Tracking changing requirements using requirements management tools like Team Forge and Rational Requisite Pro
• Expert in using Microsoft Office applications for day-to-day activities - Microsoft Word for documentation, Microsoft PowerPoint for presentation, Microsoft Excel VBA, Macros for data presentation, Microsoft Access and Microsoft Project and SharePoint for prioritizing and managing individual tasks.
• Customer focused; Adaptive to high-intensity environments; as well as changes in customer requirements
• Ability to handle multiple projects in a fast paced, team oriented and collaborative environments.

TECHNICAL SKILLS:

Business Management Tools: MS Visio, UML, Rational Requisite Pro, RTM, Caliber RM, Team Forge

Methodologies: Waterfall, Agile-Scrum, SAFe

Application Packages: MS Office 2003/2007/2010, MS Project, MS Visio, PeopleSoft, MS Dynamics, Salesforce, Teradata SQL Assistant

Process/Technologies: RUP, Use Case, Work Flow, Quick Test Pro, AEM, JIRA, RALLY, HP ALM, HP AGM, TFS

Operating Systems: Windows 95/98/2000/XP/Vista

Databases: MS Access, SQL, Oracle, DB2, Teradata

Reporting Tools: MS Excel, SharePoint, SSRS

WORK EXPERIENCE:

Confidential, Collierville, TN

Sr. Business Analyst

Responsibilities:

• Analyzed and documented the Business Requirement Document (BRD) in Team Forge and socialized the documents with the impacted application teams
• Analyzed the Business requirements with leads to identify the impacted applications across the Enterprise Level
• Performed GAP Analysis between the current and future state of EAN identifier to understand the infrastructure changes required to the existing legacy systems
• Defined Ideal state Scenarios, Customer Journey Maps and Forward looking Position Statements to socialize the Business requirements in Epic Summits
• Broke down the Business Requirements into Epics and Features to define the Minimum Viable Product (MVP) as per SAFe Environment
• Documented Epics and Features in HP Agile Manager (AGM) and assisted the teams in writing the User Stories and Acceptance Criteria and ensured Acceptance Criteria meets the business needs
• Extracted and analyzed 8.5M enrollees of FDM data to determine the potential areas and the enhancements needed for FDM growth
• Analyzed the real-time data of page visits, drop-outs and FDM registrations through different traffic sources using Adobe Analytics
• Extracted the data from Enterprise Data Warehouse using SQL Queries through Teradata SQL Assistant
• Utilized Adobe Analytics to analyze and create the metric-based and item-based reports on usage and performance of FDM
• Created Dashboards and reports from the analyzed data to identify the potential opportunities to increase the Visibility of FDM
• Prepared Customized Delivery Options and Revenue reports which provide an insight into the usability of features and the revenue generated.
• Socialized the Dashboards/reports with the extended teams and posted them into a common shared repository Purple Hub to be able to access by different organizational levels.
• Collaborated with Marketing teams in identifying the potential Guest users to perform the Email Marketing Campaigns through Adobe Analytics
• Worked with Third-Party vendor and teams to determine the Knowledge Based Assessment (KBA) Verification process to prevent fraud registrations for FDM
• Documented Test Scenarios, Test plans and Test cases by ensuring all the business lines of requirements are covered
• Prepared User Acceptance Testing (UAT) scenarios to assist the Business users in performing thorough validation
• Created Test accounts and Test data to cover all the possible Test Scenarios and Test cases to ensure adequate validation prior to the launch of the project
• Performed testing in different levels of environments and the test results/defects and documented them into HP Quality Center (HP QC)
• Utilized Defect Tracking Management in QC to maintain and track down the defect validation results
• Collaborated with the Agile Release Train team to identify the Major defects and ensure Quality requirements are fulfilled.
• Performed Pre-Production and Post-Production validations along with team to make sure the MVPs are working as expected.

ENVIRONMENT: Team Forge, Teradata, Teradata SQL Assistant, SQL, Adobe Analytics, HP Agile Manager (HP AGM), HP Quality Center (HP QC), SAFe, Windows, MS Office Suite

Confidential, Owings Mills, MD

Sr. Business Analyst

Responsibilities:

• Designed and developed project document templates based on AGILE methodology
• Ensured that all Lines of Business specifications were consistent in form and function to the Diamond Base System and the scope has been determined by using the Agile Story Cards
• Documented technical compatibility by gathering adequate requirements to mimic client's platform requirements.
• Analyzed and Documented Business Requirement Document (BRD), Functional Specification Documentation, and System Requirement Documentation, using UML methodologies and Caliber RM.
• Performed Gap Analysis of client requirements, generated workflow process, flow charts, user story mapping and relevant artifacts.
• The existing historical parent data has been collected from different database source and analyzed them by using Excel VBA and Macros for determining the data for new investor class Funds.
• Financial reports and forms has been generated by using Excel VBA for presenting to the business stake holders before the launch of the new funds.
• Utilized JIRA and RALLY tools for maintaining the user stories and acceptance criteria and tracking down the progress.
• Created test cases and test scripts for user acceptance testing (UAT) to help business partners in performing the UAT.
• Utilized HP ALM for defect management and for maintaining the test cases and test scripts.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams
• Utilized SharePoint, JIRA, RALLY and Microsoft Dynamics as a part of reporting, requirements management, testing and for determination of milestones.
• Worked on DB visualizer to set up the Data for new investor class funds in Database
• Coordinated the deployment process for deploying the set of funds across the multiple applications and websites
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing application.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server.
• Worked on creating and developing the web pages by utilizing the templates in Adobe Experience Manager as per the business requirement
• Worked on migration of internal and external websites from AEM 5.6 to AEM 6.2 and ensured the business lines are met and functionality is working as expected.
• Utilized Adobe Experience Manager(AEM) for content authoring, web pages creation & publishing across the websites and Mobile apps
• Experience in collaborating with different teams to ensure the brand & creative aspects to be implemented on the websites
• Review documentation of structure, laddering, asset management fees, expense sharing (including due diligence costs) cash contributions and distributions
• Participated insystem test reviews, developmentdesign reviewsas well as usability studies.
• Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Involved in project planning, coordination and implemented QA methodology.
• Createdfunctional prototypesbased on user requirements and presenting thosewire framesto the development and test team for their understanding during the review meetings.
• Involved in maintaining and managing different versions of Documents using Rational ClearCase.
• Implemented the Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts, and activities.
• Collaborated with the QA team to ensure adequate testing both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.

ENVIRONMENT: MS Web Technologies, AGILE, JIRA, RALLY, HP ALM, Adobe Experience Manager (AEM), Windows, IE, Rational Unified Process (RUP), Rational ClearCase, Rational RequisitePro, UML, MS Visio, MS Excel VBA.

Confidential, Timonium, MD

Sr. Business System Analyst

Responsibilities:

• Designed and developed project document templates based on AGILE methodology
• Ensured that all Lines of Business specifications were consistent in form and function to the Diamond Base System.
• Ensured CIP requirements, customer due diligence and Enhanced Due Diligence policies are being followed based on KYC norms for specific countries.
• Documented technical compatibility by gathering adequate requirements to mimic client's platform requirements for Actimize AML as a part of CDD/ECDD.
• Performed Gap Analysis of client requirements, generated workflow process, flow charts and relevant artifacts.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams
• Analyzed and Documented Business Requirement Document (BRD), Functional Specification Documentation, and System Requirement Documentation, using UML methodologies, six sigma techniques and Caliber RM.
• Utilized Team Foundation Server (TFS) & Microsoft Dynamics as a part of maintaining user stories, acceptance criteria and testing.
• Performed Data & user story Mappings based on the specified business requirements.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing application.
• Review documentation of the investments, prepare a summary memorandum of the investments focusing onaccountingconcerns such as structure, laddering, asset management fees, expense sharing (including due diligence costs) cash contributions and distributions: reporting requirements, andaccountingissues
• Discussed with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage.
• Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Involved in project planning, coordination and implemented QA methodology.
• Createdfunctional prototypeswith theUI teambased on user requirements and presenting thosewire framesto the development and test team for their understanding during the review meetings.
• Responsible for company-wide and local unit report development using PeopleSoft nVision, PeopleSoft Query and Crystal reports.
• Responsible for managing day to day operations with BPO forPeopleSoft Asset Management processing.
• Created test data files and interfaces from 3rd party vendor toPeopleSoftBilling and Fee Calculation system.
• Involved in maintaining and managing different versions of Documents using Rational ClearCase.
• Implemented the Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server.
• Assisted the QA personnel in the creation of Test Cases using Rational Test Manager.
• Engaged in system testing during User Acceptance Testing (UAT) and Quick Test Pro

ENVIRONMENT: MS Web Technologies, PeopleSoft, AGILE, SQL, Windows, IE, Rational Unified Process (RUP), Rational ClearCase, TFS, Rational Rose, Rational Unified Process, Rational RequisitePro, UML, DOORS, Quick Test Pro.

Confidential, Basking Ridge, NJ

Sr. Business Analyst

Responsibilities:

• Defined scope of the project; Estimated & kept track of project budget; Created project plan and the WBS according to the Scrum methodology.
• Using EDI transaction code, migration of HIPAA - EDI X12 4010 series to 5010 series is a part of the team.
• Conducted GAP analysis of 4010 and 5010 EDI transaction using implementation guide to identify the changes in the segments and data elements.
• Utilizing the mapping tools to map 4010 and 5010 transactions along with ICD 9 and ICD 10 codes, and validated the HIPAA Syntax.
• Developed Incident documents and portrayed the As-Is reporting structures versus To-be Reporting needs for data integrity and accuracy.
• Performed feasibility study, risk analysis and utilized Vermilion to address critical business issues within a single integrated enterprise client reporting solution.
• Established a Business Analysis methodology around the RUP. Helped develop use cases, project plans, and manage scope.
• Established the integration requirements as per the business needs to connect with the existing legacy system
• Utilized BI reporting tools like SharePoint and Microsoft Dynamics CRM for decision analysis
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using, Requisite Pro, Microsoft Visio.
• Designed and developed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams and web page mock-ups using Rational Rose and Microsoft FrontPage.
• Conducted workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements.
• Utilized different modules of Facets to design or perform the day to day operational tasks
• Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes
• Using detailed knowledge of application features and functions, assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• 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.
• Developer web forms using HTML and other web services for new EMR system.
• Conducted UAT (User Acceptance Testing), Quality Testing.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server.
• Participated insystem test reviews, developmentdesign reviewsas well as usability studies.
• Collaborated efforts with technical staff and subject matter experts to establish the technical vision of product and analyze triple constraint tradeoffs.

ENVIRONMENT: Scrum, RUP, Rational Requisite Pro, SQL Server, Clear case, Rational Clear Quest, Data warehouse, HTML, UML, Unix, XML, MS Project, MS Visio.

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Process claims for all lines of business including but not limited to HMO, PPO, POS, TPA and Medicaid/Medicaid.
• Assist in all s and meetings related to claims processing and implementations.
• Educate providers on benefits and eligibility related to member utilized health services.
• Collaborate with the health improvement department to create and implement health related activities.
• Designed ASO & BSO applications for the purpose of Analysis and Planning applications for the purpose ofBudgetingand Forecasting.
• Write back Budget interface data from Planning to Oracle EBS/PeopleSoft financials using FDMEE
• Prepared quarterly forecasts, annual budget, Ad-hoc reporting using Hyperion Financial Reports.
• Performed the integration requirement analysis, impact analysis and documented Business Requirements Document (BRD) and Functional Specification Document (FSD) using Rational Requisite Pro.
• Prioritized deliverables, identified gaps, tracked defects, defined software requirements using Team Foundation Server (TFS), created artifacts for testing and development.
• Gathered knowledge on HL7, HIPAA rules and regulations and trauma registry system.
• Mapped HIPAA compliant EDI transactions for 837: healthcare claims and 835: payment advice transactions
• QNXT, Care Advance, CWS, Facets and a host of 3rd party software suites are included with the build outs of the environments.
• Collaborated efforts with technical staff and subject matter experts to establish the technical vision of product and analyze triple constraint tradeoffs.
• Analyzed business processes, requirements, and data necessary to provide detailed logic for ETL development.
• Created UML diagrams- Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Conducted GAP Analysis of current state (As-Is) ICD 9 and proposed state (To-Be) ICD 10 situations and represented the same on MS Visio.
• Supported development of UAT cycle test scripts, Review User Acceptance Test Plan (UATP) and attend walkthrough
• Recommended changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI and Part C formats and accredited standards like ANSI.
• Managed the planning / test process for Medicare Part D Pharmacy Claims (PBM).
• Analyzed, maintained and updated FAQ knowledge base in SharePoint for better data accuracy and better timely data availability

ENVIRONMENT: MS PowerPoint, Requisite Pro, XML, TFS, MS Visio, Dreamweaver, UI, MS Excel, MS Access, Oracle, Waterfall SDLC.

Confidential, Raleigh, NC

Business Analyst

Responsibilities:

• Involved in requirement gathering session with Business Analystand Architect for building Data warehouse as part of ODS (Operational Data Store) project.
• Worked on Businessrequirement analysis and data analysis on millions of data
• Ensure accuracy of financial statements in accordance with GAAP and compliance to internal policies
• Worked on generating the reports from existing data base by using Excel VBA for channelizing the process as part of the requirement analysis.
• Created Planning Applications to manage all their Budget, Forecast and Financial planning using Classic Planning application and EPMA applications.
• Effectively manage and communicate cash flow related issues. Includes the accurate and timely preparation of cash flow statements, management of receivables, payables, cash balances, control mechanisms and timely deposits of all funds.
• Involved in Contract Management system as part of the analysis.
• Worked on gathering requirement for the monitoring/ support system for the ODS
• Helped in designing the dashboard/ UI for monitoring the data-warehouse.
• Involved in designing and developing ETL (SSIS) processes & implementing Logging strategies when loading data into data warehouses and data marts.
• Worked on creating requirement for both Tabular & Matrix report Layouts to develop reports using SSRS.
• Worked with developer in creating Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Involved in creating Report Snapshots to improve the performance of SSRS.
• Worked on Data modeling as part of building databases using Database Diagrams in SQL Server management studio
• Elicited businessrequirements and business needs into user stories and acceptance criteria performed story mapping as part of an Agile Scrum team and managed it by using the Team Foundation Server (TFS).
• Prepared test cases, Automated with using Microsoft Test Manager and Quick Test Pro.
• Worked on Security Test plan for the data warehouse according to HIPAA compliance.
• Attended daily meetings and dealt with day-to-day deadlines.

ENVIRONMENT: MS Office, Agile, MS VISIO, MS Excel VBA, SQL, Businessobjectives, XML, Outlook, Share Point, TFS, Microsoft Test Manager, Quick Test Pro.

Confidential

Jr. Business Analyst

Responsibilities:

• Gathered user/business requirements by meeting with business users and generated business models and use case analysis.
• Prepared the Software Specification Document for the application based on business user information.
• Created use case document to elaborate user experience taking into account the business objective.
• Converted Business Requirements to the Functional Specification to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
• Feature identification, defining and documenting business requirements and priorities according to Scrum Methodology.
• Critically evaluated the information gathered from multiple sources during requirements and analysis and responsible for tracking, tracing and managing requirements using Requisite Pro.
• Developed Test Plans and Test Cases according to Business Requirements.
• Interacted with development team for communicating the requirements and use cases.
• Involved in generation and execution of SQL queries.

ENVIRONMENT: MS Visio, MS Office, SQL, PowerPoint, MS Word, MS EXCEL, Windows.

Confidential

Business Analyst

Responsibilities:

• Developed the scope and vision document that defined the primary goals, objectives and features of the Loan Management System.
• Lending services, payment types and Liquidity management techniques has been utilized to determine the scope of the project
• Responsible for defining and documenting Business Requirements and the Functional Specifications.
• Responsible for the development and analysis of departmental budgets and forecast, and conducting strategic planning.
• Managing the creative content that coincides with the promotional and special packages to attract mortgage loan customers.
• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) as a part of Scrum methodology.
• Identified and developed process flow diagrams for various business processes and validated the flows with Subject Matter Experts (SMEs).
• Created business rules with calculation examples for borrower payment options.
• Analyzed the existing system and process gaps in context of new business changes - Gap Analysis.
• Performed Business Impact Analysis of proposed projects, processes and solutions.
• Involved in Change Request during the planning and design phase.
• Assisted Project Manager in analysis and planning that identify business needs, costs and benefits of implementing new products solutions in the industry.
• Assisted the QA group in developing and documenting test cases.

ENVIRONMENT: SQL Server, XML, PeopleSoft, Windows 95/98/2000, MS Office Suite, Internet Explorer and Rational Req. pro, clear case, RUP methodology, Rational Rose, Clear Quest, UML, MS Visio and MS Project