Sql Server Customer Service
Resume:
SANDEEP V
BI Consultant
*******.********@****.***
professional SUMMARY
. Over 5 years of experience in Database Administration and Microsoft
business intelligence Development under SQL Server environment, with
thorough knowledge of SQL Server 2008/2008R2/2012 databases.
Experienced in Insurance, Financial, Health Care and banking services.
. Experienced in upgrading SQL Server 2005/2008 to 2008/2012 and data
migration among versions.
. Extensive experience in developing and implementing Microsoft SQL
Server Integration Services (SSIS), Reporting Services (SSRS), SSAS
(analysis services).
. Excellent knowledge in RDBMS concepts and constructs along with
Database Objects creation such as Tables, User Defined Data Types,
Indexes, Stored Procedures, Views, User Defined Functions, Cursors and
Triggers.
. Expert in Extraction, Transforming and Loading (ETL) data flows using
SSIS; creating mappings/workflows to extract data from SQL Server and
Flat File sources and load into various Business Entities.
. Experience in DTS Migration and Metadata Management: Migrating DTS
packages to SSIS, Package Migration Wizard, and Storage Management.
. Experienced in the complete life cycle of DTS/SQL Server Integration
services (SSIS) Packages (Developing, Deploying, Scheduling,
Troubleshooting and monitoring) for performing Data transfers and ETL
jobs across different servers.
. Experience in Error and Event Handling: Precedence Constraints, Break
Points, Check Points, Logging.
. Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-
related sub queries, Dynamic SQL queries etc.
. Experience in Performance Tuning in SSIS packages by using Row
Transformations, Block and Unblock Transformations
. Experience managing and performance tuning both relational and star
(dimensional) schema databases
. Experience in developing reports using Report Builder and used
Metadata to define Fact & Dimension tables. Expert in designing
Enterprise reports using SQL Server Reporting Services (SSRS)
generated drill down reports, drill through reports, parameterized
reports, Cascaded reports, linked reports, sub reports, matrix
dynamics and filters, charts in SSRS.
. Expertise in .NET framework with great proficiency in creating
applications using Win Forms, Web Forms, Entity Framework, ASP.NET,
C#/VB.NET, ASP.NET MVC, ADO.NET, XML, AJAX toolkit, Cascading Style
Sheets (CSS), JavaScript, WCF, WPF, IIS7.0, SQL Server 2000 / 2005
/2008, LINQ and Visual Studio.NET.
. Perform complex data modeling, performance and integration testing and
builds interfaces for a variety of internal and external constituents.
. Monitor and employ source code control techniques and configuration
management.
Gather, analyze, prepare and summarize recommendations for approval
of system and programming documentation.
. Implemented changes in development, maintenance and system standards.
. Perform and coordinate data warehouse administration for development
and maintenance activities, including performance testing, tuning, and
troubleshooting of data warehouse processes
. Develop and implement new or enhanced utility components for the data
warehouse
Partner with technical team members to establish extract,
transformation, and data load designs and standards for a well managed
and well integrated data warehouse infrastructure
Interact with business users and Citizens Data Warehouse staff to
understand reporting requirements
. Design and implement Demoralized, Dimensional, and Star Data Warehouse
schemas
. Working experience of designing Ad-hoc reports for higher managers
using report model, providing them flexibility to create reports using
drag and drop functionality.
. Developed Cubes using SQL server Analysis Services (SSAS) and
Experience in Developing and Extending OLAP Cubes, Dimensions and data
source views.
. Created Dimensions with the cube wizard and generated named
calculations and named queries.
. Expert in calculating measures and dimension members using Multi-
dimensional expression (MDX), mathematical formulas, and user-defined
functions.
. Microsoft Certified Technology Specialist in SQL Server 2005 and SQL
Server 2008.
. Excellent communication and interpersonal skills. Highly motivated
with strong commitment to quality and customer service.
TECHNICAL SKILLS:
Operating System: Window 2000, Windows XP, Windows 2003, UNIX
Languages: C, C++, Java, VB6, VB.NET, C#, ASP.NET
Databases: MS-SQL Server 2000, MS SQL Server2005, MS SQL Server 2008, MS
SQL Server 2012
Data Warehouse Tools: SSIS, SSRS, SSAS
SQL Server Tools: Enterprise Manager, Microsoft Systems Center Operations
Manager,
SQL Server Management Studio, Profiler,
Query Analyzer, MS Visio
Web Technologies: HTML, DHTML, VB Script, Java Script, PERL and ASP
Professional Experience
NTT Data Inc
July 12
to Aug 13
Project: 1
BI Consultant
Client: National Life Group
Description: The current scripting process for LSW Annuities is handled by
Excel, and VBA coding. The solution proposed is to automate the scripting
process for PolySystems executions using new technology which can be easily
maintained, and managed within a controlled IT environment.
Responsibilities:
. Installation and Upgradation of SQL Server 2008 and SQL Server 2012 on
Production Environments.
. Involved in migrating data from SQL Server 2008/2008R2 to SQL Server
2012.
. Develop and implement production database backup strategies for MS-SQL
Server databases which enable maximum recoverability.
. Migrated data from different sources (text based files, Excel
spreadsheets, and Access) to SQL Server databases using SQL Server
Integration Services (SSIS).
. Involved in dimensional modeling with Star & Snowflake schemas and
created the Data Source Views (DSV) and Cubes using the identified
Fact and dimension tables.
. Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, SQL
Server 2008
. Created stored procedures, views, indexes and joins as needed.
Involved in Performance Tuning of databases to optimize existing
applications and processes.
. Worked with different Types of files like UPD, PCF, VMF, and RCF.
. Extensively utilized SSIS packages to create complete ETL process and
load data into database which was to be used by Reporting Services.
Creating jobs for scheduling the SSIS packages.
. Performed operations like sorting, merging on the source data in order
to clean the data and remove duplicates.
. Designed databases, tables, SQL functions, triggers in SQL Server
2008.
Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS,
ReportBuilder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler,
Replication, Logshipping, Mirroring, Windows XP/2000 and Windows 2003/2008
Server.
Project 2:
M*Modal, Atlanta GA
Feb 12 to June 13
BI Consultant
Description: M*Modal is a leading provider of clinical transcription
services, clinical documentation workflow solutions, advanced cloud-based
Speech Understanding technology and advanced unstructured data analytics.
We come to the challenges confronting healthcare today with a clear
understanding that at the core of quality care giving is the physician's
narrative-the telling and capturing of the complete patient story.
Everything is rooted here-from boosting quality at the point of care to how
healthcare organizations receive reimbursements
Responsibilities:
. TSQL Programming - writing new stored procedures, updating & enhancing
the existing code.
. Optimizing the queries and taking care of performance issues.
. Implementing Backup and recovery process and Replication process.
. Deploying the code, SSIS packages and SSRS reports in production
servers.
. Installing and configuring the SQL Server 2008 and SQL Server 2012 on
windows 7 servers.
. Creating New SSIS packages and Migrating SSIS packages from SQL Server
2008 to SQL Server 2012.
. Designing and modeling data warehouse and data marts, creating
database objects and applying optimization techniques.
. Exclusively worked on Script task (C#.NET, VB Scripting), File System
Task to read the excel files and updating the excel files in ETL
package.
. Effectively using various synchronous and asynchronous transformations
in ETL packages.
. Integrated third party components ACG Grouper and Milliman Grouper in
SSIS packages.
. Created various Medicaid and Medicare Claims data extract and loading
SSIS ETL packages.
. Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, SQL
Server 2008
. Created Stored Procedures/Functions/Triggers in SQL Server using T-
SQL.
. Automating various ETL jobs and sending notifications to the users.
. Created SSRS reports and taking care of deployment issues.
. Designing and deploying Adhoc reports for Business Process Management
by using Operational Data Source.
. Taken care of code and SSIS deployment and migration issues.
Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Report
Builder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler,
Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008
Server
Polaris Software Lab Oct 10 to
Feb 12
BI Consultant
Client: Citi Bank
Description: AIMS is a standalone e-billing and legal spend management
application that facilitates the approval and payment of invoices between
the corporate legal department and its legal service providers. AIMS
provide the ability to automatically enforce billing guidelines and reduce
invoice review time, thus driving cost savings and efficiency throughout
the legal department. And, with the comprehensive analysis and reporting
capabilities provided by AIMS, legal spend data becomes actionable
information that helps corporate counsel make well-informed, strategic
business decisions.
Responsibilities:
. Optimizing the queries and taking care of performance issues.
. Implementing Backup and recovery process and Replication process.
. Deploying the code, SSIS packages sin production servers.
. Installing and configuring the SQL Server 2008 and SQL Server 2012 on
windows 7 servers.
. Creating New SSIS packages and Migrating SSIS packages from SQL Server
2008 to SQL Server 2012.
. Designing and modeling data warehouse and data marts, creating
database objects and applying optimization techniques.
. Exclusively worked on Script task (C#.NET, VB Scripting), File System
Task to read the excel files and updating the excel files in ETL
package.
. Effectively using various synchronous and asynchronous transformations
in ETL packages.
. Integrated third party components ACG Grouper and Milliman Grouper in
SSIS packages.
. TSQL Programming - writing new stored procedures, updating & enhancing
the existing code. Created Stored Procedures/Functions/Triggers in SQL
Server using T-SQL.
. Automating various ETL jobs and sending notifications to the users.
Taken care of code and SSIS deployment and migration issues.
. Created SSRS reports and taking care of deployment issues. Designing
and deploying Adhoc reports for Business Process Management by using
Operational Data Source.
Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Report
Builder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler,
Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008
Server
Kansolves Technology, India
May 08 to July 10
BI consultant
Description: CIBER Data Warehouse acquires data from the various data
sources of the company and insert or update data into Data warehouse. This
data warehouse allows the Management for effective decision-making and to
transform product centric approach to customer centric approach to gain
competitive advantage by combining data from different sources. The company
has heterogeneous data stores and operational systems supporting its
operational infrastructure
Responsibilities:
. Query Optimization and tuning the query, creating Indexes to improve
the query performance.
. Bulk Insert and loading the data files which comes from various legacy
systems (Mainframes and Oracle database).
. Creating various Jobs, scheduling & running jobs and troubleshooting
the failed jobs.
. Expertise in Monitoring and Troubleshooting and resolving the SQL
Server Performance issues.
. Designing, developing and deploying various ETL packages for data
loading (SSIS).
. Creation and Execution of DTS and BCP utilities in SQL Server 2000.
. Effectively using DBCC commands, SQL Profiler, Trace Analysis and
Execution plans as part of trouble shooting and performance tuning.
. Creation and implementation of Database backup Restore and Recovery
plans.
. Replicating the database (Snapshot, Transactional and Merge
Replication) and providing greater autonomy to the users.
. Working on Log shipping, Mirroring and SQL Server Clustering
Databases.
. Developing, implementing, maintaining and exercising Disaster Recovery
processes.
. Building Data warehouse database, Designing Star Schema, Creating Fact
tables, Dimension tables and defining the relationship between them.
. Expertise in processing the Cubes, Hierarchies, and Measures putting
calculations and processing for Analysis Services (SSAS).
. Expertise in populating processed Analysis Cubes historical data into
excel file, ProClarity, various pie charts.
. Trouble shooting and fixing the issues in front end code (VB.NET,
ASP.NET, C#) when project needs.
Environment: Windows 2003, SQL Server 2008, Microsoft Visual Studio 2008,
SSIS, SSRS, Windows
XP, Windows 2003, Windows 2000
Education:
. Master of Science at University of Central Missouri, 2014
. Post Graduation diploma In Software Development, 2011
. Bachelor of Technology in Electronics, 2008
Contact this candidate