We provide IT Staff Augmentation Services!

Sr .business Analyst Resume

LouisianA

SUMMARY:

  • Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
  • Planned and documented procedures for data processing and prepared data flow diagrams for the application.
  • Used Informatica features to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows using Workflow Manager to load the data into the Target Database.
  • Importing the IDQ Maps let's to Informatica and using them in the Informatica mappings
  • Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.
  • Experience in writing Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews
  • Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing reporting portals.
  • Performed the requirement analysis, impact analysis and documented the requirements.
  • Tracking and maintaining release schedule to estimate efforts and aligning stakeholder& expectations with the availability of time and resources for development of features and functionalities promised to business - users.
  • Provided thought leadership at bank-sponsored events, industry forums and regional and national treasury conferences.
  • Adhered to team Agile development practices, including BDD story writing and Continuous Integration.
  • Facilitated daily Scrum Stand-Ups, sprint planning, sprint review, sprint demo.
  • Worked on the procurement module of ServiceNow where the primary responsibilities are to understand the procurement compliance processes for purchase requests, approvals and orders, audit compliance, general ledger coding and then gathering the requirements, BPMN.
  • Also worked on the implementation of Incident Management, Problem Management, Change Management, Event Management, CMDB, Reporting, Service Catalog in ServiceNow.
  • Involved in Order Management and Inventory Modules.
  • Enhancement related to pl/sql and sql for Oracle Clinicals (oracle product used by client for clinical trials)
  • Responsible to design, develop and test the software (Informatica, PL/SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools)
  • Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub Queries, Set Operators, Psudo Columns, Analytical Functions and having knowledge on regular expressions
  • HealthCare management experience in projects involving the customization, design, development, implementation, and testing of automated systems to support the Medical Management Information System (MMIS) as well as day-to-day business operations.
  • Prepared BRD ( Business Requirements Document), FRD (Functional Requirements Document) and N-FRD (Non-Functional Requirements Document)
  • Effectively managed the hardware and software assets through their lifecycle using the procurement module.
  • Prepared BRD ( Business Requirements Document), FRD (Functional Requirements Document) and N-FRD (Non-Functional Requirements Document)
  • Resolving the complex requirements into simpler fragments and conveying it to the technical team for faster and efficient development.
  • Coordinated with Data Analyst, ETL and UI interface Developers and did tasks in construct phase.
  • Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
  • Involved in migrating the ETL application from development environment to testing environment.
  • Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica.
  • Coordinated with Data Analyst, ETL and UI interface Developers and did tasks in construct phase.
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle)
  • Conducts coverage analysis of clinical research trial procedures to delineate standard of care and research procedures; reaches out to research site to assist in determining charge direction.
  • Created dynamic reporting using MS Excel formulas, macros and Visual Basic for Applications (VBA)
  • Created Batch files to execute the multi transaction data feed files into CTMS.
  • Clinical Data Exchange Bulk Migration: EIM Imports/Updates and SQL's Procedures to load the Historical data in between Staging/Legacy and CTMS systems.
  • Participating in testing process and coordinating with QA team in each test cycle.
  • Create and run analytical reports as needed using tools such as Reporting Workbench, Epic Cubes, BI Portal and other reporting tools.
  • Assist in the co-ordination and management of various activities associated with clinical trial planning and initiation including clinical trial budget and agreement review, third-party vendors identification, and site/study feasibility assessment; among other responsibilities.

TECHNICAL SKILLS:

Business Tools: MS Office Suite, MS Visio, MS Project, MS Access, SharePoint, UNIX,SAP CRM

Methodologies: Waterfall, Agile, RUP,SDLC

Database Tools: Oracle SQL Developer, SQL Server, UNIX, MS - Access, share-point

Test Management Tools: Quality center, QTP, JIRA,HP ALM

EDI Mapping Tools: EDIFECS, xEngine, NASCO

Visualization Tools: Power BI, Power Point, Tableau

Analytics tool: MS Access, MS Excel (Macros), SSA, Minitab

WORK EXPERIENCE:

Confidential, Louisiana

Sr .Business Analyst

