Sql Server Data

Uma Mahesh

Mobile: 951-***-****

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

Career Objective:

Looking for SQL SERVER/BI Developer positions where I can use my technical skills and be a valuable resource to the organization.

Highlights and Skills:

4 years of experience in SQL Server 2005/2008/2008R2/2012, Oracle, Teradata

Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

Worked on SSIS, SSRS and SSAS

Strong knowledge on concepts like Replication, Database mirroring

Knowledge on Database Modelling and Database Design

Involved in performance tuning using SQL Profiler and Execution plans

Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and SSIS

Experience with Transact-SQL in constructing Triggers, Tables, Stored Procedures, Functions, Views, User Profiles, Data Dictionaries, and Data Integrity.

Expertise and strong working knowledge on Performance Tuning using SQL Profiler, Execution Plans

Excellent knowledge on Indexes (Cluster/Non-Clustered/Column)

Good understanding of concepts like Enterprise Data Warehousing (EDW), Data Mart, ETL, Data Modelling, Data Mapping

Experience in generating Ad-Hoc, drill down, drill through reports using Local and Global Variables, Expressions and Filters in SSRS.

Education Background:

Masters from University of Central Missouri, USA

Bachelors from Sri Krishnadevaraya University, India

Technical Skills:

RDBMS / Databases

MS SQL Server 2012/2008R2/2008/2005/2000, Teradata 2015

Languages

T-SQL, PL/SQL, .NET, Visual Basic 6.0, HTML

Operating Systems

Windows Server 2008/2003/XP/2000/NT/98/95, MS DOS 6.2

Modeling Tools

Microsoft Visio 2007, ERwin Data Modeler 8/7/5

Reporting Tools

SQL Server Reporting Services (SSRS), PowerBI

Integration Services

SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Analysis Service

SQL Server Analysis Services (SSAS)

Database Tools

MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor (DTA), Tableau

Internet Tools

Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

SharePoint

Microsoft SharePoint 2003 – 2010

Professional Experience:

SQL Developer

Kiewit Corporation, Omaha, NE July 2016 – Till Date

Responsibilities:

●Worked as a SQL Developer with Enterprise Reporting Team.

●Closely worked with Database Manager and under his supervision.

●Worked on SQL SERVER 2012/ 2014 versions and respective data tools.

●Worked on all the end to end TSQL operations such as inserting, updating and dropping/truncating, developing scripts, running scripts as per the requirement.

●Created SSIS packages for loading data into Tables from various sources such as Excel, Text files.

●Worked on complex SQL queries using joins, CTE for data retrieval process.

●Worked on complex stored procedures, created and modified as per the requirement of the projects.

●Used Merge statements for the incremental load process into the Data Warehouse on the daily basis.

●Worked on ticketing system and fixed all types of priority tickets.

●Worked on the achieve process of large volumes of tables with millions of records for the performance enhancement.

●Involved in import / export process of the data with the vendors as per the requirement.

●Generated Ad hoc reports, SSRS reports such as parameterized report, Drill Down, Drill Through, Cascading reports as per the requirement.

●Migrated SQL reports in SSRS to Teradata.

●Created report queries utilizing Teradata SQL.

●Experience with performance tuning of the long running queries.

●Performed parallel runs to validate the Teradata results to match the SQL results exactly.

●Experience with resolving discrepancies found in parallel tests.

●Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

●Schedule SSIS packages through SQL Server Agent – Jobs and make sure that the packages are executed for every 8 hours’ time span.

●Involved in creating web applications using ASP.NET platform that supports the integration of SSRS reports for display within web portals

●Used SQL Server Profiler to trace the slow running queries and the server activity.

●Automated and enhanced daily administrative tasks including database backup and recovery.

Tools & Technologies:

MS SQL Server 2014, SQL server Data tools, Teradata SQL Assistant, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), Team Foundation Server (TFS), HP ALM

SQL Server Developer

BijjamIT.Inc –Chicago, IL Sep 2015- June 2016

Responsibilities:

●Worked with business analyst and with users to understand data and requirements, and develop visualizations in agile approach.

●Experience in writing Materialized views and Data transfer processing - extracting data from Oracle servers to SQL servers by creating ETL Packages.

●Expertise in writing SQL and PL/ SQL Queries.

●Designed and developed specific databases for collection, tracking and reporting of data.

●Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.

●Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from large number of tables.

●Designed and Developed Database Objects like Tables, Views, Stored Procedures, Triggers, Rules, Defaults, user defined functions for this project.

●Created SSIS packages using data transformations like Conditional split, OLE DB Command, Lookup, Data Conversion, Derived Column, Merge, Merge Join, Sort.

●Worked on SSRS in developing the reports such as Bar Reports, Drilldown Reports, Map Reports, and Pie Chart Reports, Parameterized reports.

●Created reports to retrieve data using Stored Procedures and accept parameters for performing the calculations, concatenation them with the strings and formatting as per the requirements on the reports and dashboards.

●Created Non-Clustered Indexes on the new servers for enhancing the performance of the queries.

●Created Data Sources, Datasets and Parameters as per the requirements of the reports

●Prepare client reports using Microsoft Excel worksheet.

●Work closely with higher management like VPs and interacted with clients to explain reports

SQL Server Developer

Genpact, Hyderabad, India Aug 2012 – July 2014

Genpact Limited is a multinational business process and information technology services company, domiciled in Bermuda with executive headquarters in New York.

Responsibilities:

●Involved in Creation of tables, indexes, sequences, constraints and created stored procedures and triggers which were used to implement business rules.

●Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.

●Extensively involved in SQL joins, sub queries, tracing and performance tuning for better running of queries

●Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.

●Designed and created different ETL packages using SSIS and transfer data from heterogeneous database different files format Oracle, SQL Server, and Flat File to SQL server destination.

●Worked on several transformations in Data Flow including Derived column, Slowly Changing Dimension Using SSIS Controls, Lookup, Fuzzy Lookup, Data Conversion, Conditional split and many more.

●Created various reports with drilldowns, drill through, calculated members, and drilldowns reports by using SQL Server Reporting Services

●Used various report items like tables, sub report and charts to develop the reports in SSRS and upload into Report Manager

●Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules

●Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2012/2008R2/2008, T-SQL, SQL Server Reporting Services (SSRS), SSIS, SSAS, Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Team Foundation Server, VB Script

Contact this candidate