Data Pharmacy

Ashwini Kulkarni

New Hudson Michigan ***** 313-***-**** ********.**********@*****.***

Professional Summary

Passionate Sr. Technical Business and Quality Analyst with more than 6 years of hands on experience in all stages of system development efforts and part of a Product Team working in a fast-paced, Continuous Delivery model, including requirements definition, design, testing and support. Strengths include Requirements elicitation, Data Analysis, Business Analytics and Business process improvements, Verification and Validation.

Work Experience

MDM Global Data Insight Analytics (GDIA)

Ford Motor Company - Dearborn, Michigan - Mar’17 –Apr’20

Project: SCA-C is the North America and South America system of Record for consumers and Consumer vehicle ownership. It keeps track of consumer and vehicle information from various sources (53+ data inputs). A Teradata database used for campaigns, reporting and analytics. It is an upgrade MDM from current Version 10.1 to 11.4. The project will replace current Trillium to IIS quality stage with the alignment of Integration Layer with upgraded MDM.MDM Upgrade: There are changes identified in core tables. Application configuration management is impacted. Business proxies in MDM are also impacted. Worked on EU Dealerization Process

BA Responsibilities:

•As a Product Owner, I performed cross functional duties of a Business Analyst and QA Analyst by partnering with the Business to define and develop product vision and product strategy in order to enhance the Single Complete Actionable view of a customer.

•Facilitated Agile ceremonies, Creating Epic, Sub Epic, User stories and Tasks as Iteration planning, stand up meeting, Iteration demos, retrospectives, demos using Rally tool.

•Involved in the discussions of impact analysis, scoping timeline for the project with development and business team.

•Collaborated with other subject matter experts, cross-functional teams across different geographies and Product Owners/Business to solicit input and define system requirements of South America, North America and Europe data sources for Ingesting Data to Hadoop (DataStage) Framework to Master Customer data in IBM Infosphere.

•Prepared Detailed Use Case document and other required process documents after interacting with the Business Owners and other Stakeholders.

•Created sequence and interaction diagrams using standard UML

•Executed on the product strategy by defining requirements, built a product backlog of work for the development team.

•Generating Tableau reports which are used by various users and decision makers.

•The automation of getting the file feeds,loading and transformation is done using Unix/Alteryx.

•Supported QlikView dashboards. Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data.

•Participated in Iteration Planning and Base camp assessment meeting every quarter to discuss % of acceptance criteria, burndown charts, retrospectives.

•Utilized Tracklite to track business approvals of production issues.

QA Responsibilities:

•Performed Automation Testing for the data flow from Hadoop data source to ETL.

•Extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.

•Performed data analysis/Mapping/validations for Global Data Sources landing in Hadoop Data Lake.

•Experienced at testing ETLs and flat file data transfers without relying on a GUI layer, validating the data mapping from source to Target and reports.

•Extensively used SQL queries for Data Analysis, Data Mapping and good exposure MDM Data model.

•Prepared and cleansed data from multiple sources using Alteryx to design extracts for optimal consumption with QlikView.

•Facilitated Functional testing, Integration Testing and User acceptance testing in different environments like Dev, QA, Pre-Prod (EDU).

•Verification and Validation of Business Rules using Test automation Tool (Fitnesse, SoapUI, Postman).

•Performed Regression testing for Data Center of Future (DCoF) Migration and Tech Refresh.

Technologies: Teradata SQL Assistant, Microsoft SQL server management studio 2016, IBM infosphere DataStage, Fitnesse, Postman, SoapUI 5.4.0, Alteryx Designer, beyond compare, Putty, Oxygen XML Developer 20.1, Slack,Tableau Software, QlikView

Senior QA Analyst Pharmacy Portal CPV (Continuous Participation Verification)

BCBS of MI- Detroit, MI - Oct’15 –Feb’17

Project: The purpose of this project is to provide capability to electronically collect, exchange, administer certifications and validations of the BCBSM / BCN pharmacy networks. It also provides secured Pharmacy portal that hosts Pharmacy manuals, policies / procedures and other documents control and displays the authorized documents. This is a Web and Mobile Application. By alerting pharmacies of the communication and decreasing the amount of time for the Pharmacy to receive the information will improve the member experience.