Responsibilities:

  • Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
  • Involved in migrating the ETL application from development environment to testing environment.
  • Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica.
  • Coordinated with Data Analyst, ETL and UI interface Developers and did tasks in construct phase.
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle)
  • Conducts coverage analysis of clinical research trial procedures to delineate standard of care and research procedures; reaches out to research site to assist in determining charge direction.
  • Created dynamic reporting using MS Excel formulas, macros and Visual Basic for Applications (VBA)
  • Created Batch files to execute the multi transaction data feed files into CTMS.
  • Clinical Data Exchange Bulk Migration: EIM Imports/Updates and SQL's Procedures to load the Historical data in between Staging/Legacy and CTMS systems.
  • Participating in testing process and coordinating with QA team in each test cycle.
  • Create and run analytical reports as needed using tools such as Reporting Workbench, Epic Cubes, BI Portal and other reporting tools.
  • Assist in the co-ordination and management of various activities associated with clinical trial planning and initiation including clinical trial budget and agreement review, third-party vendors identification, and site/study feasibility assessment; among other responsibilities.
  • Involved in Project co-ordination, Onshore/Offshore Co-ordination, optimal service delivery and Knowledge management.
  • Performed UAT and participated in writing test plans, and developed different testing strategies like black box testing and load testing.
  • Staff Augmentation and mentor new team members
  • Extensively involved in 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 inspection to transition phase.
  • Acted as liaison between external clients and SMEs to generate and standardize product requirements specification documents such as URS/FRS/Use Cases.
  • Employed UML methodology in creating UML Diagrams such as Use Cases, Sequence
  • Diagrams, State Diagrams, Activity Diagrams and business process and workflows.
  • Involved in implementing Six Sigma practices to systematically improve processes and standards and by eliminating defects
  • Coordination / Support for HL7 Interface testing (ADT Messaging)
  • Involved in HIPAA 5010 gap analysis of ANSI X12 4010 and ICD 10 initiatives.
  • Coordinated JAD sessions with all the stakeholders to understand the impact of HIPAA 5010 on the existing system.
  • Developed and updated HL7 interfaces for HIS and ancillary apps and involved in source mappings and translation tables. Supported EPIC message processing with Record Viewer functions.
  • 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. Worked on EDI transactions: 270, 271, 835, and 837 to identify key data set elements for designated record set.
  • Performed AS-IS and TO-BE analysis for EDIFECS Standards - HIPAA 5010 Database Setup for new version releases. Documented proposed changes and coordinated development, testing and production release environments, including end-to-end testing.
  • Used JIRA for project tracking, bug tracking, and reporting.
  • Responsible for identifying and documenting business rules, conducted User Acceptance Testing (UAT) in terms of training the end users.

Environment: & Tools:MS Visio, MS Office, JIRA, Agile- Scrum/ Waterfall, User Stories, Oracle, Java, SharePoint, Web services.

Confidential, Dayton, OH

Business Analyst

Responsibilities:

  • Involved in testing the HL7 Version 2.5.1 to receive messages from HL7 version 2.3.
  • Gathered requirements for "Front End" and for "Core Adjudication System" by conducting meetings and brainstorming sessions with end users and Subject Matter Experts (SMEs) and documented them using Requirement Traceability Matrix and later exporting them to HP Quality Center.
  • Involved in designing & determined 3-tier architecture for the claim processing system.
  • Assisted team lead in developing Requirements Traceability Matrix (RTM) to trace the relationship between business and functional requirements to test cases.
  • 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.
  • Gathered requirements for ICD 10 transition.
  • Maintained and controlled track of stakeholders' requests for enhancements and changes using Rational Clear Quest also shared knowledge on SAAS in brainstorming storming session.
  • Identified and documented issues, risks, gaps and their impact to the project life cycle.
  • Used JIRA for project tracking, bug tracking and reporting.
  • Create wireframes using Axure RP Pro based on collaboration with use cases and Visio flows
  • Exposed to using ICD 9/ICD 10/ANSI/HL7 coding standards in Medicare and Medicaid domains of the healthcare systems and industry for both inpatients, outpatients, Reimbursement methodology.
  • Streamlined Claims (837 EDI X12) Migration project by gathering functional specifications in Edifecs
  • Tracked the change requests.
  • Environment: MS Project, MS Visio, MS Word, MS Excel, MS PowerPoint, Mainframes, JIRA, COBOL, Rational Requisite Pro, Rational Rose, Rational Clear Case, Oracle, SQL, Toad, Java, Windows XP, HP Quality Center, UML, HIPAA
  • Involved in Agile methodologies to do requirements gathering, analysis and planning, development & testing.
  • Participated in the research and gathering business requirements through conducting surveys, interviews and JAD sessions.
  • Used Scrum practices like documenting User Stories, facilitating Story Point discussions to analyze the level of effort on project specifications.
  • Contributed to the definition of scope, preparation of work plans and definition of business requirements.
  • Developed business process models in Agile modeling to document existing and future business processes.
  • Mapped and Integrated Medicaid and Medicare module with the Facets systems.
  • Documented business requirements and communicated the requirements with the development team for design and implementation of business solutions.
  • Conducted Requirement Gathering Sessions with the stakeholders. Incorporated stakeholder feedback throughout the project lifecycle to ensure project quality and customer satisfaction.
  • Interacted with the project team to help define the Business and System Objectives, confirmation of scope, identify constraints and the measures of success for the system to be developed.
  • Created AS-IS and TO-BE business process flow diagrams, integrate process flow diagrams to show one end-to-end business model. Responsible for creating business flow diagrams (using MS-Visio).
  • Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using Joins, Database Links and Bulk Collects.
  • Involved in monitoring and reporting defects by using JIRA.
  • Incorporated User Stories in different release plans for the sprints.
  • Assisted Project Managers in the development of weekly and monthly status reports.
  • Designed the business requirement collection approach based on the project scope and SDLC Methodology.
  • Conducted Gap Analysis during the review of the compliance items for improved future audits.
  • Created Data Mapping Documents and wrote transformation rules.
  • Effectively translated business analysis requirements into appropriate data hierarchies, organizational form and technical specifications.
  • Used JIRA for project tracking, bug tracking, and reporting.
  • Responsible for identifying and documenting business rules, conducted User Acceptance Testing (UAT) in terms of training the end users.
  • Involved in the acquisition process of new infrastructure, establishment of a new service model, and implementation of a new service management system (ServiceNow)
  • Worked with internal and external customers to gather the business requirements and transform them into user stories on ServiceNow Agile Development module
  • Provided thought leadership at bank-sponsored events, industry forums and regional and national treasury conferences.
  • Adhered to team Agile development practices, including BDD story writing and Continuous Integration.
  • Facilitated daily Scrum Stand-Ups, sprint planning, sprint review, sprint demo.
  • Worked on the procurement module of ServiceNow where the primary responsibilities are to understand the procurement compliance processes for purchase requests, approvals and orders, audit compliance, general ledger coding and then gathering the requirements, BPMN.

