GAJENDRA KUMAR BHARATHI

Mobile: 206-***-****,

**B Reading Road

Edison,

New Jersey - 08817

Email : ad0id9@r.postjobfree.com

Employment Objective:

Seeking a responsible position in Snowflake, PowerBI and Cognos which utilizes my skills and thinking capability to the fullest & provides with learning opportunities. To be efficient and effective in whatever endeavors I undertake and prove myself worth. To pursue a challenging, dynamic, & rewarding career is what I aim to achieve. I have 13+ years of experience in PowerBI, Cognos Reporting service, multiple Databases. Possess excellent communication and presentation skills, as well as work ethic, drive and potential.

Profile Summary:

Provided leadership and direction across the Configuration management, Integrations, incident management and support issues.

Modeling, Architecting and designing BI solutions using PowerBI

Experience in BI consulting to choose BI technologies and solutions by understanding customer needs through various assessments.

Designed and developed business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs.

Created mockup dashboards and presented to the higher-level end users to have them a look and feel of the Power BI dashboards.

Developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Monitored and scheduled daily backup jobs for SharePoint Farm and databases using SQL Management Studio and PowerShell.

Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Experience in Bookmarks and Sync slicers

Experience in developing Cross Report drill through

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, and line better business analysis.

Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.

Implemented Managed Aggregation for the extremely big dataset to achieve desired performance

Expert knowledge of architecting and developing Power BI solutions by configuring the data security and assigning the licenses and sharing the reports and dashboards to the different user groups in the organization.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging

Experience in implementing Managed Aggregations

Experience in PowerBi Report Builder for Paginated reports

Experience in XMLA end points to refresh the report partitions

Experience in creating parameters to partial refresh in development and full refresh in services

Experience in Tabular Editor for implementing multi lingual report concepts

Experience in DAX studio to analyze the DAX queries in order to improve the performance

Experience in ALM Tool kit to compare the datasets and publish the changes

Created data bricks notebooks using Python (PySpark) and Spark SQL for transforming the data that is stored in Azure Data Lake

Implemented SCD logics.

In depth understanding of Data warehouse

Experience in Snowflake Cloud Data warehouse

Designed and implemented ETL pipelines for ingesting and processing large volumes of data from various sources

Experience in Data masking, Data sharing, Streams and Tasks creation using Snowflake

Experience in Time Travel, Fail Safe

Experience in Snowflake Time Travel and Fail safe

Experience in building Snowpipe, Cloning

Knowledge in the BODS

Having experience in Database, schemas. Table, View, Procedure, Function creation

Report development in COGNOS 8, Cognos 10.1.1, 10.1.2, 11 versions.

Cognos Migration from Cognos 7.3 to Cognos 10.1.1 version.

Metadata Modeling in Framework Manager.

Knowledge in Impromptu reports, Catalogs, Poweplay cubes, transformers.

Knowledge in Javascript.

Preparing Materialized Query Table(MQT).

Good knowledge in SQL Server, Oracle

Have worked on activities like Project estimation, Deck preparation, Project planning.

Knowledge in Power Automate flow

Basic knowledge in Power Apps

Education:

Bachelor of Engineering (B.E), 70%from Muthayammal Engineering College, Salem-Anna University, Chennai in(2003 – 2007)

HSC, 76.76% from Sri SaradaBalaMandir Matriculation Higher Secondary School, Salem in May 2002

SSLC, 83.40%from Neelambal Subramanium Higher Secondary School, Salem in APRIL 2000

Certification:

IBM Certified Designer - Cognos 10 BI Reports.

Software Exposure:

Core Skills: Snowflake, Power BI, SQL Server, Cognos.

Languages: Knowledge in C, Knowledge in COBOL

Databases: MS SQL Server, Knowledge in DB2.

Operating Systems: Windows 2000 advanced Server, MS Windows XP/2000/NT, Windows 95/98/Me, MS DOS,Z/OS

Reports: Power BI reports, Dashboards, Cognos 7.4, 8.4, 10.1.1, 10.1.2 Framework Manager, Reports, Poweplay Cubes, Powerplay reports, Transformer.

Professional Experience:

Current Employment: ILink Digital, USA (22/03/2021 to Present)

Client 1: Costco Wholesale, USA

Title : PowerBI Report development for Infrastructure Team

Role : Business Intelligence Analyst Environment : PowerBI, Azure Databricks

Team Size 7

Period : Sep, 2022 to Present Project type : Development

Responsibilities:

Designed and developed business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs.

Requirement gathering from the infrastructure team

Preparing requirement document based on the customer input

Modeling, Architecting and designing BI solutions using PowerBI Design and Architecture of semantic layer

Developing calculated columns, measures using DAX

Developing new interactive logics

Implementing Row Level security in the centralized dataset

Implementing data manipulation in Power Query

