Objective

• Seeking role as a Business Analyst / Business System Analyst to work with the IT project team to gather, analyze and implement business requirements into the software application development process.

SUMMARY

• Over 8 plus years of experience as a Business Analyst/Data Analyst/Business System Analyst.
• Performed business analysis, support and conducted testing and data entry associated with configuration and maintenance of the Facets Provider.
• Facets support systems were used to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834, 835 & 837 transactions
• Familiar with HIPAA - compliant healthcare transaction sets 270/271 (Eligibility enquiry and Response).
• Clear understanding of ICD-9-CM and ICD-10-CM/PCS
• Excellent knowledge of claim processing and EDI transactions, code sets and EDI Implementation guides in Healthcare industry.
• Excellent organizational and interpersonal skills to communicate with developers, testers and other team members.
• Applied knowledge of SDLC like Waterfall, SOA and Agile.
• .Experienced in creating User Stories and product back log using scrum methodology.
• Experience working with off-shore, on-shore and virtual teams.
• Defined the requirements and assisted DBAs and developers with data modeling and data migration.
• Participated in Business analysis planning and Monitoring, Elicitation, and translating end user requirements into user stories, also participated in the Business process modeling, Solution assessment and validation, Technical design specifications & Data modeling.
• Ability to provide clear, easy and detailed analysis to improve processes systems and methodologies currently in place.
• Expertise in writing BRD, FRD/NFR based on user requirements
• Data analysis, Gap analysis, Data profiling of source and target systems
• Created templates and collected Metadata such as data dictionary, business glossary and created Source to target mappings
• Extensive experience of working in OLAP (Data warehouse, Data Marts etc) and OLTP (ODS, Data Hub, Application Databases etc) environments
• Extensive understanding of Dimensional modeling(demoralization) concepts like Star Schema, Snow Flake schema and Data warehousing strategies like Top Down (Bill Inmon) and Bottom up (Ralph Kimbal).
• Identified requirements for Dimensions and Fact tables to fulfill reporting needs
• Gathered data requirements for Historical data (simple history, complex history), Data security and Data retention
• Extensive knowledge of data modeling using normalization forms like 1NF, 2NF, 3NF for OLTP systems
• Extensive experience working in Master Data Management environment to create 360 degree view of customer data
• Identified data domains and reference data needs for MDM solutions
• Created cleansing, matching and merging policy for de-duping redundant records to create Golden record
• Created Data quality metrics and Data Profiling and Data Cleansing
• Extensive experience writing complex SQL queries for Data analysis using analytics functions(SUM, MAX, MIN, AVG, LAG, LEAD, PARTITION Over) and SQL constructs ( Common Table Expression, Union, Union ALL, FULL/LEFT OUTER JOIN, group By, Having clause)

PROFESSIONAL EXPERIENCE

Confidential, Eagan, MN

Sr. System Analyst

Environment: RXCLAIMS, ATQ, SQL, MS Office, MS Project, MS Access,Axure, JIRA,QC, Scrum (Agile) implementation, & IBM Notes

Responsibilities:

• Analyzed the existing data needs and data model and provided suggestions and recommendations.
• Produced System Diagrams, Business Requirements, Report Specifications, Workflows and other documentations as required for Project Analysis, Planning and Design.
• Created Wireframes and Mockup Screens (UI design) of Web Portals also translated the business needs into technical/data requirements as part of the JIRA stories.
• As a liaison between the developers and management, was instrumental in resolving conflicts between stakeholders and technical development teams.
• Developed source-to-target mapping and data transformation logic, documents standard calculations, and communicated these requirements to the design and build teams.
• Designed and maintained Meta data documents on team site for unison in design and implementation of Data Model.
• Developed Data Mapping Documents to depict Data Flow between energy usages.
• Scheduled meetings with developers, systems analyst and testers to collaborate resource allocation
• Reviewed test cases for QA and provided assistance while testing.
• Involved in testing HIPAA Database, which incorporates all the HIPAA (Health Insurance Portability and Accountability Act) transaction sets.
• Assist development team with designing the application to meet end user business needs
• Prepared Test cases, according to the business specification and HIPAA standards. And also tried to cover requirements in EDI forms to be available across organization

