OBJECTIVE

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

SUMMARY

• Over 8 years of experience as a Business Analyst/Data Analyst/Business System Analyst.
• Functional experience in health Care Industry wif vast noledge on Medicare and Medicaid.
• Performed business analysis, support and conducted testing and data entry associated wif configuration and maintenance of teh Facets Provider.
• Facets support systems were used to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834, 835 & 837 transactions and their responses such as 270/271, 278 and276/277.
• Familiar wif HIPAA - compliant healthcare transaction sets 270/271 (Eligibility inquiry and Response).
• Clear understanding of ICD-9-CM and ICD-10-CM/PCS.
• Excellent noledge of claim processing and EDI transactions, code sets and EDI Implementation guides in Healthcare industry.
• Excellent organizational and interpersonal skills to communicate wif developers, testers and other team members.
• Applied noledge of SDLC like Waterfall, SOA and Agile.
• Experience in creating Wireframes and Mockup Screens (UI design) of Web Portals.
• Experienced in creating User Stories and product back log using scrum methodology.
• Experience working wif off-shore, on-shore and virtual teams.
• Defined teh requirements and assisted DBAs and developers wif data modeling and data migration.
• Participated in Business analysis planning and Monitoring, Elicitation, and translating end user requirements into user stories, also participated in teh 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
• 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).
• Extensive noledge of data modeling using normalization forms like 1NF, 2NF, 3NF for OLTP systems
• 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.

PROFESSIONAL EXPERIENCE

Confidential, Eagan, MN

Sr. System Analyst/ Data Analyst

Responsibilities:

• Analyzed teh 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 teh business needs into technical/data requirements as part of teh JIRA stories.
• As a liaison between teh developers and management, was instrumental in resolving conflicts between stakeholders and technical development teams.
• Translated teh business requirements into teh technical requirements and created and maintained teh Meta data for teh different clients.
• Communicated project related updates to PM for each project I was working on weekly basis to make sure dat we are on track for dat project or not.
• Maintained teh Internal client data mapping document for Carrier/Account/Group CAG on weekly basis in order to reflect teh required changes for different clients.
• Involved in teh Source to Target mapping of teh system also created teh Business Glossary for some of teh projects as required. Also set up and maintained different “Benefit Plans” and “Pharmacy Network plans” for each product offering in RXCLAIMS.
• Performed GAP Analysis ("As IS" - "TO BE") to derive requirements for existing system enhancements. Also was responsible for conducting GAP analysis between requirements & accounting policy/test cases
• Worked on pharmaceutical commercial operations, claims and analyzed data from heterogeneous systems.
• Scheduled meetings wif developers, systems analyst and testers to collaborate resource allocation.
• Participated in teh SA Validation to validate C/A/Gs are mapped correctly under teh Customer table/Security tables .Also wrote test cases and participated in UAT testing.
• Defined testing scenarios to QA also created Data - Members under Carriers as required for testing.
• Reviewed test cases for QA and provided assistance while testing.
• Assist development team wif designing teh application to meet end user business needs.

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

Confidential, Edenpraire, MN

Sr. Business System Analyst

Responsibilities:

• Involved in teh meeting wif Business process owners and SMEs (subject matter experts) for scope identification and requirements gathering in initiation phase of teh projects
• Performed various demonstrations of application and Access prototypes to business users while application is getting ready for release.
• Analyzed teh existing data model and provided suggestions and recommendations.
• Assist development team wif designing teh 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 dat application/s built generates expected results.
• Involved in defining teh 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 teh tests wif teh 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 testing (UAT).
• Assisted wif Test Cases and developed strategies wif 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 wif vendor and internal auditing
• Worked wif teh technical and business staff to produce Test Scripts, Configuration and Change Management Plan documents.
• Also responsible to teh user group for special requests and program maintenance, where Involved in verifying teh Web Services used in teh application and used Rally for bug tracking and reporting, also followed up wif development team to verify bug fixes, and update bug status.

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

Confidential, Richfield, MN

Sr. Business System Analyst/ Data Analyst

Responsibilities:

• Involved in teh meeting wif Business process owners, SME (subject matter experts) and marketing team for requirements gathering in project definition Stage for teh 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 wif APIs and was involved System Integration.
• Worked on teh user stories specific to teh 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 teh Business Workflow using MS-Visio wif 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 teh modules as per teh client needs for teh benefits of Facets provider.
• Worked on teh integration of our data wif teh third party system (Fairview, 3M etc)
• Used teh mapping tools to map 4010 and 5010 transactions along wif ICD 9 and ICD 10 codes, and validated teh HIPAA Syntax.
• Validated Hospital Inpatient, Medical and Outpatient claims data in SDS Quick Claim application entered in Meta Vance.
• Worked wif teh solution architect in order to understand teh existing data model and modify teh data model to accommodate teh required 5010 changes.
• Involved in testing HIPAA Database, which incorporates all teh HIPAA (Health Insurance Portability and Accountability Act) transaction sets
• Conducted GUI/Usability Testing and Black Box Testing according to specifications.

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

