As part of Special Investigation Uint (SIU) at Nationwide to identify fraud in medical billing claims. The TechHealth Integration is part of an overall effort to send a daily transactional file from Genex, TechHealth and Progressive for reporting and analytics related to Worker’s Compensation claims to the Nationwide Data Warehouse. The three companies combined will stage transactional data for Pharmaceutical, Durable Medical Equipment, Radiology et al data files into the Data Warehouse (DW). The absence of the Genex, TechHealth and Progressive data today presents a significant fraud reporting and analytic gap. Responsibilities: ? Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation. ? Used Teradata utilities fastload, multiload, tpump to load data ? Wrote BTEQ scripts to transform data ? Wrote Fastexport scripts to export data ? Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL. ? Constructed Korn shell driver routines (write, test and implement UNIX scripts) ? Wrote views based on user and/or reporting requirements. ? 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. ? Performance tuned and optimized various complex SQL queries. ? Wrote many UNIX scripts. ? Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ. ? Gathered system design requirements, design and write system specifications. ? Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently. ? Agile team interaction. ? Worked on data w