Summary:

• Over 7 years of IT experience in the Analysis, Design, Development, Implementation and Testing Client/Server applications using Microsoft SQL Server 2005/2008/2008R2/2012 and Business Intelligence Suite.
• Experience in creating 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 cleansed data.
• Created and implemented Cubes, and designed attribute relationships for optimal performance of Hierarchies and Fact Dimensions.
• Experience in optimize stored procedures, tuning database and optimize queries.
• Experienced in Dimensional Modeling, ER Modeling, and Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expertise in creating and managing Conceptual, Logical, Physical Data Models, Data Mapping, Data Normalization OLTP and OLAP databases and data warehouse.
• Excellent T-SQL Developer skills including Stored Procedures, Indexes, Views, User Defined Functions, Triggers, Cursors and Distributed Transactions.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact- SQL queries, CTE using SQL Servers to facilitate efficient data manipulation and data consistency.
• Experience in Creation and deployment of cubes and optimize the performance of cubes as well on SQL Server Analysis Services SSAS .
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball's dimensional modeling standards using SQL Server Analysis Services SSAS .
• Hands on experience in creating different types of Tabular, Matrix, Drill-Down, Cascaded parameterized, Chart report, Sub reports, Cross Tab Reports in multiple formats by using SSRS.
• Experienced in ongoing maintenance and change management to existing reports and optimize report performance SSRS .
• Experience in Importing/Exporting Data from various data sources like Excel and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.

Skillset: Microsoft SQL Server 2005/2008/2008-R2/2012, SQL Server Management Studio SSMS , SQL Server Business Intelligence Development Studio BIDS , SQL Server Analysis Services SSAS , SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , MySQL, MS-Access, MS-Excel, SQL, T-SQL, Visual Studio 2005/2008/2012, SQL Profiler, Crystal Reports, MS Visio, SharePoint, Power pivot, Power view .

Projects Summary:

Confidential

MS SQL BI SSIS/SSAS/SSRS Developer

Responsibilities:

• Created SSIS Packages to import and export data from Excel, Text files and transformed data from various data sources using OLE DB connection by creating various SSIS package.
• Designed and implemented ETL processes based in SQL, T-SQL, stored procedures, triggers, views, tables, user defined functions and security using SQL SERVER 2012, SQL Server Integration Service.
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Extensively worked with SSIS tool suite, designed and created mapping using various SSIS transformations like OLEDB command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Created partitions and optimize MDX/aggregations for cubes for tuning purpose in SSAS.
• Created a variety of charts like drill through, drill down, parameterized, cascaded and sub-reports, pie, line and worked on KPI's using SSRS. Developed drill through, drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance SSRS .

Environment: SQL Server 2012, SQL BI Suite 2012 SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services , Windows Server, SQL Server Report Builder, Data Warehouse.

Confidential

MS SQL Server/ BI Developer SSIS, SSAS, SSRS

Responsibilities:

• Gathered business requirements, definition and design of the data source, data flows and data quality analysis, and worked in conjunction with the data warehouse architect on the development of logical data models.
• Installed and Configured SQL server 2008 R2/2012 on Development and production server.
• Created complex Tables, Indexes, Views, Triggers, stored procedures and SQL joins for applications.
• Created and encapsulated User Defined Functions UDF and used business logic making the system more modular, secured and extensible.
• Optimized Stored Procedures and long running queries by using indexing strategies and query-optimization techniques.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Database Engine Tuning Advisor and Index Tuning Wizard.
• Used SSIS to build up high performance data integration solutions including extraction, transformation and load ETL packages for data warehouse.
• Used most of controls and features in SSIS to transform data from multiple data sources like Oracle, DB2, Flat Files and MS Excel.
• Developed, monitored and deployed SSIS packages. Scheduled and executed SSIS Packages by using SQL Server Agent.
• Created complex Snow Flake Schema and SSAS cubes with multiple fact measure groups and multi-dimension hierarchies based on the OLAP reporting needs.
• Designed SSAS solutions by using multiple dimensions, measures groups and Key Performance Indicators KPIs to analyze performance of strategic business units.
• Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with multi-Dimension Expression MDX , Data Mining Models and developing reports by using MDX and SQL in SSAS 2008 R2/2012.
• Worked on SSRS to generate dynamic reports according to end user requirement and deployed on web-portal.
• Created ad-hoc reports, dashboard reports, tabular reports, matrix reports, and parameterized reports according to business requirement by using SQL Server Reporting Services SSRS .

Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services SSIS 2008 R2/2012, SQL Server Analysis Services SSAS 2008 R2/2012, SQL Server Reporting Services SSRS 2008 R2/2012, SQL Profiler, Database Engine Tuning Advisor, Query Analyzer, Index Tuning wizard, SQL Server Agent, MDX, OLAP.

