SUMMARY

• Data Quality enthusiast with almost 12 years of experience in data and business analysis.
• Passionate about data, its quality and improvement to make business process smoother, accurate and reliable.

PROFESSIONAL EXPERIENCE

Sr. Business Analyst / Data Analyst/ Data Architect

Confidential

Responsibilities:

• Supported Information Management and Quality director to create data quality department.
• Maintained and developed standardized tracking methods, which facilitate the quality checking process to be able to recover potentially $2Million annual loss in cost of poor quality
• Automated existing manual process that to be able to review exception reports only thus saving total of $5Million annually
• Filled in as interim data architect to manage data model
• Supported release management team and change management team for smooth data deployment and production release
• Maintained and managed data models to make sure efficiency is not compromised
• Validated any conflicts in data model using SAP Power Design
• Worked with internal users to resolve quality issues and develop reports to present status to management
• Established an on - going process to maintain quality data and define data quality control mechanisms, and data quality audit processes
• Created an automated tool that provides dynamic data specification for RHI needs
• Determined the Critical to Quality (CTQ) data elements to optimize the quality validations to focus on process needs.
• Reviewed, analyzed, and ensured the quality of data loaded into the database system by utilizing MSSQL, Netezza SQL and SAS EG-7.1.
• Created automated process to monitor daily on quality metrics to proactively identify issues related to data
• Used statistical process controlled charts (SPC) to be able to determine go/no-go decision for 3 standard deviation variance.
• Responsible for data integrity checks, report anomalies; coordinates with development, clinical, and product teams for resolution
• Analyzed complex end user needs to determine optimal means of meeting those needs.
• Documented specific business reporting requirements to address complex business needs.
• Created and maintained documentation, messaging to Executives of metric results for informed decision
• Engaged with programming staff to ensure requirements will be incorporated into design and testing.
• Created written narratives, table charts and graphs to display data. User Stories and product backlogs.
• Performed business process analysis and implemented business process re-engineering techniques.
• Involved in providing technical expertise to define defect remediation process for QA team and provided detailed estimates for the change control process and identified resources and allocated tasks to maximize resource utilization.
• Responsible for the completion of projects within specified time and budget dealing with financials, project work flow, change management and dealing with vendor relationships.
• Involved in conducting UAT to make sure that all the user requirements are catered by the application.
• Worked as a production support as a part of DCU (Data Correction Unit).

Tools: Used: IBM Netezza, MS RDBMS, Teradata, SAS EG 7.1, SAP Power Designer, SAP Business Object, Tableau, Visio, Jira, Rational Tools suites.

Confidential

Business Analyst, Enterprise Data Management

Responsibilities:

• In charge of Client Data On boarding process for the new clients which include
• Performing Gap Analysis of the Client Data and Data Warehouse requirements.
• To provide Detail Walkthrough clients to the data dictionary and the data requirements.
• Mapping of Client Data for the client to Data warehouse.
• Validating and Testing the Data for Pre and Post Integration process using advance SQL.
• Providing the Product teams client specific Business and Data rules for the client.
• Managing the Client data process flow for timeliness, accuracy and integrity Month over Month.
• Provide HEDIS and Star Rating product data team with Enterprise Data Warehouse guidance.
• Leads data meetings engaging the clients and product teams for any Client Data or Product data related issues. Liaison between Client’s Business/Data team and Inovalon Product team for all the data related issues.
• Validate and perform the Monthly Client Data quality checks to make sure that the product teams have best quality data for their business use based on business analytics.
• Perform research and analysis on any Data warehouse related issues ranging from data analysis of data integration to making sure how the best quality data is made available to the products based on their business need.
• Analyze and integrate various types of HealthCare data file like Member information file (Including CMS MMR files), Member Enrollment file, Provider file, Medical and Rx Claims file, and Lab data file.
• Gather and Document requirements for the new tables for product teams to be used.
• Provide Standard UAT and Documenting for the Change Control Board.
• Discuss with Product team and Technical team to create new tables, table structure and data process flow.
• Manage Vendor data transmission setup for initiation and regulate operations time to time.
• Gather and Document Requirements for in house ETL product upgrade.
• Create process and work flows
• Create Product Backlog Items and Groom it in the sprint planning meeting.
• Create precise user stories/epics for agile team.
• Provide Acceptance Criteria for dev and QA team.
• Ensure that the team is fully functional and productive and enable close cooperation across all roles and functions
• Remove barriers and ensure that the process is followed, including issuing invitations to daily scrums, sprint reviews, and sprint planning
• Facilitate the daily scrums

Environment: MS SQL, Visual Studio, MS-Office Suite, MS-Visio 2007, MS-Project 2007, Share Point, Windows, Scrumwise

Sr. Business Analyst/Data Analyst

Confidential, OH

Responsibilities:

