Gurtej Bhangugsb419@hotmail.comProfessional SummaryGurtej Bhangu is ETL/EDW/BI consultant. Experienced in Business Requirements Analysis, Applications Design, Development, Testing, Implementation and Support for ETL, EDW, DQ, ILM, CRM and Client/Server applications using Teradata, Informatica, SSIS, BODS, DataStage, Agile Methodology, Jira issue tracking tools across Energy, Telecommunication, Financial, Insurance, Pharmaceuticals, Health, and Retail Industries. Experienced in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, Fast Export, Tpump, and Teradata SQL Assistant). Proficient in the Integration of various data sources with multiple relational databases like Oracle, SQL Server, DB2, Teradata, Mainframe, VSAM files and Flat Files, XML, Web Services, SAP ECC, SAP BW, and Siebel into the staging area, ODS, and EDW. Extensive UNIX shell scripting and automation of the ETL processes using UNIX shell scripting. Experienced in using Automation Scheduling tools like Autosys and Control-M. Worked with various BI tolls such as SAP BO, SSRS, and Cognos. Technical ExperienceSoftware and Tools: Informatica (PowerCenter), IDQ, ILM, DVO, Erwin, PWX, SSIS, DataStage, BODS, SAP BO, Crystal Reports, SAP ECC, SAS, Epic EMR, SAP BWPlatforms: AIX, UNIX, Sun Microsystems, Sun Solaris, HP-UX, Compaq, z/OS, Intel, Windows NT, DellDatabases: Teradata, DB2, Oracle, Access, SQL ServerProgramming: Teradata Macros, BTEQ, MLOAD, FASTLOAD, FASTEXPORT, Shell scripting, SQL, T-SQL, PL/SQL, VBA, AS400, XML, Korn, ASP, C/C++, Java, MQSeries, HTMLRelevant Client List Centene Eli Lilly and Company Vidant HealthFranciscan HealthRocheUS BankComputer Science CorporationPfizer/Pharmacia & UpjohnChrist HospitalSappi PapersAT&T/AmeritechMotorolaSpirit AeroSystems Citicorp