- Elicited business requirements from business users and subject matter experts, defined and documented requirements, wrote functional specifications, and performed business process design in conjunction with operations teams.
- Served as liaison between the internal/external business community and the IT organization in order to provide technical solutions to meet user needs.
- Identified and translated business needs into clearly defined requirements for the policy administration and claim systems.
- Developed functional documentation inclusive of user stories/ use cases, process flows, data flows and report mock-ups.
Responsible in formulating Data Dictionary from the existing SQL Script through the process of reverse engineering, maintaining integration between external and internal legacy systems, including data mapping and meta data management. - Developed complex SQL queries for querying data against different data bases for data verification process. Analyzed the data, understood the data, standardized the data and documented the lineage of data across the Enterprise.
- Performed data mapping among various source systems, transformation of data to meet internal system requirements.
- Compiled detailed documentation for technical team (Architect, Developers, QA etc.) and facilitated project/enhancement governance and prioritization.
- Involved in defining source to target data mappings, matching from Custom to Standard field elements and data definitions.
- Responsible for testing within the Quality Assurance testing cycle: Smoke (Sanity) Testing, Functionality Testing, Ad Hoc Testing, Regression Testing and End-to-End System testing on software applications.
- Performed all levels of Data Warehousing testing within an ETL Architecture/process: extraction and conversion of data from external sources and transformation of data to meet internal system requirements, and loading into EDW.
Environment: SQL Server 2012, Unix, SharePortal, Toad, XML, Rational RequisitePro, JIRA, SoapUI, Informatica, ClearQuest.