• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.• Transformations of requirements into data structures, which can be used to efficiently store, manipulate and retrieve information.• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.• Ensure that models conform to established best practices including normalization rules and accommodate change in a cost-effective and timely manner.• Used Teradata utilities FastLoad, multiload, tpump to load data• Wrote, tested, and implemented Teradata FastLoad, Multiload and Bteq scripts, DML and DDL.• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata• Worked on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.• Responsible in Generating Weekly ad-hoc reports.• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.• Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day.• Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities such as MLOAD, BTEQ and FastLoad.• Involved in Building a specific data-mart as part of a Business Objects Universe, which replaced the existing system of reporting that was based on exporting data sets from Teradata to Excel spreadsheets.• Provided design recommendations and thought leadership to sponsors/stakeholders that improved review processes and resolved technical problems.• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.• Used data analysis techniques to validate business rules and identify low quality for Missing data in the existing Bank data warehouse EDW.• Tested raw data and executed performance scripts.

• Met with Customers to determine User requirements and Business Goals.• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.• Worked closely with the claims processing team to obtain patterns in filing of fraudulent claims.• Conducted JAD sessions to gather requirements, performed Use Case and workflow analysis, outlined business rules, and developed domain object models.• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.• Wrote Teradata Macros and used various Teradata analytic functions.• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.• Responsible for management of data, duplicating the data and storing the data in to specific data warehouse using Talend Platform for Data Management and MDM.• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.• Interact with the SMEs to analyze the data extracts from Legacy Systems Mainframes and COBOL Files and determine the element source, format and its integrity within the system• Transformations of requirements into data structures, which can be used to efficiently store, manipulate, and retrieve information.• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.• Worked with internal architects and assisting in the development of current and target state enterprise data architectures.• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.

• Performed data profiling in the source systems that are required for Dual Medicare Medicaid Data mart.• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.• Responsible for ETL development with successful design, development, and integration of components within the Talend ETL Platform and Java Technology.• Responsible for management of data, duplicating the data and storing the data in to specific data warehouse using Talend Platform for Data Management and MDM.• Involved in defining the trumping rules applied by Master Data Repository.• Define the list codes and code conversions between the source systems and MDR.• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.• Involved in defining the source to target data mappings, business rules, and business and data definitions.• Responsible for defining the key identifiers for each mapping/interface.• Reverse engineered all the Source Database's using Embarcadero.• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.• Experience with various ETL, data warehousing tools and concepts.• Good Experience with Mainframe enterprise billing systems Involved in defining the business/transformation rules applied for Dual Medicare Medicaid data.• Worked with internal architects and assisting in the development of current and target state data architectures.• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.

• Work with the Project Management in the creation of project estimates.• Analysis of the data identifying source of data and data mappings of HCFG.• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.• Interact with the SMEs to analyze the data extracts from Legacy Systems Mainframes and COBOL Files and determine the element source, format and its integrity within the system• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.• Ensure that models conform to established best practices including normalization rules and accommodate change in a cost-effective and timely manner.• Enforce standards to ensure that the data elements and attributes are properly named.• Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.• Support development teams creating applications against supported databases.• Provide 24 x 7 problem management support to the development team.• Document various Data Quality mapping document, audit and security compliance adherence.• Perform small enhancements SOR element additions, data cleansing/data quality.• Create various Data Mapping Repository documents as part of Metadata services EMR.• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.