Sudheer Kumar Pamu

• ·Developed and delivered business information solutions.
• Designed and developed analytical data structures.
• Built databases and table structures for web applications.
• I have been working on Copy activity, and Azure Data Factory pipeline activities for On-cloud ETL processing.
• Day-to-day activities like Monitoring and Tuning SQL Server Performance.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Explained data results and discussed how best to use data to support project objectives.
• Extensively used Oracle Analyzer and wrote Pl/Sql Queries using joins sub-queries, and correlated sub-queries.
• · Extensively working on Azure Data Factory for pipelines, Dataflow, scheduling, Azure Data warehouse, Azure SQL server and Azure Data sets
• · Worked on Data Transferring Azure blob data to Data Lake through ADF pipelines, and scheduled triggers.
• · Acting as Point of Contact in BI and Production Support issue resolution 24/7.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, and Azure SQL Data warehouse.
• Extract Transform and Load data from source systems to Azure Data Storage services using acombination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics.
• Responsible for estimating cluster size, monitoring, and troubleshooting of data bricks cluster
• Hands-on experience in developing SQL Scripts for automation purposes.
• Daily interaction with business stakeholders, gathering requirements, and managing delivery.
• Contributed to internal activities for overall process improvements, efficiencies, and innovation.

• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• · Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• · Developed Tableau visualizations and dashboards using Tableau Desktop.
• · Data Warehouse and data mart design and development using ETL, Data Prep and modelling tools.

· Building, publishing customized interactive reports and report scheduling using Tableau server.

• · Acting as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution 24/7.
• · Highly skilled in writing Parameterized Queries for generating parameterized reports and Sub reports using global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• · Create package to Extract, Transform and load data using SQL Server Integration Services (SSIS).

• Improved existing reporting by researching data sources, compiling data, and designing output.
• Produced quality reports formatted in compliance with data quality standards.
• Prepared monthly ad hoc reporting in alignment with client needs.
• Resolved variances in performance reports through root cause analysis and review of internal performance reports.
• Utilized in-depth analysis and creative problem-solving to troubleshoot reporting issues.
• Coordinated monthly meetings to discuss resolutions for exception reporting.

• Built databases and table structures for web applications.
• Modified databases to meet needs and goals determined during theplanning process.
• Identified issues within databases, performed troubleshooting, and implemented effective solutions.
• Developed and updated databases to handle customer data.
• Coordinated with project management on database development timelines.
• · Creating New SSIS packages and Migrating SSIS packages from SQL Server 2005 to SQL Server 2012.