Professional Summary

• 6 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008/2005/2000 in Development, Test and Production Environments with insurance, sales and Banking domains.
• Experience with T-SQL, Integration Services SSIS , Reporting Services SSRS and working knowledge of Analysis Services SSAS .
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2005 to 2008/2012.
• Experience in creating and developing different types of reports using SQL Server Reporting Services and Crystal reports and migration of Data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server by using BCP and SSIS utility.
• Designed reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, schedule reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, mailing label.
• Migration of SSRS reports from SQL 2005 to SQL 2008.
• Extensive experience with data modeling techniques, logical and physical database design.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in working/migration of data with SSIS SQL Server Integration Services as an ETL tool for Data integration servicesand business applications .Creating SSIS packages using various Data transformations like conditional splitting, Derived column, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping.
• Used MDX to interact with the back end OLAP Services
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server SSAS .
• Expert in ETL designing.
• Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Experience in Creation and deployment of cubes on SSAS.
• Good understanding in Oracle 9i/10g Database.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.

Experience in Tuning SQL queries and T-SQL queries, MDX improving the performance of the queries.

Worked Extensively on ETL process using SSIS package.

Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.

Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.

• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi site development

Technical Skills

Professional Experience

Client: confidential

Title: SQL BI Developer T-Sql/SSRS/SSIS

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.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse
• 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
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012
• 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.
• Worked on several complex drilldown, 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 , SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Client: confidential

Title: SQL BI Developer

Responsibilities:

• Involved in performing server installation and configuration of SQL Server 2008/R2.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Performed maintenance of Stored Procedures to improve Performance of different front end applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008/R2.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created reports with different features like drill through capabilities, jump to another report, use of pie-charts and bar-charts, usage of tablix new feature of SSRS 2008 , use of filtering conditions.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Developed the SQL Server Integration Services SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Modified SSIS ETL package for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Designed and developed OLAP using MS SQL Server Analysis Services.
• Created MDX queries, processed facts, dimensions and populated data through Analysis Services SSAS for the front end users.
• Designed new Aggregations by creating Hierarchies and then pre calculating the Aggregations using Aggregation Wizard in SSAS.
• Created calculated measures in a cube by using MDX scripting and worked on slowly changing dimensions.
• Experienced in performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes in SSAS.

Environment: MS SQL Server 2008/R2/2005, SQL Server Management Studio, SQL Server Business Intelligence Development Studio BIDS , SQL Server Query Analyzer, SSAS, SSIS, SSRS, OLAP, OLTP, MDX, ETL, T-SQL, Erwin, MS Visual Source Safe.

confidential

SQL SERVER BI Developer

Confidential is a Nevada financial services company, the largest bank holding company in the Nevada State, by assets, and by capitalization. Nevada State Bank serves many clients in that State. The project is to create SSIS packages, for migrating data to Data Warehouse and generating reports by extracting data from data warehouse for different Investors during a month end close.

Responsibilities:

• Highly responsible for development of SSAS Project.
• Developed cubes using SQL Analysis Services 2008 SSAS according to the requirements of business users.
• Created SSAS Cube based on the requirements using SSAS 2008 R2.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• 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 .
• 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.
• Schedule SSIS package for weekly cube refresh.
• Integrate SharePoint environment for SSAS report deployment.
• 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

confidential

MS SQL Server BI/SSRS/SSAS Developer

Confidential is a healthcare information technology company established to develop a Regional Health Information Organization. LIPIX's primary mission is to fundamentally improve the quality and efficiency of health care for the betterment of patients, providers and the community.

Responsibilities:

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME's and End Users for requirement gathering, process improvement, problem identification, project analysis review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS .
• Created several Dashboards and Scorecards with Key Performance Indicators KPI in SQL Server Analysis Services SSAS -2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS ETL packages for loading data from Oracle and Flat files 3GB to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS scheduled the same SSIS packages by creating the job tasks.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• 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 writing MDX queries for various calculated members.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export DTS , SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, ASP.NET2.0, C .NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

confidential

SQL Server Developer/SQL Server DBA

Voice Gate Technologies India Private Limited is a fast growing IT and telecom solutions provider, which helps companies achieve their strategic goals and improve operational excellence. Voice Gate has strong expertise in building powerful business process solutions using IVR technology. These solutions are highly scalable, efficient and cost-effective in addition offering 100 percent mobility by integrating with mobile apps.

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 using SSRS, T-SQL, scripts, stored procedures and views .
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Worked on DTS/SSIS for transferring data from Heterogeneous Database Access database and xml format data to SQL Server.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server 2008/2005 / 2000 2003 ,64 bit edition of SQL server 2000 , DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, ERWIN.