SUMMARY:

• Over 7 year’s expertise in Business /Systems Analysis, Quality Assurance, Data warehousing/Data Modeling and Business Intelligence reporting and Testing with hands on experience in Healthcare, Finance and Insurance Sectors.
• Extensive experience with Medicare/Medicaid processing as well as the Claims/Billing.
• Skills include defining Project Scope, Business Process Analysis, Business Process Reengineering, Requirements Gathering, Data and Process Modeling
• Strong knowledge of the Software Development Life Cycle methodologies (phases and gates) like Agile and Waterfall models
• Experience with Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), involved in inception, elaboration, construction & transition phases using rational tools like RequisitePro, ClearCase, ClearQuest during various phases of RUP.
• Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD),Software Requirement Specification (SRS) across the deliverables of a project. Experience in Designing, Creating and maintaining the Universes, Business object reports, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
• Effectively used Rational Requisite Pro to organize, track and change requirements of the system.
• Expertise of UML in visualizing and documenting the artifacts using Use Cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams, Sequence Diagrams using MS Visio
• Experience in facilitating Joint Application Development (JAD) sessions, Rapid application development (RAD) sessions, conducting user interviews and acting as a liaison between the customers, development team and testing team
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users as well as trained users to use the system configured.
• Analytical, methodical and resourceful approach to problem solving, identifying root causes and corrective actions to meet short and long - term business, financial and system requirements
• Excellent verbal/written communication skills and strong analytical abilities and can perform well both independently and as a team player

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Business analyst

Responsibilities:

• Interact with various business owners across the firm to document the FRD pertaining to Teradata warehouse.
• Gather requirements by conducting meetings with end users and SME and documentation them using Optimal Trace, Caliber & BNTS (EXPRESS SCRIPT Own word Document for requirement gathering.)
• Analyze and translate business requirements into system specifications utilizing UML and SDLC. Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Identify/Document data sources and transformation rules required populating and maintaining data warehouse content, Create data mapping document, Reporting flow, Process flow, activity diagram, ER diagram.
• Analyze the data entity relationships and work on functional requirements documents (FRD). Worked for a project to customize and integrate a Business Process Management (BPM) solution.
• Capture & Document Non functional requirement, Report types, Report frequency, Report templates, Data mapping documents & CWS (Client website specifications) requirements
• Create use cases/activity diagrams/State chart diagrams, sequence diagrams, and collaboration diagrams thus defining the data process model and business process model. Generated XML documents using the XML Output Stage.
• Involvement in all the phases of software development life cycle (SDLC) methodologies throughout the project life cycle and also participated in UAT sessions. Involved in coding using Java created web pages using HTML, Java script. Involved in the process analysis, catalog design and performance optimization of Business Intelligence Reports.
• Performed UAT and exposure to User Testing (UCT) and Operational Readiness Testing (ORT)
• Develop and maintain reporting using in MS EXCEL queries, SQL in Teradata.
• Organize requirements into high-level use cases and low level use case specifications and modeled them into activity and sequence diagrams using Microsoft Visio. Involved in extensive DATA validation using SQL queries and back-end testing.
• Assure that all artifacts are in compliance with corporate SDLC policies and guidelines.
• Have worked on Surveillance & Monitoring report FRD development for MTMP 2012 targeting for Client HMSA, Client N transaction Monitoring report, PDP enrollment and Disenrollment reporting, CDUR surveillance report, E2E patient appeals - AOM Reconciliation/Surveillance reporting, Transition supply new and enhanced surveillance reports, LTC short cycle fill surveillance reporting, NPI prescriber NPI validation reporting, Smart PA surveillance reporting, LTC Surveillance report & EGWP 2012 enhanced client reporting.
• We have performed following tasks for FRD development: Reporting domain (EOB, PDE, MTM..etc), Estimate number of reports and their types, estimate number of reporting columns, identify any dependencies, Identify stakeholders, Confirm LOE and timeline with Project manager, Identify report frequency, Primary key for each table, restriction criteria, exception criteria, data types and sizes for each field within the report, Delivery mechanism criteria, sorting and grouping requirements, all pre and post conditions.

Environment: MS Excel, RUP, MS Word, MS Excel, MS Access, UML, Rational Rose, Requisite Pro, Rational Clear Quest 2002, MS Office suite, MS Visio 2003., MS-Office Suite, SQL, Business Object, Business Intelligence, ETL, Oracle, Java/J2EE, Rational Rose, Rational Clear 95/98/2000.

Confidential, CT

Sr. Business Analyst

Responsibilities:

• Gathered requirements by conducting meetings and brainstorming sessions with end users and SME and documention them using Requisite Pro - the documentation tool offered by Rational.
• Analyzed and translated business requirements into system specifications utilizing UML and Agile methodology. Conducted User Interviews and Work Shops to gather accurate Business Requirements. Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME’s
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Perform Gap Analysis of the processes to identify and validate requirements. Responsible for initiating the BPM process for all the projects.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content. Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
• Created Use Cases / Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle
• Organize requirements into high level Use Cases and low level Use Case Specifications and modeled them into Activity and Sequence Diagrams using Rational Rose.
• Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders. Created Mock-up forms in MS Access for better visualization and understanding of the software solution. Performed automated testing on the Java Application GUI using QTP.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication. Used SQL for Querying the DB2 database in UNIX environment Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Coordinate and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines. Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Assist the QA personnel in the creation of Test Cases using Rational Test Manager.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Helped in creating end user manuals and procedure manuals.

