SUMMARY

• About 6 years of experience in IT, as MS SQL Server Database BI Developer in Windows environment, current experience with SQL 2012/2008 r 2/2008/2005.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SQL Server SSIS 2008.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Experience in T-SQL (DDL and DML).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in creating the cubes and dimensions in SSAS.
• Extensive Experience in creating different types of reports like Drill down, Drill through, Parameterized etc.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created share dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis Server (SSAS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Good experience on Qlikview Business Intelligence reporting tool for developing dynamic reports.
• Hands on experience in developing QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.

TECHNICAL SKILLS

Database Application Software: SQL Server 7.0/ 2005/20, Oracle 9i/10g/11g,MS Access.

Languages: T-SQL, MDX, C, C++, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA, MS SharePoint

DB Utilities: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Reporting Server, DTS Import/Export, MS SQL Server Integration Services, Team Foundation Server.

Reporting Tools: MS Access, Excel, MS SQL Server Reporting Services 2005/2008/2012, Crystal reports, IBM Cognos, Business Objects.

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) Import Export Data, Bulk Copy Program (BCP).

Methodologies: Business Analysis, Object-Oriented (Use Case) Analysis, Database Design and Normalization, Data Modeling.

Operating Systems: Windows Vista/XP/NT/2000/7/8,UNIX

PROFESSIONAL EXPERIENCE

Confidential, Saint Paul, MN

SQL Server/MS BI developer

Responsibilities:

• Implemented SSIS packages for the exchange of data between different data sources.
• Successfully migrated data from multiple environments into SQL Server 2012/2014 using SSIS.
• Expertise in solving any issues related SharePoint Environment and SQL server.
• Extensively worked Shared Services Function such as Managed Properties, Content Sources, and Crawling.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data and extracting data from multiple data sources perform multiple complex transformations and land data into SQL Server Tables.
• Responsible for creating database objects like table, views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Wrote complex stored procedures for report development.
• Generated reports using SQL Server Reporting Services 2012 (SSRS).
• Developing complex SQL queries, Stored Procedures and packages using T-SQL.
• Creating and maintaining database objects like Tables, Indexes, Stored Procedures, and Views.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports.
• Developed Cross-Tab and Sub reports in SSRS 2012/2014.
• Developed Matrix, Tabular and parametric reports in SSRS 2012/2014.
• Created Ad-Hoc reports using Report Builder.
• Communicated with business and end users to collect the requirements.
• Documentation for all kinds of reports and SSIS packages.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Environment: SQL Server Integration Services 2012/2014 (SSIS), SSRS 2012/2014, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, T-SQL, SQL Server 2012/2014, Microsoft Office, Team Foundation Server, Windows 7.

Confidential, Detroit, MI

SQL Server/MS BI Developer

Responsibilities:

• Created and modified stored procedures, functions, views and indexes to provide best performance.
• Used XML with in Stored Procedures in different complexes queries in SQL Server 2005 environment.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
• SQL Development & Troubleshooting included indexes, stored procedures, triggers and table structures for application behavior manipulation.
• ETL implementation using SQL Server 2012 Integration Services (SSIS).
• Analyzing the source data coming from different sources and working with business users and developers to develop the Model.
• Developed all the required stored procedures, user-defined functions, triggers using T-SQL.
• Involved in Dimensional modeling to Design and develop STAR Schema, Using ER-win to design Fact and Dimension Tables.
• Created SSIS Packages to move data from flat files into SQL server database using SSIS for Each loop task to move all files into SQL Server Database
• Used “SQL Profiler T-SQL Duration” template for tracking execution time of T-SQL Statements.
• Generated different reports using MS SQL Reporting Services.
• Worked with xp cmdshell, which is used to move Flat Files and to receive the files also.
• Involved in performance tuning of the database, which includes index maintenance optimizing SQL statements and monitoring the server.
• Development support, production support, and design review in a complex environment.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL performance Monitor, SQL Profiler.
• Participated in Quality processes such as design reviews, code reviews, version control and documentation.
• Used SSRS to create customized reports and adhoc reports.
• Designed and developed the required PL/SQL stored procedures, triggers and database functions.
• Created scheduled jobs for daily process to migrate data from other servers.
• Generated the weekly, monthly, and quarterly reports by using SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary reports, Cross Tab reports using MS SQL Reporting Services 2008R2 & 2012
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan

Environment: Windows Server 2008, Windows XP, MS SQL Server 2008 & 2012, T-SQL, SSRS, SSIS, Oracle, MS SQL Reporting Services 2008 & 2012, ERWIN, Flat Files, .NET

Confidential, Phoenix AZ

SQL Server/MS BI developer

Responsibilities:

• Involved in creating new reports and add enhancements to the existing reports.
• Involved in creating dynamic SQL scripts in the stored procedures for obtaining best performance for the reports.
• Converting classic reports (coming from old system) into EDR reports (Coming from recently migrated new system.
• Created Tablix Reports, Matrix Reports, Parameterized Reports and Drill-Down Reports.
• Created SSRS reports using report parameters, Drop-Down Parameters, and Multi-Valued Parameters.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Creating and maintaining Tables, Indexes, Stored Procedures, and Views.
• Developed different kind of reports such as Sub Reports, Charts, Matrix Reports, and Linked Reports.
• Responsible for creating database objects like table, views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Built effective queries and stored procedures for high performance reporting and rendered them to HTML, PDF and EXCEL formats using reporting services.
• Involved with Query Optimization to increase the performance of the report.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS 2008 and SSISin Business Intelligence Development Studio (BIDS).
• Deploying the reports to Report Manager and then provide the report path to report users.

Environment: MS SQL Server 2008, MS Outlook, T-SQL, QC9.2, SSRS, Team Foundation Server, BIDS 2008.

Confidential

BI Developer (SSIS\SSAS\SSRS)

Responsibilities:

• Worked with the developers and provide necessary SQL Scripts using T-SQL.
• Analyzed the xml data (XMLA) and transformed to access and SQL server database.
• Involved in taking backups of SSAS database and restoring them when needed.
• Created data driven subscriptions for different users using Report Manager.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Successfully migrated data between different heterogeneous sources such as InfoPath forms, flat file, Excel, Access Database and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, InfoPath files, text files and Excel files.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Used scripting to automate the development using DOS, VB and PowerShell.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Customized tables by importing them into a LINQ to SQL document in visual studio 2008.
• Used OLAP Processing Tasks for automatic processing of OLAP Databases
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Developed Access and SQL Database and wrote queries for data migration and Reporting Services. (SSRS).

Environment: SQL Server 2008 Enterprise, WindowsEnterpriseServer2003, SSAS, SSIS, SSRS, Server 2004, InfoPath, Access, Agile, Share Point Portal Server 2003, IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio, C#, ASP.Net 3.5, VB.Net.