SUMMARY:

• 8+ years of Industrial experience as a Business Analyst across various domains including Auto Mobile, Ecommerce , Health care.
• Solid understanding on Software Development Life Cycle(SDLC) including Requirement Gathering, Analysis, Design, Development, Testing, User Acceptance Testing (UAT) and post - Implementation validations.
• Well Versed in SDLC methodologies including Agile/Scrum/Waterfall, Rup methodologies.
• Experience in facilitating Joint Application Development(JAD),Interviews, Workshops, Joint Requirement Planning (JRP )Sessions with Business Users, Stakeholders, and Subject Matter Experts.
• Proficient at providing documentation support including analyzing user needs to determine functional requirements, updating and maintaining existing technical application documentation, and determining any new system documentation required to meet the projects requirements.
• Extensively involved in developing Use case diagrams, Activity diagrams, Sequence diagrams, ER Diagrams in MS Visio.
• Experienced in developing business process maps, and AS-IS and TO-BE process conceptualization and improvements.
• Hands on experience on JIRA for managing user stories, Bug tracking and confluence for document management, creating Wiki instruction pages .
• Excellent Knowledge of Agile Backlog Grooming, Release Management & Sprint Planning, Estimation Velocity and Change Management.
• Good Knowledge of REST API's and have implemented Transactional/Non transactional services and have worked on creating API Documentation.
• Experience working with Restful Web Service.
• Proficient knowledge on html, CSS for UI development of the applications, understanding of http status codes.
• Experience as a Data Analyst / ETL/ BA, with Progressive responsibilities in data analysis with focus on financial reporting, and Data warehouse (DW), business intelligence (BI).
• Solid understanding in creating of Stored procedures, views, functions, triggers depending upon the project requirement.
• Hands on experience in SQL performance tuning by query optimization, building database maintenance plans.
• Excellent knowledge and experience of creating source to target mapping, edit rules and validation, transformations, and business rules.
• Advanced Excel Skills like building models using: macros, tables, pivot tables, v and h lookups, sum ifs, if/then statements
• Experienced in MS Visio, Rational Rose, Rational Clear Case, Rational Requisite Pro, Rational Clear Quest, MS office Suite (MS Word, MS Excel, MS Visio, MS Project & MS SharePoint )
• Experienced in creating rich interactive visualization reports and interactive dashboards such as pie-charts, Bar Graphs, Waterfall Charts, Funnel Charts, Heat Maps in Tableau.
• Excellent knowledge in developing Drill down and Drill through reports in SQL Server Reporting Services.
• Handled QA testing such as User Acceptance Testing (UAT), Performance testing, Functional testing (FT), System access testing, Unit testing, and stress/load testing.
• Solid understanding on Medicare, Medicaid, and commercial insurances in HIPAA ANSI X12 formats
• Excellent understanding with HIPPA X12 EDI transaction codes 270/271, 276/277, 834, 835, 837.
• Strong understanding of medical coding and transition from ICD 9 - ICD 10.
• Highly organized, detail oriented, and a self-starter with proven ability to manage multiple priorities.

TECHNICAL SKILLS:

Front end tools: Microsoft Project, Microsoft Visio, Remedy, ITSM

Methodologies: Agile, Scrum, Waterfall

Business Skills: Requirement Gathering, Gap Analysis, Risk, Impact Analysis, Process Flow Analysis and Design.

MS Office Tools: MS Outlook, MS Word, Ms Excel, MS Access, MS PowerPoint

Software Quality Management Tools: HPALM, JIRA, Bugzilla

Operating Systems: Linux, Windows, Mac OS X

Database: PL/SQL, Oracle, MS Access

Web Design: HTML, DHTML, XML,XSD,JASON

Agile Tools: Rally, Jira, IBM DOORS

Webservices: Soap, Rest

Languages: SQL, T-SQl Java.

BI Tools: Tableau, SSIS, SSRS

UML Tools: Rational Rose / Microsoft Visio / Enterprise Architect 4.0

Rational Tools: Clear Case/ Clear Quest, Requisite Pro, SharePoint

Other Tools: SharePoint, Serena Business Manager(SBM), Team Track

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Sr. Business Systems Analyst

Responsibilities:

