Technical, Teradata Lead Resume

SUMMARY

Twenty years of experience in database administration and development including database design and physical data modeling. Eight years financial industry experience working for Fidelity Investments and ING providing Data Warehouse design, development and support in Linux, UNIX and Windows environments.
Total 4 years of experience as a Teradata DBA/Developer with extensive experience working with most Teradata utilities, monitoring system performance, physical data modeling, and performance tuning.
Extensive experience in Teradata, DB2 UDB, MSSQL Server.
Teradata SQL Assistant, Teradata Studio, Teradata Administrator, BTEQ, ERWIN, Quest and Visio.
Teradata Utilities: FastLoad, MultiLoad, FastExport, TPT.
ETL Tools: Informatica and Ab Initio.
BI Tools: Qlik and Business Objects.
Experience includes Linux, Windows and MVS operating systems.
Provided 7/24 on call production support for mission critical databases.
Expertise with database architecture including data warehouse, operational and transactional designs.
Strong database modeling skills using tools like Erwin and able to work closely with the application teams to resolve high impact technical issues.
Experience in working with teams distributed across different, remote locations. Pro - active, self-motivated and able to work independently as well as in team.
Strong problem solving, analytical, interpersonal skills, written and oral communication skills.
Excellent Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
Versed in using project and change management tools such Service Now - used to manage and coordinate change, incident and requests assigned to the team; huddle boards and other CI (Continuous Improvement) tools for project management.

PROFESSIONAL EXPERIENCE

Technical, Teradata Lead

Confidential

Responsibilities:

Provide support to CCW (Cigna Corporate Warehouse) for critical production outages and issues and drive root cause analysis and resolution.
Monitor, analyze, troubleshoot, rectify and resolve production issues related to Teradata and ETL jobs like: Informatica, Python scripts and Teradata utilities (BTEQ, TPT, MLOAD).
Handle L2 level database operations support activities and database administration activities including data movement between systems, database user management, database space management, database object management (e.g. table creation, table rebuild etc.), database privileges management, database performance monitoring (using Viewpoint, Visual Explain), release session locks.
Handle tickets and incidents escalated by customers, technical support and development teams.
Ensuring complete adherence to SLAs for all operations of workflows, sessions and jobs running in Production 24/7.
Support deployment methodologies, code and data movement between Dev, QA and Prod Environments.
Work with development team to create standard operating procedure for production environment.
Proactively analyzing workflows/sessions/jobs, identifying and implementing performance improvement opportunities.
Develop and produce daily and weekly operations reports and metrics as required by IT management.
Create and maintain known-error-database documentation for operational issues and business incident tickets.
Communicate the status of all production problems, upcoming maintenance and release items to business partners, stakeholders and upper management.
Offshore team co-ordination, onboarding, training and client communication.

Technology,Teradata Lead

Confidential

Responsibilities:

Development of Teradata and Informatica components.
Create and run Teradata Utilities: FastLoat, MultiLoad, FastExport, TPT.
Tuning and performance of complex queries.
Assessment of the JPMC ICDW (Integrated Consumer Data Warehouse) to identify ETL processes and SAS queries for remediation (from perspective of: CPU, I/O, AMP worker tasks, concurrency, extracts and daily workload).
Analysis of targeted queries for trends analysis and improving query performance.
Technical writing for project presentation to JPMC executives.
Review LDM with the business users to get their approval. Profile the data and provide sample for this review.
Analyzed and performed data modeling for Access Layer that reflects the rules and requirements of the LDM.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship