SUMMARY

• Business/Data Analyst with 9 years of diverse IT experience with requirements management, business analysis, data analysis and project management
• Comprehensive knowledge of various Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile, Rational Unified Process (RUP) etc.
• Integrated SQL and Excel to automate reports to generate automated reports for dashboards.
• Created graphical representation for client’s using Tableau, excel and power point for the monthly reviews.
• Proficient in XML and XML (XSD) Schemas
• Conducted Requirement Gathering Sessions (RGS) and interviewed Business stakeholders through the use of different techniques like Brainstorming, Job shadowing etc.,
• Demonstrated experience defining Impact Analysis, LOE, Conversions, Business Rules, and Configuration Decisions on downstream systems and interfaces.
• Extensive experience in conducting GAP Analysis Applied tools and techniques in estimating cost and schedules using qualitative and quantitative analysis.
• Experience in facilitating JRP sessions with Business User Groups and conducting JAD sessions with IT Groups for Conflict resolutions
• Experience gathering requirements with the help of User Stories.
• Excellent skills in Data Analysis, Requirement Analysis, Business Process Modeling and Use Case Development as well as Activity Diagrams and Sequence Diagrams using UML methodology.
• Extensive knowledge of Prototyping different Graphical User Interfaces tools such as Visio and Just in Mind Prototyper.
• Experience with Data Analysis using Oracle as a backend and TOAD and SQL Developer Tools
• Facilitated Change Management across entire process from project conceptualization to Testing through projects implementation using Requirement Traceability Matrix (RTMs).
• Familiar with SQL queries to retrieve data from databases such as Oracle and MS SQL Server.
• Proficient in conducting User Acceptance Testing (UAT).

TECHNICAL SKILLS

Requirements Management Tool: Power Designer, MS Office.

Project Management Tools: MS Project, MS Excel.

Languages: SQL, UML, XML

Defect Tracking Tools: JIRA, Silk Central

Database Management: Oracle, MS SQL Server, MS Access

Database Access: TOAD, SQL Developers Tool

Prototyping Tools: Just in mind Prototyping, Smart Draw

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Sr. Business Analyst/Business Intelligence

Responsibilities:

• Created graphical representation for the client using Tableau, excel and power point for the monthly reviews.
• Evaluated hospital performance against industry using benchmarks provided by HARA.
• Projected cash inflows for the client for a period of 12 months based on the historical performance.
• Using 835 knowledge, automated AR to reduce human touch to process the AR towards resolution.
• Integrated SQL and Excel to automate reports to generate automated reports for daily and weekly dashboards.
• Interacting with QA teams to review and develop data standards, data exchange, XML data standard, and data sharing model
• Proficient with for XML - based vocabulary technologies
• Conducted and lead the JAD session with the end users and team members to setup the project goals and objectives, issues resolution, and system design for effective software development.
• Documented the detailed Business Requirement Documents (BRDs) and translated into Functional Requirement Documents (FRDs) and Non-Functional requirements documents (non-FRD) and Use Case Documents (UCD’s).
• Conducted Business Requirement Document walkthrough with business users, addressed any concerns raised and ensured timely signoffs to keep the project schedule.
• Assisted Project Manager in setting-up the timelines for project deliverables, managing project resources, and managing conflicts for successful completion of the project.
• Worked as a liaison between business and technical teams to communicate requirement prioritization and implementation level of effort to make sure highest value features are given higher priority.
• Conducted requirement walkthroughs with the development and test teams before the development and testing phases respectively, to ensure that the requirements are accurately understood.
• Prepared Requirements Traceability Matrix (RTM) between BRDs, FRDs and UCDs and reviewed RTM’s from testing team to make sure test cases covered all the requirements
• Assisted testing team in documentation of test plans, test scenarios, test cases, and managed complete defect tracking life cycle using a defect tracking tool. Actively participated in User Acceptance Testing at functional level.
• Performed Impact Analysis when request for change (RFC) arrived by looking at Requirement Traceability Matrix (RTM). Escalated the results of the analysis to the Change Control Board (CCB).
• Actively participated in Post Production Validation (PPV) and production support calls.

Environment: EPIC, XML,Windows,MS Office(MS Word, MS Excel, MS PowerPoint, MS Visio), Java, Oracle, RUP, UML, SQL

