SUMMARY:

• Over 9 years of MS SQL Server Support experience in Telecom, Banking, Retail & Manufacturing, and Internal Infrastructure Services domains with expertise in MS SQL Server 2000/2005/2008/2008 R2 and Confidential ’s suite of products like SSIS, SSAS, and SSRS.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, Rules, Defaults, User Defined Functions, views, indexes, user profiles, Relational Database models, query writing and SQL joins.
• Expert in Performance Tuning, Handling Indexes, and Query Optimization
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations in the development of SSIS packages.
• Identified and resolved problems encountered during development and release of the SSIS code.
• Developed, Monitored and Deployed SSIS Packages from Development environment to Production environment.
• Developed ETL packages using SQL Server 2008/2012 Integration Services to populate data from different sources like flat files/CSV Files to Staging Databases. The packages include wide variety of transformations like Look Up, Aggregate, Derived Column, Conditional Split, MultiCast and data conversion, Script tasks.
• Actively involved in different stages of Project Life Cycle.
• Participated in gathering Business Requirements and System specifications.
• Worked on script components is SSIS using VB.NET scripts and schedule Jobs and Alerts using SQL Server Agent.
• Involve in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Perform all scenarios of testing Transformation Rules, Referential Integirty, Data Integirty, Scenario Based Testing and creating statistical reports which include Pie Charts, Bar Charts using SSRS.
• Responsible for Database Backups and Restore on Daily Basis.
• Migrate Databases from one environment to other environment.
• Maintain versions using TFS.
• Test several stored procedures.
• Test the ETL Process for both before validation and after data validation process. Test the messages published by ETL tool and data loaded into various databases.
• Experience in working in SCOM, SCSM and STAR User Stories in Service Engg Architecture in Confidential .
• Experience in working in SQL Azure and Windows Azure (IaaS and PaaS)
• Knowledge on Big Data, Hadoop Framework and distributed technologies architecture. Aware of Big Data applications from Confidential .
• Experience in working in Power BI and knowledge of SQL Server PDW.
• Experience in creating user stories, scorecards and dashboards in Tableau in creating good data visualizations for the business.
• Manage Logins, Users, Roles and User Permissions.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations
• Experience in Deploying the created SSIS packages in Development and Testing environments.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
• Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2005.
• Extensive experience in working in Crystal Reports, Business Objects. Knowledge of creating BO Universes.
• Can code and understand Java code, JSON scripts, Python scripts, NodeJS scripts (NOSQL).
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Expert in creating cubes and dimensions, handling multi-dimensional reports
• Generated the Reports with all the subcategory Information to Business users.
• Developed and Deployed different types of Reports like Ad Hoc, List, Drill Down, Drill Through,Matrix, Chart and Sub Reports etc.
• Having work experience in Confidential Biz Talk Servers and Internet Information Servers (IIS).
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Strong communication skills when working with stakeholders, developers, project managers, system implementers, and application end-users.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

Relational Databases: MS SQL Server 2016/2014/2012/2008 R2/2008, MS Access, Oracle

T: SQL,C, VB.Net, DAX, MDX

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL, IIS (4.0/5.0/6.0/7.0 ), JSON, JQuery, ASP.Net

Documentation Tools: MS Office, MS Outlook ( Confidential Office Suite), MS Visio

Integration Tools / Data Acquisition Tools: SQL Server Integration Services(SSIS), Informatica

BI Analytics and Reporting Tools: SQL Server Reporting Tools (SSRS), SQL Server Analysis Services (SSAS), MS Excel, Business Objects XI (SAP BO XI), Universe creation, Crystal Reports.

Data visualization tools: Tableau Desktop, Power BI Desktop, Power BI Analytics Server, Tableau Server

Middle Ware Technologies: Biz Talk Server, Sharepoint

Monitoring tools: SCOM, SCSM, STAR User Stories in Service Engg at Confidential

Distributed Technologies: Windows Azure, SQL Azure, Big Data and Hadoop Framework

OOP Technologies: Java, C++, C#.NET

No SQL Technologies / Big Data: JSON, Python, Amazon RedShift

Confidential Cloud Technologies: Confidential Azure (IaaS, PaaS), Azure DW

