Resume

Sign in

Sql Server Data

Location:
Irving, Texas, 75038, United States
Salary:
$55
Posted:
October 06, 2016

Contact this candidate

Sharath

Ph: (469) ***-**** Email: acwx3p@r.postjobfree.com

PROFESSIONALSUMMARY:

Over 8 years of IT experience in the Design, Development, working experience in MS SQL Server 2012/2008R2/2008/2005(SSIS, SSRS,SSAS), Database Migration, Database Administration, Physical/Logical Design, T-SQL, Performance-Tuning, Troubleshooting, Backups and Restore of databases.

Strong foundation in T-SQL programming.

Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML).

Upgrade/Migration of MS SQL Server 2008 to MS SQL Server 2012 and MS SQL Server 2005 to MS SQL Server 2008 using any suitable approach.

Excellent Knowledge in RDBMS Concepts and Experience in Normalization of tables up to Third Normalization Form.

Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions (UDF’s) and other T-SQL (DDL, DML) statements for various applications.

Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views.

Proficient in writing distributed queries between SQL Servers by creating link servers.

Detection and resolving of blocking and deadlocks using Profiler, DBCC utilities and DMV’s.

Improved query performance by adding covered indexes, adding file groups.

Experience in Performance Tuning, Query Optimization using Indexes, Profile Traces for Dead Locks and using DBCC Utilities for Database Consistency Checks.

Hands on experience in creating Parameterized reports, Cascaded Parameterized and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report and sub reports) in SSRS.

Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.

Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Strong Data Warehousing and analysis skills including OLTP, OLAP (MOLAP, HOLAP, DOLAP, and ROLAP), Relational and Dimensional modeling skills (star schema and snowflake schema).

Developed SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.

Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.

Experienced in Installation, Configuration, and Administration of Informatica Power Center 8.x/7.x/6.x.

Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.

Experience in managing Alerts, Operators and Jobs through SQL Server Agent.

Experience in using Bulk insert and BCP utilities.

Experience in source control tools like Visual Source Safe, Team Foundation Server.

Experience with writing scripts in C#, ASP.NET, integrate information from multiple sources to execute effectively and efficiently in a dynamic environment.

Excellent Interpersonal and communication skills. Quick learner in new technologies.

PROFESSIONAL SKILLS:

RDBMS/Databases

MS SQL Server 2005/2008/2008R2/2012, Oracle 8i/9i

Data warehouse tools

OLAP, SQL Data Transformation Services (DTS)

Data Modeling and ETL tools

SSIS, ER/Studio, ERWIN

Languages

C, C++, Java Script, C#, PERL,T-SQL, PL/SQL, Oracle 9i and 10g,HTML,XML

Packages

MS Office, Visual Basic

Web technologies

HTML, VB-Script, DHTML, XML

MS technologies

MS Visio, Knowledge of ASP.NET 2.0, .NET Framework, MS Access, MS SharePoint

Operating Systems

Windows NT 4.0/, XP, Windows 2000 /2003 Server, UNIX.

Reporting Tools

Crystal Reports, Microsoft Reporting Server (SSRS).

Methodologies

Business Analysis, Object-Oriented (Use Case) Analysis, Database Design and Normalization, Data Modeling, Code Specifications, Visio, VSS.

PROFESSIONAL EXPERIENCE:

Novartis, Dallas, TX Oct 2015 – Present

Role: SQL Server SSRS/SSIS Developer

Description: Novartis is a leading global Healthcare Company. Worked in onboard project is a server-based, SQL database solution. Responsibilities include creating different Parameterized, Cross tab and ad-hoc reports using SSRS 2008, writing complex Stored procedures, tuning queries and Extract, Transfer and Loading (ETL) of data from flat file, XML, Oracle, etc. using SSIS and performing daily dba duties.

Responsibilities:

Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.

Implemented triggers and stored procedures and enforced business rules via check constraints.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries

Created views to restrict access to data in a table for security

Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using SSRS 2005.

Designed SQL 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; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Performed Full and Differential backup with simple and bulk-logged recovery models.

Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.

Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.

Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.

Implemented Snapshot and Transactional Replication models and Validation of Replicated data.

Running DBCC consistency checks, and fixing data corruption in application databases.

Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.

Used SharePoint API and ASP.NET to build custom Web Parts and Tool Parts to implement additional business requirements from and within the SharePoint site.

Designed custom workflows using Visual Studio and SharePoint Designer using custom built content types to incorporate various business processes.

Environment: SQL Server 2008 R2/2012, MS Analysis Service SSAS Developer 2000, XML, MS Project, MS Access 2000 & Windows 2K platform, VSS,ERWIN, MS Share Point, Crystal Reports, Oracle 9i, C#, ASP.Net.

Epsilon, Dallas, TX Jan 2015 - Aug 2015

Role: SQL Server SSRS/SSIS/ SSAS Developer

Description: Project involved in migrating data from ADP system to Ultipro system. Worked on logical and physical database models. Created SSIS Packages and also used third party tools like cozy rock to generate hash key for insert and update of data in to tables. Created SSRS Reports like drill down, drill through, cascaded parameterized. Data validation and project documentation.

