SUMMARY:

• About 7+ years of industry experience as a Business/ Data Analyst in Healthcare Industry with substantial understanding of Business Requirements Gathering, Software Development Methodologies, Business Process Modeling, Data Modeling and Business Intelligence.
• Experience in managing and conducting JAD sessions, Brainstorming, Interviews, Surveys, Focus Groups as well as Workshops and interacting with the internal and external Stakeholders to resolve issues
• Worked extensively on Business Process Modeling, Gap analysis, Risk analysis, SWOT analysis, Feasibility analysis and estimation of ROI.
• Extensive experience in creating various artifacts including Business Requirement Document (BRD), Software Requirements Specification (SRS), Functional Requirements Document (FRD), Test Plan, Test Scenarios, and Test Cases as well as documenting project processes and procedures.
• Proficient in UML Modeling like Use case Diagrams, Activity Diagrams, and Sequence Diagrams with Rational Rose and MS Visio.
• Managed requirements and tracked defects working with HP Application Lifecycle.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
• Strong knowledge of Unified Modeling Language (UML), System Development Life Cycle (SDLC) methodologies like Waterfall, Rational Unified Process (RUP) andAgile/SCRUM.
• Experience inDataMining,Datamapping andDatamodeling and good understanding of the ETL tools like AB Initio, SSIS and Informatica Power Center.
• Experience with working in UNIX/Linux operating systems.
• Extensive experience in writing Complex SQL Queries, inline queries, elated sub queries, Dynamic SQL queries, T - SQL queries, and PL/SQL stored procedures etc.

TECHNICAL SKILLS:

ETL Tolls: Informatica Power Center Informatica Power Exchange, SSIS, SSRS

Database Tools: SQL Plus, SQL Loader, SQL Developer, Python, TOAD, Teradata, ETL,Data Stage/Quality Stage, Cognos BI SAS

Operating System: Windows Server, Windows Server, Windows NT / XP and Windows Linux, UNIX

Tools: Java, MS Office, MS Project, TOAD, MS Visio, Rational Rose, Rational Requisite Pro, Clearquest, Clearcase.

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, Doors Erwin Data Modeller, Business Object (Crystal Reports)

Data Tools: Agile Project Manager, UML, Visio, RUP, SME,Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Colmar, PA

Sr. Business /Data Analyst

Responsibilities:

• Gathering requirements from users and SMEs through interviews and questionnaires.
• Reviewed and analyzed the business requirements document (BRD) to derive the functional specifications document (FSD) and assisted in the preparation of System Requirement Specifications.
• Organized and participated in JAD sessions with developers, users testers, users and other stakeholders.
• Authoring business requirements document and Use Case documents using various UML based methods like Use Cases, Process Flow Diagram, Activity Diagrams and Sequence Diagrams
• Creating application Prototypes and screen mock-ups.
• Interacting with Subject Matter Experts and establishing a business analysis and design methodology around Waterfall.
• Performing end-to-end analysis and design of business systems including needs assessment, requirements gathering, prioritization, estimating and risk assessment.
• Conducted the project meetings successfully by coordinating all users, technical staff and support personnel
• Participated in Planning and provided time estimates for project related tasks.
• Regularly follow up with the development team to discuss defects identified during Testing.
• Performed Regression testing on the entire application and log Issues.
• Responsible for checking the daily s
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence.
• Developed several forms & reports using Crystal Reports.
• Extensively used Agile Methodology in the process of the project Data Quality Managementt based on SDLC.
• Installed and configured Cognos BI and worked with Cognos BI modeling, Report Studio.
• Configured SSIS packages to in corporate slowly changing dimensions for tracking historical data.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Tested the application by writingSQLQueries and creating pivot views as to perform back-endtesting.
• Involved in performing a gap analysis on the existing data model of the staging layer versus the requirement on Data Data Quality Management

Environment: RUP, Rational Requisite Pro, Java, Visio, MS Project, Business Intelligence, SAS, MS Office, Python, SQL Server, SSIS, SSRS, Crystal Reports, Shell Scripting Linux, UNIX

