Janardan Mishra

Experience

• 

  ABM Infotech Ltd

  Mar 2005 - Nov 2007

  Tech Support Engineer

  • Install the software at client end after completing the development and testing• Software support after sale. And product testing• Give training to the customer after product sale

• 

  MPS Software Pvt. Limited

  Nov 2007 - Sept 2010

  Quality Engineer

  • Gathering Requirements, Communication with client and convey the client’s requirements to the development team• Check the system at client end and report to senior• Make implementation of code as per client requirement• User Manual document creation, involve in database design• Deploy the system at client side and update by time to time• Involve in design of physical database, data modeling• Creating backup copies of data • Generated reports from the database using PL/SQL and SQL Show less

• 

  GST IT Services Pvt Ltd (Groupsoft)

  Sept 2010 - Sept 2012

  Integration Test Engr.

  • Responsible for data movement from ERP / SAP BI to GrMAP (SQL Server 2008) and vice versa. Verify these data in the sense of feasibility with GrMAP• Validate the transformation, transformation mapping, and data volume• Check performance in data transformation, apply data cleansing• Generate reports from the database using PL/SQL and SSRS (SQL Server Reporting Services)• Backup, Restore of database from one location to other location• Export, Import the data from SQL to other sources such as excel, CSV etc.• Execute database script time to time for database updating Show less

• 

  Ujala Credit Co-operative Society Limited,(UCCSL)

  Jan 2014 - Jul 2022

  Sr. Manger-MIS

  Ujala Credit Co-operative Society Ltd (Jan 2014 - Present): As Sr. Manager-MIS Project Title: Sahakaar (Deposit and Loan Module)Project Title: BIJLI (Business Information Justified and Logically Integrated)Project Title: eFIMO (Loan and CBS)Roles & Responsibilities:• Get the Sahakaar/BIJLI/eFIMO implemented as per business and management requirement. Understand the business flow and coordinate with software vendor to integrate the requirement • Work with business units to get designed and developed solutions to key business problems. Responsible for preparation & maintenance of the MIS Reports on Daily, Weekly, & Monthly metrics• Providing information in a concise and simple way to Senior Management and the wider audience • Analysis of raw data to identify new performance metrics - Weekly & Monthly Quality analysis of the process• Data Analysis and Visualization using Power Pivot, Power BI and Tableau• Coordination with Branch official/RO official and capacitating them on Application• Provide necessary developmental and implementation utility for end business working units such as Branches, Regional Offices, Zonal Offices• Reporting to Top Management, design and implement reports as required by Management information needs.• Preparation of various reports like daily & weekly status reports, providing various Monthly status reports other ad hoc requests for the senior management • Understand requirements, design formats, deploy formats, follow up with Business Development Team for smooth operation• SQL Server backup and maintenance• Configure IIS to run web application smoothly and perform maintenance of IIS• Across the department coordination regarding system to resolve the issue• Team coordination to resolve the issue• Give some records through SQL query to concern which is not available in system OR if system having issue• Involve in data migration from existing system to other system Show less

• 

  DishTV

  Jul 2022 - now

  Lead-Analytics

  DescriptionDishTV is the Asia's largest Direct to Home Entertainment Company and India’s most trusted DTH brand. Furthermore, the innovative offerings and revolutionary features of DishTV have earned it a prestigious place of being World’s Eminent DTH company. Consistent with such objective, every initiative and every technological innovation at DishTV is driven with an effort to provide its customers the best possible services with a strict adherence to quality.Roles & Responsibilities:• SSRS Report designing and deployment for report automation in Email and Shared Path triggered at scheduled time• Exploratory Data Analysis using Python• Churn Analysis using Python (most common Library used such as Pandas, Numpy, Matplotlib, Seaborn and Scikit Learn)• Create Insights from data to take the appropriate decisions by management• Data movement within SQL Servers using SSIS, “Import and Export Data Tool” for the purpose of data preparation used in reporting. Verify these data in the sense of feasibility of required data format• Data Analysis and Visualization using Power Pivot, Power BI and SSRS• Preparation of various reports like daily, weekly status reports, providing various Monthly status reports and other ad hoc reports requested by senior management • Team coordination to resolve the issue Show less