Shashikant Patel Email & Phone Number | • Involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Data warehouse. • Designing & Coding ETL solutions using Informatica application. • ETL Documentation to describe the code changes • Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables. • Created workflows with the event wait task to specify when the workflow should load the tables. Loaded data from various sources (Flat files, Oracle, Teradata) using different Transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Expression, Sequence Generator, Union and Update Strategy to load the data into the target. • Developed UNIX Shell Scripts for scheduling Teradata BTEQ scripts. Redesigned some of the mappings in the system to meet new functionality and Extensively used Debugger Process to test Data. • Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings. • Re wrote the Teradata SQL scripts to improve performance. Responsible for Technical implementation of the change request solution. • Supporting enterprise data warehouse and ETL development activities.Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.• Involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Data warehouse. • Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings. • Designing & Coding ETL solutions using Informatica application. • ETL Documentation to describe the code changes • Validate the Data and Create BTEQ's and Teradata and Dynamic queries • Designing procedures, functions as per business requirement given by stakeholders. • Optimize and modifying the queries in Teradata for quicker data retrieval and timely reporting • Designing Test plans, test cases, validate test cases, Validate Change requests and modify Fleet EDW. • Co-ordinating with support team for deploying the code & ensuring successful production migration. Along with post production support. • Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files. • Created the BTEQ scripts to do Audit after completion of Runs. Prepared MLoad and FLoad script to load the flat files data into Teradata database. • Responsible for the Data Cleansing of Source Data using different operations of the Expression Transformation. Created Shell scripts to drop and Re create indexes to load data efficiently and decrease load time. • Participated in code reviews. Did code promotions from dev to test, staging and production environment using ODI. • Coordinate with testing teams for UAT, SIT. • Worked as Team lead to provide production support at warranty Period .• Handled the Billing Cycle activities. • Involved in error resolution during the Bill Cycle Activity. • Handled rating process and Rejection of the CDR. • Reporting file generation for PMS and CRM using PL/SQL and shell scripting. • Resolving L1, L2 and L3 issues raised by client. • Part of reconciliation of migrated data. • Code level changes and bug fixes. • Involved in implementation of payment, adjustment and deposit code. • Also I Was part of Sub Ledger Report (Accounting) module as a developer. • Developed SLR module using PL/SQL code and UNIX shell scripting. • Handled CR raised by the business user.

Shashikant Patel

• Involved in Requirement Analysis, ETL Design and Development for extracting from the source system...
West Chester, West Chester, United States

*50 free lookup(s) per month.

No credit card required.

Shashikant Patel’s Email shashikant_29@yahoo.co.in

Shashikant Patel’s Phone Numbers

Get SHASHIKANT’s Phone Number (For Free)

Social Media

Shashikant Patel’s Location West Chester, West Chester, United States

Shashikant Patel’s Current Industry Tata Consultancy Services

Shashikant Patel’s Prior Industry Reliance Communications

Not the Shashikant Patel you were looking for?

Find accurate emails & phone numbers for over 700M professionals.

Work Experience

Tata Consultancy Services

Teradata Consultant

2015-07-01 00:00:00 - Present

Reliance Communications

TSE

2008-06-01 00:00:00 - 2009-12-01 00:00:00

Skills

No Skills Available

Languages

No Languages Available

FAQ About Shashikant Patel

Shashikant Patel is located at
West Chester, West Chester, United States

Shashikant Patel is a • Involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Data warehouse. • Designing & Coding ETL solutions using Informatica application. • ETL Documentation to describe the code changes • Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables. • Created workflows with the event wait task to specify when the workflow should load the tables. Loaded data from various sources (Flat files, Oracle, Teradata) using different Transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Expression, Sequence Generator, Union and Update Strategy to load the data into the target. • Developed UNIX Shell Scripts for scheduling Teradata BTEQ scripts. Redesigned some of the mappings in the system to meet new functionality and Extensively used Debugger Process to test Data. • Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings. • Re wrote the Teradata SQL scripts to improve performance. Responsible for Technical implementation of the change request solution. • Supporting enterprise data warehouse and ETL development activities.Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.• Involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Data warehouse. • Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings. • Designing & Coding ETL solutions using Informatica application. • ETL Documentation to describe the code changes • Validate the Data and Create BTEQ's and Teradata and Dynamic queries • Designing procedures, functions as per business requirement given by stakeholders. • Optimize and modifying the queries in Teradata for quicker data retrieval and timely reporting • Designing Test plans, test cases, validate test cases, Validate Change requests and modify Fleet EDW. • Co-ordinating with support team for deploying the code & ensuring successful production migration. Along with post production support. • Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files. • Created the BTEQ scripts to do Audit after completion of Runs. Prepared MLoad and FLoad script to load the flat files data into Teradata database. • Responsible for the Data Cleansing of Source Data using different operations of the Expression Transformation. Created Shell scripts to drop and Re create indexes to load data efficiently and decrease load time. • Participated in code reviews. Did code promotions from dev to test, staging and production environment using ODI. • Coordinate with testing teams for UAT, SIT. • Worked as Team lead to provide production support at warranty Period .• Handled the Billing Cycle activities. • Involved in error resolution during the Bill Cycle Activity. • Handled rating process and Rejection of the CDR. • Reporting file generation for PMS and CRM using PL/SQL and shell scripting. • Resolving L1, L2 and L3 issues raised by client. • Part of reconciliation of migrated data. • Code level changes and bug fixes. • Involved in implementation of payment, adjustment and deposit code. • Also I Was part of Sub Ledger Report (Accounting) module as a developer. • Developed SLR module using PL/SQL code and UNIX shell scripting. • Handled CR raised by the business user.