SUMMARY

• 8+ years of Industrial experience as a Business Analyst across various domains including Auto Finance, Health care, and Insurance.
• 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.
• Experienced in providing comprehensive technical consultation to business unit and IT stakeholders through all phases of a project and/or a process.
• 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.
• Experienced in creating Business Requirement documents, User Specification documents, Functional Requirement Documentation.
• Extensively involved in developing BPMN workflows, 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
• Experienced in performing GAP Analysis of the AS-IS and TO-BE process to identify and validate the requirements.
• Ability to engage with stakeholders, particularly Business Team / SMEs / Product Owners, to prioritize work for input into IT release planning.
• Hands on experience on JIRA for managing user stories, Bug tracking and confluence for document management.
• Excellent knowledge on claims process and adjudication in the Medicare, Medicaid, CMS and Private Insurance Sectors
• Excellent knowledge and experience of creating source to target mapping, edit rules and validation, transformations, and business rules.
• .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.
• 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).
• Functional knowledge in Microsoft Project, Visio, MS Office, MS SharePoint and Macromedia Dreamweaver.
• Excellent at using MS Office Products, MS Project, Visio. Additionally, advanced Excel Skills like building models using: macros, tables, pivot tables, v and h lookups, sum ifs, if/then statements.
• Experienced in Software Quality Assurance, Knowledge Management, Service Management, Client Management and SDLC activities.
• Good working knowledge of HIPAA ICD10 and HIPAA transaction requirements.
• 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)
• Handled QA testing such as User Acceptance Testing (UAT), Performance testing, Functional testing (FT), System access testing, Unit testing, and stress/load testing.
• Extensive experience in development of test cases, test plans and test scripts based on the business requirements and technical specifications.
• Solid understanding in creating of Stored procedures, views, functions, triggers depending upon the project requirement.
• 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.
• Proficient knowledge on html, CSS for UI development of the applications, understanding of http status codes.
• Experienced in Business/Systems analysis, project scope definition, business information management, business production support, business content configuration and business quality assurance testing.
• SME for Project planning, Execution, and Risk management, Agile, Software Configuration Management, Release/Change (ECM)/Incident management and business processes re-engineering.
• Proven ability to deliver high quality IT products on schedule and under budget with excellent skills in managing multiple projects and mentoring one or more project teams (on shore and off shore project team).
• Highly organized, detail oriented, and a self-starter with proven ability to manage multiple priorities.
• Ability to work under pressure, think independently, multi-tasking (managing multiple projects), excellent analytical, communication and negotiation skills and rapidly adapting to new technologies, ideas, and act as “Go to Guy”.
• Strong problem-solving/troubleshooting, CM processes and approaches for continuous process improvement.
• Strong communication skills - proven ability to provide concise, summarized communication in written or verbal form to those who need it.
• Ability to deliver results in a complex, fast-paced, multi-team environment.
• Strong interpersonal and coaching skills with proven ability to effectively facilitate meetings with varying levels of management and number of participants

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

Agile Tools: Rally, Jira

Languages: 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

Tools: & Platform: MS Office, HPALM, Serena Business Manager, SharePoint MS Outlook, MS Visio, Axure RP,Daybreak, FICO Blaze, Subversion, PL SQL, Linux/Unix, WebLogic, Java/J2EE, Tomcat, Jira, SSIS, SSRS.

Responsibilities:

• Responsible for eliciting, analyzing, and communicating requirements among business users, IT colleagues and third-party vendors
• 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, 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.
• Supported testing of new solutions by coordinating with development and QA team members to ensure test plans and test cases reflect business requirements. Acts as point of contact for business users during user acceptance testing.
• Used Jira as a tracking tool for planning and tracking our project, managing user stories, and issued bug tracking.
• Worked with business users and developers to identify data mapping needs and data management initiatives. Ensures data requirements are accurate and complete. Assists with investigating and resolving data integrity issues such as missing or inconsistent data.
• Facilitated discussions with business users and project teams to identify process improvement opportunities and align process changes with system changes. Contributes to change management activities to prepare the business to use new system solutions and new or modified business processes.
• Submitted change requests/tickets and allocate them for upcoming deployments/releases
• Planned, facilitated, and executed system / functional testing and UAT for projects and enhancements.
• Involved in the development of UI layout and front-end programming (HTML) for web application that matched requirements.
• Actively participated during the production releases of the products and provided go-live support during production deployments.
• 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.
• 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 upgrading from SQL Server 2008 to SQL Server 2012.
• Intensively worked on transformations like derived columns, import columns, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• 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.
• Involved in the development of UI layout and front-end programming (HTML) for web application that matched requirements.
• Updated QA Leads on weekly basis with the testing status which included Defect management and test Metrics.
• Tested the Applications compatibility on different browser versions of IE, Firefox and Safari.
• Answer questions and clarify requirements for projects and enhancements during the estimation process.
• Helped in creating long-term support structure and plan.
• Ability to multi-task and help execute on multiple projects in parallel
• Ability to learn new business areas and systems quickly
• Performed other duties as required or assigned

Confidential, Irvine, CA

Sr. Business Analyst/ Release Coordinator

