profile-pic

Vijay Kumar Dhiraj

BI Architect with 15+ years of experience in analysis, design, development and implementation of various business applications mainly in BFSI domain. Experience in all stages of the development life cycles. Strong ability to investigate, analyzes, design, and deliver SaaS/Power BI applications. Substantial management reporting, business intelligence development experience: over seven years. Architecture design/E2E implementation of BI and reporting solution. Effective translation of business requirements into functional specifications. Strong administration knowledge of QlikView, QlikSense and nPrinting servers. Worked with support to monitor report scheduling, log files and also participated in bug finding and fixing. Adept at working in a diverse team setting and collaborating across functions and geographies. Strong investigative and troubleshooting skills. History of working in close association with business owners, serving as the single point of contact for numerous major implementation projects.
  • Role

    Data Science & Qlikview Developer

  • Years of Experience

    20 years

Skillsets

  • SQL - 10 Years
  • PowerBI - 1 Years
  • Reporting - 10 Years
  • Tableau - 1 Years

Professional Summary

20Years
  • Dec, 2021 - Present4 yr

    Sr. Consultant (QlikView/QlikSense)

    Icon Resources Pvt. Ltd.
  • Jul, 2018 - Nov, 20202 yr 4 months

    Consultant (QlikView/QlikSense)

    Oxydata Systems
  • Apr, 2016 - Dec, 2016 8 months

    Architect (QlikView/QlikSense)

    Lazada Group
  • May, 2008 - Dec, 20091 yr 7 months

    Sr. Software Engineer Alternate Investment

    Credit Suisse (Ness Technologies)
  • Jan, 2010 - Jul, 20144 yr 6 months

    Lead QlikView Developer

    Barclays
  • Jan, 2015 - Jul, 2015 6 months

    Lead QlikView Developer/Architect

    Citi Bank
  • Nov, 2007 - May, 2008 6 months

    Sr. Analyst Marketing Division

    Bank of America
  • Dec, 2006 - Oct, 2007 10 months

    Technical Lead

    FCS Ltd.
  • Dec, 2003 - Nov, 20062 yr 11 months

    Team Lead

    Visnova Software Solution Pvt. Ltd.

Applications & Tools Known

  • icon-tool

    QlikView

  • icon-tool

    QlikSense

  • icon-tool

    Crystal Reports

  • icon-tool

    ASP.NET

  • icon-tool

    C#

  • icon-tool

    VB.NET

  • icon-tool

    Azure Data Factory

  • icon-tool

    SQL Server

  • icon-tool

    Oracle

  • icon-tool

    Teradata

  • icon-tool

    Netezza

  • icon-tool

    MangoDB

  • icon-tool

    SAP

  • icon-tool

    Team Foundation Server

  • icon-tool

    HTML

  • icon-tool

    CSS

  • icon-tool

    Web Services

Work History

20Years

Sr. Consultant (QlikView/QlikSense)

Icon Resources Pvt. Ltd.
Dec, 2021 - Present4 yr
    Architecture Replicate/QlikSense SaaS and Power BI projects. Build/support applications for different clients (Daikin, Ricoh, ABPS, Samsung, Hoya, SLA, CRA). Worked directly with business units to define and prototype QlikView/QlikSense, Replicate Applications. Transformed data from different sources like Excel, SqlServer, SAP, and integrate these and built Dashboard.

Consultant (QlikView/QlikSense)

Oxydata Systems
Jul, 2018 - Nov, 20202 yr 4 months
    Helped client to migrate QlikView to Tableau. Helped Tableau developers to understand QlikView applications. Documented all business logic of QlikView applications. Worked directly with business units to understand QlikView/QlikSense Applications.

Architect (QlikView/QlikSense)

Lazada Group
Apr, 2016 - Dec, 2016 8 months
    Managed QlikView/QlikSense infrastructure efficiently. Involved in decommissioning of excel based reports and migration in QlikView/QlikSense. Built applications for Operation team in QlikView/QlikSense. Worked directly with business units to define and prototype QlikView/QlikSense Applications. Transformed data from different sources like Excel, Sales force, Oracle, and integrate these and built Dashboard.