Developing the new pharmacy portal screen and the functionalities that will be hosted on the pharmacy portal screen like MAC2 Cost Look up, Publication of Newsletters/ Manuals and other documentations, displaying published alerts, Online enrollment forms / Manual upload of Enrollment forms etc. for external and internal users. Developing the web application and functionalities that will be hosted on blues link intranet portal like Broadcasting Alerts, Enrollment Forms Verification etc., created specifically for the internal users. WEBDENIS is implementing new screens for the MAPPO Contracts prior authorizations. All the MAPPO contracts associated with the following services: Post-Acute Care, Physical Therapy, Radiation Oncology, Lumbar Spinal Fusion Surgery and Interventional Pain will be provided capability to single sign on to third party - eViCore - site for prior authorizations.

Responsibilities:

•Reviewed / Modified / Created – Test Data, Test Scripts, and Test Execution Plan.

•Facilitated scrum ceremonies (grooming, sprint planning, retrospectives, daily stand-ups, etc.) by pipelining of development and testing tasks altogether which helped in delivering more base support tickets in each SPRINT.

•Implemented test plan for Regression testing within a SPRINT to overcome a challenge for regression testing within SCRUM.

•Conducted SIT review meetings to go through SIT test grid which is included with all the test cases according to the scenarios.

•Performed Functional and Regression testing of Facets.

•Extensively involved in data validation between 834 Membership file to Facets backend tables.

•Tested the membership and claims files (XML) in Facets.

•Analyzed which test data is needed for each scenario and requesting for the same to the Information data management team.

•Validation of data transformations and perform end-to-end data validation for ETL systems.

•Supported EDI team in testing 835/834 and Validate EDI Claim Process according to HIPAA compliance.

•Tested Regression EDI834, 820 Transactions following the HIPPA compliance EDI Standard of X12.

•Develop test framework using TestNG and Selenium Webdriver.

•knowledge of Automation Framework Design & implementation using selenium Tool

•Integration with Jenkins for nightly execution.

•Created UNIX shell scripts to access and move data from production to development environment.

•Gave Demo for a project to the performance team to build the data for performance testing.

•Developed Requirements Traceability Matrix (RTM) to trace each software requirement to test case.

•Worked closely with the Test Lead, Business Analyst and Developers to resolve test related issues.

•Reported all issues/deviations and defects in bug tracking system (IBM CQ).

Technologies: Rational Clear Quest, MS Office (Word, Excel, Power Point), SharePoint, Oracle, Java, winSCP, Putty, HP Service Manager, Selenium WebDriver, GUI testing, GIT,Jenkins, Facets, EDI Notepad

Senior QA Analyst Rubicon breeding and Lab

Nexient, Ann Arbor, MI (Client- Monsanto, St. Louis, MO) Detroit - Jun’13 –Jan’14

Project: Rubicon Breeding: Rubicon is a decision support system which combines the phenotypic data and genotypic data (from lab) and help breeders to make decision. The system supports Molecular Breeding to drive increased genetic gain and faster time to market in the product pipeline Perform manual testing of several web-based applications developed to retire existing Rubicon Application, which allow breeders to track various life cycles of Hybrid Agricultural Products in Lab without relying on Rubicon.

Responsibilities:

•Worked as QA Single Quality Assurance Engineer testing the Rubicon web-based application.

•Worked in Agile Development environment with two weeks’ iteration.

•Participated in Sprint Planning meetings, requirements review and interact with business analysts for clarifications.

•Analyzed stories and requirement documents planned for current Sprint.

•Created test cases based on the stories and requirement documents.

•Co-ordinated test case review meeting with BA and developers and update based on the review.

•Created test data and mock-up the existing data to simulate the test conditions.

•Documented test cases and built a requirement traceability matrix to demonstrate test coverage.

•Executed test cases, test scripts and document the test results.

•Logged defects in JIRA – Defect tracking tool to track issues identified during functional testing of application.

•Troubleshooted and debugged issues and researched the root causes before logging into JIRA.

•Participated in defect review meetings.

•Managed test documents such as test cases, test results and defect logs.

•Developed and used SQL queries to validate the database and test its integration with the front end.

•Performed Regression Testing to ensure fixes do not have a negative impact on other application functionality.

•Performed various types of testing like Functional, System, Integration and User Acceptance.

