SUMMARY:

• 7+ years of IT experience with expertise in Business Analysis in Healthcare/Insurance/Telecom Domain.
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow - Flake schema
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.
• Expert at assessing business requirements and defining traceable, understandable application requirements
• Deep understanding of enterprise data warehouses.
• Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Expertise in writing JavaScript, HTML, DHTML, VBScript, XML and XSLT.
• Experience in Agile and Scrum Methodologies and related terminology such as Daily Scrum, Product Backlog, Release Burndown, Scrum Master, Sprint Planning Meeting, Task board, To-do and Work in Process Charts.
• Expertise in using the testing tools such as Mercury Quality Center (QC)/Test Director and Quick Test Pro (QTP).
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Experienced with System Development Methodologies (SDLC), Prototyping, ER Modeling, Functional Hierarchy Diagrams, Data Flow Diagrams, RDBMS, Object Oriented Programming Approach, Design Patterns, UML, Data Warehouse (ETL/OLTP/OLAP), Unix Shell Scripts, Service Oriented Architecture (SOA), SharePoint & BizTalk Messaging.
• Strong knowledge and experience in healthcare industry working knowledge on HIPPA and Medicare Management Information System (MMIS).
• Exposed to using ICD 9/ICD 10 coding standards in Medicare and Medicaid domains of the healthcare systems and industry for inpatients, outpatients, Reimbursement methodology.
• Experience in writing Business Requirements Document (BRD), Functional Requirements Document (FRD), Request for Proposals (RFP), Statement of Work (SOW)
• Extensively worked on MS Access, MS Excel, MS Visio, MS PowerPoint, MS Project, and Oracle/ SQL.
• Extensive experience in requirements gathering, feasibility analysis and successive documentation in project related artifacts like the User, Functional and System Requirements Specification documents.
• Experienced with Medicare and Healthcare Insurance; as well as Medical Standards (HIPAA and HL7)
• Built Queries to test various Pharmacy, Medical Regulatory Reports for various Line of Business
• Worked on Data Analysis & Reporting for Data Conversion/Migration project.
• In depth knowledge of Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Providing solutions and enhancements for product, reporting, and application functions
• Comprehensive background in all areas of Medicaid and Medicare billing and claims processing
• Creating artifacts such as URS, FRS, Traceability Matrix, project plan, BRD, test plans, and test cases
• Experience running scripts to check web user interface and Portals for Broken Links, Frame Properties, Table Properties, URL links, Images, Text and prepared Test Metrics to test execution status and results
• Proficient in creating User Acceptance Test (UAT) Plan and; implementing and coordinating UAT
• Developing AS-IS and TO-BE systems, and translating business needs into technical changes / developments
• Experience and understanding of Healthcare and Health Insurance business models and operations including Enrollment, Membership Management, Claims Processing, and Client Management
• Has demonstrated excellent interpersonal as well as written and verbal communication skills

TECHNICAL SKILLS:

Business Modeling Tools: Visual Paradigm, MS Visio, PowerPoint, Rational Rose

Requirements Gathering Tools: Rational RequisitePro, MS Word, MS Excel

Microsoft Tools: MS Office, MS Visio, MS Project

SDLC Methodologies: RUP, Prototyping, RAD, Scrum, Waterfall

Testing Tools: Mercury Test Director

Database: MS Access, Oracle 9i, MySQL

Operating Systems: Windows 2000/XP, Vista, DOS

Programming Languages: PL/SQL, VB.Net, QBasic, HTML, PHP, ASP.Net

Defect Management Tools: Mercury Test Director, Rational ClearQuest

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Sr. Business Analyst

Responsibilities:

• Utilized SDLC Methodology to configure and develop process, standards and procedures
• Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business workflows & task analysis and determine whether any current or proposed systems are impacted by the new development efforts.
• In depth analyzing & testing for 834/835 Inbound & Outbound process of X12 through X-Engine until Submission file to State in ETL Process for Various LOB's.
• Coordinated with various IT teams related to various backends (WGS, Facets, Nasco etc) for Test Data Setup in SIT & UAT environments
• Designed Test Plans, Scripts after analyzing various scenarios/requirements & performed defect tracking using Test Director & Clear Quest
• Projects included designing retail architecture for Do Not Solicit, Customer Proprietary Network Information, U-Verse and DSL product sales and Order Life Cycle Reporting applications. Adhered to a Service-Oriented Architecture framework and utilize System Development Life Cycle and IT Unified Process techniques for all ongoing projects.
• Facilitated problem solving, client interface interaction design, analysis of data flow/data model, and technical leadership with business intelligence teams.
• Performed User Acceptance testing & End to End testing in interaction with Offshore QA/dev teams for various system releases & pushed them to production
• Provided Production support, documented System Release/deployment issues & SOX documentation for Business Signoff.
• All work performed in a SOA (Service Oriented Architecture) and using an Agile development methodology.
• Design/implement multiple enterprise business intelligence solutions.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Analyzed various 834 Claims, Membership, Billing, Benefit and plan
• Work closely with EDI to ensure accuracy in data transmissions and shared processes. Transaction sets processed (834,835)
• Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Mercury Quality Center.
• Author release management plans, release notes and code migration documents.
• Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data
• Always maintained excellent problem-solving and communication skills; and effectively listened, negotiated, debated, discussed, brainstormed, communicated, and collaborated with a variety of individuals and groups

Environment: Life70, DB2, QSAM, VSAM, TeamWorks, EZTRIEVE, COBOL, Assembler, J2EE, MS SQL Server 2005, MS Office, MS Visio, Certify, MQC, VB.Net, Java

Confidential, Palo Alto, CA

Business Systems Analyst

Responsibilities:

• Gathered User and Business Requirements through interviews, surveys, prototyping and observing Stored and modified requirements.
• Liaised between technical and business teams for obtaining status/updates as well as sharing best practices.
• Created Need Analysis Documents of the requirements gathered through JAD and JRP individual elicitation sessions using MS Word.
• Created User Requirement Specifications (URS), Business Requirement Document (BRD) and Functional Requirement Specifications (FRS) documents.
• Created Use cases, Use Case Diagrams, Activity Diagrams and Business flow diagram using Rational Rose and Rational Requisite Pro.
• Involved in analysis of the technical specifications of the current system and the infrastructure needs performed Gap analysis.
• Created complex stored procedures using SQL with multiple table joins and comprehended and isolated areas problems.
• Made Screen Mockups/Definitions and Dependencies using Excel.
• Extensively used SharePoint to document project processes and procedures, communicate requirement and version control them.
• Collaborated with Quality Assurance Analyst in Rational Clear Quest to track defects and used Rational Clear Case to maintain consistency in the builds.
• Experienced setting up test scenarios and executing on these scenarios and worked closely with testing team to make sure all the changes made to requirements documents are implemented in there Test Cases
• Maintained various versions of the documents generated during the project using Rational Clear Case
• Used Agile development methods to promote development iterations, team work, collaboration and process adaptability and strong experience with Scrum
• Created User Stories to capture all requirements.
• Set up definitions and process for test phases including Product test, Integration test, System test and User Acceptance Test (UAT).
• Conducted GUI testing, Functional Testing, Smoke Testing, Integration Testing, Performance and User Acceptance Testing on the application.
• Extensively worked on Mercury Test Director for bug reporting/tracking.
• Worked with SQL extensively to test database integrity.
• Involved in maintaining the Requirements Traceability Matrix (RTM) across the deliverables for a project
• Conducted Training Sessions to familiarize users with system.

Environment: Agile/Scrum, Rational Rose, Rational Requisite Pro, UNIX, MS Visio, MS Project, MS SharePoint, HTML, Windows, Oracle, SQL, people soft, IBM Web sphere, Business Intelligence.

Confidential, NYC, NY

Business Analyst

Responsibilities:

• Assisted in the Project manager in creating and updating the Vision Documents, Business case, and the Project Plan to define Objective, Scope and Risks. Also, assisted in creating RUP iteration plans and phase plans
• Elicited requirements, and managed Change Configuration to maintain an orderly procedure for managing requirement changes after sign off
• Elicited functional specifications, conducted feasibility analysis, and performed impact analysis
• Elicited Business Rules and other Non-functional specifications for the new system by interviewing the Subject Matter Experts (Doctors & Nurses) to further understand the business models
• Authored functional specifications for different HL7 system interfaces: ADT (registration), SIU (scheduling), OMG (rad order entry), and ORP/RDS (Rx processing)
• Responsible for Back-End Testing Using SQL Commands using TOAD.
• Documented and reported feedback made by users. Documented out of scope (but relevant) requirements to aid in new Initiatives or Enhancement projects (future upgrades)
• Created Request for Proposal to identify possible vendors and obtained cost and functionality information
• Created UML Activity Diagrams to depict business processes (AS-IS and TO-BE) and analyzed them for their efficiency and productivity
• Tracked UAT issues/bugs and prepared reports.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Created Use Case Model using Rational Rose for developers and other stakeholders to understand the business process, depict roles, and procedures
• Facilitated requirement-eliciting sessions (JAD sessions) with Subject Matter Experts and other Key Users and documented the requirements in an easy to understand format by both the business and technical personnel
• Constructed Use Cases and Wireframes and translated them into a Functional Requirement Specifications document
• Performed manual testing, including validation/smoke testing of HL7 interface messages on each new build before delivering to quality assurance team
• Assisted quality assurance team to functional-test the new HL7 interfaces always keeping in mind HL7 and HIPAA guidelines, and coordinated user acceptance testing using derived test data
• Created Online User Guide comprising different scenarios, screenshots, and troubleshooting procedures

