PROFESSIONAL SUMMARY:

• Highly motivated Business Intelligence Professional using SQL Server 2005/2008 and Microsoft Technologies.
• Around 7 Years of experience with Data Warehousing in Engineering, Financial, Sales, Human Resources, HealthCare with Business Intelligence.
• Strong conceptual, analytical, and design skills and excellent communication skills with leadership qualities.
• Applications:ETL
• Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks).
• Successfully extracted Data from Different Databases like Oracle, DB2, and Sybase.
• Expert in Migrating DTS Packages to SSIS.
• Created SSIS Packages to import and export data from Excel Spreadsheets, ACESS, Text files and CSV filesReporting:
• Well Experienced in Generating parameterized reports in SSRS.
• Extensive experience in basic and advanced report creation with thorough knowledge of report serving architecture. Experience in creating various types of reports(table, chart, list and matrix report)
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP for various multi - tiered complex applications involving design,development, implementation and Support
• Hands on experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, Stored Procedures user profiles, relational database models, cursors, data dictionaries, and data integrity
• Extensively worked on Index Tuning using DTA/ITW, DMFs,DMVs in creating Clustered and Non Clustered indexes on tables.
• Proficient in using Profilers for both performance and auditing purposes.
• Expertise in Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in Database Mirroring, Optimizing and Tuning of SQL Queries.

TECHNICAL SKILLS

Relational Databases: SQL Server (2000, 2005, 2008,2012)

Querying/Reporting: T-SQL,PL/SQL

Reporting Tools: SQL Server Reporting Services (SSRS 2005/2008/2012)

ModellingTools: SQL Server Analysis Server 2005/2008/2012(SSAS)

ETLTools: Microsoft Integration Services (SSIS),Informatica,Impromptu

Server Scripting: ASP, PHP, JSP

DataMiningModels: Classification, Association Rule Mining, Clustering

ProgrammingLanguages: C, C++,JAVA, C#.net,ASP.Net

Documentation Tools: MS Office (Including MS VISIO)

Web Portal Technologies: HTML, Photoshop, SharePoint, Visual Studio, Ms Front Page

Operating Systems: Windows (98, 2000, XP), Windows Server 2000/2003, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in supporting more than 80 Users for various Reporting and Analytics requirements across multiple Business Units and departments.
• Created Databases, Schemas, Tables, Cluster/Non-Cluster Indexes and various other database objects Wrote efficient Stored Procedures for the optimal performance of the system
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Involved in writing multiple reports incorporating business logic and user requirement.
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Developed Complex SSRS Reports involving Sub Reports using new SSRS 2008 features like (Tablix Reports, Charts and Graphs).
• Created large enterprise reports for various Business functionalities assigning report parameters.
• Good Hand on Resolving complex issues and Error Handling in SSIS for handling Delta load changes.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc and vice versa.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Developing OLAP cubes using SSAS 2008 and calculates the metrics that were revealed in the functional analysis.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Handling Initial and Delta loads and processing Cubes (Star Schema) across all environments.
• Created Dash Boards and Score Cards and integrated them with MOSS. Created several KPIs in performance point server
• Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes and user profiles.
• Extensive query tuning using Execution Plans DMF’s, DMVs DTA and various Indexing features and utilities
• Involved in Installation, configuration and setting of Database servers for various test and development environments including SSRS Installation configuration and administration
• Involved in Security administration, granting permissions, roles and maintain various AD Permissions at database and report levels.
• Adhering to Change control methods and mechanisms for code promotions and migrations of various objects.
• Interacting with end users and customers and act as functional analyst /development member with various cross functional teams
• Well versed in doing remote support for various levels of customers across different geographical locations.

Environment: SQL Server 2005/2008, ORACLE, Windows Server 2000/2003, ASP.NET, C#, VB.NET, ASP.NET, Visual Basic, ASP, MTS, EXCEL, Visio, ERWIN, WORD.

Confidential, New Jersey

SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Extensive work experience as a SQL Server Developer and in depth proficient experience in OLTP, Operational Data Source (ODS), and Dimension Modeling, Data warehouse, OLAP and Database technologies.
• In-depth understanding of all stages of software development life cycle (SDLC).
• The project involved building of business intelligence tools for an enterprise wide Data Warehouse. Informatica and SSIS were used for Extraction, Transformation and Loading and Report studio for reporting.
• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS.
• Expertise includes Data Analysis, Data Modeling, Data Cleansing, Transformation, Integration, Data import, Data export.
• Proven ability in utilizing ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and ETL package design
• Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Designed, deployed and maintained various SSRS Reports in SQL Server 2005 and converted Reports in JAVA to SSRS
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Data transfers between various servers using BCP and SSIS.
• Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Worked on SSAS, developed Cubes, deployed Cubes on the server, pulled data from various data sources and thus developed Cubes.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Designing DTS packages for the data transfer from the customer feedback to databases for various purposes.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Experience in supporting multiple Production database servers including backup and recovery, Performance Tuning (DB Tuning).

Environment: SQL Server 2005/2008, MS Access, Query/Report Studio, Windows Server 2000/2003, BIDS.

Confidential, Pittsburgh, PA

MS SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Performing DTS for data transfer from MS Excel and text file to SQL Server 2005.
• Good knowledge on Power Campus.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, MDX, MOLAP, ROLAP (RDBMS), Data Cleansing, Data Scrubbing and Data Migration with good knowledge in RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Identified the database tables and data marts for defining the queries for the reports.
• Written DTS Packages to get the data from various heterogeneous databases such as Oracle, Teradata and Sybase to SQL Server 2005.
• Using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes Using MDX.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005 Analysis Services(SSAS).
• Using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes Using MDX.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Reporting with SQL Server: Experience in developing User reports and management reports using Sql Server Reporting Services SSRS.
• Created multiple reports in Drill mode using tables, financial tables, crosses tabs and charts using Reporting Service (SSRS).
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2005.
• Designed and implemented Parameterizedand Cascading Parameterized reports using SSRS.
• Integrated SQL Server 2005 reporting services (SSRS) with Microsoft Office Share point Server to automatically deliver reports to the Share Point portal.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Created Logical and physical data modeling for development database using Erwin Tool.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created different SSIS Packages, which migrates the data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different SSAS Cubes.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Understanding the OLAP processing for changing and maintaining the Data Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• SQL Integration Services (SSIS): Highly capable in developing and monitoring DTS and SSIS packages for use in regularly scheduled jobs to extract modify or transform data for a variety of purposes.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Designer
• Analysis Services (SSAS) -- Creating data sources and data source views (DSVs), named calculations and named queries. Creating cubes, dimensions, measures, measure groups, key performance indicators (KPIs), perspectives, measure group partitions, partition aggregations, data mining models. Deploying and processing SSAS objects.
• Implemented MS Analysis Services (SSAS) setup, DB tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Created DTS packages to transfer objects from development server to production.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)

Environment: MS SQL Server 2005, Windows 2003/2008, Windows NT 4.0, Visual Basic, ASP, VBScript, JavaScript, Excel, MS Access, Visio, PowerPoint.

Confidential, MD

SQL Server Developer

Responsibilities:

• Create and maintain the databases using SQL Server.
• Installing and Configuring SQL Server on the server and client machines provide connections and manage databases.
• Experience in MOLAP (Multi dimensional Cube) and ROLAP (RDBMS) to develop customized reports in MS SQL Server database.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Involved in performance tuning (DB Tuning) and monitoring of T-SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005.
• DB Tuning And optimizing SQL Server by using performance monitor.
• Create packages, procedures, functions and triggers. Handle database performance and DB tuning.
• Created SSIS process design architecting the flow of data from various sources to target
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Data transfers between various servers using DTS.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.

Environment: SQL Server 2005, VBScript, ASP, .Net, Excel, MS Access, Visual Basic 6.0, and Windows 2000/NT 4.0

Confidential

SQL Server Developer

Responsibilities:

• Data, mostly scientific, being highly confidential even within the organization, required high levels of security being applied throughout the processing in the SQL Server.
• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Used DTS, T-SQL, scripts, stored procedures and views to run routine reports.
• Maintained a good client relationship by communicating daily status and weekly status of the project.
• Managed requests that came from the client as well as the development teams.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, and Indexes.
• Created and automated regular jobs.
• Managed and monitored system utilization.
• Managed backup and disaster recovery of the team.
• Managed the security of the servers (Logins and users).
• Designed stored procedures and triggers for automating tasks.
• Worked on complex data loading (implemented the batch data cleansing and data loading).

Environment: MS SQL Server 2005, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data.