SUMMARY

• Outstanding productivity as an Information Technology professional. Unique combination of expertise in technical, interpersonal and organizational skills.
• Exposure of complete software development life cycle.
• Familiar with Cloud services (e.g. SaaS, PaaS, and IaaS)
• Strong technical experience in EIB, Workday Studio, Transformation using XSLT, Web services, Workday Report Writing, custom reports, calculated fields, compensation, MS PowerPoint, MS Excel, and Oxygen XML.
• Strong understanding of quality Methodologies (e.g., Agile, CMMI, ISO9001)
• Experience in Healthcare/Claims adjudication with the knowledge of industry compliance standards - HIPAA 4010/5010, ICD9/ICD10 and EDIX12 transactions (837,834,835,270,271,276 and 277)
• Worked on Data Mapping and Data conversion from Legacy Facet 4.21 to FACETS 5.01
• Extensive work experience to create and update XML, XSD, JASON and XSLT
• Hands on Experience in Data Driven Testing using SQL queries with Joins, Functions etc. for Data Validation and Data Analysis
• Expertise in reviewing requirement documents and converting them to testable scenarios.
• Worked as lead in test planning, design and duration estimations.
• Experienced in bug tracking systems and process.
• Communicating with Analysts, Clients, Software Vendors and other participating groups to analyze any requirement gaps or any other conflicting issues.
• Experience in functional, regression, integration, compatibility, installation, black box, white box, gray box, unit, design verification, database, GUI, and supporting user acceptance testing.
• Integration testing experience in various environments.
• Authorized to work in United states as a Citizen
• Dynamic communicator with ability to clearly articulate in-depth technical concepts to others

PROFESSIONAL EXPERIENCE

Confidential

WORKDAY INTEGRATION Associate CONSULTANT

Responsibilities:

• Helped to develop and maintain functional and system documentation for Workday (PRD/ BRD/ TDD etc)
• Provided technical support for development of Mass Update EIB’s
• Assessed upcoming Workday release functionality and impacts to client business processes Developed test scenarios and test cases for all in scope Business processes such as (hire, job change, terminate, etc.) along with testing of security role mapping for each of the Business processes.
• Participated in end to end design reviews, prototype reviews and user acceptance testing
• Written Use Cases and produced Activity diagrams, Developed requirement specifications and Documentations for Business Process Management.
• Configured Workday compensation packages including salary, bonus, allowance, commission, and merit plans for multiple countries including merit and bonus plan processing.
• Assisted with data cleanup, extraction/load and data validations(as needed)
• Created custom Workday reports and modified the existing custom reports. Managing Data conversions, HR and Compensation related Custom Reports, and Security Management, Business Process configuration and, configuring the application according to customer requirements and developing system Integration.
• Interacted with Business analysts and end users to clarify requirements and use cases.
• Built and managed integration using Calculated Fields, EIB, Document Transformation, Workday Connector, XML, XSLT and Web Services technologies.

Confidential, Rochester, NY

Senior ETL Test Analyst

Responsibilities:

• Validated XML, CSV and flat files to verify the data format meets business requirement
• Created and maintained QA test plan, defect logs and test results in HP ALM and JIRA
• Developed and maintained functional test artifacts and the test data for data validation
• Worked and created complex SQL scripts using various joins, case statements/decode functions, sub queries, aggregate and analytical functions in Oracle database
• Created XSD from XML using XMLSpy tool.
• Created mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta - data definitions
• Prepared and executed the end to end scenario Test Cases.
• Participated in end to end design reviews, prototype reviews and user acceptance testing
• Updated different reports such as Tabular, Summary and Joined HCM Payroll reports using Salesforce
• Created automation test scripts to test client web integration to validate new changes occurred on new reports
• Conducted and participated project meeting to discuss bugs and requirement issues
• Built and managed integrations, Transformation, Connector, XML, XSLT and Web Services technologies.

Confidential, Rochester, NY

Senior ETL & Data warehouse Analyst

Responsibilities:

• Reviewed functional and design specifications to ensure full understanding of individual deliverables required to support project deliverables
• Created and maintained QA test plan, defect logs and test results in HP QC
• Developed and maintained functional test cases and other test artifacts like the test data and data validation
• Extensively worked on validating and running ETL work flows via command line/work flow manager and used work flow monitor as to start, monitor and verify logs on ETL work flows
• Extensively worked and created complex SQL scripts using various joins, case statements/decode functions, sub queries, aggregate and analytical functions in Oracle database
• Performed backend database validation for data warehouse, dimensional data mart, and enterprise report and Dashboard testing using Cognos and Tableau
• Conducted and participated meeting to discuss bugs and requirement issues
• Designed end to end scenarios test cases.
• Executed the end to end scenario Test Cases

Confidential, Fargo, ND

Senior QA Analyst

Responsibilities:

• Created test process document and test document templates to stream line the testing efforts and to communicate the process to the other departments
• Participated in defining rules involving bug tracking and also handling of new requirements
• Executed and managed all aspects and phases of testing including manual, automation to find critical defects using Microsoft Visual studio, Microsoft Test Manager, SOAPUI with Selenium RC/Java Web
• Performed backend database testing for data warehouse, dimensional data mart, and enterprise report testing
• Participated in design, use case reviews and quality inspections for each release.
• Participated in project review meetings.
• Designed end to end scenarios test cases using Team Foundation
• Executed end to end scenario Test Cases
• Involved in writing extensive SQL queries to check the data integrity
• Conducted and participated QA meeting to discuss bugs and requirement issues