SUMMARY:

• 6+ years of comprehensive experience in the field of Information Technology as Business Analyst, System Analyst, Quality Analyst covering areas like Project Management, Business Process Design, System verification, Business Intelligence and validation in diverse fields such as Healthcare, Retail, Insurance, Banking and IT.
• 4+ years experience on HRMS and Payroll Sysytem .
• Responsible for coordinating, analyzing and reporting eCommerce sales and digital marketing data pulled from numerous data sources and analytic tools.
• Experienced working on tools like MS Excel, SQL server, Tableau, Power BI for data analysis projects.
• Through knowledge of Digital Asset Management (DAM) techniques and methodologies .
• Experienced in creating use Case Diagrams, Activity Diagrams, Business Process Models, Work Flow Diagrams, Data Flow Diagrams, Flow Diagrams, Sequence Diagrams, Process Flows using Unified Modeling Language (UML) and Rational Unified Process (RUP) and UML modeling tools such as MS Visio and Rational Rose.
• Business Analysis with Project Management experience in ecommerce platforms, CRM platforms and consumer online products and services.
• Worked on numerous cross platform applications and organized Joint Application Developments (JAD) and Joint Requirement Planning sessions (JRP), Interviews and Workshops, Rapid Application Development (RAD) sessions with end - user/clients/stake holders and the IT group. Also, carried out Project Feasibility Study, Gap Analysis and Risk Analysis.
• Maintained Test Matrix and Requirements Traceability Matrix (RTM).
• Involved in defining the source to target data mapping, Implementation, consolidation, Integration, Data Migrating as per the business rules and data definitions.
• Experience in working with SharePoint and managing Documents on SharePoint.
• Experience in different lifecycle models Agile Scrum, Waterfall, Onsite-Offshore .
• Experience is refining the Product Backlog and writing user stories.
• Strong experience in working with all phases of SDLC throughout the project life cycle in Rational Unified Process (RUP) environment. Mature understanding of Quality Assurance Methodology relative to SDLC.
• Strong knowledge in insurance PLM, eCommerce PLM, product development
• Extensive experience in various testing strategies like System/Integration/Load/Regression/User Acceptance Testing (UAT) and Manual testing (GUI Testing, Field Validation Testing, Functionality Testing) of UI and Web Applications.
• Extensively worked in creating Test Procedures, Test plans, Test cases and reviewing them for quality assurance. Tracking defects and interacting with team members in fixing errors. Worked on both Black box and White box Testing.
• Track, escalate and remove impediments. Report at daily Scrum of Scrum meetings.
• Gather requirements for Enterprise Data warehousing (EDW) for the client reporting needs and managed the entire functional requirements life cycle using Rational Unified Process (RUP).
• Experience in creating test cases for all test scenarios including functional testing and UAT.
• In-depth knowledge of Risk Engineering, Data Modeling & Mapping, Design using UML and Visio, Excel reporting and automation of reporting and PowerPoint Presentations.
• Performed GAP analysis between current and future systems for an increase in productivity and cost reduction.
• Defined and created Test scripts, analyzed defects, by interacting with QA /developer teams in fixing errors.

TECHNICAL SKILLS:

Software Methodologies: Agile (SCRUM), Waterfall Model

Business Modeling Tools: MS Visio, Rational Requisite Pro

Databases: MS Access 2003/2007, Microsoft SQL Server, PL/SQL

Software Tools: JIRA, BM Remedy, SysAid, Issue Tracker, Confluence, Blueprint, SAP HANA, Web IDE

Testing Tools: SOAP UI, Postman, Version One, HP Quality Center

ETL, BI and Reporting Tools: SQL Server Data Tools - Business Intelligence, SSAS, Tableau Desktop, Qlikview, Crystal Reports, Business Objects, Micro Strategy, Tableau, PEGA

Microsoft Office Suite: MS Project, MS Word, MS Excel, MS SharePoint concept, MS PowerPoint, MS Visio

Operating Systems: Window Server 2008R2/2012, Windows XP, Windows 7,8,10 Mac OS

Project Management and Business Skills: HIPAA, ITIL(Information Technology Infrastructure Library), Change Management, SWOT Analysis, Project Planning,Project Budgeting, Content management, Scheduling, Cost and Time estimation

PROFESSIONAL EXPERIENCE:

Confidential, CA

Business System Analyst/PM

Responsibilities:

