Sudipta C. Email & Phone Number

Kolkata, Wb, In

Bengaluru Area, India

Clientele (Domain): ABS (Travel), GE (Manufacturing), HSBC (Banking), Lloyds (Banking), ANZ (Banking)Key Contribution☛ Developed mapping templates and mapping specifications to migrate data from ABS 2000 (legacy) to IBM Maximo☛ Analyzed the Legacy data and created reports and shared the same with the management☛ Created generic jobs to load from legacy application (~150 tables) to one single table in IBM Maximo☛ Exposed to the functional aspects of SAP Material Master and the various views

Clientele (Domain): Avery Dennison (Manufacturing) and MCJUNKINREDMAN Corp (Manufacturing)Key ContributionAs Designer☛ Worked on CR1896 and submitted reusable assets in Ultimatix☛ Worked with ISTOOL EXPORT and ISTOOL IMPORT options, created project backup☛ Developed reusable jobs to search anything and everything☛ Collaborated with the team to understand the Datastage Architecture and the short comings of the existing AD project architectureAs Designer/Technical Lead☛ Executed incremental load logic to migrate Master tables and Transactional tables☛ Designed DS jobs to execute 24 instances parallel to the tables; minimized the load time from 23 hrs to 1 hr.☛ Communicated with the client to map only required fields which reduces the number of columns☛ Extensively worked with Parameter Sets and Value files

Clientele (Domain): IBM UK (Telecom), IBM Canada (Retail), DGF NFE Germany, Mead Johnson Nutrition Company US, Walmart US, ConvaTec US, Canadian Wheat Board Canada, Gap Inc. USKey ContributionAs Developer☛ Efficiently minimized the integration points of failure through direct access to application or relying on ESB for optimized movement of data across the LCL enterprise☛ Played a pivotal role in ETL start and stop activities☛ Maintained the documentation (tech specs, ticket resolution, RCA, migration request etc.)☛ Maintained strong business control posture with zero tolerance of violations on business integrity and ethics, IBM security guidelines, IBM's business conduct guidelines and other required guidelines, labor/expense claim etc.As Senior Datastage Designer☛ Translated business logic and requirements into technical requirement and understanding☛ Designed and developed reusable jobs and sequencers to migrate data from various legacy systems to SAP☛ Created parameter sets and value files according to the various subject areas☛ Delivered quality products which meet the quality standards set by IBM

Clientele (Domain): AC Nielson US (Retail), Pfizer US (Pharmaceutical)Key Contribution☛ Migrated the data in form of files, performed some transformations and cleaned the given data and populated Dimension and Fact tables which are already presented with the new transformed data☛ Provided the data that needs to be populated in the Dimension and Fact tables with some minor transformations and cleaning☛ Migrated data from Siebel EIM tables to target Siebel OLTP tables☛ Developed jobs in Datastage using Oracle 9i at the backend, migrated the data from the files generated from clients existing OLTP system to Siebel EIM tables☛ Modified and enhanced the existing jobs according to the changed requirements

Bachelor Of Technology (B.Tech.), Computer Science And Engineering, 78.9%

3Yrs Diploma In Computer Science And Technology, Computer Science And Technology, 80.6%

Maths Honours (Took Admission But Didn'T Complete), Maths

W.B.H.S (Class 12), Pure Science, 60.7 % (First Division)

I.C.S.E, Class 10, 81.6% First Class With Distinction