Teradata Senior Associate Consultant Resume Example

Project Description :

Development and maintenance of semantic/downstream layer in a data warehouse for Business user reporting. This project aims at building and maintaining a data mart on Enterprise Data warehouse, in order to increase the efficiency of the reporting, support business users in performing, more robust analytical reporting and decision making capability.

Responsibilities :

• Performed data analysis and gathered columns meta data of source systems for understanding requirement feasibility analysis.
• Worked on optimizing and tuning the Teradata views and SQL's to improve the performance of batch and response time of data for users
• Implement the code changes through change management tools.
• Worked closely with subject matter experts to come up with detailed solution approach design documents.
• Used Teradata utilities like Bteq export/import and Fast Load to load data into/out of Teradata database.
• Provided initial capacity and growth forecast in terms of Space, CPU for the applications by gathering the details of volumes expected from Business.
• Prepared low level technical design document and participated in build/ review of the BTEQ Scripts, Reviewed Unit Test Plans & System Test cases.
• Provided support during the system test, Product Integration Testing and UAT.
• Coordination of all the offshore development from onsite from assigning the job till code delivery and signoff.
• Verified if implementation is done as expected.
• Done the impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existing Data Warehouse applications that running in Production environment.
• Provided quick production fixes and pro-actively involved in fixing production support issues.
• Liaised between different implementation groups (Both source and target systems) and monitored the implementation activities.
• Analyze business requirements, designs and write technical specifications to design/ redesign solutions.
• Involved in complete software development life­cycle(SDLC) including requirements gathering, analysis, design, development, testing, implementation and deployment.
• Developed technical design documents (HLD and LLD) based on the functional requirements
• Coordinate with Configuration management team in code deployments.
• Implemented AGILE methodology for our formal delivery. Environment: Teradata14, BTEQ, Basic Unix, Oracle. ­

Project Description :

Data Warehousing Services. Description: Data Warehousing Services (DWS) manages the platform infrastructure hosting data from the Group's operational systems providing the capability for users or operational systems to query and extract this information as required. DWS manages the whole end to end change and service lifecycle including build, schedule and infrastructure support, service desk, risk and compliance and service and finance management. The goals of the Warehouse are to: ­ Provide a single version of the truth ­ Empower users to find out new information about their business for themselves ­ Provide an integrated database model with common definitions regardless of the source of the data. Data from various source systems is fed into the EDW (Enterprise Data Warehouse).

Responsibilities:

• Actively involved in enhancing the Data Warehousing Application wherein all small, Teradata,
• Prepared high level design document for developers and participated in review / build of the BTEQ, Scripts, Fast loads, Multi load and JCLs, Prepared/Reviewed Unit Test Plans & System Test cases
• Worked closely with Business Users and analysts.
• Worked on BTEQ, Fast load, and Fast export for loading data from Oracle to Teradata.
• Responsible for overseeing the Quality procedures related to the project
• Involved in code reviews and strictly followed best practices.
• Design, develop, and test complex Teradata BTEQ Scripts
• Involved in complete software development life­cycle(SDLC) Performed unit testing on the source code.
• Used to interact with testing team to ensure appropriate testing is performed and with Configuration team for code deployments and with technical writers to ensure manuals are in Synch with the developed software Environment: Teradata, Main Frame, BTEQ, Fast Load, Fast Export.