.

Nikhitha Vakkala

Toronto, ON 647-***-**** ady4zd@r.postjobfree.com

Professional Summary

● Highly skilled and results-oriented Azure Data Engineer with over 5+ years of experience in Microsoft Azure Data Stack, Microsoft BI tools, Power Platform, and PowerApps

● Designed and developed Power BI reports and dashboards from multiple data sources using data blending.

● Proficient in Microsoft BI Tools (SSIS, SSRS, and SSAS) and T-SQL using SQL Server

● Expertise with Microsoft Power Platforms (Power Apps, Power Automate, Power Virtual Agent, and Power BI) for app creation, process automation, and enterprise solutions

● Demonstrated expertise in utilizing top data migration tools such as Azure Data Factory and Azure Data Migration Service to seamlessly transfer vast volumes of data while ensuring integrity and minimizing downtime.

● Equipped with strong command of key technologies, including Azure Synapse Analytics, Azure SQL Database, Azure Cosmos DB, and Azure Databricks, adept at architecting scalable and efficient data pipelines, data lakes, and data warehouses. Skilled in data modeling, ETL

(Extract, Transform, Load), as well as ELT (Extract, Load, Transform) processes.

● Experience in developing interactive Tableau dashboards

● Experienced in T-SQL for creating and managing database objects, stored procedures, functions, and more.

● Experience in developing and debugging stored procedures and triggers.

● Administration tasks such as data loading, batch jobs, configuring IIS, backup and recovery, and more

● Utilized tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance for SQL Server performance tuning

● Hands-on experience in ETL using SSIS, including data extraction, transformation, and loading

● Implemented ETL processing using Custom Azure Data Factory Pipeline Activities

● Experience in handling dirty data from different sources

● Worked on BI DW projects using Microsoft Power BI, Informatica Power Center, SQL.

● Error handling and event handlers in SSIS packages

● Created SSIS packages for data integration using OLE DB connections and transformations

● Implemented data cleansing techniques in ETL procedures

● Built and deployed multi-value parameterized reports using Power BI and Tableau

● Implemented Row security (RLS) in Power BI

● Worked with Microsoft Power BI, Datazen, DAX expressions, Power View, and Power Query integrated with SharePoint

● Familiarity with reporting from a Data Warehouse environment and dimensional modeling

.

.

● CI/CD deployments and builds for database objects and SSIS projects using VSTS and Visual Studio

● Used Alteryx and SAP Information Steward for data cleansing and profiling before visualization

● Developed OLAP Cubes using SQL Server Analysis Services (SSAS) and defined data sources, dimensions, measures, hierarchies, and more

● Developed complex Crystal reports using custom SQL and unions

● Created a tabular model cube from scratch with different measures and dimensions

● Experience in performance tuning, processing, and deploying cubes

● Proficient in Linux shell scripting on AWS EMR, Postgres, Snowflake SQL, and Python scripting and AWS knowledge

Work History

CONVERGE TECHNOLOGY SOLUTIONS, INC.

AZURE DATA ENGINEER January 2022 - May 2023

● Analyzed client needs and designed effective ETL processes, including entity relationship diagrams and Data Modeling.

● Developed data migration strategies for Reporting solutions, ensuring alignment with clients' business requirements.

● Created and parameterized pipelines in Azure Data Factory to optimize data transfers and maximize efficiency.

● Performed troubleshooting activities to address environmental issues and ensure smooth data transit.

● Generated comprehensive documentation on ETL Design and post-production error correction procedures.

● Designed and executed test case scenarios to validate data integrity.

● Designed and maintained efficient data pipeline architecture, including constructing dimensions and fact tables.

● Implemented process improvements, automating tasks, optimizing data delivery, and enhancing infrastructure scalability.

● Built and managed infrastructure components for extraction, transformation, and loading of data using SQL.

● Utilized the data pipeline to derive actionable insights related to customer acquisition and operational efficiency.

● Assisted in designing the data warehouse.

● Provided guidance to PowerBI developers for report and dashboard creation and supported additional data requirements.

● Developed and maintained data pipelines based on the provided ETL design.

● Ensured continuous data transfer between databases, managing delta changes effectively.

● strategized and implemented data-moving methods to meet business requirements.

● Employed cost-effective data migration techniques to provide efficient solutions to clients.

● Managed pipeline triggers for timely coordination with other pipeline jobs.

● Led the creation of the client's Sales Cube, including importing data for reporting purposes.

● Performed data transformation using Databricks to meet reporting needs.

.

.

● Optimized the existing ETL design to reduce costs and improve efficiency.