• Builds long-term relationships between multiple business partners to drive engagement in IT strategy. Influences business partner decision making to optimize requirements and their prioritization.
• Lead implementation of an e-commerce solution for educators to explore, and purchase various types of teaching aid resources .
• Performed manual testing, data analysis and validation of reports and database changes using SQL.
• Gather / document digital marketing solution and platform requirements from management, staff and customers, working with technical architect to flush out design, integration, security, UX/UI, content management / publishing, digital asset management, social media, eCommerce and commercialization features.
• Create ad hoc reports via SQL data extraction.
• Outsourced Vendor Management; Support Team metrics analysis and reporting using SQL for data retrieval/manipulation, Excel for creation of graphs and PowerPoint and Visio as presentation tools .
• Creates solutions that work within, and advance architectural objectives. Guides solutions options and business partner decision making to minimize the amount divergence from target architecture. Identifies opportunities for creating reusable enterprise services.
• Collaborated with eCommerce Marketing Manager while providing analytical assistance to promote and drive revenue.
• Using SQL queries on various databases to find the main source of data required and getting the output to build the solution.
• Conducted UAT testing and validation for each project and held UAT status meetings with SMEs to ensure the quality of tech deliverable for the project.
• Produced Requirements documents (FRD), Testing documents, System Design Documents (SDD), Requirements Traceability Matrixes (RTM), User Acceptance Training (UAT) plans .
• Works with stakeholders to develop scope and phases to meet intended deadlines.
• Worked directly with IT team and vendor partners to analyze eCommerce business processes and procedures and implement necessary changes
• Maintains deep understanding of multiple business areas supported including current state and best practices.
• Facilitated JAD sessions with management, users and other stakeholders to define the project and to reduce the time frame required to complete deliverables.
• Assisted QA Team along with Clients in UAT to log any issues or help/guide in any testing efforts.
• Communicates complex topics to support project and organizational change objectives. Leads and engages key knowledge workers and business sponsors in change management activities.
• Designs complex solutions for usability, end-user adoption and productivity improvement. Identifies the requirements to ensure end user performance. Gains business sponsor commitment to ensure usability.
• Helping team to create the reports with supportive FRD’s and BRD’s creation analyzing the development models using Web IDE, SAP HANA and Tableau.
• Work as Product Owner for an ECommerce prototype application.
• Quantifies project resource requirements for large projects. Manages ambiguity and creates accurate project effort estimates. Accurately quantifies project-specific risks and mitigation through the development lifecycle.
• Performs advanced requirements elicitation, develops functional requirements documentation, drafts user stories based on personal knowledge and generates stories with stakeholder input.
• Anticipates user needs and proactively develops change plans and course of action to communicate change. Adjusts customer expectations in accordance with changes in scope.
• Maintains working knowledge of project management and business analysis tools, principles, practices and procedures.
• Applies standards and best practices by continuously learning on projects and initiatives and can communicate these to stakeholders.
• Advocates on behalf of business partners to engage IT teams and suppliers to ensure solution quality and targeted business outcomes.
• Leads complex medium and large projects. Communicates project status reporting to key project stakeholders. Plans, assigns and monitors work of internal and 3rd party professionals.
• Creates a vision of project success that drives supplier engagement. Educates IT teams and suppliers on a project’s business technical context. Collaborates with geographically distributed teams.

Environment: MS Office (MS Word, MS Access, SQL,UAT, MS Excel, MS Office, MS PowerPoint, MS SharePoint, MS Visio), Tableau, Micro Strategy, Notepad++, JIRA, SAP HANA, Web IDE.

Confidential, PA

Sr.Business System Analyst

Responsibilities:

• Analyzes user requirements, procedures, and problems to offer innovative ideas, and improves, creates and designs solutions.
• Manage and communicate requirements appropriately to ensure stakeholders and the project team remain in agreement on the solution scope, how requirements are communicated to stakeholders, and how knowledge gained by the business analyst is maintained for future use.
• Created and Designed logical database schema for data warehouse environment to prepare ETL and Implemented basic SQL queries for QA Testing and Report/ Data Validation.
• Running SQL queries during the testing cycle to verify data accuracy.
• Assess proposed solutions to determine which solution best fits the business need, identify gaps and shortcomings in solutions, and determine necessary workarounds or changes to the solution.
• Responsibilities included Test Planning, Test Case development and test script execution for Integration, Regression, Performance, Functional and System Testing
• Assist business stakeholders with the generation and completion analysis of system testing scripts, including identifying use cases and developing acceptance Criteria.
• Analyzed the performance, complex data and reported data & information to effectively determine opportunities to improve outcomes used in the maintenance of organizational performance measurement system (patient safety risk management, case management and utilization management)
• Experience using Business Process Re-engineering (BPR) for improvising the existing business process
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Used the Agile (SCRUM) Methodology on the project and HIPAA standards.
• Experience in Utilization Management and Care Management along with analysis compliance from HealthCare Payers, Providers and exchange perspectives.
• Used MS Project to document the project progress and manage the project resources
• Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams using MS Visio according to UML methodology
• Created Screen mock up to illustrate new requirements and alignment around project scope using MS Visio.
• Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test
• Provided support for User Acceptance Testing with UAT cases and resolving any issues with the users and performed UAT and participated in writing test plans.
• Assess deployed solutions to see how well they met the original need so that the sponsoring organization can assess the performance and effectiveness of the solution.

