Sql Server Data

SUMMARY

Over *+ years IT experience in Database Design, Development and Implementation of SQLSERVER 2012/2008R2/2005 and providing ETL/Business Intelligence applications using Microsoft components.

Effectively involved in all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects.

Extensive SQL Development experience in a Banking & Healthcare environment with a strong understanding of data & analytics.

Working experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, and DCL commands for various business applications.

Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.

Expert in using SQL Server Agent to Schedule and monitor Jobs.

Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.

Experience in Error handling and debugging coding issues and troubleshoot production problems.

Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMF’s and Query Execution Plans.

Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance

Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)

Expertise in conversion of DTS to SSIS packages and troubleshooting the migration issues.

Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.

Experience in providing System and User-defined Variables, Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.

Experience in creating configuration files to deploy the SSIS packages across all environments.

Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.

Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.

Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions (2005/2008/2008R2) & features.

Expertise in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports.

Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms.

Experience in developing applications using C#. Net, VB.Net.

Strong Experience in Unit, Integration and System Testing.

TECHNOLOGY EXPERIENCE

Tools/Utility

Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SQL SERVER BIDS, Visual Studio 2003/2005/2010, Visual SourceSafe 8.0

Programming Languages

Pascal, C, C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL, HTML, XML

Tools

DTS, SSIS, SSRS, SSAS, Erwin

DATABASE

MS Access, MS SQL Server 2005/2008/2008 R2/2012, Oracle8i/9i/10g, DB2

Operating Systems

Windows NT/98/2000/XP/2003/2008 server

Software

MS Office Visio, MS-Project 2000

IT Processes

Software Development Life Cycle (SDLC)

EDUCATION:

Bachelor’s degree from JNTU Hyderabad, India

PROFESSIONAL EXPERIENCE

Ecolab, St Paul, MN Oct’ 15 – Till Date

Role: SQL / BI Developer

Responsibilities:

Develop technical design documents and mapping specifications to build ETL Mappings to load data into target tables.

Developed ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files and loaded the data into target tables by performing different kinds of transformations using SSIS.

Used Microsoft TFS in order to share the code with other programmers and as a source control Document, design, develop, optimize and maintain reliable, repeatable and scalable ETL packages and solutions by implementing ETL standards, conventions and best practices in SSIS

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent

Extensively used SSIS transformations in order to perform data cleansing and data mapping before loading the data in to data marts.

Provided technical expertise with data analysis, collection and documentation of metadata components and information delivery

Utilized T-SQL extensively in order to replace SSIS transformations in order to improve the performance of packages.

Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server in SharePoint integrated mode.

Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to diverse group of users, clients, and managers.

Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from multiple tables.

Developed reports with flexibility using Report Parameters Drop-Down Parameters Multi-Valued Parameters in order to meet the changing business needs (SSRS) and deployed to SharePoint site.

Environment: SQL Server 2008R2/2012, SharePoint 2010/2013, MDX, SSRS, SSIS, SSAS Multidimensional and Tabular

UnitedHealth Group, Minneapolis, MN Nov’14 – Oct’ 15

Role: SQL / BI Developer

Responsibilities:

Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers.

Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.

Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.

Exceptional communication skills in requirement gathering and design strategies for database management system.

Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.

Created VISIO diagrams in order to give idea for Business Users and for IT team about existing flow. Also created future state data flow diagrams.

Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.

Optimized and updated logical and physical data models to support new and existing projects

Offered production support at regular periods for migration and data issues.

Developed re-usable stored procedures for database application support.

Worked with transferring the data using SSIS (SQL Server Integration Services) packages.

Used MS Excel, CSV files as data source and copied data to the target.

Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database.

Generated Reports in SSRS using Expressions and Functions for the reports.

Designed and rolled out canned and ad-hoc reports.

Designed drill down, drill through, sub-reports and ad-hoc reports on large scale.

Worked on analysis of data in PowerPivot by connecting to various data sources.

Designed reports in PowerView.

Responsible for scheduling the subscription reports with the subscription report wizard.

Created SSIS packages to import the data into SQL server.

Involved in Troubleshooting of the already existing SSIS packages.

Managed server related issues.

Developed unit test plans for SSIS packages.

Provided documentation for reports and SSIS packages.

Worked with a team to suggest automated processes to reduce human errors and also to save time and resources.

Environment: MS SQL Server 2012, Ms Visio, SQL Server Reporting Services(SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), OLAP, C#.

Realogy INC, Madison NJ Apr’13 – Nov’14

MS SQL Server SSIS/SSRS Developer

Responsibilities:

Created ETL SSIS packages both design and code to process data to target databases.

Identify and resolve problems encountered during both development and release of the SSIS code.

Debugging and troubleshooting the technical issues while implementing the applications.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Created packages in SSIS with error handling and worked with different methods of logging in SSIS

Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.

Worked on QNXT claims and Conversion of Interface Programs from Legacy to QNXT.

Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.

Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

Responsible for data analysis, loading data from Data feed to Data Warehouse tables.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Created views to display required information on user interface, and triggers to validate consistent data entry into the database.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.

Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners.

Documented all the work and all the process of integration and reporting services for further references

Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0,Enterprise Manager, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005/2010, MS Access, Crystal Reports, MS Excel 2007.

Lenox Hill Hospital, NYC, NY Feb’12 - Mar’13

MS SQL Server SSIS/SSRS Developer

Responsibilities:

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 such a way that they can be dynamically deployed into Dev., Test and Production Environments.

Worked on development, implementation, administration and support of ETL processes for large-scaleData Warehouses using SSIS and DTS.

Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Using Dtsx Change tool converted DTS packages to SQL Server 2005 SSIS packages.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.

Involved in conversion interfaces on QNXT Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits.

Used techniques like backups, restore, replication, and standby databases to ensure higher availability Production Environment.

Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages

Responsible for maintaining cubes using SSAS and populate the cubes with the data

Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.

Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS 2005/2008.

Involved in designing the physical database models on SQL Server 2005 RDBMS using DML/DDL implementing constraints and triggers for data integrity.

Extensively used T-SQL to manipulate and architect to produce results for users.

Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency

Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.

Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization

Involved in projectstatus report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Used SQL profiler to view indexes performance to mostly eliminate table scan.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server.

Worked with development teams in the design of physical databases and in modification.

Involved in migration from SQLServer 2005 to SQL Server 2008

Environment: MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g, Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007.

ProBuild, Denver, CO Apr’10 - Dec’11

MS SQL Server SSAS/SSRS Developer

Responsibilities:

Actively participated in gathering of User Requirement and System Specification

Developed database objects like tables, views, stored procedures in SQL Server 2008

Created Partition Tables based upon Partition Functions and Partition Schemas

Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries.

Created reports based on the format specified in the design document

Documentation of all the processes involved in maintaining the database for future reference

Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer

Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.

Involved in development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.

Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS

Created reports using SQL Server reporting services SSRS, which is then exported as PDF. Reports variables are passed from ASP.NET web pages.

Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS

Created reports using SQL Server reporting services (SSRS), which is then exported as PDF. Reports variables are passed from ASP.NET web pages.

Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.

Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks

Involved in Unit Testing, Integration and deployment in Production and Staging Servers.

Used .Net Framework for creating Reports and also for customization of reports.

ENVINORMENT: MS SQL Server 2005/2008,Visual Studio 2005, COM/COM+, VC++, C#, MySQL, Windows 2000, Windows XP, T-SQL, ASP.NET, Visual SourceSafe, XML, ER Studio, Crystal Reports, SSAS, SSRS, ERWIN, Brio.

HSBC, Bangalore India Jun’08- Mar’10

MS SQL Server SSIS/SSRS Developer

Responsibilities:

Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes

Installed and configure servers and clients using SQL Server 2008,Upgraded SQL databases

Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing

Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards

Managed database portioning across multiple disks

Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases

Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards

Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties

Knowledge of Database Performance monitoring tools

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs

Created packages in SSIS with error handling and worked with different methods of logging in SSIS

Created ETL SSIS packages both design and code to process data to target databases

Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis

Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages

Managed SQL user logins, database user accounts, server roles, database roles and its permissions.

Created jobs to collect status information from various servers and feed them to the Master Server

Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler

Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking&deadlocks user counts and connections/locks etc.

Implement automated Index Maintenance strategy run as SQL Job on a daily basis

Created Snapshots, Subscriptions and Transactions using Replication services

Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server

Resolving any dead locks issues with the Databases/Servers on a real-time basis.

Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS

Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems

Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor

Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, BizTalk Server 2004 Erwin, Microsoft Visio 2003, SFTP

Omnie Solutions Ltd. Noida, India May’ 07 – Jun’08

MS SQL Server Developer/SSRS/SSAS

Responsibilities:

Worked closely with business units to understand key business drivers and then identify the individual business metrics and key measures that support them.

Worked with management to develop strategies to support company needs.

Resolved data conflicts and inappropriate use of data.

Wrote complex SQL queries using joins, stored procedures, and user defined functions to verify the data from the database to generate reports based on the business requirement.

Utilized SSRS reports from different source formats satisfying clients by representing reports and presentations.

Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized report, ad-Hoc and parameterized reports using SQL server 2005 reporting Services.

Implemented multiple grouping into several reports using visibility and toggle options.

Administrated and scheduled mailing subscriptions on SSRS reporting server.

Structured conditional formatting logic to control components behavior and appearance.

Produced parameter driven matrix, sub-reports and integrated report hyper-link functionality to access external applications.

Customized SQL queries to create RDL Datasets and create SQL reports.

Created Tabular and Matrix Reports with all aggregate functions and expressions.

Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.

Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.

Created SSRS Data Model projects using Microsoft Visual Studio 2005 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users

Environment: SQL Server 2005, SSRS, SSAS, T-SQL, SSMS, BIDS, Visio, Excel 2003, SharePoint.

Contact this candidate