•Performed smoke testing when the code is deployed into QA Environment.

•Participated in all project related meetings and provide feedback on QA test activities.

Technologies: Java, Oracle SQL Developer 2.1.1.64, SOAP UI 4.5.1, Microsoft Office, Jira

QA Tester FMS (Next Generation Flight Management System)

Vista Infotech, Bangalore, India (Client- Honeywell Aerospace, AZ) - Oct’11 –May’12

Project: This is an advanced FMS which has layered, sub system, component, subcomponent architecture. Flight Management System is a product which manages overall working of Flight from Takeoff to landing. It is a crew’s primary Automation interface. It reduces the pilot workload by doing most of the work itself. It controls the overall working of flight by taking Input from all the subsystems attached to the flight based on that inputs it will decide what is going to be next decision. It is very safety critical software because life of human beings is related so chance of single failure is not acceptable.

Responsibilities:

•Analyzed functional specifications and reviewed manual test cases.

•Wrote test cases as per DO178B Guidelines.

•Unit Testing, Integration Testing, System Testing, Regression Testing are performed for the application.

•Reported the Coverage status of test performed on weekly basis, reviewed unit test artifacts

•Identified the critical breaks/bugs in the application and reported to the development team using Rational Clear Quest.

•Involved in the testing effort estimation.

•Assigned daily activities to the testers and kept track of progress.

Technologies: C++, Vector cast, Clear case, Clear quest, Siemens Team Centre, Jira

QA Analyst Loan Delivery (LD)

MAXrad Software Pvt Ltd, India (Client- Fannie Mae, VA) - Oct’10 –Sep’11

Project: Fannie Mae is Government Sponsored Mortgage Finance Company. This is a Web and Mobile Application. They provide Working families a Mortgage Credit to buy homes they can afford for the long term. The Application Loan Delivery is a Web-based application through which lenders submit loans to Fannie Mae for Whole loan sale and MBS (Mortgage – based security) Pools. You can import loan and pool data, perform edits to facilitate error-free delivery, transfer loans between commitments (or pools), track the status of loan deliveries, generate reports, and export loan and pool data for use elsewhere in your organization.

Responsibilities:

•Designed and executed test cases to validate Social Security Number validation process (SSN) to meet the objectives of the Loan Quality Policy Rules.

•Performed Pre-Delivery Data integrity validations to lower the credit risk of a loan that Fannie Mae purchases or securitizes.

•Facilitated test cases review walkthroughs for Business and Technical stakeholders.

•Supported the testing efforts for LD Application to transition from 2000-character (2K) file to MISMO Version 3.0 Reference Model file in support of the Uniform Mortgage Data Program (UMDP).

•Created 2K test data files in order to trigger a particular edit and imported 2K and MISMO XML files into LD to validate the business rules.

•Designed and executed testing scripts using SQL queries to perform database testing.

•Executed UNIX scripts and Auto Sys jobs to generate reports and then validate the report data.

Technologies: Java, Oracle SQL Developer 2.1.1.64, SOAP UI 4.5.1, Microsoft Office, Jira

Jr QA Analyst Health Care Management System (HCMS)

Coral Digital Technologies (Client- Genpact, India) - Sep’09 –Sep’10

Project: GE Global Research is one of the world’s most diversified industrial research labs, providing innovative technology for all of GE’s businesses. The Diagnostic and Medical care technology is a complex system which is used to manage the several components right from Patient monitoring to material management. The project involved testing their material management system which included raising purchase requests to ordering components.

Responsibilities:

•Developed test scenarios and test cases, as per the functionality of the application.

•Performed all phases of Blackbox testing, which includes Functional, Regression, GUI, System and Smoke test.

•Wrote SQL Queries to validate data.

•Responsible for testing online processing for the new interfaces of Medical and Diagnostic systems.

•Generated virtual users and executed test scripts in Load Runner to record and report the performance of the application.

•Reported bugs and tracked defects using Test Director 7.0.

Technologies: Win Runner, Test Director, Load Runner, .NET, Java, Web Logic, HTML, XML, Oracle9i, MS-Office, IE, Netscape Navigator

Education:

B.E (Electronics), Viswesawarya Technology University, India

GPA-3.5,2009

Contact this candidate