Vandana K Mail ID: adc3d8@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 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 SQL/SSIS/SSRS/SSAS Developer/Data Analyst role

UPS Dunwoody GA 07/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 Data 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 Extract data from different data sources (Teradata, Oracle, Flat files, XML) using (SSIS/Import Export Wizard/Open Query/Linked servers) into staging, transform to recast source data for analysis, and loading of transformed data into the presentation repository.

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

Working on Azure Data Factory (ADF) and SSIS systems for moving and integrating data across on-premises and cloud using Azure functions.

Develop and improve Microsoft Analysis Services cubes (tabular and dimensional). Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Design and develop ETL processes/ SSIS packages (data flow tasks, transformations, precedence constraints, expressions, etc.) and create ETL test cases with strict adherence to transformation rules and is in compliance with all validity checks.

Worked extensively on data mapping of all source systems as part of data Analysis. Used data transformations such as script component, Pivot /unpivot, Multitask, Derived column, Data conversion, row count and send mail task etc.

Used JIRA for bug tracking, issue tracking, and project management. It was used to watch software backlog planning, release planning, and overall progress of the projects.

Aggregated and analyzed data then ingested into Power BI for creating Dashboards, KPI for the business users to have a better insight into the business.

Expertise stored procedures, Page level compressions, Optimizing Code and improving efficiency in databases including Re-indexing, Updating Statistics, using Always Encrypted feature 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, JIRA.

AT&T (Atlanta GA) 01/2015- 06/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.

Design and schedule the ETL/ELT process for periodic automated updates, including FTP/SFTP file transfers.

Worked extensively with SSIS Performance tuning using counters, error handling, event handling, rerunning of failed packages using checkpoints and scripting with VB.net in SSIS

Develop interactive dashboards, scorecards, highly formatted reports 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.

Expertise in writing and debugging SSIS Packages, 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.

Worked extensively on SSIS data mapping of all source systems as part of data Analysis. Used data transformations such as Script component, Pivot /unpivot, Multitask, Derived column, Data conversion, Row count and send mail task etc.

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.

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

Contact this candidate