5+ Yrs Exp Profile - PowerBI,MSBI and SQL

Bharat Kumar Nunna

Mobile: +*** - ********* (UAE)

+91 - 913-***-**** (India)

***************@*****.***

Summary

To work in my field of expertise, seeking a quality of employment where my knowledge can be shared and enriched, looking for the opportunity where I can improve my quality with an opportunity for career growth.

Skills

Development Environment : Windows 2000, XP and Windows 7.

Office Packages : Office 2012 and VBA.

Data Base : SQL Server 2008/2012/2014.

Business Intelligence Tools : SSIS, SSRS 2014

Data Visualization Tools : Power BI

Certification

Microsoft 70-778 Analyzing and Visualizing Data with Microsoft Power BI.

Employment History

TECHWAVE CONSULTING INDIA Pvt Ltd FROM JULY2017 TO September 2019

Project Name

Westcon Comstor

Team Size

9

Role

Senior Developer (Consultant)

Environment

SQL Server 2014, SSIS, SSRS, PowerBI and Excel.

Brief Description of Project

Westcon-Comstor (Westcon Group Inc.) is a value-added technology distributor of category-leading solutions in Security, Collaboration, Networking and Data Center. The company is transforming the technology supply chain through its capabilities in Cloud, Services and Global Deployment Contributions.

Responsibilities

Created new SSIS package to load all business data from BOBJ server to SQL Server Objects using Business Intelligence Development Studio (BIDS).

Loaded data from various sources (MS Excel, MS Access, Flat Files to SQL Server using SSIS/DTS)

Created variables (Project & SQL) and Package automation through SQL Jobs.

The packages created included a variety of transformations for example Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Multicast and Data Conversions.

Designed and implemented Tables, Joins, Sub-Queries, Stored-Procedures, Functions, Views, Indexes and Triggers in SQL Server 2014 Created jobs.

Developed Sub reports, Matrix and Drill down reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Working With all New Vendors On board and redesigned all SSIS Packages and SSRS Reports as per Vendor requirements.

Deployed all Packages & Reports through TFS 2014 and created roles and subscriptions for SSRS reports.

Created various visualizations tables, Matrix, slicer, Bar Charts, Line Charts, pie chart, Funnel chart, KPI, Gauge chart etc. using power BI Desktop

Created various Custom Visual Reports like Bullet chart, Heap Map, Word Cloud, cluster Map, chiclet slicer, Tachometer, Narratives for Business, KPI Grid

Experienced different source Microsoft Azure, files, SQL server, SSAS, Excel in Power BI Desktop.

Experienced in Creating Calculated measures and columns with DAX in PowerBI Desktop.

Customized data by adding Filters, conditional format, calculating column and measures, new table, DAX etc. in Power BI Desktop.

Created Content pack, my workspace, subscribe, on-premises data gateway, add tiles, shared, web view, phone view in power bi services.

Created PowerBI security like Data level security, member can view and admin content with PowerBI security.

Created and deployed Reports and Dashboards in Power BI web services.

Working with Westcon IT team on Tickets based (Service Now) and modified all SSIS and SSRS Reports as per Business requirements.

YASH TECHNOLOGIES PVT LTD FROM AUGUST2014 JULY2017

Project Name

EGS Group

Team Size

5

Role

Senior Developer

Environment

SSIS, SSRS, SQL Server 2012 and Excel.

Brief Description of Project

Expert Global Solutions (EGS) is a global customer service organization, delivering leading outsourced solutions, for customer and financial care. Serving the world’s leading companies, EGS helps decision-makers delight their customers and deepen brand engagement. This project deals with the development of SSIS packages as per the business requirement.

Contributions

Designed and implemented Tables, Joins, Sub-Queries, Stored-Procedures, Functions, Views, Indexes and Triggers in SQL Server 2014

Creating and altering tables on timely basis as per the enhancements in the product

Loaded excel, text, SQL Server and other source data provided from clients utilizing SQL, DTS and SSIS into SQL Server databases. Applied data conversions using lookup, merge join, aggregation, derived columns tasks.

The packages created included a variety of transformations for example Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Multicast and Data Conversions.

Created variables (Project & SQL) and Package automation through SQL Jobs.

Deployed, monitored, scheduled jobs and maintained SSIS packages.

Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring and archived data files for different RDBMS

Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

Developed Sub reports, Matrix and Drill down reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Deployed all reports in Report Manager.

NON IT Experience

ADP Pvt Ltd., FROM FEBRURAY2013 TO August2014

Project Name

Payroll Services

Team Size

6

Role

Analyst

Environment

MS Excel, Advance Excel, Power Pivot, Access, VBA and SQL Server 2008.

Brief Description of Project:

ADP Supports 401k Plan for US Citizens. Under 401k they Deducts Contribution Amount from their Pay cheques.

Contributions:

Dashboards, Growth Report, All Project Reports MTD, QTD and YTD wise.

Automated all frequency reports by using VBA code in excel. Created Dashboards by using Functions & ODBC connectivity. Prepared multiple Performances analysis (waterfall & deep analysis) reports in excel on existing products in the project for decision making.

Wrote complex SQL Sub queries, joins to extract raw data from the Databases.

Preparation of volumes report, quality reports, ensuring that the MIS is recorded accurately and on time

Expertise in generating reports using MS Excel Power View.

MIS, All Documentation work related to project.

Preparing and maintain reports and other data used by the top management.

Created Queries in Access Databases for adhoc raw data to offshore team.

SQL Server Data Base maintenance and updating.

Experienced in Sub Queries, views and Parameterized Stored Procedures in SQL Server 2008.

IMI Mobile Pvt Ltd., FROM MAY 2010 TO February 2013

Project Name

CRBT Services

Team Size

15

Role

Senior MIS Executive

Environment

Excel, Access and VBA 2007 & 2010.

Contributions:

Creating and maintaining reports in Excel & MS Access that allows the company to get information on daily business activities and identifying any un-captured products or call types in logs.

Analyze present company performance quarterly, half yearly and yearly. Preparing Target Vs Actual analysis monthly basis and tracking financial year wise.

Creating Revenue Dashboard/Historical report and reporting to the Vertical Head.

Adhoc data collection, analysis and reporting as required (i.e. Data/ Field Formatting, Data Storage, and report Generation.

Understand requirements, design formats, deploy formats, follow up with Business development team, and Quality team (Business Intelligence) and validate data.

Personalize New MIS requirements from Operations perspective for accurate Business information.

Prepared product wise Business reports to marketing team and involved in new products design.

Coordinating onsite managers and provide Adhoc reports for immediate action plans.

Prepared Stickiness and various analysis reports on Topline Revenue Contribution monthly wise.

Reports Automation in Excel by using functions, ODBC Connectivity and Macros.

Prepared Power-Point Presentations with neat formatting to Higher Management for every Periodical Meetings.

Education

2005 Bachelor of Science Andhra University India

2002 Intermediate (Maths &Science) Intermediate Board India

2000 Secondary school of Education Board of secondary Education India

Personal Details

DOB : 02-OCTOBER-1984.

Sex : Male

Marital Status : Married

Nationality : Indian

Languages Know : English, Telugu & Hindi.

Visa

Visa Status : Visit Visa

Visa Expiry Date : 20–January-2020

Contact Numbers

After Visa Expire : +971 - 567144716 (Mr. Naren Kranthi – Dubai Resident)

: +91 - 913-***-**** (Personal Number)

Contact this candidate