Sql Server Data

Tejasvee Ambati

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

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

Visa Status : EAD

1

An accomplished Database developer with demonstrating ability to implement solutions that decrease costs and increase performance by implementing database solutions. Seeking for a progressive organization that allows me to utilize my knowledge to define new opportunity for personal development and to improve business functionality. Professional Summary:

Around 3 years of IT experience as SQL Server Database Developer in Retail, Healthcare environments with primary skills on the Analysis, Design, Development, implementing and testing client and server application using Microsoft SQL Server suite.

Experience in Software Development Life Cycle, and involved in Waterfall and Agile projects.

Analysing Execution Plan and managing indexes and troubleshooting deadlocks.

Experienced in Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import, DDL/DML Triggers, Hints, Views, User defined data types, Cursors using SQL/ PLSQL and T-SQL.

Hands on experience on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses.

SQL Server Integration Service (SSIS) - Built Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing.

SQL Server Analysis Service (SSAS) - Knowledge in Data Warehouse, Dimensional, Entity Relation, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS) modelling.

SQL Server Reporting Services (SSRS) - Created Stored Procedures for generating parameterized, dashboard reports

Knowledge of Relational Database Management Systems like DB2, Oracle.

Expertise in MS Office products including Word, Excel, Access, PowerPoint, Project and Visio.

Excellent communication and interpersonal skills and strong ability in seeking solutions effectively and aggressively in challenging environments. Technical Skills:

SQL Server Tools SQL2014/2012/2008R2, SSIS, SSRS, SSAS ETL Tools SSIS(SQL Server Integration Services), Data Stage, Bulk Copy Program (BCP), Import Export Data, DTS(Data Transformation Services),

RDBMS MS Access, Oracle 11g/10g, DB2, Teradata

Operating Systems Windows 10, 8/7, Linux

EDUCATION:

Bachelor of Technology from Jawaharlal Nehru Technology University, Hyderabad, India. Tejasvee Ambati

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

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

Visa Status : EAD

2

Professional Experience:

BirlaSoft [Hyderabad, India] Jun 2013 – May 2015

Junior SQL Developer

Responsibilities:

Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.

Reviewed logical and physical data models for new requirements after discussion with technical team and application users as per agile methodology.

Designed and developed SSIS packages to move data from staging environment to Repository environments within the organization.

Designed and implemented complex SSIS package to migrate data from multiple data sources for data analysing, deploying and dynamic configuring of SSIS packages.

Knowledge of ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

Wrote T-SQL queries, common table expressions, Store Procedures and used them to build packages. Used various event handlers to log process information into SQL tables.

Generated reports using Expressions and Functions using SSRS 2008.

Identified the database tables for defining the queries and defined datasets for report generation.

Involved in unit testing documents and shared with the business. Environment: SQL Server 2008 R2/ 2012, SSIS, SSAS, SSRS Tech Mahindra [Hyderabad, India] Jun 2012 – May 2013 Technical Intern

Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.

Worked with team to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.

Gained experience in T-SQL queries, Store Procedures and used them to build packages and handled Change Data Capture (CDC) to maintain the history of the data.

Learnt more on optimizing all indexes, SQL queries, stored procedures to improve the quality of software and improve the performance tuning of queries. Environment: MS SQL Server 2008R2/2005, SSIS, SSRS, SSAS

Contact this candidate