Lakshmi Sahitya Anala Email: ac4kas@r.postjobfree.com

425-***-****

Summary:

* ***** * ****** ** IT Experience in Database Design, Development and business

intelligence of Microsoft SQL Server BI.

Expertise in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) and good knowledge in Power BI.

Experience in writing T-SQL Queries, Stored Procedures, Functions, Joins, Views etc.

Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques.

Experience in creating packages, Jobs, Sending Alerts using SQL Mail.

Expertise in enhancing and deploying the SSIS Packages from development server to production server.

Expertise in creating cubes with dimensions and facts tables in Warehouse using SQL Server Analysis Services (SSAS).

Extensive experience in developing reports and deploying reports in SSRS using Report Wizard, Report Builder and Report Manager.

Experience in designing report with rich UI including Tabular forms, Matrix (Cross /tab Report) form, Drill down, parameter, cascading parameters, Charts and Sub Reports.

Experience in designing and developing large number of enterprise reports in SSRS using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.

Experience in using the performance monitor/SQL profiler to solve long running queries.

Quick learner and good performer both in team and independent job environments.

Technical Skills:

SQL Server

MS SQL Server 2012

Languages

T-SQL, PL/SQL & C

BI Tools

SSIS, SSAS, SSRS, Power BI & SQL Profiler

Version Control

Team Foundation Server

Development Tools

BIDS, SSMS

Professional Experience:

Client:Jardencorporation June 2015 – August 2016

SQL Developer:

Jarden Corporation is a provider of a range of consumer products. The Company operates in three business segments: Outdoor Solutions, Consumer Solutions and Branded Consumables. Its segments manufacture or source, market and distribute a number of brands, including Outdoor Solutions, Consumer Solutions, and Branded Consumables.

Responsibilities:

Collected business requirements from users and translated them as technical specs and

design docs for development.

Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.

Creating and Modifying T-SQL stored procedures for validating the integrity of the data.

Extensively used SSIS to move data from text files to SQL Server.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

Rebuilding Indexes and Tables as part of performance tuning exercise.

Scheduling Jobs and Alerting using SQL Server Agent.

Created datasets for reports using T-SQL and stored procedures.

Responsible for maintaining cubes using SSAS and populate the cubes with the data.

Performing query plans and making sure each and every query is using appropriate useful indexes.

Client:AxisCapital March 2014 – May 2015

MS SQL Server Developer:

AXIS Capital provides specialty insurance and treaty reinsurance on a worldwide basis through operating subsidiaries and branch networks based in Bermuda, The United States, Canada, the United Kingdom, Ireland, Switzerland, Australia and Singapore.

Responsibilities:

Defined Check Constraints, functions, indexes, synonyms and views.

Created and modified complex TSQL batches/stored procedures.

Creating Database objects – tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.

Performing query plans and making sure each and every query is using appropriate useful.

Involved in creating new stored procedures and optimizing existing queries and stored procedures.

Involved in defining referenced relationships with the measure groups and fact tables.

Designed and implemented stored procedures and triggers for automating tasks.

Created SSIS Packages for Import/Export data to/from SQL Server.

Worked on SSIS using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.

Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.

Scheduled jobs and alerts using SQL server agent.

Contact this candidate