Sql Server Project Management

Swetha Y

Plano, TX ***** – 201-***-**** – *****.******@*****.***

SQL BI Developer

IT Design & Development~ Project Management ~Application Testing

Project Life Cycle

SQL Reporting and Analytics

ETL Implementation

Data Modeling

Web Applications

Indexed Views

Data Manipulation

Adhoc Reporting

QA Processes

Analytical, highly adaptable professional with 8 years of progressive experience in the Analysis, Design, Development and Testing of Client/Server Applications utilizing Microsoft SQL Servers and BI Suite.

Strong knowledge and comfort within Microsoft-based server environments, along with all peripheral processes.

Knowledgeable in aligning end-user needs with long-term resolutions to complex IT challenges. Solid track record of progressive success.

Skilled troubleshooter continually focused on identifying, isolating and resolving technical issues.

Accomplished communicator skilled in building and strengthening relationships across functions to drive cohesive, strategic operations.

Career Highlights

Successfully transferred data from one server to various other servers by utilizing tools such as Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SISS) (2005/2008/2008 R2/2012, 2014).

Supported team while resolving SQL Reporting services & T-SQL related issues, while maintaining proficiency of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP & Sub Reports.

Created and structured reports on SASS & SSRS on SQL Servers (2008/2014).

Expertise in formulating MDX cubes & dimensions (SSAS). Deployed new test design specifications for all new features to ensure adherence to service levels.

Managed Adhoc, Parameterized, & Custom Reporting logistics by utilizing SSRS.

Extensive knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI Suite, Reporting & Analytics; Played essential role in DBA activities like backups, restores & replication.

Career Progression

SCANTRON San Diego, CA Sep 2010-Present

Lead SSAS/SSIS/SSRS Developer

Operations Management: Planned, organized & launched complex ETL architecture for data transfer from OLTP to OLAP by utilizing SSIS.

Efficiency & Quality Improvements: Deployed SSIS Packages from development server to production server; Ensured SSIS Packages data was loaded into Data WareHouse; Created SSAS Cubes and Partitions. Created Tables, Views, & Triggers & stored Procedures by utilizing T-SQL.

Systems Administration: Collaborated within a team environment: Participated in writing ASP .Net, Visual C# Scripts within SSIS Packages.

Design & Development: Charged with formulating SSAS Cubes from the Data WareHouse.

Reporting & Analysis: Created data models with Erwin as well as Tabular, Matrix, list, Parameterized, sub & adhoc Reports; Analyzed & monitored changes accordingly.

Project Management: Integral participant who directed projects involving Data Marts, Operational Data Store (ODS), Snow-Flake Modeling, & Star Schema Modeling; Delivered strategic recommendations for solutions and process improvement.

Staff Management: Oversaw technical operations of both On-Shore & Off-Shore teams.

Deutsche Bank (RREEF) Chicago, IL Nov 2009-Aug 2010

Lead SSIS/SSRS Developer

Operations & Technical Management: Influential role in Production Support of SSIS Packages; Input data into staging tables & verified it by applying validation rules; Installed & configured SSRS 2005/2008.

Server Support: Planned and executed operations related to installation & configuration of SQL Server 2008/2005 while simultaneously managing other projects.

Systems Administration: Successfully designed & developed intricate level of ETL architecture to ensure accuracy during data transfer from source server to the Enterprise Services Warehouse, which involved database name, accounts, tables & direction of data flow, Data dictionary, & Metadata.

Eli Lilly In Feb 2009- Oct 2009

SQL SSRS/SSIS Developer

Efficiency & Quality Improvements: Developed SSRS reports by utilizing sources such as Oracle, Hyperion & SQL Server; Designed Tablix, Matrix, Parameterized, & Sub Reports through the use of SQL Server Reporting Services 2008; Built & tested OLAP cubes with SSAS 2005.

Molina Healthcare CA Aug 2008- Jan 2009

Sr. SSAS, SSIS Developer

Production, Reporting & Analysis: Developed reports with the use of SQL Server 2005 Reporting Services & successfully created reports on Analysis Services cubes; Provided extensive production support of SSASS cubes & SSIS jobs.

Operations & Technical Management: Directed a team of three developers, one DBA & two Business Analysts; Fostered their career development & monitored progress.

Project Management: Launched project by using ASP.Net, Visual C# as front end & SQL Sever 2005 as back end Database; Developed Shell scripts; Participated in logistics surrounding Change Management & creation of Autosys jobs.

Technology Proficiencies

Hardware: HP/Compaq ML 380 Servers, Dell Power edge series

Database: SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, Oracle 10i

Operating Systems: HP UNIX, Windows XP/2000/2003

Programming Languages: SQL, PL/SQL, C

BI Suite: SSAS, ProClarity, SSRS, MOSS, PPS, Hyperion

ETL TOOLS: DTS, SSIS, Informatica 7.1.3/6.2

Database Tools: DBArtisan, SQL Litespeed

SCM Tools: Visual Source Safe, Team Foundation Server

Education

MASTERS IN Electrical Engineering

FDU,nj,USA

Bachelor in Computer Science and Engineer

JNTU, Hyderabad, India

Certifications

Microsoft Certified Technology Specialist in SQL Server 2008

Brain bench Certified in SQL Server 2005

Contact this candidate