Dilip Morsu Email: adve9y@r.postjobfree.com

Teradata Database Administration/ Data Modeling Ph: +1-516-***-****

Professional Summary:

9+ Years of IT experience in Teradata Data Warehousing Administration including Data Modeling, Tableau Administration and ETL Development & Support.

Have clear understanding of Data warehousing concepts with emphasis on ETL and life cycle development including requirement analysis, design, development and implementation.

Extensive experience in managing Petabytes of Teradata systems, creating database users/profiles/macros/views/indexes etc.,

Proficient in using viewpoint and various other database utilities like Checktable, Scandisk, DBSControl, Ferret, Filer, Qrysessn, Lockdisp, Showlocks, DBQL etc.

Managing space activities, following with perm space movements, identifying skewness to reduce space usage. Assigning spool & temp space to profiles and tracking movements.

End-to-end monitoring using Viewpoint and creating/monitoring all alerts for all supported Teradata application.

Experience in optimization where major activities include identifying AMP worker task depletion, looking for delayed system response times, identifying high consuming queries or users, run away queries etc. Identifying unnecessary collect stats running on the system to save system resources. Many administration and prioritization tools such as Viewpoint, TASM, ResUsage.

Compression- Analyzed and implemented MVC compression strategies on large tables to reduce space consumption.

Teradata SQL Query Tuning - With the in-depth expertise in Teradata internals, identified/resolved potential issues with queries from the aspects of query re-writing, skewed redistributions, access method selection, join order/costing problems, optimizer statistics usage, cardinality estimations, physical design considerations (PI/USI/NUSI/JI/HI) etc. Educated users on optimizer internals and better usage of tools such as TSET, Visual Explain etc. that help in understanding the query plans, plan differences.

Teradata Load/Export Utility usage- Experience of working on utilities like TPT’s, Fast load, Multiload, Export for loading/unloading data to perform ETL.

Worked on analyzing ETL jobs from Teradata perspective to improve the ETL performance and on SAS environment to understand their requirement and change the code to get the best performance from Teradata.

Experience in creating data mover jobs between the systems. Experience in UNITY data mover jobs support, evaluation.

Experience in Backup and Restore (BAR) methodologies. Design implements and co-ordinate all back-up and restore strategies using Arc utility - Taragui & Netback up. Familiar on DSA backup. Created container on Azure platforms with DSA backup utilities.

Responsible for few critical applications and their performance, best practices implementation. Supporting all issues related to system.

Change/Release Management- SQL code review for DDL standardization, implementation and validation for assigned Applications.

On-Call Handling-Extensive experience of handling on-call supports to handle critical issues, which need immediate assistance. This requires working closely with Vendors and various internal teams.

Strong experience with star and snow flake schema, dimensional Data Modelling, facts, dimensional and slowly changing dimensions.

Expertise in OLTP/OLAP System Study, E-R modeling, developing Database Schemas (Star schema and Snowflake schema) used in relational and dimensional modeling.

Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.

Expertise in RDBMS, database Normalization and Denormalization concepts and principles.

Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

Developed shell scripts for workflows and for running batch process.

Extensive experience in designing the architecture for extract, transformation, load environment and development of mapping.

Experienced in Performance Tuning at Mapping, Session and database level, tuning mappings, Pipeline Partitioning to speed up data processing.

Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries in Teradata.

Experienced in using different scheduling tools - Control-M, Auto Sys, Cron Job.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Excellent analytical skills in understanding client’s organizational structure.

Excellent problem-solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

Experience in Configure and maintain Tableau Server Software Layer within Windows Servers.

Participating in capacity planning and performance testing on Tableau desktop to ensure environments are adequately sized and configured to meet current and projected demand.

Experience as Tableau admin, developing in, configuring and administering Tableau Server.

Working as System Administration (includes site creation, server maintenance/Upgrades/patches).

Change management (Remedy, Jira & Service Now) with complete ITL process including software, hardware upgrades, patches.

Monitor server activity/usage statistics to identify possible performance issues/enhancements.

Expertise in Switch over failures (PROD & DR), system backup to tapes, backup schedules within environment.

Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections through Tableau Desktop.

Provide appropriate training and support to business users on the use of Tableau interactive web reports, and Tableau Desktop.

Develop and document standards/best practices for development and administration of the Tableau platform.

Work closely with technical architects, data and software engineers to ensure optimal application and data database/warehouse design to support reporting requirements.