Confidential, Edenpraire, MN

Sr. Business System Analyst

Environment: Rally,.Net, UML, SQL, MS Office, MS Project, MS Access,Axure, ADR, Scrum (Agile) implementation, UAT, XSD, XML, WSDL, Plan source & Content Management.

Responsibilities:

• Involved in the meeting with Business process owners and SMEs (subject matter experts) for scope identification and requirements gathering in initiation phase of the projects
• Performed various demonstrations of application and Access prototypes to business users while application is getting ready for release.
• Analyzed the existing data model and provided suggestions and recommendations.
• Assist development team with designing the application to meet end user business needs
• Responsible for conducting GAP analysis between requirements & accounting policy/test cases
• Responsible for developing various documents during different phases of development life cycle- such as Scope document, Business/Functional requirements document; Interface control documents; Test Plans; Test Scripts; Requirement Traceability Matrix and Test Summary Reports according to SDLC compliances
• Responsible for performing various data reconciliation processes to ensure that application/s built generates expected results.
• Involved in defining the source to target Data Mappings, Business rules, and Business and Data definitions.
• Framed a detailed agenda for Joint Application Development (JAD) and brainstorming sessions as requirement elicitation technique.
• Developed Test Plans, Test Cases, and Expected Results, and coordinated the tests with the QA team to verify implementation of new features and enhancements.
• Responsible for performing various testing activities such as system test; user acceptance test and integrate user acceptance test (UAT).
• Designed queries to manipulate and migrate data from different legacy databases to Enterprise Data Warehouse (EDW)
• Assisted with Test Cases and developed strategies with Quality Assurance group to implement them. Efficiently responded to client inquiries and resolved discrepancies. Identified, prioritized, tested and proved essential business functions to assure compliance with vendor and internal auditing
• Worked with the technical and business staff to produce Test Scripts, Configuration and Change Management Plan documents.
• Also responsible to the user group for special requests and program maintenance, where Involved in verifying the Web Services used in the application and used Rally for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Prepared Test cases, according to the business specification and HIPAA standards.

Confidential, Richfield, MN

Sr. Business System Analyst

Environment: Quality center 10.0,Web/Mobile Application,.Net, UML, SQL, MS Office, MS Project, MS Access,Axure, SharePoint, Perfecto Mobile, Scrum (Agile) implementation, UAT, HIS,XSD,XML,WSDL Informatics Power Center 9.1/8.6,, Data Warehouse.

Responsibilities:

• Involved in the meeting with Business process owners, SME (subject matter experts) and marketing team for requirements gathering in project definition Stage for the new dental module.
• Followed existing templates, formats and procedures and helped in improving them for meeting project needs.
• Created Wireframes and Mockup Screens (UI design) for Web Portals
• Developed process model and detailed business policies.
• Worked on the user stories specific to the Security concerns i-e Session timed out. Also added multiple features (secured url and security icons) to our application in order to ensure security/privacy.
• Gathered data requirements regarding needed data elements, data history, and retention and data security.
• Prepared the Business Workflow using MS-Visio with input, output, and Pre and Post conditions.
• Created data mapping document for our existing system and to be system. And Participated in data analysis for verification purposes.
• Provided SDLC Methodology for developing HIPAA EDI applications used by hospitals to completely automate payments posting for Medicare, Medicaid and commercial payers electronic payments files.
• Configured the modules as per the client needs for the benefits of Facets provider.
• Worked on the integration of our data with the third party system (Fairview, 3M etc)
• Used the mapping tools to map 4010 and 5010 transactions along with ICD 9 and ICD 10 codes, and validated the HIPAA Syntax.
• Validated Hospital Inpatient, Medical and Outpatient claims data in SDS Quick Claim application entered in Meta Vance.
• Worked with the solution architect in order to understand the existing data model and modify the data model to accommodate the required 5010 changes.
• Involved in testing HIPAA Database, which incorporates all the HIPAA (Health Insurance Portability and Accountability Act) transaction sets
• Conducted GUI/Usability Testing and Black Box Testing according to specifications.

Confidential, Bloomington, MN

Business System Analyst/ BA

