PROFESSIONAL SUMMARY:

• 9+ years of experience in Microsoft business intelligence Development under SQL Server environment, with thorough knowledge of SQL Server 2008/2008R2/2012 databases. Experienced in Insurance, Financial, Health Care and banking services.

• Experienced in upgrading SQL Server 20 /2012 and data migration among versions.
• Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS), SSAS (analysis services).
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Expert in Data Analysis as well as Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experienced in the complete life cycle of DTS/SQL Server Integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL jobs across different servers.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Generating complex Transact SQL (T - SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
• Experience in developing reports using Report Builder and used Metadata to define Fact & Dimension tables.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated drill down reports, drill through reports, parameterized reports, Cascaded reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
• Working experience of designing Ad-hoc reports for higher managers using report model, providing them flexibility to create reports using drag and drop functionality.
• Developed Cubes using SQL server Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions with the cube wizard and generated named calculations and named queries.
• Microsoft Certified Technology Specialist in SQL Server 2005 and SQL Server 2008.
• Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2008/2005/2000 ), MS Access, MS Excel, Crystal Reports, Business Objects4.0

Database: MS SQL Server 2012/2008/2005/2000, MS Access, Oracle 9i/8i

Programming Languages: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Windows Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr. SQL Developer (SSIS/SSRS) /Data Analyst

Responsibilities:

• Work closely with business users to congregate and comprehend requirements.

• Preparation of documentation for all the requirements and enhancements to reports.
• Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Developed and deploySIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, Oracle and SQL server using SSIS.
• Handled Enterprise scheduling using IBM tool Tivoli
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Created cross validation rules to ensure mapping accuracy.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designing, Creating & maintenance of Reports in SSRS.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and Confidential .
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2012 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2008R2/2012,SSIS,SSRS,SSAS, DTS, VSS, VBScript, XHTML, XML,MS Access, Windows 2005/2008 Server, Oracle 11g, IIS5.0, 6.0, 7.0.

Confidential, Washington, DC

SQL BI Developer (T-Sql/SSRS/SSIS)/DATA Analyst

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.

• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Worked extensively on SSIS packages to implement the data load strategy
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012
• Created and Maintained various database in MS Access to track activities and progress.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Created and Maintained various database in MS Access to track activities and progress.
• Worked on several complex drilldowns, parameterized reports and on reports that call sub reports using SSRS.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution
• Involved in testing, bug fixing and documenting the work for the project at each and every phase

Environment: MS SQL Server 2012/2008/R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), T-SQL,MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential, Salem, NH

MS SQL Server Developer/BI Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.

• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, CTE, user profiles, relational database models and data integrity, SQL joins and query writing.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2005/2008/2012.
• Expert in Created/Updated database objects like tables, views, stored procedures, function, packages,
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services (SSRS).
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using MS SQL Server Integration Services (SSIS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Leading offshore team in India and client facing skills.

Environment: MS SQL Server 2008R2, T-SQL,Teradata, SQL SSIS, SSRS, SSAS, Windows server 2003 Visual Source Safe, SQL Profiler, Visual Studio 2008, XML, Informatica, Oracle 10g, VB.Net

Confidential, Louis, MO

SQL SERVER BI Developer

Responsibilities:

• Highly responsible for development of SSAS Project.

• Developed cubes using SQL Analysis Services 2008 (SSAS) according to the requirements of business users.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designed custom MDX queries as desired by the end users to make the reports simpler.
• Generated reports from the cubes in MS Excel 2007 & SQL Reporting Services 2008(SSRS).
• Created SSIS Packages using Lookup, Merge, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task and expressions etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file and MS Access, Oracle Servers to different data Marts.
• Involved in pulling out reports using Crystal Reports.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for Process CUBE Partitions and Dimensions.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
• Schedule SSIS package for weekly cube refresh.
• Provided Production Support for the cubes moved to production.
• Setup cube security for multiple user, created language translation for
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: MS SQL Server-2008R2 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, SharePoint 2010, Office-2007, MS Excel, MS-Access

Confidential, Glen Allen, VA

Sr. SQL Server BI/ETL Developer

Responsibilities:

• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.

• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Experienced in slowly changing dimension in SSIS packages.
• Performed i Confidential emental data load packages in SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Identified and Defined Fact relationships in SSAS.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, Camp Hill, PA

MS SQL Server Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and form Confidential ed the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables

Environment: MS SQL Server 2000, T-SQL, DTS, Microsoft Visual Source Safe 6.0, Visual Basic 6.0,Crystal Reports 8.0 and windows 2000.