Venkata Krishna
Dubai,DU
Summary
Meticulous Data Architect with 15 years of expertise producing data management solutions. A natural team leader enabling consistent productivity, compliance and timely completion of projects.
Highly skilled data professional with extensive expertise in SQL, Python, Power BI, Tableau, and advanced analytics techniques such as machine learning, deep learning, and predictive modelling. Proficient in designing scalable data architectures, optimising ETL/ELT processes, and integrating business intelligence solutions across hybrid cloud platforms. Demonstrates strong capabilities in data governance frameworks, real-time data processing, and big data handling while leveraging tools like Azure Data Factory, Azure Databricks, and Alteryx. Adept at creating impactful data visualisation strategies and conducting exploratory data analysis to drive informed decision-making. Committed to delivering innovative solutions through stakeholder collaboration and advanced technical proficiency in cloud platforms and modern analytics tools.
Overview
14
14
years of professional experience
7
7
years of post-secondary education
Work history
Data Architect/BI Manager
GEMS IT
Dubai
11.2024 - 12.2025
- Engineered enterprise-level data architectures, ensuring scalability and cost efficiency.
- Optimised ETL/ELT workflows for efficient real-time and batch data transformation.
- Conducted gap analysis to identify improvement opportunities in business processes.
- Designed hybrid cloud architectures across Azure, AWS, Google Cloud, and on-premises solutions.
- Established data governance frameworks, enforcing security policies and compliance with GDPR and HIPAA.
- Crafted comprehensive business requirement documents (BRDs) and functional specifications for development teams.
- Led initiatives integrating business intelligence tools to enhance decision-making processes.
- Collaborated with engineers, analysts, and stakeholders to align data strategy with business objectives.
- Designed and delivered a scalable D365–Fabric data pipeline leveraging Dataverse, Fabric Lakehouse, and Dataflows Gen2, ensuring secure, governed, and incremental data movement for enterprise analytics.
Senior Specialist, Data Engineering
LTIMindtree
Hyderabad
09.2021 - 11.2024
- Designed innovative architectural solutions that addressed client needs and preferences.
- Demonstrated extensive expertise in Data Engineering, Analysis, Visualisation, and Science.
- Constructed Lakehouses and Semantic Models in Microsoft Azure for data movement.
- Designed and implemented dashboards integrating data from cloud platforms and SQL Server.
- Executed exploratory data analysis and preprocessing to ensure data quality.
- Developed scalable data pipelines for efficient processing and storage of data.
- Implemented ETL processes to ensure accurate data collection across sources.
- Established data governance policies to maintain compliance and integrity.
- Mentored junior staff, fostering professional growth within the organisation.
Automation Specialist
Invesco India Pvt Ltd
Hyderabad
04.2019 - 09.2021
- Designed and automated data workflows in Alteryx for portfolio performance analysis, risk modelling, and financial reporting, reducing manual data preparation time by 50%.
- Built interactive Power BI and Tableau dashboards to monitor AUM (Assets Under Management), portfolio allocation, risk exposure, and investment returns for traders and portfolio managers.
- Integrated cloud-based data pipelines to consolidate market data, client portfolios, and transaction records, ensuring scalability and high availability.
- Automated recurring portfolio monitoring tasks using Python (pandas, numpy) and Selenium, enhancing reporting turnaround for compliance and regulatory submissions.
- Partnered with investment and risk teams to deliver insights on portfolio diversification, asset allocation, and performance metrics.
Lead Data Analyst
Open Text Technologies India Ltd
Hyderabad
11.2018 - 03.2019
- Led a team of analysts in delivering end-to-end data solutions utilizing SQL, Python, Power Query, Power BI, Tableau, VBA, and automation tools.
- Designed and implemented cloud-based data pipelines (Azure/AWS/GCP) to integrate enterprise data sources, ensuring scalability and performance.
- Built and optimised business-critical dashboards in Power BI and Tableau for KPIs across banking, healthcare, and operations domains (e.g., Medicare/Medicaid enrollment, mortgage loan performance, collateral risk exposure).
- Drove automation initiatives using Python and Selenium, reducing manual reporting efforts by up to 70% and expediting decision-making.
- Collaborated with business stakeholders to transform requirements into actionable data models, ensuring compliance with regulatory standards (CMS, banking compliance).
Senior Analyst
Wells Fargo Information Services Pvt Ltd
Hyderabad
12.2015 - 11.2018
- Designed and optimised SQL queries and stored procedures to extract and validate loan, collateral, and customer data across wholesale banking systems.
- Developed Power BI and Tableau dashboards to provide real-time insights into mortgage loan performance, collateral risk exposure, and delinquency trends.
- Built Power Query data models to consolidate data from multiple banking systems, ensuring accuracy and consistency in financial reporting.
- Automated repetitive banking workflows using Python (pandas, openpyxl, selenium), decreasing data processing time by 60%.
- Implemented Selenium-based automation for web portals and internal loan processing systems, minimising manual intervention and errors.
- Partnered with business and risk teams to deliver analytics for loan underwriting, compliance, and risk management.
Business Ops Specialist
United Health Group Information Services
Hyderabad
09.2013 - 12.2015
- Constructed automated Excel dashboards, Access tools, and VBA macros to streamline Medicare/Medicaid member enrollment reporting, cutting manual effort by 50%.
- Developed and optimised SQL queries to extract, validate, and reconcile member enrollment, claims, and eligibility data across multiple systems.
- Designed Tableau dashboards to provide real-time insights into enrollment trends, claims status, and compliance KPIs for management.
- Automated web-based enrollment and claims data processing using VBA Selenium, reducing turnaround time for Medicaid/Medicare reporting.
- Implemented Python automation (pandas, openpyxl, selenium) to manage large healthcare datasets, improving accuracy and reducing processing time by 70%.
- Delivered end-to-end reporting solutions that integrated SQL, Excel, and Python.
Jr Executive
MOL Information Processing Services Pvt Ltd
Hyderabad
12.2011 - 09.2013
- Developed advanced Excel dashboards and automated templates, enhancing KPI tracking and decision-making efficiency.
- Created VBA macros to automate data cleaning, reconciliation, and report generation, reducing manual effort by 60%.
- Designed user-friendly Excel tools with custom forms and scripts to streamline reporting for non-technical teams.
- Wrote and optimised SQL queries to extract and validate large datasets, ensuring data accuracy and timely MIS reporting.
- Automated recurring reports by integrating SQL with Excel/VBA, cutting report turnaround time by 40%.
- Improved process efficiency by consolidating multiple data sources into single reporting framework.
Education
MBA - Finance & IT
JNTU
Madanapalle 08.2009 - 05.2011
B Sc - Computer Science, Statistics, Mathematics
SKSC Degree College
Proddatur 07.2006 - 05.2009
Intermediate - Mathematics
SVB Junior College
Proddatur 06.2004 - 05.2006
SSC - Mathematics
ZPH School
Proddatur 06.2003 - 05.2004
Skills
- SQL
- Python
- Power BI
- DAX
- Tableau
- Power Automate
- Power Apps
- Azure Data Factory
- Azure Data Bricks
- VBA Macros
- Teradata
- Alteryx
- R Language
- Pyspark
- Data Governance
- Machine Learning
- Deep Learning
- Predictive Modelling
- Clustering
- Time Series(ARMA, ARIMA, Auto ARIMA, SARIMA, HWM)
- Microsoft Fabric
- Statistics
- Regression
- Predictive Analytics
- Confluent
- Data architecture design
- ETL/ELT optimisation
- Hybrid cloud solutions
- Data governance frameworks
- Business intelligence integration
- Real-time data processing
- Scalable data pipelines
- Data visualisation strategies
- Exploratory data analysis
- Cloud platform expertise
- Stakeholder collaboration
- Data modelling techniques
- Big data handling
Timeline
Data Architect/BI Manager
GEMS IT
11.2024 - 12.2025
Senior Specialist, Data Engineering
LTIMindtree
09.2021 - 11.2024
Automation Specialist
Invesco India Pvt Ltd
04.2019 - 09.2021
Lead Data Analyst
Open Text Technologies India Ltd
11.2018 - 03.2019
Senior Analyst
Wells Fargo Information Services Pvt Ltd
12.2015 - 11.2018
Business Ops Specialist
United Health Group Information Services
09.2013 - 12.2015
Jr Executive
MOL Information Processing Services Pvt Ltd
12.2011 - 09.2013
MBA - Finance & IT
JNTU
08.2009 - 05.2011
B Sc - Computer Science, Statistics, Mathematics
SKSC Degree College
07.2006 - 05.2009
Intermediate - Mathematics
SVB Junior College
06.2004 - 05.2006
SSC - Mathematics
ZPH School
06.2003 - 05.2004