Ranjan Kumar

Ranjan kumar

bookmark on deepenrich
location of Ranjan KumarPune, Maharashtra, India
Followers of Ranjan Kumar384 followers
  • Timeline

  • About me

    Director - CFO Data & Analytics

  • Education

    • Sri venkateshwara college, delhi university

      1997 - 2000
      B sc
    • National institute of information technology

      1998 - 2001
      Dniit software engineering, dbms, ms-office, vb programming
  • Experience

    • Ibm

      Jul 2004 - Aug 2006
      Lead - opcg
    • Infosys

      Sept 2006 - Jul 2007
      Team leader - mis
    • Patni computer system

      Jul 2007 - May 2009
      Assistant manager
    • Mercer

      Jun 2009 - Aug 2010
      Team manager

      Responsible for leading the Business Intelligence and Operations Reporting team for Employee Healthcare Benefits divisions of the group. - Established a high performing cross-functional Reporting team of 10 analysts from the scratch with varied technical and business skill sets that provided MI services to senior stakeholders. - Designed multiple transition plans for agreed scope of scope and executed it to bring in lot of Reporting work to offshore India unit. It included travel to US as well.- Executed successfully lot of automation projects that brought in efficiencies and process improvements across different Lines of Businesses. Show less

    • Hcl infosystems ltd

      Aug 2010 - Oct 2011
      Senior technical lead - business intelligence

      Responsible for maintenance of Decision Support System (DSS) at PAN India level (4 zones and Central Head Quarter in Delhi) for one of the leading Telecom operator in India. Multiple technologies like Cognos, Informatica PowerCenter, SPSS, Oracle and Shell scripts were used to create and deliver very complex reports (like TRAI) and business revenue models within DSS.- Led a team of 6 technical experts skilled to handle different aspects/ technologies of the solution.- Worked for 2 months on UIDAI project and delivered a high level technical architecture (using all Open Source technologies) for HCL's pre-sales bid for UIDAI (Aadhar). Show less

    • Barclays

      Oct 2011 - Jan 2022

      Responsible for consolidation and management of group level Controls data that enables all the critical MI and reporting that goes upto regulators.- Successfully led and delivered a very complex data integration project to create a single golden source for all issues within the Bank.- Delivered an automated solution to streamline and consolidate critical and non-standard Executive level reports into one single Standard PowerPoint deck which enabled Controls team to realise huge efficiency gains of 5 FTEs. Show less Responsible to plan strategically and manage the BI solutions portfolio / roadmap for Procurement. - Shortlisted and implemented BI tools based on Procurement MI / Dashboarding user stories. This included development of dashboards mainly using QlikView and Tableau- Continuously engaged with Senior leaders / Management Team / stakeholders within Procurement to showcase new MI / BI developments, capture their feedback and further seek ways to improve and enhance existing MI & reporting processes.- Delivered many automated solutions to improve team’s productivity, enhance controls and gain efficiencies- Developed and launched Procurement’s MI Portal using SharePoint that enabled global access to self-serve tools and effective usage tracking to reduce MI production workload Show less

      • Vice President - MI & Reporting (Controls)

        Dec 2017 - Jan 2022
      • Associate Vice President - BI & Data Manager (Procurement)

        Oct 2011 - Dec 2017
    • Ubs

      Jan 2022 - now
      Director
  • Licenses & Certifications