Rajesh Guntupalli

Mobile: +1-317-***-****

Mail Id: advrb5@r.postjobfree.com

Professional Summary:

15+ years of create & implement data engineering best practices for the full software development life cycle, including coding standards, code reviews, source control management, documentation, build processes, automated testing, and operations.

3+ years of experience using Power BI Desktop, Power BI Service, and Power BI Report Builder, Tabular Editor, ALM Toolkit and DAX Studio designing Power BI data models; including DAX, SQL queries and implementing role level security.

Design and develop Microsoft Power BI reports and Dashboards (Operational, Strategic & Analytical) including data set ingestion and transformation, Data Modeling, Data Analysis Expressions (DAX) using the appropriate report templates depicting status of key performance indicators (KPIs).

Experienced producing Power BI data models and recommending best practices for the creation of reports and graphics/visualizations.

Configured and implemented the Azure Data Factory Triggers and scheduled the Pipelines; monitored the scheduled Azure Data Factory pipelines and configured the alerts to get notification of failure pipelines.

Experienced in data modelling, designing data warehouse / data marts and reporting, dashboarding and advanced analytics solutions using Power BI.

Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate Shire’s data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.

Experienced in creating tabular data models, Power BI data sets, Data Flows and working with millions of rows of data.

Worked end-to-end systems development cycle from requirements analysis, coding, testing, User Acceptance Testing (UAT), and maintenance in Power BI life cycle.

Technical Skills:

BI Tools

Microsoft Power BI Suite, Tableau 2022.2.x, Cognos Analytics 11.2.x

Data ETL Tools

Informatica 10.x, Data Stage 11, Talend and Snowflake

Operating Systems

Windows 2000/XP and UNIX/Linux

ITS/Version Management

Service Now, Remedy, ITSM, PVCS, MS Source Safe, CVS, perforce

Database

SQL Server 2019, Oracle12C, MS Access and Snowflake, DB2

Languages

XML, HTML, MS.NET, SQL, JAVA

SAP tools

ABAP, HANA, BI, NetWeaver

Data Modeling tools

ERwin Data Modeler, Oracle SQL Developer, Data Vault Modeling

Cloud

Azure, AWS, and Google Cloud Platform

Education:

Master of Science in Computer Science (2003) from Bharathidasan University, Tamilnadu, India

Certification:

Microsoft Certified: Power BI Data Analyst Associate (No: I485-0690)

Professional Experience: