Nikhil K.

Data Engineer& BI Consultant

Data engineering guru with 11+ years of experience.

A strong individual contributor with hands-on experience in multiple BI reporting tools, including Cognos, Tableau, QlikView/Sense, Sisense, and Power BI.

Nikhil is proficient in using the SDLC methodology to deliver Business Intelligence engagements through requirements gathering, scope definition, development, testing, and implementation.

Throughout his career, he has created advanced complex reporting solutions such as Dashboards, Reports, and Cubes.

Main expertise

  • Cognos 11 years
  • MS SQL Server MS SQL Server 11 years
  • Data Engineering 11 years

Other skills

  • Data & Analytics 11 years
  • Data Modeling 11 years
  • ETL ETL 11 years
Nikhil

Nikhil K.

29.00 € hourly

United States

Book Nikhil K.

Selected experience

Employment

  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: CCMIS/Pelican Project for PA DPW:

    • Analyzing and implementing the changes required for all the data warehouse PCRs;
    • Working extensively with Cognos Support regarding requirements and engagement issues;
    • Writing validation scripts for PCR’sR’s;
    • Creating Cognos packages;
    • Troubleshooting Cognos 8 report data & formatting issues.
    • Modifying Power Cubes by adding new dimensions, levels, and measures.
    • Migrating existing Cognos series 7 cubes to Cognos 8.4.1;
    • Creating SRs for monthly Landcare report;
    • Working extensively with complex mappings using expressions, Routers, Lookups, source qualifiers, and aggregators;
    • Creating ad-hoc reports using Query Studio and complex pieces using Report Studio;
    • Developing the Cognos Impromptu query definition (.iqd) files that will feed Cognos cubes.

    Technologies:

    • Technologies:
    • Tableau Tableau
    • Cognos
  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    • Creating data level, object level and package level security in Framework Manager;
    • Creating the Framework manager model using the Model Accelerator to bring up a perfect Star Schema;
    • Building DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source;
    • Developing various Adhoc report types and trained business users in Ad-Hoc Components, such as Business Insight & Business Insight Advanced.

    Technologies:

    • Technologies:
    • Cognos
  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: Department of Human Services Phase I and II:

    • Creating Tableau scorecards and dashboards;
    • Creating action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
    • Developing Tableau visualizations and dashboards using Tableau Desktop.

    Technologies:

    • Technologies:
    • Tableau Tableau
    • Cognos
    • Qlik Sense Qlik Sense
  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: CAPS Ad Hoc Self-Service Reporting:

    • Implementing the Framework Manager Model in Cognos 10.2.2;
    • Creating Database, Abstraction, Alias, and Presentation layers;
    • Creating Model Query Subjects, Embedded and Model Filters;
    • Creating of 1600 + data elements, including (Query Items, Filters, and Measures);
    • Developing FM Model against STAR and SNOWFLAKE data models.

    Technologies:

    • Technologies:
    • Cognos

Education

  • MSc.Electrical

    McNeese State University (Lake Charles, LA) · 2008 - 2009

  • BSc.Electrical

    JNT University (Hyderabad, India) · 2003 - 2007

Find your next developer within days, not months

We can help you deliver your product faster with an experienced remote developer. All from 32.90 €/hour. Only pay if you’re happy with your first week.

In a short 25-minute call, we would like to:

  • Understand your development needs
  • Explain our process to match you with qualified, vetted developers from our network
  • Share next steps to finding the right match, often within less than a week

Not sure where to start?

Let’s have a chat

First developer starts within days. No aggressive sales pitch.