Statistical Tools & Models: R, SAS

EXPERIENCE:

Confidential, Renton, WA

Sr MSBI Developer

Responsibilities:

• Analyze the existing source system schema and develop the STM(Source To Target) Mapping for the warehouse.
• Identify the filters that are to be applied to bring in data for facts and dimensions.
• Identify the potential dimensions from the Source System
• Understand the business requirements of GTF and develop the technical specification document for sign off by business for development
• Creating SSIS Packages, Transformations to develop the data into Sourcing ODS from Source system - SP and CRM.
• Creating the Config tables for Incremental load and error handling in SSIS packages
• Implemented SCD Type 1 and Type 2 dimension using SCD transformation and other transformations like Lookup and Merge Join.
• Created Tables, Facts, Dimensions and Staging Environment, Staging tables to facilitate ETL and warehouse development.
• Use of Kingsway Soft extension for pulling data from Dynamics CRM Source system into Sourcing ODS.
• Used industry best practices for error handling, logging, table design and
• Gathering the cube and reporting requirements and developing the cube in tabular mode as per business requirements.
• Created calculated metrics using DAX functions.
• Developed powerful Power BI dashboards using Power BI desktop and publishing it in the Power BI Analytics server.

Confidential, Redmond, WA

ES Analytics - Data Analyst

Responsibilities:

• Analyzing existing applications in both the business platforms like JADE and PSR and combining them into one platform.
• Create Business Requirements Document, Source to Target Mapping (STMs) document for the attributes for dimensions and facts.
• Identify the potential dimensions and facts and the calculations that are used in these applications and work towards solutions of deriving these measures in ES Analytics warehouse
• Integrations, Transformations and Code by Code(T-SQL) study of the intending business definition arrival of each metric, measure and dimension in the existing platforms and providing business scenarios.
• Data analysis of the fact tables and identify the granulaity of the data.
• Create Technical specification document for developers to develop and code the requirements.
• Derive new dimensional schemas and facts for the new requirements that come from the business for the ES Analytics platform.

Confidential, Redmond, WA

Data Analyst Service Engineer

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Maintanenance, Development and support of SSIS Packages, SQL Jobs for smooth functioning of OPX Application and sending daily status reports on Day to Day basis to business teams of upstream and downstream applications of OPX.
• Analyzed the bugs and issues created in Team Foundation Server and fixed the issues
• Bits are deployed for the corresponding Bug and issues in future releases.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Monitoring SCOM Alerts and fixing issues and training the SO Team for known issues.
• Raising CRs and follow ups with the Dev, PM Teams on the gaps in release to fix production issues and identify potential production impact issues with each release
• Drive each release cycle from Start to End. Creating STAR User Stories for Service Engineering Stream to track the User Stories created by Dev teams.
• Coding for creation of simple tools for the team for better monitoring.
• Excellent report creation skills using Confidential Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Understanding the report design Requirements and Constraints.
• Created Drill-down, Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server (SSRS).
• Involved in the design of the UI and developed new button designs in JQuery for the chat application UI.
• Reports are developed in Power Pivot in Excel and SSRS.
• Supporting the application in case of any critical issues. Issues are first reproduced in Test Env and later in UAT and then moved the bits to production.
• Adhoc reporting for business needs and monitor ETL for any issues and sending timely communication on planned or unplanned outages.
• Server upgrades, scheduled downtime mails to business and sending business alerts in case of ETL or outage issues.
• Created scorecards, dashboards and user stories using Tableau Desktop and using SSAS OLAP cube (MDX) and SQL Server as source systems.

Confidential, Redmond, WA

