Mitranjan Kumar Email & Phone Number

Delhi, India

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.• Managed all MIS & New requirements • Managed across company department requirement & providing solution to arrange development.• Handling Stakeholder requirement for any functional changes and new requirement• Played a stellar role in Streamline the MIS development & databases support process• Efficiently ensured that Tickets were resolve within the define SLA’s if any came under L3• Played a stellar role in analyzing and implementing new procedures.• Setting up Roadmap to get permanent fix for reoccurring issue.• Improving and implementing process as per business requirement.

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 into Data Mart.• 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.• Responsible for automation and scheduling of DataStage jobs at onsite for the Production environment.• 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.• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.• 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• Created indexes on the tables for faster retrieval of the data to enhance database performance.• Leading L3 development team to deliver various project on committed date.

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.• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.• Created indexes on the tables for faster retrieval of the data to enhance database performance.• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.• Partitioned the fact tables and materialized views to enhance the performance. • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application

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 9iMajor responsibilities Existing data analysis and research. Clearing of the data in Previous System (Trichur)  Migration of the data from previous System (Oracle 7.3) to DotSoft (Oracle 9.2) Database creation for DotSoft application and Implementation of application Creating & maintaining Database Objects like Tables, Views & Indexes. Creating users, granting & monitoring user access rights & privilege through Roles. Extensive use of Stored Procedure,Trigger & Cursor. Performing Export and Import of Data / Daily Backup. Creating several Reports as per requirements by using Reports 6i. Providing interactive support in BSNL billing through DotSoft.

Master Of Computer Applications (Mca), Information Technology

Bachelor Of Infomation Technology, Computer Science