Tools: & Platform: MS Project, HPALM, ITSM, SharePoint, MS Outlook, MS Visio, JIRA, Microsoft Lync, Access, Security Exception, Auto way, Unix/AIX/Solaris/JEUS, MySQL, PVCS, Java/J2EE,Rest,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.
• 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.
• 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.
• Involved in design and development of data base and worked on Rest domain and DAO layers for mapping the data.
• Created API mapping and documents for various billing plans and for the payment api and the gateway used.
• Worked on web service designs for integrating with various 3rd Party Data apis such as Google and YouTube data apis. Also test the web services end to end and performed UAT of application using the apis after functional testing.
• Involves in creating documents for integrating the Rest Layer with SOAP Web services from back end and databases for providing various services.
• Used SOAP UI for testing the end points for the SOAP services via wsdl file and provided front end users with the wadl for the rest layer.
• 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.
• Performed User Interface testing to make sure that the final product was in line with the business needs and their requirements.
• Worked with the developers in the unit testing of the application, performed system integration testing, system testing and User Acceptance Testing.
• Conducted iteration kick-off meetings with business users, project managers, Development teams, and QA teams.
• Worked on key deliverables like Release Planning Meeting, Release Strategy, Release Plan, Release Readiness, GO/NO-GO Meetings, and Release Closure
• Familiar with Agile (Scrum) and/or Lean software development processes and tools
• Worked with engineering teams and PM's to identify and compile functionality (features, bugs, upgrades, etc.,) that are planned for a major release.
• Worked hand in hand with QA, Build, Engineering, and Operations teams to manage the release to a successful outcome
• Create, publish, and maintain release plans and deployment calendar for assigned services including key milestones, cut-off dates and dependencies
• Schedules/Leads daily Release Management triage meeting to track all the issues and assign them to the right resource and bring them to closure
• Ensured appropriate deployment plans and supporting details are recorded and disseminated across multiple teams
• Created UAT/QA test plans, strong manual, functional, system and regression testing in an agile development environment.
• Gathered appropriate level of details required for release and prepare to represent those plans in cross-team integration meetings or to stakeholders as needed
• Identify and work through release impediments and risks, utilizing escalation paths with delivery teams and other release stakeholders as needed to resolve
• Proficiency with Microsoft Project, SharePoint, Visio & Office Suite (Word, Excel, Outlook, PowerPoint, etc.,)
• Previous experience working with remote employees and developing processes for cross-functional teams
• Made good, timely decisions in relatively complex situations
• Proven ability to solve complex problems, spanning multiple teams and departments

Confidential - Minneapolis, MN

Business Analyst

Environment: /Tools: Windows NT/2000, MS SQL Server, Rational Unified Process (RUP), UML, HP ALM, DB2UDB, Requisite Pro, Mercury Quality Center Test Director, Clear Quest, MS Office Tools, MS Outlook, Java, Rally

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.
• Involved in defining the source to target data mappings, business rules and data definitions, System rules/validation, user interface requirement type, output requirement type.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• 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 in the Functional Design documents based on the business requirements.
• Prepared and executed different Test Cases and Test Scripts
• Involved in conducting Functionality testing, Integration testing, Regression testing and User Acceptance testing (UAT).
• Provided analysis and insight to QA Team in defects and bugs tracking

Confidential, Chicago, IL

Business Analyst

Environment: MS Visio, Excel, MS office, Rational Rose, DB2/SQL server/Sybase,Dreamweaver, Rational Unified Process (RUP), ETL, Agile, 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.
• Utilized RUP methodology during the project life cycle and worked together with RUP mentors at the location.
• 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.
• Provided business and technical suggestions and recommendations during the project life cycle.
• 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.
• Involved in performing several database tuning tasks and built reports using PL/SQL.
• Involved in back end testing writing SQL queries in TOAD against Oracle database to extract information about specific tables to know the order status and recommended changes to the PL/SQL code.
• Responsible for Production and Non-Production, OS/DBMS, EOL migrations on DB2/SQL Server/Sybase Systems.
• Involved in adding new descriptive flex fields in Order Entry to capture additional data.
• Involved in a lot of stress testing to find out the performance of the Order Management as to whether it could handle load of 5000 orders within the SLA. code.
• Involved in adding new descriptive flex fields in Order Entry to capture additional data.
• Involved in a lot of stress testing to find out the performance of the Order Management as to whether it could handle load of 5000 orders within the SLA.
• Extracted large volumes of data from legacy systems and uploaded into the Oracle database using SQL*Loader and PL/SQL.
• Ran SQL queries to check the results of the involved database.

Confidential

Business Analyst

Tools: & Platform: MS Visio, Excel, MS office, MS Access, Rational Rose, Dreamweaver, Rational Unified Process (RUP), ETL, Agile, SQL Server, Informatica..NET, Mercury Quality Center, ARGUS, MedDRA, J2EE, HTML/XML

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 (eg. 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..
• Used the guidelines and artifacts of the SCRUM methodology for project implementation and development.
• 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.
• Worked as an SME for identifying the scope of End-to-End testing with different teams
• Coordinated UAT of the product with Business Users