OBJECTIVE

• To work in a fast - paced dynamic environment to align my professional Scrum Master / Business/Data Analysis skills with a progressive company, wherein the application of my technical education and work ethics that would provide a significant contribution to the company’s continued success and thereby adding value to the organization.

SUMMARY

• 7+ years of experience as a ETL Tester / System Analyst having extensive experience in Healthcare space.
• Good understanding of SDLC and have worked on different methodology such as Agile, Scrum and Waterfall.
• Comprehensive knowledge and experience in all aspects of the Software Development Life Cycle (SDLC), which includes Gathering Requirements, Analysis, Testing and Implementation.
• Experience in data validation of different subject areas like: Claims, Members, Providers, Pharmacy, Authorization, Provider Hierarchy, Clinical Data, etc.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Load the flat files to the HDFS in Hadoop and validated the Raw, Archival zones in the HDFS.
• Experience in creating Test Plans, Test Cases, Test scenarios and Test strategies to ensure Quality Assurance and test all the business requirements.
• Knowledge of test automation development with Python
• Highly proficient in working with users and stakeholders to analyze, communicate and gather requirements using techniques such as Brainstorming sessions, Workshops, Observation and Existing systems documentation/procedures, JAD, User Interviews and to identify Functional, Non-Functional, Business and System Requirements and document them.
• Facilitated scrum meetings, sprint planning, review & retrospective sessions and ceremonies.
• Good knowledge with Teradata, SQL Server Reporting Services (SSRS), PL-SQL, SQL Server Integration Services (SSIS), Tableau etc.
• Expertise in handling SCRUM artifacts (Product Backlog, Sprint Backlog, Sprint Task list, Sprint Burndown chart and Release Burndown Chart).
• Worked on Health Insurance Exchanges, Health Care Reform (PPACA), ICD-10, Medicare/Medicaid, EDI transactions (837,835,270/271,276/277,999), Wellness Apps & Membership portal related projects.
• Well versed with Facets, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.
• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews, Questionnaire and Requirement Elicitation sessions.
• Conducted document analysis, business process re-engineering (BPR), Business Process Improvements and creating Business Requirements document (BRD), Functional Specification document (FSD) and Use-Case Specifications.
• Conducted “AS-IS” and “TO-BE” analysis, Business Process Automation, Business Process Improvement, and Business Process re-engineering.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, Cost Benefit Analysis, Risk Analysis.
• Extensive design experience in creating UML diagrams such as Use Cases, Activity Diagrams, State Machine Diagrams and Sequence Diagrams using MS Visio.
• Experience in creating Requirement Traceability Matrix (RTM) to manage the requirement gathering process and keeping the track of milestones.
• Experience in creating and execution of SQL queries.
• Proven ability to manage multiple tasks and work with diverse teams to anticipate problems and meet deadlines with strong analytical abilities and proven leadership qualities.
• Motivated self-starter and comfortable in high intensity, high rewarding work environments with exceptional team building, leadership, written and verbal skills.

TECHNICAL SKILLS

Methodologies: Agile-Scrum and Waterfall

Requirement Management/ Defect Tracking Tools: TFS, HP ALM/QC, JIRA

Big Data Ecosystem: HDFS, HBase, Hive, Sqoop, Flume

Business Modeling Tools: MS Visio

Language: SQL, PL/SQL, Python

RDBMS: SQL Server, Oracle, MS Access, Teradata

Web Technologies: HTML, XML, SOAP

Operating Systems: Microsoft Windows - Vista, XP UNIX - Sun Solaris, HP-UX

Business Applications: MS Office Suite, MS Project, MS SharePoint

Reporting Tool: Tableau

Healthcare Tool: Facets

PROFESSIONAL EXPERIENCE

Confidential - Nashville, TN

ETL Tester/ System Analyst

Responsibilities:

• Involved in preparation of Test Procedures, Test Scenarios, Test Cases and Test Data for end to end testing.
• Participated in daily and weekly scrum team meetings.
• Developed, executed and implemented test plans, test cases and test scripts for applications.
• Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in HP ALM.
• Created Subject Area Questionnaire, identified key subject area stakeholders.
• Used SQLs to test various reports and ETL load jobs in development, QA and production.
• Worked in design and developed Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Experience in Data validation between the pre hadoop layer and HDFS staging layer
• Worked on loading structured and semi structured data into HDFS and Hive
• Experience using SQOOP for transferring data from relational database to HDFS
• Manage and extend the automated test framework developed in Python, testing new features for releases of their real-time streaming device ensuring projects are released on time.
• Collecting Test Data for Data Driven testing and creating test cases using Python Selenium webdriver, TestNG Annotations.
• Reviewing Python code for running the troubleshooting test cases and bug issues.
• Worked with the Data Modeling team to create Logical/Physical models for Enterprise Data Warehouse.
• Performed Data Analysis and Data Profiling using complex SQL queries on various sources systems including Microsoft SQL Server and Oracle.
• Work with solutions/delivery teams to implement data quality processes during acquisition, ETL, and delivery stages for Business Intelligence solutions and changes to Data Warehouse.
• Wrote complex SQL queries to extract and validate the data from the database.
• Responsible for Data Profiling to determine data integrity for transformation of Data from Source to Target.
• Able to create a Requirements Traceability Matrix to assist in testing and understanding Business scenarios/use cases.
• Developed Requirements Traceability Matrix using MS Excel.
• Created SQL queries involving Joins, Functions and Stored Procedures.
• Conducted brainstorming and JAD sessions with stakeholders and end-users for requirement analysis and documented the same.
• Managed Databases and updated data coming from different sources
• Communicate with the technical team and product owner to understand about the application functionality.
• Reviewed Business requirement Documents and functional requirements.
• Identified gaps and created stories for Data Acquisition by working with source system owner/experts for details
• Established baseline KPIs by accessing and analyzing existing reports.
• Write User Stories -Elaborated User Stories and Acceptance Criteria; Reviewed user stories with team.
• Responsible for conversion of data in Data Mapping and writing transformation rules.
• Performed Requirements Analysis and traceability.
• Compiled Mini JAD notes in a S2T Document.
• Review baseline items agreed upon in the initial kickoff meeting, Data Model- logical and physical, S2T mapping business logic and transformations, table/attribute definitions.
• Led and managed the User Acceptance Testing (UAT) for the implementation Extended Enterprise administrative system with emphasis on ensuring that the HIPAA regulations are met across all the modules
• Worked with the clients on the final signing process in the User Acceptance stages.

Environment: Teradata SQL, MS SQL Integration Services SSIS, PL-SQL, Access Database, Python, MS Excel, Window XP, MS Word, Visual Studio, Agile, Microsoft Powerpoint, ERWIN Data Modeler, MS Visio

Confidential, Madison, WI

ETL Tester/Systems Analyst

Responsibilities:

• Worked through Software Development Life Cycle (SDLC) from Requirements, Analysis, Design, and Implementation through Testing.
• Continuously improved empirical process (Transparency, Inspection and Adoption) for Scrum team.
• Facilitated Scrum ceremonies like Sprint Planning, Daily Stand Up, Sprint Review and Sprint Retrospective.
• Created JIRA dashboards for team velocity, pie chart, sprint hours and team health.
• Created and executed SQL queries using Relational Database.
• Performed Data Analysis and Data validation by writing SQL queries using TOAD.
• Worked in design and developed Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW).
• Performed data analysis using SQL, data profiling and validation on the various source data systems and feeds and cleansed and standardized the data to be provided to ETL.
• Involved in comprehensive functional testing during the development process ahead of QA and UAT.
• Experience in reviewing Python code for running the troubleshooting test cases and bug issues
• Understanding Python files in openstack environment and make necessary changes if need
• Extensively used complex SQL to retrieve and manipulate data in the database for data validation within the UAT phase
• Actively worked with the Business Users in the UAT phase by helping them build test scenarios, test cases and resolving any anomalies in the results of the reporting elements.
• Removed any impediments and re-prioritize Sprint Backlogs as required.
• Used JIRA to document user stories, acceptance criteria, attach mock-ups and more components.
• Created and maintained user stories using JIRA/Confluence.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Understood the AS-IS system, developed the TO- BE system concepts and also prepared the System Process Maps.
• Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Assisted in the implementation of Enterprise Data Warehouse with individual data marts to address areas of business interest.
• Created a team specific agile workflow in JIRA to move tasks from one activity to another.
• Coordinated the backlog and sprint cycles with the Product Owner to ensure that the milestones are achieved.
• Gathered Business Requirements. Gap Analysis of Client requirements, generated workflow process and necessary documents for the project by interacting with stakeholders, and SMEs.
• Prepared data visualization and data analytics reports with Tableau software.
• Worked on Pivot table and V-lookups in MS Excel.

Environment: Agile Scrum, JIRA/Confluence, ETL, MS SQL Server, Enterprise Data Warehouse (EDW), MS Access, Tableau, MS Visio, MS Project, MS SharePoint, SQL, PL-SQL,MS Office, XML, HTML, UAT, Windows.

Confidential, Tampa, FL

ETL Tester/Systems Analyst

Responsibilities:

• Used Agile Scrum methodologies working on the complete project life cycle.
• Performed Data Analysis & used MS Excel to generate various reports for the Monthly, Quarterly & Annually meetings.
• Wrote SQL queries to perform data quality checks, to know the domain of values and to determine reasonableness conditions for the fields that were getting mapped.
• Co-coordinated UAT with the SME's to make sure that all the business requirements are addressed in the application.
• Developed test cases to test the functionality of the system based on the test conditions.
• Created detailed level test scenarios on HIPAA compliance testing. Gathered business requirements from business users such as Insurance Policy Managers and drafted business requirement documents (BRD).
• Built relationships with Product owners and other stakeholders to facilitate team interaction with them.
• Continuously learns Agile/Scrum techniques and shares findings with the team.
• Engages with other Scrum Masters to increase the effectiveness of the application of Scrum in the organization.
• Organizes and facilitates project planning, daily stand-up meetings, reviews, retrospectives, sprint, release planning, demos, and other Scrum-related meetings.
• Facilitates sprint planning, retrospective and sprint demos.
• Conducted data analysis using SQL and Excel to create reports in Tableau.
• Monitored the project progress and radiated the information to stakeholders. Identified and mitigated team risks and impediments (Blocking Issues, Critical Defects) on a daily basis.
• Tracks and effectively communicates team velocity and sprint/release progress to all affected teams and management.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Conducted Functional Walkthroughs as well as User Acceptance Testing (UAT) sessions.
• Developed Use Case diagrams with MS Visio and also created Business Flow Diagrams, Activity/State diagrams, and Sequence diagrams, which enabled developers and other stakeholders to understand the business process.
• Designed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams to define the Business Process with the help of MS Visio.
• Responsible for the analysis of existing processes; elicitation, analyses, and management of requirements; and development of Systems Development Life Cycle (SDLC) documents.
• Analyzed the existing business process and created AS-IS process flow to illustrate the existing system.
• Determine the future business process and TO-BE process.
• Conducted GAP analysis to analyze and identify the gap between the current process and the future process and identified steps to close that gap.
• Incorporated stakeholder feedback throughout the project lifecycle to ensure project quality and customer satisfaction.
• Traced requirements throughout the development process and verifying adherence using the Requirements Traceability Matrix (RTM).
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Implemented a set of BI tools and techniques for gathering and transforming raw data into meaningful and useful information for business analysis purposes.
• Provided business and technical recommendations or solutions for assigned projects.

Environment: Agile Scrum, HP ALM/QC, SQL Server, ETL, MS Office Suite, ETL, SQL, MS Visio, MS Project, MS SharePoint, Data warehouse, Tableau, HTML, XML, UAT.

Confidential, Buffalo, NY

Business Systems Analyst

Responsibilities:

• Implemented the SDLC for the developing life cycle and followed the standards process in the application.
• Facilitated JAD (Joint application development) & JAR (Joint Application Requirement) sessions with business users and development teams to drive out detailed business requirements.
• Closely interacted with designers and software developers to understand application functionality, navigational flow and how data is passed.
• Documented and delivered Business Requirement Documents (BRD), Functional Requirement Specification (FRS) to the project team.
• Identified 'AS-IS' process and 'TO-BE' process as parts of Gap Analysis.
• Facilitated sprint ceremonies in absence of Product owner and Scrum Master.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Configured facets modules such as Claims, Membership, Billing, Benefit and plan.
• Involved in claim adjudication process of facets application.
• Performed forward and backward data mapping between fields in Mainframe and Facets.
• Tested the changes for the front end screens in Facets related to Membership, Benefit and Plan modules.
• Identified and analyzed trends in EDI failures, collaborating with new EDI partners to develop innovative solutions.
• Utilized MS Visio diagrams, data flow diagrams, use case diagrams and process flow diagrams using the CMS-MITA guideline.
• Designed and developed test cases based on functional requirements for Institutional and Professional claims for EDI and HIPAA Transactions 837/835, 834, 276/277, 270/271 testing.
• Created data mapping documents based on client specifications which involved working with Facet claims, membership & plan data model.
• Gathered the Requirements for Medicare Systems as part of Patient Protection Affordable Care Act (ACA).
• Managed and prioritized user stories using Quality Center. Worked with the development team to identify blockers and provide resolution.
• Created a Requirements Traceability Matrix (RTM).
• Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Quality Center.
• Used SQL queries to analyze data for decision making & for Backend testing.
• Conducted data analysis using SQL and Excel to create reports in Tableau.
• Processed data using Excel pivot tables.

Environment: Agile Scrum, Quality Center, Facets, HIPAA, EDI, ETL, SQL, Tableau, MS Visio, MS Project, MS SharePoint, MS SQL Server, MS Office Suite, Windows.