SUMMARY:

• Over 8+ years of extensive experience in Business Systems Analysis, Software Validation and business process re - engineering with proven ability to articulate business values.
• Experience in Business Systems Analyst, business requirements modeling and development of Web Based, and Client/Server applications in diverse business domains of Healthcare, Insurance and Financial Industry Sectors.
• Expertise in Business Process Modeling, Business Process Re-design and in designing Process Architecture.
• Functional experience with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Change Management, Technical, Software Development methodologies, QA testing, and Systems Testing of client server and web-based systems.
• Strong knowledge of managed care payer requirements and procedures.
• Very well experienced using Microsoft Office Suite - Word, Excel, Access, and PowerPoint.
• Excellent Project Management skills and Team Leading abilities.
• Conversant in a broad range of technologies and tools, including business process tools such as Erwin, Rational Rose, MS Visio, Data Analysis and Data Modeling.
• Expertise in Analysis of Problem Severity, Defect tracking and reporting system.
• Deep understanding of enterprise data warehouses.
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
• Well versed with client server environment and tools like SQL*Loader, UNIX shell scripts and TOAD
• Expertise in HealthCare Administration/Managed Care Systems working with various Claims Systems/Applications.
• Experienced in Quality Assurance and testing of Client Server and Web based Applications.
• Adequate knowledge in Health Administration - Claims processing (auto adjudication), COB, EOB/Drafts, Claims pricing and testing, HIPAA, enrollment, EDI, Medicare, Medicaid, CDHP (consumer driven health plans) and Edifecs Products.
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Good working knowledge of Claims processing, HIPAA Regulations and 270, 837P, 837I, 837D EDI Transactions for health care industries.
• Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).
• Excellent understanding of Data Models and Information Architecture and sound skills in SQL.
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center (8.1/7.x/6.x/5.x) /Power Mart 4.7, Datastage, Mainframes SAS, SSAS, SSIS, OLTP,OLAP, Business Objects.

TECHNICAL SKILLS:

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE

Automation Tools: MS Visio, Rational Rose, Rational Clear Case, Rational RequisitePro, Documentum, SharePoint Site, SQL Server, TOAD, Erwin.

MSAccess, MSProject, MS: Excel, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Web sphere, ATG Dynamo, BEA Web Logic

Bug Tracking Tools: Mercury Test Director, Rationa Clear Quest

Testing Tools: Quick TestPro (QTP), Test Director, Win Runner, Load Runner, Nike Project Workbench

Project Management: Project Planning, Resource Allocation, Risk Management, Evaluations

Development Methodologies: RUP, AGILE, Waterfall, ESDM, STV

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin, SAS

PROFESSIONAL EXPERIENCE:

Confidential, CT/ Vienna, VA

Sr. Business Analyst

Responsibilities:

• Requirement Elicitation.
• Created FRD Functional Requirement Document.
• Demo to users and gathered feedback from users.
• Created Test Plan, Test Cases for regression Testing and UAT.
• Tested for iOS 5 (iPad) versions.
• Used Planning Poker to estimate for sprints.
• Used Pivotal Tracker to track sprints.
• Tested charts for Color Blind users.
• Extracted data from existing system Clarity using Business Object, Cognos reports.
• Created Data Dictionary of existing data.
• Pulled sourced data from different source systems in Excel format.
• Mapped the existing data with Mock-ups.
• Created Action items for any chart which is Red or Yellow.
• Created/Managed user permissions and profiles.
• HIPAA and HL7 compliance.

Environment: Data warehousing, .Net, Cognos, ETL, Clarity, Business Object, SQL Server Integration Services (SSIS), JSON, SQL Server, Agile/Scrum, Pivotal Tracker, MS Office tools (Word, Excel, PowerPoint and Visio), iRise, MS SharePoint, HL7, HIPPA, iOS 5.0.

Confidential, Columbia, SC

Sr. Business Systems Analyst

Responsibilities:

• Worked in South Carolina Confidential to implement HIPAA X12 versions 5010 and NCPDP version D.0 which are new sets of standards that regulate the electronic transmission of specific healthcare transactions.
• Gathered analyzed and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Worked extensively with the Project Management and QA Team for designing Test Plan and Test Cases. Interacted with the users and logged any defects or enhancements for UAT.
• Conduct meetings and workshops with Subject Matter Expert, Project Manager, Developers, and the end-users to discuss action item log and risk factors.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Perform Gap Analysis of the processes to identify and validate requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Managed and traced requirements using Rational requisite pro
• Executed project management activities and managed the project team for an initiative to provide end to end order and product traceability for the business.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).

Environment: Java 1.4, J2EE 1.4, EJB, JSP, Java Swing, PL/SQL, Open Office.org 2.3, Oracle 10g, Documentum, SharePoint Portal Server 2003, SQL Navigator 3, OC4J, MS Office, Windows XP/2003, IBM Rational RequisitePro, IBM Rational Clear Quest, IBM Rational Clear Case.

Confidential, Harrisburg, PA

Business Analyst

Responsibilities:

• Interacted with SME’s to understand the current system and the expected changes.
• Conducted interviews, JAD sessions and one on one session with them to gather requirements.
• Developed the Business Requirement Document (BRD) and took the sign off from the SME’s.
• Wrote SQL queries to extract data.
• Closely interacted with designers and developers to understand application functionality navigational flow and kept them updated about business user’s sentiments.
• Analyzed system requirements and developed Test plan and Test cases for testing the functionality.
• Produced the visual models for the application using MS Visio.
• Involved in Testing.
• Reverse engineered the BRDs from Detail Design documents which were originally written by the technical team.
• Helped in creating user manuals.
• Used IBM Rational RequisitePro for Requirements and defects.

Environment: Oracle 8i, Mainframe, COBOL, JCL, CICS, DB2, SQL, UNIX, MS Visio, Java, MS Office.

Confidential, Union, NJ

Business Systems Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them and tested them.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Designed report templates based on the requests by account managers.
• Designed Functional Specification Documents for the reports.
• Extensive use of Excel to create Functional Specification Documents & Templates.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Web sphere and Cognos.
• Defined ETL strategy to capture new data, store historical data and update data warehouse in the most efficient way.
• Designed the process flow diagrams for flow of information and report creation process.
• Conducted RAD sessions for the report users, requestors, and the developers.
• Assisted in creating wireframes for web interface with the GUI design team
• Experience in Creating wireframes Mockup and storyboards
• 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.
• Modified System flow diagrams using SDLC.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).

Environment: .Net, C#, SQL, UNIX ES7000, HTML, XML, Windows 2000, Crystal Reports, Teradata, BizTalk, Cobol, CICS, JCL, DB2, HL7.

Confidential

Business Analyst/Tester/SME

Responsibilities:

• Documented user requirements.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.
• Preparing Test cases based of functional requirements.
• Performed Smoke, System and User Acceptance Testing.
• Designed and imparted various user .
• Worked as SME.
• Followed CMMI guidelines.

Environment: Windows NT, SQL Forms, PL/SQL, ATL COM, SQL SERVER 7.0, VC++ 6.0, MFC, C++, COM/DCOM, MTS, ADO 1.5, OOAD, Crystal Reports 6.0