SUMMARY

• 8+ years of strong experience in the IT industry as a MS SQL Server 2016/2014/2012/ 2008 R2/ 2008/ 2005 Developer/BI Developer.
• Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R 2/2012/2014/2016.
• Skillful in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Trouble shooting and Database Objects authorization.
• Expert in developing and modifying multi-dimensional cubes using MS SQL Server 2012/2014 Analysis Services (SSAS).
• Experience in SQL server administrative skills including backups, disaster recovery, database maintenance, user roles, authentication and authorizations and database creation.
• Database design & administration experience on SQL Azure, MS-SQL Server 2016/2014/ 2008 R2/ 2012.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.
• Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint 2016, and deploy models into SQL Server SSAS instance.
• Strong experience in data retrieval using ADO.NET data objects such as Dataset, Data Reader, Data list, Data Adaptor.
• Strong in developing and modifying cubes using SSAS and transform into pivot table.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Expertise in using Team Foundation Server (TFS) and Visual Source Safe (VSS) as a tool for repository of codes and version control, branching and merging into production
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relational data modeling.
• Quick learner, excellent communication skills and good performer both in team and independent job environments.

TECHNICAL SKILLS

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, VBScript, C#.Net, JavaScript, ASP, HTML 4.0, DHTML, XML.

Databases: SQL Server 2016/2014/2012/2008 R2/2008/2005, Oracle 9i, DB2 MS Access, Sybase 12.5/11.5,Teradata, MS Azure

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9, Power BI, Tableau.

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP), Business Objects XI R2/R3.

Other Software: MS Office- 2007/2010, Adobe Professional.

Operating Systems: Windows / 98/2000/2003/ XP/Vista.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, SQL Server Analysis Services (SSAS), TOAD

PROFESSIONAL EXPERIENCE

Confidential, Indianpolis, IN

Sr SQL Developer

Responsibilities:

• Conducted Data Migration processes in the SQL Server environment using SQL Server Integration Services 2016.
• 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.
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy grouping etc. for creating many SSIS packages.
• Used MicroStrategy Desktop 9.2.1 to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.
• Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Designed Incremental Load Packages which were used to load the updated and new data into the Enterprise Data Warehouse without removing the existing data.
• Worked with different methods of logging in SSIS.
• Used SSIS and T-SQL stored procedures to transfer data from OLAP and OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Created packages in SSIS with error handling.
• Migrated all the packages to Test Environment and finally deployed from Test Environment.
• Designed reports using SQL Server Reporting Services (SSRS).
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2016.
• 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 and deployed SSRS reports.
• Uses PRISM on a regular basis to advance database configurations and faster event logging.
• Ability to configure XML files for import into the PRISM system.

Environment: SQL Server 2014/2016, Windows 2008/2010, MS Access 2000/2003, T-SQL, Windows 2010 Advanced Server, SQL Server Integration Services(SSIS), SSRS, Crystal Reports, Power BI, Micro Strategy 9.2.1, Narrowcast Server, Intelligence Server, Web Administration SharePoint (MOSS) 2007, Erwin 4.0.

Confidential, IL

Sr SQL Server Developer

Responsibilities:

• Working on Designing, Analysis, Development, Maintenance, Implementation using Crystal Reports /2008/XIR4.1, Business Objects XI.
• Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using Crystal Reports XIR4.1. Maintaining proper documentation of the reports for future
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Developed complex reusable formula, parameter reports and reports with advanced features such as conditional formatting, built-in/custom functions and stored them in repository explorer.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Performed parallel runs to validate the Teradata results to match the SQL results exactly.
• Executed queries against SQL Server 2016/2014 and Teradata databases and tables to support testing, data quality, data integrity.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Worked on applications and/or interfaces that utilize Rapid SQL in a complete Sybase 12.5 Environment.
• Worked on multiple projects involving Informatica, MS Visio and Sybase 12.5.
• Data modeling under different schemas like Star Schema and Snow Flake Schema
• Working in production support to tune and optimize SSIS the process for better performance.
• Created and Consumed ASP.Net Web Services and implemented WCF Services for service layer, created filters.
• Worked in production support to optimize SSIS the stored procedures and scheduled many jobs using SQL server 2016/2014
• Experience in the Data migration activities to load the Data into different DB Schemas.
• Designed the ETL process to pull and populate data from OLTP sources to the data mart.
• Wrote CTEs and ranked functions to remove duplicate records in OLTP tables.
• 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.
• Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Developed SSIS packages using SQL Azure database and used SQL Azure database to connect to Power BI.
• Designed and developed jobs for loading data to star schema.
• Migration of SSRS reports from SQL 2014 to SQL 2016.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server2016/2014 Performance.
• Well versed with database concepts as well database design, writing SQL queries and UNIX shell script programs.
• Created DTS packages to copy tables, schemas, views and to extract data from Excel and SharePoint 2016 using SQL Server and SSIS.
• Migrated Objects (Stored Procedures, Views, Tables) from SharePoint 2016, SQL and Excel to SQL.
• Responsible for creating datasets using T-SQL and Stored Procedures and also involved in Data visualization.
• Extracted data from Txt/CSV/XML/Oracle/Sybase/DB2 to SQL server 2016.
• Worked in creating Team projects for Reporting and Integration using TFS.
• Worked with Installation/Management of MS Team Foundation Server and TFS Migration processes from .
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients.
• Assisted and worked on database Normalization to reduce data redundancy and improve data integrity.