Environment: CRM, UML, SQL, MS Office, MS Project,.Net, MS Access,Axure, SharePoint, Perfecto Mobile, Scrum (Agile) implementation, SOAP Tester,XSD,XML,WSDL Informatics Power Center 9.1/8.6, Data Warehouse, IBM Congas 10.2.

Responsibilities:

• Worked as a liaison between product owners, project sponsors and project management and successfully deployed end product in for one of our client located in japan.
• Conducted meetings and discussions with program managers, application owners and business users to identify business requirements, use cases and to develop functional specifications. Identified and documented dependencies between various business processes.
• Prepared Business Requirement Documents (BRD), Functional Requirement Documents (FRD), System Requirement Documents (SRD) and system mock-ups for detailed expansion of business processes and application functionalities, which included ecommerce based web portal. Performed requirement walkthroughs with the technical and testing team to develop testing strategies and test plans such that test cases reflect user needs.
• Documented use case specifications on the basis of requirements gathered from stakeholders.
• Create scope document, project charter and Business Case Template (BCT).
• Conducted requirement gathering sessions with the purpose of creating and defining the Business Decision Document (BDD) and the Functional Requirement Document (FRD). and project completion using MS Project.
• Used Business Intelligence tool Cogon’s to prepare reports for management.
• Helped co-business analyst in drawing data flow diagrams and process flow diagrams using MS Visio.
• Helped project manager with MS Project for developing schedules using Gantt charts and helped the process team in developing methodology and lifecycle for the processes of testing and quality assurance.

Confidential

Sr. Functional Business Analyst

Environment: CRM, UAT, CALT, Java/J2EE, Agile/Scrum, SharePoint, QualityCenter10, UNIX,QNTX, Windows, XSD,XML,WSDLSQL & My SQL Server.

Responsibilities:

• Responsible for Gathering Requirements from SME, Stakeholders and Executive Sponsors to produce Business and Functional Requirements.
• Participated in Primary and Secondary Research to determine User Requirements and Goals and converting them into Business and Functional Requirements.
• Worked in different models of facets configuration like Payer and Provider modules.
• Conducted Requirement analysis and Design Walkthroughs with the designers, developers and management staff.
• Followed the UML based methods using MS Visio to create Business flow diagrams, Use Case diagrams, Activity diagrams, State diagrams, Sequence, and Collaboration Diagrams.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Reviewed HIPAA compliant guidelines and procedures with teams.
• Interacted with Test team to ensure the guidelines were met for HIPAA
• Analyzed and worked with HIPAA specific EDI transactions for claims, member enrollment, billing transactions. Worked specifically with 837, 835 & 834.
• Managed on going implementation of vendor outsourcing claims pre-processing & EDI gateway processes, including transformation to FACETS ready formats for upload into FACETS.
• Develop, coordinate and support Information Technology Division on all operational requirements of FACETS Providers claims processing system with respect to reporting specifications and production management.
• Ensured that the facets configuration was created and maintained in a manner that supports the departmental, user and overall business objectives in coordination with other system vendor products.
• Performed System Integration and Regression Testing for the Microsoft BizTalk 2002 applications. These are developed to perform EDI translation from ANSI ASC X12 layout to MMIS (Medicaid Management Information Systems) fixed-width record format.
• Experience in Business process Analysis.
• Translated and transferred requirements from Business Need Document (BND) to Business Requirements Document (BRD).
• Designed Activity, Sequence and Process Flow Diagrams using MS Visio to simplify and elaborate certain selection criteria and filter conditions.
• Extensively worked with HIPAA Privacy FACETS application groups.
• Utilized RUP to configure and develop processes, standards, and procedures, to provide technical leadership and expertise in reorganization of a complex End-to-End Testing effort, and to perform system analysis and organizational review of existing QA processes.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Entered numerous claims for testing purposes to ensure accurate and quality adjudication and implementation of business and operational requirements.
• Documented the dimensional models of ETL system.
• Led the testing efforts of the datamarts in development, coordinated moving/setting up of processes in dev/qa/production. Worked with QA team and UAT team to go over the various test scenarios for different types of loads in the datamarts.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment
• Prepared and Reviewed Business Requirement Documents and the Technical Specifications using Rational Requisite Pro.
• Assisted the development team during the second and third iteration using the RUP model.
• Involved in Functional System Testing, Integration Testing, Regression Testing, and User Acceptance Test using the test cases
• Assisted the prep team in sprint planning and deciding the duration of the sprints.
• Managed the progress of the sprint backlog and added incomplete requirements into product backlog at the end of each sprint.
• Facilitated meetings with the product owner, scrum masters, project coordinator, SMEs and testing teams.
• Wrote high level use cases for the purpose of testing and assessed testing team for understanding the requirements.
• Helped sorting the reviewed user stories into product backlogs prioritizing them on the basis of the business requirements.
• Facilitated daily scrum meetings and kept track of the meetings.
• Held the sprint retrospective meetings, reflected upon the past sprint and what could be improved.

