| Name: | Venugopal N - DataStage/ETL Developer/Admin | | Primary Skills: | DataStage 8.1/7.5/7.5.2, Teradata Utilities (BTEQ, FastLoad, MultiLoad, FastExport), Oracle 10g/8i, Remedy, DB2/UDB 8, SQL Server 2000/2005, Cognos, WebSphere RTI 7.5.2, XP, Linux, AIX, MVS (OS/390) | | Summary: | More than thirteen years of IT experience in System Analysis, Business Analysis, Database Design, Development, Testing, Implementation and Integration of various Data Warehouse Systems and Business Intelligence Applications on Client-Server and Mainframe environments
Ten years of experience in Data Warehousing on ETL (Extract, Transform and Load) using IBM WebSphere/Ascential DataStage 8.1/7.5/7.0/6.0/5.2, Teradata Utilities (BTEQ, MultiLoad, Fastload, FastExport &TPump) including ETL Architect, Administration, Data conversion/migration/architect & building Enterprise Data Warehouses and Business Intelligence Reporting Systems using Cognos 8.x
Team lead experience that included managing project tasks, mentor developers and user liaison.
Experience in Full Life Cycle and Methodology for Implementing Enterprise Data Warehouses and Business Intelligence Reporting System.
Experienced in Data modeling (Star and Snowflake Schema), Conceptual, Logical, Physical model and ER-Diagrams using Erwin and Visio.
Experienced in gathering functional, technical requirements and translate the requirements into data models, preparing Data Mapping documents and ETL Design Specifications
Experienced in working with Data Management team to determine and define data transform requirements, design ETL process to Migrate Data from Legacy Systems into New Core Systems
Extensive experience in Administration and developing Parallel Jobs, Mainframe Jobs, Shared Containers, Server jobs, Sequence Jobs and Quality Stage Jobs using DataStage
Extensively worked on Teradata Utilities (BTEQ, MultiLoad, Fastload, FastExport, and TPump), Oracle SQL Plus programs and Computer Associates (CA) FastUnload utility for ETL process.
Experienced in Business Intelligence tools Cognos 8.3/7, Business Objects 5.x/4.1,SQR, Actuate Reports and Crystal Reports
Experienced in Database Design/Development in Teradata V2Rx, Oracle 10g/9i/8i/7.x, DB2 8.x/7.x, SQL Server 2005/2000/7, Sybase 11/10, VSAM and MS-Access 97/200x
Experienced in writing Database Stored Procedures, Functions, Packages and Triggers using PL/SQL.
Experienced in writing JCL, COBOL programs on Mainframe environment and also working with PeopleSoft, SAP BW, SAP R/3 - ERP Systems
Experienced in writing UNIX Shell Scripts/Windows Batch Programming, Scheduling and running Jobs in AutoSys, Control-M, Tidal and DataStage Director
Experienced in performing database tuning, troubleshooting, capacity planning, availability, and performance monitoring activities.
Experienced on OS platforms like Windows NT/2000, MVS (OS/390), UNIX (Solaris, AIX, HP, Linux)
Excellent in Documentation, End-User Training, Knowledge Transfer and Production Support.
| | | Total Exp: 13 yrs, US Exp: 9 Yrs, Available: Now, Current Location: San Francisco, CA. Relocation: West Coast & Midwest | | Goto Top | Receive Resume by EMail | |
0 comments:
Post a Comment