Confidential

Sr. Business Analyst

Responsibilities:

• Performed GAP analysis by identifying existing technologies, mapped the current and the expected processes respectively. Documented the enhancements to meet the end state requirements.
• Conducted and lead the JAD session with the end users and team members to setup the project goals and objectives, issues resolution, and system design for effective software development.
• Documented the detailed Business Requirement Documents (BRDs) and translated into Functional Requirement Documents (FRDs) and Non-Functional requirements documents (non-FRD) and Use Case Documents (UCD’s).
• Conducted Business Requirement Document walkthrough with business users, addressed any concerns raised and ensured timely signoffs to keep the project schedule.
• Assisted Project Manager in setting-up the timelines for project deliverables, managing project resources, and managing conflicts for successful completion of the project.
• Worked as a liaison between business and technical teams to communicate requirement prioritization and implementation level of effort to make sure highest value features are given higher priority.
• Worked and overlooked with QA teams to review and develop data standards, data exchange, XML data standard, and data sharing model
• Experienced in working with XML processing tools
• Conducted requirement walkthroughs with the development and test teams before the development and testing phases respectively, to ensure that the requirements are accurately understood.
• Prepared Requirements Traceability Matrix (RTM) between BRDs, FRDs and UCDs and reviewed RTM’s from testing team to make sure test cases covered all the requirements.
• Assisted testing team in documentation of test plans, test scenarios, test cases, and managed complete defect tracking life cycle using a defect tracking tool. Actively participated in User Acceptance Testing at functional level.
• Performed Impact Analysis when request for change (RFC) arrived by looking at Requirement Traceability Matrix (RTM). Escalated the results of the analysis to the Change Control Board (CCB).
• Actively participated in Post Production Validation (PPV) and production support calls.
• Travelled to different client locations to understand the reporting needs and create a reporting package for them.
• Prepared weekly dashboards for the internal client to understand the current standing of the projects on hand.
• Prepared dashboards for key client KPIs to evaluate performance against them.

Environment: SQL, XML, Meditech, Invision, Mede Analytics, Windows,MS Office(MS Word, MS Excel, MS PowerPoint, MS Visio), Java, Oracle, RUP, SQL

Confidential

Business Analyst

Responsibilities:

• Using 835 knowledge, automated AR to reduce human touch to process the AR towards resolution.
• Prepared dashboards for key client KPIs to evaluate performance against them.
• Created graphical representation for client’s using Tableau, excel and power point for the monthly reviews.
• Evaluated hospital performance against industry using benchmarks provided by HARA.
• Directly worked with client provider enrollment team to help them get enrolled with Medicaid of various states.
• Projected cash inflows for the client for a period of 12 months based on the historical performance.
• Experience in conducting SWOT Analysis, Cost Benefit and ROI Analysis.
• Performed GAP analysis by identifying existing technologies, mapped the current and the expected processes respectively. Documented the enhancements to meet the end state requirements.
• Worked closely with the Business Intelligence (BI) team to define standards for report.
• Developed SQL code using complex joins, nested and correlated queries to test the automated process that were developed to reduce the manual effort.

Environment: SQL, Meditech, Invision, Mede Analytics, Windows,MS Office(MS Word, MS Excel, MS PowerPoint, MS Visio), Java, Oracle, RUP, SQL

Confidential

Data Analyst

Responsibilities:

• Evaluated hospital performance against industry using benchmarks provided by HARA.
• Created graphical representation for client’s using Tableau, excel and power point for the monthly reviews.
• Travelled to client location to understand the reporting needs and create a reporting package for them.
• Prepared dashboards for key client KPIs to evaluate performance against them.
• Developed SQL code using complex joins, nested and correlated queries.
• Experience working in Medicare and Medicaid projects.
• Experience in conducting SWOT Analysis, Cost Benefit and ROI Analysis.
• Integrated SQL and Excel to automate reports to generate automated reports for daily and weekly dashboards.
• Using 835 knowledge, automated AR to reduce human touch to process the AR towards resolution.
• Directly worked with client provider enrollment team to help them get enrolled with Medicaid of various states.
• Worked closely with the Business Intelligence (BI) team to define standards for report.

Environment: SQL, Meditech, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio)