SUMMARY

• More than 10 years of experience as Business System Analyst and 4 years of Project Management experience majorly Information Technology and Healthcare Industry.
• Strong Background in data warehouse related projects.
• Extensive use of Haddop, Hawq, Informatica, Netezza and Toad.
• Thorough Knowledge of various SDLC methodologies like Waterfall, RUP and Agile models.
• Experienced in Business analysis, Risk analysis, SWOT analysis, GAP analysis, and Project Management.
• Experienced with Iterative approach for Software Development as per Rational Unified Process (RUP). Involved in inception, elaboration, construction and transition phases.
• Broad knowledge of Medicare, Medicaid, PPO, HMO, POS, diagnostic codes and claims process.
• Experienced in facilitating Joint Application Development (JAD), Rapid Application Development (RAD), interviews, workshops, and requirement elicitation sessions with end - users, clients, stakeholders and development team.
• Worked on projects involving Siebel UI (User Interface) enhancements and gathered requirements for integration of Siebel with the new portal system for Medical Review.
• In depth experience in HIPAA ANSI X-12 EDI series such as 270/271, 276/277, 278, 834, 835, 837 and version 5010 of this transaction and also about Medicaid and Medicare.
• Extensive experience in interacting with stakeholders, gathering Requirements and creating Business Requirement Documents (BRD), analyzing and Creating Use Cases, Use Case Diagrams, Activity diagrams, Business Flow Diagrams.
• Strong experience in writing SQL for Data Analysis and QA report testing.
• Excellent analytical skills in understanding the business process (AS-IS and TO-BE), understanding the functional requirements and translating them to system requirement specifications.
• Excellent Knowledge of Industry standards such as Six Sigma, ISO 9000 and CMM levels.
• Expert in writing complex SQL queries, Stored Procedures & ETL to extract and load data from multiple source on to data mart. Designed complex dataflow tasks to integrate, transform and load the data from different sources.
• Professional with extensive experience in the development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.
• Excellent communication and presentation skills.

TECHNICAL SKILLS

Methodologies: RUP, Agile, Waterfall

Project Management: MS Project, Primavera, SharePoint

Requirements Management: RequisitePro

Change Management Tools: Rational ClearCase

Operating Systems: Windows 95/98/NT/2000/03/XP, MAC OS, LINUX, UNIX

Databases/RDBMS: Haddop, Hawq, Hive, Redshift, Amazon Cloud, Oracle 8.x/9.x,10.x, DB2, MS SQL Server, MS Access, TeradataBusiness Modeling Tools: MS Visio, MS PowerPoint, Rational Rose

Business Intelligence Tools: COGNOS 8, ReportNet, Micro Strategies

Documentation Tools: MS Word, MS Excel, Rational SoDA, Siebel

Reporting Tools: Crystal Reports, Micro Strategies

Automated Test/Bug Tracking Tools: Win Runner 7.6, Quick Test Professional 8.0, Load Runner 7.x, 8.0, Test Director 8.0, Quality Center 11.5, Clear Quest, PVCS, SQA Administrator, SOAP UI

PROFESSIONAL EXPERIENCE

Confidential, BETHPAGE, NEW YORK

SR. BUSINESS SYSTEM ANALYST

RESPONSIBILITIES:

• Functioned as the primary link between business line, operations and the technical areas throughout the project.
• Prepared Work Flows, Process flows, Data dictionary and Data Mapping document.
• Prepared Design specification documents and test cases and formulated the Appworks sheet by listing the dependencies on various work flows.
• Analyzed data coming in from various Sources and mapped the necessary data to the target.
• Data Analysis and requirements gatherings, including meeting with the business unit stakeholders, subject matter experts and engineering
• Preparation of technical documentation, including process flows, data mapping, data flow diagrams, design specifications and data dictionaries.
• Technical assistance during the Extract Transform Load (ETL) development process using technologies including Oracle, Netezza, Hadoop and Informatica
• Remediation and post deployment support.
• Conducted meetings to gather requirements from Business Managers, Supervisors, stakeholders, Data Governance Team and subject matter experts to gain knowledge about needs of the system.
• Extensive use of MS Project to maintain record of recommendations, communications, activities, schedules and to monitor progress of project in real time.
• Worked with Designers to create data warehouses and/or reporting solutions using Informatica /ETL.
• Thorough use of UML and MS Visio to develop Use Cases, Activity Diagrams, Sequence Diagrams.
• Identified, researched, investigated, analyzed and documented business processes and use case scenarios.
• Responsible for ensuring that privacy and security environments of marketing data remained intact.
• Interacted effectively with internal and external parties and worked closely with project manager in handling the whole and project.
• Also worked on delivering multiple projects as a Project manager as well as a BA

Environment: Hadoop, Hawq DB, Redshift, Amazon Cloud, MS Project, SQL, Toad, Informatica, Netezza Rational Rose, Clear Quest, Microsoft Visio, Windows Vista/XP, MS Visio, ETL, SQL, DB2, Office Suite (Word, Excel, Power Point), Micro strategy.

