Sql Server Engineer

Sneha Muddup

*******@*****.*** 408-***-****

Sr. SQL Server BI Developer

PROFESSIONAL SUMMARY

Having 8+ years of IT experience in Database Design, Data Modeling, Requirements Analysis, Application Development, and Testing, Implementation and Deployments using SQL Server 2005/2008/2008 R2 /2012and some DB2 experience.

Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.

Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.

Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements.

Experience in migration of data using Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.

Expert in Query Tuning and activities including Updating Statistics, Re-building and Re-organizing Indexes.

Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Experience in developing, configuring and deploying the SSIS packages and providing security for the packages.

Good experience in working with SSAS in creating cubes, named queries, data source views, dimensions and deploying of analysis services projects.

Experience in Dimensional Data Modeling Star and Snow Flake Schemas

Experience in creating different kinds of reports like Drill down, Drill through, Sub Reports, Parameterized reports and Charts

Experience in developing various kind of complex reports including Cascading parameters, Drill down, Drill through, Sub Reports and Charts.

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

Good experience in creating and maintaining Documents for future needs.

Hands on experience with Load Testing, Integration Testing and User Acceptance Testing (UAT).

Having good knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), and Bug Life Cycle (BLC)/Defect Life Cycle.

Extensive experience in performing different types of Functional test activities like System testing, Regression Testing, Smoke Testing and Adhoc Testing

Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.

Experience as a QA Test Engineer, coordinating and managing teams across 2 locations, e.g. teams of 8-10 people. Excellent understanding of QA processes, methodology and Testing Concepts.

TECHNICAL SKILLS

Databases : SQL Server2012/2008R2/2008/2005/2000, DB2, MS-Access

Database Tools : Management Studio, Enterprise Manager, SSIS, SSRS

Data Modeling Tools: Erwin, Microsoft Visual Studio 2008/2005, VISIO

Languages : C, T-SQL, PL-SQL, VB.net

Operating System : Windows 2008/2003 Server (32/64 bit), Windows 2000 Datacenter,

Windows XP, Vista, Windows Server 2003/2008

Architecture : Relational DBMS, Client-Server Architecture and OLTP

Management tool : Quality Center, JIRA, CVS, MS TFS

CURRENT PROJECT:

FEDERAL HOME LOAN BANK OF DALLAS, TX DEC 14 – CURRENT

Sr. SQL Server Developer T-SQL/SSRS

The Federal Home Loan Bank of Dallas (FHLB Dallas) is a part of the Federal Home Loan Bank System, created by an Act of Congress and signed into law by President Herbert Hoover on July 22, 1932, to provide capital for mortgage funding during the Great Depression.

The System has 12 banks around the United States, serving as an affordable, flexible source of funding for some 7,800 financial institutions. FHLB Dallas is one of these 12 banks.

SQL Experience Overview:

6+ Years in SQL

4 + Years in SSIS

4 + Years in SSRS

2 + Years in SSAS

For Complete Resume Please contact me as Follow –

Email – *******@*****.***

Direct – 408-***-****

Contact this candidate