Confidential, New York, NY

Business Analyst

Responsibilities:

  • Used ITIL practices to implement ServiceNow applications in phase by phase approach, created SLAs and participated in running SLAs and responsible for closing successfully in ServiceNow
  • Developed Service catalog, which includes creating new catalog items, designing workflows and execution plans.
  • Hands on experience in writing Triggers, Procedures, Functions, Cursor, XML and PL/SQL Packages, Bulk Collect, For ALL clause, REF cursor, DBMS packages, SQL Loader, Analytical functions, Dynamic SQL, Collections, Views, Materialized views, data cleansing, UQT reports and Exception handling.
  • Developed Complex Database Objects like Stored Procedure, Function, Package, Triggers using SQL, PL/SQL Scripts.
  • Actively participated in activities such as CMDB administration, system upgrade and patching, regression testing and releasing of new applications
  • Worked on creating Users, roles, groups and load the data to service-now objects using import sets on daily, weekly, monthly on request basis.
  • Responsible for creating homepages, including basic reporting and dashboard presentation.
  • Worked on creating survey questions in ServiceNow using Survey designer.
  • Provided training on service-now process, operations, answer questions, resolve issues and capability to all required teams.
  • Manage the user story backlog by ensuring that the backlog items are appropriately groomed, prioritized and estimated and that the teamfully understand what needs to be delivered.
  • Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
  • Planned and documented procedures for data processing and prepared data flow diagrams for the application.
  • Used Informatica features to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows using Workflow Manager to load the data into the Target Database.
  • Importing the IDQ Maps let's to Informatica and using them in the Informatica mappings
  • Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.
  • Experience in writing Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews
  • Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing reporting portals.
  • Performed the requirement analysis, impact analysis and documented the requirements.
  • Tracking and maintaining release schedule to estimate efforts and aligning stakeholder& expectations with the availability of time and resources for development of features and functionalities promised to business-users.
  • We used to validate the documents which are received from customers and once the requirements met then we will settle the claims to respective persons.
  • Worked as quality analyst, we used to verify the documents twice before settling the claims.
  • Handling a team of 10 associates for HealthEC - MneConnect/OrbiteConnect Process.
  • Quality Analysis and sharing feedback with the associates.
  • Handles Payer Implementation process. Responsible for making direct contacts with the different payers
  • (Commercial, State/Federal etc.)
  • Responsible for maintaining direct connections with Health Payers for claim transmission.
  • Responsible for conducting training sessions in the team for any new joiner.
  • Responsible for conducting webinars and session with the clients
  • Modifying and Improving the existing Product. Updating SOP's on regular basis and sharing with the team as suggested by the onshore partners.
  • Handled regular nesting batches before they hit the floor.
  • Handling customer complaints and taking escalation calls.
  • Conducting Training & Development programs for associates on monthly basis for knowledge enhancement and self-grooming.
  • Knowledge of medical terminology and procedures, billing standards, data analysis and law regarding medical billing.
  • Complete knowledge of claims transmission process and all types of medical files (837 P/I, 835, 270, 999, 277etc.)
  • On board healthcare providers (submitters) for Batch Claims. Responsible for the entire Batch Implementation
  • Process for all formats ANSI, CSV and Image. This process includes testing as per the format submitter will chose, also as per the payer requirements.
  • Helps development team to get all the new payer requirements validated in our system/portal.
  • Experienced professional with strong knowledge of the medical and insurance fields, including but not limited to customer service, claims processing, medical transcription and practice management.

Hire Now