Responsibilities:

Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.

Created complete documentation for the daily build process, daily loads and reports.

Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.

Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.

Designed dynamic SSIS Packages for Landing-Pad to transfer data between servers, load data from FTP, flat files, access and oracle into database, and archived data file from different DBMS.

Involved in daily loads (Full & Incremental), Data Conversions into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.

Developed SSIS Templates with error logging and configurations which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Implemented SCD2 (Slowly changing Dimensions) by using different dataflow tasks in SSIS.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Used SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.

Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.

Used Cozy rock third party tool to generate Hash keys, to insert and update data in to data warehouse.

Developed complex queries for generating drill down and drill through reports and worked with Parameters for parameterized and cascading parameterized reports in SSRS.

Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.

Created star schema in SSAS and developed SSRS reports based on the cubes.

Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.

Uploaded reports on to the report manager and organized them into folders.

Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).

Created reports which generate multiple named tabs in excel and created data driven and standard subscriptions for different users using Report Manager.

Managed permissions in the Report manger through Role based security.

Used Transparent Data Encryption (TDE) to encrypt sensitive data.

Daily builds, merging, branching source code to different environments using Visual Studio Team System.

Every day SCRUM meetings and two week sprint.

Environment: SQL Server 2012 Enterprise, ERWIN, Windows Enterprise Server 2003, XML, MDX, Microsoft Visio, SFTP, SSRS, SSIS, SSAS, VB .NET, ASP .NET and C# Microsoft Entity Framework, Visual Studio Team System 2008, SharePoint, Cozy rock

Sutter Health, Sacramento, CA Feb 2014 –Nov 2014

Role: SQL Server SSRS/SSIS SSAS Developer

Description: Sutter Health is a Healthcare Company, worked in onboard project. This project is a server-based, SQL database solution. They provide core data processing, item processing, check imaging and remote capture processing. Responsibilities include monitoring and tuning Very large databases (VLDB) for performance and availability, modify database structures, and develop database backup/recovery procedures, Database analysis, stored procedures and creating different chart reports, Parameterized, Drill through reports using SSRS 20012.

Responsibilities:

Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Successfully upgraded from SQL 2008 to SQL 2012 with side-by-side approach.

Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.

Implemented triggers and stored procedures and enforced business rules via check constraints.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Writing SQL scripts for various daily database tasks like checking table fragmentation and reorganize/reindex, synchronizing data from one server to another etc.

Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries

Created views to restrict access to data in a table for security

Improved the performance of the application by 22% by creating proper clustered, non-clustered, covered indexes in a secondary file group (ndf) and partitioning.

Configured SSRS in both Native and SharePoint mode.

Configured Report Server and Report Manager in SQL Server 2008.

Created star schema in SSAS and developed SSRS reports based on the cubes.

Created Cross-Tab, Drill-down, Cascaded Parameterized, Charts and Sub-Reports

Created data models with Report Builder 2.0 to provide a template for end-users for creating reports by themselves with pre-selected group of relational tables.

Used Expressions, Functions and wrote custom code using VB.Net for the dynamic sorting, dynamic visibility and dynamic columns using SSRS 2008.

Created client side reports (RDLC) using Visual Studio 2008 for reports to be generated from session data

Built reports to generate in desired form (Word, PDF, Excel and XML) to present statistical information according to business requirement.

Deployed the created reports into SharePoint and Report Manager, created data driven subscriptions for different users in desired format.

Integrated the reports into web application using Report Viewer Control in Visual Studio 2008.

Designed and implemented Dashboards and Scorecards with business KPIs using SSRS and Performance Point Server, and published them Via Microsoft Office Share point Server (MOSS).

Created SSIS packages to import and export Account details in XML format from one server to another.

Worked on Power Pivot to create ad-hoc reports based on user requirments.

Used Triggers and the new Change Data Capture (CDC) to implement database auditing.

Every day Agile/SCRUM meetings and two week sprint.

Created Policies, Conditions and used Facets with Policy Based Management to configure and manage the SQL Servers.

Environment: SQL Server 2005/2008 Enterprise, MS VISIO, Windows Enterprise Server 2003, IIS 7.0, XML, Microsoft Visio 2003, SFTP, SSRS, SSIS, SSAS, VB .NET, ASP .NET and C# Microsoft Entity Framework, Visual Studio Team System 2008, AJAX, Telerik RAD Controls, SharePoint, LINQ.

Bed Bath & Beyond Inc, Union, NJ Aug 2013 – Dec 2013

Role: SQL Server SSRS/SSIS SSAS Developer

Description: Bed Bath & Beyond is an American chain of domestic merchandise Retail Stores in the United States. This Project mainly involved Database design, Performance tuning, coding, unit testing and Implementation. Developed and designed complex automated reports in SSRS. Created SSIS packages to import data from different heterogeneous sources.Generate the reports using SSRS for different SSAS Cubes

Responsibilities:

Created indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.

Created Jobs, Alerts using SQL Agent to run packages and maintenance plans

Query Optimization and Performance Tuning of Stored Procedures, Functions etc.

