Sumit K.

Sumit K.

Team Lead

, India

Experience: 11 Years

Sumit

Team Lead

54857.1 USD / Year

  • Immediate: Available

11 Years

Now you can Instantly Chat with Sumit!

About Me

11+ Years of experience in ETL Design, Data Migration, Development, Testing, Maintenance, Production support, Implementation and Troubleshooting in the field of Data warehousing and Application Development. Extensively used Informatica PowerCenter, I...

Show More

Portfolio Projects

Talend Developer

Contribute

 Creating Talend Job using various Talend components and deploying it on TAC..  Talend Code review for Integrations created by Teammates.  Explain and helping team to understand the background of a

Description

The project is about migrating data from Peoplesoft to OracleCloud for Interfaces. CSV Files are generated and data is uploaded using Soap UI.

Show More Show Less

Contribute

 Leading a team of six person.  Creating Talend Job using various Talend components and deploying it on TAC.  Talend Code review for Integrations created by Teammates.  Coordination with Onshore

Description

The project is for Malaysian petroleum client Petronas. From various sources(Amazon S3, Azure and SFTP) we get files from different partners and eventually load it to Postgres for UI.

Show More Show Less

Description

Ø Production Batch Support and monitoring.

Ø Working on CR and resolving Service Request Tickets raised by Customer.

Ø Coordination and task assignment with Offshore Team.

Show More Show Less

Description

The project is about loading the Zurich Insurance data of different Interface files into different layers. The first layer (Input Layer) maintains the validation rules, the second (UTL Layer) has Agonistics process and Other (S1 and S2) Layers have cloning and calc rules. At last the process generates the RFB File and send is to Business.

Show More Show Less

Description

The project consists of loading all Trade related information into Client Data warehouse. Different Feed sends their trading related data in form of Flat Files. ETL tool is responsible for extracting data from feed files, transforming and loading data. Each day (except Sat/Sun) batch run. This Trade level information is stored in Credit Swiss CDW and later on consumed for various types of report generation.

Show More Show Less

Description

It is one of the umbrella project of AT&T Wireless division. Under this we have various billers like MOW, Universal Biller,SBC, EMEA etc. Now each biller contains various customer(Accounts). These Biller provides us source data in terms of Charge Data files, Reference data files, Bill Messages feed files, XML files. ETL tool is responsible for extracting data from billers files, transforming and loading data to reporting and other schemas. During this process ETL checks if the files is corrupted, then report corrupted files to billers. For each Biller, daily minimum one job runs to process their accounts and once the Account is successfully processed, it becomes Active and the user can see it online though web focus reports.

Show More Show Less

Description

The project consists of loading the EPC (Enterprise Product Catalogue) XMLs data in to PODS tables. ETL process is responsible to perform the mapping between EPC XML files to PODS DB. The process received XML files in specific directory and process loads those different XMLs data to PODS DB based on certain business logic. The process also responsible to execute DB script like refresh, backup and restore the DB during ETL loading process.

Show More Show Less

Description

CCPM is to measure performance of AT&T call centers & standardized data and metrics, and consistent performance management processes across all levels of the national Consumer organization, which will support goal attainment through improved employee performance. The capabilities provided through CCPM are foundational to the success of the national Consumer organization. Here are the diffent modules of the project in which I worked upon CRIFT (Evaluate Call Center Agents Performance). HIERARCHY (Maintain Hierarchical Changes). SALES ORDER (Tracking Order Managed by Sales Representative). CHARGEBACK (This is Calculating Final Compensation of the Agents).

Show More Show Less

Description

QPASS Product Suite manages the digital commerce between Network Provider and Content Providers. Qpass Services Management Platform is software that enables the seamless delivery of premium services over all networks and manages back-office functions such as payment, settlement, reporting and customer care while bridging the gap between operator systems including billing, care, provisioning and third party content and service providers. The DAP (Data Analytics Product) of QPASS provides the analytics on the data extracted from the different QPASS OLTP systems. It consists of ETL that is implemented by the Informatica Power Center and the reporting that is implemented by InetSoft Style Reports.

Show More Show Less