MS BI BI Data Analyst

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Maintanenance, Development and support of SSIS Packages, SQL Jobs for smooth functioning of OPX Application and sending daily status reports on Day to Day basis to business teams of upstream and downstream applications of OPX.
• Analyzed the bugs and issues created in Team Foundation Server and fixed the issues
• Bits are deployed for the corresponding Bug and issues in future releases.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Confidential Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Understanding the report design Requirements and Constraints.
• Created Drill-down, Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server (SSRS).
• Involved in the design of the UI and developed new button designs in JQuery for the chat application UI.
• Reports are developed in Power Pivot in Excel and SSRS.
• Supporting the application in case of any critical issues. Issues are first reproduced in Test Env and later in UAT and then moved the bits to production.
• Adhoc reporting for business needs and monitor ETL for any issues and sending timely communication on planned or unplanned outages.
• Server upgrades, scheduled downtime mails to business and sending business alerts in case ofETL or outage issues.
• Created scorecards, dashboards and user stories using Tableau Desktop and using SSAS OLAP cube (MDX), Flat File, MS Excel, SQL Server as source systems.

Confidential, Philadelphia, PA

MS BI SQL Analyst Developer

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Analyzed the bugs and issues created in Team Foundation Server and fixed the issues
• Bits are deployed for the corresponding Bug and issues in future releases.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Confidential Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Understanding the report design Requirements and Constraints.
• Created Drill-down, Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server (SSRS).
• Involved in the design of the UI and developed new button designs in JQuery for the chat application UI.
• Reports are developed in Support Soft. These reports are successfully re-created and migrated to SSRS Reports.
• Supporting the application in case of any critical issues. Issues are first reproduced in Test Env and later in UAT and then moved the bits to production.

Environment: MS SQL Server Management Studio 2008/2008R2, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Confidential Team Foundation Server, JQuery, Support Soft.

Confidential, Seattle, WA

SQL Support Analyst

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Analyzed the bugs and issues created in Team Foundation Server and fixed the issues
• Live Site issues with high priority are taken as per the suggestions from Tech Lead and fixed those prirotiy issues.
• Bits are deployed for the corresponding Bug and issues in future releases.
• ETLs in Confidential are maintained by Confidential Shuttle
• Debugged packages and find out any new business requirement in the bug and incorporated in the Package and deployed in the corresponding servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Confidential Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Understanding the report design Requirements and Constraints.
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).

Environment: MS SQL Server Management Studio 2008/2008R2, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Confidential Team Foundation Server, Confidential Shuttle Servives.

Confidential, Seattle, WA

MS BI Analyst PM

Responsibilities:

• Analyzing the data in the servers. The data is divided based on HBI, MBI, LBI. Governance of Cloud Computing does not allow HBI Data to be stored in Cloud Servers.
• Feasibility Study of Current Design Architecture from SMEs of this app and the dependencies (Upstream and Downstream applications depending on this data).
• Understanding the Cloud limitations and limitations of data processing and storage capabilities in SQL Azure.
• Purge Policy of the application and data volume on a day to day coming into the application.
• Understanding the ETLs and Cube processing process.
• Understanding the key KPIs, measures and dimensions in the data warehouse.
• Understanding the Availability and alternate options availability in case of catastrophic application failure in the current application and comparing it with SQL Azure
• Understanding and examining the study of moving the data in BLOBs and SQL Azure.
• Created presentation decks with the flaws in current application and provided suggestions and improvement to current application. Introduced SQL Azure to business and its advantages compared to traditional physical servers.
• Held meetings with business and understood their concern.
• Analyze the hardware costs and maintenance costs of physical servers and comparing it with SQL Azure.
• Analyze the database (big tables) and roles and indexes and server sizes.
• Understand the external data sources of ARC system and types of feeds that get into the Arc System
• Understand the current server environments and design the proposed architecture in Azure platform
• General observations of the ETL process and propose improvements and suggestions to Leadership team of ARC system.
• Understand the user base of ARC System and frequent queries used in the system.
• Understand the CPU, Memory Stats of the current ARC system and understand any parallel processing happening on ARC system.
• Understanding the parameters involved in evaluating the Azure platform to the current system
• Analyze and understand the costing, performance, scalability, availability, migration and maintenancecost involved in Azure and compare it with the current architecture.

Environment: MS SQL Server Management Studio 2008/2008R2, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Confidential Team Foundation Server, MS Visual Studio, SQL Azure.

Confidential, Redmond, WA

MS BI Analyst / Live Site Analyst

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008R2
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Confidential Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Understanding the report design Requirements and Constraints.
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Created legacy reporting using Crystal Reports XI

