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 projects 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 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

  • Dashboard Developer&Senior BI Developer

    Info-Matrix Corporation, Camp Hill, PA - 3 years

    Project - Probation:

    • Created Caseload Dashboards for Probation officers, Supervisors and Judges.
    • Applied data level security for each viewer accessing based on the data they have permission to see.
    • Configure and manage users and groups based on API calls.
      Project: Game Commission:
    • Created Citations dashboards to identify whether the citations are created in SGL or Private property based on Tableau map layers.
    • Developed dashboards for Law Enforcement to focus actions in high wildlife crime areas to reduce complaints and crimes
    • Created dashboards to identify high-crime areas and design an appropriate law enforcement program to address the issues.

    Project: Automated Children & Youth Solution (ACYS):

    • ACYS is the IT case management solution that was approved to be used by counties for communicating with the CWIS. Over the past few years, few counties have used the ACYS system as a solution to their case management needs, and they have found it to be easy to use, intuitive and support the case work practice
    • Created Sisense scorecards and dashboards using stack bars, bar graphs, scattered plots, geographical maps and advanced widgets using Sisense-supported plugins.
    • Creating an advanced dashboard with multiple data sources using Elasticubes and live data models.
    • Created Elasticubes connecting to SQL server, Azure DevOps for creating dashboards.
    • Experience working with Sisense Blox features to bring dynamic and rich content to Dashboard.
    • Migrating all Power BI dashboards to Sisense Dashboards.
    • Configure and manage users, groups, data sources, and system settings.
    • Configure data level security based on user, group and role level.
    • Developed Power BI dashboards from multiple data sources using data blending.
    • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and massaging.
    • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

    Technologies:

    • Technologies:
    • Tableau Tableau
    • MS SQL Server MS SQL Server
    • Streamlit Streamlit
  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: Workload Dashboard

    • As a part of this initiative, DHS plans to enhance workload management tracking and efficiencies through leveraging analytics. DHS has requested four new dashboard visualizations be implemented to provide headquarters stakeholders with deeper insight into office workloads, staff performance and throughput, and work item composition details.
    • Preparing functional design documents, requirement documents & technical design documents for reports.
    • Developing a data model to create reports and dashboards.
    • Developing worksheets using parameters, calculated fields, groups, sets and hierarchies.
    • Developing worksheets with different styles like a bar, pie, treemap, dual axis, and filled maps.
    • Implementing the reports with best practices to improve the report performance.
    • Creating rich dashboards using Tableau Dashboard and applying actionable insights.
    • Implementing user-level security to restrict the data by group and user levels.
    • Publishing dashboards to tableau server and managing the security for users.
    • Preparing deployment documents and involving in production deployments.
    • Involved in full project life cycle implementation (requirement gathering to production) QlikSense dashboards.
    • Extensively worked with QlikSense functions, objects, Set Analysis, and Variables to generate different kinds of charts.
    • Assisted in performing Qliksense applications for faster data reloads and efficient response times.
    • Created dashboards using Qliksense extension objects.

    Technologies:

    • Technologies:
    • Tableau Tableau
    • Cognos
    • MS SQL Server MS SQL Server
    • Oracle Oracle
    • Qlik View Qlik View
    • Qlik Sense Qlik Sense
  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: Income Eligibility:

    • The Office of Income Maintenance (OIM) currently requests manual reports on an ad hoc basis to support their income reporting needs. To automate the income reporting process and build additional income data transparency, the OIM has requested the ‘Income Eligibility Data in the EDW’ initiative.
    • Developed List, Cross tab, drill through, master-detail, chart and complex reports, which involved multiple prompts in Report Studio.
    • Developed reports using Conditional formatting, cascading prompts, optional prompts and report bursting.
    • Customized reports using HTML and Java Scripts.
    • Created Database Layer, Intermediate layer and Presentation Layer, defining the appropriate relationship between query subjects and Fact Table in Framework Manager.
    • Developed Scorecards using Metric Studio with the use of Indicators.
    • Involved in defining Relationships and Cardinality between query subjects; built models containing query subjects, query items, and namespaces from scratch and imported metadata in Framework manager.

    Technologies:

    • Technologies:
    • Microsoft PowerBI Microsoft PowerBI
    • Tableau Tableau
    • Cognos
    • Qlik View Qlik View
    • Qlik Sense Qlik Sense
  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: Department of Human Services Phase I and II:

    • Developed Tableau workbooks from multiple data sources using Data Blending.
    • Planned an approach for documenting, categorizing and packaging the requirements.
    • Delivered advanced/complex reporting solutions such as Dashboards and Standardized reporting using Qlikview and Qlik Sense.
    • Enable the features requested by the clients and make them understand the new features.
    • Extensively worked with QlikSense functions, objects, Set Analysis, and Variables to generate different kinds of charts.
    • Generated QVD files by writing scripts in Qlik Sense applications. Also created automated QVD files in Qlik Sense.
    • Created Dashboards with different styles using Qlikview components like List Box, Slider, Buttons, charts and Bookmarks.
    • Trained users to build their apps in QlikSense.
    • Developed Linked Tabl. and Concatenation and solved the loops issues.
    • Created different sheet objects like List boxes, Buttons, and Multibox.
    • Sound knowledge of various functions of QlikView and Qlik Sense technologies.
    • Implemented the Best Practices for optimizing the Tableau report performance and data extract refresh

    Technologies:

    • Technologies:
    • Microsoft PowerBI Microsoft PowerBI
    • Tableau Tableau
    • Cognos
    • MS SQL Server MS SQL Server
    • Oracle Oracle
    • Qlik View Qlik View
    • Qlik Sense Qlik Sense
  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: CAPS Migration and Enhanced DW Reporting:

    • The CHIP and adultBasic Processing System (CAPS) integrates application processing and maintenance for the CHIP and adultBasic programs under a single management environment. The Pennsylvania Insurance Department (PID) contracts companies providing CHIP and adultBasic coverage.
    • The implementation of CAPS results from PID’s initiative to design and develop an integrated system that can be used by all contracted CHIP and adultBasic insurance providers.
    • Enhanced DW reporting helps the Pennsylvania Insurance Department automate the delivery of key program metrics required by State and Federal govt to those needed for the ongoing stability of the CHIP Program.
    • Migrated the Cognos 7.4 Catalog to Cognos reports 10.2.
    • Migrated Power Play cubes into Cognos 10 BI and participated in regression testing.
    • Set up drill through connections between cubes and reports.
    • Created complex dashboards from scratch to match the Visualizer.
    • Worked on bug fixing and enhancements to existing reports in report studio and models in framework manager.
    • Created complex Reports having Calculations, Master Detail Reports, Conditional Formatting, Joins and Query sets.
    • Automating Cube Build in IBM Cognos Transformer 10

    Technologies:

    • Technologies:
    • Microsoft PowerBI Microsoft PowerBI
    • Tableau Tableau
    • Cognos
    • MS SQL Server MS SQL Server
    • Oracle Oracle
    • Qlik View Qlik View
    • Qlik Sense Qlik Sense
  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: Healthy PA:

    • Healthy PA initiative is to increase Access to quality, affordable health care for PA citizens. To help achieve this goal, Healthy PA stakeholders have identified the need for enhanced reporting and analytics capabilities. The Reporting and Analytics thread will enable HPA stakeholders access to additional data to answer critical business questions, monitor/ track key performance indicators, and gain additional transparency into health care operations.
    • Involved in requirements gathering, report design, report development, and support of all client/server layers and components of the data warehouse.
    • Created Complex Reports using various Calculations and drilled through in Report Studio.
    • Implemented the user-level Security based on their type and level of Access.
    • Set up the Cube schedules in the Production Environment.
    • Set up the Drill through path for the Packages.
    • Provided Support for the Servers in Production, Staging and Development.
    • Created the Cubes, Dashboards for Different Departments and Customized the Reports.
    • Optimized the Performance of the Reports at the Report level and the Model level.
    • Created complex Reports having Calculations, Master Detail Reports, Conditional Formatting, Static Documents, Joins and Query sets.
    • Created Events and Jobs and set up the Schedules.
    • Build models/packages in Framework Manager to support canned and ad-hoc Reporting.

    Technologies:

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

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: CCMIS/Pelican Project for PA DPW:

    • The Office of Child Development and Early Learning’s (OCDEL) process ensures that the Early Intervention (EI) programs comply with Federal and State reporting policies and guidelines managed by the Early Intervention Reporting System (EIRS). EIRS is a data management system used to collect, update, retrieve and aggregate data for statistical reporting to improve reporting efforts. OCDEL has asked Deloitte to produce automated testing reports from PELICAN EI that track issues critical to the Early Intervention Program.
    • Analyzing and implementing the changes required for all the data warehouse PCRs
    • Extensively involved with Cognos Support regarding requirements and engagement issues.
    • Writing validation scripts for validatiPCR’sR’s
    • Created Cognos packages by using Framework Manager.
    • Published PowerPlay Cubes onto Cognos Connection by using Cognos 8 BI Modeling.
    • Performed Unit Testing for all reports, cubes and packages.
    • Writing queries based on client requirements.
    • Troubleshooting Cognos 8 Report Data & formatting issues.
    • Modified Power Cubes by adding new Dimensions, Levels and Measures.
    • Resolved issues that the client faced in Report Studio and PowerPlay Cubes.
    • Involved in Migration of existing Cognos series seven cubes to Cognos 8.4.1
    • Created SRs for monthly Landcare report.
    • Worked extensively with complex mappings using expressions, Routers, Lookups, source qualifiers, and aggregators.
    • Writing queries to validate data against data warehouse and application.
    • Created Ad-hoc reports using Query Studio and complexpiecess using Report Studio.
    • Developed 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

    Project: ACA and Executive Dashboard Phase 2, 3,4,5,6:

    • ACA aims to increase the quality and affordability of health insurance, lower the uninsured rate by expanding public and private insurance coverage and reduce health care costs for individuals and the government.
    • The Executive Dashboard project aim is to provide the Secretary of DPW and his deputy secretaries a snapshot of trends on critical metrics like enrollments, expenditure and revenue for crucial programs and a summary of performance on the key operational metrics in DPW.
    • Worked on the Active Reports to provide the interactive behaviour outputs to the users. Created tabbed
      reporting with complex calculations/formatting.
    • Involved in Designing and creating various models and Publishing packages in Framework Manager.
    • Created data level, object level and package level security in Framework Manager.
    • Created the Framework manager model using the Model Accelerator to bring up a perfect Star Schema.
    • Trained business users in the Ad-Hoc Components like Business Insight & Business Insight Advanced.
    • Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source.
    • Identified various dimensions and measures required for the generation of a cube.
    • Developed various Adhoc report types ranging from simple lists, crosstab, and charts to complex dashboards, drill-through, Master-Detail and Conditional formatting reports.
    • Developed advanced reports using Report Studio.
    • Created Complex, multipage reports involving prompts, Cascading prompts, Conditional rendering and Conditional formatting.
    • Created custom prompted reports in Report Studio, Bursting reports to different user groups

    Technologies:

    • Technologies:
    • Cognos
  • Senior BI Developer

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: Home and Community Services Information Systems (HCSIS):

    • The Commonwealth of Pennsylvania is implementing a significant Home & Community Services Information System initiative. HCSIS is a web-enabled information management system that allows DPW (Department of Public Welfare) program offices to manage public benefits programs in a standardized way statewide. HCSIS has different program offices like OCDEL (Office of Child Development and Early Learning), Office of Mental Retardation (OMR), Bureau of Autism Services Pennsylvania (BAS) and Office of Developmental Programs (ODP), which provide the services at the county level. An enterprise data warehouse is built for PA to generate reports for prior approval of the budget.
    • Created complex Dashboards using Bar charts, Pie Charts, Cross tab, List Reports, and Multi prompts, allowing the data to filter at the State and County levels.
    • Applied data level Security in framework manager by controlling privileges for users, groups and roles to the various reports & dashboards.
    • Involved in designing ad hoc packages which give OCDEL access to flexible reporting through the ability to run ad hoc data queries.
    • Created cubes which enable OCDEL users to view/analyze aggregate counts related to critical program dimensions.
    • Involved in designing dashboards which allow users to compare their program performance versus the overall state performance.
    • Carried out UAT by developing test scenarios, test cases, and test data for testing based on business and user requirements.
    • Created dashboards which enable OCDEL users to view/analyze monitoring and exception information.
    • These dashboards put pertinent business metrics on one page instead of multiple reports, allowing users to drill through to a detailed description.
    • Deployed packages, folders and Reports from a development environment to a Testing environment
    • Check bugs and problems, diagnose and fix them.

    Technologies:

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

    Deloitte Consulting, Camp Hill PA - 9 years 2 months

    Project: Department of Human Services Phase I and II:

    • These services include eligibility and benefits determination, foster care, juvenile justice, early childhood development, services for persons with developmental disabilities, autism services, long-term living programs, Management of state psychiatric hospitals, and Management of the Medical Assistance physical and behavioural health care programs:
    • Published the dashboard reports to Tableau Server for navigating the developed dashboards on the web.
    • Created Tableau scorecards and dashboards using stack bars, bar graphs, scattered plots, and geographical maps using show me functionality.
    • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
    • Restricted data for particular users using Row-level security and User filters.
    • Developed 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:

    • Ad Hoc Self-Service reporting will improve reporting efficiency and timeliness by allowing the Office of CHIP to create reports and queries. Increased flexibility and data discovery by allowing the Office of CHIP stakeholders to develop and apply user-defined filters and measures.
    • Implementation of Framework Manager Model in Cognos 10.2.2.
    • Creation of Database, Abstraction, Alias, and Presentation layers.
    • Defining appropriate relationships between the tables
    • Creation of Model Query Subjects, Embedded and Model Filters.
    • Creation of 1600 + data elements, including (Query Items, Filters, and Measures)
    • Developed FM Model against STAR and SNOWFLAKE Data Models.
    • Creation of Packages and publishing the same.
    • Performed Data Validations, Unit testing and prepared Test cases.

    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.