Computer Programmer 2017-2020(From Hyderabad, India)
2020-Present (From Toronto, Canada)
Domain: Banking
Organization: Tech Mahindra
Client: Bank of Nova Scotia
Project Description:
Global Anti-Money Laundering System forms the crucial part of the Anti-Money Laundering Compliance of Scotia bank where we collect the data from all the customer countries and load the data into different tables and then generate extracts to send to downstream systems for suspect scanning and report to enforcement departments.
Responsibilities:
- Designing and developing ETL jobs using the mappings provided by Business analysts on 11.5 on the EDL
- Unit testing ETL jobs.
- Developing Unix scripts to call the DS jobs.
- Coordinating to load masked historical data that is required for TM tuning in FCCM.
- Providing transition to production support for the new code.
- Debugging data issues if any occur.
- Provide support for Business acceptance testing.
- Interaction with business for the clarifications needed on the data feeding.
- Placing Jobs in batch scheduling tool Tidal.
- Share the Best practices to team members.
IT Analyst 2014-2016
Domain: Insurance
Organization: Tata Consultancy Services Limited.
Client: United Services Automobile Association
Project Description The regulatory environment is rapidly evolving in the UK under the Solvency II directive and other accounting regulations. As a result, there is a significant pressure on firms to ensure compliance and to demonstrate a clear audit trail, controls and governance in relation to the underlying data. The objective of this project is to implement the Wolter Kluwer’s Solrep Solvency II Reporting Solution to enable USAA P&C to comply with Pillar 3 financial reporting requirements.
Responsibilities:
- Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
- Supporting solution Architect in functional and Solution related queries
- Estimation preparation for any change request using the estimate calculator tool
- Understanding the business requirement and analyze the source data and challenges involved in the various data before processing through transformation logic.
- Had proposed and designed the solution, where the different structured flat file data are being processed using a single reusable set of jobs to the respective staging tables.
- Also involved in designing some other reusable set of jobs for processing the data to the dimension and fact tables, irrespective of changed nature of the same source file in different versions.
- Extensively used DataStage Designer to develop various Parallel jobs to extract, cleanse, transform, integrate and load data into Enterprise Data Warehouse tables.
- Used all parallel stages like Sequential files, Data set, Lookup, Join, Funnel, Filter, Transformer and DB connector stages.
System Engineer 2010-2014
Domain: Insurance
Organization: Tata Consultancy Services Limited.
Client: United Services Automobile Association
Project Description
As a part of Data Integration strategy for The Dodd Frank Act implemented in United States to ensure that all the financial institutions should withstand to the recession that may come in future, the data received from various Heterogeneous sources will be loaded into Staging Database for Reports Generation that would be submitted to Federal Reserve Bank.
Responsibilities:
- Implementing Data Validation Option (DVO) tool and MS-Excel frameworks to perform automated validation of
- data in Oracle - staging and target database.
- Participating in code walkthrough to understand the DataStage ETL jobs design.
- Participating in early phases of testing – Unit and Integration Testing.
- Tracking and reporting the defects in ALM
- Attending the daily status meeting with the onsite manager and weekly status meeting with the client manager
- Updating the daily activities in the RTC
