SUMMARY

• Over 7+ yrs of Professional experience as a TechnicalBusinessAnalyst/Data Analyst with solid understanding ofBusinessAnalysis,Businessand Functional Requirements Gathering, Translating Requirements into Specifications, Project management, Application Design,datamapping/modeling, and Testing.
• Expertise in theDataAnalysis, Design, Development, Implementation and Testing usingData Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non - relational databases.
• Extensive experience on DataAnalysis /DataProfiling, DataMigration,DataConversion,DataQuality,DataGovernance,DataIntegration, MDM, SQL and Metadata Management Services and Configuration Management
• Designing, documenting, configuring and deploying SharePoint solution for corporate documents, client management, issue management and task management.
• Experience in Microstrategy and Microsoft Business Intelligence (BI) platforms including SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS)
• Experience working onDataquality toolsInformaticaIDQ,InformaticaMDM
• Possess strong Conceptual and LogicalDataModeling skills, has experience with JAD sessions for requirements gathering, creatingdatamapping documents, writing functional specifications.
• Proficient in handling complex processes using SAS/ Base, SAS/ SQL, SAS/ STAT SAS/Graph, Merge, Join and Set statements, SAS/ ODS.
• Experience in analyzing and gathering requirements and writingBusinessRequirements Document, Systems Requirements Specifications, Design, Traceability Requirements Matrix and testing documents.
• Extensive knowledge of Patient Protection and Affordable Care Act (PPACA).
• Extensive knowledge of Medicaid Information Technology Architecture (MITA).
• Experience working in the SAFE Agile environment and using HEDIS to measure performance
• Good experience inDataModeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and LogicalDataModeling using Erwin.
• Experience in designing of on-line transactional processing (OLTP), operationaldatastore (ODS) and decision support system (DSS) (e.g.,DataWarehouse) databases, utilizingDatavault (hub and spoke), dimensional and normalizeddatadesigns as appropriate for enterprise-wide solutions.
• Extensive knowledge of SDLC methodologies and exposure to Agile, RUP, and Waterfall.
• Proficient in conducting GAP analysis, SWOT analysis, Cost Benefit analysis and ROI Analysis.
• Experienced in creating visually attractive Reports using Excel, visual basic, power BI and SQL Server Reporting Services (SSRS).
• Extensive knowledge of Relational Database Management System (RDBMS) Concepts.
• Extensive use of JIRA in filing bugs along with determining urgency level and regular follow up with developers ensuring that resolution goes out within specific timeline.
• Experience withDataflow diagrams,Datadictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Extensive experience in gatheringBusiness/Functional user requirements, creating Use Cases as per user requirements, developing/designing diagrams such as Activity, Class, and or Sequence diagrams, and in addition to creatingBusinessRequirements Document (BRD).
• Conducted successful projects with the help of teams to achieve deadlines timely and proficiently.
• Documentation of Test Plans, Test Cases, Test Scripts, Test Procedures based on the Design Document and User Requirement.
• Interface withbusinessusers to prepare and updateBusinessProcess Requirements (BPR) and Software System Requirements (SSR).
• Document for the Black Box, Functional, Usability and User Acceptance Testing (UAT).
• Possess excellent organizational, interpersonal, communication and documentation skills with good process management skills along with a remarkable ability to gather requirements to bring out quality product.

PROFESSIONAL EXPERIENCE

Sr. BusinessAnalyst/DataAnalyst

Confidential, Los Angeles, California

Responsibilities:

• Led "whiteboard sessions" with design team to define user stories and prioritize backlog screen flows to assist in system enhancements via Agile/Scrum methodology
• Performed testing for newly developed functionality to ensure they are aligned with the expected system behavior
• Responsible forbusinessrequirement collecting and analyzing,dataflow clarification,datamodel documentation,datamapping, and test supporting.
• Designed the screen mockups using Balasamiq.
• Implemented various Performance tuning techniques at ETL & Teradata BTEQ for efficient development and performance.
• Designed the procedures for getting thedatafrom all systems toDataWarehousing system.
• Involved in extensiveDATAvalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues
• Analyzeddataand investigated service related issues to identify root cause of problem(s).
• Created User stories in MS Word, MS PowerPoint for better visualization of the application.
• Extracted the source tables into SQL server and also MS-Access databases and extracting the target tables from Oracle and Teradata databases.
• Enhanced test cases and scripts by adding the required functionality as per the newbusiness requirements.
• Ensured comprehensive defect tracking and issue resolution using JIRA and Quality Center
• Provide support, tools, and guidance to project teams to assist transition from waterfall to agile/safe methodology and product model.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs
• Responsible for defining the key identifiers for each mapping/interface.
• Create Excel workbooks for the development of project storyboards and project tables.
• Developedbusinessprocess models in RUP to document futurebusinessprocesses.
• UtilizedInformaticaIDQto complete the initialdataprofiling and matching/removing duplicatedatafor the process ofdatamigration from the legacy systems to the target Oracle Database.
• Created issue logs, work request template, change request template and problem request template forBusiness.
• Created, assigned, and maintained tickets in JIRA for bugs and defects.
• CreatedBusinessprocess flow chart of As-Is and To-Be Process using MS Visio
• Efficiently interacted with designers and software developers to understand application functionality and navigational flow and keep them updated aboutbusinessuser's specifications.

