Project Synopsis:

FIS Profile® is a comprehensive real-time core banking system operating in the U.S. and more than 20 countries around the world in some of the world’s largest and most recognizable global financial institutions.

Role and Responsibilities: Sr. Tech Lead.

• Coordinated with Business analysts to understand the requirements.

• Created the Low level design documents for the solution.

• Design and developed the functionality

• Analyze data in the application

• Involved in Data Modeling.

• Design most cost effective solution to meet requirements

• Written Packages, Functions and Procedures.

• Extensively work in Performance tuning

• Build and release activities using Openshift, Jenkins and Bitbucket.

• Code review. Adhering to coding standards

• Non Prod environment management activities.

FATCA(Foreign Accounts Tax Compliance Act) targets tax non-compliance by US Tax Payers with foreign Accounts. FATCA focuses on Reporting by US Tax Payers about certain foreign Financial accounts and offshore assets and also by Foreign Financial Institutions (FFIs) about Financial Accounts held by US Tax payers.Data From all the ANZ Applications are obtained as Flat files and loaded into FATCA Stage A Database and Transformed into Customer and Account Information in StageB Database. The XML reports are generated based on the StageB data and Reported to Internal Revenue Service(IRS).

Role: Sr.Tech Lead

Responsibilities:

• Working as Tech lead, responsibilities of which include providing estimations, Assigning Tasks to team members, delivering the code to different test environments.
• Coordinated with Business analysts to understand the requirements.
• Created the High level, Low level design documents for ETL logic.
• Created the PL/SQL packages, procedures, functions applying the business logic
• Designed and developed the functionality of loading data from flat files into oracle tables using SQL Loader.
• Designed and developed the Transformation logic in ETL using complex join queries in PL/SQL.
• Designed and developed the functionality of Extracting files from oracle tables.
• Defect fixing.
• Involved in Data Modeling.
• Designed and developed the FATCA Reporting Solutions for IRS using PL/SQL and Unix Shell Scripting.
• Code review. Adhering to coding standards.
• Optimized the queries which involve large volumes of data.

ANZ has NORKOM system to detect and report Anti Money Laundering activities. This requires data in the form of CUSTOMER, ACCOUNT, TRANSACTION and reference data. The Data Sourcing project enables integration of the company’s other systems (e.g., Finacle 10) with NORKOM System in the form of CATR data.

Files will be received from different source systems and then transformed into CATR format and then loaded into the NORKOM System.

Role: Lead Developer

Responsibilities:

• • Coordinated with Business analysts to understand the requirements.
  • Created the High level, Low level design documents for ETL logic.
  • Design and developed the functionality of loading data of ETL from flat files into oracle tables using SQL Loader.
  • Designed and developed the Transformation logic in ETL using complex join queries in PL/SQL.
  • Design and developed the functionality of Extracting files from oracle tables.
  • Defect fixing.
  • Code review. Adhering to coding standards.
  • Estimation and assigning of tasks to team members.

Optimized the queries which involve large volumes of data

ANZ has TRAC system to report Addresses, TINs, account balances of US citizens to comply with FATCA (Foreign Account Tax Compliance Act). This requires data in the form of CUSTOMER, ACCOUNT, and ADDRESS.

The Data Sourcing project enables integration of the Bank’s other systems (e.g., Finacle 10) with TRAC System in the form of CUSTOMER, ACCOUNT, and ADDRESS data. Files will be received from different source systems and then transformed into TRAC format and then loaded into the TRAC System which would be then send to IRS.

MQSubscribe is a convergent customer management and billing solution for the Pay TV, ISP and IPTV industry. MQSubscribe is a highly cost-effective, modular, flexible and scalable solution. It enables service providers to effectively provision, rate, accurately bill and engage in customer care for all their basic and advanced services such as PayTV / Internet Service Providers, Broadband Services, Interactive TV Services. MQSubscribe can be integrated with Middleware for Broadband services, VOIP services and Conditional Access Systems for PayTV Services. MQSubscribe is designed to meet the billing requirements of voice, data and video services and generate a single bill for customers. The open architecture and flexible modular design enables easy integration with existing systems and easy configuration of complex and dynamic business models.

Responsibilities:

• Gathering the requirements of customizations requested by the various clients

• Coding using Oracle Pl SQL, testing and delivery.

• Developing of Client Specific customizations using Oracle/SQL Server and reports using Crystal Reports.

• Responsible in write-offs of ATP/ATC (Acceptance test plan/Acceptance test criteria) with the client.

• Training co-ordination.

• preparation of training materials and end user training.

• Responsible for data mapping and porting, i.e. If the customer has an existing billing system, helping customers map the data in the existing billing system to the new billing solution.