Project Name: Network International

Domain: Banking

Team size: 4

Description: Network International provides technology-enabled payments solutions to merchants and financial institutions in the middle east. It deals with Card Acceptance, Authorization and Processing, ATM Management and Monitoring, Merchant Acquiring, Consumer Finance Services, Point-of-sale (POS), Merchant Settlement and Chargeback Services, Dynamic Currency Conversion, E-commerce services, Loyalty Programme, Multi-Currency, Fraud Monitoring.

Mashreq Bank needs to on-board on Mercury Payment Systems as a PoS & ATM

Acquirer which will enable Mercury card acceptance on Mashreq Bank Merchant/ PoS

terminals and ATM terminals. ADIB needs to on-boarded on Mercury Payment Systems as a PoS Acquirer which will enable Mercury card acceptance on ADIB Merchant/ PoS terminals.

Diners card report generation using Talend and DataMart. Calculating Diners Transaction and discount amount and incorporating with other schemes except diners (Visa, MC, AMEX, CUP, JCB, MERCURY, Private Label)

Role and Responsibilities:

• TALEND need to enhance the mapping to accommodate Mashreq Bank PoS and ATM acquiring member.
• TALEND need to enhance the mapping to accommodate ADIB Bank PoS acquiring member.
• Input data was flat files, xml files or database.
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis
• Creating complex SQL scripts to get the data from various tables, transform and normalize in Talend to create reports.

Project Name: United States Cellular Corporation(USCC)

Domain: Consumer and Industrial Products

Team size: 12

Description: United States Cellular Corporation(USCC), is a regional carrier which owns and operates the fifth-largest wireless telecommunications network in the United States.

USCC underwent a major technology transformation to update its Billing system, CRM, Financial and order management system, Enterprise data warehouse and Self-care portal

Deloitte USI helped them with an assessment of their testing work and with setting up a Testing CoE.

Role and Responsibilities:

• Validate the movement of data elements on a field by field basis from source to target, validation is done by using approved Source to Target mapping sheet
• Design test cases for each column
• Check for data Integrity and data correctness
• Run historic ETL loads and execute designed test cases
• Identify and raise defects
• Run incremental ETL loads and execute incremental test cases
• Identify and raise incremental defects
• Check for performance of the query and optimize it
• List down the count of Nulls ,Zeros, Positive and Negative values for each KPI column and submit this report to client.

Domain: Consumer and Industrial Products

Team size: 8

Description: Clarivate Analytics owns and operates a collection of leading subscription-based businesses focused on scientific and academic research, patent analytics and regulatory standards, pharmaceutical and biotech intelligence, trademark protection, domain brand protection and intellectual property management.

The key objective of Project Elevate is to successfully lead and facilitate the end-to-end implementation of core business information systems while facilitating the transformation of our business.

I was involved in mapping and transforming Finance objects like Vendor Bill, Vendor, Purchase Order from SAP to NetSuite using Talend ETL Tool. Data was loaded from SAP to Oracle, then Talend was used to map and convert Oracle source data to Netsuite required format using components like tWriteJSON, tMap etc.

Role and Responsibilities:

• Created Talend jobs both design and code to process data from Oracle source to staging and then to Netsuite
• Used components in Talend like tMap, tFilterRow, tjava, toracle, tWriteJSON, tdelimited files, tlogrow,tjavarow
• Worked on Joblets (reusable code) & Java routines in Talend.
• Created local and global Context variables in the job
• Responsible for creating lookup and staging tables and other database objects like views, function, indexes and constraints
• Implemented Error handling in Talend jobs
• Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobs.
• Tuned sources, targets and jobs to improve the performance
• Developed complex ETL jobs to source from flat files and loaded into target databases using Talend OS ETL tool.
• Interact with business community and gathered requirements based on changing needs. Incorporated identified factors into Talend jobs to build the Data Mart.
• Performance tuning - Using the tmap cache properties, Multi-threading and Parallelize components for better performance in case of huge source data. Tuning the SQL source queries to restrict unwanted data in ETL process.
• Involved in Preparing Detailed design and technical documents from the functional specifications.

Eliminate dependency on SFDC while reimagining Digital Marketing and Sales experiences through the integration of Adobe Experience Cloud and Microsoft Dynamics. Implement Microsofts selling platform with Adobes Experience Platform to demonstrate the value of the Adobe – Microsoft GTM partnership Decouple major technical capabilities from SFDC Move to Cloud independent vendors Configure, Price, Quote (CPQ)(Pros) Contract Lifecycle Management (CLM)(Icertis) Simplify end to end business processes Enable capabilities supporting Sales, Deal Desk The reports generated were on Deal Desk,Sales Operations,Revenue Operations,Order Management, Technical Accounting etc.

Four Enabling Technologies will facilitate global processes in the future state. Middleware and ETL platforms will be used to connect the Enabling Technologies to the three Centralized Finance Platforms (CFPs) The Enabling Technologies used are APxCelerator, Blackline, Cforia, Concur. The Centralized Finance Platforms (CFPs) are JDE E1, SAP PR1 and ORACLE EBS. Oracle Fusion Middleware/Informatica ETL Facilitates the extraction, transformation, and loading of data between CFPs and ETs. Provides a platform for users to interact and send commands to both CFPs and ETs

United States Cellular Corporation(USCC), is a regional carrier which owns and operates the fifth-largest wireless telecommunications network in the United States. USCC underwent a major technology transformation to update its Billing system, CRM, Financial and order management system, Enterprise data warehouse and Self-care portal Deloitte USI helped them with an assessment of their testing work and with setting up a Testing CoE.

Pekin Insurance administers and delivers a long-term security for policyholders, shareholders, agents, and employees. It is undergoing a business transformation program, PIVOT, which includes data strategy to help recommend its current and future enterprise data, reporting, enterprise data warehouse (EDW) and business intelligence (BI)/analytics environment. PIVOT is a P&C(Property and Casuality) transformation including a portfolio of many ongoing projects(Guidewire,legacy changes,change management).DataHub was established as the operational data store and InfoCenter for reporting needs around BOP(Businessowners Policy), WC(Workers compensation) and PA(Personal Automobile), while other reports were developed from the mainframe or legacy EDW. From ETL perspective, PEKIN invlolves data conversion i.e moving data from legacy to ERP system where legacy system is pas(policy administration system) or mainframe system and ERP is guidewire. Agile software development model was followed

Redesign MFGDW ETL flows from ODS system to retire existing flows from HDB- This projects covers impact analysis of MFG DW because of ODS along with ETL and DB modifications .I was involved in analyzing the impact of this change in the current MFG DW system. I worked on the ETL and Database changes and in the process validated ODS data.

Microchip corporate procurement group and foundry operations group had requested for capability to generate foundry spend report from Dashboard. In order to accomplish this objective, we had to transport data from Baan source tables to corporate data warehouse (UDB). Data to be ported pertain to purchase orders, purchase order lines, receipts, suppliers, items, warehouses, general ledger accounts and cost center dimensions. I worked on this from scratch and I was involved right from data modelling, designing the code, testing. I created Dimensional model to the proposed database. Later the foundry tables had to be restructured in order to satisfy reporting needs. The fact and dimension tables were re-organized and I was able to modify the universe accordingly.

Micrel was acquired and its Point of Sales data and Sales Forecast data had to integrated with the existing Microchip tables.

All the manufacturing workflows have a complex design and recovering the missed loads during a failure is quite a challenge. I fixed rejections happening in the current flows and this gave me an insight in the actual data flows, its functionality and data cleansing