Environment: LMS System,SQL, Office (MS Word, MS Access, MS Excel, MS PowerPoint, MS SharePoint, MS Visio, MS Office), Sysaid, Issue Tracker, GIS, AIS, Adhoc Reporting, Oracle 8i, PL/SQL

Confidential, Morristown,NJ

Business Analyst

Responsibilities:

• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners, document analysis, JAD sessions.
• Assessed the flaws in the existing as-is system and made clear recommendations of business process improvements and BPR, and incorporated them in the to-be system design.
• Wrote Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) documents as per the business requirements and process flow.
• Making sure current project requirements are being met by using Requirement Traceability Matrix (RTM)
• Actively involved in the creation of UML Sequence and Activity Diagrams for certain modules of the application in collaboration with design team by utilizing MS Visio and Rational Rose.
• Used Rational Clear Quest for all types of change requests, including defects, enhancements, issues and documentation changes with a flexible workflow process.
• Developed and updated data mapping document at each phase of development and logical data modeling.
• Track, escalate and remove impediments. Report at daily Scrum of Scrum meetings.
• Assisted in mapping the requirements to the source system, the DW and the applicable data marts.
• Tested the ETL Informatica mappings and ETL processes (Data Warehouse Testing)
• Assisted ETL consultant in designing and creating the database which stores the data generated from Informatica mappings delivery of individual subject areas and used Informatica for extracting data from various sources systems.
• Assisted and directly involved with QA team and UAT test strategies, including regression and integration testing, wrote test scripts, end-to-end testing scenarios and test plans, managed testing, defect reporting and change requests.
• Created Use-Cases, BPM, and Requirement documents to document the Business needs.

Environment: Rational Suite Tools, Office (MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio), Informatics, JIRA, Windows NT 4.0, UNIX, PL/SQL.

Confidential

Title: Business Analyst

Responsibilities:

• Responsible for Requirement gathering, Business Process Flow, Business Process Modeling and Business Analysis with Document and Records Management
• IT Business Analyst in Retail area with leading and supporting technical initiatives related to Retail POS Systems.
• Responsible for making decisions that can increase efficiency in delivery of quality health care services.
• Gathered requirement for Walgreens pay application and integrated with Walgreens Point of Sale (POS)
• Worked with the business community to define business requirements and analyze the functional requirements and gathered the requirement from stakeholder and SME’s
• Prepare monthly reports for Utilization/Case Management outlining case management activities, including actual vs. expected performance, potential problem areas and opportunities for improvement.
• Employed SDLC for monitoring the project and followed the step-by-step procedure
• Performed claims and trend analysis, ensured supporting documentation is accurate and obtained necessary approvals to close out claims issues.
• Maintain organization’s standard of care while providing expert care management leadership, treatment planning, and admission/discharge workflows
• Leveraged review decision tools where appropriate to automate utilization management review
• Assisted Project Manager to get CAB approval for various sprint releases.
• Prepared and presented Business Requirement Document (BRD), System Requirement Specification (SRS) and Functional Requirement Document (FRD) and involved in sign-off process
• Utilized Agile Scrum practices to help the team increase velocity by 63% within the first year of Agile adoption.

Environment: Agile (Scrum), MS Office, JIRA, Access, Outlook and Visio, In-build testing tools.

Confidential

Business Analyst

Responsibilities:

• Assisted in reviewing, testing and implementing of HRMS system needs. Collaborated with functional and technical staff to coordinate application of upgrade or fix.
• Facilitated meetings, including creation of agendas and recording of action items from meetings, received, consolidated, and produced status reports for business constituents and steering committee, etc. using MS Word & PowerPoint in the JAD Session with SMEs and researched on the process flow application.
• Prepared and analyzed "AS IS" and "TO BE" workflow scenarios and performed GAP Analysis
• Prepared graphical depictions of Use Cases, Use Case Diagrams using Microsoft Visio
• Experienced in document reviews and training, reporting, identifying defects, bugs and errors as well as suggesting improvements.
• Measures and communicates the proposed project benefits for complex projects. Quickly adapts to changes in business strategy. Accurately measures and helps business partners communicate solution value and IT contribution to key stakeholders.
• Successfully coordinating with QA, Developer and tester to construct System Integration Testing (SIT) and User Acceptance Testing (UAT) including Test Plan, test cases and test scripts to Quality Assurance Verification and Validation
• Supported a variety of reports or queries utilizing appropriate reporting tools. Assisted in development of standard reports for ongoing customer needs. Help maintain data integrity in systems by running queries and analyzing data.
• Developed user procedures, guidelines and documentation. Trained clients on new processes/functionality. Trained new system users.

Environment: RUP Model, SQL, UML, QC, Assignment Management, MS office and XML.