Environment: MS Project, MS Excel, MS Word, Rational Rose, MS PowerPoint, UAT, Oracle 9i, Citrix (server), Epic

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Worked as an Interface between the Users and the different teams involved in the application development for the better understanding of the Business and IT Processes.
• Analysis of Business requirement and creating business rules for data cube using Performance Point Server Biz Modeler.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Involved OLAP reporting system implemented in Business Objects to provide business intelligence capability to Asset Managers
• Executed all efforts within the SDLC parameters of the IT organization leveraging existing technologies, proven system architectures and management team.
• UAT testing performed along with call center managers to make sure that application meets their requirements.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Design, development, implementation and roll-out of Micro Strategy Business Intelligence applications
• Followed a structured approach to organize Requirements into logical groupings of essential Business Processes, Business Rules, and Information needs that insures any Critical Requirements are not missed
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.
• Created and maintained business rules in Performance point server for data cubes to enhance data cube security.
• Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript
• Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Generated XML documents using the XML Output Stage.
• Troubleshot the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Created jobs sequences.
• Created job schedules to automate the ETL process.
• Enhanced the job properties for performance tuning.

Environment: Windows NT, Windows Vista, Teradata, Oracle, ETL, INFORMATICA, Business Intelligence(BI), Performance Point server, Visual studio, Business modeler, Visio, Windows XP, Office 2007, SQL Server 2005/2008

Confidential, India

Business Analyst

Responsibilities:

• Worked in accordance to the activities/roles laid down in each phase of software development life cycle created using Rational Unified Process
• Organized meetings to elicit expert knowledge of the TO-BE business process in an effort to generate requirements
• Analyzed business requirements and created Use Cases, activity diagrams using MS Visio
• Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests
• Updated requirements document, Use Cases, and FRS according to Change Control Committee’s approval of CR and the Traceability of the documents
• Performed GAP Analysis by comparing the existing system to the future system to create “AS-IS” and “TO-BE” flow charts and generating risk assessment
• Drafted a Traceability Matrix in Excel and imported it into Rational RequisitePro
• Worked as a liaison between the developers and the QA team in creating the Test Plan and Test Cases using Rational Test Manager. Generated test data, and assisted QA team with manual testing whenever possible
• Maintained and Reviewed Change Requests and documented all analysis
• Conducted User Acceptance Tests to ensure that all mutually agreed upon user requirements had been met and to gather additional requirements for enhancements to the application for future release

Environment: J2EE, XML, HTML, UAT, WebLogic, Oracle9i, MS Word, MS Outlook, MS PowerPoint, MS Visio, Rational RequisitePro

Confidential

Business Analyst

Responsibilities:

• Facilitated JAD sessions, introduced use cases into application development methodology and created client approval process for project methodology.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Managed the HEAT Trouble Ticket Tracking application and the Avaya ACD Server.
• Enhanced and maintained the Billing Application used by DPI software package.
• Manage the product development of a proprietary system enabling the integration of electronic invoicing with traffic, billing systems, and order fulfillment
• Prepared & presented weekly and monthly business operations review before the senior leadership team
• Responsible for conducting meetings & providing training sessions for Suppliers for improving External Balance Score Card.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Provided post production support/analysis and assisted in performing User Acceptance Testing (UAT), performance testing and validated test plans.
• Tested Performance & Accuracy related queries under SQL Server.
• Created bi-weekly reports and conducted client meetings to track the progress and timely delivery of final deliverable.
• Plan, schedule, initiate, and follow up with quality engineering procedures to improve and maintain product quality
• Involved in project management using MS Project
• Aligned requirement documentation with use of UML for object oriented software development (OOD).
• Created detailed functional specifications for development team
• Documented the Use Cases and prepared the Use Case, Activity, Logical, Component and Deployment views using MS Visio and Rational Rose for a clear understanding of the requirements by the development team. Coordinated with testers in using Rational ClearQuest for defect tracking
• Reviewed Integration Test Plan for integration between modules.