Power Bi Configuration Management
Resume:
GAJENDRA KUMAR BHARATHI
Mobile: 206-***-****,
**B Reading Road
Edison,
New Jersey - 08817
Email : *************@*****.***
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