Environment: MS SQL Server 2016/2014 Enterprise Edition, SSIS, Teradata 14, SQL Assistant, ASP.NET Tabular,Sybase ASE, Stored Procedure MS Azure, TFS, SharePoint 2016, Power BI, Autosys, ETL,UC4, SSIS, UNIX, SSAS, SSRS,C#.NET,OLTP, T-SQL, OLAP, Crystal reports.

Confidential, Chicago, IL

Sr SQL BI Developer

Responsibilities:

• Worked on Teradata SQL Assistant, Proficient in transferring data from Teradata view or Table using SSIS package and deploy to SQL server 2014/2012, excel, access and other destinations.
• Created data Schemas (Name Spaces), views and established various connections with Teradata and SSMS in Customized SQL tool.
• Proficient in Data Migration from sources like Teradata, MS Access, SQL server, Text Files, Excel to SQL server /2012/2014 using SQL Server Integration Services (SSIS).
• Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
• Worked with SQL Agent to create new SQL Job, as well as monitor and maintain existing SQL jobs.
• Creating new SSIS Packages and Marinating old packages.
• Experience in creatingSQL Logins, RolesandAuthentication modesas a part of security policies for various categories of users.
• Experience in using BCP and Bulk Insert commands while working with Flat files, Excel file.
• Worked with various SQL Joins, Aliases and SQL Functions.
• Worked with Sybase 11.5 as Source and SQL Server as Destination.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Create functions to provide custom functionality as per the requirements.
• Be aware of potential blocking, deadlocking and write code to avoid those situations.
• Endure that the code is written keeping in mind any security issues such as SQL Injection.
• Develop reports in SQL Server 2014/2012 Reporting Services.
• Generated reports usingSSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Createdtabularandmatrix reportsinSSRS. Wrote stored procedures and functions to create SSRS reports.
• Defined relationship between facts and dimensions with star schema and Snowflake Schema in SSAS.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Created Tabular and Matrix Reports using Report Wizard and Report Designer and identifying datasets, data regions and Report Items accordingly
• Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
• Deployment and Processing SSAS cubes, monitor full and incremental loads and support any issues.
• Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Involved in thecreation and deploymentof the reports usingSSRSand configuring the SQL Server Reporting Server
• Deployed SQL Server with HA DR (using AlwaysON) using Azure Infrastructure as a service platform.
• Developed custom C# code to consume and convert data from various Web service API's given in different formats like JSON, ODATA to a flat file format.
• Expert in creatingComplex Crystal ReportsAd Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical.
• Upgraded packages from SQL Server 2008R2 to SQL Server 2014/2012.
• Data mining and report development using T-SQL Scripts, SQL Server Reporting Service (SSRS) and other data tools.
• Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server 2014/2012.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Used ASP.NET Validation Controls like JavaScript, JQuery for client side validations in the Web Pages.
• Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint2010 Business Intelligence platform.
• Deployed and Generated SSRS reports using the Reporting Services, Report Manager and Microsoft SharePoint 2010.
• Responsible for Query Performance tuning and Optimization.
• Worked on performance tuning of SSAS cubes by creating partitions and hierarchies.
• Performance Tuning for existing T SQL code to retrieve the data faster.

Environment: MS SQL Server 2014/2012 Enterprise Edition, Teradata 14, SQL Assistant, Tabular, ETL, SSIS, SSAS, SSRS, Autosys, Sybase 11.5, SharePoint 2007/2010, TFS,Stored Procedure T-SQL, UNIX, C#.NET,OLTP, ASP.NET, MS Azure, UC4, OLAP, Crystal reports.

Confidential, Morton Grove IL

