Anshul Shrivastava

Working as a Senior Delivery Manager for UK client.

• Worked with Product Engineering team for Product testing for Teradata DSA (Data Stream Architecture) stream used in migration of data. • Worked with client (Banque Misr) in Cairo Egypt for banking greenfield project for initial project setup and ETL/testing strategies. • Worked on migration project for UHG Optum (Persistent) from DB2 to Teradata as Technical Project Manager in offshore/onsite model. • Worked as a Data Architect and team leader for Retail account. • Developed and shared history data migration Tools with client.

• Working as a Project Lead/Team leader for Retail account. • Working on migration from OnPrem to Azure cloud and managing team of 20+ members • Analysis, design, development, and automation of current and future processes/systems. • Working on project management activities like cost estimation, shift & resource management, leave management, team meetings, GAP analysis, KT management, maintaining project documents, resource grooming and monthly service review presentation to customer. • Reconciliation of user requirements to the new system capabilities. • Designed and developed Audit frameworks, ETL processes using ETL Tools.

• Worked as a Technical Lead for Retail, manufacturing, and Aviation and projects. • Gathering requirements from users, creating technical specifications for requirements, designing solution, and passing it to the team for development. • Involved in efforts estimation and providing timelines.

• Design and development of ETL end to end solution for various clients which includes Health care and Aviation domain. • Design/Development of Audit/Notification/Validation scripts. • Involved in business decisions to be implemented in project. • Responsible for overall Development of ETL in different projects. • Ensuring that agreed-upon project tasks and assignments are completed on time. • Implementation of Teradata best practices and use of Teradata proprietary tools to enhance the productivity of the clients DWH applications. • Working with users, teams, and PS consultants to ensure the project meets business needs. • Analysis and discussion with team for the current and future processes/systems. • Provide functional and technical expertise in an administrative process. • Working with the Project Managers, architects to provide the best possible solutions for DWH applications. • Worked as a Module Lead for Healthcare and Banking projects. • Worked on Teradata stored procedures. • Responsible for Migration of code from Sybase to Teradata. • Responsible for Unit testing of code and fixing bugs.

I was working in IBM as an ETL solution Designer. My key skills are Teradata, DataStage,Tivoli,Unix,Oracle and Netezza. My responsibilities includes: • Provide functional expertise in an administrative process. • Working with other module teams for Deployment and Production readiness. • Data Migration, validations. • Ensuring that agreed-upon project tasks and assignments are completed on time. • Reconciliation of user requirements to the new system capabilities. • Prepare test cases and identify the possibilities of improvement. • Involved in migration of 23 Telecom circles (PAN India) from existing system to new System which involves migration of all the existing TD scripts to Data stage jobs and Oracle stored procedures. • Involved in 3G rollout (Design/Development/Testing/Implementation) for all circles for Telecom client. • Working closely with users and architects to ensure the project meets business needs. • Documentation and analysis of current and future processes/systems. • Identification and mapping of information needs. • Working with the Project Manager on definition of development requirements and priorities. • Ensuring that agreed-upon project tasks and assignments are completed on time. • Reconciliation of user requirements to the new system capabilities. • Identify and implement business process improvements and changes. • Designed and developed new processes for better performance. • Ensured and maintained the quality of codes and documents according to business standards.

Teradata Application devlopment(Multiload, Fastload,Fastexport,Bteq Scripts) , Data cleansing,Datastage job designing,Pl-Sql. Day to day data loading in warehouse using Teradata utilities. Handling Data loading related issue. Developing unix scripts for ETL purpose.

I was working as Teradata developer in Satyam computers services ltd. My resposibilities were: • Involved in the development of UNIX Shell scripts for data loading through Fast Export, Fast Load, Multi Load, BTEQ utilities and tracking down the error records • Writing Reconciliation Queries as per Business Requirements • Involved in Performance Tuning of Queries • Involved in Creating Programs for Missing Files using UNIX Shell Scripts • Involved as an ETL member to Transform and Load data to the warehouse. • ETL development using Teradata Utilities like Fastload, Multiload, FastExport, BTEQ and UNIX Shell Scripts.