SUMMARY:

• Having total work experience around 9 years, which involves working in core development projects using Teradata and ETL (DMExpress).
• Extensive understanding of Teradata architecture.
• Strong knowledge on indexes like UPI, NUPI, SI, NUSI, PPI .
• Extensive experience on Teradata SQL, BTEQ, MLOAD, Fast Load, Fast Export scripts.
• Strong Knowledge on SQL and DBMS concepts.
• Very good experience in Teradata client tools like SQL Assistant, Bteq.
• Extensively worked with Teradata which was the main database used as source and target in the projects involved
• Actively involved in the core development of Confidential project which involved conversion of 6000 mappings from Informatica to DMExpress.
• Writing Unix Shell Scripts as part of the project
• Having working Knowledge on Unix/Linux & SQL.
• Extensive knowledge on Relational Database Management Systems.
• Extensive domain knowledge on U.S HealthCare and Life Sciences.
• Giving knowledge transition within the organization.
• Involved in POC and a member of Teradata CoE.
• Share good insights on Teradata and DMExpress to team members.

TECHNICAL SKILLS:

ETL Tools: DMExpress 7.1, 7.9, 9.0

Languages: SQL, UNIX

RDBMS: Teradata, SQL Server 2008, 2012

Operating Systems: Windows 2000/NT/XP, UNIX.

Schedulers: ZEKE

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Environment: DMExpress, Teradata, Oracle, SQL Server

Developer/Support Engineer

Responsibilities:

• Gather the project requirements from client to develop ETL DMExpress jobs to load the data from source to target.
• Create the ETL flow and transformations to load the data into EDW as per design.
• Writing BTEQ’s and views based on user and reporting requirements.
• Monitor, analyze, troubleshoot, rectify and resolve BTEQ workflow/session failures and related issues.
• Extract data from source such as | de - limited flat files into UNIX as staging and loaded the data into Teradata DWH.
• Create tables with appropriate UPI and PI depending on the requirement.
• Involved in writing scripts for loading data to target data Warehouse for Bteq and MultiLoad.
• Involved in performance tuning by collect stats and join index creation in different scenarios according to the requirement.
• Unit testing and Data validation for the Data loads.
• Raised different change requests in service now to implement this project at different phases.
• Performed Unit, Integration and system testing and provided UAT support to the respective teams while implementation.
• Log, in detail, the root-cause, the troubleshooting-flow, the impact of an incident etc on BMC Remedy incident-management application.
• Ensuring complete adherence to SLAs for all operations of workflow/sessions/jobs.
• Created IP, Mainframe TWS scheduling plan and provided to the respective teams to automate the files generation process in mainframe.
• Develop clear and detailed technical & process. Develop and maintain known-error-database documentation for operational issues.
• Attend periodic meetings with client to understand adhoc change requests and designing efficient workflow for data load.
• Hands-on knowledge on Mainframe Zeke scheduler, to be able to monitor the jobs continuously.
• Involve in SIT/UAT, Live production run of the project.

Confidential

Environment: Dmxpress, Teradata

Developer/Support Engineer

Responsibilities:

• Gather the project requirements from client to develop ETL DMX jobs to load the data from source to target.
• Create the ETL flow and transformations to load the data into EDW as per design.
• Understanding Requirements Specifications of the project.
• Extracted data from source such as | de-limited flat files into UNIX as staging and loaded the data into Teradata DWH.
• Created tables with appropriate UPI and PI depending on the requirement.
• Involved in writing scripts for loading data to target data Warehouse for Bteq and MultiLoad.
• Involved in performance tuning by collect stats and join index creation in different scenarios according to the requirement.
• Unit testing and Data validation for the Data loads.
• Raised different change requests in service now to implement this project at different phases.
• Performed Unit, Integration and system testing and provided UAT support to the respective teams while implementation.
• Involved in preparing TWS, IP and support documents for the project at different phases.

Confidential

Environment: Dmxpress, Teradata, SQL Server, UNIX (AIX)

Developer/Support Engineer

Responsibilities:

• Understand the requirement of the assigned project. If required, communicate with the Project Manager for clarifications.
• Create Taradata BTQE Scripts for the assigned project.
• Develop DMExpress jobs for ETL processing.
• Writing BTEQ’s and views based on user and reporting requirements.
• Monitor, analyze, troubleshoot, rectify and resolve BTEQ workflow/session failures and related issues.
• Extracted data from source such as | de-limited flat files into UNIX as staging and loaded the data into Teradata DWH.
• Created tables with appropriate UPI and PI depending on the requirement.
• Involved in writing scripts for loading data to target data Warehouse for Bteq and MultiLoad.
• Involved in performance tuning by collect stats and join index creation in different scenarios according to the requirement.
• Unit testing and Data validation for the Data loads.
• Raised different change requests in service now to implement this project at different phases.
• Performed Unit, Integration and system testing and provided UAT support to the respective teams while implementation.
• Log, in detail, the root-cause, the troubleshooting-flow, the impact of an incident etc on BMC Remedy incident-management application.
• Ensuring complete adherence to SLAs for all operations of workflow/sessions/jobs.
• Created IP, Mainframe TWS scheduling plan and provided to the respective teams to automate the files generation process in mainframe.
• Develop clear and detailed technical & process. Develop and maintain known-error-database documentation for operational issues.
• Document every step followed during development phase so that the same can be replicated in the production phase. Documents are important for future implementations.
• Involve in SIT/UAT, Live production run of the project.

Confidential

Environment: Informatica 8.6, Dmxpress, Teradata, SQL Server, UNIX (AIX), Flat Files

ETL Developer

Responsibilities:

• Involved in understanding the logic in the Informatica mapping and developing the equivalent job in DMExpress that agrees with the logic
• Extensive worked on Teradata SQL, BTEQ, MLOAD, Fast Load, Fast Export scripts
• Acquiring practical knowledge on various concepts of Data warehousing like Slowly Changing Dimensions, Facts, Dimensions etc.
• Converted hundreds of mappings, majority of which were complex, across different LOBs.
• Writing several shell scripts in UNIX to create a proper environment for DMExpress jobs to run
• Prepared the low level design documents for Informatica Mappings.
• Code review & debugging the mapping.
• Creating reusable transformations/jobs and using in other mapping.
• Optimizing/Tuning mappings for better performance and efficiency.
• Unit testing for validating the data to meet business requirements.
• Also, due to the stringent timelines, supported the Quality Assurance team in testing the code in QA environment and checking whether it met the standards and procedures.
• Monitored the jobs and made many last minute fixes and was actively involved in the project when it went live.
• Received the STRETCH (Syntel Value ) for being a part of the team that worked hard to ensure that the modules were delivered on time.