Sql Server Data

Divya Kommoju

Phone: 813-***-****

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

SQL/MSBI Developer

Summary:

Over 2.5years of experience in Information Technology with solid working experience as SQL server Developer with SSIS, SSRS, and SSAS mainly in Sales & Telecom Domains.

Skilled in writing and reviewing T-SQL code DDL, DML, DCL and maintaining coding standards.

Experienced in writing complex T-SQL Queries, Stored Procedures, Triggers, Views and Indexed Views, User Defined Functions, CTE’s, Latest Date Functions, Table Variables to implement business logic.

Strong knowledge and experience with Relational Database Management Systems, including E/R Diagrams, Normalization, Constraints, Querying, Joins, Keys, Indexes, and Data Import/Export.

Experience in Error handling and debugging coding issues using Try Catch Block and error methodologies for troubleshooting coding issues.

Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.

Expert in Extracting, Transforming and Load data (ETL) from various heterogeneous sources and creatng packages using SSIS, Import & Export Data, Bulk Insert and BCP utilities.

Developed SSIS packages for importing and exporting data from various Databases like MS Excel, Flat files, Teradata, Oracle, DB2.

Expert Level experience with performing various SSIS control flow and data transformation tasks like Look-ups, Conditional Splits, Derived columns.

Expert in creating custom Logging and Event Handlers for error handling in SSIS packages.

Experience in converting ETL packages from legacy systems (DTS and SQL 2000 code) and migrating to Latest SSIS versions, deploying the packages across Dev/UAT/Prod environments.

Expertise in creating Cross-Tab, Drill-down and Sub-Reports using SSRS RDL and promoting RDLs to Reporting Services Server.

Wrote and integrated stored procedures to generate the SSRS reports.

Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, writing named queries, calculations members using expressions, creating perspectives and actions for users and Deploying and Processing SSAS objects.

Strong team player with ability to prioritize workload.

Very good understanding of the project development life cycle, estimating project-hours, writing project Implementation plans, and preparing back up plans.

Technical SKILLS:

Programming Languages

T-SQL, PL/SQL, C -Language

Databases

MS SQL Server 2014/2012/2008 R2, Teradata V14/15, Oracle11i MS Access 2000, DB2, SQL*PLUS.

Database Tools

SQL Management Studio, Data tools (SSIS/SSRS/SSAS), SQL Server Enterprise Manager, T-SQL, DBCC, BCP, SQL Server Profiler, SQL Server Query Analyzer, Import/Export tools, SQL Server Agent, oracle enterprise manager and TOAD.

Reporting Tool

SSRS, Excel, Tableau.

Tools

Microsoft Visio, Data tools (SSIS/SSRS/SSAS),Visual Basic 10.0,HP Quality Center.

Version Control

Visual Source Safe 8.0, Windows SharePoint Services.

Operating System

Windows 2012 R2/2008/ Windows 7/8/WIN 10.

EDUCATION:

Bachelors of Technology in Electronics & Communication Engineering, Jawaharlal Technological University, India.

Valira llc, FL May 2016 –Till Date

SQL/ MSBI Developer

Roles & Responsibilities:

Gathering new requirements from the users and preparing the BRD’s and HLD’s.

Communicating with users to understand the functional and technical specs.

Understanding BRD, Gathering requirements from users and mapping them to development.

Developing Complex SSIS Packages for Data Migration, Incremental Loads, and SCD’s using control flow and data flow toolbox components.

Transforming the SSIS packages according to the Client requirements with required business Logics.

Involved in designing SSIS packages for data mart for sales and partner channel subject areas of ODS and DW. Integrated data into ODS and cleansed it to move to Data mart using SSIS.

Developed complex SSIS packages to transform raw data into business data from various sources like Flat files, Teradata, SQL Server to SQL Server database stage area.

Developed SSIS Packages to run the Batch scripts and FTP (File Transfer Protocol) to other servers using UNIX and DOS commands.

Configured packages for sending automatic mails to the respective Groups when a SSIS process

failure or success.

Enhancing and deploying the SSIS Packages with new logics or enhancements and deployed them from Development server to UAT and Production server.

Extensively developed SSAS Cubes, Partitions, Aggregations, KPI’s and Browser perspectives.

Creating SSRS Reports from Pre-built Cubes for Business Users. Assigning access approvals to the new users for SSRS reporting website.

Involved in creating SQL server logins, creating roles, granting privileges, unlocked accounts, reset passwords for developers and users.

Responsible for Database backups &Restoration, Backup policies, scheduling backups.

Tuning and optimization of T-SQL Queries using Execution plan, tuning advisor based on Change request management.

Environment: Windows 2012 R2/2008/2003 Server, SQL Server 2014/2012/2008R2, Data tools( SSIS,

SSAS, SSRS), .NET Framework 4.5, VB10, TERADATA VR14/15 MS Excel, Access,

Visual Studio.

Visakha Steel Plant, India April 2015 – March 2016

SQL/ MSBI Developer

Roles & Responsibilities:

Involved in understanding Business requirement document and developing Technical Design specification documents for multiple interfaces.

Identified various source systems for data feeds.

Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Designed and developed jobs for loading data to star schema.

Extracted Data using SSIS from DB2, and flat files, Excel transformations and

Populate the data warehouse. Worked on SSIS to remove duplicate records with data standardization.

Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.

Created various Jobs, Alerts and Events, Created Backups for databases and automated the process. Assisted in building dimensional cubes with SQL Server Analysis Services (SSAS) and building multiple calculated members, KPI’s for user perspectives.

Worked as a developer in creating complex Stored Procedures, tables, and views and other SQL joins and statements using T-SQL for different applications.

Managed index and optimized queries using execution plan.

Created and integrated user defined functions and stored procedures for reporting purposes.

Involved in the Analysis of the Report Data, Developed and Deployed Reports on to the Reporting Server. Wrote and integrated stored procedures to generate the reports.

Created Cross-Tab, Drill-down and Sub-Reports using RDL and promoting RDLs to Reporting Services Server.

Environment: SQL Server 2012/2008 R2, T-SQL, PL-SQL, SSIS, SSAS, Power Pivot, MS Access, SharePoint server, Windows 8/7.

Contact this candidate