vijay (RID : 157l8l5qbhwli)

  • Senior Power BI Consultant
  • bangalore, India, ,

Rate

₹ 223,000 (Monthly)

Experience

11 Years

Availability

Immediate

Work From

Offsite

Skills

DAX expressions MS Power BI DesktopPower BI ServiceFramework ManagerReport StudioQuery StudioCognos 10.2.1Cognos 11Win XPWin 7UnixMS SQL Server

Description

Career Objective

To work in an environment that is conducive to effective utilization of my experience in Data warehousing and Business Intelligence and promoting further knowledge acquisition, thereby contributing to the growth of the organization and myself.


Profile Summary

·      11+ years of IT experience, working with the Data Warehousing and Business Intelligence tools/applications and ETL tools.

·      Knowledge of MS Power BI Desktop, DAX expressions, and Power BI Service

·       Power BI Expert with 4.7 years of rich experience in creating compelling reports and dashboards using advanced DAX. Looking to work with an esteemed organization that allows me to utilize my existing analytical skills and help make better business decisions.

·      Knowledge of Cognos BI suite components such as Framework Manager, Report Studio, Query Studio, and Active Reports in Cognos 10.2.1, Cognos 11

Adept in team & time management, client relationship management, and implementation of the unit test cases. Skilled at analyzing, and troubleshooting problems. Shaped with sound technical knowledge and the ability to identify, analyzing, and resolving in early stages to avoid 


Academic Qualifications

Master of Technology NIT Rourkela Electronics 2010 79.06

Bachelor of Engineering GITAM University Vishakhapatnam Electronics & Communications 2007 67.10

Intermediate IGNATIUS Jr. College, Karampudi M.P.C 2003 88.30

SSC Z.P.H. School, Dachepalli SSCm2001 72.80


Technical Skills

Operating system Win XP, Win 7, Unix

Tools MS Power BI Desktop, Power BI Service, Cognos 11, and Cognos 10.2.1

Database MS SQL Server

Company: Covalense Global

Project Details:

Client: Unilever (Aug-2021 to till date)

Tools: Power BI, SQL Server, and Azure

Role: As Technical Lead:             

ü Requirement gathering from Customers to provide In-scope and scope projects

ü Distributing the work to all team members

ü Handling weekly and daily stand-up calls to make sure to deliver the projects within the timelines

ü Learning Microsoft Azure data Factory

As Developer:

ü Imported data from SQL Server DB, Azure SQL DB, and Share point location to Power BI to generate reports.

ü Making the relationships between fact and dim tables

ü Creating the measures and Calculated Columns as per Dashboard Requirement using DAX functions.

ü Making the dashboard with visualization and cosmetic changes to look more effective.

ü Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps


Company: Tata Consultancy Services

Project Details:

Client: The Adecco Group (Jan-2020 to Aug -2021)

Tools: Power BI, SQL Server, and Salesforce

Role: As Team Lead:             

ü Creating Proposal Documents for new Power BI projects

ü Requirement gathering from Customers to provide In-scope and scope projects

ü Distributing the work to all team members

ü Handling weekly and daily stand-up calls to make sure to deliver the projects within the timelines

As Developer:

ü Imported data from SQL Server DB, Azure SQL DB, Snowflake DB, Salesforce, and Share point location to Power BI to generate reports.

ü Making the relationships between fact and dim tables

ü Creating the measures and Calculated Columns as per Dashboard Requirement using DAX functions.

ü Making the dashboard with visualization and cosmetic changes to look more effective.

ü Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

ü Explore data in a variety of ways and across multiple visualizations using Power BI


Client: TPI Composites (Jul-2017 to Dec-2019)

Tools: Power BI, SQL Server, and Snowflake

Role:

ü Connecting the excel files from Share point folder

ü Transforming the excel files and loading them into data model

ü Making the relationships between fact and dim tables

ü Creating the measures and Calculated Columns as per Dashboard Requirement using DAX functions.

ü Making the dashboard with visualization and cosmetic changes to look more effective.

ü Imported data from SQL Server DB, Azure SQL DB, Snowflake DB, and Share point location to Power BI to generate reports.


Client: Bank of America (Jan-2013 to May 2017)

Tools: IBM Cognos admin, IBM Cognos Developer, Motion PI, and Motion CI

Role: Cognos Developer:

o  Managing the past, present, and upcoming activities through the Cognos connection page.

o  Creating the schedules for new reports with trigger based

o  Developing Reports to find unused reports and delete them to improve the system performance as well as to increase server space

o  Restarting the server whenever required

o  Developed Cognos Package.


Client: GE Health Care (Jul-2010 to Dec-2012)

Tools: IBM Cognos Admin, Teradata, and Informatica

Roles: Cognos Administrator

o  User administration (create/edit user/role/groups),

o  Data source Creation and configuration.

o  Import/Export of archives.

 


 







Submit Query icon