● Maintained and troubleshooted pipelines and environments.

● Provided guidance and support to address network-related issues.

● Supported the ETL environment, ensuring timely delivery of data to clients and data scientists.

● Coordinated customer contacts, resolved reported malfunctions, and contributed to pipeline redesign efforts.

● Provided data on-demand, collaborated on code modifications, and manually triggered pipelines when required.

● Facilitated access to vendor reports for staff members to manipulate dashboards for the board of directors.

Technology Stack: Azure Data Factory, Databricks, Azure Dataflows, Azure DevOps, Azure Blob Storage, Synapse Analytics, Matillion, MS SQL Server 2012/2014/2016/2018, Management Studio (SSMS), ETL, DBT, Integration Services (SSIS) 2012, Power BI, Power BI (Pro), Tableau Server, Snowflake, Data Warehouse, Informatica, SQL Server Integration Service, Azure, SSMS, Jira (Scrum), T-SQL, PL/SQL, MDX. SQL Server Management Studio, Enterprise Manager, MS Visio, Erwin, Query Analyzer, SSIS, SSRS, SSAS, SQL Server DTS, and Sybase Visual Studio. INTERAC

SENIOR BUSINESS INTELLIGENCE DEVELOPER March 2020 - January 2022

● Utilized Azure Data Factory to orchestrate and manage data pipelines, ensuring efficient and reliable data movement between various data sources and destinations.

● Leveraged Azure Databricks for scalable and collaborative data engineering tasks, including data preprocessing, data transformation, and feature engineering.

● Implemented Azure SQL Database and Azure SQL Data Warehouse for storing and managing structured data, ensuring data integrity, and optimizing query performance.

● Used Azure Blob Storage and Azure Data Lake Storage to store and manage raw and processed data at scale, enabling easy data ingestion, exploration, and analysis.

● Employed Azure Synapse Analytics (formerly Azure SQL Data Warehouse) for large-scale data warehousing and analytics, enabling fast querying and reporting on massive datasets.

● Utilized Azure Cosmos DB to build globally distributed and highly scalable NoSQL databases, accommodating a wide variety of data types and providing low-latency access to data.

● Leveraged Azure Stream Analytics for real-time data processing and analytics, enabling the ingestion, transformation, and analysis of streaming data from various sources.

● Implemented Azure HDInsight to deploy and manage Apache Hadoop and Apache Spark clusters for big data processing and analysis, enabling distributed computing and parallel processing.

● Utilized Azure Machine Learning to build and deploy machine learning models, enabling predictive analytics and automated decision-making based on data insights.

● Implemented Azure Data Catalog to create a centralized catalog of data assets, facilitating data discovery, data lineage, and data governance.

● Leveraged Azure Monitor and Azure Log Analytics to monitor and troubleshoot data pipelines and data processing workflows, ensuring system reliability, performance, and scalability.

● Implemented Azure Data Explorer (ADX) to perform fast and interactive data exploration and analysis on large volumes of structured and unstructured data.

.

.

● Utilized Azure Data Share to securely and easily share data with external partners and stakeholders, ensuring data collaboration and governance.

● Implemented Azure DevOps for continuous integration and continuous deployment (CI/CD) of data engineering pipelines and workflows, ensuring efficient and agile development processes.

● Connected various data sources like Mongo DB, SQL Server, SAP Hana, AAS, ADW, SSAS flat files, Excel, CSV, etc., to Power BI Desktop using import, direct query, or live connect mode.

● Developed reports in Power BI Desktop and collaborated in My Workspace or App Workspace to share with team members.

● Extensive experience in the Microsoft Power Platform, including MS PowerApps, MS Power Automate, and Power BI.

● Used Alteryx Analytics for forward-looking predictive analytics and making critical business decisions.

● Evaluated business insight predictions using R and Python in BI reports.

● Validated reports in the Development, QA, UAT, and Production environments.

● Accessed and used PowerApps, Power Automate (MS Flow), and Power BI.

● Built Power Automate (Flows) to support multiple users on Power BI and Power Apps.

● Used SQL to analyze and collect sample data to understand the scope of reports.

● Extracted datasets from different data sources, including SQL Server, Excel, and flat files, to prepare datasets for Power BI.

● Created different types of reports based on customer requests.

● Created sub-reports and drill-through reports and deployed them to SharePoint Server.

● Created SSIS packages to export data from text files to SQL Server Database.

● Created SQL Server Reports and developed queries for generating drill-down and drill-through reports using SSRS.

● Used Visual Studio Team Services (VSTS) for version control, documentation, and creating data dictionaries.

