Bindya Vijay

SQL Server DBA/Developer

*+ years of MS SQL Server Development and Administration for very large and complex databases in SQL Server 2014, 2012, SQL Server 2008 R2, 2008 and 2005; Microsoft's suite of products like SSIS, SSAS, and SSRS.

Very strong in Data Warehousing Concepts and Expertise in planning, architecture, and design of data warehousing and SQL optimization.

Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision. Good understanding of Health care, Financial and Retail domains.

PROFESSIONAL HISTORY

Cox Automotive (Autotraders), Atlanta, GA Mar 2013 – Dec 2016

SQL Server DBA/DEVELOPER

Installed SQL Server 2014/2012/2008R2/2008/05 on Windows Clustered and standalone environments with latest service packs.

Upgraded SQL Server databases from 2000/2005 to 2008R2/2012

Experience in working and troubleshooting2TB Very Large databases (VLDB) in OLTP Environment.

Configured AlwaysON availability groups in SQL Server 2012

Configured log shipping for multiple databases as a part of DR.

Configured Replication and Database mirroring.

Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.

Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.

Analyze long running slow queries and tune the same to optimize application and system performance.

Reorg/Rebuilding the indexes at regular intervals for better performance

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Designed transformation rules and processes to derive the correct data from the extracted data and transform into the required format and structure to support the business requirements.

Loading the transformed data into the target database and the associated metadata into the enterprise metadata repository.

Designed various schemas which are used for Landing the data, staging for transforming the data and PROD in MS SQL Server 2012.

Extensively worked with Team Foundation Server 2012.

Experience in creating complex SSIS packages using proper control and data flow elements.

Created joins and sub-queries for complex queries involving multiple tables.

Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.

Worked with different sources to extract the data like Flat File, Excel, OLE DB, and Raw File and loaded the data into different destinations like OLE DB, Flat File, Excel and Record set Destination.

Worked on multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all.

Extensively worked with different control flow tasks such as ExecuteSQL Task, Data Flow, Execute Package, File System Task, Script Task, Send Mail Task and different containers like For Each Loop and Sequence Container.

Created about 25 dimensions and 5 facts

Pulling data on a daily basis from AS/400(DB2) using the SSIS packages.

Processing the Facts and dimensions on a daily basis using the SSIS tasks.

Partitioned Fact and Dimension data on Year and Month. Designed partition techniques to swap out latest 4 months data to load fresh data in daily run.

Performed the task of data transfer from files in remote Server to folders in another Server using FTP.

Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2012.

Worked on Slowly Changing Dimensions (Type-1 & Type-2) and Change Data Capture.

Created Junk Dimensions, Conformed Dimensions and Fact less Fact.

Created database maintenance plans and deleting of history data using SSIS packages.

Worked on migrating data from SQL Server 2008(R2) to 2012.

Actively designed the database to fasten certain daily jobs, stored procedures.

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Worked on Analysis Document, Design Document and Data Profiling.

Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.

Worked with HP Quality Center for writing and testing the test cases.

Worked on migrating the Cognos reports to SSRS. Worked with different tasks in SSRS like tables, charts, sub reports, List, Image and Textbox.

Created drill through, drill down reports, parameterized reports. Deployed reports to Report Server.

Environment: MS SQL Server 2014/2012/2008R2/2008/05, Business Intelligence Development Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), SQL Profiler, SQL Server Agent, Erwin, Windows 7/XP

The Home Depot, Atlanta, GA Nov 2011 - Feb 2013 MS SQL Server BI Developer

Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL 2012/2008 to store data and to maintain database efficiently.

Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.

Developed and deployed data transfers packages using SSIS 2012/2008, also maintained the jobs running on Servers.

Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.

Wrote SSIS Packages to migrate user's logins, stored procedures, and functions.

Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

Deploying, Testing and Scheduling SSIS packages using SQL Agent.

Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.

Created many Cascaded parameters in the reports using SQL SSRS 2012/2008. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2012/2008).

Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.

Worked with production control team to deploy code and for schedule run in both staging while testing and production. Responsible for providing 24/7 on-call production support for daily job and ETL loads.

As in development team, worked with DBA teams for database update and system restarts.

Raised RFCs to implement the reports to production and also worked with the portal team to create links accessed by the store users on the My apron web portal.

Created SSRS reports for buyback reports and also had to recreate the reports in microstrategy.

Involved in normalizing the data from source systems by identifying columns in the table, which came in as fully De-normalized flat file.

Migrated objects from Dev to QA by creating Packages through object manager.

Created mock up data as per logic provided by business and had them updated on the aggregate tables for testing.

Create reusable queries using Teradata SQL Assistant to validate content of normalized table structures, and denormalized materialized views following ETL loading.

Created metrics using pass through functions such as apply simple and derived metrics with IF functionality.

Environment: MS SQL Server 2008R2/2008/2012, Business Intelligence Development Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), SQL Profiler, SQL Server Agent, Erwin, Windows 7/XP, Microstrategy 9.x.

EDUCATION

B. Com (Computer science), Bangalore University

SKILLS

Databases:

MS SQL Server 2014, 2012, 2008, MS SQL Server 2005, Hadoop, Oracle 10g/9i/8i, Teradata 12 and 13,

Programming:

Visual Basic 6, Visual Basic 5, C, C++ & SQL,.NET,Python

DBA:

database administration of MS SQL Server 2012,2008, 2005

Operating System:

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Other Software:

BI Tools-microstrategy, crystal reports, Hyperion, obiee

Tools:

Backup Utility, SQL LiteSpeed, Visio, ERWIN

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Contact this candidate