Megha Tejeshwar Potabhare

• Company Overview: Cognizant is an American multinational corporation that provides IT services, including digital, technology, consulting, and operations services. It is headquartered in Teaneck, New Jersey, United States.
• MGM international resort (September 2023 to till date)
• Client : MGM international resort, Las vegas
• Role : Production support for Teradata, HYPERSCALE, SYNAPSE, Azure administration.
• Domain : Hospitality
• Skill Set : Teradata view point, Informatica power center, Sql server, Azure portal
• Team size : 12
• Description : MGM Resorts International is an American global hospitality and entertainment company operating destination resorts in Las Vegas, Massachusetts, Michigan, Mississippi, Maryland, Ohio, and New Jersey, including Bellagio, Mandalay Bay, MGM Grand, and Park MGM.
• Contribution: Team lead to manage and function on Teradata SQL, MLOAD, FLOAD, TPT, BTEQ, Fast EXPORT, PMON, Teradata Manager, Viewpoint, TSET. Teradata Administrator, Control-M. Creating incidents and coordinating with Teradata GSC during system availability P1/P2 issues like AMP down, node failures, DBS hung and other hardware related failures. Actively participating on Hyperscale to synapse EDH migration.
• Project Profile:
• Volvo Cars DMA Base (October 2021 to September 2023)
• Client: Volvo, Sweden
• Role: Team Leader, Production Support (L1 & L1.5), Code Deployment, Release Management, Incident Management, Teradata DBA.
• Domain: Automobile Manufacturing
• Skill Set: Teradata, Informatica PowerCenter, PowerBi, Service Now
• Team Size: 16
• Description: Volvo Cars, stylized as VOLVO, is a luxury vehicles brand. It is headquartered in Gothenburg, Sweden. Volvo was founded upon the concept of safety, has long been marketed and stressed their historic reputation for solidity and reliability.
• Contribution: The role of Production support is to act as the resolver and key contributor to solve the difficult technical cases. Act as technical expert to Provide internal support personnel with technical information. Report/communicate developments and trends regarding support requests. Support root cause analysis of failures. Monitor and effectively manage production situations.

Project Profile:

Ø Payless Shoe Source (October 2021 to September 2023)

Project : Production Databases Maintenance.

Client : Payless Shoe Source

Role : Production DBA.

Environment : Teradata 15.10

Ø About 1st Project:

It is 24*5 supports and 2 DBA teams responsible for Teradata DBA support work . The database contains 2690 systems with a total of 150 TB of data. Project includes management of DB objects, system monitoring, backups and restoration activities.

Ø Responsibilities:

· Part of core Production DBA maintaining critical production databases .

· Worked as team lead for Teradata tower.

· Administering the physical aspects of the databases such as creation of Tablespaces , Users, Rollback segments.

· Created customized Procedures for User creation, cloning & Grants (Direct, Role) for the huge amount of User management request.

· Monitoring of Sessions, Nodes, and Vprocs Information.

· Monitoring/ Aborting sessions through Teradata Manager/Viewpoint

· Participate in establishing and evolving database standards within the company

· Providing 24X7 support for production databases and working experience on on-call .

· Provided maximum effort and avilablity to overcome from Outage disaster and work as a KEY resource in Teradata outage .

• Company Overview: Teradata Corporation is an American computer company that sells analytic data platforms, applications and related services. Its products are meant to consolidate data from different sources and make the data available for analysis. Teradata is an enterprise software company that develops and sells a relational database management system (RDBMS) with the same name.
• It was a Database production support project for ABI(Anheuser-Busch Inbev BUDWEISER). It is 24
• 5 supports and 4+1 DBA team responsible for Teradata DBA and ETL Support Tasks. The database contains 4 V14.10 systems with a total of 100 TB of data. Project includes management of DB objects, system monitoring, backups and restoration activities.
• Project Profile:
• Project: Production Databases Maintenance and ETL Support.
• Client: ABI (Anheuser - Busch Inbev)
• Role: Production DBA.
• Environment: Teradata 14.10
• Responsibilities:
• Worked as a Production DBA for a very large system.
• Regular interaction with client (ABI) on technical and functional road-blockers and their possible solutions
• Pre and Post Activities performed during Teradata 13.10 to Teradata 14.10 Upgrade.
• Tested all Teradata 14.10 Features and provide results to Client (Related to a separate project for same client).
• Checktable and Scandisk feature used during upgrade.
• Optimizing Suspect Queries, Long Running and High Resource Consuming Load Jobs.
• Teradata Multi Valued Compression (MVC) to save space and I/O.
• Generated CPU, I/O and AWT Utilization Reports for week on week comparison.
• Generated IRA, Monthly SLA and Resource Utilization Reports.
• Handling Administration such as Monitoring CPU Utilization, DB Space of Systems via Viewpoint.
• Monitored Sessions and Reporting High Resource Consuming and Skewed Sessions.
• Troubleshoot DATA STAGE job Error from Director & Designer
• Worked on HPSC Ticketing tool.
• GSC/TDCS Co-ordination in P1/P2 cases.