Confidential

MS SQL BI /SSAS/SSIS/SSRS Developer

Responsibilities:

• Designed and implemented consolidation of client hierarchies in an existing data mart and corresponding dimensions and hierarchies in SSAS cubes for Thomson Reuters Deals BI product, allowing for reduction in development times for new custom cubes for investment banking clients from 2 months to 2 weeks
• Implemented various enhancements to the existing Deals BI application, including new corporate hierarchies, changes in fiscal years for existing clients, as well as new custom drill-throughs to detailed investment banking fee data.
• Redesigned poorly performing bridge table architecture in existing SQL Server SSAS application into a star schema with 30 performance improvement in cube processing times.
• Created references objects for a Master Data Services hub, created artifacts to drive ownership planning, and designed a repository for the producing and consuming of these objects
• Designed and created different ETL packages using SSIS and transfer data from heterogeneous database different files format Oracle, SQL Server, and Flat File to SQL Server.
• Worked on several transformations in Data Flow including Derived column, Slowly Changing Dimension Using SSIS Controls , Lookup, Fuzzy Lookup, Data Conversion, Conditional split and many more.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in table and index partitioning for performance and Manageability.
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration.
• Analyzed the requirements and selected the appropriate fact tables/created fact tables.
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions.
• Actively involved in Normalization De-normalization of database.
• Materialized views, dimensions and stored outlines for optimal performance.
• Optimize the performance of cubes by optimize MDX, aggregations and different ways.
• Experience in SQL Server Analysis Services SSAS for data mining to identify rules and patterns in the data.
• Created calculated measures and dimension members using multi-dimensional expression MDX , mathematical formulas, and user-defined functions by using SSAS.
• Defined the MDX calculations and sub cube calculations.
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.

Environment: SQL Server 2008/R2, SQL BI Suite 2008/R2 SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services , Data Warehouse, MS PowerPoint, MS Project, MS Access Windows Server, Power pivot, Power view.

Confidential

MS SQL BI /SSAS/SSIS/SSRS Developer

Responsibilities:

• Created Packages for Transaction processing using containers as For-Each Loop, Sequence controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.
• Used Breakpoints Event Handlers to debug packages and capture errors.
• Developed SSIS packages for developing a fully-fledged data warehouse solution.
• Gained performance improvement by direct execution of packages on server.
• Defined Dimension Models based on existing fact and dimension tables in Relational Data Warehouse.
• Created dimensions by defining Parent-Child relationships, using different dimension types.
• Created Perspectives defined security, roles for different group of users.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball's dimensional modeling standards using SQL Server Analysis Services SSAS
• Experience in creating Drill Through, Drill Down, Tabular Pivot reports.
• Created Reports directly from Integration Services packages Analysis Services.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Created Filtered reports using report parameters, stored procedures cascading parameters.

Environment: SQL Server 2008/R2, SQL BI Suite 2008/R2 SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services , Excel 2007.

Confidential

MS SQL BI /SSAS/SSIS/SSRS Developer

Responsibilities:

• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance SSRS .
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
• Created and implemented Cubes, and designed attribute relationships for optimal performance of Hierarchies and Fact Dimensions.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze 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.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Environment: SQL Server 2005, SQL BI Suite 2005 SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services , Crystal reports, Windows Server, SQL Server Report Builder.

Confidential

MS SQL BI SSIS/SSAS/SSRS Developer

Responsibilities:

• Gathered data from various external sources Oracle, Excel, Flat files into a data warehousing system Enterprise Cube with the help of ETL process.
• Written T-SQL queries and stored procedures to perform Data Cleansing to eliminate dirty read.
• Implemented FTP task to download and uploads data files from an FTP server to local server.
• Developed and Implemented the SQL Server Integration Services SSIS packages to populate the data into Enterprise Data Warehouse from various sources like Flat File Source, Excel Source into OLEDB destination SQL Server .
• Ensured data changes in the source system by using Slowly Changing Dimension Transformation.
• Configured Send Mail Task to send the mails upon successful deployment of package using STMP.
• Deployed and scheduled packages using SQL Server Agent Job in Management Studio.

Environment: Windows XP, MS SQL Server 2005, SQL Server Integration Services, SQL Server Reporting Services, Excel 2007.