SUDHEER PAMU

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs
• Very good experience in data mining and data analytics
• Created Drill-down and Sub-Report using SSRS
• Monitored the performance of the reports
• Performance tuned data warehouses, data marts and reports for high volume data in Oracle
• Built dashboards for measures with forecast, trend line and reference lines
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security
• Worked on Creating calculations and parameters to change data dynamically
• Developed Employee scorecard reports which track all the employee’s hours spent in different projects, track time, break span and all other major information needed for the business
• Used various types of aggregations like sum, average, count, count (distinct), median, minimum, maximum, percentile and std
• Deviation, etc
• To build strong informative dashboards
• Provided 24/7 Level 3 support for critical production issues leading to greater customer satisfaction
• Scheduled and executed SSIS Packages using SQL Server Agent
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and statistics updates
• Monitoring SQL server performance using profiler to find performance and deadlocks
• Worked on database design for Query optimization, performance tuning and Indexing
• Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, BCP, Oracle, Tableau, Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server.

• Developed Oracle statements using Pl/sql and defined Referenced relationships with the measure groups and fact tables
• Good in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access
• Writing Stored Procedures, Triggers, cursors and creating indexes
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks to analyze CPU, Memory and Disk usage patterns
• Planned the complete backing up of Databases and Disaster Recovery /Restore procedures
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler
• Configured monitoring jobs to monitor CPU usage, Blockings, Login tracking, Tempdb utilization on Production servers in SQL/Oracle
• Responsible for database development in SQL Server 2008, worked on T-SQL functions and SQL syntax
• Used DTS Packages to move logins and jobs from one server to another server
• Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS), SQL Profiler, Oracle, Windows XP/2000 and Windows 2003/2008 Server.

• Installation of SQL Server 2005/2008 on production, development and testing environments
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services 2005
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink), Parameterized Reports(single valued parameters, multi-value parameters) etc
• Created Stored Procedures, DTS packages, tables, views and SQL joins and statements for applications
• Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle
• Created Perspectives and defined security, roles for different group of users
• Installing and configuring the SQL Server 2005 and SQL Server 2008 on windows 7 servers
• Creating New SSIS packages and Migrating SSIS packages from SQL Server 2005 to SQL Server 2008
• Implementing Backup and recovery process and Replication process
• Developed Queries for generating drill down reports in SSRS and prepared AD HOC reports through report builders
• Defined the report layout and identified Datasets for the report generation
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications
• Created indexes on the database tables and generated trace events to improve the query performance and optimize data access in Oracle
• Designed and Implemented the Stored Procedures for automating tasks
• Environment: SQL Server 2005/2008/2008 R2, SSIS, Oracle, Enterprise Manager, Windows 2000/2003, SQL Profiler, T-SQL.

• Daily interaction with business stake holders, gathering requirements and managing the delivery
• Implemented Copy activity, Azure Data Factory pipeline activities for On-cloud ETL processing
• Day to day activity like Monitoring and Tuning SQL Server Performance
• 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, Synapse Analytics, Azure Data warehouse, Azure SQL server and Azure Data sets
• Worked on Data Transferring Azure blob data to Data Lake though ADF pipelines, scheduled triggers
• Acting as a 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, Azure SQL Data warehouse
• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics
• Responsible for estimating the cluster size, monitoring and troubleshooting of the data bricks cluster
• Hands-on experience on developing SQL Scripts for automation purpose
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction
• Environment: Azure Data Lake, Data factory, Azure Databricks, Azure SQL database, Azure SQL Datawarehouse, SQL, Oracle Developer, Data Visualization, Toad and MSBI.

• Experience on Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and granting database access
• Worked on Azure Data Factory for pipelines, scheduling, Azure SQL server and Azure Data sets
• Experience on SQL scripts for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns
• Strong skills in visualization tools Power BI, Confidential Excel - formulas, Charts and DAX
• Creation of metrics, attributes, filters, reports, and dashboards
• Created advanced chart types, visualizations and complex calculations to manipulate the data
• 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)
• Environment: Oracle Application Server 10g, Azure Data Factory, Oracle Identity Management, Oracle Web Tier, Oracle Web Logic, Oracle Web Center.

Creating and maintaining various databases on Production and development environments using oracle 11g/10g

• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD type of analysis
• Handling the monitoring application, based on Oracle Enterprise Manager for issues like errors, threshold breach, report generation, etc
• Automation of Various tasks including bouncing Siebel servers, deployment activities, Report generation
• Expert in performance tuning the Oracle queries, stored procedures and other slow running worksheets, SSRS reports or Tableau Dashboards
• Troubleshoot Web Logic Server connection pooling and connection manager with Oracle database
• Carried out the Merge process as defined in the usage model in each project
• Ownership of release branch
• Creating Database designing, Tables, Data marts for multiple databases and delivering all modules on-time without fail, meeting client satisfaction all the time
• Defined the report layout and identified datasets in all reports for the report generation
• 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
• Developed datasets to perform reporting and included interactive drill down reports and ad-hoc reports
• Trouble shooting various SQL server 2012/2008/2005/2000 Database connectivity issues from the web applications
• Environment: MS SQL Server 2012/2008R2, T-SQL, SSIS, SSRS, Report Builder, Tableau, Power-BI, SQL Profiler, Windows XP/2000 and Windows 2003/2008 Server.