Experience in Tableau scripting (TABCMD and TABADMIN).

Experience in working on different versions of Tableau - 8.3, 10.4, 2018.1.

Education:

Post Graduate Diploma in IT from Whitireia University (New Zealand) in 2009

Bachelor of Technology from JNT University (Hyderabad) in 2007

Employment History:

Atos India - (Aug 2021 - Feb 2023)

Teradata India Pvt Ltd - (Aug 2015 - May 2021)

Bank Of America - (Jan 2014 – Aug 2015)

Certifications:

SCRUM Master

GCP – Data Engineer Certified

Teradata Vantage 16.20 DBA.

ITIL Foundation V3

Teradata 14 SQL

Teradata 14 Professional

Technical Skills: -

Database

Teradata 13,14,15,16, Vantage 1.0, 2.0

ETL Tools

ELTFRAMEWORK (Teradata), Informatica PowerCenter, DataStage

Data Modeling Tools

Erwin 4.1, TOAD, Star and Snow Fake Schema.

Scheduling Tools

Auto Sys, Cron Tab, Control – M, Informatica Scheduler

Languages

SQL, C, C++

Scripting Languages

UNIX Shell Scripting, Korn Shell, Bash shell scripting

Operating Systems

Windows, Linux, Unix

Professional Experience: -

HCA Healthcare –Nashville, TN Aug 2021-Feb 2023

Sr. Consultant- Teradata DBA/Data Modeler/Data Analyst

Responsibilities:

Responsible for Business Analysis and Requirements gathering.

Supporting Tier 1 Data Warehouse for Data Analysis.

