Sql Server Data
Resume:
Sanjay Reddy
********@*****.***
MS BI/ SQL Server Developer
PROFESSIONAL SUMMARY:
Over 7 Years of experience as SQL Developer, BI Developer (SSIS, SSAS, SSRS), MDX services.
Experience in Analysis, Design, Architecture and Development of Software Applications, Business Intelligence projects in the Microsoft Server Suite of Products.
Experience in installing, configuring and monitoring MS Server 2014/ 2012/2008/2005 installations.
Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
Extensive knowledge of Normalization and Database Design Concepts.
Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL.
Extensive experience in designing, developing and deploying SSIS 2008 packages.
Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
Extensive expertise in C#, .NET Framework including WCF and web services
Extensive experience in migrating DTS packages to Integration Services Packages.
Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
Experience in data modelling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using SSAS 2008/2012.
Experience in developing on demand and scheduled reports for Business Analysis or Management Decision using SQL Server Reporting Services (SSRS).
Experience in Scheduling and the Deployment of the reports and uploading files to a Report Server Catalog from the Report Manger using SSRS 2008/2012.
Experience in defining queries for generating Drill down and Drill through reports in SSRS 2008/2012
Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
Experience in developing technical documentation for ETL's and BI reporting based on functional documents and support transition documentation.
Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
Expert in creating Parameterized Reports.
Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
Strong inclination for finishing job before the project deadline.
TECHNICAL SKILLS:
RDBMS: MS SQL Server 2000/2005/2008/2012/ MySQL
Operating System Windows
Programming Languages C, SQL, TSQL, MDX
Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL, Agents, SQL Alerts, SQL
Design and Development: Visual Studio 2008/2005/2003, Visual Studio 6.0
Reports: SSRS Reporting tool, Business Objects.
WORK EXPERIENCE
Springer Miller, ON June 2013-Present
MS BI/ SQL Server Developer
Responsibilities:
Created stored procedures, user-defined Functions, sub-queries, views and cursors for both Online and Batch requests handling business logic and functionality of various modules.
Experience in creating joins for complex queries involving multiple tables.
Implemented the Error handling in the Stored Procedures and Objects and also modified already existing stored procedures, views.
Involved in query optimization and tuning stored procedures for better performance.
Configured and maintained Report Manager and Report Server for SSRS.
Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
Experience in creating Adhoc reports using Report Builder 1.0 and Report Builder 2.0.
Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2008.
Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
Generated the weekly, monthly, and quarterly reports by using SSRS.
Created data loads and upgrade scripts for data migrations and validations.
Experience in analyzing and improving existing dashboards, reports and reporting systems.
Involved in building and improving data model (physical/logical) to serve different fund types involved in the module.
Involved in performance tuning of queries for query efficiency
Involved in debugging and testing support of Module in all environments and coordinating with QA on defects and performance issues.
Involved in using SSAS datasources in SSRS reports.
Used VB.net, C# to integrate .net framework with SSRS reports.
Environment: MS SQL Server 2005/2008, SSIS/SSRS/SSAS, Visual Studio 2008, VB.net,, C#, PL-SQL, Share Point, Oracle 10g, MS Access, Windows Server 2003.
Toyota, KY April 2011 – May 2013
MS BI/ SQL Server Developer
Responsibilities:
Performed Server installation and configuration using SQL Server 2008.
Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views, Rules, Defaults and complex SQL statements.
Developed the PL/SQL programs and involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
Created automated stored procedures for day end operations using SQL Server agent.
Coordinated with front-end for implementing logic in stored procedures and functions.
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using Server Agent job.
Created and monitored database maintenance plans for checking database integrity in SSIS.
Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005/2008 Integration Services (SSIS).
Transferred data from flat files, Excel spreadsheets and heterogeneous data to SQL Server using DTS and also used BCP and Bulk Insert and even the other way.
Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SSAS 2008.
Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SSAS 2008.
Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
Environment: MS SQL Server 2005/2008, SSIS/SSRS/SSAS, Visual Studio 2008, PL-SQL, C#, Oracle 10g, MS Access, Windows Server 2003.
Deloitte, ON July 2008 – March 2011
MS BI/ SQL Server Developer
Responsibilities:
Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Fuzzy Lookup, Fuzzy Grouping in SSIS Dataflow.
Involved in ETL architecture enhancements to increase the performance using query optimizer.
Implemented Event Handlers and Error Handling in SSIS packages.
Created SSIS packages for Data Conversion using data conversion transformation.
Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
Designed and created Report templates, bar graphs and pie charts based on the financial data regarding competitive rates and financial market.
Developed various types of complex reports like Drill Down, Drill through, linked reports, cascading parameter reports for business loan, first time buyer or refinancing home mortgage.
Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
Involved in designing Parameterized Reports and Matrix Reports for generating Ad-Hoc reports as per the client requirements.
Coordinated with front-end for implementing logic in stored procedures and functions.
Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML, MDX and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
Involved in upgrading from SQL Server 2005 to SQL Server 2008.
Advised optimization of queries by looking at Execution Plan for better tuning of the database.
Environment: MS SQL Server 2005/2008, SSIS/SSRS/SSAS 2008, Visual Studio 2008, PL-SQL, C#, MS Access, Windows Server 2003.
IBM, India June 2007 – May 2008
SQL BI Developer
Responsibilities:
Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.
Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form for highest performance.
Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
Installed and configured SQL Server 2008 in Test environment with latest service packs and migrated few databases.
Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuilt indexes if necessary.
Created and managed users, roles and groups and handled database security.
Implemented computational sensitive queries Stored Procedures.
Rebuilt indexes on various tables.
Involved in migration from SQL Server 2000 to SQL Server 2005/2008.
Involved in writing DDL / DML Triggers as per company policy.
Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
Managed Database files, transaction log and estimated space requirements. Performance tuning, and optimization of procedures and queries.
Monitored SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
Environment: MS Server 2005, T-SQL, DTS, Microsoft Visual Source Safe, Visual Basic 6.0 and Windows NT.
Qualification
Successfully completed Bachelor of Business Management from Nagarjuna university in 1999
Contact this candidate