Lead QlikView Developer/Architect

Citi Bank
Jan, 2015 - Jul, 2015 6 months
    Involved in gathering and analyzing business requirements. Wired the existing dashboard with Netezza database. Involved in decommissioning of excel based reports and migration in QlikView. Coordinated UAT and participated in related activities. Worked as Global point of contact for QlikView/QlikSense applications for QlikView/QlikSense development. Documented process flows and design documents for all available application. Participated in every aspect of SDLC like developing, testing, packaging and deployment. Transformed data from different sources like Excel, CRM, SAP, Netezza, and others integrate these and built Dashboard.

Lead QlikView Developer

Barclays
Jan, 2010 - Jul, 20144 yr 6 months
    Built seven Dashboards for different teams like sales, marketing, trading and trade confirmation teams. Analyzed business requirements to all on boarded applications. Worked as a Global point of contact for QlikView applications for FX domain. Monitored the FX QlikView server infrastructure. Documented process flow and design documents for all available application. Participated in every aspect of SDLC like developing, testing, packaging and deployment. Utilize .NET component to deliver some regulatory report as PPT/Excel. Transformed data from different sources like Devon, Murex, BARX, Summit, Teradata and others integrate these and built Dashboard. Worked on enhancements and Performance tuning on existing dashboards. Provided user meetings and training on QlikView Dashboard functionalities. Managed QlikView Server infrastructure, CALS and licensing.

Sr. Software Engineer Alternate Investment

Credit Suisse (Ness Technologies)
May, 2008 - Dec, 20091 yr 7 months
    Worked as Ness consultant and interacted with the end users for new requirements. Involved in UML design (use case preparation, Sequence Diagram preparation, Class Diagram preparation), optimization of codes per the coding standards. Key responsibilities included writing C# Web and desktop utilities to automate the PB clients detailed reports to be sent to a 3rd party print repository. Developed reports using SSRS and deployed on the reporting server. Developed, maintained, scheduled and troubleshoot the SSIS packages to move heavy static and trade data from data warehouse to the client database. Database design and resolved technical design issues and facilitated to independent unit/integration testing. Used Infragistics controls to build this application (date, edit, currency and tab control). Used the test driven development approach in this application. Migrated all of the reports from Crystal Report to SSRS.

Sr. Analyst Marketing Division

Bank of America
Nov, 2007 - May, 2008 6 months
    Involved in understanding user requirements, designing and developing the system. Involved in UML design (use case preparation, sequence diagram preparation, class diagram preparation), Optimization of Code as per Coding standard. Interacted with business analysts and worked on the application specifications, analysis. Implemented .NET framework employing Object Oriented (OO) Concepts, UML, and application was developed as consisting of UI Layer, Business Layer and Data Layers. Developed ASP.NET pages in Visual Studio.NET 2008, XML, and C #, HTML, CSS and JavaScript. Used Infragistics controls to build this application (Web Combo, Date, and Web Grid Control). Used LINQ to SQL in Database Layer creation. Wrote business objects, custom controls and user controls in ASP.NET and C#.

Technical Lead

FCS Ltd.
Dec, 2006 - Oct, 2007 10 months
    Worked as a Microsoft developer and also involved in QA and testing. Major developments concentrated in business and data layers. Working hands on in Microsoft technologies like ASP.Net using C#, Web Services, Win Forms using C#, SOAP, ADO.Net and Crystal reports.

Team Lead

Visnova Software Solution Pvt. Ltd.
Dec, 2003 - Nov, 20062 yr 11 months
    Participated and lead the team of developers for the development of HRMS ERP for the USA clients and also participated in coding of the complete life cycle of employee life cycle management. Worked, designed and implemented best practices of SDLC. Job responsibilities include analysis, development and implementation in Microsoft .Net Platform.

Major Projects

9Projects

Sr. Consultant (QlikView/QlikSense)

