Praveen

(SQL/BI Developer)

Email:acu0ny@r.postjobfree.com

Mobile number: 469-***-****

Summary:

Having 2+ years of SQL Server Development experience in SQL Server 2008/2008r2/2012 with an emphasis on design, development, enhancement, automation, tuning and optimizing databases for high Availability, Performance and Security.

Experience in using Business Intelligence tools (SSRS,SSIS) in MS SQL Server 2008

Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles and Data Integrity.

Extensive knowledge of Normalization and Relational Database Management Systems.

Experience in Performance Tuning and Query Optimization.

Expertise in defining Database Backup, Recovery and Disaster Recovery Procedures.

Knowledge on installation of Sql server and configure it.

Experience on working with Team Foundation Server (TFS) environment.

Experience with SQL Server Security and SQL Server Auditing.

Created different types of encryptions and decryptions in SQL Server as per the client requirement to secure the data and also use it in flexible ways by a group of users.

Experience in migration of Data from Excel, Flat file, to MS SQL Server by using SQL Server Integration Services (SSIS), BCP and DTS utility.

Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.

Experience in migrating DTS packages and reports from SQL server 2000 to SQL server 2005.

Created stored procedures for generating reports using SQL Server Reporting Services (SSRS).

Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.

Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Experience on handling charts, links, Power Pivot on excel.

Technical Skills:

Programming Languages : SQL, TSQL, C.

Database : SQL Server,

Operating Systems : Window 2000/XP/7

BI/Data Model Tools : Microsoft BI tools (SSIS, SSRS)

Educational Qualifications:

Master of Science in Computer and Information Science

Southern Arkansas University

GPA- 3.50/4.

Graduated Date: 05/06/2016.

Professional Experience:

Hawk generation technologies,India Mar 2013 to Nov 2014

SQL/SSIS/SSRS Developer

Description :

Hawk generation provides with a wide range of capital market products and services to corporate, government and institutional clients who choose the company for our knowledge, innovation and experience in the following key areas of finance Investment and Corporate Banking, Capital Markets, Interest Rate, Currency and Derivative Products, Commodities.

Responsibilities

Created various tables, views, stored procedures, Functions and Indexes.

Created Jobs, Alerts and scheduled DTS to generated Reports

Created SSIS package to load data to SQL Server, from Flat files or excel spreadsheet

Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS /SSIS package

Created SSIS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat Files.

Created reports and performed all Administrative activities. Also Installed and maintained SQL Server Reporting Services (SSRS) 2008

Extensively used SQL Server Reporting Services to generate various types of reports.

Developed Stepped and Block reports usingSSRS.

Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.

Performed data analysis to generate various trend reports.

Generated Ad-hoc, matrix and tabular reports using SQL Server reporting services based on customer needs.

Environment

Windows 2007 Advanced Server, TSQL, SSIS, SSRS, MS SQL Server 2008R2/2012, Visual Studio (BI) Tool.

Anblicks,Dallas,Texas. Jan 2016 – May 2016

SSIS/SSRS Developer

Description :

The Project provides business intelligence reporting services to Performance Chemicals Ltd to analysis the sales performance across various dimensions like Region, Product, Period and Customer wise Data from online transaction processing (OLTP) applications is selectively extracted, related, transformed and loaded into the data warehouse using SSIS ETL tool. Our goal is to create reports using SSRS on the basis of every transaction from all locations at a central zone on a daily basis

Responsibilities

Participated in gathering User Requirements and System Specifications.

Involved in installation and configuration of SQL Server 2008R2 and SQL Server 2008 with latest Service Packs.

Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.

Worked on QNXT 4.8 with SSIS and SSRS implementation rules.

Designed and created views for security purposes, implemented rules, defaults, and user defined data types.

Tested queries to optimize the procedures and triggers to be used in production.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.

Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Created Jobs, Alerts and scheduled DTS to generated Reports

Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting

Loading data from various data sources using MS Data Transformation Services.

Backing up, restoring system & other databases as per requirements, and also scheduled those backups.

Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.

Environment:

Windows 2003/2007 Advanced Server,MS SQLServer2008/2008R2, SQLServer Management Studio (SSMS),T-SQL, SQLServer Integration Services (SSIS),Microsoft Excel.

Contact this candidate