Sql Server developer

Chitra V

Phone: 720-***-****

Email: ***********@*****.***

SUMMARY:

* ****** ** ********** ** Microsoft technologies in design, development and support of database and client applications in production and development. Strong hands-on experience with SQL, T-SQL, PL/SQL. Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts. Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.

Extensive experience in Database development for OLAP Systems (SSIS) using MS SQL Server. Proficient in system management and maintenance with keen focus on database backup, restoration and integration of normalized and de-normalized data.

Transformed data from one server to other servers using SQL Server Integration Services (SSIS). Using Checkpoints in packages to enable the package to run from the point of failure. Analyzed trending reports, drew extrapolations from findings to/with the project manager and the commercial team (SSRS, Excel, T-SQL, Queries)

Experience in documentation and understanding the business/operational requirements. Experience with working in Agile Software Model using Scrum. Ability to troubleshoot system problems, identify interdependencies and implement new solutions. Having exceptional analytical skills, critical thinking ability and recognized as self-motivated, creative, result oriented, excellent communicator and a fast learner. Proven technical skills and the ability to work in a team for successful completion of projects. TECHNICAL PROFICIENCY:

Operating Systems: Windows server 2003, Windows 2000 advanced server, Windows […] XP. Languages: T-SQL, Pl/SQL

Databases: MS SQL Server MS Access Oracle MySQL. Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP SQL Server Tools: Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Microsoft visual studio, SQL Server data tools.

ETL Tools: DTS, SQL Server Integration Services (SSIS), Reporting services (SSRS), Analytical services (SSAS)

Version Control system: Subversion(SVN), Concurrent Versions System (CVS), Team foundation server(TFS) Methodologies: Agile

EDUCATIONAL BACKGROUND:

Bachelor of technology in Electronics and communication, 2007-2011 JNTU, Hyderabad, India

Master’s in Technology, 2011-2012

Eastern Illinois University, Charleston-IL

Master of Business Administration, 2014-2016

Eastern Illinois University, Charleston-IL

PROFESSIONAL EXPERIENCE:

Client: Deloitte (State of West Virginia)

Location: Harrisburgh, PA Mar’13 –Aug’13

Role: SQL/BI Developer

Project Description: Project was to build a data warehouse, migrate the data from various sources into SQL Server, design ETL strategy, create complex cubes and develop analytical reports. Role & Responsibilities:

Working closely with Team lead and Business Analysts to identify and specify business requirements.

Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs.

Developed SSIS Packages to extract data from various data sources such as MS Access, Excel and flat files into SQL server 2008 using different transformations, Derived column, Sort, Row count.

Scheduled SSIS packages by creating the corresponding job tasks.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Designed and Populated specific tables, databases for collection, tracking and reporting of data

Expert in calculating measures and dimension members using mathematical formulas, and user-defined functions.

Created and automated SSRS reports.

Diagnosed and addressed operational data issues

Maintained client relationship by communicating the daily status and weekly status of the projects. Environment: MS SQL Server 2008 Visual Studio, MS SQL Server 2008/2012 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, Windows XP, MS Excel 2007,SVN/CVS.

Contact this candidate