Resume

Sign in

Sql Server Data

Location:
Seattle, Washington, United States
Posted:
May 31, 2017

Contact this candidate

Teja sri

210-***-****

ac0kss@r.postjobfree.com

Professional Summary:

A Microsoft Professional around 8 years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2.

Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.

Experience in maintaining one to many and many to one relationships while moving data between two databases.

Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.

Expertise in writing TSQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

Supported team in resolving SQL Reporting services and TSQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.

IOS Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.

Experience in ETL processes involving migrations and in sync processes between two databases.

Experience in Microsoft Visual C# in script component of SSIS.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).

Experience in creating configuration files to deploy the SSIS packages across all environments.

Expert in generating writing parameterized queries, drill through reports andformatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.

Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.

Proficient in Data warehousing and SSAS skills: MDDB/MDX, KPIs, CalculatedMembers, OLTP, OLAP (MOLAP, HOLAP, and ROLAP), Relational and DimensionalModeling skills (star schema and snowflake schema).

Performance Oriented in Developing and Extending Cubes, Dimensions and DataSource Views, Data Mining Models, and Deploying and Processing SSAS Objects.

Experience in writing TSQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.

Worked with report manager for deploying the reports across all the environments.

Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.

Expertise in Configuring and managing data sources, data source views, cubes, dimensions with SSAS.

Expertise in creating Aggregations, partitions in cubes using SSAS.

Experience in Database Backup, Recovery and Disaster Recovery procedures for large, medium and small database instance

Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.

Strong experience in SQL database design, architecture, data modeling (conceptual, logical and physical) using Erwin

Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008/2014.

Strong work experience as Business Objects Developer.

Knowledge on Oracle Data Integration Tool(ODI).

Knowledge on Oracle 9i and PL/SQL

Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

Good ability to quickly grasp and master new concepts and technologies

Technical Skills:

Operating Systems Win 2000/NT/2003/2008 server.

RDBMS MS SQL SERVER 2016/2014/ 2012/2008/2005/2000, MS Access, Oracle8i/9i,oracle10g.

Database Tools SQL Query Analyzer, SQL Enterprise Manager, Management.

Studio, SQL Server 2005, Query Editor,Reporting Server, Ms-Access.

ETL Tools Data Transformation Services (DTS), MS SQLServer Integration

Services (SSIS),IBM AS/400,Informatica,ODI(Oracle Data Integration).

Reporting Tools Crystal Reports XI/X, MS SQLServer Reporting Services (SSRS).

Data Modeling ER-Win 4.0, MS Visio 5.0.

BI Tools MS SQL Bussiness Intelligence, Business Objects.

Programming Languages Unix,C#, VB,XHTML and XML.

Education Details:

Masters in Computer science Texas A and M University,USA.

Professional Experience

HYLA,Dallas, TX Sept’15 – Till Date

SQL BI Developer

Responsibilities:

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2014(BIDS) and Crystal Reports.

Provided all configuration details, including the product version, product level, engine edition, database file sizes, and CPU and memory resource, of all the SQL Server 2005/2008 accounted for migration.

Granted DB access to users following the security standards

Coordinated with the application teams and performed backups of SQL Server 2005/2008 Involved in Migrating Crystal reports to SSRS Reports.

Worked on formatting SSRS reports using the Global variables and expressions.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Write TSQL Scripts for database backup jobs and daily/weekly jobs.

Involved in creating multiple parameterized stored procedures, which were used by the reports to get the data.

Installation and Maintenance of SQL Server 2008 R2/2005 on Test, Development and Production Environments.

Created and Maintained Databases across Development and Production Instances.

Wrote VB and c# scripts when creating SSRS Reports.

Loading data from various sources like OLEDB, flatfiles, MS Access to SQL Server database Using SSIS/ETL Packages and created data mappings to load the data from source to destination.

Experience in Performance Tuning in SSIS packages by using Transformations, Block and Unblock Transformations.

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

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler.

Involved in Monitoring and troubleshooting complex SSIS/ETL packages by using Data Viewers Grids.

Write TSQL statements for retrieval of data.

Creating joins and sub-queries for complex queries involving multiple tables.

Optimized query performance by creating indexes.

Used query execution plan to optimize the store procedures to reduce the cost.

Environment: SQL Server 2005/2008/2014 SQL Reporting Services (SSIS), Crystal,Microsoft Windows 2012/2008 R2/2008 Servers,XML.

