Summary
Overview
Work History
Education
Skills
Certification
Honors & Awards
Timeline
Generic

Mareswar Rao Porandla

Technical Architect - Data & Analytics
London

Summary

Seeking a successful, challenging and rewarding career that provides the opportunity to innovate and grow along with organization.

Overview

18
18
years of professional experience
8
8
Certifications

Work History

Technical Architect

Tech Mahindra
London, ENG
2 2015 - Current
  • Recreating existing application logic and functionality in Azure Data Lake, Data Factory, Azure SQL Database and Azure data warehouse environment
  • Implementing copy activity, custom Azure Data Factory Pipeline Activities Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory
  • Managing Azure Data Lakes (ADLS) and Data Lake Analytics and understanding of how to integrate with other Azure Services
  • Using Power BI Created and customized various types of visualizations such as Combination charts, Slicers, Maps, scatter plots, funnel charts, Gauges, cards and KPI's
  • Created various filters such as filters at Page Level, Report Level, Visual Level, Drill through and Slicers
  • Created and managed Row level security so that end user can view data based on their role
  • Created Calculated Columns and Measures in Power BI and Excel depending on requirement using DAX queries also Implemented DAX (Data Analysis Expressions) functions
  • Deriving data from web API's and load data to Azure Blob Storage for further cleansing and reporting needs
  • Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and pivot charts using power pivot skills
  • Usage of Key Vault for storing and retrieving security related information
  • Perform technical walk-through as needed to communicate design/coded solution and to seek input from team lead and members
  • Understanding of code promotion, code turnover to operations, version control, and QA procedures
  • Working on Data Factory Editor to create linked services, tables, data sets, and pipelines by specifying JSON definitions for these artifacts
  • Working on Azure Data Factory to create pipelines and various activities in Azure (lookup, metadata, loop etc.), including Azure data flows
  • Azure Data Factory (ADF), Integration Run Time (IR), File System Data Ingestion, Relational Data Ingestion
  • Migration of on-premises data (Oracle/ SQL Server/ DB2) to Azure Data Lake Store (ADLS) using Azure Data Factory (ADF V1/V2)
  • Developed feasible analytical solutions to cater request from stakeholders which help to identifying areas of deep dive and suggest them to improvements in various initiatives in different activity
  • Managing and monitoring lead KPIs and developed tools in Power BI that help to understand business model activity
  • Organizing meetings with stakeholders to gather business requirements and provide solution accordingly.
  • Contributed innovative ideas during brainstorming sessions that led to successful execution of key initiatives.
  • Participated in strategic planning sessions to align technology investments with organizational goals and objectives.
  • Resolved complex technical issues by troubleshooting systems, analyzing root causes, and implementing effective fixes.
  • Created comprehensive documentation for system designs, ensuring clarity of purpose and facilitating seamless maintenance activities.
  • Delivered high-quality solutions within tight deadlines while adhering to budget constraints.
  • Managed vendor relationships effectively in order to negotiate favorable contract terms and ensure timely delivery of services products.
  • Proactively monitored system performance trends to anticipate potential issues before escalated into larger problems.

Senior Business Intelligence Developer

HSBC Software Development (India) Private Limited
09.2008 - 01.2015
  • Managing and Administering Power BI premium Capacities (Admin Portal, Capacity Management) Power BI Premium administration (Creation of PSC Power BI Premium Workspaces and Managing user accesses)
  • Installing updated Power BI Gateway Versions on Cluster Servers
  • Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI desktop
  • Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions
  • Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI
  • Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column
  • Created several user roles and groups to end - user and provided row level security to them
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
  • Setting up data sources using Pharma Supply Chain Power BI data gateway
  • Setting up Scheduled Refreshes for datasets
  • Monitoring scheduled refresh failures and fixing them
  • Monitor Premium Resources per workspace: Memory, CPU, Storage Creation of data flows in Power BI Service
  • Working on Incidents, Requests raised in Remedy and ServiceNow PSC Power BI Queue
  • Helping users in requesting for Power BI Pro licenses and Installing Power BI Desktop Helping users in creation of reports and dashboards
  • Hosting PSC Power BI Monthly Service Review where discuss about service performance, new and upcoming Power BI features and also cover topic of month to explain some Power BI features in more details to users.
  • Delivered exceptional client support by promptly addressing concerns and implementing requested changes or enhancements to software solutions.
  • Spearheaded adoption of modern programming practices, promoting continuous improvement in development processes.
  • Integrated cutting-edge technologies into existing systems for enhanced functionality and user satisfaction.
  • Proactively identified areas for process improvement, implementing changes that led to significant time savings for team.
  • Developed scalable applications using agile methodologies for timely project delivery.
  • Managed multiple projects simultaneously while maintaining strict deadlines and high-quality standards.
  • Maintained comprehensive documentation of development work, facilitating knowledge sharing among team members.
  • Contributed valuable insights during product planning sessions, aligning technical strategy with business objectives.
  • Collaborated with cross-functional teams to design innovative software solutions.