Technology Stack: Azure Data Factory, Databricks, Azure Dataflows, Azure DevOps, Azure Stream Analytics, Azure Blob Storage, Synapse Analytics, MS SQL Server 2008/2012 Enterprise Edition, MS SQL Server Reporting Services 2012, Power BI,SQL Server 2017/2019 Azure, SSMS, T-SQL, PL/SQL, Enterprise Manager, Profiler, MS Visio, SSIS, SSRS, RLS, SSAS, SQL Server DTS, Sybase, Visual Studio, Excel, SQL, and BO.

GO RIGHT

SQL/ BI DEVELOPER May 2018 - March 2020

● Involved in the complete SSIS life cycle, including creating packages, building, deploying, and executing them in both Development and Production environments.

● Utilized Java APIs to call stored procedures.

● Analyzed complex business requirements and functional specifications of client modules.

● Performed functional analysis of specifications and tracked customer tickets, resolving problems.

● Developed complex T-SQL code, including Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, and Views, following SQL code standards.

● Designed, developed, and tested reports in Power BI based on KPIs and Requirements Documents.

.

.

● Prepared design documents, design patterns, and component design specifications, estimating project time.

● Used SSIS variables to capture package start time, end time, and failure, enabling dynamic execution.

● Designed SSIS packages to transfer data from DB2, flat files, and Excel documents to the Staging Area in SQL Server.

● Migrated reporting from Tableau and Cognos to Power BI

● Assisted in migrating SQL Server databases to SQL Azure databases using SQL Azure Migration Wizard and deploying applications to Azure Cloud.

● Designed and developed SQL Server Analysis Tabular models on the Windows Azure ADF platform.

● Created reports in Power BI with large datasets, involving facts, figures, and number processing.

● Gathered information from end users and enhanced existing applications (C#.Net, VB.Net, and SQL Server) according to requirements.

● Monitored workflows using SharePoint Designer 2013 and implemented Event Handlers and Error Handling in SSIS packages.

● Developed applications in Visual Studio 2010 and 2012, primarily using C#.

● Built Power BI Dashboards using Tabular Models, designing and modeling data sets based on customer requirements.

● Possess strong knowledge of Power BI, including data import, shaping, and transformation, report authoring, automated report refresh, and dashboard creation and sharing.

● Actively resolved production and maintenance tickets related to ETL tasks.

● Implemented ETL for Slowly Changing Transformation in order to maintain Historical Data in the data warehouse.

● Prepared templates for functional specifications, technical specifications, unit test cases, and string test cases.

● Implemented internal Cognos Security, including Column Level and Row level security, using Security tables, Security filters, Macros, Session Parameters, and Parameter Maps.

● Experienced in writing complex formulas and SQL queries in Crystal Reports using Crystal Designer and migrating Crystal Reports across different versions. Technology Stack: MS SQL Server 2016/2014/2008, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2014/2013/2012, C#, KPI, SQL Server Profiler, Azure Cloud, ADF, Azure SQL Database, Azure Data Lake, Azure Blob, OBIEE, Power BI Service, Power Query, Power Pivot, Power Designer, Tabular Models, SQL Server Management Studio, Team Foundation Server (TFS), Business Intelligence Development Studio (BIDS), Business Objects, Jasper Soft Studio. Technical Skills

RDBMS/DBMS: MS SQL Server 2016/2014/2012/2008R2/2008/2005/2000, MySQL, and MS Access 2003/2000/97

Database

Technologies/Tools:

SQL Server Enterprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, and OLAP. Microsoft Visio, ER Studio

.

.

Databases: Azure SQL Database, Azure Data Warehouse, Azure Data Factory, Azure Data Synch, MS SQL Server 2008 R2, 2012, 2014, 2016, MySQL, and Oracle12c.

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), and Azure Blob Storage. Cache using Pipeline and SSIS, Data Migration Service (DMS), Azure SQL Data.

Reporting Tools: Power BI, Power Platform, Power Apps, Alteryx, Informatica, OBIEE, Qlikview, SQL Server Reporting Services, Crystal Reports, Excel. Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, and Windows 7

Programming

Languages:

T-SQL, Python, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts

Design

Technologies/Tools:

Erwin, MS Visio, and Rational Rose

Data Warehouse /

Business Intelligence

Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services

(SSIS), Visual Studio 2016/2014/2013/2010/2008, SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012, / Visual Studio Shell

Education and Training

● PG Diploma in Research and Analytics at Centennial College

● PG Diploma in Corporate Account Management at Centennial College

● Bachelor of Science in Business Administration (BSBA) from PES University

.

Contact this candidate