Environment: /Linux/Windows/Azure Databases: /Oracle/MS SQL Server/ Teradata ETL tools: /Ab Initio/Azure ADF/Bash scripts Code Control and Scheduling: Github - Installed and configured Ab Initio Coop, EME, Control Centre, Authorization Centre - Migrated applications from Informatica to Ab Initio - Designed and developed batch jobs to support business needs - Designed and developed real time applications using Ab Initio Continuous Graphs, Ab Initio queues, JMS queues and Web services - Designed and developed Azure ADF pipelines and dataflows to load data in Synapse - Successfully implemented conversion/ingestion components to PAT/PROD.

Environment: /Windows/JIRA/Linux/Apache Hadoop/Cloudera HDFS Databases: /Oracle/MS SQL Server/ Postgres ETL tools: /Data Stage/Ab Initio/Podium/Python/Bash scripts Code Control and Scheduling: Bit Bucket/GIT/Atlassian SourceTree/Jenkins/Oozie Data Access: HUE (hive and impala), SQL developer, Dbeaver, MS SQL Server Management Studio - Migrated ingesting processes from Ab Initio and Data Stage to Podium/EDPP platform - Designed ingestion components for podium using sqoop, python and bash scripts. Documented ingestion guidelines for team of developers. - Implemented Data Conversion Phase1 of Guidewire Claim Centre to Oracle using Data Stage - Designed and developed ingestion for AS400 data to EDPP (Enterprise Data Provisioning Platform). - Prepared conceptual solutions for new cases and scenarios, executed proof of concept for most complicated interfaces and provided end to end solutions. - Lead development effort by onshore team, providing help and advice, as well as reviewed ingestion code on daily basis. - Provided support for testing and quality assurance. - Successfully implemented conversion/ingestion components to PAT/PROD.

Environment: /Windows/UNIX/Oracle/Ab Initio/Data Stage/Netezza/Cognos - Migrated Data Load processes from platform Ab Initio/Oracle to Data Stage/Netezza - Designed and developed Staging for Data Warehouse. - Provided estimates for design and development efforts by onshore and offshore development teams. - Developed interfaces for processing TSYS ebcdic and ascii flat files - Lead development effort by offshore team, providing help and advice, as well as reviewed ETL code on daily basis. - Implemented reports to provide RISE compliance.

Environment: /Windows/UNIX/Oracle/DB2/Data Stage - Designed interfaces for new iHUB platform within TD Canada Trust MBNA program. - Provided estimates for design and development efforts by onshore and offshore development teams. - Prepared conceptual solutions for new cases and scenarios, executed proof of concept for most complicated interfaces and provided end to end solutions. - Lead development effort by offshore team, providing help and advice, as well as reviewed ETL code on daily basis. - Provided support for testing and quality assurance.

Environment: /Windows/UNIX/DB2/Data Stage - Audited current Data Warehouse solution of the Rosbank as lead of the Architecture and Infrastructure team. - Prepared AS IS analysis of current Corporate Data Warehouse solution at the high level by identifying problems and suggesting solutions. - Prepared target architecture for Rosbank aligned with Enterprise architecture and recommendations from SG.

Environment: PC/UNIX/Java/C/SQL/Sybase/Ab Initio - Designed options for implementing both projects. Conducted meetings and reviews with all involved parties to identify best options for projects. - Designed high level and detailed system design for both projects. - Created templates for ETL specifications for DSA and DataFeeds projects - Developed common components for DSA and DataFeeds projects in dynamic Ab Initio environment - Coordinated work with outsourcing development and quality assurance, as well as local data model and business intelligence teams to achieve successful development of DSA and DataFeeds projects - Conducted reviews with the support system administration and database administration groups to schedule implementation of the projects. - Successfully implemented the projects on time and within the budget.

Environment: PC/UNIX AIX/Java/C/SQL/DB2 UDB /Abinitio - Planned and designed ETL part for AML 3 Project - ETL development of OCIF subsystem for name matching AML phase3 - Designed and developed common components for the new platform. - Designed, developed and provided benchmark testing for near real time applications using Ab Initio continuous components

Environment: PC/UNIX AIX/Java/SQL/UDB EEE/Oracle/Access/Informatica - ETL development of data marts to stage data for BASEL II on DB2 UDB - ETL development auditing data marts for Bafin project using SQL on Oracle and MS Access - Designed scripts for quality assurance using Excel and Mercury quality centre.

Environment: PC/UNIX AIX/C/C++/Java/SQL/UDB EEE/Ab Initio - ETL development of Staging Data Warehouse for Basel II (Risk Assessment) and AML (Anti Money Laundering) Data Marts (Customer Link, Accounts, Transactions) - Designed and coded data loading processes to load files received from mainframe into DB2 EEE database using SQL and Ab Initio ETL tool. - Provided training and support for new Ab Initio Developers, including design documents and walkthroughs of the graphs. - Implemented performance tuning recommendations using parallel processing with parallel connection to database. - Implemented EME data repository for different environments, executed code migrations to different systems and analysis for various applications. - Used Ab Initio Data Profiler for data analysis of host files

Environment: PC/UNIX AIX/C/C++/Java/SQL/UDB EEE/Ab Initio, Perl - ETL development of Staging Data Warehouse and Basel Retail and Commercial Data Marts (Application Processing, Credit Cards, Loans, Mortgages, Risk Rating and Default systems) - Designed and coded data loading processes to load files received from mainframe into DB2 EEE database using C, Java, SQL and Ab Initio tool. - Designed and coded data retrieving tools to extract data from Data Warehouse to Data mart using Ab Initio. - Implemented business requirements to comply with Basel Accord. - Loaded 5 years history data into data mart for Application Processing, Credit Cards, Loans and Mortgages systems.

Environment: PC/UNIX AIX/C/C++/Java/VB/Embedded SQL / DB2 UDB EEE/Oracle 8 - ETL development using Informatica - Designed and coded data loading tools to load files received from mainframe into DB2 EEE database using C/C++ and embedded SQL. - Redesigned and coded data retrieving tools to extract data from the Data Warehouse to other systems for refresh process to implement hardware upgrades. - Implemented Data warehouse changes to support Microstrategy.