Mitranjan Kumar Email & Phone Number

Gurugram, Haryana, India

• Responsibility
• Leading development team to provide solution to Business
• Delivered MIS Project, Dataware house Project, Set up reporting module to sync data from MongoDB to SQL Server 2017 to publish real time reports and Business Dashboard to Business User.
• Setup all digital communications like- WhatsApp, Email Service & SMS.
• Taking care of application CKYC,IIB Data upload module, AML, CCM,SMS,Whatsapp, RIY,CRM Module since development
• Monitoring the Ticketing tool (Trace) to track issue raised by end user.

Gurugram, Haryana, India

• Responsibilities:Design and development of parallel jobs using DataStage 11.7 to extract data from DB2,Oracle and SQL Server database, cleanse it, validate ad transform it as per business requirement and populate it.
• Design and development of Sequence jobs to execute the series of job as per loading frequency.
• Involved in running, monitoring and analyzing performance of the individual stages of the jobs performed using DataStage Director.
• End to end knowledge of ETL processes, Performance tuning and troubleshooting of ETL DataStage jobs.
• Responsible for system integration testing at onsite and preparing SIT test scripts using Db2 SQL.
• Building DB2,Oracle SQL queries for UAT validation and testing for the product.

Gurgaon, India

• Responsibilities:
• Performance tuning of existing stored procedures and scripts using the help of Explain Plan.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

Gurgaon, India

Gurgaon, India

Bhubaneshwar Area, India

Project Overview DotSoft is a CRM Package developed by A.P. Telecommunication Circle, Hyderabad as per BSNL requirements. DotSoft is integrated Software for Commercial, TRA (Telecom Revenue Accounts), FRS (Fault Recording System) and DQ (Directory Enquiry). Module is working on client/server technology, in which front end tool is D2K & backend is Oracle.

Master Of Computer Applications (Mca), Information Technology

Bachelor Of Infomation Technology, Computer Science