SUMMARY

• 6+ years of experience in Business Data Analyst.
• Strong in Software Analysis, Planning, Design, Development, Testing, Maintenance and Augmentation for various applications in data warehousing, metadata repositories, data migration, data mining and Enterprise Business Intelligence.
• Experience in Data modeling for Data Warehouse/Data Mart development, Data Preparation, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Proficient in Agile User Story writing with acceptance criteria, facilitating daily scrum, Iteration Planning, Iteration Demo, backlog Refinement and Iteration Retrospectives.
• Experience in conducting GAP analysis, SWOT analysis, Cost benefit analysis and ROI analysis and working with different software methodologies like Agile, Waterfall.
• Expertise in documenting the Business Process Modeling, Business Process Improvement, Business Requirements Document (BRD), Functional Requirement Document (FRD), User Stories. Conducting story grooming sessions, maintaining the Traceability Matrix and assisting in Post testing activities.
• Gathered Functional and Business Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mapping Documents, Data Flow Diagrams, Class Diagram and Sequence Flows.
• Involved in Supporting Product Owner in pre - grooming, Backlog refinement and product backlog.
• Well-versed in MS Visio, MS Project, Mockup screen, and Microsoft suite (Word, Excel, Access, Visio, Power Point, and Outlook) for analysis and presentation.
• Developed and executed SQL queries on customers, claims or other records to validate reporting data.
• Expertise in T-SQL functions such as rank, dense rank, row number, nitle, lead, lag, first value, and last value
• Experienced with SQL ad hoc development, stored procedures, and developing SQL queries for data mining.
• Wrote complex SQL queries to validate, create modifying table and extract data from the database for further analysis.
• Created SQL queries involving Joins, Functions and Stored Procedures.
• Used SQL to query and extract data from a variety of databases (Oracle, SQL Server) to prepare for analysis or reporting.
• Wrote SQL queries for database backend testing, research and data validation.
• Expertise in defect tracking and Requirement management tools like HP ALM, Quality Center, JIRA etc.
• Proficient in Tableau functionalities including parameters, calculations, maps, trend lines, statistics, log axis, hierarchies, Blending, Joins, Dual Axis charts, Filters, Groups, Reference lines, and Bins.
• Expertise in creating dashboard and story lines in Tableau using action filter.
• Introduced Tableau to Client to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
• Skilled in Tableau Desktop and Power Bi for Analysis, Reporting and data visualization, Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, and Density Chart.
• Strong knowledge of Word, Excel, VLOOKUP, Pivot table generation, Pivot Reporting, and advanced functions.
• Experienced in Webservices, SOAP, SOAPUI, RESTFUL, POSTMAN, WSDL technologies.
• Extensive knowledge of database design according to Normalization rules to reduce redundancy and increase data integrity.
• Hand on experience with SSIS tool loading and transforming files from flat file source to OLE DB Destination in SQL Server using conditional split, then creating tables with the right data types in SQL Server.
• Assisted QA team in preparing test plans and test cases. Experienced with different system/functional testing such as Integration Testing, Back-end testing, and UI/GUI testing.

TECHNICAL SKILLS

Operating Systems: Window 7/8/10, UNIX

Methodologies: Agile, Scrum and Waterfall

Requirement Management: Jira, HP AML, Quality Center

Business Modeling Tool: MS Visio, LucidChart

Databases: MS SQL Server, My SQL, PostgreSQL Oracle

Web Technologies: HTML, XML

Business Intelligence Tools: PowerBI, Tableau

ETL Tool: SSIS

Business Applications: MS Visio, MS Word, MS Excel, MS PowerPoint, MS Project, MS SharePoint

PROFESSIONAL EXPERIENCE

Confidential

Business Data Analyst

Responsibilities:

• Involved in business analysis and project management, coordinating between the team members and addressing budget issues.
• Provide project status reporting to stakeholders, program and project management.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Documenting interface specifications, Data Preparation, data warehouse business rules and transformations.
• Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other SCRUM related meetings. Facilitated requirement elicitation sessions.
• Provided functional and technical documentation, including BRD, FRD, User Stories and Process Flows .
• Performed business analysis to migrate legacy systems to new systems, with emphasis on data warehouse and business intelligence reports.
• Performed data analysis task using SQL queries on Enterprise Data Warehouse (EDW) and various source systems.
• Developed and executed SQL queries on claim records to validate reporting data.
• Experienced with SQL ad hoc development and stored procedures.
• Wrote complex SQL queries to validate, create modifying table and extract data from the database for further analysis.
• Created SQL queries involving Joins, Functions and Stored Procedures.
• Responsible for conversion of data in Data Mapping Documents and writing transformation rules.
• Worked on EDI transactions: 270, 271, 276, 277, 278, 834, 835, and 837 (Professional, Institutional and Dental) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment.
• Responsible for documenting the mapping and requirements of group insurance for interface and conversions between the source and applications.
• Processed EDI 837P, 837I, 834 and 837D transactions, verified 837 transactions were converted correctly from X12 to XML file format and verified the claims data loaded to Facets for further processing.
• Worked on HIPPA code sets ICD-9 and ICD-10, and HL7
• Utilized tools like Soap UI for testing web services to see if they meet acceptance criteria defined by user stories.
• Worked on the EDI 834-file load to Facets through MMS (Membership maintenance sub-system)
• Provided business and data requirement analysis including definitions for all system and report requirements to support financial functions.
• Created Dashboard and Stories using Tableau for Premium forecasting. It is to determine which factors including gender, age, region, health status, and other historical data influence the future premium. Other reports and visualizations include Fraud Detection, Revenue Comparison and Claim Analysis.
• Assisted the QA team in writing test cases and executing different types of testing such as UAT, Back-end, Regression Testing.
• Wrote SQL queries to validate data integrity during backend, and SOAPUI testing.
• Led and managed the User Acceptance Testing (UAT) for the implementation Extended Enterprise administrative system with emphasis on ensuring that the HIPAA regulations are met across all the modules
• Worked with the clients on the final signing process in the User Acceptance stages.

