SUMMARY

• Over 11+years of experience in the Information Technology sector analyzing, developing, implementing, validating systems and Team management as a Technical Business Analyst.
• Comprehensive understanding of the work flow analysis in Information Technology, Healthcare Payer Industry.
• Proficient in using SQL Server 2005/2008 for the development of SQL queries, Stored Procedure and functions.
• Having good experience in Healthcare Revenue cycle Management, ICD 9 - 10, HIPAA 5010, EDI Transactions.
• Strong knowledge of Software Development Life Cycle (SDLC) methodologies like Iterative, Agile, Waterfall.
• Extensive knowledge of SOA, Object Oriented Analysis and Design (OOAD) using UML and MS-Visio.
• Thorough Knowledge of implementing RUP in all the phases Inception, Elaboration, Construction and Transition of a project.
• Proficient in creating UML diagrams including Use Case Diagrams, Behavioral Diagrams (Sequence Diagrams, Collaboration Diagrams, Activity Diagrams and State Chart Diagrams), Class Diagrams, Data Flow Diagrams (DFD), and E-R Diagrams using Rational Rose and MS-Visio.
• Experience in generating reports using Crystal Reports
• Experience in interacting with business users to identify information needs and initiating process changes.
• Proficient in identifying, documenting and analyzing business requirements specifications (BRS), System Design Specifications (SDS) and Software Requirement Specification (SRS).
• Strong business acumen, strategic thinking, communication, interpersonal and presentation skills adept at creating, editing, and coordinating extensive communication networks (facilitation of Rapid Application Development (RAD) sessions and interviews, written correspondence, reports, implementation requirements, project status reports, oral presentations, e-mails, etc.) to keep executive staff and team members abreast of goals, project status, and resolving issues and conflicts
• Strong facilitation skills and experience in leading requirements gathering, Use case walkthroughs and functional requirement sessions.
• Experiencing in developing Test Plans, Test Case Scenarios and usability testing
• Maintaining documents in SharePoint 2010 and working on .Net Environment.
• Experience in involving in User Acceptance Testing (UAT) and considerable knowledge of Gap Analysis.
• Interacted with the team members to analyze and understand the issues in the system
• Adapts new systems and environments quickly. Good work ethics, take ownership of all duties, responsibilities in meeting management skills. Group and individual based problem solving and decision making skill.
• Act as a liaison between business and systems during analysis, Development and testing phases.
• Worked with cross functional teams like development, testing, documentation, project / implementation team to disseminate requirements and their implementation.

TECHNICAL SKILLS

Operating System: Windows Vista/NT/XP

Business Tools: Rational Rose, Visio, MS Project, Data Stage, SharePoint 2010

Database: MS Access, SQL Server 2005/2008, Oracle 9i

Reporting Tools: Crystal Reports

Software packages: Visualbasic6.0, MS-Office - Word, Excel, PowerPoint, Outlook, FrontPage, Visio, Project, Access

PROFESSIONAL EXPERIENCE

Confidential, El Dorado Hills, CA

Technical Business Analyst

Responsibilities:

