SUMMARY

• Over 7 Years of experience as SQL Developer, BI Developer (SSIS, SSAS, SSRS), MDX services.
• Experience in Analysis, Design, Architecture and Development of Software Applications, Business Intelligence projects in teh Microsoft Server Suite of Products.
• Experience in installing, configuring and monitoring MS Server 2014/2012/2008/2005 installations.
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Extensive knowledge of Normalization and Database Design Concepts.
• Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T - SQL.
• Hands-on experience in Upgrade/Migration of MS SQL Server using a suitable approach.
• Expertise on Business Intelligence Tools (SSAS, SSIS AND SSRS).
• Extensive experience in designing, developing and deploying SSIS 2008 packages.
• Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Extensive experience in migrating DTS packages to Integration Services Packages.
• Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
• Experience in data modelling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using SSAS 2008/2012/2014.
• Experience in developing on demand and scheduled reports for Business Analysis or Management Decision using SQL Server Reporting Services (SSRS).
• Experience in Scheduling and teh Deployment of teh reports and uploading files to a Report Server Catalog from teh Report Manger using SSRS 2008/2012/2014.
• Experience in defining queries for generating Drill down and Drill through reports in SSRS 2008/2012/2014.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experience in developing technical documentation for ETL's and BI reporting based on functional documents and support transition documentation.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
• Experience in VB.NET, C#, ASP.NET, ADO.NET and Web Services
• Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Expert in creating Parameterized Reports.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Strong inclination for finishing job before teh project deadline.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008/2012/2014 , MySQL, Oracle 9i/10g

Operating System: Windows, Linux, HP-UNIX

Programming Languages: C, C++, VB.NET, ASP.NET, C#, SQL, TSQL, PL/SQL, MDX

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL, Agents, SQL Alerts, SQL Jobs, Replication tools, Data visualization ( Composite tool).

Programming Languages: C, C++, Java

Web Technologies: HTML, DHTML, CSS, Java Script, AJAX, VB Script, XML, SOAP, IIS

Database Access Technology: ADO.NET, DTS

Markup Languages: XML, HTML

Design and Development: Visual Studio 2008/2005/2003 , Visual Studio 6.0

Reports: SSRS, Crystal Reports, Cognos Reporting tool, Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, MN

MS BI/ SQL Server Developer

Responsibilities:

• Created stored procedures, user-defined Functions, sub-queries, views and cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Experience in creating joins for complex queries involving multiple tables.
• Implemented teh Error handling in teh Stored Procedures and Objects and also modified already existing stored procedures, views.
• Involved in query optimization and tuning stored procedures for better performance.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Experience in creating Adhoc reports using Report Builder 1.0 and Report Builder 2.0.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2008.
• Built teh SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and tan created reports using dis data using SSRS.
• Generated teh weekly, monthly, and quarterly reports by using SSRS.
• Created data loads and upgrade scripts for data migrations and validations.
• Experience in analyzing and improving existing dashboards, reports and reporting systems.
• Involved SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Involved in building and improving data model (physical/logical) to serve different fund types involved in teh module.
• Generated several drill down and drill through reports usingSSRS.
• Involved inperformance tuningof queries for query efficiency
• Managed and coordinated releases throughout different environments.
• Involved in debugging and testing support of Module in all environments and coordinating with QA on defects and performance issues.
• Involved in usingSSASdatasources inSSRSreports.
• Used VB.net, C# to integrate .net framework with SSRS reports.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SSIS/SSRS/SSAS 2008, Visual Studio 2008, VB.net,, C#, PL-SQL, Share Point, Oracle 10g, MS Access, Windows Server 2003.

Confidential, KY

MS BI/ SQL Server Developer

Responsibilities:

• Performed Server installation and configuration using SQL Server 2008.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views, Rules, Defaults and complex SQL statements.
• Developed teh PL/SQL programs and involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• Scheduled Database and Transactional log backups using teh Database Maintenance Plan Wizard in SSIS.
• Involved in SQL Server Mirroring and Database optimization.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created teh automated processes for teh activities such as database backup processes and SSAS, SSRS Packages run sequentially using Server Agent job.
• Created and monitored database maintenance plans for checking database integrity in SSIS.
• Developed DTS packages to extract, transform and load into teh Campaign database from OLTP database using of SQL Server 2005/2008 Integration Services (SSIS).
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to SQL Server using DTS and also used BCP and Bulk Insert and even teh other way.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SSAS 2008.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Enhanced teh functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SSAS 2008.
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Generated Reports using Global Variables, Expressions and Functions for teh reports using SSRS 2008.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used VB.net, C# for scripting to use in SSIS projects.

Environment: MS SQL Server 2005/2008, SSIS/SSRS/SSAS 2008, Visual Studio 2008, PL-SQL, VB.net, C#, Share Point, Oracle 10g, MS Access, Windows Server 2003.

Confidential, MI

MS BI/ SQL Server Developer

Responsibilities:

• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing teh packages in both teh environments (Development and Production).
• Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Fuzzy Lookup, Fuzzy Grouping in SSIS Dataflow.
• Involved in ETL architecture enhancements to increase teh performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured teh loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on teh financial data regarding competitive rates and financial market.
• Developed various types of complex reports like Drill Down, Drill through, linked reports, cascading parameter reports for business loan, first time buyer or refinancing home mortgage.
• Involved in scheduling, creating snapshots and subscriptions for teh reports using SSRS 2008.
• Involved in designing Parameterized Reports and Matrix Reports for generating Ad-Hoc reports as per teh client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML, MDX and User Defined Functions to implement teh business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of teh database.
• Used VB.net, C# for scripting to use in SSIS projects.

Environment: MS SQL Server 2005/2008, SSIS/SSRS/SSAS 2008, Visual Studio 2008, PL-SQL, VB.net, C#, Share Point, Oracle 10g, MS Access, Windows Server 2003.

Confidential

SQL BI Developer

Responsibilities:

• Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Converted Logical Database Diagram into Physical Schema using teh balanced Normalization in 2nd and 3rd Normal Form for highest performance.
• Normalized and De-normalized teh tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Installed and configured SQL Server 2008 in Test environment with latest service packs and migrated few databases.
• Tuned database by creating proper Indexes on different tables that improve teh performance of T-SQL queries on teh database.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Used SQL Server Profiler to trace teh slow running queries and optimized query execution with teh use of Index Tuning Wizard and Rebuilt indexes if necessary.
• Created and managed users, roles and groups and handled database security.
• Implemented computational sensitive queries Stored Procedures.
• Rebuilt indexes on various tables.
• Involved in migration from SQL Server 2000 to SQL Server 2005/2008.
• Involved in writing DDL / DML Triggers as per company policy.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Managed Database files, transaction log and estimated space requirements. Performance tuning, and optimization of procedures and queries.
• Monitored SQL Server logs to ensure teh backup operations, batch commands, or other scripts and processes has completed successfully.

Environment: MS Server 2005, T-SQL, DTS, Microsoft Visual Source Safe, Visual Basic 6.0 and Windows NT.