Dwh Designer/data Modeller Resume
MassachusettS
SUMMARY:
- Over 8+ years of Professional Experience in Software Development Life Cycle (SDLC) including Business, System and Data Analysis, Testing, Implementation and Documentation in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
- Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Mapping Documents for Dev and QA Teams.
- Good knowledge of Medicare/Medicaid (MMIS) rules and HIPPA standards.
- Deep understanding of Software Development Life Cycle (SDLC), Waterfall, Agile.
- Solid experience with all levels of testings including Smoke Testing, Unit testing, Functional Testing, Integration Testing, System Testing, Regression Testing and UAT.
- Experienced in writing and providing mapping documents for the team to make their - Test plans, Test Cases, Test Scenarios and defining the Testing methodologies and verifying and validating them.
- Developed different Automation Frameworks like Linear, Structured, Keyword in HP Quick Test Professional.
- Experienced in both Manual and Automated tools using HP Quality Center/ Application Lifecycle Management, Test Director and QTP with VB Script.
- Excellent knowledge and working experience in Planning,Test Results Analysis, Requirement Traceability Matrix and analyzing business requirements.
- Good Working knowledge of Linux and Microsoft operating systems.
- Experience working with HP Load Runner for performance testing and developed test scripts
- Experienced in Functional, Load and Data Driven Testing in using SOAP UI.
- Extensively verified and validated XML request and response files Web Services from the third party service provider.
- Extensively involved in Build Acceptance Testing, Functional Testing and Database Testing using SQL Server 2000/20 .
- Excellent working Knowledge of Databases like MS Access, SQL server, Oracle with PL/SQL and Stored Procedure.
- Good knowledge of ETL Analysis, DWH, Datamart to Views designing of the flow and the logic for the Data warehouse project.
- Excellent Core JAVA knowledge and experience.
- Extensive use of defect tracking tool like HP Quality Center(ALM), Rational Clear Quest, JIRA.
- Excellent hands on MS office applications.
- Good knowledge using the reporting tools BI and Tableau.
- Excellent Knowledge of Data Warehouse/Data Mart design concepts.
- Organized, detail-oriented and have the ability to work well in a time sensitive environment.
- Excellent communication and presentation skills, self starter, quick learner and team player.
TECHNICAL SKILLS:
Languages: Java, VB Script, VBA, C, C++, SQL, PL/SQL, T-SQL, UML, XML, Shell Scripting
Tools: QTP 8.2/9.0/9.5/10.0 , UFT, SOAP UI, Data warehouse tools, ETL Tools, BO, tableau.
Bug Tracking Tools:: HP Quality Center, Clear Quest, JIRA.
Databases:: MS Access, MY SQL, SQL Server 2000/2005/2008 , Oracle 9i/10g, Toad for SQL server
Operating system:: Unix/Linux, Windows NT, Windows 2000/2003/2008 Server & Windows XP/Vista
Web Technologies:: XML, HTML, CSS, J2EE, PHP, VB Script, web services, .NET
PROFESSIONAL EXPERIENCE:
Confidential, Massachusetts
DWH Designer/Data modeller
Responsibilities:
- Extensively involved in Data Analysis Activities including Enterprise Data Management (EDM), Data Profiling, Data Quality, Data Governance, Source to Target Data Mapping and Data Testing/validation.
- Generated, formatted, and distributed data validation checklists and reports and collected sign off’s from business users and stakeholders for the same
- Written complex SQL queries for validating the data against different reports generated by Business Objects.
- Involved in Integrating and Functional System Development and Testing for the entire Data Warehousing Application.
- Efficiently maintained all the documents and trackers up to date and following up on any defects that require immediate attention.
- Created Business Requirement Document outlining detailed Business requirements (Functional and Non Functional), Data Requirements, ETL Specs, Timing, Constraints and Exceptions etc. Collaborate with data modelers, ETL developers in creating the Data mapping document.
- Experience in handling large volumes of data and played a key role in building transformations to meet the Confidential /HIPPA requirements.
- Attended daily standup meeting for daily update from the team. Co-ordinate with different scrum teams for updates and defect tracking.
- Experience working with Java Frameworks and general design patterns.
- Extensively used ETL tool Informatica for extraction, transformation and loading process.
- Used HP ALM for Requirements and Defects Tracking.
- Worked on test data to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
- Performed complex defect analysis in various environments like UAT, SIT, and QA to ensure the proper delivery of the application into the production environment.
- Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
- Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
- Developed Test plan, Test cases, Test scripts, Test results and various other project documentation in HP Application Lifecycle Management.
- Analyzed the data and applied relevant transformations and verified that the source data types are correctly transformed to Target tables as per the transformation logic.
- Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end System Integrated testing(SIT)and worked with data quality issues.
Environment: IBM Netezza, Oracle 10g/11g, Oracle Exadata 12g, SQL, PL/SQL,HP UFT 12.0, HP Quality Center 10,ALM 11.0, Toad, Windows XP, ETL Datawarehouse, Informatica, Business Objects, tableau.
Confidential, Olympia, Washington
Sr.Business System Analyst/Data Analyst
Responsibilities:
- Worked as a Business System analyst (backend and front end) in the financial management, member enrollment and eligibility module for the UAT and production environment for the Washington Health Finder web application.
- Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate.
- Responsible for testing entire member enrollment and eligibility workflows as per business requirements using Facets 5.01
- Used JIRA to raise defects and submit the tickets to the respective level.
- Responsible for communicating with the client for weekly status report and also with the offshore team.
- Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.
- Responsible for running batch jobs (daily and monthly) to create the EDI files from the existing XML.
- Responsible for validating and analyzing the EDI 834 and 820 files.
- Created jobs to schedule multiple reports in Cognos connection.
- Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements.
- Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer.
- Participated in business requirements reviews and software system (application) designs for testability.
- Track and report upon testing activities, including the test case execution stage, defect status if any defects opened during execution and the testing results status.
- Performed end to end data validation using ETL and BI tools.
- Wrote Use Cases, prepared use case diagrams (using Rational Rose & UML) and followed Agile at every stage of the processes.
- Developed SQL Queries for checking the Data Transaction and Database Integrity.
- Provided technical and procedural support for User Acceptance Testing (UAT).
- Assisted in GAP analysis for any available requirements and communicated through the CR process.
Environment: Oracle 11g, Facets 5.01, SOA Framework, ETL, Datawarehouse, Informatica, SQL server management studio, MS Outlook, Linux, MS Excel, MS Access, QTP, HP ALM, MS Visio, JIRA, Cognos.
Confidential, Solon, Ohio
Business System Analyst
Responsibilities:
- Coordinated, Managed, Mentor and Lead the offshore team in all the activities regarding Testing and conversion of legacy system to the newest version of Facets 4.81.
- Worked on Member Enrollment and Billing module for the implementation of Facets.
- Highly Responsible in developing High Level Test Scenarios from the Business requirement/Functional requirement document.
- Get approval from the business/ Client for the Test Cases/Test Plan, Data Setup and Execution of Test Cases.
- Logged defect in Quality Center (QC) 10.0, and assigned to an appropriate developer.
- Document all the Test Results (TR) from the Scenarios and submit to respective POC.
- Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project and performed the testings.
- Validated Extract/Transform/Load (ETL) processes that load Teradata test databases with data feeds from upstream applications and provided information deliveries of warehouse data to downstream users
- Involved in Adjustment of the Pharmacy Claims (Reversing the Claims, RR, RRCR, RRMR), and paying various types of claims. I.e. DMR (Paper Claims), PTP, Government claims, E-claims, MSP (Medicare secondary payer), COB, steps on running ERIC, EXTRACT, CET and NDM process.
- Performed smoke, Integration, Functional, and Regression Testing.
- Handled and worked in multiple projects at the same time within the given time frame.
- Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements
- Attend multiple meetings with the client Lead, Developer, and Project Manager to fully understand the functional and technical requirement, and to discuss the Test Scenarios Created.
- Highly involved with the Client to better understand the system and the business requirements.
- Wrote and Review test cases in QC, and Matrix the requirement documents along with it.
- Provide answers to the users for the test cases created and explained the final results, and the important functionality in the project.
- Conducting the Test Results walkthrough with the Clients and getting Sign off to deploy project on time.
- Involved in integration testing between EAS and RxClaim.
- Prepare TR (Test Results) documents via Quality Center and provide to the Clients on each project.
Environment: HP Mercury Quality Center 10.0, Windows 2000/2007/XP, Facets 4.81, Rational Clear Quest, MS Excel, MS Visio, Oracle BI, Business Objects, SSIS, Informatica, DWH, XML, Selenium, Cognos.
Confidential, Buffalo, NY
EDI Tester/Business Analyst
Responsibilities:
- Responsible for testing entire claims processing workflows as per business requirements using Facets 4.71.
- Gathered requirements and reviewed Use Cases for the applications that used SSN and DOB as unique identifiers.
- Analyzed URS and Functional Requirements Specifications to understand business rules of application.
- Validated displays of Patient Screen to include masked SSN & DOB Information.
- Claims Process validation - Identified Claims Matching Scenarios upon which millions of Claim records were matched daily based on Patient’s Information
- Involved in writing Test plans, creating Test scripts, and Team Co-ordination
- Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances
- Participated in meetings and JAD sessions to ensure legal and compliance deadlines of CMS (Centers for Medicare and Medicaid Services) are met
- HIPAA Conversion Analysis - Involved in the documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
- Defined the approach for automating significant parts of the QA framework.
- Responsible for carrying out manual testing like Integration, Regression testing during various phases of test cycles.
- Interacted with dev. & various members to discuss and resolve defects based on priorities.
- Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project and performed the testing’s.
- Developed and Maintained Test Schedule for Quality assurance deliverables.
- Responsible for working with application team in UAT and Production Release.
- Documented defects in IBM Clear Quest and provided test execution progress updates. Involved in writing functional automation framework code by using Descriptive programming. Validated the internal processing of the MMIS, or other transaction processing system.
- Developed Test scripts to meet the requirement by using the Business Scenarios and Business Requirements for different kind of Claims.
Environment: SOA Framework, MS Visio, Word, Excel, PowerPoint, Facets 4.71, CMMI, Rational Rose, Requisite Pro, Clear Quest, Claredi, SQL, Oracle, J2EE, Load Runner, Cognos, Datawarehouse.
Confidential, Parsippany, NJ
EDW-Data/Quality Analyst
Responsibilities:
- Performed end to end testing of pharmaceutical company’s renowned application iMANY CARS
- Configured the QA Environment for Manual Testing that includes data level testing and web application testing.
- Used QTP for web application testing as well.
- Performed Business objects testing and validating the results against Data warehouse.
- Tested the data and data integrity among various sources and targets.
- Use putty to connect to the remote systems over the internet through Telnet and SSH.
- Well exposed to SDLC system and its methodologies.
- Review the different subject areas like Formulary, Customer, Sales, Employee, Aggregates etc and provide feedback and comments that help in fulfilling the goal of EDW project.
- Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.
- Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
- Good experience in communicating with offshore team.
- Communication with the client for weekly status report
- Helped the team in analyzing the data to be able to identify the data quality issues
- Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project.
- Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases. Involved in various testing phases like Functional Testing, Integration Testing, Data Validation Testing Positive and Negative Testing, Sanity Testing, User Acceptance Testing and Regression Testing.
- Used HP Quality center to write and run the test cases and to raise and track the defects.
- Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.
- Developed Test Plan and Test Strategy for multiple data feed applications.
Environment: Oracle 9i/10g, SQL, TOAD, ETL/Informatica, DB2, Business Objects XIR2, XML, Flat Files, Shell Scripting, UNIX, Windows NT