Dec, 2021 - Present4 yr
    Icon Resources empower businesses in their digital transformation journey by harnessing next-generation technologies across Business Analytics and Enterprise Performance Management. Architecture Replicate/QlikSense SaaS and Power BI projects. Build/support applications for different clients (Daikin, Ricoh, ABPS, Samsung, Hoya, SLA, CRA). Worked directly with business units to define and prototype QlikView/QlikSense, Replicate Applications Transformed data from different sources like Excel, SqlServer, SAP, and integrate these and built Dashboard. Environment: QlikView, QlikSense, Replicate, Power BI VBScript, SqlServer, Oracle, nPrinting

Consultant (QlikView/QlikSense)

Jul, 2018 - Nov, 20202 yr 4 months
    Oxydata Systems provides value-based information technology services, across Enterprise to Custom Application and Specialized Services of Testing, Analytics and CRM. I was helping client to migrate QlikView to Tableau Helped Tableau developers to understand QlikView applications. Documented all business logic of QlikView applications Worked directly with business units to understand QlikView/QlikSense Applications Environment: QlikView, QlikSense, VBScript, SqlServer, Oracle

Architect (QlikView/QlikSense)

Apr, 2016 - Dec, 2016 8 months
    Lazada is one of the fastest-growing e-commerce companies in the South-East Asia region. It has operation in Thailand, Singapore, Malaysia, Philippines, Indonesia and Vietnam. Recently Alibaba group has bought 50% stack in this company. Managed QlikView/QlikSense infrastructure efficiently. Involved in decommissioning of excel based reports and migration in QlikView/QlikSense. Built applications for Operation team in QlikView/QlikSense Worked directly with business units to define and prototype QlikView/QlikSense Applications Transformed data from different sources like Excel, Sales force, Oracle, and integrate these and built Dashboard. Environment: QlikView, QlikSense, Excel, Sales force, Oracle, QlikView Extension Object, VBScript

Lead QlikView Developer/Architect

Jan, 2015 - Jul, 2015 6 months
    Citi is todays pre-eminent financial services company and was built to create a highly diversified financial services company that could act as one to deliver solutions to clients throughout the world. Citi works tirelessly to provide consumers, corporations, governments and institutions with a broad range of financial services and products. Citi strive to create the best outcomes for their clients and customers with financial ingenuity that leads to solutions that are simple, creative and responsible. Involved in gathering and analyzing business requirements. Wired the existing dashboard with Netezza database. Involved in decommissioning of excel based reports and migration in QlikView. Coordinated UAT and participated in related activities. Worked as Global point of contact for QlikView/QlikSense applications for QlikView/QlikSense development. Documented process flows and design documents for all available application. Participated in every aspect of SDLC like developing, testing, packaging and deployment. Transformed data from different sources like Excel, CRM, SAP, Netezza, and others integrate these and built Dashboard. Environment: QlikView, QlikSense, SQL server, Netezza, CRM, Oracle, Excel, SAP, nPrinting, Google Map, Microsoft Team Foundation, QlikView Extension Object, VBScript

Lead QlikView Developer

Jan, 2010 - Jul, 20144 yr 6 months
    Barclays is a British multinational banking and financial services company headquartered in London. It is a universal bank with operations in retail, wholesale and investment banking, as well as wealth management, mortgage lending and credit cards. It has operations in over 50 countries and territories and has around 48 million customers as of now Barclays is the seventh largest of any bank worldwide. Built seven Dashboards for different teams like sales, marketing, trading and trade confirmation teams. Analyzed business requirements to all on boarded applications. Worked as a Global point of contact for QlikView applications for FX domain. Monitored the FX QlikView server infrastructure. Documented process flow and design documents for all available application. Participated in every aspect of SDLC like developing, testing, packaging and deployment. Utilize .NET component to deliver some regulatory report as PPT/Excel. Transformed data from different sources like Devon, Murex, BARX, Summit, Teradata and others integrate these and built Dashboard. Worked on enhancements and Performance tuning on existing dashboards. Provided user meetings and training on QlikView Dashboard functionalities. Managed QlikView Server infrastructure, CALS and licensing. Environment: QlikView, SQL server, BARX, SUMMIT, Murex, Devon, Oracle, Excel, Teradata, nPrinting, Google Map, QlikView Extension Object, VBScript

Sr. Software Engineer

