Pankil Sutaria

Experience

• 

  Accenture

  Jul 2012 - Oct 2015

  Software Engineering Analyst

  Worked as datastage developer at Accenture for Royal Mail Group .Royal Mail is the UKs designated Universal Postal Service Provider supporting customers,Businesses and Communities across the country. The company provides mail collection and Delivery services throughout the UK.Role Description:• Involved in the data analysis for source and target systems.• Designed and developed ETL jobs using DataStage to extract data from flat files and to load the data into the target database.• Extensively used various stages like Join, Lookup, Remove duplicates, Filter, Funnel, sort, Copy, Transformer,Aggregator stage.• Used slowly changing dimension Type 2 approach to maintain history in database.• Using Peek stage for debugging Datastage jobs.• Scheduled datastage jobs using crontab.• Good understanding of existing system , involved in impact analysis• Created, updated and maintained ETL technical documentation.• Implemented BPM Workflow changes.• Manipulated data using DB2 SQL.• Involved in Peer reviews and Creating Implementation Plan.• Involved in moving code from DEV to UAT and UAT to PROD.• Coordinating with the offshore , onshore team and business users.• Created Test plans and performed Unit Testing , Integration Testing and Regression testing.• Supported production system by monitoring DataStage jobs and taking appropriate action whenever job fails.• Performed POC (Proof of concept) for RDM (reference data management) tool.• Demonstration of RDM Application to business users and onshore team. Show less

• 

  Teradata

  Nov 2015 - May 2021

  Technical Consultant

  Working as datastage/Teradata developer at Teradata for one of the largest Airlines.Role Description:• Worked on development, Testing and deployment of several tasks/requirements with team as well as independently. • End to end delivery of the project using Agile methodology.• Understanding the requirement and creating Datastage jobs as per the requirement.• Using Teradata SQL to transform data to Insert/Update in target Tables.• Creating ETL Control Table entries and Tivoli components to schedule Datastage jobs.• Checking-in all the components to Sub-Version (SVN).• Testing and creating data validation sheet in DEV/TEST/PRE-PROD/PROD Sandbox.• Creating ETL Implementation checklist and JIRA to deploy code in TEST/PRE-PROD/PROD Environment.• Creating BTEQ scripts for History Load /Restatement.• Deploying Datastage code and BTEQ Scripts in TEST Environment.• Coordinating with Configuration Manager to deploy code in PRE-PROD environment.• Working on the PROD issue and analyzing the resolution if any failure occurs.• Validating data once the code is in PROD Environment.• Creating tasks in Rally as per the User Stories of the particular Iteration.• Participating in daily stand up call with client and onshore coordinator to understand the requirement.• Involved in delivering training session on project related process/tools to new consultants.• Involved in Peer reviews. Show less

• 

  Accenture

  May 2021 - now

  Application Development Assoc Manager