Sr. Business Analyst

Confidential

Responsibilities:

• Involved with creating month end position reports for Fed Safety and Soundness Audit.
• Organized and drive Scrum ceremonies including Grooming, Planning, Daily Standup, Sprint Demos, Sprint Closure, Sprint Retrospective etc.
• Worked with the engineering managers to identify cross-team dependencies and manage inter-team tasks.
• Involved in writing shell scripts on UNIX for Teradata ETL tool anddatavalidation.
• Built out content using SharePoint Designer, provided training for additional best practices and lessons learned for education of end users.
• Provide inputs to development team in performing extraction, transformation and load fordatamarts anddatawarehouses.
• Performing and supporting System Integration Testing (SIT), and User Interface Testing (UAT)
• Monitored various interfaces to maintain continuous processing of patient insurance claims and payments
• Conducted meetings for the Data Modeling and Analysis and Helped with Data Mapping between the data mart and the Source Systems.
• Validated the testdatainDB2tables on Mainframes and on Teradatausing SQL queries.
• Translatedbusinessrequirements and assisted IT with the development of technical specifications.
• Developed screen layouts, process flow charts and test cases/scenarios that ensured all expected requirements and processes.
• Developed strategy for productiondataloading anddatamapping creating scripts in PERL which loadeddatainto MySQL.
• Involved indatalinageanddatareconciliation implementation for all sources end to end
• Developed and managed the formal Software Development Life Cycle (SDLC) Methodology which includes Configuration Management, Requirements Management, UML Analysis and Design under Agile (SAFE) methodology.
• Worked onDataProfiling using IDE-InformaticaDataExplorer andIDQ-InformaticaDataQuality to examine different patterns of sourcedata.
• Developed complex Excel macros for largedatapull from SAP and SAS
• Facilitate the prioritization of product requirements and operationalize them into detailed technical specifications for development.
• Analyzing defects within thebusinessapplication functionalities and GUI following software releases or updates, consorting with the development team to establish technical fixes, and revising applicable test cases to reflect the software system changes
• Create and share dashboards that track and display Sprint KPI metrics including Burn down/Burn up chart, Unit Test Coverage, Functional Test Coverage Automated Test Coverage, Regression Test Coverage, Blocker Board, Defect Find/Fix Rate, Sprint Committed vs. Acceptance rate etc.

Agile Business Analyst

Confidential, Atlanta, GA

Responsibilities:

• Gathered requirements from stakeholders for provider management and member management.
• Coordinated JAD sessions for Requirement Validation with Dept. of Cleveland clinic to gather requirements for the new MMIS.
• Identified and validatedbusinessrules anddataelements.
• Worked in the Scaled Agile Framework (SAFE) environment
• Created 837(P, I, D) claims, and maintaineddatamapping documents in reference to HIPAA transactions primarily 837(P, I, D), 835, 270/271, 276/277 and 278.
• Wrote complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects.
• Modeled the 'as-is' process flow and the 'to-be' process flow and analyzed the gap and developed the action steps to fill the gaps.
• Worked within project team to identify and interpret state Medicaid policies as applicable to customer defined algorithm research as well as assist with internal development of newhealthcareanalytics.
• Worked under Agile scrum methodology using JIRA ticketing system to log day to day activities.
• Used Agile/Safe or Lean methodology for gatheringbusinessrequirements, writing User Stories and acceptance criteria's.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehous
• Analyzed Impact analysis when there is any change in the requirements and updated theBusiness Requirements Document (BRD) and Systems Requirements Specification (SRS).
• Analyzed Audit and Change Files of 834, 835, 820, 837 PDI, 270 & 271HIPAA EDI Transactions using MS Word, MS Excel, MS Access and Facets PROD & PPMO
• Created use cases to depict the interaction between the various actors and the system and created data flow models, data quality analysis and performed cost/benefit analysis
• Have utilized Clear Quest to repair and detect errors in a program.
• Developed the User Interface (UI) prototypes to capture and validate requirements and spike solutions to the current problem.
• Performeddataanalysis anddataprofilingusing SQL and PL/SQL
• Responsible for differentDatamapping activities from Source systems to Teradata
• Analyzed requirements for developing a crosswalk for understanding major changes from ICD-9 to ICD-10 with the help of SME's
• Used Alteryx and advanced Excel tools to clean and combinedata. Analyzed customer behavior by decile
• Created Excel/VBA automation tools for a variety of User Directed Tasks
• Participated in developing test plan, test scripts, and test scenarios and designed user documentation.
• Successfully conducted Product Increment planning as a part of SAFE and broken down the requirements for the upcoming sprints
• Reviewed Risk Assessments, Performed Gap Analysis of the current system and Prepared Remediation Plan.