RameshBabu Nakka

• Develop/Design and maintain interactive data exploration and visualization Reports
• Writing SQL scripts and creating stored procedures
• Develop interactive decision-supportive reports using Microsoft Relational Databases, Reporting Services, and PowerBI technologies
• Performance improvement of the database through indexes and statistics
• Performance improvement of SQL/reports by creating optimized queries
• Unit testing and bug fixing.

Tools and Technologies: Microsoft SQL Server, Azure Data Factory, BitBucket, SQL Management Studio, SourceTree, Visual Studio, Microsoft SSRS

• Migrating the DWH Development, Data Transformation work, DWBI, ETL processing, Reporting Analysis
• Created a New Dimension by using a Data Map and Conceptual Data Model
• Updated New SAP attributes and added to that dimension are present in the Data Map
• Worked on updating role-playing dimension schema
• Generated New SQL & Metadata scripts by using a Dimensional Modelling Workbook
• Executed that script using Azure data bricks in deployment.

Tools and Technologies: Azure Data Factory, Azure Databricks, Azure SQL Database, Azure Data Factory, Azure SQL Microsoft, Azure Storage, Microsoft SQL Server, Microsoft Azure

• The core aim of this project was to support the broader set of analytic needs
• This data Warehouse design process includes data extracted periodically from the applications that support business processes and validated, reformatted, reorganized, summarized, restructured and finally loaded into Data warehouse systems
• The resulting data warehouse is the main source of information for report generation, analysis, and presentation through ad hoc reports and dashboards
• Preparation of ETL Design Documents
• Implementation of data extraction, transformation, and loading (ETL) processes
• Creation of package configuration to handle data source connection information
• Implementing Logging for each SSIS package
• Design and deployment of different reports in tabular, Matrix, Graphical for interactive analysis
• Creation of report subscriptions to send the reports by mails by scheduling the reports
• Providing report level securities for end used
• Creation of Sql server agent jobs with SSIS packages to run daily ETL's at schedule times.

Tools and Technologies: SQL SERVER 2012, SQL Server Integration Services & Reporting Services, SQL & TSQL

• British Airway Authority which have two location - Heathrow and Stansted Procurement of office goods , home offices etc
• Company has main head quarters in London
• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Data Tool 2012
• Used SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse databases, data mart databases
• Developed SSIS Templates that can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test, and Production Environments
• Executing data validation stored procedures in SSIS packages in the Business Intelligence Development Studio (BIDS)
• Involved in the Deployment and Administration of SSIS packages with Business Intelligence development studio
• Developed, monitored, and deployed SSIS packages
• Performance tuning of Stored Procedures and T-SQL Queries
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports
• Worked On testing of Report against actual data in Database.

Tools and Technologies: SQL SERVER 2012, SQL Server Integration Services & Reporting Services, SQL & TSQL