ANUSHA GEDA

• Was responsible for implementing and delivering multiple migration project Activities like upgrading SQL Server 2008 R2 to Azure SQL Server, PDW to Azure synapse, Teradata to Azure Synapse
• Experience in most of collective Azure services like Data Factory, Azure SQL Server, Synapse Analytics, Data Lake, Storage Accounts
• Creating ARM Templates for provisioning ADF pipelines in Azure environment
• Creating objects like tables, external tables and external sources, stored procedures in azure environment according to source system
• Worked on rewriting SQL Stored procedures, views, functions compatible with target systems
• Creating pipelines, datasets, and mapping data flows in ADF pipelines
• Worked on loading different file formats like Delimited text, Parquet using ADF
• Worked on modifying SSIS packages and SSAS cubes compatible with Azure Synapse
• Established quality activities such as code reviews, integration testing and supported QC team
• Improved performance of long running queries after migrating to azure synapse analytics
• Wrote Power Shell scripts to automate/perform several migration operations like deploying DDLs , fixing specific patterns
• Experience in Azure DevOps Board, CI/CD Pipelines/Releases creation/execution
• Delivered multiple sessions on Azure DevOps pipelines, Azure Data Factory, Azure SQL deployment. This has resulted in successful Data factory orchestration for customer

• Interacted with Clients and co-workers in identifying Analyzing and Documenting the Business requirements
• Created reports using Crystal Reports, SSRS and EXCEL and published the reports using 1Key BI suite and Report server
• Developed reports on SAGE ERP and CRM data and deploying reports on client server
• Created Drill through reports, Drill down reports, Parameterized and Cascading reports using SSRS and
• Created packages using SSIS to transform the data and load into destination and deploying the package on live server
• Created Procedures, User defined Functions, Triggers, CTE
• Created cubes for reporting in SSAS along with calculated members and required hierarchies which include MDX queries
• Scheduling and monitoring ETL packages on Daily and Monthly basis
• Conducted Demo sessions to clients for a better understanding and usage of 1Key BI suite

ENVIRONMENT: CRYSTAL REPORTS, SQL SERVER 2008, PL/SQL, SSIS, SSRS, SSAS, 1KEY BI SUITE.

• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Reports accordingly
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for preparing reports
• Created Client reports, according to end user requirements using Business Objects Repository Functions and Formula
• Resolved complicated defects in existing reports
• Created Packages using SSIS and scheduling them on Monthly basis.