Partitioning the tables for increase in Performance and availability of data.

Written different test Scripts for testing complex codes.

Implementing and administering database replication between SQL Server database

Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and scheduling the reports through standard and data driven subscriptions.

Formatted the reports using the Global variables and expressions.

Performed Data Analysis for automating various Customers Order Reports utilizing SSRS 2005.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Implemented the project using ASP and VB-6 backend database as sql server.

Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.

Created master and child packages, package configurations and logging.

Designed SQL 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; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Implemented SCD2 (Slowly changing Dimensions) using Table Difference in SSIS.

Transformed data from various data sources using OLE DB connection by creating various SSIS packages.

Worked with EDI 837 Conversions.

Created star schema in SSAS and developed SSRS reports based on the cubes.

Experience with Analysis services 2005 and made various cubes based on the reporting requirement.

Environment: SQL Server 20005/2008, ASP,VB-6, C#, Enterprise Edition, SQL,PL/SQL, Enterprise manager, SSRS 2005, SSIS,SSAS, Spotlight, MS SharePoint, MS Access, Excel, 2000 & Windows 2003/2000 Platform, Red gate.

US Cellular, Chicago, IL Sep 2011-Feb 2013

Role: SQL Server SSRS/SSIS Developer

Description: U.S. Cellular is the fifth-largest full-service wireless carrier in the United States, providing national network coverage and industry-leading innovations designed to elevate the customer experience.

The project mainly involved in creating new databases, Performance tuning, creating, deploying and scheduling reports. Also it included Extract, Transfer and Loading (ETL) of data from flat file, excel sources, etc. using SSIS, Migration of data, Writing T-SQL code, backups etc. and create various operational, drill-through and dynamic reports using SSRS 2008.

Responsibilities:

Identifying and make recommendations for enhancements to the business issues and process challenges for the organization

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.

Created complete documentation for the daily build process, daily loads and reports.

Conducted training sessions for end users on how to use adhoc reports using Report builder 2.0.

Created logical and physical database design, data structures and maintained it by using Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.

Implemented triggers and stored procedures and enforced business rules via checks and constraints.

Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries

Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using SSRS 2005.

Designed and created Report templates, bar graphs, pie charts and adhoc reports using Report builder 2.0.

Worked on Power Pivot to generate Ad-Hoc Reports based on end user requirments.

Designed and implemented Dashboards and Scorecards with business KPIs using SSRS and Performance Point Server, and published them Via Microsoft Office Share point Server (MOSS).

Created data driven and standard subscriptions for different users using Report Manager.

Managed permissions in the Report manger through Role based security.

Performed Full and Differential backup with simple and bulk-logged recovery models.

Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.

Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results

Environment: SQL Server 2005/2008 MS VISIO, Windows Enterprise Server 2003, XML, Oracle 9i, SFTP, SSRS, SSIS, VB .NET, ASP .NET and C# Microsoft Entity Framework, Visual Studio Team System 2008, SharePoint, LINQ.

Goldstone Technologies, Pvt Ltd, India Jun 2009 - Aug 2011

Role: SQL Server SSRS/SSIS Developer

Description: This Project involved in creating and implementing the new SQL Server 2008 R2 Parallel Data Warehouse. Microsoft SQL Server 2008 R2 Parallel Data Warehouse is a highly scalable data warehouse appliance that delivers performance at low cost through a massively parallel processing (MPP) architecture. Creating Physical and logical models, SSIS Packages, daily loads and creating different kinds of reports using SQL Server 2008 R2.

Responsibilities:

Designed dynamic SSIS Packages for Landing-Pad to transfer data between servers, load data into database, and archived data file from different DBMS.

Involved in daily loads (Full & Incremental), Data Conversions into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.

Implemented the sliding window concept to manage time-based partitions and documented the sliding window process.

Created complete documentation for the daily build processes, daily loads and reports.

Used various Transformations in SSIS Dataflow, Control flow using for loop Containers, Script Task, ActiveX scripting and Fuzzy Lookups.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Designed and created Report templates, bar graphs, adhoc reports using Report builder 2.0 and pie charts.

Designed and implemented Dashboards and Scorecards with business KPIs using SSRS and Performance Point Server, and published them Via Microsoft Office Share point Server (MOSS).

Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

Created data driven and standard subscriptions for different users using Report Manager.

Managed permissions in the Report manger through Role based security.

Synchronizing schema and data between development, test and QA servers using Red gate SQL Compare and Data Compare

Worked on Cassandra to store big data.

Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor.

Every day Agile/SCRUM meetings and two week sprint.

Created Policies, Conditions and used Facets with Policy Based Management to configure and manage the SQL Servers

Daily builds, merging, branching source code to different environments using Visual Studio Team System 2008.

Environment: SQL Server 2005/2008 Enterprise, MS VISIO, Windows Enterprise Server 2003, IIS 7.0, .XML, Microsoft Visio 2003, SFTP, SSRS, SSIS, VB .NET, ASP .NET and C# Microsoft Entity Framework, Cassandra, Visual Studio Team System 2008, AJAX, Telerik RAD Controls, SharePoint, LINQ.



Contact this candidate