SHIRISH REDDY GANGULA
Highly skilled, competent and diligent individual seeking an opportunity to establish career as a Data Scientist.
- Meticulous and highly accomplished certified in Designing Business Intelligence Solutions with Microsoft having 8 years of experience as MSBI Developer in IT industry with expertise in Azure Data Platform services Azure Data Factory (ADF),SynapseAnalytics,DataLake(ADLS),MSBI:SSIS,SSMSandPower BI.
- Have been toOnshore to different client locations for GOLIVE deployment and Migration activities of solution toProduction.
- Expertise in Application development, Migration, PerformanceEnhancement.
- Result oriented decisive professional to maintain high quality standards to meet challenges of this fast paced, high turn industry; Highly ethical, trustworthy and discreet.
PROFILE SUMMARY
- Understanding Business Specification document /Source map document for creating ETL packages andReports
- Build multiple Data Lakes based on how the data will be received, validated, transformed and thenpublished
- Experience in implementing hybrid connectivity between Azure and on - premise using virtualnetworks.
- Excellent skills in implementing ETL Packages using SSIS2014/2016/2017/2019.
- PlanandDeveloproadmapsanddeliverablestoadvancethemigrationofexisting solutions on-premise systems/applications to Azurecloud
- Experience with Azure transformation projects and Azure architecture decision making Architect and implement ETL and data movement solutions using Azure Data Factory,SSIS
- RecreatingexistingapplicationlogicandfunctionalityintheAzureDataLake,Data Factory, SQL Database and SQL Datawarehouseenvironment
- Engage with business users to gather requirements, design visualizations and provide training to use self-service BItools.
- Developdashboardsandvisualizationstohelpbusinessusersanalyzedataaswell asprovidingdatainsighttouppermanagementwithafocusonMicrosoftproducts like PowerBI.
- Extensively worked with transformations such as Alter Row, Select, Joins, Derived Column,Flatten,ConditionalSplit,Exists,Union,Switch,Foreach,GetMetData,Delete etc.
- Experience in implementing various ETL Data Transformations to load data intoData Warehouse and in PerformanceTuning.
- Won several laurels and appreciations for my hard work and effort shown inmeeting the projectdeadlines.
TECHNICAL QUALIFICATIONS
ETL Tool
:
Azure Data Factory, Azure Synapse, SSIS
Reporting Tool
:
Power BI.
Database
:
Azure SQL Database, SSMS
Operating Systems
:
Windows
Educational Qualifications
Master of Science with specialization in Biotechnology from Periyar University, 2008
Certifications
MICROSOFT CERTIFICATION EXAMS COMPLETED SUCCESSFULLY: MCID- 11727061
Exam ID
Description
Date Completed
DP-203
AZ-900
Azure Data EngineerAssociate
Microsoft AzureFundamentals
July 152022
Aug 052020
762
Developing SQL Databases
Sep 15, 2017
462
Administering Microsoft SQL Server 2012/2014 Databases
Jan 03, 2017
461
Querying Microsoft SQL Server 2012/2014
Dec 28, 2016
533
Implementing Microsoft Azure Infrastructure Solutions
Jan 31, 2016
532
Developing Microsoft Azure Solutions
Jan 08, 2016
466
Implementing Data Models and Reports with Microsoft SQL Server
Nov 30, 2015
463
Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
Oct 05, 2015
467
Designing Business Intelligence Solutions with Microsoft SQL Server
Feb 26, 2015
UI Path RPA DEVELOPERFoundationDiploma Feb 23,2018
Professional Experience
Confidential, Hyderabad
Current Designation: Associate Consultant (Data Engineer)
&n