Resume

Sign in

Sql Server Data

Location:
Decatur, Georgia, 30030, United States
Posted:
January 11, 2018

Contact this candidate

Vandana K Mail ID: ac3z3g@r.postjobfree.com

Ph No : 404-***-****

Summary:

Over 9+ years of IT experience as a MS SQL Server Developer 2000-2016 with Integration Services, Reporting Services and Analysis Services and Database experience in data modeling, data warehousing, data entity analysis, logical and relational database design

Extensive knowledge and experience in working with RDBMS, Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Views, Cursors, UDF and Data integrity.

Expertise in Database Backup and Recovery procedures for Disaster recovery using native and third party tools. Expertise in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Experience in implementing High availability like different Replication models, Log shipping, clustering and mirroring on physical and virtual machines.

Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL and Understanding of the Agile and Waterfall methodologies.

Worked on Database usage in cloud, design, administration, OLAP, OLTP and data warehousing, clustering, performance, XML, text search.

Extensively worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML /SQL/ Oracle/Teradata) to different targets (DB/Files).

Extensively worked with the Business Users for creating Reports & Dashboards from Different Data Sources on Tableau, SSRS, Excel, MS Access, Power BI with a focus on timely, accurate and consumable information that enables key decision making.

Worked on Teradata 14.0 SQL Assistant for Analyzing DWH data and integrate into SSAS.

Experienced in MS SQL Server configuration, Partitions, Table Compressions, performance tuning, client/server connectivity, query optimization, back-up/recovery.

Used tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Typically work as a Data scientist which include building data pipelines to pull together information from different source systems; integrating, consolidating and cleansing data; and structuring it for use in individual analytics applications

Excellent analytical, communication and inter-personnel skills with exceptional ability to learn new concepts, adaptable to ever changing priorities.

Skills Set:

T-SQL, SQL, PL/SQL, .NET Framework, VBScript, XML, HTML, DHTML, Shell Scripting, SQL Server 2014/2012/2008R2/2008/2005/2000, Oracle 11g/9i, MS Access, ERWIN, SSRS, SSAS, SSIS, BIDS, Visual Studio, DTS, Crystal Reports, MS Access, VBA Coding, Teradata 14.0, TFS, Web Services, Import/Export data, BCP, MS Visio, Windows 7/Vista/XP/2003/2000 & NT, SharePoint 2010, Tableau 10, Power BI, Microsoft Azure.

Projects Summary As BI Developer/Data Analyst role

UPS Dunwoody GA 03/2016- Present

United Parcel Service (UPS) is a 110 year old package Delivery Company and a provider of supply chain management solutions. The global logistics company UPS's primary business is the time-definite delivery of packages and documents worldwide.

Responsibilities:

Working on UPS Revenue per Plane Project is to build the Revenue Database Model and Analyze the data for Business Users.

Extensively worked in development and tuning of SQL queries, Stored Procedures, data extracts, Data analysis and query optimization, Using DDL commands to build the Database Model and other performance tuning.

Worked on data cleansing and Extract data from different data sources using (SSIS/Import Export Wizard/Open Query/Linked servers) and also Legacy systems.

Schedule and Manage Jobs, Shrink logs and Check performance of the servers.

Write advanced complex SQL queries and stored procedures to perform complex database tasks using T-SQL, PL/SQL, Teradata and implemented best practices to maintain optimal performance.

Design, develop, maintain, support and test advanced SSIS packages related to the extraction, transformation and loading (ETL) process.

Worked extensively on key concepts in data analysis, Dimensional Data Model (Star Schema), Data Mapping and data visualization Develop to Reports & Dashboards for the business users.

Created SSIS packages for the purpose of building reports for business users and deployed it.

Worked on Database architecture, design and implementation of Data Models.

Work on Migrations, Table Compressions and created ColumnStore Indices and worked on partitioning tables.

Developed Tableau Dashboards & workbooks from multiple data sources using Data Blending. Communicating with customers to analyze historical data and identify KPIs.

Design Dashboards using Filters, Parameters and Action Filters and Produce standard monthly reports and create Thematic Heat maps using MapInfo.

Expertise stored procedures, Page level compressions, Optimizing Code and improving efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.

Environment: Microsoft SQL Server 2008R2/2012/2014, SSIS, SSRS, SSAS, MS Access, ODBC, Oracle 12c, Teradata 14.0, MS Office 2010, SVN, SharePoint 2010, Tableau 10, TFS, Informatica PowerCenter Client.

AT&T (Atlanta GA) 01/2015- 03/2016

AT&T is one of world's largest communications companies operating globally under the AT&T brand. It is one of the worlds most advanced and powerful global backbone networks, carrying 82.8 petabytes of data traffic on an average business day to nearly every continent and country.

Responsibilities:

Working in a fast paced team for performing Extraction Transformations and Load DTV Merger data while working for both Mobility & Home Solutions.

Skilled in development and tuning of SQL queries, Stored Procedures, data extracts, Data analysis and query optimization, and other performance tuning.

Write advanced SQL queries and stored procedures to perform complex database tasks using T-SQL, PL/SQL, Teradata and implemented best practices to maintain optimal performance.

Design, develop, maintain, support and test advanced SSIS packages related to the extraction, transformation and loading (ETL tools SSIS, Informatica PowerCenter Client) process.

Involved in data migration projects to Microsoft Azure from MS SQL Server and Oracle for reporting.

Develop scorecards for the business users to analyze the call center evaluation and analytics.

Worked extensively on key concepts in data analysis, Dimensional Data Model(Star Schema), Data Mapping and data visualization Develop to Reports & Dashboards for the business users

