Khadarvalli Patan

Senior Data Engineer offering 14+ years in data warehouse design and development, modeling, implementation and management. Highly skilled at programming and configuring databases to achieve business data needs. Quality-focused by quickly identifying and resolving issues.

Informatica Power Center 9.1 and 8.6.1, Informatica power exchanges, 

Teradata V2R6/V12/V13/V15, Teradata SQL Assistant, 

Teradata FSLDM, Control-M, Agile (Scrum, Sprints etc.)

• Having around 14+ years of IT experience as Business Systems Analyst/Data Analyst/Data Base Administrator including project planning and management, software analysis and design.
• Worked on complex information model, logical relationships, and the data structures that support to the Project
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation
• Excellent Experience in Data Model and Data Architect in Enhancing the FSLDM
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions
• Design & development views in Teradata system to extract data for analysis using filters based on the analysis.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation
• Good commanding of views, Synonyms, Indexes, Joins and Partitioning
• Have worked on all phases of data warehousing development lifecycle, from gathering requirements, analysis, design, development, testing, implementation, and support.
• Having excellent Experience in Data Warehousing Concepts and expertise skills in Teradata development using BTEQ, Fast export, Fast load, Multi load utilities and well known about Teradata Architecture.
• Have good experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Relational Database (Teradata) and Worked on integrating data from flat files, relational files into a common reporting and analytical Data Model.
• Having expert skills in Tivoli, Teradata, Hadoop, Informatica, Data Stage, UC4
• Team player both Onsite and off shore with excellent team management, communication, and analytical skills.

ANZ Enterprise Profitability Solutions, integrated Customer Profitability .

Technologies:  Teradata

Roles & Responsibilities:

• Have prepared detailed platform application design document based on the business requirements document.
• Identified the logical data model design and implementing physical data model.
• Built parent & child Relationship B/W the entities Using Erwin Based on the project requirement.
• Have prepared Test data for Unit testing and performed Unit testing.
• Have involved in Teradata DBA activities for the project- Environment Build, Performance Tuning
• Have supported QA team in system testing / UAT testing.
• Have involved in peer reviews of the code
• Coordinated with the team and delivered deliverables on time.

Comcast cable Fusion module.

Technologies:  Teradata, informatica 10.1, Unix, Hadoop, SQL server, Oracle

Roles & Responsibilities:

• Worked in Agile team (scrum framework) and responsible for the creation and delivery of 9 outbounds as per user stories
• Have prepared detailed platform application design document based on the business requirements document.
• Identified the logical data model design and implementing physical data model.
• Built parent & child Relationship B/W the entities Using Erwin Based on the project requirement.
• Have prepared Test data for Unit testing and performed Unit testing.
• Have involved in Teradata DBA activities for the project- Environment Build, Performance Tuning
• Have supported QA team in system testing / UAT testing.
• Have involved in peer reviews of the code
• Coordinated with the team and delivered deliverables on time.

Johnson & Johnson AGP-fidelity team

Technologies:  Teradata, informatica 10.1, Unix, SAP

Roles & Responsibilities

• Have prepared detailed platform application design document based on the business requirements document.
• Identified the logical data model design and implementing physical data model.
• Defined Source and Target definition for various files /tables such as Files
• Built parent & child Relationship B/W the entities Using Erwin Based on the project requirement.
• Have prepared Test data for Unit testing and performed Unit testing.
• Have involved in Teradata DBA activities for the project- Environment Build, Performance Tuning
• Have supported QA team in system testing / UAT testing.
• Have involved in peer reviews of the code
• Coordinated with the team and delivered deliverables on time.
• Have supported during project implementation and warranty activities.
• Have involved in solving user requests

AIA Thailand (Anti Money Laddering)

Technologies:  Informatica, Oracle, DB2, Sqlserver, Sybase and Linux.

Roles & Responsibilities:

• Played onshore architect role for The client AIA Thailand
• Worked in Agile team (scrum framework) and responsible for the creation and delivery of 9 outbounds as per user stories
• Have prepared detailed platform application design document based on the business requirements document.
• Identified the logical data model design and implementing physical data model.
• Defined Source and Target definition for various files /tables such as Files
• Built parent & child Relationship B/W the entities Using Erwin Based on the project requirement.
• Have prepared Test data for Unit testing and performed Unit testing.
• Have involved in Teradata DBA activities for the project- Environment Build, Performance Tuning
• Have supported QA team in system testing / UAT testing.
• Have involved in peer reviews of the code
• Coordinated with the team and delivered deliverables on time.

Mass Mutual Insurance Info delivery

Technologies:  Teradata, informatica, UNIX

Roles & Responsibilities:

• Have prepared detailed platform application design document based on the business requirements document.
• Identified the logical data model design and implementing physical data model.
• Defined Source and Target definition for various files /tables such as Files
• Built parent & child Relationship B/W the entities Using Erwin Based on the project requirement.
• Have prepared Test data for Unit testing and performed Unit testing.
• Have involved in Teradata DBA activities for the project- Environment Build, Performance Tuning
• Have supported QA team in system testing / UAT testing.
• Have involved in peer reviews of the code
• Coordinated with the team and delivered deliverables on time.
• Have supported during project implementation and warranty activities.
• Have involved in solving user requests

Lloyds Bank, UK

Technologies:  Teradata ,Datastage,Mainframe ,Unix

Roles & Responsibilities:

• Have prepared detailed platform application design document based on the business requirements document.
• Identified the logical data model design and implementing physical data model.
• Defined Source and Target definition for various files /tables such as Files
• Built parent & child Relationship B/W the entities Using Erwin Based on the project requirement.
• Have prepared Test data for Unit testing and performed Unit testing.
• Have involved in Teradata DBA activities for the project- Environment Build, Performance Tuning
• Have supported QA team in system testing / UAT testing.
• Have involved in peer reviews of the code
• Coordinated with the team and delivered deliverables on time.
• Have supported during project implementation and warranty activities.
• Have involved in solving user requests.

• Involved in object creation and management, granting access privileges etc.
• Migration of code/objects across environments using Teradata Administrator utility and batch scripts.
• Involved in System level performance tuning that Involves tuning complex Source qualifier, by thorough analysis of explain plan and gathering performance parameters like CPUtime/AMPtime/IOtime by enabling Teradata features (DBQlogtbl) and showcasing the comparison report of actual vs. tuned queries.
• Proactive system health check and reporting through Teradata Viewpoint utility.
• Implemented best practices on areas like performance tuning, DB security etc.
• Worked on PDCR tool to extract reports on database performance.
• Involved in database space estimation and management

• Received "Star Performer" award.
• Published in Lloyds news letter with regards mortgage integration project

• Teradata Certified