Confidential

Business System Analyst/ BA

Environment: Advanced Rest-Client,UAT, XSD,XML,JSON,WSDL,Agile/Scrum, Jira, QualityCenter10.0, WADL, WindowsOracle, SQL, Web/Mobile Application & Fish Eye.

Responsibilities:

• Worked directly with portfolio managers and was involved in learning information about portfolio modeling, electronic trading, pre-trade compliance and unparalleled access to liquidity and other investment and operations professionals.
• Worked heavily on SQL server database to extract data and build business reports.
• Prepared Business Requirement Documents (BRD), functional and nonfunctional requirement documents, process flows, business and system use cases.
• Analyzed data and created both class diagrams and ER Diagrams for designing databases called Microsoft SQL Server 2008.
• Prepared business cases, use cases, business and technical architecture, state charts, wire frames, activity diagrams, story boards and UI screens. Also, interviewed stakeholders, conducted JAD sessions and used BPM, UML and MS Visio. Prepared and delivered presentations to support other functional departments like sales and marketing.
• Used iterative life cycle methodologies and processes including RUP, Unified and Agile.
• Performed risk analysis to identify the business critical and high-risk areas of the application.
• Conducted presentations of QA test results with analysis to the stakeholders and users and documented modifications and requirements.
• Analyzed Business Requirement Document (BRD), Functional Specification Documentation and System Requirement Documentation.
• Helped maintain and prioritize lists of outstanding application issues and user enhancement requests. Conducted GAP analysis to gather new functionality requirements. Also, worked on Agile and Scrum methodologies for fast completion of projects.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Kept track of release burn down to reflect the amount of work left to complete the target before a product release date.

Confidential, Philadelphia, PA

Jr Business System Analyst/ BA

Environment: SOA, QNTX, MS Office, MS Visio, Quality Center 10.0, UNIX, Windows, XML, XSD, SQL & MySQL Server.

Responsibilities:

• Conducted extensive meetings to understand the business model and processes, documented and gathered the business requirements, and carried out implementation of new derivative products.
• Worked extensively with SME's including heads in areas of fixed income derivatives, options, swaps, futures and risk managers in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRDs.
• Extensively worked on SOA Methodology specifically on Extreme Programming.
• Worked with SME's of Corporate Actions to better understand the impact and document the Business Requirement Specifications.
• Created Use Case Scenarios and maintained the Use Cases (Business Use Cases, System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, Business Flow Diagrams, revised functional specifications and other core materials throughout the System Life Cycle making all necessary revisions for defect correction and requirement clarification and refinement.
• Performed Gap Analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Worked with stakeholders to obtain deliverable sign-offs. Provided functional direction to other systems analysts and used the meta-data definition and workflow needs and how these functions map to business processes.
• Completed Project Status Reports and led Project Status meetings to update senior management and other stakeholders on the progress, issues and deliverables of the project.
• Created numerous deliverables in different phases of the project beginning from project Initiation, through Inception, Elaboration, Construction and Transition to create User Manuals.
• Involved in analyzing various business scenarios and pitfalls in the process that could occur because of network/system/user undoing; this being a data intensive project.
• Conducted scenario analysis to document business rules that govern the pass/fail criteria, set timelines to process the files, created backup for failed imports, etc.
• Assisted and executed Test cases and test scripts per Functional Specifications of the application. Documented test/cases, test results, test procedure and reported to client.