Venkata Hareesh Devarakonda
Specialist- Data Engineering
Hyderabad
Summary
7.6 Years of experience in the Information Technology industry and wide range of progressive experience in providing product specifications, requirement assessment, design, analysis, development, documentation, coding, enhancement, testing and implementation of the business technology solutions using Microsoft Power BI and IBM Cognos BI
Overview
7
7
years of professional experience
Work History
Specialist – Data Engineering
LTI Mindtree
12.2023 - Current
- Participated in Microsoft Fabric webinars
- Extensively used Azure Data Lake Gen2, Excel, CSV as data sources to import the data into Microsoft Fabric Lake house using Direct Lake model
- Created multiple Lake houses and Warehouses to store the data into Fabric
- Used SQL end points to query the Lake house data and applied relationships between the tables
- Used Dataflow Gen2 for applying transformations to the loaded tables in Lake houses and Warehouses
- Created and updated the default semantic models by creating new measures using Dax expressions
- Created Power BI reports on top of Lake houses and warehouses to capture the performance statistics
- Improved customer satisfaction rates through proactive problem-solving and efficient complaint resolution.
- Mentored junior team members, fostering professional growth through guidance on best practices in the industry.
- Collaborated with cross-functional teams to achieve project goals on time and within budget.
- Developed strong client relationships through consistent communication and attentive service.
- Monitored industry trends to adapt strategies accordingly.
- Created and delivered presentations to internal and external stakeholders to showcase work.
Specialist – Data Engineering
LTI Mindtree
04.2020 - 11.2023
- Extracting data from different kinds of source systems into Power BI and then cleansing the data by applying business rules and loading it into Power BI
- Gathering the requirements from business users and analyzing those requirements and providing estimates
- Understanding business requirements in BI context and design data models to transform raw data into meaningful insights by having appropriate relationships
- Creating data flows and datasets for various Power BI applications
- Creating Microsoft Power automated flows to refresh the data flows and datasets on hourly basis and daily basis depending on the user requirement
- Creating calculated measures and columns with DAX in Power BI desktop
- Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
- Implemented Role Level Security as part of user level security in Power BI
- SQL querying for best results, use of filters and graphs for better understanding of data
- Worked on On-Premises Gateway to refresh the data sources and scheduling the data
- Configuring Gateways in the power BI services
- Responsible for upgrading the gateway versions and Power BI desktop versions
- Creating Power automate flows for sequential refresh of multiple data flows and datasets
- Redefine and make technical/strategic changes to enhance existing Business Intelligence systems
- Deploying Data flows, datasets and reports from lower environment to higher environment.
- Migrated 50 + SAP BO reports and 70+ QlikView reports into Power BI
- Earned recognition as a top performer consistently exceeding targets throughout my tenure as a specialist in the field.
- Led successful presentations to prospective clients, resulting in increased partnerships and collaboration opportunities.
- Developed strong client relationships through consistent communication and attentive service.
- Created and managed project plans, timelines and budgets.
Senior Data Engineer
L&T InfoTech ltd
04.2018 - 03.2020
- Collecting the Requirements, analyzing the requirements and interacting with the client for better Understanding of business requirements and developing reports
- Worked closely with business teams to gather requirements, prepared functional documents and UAT feedback
- Developed around 20 Cognos reports within a month's duration, with each of the reports having specific design requirement
- Responsible for analyzing the Reporting requirements, Report design discussion, Report development, Unit Testing, Design Document and Unit testing Documentation, Functional/System Testing Support, UAT Defect Fixes and Deployment of Cognos components across the servers (Dev/UAT/Prod)
- Developed FM model for the entire Project involving complex table relationships which involved complex relationships between tables.
Software Engineer
L&T InfoTech Ltd
10.2016 - 03.2018
- Collecting the Requirements and analyzing the requirements and interacting with the Onsite coordinators to find the proper information
- Customized data by adding filters at both the Framework Level and Report Level
- Published different packages from Framework Manager to Cognos Connection
- Creating technical design documents and unit test cases
- Created package and published to the Cognos server
- Checking and fixing validation issues at Cognos
- Modified the existing Framework Manger Models to incorporate the new data elements
- Modified existing reports to incorporate the changes in the Source System
- Prepared Unit Test cases for report validation
- Responsible for code migration across environments (DEV, UAT, Prod)
- Responsible for documenting the code changes as per the User change requests
- Worked on priority data issues/report technical issues, on need basis.
Education
Bachelor of Technology - Computer Science
Narasaraopet Engineering College
Andhra PradeshSkills
Microsoft Fabric- Lakehouse, SQL end point, Warehouse, Semantic models
Power BI – Power BI Desktop, Power Query, Power Pivot, DAX, M language, Data modeling, Reports and Dashboards, Row level security (RLS), Object level security (OLS), Power BI service, Data flows,Semantic Models
Power Apps - Power Automate Flows
IBM Cognos BI – Query Studio, Report studio, Framework manager, Cognos Analytics
o Databases –MS SQL server 2012, Oracle 11g, IBM DB2
o Others – DAX Studio, Tabular Editor
Accomplishments
- Achieved Database Administration fundamental certificate from Microsoft.
- Attended various sessions on Microsoft Fabric
Timeline
Specialist – Data Engineering
LTI Mindtree
12.2023 - Current
Specialist – Data Engineering
LTI Mindtree
04.2020 - 11.2023
Senior Data Engineer
L&T InfoTech ltd
04.2018 - 03.2020
Software Engineer
L&T InfoTech Ltd
10.2016 - 03.2018
Bachelor of Technology - Computer Science
Narasaraopet Engineering College