MADHAVA MARNENI

• Worked on successfully implementing Teradata database refresh projects including Discovers front end application servers.
• Currently Supporting 3 appliance Teradata Severs (680, 1800, 2-2800), 5 - Intelliflux 2.1 servers and 1 Enterprise Data warehouse server (6800).
• Working with Teradata database migration project to migrate data to Snowflake (AWS as storage).
• Mentoring and Manages database team (Offshore).
• Working as a financial budget planning to estimate Cloud database credits and usage and project the credit usage for the remaining planning period.
• Worked with various vendors on weekly basis and get the latest product updates from the vendor and prepare the test cases that suits the business requirements.
• Developed home grown application called Snow owl that will estimate an accurate charge back of cloud database credits to various Discovers organizations.
• Provides reviews and set goals to the team for the upcoming planning period.
• Working as Cloud Database (Snowflake) administrator and provide database support to the three snowflake database accounts (Dev, Prod and Stage).
• Working with various internal data operation teams and provided them design solutions and best dba practices that meets the expected performance gain on the data ops process.
• Involving on various Teradata system upgrades and resolving the issues that occurred during the upgrades.
• Involved in system outage issues to identify the root cause for these issues and provided support in timely manner.
• Worked with front end application teams and provided the support to resolve all performance issues facing by the fraud investigators.
• Worked with internal audit groups and security and compliance audit team and resolved all the audit findings in each time.
• Worked with Protegrity tool to enable Database encryption and Tokenization tool on Discover Teradata and Snowflake environments.
• Worked with security teams and provided design docs to the team to resolve all performance issues identified on Business and Technology groups.
• Provided various query tuning metrics to the business users where they used this metrics to resolve the performance issues identified on their queries.
• Successfully completed On Prem – Cloud database migration project and providing cloud database support to various teams internally.
• Onboarded 3000+ users to Snowflake database and provided support and query tuning documents that helping them to run their queries efficiently.
• Extensively implementing all Discover’s Management system techniques and completing all assigned project on time during the planned sprint.
• Wrote Python scripts to automate the DDL implementation process using Python code and Jenkins Pipeline process and integrating with internal service now tickets which will kickoff the DDL install automatically with out manual intervention.
• Wrote various process improvement documents that helped users and business teams.
• Working with Non-working teams and provided support to them to resolve the issues they identified during the migration projects.
• Working with various contracting vendors and providing DBA assistance to them that help them to finish their process in time.
• Working with internal security teams and provided them with proper stored procedures they can use to resolve user issues.
• Wrote many stored procedures, functions internally that helped various projects to capture performance related metrics.
• Followed the change management process to fix production related issues.
• Resolved various incidents raised by Global Discover technical users about the database connectivity issues.
• Provided various database usage reports to the higher management teams that helped them to manage the database resources efficiently.
• Worked with Onsite-Offshore support by providing Knowledge transfer, communicate timelines, progress, status reports, delays etc.
• Providing various trainings to the Discover database users internally on monthly basis so they can use both on-prem and cloud databases system effectively.
• Environment: Teradata versions 17.05/16.10/15.10, Teradata Administrator, Snowflake, Snowsql, S3, AWS EC2, Neo4j, Jenkins, Python, Java script, Teradata SQL Assistant, Teradata Manager/Viewpoint, BTEQ, TASM, Columnar, Protegrity, Query Grid Version 2.0, DSA, NetBackup, Unix, MLOAD, TPT, PMON, TSET, ODBC, Teradata .Net Provider, TTU Utilities 15.10 version.

• Completed multiple system upgrade projects, including Teradata servers, and documented architecture design.
• Provided Teradata DBA support for Informatica ETL developers and system users.
• Integrated Teradata with downstream BI groups to facilitate data flow.
• Installed and configured Protegrity server on 6650 servers, managing roles and encryption policies.
• Conducted performance assessments using TASM rule sets and TPERF/COD, reporting monthly to management.
• Created databases, tables, views, and assigned user access as needed.
• Collaborated with development teams on design, implementation, and performance tuning of applications.

Clients:

1) State of Illinois HealthCare and Family Services, Springfield, IL.

2) Abbott Laboratories, Abbott Park, Waukegan, IL

3) Wells Fargo, Minneapolis, MN

• Involved in Analysis, Study and Design of the Application.
• Created stored procedures in SQL Server.
• Involved in a reporting system like SSRS (SQL server Reporting Services), SSIS (SQL Server Integration services) and SSAS (SQL Server analysis services).
• Created windows services in .net.
• Created Deployment Setup package file for windows service.
• Used Data Access Application block extensively for data retrieving, querying, storage, manipulation and for achieving disconnected database connectivity.
• Environment: Sql Server 2005, SSRS, SSAS, SSIS, Shell scripts, PL SQL, MS Access.