Confidential, BALTIMORE, MARYLAND

BUSINESS SYSTEM ANALYST

RESPONSIBILITIES:

• Facilitated JAD sessions, user meetings, interviews and Requirement Elicitation Sessions to extract business requirements and to confirm that those requirements are in alignment with up gradation of existing system to 5010.
• Extensive use of MS Project to maintain record of recommendations, communications, activities, schedules and to monitor progress of project in real time.
• Developed and modify ETL for data processing from Staging to ODS to DW
• Worked with Medicare, Medicaid and insurances in X-12 formats. Along HIPAA ANSI X-12 EDI series such as 270/271, 276/277, 278, 834, 835, 837 and version 5010 of this transaction.
• Conducted GAP analysis to identify and document gaps between existing 4010 compliant system and proposed 5010 compliant system.
• Thorough use of UML and MS Visio to develop Use Cases, Activity Diagrams, Sequence Diagrams.
• Identified, researched, investigated, analyzed and documented business processes and use case scenarios.
• Designed strategy for up gradation of system and implementing user interfaces to be 5010 compliant.
• Ensured that project followed Business Rules and was compliant with HIPAA rules to display minimum benefit information.
• Responsible for ensuring that privacy and security environments of healthcare data remained intact.
• Prepared Business Process Reengineering (BPR) documents by interacting with SMEs.
• Executed SQL queries to test the database for records that detect and submit functional acknowledgement and remittance advice in the claims application
• Interacted effectively with internal and external parties and worked closely with project manager in handling the whole and project.

Environment: MS Project, SQL, Rational Unified Process (RUP), Rational Requisite Pro, Rational Rose, Clear Quest, Microsoft Visio, Siebel,Windows Vista/XP, MS Visio, ETL, SQL, DB2, Office Suite (Word, Excel, Power Point).

Confidential, DOWNERS GROVE, IL

BUSINESS ANALYST

RESPONSIBILITIES:

• Developed business requirement updates while working with different user groups to define priorities concerning project development.
• Documented business requirements, and communicated these requirements to the development team for the design and implementation of business solutions.
• Conducted brainstorming and JAD sessions with stakeholders and end-users for requirement analysis and documented the same.
• Followed the Agile Methodology wherein we had weekly status meeting. Performed scrum technique with a 1 month sprint.
• Core activities involved creating/updating Work Breakdown Structure (WBS), preparing deliverable tasks in the project plan
• Used UML during requirements gathering and created Use Case Models and Use Case Diagrams for the purpose of stakeholders in the project to help them understand the workflow of the system associated with the requirements.
• Maintain PeopleSoft systems by performing PeopleSoft required system updates and maintenance on a periodic basis.
• Analyzed, coordinated, documented and managed project requirements, project processes and procedures and its changes throughout the software development lifecycle.
• Performed Requirements Analysis and traceability using Test Director and MS Word.
• Involved in writing test plans, defining test cases, test scenarios and data sets; developed and maintained test scripts, analyzed bugs and interacted with development team in fixing the errors.
• Worked with Subject Matter Experts (SME), project team members (business and technical), to define technology application for the business and system requirements. Also worked with the QA Team Lead to develop QA standards and ensured compliance with all regulatory requirements.
• Developed several MS Excel spreadsheets and applications to automate manual calculations and optimize reporting structure.
• Also assisted in development of staging database and inquiry screens to support EDI transactions.
• Created and segregated SQL views and stored procedures for obtaining meaningful set of data.
• Extensively used MS Project 2003 for status reporting and planning throughout the project lifecycle

Environment: MS Office, MS Project, RequisitePro, Rational Rose, Rational ClearCase 6.0, SQL Navigator, Teradata, Test Director, ReportNet 1.1 MR 2/3, Cognos, MOSS 2007, Windows Server 2003. .NET, PeopleSoft, Java, J2EE, Siebel

Confidential, SAN DIEGO, CA.

BUSINESS ANALYST

RESPONSIBILITIES:

• Developed business requirement documents based on HIPAA Guidelines.
• These documents were prepared by extracting business requirements from clients and users by conducting JRD and JAD sessions keeping in mind their requirements for the application (Internet, Claims, Provider and Recipient) and coordinated with developers for the successful completion of the project.
• Developed Use Case diagrams, Sequence diagrams and Activity diagrams for better understanding of the project.
• Involved in HIPAA Claims Validation and Verification Process (Pre-Adjudication).
• Worked on claim processing module which involved Receipt and Verification of Claim Forms (837) and Claims Attachment (275), Reviewing and response for claims (278), Claims Enquiry and Response (276/277), Adjudication, Health Claim Payment/Advice (835) as per HIPAA guidelines.
• Followed the Agile Methodology wherein we had weekly status meeting. Performed scrum technique with a 1 month sprint.
• Experience with Medicare, Medicaid and insurances in X-12 formats.
• Understanding of complete EDI (Electronic data interexchange) format used in electronic documentation which was part of knowledge transfer program to the vendors as per the requirements.
• Worked on the 278 transaction used to submit information for advance notification, scheduled inpatient, specialty care.
• Reviewed and prioritized defects within a functional area by actively participating in the Weekly Defect Status meetings
• Maintain PeopleSoft systems by performing PeopleSoft required system updates and maintenance on a periodic basis..
• Provided support to UI architect to develop new UI for claims reimbursement process.
• Developed ETL programs using Informatica.
• Built and supported ETL mapping/workflows using Informatica tool
• Involved in the day-to-day implementation of the rational unified Process (RUP) methodology of application development with its various work flows and activities.
• Designed and developed Business Flow diagrams, Dataflow diagrams, UML Activity diagrams and Use Case diagrams.
• Reduction in defects of the project by sticking to Six Sigma discipline and methodology.
• Conducted GAP analysis and documented business and system level use cases to derive the requirements illustrating functional behavior.
• Engaged in different stages of testing process like Integration testing, Black box testing, user Acceptance testing, Regression testing and Back End testing

Environment: Rational Requisite Pro, Rational Rose, Rational Clear Quest, RUP, UML, MS Office, MS Project, MS Visio, Windows XP, SQL., Informatica

Confidential, HARTFORD, CT

BUSINESS ANALYST

RESPONSIBILITIES:

• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Worked with the business users to define business requirements and analyze the possible technical solutions.
• Performed extensive data analysis and data integrity testing for loading and validation of the data set output.
• Gathered user and business requirements through discussions, brainstorming, interacting with corporate to understand the business requirement.
• Reviewed the user perspective use cases to determine the functionality that had been incorporated on the web application.
• Functioned effortlessly and efficiently, as a liaison between four work streams and its task leads, SMEs, QA team, and management group. Actively participated in Joint Meetings with the various teams involved in the development process.
• Reviewed the test cases that detailed the functionality to be tested in various UIs.
• Performed the User Acceptance Testing of the functionality and involved in defect management process using Track Record (TR).
• Interacted with the SME’s and stakeholders to get a better understanding of client business processes and gather business requirements.
• Facilitated JAD and JAR sessions with management, development team, users and other stakeholders to refine functional requirements.
• Redefined existing Business Processes and preparing To-Be Processes using MS Visio.
• Developed Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.
• Created and managed Use Case project templates.
• Creating test plans utilizing the customer request documents for identifying specific business requirements to be created and maintained numerous automated functional regression tests from the ground up and delivered on time working within an Agile (SCRUM) process.
• Implementing Software Quality Assurance (SQA) development policies, procedures, SDLC and testing methodologies.

Environment: JAD, MS Visio, Windows 2000/2003,RUP, Rational RequisitePro, Rational Rose, Oracle, SQL, PL/SQL, MS Office, Load Runner, UAT

Confidential

BUSINESS ANALYST

RESPONSIBILITIES:

• Involved in gathering, analyzing and documenting business requirement and data specifications.
• Created and reviewed business requirements, functional specifications, project schedules and documentations.
• Diagrams using MS Visio and developed test plans, test cases to analyze match results.
• Reproduce, verify and validate issues documented in a defect tracking system and writing tractability matrices based on use cases and business requirements (BRDs) performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Involved in constructing an integrated IVR CRM application to provide system access to real time customer data and information.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse
• Organized impacted systems into high, medium and low impact to help business analyze the level of effort for remediation activities and ease resource allocation work.
• Created use case models, analysis models, implementation models, authored use cases, use case diagram, behavior diagrams(sequence diagrams, activity diagrams) based on UML methodology using Rational Software Modeler and MS Visio.
• Followed the Agile Methodology wherein we had weekly status meeting. Performed scrum technique with a 1 month sprint.
• Performed Gap Analysis to identify the gap between the optimized allocation and integration of the inputs, and the current level of allocations.
• Involved in UATsessions to test and validate the system with stakeholders.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Prepare schedule work flow, following agile methodology of software development.
• Prepared and maintained requirements traceability matrix (RTM) throughout the project lifecycle.
• Worked with the compliance and audit team to make sure we were following correct HIPAA guidelines/protocols throughout the project lifecycle.
• Involved in SWOT analysis of project plan.

Environment: SQL, Java, Oracle, UML, Windows XP, Business Objects, Informatics, MS Project 2000, MS Word, MS Excel, MS Visio, SharePoint.

Confidential

BUSINESS ANALYSIS

RESPONSIBILITIES:

• Researched and assessed client systems and business processes.
• Explored all aspects of the claim processing lifecycle, starting from identifying a claim to its closure.
• Used MS Word document for requirement gathering.
• Worked intensively on various phases in the project lifecycle to design the system in such a way that the high risk claims could be easily identified and monitored.
• Participated in preparing basis for Project Vision documentation.
• Involved in walkthroughs with business team, architects and developers to refine the requirements.
• Implemented Traceability Matrix and User Requirement Specification Document (URS) to verify the functionality.
• Streamlined clerical work processes and mapped to the automated system
• Involved with the Software Quality Assurance (SQA) Team to develop Test