Ruthvik Garlapati
Summary
Results-driven Azure Engineer and BI Consultant with five years of experience in designing, developing, and implementing advanced cloud-based and on-premises Business Intelligence (BI) solutions. Adept at leveraging Microsoft Azure services and BI tools to deliver actionable insights, optimize data workflows, and drive strategic decision-making. Demonstrated expertise in cloud architecture, ETL processes, data warehousing, and reporting solutions. Proven track record in leading BI projects, optimizing SQL queries, and building scalable data models. Led a successful migration project to Azure Data Warehouse, achieving a seamless transition with improved system performance and scalability. Developed a Power BI dashboard, which provided real-time insights and significantly improved decision-making processes.
Overview
5
5
years of professional experience
Work History
Azure Engineer and BI Consultant
Apple Express
12.2023 - Current
- Proficiently developed and maintained complex T-SQL queries, stored procedures, and SSIS packages for robust data integration and warehouse loading
- Designed SSIS packages for efficient data transfer from flat files and Excel to SQL Server, streamlining data import processes
- Managed the complete SSIS package lifecycle, from creation to deployment, ensuring reliable ETL processes in both development and production environments
- Implemented star and snowflake schemas in data warehouses, enhancing data modelling and reporting for business intelligence
- Executed SQL Server database migrations to SQL Azure, ensuring seamless data transfer to cloud environments
- Designed and deployed OLAP cubes using SSAS with star and snowflake schemas, enabling comprehensive data analysis
- Developed interactive dashboards and reports in Power BI, using DAX for calculated columns and measures to deliver detailed insights
- Created and refined Tableau dashboards, developing visualizations tailored to specific business needs
- Configured and managed Azure Data Lake and Azure Storage for optimized data access and processing efficiency
- Developed and deployed CI/CD pipelines in Azure DevOps, automating deployment and improving development efficiency
- Implemented data security measures, including role-based access and encryption, to protect sensitive information
- Performed data profiling, cleansing, and validation to ensure high data quality and integrity across BI solutions
- Troubleshoot and optimize the performance of SSIS packages, SSRS reports, and SSAS cubes, improving overall system efficiency
- Utilized tools like SQL Profiler for query optimization, significantly enhancing query execution times
- Led data migration projects, effectively consolidating data from legacy systems to modern platforms
- Provided technical support and troubleshooting for BI solutions, ensuring continuous service availability
- Engaged with business users to translate their needs into technical BI solutions, delivering on user expectations
- Evaluated emerging technologies related to Microsoft Azure services to identify areas for future growth or improvement initiatives within the organization''s IT landscape.
- Conducted regular reviews of system logs and performance metrics to identify trends or anomalies that may signal areas for improvement in the Azure environment.
- Created, updated and maintained Azure security standards and best practices across Azure domain.
- Developed and implemented security measures for Azure environments, ensuring data protection and compliance with industry regulations.
Azure BI Developer
Goeasy
09.2022 - 12.2023
- Employed data transformation methods such as Slowly Changing Dimensions, Aggregates, Sorting, Multitasking, Conditional Splits, and Derived Columns to manage data and meet business needs effectively
- Designed, reviewed, and created critical database objects like views and indexes based on logical models and user requirements to ensure optimized database performance and reliability
- Developed SSIS Packages to efficiently transfer data from various sources, including Text Files and XML, improving data integration and accessibility
- Built and maintained SSIS Packages for importing and exporting data from diverse sources using BIDS, streamlining ETL processes and enhancing data integration
- Successfully transitioned legacy SSIS packages to Azure Data Warehouse, upgrading to a modern cloud-based solution and improving data management capabilities
- Utilized the SSIS toolset to design and implement complex mappings and transformations, such as OLEDB Command, Conditional Split, Lookup, Aggregator, and Multicast, to optimize data processing workflows
- Executed ETL tasks, including FTP operations, Merge, Merge Join, Sort, Pivot, and Unpivot transformations to prepare data for analysis, enhancing data handling efficiency
- Configured Spark clusters for high concurrency in Azure Databricks, boosting the speed and quality of data preparation for analysis and reporting
- Implemented Copy Activities and Custom Pipeline Activities in Azure Data Factory and designed Dimensional and Fact Tables for an Enterprise Data Warehouse, optimizing ETL workflows
- Crafted advanced T-SQL queries and stored procedures for constructing SSIS packages, generating SSRS reports, creating Tableau visualizations, and enhancing data manipulation and reporting capabilities
- Developed and scheduled tasks for reloading and distributing data in Tableau, ensuring timely and accurate updates for reporting and analysis
- Created executive scorecards and summary dashboards in Tableau to monitor performance metrics, delivering actionable insights and performance evaluations to stakeholders
- Refined Tableau dashboards by integrating data from multiple sources, providing dynamic visualizations to support business decision-making
- Developed detailed reports on Power BI Desktop and published them to Power BI Report Server, offering comprehensive data visualizations and insights
- Created Calculated Columns and Measures in Power BI and Excel using DAX queries to address specific reporting needs, enhancing data analysis capabilities
- Designed analytical reporting visualizations in Power BI, including trendlines, donut charts, and bubble filters, to support data analysis and business intelligence
- Produced and scheduled SSRS reports, defined data sources, and utilized Report Builder for on-demand queries and email delivery, improving reporting efficiency and flexibility
SSIS/SSRS/ETL Developer
Bank of Baroda
02.2020 - 08.2022
- Facilitated practical technical discussions by leading technical discussions and decision-making processes for business requirements, collaborating with Business Analysts, client teams, and development teams to ensure alignment on project objectives and deliverables
- Optimized database design and data modelling by developing comprehensive database designs and models, applying best practices to structure schemas, define constraints, and create views, resulting in efficient database solutions for complex business requirements
- Ensured high data quality for migration by analyzing data quality, validating data, and mapping data from various sources to SQL server databases, providing accurate and reliable data migration through meticulous data management techniques
- Designed robust SQL server databases, including table designs, schemas, and constraints, to support scalable data solutions and improve data organization and integrity
- Developed, reviewed code, fixed bugs, tested, and deployed SSIS packages using SQL Server Business Intelligence Development Studio, achieving reliable data integration and ETL processes
- Designed SSIS packages with transformations like Slowly Changing Dimension, Lookup, Aggregate, and Conditional Split, which streamlined data loading processes into the Data Warehouse
- Utilized SSIS transformations, including Slow Changing Dimension, Lookup, Conditional Split, Sort, Merge Join, and Data Conversion, to manage complex ETL processes for data warehousing
- Analyzed business requirements to design and implement data mart solutions for data mining and reporting, providing users with accessible and actionable business intelligence
- Designed and developed complex reports such as Drill Down, Drill Through, and Cross Tabbed reports using MS Reporting Services, delivering clear and informative data visualizations
- Collected report requirements and designed diverse report types, including Matrix, Table Reports, Dashboards, and Subscription Reports, meeting user needs for detailed data analysis
- Created AD-Hoc report models with drill-down and drill-through functionalities using SSRS, offering flexible and on-demand reporting solutions tailored to specific business requirements
- Ensured referential integrity and data consistency and implemented indexing and cleanup procedures, resulting in high-quality data for reliable reporting and analysis
- Identified issues and developed procedures to correct data problems, improving the quality of critical tables and preventing duplicate data entry into the Data Warehouse
- Applied data blending techniques to merge data from different sources, creating unified datasets for comprehensive analysis and reporting
Education
Bachelor of Technology -
Gayatri Vidya Parishad College of Engineering
Visakhapatnam, Andhra PradeshSkills
- Azure Data Factory
- Azure Data Lake
- Azure Synapse Analytics
- Azure SQL Database
- Power BI
- SSRS
- SSAS
- ETL
- SSIS
- Cloud Architecture
- Data Warehousing
- Data Modeling
- Star Schema
- Snowflake Schema
- OLAP
- Query Performance Tuning
- Data Cleansing
- Agile
- SCRUM
- Client Engagement
Timeline
Azure Engineer and BI Consultant
Apple Express
12.2023 - Current
Azure BI Developer
Goeasy
09.2022 - 12.2023
SSIS/SSRS/ETL Developer
Bank of Baroda
02.2020 - 08.2022
Bachelor of Technology -
Gayatri Vidya Parishad College of Engineering
Similar Profiles
Nesty MacasaquitNesty Macasaquit
Parcel Sorter at Apple expressParcel Sorter at Apple express
Michael GasanaMichael Gasana
Courier Contractor at Apple ExpressCourier Contractor at Apple Express
Gurtrj SinghGurtrj Singh
Fork Lift Operator at Apple ExpressFork Lift Operator at Apple Express