Etl/teradata Lead Resume
Kansas City, MO
SUMMARY
- Client - focused ETL\Teradata Developer with 7 Plus years of experience in the areas of Application Software Requirement Analysis, Design, Development, Testing, Implementation, and Maintenance with proficiency as Teradata developer innovative and achieving high client satisfaction.
- Over 4 Plus years of experience using Teradata SQL Assistant, and data load/unload utilities like BTEQ, Fastload, Multiload, Fast Export and Tpump
- Extensive experience on Mainframes (MVS) Job Control Language (JCL).
- Extensive experience in writing and executingBTEQ scriptsfor validation and testing of the sessions, data integrity between source and target database and for report generation.
- Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database
- Familiar with designing the application data model and identifying the Primary Index, Secondary Index, Join Indices in Teradata for efficient storage and retrieval.
- Hands on experience in writing SQL queries in multi database environment.
- Good knowledge of Dimensional Data Modeling, Star Schema, Snow-Flake schema, FACT and Dimensions Tables.
- Working knowledge on the Business Intelligence Reporting Tool - Microstrategy.
- Done a lot of Performance Tuning for improving query performance of user queries and production SQL’s.
- Proficient in Teradata Database Design (Physical and Logical), Application Support and setting up the Test and Development environments.
- Worked on TCRM application on Campaign Management.
- Excellent Retail domain and ITIL knowledge
- Extensive experience working in Agile and Waterfall methodologies.
- Good documentation skills with the ability to meet project deadlines and ability to work in a cross functional environment.
- Strong communication skills, interpersonal skills, leadership skills, self-motivated, quick learner and team player
TECHNICAL SKILLS
ETL Tools: ETI extract, Teradata SQL Assistant, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, BTEQ, TOAD
Languages: SQL, SPL, COBOL,JCL
Database: Teradata TD12/TD13/TD14, DB2, Oracle 9i
Operating Systems: Windows 2003/2000/NT, UNIX, Mainframe
Office Suits: Microsoft Office - Word, Excel, Access, Visio, PowerPoint
Reporting Tools: Microstrategy, Excel.
Data Modeling Tools: ERWIN
EDI Translation Tool: GENTRAN
PROFESSIONAL EXPERIENCE
Confidential, Kansas City, MO
ETL/Teradata Lead
Responsibilities:
- Actively involvedin requirements gathering, creating design specifications and ETL designdocuments.
- Participated in Daily meeting with Business Units to resolve any issues/concerns.
- Loading Data to the Teradata Data Warehouse Tables from multiple data sources using Teradata utilities.
- Created tableswith appropriatePItaking into consideration of bothplanned access of data and even distribution of data across all the availableAMPS.
- Analyzed anddesignedSIbased on the columns used in joins during data retrieval.
- Used BTEQ andTeradata SQL Assistant front-endtools to issue SQL commands matching the business requirements to TeradataRDBMS.
- Utilizing Teradata Explain and Visual Explain to analyze and improve query performance. Redesigning and fine Tuning Teradata SQL for higher Performance.
Environment: Mainframe, Teradata 14, Datastage, Fastload, Multiload, BTEQ, FastExport, TPUMP.
Confidential, Houston, TX
Technology Analyst
Responsibilities:
- Coordinate with offshore team on Development activities.
- Setup new trading partners and monitor the EDI data for any data issues or application job failures.
- Interact with the end customers who wish to interface with us using EDI and develop new maps for 810, 850, 855, 832, 997 transactions as per their requirements.
- Manage a team size of five along with the application support.
- Use ITIL tools for Incident, Problem and Change Management to track the Service Level Adherences and production data changes.
- Execute SQL to report the analytics on the orders placed by the customers.
Environment: COBOL, JCL, GENTRAN, BMC Remedy, DB2.
Confidential, Kansas City, MO
ETL/Teradata Analyst
Responsibilities:
- Participate in Daily meeting with Business Units to resolve any issues/concerns.
- Create ER diagrams using Erwin and Microsoft visio based on the business requirements.
- Maintain all Customer data applications, TCRM and Enterprise Data Warehouse (EDW).
- Use Teradata Mload and FastLoad utilities through mainframe to extract data from flat files and load to Teradata tables.
- Wrote BTEQ scripts in mainframe to import and export data to and from the Teradata tables.
- Create views with OLAP functions for business to do analysis.
- Extract, Transform and Load data from various data sources to Teradata using Teradata utilities.
- Do performance tuning in the user queries and batch queries running in test and production environments.
- Coordinate with offshore team on Development activities
- Implemented changes in coordination with Infrastructure team and Provide Warranty Support.
- Worked as Production support team for production issues with Space forecast on the system
- Troubleshooting any issues related to production, database development and documenting issues.
- Working on improvement of existing process by integrating various sources and helping in maintenance code hence ensuring process is efficient.
- Review of statistics and joins for performance improvement of Teradata SQL's using DBQL, Explain Plans
- Making changes to Physical model to assist with performance improvement by implementing partitioning, compressions and indexes on EDW tables.
Environment: COBOL, UNIX, BTEQ, Teradata SQL Assistant, Mload, Fastload, FastExport, TPUMP, Oracle, DB2, Teradata 12/13, TOAD, Erwin, Microstrategy, Microsoft visio.