Ranga Reddy Ankireddypalle
Data Analyst
Bangalore
Summary
Having 10+ years of overall experience with 6 years of experience in Microsoft Power BI Power BI Desktop, Power BI Service/Cloud, Power BI Admin DAX, M-Query and SQL Having experience in working with multiple data sources like SQL Server, Snowflake, Azure, AWS, SharePoint, Oracle DB, etc. Worked on Cloud computing services/platforms like Snowflake. Experience in Agile methodologies. Agile Tools: JIRA, Azure DevOps. Worked with across different geographical locations and has good exposure to global team cultures. Good client exposure with Insurance, Finance/Banking, Healthcare & Pharmaceuticals, Media & Entertainment, Retail and etc. Provides the thoughts/ideas to the business in data analysis prospective. Worked on requirements gathering, Data modelling, development of Power BI dashboards from multiple data sources. Experience in leading and managing small teams. Involved in completed journey of the data analysis. starting from the requirements gathering to deployment and maintenance of the dashboards. Seeking a challenging position in any industry that needs innovation, creativity, and dedication that enables me to continue to work in a challenging and fast-paced environment, leveraging my current knowledge and fostering creativity with many learning opportunities.
Overview
10
10
years of professional experience
5
5
years of post-secondary education
Work History
Senior Data Analyst / Business Analyst
RANGA REDDY
- Worked on multiple modes of data connection with reporting tools, worked on complex datasets
- Complex data modelling with multiple tables and worked on the
- Star and Snowflake schema
- Worked on measures and calculated columns and tables in reporting tools
- Used the most and appropriate visualization (Custom and default) for better story telling/ data visualization
- Maintain the existing dashboards, development of new dashboards simultaneously
- Implemented Row Level Security (RLS) as part of Security in Power BI
- Debugging, diagnosing and correcting the reports/dashboards
- Functions and used the different filters like visual level filters and page-level filters and report level filters as per reporting needs
- Deployed reports with
- Drill Down and Drop down menu option
- Created various visualizations like donut chart, Pie chart, and Bar graph,
- Treemap and waterfall charts, and Card Visualizations
- Publishing reports to the Power BI server and providing the access to required users
- Implemented Row Level Security as part of Security
- Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.
Lead Data Analyst
Ernst & Young
07.2021 - Current
- Involved in multiple projects like Insurance, Finance and banking, Media &
- Entertainment, Healthcare/Pharmaceuticals, and etc
- Responsibilities:
- Worked mostly with global teams, across different geographical locations/
- Firms and has good exposure to global team cultures (US and European)
- Provides the thoughts/ideas to the business in data analysis prospective
- Worked on development of Power BI and Quick Sight dashboards
- Worked on requirements gathering, data modelling, development of
- Power BI dashboards from multiple data sources
- Experience in leading and managing small teams
- Involved in completed journey of the dashboards starting from the requirements gathering to deploy and maintenance of the dashboards
- Data modelling with multiple tables and worked on the Star and Snowflake schema and Used the most and appropriate visualization (Custom and default) for better story telling/ data visualization
- Involved in snowflake side to create views and data modeling, complex data model to make sure the reports are working fine
- Involved in defining the size of the warehouse, Nodes and user roles
- Environment: Power BI, Quick Sight, Snowflake, SQL Server, Advance Excel,
- SharePoint folder, SharePoint list and Oracle DB
Power BI Developer
BBraun Medical
04.2020 - 07.2021
- Participate in meetings and calls to understand the report requirements like sales professionals
- Daily call Avg, Customer Coverage, Frequency , Customer engagement activities, Therapy activities
- Participate in meetings and calls to understand the report requirements like sales professionals achievement on targets (month, quarterly, annually), of overall, Product, Area, Growth, Consistency of BU1,2&3
- Prediction of futuristic Sales, Profit, Expiry, Returns & related to the sales and marketing
- Created new calculated columns and new measures over data models to enhance Power BI visuals using DAX
- Installed and configured data Gateways to refresh and schedule the refresh of the dataset
- Implemented Row Level Security as part of the Security
- Environment: Power BI, SQL Server, Advance Excel
Power BI Report Developer
Alkem Laboratories Ltd
12.2018 - 04.2020
- Extracting sales data from different kinds of source systems into Power
- Query and then cleansing the data by applying business rules and loading it into Power Pivot
- Building the relationships between the various data sets in power pivot,
- Created new columns, new measures, and conditional columns using DAX
BI Developer
Dr Reddys laboratories Pvt Ltd
11.2015 - 12.2018
- Extracting sales data from different kinds of source systems into Power query and then cleansing the data by applying business rules and loading it into Power Pivot
- Building the relationships between the various data sets in power pivot
- Created new columns, new measures, and conditional columns using DAX functions
- Created different filters like visual level filters and page-level filters and report level filters as per reporting needs
- Designed and deployed reports with Drill Down and Drop down menu option
- Created various visualizations like donut chart, Pie chart, and Bar graph,
- Treemap and waterfall charts, and Card Visualizations
- Developed at least two-three visual options for each report for discussion with stakeholders and customers
- Publishing reports to the Power BI server and providing the access to required users
- Implemented Row Level Security as part of Security
- Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports
- Pharma Sales and Marketing Experience
Territory Sales Executive
Abbott Healthcare Pvt ltd
01.2015 - 11.2015
Sales Officer
Sun Pharmaceuticals Pvt Ltd
03.2013 - 01.2015
Education
Master of Business Administration - Finance and Business Administration
Sri Venkateshwara University
07.2009 - 05.2011
Bachelor of Commerce - Commerce with Computer Application, E-Business
Sri Venkateshwara University
07.2005 - 05.2008
Skills
Power BI
undefinedTimeline
Lead Data Analyst
Ernst & Young
07.2021 - Current
Power BI Developer
BBraun Medical
04.2020 - 07.2021
Power BI Report Developer
Alkem Laboratories Ltd
12.2018 - 04.2020
BI Developer
Dr Reddys laboratories Pvt Ltd
11.2015 - 12.2018
Territory Sales Executive
Abbott Healthcare Pvt ltd
01.2015 - 11.2015
Sales Officer
Sun Pharmaceuticals Pvt Ltd
03.2013 - 01.2015
Master of Business Administration - Finance and Business Administration
Sri Venkateshwara University
07.2009 - 05.2011
Bachelor of Commerce - Commerce with Computer Application, E-Business
Sri Venkateshwara University
07.2005 - 05.2008
Senior Data Analyst / Business Analyst
RANGA REDDY
Similar Profiles
Subba Lakshmi Devi Vyshnavi AlluriSubba Lakshmi Devi Vyshnavi Alluri
Project at Reddy and Reddy AutomobilesProject at Reddy and Reddy Automobiles
Pintu DeyPintu Dey
Area Sales Manager at N Ranga Rao and Sons Pvt LtdArea Sales Manager at N Ranga Rao and Sons Pvt Ltd
MADAN V. NAYAKMADAN V. NAYAK
Depot Supervisor at N Ranga Rao and Son’sDepot Supervisor at N Ranga Rao and Son’s
Muskan JainMuskan Jain
Associate – Bid Management at Subex Ltd.Associate – Bid Management at Subex Ltd.
Lakshmi Durga KogantiLakshmi Durga Koganti
Technical Writer at Cisco Systems Inc. Ltd.Technical Writer at Cisco Systems Inc. Ltd.