• Prepared Business Requirement Document for the Tool.
• Designed and developed wire frames for the screens of each and every module in the tool which will be strong ground work for development.
• Involved in an in-depth Gap analysis, generating reports and maintaining documentation of the Gaps captured during the Gap Sessions.
• Designed and developed database, SQL Queries, functions and stored procedures for iCRM tool using SQL Server 2008.
• Did performance tuning in SQL queries for the faster performance and execution of SQL queries.
• Created wireframes of the screens in every module which will make the development and the testing team more feasible in understanding of the functionality.
• Created Use Case Models, Analysis Models, Design Models, Implementation Models, authored Use Cases, Use Case Diagrams, Behavior Diagrams (sequence diagrams, collaboration diagrams, activity diagrams) based on UML methodology using MS Visio.
• Designed and coordinated for the development of the security and encryption for the claims received in EDI format.
• Directed and managed the change control to ensure the incoming issues are new requirements or the bugs which need to be fixed.
• Gathered and documented the Impact Assessment on the project, due to change request, from the work stream owners and the project management team, in terms of project duration.
• Prepared and presented the process of the ongoing project in a form of Dashboard to the senior management.
• Co-ordinate with the project managers in the preparation of the project plans with any impact due to a change request.
• Prepared Impact analysis report document based on the version changes in the ICD 10 version releases.
• Conducted surveys, interviews and JRP (Joint Resource Planning) and JAD sessions and translated them into System Requirements.
• Used SQL queries to review the current claim details which have been maintained in current Benefit administrator tool.
• Using SQL, fetched data from benefit administrator tool database for data analysis of ICD codes.
• Performed Data Analysis on the historical data using SQL queries in SQL Server 2008, which will be useful for the pilot run of the ICD 9- ICD 10 conversion.
• Using SQL developed complex queries to fetch data for the given reports in the iCRM tool.
• Migrated data from base database to iCRM tool using SQL server 2008.
• Reviewed the functional test cases and updated the missed functionalities accordingly.
• Coordinated the UAT for the sign off on the tool from the customer end.
• Conducted project related presentations and provided reports including graphs to the higher management.
• Coordinated with the Business Users and resolved the day to day issues which were raised by them.
• Administrated and managed the content management using Documentum 7. Provided access and rights to the specific users based on their role in the project.
• Maintained audit trails and records in Documentum for the purposes of regulatory compliance in the project.

Environment: ASP.Net, C#, SQL, PL/SQL, MS SQL Server, XML, MS Office Suite, MS Visio, WinRunner, Test Director, Load Runner, Windows XP /2003.

Confidential, New Jersey

Technical Business Analyst

Responsibilities:

• Analyzed Business Requirements, and segregated them into high level and low level Use Cases based on the project scope and followed the RUP methodology
• Created database and developed stored procedures, functions and performed all PL/SQL activities related to the project.
• Carried out performance tuning activities using SQL to speed up the fetching of data.
• Conducted the Functional Requirements and User Requirements Specification reviews and walkthroughs with designers, developers and stakeholders
• Prepared a package of Process Flow diagrams to document the existing system and used UML notations for Object Oriented Design and Documentation
• Involved in designing and developing workflow diagrams for different modules using MS Visio
• Responsible for identifying gaps in the software between core functionality and user defined requirements
• Provided estimates to Project Manager on Change Requests for Analysis, Development and Testing
• Manual testing for checking the data flow of the application using SQL.
• Coordinated with Business Users and Development team for setting up Test Environment, Test Data and Backend Interfaces
• Assist and guide project teams to implement and document standards, procedures, artifacts, and plans consistent with QA and Test deliverables for the project team
• Mentored QA Team by looking into different technical problems with development and helped them prioritize testing tasks
• Tracked defects using Test Director Tool. Analyzed test progress and send weekly progress reports to the Project Manager
• Actively trained Business Users involved in User Acceptance Testing (UAT) and helped them understand UAT procedure.
• Used complex SQL queries and procedures to migrate the database from the existing system to new HPSTA application.
• Wrote complex SQL procedures and functions to fetch data for the data processing.
• In HPSTA tool developed reports based on SQL server 2008 SSIS and SSRS.

Environment: ASP.Net, VB.Net, SQL, PL/SQL, MS SQL Server, XML, MS Office Suite, MS Visio, WinRunner, Test Director, Load Runner, Windows XP /2003

Confidential