Involved in Dimensional modeling (snowflake Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Carried out changes into Architecture and Design in Teradata for OLAP systems

Involving in SQL code approvals, performance optimization, code rewrites in development and testing.

Code deployments in Lower environments & Production too.

All kind of DBA activities such as Monitoring, User Management, Access Management, Space Management.

Working on System DBA activities such as involving in upgrade activities.

Performed tuning of SQL queries and Stored Procedures for speedy extraction of data, to resolve and troubleshoot issues in OLTP environment.

Troubleshooting of long running sessions, spool out, Skew issues and fixing them.

Worked on Backup & Restore activities by using DSA/Netbackup.

Knowledge on Informatica PowerCenter tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor & Datastage designer.

Proved accuracy in doing sanity checks, smoke tests after the install of new scripts used by ETL.

Prepared Data Mapping documents, process documents, Re-start ability Matrix to help on-call team reduce the turnaround time when there is an issue.

Provided Training to the team with the functional and technical knowledge.

Shaw Communications (Freedom Mobile)- Toronto, CA Feb 2020-May 2021

Sr. Specialist Database Administrator/Teradata DBA

Responsibilities:

Maintaining Operational document for all changes according client requirements.

Leading 3 projects together and assigning respected tasks to the team.

Proposing best practices in all environments and implemented many access & User managements.

Performance optimization on high CPU, highly skewed views and queries.

Worked on Data Modelling activities with respect to new PI proposals.

Physical implementation using TOAD tool.

Involving in all system DBA activities such as maintenance and upgrade activities.

Worked on performance reports, involved in Review meetings.

Siemens Healthineers - Erlangen, Germany Feb 2020-May 2021

Sr. Specialist Database Administrator/Performance DBA

Responsibilities:

Involved in planning, building, and managing successful large-scale Data Warehouse and decision support systems.

Creating conceptual and access diagrams and setting up entitlement and business roles across lower and upper regions.

Setting up data marts and deploying database objects.

Involved as infrastructure as a Service and Do It Yourself with Teradata on AZURE cloud.

Backup & Restore jobs set up with containers & DSA in Azure cloud.

Involved in IP switch overs when there were upgrades on Teradata.

Performance optimization on many queries and SAS workflows to Teradata. Recommended structural changes.

Worked on DBA activities such as User Management, Access Management, Viewpoint Monitoring

Ziply Fiber - Kirkland, WA Feb 2020 – May 2021

Sr. Specialist Database Administrator/Operations DBA

Responsibilities:

Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Responsible to write complex SQL queries to check the validity of DATA.

Scheduling Backup jobs and monitoring.

Working on Weekly/Monthly Performance reports and delivering them to client.

Working on Roadmap activities and showcased thousands of dollars to client.

Creating tables, views, UPI, NUPI, USI and NUSI.

Managing spool, temporary, permanent space.

Applying compression and resolving data skewness at table and database levels.

BMW–Munich, Germany Aug 2015-Feb 2020

ETL Development/Tableau Admin/Teradata DBA

Responsibilities:

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

working on utilities like TPT’s, Fast load, Multiload, Export for loading/unloading data to perform ETL operations. Performing initial loading and full loading.

Develop and maintain data models and data maps for data warehouse system and operational data store.

Used Change Data Capture (CDC) to simplify ETL process when working in data warehouse applications.

Creating Mapping documents and updating them accordingly. Updating Operational documents after deployments of the scripts. Interacting with client to get updated Project Charter and RACI Matrix.

Wrote complex SQL Query as per business requirement to fetch the data from relational tables.

Optimized complex SQL query to improve performance.

Improving Data-Driven Decisions with Data Cleansing. Performing Data Cleaning from Staging area and transforming good data to Core & Access Layer. Identify duplicate or irrelevant values and remove them.

Creating materialized Views for easy data access and optimizing views according to business standards. Worked on Row level security by joining them with secure views using Security Layer. Maintained a unique secure layer to prevent data vision for end users.

Worked on analyzing ETL jobs from Teradata perspective to improve the ETL performance. Creating Identity columns to maintain uniqueness with in the objects in Core Layers.

Trained on Informatica PowerCenter, mappings and mapplets to transform the data and Informatica designer.

Performed Unit testing, Integration testing/User Acceptance testing for ETL/SQL/Unix script codes.

Developed UNIX shell scripts to run the workflows and SFTP source/target files from various systems and Informatica process automation

Worked on Partitioning objects for better performance and balanced load.

Worked as Tableau Administrator such as creating groups, users, projects, workbooks.

Working closely with Tab Admin commands for Tableau restarts, server switch overs when there are upgrades.

Following ITIL process for any change deployments.

Participating in capacity planning and performance testing on Tableau desktop to ensure environments are adequately sized and configured to meet current and projected demand.

Monitor server activity/usage statistics to identify possible performance issues/enhancements.

Provide appropriate training and support to business users on the use of Tableau interactive web reports, and Tableau Desktop.

Investigating Data quality issues/Data miss match issues.

Marsh & McLennan– New York, NY Aug 2015-Nov 2017

Op’s & Performance DBA

Responsibilities:

Supporting multiple projects in Managed Service.

Tuning materialized Views and making suggestions to client.

Optimizing daily load bteq queries and implementing those changes in production.

Suggesting PI changes to the tables in Teradata which will avoid skewed impact on Database.

System DBA activities such as upgrades, PDCR installations, DBS control settings, Viewpoint alert set up.

Data Move activities by using Easy Loader.

Backup and Restore activities using Tara GUI & Netbackup.

Involving in Daily standup, Weekly Meetings and Monthly Performance meetings.

McDonalds –Chicago, IL Aug 2015-Sept 2016

Teradata Development

Responsibilities:

Working on Data Mover jobs by using ARC utility.

Creating scripts for data movement and monitoring jobs regularly.

Automation scripts and scheduling jobs.

Worked on Data Mover portlet for monitoring the jobs.

Applying compression and resolving data skewness at table and database levels.

Involved in Migration activity to Redshift.

Involving in SCRUM meetings, Scrum calls, Retrospective calls etc.,

Bank of America–Charlotte, NC Jan 2014-Aug 2015

Teradata Op’s & System DBA

Responsibilities:

Experience in using Teradata Administrator, BTEQ utilities.

Investigating space usage and monitoring the growth of the databases. Resolving Perm Space issues and spool issues by fine tuning.

Worked on MVC, PPI, Fallback Activities.

Actively Monitoring Sessions, Nodes, and Vprocs Information.

Good analytical, programming, problem solving and troubleshooting skills.

Involved in identifying the performance bottlenecks and optimizing respective databases and processes for performance improvement.

Strong hands-on experience using Teradata utilities (SQL, BTEQ, Fast Load, MultiLoad, Fast Export, Tpump).

User access management, space management, session management, Index management (Partition Primary Index, Join Index, Secondary Index, etc.)

Granting and revoking of Object Rights, Users and Roles including security issues.

System Maintenance – Involving in all kind of system maintenance activities.

Experience in Backup and Restore (BAR) methodologies. Coordinate all back-up and restore strategies using Arc utility – Tara GUI & Netback up.

Working on performance reports (PDCR Reports), Roadmap activities.

Managing and scheduling alerts through Viewpoint.

Contact this candidate