May, 2008 - Dec, 20091 yr 7 months
    Credit Suisse Group is a Switzerland-based multinational financial services holding company, headquartered in Zrich that operates the Credit Suisse Bank and other financial services investments. The company is organized as a stock corporation with four divisions; investment banking, private banking, asset management and a shared services group that provides marketing and support to the other three divisions. Worked as Ness consultant and interacted with the end users for new requirements. Involved in UML design (use case preparation, Sequence Diagram preparation, Class Diagram preparation), optimization of codes per the coding standards. Key responsibilities included writing C# Web and desktop utilities to automate the PB clients detailed reports to be sent to a 3rd party print repository Developed reports using SSRS and deployed on the reporting server. Developed, maintained, scheduled and troubleshoot the SSIS packages to move heavy static and trade data from data warehouse to the client database. Database design and resolved technical design issues and facilitated to independent unit/integration testing. Used Infragistics controls to build this application (date, edit, currency and tab control). Used the test driven development approach in this application. Migrated all of the reports from Crystal Report to SSRS Environment: ASP.NET, C#, MS SQL Server, WCF,Entity Framework, Crystal Report, Sqlserver Reporting services, SqlServer integration Services, Infragistics, HTML, CSS, JQuery and CVS.

Sr. Analyst

Nov, 2007 - May, 2008 6 months
    Bank of America (abbreviated as BofA) is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets. Involved in understanding user requirements, designing and developing the system. Involved in UML design (use case preparation, sequence diagram preparation, class diagram preparation), Optimization of Code as per Coding standard. Interacted with business analysts and worked on the application specifications, analysis. Implemented .NET framework employing Object Oriented (OO) Concepts, UML, and application was developed as consisting of UI Layer, Business Layer and Data Layers. Developed ASP.NET pages in Visual Studio.NET 2008, XML, and C #, HTML, CSS and JavaScript. Used Infragistics controls to build this application (Web Combo, Date, and Web Grid Control). Used LINQ to SQL in Database Layer creation. Wrote business objects, custom controls and user controls in ASP.NET and C#. Environment: ASP, ASP.NET, C#, MS SQL Server, HTML, LINQ, CSS, JavaScript, Crystal Report,SVN

Technical Lead

Dec, 2006 - Oct, 2007 10 months
    FCS Software Solutions is a leading provider of IT services. In the past one decade of its existence, FCS has carved out a niche for itself in core IT areas like e-learning, digital content services, IT consultancy and product engineering services. The development offshore center in India that caters to a global clientele prides in state-of-the art facilities and a competent workforce consisting of programmers, IDs, visualizers, e-learning experts, writers and editors who have worked extensively in the areas of e-learning, product training, sales training, support services, performance and collaboration for several Fortune 500 companies. Worked as a Microsoft developer and also involved in QA and testing. Major developments concentrated in business and data layers. Working hands on in Microsoft technologies like ASP.Net using C#, Web Services, Win Forms using C#, SOAP, ADO.Net and Crystal reports. Environment: ASP.NET, C#, MS SQL Server, ADO.NET, WCF, SOAP,Web Services, Microsoft Test Suite, Microsoft Team Foundation, Crystal Reports

Team Lead

Dec, 2003 - Nov, 20062 yr 11 months
    Visnova Solutions Pvt. Ltd. is a leading ERP consulting and implementation company, specializing in software solutions for small and mid-sized businesses. Headquartered in the national capital region, it is the largest SAP business partner in India for the SAP Business One solution. In addition to SAP Business One, Visnova is a partner to Microsoft for MS Dynamics Navision and Ramco for Ramco on Demand Solution. Participated and lead the team of developers for the development of HRMS ERP for the USA clients and also participated in coding of the complete life cycle of employee life cycle management. Worked, designed and implemented best practices of SDLC. Job responsibilities include analysis, development and implementation in Microsoft .Net Platform Environment: Visual Basic, Unisys, MS Access, MS SQL Server, Crystal Reports, MS Navision.

Education

  • Master in Computer Application

    IGNOU, New Delhi India
  • Professional Diploma in Software Management

    NIIT, New Delhi India

Certifications

  • Microsoft certified professional

  • Scrum master from international scrum institute