Performance analysis through DAX Studio and fine tuning the report

Implemented dynamic row level security based on user login

Implemented incremental refresh based for the datasets in import mode

Implemented XMLA end points using SSMS in order to create and refresh the PowerBI dataset partitions

Printable reports are developed using PowerBI Report Builder (Paginated reports)

Datasets creation in report builder

Designing parameters in report builder

Implemented parameter logic to load partial data in development phase and full load in services

Done performance tuning by analyzing the DAX queries in DAX Studio

Published dataset changes to the published datasets using ALM tool kit

Unit testing, Analyzing and fixing the defects

Deploying the PowerBI reports and datasets to multiple environments

Implementing Time Intelligence functions

Data comparison and comparison document preparation between source API and Databricks tables

SQL script preparation based on requirement

Daily stand up call with client

Peer review of developed reports before actual delivery

Test case preparation for the upgraded reports

Implemented Power Automate flow to schedule report bursting

Implemented Power Automate flow to move files from shared path to Azure data lake

Project 2: Costco Wholesale, USA

Title : Cognos to PowerBI Migration

Role : Business Intelligence Analyst Environment : PowerBI, Synapse Analytics

Team Size 12

Period : Jan, 2022 to Sep, 2022 Project type : Development, Migration

Responsibilities:

Requirement gathering from the client

Modeling in Power BI replicating the Cognos FM model

Design and Architecture of semantic layer

Developing calculated columns, measures using DAX based out of Cognos reports

Developing new interactive logics between the visuals

Recreating the Cognos equivalent reports in PowerBI

Performance analysis through DAX Studio and fine tuning the report

Implemented dynamic row level security based on user login

Implemented incremental refresh based for the datasets in import mode

Implemented XMLA end points using SSMS in order to create and refresh the PowerBI dataset partitions

Printable reports are developed using PowerBI Report Builder (Paginated reports)

Implemented in report drill through and cross report drill through

Fine tuned a very big dataset of size 100GB implementing Manage Aggregation

Unit testing, Analyzing and fixing the defects

Data comparison and comparison document preparation between Oracle and Synapse

Daily stand up call with client

Peer review of developed reports before actual delivery

Test case preparation for the upgraded reports

Technically Leading the team by providing solutions

Implemented Managed Aggregation for the extremely big dataset to achieve desired performance

Client 2: Electronic Arts (EA Sports), USA

Title : Power BI Reports and Dashboard Development, Excel to PowerBI Role : Technical Architect

Environment : PowerBI, Snowflake

Team Size 4

Period : April, 2021 to Dec, 2022 Project type : Development, Migration

Responsibilities:

Modeling in Power BI centralized dataset for the finance team

Design and Architecture of semantic layer in PowerBI datasets

Data manipulations using M query at Power query window

Implemented functions in the Power Query

Developing calculated columns, measures using DAX

Developing new interactive logics

Developed reports using external PowerBI visual ZebraBI for financial reports

Performance tuning done using the DAX Studio

Created measures using Time Intelligence functions for the financial report

Implemented Bookmarks for the interactivity dashboard

Unit testing, Analyzing and fixing the defects

Requirement gathering from the client

Preparing Report specification document, Business requirement document.

Validating Unit test case documents

Table, view, procedure, function creation in Snowflake.

Creating Warehouse, Roles and assigning user to respective Roles. Granting BB objects to different roles

Implemented data ingestion in Snowflake Using Snowpipe

Data comparison and comparison document preparation between Source and Snowflake

Weekly status call with the client, sending WSR

Peer review of developed reports before actual delivery

Test case preparation for the upgraded reports

Leading the team size of 4

Previous Employment: Hexaware Technologies Pvt Ltd, Chennai (10/08/2015 to19- Mar-2021)

Client 1: Freeport McMoran, USA

Title : Power BI Reports and Dashboard Development, Teradata to Snowflake Migration

Role : BI Architect

Environment : PowerBI, Teradata, Snowflake

Team Size 6

Period : January, 2017 to 19-Mar-2021 Project type : Development, Migration

Responsibilities:

Requirement gathering from the client

Modeling sematic layer in Power BI

Design and Architecture of semantic layer

Developing calculated columns, measures using DAX

Developing reports based out of IOT data

Implemented Bookmarks for the interactivity

Developing new interactive logics

Unit testing, Analyzing and fixing the defects

Migrating the Data Warehouse into Snowflake from Teradata and Oracle DB

Table, view, procedure, function creation in Snowflake

Data comparison and comparison document preparation between Teradata and Snowflake

Analysis of existing Teradata objects to identify the challenges and constraints to create a robust and seamless migration into Snowflake

Extracting the metadata needed from the Teradata data dictionary and creating them in Snowflake Environment.

Outline the ETL process, setting the borders of data processing

