Shruti Mohan

Working as Ab-initio Developer and Team Reviewer • Responsible for migrating tables from Teradata to AWS S3. • Loading AVRO files from S3 Buckets to Snowflakes. • Currently managing team of 8 People. • Responsible for information gathering from the client for tables which are to be migrated. • Using JIRA for Tracking and Updating of a BUG created for migration Tables. • Documentation on Migration and flow for the migrating tables. • Manage and review a team of 5 people with their tasks.

• Responsible for maintaining the requirement clarification log and Estimation report. • Validated internal, user and third-party reports and verified for accurate data population • Responsible for Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes. • Coordinated with the business analysts and developers to discuss issues in interpreting the requirements • Responsible for Tokenization/masking of CRD (Critical Risk Data) fields. • Involved in performance Tuning of existing graph or process improvement. • Responsible for Unit Testing of data and data analysis. • Good knowledge on Teradata SQL assistant. • Responsible for Reviewing Applications changes and standardization for graph. • Responsible for writing many UNIX Script used in Ab-initio Graphs.

Worked as Ab-Initio & Teradata Developer • Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation. • Used Teradata utilities Fastload, Multiload, BTEQ to load data • Wrote, tested, and implemented Teradata Fastload, Multiload and BTEQ scripts, DML and DDL. • Wrote views based on user and/or reporting requirements. • Wrote Teradata Macros and used various Teradata analytic functions. • Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata. • Performance tuned and optimized various complex SQL queries. • Wrote many UNIX scripts. • Good knowledge on SQL assistant and BTEQ. • Gathered system design requirements, design and write system specifications. • Excellent knowledge on ETL tools such as Ab-Initio to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently. • Agile team interaction. • Coordinated with the business analysts and developers to discuss issues in interpreting the requirements

Worked as Informatica Developer • Responsible for all activities related to the development, implementation, and support of ETL processes for large scale data warehouses. Accountable for the data build deliverables from offshore system development. • Worked on Informatica Power center 9.1 and SQL server 2008. • Responsible for getting the requirements from onsite Shell and come up with questions and suggestions to get the clear picture of requirement Solution notes along with Business analyst. • Responsible for maintaining the requirement clarification log and Estimation report. • Validated internal, user and third-party reports and verified for accurate data population • Responsible for data extraction, Transformation and loading data from various sources like SQL Server and Flat files. • Responsible for Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes. • Unit testing of the data received at production server.

Created Face tracking software