• Updated scope document during the pre-initiation stage for project approval by the management.
• Conduct the review meetings for scope document sign-offs whit SMEs, stakeholders and involved in project planning, project monitoring and control.
• Developed UML diagrams using Visio, UI screen shots and conducted JAD sessions with business team and IT team.
• Documented Vision & Scope document and walk it through to get Agreement & Sign-off on document.
• Conduct and Facilitate various JAD sessions to define the scope for the application.
• Gathered business requirements from SME and translated business needs into technical specifications through requirement analysis and wrote detailed requirements for Multi-Dimensional Analysis Audit review reports.
• Performed Gap Analysis from AS-IS to TO-BE state, categorized them as per criticality.
• Created and maintained Requirement Traceability Matrix RTM and Supplemental Requirement document(SRD)
• Conducted data analysis and updates to Reference Data tables for Business Users using SQL queries.
• Maintained comprehensive understanding of business functions and interrelationships among operational data stores and data warehouse systems as well as relational table structures.
• Created data mapping document for ETL transactions for creation of data mart for reporting needs and ad-hoc queries.
• Closely worked with testing team for System Testing and business team for UAT. Heavily involved in tracking and prioritization of defects, controlling defects, prioritizing through fixed effort using Quality Center.
• Responsible to gather, analyze, coordinate all the weekly updates from business team, design, development and testing team and present it to PM and Director.
• Managed project resources to successful completion and involved in review sessions with SMEs, stakeholders, system architects, developers and testers to resolve open and pending issues and update business continuity plan.
• Worked as point of contact (POC) to users, design, development, testing team and PM.

Environment: MS-Office Suite, MS-Visio 2007, MS-Project 2007, Share Point Server 2007, Windows, HTML, XML

Confidential

Sr. Business Analyst

Responsibilities:

• Updated scope document during the pre-initiation stage for project approval by the management.
• Conducted data analysis and updates to Reference Data tables for Business Users using SQL queries.
• Conducted the review meetings for scope document sign-offs whit SMEs, stakeholders and involved in project planning, project monitoring and control.
• Developed UML diagrams using Visio, UI screen shots and conducted JAD sessions with business team and IT team.
• Created and maintained RTM and interface specification document(ISD)
• Gathered business requirements from SME and translated business needs into technical specifications through requirement analysis and wrote detailed requirements for counterparty management, counterparty credit review reports.
• Reviewed and analyzed data on review reports and made some recommendations to the business team to improve the effectiveness and efficiency of report and created release notes for the release management team to deploy the code.
• Performed business process analysis, business process design, business process testing, data analysis, data validation, using complex SQL queries.
• Served as liaison between project manager and other team members, also between business team and IT team
• Closely worked with testing team for System Testing and business team for UAT. Heavily involved in tracking and prioritization of defects, controlling defects, prioritizing through fixed effort using Quality Center.
• Involved in user group discussion, provided training material and training to user.
• Responsibility gather, analyze, coordinate all the weekly updates from business team, design, development and testing team and present it to PM and director.
• Responsibility for documenting meeting minutes and distributing PM and team members and create Risk log document.
• Managed project resources to successful completion and involved in review sessions with SMEs, stakeholders, system architects, developers and testers to resolve open and pending issues and update business continuity plan.
• Closely worked in establishing and maintaining agreements between the customer and the project team on the changing requirements of the system
• Managed and controlled change using Team Track, associated requirement to specific change request/ enhancements /defects within the change request guideline as per CCB(change control board)
• Worked as point of contact (POC) to users, design, development, testing team and PM.

Environment: MS-Office Suite, MS-Visio 2007, MS-Project 2007, Share Point Server 2007, Windows, Team Track, Quality Center, HTML, XML, Oracle10g,.

Confidential

Business Analyst

Responsibilities:

• Participated in gathering of business and functional requirements.
• Conducted the review meetings for scope document sign-offs with SMEs, and involved in project planning, project monitoring and control.
• Developed UML diagrams using Visio, UI screen shots and conducted JAD sessions with business team and IT team.
• Status reporting and project planning using MS Project.
• Created and maintained Requirements Traceability Matrix (RTM) and Interface Specifications Document (ISD).
• Conducted multiple one on one and brainstorming sessions with the SME’s to understand the as-is process and gather business requirements.
• Created as-is data flow and work flow diagrams and to-be data flow and work flow diagrams and conducted walkthrough sessions for these diagrams to make sure that the business and SME’s were on the same page.
• Participated in several sessions related to quality management, joint application development (JAD), defects management, business requirement and professional development
• Analyzed the Project Definition Document and Business requirements documents to develop functional and detailed design specification of the application.
• Planned, scheduled, and controlled projects based on plans and requirements outlined by the business.
• Performed business process analysis, business process design, business process testing, data analysis and data validation using complex SQL queries written on Oracle.
• Worked on VMware.
• Served as the liaison between project manager and other team members also between business team and IT team.
• Monitored Project Life Cycle (PLC) using MS Project and Visio.
• Understand and articulate business requirements from user interviews, and workshops and then convert requirements into technical specifications.
• Performed backend testing to check the system data integrity for insert, update, delete and retrieve transactions by writing complex SQL queries including joins, group by, having clause etc.
• Performed Functionality testing, Integration Testing, Unit testing and System Testing.
• Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.

Tools: Used: MS Project, MS Access, Rational Requisite Pro, Rational Clear Quest, Rational Clear Case, MS Visio, Oracle, SQL, Toad, Shell Scripts, MS Excel, MS Word

Confidential

Business Analyst

Responsibilities:

• Manage requirements for audit approver section by documentation and walkthrough of requirements.
• Support lead BA and other team members for documenting the business and system requirements.
• Manage calls and schedules for JAD session for detail understanding and brainstorming.
• Performed gap analysis for multiple streams that helped in identifying the updates.
• Gathered business requirements from SME and translated business needs into technical specifications through requirement analysis and wrote detailed requirements for Multi-Dimensional Analysis Audit review reports.
• Supported Lead BA and Project Manager in day to day operations and managing the project timelines.

Tools: Used: MS RDBMS, MS Visio, MS Word, MS Excel, MS Access, MS Project