Business Intelligence Developer

Reliance Communications
07.2006 - 09.2008
  • Constantly worked with Business users to provide them with data in form of complex reports and excel sheets for analysis.
  • Created reports based of free hand SQL and Universe objects Created prompts in report to restrict data fetch and ease data load.
  • Worked on crosstab and master detail reports and also represented same as line charts/ bar charts/ pie charts.
  • Created User groups, Users, Database connections, Managed user privileges, Import/export of universes in production environment.
  • Used Info view for scheduling Desktop Intelligence and Web intelligence documents
  • Involved in Requirements gathering, Development, UAT, and Production support phases of Business Objects Report development.
  • Extensively used Designer to design various universes for different business groups.
  • Detected cardinalities, loops, and checked Integrity of Universes
  • Modified existing Universes by merging different Classes and resolving Loops and Chasm Traps.
  • Developed and created classes with Dimension, Detail & Measure Objects and specified hierarchies.
  • Extensively used Web Intelligence Info view for exploring querying, reporting and analysis tasks
  • Cross verifying of Query result by SQL with end user before finalizing query for BO development.
  • QA of report and universe (Checking format of report and verifying query from report WEBI/DESKI in TOAD for same result in production)
  • Applying universe level Row and Object level Security.
  • Delivered actionable insights by analysing large datasets and effectively communicating results to key stakeholders.
  • Mentored junior team members on best practices in business intelligence development, fostering culture of continuous learning and improvement.
  • Improved overall efficiency by automating manual reporting tasks through development of dynamic BI tools.
  • Ensured data quality and integrity by implementing rigorous validation methods within business intelligence framework.
  • Translated complex technical concepts into easily understandable terms for non-technical stakeholders during presentations and meetings.
  • Evaluated emerging BI technologies and methodologies, recommending appropriate additions or improvements to existing systems.
  • Streamlined data analysis by creating customized visualizations, dashboards, and KPIs using BI tools.

Education

Bachelor of Technology

JNT University
India
04.2006

Skills

MS SQL Server

Oracle

MS Power BI

SAP Business Objects

Crystal Reports

Qliksense

ServiceNow

HP ALM

JIRA

Certification

Registered Product Owner (RPO) endorsed by Scrum inc

Honors & Awards

Standing Ovation Award - Jan 2024

Pat On Back - Jan 2021

Pat On Back - Mar 2018

Pat On Back - Aug 2017

Certificate of Excellence - Mar 2013

Above & Beyond Award - Dec 2012

Certificate of Recognition - Dec 2010

Team Award - Sep 2010

SPOT Award - Mar 2010 

Timeline

Registered Product Owner (RPO) endorsed by Scrum inc

06-2024

DP 600 - Microsoft Fabric Analytics Engineer Associate

06-2024

PL 900 - Microsoft Power Platform Fundamentals

02-2023

Registered Scrum Master (RSM) endorsed by Scrum inc

11-2022

DP 203 - Microsoft Azure Data Engineer Associate

03-2022

DA 100 - Analyzing Data with Microsoft Power BI

02-2022

ITIL Foundation Certificate in IT Service Management

05-2017

Business Objects Certified Professional

01-2009

Senior Business Intelligence Developer

HSBC Software Development (India) Private Limited
09.2008 - 01.2015

Business Intelligence Developer

Reliance Communications
07.2006 - 09.2008

Technical Architect

Tech Mahindra
2 2015 - Current

Bachelor of Technology

JNT University

Similar Profiles

CREATE PROFILE
Mareswar Rao PorandlaTechnical Architect - Data & Analytics