PROFILE SUMMARY:

• Business Analyst with over 5 of experience in Business Analysis, Quality assurance, Software Validation and Business Process Re-engineering with proven ability to articulate business values.
• Experience in system design, implementation and integration strategies within a team oriented environment.
• Working experiences in Healthcare Insurance, Retail, and Pharmaceutical Domain.
• Knowledge Health Insurance Portability and Accountability Act HIPAA standards, Electronic Data Interchange EDI and implementation of HIPAA code sets, ICD-9, ICD-10 and HL7.
• Experienced in financial planning, budgeting, forecasting and reporting using Cognos
• Skillful at eliciting business and functional requirements through 1-1 meeting, team meeting, interviewing, questionnaires, the Joint Application Development JAD sessions.
• Proficient in working with business SMEs and external stakeholders to gather business and technical requirements
• Skillfully documented Business Requirements, Use Case Specification, Functional and Non-Functional specification, UML diagrams Use Case diagram, Class diagram and Sequence diagram , Data Flow diagram DFD , Entity-Relationship diagram ERD , Requirement Traceability Matrix RTM , Change-Version Control, Training Manual and User Guide using MS Visio 2013
• Experience in implementing Test scenarios, Test cases, System testing, Regression testing and writing, Defect Report, and Weekly Status Reporting while maintaining Requirement Traceability Matrices for baseline documents
• Experience in conducting Gap Analysis and Impact Analysis, and modeling Business Process
• Experience working with Agile/Scrum Methodology, and Rational Unified process in Software Development Lifecycle
• Experienced performing quality assurance, user acceptance testing, and change management control
• Strong knowledge and experience in Data Analysis, Data Warehousing writing SQL queries T-SQL PL-SQL especially stored procedures, joins, triggers and views
• Broad MS Excel skills, like pivot tables and Vlookups
• A team player with experience in handling remote teams esp. managing schedules and meeting agenda
• Worked with project managers throughout project lifecycle to manage scope, schedule, budget, and resources
• Developed training documentation, training modules, training presentations, and facilities workshops for end users
• Excellent planning, organizational, and communication skills Strong analytical, interpersonal, and problem solving skills

TECHNICAL SKILLS TOOLS

PROFESSIONAL EXPERIENCE:

Confidential

Business Data Analyst

Confidential is a leading provider of revenue and payment cycle solutions with connections to payers, providers and vendors. The project was to deliver a data mining solution for Payment Integrity based on EDI Claims data fully integrated into an OLAP cube.

Responsibilities:

• Participated in Backlog Grooming sessions, identified obstacles, planned releases and managed sprints, also created a Business Requirement Document for management.
• Created and Managed User Stories in Epics, Themes and Sprints also calculated velocity and Story-points in TFS. I was also part of the team that assessed and analyzed TFS, HP Agile Manager and Green Hopper as Agile ALM tool
• Conducted interviews with the SME and gathered information about Health care Enrolment, Billing and Claims processing leading to creation of user stories, test cases in epics and themes.
• Analyzed HIPAA 5010 related to 837,835, 834 creating Data warehouse model schemas for faster data processing also performed Normalization-De-Normalization at various occasions.
• Worked with end users to define business design solutions e.g. new workflows, systems, programs, and reports as well as created integration requirements for system coupling.
• Designed reports and data sets for COGNOS reporting
• Created Report Mockups for SSRS based data and Sample Data Mapping documents for ETL process.
• Worked with the DBA to define the dimension modeling requirements.
• Created SharePoint workflow diagrams describing how to use the new system.
• Participated and conducted daily standup meetings and owned daily milestones to gather and create reporting specifications.
• Created UAT plans and several other types of test cases for each project to ensure that the system runs smoothly after the proposed enhancements.
• Coordinated between business line, operations and the technical team throughout the project.
• Gathered requirements for impacted system and business areas for ICD-10 and their needs to embrace the changes.
• Created T-SQL statements, stored procedures to query the custom claims OLAP database.
• Proactively identified opportunities and made recommendations to improve the system's effectiveness via data mining and analysis

Environment: Agile, MS Office 2007, MS Project, Rational Requisite Pro, MS Visio 2010, MS SQL Server,Oracle, MS Share Point, Cognos

Confidential

Business Systems Analyst

The Scope of the project is to create a single global channel program that brings together Motorola Solutions' many disparate programs, making it easier for its distributors and resellers to conduct business with Motorola. Initiative involves a partner-focused channel program that leverages partner competency to best service the market. The project lays a foundation that allows for partner differentiation in the market based on the partner's competency and investment in technologies and markets leveraging an expanded diverse partner ecosystem that creates new solutions-focused business opportunities for Motorola and its dealers.

Responsibilities:

• Coordinate with Program/ Project Managers and their teams, keeping the business and IT team up-to-date/ informed about scope changes, as and when approved, analyzing the business impact on the initiative
• Coordinate between teams to clarify GAPs, and find resolutions for the Data Model
• Conduct JAD sessions to gather/ review Process Flows, Requirement Timelines, and Component- Delivery Milestones, with emphasis on the ones that impact the Data Model
• Coordinate target-dates for SIT/ UAT, and RT with QA Team during STLC Software Testing Life Cycle , Solutions Architect, and the Developers to prioritize activities revolving around the Data Model
• Draft high level conceptual, and logical data models, conduct walkthroughs, and seek/ secure sign offs from business and IT teams Collaborate with UI development team the development of User Interfaces, and secure sign offs from the business team in light of the validated Business/ System Use Cases achieving the most intuitive User experience Used FTP-Secure for accessing and managing files on a UNIX host servers Create and maintain the physical Data Model, incorporate changes, analyze dependencies and impacts of such changes Create, manage and execute Data Governance document to ensure that changes impacting the data Model are accurately and smoothly documented and then implemented to carry out Data Governance in line with business/IT needs and requirements Create/modify Use cases for the assigned projects Order Management/Price quoting/exception, Learning Management System . Conduct analysis for change-requests, walk-thrus, advise the concerned Project Managers, BSAs and technical teams on the impacts of the changes Facilitate virtual meetings utilizing GotoMeeting, and Intercall to validate requirements with the Developers, SMEs, and QA Team during the entire project Environment: Quality Center, MS Project, Visio, SQL, Oracle 12g, .Net Technologies, SFDC, Compass.

Confidential

Business Analyst

Confidential Company is the leading paint company which provides paint solutions to a wide range of industries across the globe. I Worked on two main projects, improving the functionality of the color matching software with multiple bases and pigments with various sources and creating new formulae and modify existing color formula using the databases.

Responsibilities:

• Worked with the end users to conduct business process modeling, analyzed system requirements and changed requests to existing software
• Developed design prototype of the color matching software application and wrote feature lists describing functions and rules
• Gathered functional and user requirements and documented the same creating use case documents and system functional requirements document
• Engaged the team of chemists and technologists and created several color databases in order to make efficient color formulas using low VOC colorant pigments
• Used SQL tools to access data and interfacing with the project manager and scientist to perform data analysis
• Involved in development, testing and implementation of software functionality
• Worked with users to build and formulate business requirements
• Implemented project plan/timeline and execution and provided technical solution design document
• Provided support to customers of all levels of the organization
• Participated in decision making according to established guidelines, standards and procedures.

Environment: MS Project, Oracle, MS Visio, SQL, MS Office, C Language

Confidential

Business Analyst

Confidential is a fastest growing pharmacy chain and part of nationwide Confidential, organizations HMOs , preferred provider organizations PPOs , commercial health insurances, Medicare Part D and State Medicaid patients. The project was to develop Pharmacy Benefit Management System, Health Insurance Claims Adjudication and Web Application.

Responsibilities:

• Gathered all the required functional requirements
• Coordinated and conducted several JAD sessions with SMEs, stakeholders, design/development teams and users.
• Prepared Business Requirement Documents BRDs , Technical Requirement Documents TRDs and Case Studies to evaluate business needs for Pharmacy chain.
• Custom solutions were created and tested to resolve operational issues.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML in Visio to map the claims adjudication workflow, and POS integration.
• Created and maintained the Requirement Traceability Matrix RTM between the requirements and design documents and test plans
• Conducted various meetings and interacted with the SMEs, and developers to discuss Enhancement and Modification Request issues.
• Assisted in developing User Interface UI designs and prototypes using Fireworks for web application development.
• Assisted in User Acceptance Test UAT .

Environment: Windows, MS Visio, Requisite Pro, Bugzilla, UML, SQL, MS Office, .Net, HIPPA, EDI.

Confidential

Jr. Business Analyst

Confidential is a national organization dedicated to the delivery of quality health care plans and products to its customers. This project was aimed at developing a lightweight internal Work Flow Management system to automate business processes based on preset business rules and conditions. The system is primarily aimed at handling Medicare/Medicaid insurance claims and process exceptions based on HCFA 1500 and CMS 1500.

Responsibilities:

• Analyzed current business process flow by understanding preset business rules and conditions
• Conducted formal interviews, live meetings with business users and subject matter experts SME's . Documented, organized and tracked the requirements.
• Designed and developed Use cases, Activity diagrams, and Sequence diagrams using UML.
• Developed Business process flow diagrams, Data Flow Diagrams DFD's , Activity Diagram for data modeling
• Created web-page mock-ups on MS - Visio using Data Fields from HCFA 1500 and CMS 1500.
• Defined project milestones, schedules, and monitored progress using MS-Project and updated plans
• Analyzed, organized, and updated database using SQL.
• Involved in back end testing to verify data integrity using SQL.
• Analyzed and tested data interface needs with external systems.
• Developed Test plans, Test conditions, and Test cases to be used in testing based on business requirements and technical specifications.
• Assisted with user testing of systems and maintained quality procedures and ensured appropriate documentation in its place.

Environment: UML, MS Word, Rational Requisite Pro, SQL, MS Visio