Environment: MS SQL Server Management Studio 2008/2008R2, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Team Foundation Server

Confidential, Plano, TX

SQL Server/SSIS/SSRS Support Analyst

Responsibilities:

• Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• Designed SSIS packages to Extract data from different sources like SQL server 2008,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports. Responsible for ETL through SSIS and loading Data to DB from different input sources.
• Used ETL for data flow from different source files like XML, Excel, Tables, and Views to other databases and files with proper mapping.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Implemented Complex Logging in SSIS Packages.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations
• Converted manual reports pasted together into parameter driven stored procedures to be used with Confidential Reporting Services 2008
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Confidential Visual Studio 2008 and using Report Builder for report server to create reports
• Responded to AD-HOC requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.
• Supported few applications having ETL process in Informatica. Worked in Informatica ETL and created reports using Business Objects XI.
• Involved in BO Universe creation. Experience in BO Data Services in connecting to different data sources and created universes in BOXI report designer.

Environment: MS SQL Server Management Studio 2008, Query Analyzer, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Confidential Visual source Safe

Confidential, Jacksonville, FL

SQL Developer/SSIS/SSRS /SSAS

Responsibilities:

• Installed and Configured SQL Server 2005 and also Upgraded the existing database to SQL Server 2005.
• Actively supported business users for change requests.
• Created several databases in various Development and Test server by using SQL Server 2005.
• Created several tables, views using SQL Server 2005 Management Studio .These tables, views are created based upon the function spec.
• Responsible for making weekly backup databases by using SQL Server 2005 and restore these databases in different server.
• Responsible for installation, configuration, security, maintenance and restoration of SSRS on Windows Server 2003.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.
• Migrated data from different sources including flat files, MS Access to SQL Server 2005 by using SSIS.
• Involved in SSIS Package, DTS Import/Export for transferring data.
• Imported and exported data in the tables using SSMS for SQL.
• Performed Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2005.
• Involved in creating Dimensions, KPI, Measures and calculations in SSAS in SQL Server 2005.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Performed report testing and Verification as per internal reporting system requirements.
• Applied security to web server and database server that affects report server installation. Managed role-based security to reports and reporting resources.
• Responsible for back up and restoration of SQL Reporting Service.
• Provided Documentation support on SSRS 2005 as assigned.
• Worked in Oracle 8i as part of support and development to application called DigiDash. Working in PL/SQL queries.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, SSIS, SSAS, Oracle 8i, Crystal Reports XI, Crystal Management Server (CMS), Crystal Data Objects (CDO), MS Office, Windows XP/NT.

Confidential

SQL Server Developer

Responsibilities:

• Involved in designing the Logical and Physical data models for the data warehouse.
• Created tables, stored procedures, views, functions, and triggers using T- SQL.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• Involved in database designing using Normalization.
• Create the clustered/non-clustered indexes on tables; created views, stored procedures and triggers. Trace out for any table required any indexes and determine the type of index on it.
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• Optimized indexes to improve queries and analyzed database performance with SQL Profiler
• Worked creating reports in Crystal Reports and Oracle 8i as source. Worked in PL/SQL queries.
• Created Stored Procedures, Views, Materialized Views in Oracle 8i/9 in PL/SQL.

Environment: MS SQL Server 2005, Enterprise Manager,Crystal Reports, Query Analyser,T-SQL,Oracle 8i, PL/SQL, MS Visio, Excel.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Installing, Configuring and Tuning Database
• Database Backups, disaster recovery and database maintenance plan
• Space management
• Security and new user maintenance
• Upgrading to latest version
• Data conversion from Text File, MS-Excel into SQL Server Table
• Data Integrity Validation
• Database and Object Creation: Developed Stored procedures, Triggers, Tables, Views
• Resolving any dead locks issues with the Databases/Servers on a real-time basis
• Troubleshoot Database Errors
• Maintaining the database consistency with DBCC at regular intervals
• Migrating Data, Tables, Stored procedures and other Objects from SQL Server 7.0 to 2000
• Production support for existing Database
• Documentation of the systems Tables, Views, Stored Procedures, Jobs, Packages

Environment: MS SQL Server 2000/6.5/7.0, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer