Summary
Overview
Work History
Education
Skills
Certification
Hobbies and Interests
Disclaimer
International exposure
Timeline
Generic

Nimish Jain

Gurgaon

Summary

Having 6.5 years of Power BI and Total 15 years of experience in Requirement Gathering, Data Analysis, Data Modelling and Reporting as a Technical Solution Architect Experience in developing end to end Power BI solutions starting from Transforming data using Power Query, Modelling the data into Facts and dimensions, writing complex DAX logics and visualizing the data using various visuals. Experience in cleaning and transforming data in Power Query using various functions like Split, Extract, Format, Merge and Append, Duplicate and Reference and Basics of M code Extensive experience in Modelling data in Power BI like configuring Active Inactive Relationships, BI-Directional Relationships, Many to Many Relationships, Composite models, Handling Star and Snowflake schemas, Date Dimension creation, Aggregate Tables, configuring Row Level Security Extensive experience in writing complex business logics using DAX and performing various Time Intelligence based calculations among others. Configuring Buttons, Alerts, Hierarchies, Creating Drill Down and Drill through reports, Bookmarks, Grouping, Binning, Tooltips, Filtering data Data Story Telling by using various Built in and custom visuals like Bar Charts, Column Charts, Ribbon Charts, Stacked Charts, Tables, Matrix, Slicer, Map, PDF viewer, HTML Content Viewer. Experience in various Data Warehousing concepts like Star, Snowflake Schema, Types of Facts and Dimensions, OLTP and OLAP. Extensively worked on tuning the SQL query performance, experience in troubleshooting complex SQL Queries and improving the data delivery performance Experience in Metadata Modeling at all the three layers (Physical, Business Model and Presentation) using the OBIEE Administration Tool Extensive experience in using OBI Answers for creating different Requests using different views, Interactive Dashboards with page and dashboard Prompts and performing various security tasks. Experience in SAP Business Objects (WEBI) Experience in developing mappings, creating sessions, monitoring workflows in Informatica Good understanding of full life cycle methodologies, from conceptualization to implementation and maintenance A quick learner with an eye for detail and excellent analytical and quantitative skills

Overview

15
15
years of professional experience
1
1
Certification

Work History

Associate Consultant (Power BI Technical Architect)

TCS
07.2022 - 09.2025
  • Projects Undertaken:
  • Hartford: August, 2024 – August, 2025 (12 months)
  • Role: Power BI Technical Architect
  • Designed and implemented Power BI dashboards for the insurance team, by integrating data from multiple sources like Sharepoint, SQL Server etc.
  • Created DAX measures and calculated columns to provide trend analysis and providing insights to their data.
  • Developed automated data refresh deployment pipelines for movement of code across multiple environments.
  • Enabled row-level security, object level security ensuring secure access for multiple users.
  • Metlife: September, 2022 – July, 2024 (21 months)
  • Role: Power BI Technical Architect
  • Configuring the data model for the reporting solution from scratch by identifying fact and dimension tables
  • Created reports and visualizations using DAX measures and calculated columns
  • Also involved in effort analysis and direct interaction with the client.
  • Enabled row-level security, object level security ensuring secure access for multiple users.

Senior Associate (Power BI Technical Architect)

Cognizant
01.2018 - 07.2022
  • Projects Undertaken:
  • Biomarin: April, 2020 – July, 2022 (27 months)
  • Role: Power BI Technical Architect
  • Configured and transformed BioMarin sensitive data using Power BI query
  • Modelled the data to star schemas creating shared dimensions, aggregate tables
  • Carrying out the development of reports, dashboards including various visuals like Tables, Charts, Slicers, Bookmarks, Filters, Selection Pane etc.
  • Used DAX to create complex business logics creating calculated columns and measures required for reporting
  • Involved with the team on the defects already in their system and resolved them in conjunction with the business implications and followed the best practices.
  • To prepare the functional & technical design documents along with the test cases.
  • GlaxoSmithKline: January, 2018 – March, 2020 (27 months)
  • Role: Power BI Technical Architect
  • Developed PBI Reports & Dashboards. For Dashboard analyzed the Master database tables and created view to match the requirement.
  • Worked on Direct and Import query, DAX, Data Modeling, groups, combine fields, calculated fields and aggregated fields to compare and analyze the data in different perspectives.
  • Used Different Visuals like Stacked Bar Chart, Stacked Column Chart, Cards, Multi-card, Area chart, Pie chart for visualize the data.
  • Work on optimizing Power BI Reports with focus on usability and performance.
  • To prepare the functional & technical design documents along with the test cases.

Senior Consultant (OBIEE Developer)

IBM
03.2015 - 12.2017
  • Projects Undertaken:
  • American Express: April, 2015 – Dec, 2017 (32 months)
  • Role: OBIEE Developer/Consultant
  • Configuring the metadata in the RPD, developing the subject areas.
  • Security, cache, dimensional hierarchy, Initialization Blocks configuration
  • Carrying out the development of reports, dashboards.
  • Involved with the team on the defects already in their system and resolved them in conjunction with the business implications and followed the best practices.
  • Creating reports using BI Publisher and creating data models, layouts, templates, scheduling and bursting reports.
  • To prepare the functional & technical design documents along with the test cases.

Senior Systems Engineer (OBIEE Developer)

Accenture Services Private Limited
08.2014 - 03.2015
  • Projects Undertaken:
  • Telenor: August, 2014 – January, 2014 (6 months)
  • Role: OBIEE Developer
  • Configuring the metadata in the RPD, developing the subject areas and configuring security.
  • Carrying out the development of reports, dashboards.
  • Taking care of various process related documents.

Systems Engineer (OBIEE Developer)

Infosys Limited
06.2010 - 08.2014
  • Projects Undertaken:
  • RIVERBED: January, 2013 – July, 2014 (19 months)
  • Role: OBIEE Developer
  • Proficient in developing OBIEE Interactive Dashboards with Drill- down capabilities using global and local filters, OBIEE (users/groups, access/query privileges), configuring OBIEE metadata objects (Subject Area, Table, Column), Presentation Services/ Web Catalog objects (Dashboards, Pages, Folders, Reports).
  • Developed the RPD from scratch which includes - Importing the tables, creating their alias and setting the joins, developing the hierarchies, calculated columns, subject areas
  • Carrying out the development of reports, dashboards, RPD and analyzing them with impact details & suggesting best practice methods.
  • Taking care of all process related documents.
  • MOTOROLA: July, 2011 – December, 2013 (18 months)
  • Role: OBIEE Developer
  • Client has gone for an upgrade of their existing system i.e. from OBIEE10g to OBIEE11g. So here, we assessed the Quality of the upgrade process and suggested them recommendations along with the faulty observations & impact of their existing system.
  • Performed the detailed study of Motorola business needs and interacted with their business users and got the requirements for building the OBIEE reports.
  • Used OBIEE Administration Tool for customizing the Physical, Business Model/ Mapping & Presentation layer of metadata/ repository
  • Developed the RPD from scratch which includes - Importing the tables, creating their alias and setting the joins, developing the hierarchies, calculated columns, subject areas.
  • Creating reports using BI Publisher and creating data models, layouts, templates, scheduling and bursting reports.
  • Project categorized as CMM level 5 and documentation was well taken care off. I have experience in creating: Functional, Technical specification document for OBIEE, Estimates/Efforts involved for the reports.
  • CGC: December, 2010 - June, 2011 (7 months)
  • Role: Business Objects (WEBI) Developer
  • Worked extensively on Business Objects XI and Developed WEBI reports and Universe
  • Developed the unit test cases and other technical and functional documents.
  • Did the detailed study of Project Requirements and interacted with their business users to get the required information for building the reports.
  • Project categorized as CMM level 5 and documentation was well taken care off. I have experience in creating: Functional, Technical specification document. Built Unit test cases for all the reports and verified the reports for the relevance of the test cases.

Education

B.Tech/B.E. -

Maharaja Surajmal Institute of Technology
01.2010

Senior Secondary - undefined

Ajit Karam Singh International Public School
01.2006

Higher secondary - undefined

Ajit Karam Singh International Public School
01.2004

Skills

  • Power BI Desktop
  • Power BI Service
  • SQL, MS SQL SERVER, PostgreSQL, Oracle
  • Data Analytics & Data Modelling
  • OBIEE
  • Oracle BI Publisher

Certification

  • Certification Course in Microsoft Power BI (2021)
  • Certification Course in Oracle Business Foundation Suite 11g (2014)
  • Certification Course in Microsoft SQL Server 2008 Business Intelligence Development (2013)
  • Certification Course in Microsoft SQL Server 2008 Database Development (2013)
  • Certified Scrum Master (2016)
  • Certified Kanban Professional (2017)
  • Conducted training in Infosys regarding the Basics of Oracle 11g.

Hobbies and Interests

Listening to music, travelling.

Disclaimer

I hereby, declare that the information furnished above is true to the best of my knowledge. Nimish Jain

International exposure

While working with Infosys, got the opportunity to conduct Technical Interviews over the phone of candidates across different regions US and China (2012)

Timeline

Associate Consultant (Power BI Technical Architect)

TCS
07.2022 - 09.2025

Senior Associate (Power BI Technical Architect)

Cognizant
01.2018 - 07.2022

Senior Consultant (OBIEE Developer)

IBM
03.2015 - 12.2017

Senior Systems Engineer (OBIEE Developer)

Accenture Services Private Limited
08.2014 - 03.2015

Systems Engineer (OBIEE Developer)

Infosys Limited
06.2010 - 08.2014

Senior Secondary - undefined

Ajit Karam Singh International Public School

Higher secondary - undefined

Ajit Karam Singh International Public School

B.Tech/B.E. -

Maharaja Surajmal Institute of Technology

Similar Profiles

CREATE PROFILE
Nimish Jain