T.G.Mercer,Dallas, TX Nov’14 - August'15

SSRS Developer/DBA

Responsibilities:

Created a new software solution for inhouse need,using TSQL as back end and .net as front end application.

Even did UAT Testing for inhouse application.

Developed SSRS ad-hoc reports,Parameterized Reports and subreports.

Working on SymmetricDS Software and solving the issues occrued on that software.

Crated database backups and restored the databases.

Optimizied stored procedures to reduce the time of running.

Used Background Worker, Multithreading and TPL for implementing parallel processing and printing of returns.

Provide support out of office hours, during weekends and during major release work to development and customer to help them resolve issues faced.

Migrating the data using SSIS/ETL package.

Configured and Monitored transactional replication.

Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.

Configuring XML files for the application to run the reports.

Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Wrote Vb scripts in SSIS packages and SSRS Reports.

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Troubleshoot problems by checking sessions and workflow logs.

Created Linked Servers between different Servers in SQL server.

Database Backup and restores.

Designed SSIS/ETL Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Environment: Windows 2007 enterprise, SQL Server 2008/2005,SQL Integration Services(SSIS), Business Intelligence Development Studio, TFS, Symmetric,.Net framework 3.5,XML.

Liquid Motors,Dallas, TX Oct’13 – Oct’14

SQL BI Developer /DBA

Liquid Motors Inc., a Dallas, Texas based corporation, offers the automotive industry comprehensive Internet marketing solutions designed to maximize lead generation. Liquid motors also offers marketing solutions for financial Institutions like Bank of America, Wells fargo etc. for un-paid loan recovery vehicles. For automotive dealers liquid motors provide a variety of software and services that create competitive advantages by generating and capturing more cost effective Internet leads by utilizing a variety of online channels.These include no-cost online classifieds, eBay Motors, leading pay classifieds and dealer websites.

Responsibilities:

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSISin Business Intelligence Development Studio (BIDS).

Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.

Worked on formatting SSRSreports using the Global variables and expressions.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.

Day to day activities including monitoring the jobs and resolving the issues occurred in the job.

Created ssis package to migrate data between databases.

Used robo copy to transfer files between databases.

Write TSQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.

Creating joins and sub-queries for complex queries involving multiple tables.

Optimized query performance by creating indexes.

Used various SSIS/ETL tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Used Red gate for SQL compare.

Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Used query execution plan to optimize the storeprocedures to reduce the cost.

Configured and Monitored transactional replication.

Supporting the ETL Inbound for the Legacy MDM solution built.

Daily routine dba tasks like handling user's permissions and space issues on Production and Semi-Production servers and handling maintenance jobs.

Environment: Windows 2007 enterprise, SQL Server 2008/2005, SQL Integration Services (SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, Source safe,RedGate.

Caliber Home Loans,Dallas, TX Apr’13 – Sep’13

SQL Developer

Caliber Home Loans, Inc. is a full-service national mortgage lender and agency direct seller/servicer. Caliber originates loans through various channels and transaction types, including a network of retail branches, wholesale lending, correspondent and mini-correspondent lending, and a consumer-direct centralized operation specializing in a variety of loan programs for purchase and refinance such as conforming, jumbo, and government products. Caliber also offers innovative servicing solutions for both conforming and non-conforming loans. Caliber is led by a veteran senior management team that consists of mortgage banking professionals with a history of building successful national mortgage operations. Caliber is owned by Lone Star Funds, a global private equity fund.

Responsibilities:

Write TSQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.

Creating joins and sub-queries for complex queries involving multiple tables.

Optimized query performance by creating indexes.

Using DDL and DML for writing triggers, stored procedures, and data manipulation.

Created several SSIS/ETL Packages to pull data from SQL server and Flat files into Excel sheet and to archive the data as per the business logic.

Requirement gathering and creating mapping specs.

Created Email Notifications for critical events at database application level.

Created various SSIS packages which would load raw physical data in to the tables of the databases.

Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.

Designed, implemented and maintained UNIX-based custom statistics collection package.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.

Used spreadsheets for reporting server.

Developed and tested system maintenance tasks such as Database Backup andRecovery, Database mirroring and replication.

Implemented Logshipping for Disaster Recovery.

Experienced in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI’s and visually accentuate critical business controls.

Created powerpivot file and power view reports in excel.

Developed web-based reports, scorecards, and dashboards .

Created reports with multiple views in power view.

Strong experience in Data Warehousing and ETL using SSIS.

Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Worked on formatting SSRSreports using the Global variables and expressions.

Using Team foundation server 2010.

Assign permission to user(s), role(s) and object. Administrate security for server’s logins (Windows and SQL server account).

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business IntelligenceDevelopment Studio, Visual Studio 2008/2005,Team Foundation Server(TFS),Crystal Reports,Informatica.

Hennepin County, MN Jul’12 – Apr’13

SQL Developer

Responsibilities:

In this agile project all tasks are assigned to the team members using the Share point priorityTasks. The tasks are completed as per the priority heirarchy.

Responsible for development of stored procedures, functions and database Triggers.

Imported data from Cache Monitor using SQL Server Integration Services (SSIS)packageInvolved in migrating from cache to SSMS.

Involved in creating stored procedures,Indexes in MS SQL Server environment using 2012 and writing TSQL queies.

Created, indexes,Triggers,Stored Procedures in SSIS Package.

Created Complex ETL Packages using SSIS to extract data from Cache Monitor to SSMS with execute SQL Task and Incremental Load.and even created and dropped indexes in execute sql task.

Created SSIS packages for Migrating from one Database to the other using Data Reader Source.

Used VB scripting in SSIS.

Access SQL Server using front end applications like VB.

Writing C# code in SSRS.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.

Managing and scheduling daily jobs relating to data transfers, backup and recovery.

Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.

Even used special field casting and data conversion in Data Reader Source.

Created reports based on the format specified in the design document.

Involved in creating Sub reports in MS Reporting services(SSRS).

Passed parameters to the Reports using Report parameter menus.

Used Deployment wizard for Deploying the Reports.

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business IntelligenceDevelopment Studio, Visual Studio 2008/2005,IBM AS/400.

State Of Maine,Augusta, Maine Sep’11 – Jun’12

SQL Developer

Responsibilities:

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSISin Business Intelligence Development Studio (BIDS).

Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.

Prepared the complete data mappingand Report Definitionsfor the project which involved around 33 reports.

Wrote TSQL queries and created multiple parameterized stored procedures which were used by the reports to get the data.

Worked on formatting SSRSreports using the Global variables and expressions.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.

Prepared the complete data mapping for all the migrated jobs using SSIS.

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Created DTS, SSIS packages and also converted some DTS to SSIS packages.

Prepared documentation and designed the GUI forms by using VB.Net.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Used VB scripting in reports and also in SSIS.

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business IntelligenceDevelopment Studio, Visual Studio 2008/2005, OLE DB.

Zondervan, Grand Rapids, Michigan Dec’ 10 – Aug’11

SQL Server/SSIS Developer/SSAS

Responsibilities:

Implementation of MS SQLServer 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using TSQL to evaluate result for the reports.

Responsible for installation and Configuration of SQL Server 2005 and 2008database and configuration of Report manager.

Responsible for performing TSQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQLServer 2008/2005.

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

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.

Build scalable and secure database applications in service broker using microsoft sql server 2005.

Developed, deployed, and monitored Packages using ETL tools Like SSIS .

Creating complex MDX Queries. Accessing and manipulating data within MDX.

Working on performance tuning and optimizing MDX queries to reduce the runtime and increase performance and efficiency.

Expert in creating Star schema cubes using SSAS.

Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.

Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.

Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Performed reliable messaging between SQL server instances using service broker.

Supported, monitored and tuned Informatica ETL processes.

Took part in creation of Star Schema and Snowflake dimensional schema in MS analysis

services (SSAS).

Created cubes in SSAS cubes which require complex calculations such as calculation of the premium for a particular policy.

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.

Created reports with Analysis Services Cube as the data source using SSRS.

Environment: MS SQLServer 2005/2008, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MS SQLServer 2008, Ms Access2007, Office2007, Windows Server 2003.

Diligent Solutions,Hyderabad, India May’09 – Aug’10

SQL Server Developer/DBA

Responsibilities:

Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.

Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.

Performed Database code Migration from SQL Server 2000 to 2005 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.

Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.

Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.

Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts

Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. .

Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.

Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Environment: MS SQL Server 2000, TSQL, DTS, Windows XP, 2000, MS Visio 2000, MS Projects 2000.



Contact this candidate