Environment: PL/SQL, SQL Server, Business Object, Business Intelligence, ETL, Oracle, XML, JAVA, Windows 95/98/2000, Web Logic, Mainframe, UNIX, Rational Req. pro, clear case, Rational Rose, Clear Quest, UML, MS Word, MS Excel, MS Access, Ms Visio, and Ms Project

Confidential, Jacksonville, FL

Systems Analyst

Responsibilities:

• Gathered; analyzed and documented business and technical requirements from both internal and external reviews and validated the needs of the business stakeholders.
• Moderated JAD sessions.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose and Requisite System Architect (RSA).
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data. Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Created use case scenarios and documented work flow and business process using Rational Rose
• Involved in project management using MS Project
• Documented requirements associated change requests with requirements and connected requirements with Use cases. Extracted data from various sources like Oracle, XML, Excel and COBOL Flat Files.
• Worked in iterative Rational Unified Process (RUP methodology)
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Assisted in building an Analysis Process Model using Rational Rose and Visio.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling. Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Teamed up with both internal and external software development teams to provide functional requirements specifications in the form of use cases, business process flows, and prototypes and management reporting requirements
• Coordinated with the developers, on day-to-day basis, during the development process.
• Facilitated preliminary sessions with the client SMEs for the upcoming 5010 transaction sets on Claims and Payment. Identified needed modifications for upcoming ICD9/ICD10 directives from the then available documents from CMS.
• Managed the team of consultants responsible for developing on-demand Medicaid Management System reports.
• Designed the online screens and reports for the Medicaid Online Electronic Claims Submission System.

Environment: MS Excel, RUP, MS Word, MS Excel, MS Access, UML, Rational Rose, Requisite Pro, Rational Clear Quest 2002, MS Office suite, MS Visio 2003., MS-Office Suite, SQL, Business Object, Business Intelligence, ETL, Oracle, Java/J2EE, Rational Rose, Rational Clear 95/98/2000.

Confidential, Louisville, KY

Systems Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Moderated JAD sessions.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Used Agile Software Development process viz. Scrum, as this was a time bound project
• Contributed to software process-reengineering efforts aimed at evolving previous software development practices to adopt Lean/Agile and Scrum practices
• Provide innovative IT, business & e-commerce solutions to perspective and existing clients.
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Created use case scenarios and documented work flow and business process using Rational Rose
• Involved in project management using MS Project
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Assisted in building a Analysis Process Model using Rational Rose and Visio.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Teamed up with both internal and external software development groups to provide functional requirements specifications in form of use cases, business process flows, and prototypes and management reporting requirements
• Worked in iterative Rational Unified Process (RUP methodology)
• Coordinated with the developer, on day-to-day basis, during the development process.
• Tested the report for its content.
• Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access
• Created Test Scripts & Test Scenarios to check report content, layout, and parameters.
• Worked on Report Re-engineering Project and made enhancements to the system flow.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel

Environment: JAVA, MS Access 2000, MS Excel, RUP, Mainframe, Oracle, MS Word, MS Excel, MS Access, UML, Rational Rose, Requisite Pro, Clear Case 2002, SQL, Oracle, Java/J2EE, Rational Clear Quest 2002, MS Office suite, MS Visio 2003.

Confidential

Business Analyst

Responsibilities:

• Performed SWOT and GAP analysis for new functionality requirements as well as prioritized them based on actual business needs.
• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked on profiling the data for understanding the data and ETL specification document.
• Collaborated with business and technical teams to reengineer and translate the current trading process into new requirements that encompassed an improved solution. This included defining a new trading flow, data mapping, data messages, exception handling, gaps and impacts.
• Extracted data from various sources like Oracle, XML, Excel and COBOL Flat Files.
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Involved in the performance tuning of the DataStage Jobs and SQL queries.
• Facilitated JAD sessions and conducted peer review meetings periodically to keep track of projects milestones.
• Developed business requirement specification documents using Requisite Pro.
• Developed UML diagrams such as activity and other flows to document and present to business users using MS Visio. Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration.
• Worked with various ETL tools for the generation of data marts for reporting purpose.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Acted as the liaison between the client and the development team at offshore.
• Participated as lead analyst for JAD sessions pertaining to the Lease Management phase.
• Acted as liaison for projects with other corporate functions like Technology, Legal, and Vendor Services.
• Helped in QA methodologies like regression testing, phases like SIT & UAT, and documentation like unit test plans.
• Conducted end-user testing; created testing strategy, test plan and performed test tracking for all scenarios.

Environment: Rational Suite (Rose, Requisite Pro), Windows XP/NT, ASP.Net, PowerPoint, Oracle. MS SQL Server, JSP, XML, MS Office Suite, MS Visio, WinRunner, Test Director, Load Runner, Team site Content Management Tool.