Netezza Architect Resume
Irving, TX
SUMMARY
- 12+ Years of experience in Data Warehousing and Business Intelligence applications using Teradata V2R12, Netezza 7, Informatica 8.1.1, BusinessObjects 6.5.1, Webintelligence 6, Oracle 9.1, SQL Server 2005 and TIDAL Enterprise scheduler.
- ‘Teradata 12 Certified Professional’ and ‘Teradata Certified Master V2R5’ with expertise in Design Architecture, Physical Implementation, Database Administration, Application Development and SQL.
- ‘IBM Certified Specialist - Netezza Platform Software v6’ with expertise in Netezza Architecture, Application Design and Development.
- Extensive hands on experience in areas of DW consulting, business study, database administration, analysis, design, development, decommissioning, implementation and support of software applications in Data Warehousing and Client/Server environment in Healthcare, Airline, Telecom, Manufacturing and Retail Industries.
- Extensive hands on experience in design, development, testing, administration and performance tuning of complex Teradata and Netezza SQL in EDW environment
- Extensive hands on experience in design, development and testing of complex Informatica mappings involving various transformations like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
- Extensive hands on experience in BusinessObjects Administration and Design of Universes and Reports in BusinessObjects.
- Expertise of working in Onsite-Offshore delivery model.
- Good team player with leadership abilities and excellent communication skills.
- Strong analytical, presentation, problem solving and excellent inter-personal skills.
TECHNICAL SKILLS
Operating Systems: Linux Server Release 5.4, Solaris UNIX, SCO UNIX, SunOS, Windows NT, 95, 98 & 2000, XP, Vista
Languages: PL/SQL, SQL, Unix Shell programming and Pro*C
Scripting: UNIX Shell Scripting
RDBMS: Teradata V2R12/V2R6/V2R5, Netezza 6/7, SQL Server 2005 and Oracle 9.2.0.5.0
BI Tools: ERWin Data Modeler 7.3, Informatica 8.6.1/8.1.1/6.1/5.1.1 , BusinessObjects 6.5.1/5.1.4 , Webintelligence 6/5
Scheduling Tools: Autosys, TIDAL Enterprise Scheduler, Maestro 6.3, Control-M and BusinessObjects BCA Scheduler and Console utilities
Special Software: Teradata Manager, Teradata Adminstrator, Teradata SQL Assistant, Aginity and BusinessObjects Server Applications
PROFESSIONAL EXPERIENCE
Confidential
Netezza Architect
Environment: Netezza 7, DBCrane, Talend Open Studio, Informatica Fast Clone, Informatica CDC, iMasterdata MoveitAll and Dell Shareplex, Linux and Widows
Responsibilities:
- Evaluation of following tools and approaches to load data from Oracle to Netezza DBCrane, Talend Open Studio, Named Pipe Approach in Linux Environment, Informatica Fast Clone, Informatica CDC, iMasterdata MoveitAll, Dell Shareplex and Oracle HS ODBC
- Netezza client installation on Linux
- Working on Agile methodology and delivering increments of deliverables
- Interacting with Offshore Team to clarify requirements and issues
- Documenting Business requirements in Technical Specifications
- Preparation and development of test data and performance testing on various replication & CDC tools during evaluation of Tools and approaches.
- Prepare the Oracle to Netezza migration approach document.
- Peer review of documents prepared by the team mates.
- Involved in the retrospective meetings to discuss on what went wrong in the current Sprint and improvements for the next sprints at the end of every sprint.
- Responsible for Knowledge transfer and other team activities.
Confidential
Netezza Designer
Environment: Netezza 6, SSRS, Linux and Widows
Responsibilities:
- Push-down enablement in Informatica to Netezza to utilize Netezza performance features.
- Code migration from Informatica to Netezza for higher performance.
- Performance tuning/optimization and analysis of Netezza SQL objects.
- Enhancement and new development and testing of INFA/ UNIX/Netezza Objects.
- Project Management documentation.
- Responsible for Trainings, Knowledge transfer and other team activities.
Confidential
Teradata Application DBA
Environment: Teradata V12, ERWin Data Modeler 7.3, Linux Server release 5.4, Oracle 10G, and Windows XP
Responsibilities:
- Performance Analysis and Tuning of existing and new Teradata scripts
- Data modeling activities using ErWin
- Provide Teradata technical support to Operations, Reporting and ETL development teams at Offshore
- Conduct Teradata Training Programs to bring development teams up to speed
- Involve in Physical Database Design and Physical Modeling
- Creating Database structures like Tables, Views, Macros and Procedures
- Use Multi value compression to reduce space consumption and enhance query performance
- Implementation of physical data standards
Confidential
Teradata Application DBA
Environment: Teradata V12, Linux Server release 5.4, Oracle 10G, and Windows XP
Responsibilities:
- Involve on Physical database Design activities
- Performance Tuning of Teradata scripts and Procedures
- Migration of Oracle Packages, Procedures, Macros and Functions to Teradata
- Provide technical assistance to migrate Tables, Views, BTEQ Scripts, Macros, Packages, Procedures and Functions from oracle to Teradata
- Creating Database structures like Tables, Views, Macros and Procedures
- Implementation of physical data standards
- Provide technical support to Reporting and ETL development teams at Offshore
- Co-ordinate with DW Architects from Onshore
Confidential, Irving, TX
Teradata Application DBA
Environment: Teradata V2R6, SQL Server 2005, Oracle 9.2 and Windows XP
Responsibilities:
- Physical database design
- Performance Analysis and Tuning of complicated Teradata BTEQ scripts
- To use Teradata Multi Value Compression feature to reduce space consumption in large tables and increase performance
- Weekly and Monthly Back up monitoring
- Diagnose and resolve problems in BTEQ Scripts on Windows environment.
- Create, alter and maintain application database structures
- House keeping activity such as allocating space, checking statistics, ensuring databases have sufficient space.
- Implement physical data standards
- Production run and Maintenance of Batch jobs
Confidential, Peoria, IL
Teradata Application DBA
Environment: Teradata V2R6, IBM Information Server 8.0, IBM MDM, Legacy Mainframes, SAP ECC, UNIX/LINUX and Windows XP
Responsibilities:
- Performance analysis and tuning of complicated Pre-Close and Post-Close Teradata processes.
- Physical modeling, physical setup of schemas, tables, etc.
- Monitoring the performance of database and other alerts
- Investigating long running queries, assisting developers/users to tune queries
- Database and application design reviews
- Monitoring backups to completion
- Perform research on database features, technologies, and tools
- To understand Pre-Close and Post-Close Teradata processes and transfer the knowledge to CAT EDW team.
Confidential
Teradata Application DBA
Environment: Teradata V2R6, Windows NT/2000 servers and Windows XP
Responsibilities:
- Tuning of complicated Teradata Queries generated by Cognos reports involving Business Views.
- To create Users, Batch IDs and allocate space and other database rights.
- To set up Dev, Sys and UAT environments.
- To co-ordinate with onsite team in implementing Business Views in production environment.
- To assist developers with ETL processes involving Fast Loads, Multi Loads, complicated queries and performance issues.
- To understand Teradata CLDM and proactively suggest design improvements for Teradata Business Views.
- To understand Low Level Design and assist developers in development and testing of efficient Teradata Business Views.
- To work in shifts and assist ETL and Reporting Dev teams.
Confidential
Technical and design consultant and BusinessObjects Administrator
Environment: BusinessObjects 6.5.1/5.1.4 , Webintelligence 6/5, Teradata V2R6/V2R5, Windows NT/2000 servers and Windows XP
Responsibilities:
- Provide design and technical support for ICW (Integrated Commercial Warehouse) BusinessObjects development projects across Confidential to develop BusinessObjects reports and universes.
- Performance Tuning of time consuming and inefficient Teradata queries generated by BusinessObjects.
- As a BusinessObjects administrator, create and maintain BusinessObjects security groups and users in Supervisor module of BusinessObjects as per users’ requirement and BA standards.
- Assist in planning and implementation of BusinessObjects capacity Management for various BusinessObjects development projects in BA.
- Support and maintain BusinessObjects environment in BA, which includes performance and status monitoring of BusinessObjects repository, BCA schedulers and Webi application.
- Migration of Live BusinessObjects reports and universes from older to newer versions.
- Responsible for BusinessObjects Technical Helpdesk and resolve BusinessObjects queries raised by BA BusinessObjects users located across the globe.
- Design review and live implementation of BusinessObjects reports/universes and further link them to necessary security groups in Supervisor.
- Enhance and fix bugs in Live BusinessObjects reports and universes raised by users and other support teams.
- Set standards and guidelines for design and development of BusinessObjects reports and universes.
- Schedule and monitor BusinessObjects reports on BCA schedulers.
Confidential
ETL and Reporting Design and Technical consultant
Environment: Informatica Power Center 7.1.1/6.1, BusinessObjects 6.5.1/5.1.4 , Webintelligence 6/5, Teradata V2R6/V2R5, UNIX Solaris and Windows XP
Responsibilities:
- Involve in Business Study, investigate and propose the best method of ETL for loading engineering materials data from SAP operational system to corporate warehouse using Informatica.
- Performance tuning, Prototyping, Design, Development, Review and Testing of Teradata .BTEQ/.SQL scripts, Informatica mappings and Detail Navigator data maps.
- As a technical lead and offshore coordinator, responsible for development, Unit/System/Volume/User acceptance testing, delivery, implementation support and warranty support of Teradata, Informatica and detail navigator components.
- As an onsite coordinator, responsible for interaction with the client and other support teams, Onsite coordination, Design, Development, Unit/System/Volume/User acceptance testing, implementation and warranty support of Teradata, .BTEQ/.SQL scripts.
- Decommission Data marts and Transaction Data warehouses on Teradata, Oracle and mainframe.
- Development, testing and implementation support of UNIX Shell scripts.
- Involve in Business Study and propose the number of BusinessObjects universes, number of ad-hoc and canned reports for a set of given reporting requirements of engineering materials data.
- As an onsite coordinator, responsible for interaction with the client and other support teams, Onsite coordination, Design, Development, Unit/System/Volume/User acceptance testing, implementation and warranty support of BusinessObjects reports and universes.
- Prototyping, Design, Development, Review and Testing of BusinessObjects reports and Universes.
Confidential
ETL Developer
Environment: Informatica Power Center 5.1.1, Windows 98/95 and UNIX SunOS/ SCO
Responsibilities:
- Development, Modification, Review and Unit testing of Informatica mappings, Maestro Schedules, Pro *C template programs and UNIX shell scripts.