Summary
Overview
Work History
Education
Skills
Timeline
Generic

SUBHAM SAMANTARAY

IT Analyst

Summary

Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.

Seasoned ETL experienced developing applications, databases and cloud computing solutions. Smart professional with proven troubleshooting and debugging capabilities for resolving complex technical issues.

Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.

To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

8
8
years of professional experience

Work History

Software Engineer

TechMahindra
Bhubaneswar
08.2015 - 12.2016
  • GE is the manufacture based industry based in US
  • There were some monthly activities like Data extraction, Estimator process etc
  • These processes are carried out once in every month and initially all are manual processes
  • There were heterogeneous data sources like SAP, Oracle Based DB & Flat files
  • This project involved integration of all the data sources in the target data warehouse with business logic
  • On the final tables reports were generated
  • We used to handle the production defects as well on a daily basis and work on finding the RCA for the issue in hand
  • There are a total of 15 Informatica jobs which runs on a certain frequency to load the 20 stage tables, 20 snapshot tables & final tables on top of which reporting was done
  • Contribution
  • Production Support, handling tickets to check the SLA's are not missed
  • Understanding the business requirement
  • Project Domain, Project Name: STOREFRONT

Software Engineer

Tech Mahindra
Bhubaneswar
01.2017 - 12.2021
  • We worked on 7 airlines according to client requirement
  • Each had different data source which were integrated in informatica mappings through SFTP connection
  • B) Contribution
  • We have 12 tables to work on & put the business logics
  • We worked on the mapping creation
  • I am responsible to monitor and resolve the day-to-day issues in the ETL part, which involved huge backtracking of data
  • I supported Informatica mappings/sessions and workflows for new requirements
  • I worked on the enhancements of the present jobs
  • I have also done the ETL testing and basic data validations, prepared test cases documents for the client
  • Migration of the Informatica objects to different environments and handling the tickets
  • Interacting with the client continuously to gather the requirements and provide the daily status details
  • Conducted research to test and analyze feasibility, design, operation and performance of equipment, components, and systems.

IT Analyst

TCS
Bhubaneswar
01.2022 - Current
  • Project Domain : Lifescience-Insurance Pharmacy
  • Project: MTM:Humana Pharmacy
  • Client : Humana
  • Team Size Project : 8
  • Functional Skills Informatica,Oracle(PL/SQL),Snaplogic,AngularJS,Dotnet,SSIS,Power-BI,Qlick-view
  • A-Project Description
  • We generated readiness file for Humana to present to CMS
  • We used to handle data coming from different vendors, that ultimately is used to generate READINESS FILE
  • B-Contribution
  • We have developed and maintained 2 applications based on dot-net and angular-JS, where the business usually monitors the reporting data and inputs their conditions from which some of our process starts
  • After the conditions are set-up by business, SSIS, Snaplogic and Informatica starts running the process
  • I mainly looked after Informatica workflows and Snaplogic pipelines and worked on creating new developments and enhancing the existing process
  • Migration of the Informatica/Snaplogic objects to different environments and handling the tickets
  • Interacting with the client continuously to gather the requirements and provide the daily status details
  • Supported PSM team during production issue.

Education

B.Tech - IT

ITER(SOA)
Bhubaneswar
05.2011 - 2015.05

12th IT - Science

Ravenshaw College
Cuttack
03.2009 - 2011.03

10th - Science

Stewart School
Cuttack
03.1997 - 2009.03

Skills

    Agile

undefined

Timeline

IT Analyst

TCS
01.2022 - Current

Software Engineer

Tech Mahindra
01.2017 - 12.2021

Software Engineer

TechMahindra
08.2015 - 12.2016

B.Tech - IT

ITER(SOA)
05.2011 - 2015.05

12th IT - Science

Ravenshaw College
03.2009 - 2011.03

10th - Science

Stewart School
03.1997 - 2009.03

Similar Profiles

CREATE PROFILE
SUBHAM SAMANTARAYIT Analyst