Confidential, Bloomington, MN

Business System Analyst/ BA E-commerce

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 wif 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 wif teh technical and testing team to develop testing strategies and test plans such dat test cases reflect user needs.
• Documented use case specifications on teh basis of requirements gathered from stakeholders.
• Create scope document, project charter and Business Case Template (BCT).
• Conducted requirement gathering sessions wif teh purpose of creating and defining teh Business Decision Document (BDD) and teh 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 wif MS Project for developing schedules using Gantt charts and helped teh process team in developing methodology and lifecycle for teh processes of testing and quality assurance.
• Also wrote test cases and participated in UAT(User acceptance testing) as required.

Environment: CRM, UML, SQL, MS Office, MS Project,.Net, MS Access,Axure, SharePoint, Scrum (Agile) implementation, SOAP Tester,XSD,XML,WSDL, TFS.

Confidential, Columbia, MD

Sr. Functional Business Analyst/Data Analyst

Responsibilities:

• 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 wif teh designers, developers and management staff.
• Followed teh 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 wif teams.
• Interacted wif Test team to ensure teh guidelines were met for HIPAA
• Analyzed and worked wif HIPAA specific EDI transactions for claims, member enrollment, billing transactions. Worked specifically wif 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 wif respect to reporting specifications and production management.
• Ensured dat teh facets configuration was created and maintained in a manner dat supports teh departmental, user and overall business objectives in coordination wif other system vendor products.
• Performed System Integration and Regression Testing for teh 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 wif 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 teh dimensional models of ETL system.
• Led teh testing efforts of teh datamarts in development, coordinated moving/setting up of processes in dev/qa/production. Worked wif QA team and UAT team to go over teh various test scenarios for different types of loads in teh datamarts.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment
• Prepared and Reviewed Business Requirement Documents and teh Technical Specifications using Rational Requisite Pro.
• Assisted teh development team during teh second and third iteration using teh RUP model.
• Involved in Functional System Testing, Integration Testing, Regression Testing, and User Acceptance Test using teh test cases
• Managed teh progress of teh sprint backlog and added incomplete requirements into product backlog at teh end of each sprint.
• Facilitated meetings wif teh product owner, scrum masters, project coordinator, SMEs and testing teams.
• Wrote high level use cases for teh purpose of testing and assessed testing team for understanding teh requirements.
• Helped sorting teh reviewed user stories into product backlogs prioritizing them on teh basis of teh business requirements.
• Facilitated daily scrum meetings and kept track of teh meetings.
• Held teh sprint retrospective meetings, reflected upon teh past sprint and what could be improved.

Environment: UAT, CALT, Java/J2EE, Agile/Scrum, SharePoint, QualityCenter10, UNIX,QNTXWindows, XSD,XML,WSDL,SQL & My SQL Server.

Confidential, Celebrations, FL

Business System Analyst/ BA E-commerce

Responsibilities:

• Worked directly wif 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.
• Developed API and BATCH file transfer process requirements to maintain information.
• 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 teh business critical and high-risk areas of teh application.
• Conducted presentations of QA test results wif analysis to teh 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 teh amount of work left to complete teh target before a product release date.
• Wrote test cases and participated in UAT (User acceptance testing) as required.

Environment: Advanced Rest-Client,UAT,API, XSD,XML,Agile/Scrum, Jira, QualityCenter10.0, WADLWindows, .Net, SQL, Web/Mobile Application & Fish Eye.

Confidential, Philadelphia, PA

Jr Business System Analyst/ BA

Responsibilities:

• Conducted extensive meetings to understand teh business model and processes, documented and gathered teh business requirements, and carried out implementation of new derivative products.
• Worked extensively wif SME's including heads in areas of fixed income derivatives, options, swaps, futures and risk managers in understanding, extracting, refining and documenting teh User and Business Requirement Specifications in teh BRDs.
• Worked wif SME's of Corporate Actions to better understand teh impact and document teh Business Requirement Specifications.
• Created Use Case Scenarios and maintained teh 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 teh System Life Cycle making all necessary revisions for defect correction and requirement clarification and refinement.
• Performed Gap Analysis for teh modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Worked wif stakeholders to obtain deliverable sign-offs. Provided functional direction to other systems analysts and used teh 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 teh progress, issues and deliverable of teh project.
• Created numerous deliverable in different phases of teh project beginning from project Initiation, through Inception, Elaboration, Construction and Transition to create User Manuals.
• Involved in analyzing various business scenarios and pitfalls in teh process dat could occur coz of network/system/user undoing; this being a data intensive project.
• Conducted scenario analysis to document business rules dat govern teh pass/fail criteria, set timeline to process teh files, created backup for failed imports, etc.
• Assisted and executed Test cases and test scripts per Functional Specifications of teh application. Documented test/cases, test results, test procedure and reported to client.

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