Environment: Agile-SCRUM, JAD, Tableau, BRD, Web Services, ETL, FSD, RESTful API, MS SQL Server, MS Office Suite (Word, Excel, Access, PowerPoint, Outlook), SSIS, MS Project, MS SharePoint, Jira, SOAP UI, POSTMAN, HTML, XML, UAT, SOAP, Oracle, Windows.

Confidential - Cincinnati, OH

Business System Analyst/Data Analyst

Responsibilities:

• Worked on AGILE environment with daily scrum meetings, grooming sessions, planning and sprint cycles.
• Facilitated Scrum Meeting, Sprint Planning Meeting, Sprint Review Meeting, and Retrospective Meeting etc.
• Elicited requirements using JAD Sessions, Survey/Questionnaire, Interview sessions, Focus Groups and analyzed the feasibility of the requirements and conducted GAP Analysis to derive requirements for ACH payment processing.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Analyze and test the legacy system to document the current state. The requirement documents were used as a base to define the web based application.
• Developed and executed the Test Cases for the requirements as part of the staging and User Acceptance Testing (UAT) environments.
• Facilitated interface requirements to capture data exchange between various systems.
• Managed software artifacts for the suite of investment products such as Online Banking and Brokerage, Insurance, etc
• Authored several documents such as Test Plan, Test Cases, Daily Defect Report, UAT Report, Closure Report
• Used SCRUM Related tools such as JIRA to create user stories, tasks and measure performance through burn down charts/velocity charts application.
• Worked on Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, Financial Cash flows, financing structure, Capital Management, Stock Valuation, etc.
• Involved depth understanding of Credit Risk management for the application
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Used SQL intensively for ad hoc development, stored procedures, data validation and generating reports.
• Prepared graphical depictions of User Stories, Use Case Diagrams, Activity Diagrams and Sequence Diagrams.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Carried out reports using PivotTable in Excel.
• Created dashboard and visualizations in PowerBI/Tableau using key performance indicators (revenues, expenses, operating profit, return on equity, return on assets, client survey score, total volume of account, etc.). Reports included drill down into performance measure for quick insights, the effectiveness of new products/pricing policies, current vs. past financial information for management to improve quality of their decision.
• Created and maintained SQL scripts to perform back-end testing on oracle database.
• Worked with Database team, involving in writing SQL queries, extracting data, creating modifying tables, functions, procedures.
• Conducted User Acceptance Testing (UAT), gathered and documented User Manuals and Business Rules.

Environment: Agile-SCRUM, JAD, BRD, FRD, SQL Server, JIRA, MS SharePoint, MS Office Suite, MS Visio, UAT, Power BI, Tableau, MS Suite (Word, Excel, PowerPoint), MS Project, MS SharePoint, SOAP UI.

Confidential

Business Analyst

Responsibilities:

• Prepared Business Requirement Documents (BRD) as well as high-level project plans and used Rational RequisitePro to manage, analyze, and convert business requirements into functional specifications.
• Assisted the Business Analyst in Requirement gathering and preparation of Use cases.
• Created Product backlog, Sprint backlog and Use cases for content management application including work flow, file management, image management and webpage layout
• Assisted in Regression Test, System Test, and UAT.
• Performed GAP analysis and carefully elaborated application enhancement specifications detailing in scope/out of scope items.
• Responsible for document management using MS SharePoint, update the document, and transmit the information to all stakeholders
• Prepared User stories, managing focus grouped exercises, facilitating brainstorming sessions, process GAP documentation, technical solution documentation and requirement traceability.
• Performed Data Mapping to map the EDI 834 data to XML.
• Analyzed the Design of FACETS data model to ensure optimal system performance and tuning.
• Worked to create interfaces and extensions for Facets Billing & Enrolment and Provider contract applications.
• Worked on developing the business requirement and requirements for FACETS batch process, automating the billing entities and commission process.
• Responsible for creation of visuals, dashboard and story lines for reports using Tableau.
• Wrote SQL queries to validate data in data warehouse.
• Involved in data analysis, data modeling, data mapping, etc. under the Data Warehouse Project.
• Involved in drawing data flow diagrams and process flow diagrams using LucidChart for the Claim Adjudication module.
• Conducted eligibility analysis of EDI (X12) 837, 834, 820, 835, 999 protocols in Medicaid and Medicare Services.
• Involved with the 837 (Claims and encounter), 835, 834, 820 HIPPA-EDI Transaction Code Sets.
• Worked on mobile application for gathering requirements and helping the UX/UI developer for developing wireframe.
• Prepared test data for positive and negative test scenarios as per application specifications and application requirements and wrote test plans.
• Participated in the bug review meetings, updated requirement document as per business user feedback and changes in the functionality of the application.
• Organized meetings to discuss outstanding issues with QA team and developers.
• Coordinated with the development team in documenting End User Manual.

Environment: Agile/Scrum, FACET, JAD, BRD, FRD, SQL, HP ALM, Tableau, LucidChart, MS Office Suite (PowerPoint, MS Word, MS Excel)MS Project, MS SharePoint.