SUMMARY

• Highly motivated and result oriented with 9+ years of industry experience as Business Analyst in Healthcare, Retail, Life science and Banking industries.
• Experience with Medicaid, Medicare, Claim adjudication process, Disease Management, Case Management, Pharmacy Benefit Management, Government Pricing (GP), Retail banking, Mobile banking and Email Marketing.
• Experienced in interacting with business users and executives to identify their needs, gathering requirements. Experienced in facilitating and conducting Requirement elicitation sessions and interviews with end - users, clients, stakeholders and development team.
• Authored various documents like Business Requirement Documents (BRD), Use Case Diagrams, Technical Requirement document, requirement traceability Matrix, Process flow diagrams and test scripts.
• Experience working in Agile and waterfall methodology.
• Experienced in working with various departmental teams, developing interactive relationships with business and IT colleagues.

TECHNICAL SKILLS

SDLC methodology: Waterfall and Agile (Scrum & Kanban)

Documents: Business Requirement Document (BRD), Functional Requirement Document (FRD), Use cases, Test cases, Requirement Traceability Matrix, Test Scripts

Microsoft office tools: Word, PowerPoint, Excel, Visio, Paint, Project

Requirement Management tools: Rational tools (Clear Quest, Clear case and Requisite Pro) & BluePrint

Database Querying tools: Oracle Toad, MS SQL server, DB2, Mainframe, MS Access, Oracle SQL developer, TeraData

Defect Management tools: Rational Clear quest, HP Quality Center, Team foundation server

Other: Informatica Data Explorer, SnagIT, MS Paint, Axure, Oracle Marketing Cloud/ Oracle Responsys, Tableau

PROFESSIONAL EXPERIENCE

Confidential

Business System Analyst/Data Analyst

Responsibilities:

• Documented functional requirement document for CCPA project. CCPA is California act which allows customer to request companies to either delete or provide their personal information from company’s database. Also, it allows customer to inform companies to not to sell their personal information to any other vendor.
• Updated current state documentation of Confidential ’s offer management system to make sure all current functionality of system is documented clearly and eventually migrated to new google cloud platform as expected.
• Performed data analysis/data validation of all production data issues assigned to the team using Teradata.
• Validated customer/Campaign information through Oracle Marketing tool( Responsys).
• Captured/Validated all information for all email acquisition source codes for Confidential and its subsidiaries.
• Responsible to interact with external vendors for all data exchanges between vendor and Confidential .
• Wrote SQL queries to perform data analysis including data extraction and data upload.
• Performed analysis of campaign programs are running as expected in Oracle Marketing cloud ( Responsys).

Tools: Oracle Marketing Cloud/ Oracle Responsys, TeraData

Confidential

Business System Analyst

Responsibilities:

• Involved in product backlog grooming sessions to identify stories based on priority and resource availability for sprint planning.
• Attended daily scrum calls to provide an update on JIRA stories being worked on and also shared any roadblocks or information required for team.
• Created stories, sub-tasks in JIRA and keep it updated on daily basis.
• Created test script for government pricing (GP) for converted data to check completeness and accuracy of data conversion from source to target.
• Performed data analysis on legacy data for data validation and identify data anomalies for domain and target tables.
• Participated in sprint review and sprint planning sessions on bi-weekly basis.
• Wrote SQL scripts to convert data from legacy to new system for government pricing attributes and for other requirements as needed.
• Worked on reconciliation reports for business to present that legacy data for domain and transactional tables are converted accurately.
• Imported outside source data from excel into database tables using excel formulas and SQL.
• Reviewed all data quality analysis results to the team and business to inform about data anomalies. And also involved in business review sessions to review data analysis results and get resolution for the same before data being converted.
• Used Amazon Web Services (AWS) for day to day work.

Confidential

Business Analyst/ QA Analyst

Responsibilities:

• Created requirement traceability Matrix to match requirements against test cases.
• Scheduled sessions with Subject matter expert (SME) to find out base table values for each drop down fields.
• Scheduled sessions with Subject matter expert (SME) to understand business processes across different modules.
• Documented business process flow diagram using MS VISIO.
• Performed integration and functional testing for business requirements and End of day processes.
• Validated that application is interacted with external systems like Solutran and CAP of Lancaster as required.
• Validated roles, permission and security requirements for access to modules within application.
• Validated system functionality with USDA compliance requirement document (FRED) to make sure that system is in compliance with regulations.
• Logged defects (bugs) using Team Foundation Server 2015 (TFS). Also reviewed, Prioritized and resolved bugs during weekly defect triage meetings.
• Created test execution matrix and provided to the project manager.
• Identified high priority bugs to be resolved before Go-No Go meeting for UAT.
• Documented User acceptance test (UAT) scripts for different modules in WIC ON Web (WOW) application.
• Involved in User setup, data set up and roles and permission set up for User Acceptance Test (UAT) dry run for 8 users.

Confidential, Mt. Laurel, NJ

IT Business Analyst

Responsibilities:

• Responsible to create System requirement document in a clear and concise fashion to ensure requirements can be understood and meet the needs of requirements stakeholders, business, developers/designers and quality assurance.
• Worked with digital content team to review wireframes and content for the iOs and Android devices (Mobile devices).
• Worked with business analyst to understand and analyze business requirement to translate them into functional, operational and non-functional requirements.
• Worked with technical leads and applications SME to conduct impact analysis to understand how new requirements will interact with existing system function.
• Reviewed business requirements and system requirements with Fiserv team to identify visibility of implementing business requirements
• Helped business teams to create test cases for user acceptance testing.
• Provided support for application teams in design & development phase and reconcile all requirements related issues.
• Create traceability Matrix document to make sure that each system requirement is tied to business requirement and all business requirements are covered.
• Created system use case to describe step by step interaction between system and customer.
• Facilitated technical and Business review session to review system requirement document.

Confidential

Business System Analyst/Data analyst

Responsibilities:

• Facilitated requirement sessions to identify requirements for connectivity between Vendor and Horizon and to finalize format of data in which data will land in databases.
• Worked on Informatica Data Explorer tool to profile column data in order to avoid data anomalies.
• Experience in performing Data Analysis and Data Mapping from a source to an Enterprise Data Warehouse
• Performed source data profiling to verify that data meets the business requirements and Analyzed results from data profiling for each column including pattern, data types and Null.
• Wrote SQL queries to pull out data and table information in order to do data mapping.
• Documented current state diagram, Future state flow diagram and Process map diagram in technical requirement document using MS Visio.
• Identified as well as documented data sources and transformation rules required to populate and maintain data warehouse content.
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Worked with Information exchange team to set up connectivity with different vendors in order to receive files using Master file transfer process.
• Worked with architecture to understand data validation checks, error handling and control & balancing process to be applied on data.
• Worked with architect and Data modeler to create Data Dictionary for data mapping purposes.
• Created STTM (Source to target mappings) for existing and new changes which include source, target and transformation rules for migration of data from old data warehouse to new data warehouse.
• Identified root cause of an issue and conducted UAT to make sure that required data has been loaded data-warehouse.
• Performed source data profiling to verify that data meets the business requirements and Analyzed results from data profiling for each column including pattern, data types and Null.
• Elicited requirement session with business for report layouts, frequency and data needed to produce report.
• Used oracle toad 9.2 as SQL querying tool to pull out data from data-warehouse.
• Analyzed incoming and outgoing data feeds to make sure that they are ICD-10 compliant.
• Documented current state diagram and Future state flow diagram in technical requirement document using MS Visio.