• Responsible for eliciting, analyzing, and communicating requirements among business users, IT colleagues and third-party vendors
• Studied existing business application and processes, current source system, collected end user requirements and suggested the improvised business process model.
• Served as a liaison between the business areas and the IT organization to provide system solutions and process improvements to meet business needs.
• Facilitated JAD sessions with management, SME, vendors, and other stakeholders for open, pending and critical issues .
• Worked in transforming business requirements into user requirements specification, Functional Requirement Specifications Document.
• Worked closely with business users and IT project teams, including project management, development, and QA team members. Creates documentation suitable for their use, including process diagrams, State diagrams, workflows, wireframes, UML models, use cases, business, functional, and non-functional requirements.
• Acted as technical point of contact to business users with respect to system functions and features. Provided guidance regarding system capabilities and configuration. Liaises with vendors to address system defects and requested system enhancements.
• Create sketches, usage scenarios, user flows, wireframes, mockups, and prototypes to optimize the way users interact with the website from conceptualization to implementation.
• Coordinated with UX designers to update UI as per needs and requirements.
• Involved in the development of UI layout and front-end programming (HTML) for web application that matched requirements.
• Present designs to stakeholders for approval, then finalize designs with supporting annotations for developers.
• Used Jira as a tracking tool for planning and tracking our project, managing user stories, and issued bug tracking.
• Assisted in some of the Product Owner activities by providing high level estimates, prioritizing stories for the sprint and maintaining backlogs and release plans
• Involved in the development of UI layout and front-end programming (HTML) for web application that matched requirements.
• Developed REST service documentation using Swagger UI and developed test cases using Junit frameworks.
• Planned, facilitated, and executed system / functional testing and UAT for projects and enhancements.
• Ran SQL queries as required for reading, loading, updating and testing data residing in different databases (Oracle, SQL Server).
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions, and functions.
• Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SQL Server Reporting Services (SSRS).
• Created the User Acceptance Test plan and conducted the user acceptance testing for the final confirmation of the project from the Business and SME.
• Depicted the requirements in HP-Quality center and helped QA testers to map the requirement to the test case accordingly.
• Updated QA Leads on weekly basis with the testing status which included Defect management and test Metrics.
• Actively participated during the production releases of the products and provided go-live support during production deployments.

Confidential, Irvine, CA

Sr. Business Systems Analyst

Tools: & Platform: MS Project, HPALM, ITSM, SharePoint, MS Outlook, MS Visio, JIRA, Microsoft Lync, XML, XSD,Access, Security Exception, Auto way, Unix/AIX/Solaris/JEUS, SQL, PVCS, Java/J2EE, SSIS, T-SQL,TableauRest, Axure RP, Soap Webservices, WebSphere, Weblogic, Tomcat, Jboss, Apache

Responsibilities:

• Managed multiple Project teams through the life cycle of an enterprise release, working closely with leads from the technical application team, Quality Assurance, outside vendors and impacted business areas
• Responsible for the coordination and communication of releases across set of services with all the stakeholders
• Interacted with the business teams to gain knowledge about the existing system and understand their need.
• Created MS Visio flow diagrams to depict the current business process and then documented the AS-IS process. performed GAP Analysis of the AS-IS and TO-BE process to identify and validate the requirements.
• Designed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams to define the Business process.
• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS. Conducted user interviews, understood and articulated business requirements and further converted requirements into technical specifications.
• Conducted iteration kick-off meetings with business users, project managers, Development teams, and QA teams.
• Responsible for translating Business Requirement Documents into functional specifications and test plans. Closely coordinated with both users and developers for arriving at mutually acceptable solutions.
• Setup bi weekly sprints in Jira for team’s Agile Scrum environment and conducted sprint review session to discuss the challenges faced and how one can go about improving upon them in next sprint.
• Involved in prioritizing the user stories based on the business values, estimating the story points, conducted release planning meeting to develop features list.
• Participated in Daily standup calls to check update the status of each user story.
• Involved in creating API documentation with API properties and datatypes for the development teams.
• Created API mapping and documents for various billing plans and for the payment API and the gateway used.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Involved in Creating and Updating database objects like tables, views, stored procedures, function, packages.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Tableau for analyzing, reporting, and transforming data, Created dashboards and worksheets in tableau.
• Created interactive charts and dashboards for payments and order data, created future forecasting based on graphs generated using tableau.
• Worked with the developers in the unit testing of the application, performed system integration testing, system testing and User Acceptance Testing.

Confidential, Minneapolis, MN

Business Analyst

Environment: /Tools: Windows NT/2000, MS SQL Server, Waterfall, UML, HP ALM, DB2UDB, Requisite Pro, Mercury Quality Center Test Director, Clear Quest, MS Office Tools, MS Outlook, MS Project, Java

Responsibilities:

• Extensively involved in the implementation of effective requirements practices, including gathering User Requirements, and analyzing User Requirement Document (URD), and functional specification document (FSD), use and continuous improvement of a requirement gathering processes
• Applied RUP methodology with its various workflows, artifacts, and activities to manage life cycle from Inception to Transition phase
• Employed UML methodology in creating UML Diagrams such as Use Cases, Sequence Diagrams, and State Diagrams, Activity Diagrams and business process and workflows
• Converted MS SQL server data tables into SAS data files using SAS SQL
• Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA.
• Involved in GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
• Gathered requirements and developed use cases by interacting with different functional groups for ICD 9- ICD10 conversion.
• Created UI specification document for the business users to feed data into healthcare web application.
• Tracked all the reports, files and extracts exchanged between vendors. Identified the location, purpose and requirement change after the ICD 10 updates are performed on the data.
• Gained good understanding on HIPPA standards, EDI formats, plans, benefits, and healthcare products .
• Worked on EDI transactions: 270, 271, 835, and 837, to identify key data set elements for designated record set
• Monitor DB2 UDB processes and logs for any anomalies, provide corrective actions.
• Assisted team lead in developing Requirements Traceability Matrix (RTM) to trace the relationship between business and functional requirements to test cases.
• Document all data mapping and transformation processes of the legacy systems in the Functional Design documents based on the business requirements.
• Involved in conducting Functionality testing, Integration testing, Regression testing and User Acceptance testing (UAT).

Confidential, Hartford, CT

Business Analyst

Environment: MS Visio, Excel, MS office, MS Project, Rational Rose, DB2/SQL server/Sybase, Dreamweaver, Waterfall, MSOffice, ETL, SQL Server, Informatica.

Responsibilities:

• Worked on analysis of the Facets claims processing application to gather requirements to comply with HIPAA 5010 requirements.
• Analyzed HIPAA 4010 and HIPAA 5010 standards for 837P, 837I and 835 transactions and prepared gap analysis document for each transaction.
• Wrote high level and low-level business requirements for the project.
• Supported developers with creating database objects like Tables, Triggers, and Indexes using T-SQL Management Studio.
• Analyzed the existing data model and provided suggestions and recommendations
• Worked with the solution architect to understand the existing data model and modify the data model to accommodate the required 5010 changes.
• Dealt with data mapping issues between various source systems and staging area and data marts
• Worked with data mapping team to create data maps for data integration task i.e. transformations.
• Utilized Mercator as an EDI mapping tool to map the claims data that passes through the EDI gateway to the Facets claims processing application.
• Conducted meeting with the EDI team and other stakeholders team members to discuss the requirements
• Responsible for transforming data from OLTP to OLAP data sources using SSIS.
• Involved in meetings with product manager, project manager, onsite and offshore team members to resolve issues and roadblocks during the project.
• Used Rational Requisite Pro for overall Requirements Management and to build the Requirements Traceability Matrix.
• Involved in identifying the integration points within the organization as required for the project, involved in preparing test cases and UAT.
• Worked closely with the business team, development team and the quality assurance team to ensure that requirements are understood as intended in order to achieve the desired output.

Confidential

Business Analyst

Responsibilities:

• Obtained business requirements from business users and stakeholders using JAD sessions, brain storming sessions, focus groups and personal interviews to get a better understanding of the client's business process.
• Worked with the business to document and develop formulas for the calculation of premiums and losses statistics in the marts (e.g. Written Premium, Earned Premium, Unearned Premium)
• Elicited, documented, modelled, validated, and prioritized functional and non-functional requirements using interviews, data analysis, and different modeling tools.
• Actively involved in preparing and writing the business requirement documents, functional requirement documents and data mapping documentation.
• Performed in depth data analysis identifying data issues in legacy system and worked with business to develop resolutions to those issues.
• Used MS Project for status reporting and planning.
• Utilized MS Visio for designing Use Case Diagrams, Activity Diagrams, and Sequence Diagrams, after accessing the status and scope of the project and understanding the business processes.
• Analyzed the as-is and to-be state of the project and performed Gap analysis, Impact analysis and SWOT analysis.
• Created data mapping documents for the movement of data from production databases to the warehouse and from the warehouse to the policy and claims marts.
• Wrote PL/SQL Queries to get Schedule of policy payment and defaults.
• Assisted System Architects and Quality Assurance Analysts in creation of various tests.
• Assisted in deletion of defects and bugs, to meet specific requirements and deadlines for successful execution of the project, Coordinated UAT of the product with Business Users