SR Chakravarthy Tanuku
Power BI Developer
Hyderabad,Telangana
Summary
Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.
Overview
10
10
years of professional experience
7
7
years of post-secondary education
Work History
Power BI Developer
Cenit It Hub Private Limited
Hyderabad
10.2022 - Current
- Experience in Power BI (Desktop and Service) with different data sources such as SQL Server using Live Connection as well as Importing data from Excel Sources.
- Hands-on experience in development using Power BI (Power BI Desktop, Service)
- Experience in gathering and translating end-user requirements into effective & efficient dashboards.
- Building Analysis Services reporting models.
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
- Connecting to data sources, importing data and transforming data for Business Intelligence.
- Excellent analytical thinking for translating data into informative visuals and reports.
- Implemented role-based security as part of user-level security in Power BI
- Proficient in making DAX queries in Power BI desktop.
- Experience in developing, publishing and scheduling Power BI reports as per the business requirements.
- Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
- Expertise in importing data from multiple data sources into Power BI, creating relationships between various datasets in power pivot.
- Experience in data modelling in Power BI Power Pivot.
- Experience in Data preparation in Enter Data and shaping data in Edit Query like adding the column, split column, pivot column, unpivot column, changing data type, and Merge queries and Append queries.
- Experience in understanding DAX Functions in Power BI and creating new columns and new measures using DAX.
- Comfortable in working with filters/calculated columns/measures/relationships and transformations of the Edit Query section.
- Combined the tables and columns by append queries and merge queries by Joins Concepts.
- Having valuable experience in creating Filters like Visual level, page level, Drill through, and Report level filters in Power BI.
- Experience in creating hierarchies and implementing hierarchy filters in reports.
- Having good experience in creating Parameters, sorting, and grouping, binning.
- Expertise in Creating Data Visualizations like Matrix tables, Area Charts, tree maps, Line and Stacked column charts, and Creating Visuals like Donut charts, Waterfall charts, Gauge charts and Funnel charts.
- Experience in Data Transformations like Derived Column, Conditional Split, Aggregate, and Union all, Merge join, Lookup and Sort to load data into Data Warehouse.
- Experienced in Creating Reports as per client's requirements in the form of Tables, Matrix, List, and Chart
- Hands-on experience in Creating Sub reports, drill-down reports, Drill through reports and cascading parameterized reports from queries in SSRS.
- Have knowledge on identify Dimension and Fact tables based on business logic
MIS Analyst/Lead Developer
First American India Pvt Ltd
Hyderabad
05.2016 - 09.2022
- Responsible for providing MIS reports on daily/weekly/monthly basis to different location SPOC or focal point (Leaders).
- Act as a single point of contact for internal Management & External Vendors
- Involved in collecting reports from various functions and compare it to the targeted AOP to evaluate the organization performance across all the functions.
- Identifying and analyzing the key issues that need to be addressed.
- Involved in providing detailed TAT/SLA analysis on weekly basis to team to achieve the target.
- Additionally, handled validation of MIS reports generated on billing, invoice data for different clients and Handled different Ad-hoc requests by clients and delivering in time.
- Preparation of templates and daily reports.
- Additionally, handled validation of MIS reports generated on billing and invoice data for different clients.
- Sharing daily/weekly & monthly historical performance report to ops.
- Understanding source systems and customer requirements.
- Worked with Dashboards style of reports using all the Power BI, Power Pivot components.
- RAG Reports creating as per the Management requirement
- Created Dashboards style of reports using Power Bi Desktop, Power Pivot Visualizations like Bar Chart, Line Chart, Area Chart and Slicer etc.
- Created the Calculated Columns and measure using DAX as per the KPI
- (RLS-Row Level Security) by defining as per the business constraints for each defined ROLE
- Charts are used in making reports more user-friendly in analysis purposes.
- Developed User interactive Reports as business needs.
- Published reports into Power BI publisher and schedule the data sets.
Senior Process Associate
Fidelity National Financial India
Bangalore
08.2013 - 04.2016
- Met month-end reporting objectives and deadlines.
- Performed reconciliations to drive accuracy and validity of financial information.
- Monitored and reported on process performance to verify compliance with established standards.
- Performed quality assurance checks on transactions and account actions to assess compliance with state and federal regulations.
- Supervised team of process associates to enhance accountability, develop professional skills and improve efficiency.
- Implemented continuous improvement metrics to streamline workflows and reduce waste.
- Conducted training and applied change management to achieve desired outcomes.
- Determined and recommended methods to implement improvement opportunities.
Education
Executive MBA - Finance
Indian School of Management & Studies (ISMS)
Mumbai, India 10.2010 - 05.2012
Bachelor of Commerce - Commerce
Andhra University
Rajahmundry, AP, India 06.2005 - 05.2008
Intermediate - Commerce
Board of Intermediate
Rajahmundry, AP, India 06.2003 - 05.2005
SSC -
Board of Secondary Education
Rajahmundry, AP, India 06.2002 - 05.2003
Skills
Technical Analysis
Virtualization
Power BI
Data Modelling
Excel
SQL
Alteryx
Gymming
A fitness enthusiast who is passionate about fitness and health
Timeline
Power BI Developer
Cenit It Hub Private Limited
10.2022 - Current
MIS Analyst/Lead Developer
First American India Pvt Ltd
05.2016 - 09.2022
Senior Process Associate
Fidelity National Financial India
08.2013 - 04.2016
Executive MBA - Finance
Indian School of Management & Studies (ISMS)
10.2010 - 05.2012
Bachelor of Commerce - Commerce
Andhra University
06.2005 - 05.2008
Intermediate - Commerce
Board of Intermediate
06.2003 - 05.2005
SSC -
Board of Secondary Education
06.2002 - 05.2003