Vatan Kumar Singh Email & Phone Number

Varanasi, Up, In

Noida, Uttar Pradesh, India

ExperienceRole: Analyst cum Team LeadAstellas Pharma Inc.Feb 2018 – Oct 2018 & Frb 2019 - Dec 2019 (Offshore)Nov 2018 – Jan 2019 (Japan Onsite)Project Overview: Astellas Pharma Inc. is a leading Japanese pharmaceutical company with key divisions in research, drug development, manufacturing, and sales, operating across the US and Europe.Responsibilities:> Managed and coordinated team activities, ensuring efficient project execution and high-quality SLC deliverables.> Collaborated with onsite teams during the onsite phase to align project strategies and enhance cross-functional communication.> Developed and optimized PL/SQL and SQL queries per project needs, utilizing database management skills.> Applied Fuzzy Control Language, workflow configuration in Oracle EDQ tool (used to Extract Transform Load data) for specialized data analysis tasks, contributing to enhanced decision-making processes.Technical Skills:Databases: Oracle 11g, Oracle 12c.Software Tools: Proficient in Toad for Oracle, Putty, WinSCP (SFTP client), MS Office, Oracle Fusion Technical-Business Intelligence, Oracle Enterprise Data Quality, Remote Desktop, and Windows Virtual Desktop.

Noida, Uttar Pradesh, India

ExperienceDeveloperCity University of New York (CUNY) ProjectFeb 2016 – Jan 2018> Developed, Enhanced, and Maintained Mainframe Applications: Worked on critical applications such as CUDLS, PETS, and SKAT, which focused on Disbursement and Exam Scoring, ensuring their functionality and reliability for CUNY’s operations.> Ad-Hoc and Strategic Activities: Participated in ad-hoc tasks, including drafting Requests for Proposals (RFPs) and collaborating in business meetings with companies like 24alife to evaluate potential partnerships.> Quality Assurance: Ensured the quality delivery of Software Life Cycle (SLC) documents, maintaining high standards in documentation and project execution.> Effort Estimation and Project Management: Conducted effort estimation and managed activities in TCS internal IPMS tool, contributing to effective project planning and resource management.> Technical Skills: Proficient in languages such as Rexx, SQL, JCL, Basic-PL1, COBOL, HTML, and JSP. Experience with z/OS DB2 databases and IBM WebSphere Application Server.> Tools and Environments: Skilled in using IBM z/OS (TSO/ISPF/File-Aid) and other mainframe tools to support project needs.

Thiruvananthapuram, Kerala, India

ExperienceTraineeTata Consultancy Services (TCS) – ILP TrivandrumMainframe Training Program: Participated in an intensive training program focused on mainframe technologies and software.Object-Oriented Programming and System Design: Gained knowledge in Object-Oriented Programming concepts and the system development life cycle, enhancing both technical and analytical skills.Communication Skills Development: Improved professional communication skills through interactive sessions and team projects.Code Review and Peer Collaboration: Conducted code reviews for peers to ensure code quality and enhance collaborative skills.Technical Proficiency: Trained in IBM OS390, COBOL, JCL, and DB2, utilizing tools such as IBM OS390 (TSO/ISPF/File-Aid).About the ProjectMainframe Training Program: This program provided foundational training in mainframe technologies, preparing participants for future roles in various projects within TCS.About the Mainframe Training Program: This program provided foundational training in mainframe technologies, preparing participants for future roles in various projects within TCS.Post-Training Allocation to Retail Domain Project - CUNYCity University of New York (CUNY), is largest urban public university in the USA, renowned for its transformative role in social mobility and as a critical element of New York City's educational framework.

Bachelor Of Technology (B.Tech.), Mechanical Engineering, 68.99

B.Tech from Mechanical Engineering

12, Pcm, 78.4

10, Matriculate, 78.2