Provide system architecture for each element and the whole data pipeline

Moving the Data Pipeline and ETL (extract, transform, load) processes into the new Snowflake environment.

Actively used multiple Snowflake concepts like cloning, table copy, Time travel, Materialized view etc.

Having good knowledge on Snowflake Streams and Tasks

Weekly status call with the client, sending WSR

Peer review of developed reports before actual delivery

Test case preparation for the upgraded reports

Leading the team size of 6

Client 2: Brown Brothers Harriman, USA

Title : Hyperion to Cognos Migration

Environment : SQL Server, IBM Cognos 10.2.1 version, PowerBI

Team Size : 10

Period : August 2015 to January 2017 Project type : Migration

Responsibilities:

Requirement gathering from the client.

Metadata modeling using in framework manager

Migration of Hyperion reports to Cognos 10.2.1 using BIMA(Internal tool).

Dashboard, Report development in PowerBI

Leading team size of 10.

Project estimation, Project Planning, Deck preparation, SOW preparation etc.

Participating in client status call, Defect discussion call etc.

Preparation of Business Specification document based on client requirement.

Prepared checklist(test cases) for Unit testing.

Peer review of the developed report to avoid defects.

Achievement:

Got Ace award in Q3 2016 for excellent support in project.

Previous Employment 1: Temenos, Chennai (07/06/2010 to 20/12/2013)

Client: Kasikorn Bank, Thailand

Title : Temenos Core Banking(TCB)

Environment : Mainframe, Cognos 8.3, Appbuilder Client : K-Bank, Thailand

TemenosCoreBanking (TCB) is an open technology, IBM mainframe-based mass retail banking software platform. Used by some of the world’s largest retail banks, TCB is ideal for complex Tier 1 and Tier 2 retail banking businesses - in-house or outsourced – and ideally suited to making phased banking transformations across one or more lines of business.

Team Size :4

Period : Jun 2010 to Dec 2013 Project type : Development

Client : Kasikorn Bank, Thailand.

Domain 1: TCB Lending

In TCB Lending deals with the Loans in banking sector. The Cognos reports are developed for these domain based on the customer requirement and delivered in on time with less defects.

Domain 2: TCB Deposits

In TCB Deposits deals with the Deposit in banking sector. The Cognos reports are developed for

these domain based on the bank’s requirement.

Responsibilities:

Metadata modeling in Framework manager.

Report Development in Cognos 8.4.

Creating MQT in DB2.

Requirement gathering from the client.

Onsite client support.

Mainframe batch support in OPC.

Achievement:

Got Gem award in Q1 2011 for excellent support in project.

Previous Employment 2: RAVSoft Solutions, Chennai (26/12/2013 to 20/06/2014)

Client: Merge Healthcare, USA

Title : Development and Support Environment : SQL Server, Cognos 10.1

Team Size 2

Period : Dec 2013 to Jun 2014 Project type :Development and Support

Responsibilities:

Metadata modeling in Framework manager.

Report Development in Cognos 8.4.

Client support from offsite.

Requirement gathering from the client.

Project status meeting with client.

Achievements:

Got GEM award for fixing defects in on time and batch support in Temenos.

Appreciation for Reports Onsite support in client place and fixed issues in time.

Good Team performer.

Previous Employment 3: Niteo Technologies Pvt Ltd, Chennai (30/06/2014 to 31/07/2015)

Client 1: BMW, USA

Title : Migration from Impromptu 7.3 to Cognos 10.1.1

Environment : SQL Server, Cognos 7.4, IBM Cognos 10.1.1 version

Team Size : 5

Period : July 2014 to Jan 2015 Project type : Migration

Responsibilities:

Migration of Impromptu catalog from Cognos 7.3 to Cognos 7.4 and from Cognso 7.4 to Cognos 10.1.1.

Migration of Impromptu reports from Cognos 7.3 to Cognos 7.4 and from Cognso 7.4 to Cognos 10.1.1.

Migration of Transformer Model from Cognos 7.4 to Cognos 10.1.1 transformer version.

Generating cubes and publishing Cube packages for Powerplay reports.

Migration of powerplay reports from CognosPowerplay 7.4 version to Cognos 10.1.1 version.

Recreating Cognos 7.4 version Visualizer in Cognos 10.1.1 version.

Unit testing on migrated objects.

Project status meeting with the client.

Requirement gathering from the client.

Client 2: Bentley University, USA.

Title : FM development with data security and Reports development Environment : SQL Server, IBM Cognos 10.1.1 version

Team Size : 3

Period : Mar 2015 to Jul 2015

Project type : Framework Manager, Report development

Responsibilities:

Requirement gathering from the client.

Metadata model development with data security.

Report development in Cognos 10.1.1.

Unit testing of Framework manager, reports.

Project status meeting with client.

Contact this candidate