Confidential, Roanoke, VA

Business/ Data Analyst

Responsibilities:

• Gathered User and Business Requirements through interviews, surveys, prototyping and observing Stored and modified requirements.
• Extensively worked with Project Manager to determine the current best practices for requirement gathering.
• 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.
• Implemented business intelligence dashboards and developed detailed and summary reports, line and pie charts, trend analysis reports and subreports according to business requirements using tableau and SSRS.
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Involved in analysis of the technical specifications of the current system and the infrastructure needs performed Gap analysis.
• Experienced setting up test scenarios, executing these scenarios in Microsoft Test Director. Worked closely with testing team to make sure all the changes made to requirements documents are implemented in there Test Cases.
• 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, Performance testing on the application.
• Created RequirementsTraceability Matrix (RTM) across the deliverables for a project.
• Created and maintained reports and documents on SharePoint.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems.
• Broad Understanding of Cognos BI tools and ability to translate user requirements into Framework Manager Models and reports.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.

Environment: Shell Scripting Linux, Java, UNIX SQL Server, Crystal Reports, Business Intelligence, SAS, Rational tools like Rational Rose and Requisite pro, Rational Clear Quest, Agile/Scrum, Cognos BI Business Objects, Test Director

Confidential, Dayton, OH

Business Analyst

Responsibilities:

• Performed extensive task which include DataQuality Analysis,Datalineage andDataStandardizationdatastructures,database design,data warehouses, business intelligence/analytic tools, SQL, ETL tools, anddataintegration methods
• Highly experienced in developing decision support applications with Cognos and other Business Intelligence, ETL and database tool suites
• Designed and Developed Adhoc reports by extracting data from Oracle PCARD Data warehouse using SQL Plus.
• Worked with Waterfall methodology during the beginning of the project then transitioned to Agile methodology
• Handled Source to TargetDataMapping, Technical Specs documentation, and ETL documentations such as EarlyDataInventory DesignedSSIS Packages to transferdatabetween servers, loaddatainto database on SQL Server 2005 environment and deploy the data.
• Perform Metadata analysis of the Grants data dictionary from various grants systems
• UsedDatawarehousing forDataProfiling to examine thedataavailable in an existing database.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Participate in the scrum meeting and also represented the teamduring the meeting
• Working through the phases of SDLC using the Agile methodology
• Responsible forDatamapping testing by writing complex SQL Queries using WINSQL
• Reviewed ETL and Business Objects defects and proposed fix for defects as per the scheduled timeframe
• Configured SSIS packages to in corporate slowly changing dimensions for tracking historical data.

Environment: Windows XP Toad for Oracle Version, SQL Server, Agile, Waterfall, Oracle, MS Office tools, Windows, SharePoint, MS Visio. PERL, Shell Scripting Linux, UNIX

Confidential, Tampa FL

Business Data Analyst

Responsibilities:

• Supported full traceability among all artifacts throughout the software development life cycle
• Extracted the Business Requirements during various sessions with business leads and tagged all requirements in Requisite Pro, tracing them all the way to the stakeholder requirements.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Extensively worked on Patient, provider, claims, and encounters data sets.
• Knowledge of various healthcare systems like Cerner, Epic, Star etc.
• Worked with several tools to access and perform several operations on database.
• Build and maintain SQL scripts to validate and profile healthcare data.
• Closely worked with development teams on business requirements and source to target mappings.
• Designed and developed specific databases for collection, tracking and reporting of data
• Involved in requirements gathering, Analysis, Design and Develop and maintenance Phases.
• Wrote advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Played a key role in planning UAT and implementation of system enhancements and data migration and conversions.
• Involved in extensiveDATAvalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Worked with Waterfall methodology during the beginning of the project then transitioned to Agile methodology

Environment: Oracle SQL, MS Access, MS Excel MS Word MS Outlook SSIS, SSRS, PowerPoint SharePoint