Used volatile table and derived queries for breaking up complex queries into simpler queries.

Created SSIS packages for the purpose of building reports for business users and deployed it.

Worked on Database architecture, design and implementation of relational databases.

Experience in Batch processes, SSIS, DTS, BCP, Import, Export, and Backup.

Expertise in writing and debugging stored procedures, Optimizing Code and improving efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.

Environment: Microsoft SQL Server 2008R2/2012/2014, SSIS, SSRS, SSAS, MS Access, ODBC, Oracle 11g, Teradata 14.0, SQL Assistance 14.01, MS Office 2010, SVN, SharePoint 2010, Microsoft Azure, Power BI.

Norfolk Southern Corp. (GA) 05/2012 –12/2014

Norfolk Southern Corporation is one of the nation’s premier transportation companies. Its Norfolk southern Railway subsidiary operates approximately 21,000 route miles in 22 states and the District of Columbia, serves every major container port in the eastern United States, and provides efficient connections to other rail carriers. Norfolk Southern operates the most extensive intermodal network in the East and is a major transporter of coal and industrial products.

Responsibilities:

Understanding the requirement and working with different teams to do Data Analysis on different Data Sources like (Oracle 11g, Teradata 14.0 and MS Access) to provide the Power BI for the business users.

Used Fast Export utility to unload large volumes of data to feed downstream data marts.

Converted the cubes built on DTS Packages from SQL Server 2000 to SSIS packages SQL Server 2008 R2 and added the new business logic for some cubes.

Skilled in development and tuning of SQL queries, Stored Procedures, data extracts, Data analysis and query optimization, and other performance tuning.

Write advanced SQL queries and stored procedures to perform complex database tasks using T-SQL, PL/SQL and implemented best practices to maintain optimal performance.

Create solutions that heavily rely upon T-SQL which requires strong analytical skills to interpret and provide analysis of data and design the best possible ETL process around those goals.

Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008 R2

Build Packages for N&SM - Transportation Planning Department (UTCS) & N&SM - OLC - Loco System & Special Projects Department (LEADER)

Created SSAS Cubes from the new DataMart created for the LEADER Project.

Actively participated in transforming enhanced logical data model to physical data model

Actively involved in Data Gathering, recognizing and confirming the data sources/elements.

Involved in the data migration from different data Sources (Oracle, TeraData) and legacy system to centralized SQL Server databases using SSIS to overcome transformation constraints.

Design, develop, maintain, support and test advanced SSIS packages related to the extraction, transformation and loading (ETL) process.

Environment: Microsoft SQL Server 2005/2008/2008R2/2012, SSIS, SSRS, SSAS,Power BI, MS Access, ODBC, Oracle 11g,TeraData 14.0, SQL Assistance 14.01, MS Office 2010, SharePoint 2010, TFS, Power BI.

NYK Business Systems Americas Inc., Secaucus NJ 02/2009 – 05/2012

NYK Business Systems Americas Inc. is a Global provider of IT for NYK, a Global logistics shipping company. The aim of the project is to provide prompt and accurate Freight business solutions and change of certain business rules that required development of new modules to the system.

Responsibilities:

Migrated data from Heterogeneous data Sources and legacy system to centralized SQL Server databases using SQL Server Integration Services to overcome transformation constraints.

Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.

Upgraded SQL servers to the latest patches on different environments.

Extensively worked on Developing, deploying and supported SSIS packages on SQL Server integration catalog using flat files, SQL Server and Oracle as the source.

Supported data warehouse database and multidimensional cube to make sure the jobs are processed successfully and the cube is processed in a timely manner to meet the SLA’s.

Worked on capacity planning and rearranged the database files across the SAN drives for better performance.

Performed regular backups and restores of the databases using native SQL Backups based on the SLA of the application.

Created and monitored database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.

Maintained Documents for the business users on Microsoft SharePoint to store, organize, share, and access information

Analyzed the strange behavior of the server and provided fixes for the bugs investigated.

Implemented column store index and table partitions to improve performance during executing the SQL Queries on large tables and cube processing.

Performed regular DBA tasks to check for the security level privileges for all the users to maintain compliance issues.

Worked closely with the development team on monthly releases and help fixing the bugs encountered by proactively addressing the issues.

Worked flexibly at late hours with the development team on making any changes and deploying code to the Production Servers.

Setup Windows task scheduler jobs to push all the outbound files to different vendors generated by our daily process.

Developed and implemented custom reports to send out the disk space and SQL Server information to the team and higher management.

Provided 24/7 on call support and dealt with multiple issues by prioritizing.

Environment: Microsoft SQL Server 2000/2005/2008R2, SSIS, SSRS, BI, DTS, SQL Profiler, MS Access, ODBC, Oracle 10i, Microsoft Visio, Erwin, MS Office 2007, Tableau 7.0.

Point Right Inc., Lexington, MA 01/2008– 01/2009

The Company Point Right Inc. is the healthcare leader in predictive data analytics and decision-support services for the clients. The scope of the project was about migrating data from other sources, optimize the existing SQL queries and report generation.

Responsibilities:

Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.

Analyzed Reports and deployed reports in SSRS. Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.

Experience in creating multiple reports (SSRS) in Drill mode using tables, cross tabs and charts. Rebuilt reports and fixed bugs in Stored Procedures, Tables and Triggers.

Involved to implement OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data.

Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard

Involved in creating relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS (SQL Server Analysis Service).

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Environment: MS SQL Server 2008/2010,SSIS, SSRS,MS Access, DTS, Query Analyzer, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server



Contact this candidate