Archana Deshpande

- Designing test cases and performing tests on the ETL flows - Raising and tracking defects - Basic training on Tableau

- Designed, developed, tested and deployed Informatica transformation logic based on business logic provided by business analyst. - Built reusable transformations and mapplets whenever redundancy was needed. - Trained in Abinitio and developed graphs for this project as part of Informatica to Abinitio migration. - Created tax and invoice reports in xml and text formats and created data for BI reporting. - Created Tivoli jobs for scheduling the Informatica workflows.

- Implemented Informatica mappings that performed Extraction, Transformation and Load of source data to cater business requirement. - Extracted data from various source systems: relational database, text files etc. - Implemented Slowly Changing Dimensions (SCD) types I and II. - Created Linux scripts for source file validations and move, remove, touch file operations. - Implemented coding standards, performed Unit Testing - Interacted directly with client, test teams and production support teams.

- Developed or modified existing Informatica mappings as per requirements. - Well versed in issue analysis and data mapping in ETL processes. - Created jobs for scheduling the ETL processes. - Gained basic knowledge of Banking Domain and of Data Quality Analysis of Enterprise Data. - Worked on conversion of about 3000 Autosys jobs to CA7. - Had been part of Oracle to Teradata migration. - Worked on Automating processes in production.

Computer Architecture, Object oriented programming, C, C++, Java basics, computer networks, database and SQL etc.

Physics, Chemistry, Mathematics, English