SQL Server BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Generated dynamic stored procedures, triggers for the database development.
• Used BCP and DTS utility for Meta data transfer across servers.
• Involved in installation and configuration of SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012/2014 with latest Service Packs.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server 2014 by using BCP utility, SSIS services.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system and CSV Files and load into staging tables.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 R2to SQL Server 2012/2014 as SSIS Packages.
• Involved in migrating sybase 11.5/oracle service providers to SQL Server 2012
• Created Script in C# in Script task using Excel Interop to read the excel file and also generate customized excel files after data modification.
• Created SSAS Tabular semantic model in Direct Query mode with multiple partitions, KPI's, hierarchies and calculated measures using DAX as per business requirements.
• Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2012/2014.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Major experience in Data Warehousing and SSIS Packages along with SQL Server 2014 Programming.
• Designing OLAP cubes, Data Modeling, Dashboard Reports according to the business requirement.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2014 from different environments for the SSAS cubes.
• All historical data stored in Teradata database, push the old data from cube to Teradata.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
• Created datasets for reports using T-SQL and stored procedures
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Performed Data Analysis, Data Migration and data profiling using complex SQL on Various sources systems including Oracle and Teradata.
• Performance tuning and optimization of procedures and queries.
• Experience in creating complex packages using proper control and data flow elements.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Creating multidimensional Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2012.
• Used Visual Studio 2012 and TFS for code sharing and version control.
• Implemented TFS and SharePoint for deployment, source control, and version control.
• Good experience in working with high volume of transactions for OLTP & OLAP applications.
• Used replication to create a snapshot of passwp database. Because there were 100GB volumes of data snapshot replication was used.
• Pulling data on daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Created stored procedures for datasets in SSRS reports to run calculations at database level.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Experience in handle the offshore team and maintain.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2012/2014.

Environment: MS-SQL Server 2012/2014, Sybase 11.5,Powershell, Crystal Reports, Teradata, Management Studio, ETL Informatica, TFS,UNIX, C#.NET,Crystal Reports,OLTP, Visual Studio 2012, Data Modeling, OLAP, MDX, T-SQL, Windows 2003, SSAS, SSIS, SSRS.

Confidential, CA

MS SQL Server Developer/BI Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams 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 deployedSSIS packages for ETL fromOLTP and various sourcesto staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server 2012 IntegrationServices.
• System (WELS) is designed for early childhood school administration agencies to track the quality of child care centers and homes.
• 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.
• Designed and developed SSIS packages to load data from Flat files, Excel to Data warehouse using C#.NET.
• Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Involved in migration of DTS Packages (2000) to SSIS (2012) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2008R2/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 ofthe data after the insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including 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 2012 Integration Services (SSIS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created datasets using stored procedures and reports using multi value parameters.
• 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.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• 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 monitoringtools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Identified and defined the Datasets for the report generation.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
• Multi-Dimensional Data Modeling techniques like Star Schema Modeling, Snowflake Dimension modeling using Kimball Design Methodology.
• Extracting required data from database through Teradata.
• Leading Offshore team in India and client facing skills.

Environment: MS SQL Server 2012, T-SQL, Teradata, SQL SSIS, SSRS, SSAS, Windows server 2003 Visual Source Safe,SQL Profiler, Crystal Reports,TFS, Visual Studio 2010/2012, XML, Informatica, Oracle 10g, VB.Net.

Confidential, Richardson TX

SQL Server BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed logical and physical data models for schemas using Erwin.
• Installed MS SQL Server 2008R2 and Management tools using SQL Server Setup Program.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed SSIS Packages to transfer data from flat files to SQL Server 2008R2 using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Converted existing Excel templates into SSRS reports to migrate the reporting model to SQL Server Reporting Services.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Generated Sub-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.
• Maintained and Supported Microsoft Team Foundation Server (TFS) to allow for a secure code, SSIS Packages and Reports and use as a repository in order to compare modified and unmodified code.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Performed daily tasks including backup and restore by using MS SQL Server 2008R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Supported production operation activities, with focus on integration and development of new and existing products and services.

Environment: MS SQL Server 2012/2008R2, SSIS, Crystal Reports,SSRS, SSAS, BIDS, Visual Studio 2008/2010, Erwin v7.3,TFS, Windows NT/2003, MS.NET 3.5.

Confidential

MS SQL BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL Server 2008/2008R2.
• Designed an OLAP with the help of ERWIN to visualize data structure.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Improved query performance and reduced by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS.
• Generated reports using SSRS as per business requirements.
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
• Involved in package migration from DTS packages to SSIS packages, running the Microsoft upgrade advisor tool.
• Implemented the calculations to aggregate physical measures using management studio.
• Identified and defined the scoped assignments using script commands.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Designed, Developed and Deployed reports in MS SQL Server 2008/2008R2 environment using SSRS-2008.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Experience in working withSSASin creatingcubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Established a sound backup and recovery policies and procedures.

Environment: MS SQL Server 2008/2008R2, SSIS, SSRS, Visual studio 2008/2005,TFS,Crystal Reports, SSAS, DTS, T-SQL, VB Script,C#.NET, Windows Server 2003, Erwin 4.0.