Technical Business Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Designers and Developers, Project Manager to get a better understanding of the Business Processes.
• Analyzed, designed and developed database for the tool Lorenzo using SQL server 2005.
• Created tables, procedures and functions for the manipulation of data in the tool using SQL and PL/SQL.
• Identified Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), ER Diagrams and Web Page Mock-Ups using Rational Rose and MS-Visio thus defining the Business Process Model and Data Process Model
• Assisted in technology selection for the application, based on Cost-Effectiveness and Quality with an eye towards the future.
• Designed SOA for the new functionalities in tool which will make the generic middle tier layer in the tool
• Performed Feasibility, Adaptability and Risk Analysis to identify the business critical and high-risk areas of the application.
• Communicate with design, development and test team using MS exchange Messaging and Defect Tracking System.
• Extensively worked on standard operating procedures.
• Participated in various testing related review meetings.
• Used the Unified Change Management (UCM) tool, Rational Clear Quest, to maintain and track the Stakeholders requested enhancements and changes. Used Rational Clear Case, a Configuration Management tool to maintain different builds of the application with description about all changes and Versions.
• Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Generated reports for Lorenzo tool based on the SQLServer SSRS.
• Identified the database entities, attributes, and also finalized their multiplicity and cardinality.
• Performed data analysis and data migration process for the implementation of the Lorenzo tool.

Environment: Rational Rose, Visio, Microsoft Project, Visual Studio .NET, SQL, SQL Server, Windows 2000.

Confidential, Philadelphia

Business Analyst

Responsibilities:

• Participated in requirement gathering with clients to ensure that all requirement analysis were satisfactorily met and performed using Rational RequisitePro.
• Prepared Business requirement document (BRD) using Rational RequisitePro.
• Facilitated and managed meeting sessions with committee of stakeholders from various business areas.
• Identified use cases from the requirements and wrote use case specification
• Maintained relationships with clients to manage expectations of service including work products, timing, and value to be delivered.
• Used extensive knowledge of client's business/industry to identify technological developments, understand business processes and identify best practices, evaluating the impact on client's business.
• Provided senior management with reports on potential business opportunities and improvements in the system.
• Created use cases and business use case model after accessing the scope and status of the project and understanding the business processes from USER perspective.
• Monitored client expectations through client involvement and communicated through the lifecycle of the project, educated clients and stakeholders on the benefits and risks associated with the project
• Prepared cost and time estimates for development projects
• Developed time lines for project delivery & managed projects & resources to successful completion.
• Track and maintain stakeholder requested enhancements and changes using Rational RequisitePro.
• Recommended and ensured appropriate training was available for all users.
• Used SQL Server Reporting services for the development of the reports in the OESS tool.

Environment: ASP.Net, VB.Net, SQL, PL SQL, MS SQL Server, XML, MS Office Suite, MS Visio, WinRunner, Test Director, Load Runner, Windows XP /2003

Confidential, Delware County

Business Analyst

Responsibilities:

• Worked with the business community of different departments to gather their requirements.
• Developed and implemented RUP processes and tools for requirements gathering, analysis, planning, tracking and delivery.
• Performed GAP analysis by working closely with the users to understand their current state of information availability in and defined future needs based on analysis of business requirements.
• Organized and conducted JAD sessions with different groups of users.
• Actively involved in preparation of Entity Relationship Diagram.
• Created database, stored procedure, functions and other PL/SQL activities using SQL Server 2000.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
• Coordinated UAT and training.
• Prepared the screen layout of the various reports that was generated at the end of the month for different departments.
• Facilitated discussions to help the business people anticipate future needs/requirements and opportunities with regards to various reporting structures.
• Developed timelines for project delivery, and managed projects and resources to successful completion.

Environment: ASP.Net, VB.Net, SQL, Stored Procedure, MS SQL Server, XML, MS Office Suite, MS Visio, WinRunner, Load Runner, Windows XP /2003

Confidential, Philadelphia

Business Analyst

Responsibilities:

• Work with business users and user group managers to define requirements and document existing and new business work flow and business processes
• Thoroughly document all existing applications to be replaced using Visio
• Developed detailed workflow analysis for areas not automated
• Developed high-level design of new processes, graphically presented along with text based requirements to IT management
• Involved in Agile methodology for all phases of the Project
• Used Rational DOORS to link requirements to design items, test plans, test cases and other requirements for traceability
• Conducted informal requirements discussions with DOORS Discussions
• Use ClearCase and ClearQuest for version control and defect tracking
• Conduct JAD sessions to refine prototypes, prioritize and time-box use cases
• Interview clients & define functional, non-functional requirements, captured in Requisite Pro
• Facilitated and managed meeting sessions with committee of SMEs from various business areas.
• Successful replacement of the way the application gets rate information from a database based back-end to an XML based middleware. Act as the main requirements analyst for creating this XML based middleware so other groups in the company can also query the created middleware for rate information
• Assist in preparation of Request for Proposal (RFP) for finding out the right vendor for off the shelf products.
• Defined high-level system actors and Use Case text reflecting the scope of the project
• Generate initial use-case diagrams using UML in Rational Rose
• Document test cases during requirements, analysis and design phases
• Create dashboards, metrics, analytics, goals, alerts using Business Objects XI enterprise.

Environment: Rational Rose, Visio, Microsoft Project, Visual Studio .NET, SQL Server, Windows2000.

Confidential

Business Analyst

Responsibilities:

• Interface with business partners, capturing business requirements, documenting individual project requirements and reporting status of deliverables formally and informally.
• Studied the working of the existing system to analyze the different kinds of reports that are to be generated for the senior management
• Work independently, provide guidance to middle office and staff in various phases of project life cycle.
• Elicit requirements using interviews, document analysis, requirements workshops, business process descriptions and workflow analysis
• Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs
• Facilitate development of UAT test scripts and business procedures
• Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs. Act as a liaison between the business units, technology teams and support teams
• Develop and guide project initiative requirements
• Ask all universal questions to define project, estimates man hours required to accomplish specific tasks for budget purposes, obtains authorization; designs project plan, constructs project plan, tests all areas of project with focus on quality assurance to find all errors before implementation, implement plan, develops and trains appropriate audience
• Facilitate requirements gathering and fact finding sessions as required
• Work closely with business and cross-functional technology team members to document and communicate business goals and objectives
• Strong working knowledge of MS Word, MS Excel, MS Outlook, and PowerPoint

Environment: VB 6.0, SQL, Stored Procedure, MS SQL Server, XML, MS Visual Basic, MS Office Suite, MS Visio, WinRunner, Load Runner, Windows XP .

Confidential, New Jersey

Business Analyst

Responsibilities:

• Gathered Business Requirements, interacted with the stakeholders, developers, Project Manager and SME’s and facilitated JAD sessions to formulate Business Processes.
• Prepared User Requirements Document (URD) and Functional Requirements Document (FRD).
• Developed Use Cases and Use Case Scenarios and visualized those using UML diagrams in MS Visio.
• Designed the User Interface prototype for the Customer Information System based on the Business and Functional Requirements using MS FrontPage.
• Conducted surveys and questionnaires with the end customers and escalated their concerns to the management to better meet their expectations from a Business standpoint as well as a User Interface usability standpoint.
• Initiated Impact Analysis to study the feasibility of the IT integration and expected downstream results by identifying and review multiple business scenarios.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
• Developed a Traceability Matrix to keep track of the Requirements, Use Cases and Test Cases.
• Reviewed Test Plan and Test Cases to ensure that they met the requirements.
• Assisted the development team with design and development of the application, provided usability metrics collected from user surveys.
• Resolved found bugs with developers and clarified any ambiguities.
• Acted as liaison between the senior management and different teams with effective presentations to achieve best results.
• Recommended and coordinated development efforts and enhancements.
• Involved in different phases of Test effort like Smoke/Sanity Testing, Functional Testing, Regression Testing and UAT.
• Acquired the business Sign-Off on the User Requirements Document (URD) and functional requirement document (FRD).
• Provided technical recommendations for concise reporting format.
• Actively involved in walkthroughs and meetings with development team to discuss related issues.
• Documented best practices in the project for reusability.

Environment: VB 6.0, SQL, PL SQL, MS SQL Server, XML, MS Visual Basic, MS Office, MS Visio, Windows XP .