Krishna Mohan Payyaula
Farmers Branch,TX
Summary
Highly skilled Data Analytics Developer with over 12 years of experience in Business Intelligence (BI) and Big Data technologies, specializing in delivering data solutions through Power BI and Azure platforms. Proven track record of designing and implementing end-to-end data pipelines, BI reports, and dashboards for global clients like Shell, British American Tobacco, Air Asia, Sri Lankan Airlines and Fluke corporation.
Overview
13
13
years of professional experience
Work History
Data Analytics Developer
IBM
Houston, TX
10.2022 - 07.2024
- As a Data Analytics Developer, I led the design and development of comprehensive BI solutions that transformed raw data into meaningful insights
- I worked closely with business stakeholders to translate complex business requirements into actionable data strategies, ensuring the BI solutions met organizational goals
- Worked with Azure services like Data Lake, Databricks, and SQL Server to orchestrate large-scale data processing workflows, ensuring scalability and efficiency
- Designed and implemented scalable data ingestion pipelines using Azure Data Factory to ingest data from SQL databases, CSV files
- Developed data processing workflows using Azure Databricks, leveraging Spark for distributed data processing and transformation tasks
- Ensured data quality and integrity by performing validation, cleansing, and transformation operations using Azure Data Factory and Azure Databricks
- Performed ETL using Azure Databricks and migrated on-premises to Azure SQL DB
- Conducted performance tuning and capacity planning exercises to ensure scalability and efficiency of the data infrastructure
- Collaborated with DevOps engineers to develop automated CI/CD and test-driven development pipelines on Azure DevOps based on client requirements
- Moved all Meta data files generated from various source systems to ADLS for further processing
- Implemented Spark using Python in Data bricks utilizing Data Frames and Spark-SQL API for faster Processing of data using Avro, Json and Parquet data formats to store data into ADLS
- Creating dashboards and interactive visuals using BI tools
- Working with technical teams to ensure the success of BI projects
- Perform DAX queries using Power BI tools
- Creating interactive visual reports using BI tools
- Hands on Experience on Power BI Desktop and Service/Report Server and worked on the Power BI Reports & Dashboards with SQL Server and Row level and object level security
- Experienced to use standard visualizations like Slicer, Card, Stacked column chart, Clustered column chart, Line and stacked column chart, Line and clustered column chart, map, Pie- Charts, Bar Graphs, Drill downs, Drill through, Navigation Reports etc..
- Using Power BI
- Comfortable in working with filters, calculated columns, measures, relationships and transformations of edit query section
Azure Data Engineer
British American Tobacco
10.2018 - 09.2022
- Played a pivotal role in developing data solutions for British American Tobacco, focusing on building data pipelines and providing advanced reporting capabilities to support the company’s global operations
- Successfully delivered end-to-end data solutions using Power BI and Azure Databricks, providing business users with real-time visibility into operational data
- Designed and developed scalable data pipelines using Azure Data Factory, enabling the company to process and analyze large volumes of data from multiple on-premises and cloud sources
- Built customized reports and dashboards in Power BI, using advanced visualizations like slicers, bar charts, and line charts, providing key insights into operational metrics
- Developed and optimized Azure Data Factory pipelines to extract, transform, and load data into Azure Data Lake and SQL databases for analytics and reporting
- Created complex DAX calculations to support advanced analytics in Power BI, providing users with deeper insights into their business data
- Integrated Azure Databricks for large-scale data processing, ensuring efficient handling of both structured and unstructured data
- Experienced to use standard visualizations like Slicer, Card, Stacked column chart, Clustered column chart, Line and stacked column chart, Line and clustered column chart, map, Pie- Charts, Bar Graphs, Drill downs, Drill through, Navigation Reports etc..
- Using Power BI
- Migrated SAP and OBIEE reports to Power BI and Implemented data security and user access controls, including row-level security and Object level security
- Adept in cloud migration, including report and data model migration from SAP BO to Power BI, and deploying CI/CD frameworks for automated data pipeline management using GIT Actions and Azure Devops
- Migrated on-premise to Azure ADLS using Azure databricks and data factory
- Developed ETL transformations and validation using Pyspark Data Frames with Azure Databricks
- Extensive experience and knowledge in Charts & Graphs & KPI, Marks cards, charts, Calculated fields
- Worked on DAX expressions like filters, Aggregate, Functions and time intelligence etc
- Thorough Knowledge on Data Warehouse concepts like Star Schema, Snowflake, Dimension and Fact Tables
BI Developer
Air Asia Airlines
05.2016 - 08.2018
- At Air Asia Airlines, played instrumental role in implementing a comprehensive data warehouse for the airline’s reservation system, revenue accounting, and inventory management, ensuring that the airline could track key operational metrics and generate reports for critical decision-making
- Successfully designed and deployed a data warehouse for Air Asia Airlines, allowing the business to efficiently analyze and report on data across reservation systems, inventory, and revenue
- Developed numerous interactive dashboards and custom reports using OBIEE (Oracle Business Intelligence Enterprise Edition), providing valuable insights into business performance
- Led the migration of analytical reports to Power BI, enabling more flexible and dynamic reporting options for business users
- Worked closely with business analysts and stakeholders to gather requirements and develop technical specifications for BI solutions
- Designed and developed the OBIEE Metadata Repository, creating logical models and hierarchies to support complex reporting needs
- Built interactive dashboards with drill-down capabilities, utilizing global prompts and presentation variables to allow users to explore data in greater detail
- Developed custom SQL views and time-series objects for computing Year Ago, YTD, MTD, and WTD measures
- Worked on data security and user access management to ensure that sensitive data was protected while allowing appropriate access for business users
BI Developer
Sri Lankan Airlines
09.2013 - 04.2016
- In this role, I have contributed to the implementation of a data warehousing solution using Oracle Airline Data Model, helping Sri Lankan Airlines streamline data from various upstream systems and providing comprehensive dashboards and analytical reports
- Delivered a comprehensive BI solution for Sri Lankan Airlines, integrating data from multiple systems and providing insightful reports for management
- Created dynamic reports using OBIEE, supporting day-to-day operational needs and facilitating long-term strategic planning
- Developed OLAP cubes and managed daily and incremental loads, ensuring data accuracy and timely availability for reporting
- Developed and maintained OBIEE reports and dashboards, ensuring that the airline’s management had access to up-to-date, actionable insights
- Worked on Oracle OLAP cubes to facilitate efficient reporting and analysis
- Designed and developed star schema models for data analysis and created data quality checks to ensure accuracy
- Managed the integration of data from upstream systems, ensuring seamless data flow into the data warehouse
BI Developer
Fluke corporation
11.2011 - 08.2013
- In this role, I have created reports and dashboard for their daily and monthly data analysis and also involved in access control part for end users on OBIEE application
- Working as BI Developers
- Providing the consultation to the end users on their day-to-day queries on BI systems
- Monitoring the OBIEE servers and environments
- This includes monitoring the server performance and maintenance
- Managing the user’s permissions and access control by controlling the user’s web group access
- Managing and monitoring the user’s OBIEE Reports, dashboards and I-Bots
- Managing and cleaning the OBIEE web catalog by removing the inactive users from the system
Education
Bachelors Degree - Computer Science
SK University
01-2006
Skills
- Azure Databricks
- Azure Data Factory
- Azure Data Lake
- Power BI
- Azure Analysis Services
- SQL
- Pyspark
- SQL Server
- Oracle
Corporateaffiliations
- Big Data Engineer, IBM, 09/01/22, 07/31/24
- Azure Data Engineer, ITC InfoTech, 08/01/13, 08/31/22
- OBIEE Associate, Cognizant, 11/01/11, 08/31/13
Timeline
Data Analytics Developer
IBM
10.2022 - 07.2024
Azure Data Engineer
British American Tobacco
10.2018 - 09.2022
BI Developer
Air Asia Airlines
05.2016 - 08.2018
BI Developer
Sri Lankan Airlines
09.2013 - 04.2016
BI Developer
Fluke corporation
11.2011 - 08.2013
Bachelors Degree - Computer Science
SK University
Similar Profiles
RAJKUMAR PRAJKUMAR P
Azure Devops Engineer at IBMAzure Devops Engineer at IBM
Ebony McRaeEbony McRae
Technical Chat Support Specialist at IBMTechnical Chat Support Specialist at IBM
Vinothkumar KVinothkumar K
Technical EWM, S/4 Hana, CDS,RAP at IBMTechnical EWM, S/4 Hana, CDS,RAP at IBM
Amit LingeAmit Linge
Offshore Delivery Lead at IBMOffshore Delivery Lead at IBM
Jennifer CaseyJennifer Casey
Ophthalmology Scribe at Retina Institute of TexasOphthalmology Scribe at Retina Institute of Texas