Anuja Nandurkar

• I have worked on DB2 to Teradata migration. wherein all DataStage jobs are migrated from DB2 to Teradata.
• Requirement analysis, Solution Design and Development.
• Participate in project planning and estimation, defining project milestones and deliverables.
• Troubleshooting Production, UAT and SIT Issues
• Collaborated with team to design architecture of the software solution, making strategic decisions to ensure scalability and maintainability

Environment : ETL IBM DataStage 11.7, Unix, DB2, SQL, Teradata,Airflow scheduling tool,Jenkins, Github,Pyspark,DataBricks.

• I have worked on HR data migration project wherein HR data transformation process changed from one bank to another bank
• Requirement analysis, Solution Design and Development
• Collaborate with stakeholders to define technical requirements and project scope
• Participate in project planning and estimation, defining project milestones and deliverables
• Provide guidance and leadership to a team of DataStage developers
• Creation of Test Cases, Unit Testing, SIT/UAT test support and SIT/UAT/PROD deployment/migration
• Troubleshooting Production, UAT and SIT Issues
• Design architecture of the software solution.
• Environment : ETL IBM DataStage 11.7, Unix, DB2, SQL, Azure Data factory, Azure Databricks, Azure Devops, Agile methodology, Bitbucket,
  Jenkins, Github, Control M.

• Requirement analysis, Solution Design and Development
• Troubleshooting Production, UAT and SIT Issues
• Technical support for Application and Tools upgrade
• Work with Client and BA to Understand Requirement
• Creation of Test Cases, Unit Testing, SIT/UAT test support and SIT/UAT/PROD deployment/migration.
• Environment : ETL DataStage 11.7, Unix, MS SQL Server, Oracle, Agile methodology.

• In CAD project, worked on complex Unstructured data, developed complex ETL jobs, worked on Quality stages to standardized address data, Name data and Phone numbers
• Worked on DataStage job performance tuning
• Worked on DataStage upgrade from version 11.3 to 11.7
• Work with Client and BA to Understand Requirement
• Troubleshooting Production, UAT and SIT Issues
• Creation of Test Cases, Unit Testing and SIT/UAT test support and SIT/UAT/PROD deployment/migration
• Help/Guide Junior team members for any Technical issues.
• Environment : DataStage 11.7 migration/Upgrade, ETL Datastage 11.7 Development, Unix, MS SQL Server ,Oracle, Control M,
  Agile methodology.

• TJX IDS designed to integrate data from different source system with different format and transferred integrated data to target system
• In IDS I have worked on complex mainframe flat files , unstructured data , hierarchical data ,designed complex ETL jobs and created SQL to flatten data
• I have worked on UPS Revenue Datamart project. Datamart used to captured all activity of transporting parcel to customers. Replaced complete old ledger system with new system.
• I have provided solution in Datastage to utilized same design/Job for multiple region data
• I have developed US/CA domestic complete module End to End which had challenged to handle huge volume of data so

developed complete module on dataset level

• Datastage Job performance tunning
• Migration from Informatica/ISI to Datastage/Qualitystage
• I have worked on Datastage Upgrade from Version 11.3 to 11.5
• Requirement analysis, Solution Design ,Development , Troubleshooting Production, UAT and SIT Issues and PROD deployment
• Environment : DataStage Migration/Upgrade, ETL Datastage Development, Qualitystage 11.3, Informatica 9.1, Unix, Oracle 11g

• Requirement analysis, Solution Design, Development
• Troubleshooting Production, UAT and SIT Issues and PROD deployment.
• Environment : ETL DataStage , Unix, Mainframe JCL, Oracle 10g

• Requirement analysis, Solution Design ,Development , Troubleshooting Production, UAT and SIT Issues and PROD deployment
• I have worked on Datastage upgrade from Datastage 7.5 to Datastage 8.5. Resolved issues faced during Datastage upgrade.
• Datastage job performance tunning Implemented Unix scripts for File extraction process and job scheduler
• I was part of project Audit team and helped team to make our project 100% HSBC process compliance
• Environment: ETL IBM Datastage 8.5/9.1/11.3, Unix, Control M, DB2 , Oracle,Cognos