Sangram Sinha

Experience

• 

  Tata Consultancy Services

  May 2015 - Sept 2017

  Software Engineer

  Worked in PL/SQL (Oracle 9i), UNIX programming like writing stored procedures, blocks, functions and cursors for bulk update on tables in Oracle, shell scripting and used tools like TOAD and SQL Developer.Provided solutions for problems raised in production as well as technical production support and assistance to customers. Involved proactively in process improvement and automating manual workAnalysis, Issue identification and enhancing the Billing Operations System in Telecom Domain with effective automation mechanisms like resolve order failures at billing level and close the orders.Handled Enterprise Billing of TTSL customers using Kenan FX independently.Handled batch processes like COM, MCAP, CAP, BIP, BIF and MIU, Supporting Kenan BP modules usage processing, Invoice generation, Journals, resolving Package Configuration issues, Discounts and Unit Credits Configuration Issues.With Excellent interpersonal & communication skills, better understanding of client’s expectation and strong problem solving abilities, worked in ITIL processes like incident management and problem management related to discount and invoice issues and ensured timely closure.Training and Business Induction sessions to the newcomers and preparation of Induction Manuals.My accomplishments:• Analyzed, identified, and enhanced the billing operations system with effective automation mechanisms. • Resolved customer related queries by providing logical information.• I was awarded a star of the month for identifying and reducing loss of business revenues. Show less

• 

  On Device Solutions Ltd.

  Jun 2018 - Nov 2022

  Provided tier 2 application software support for multiple products; Regular health checks and housekeeping roles for multiple applications; analyze system errors and troubleshoot network, server, and database errors. Established new user accounts/passwords, utilized active directory; monitored and updated permissions rights for users. Performed connectivity and login activities and unlocked user accounts and reset password while formulating effective solutions to issues/defects. Tracked, logged and responded to support tickets. Performed user account maintenance, managed incidents and provided resolution for end-users technical challenges.As a tester, participated in major and minor application upgrades and releases.Wrote and updated process support documentation.Utilized knowledgebase tools to transfer technical & business knowledge to team members.My accomplishments:• Provided solutions to the customers for the query raised by them in an efficient manner.• Resolved incident with SLA and received appreciation from clients.• Managed recoveries for business-critical applications and databases.• Acted as a leader whenever required for the team Show less

  • Senior Software Engineer

    Oct 2021 - Nov 2022

  • Software Engineer

    Jun 2018 - Oct 2021
• 

  Takenmind Organisation

  Oct 2019 - Oct 2019

  Data Analytics Internship at TakenMind

  This internship is all about data analytics and visualization, creating attractive visuals and drawing valuable insights are few things I did. I did the project on employee attrition which was exciting. I have applied most of my ML learning concepts on this and created stable model which was highly appreciated.Achievements: Identified valuable insights while exploring the data. Created stable model to predict the employee attrition with high accuracy. Able to identify and provided unique solutions to the problems raised during the project. Show less

• 

  IBM

  Nov 2022 - now

  Data Engineer

  As Data engineer, I develop and move data from the operational and external environments to the business intelligence environment using DataStage software. Skills include designing and developing extract, transform and load (ETL) processes.Responsibilities: Coordinate with multiple technical teams to ensure apt integration of functions to identify and define necessary system enhancements to deploy new products and process improvementsProvide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprintUtilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementationDevelop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goalsResolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standardsProvide in-depth analysis with interpretive thinking to define issues and develop innovative solutions, Show less