Namefillthis

Mobile: XXXXXXX
Email: [email protected]

Professional Summary:
Having 5 Years of IT experience which includes 3 years of Power BI experience in developing
various reports and data visualization. Worked in order to support consulting projects in SQL
Server 2014/2016 and Microsoft Business Intelligence tool reporting services - POWER BI.

 Expertise in Power BI, Power BI Pro, Power BI Mobile and Power Bi Service.
 Prepare Daily, Weekly, Monthly & Quarterly Reports by coordinating the information from
various applications to distribute accurate Reports within prescribed deadlines.
 Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Maps,
Scatter, Bullets, Heat Maps,Water Fall, Donut, Tree maps, etc.
 Able to create measures,attributes,hierarchies and relationships in Power BI.
 Experience on Creating Power BI report authoring (RLS), dashboard design.
 Adopt in developing, publishing and scheduling Power BI reports as per the business
requirements.
 Experienced in creating Paginated reports using Power Builder.
 Creating the reports as per client’s requirements in the form of table, matrix, Sub report,
Parameterized report, Linked reports and list using SSRS.
 Able to create Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable,
Functions, Batch Scripts and numerous stored procedure consumed at various stages
of migration/cleansing process, infographic graphs, reports or data validation.
 Strong DAX knowledge.
 Good Experience in SSIS Packaging and deployment.
 Communicate progress of allocated tasks periodically.
 Good troubleshooting, analytical and problem solving skills.
 Ability to work independently.
 Interact with the customer on a daily basis.
 Effective communication skills and a good team player.

Experience Profile:

 Working for ....................., Bangalore from Feb 2018 to Till Date.

 Worked for ……………., Bangalore from July 2016 to Jan 2018.
 Worked for………………, Chennai from April 2015 to Dec 2015.

Education Details:

 Graduated B.Tech (ECE) in ...... from .......................

Technical Skills:
Operating systems : Windows Family, linux
Programming Languages : SQL, T-SQL
Databases : SQL Server 2014/2016
Reporting Tool : POWER BI, SQL Server Reporting Services,Visual
Studio,SSIS

Professional Experience:

Project #2

BRD – Business-Reporting Dashboard

Client : Travelers | Insurance
Technology/Tools : Power BI Desktop. MYSQL Database
Role : Data Analyst
Team Size : Eight
Process : Agile
Duration : 22 months

Description:

Travelers is one of the top insurance company in USA, which is providing Home, Business and
Personal Insurance to the customers. Travellers Business users’ Policies and Customer details
were closely monitored such as premium charged, premium paid and Claimed amount etc. to
improve the business by giving satisfactory services to customers.

Responsibilities:

 Data gathering
 Gathering data from structured database where actual transactions takes place
 Survey and feedback information’s collected from sales and marketing team
 3rd Party data source
 Data Modelling
 Data Cleaning in power query editor
 Complete responsibility on Database designing
 Maintained complete structured database (MYSQL)
 SQL tuning
 EA Diagrams
 Developed high level test matrix
 Developed Power BI reports from multiple data source
 Data cleaning in Power BI
 Reported EDA analysis in Power BI
 Implemented DAX (Data Analysis Expressions) functions for Calculated columns and
measures
 Designed power BI data visualization utilizing cross tabs, maps, scatterplots
 End to end process to deliver the project
 Published Power BI Reports
Project #1

CVA – Customer Value Analysis

Client : Cisco Stores
Technology/Tools : Power BI Desktop. MYSQL Database
Role : Junior Data Analyst
Team Size : five
Process : Agile
Duration : 12 months

Description:

A retail store wants to evaluate customer value in terms of high/medium/low based on each
customer’s demographics and purchase information/ sales transactions, to take decisions and
implement appropriate action plans.

Responsibilities:

 Defined, designed, and developed interactive dashboards and other automated reporting in
Power BI
 Develop and maintain standardized reports, dashboards and portals utilizing the business
intelligence platform’s software developer tools
 Data pre-processing
 Data transformation
 Participates in the design and maintenance of the Database Management System (DBMS)
including data modelling, extraction, cleansing, aggregation, transformation and validating
the data to ensure accuracy and consistency
 Analyze complex business problems to execute the vision and strategy of the Compliance
organization with the overarching goal to reduce operational risk across the enterprise
 Consistently complete tasks within agreed upon target dates
 Pro-Active and resourceful with the ability to work independently and problem solve

Personal Profile:

Date of Birth:

Address: Bangalore, Karnataka

Languages Known: English, Telugu & Tamil.