Rajasekhar Reddy

6 years of total work experience in designing and developing database, data warehousing and Business Intelligence using Microsoft technologies SQL + Power BI + Excel and Looker BI. Having good experience in Power query, Power pivot and Power view for creating the effective reports and dashboards.

Experience in Looker's modeling language, LookML, including defining data models, dimensions, and measures. Strong SQL skills for writing and optimizing database queries. Understanding of different SQL database systems and dialects (GCP/BQ preferable).

Knowledge of data modelling best practices. Proficiency in ETL processes for data transformation and preparation. Skill in creating visually appealing and effective data visualizations using Looker's dashboard and reporting tools.

Ability to optimize Looker performance by fine-tuning queries, caching strategies, and indexing options. Familiarity with related tools and technologies, such as data warehousing (e.g., Big Query), data transformation tools and scripting languages (e.g., Python). Knowledge of data governance principles and practices to ensure data quality, privacy, and compliance within Looker.

Willingness to stay updated on Looker's latest features and best practices in data analytics and BI. Involved in importing/migrating data from Excel, SQL Database, SSAS Tabular cubes, Azure Analysis Services into Power BI Desktop. Worked on Custom Visualizations like Chiclet Slicer, Bullet Chart, Linear Gauge by MAQ Software, Distribution, Infographic Designer and Pulse Chart etc.

Used DAX expressions like Logical, Aggregate, and Time Intelligence & Date Functions to create business Calculations based on requirements. Worked on visual interactions using edit interactions to make few visual to effect data based on requirement. Having good skills in trouble shooting On-Premises Gateway to refresh the dashboards/ reports.

Data modeling, Calculations, Conversions, Scheduling for data refreshes in Power BI Desktop. Performance tuning of queries and reports calculations using Power BI (Performance Analyzer).

Experience on working with SQL server database objects like Temp tables, CTEs, sub-queries, Views, DDL/DML commands, Joins, User defined functions, stored procedures to facilitate efficient data manipulation and data consistency as well as to support the existing applications. Having basic knowledge in Azure Data Factory (ADF), Azure Analysis services, Azure SQL DW and willing to learn new technologies.

BI Developer - Tata Consultancy Services (TCS) - Hyderabad

(2023-04 - 2025-12)

BI Developer - LTIMINDTREE - Bangalore

(2019-09 - 2023-03)

BI Developer - Citi Bank

Citi is the leading global bank, serves more than 200 million customer accounts, and does business in more than 160 countries and jurisdictions. Citi works tirelessly to provide consumers, corporations, governments and institutions with a broad range of official services and products. Data from Operational Source System is extracted and loaded into data warehouse Using SQL. The reports are being generated in PowerBI

• Responsible for gathering Business requirements and deliver the same within the timelines.
• Conducting meetings to understand the business requirements with business user and analysts
• Understand business requirements in BI context and design data models to transform raw data into meaningful insights
• Create dashboards and interactive visual reports using Power BI
• Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
• Analyzing data and present data through reports that aid decision-making
• Convert business requirements into technical specifications and decide timeline to accomplish
• Create relationships between data and develop tabular and other multidimensional data models
• Chart creation and data documentation explaining algorithms, parameters, models, and relations
• Design, develop, test, and deploy Power BI reports and perform detailed analytics
• Perform DAX queries and functions in Power BI
• Analyze current ETL process, define and design new systems
• Data warehouse development and work with SSAS, SSIS, and SSRS
• Redefine and make technical/strategic changes to enhance existing Business Intelligence systems
• Create customize charts and custom calculations as per requirements
• Design, develop and deploy business intelligence solutions as per needs
• SQL querying for best results, use of filters and graphs for better understanding of data
• Work with users and team members at all level for performance improvement and suggestions
• Understanding functional requirements and prepared the BRD and technical design documents
• Interaction with the clients regarding the technical specifications and requirements
• Training for key users on dashboards/reports and data model in Power BI
• Key resource for Design and analysis of the Power BI technology
• Responsible for deliverables
• Ensure that development is performed as per the requirements.
• Analysis of the problems across the dashboards and defining the resolutions in the format of documentation and CR estimations
• Implementation of the New reports/dashboards and Modifications to the Existing dashboards based on the CR Approvals
• Supporting at various stages of testing (SIT & UAT), scheduling and deployment of the code.
• Executed Unit test for dashboards based on the BRD.

Looker BI Developer - Biocon Biologics India - Bangalore

Biocon Biologics India is a Biopharmaceutical company based in Bangalore, India.

Biocon Biologics

Limited specializes in research, development, and manufacturing of innovative biopharmaceuticals. Biocon's mission is to provide affordable access to high-quality biopharmaceuticals for patients across the world.

Biocon Biologics

Limited may be using Looker to gain insights into their data, such as production processes, clinical trials, and market trends. With Looker's capabilities, Biocon Biologics Limited can analyse complex data sets and make informed decisions to improve their operations and meet.

• Working with business users for requirements gathering.
• Doing Data Curation and Transformation based on user requirements.
• Generating views based on existing Biocon and Snowflake tables and adding dimensions, measures, filters, and dimension groups to LookML views according to business scenarios.
• Designing and developing LookML model and creating explores which show different views of data to business users to enable them to self-serve.
• Creating derived tables and adding persistence to them to improve performance.
• Creating datagroups and catching policies for LookML explores according to ETL schedules.
• Creating user attributes, access grants, and access filters to control access to different LookML structures and to achieve row-level security. Creating different groups to achieve content security and roles to manage feature access.
• Creating dashboards according to user requirements and adding different dashboard filters, look level and custom filters, table calculations, custom measures, filter only fields, measures for forecast, trend line, and reference lines along with the options to drill down to row-level details, etc.
• Using HTML and Liquid to customize dashboard tiles as per client requirements.
• Updating existing data model as per client requirement by moving complex logic to Looker to ensure performance improvements. Creating new models from scratch.
• Creating email data delivery schedules for Looker reports which has each user's access filters applied to the data included in the email. Also worked on setting alerts for different tiles.

Power BI Developer - Medtronic

Medtronic is an American Irish medical device company that generates the majority of its sales and profits from the U.S. healthcare system but is headquartered in the Republic of Ireland. Medtronic has an operational and executive headquarters in Fridley, Minnesota in the U.S. In 2015, Medtronic acquired Irish–tax registered Covidien in the largest U.S. corporate tax inversion in history, which enabled Medtronic to move its legal registration from the U.S. to Ireland.

Medtronic operates in 140 countries and employs over 100,000 people

• Developing, maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI.
• Good working experience on Power BI development on both Cloud level and Desktop
• Gateways installation, configure a data source for the gateways Manage the gateways
• Managing the roles and permissions. Creating the audit logs, Data modelling, Calculations, Conversions, Scheduling Data refreshes
• Ability to modify users and licenses within the Microsoft 365 admin Centre.
• Managing Power BI Premium involves creating, managing, and monitoring Premium capacities.
• Manage storage capacity, creating the Contents Packs, and share and publish the dashboards, Scheduling Data refreshes using Management gateways, tenant settings
• Content packs creations, giving access

MCA - SVU Tirupati (2015)